Listing all records

Displaying records 1301 through 1400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
543152 Ultrasound Tech Concord NEW HAMPSHIRE 8 Hour Days
542029 Med Surg Bronx NEW YORK 10 Hour Days
542039 OR San Angelo TEXAS Varied
542040 Physician PHiladelphia PENNSYLVANIA 8 Hour Days
542049 Surgical Tech CVOR York PENNSYLVANIA 12 Hour Days
542063 ICU Wailuku HAWAII 12 Hour Nights
542070 Med Surg Tele Wailuku HAWAII 12 Hour Varied
542071 Med Surg Tele Wailuku HAWAII 12 Hour Nights
542081 Med Surg Tele Madison WISCONSIN 12 Hour Day/Night Rotate
542084 RAD Tech Farmington CONNECTICUT 8 Hour Days
542085 PT Oneonta NEW YORK 8 Hour Days
542103 Medical Assistant Portland OREGON 12 Hour Nights
542104 Medical Assistant Portland OREGON 12 Hour Nights
543644 ER Walnut Creek CALIFORNIA 12 Hour Nights
542449 PTA Lakeport CALIFORNIA 8 Hour Days
542129 RAD Tech Kapaau HAWAII Varied
542130 Echo Technologist San Angelo TEXAS Varied
542131 Echo Great Falls MONTANA 8 Hour Days
543633 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
542138 Med Surg Brooklyn NEW YORK 12 Hour Nights
542156 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
542160 CT Tech Lynwood CALIFORNIA 12 Hour Day/Night Rotate
542171 Angiography Hilo HAWAII 12 Hour Day/Night Rotate
542176 ICU Boise IDAHO 12 Hour Nights
542177 ICU Boise IDAHO 12 Hour Nights
543024 Interventional Radiology Des Moines IOWA 10 Hour Days
542847 SLP Oakland NEW JERSEY Days
542211 Telemetry CHANDLER ARIZONA 12 Hour Nights
542242 Oncology Charlottesville VIRGINIA 12 Hour Nights
542243 Oncology Charlottesville VIRGINIA 12 Hour Nights
542262 CVOR Charlottesville VIRGINIA 10 Hour Days
542263 CVOR Charlottesville VIRGINIA 10 Hour Days
543645 ER Walnut Creek CALIFORNIA 12 Hour Nights
542273 Med Surg Excelsior Springs MISSOURI 12 Hour Nights
542299 ER Laconia NEW HAMPSHIRE Nights
542321 CT Tech Boise IDAHO 10 Hour Days
543123 ER Primghar IOWA 12 Hour Nights
542345 MLT Westerville OHIO 8 Hour Nights
542347 Ultrasound Tech Greenbrae CALIFORNIA 12 Hour Day/Night Rotate
542353 Therapy Rehab Inman SOUTH CAROLINA Days
542364 OR Spokane WASHINGTON 12 Hour Days
542375 Med Surg Spokane WASHINGTON 12 Hour Nights
542380 PT SANTA ROSA CALIFORNIA 8 Hour Days
542387 Med Surg Des Moines IOWA 12 Hour Days
542390 Pediatric ER New York NEW YORK 12 Hour Nights
542401 Surgical Tech Leavenworth KANSAS 8 Hour Days
542402 Sterile Processing Tech Leavenworth KANSAS 8 Hour Days
542423 OR IOWA CITY IOWA 10 Hour Days
542424 PT Norwalk IOWA Days
542427 PT Lakeport CALIFORNIA Varied
542430 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
542451 ER Rockford ILLINOIS 12 Hour Nights
542458 Clinic Pahala HAWAII 12 Hour Day/Night Rotate
542462 SLP Williamstown NEW JERSEY Days
542466 Neurology Des Moines IOWA 12 Hour Nights
542474 Sterile Processing Technician Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
542497 PT Clovis NEW MEXICO 8 Hour Days
542500 MRI Tech Clarkston WASHINGTON Varied
542501 Long Term Care Sitka ALASKA 8 Hour Evenings
542523 Surgical Tech CVOR Los Angeles CALIFORNIA 12 Hour Days
542525 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
542526 ICU Cleveland OHIO 12 Hour Day/Night Rotate
546182 Med Surg Peoria ILLINOIS 12 Hour Nights
543153 Ultrasound Tech Concord NEW HAMPSHIRE 8 Hour Days
542578 Outpatient Clinic Chillicothe OHIO 10 Hour Varied
542586 OR Watertown NEW YORK 8 Hour Varied
542595 CMA Farmington CONNECTICUT 8 Hour Days
542596 Interventional Radiology Tech Daytona Beach FLORIDA 8 Hour Days
542601 Ambulatory Cleveland OHIO 8 Hour Days
542605 Surgical Tech Woonsocket RHODE ISLAND 8 Hour Days
543649 ER Walnut Creek CALIFORNIA 12 Hour Nights
542617 PCU Sun City West ARIZONA 12 Hour Nights
542618 PCU Sun City West ARIZONA 12 Hour Days
542636 Oncology Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
542642 Cath Lab Mason City IOWA 8 Hour Days
542653 Telemetry Charleston SOUTH CAROLINA 12 Hour Nights
542657 PT Middletown OHIO Days
542658 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
544103 Phlebotomist Farmington CONNECTICUT 8 Hour Days
542669 Oncology Madison WISCONSIN 12 Hour Day/Night Rotate
542670 Oncology Madison WISCONSIN 12 Hour Day/Night Rotate
542685 Postpartum Kealakekua HAWAII 12 Hour Nights
542687 RAD Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
542691 Lab Supervisor Avalon CALIFORNIA 8 Hour Varied
542697 Therapy Rehab Garden City KANSAS 8 Hour Days
542701 PT Athens GEORGIA 8 Hour Days
542713 Med Surg Tele Potsdam NEW YORK 12 Hour Nights
542718 Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
542734 PT Hayward CALIFORNIA 8 Hour Days
542740 ICU Saratoga Springs NEW YORK 12 Hour Nights
542758 Med Surg Tele Concord CALIFORNIA 12 Hour Days
542772 Med Surg Kingsport TENNESSEE 12 Hour Nights
542773 Med Surg Kingsport TENNESSEE 12 Hour Nights
542775 Med Surg Johnson City TENNESSEE 12 Hour Nights
542779 PCU Bristol TENNESSEE 12 Hour Nights
542780 SLP Oakhurst CALIFORNIA Days
542781 ICU Boise IDAHO 12 Hour Nights
542782 ICU Boise IDAHO 12 Hour Nights
542790 PCU Kingsport TENNESSEE 12 Hour Nights
542803 Med Surg Newberg OREGON 12 Hour Nights
Slow: select count(*) from joborders a left join specialties b on a.specialty=b.id left join shifts c on a.shift=c.id left join job_titles d on a.title=d.id left join hospital z on z.id=a.hospital_id left join states y on y.id=z.state where closed=0 in 1.5111 seconds
Slow: select a.id,a.id,b.name as specialty,c.name as shift,d.name as title,z.city,y.name as state from joborders a left join specialties b on a.specialty=b.id left join shifts c on a.shift=c.id left join job_titles d on a.title=d.id left join hospital z on z.id=a.hospital_id left join states y on y.id=z.state where closed=0 order by a.title asc limit 1300,100 in 1.4179 seconds