Listing all records

Displaying records 1801 through 1900 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547340 Patient Care Coordinator Hillsboro OREGON 12 Hour Days
546256 PACU Hilo HAWAII 12 Hour Day/Night Rotate
546869 Vascular Ultrasound Tech Hilo HAWAII 12 Hour Day/Night Rotate
546870 Vascular Ultrasound Tech Hilo HAWAII 12 Hour Day/Night Rotate
546915 Med Surg Hilo HAWAII 12 Hour Nights
547497 Pediatrics Hilo HAWAII 12 Hour Nights
547804 EEG Tech Hilo HAWAII 12 Hour Days
547835 Nuclear Med Technician Hilo HAWAII 8 Hour Days
542655 Long Term Care Hilo HAWAII 12 Hour Day/Night Rotate
538917 Med Surg Hilo HAWAII 12 Hour Day/Night Rotate
539718 Angiography Hilo HAWAII 12 Hour Day/Night Rotate
544474 ER Hilo HAWAII 12 Hour Nights
544536 PCU Hilo HAWAII Varied
545524 Postpartum Hilo HAWAII 12 Hour Day/Night Rotate
546061 Intermediate Care Hilo HAWAII 12 Hour Day/Night Rotate
546037 Pediatrics Hilo HAWAII 12 Hour Varied
546039 Pediatrics Hilo HAWAII 12 Hour Nights
546041 Med Surg Hilo HAWAII 12 Hour Nights
546053 Med Surg Hilo HAWAII 12 Hour Day/Night Rotate
546054 Intermediate Care Hilo HAWAII 12 Hour Day/Night Rotate
546096 ICU Hilo HAWAII 12 Hour Days
540802 Long Term Care Hilo HAWAII 12 Hour Day/Night Rotate
542171 Angiography Hilo HAWAII 12 Hour Day/Night Rotate
545610 Med Surg HOBBS NEW MEXICO 12 Hour Nights
472729 PT Holyoke MASSACHUSETTS Days
533310 Long Term Care Honakaa HAWAII 8 Hour Day/Night Rotate
536159 Long Term Care Honakaa HAWAII 8 Hour Day/Night Rotate
504432 PT Honolulu HAWAII Days
538087 PT Honolulu HAWAII 8 Hour Days
538849 Echo Honolulu HAWAII 8 Hour Days
544288 Dialysis Honolulu HAWAII 12 Hour Day/Night Rotate
545305 Cath Lab Honolulu HAWAII Nights
547836 OR Honolulu HAWAII 8 Hour Day/Night Rotate
547837 Surgical Tech Honolulu HAWAII 8 Hour Day/Night Rotate
542572 ER Honolulu HAWAII 12 Hour Days RN/Registered Nurse
543679 RN House Supervisor Honolulu HAWAII 12 Hour Day/Night Rotate
548009 RAD Tech Honolulu HAWAII 8 Hour Day/Night Rotate
548120 Med Surg Tele Honolulu HAWAII 12 Hour Days RN/Registered Nurse
546949 RAD Tech Hot Springs ARKANSAS 8 Hour Days
516484 PT Hot Springs VIRGINIA Days
546681 PACU Hot Springs ARKANSAS 8 Hour Days
542007 Med Surg Hot Springs ARKANSAS 12 Hour Nights
527053 CVOR Houston TEXAS 8 Hour Days RN/Registered Nurse
545185 CVOR Houston TEXAS 12 Hour Day/Night Rotate
543293 PT Hudson FLORIDA Days
530820 CT Tech Hudson NEW YORK 12 Hour Nights
548169 Interventional Radiology Tech Indianaplis INDIANA 10 Hour Nights Radiology Techs/Technologists
548108 Case Manager Indianaplis INDIANA 8 Hour Days RN/Registered Nurse
548111 Respiratory Therapist Indianapolis INDIANA 12 Hour Nights Respiratory Therapist
547782 PT Indio CALIFORNIA 8 Hour Days
540616 Cath Lab Inglewood CALIFORNIA 10 Hour Days
542353 Therapy Rehab Inman SOUTH CAROLINA Days
531763 PT Inman SOUTH CAROLINA Days
518165 Endoscopy IOWA CITY IOWA Days
536650 Med Surg IOWA CITY IOWA 12 Hour Nights
538598 RAD Tech IOWA CITY IOWA Varied
542423 OR IOWA CITY IOWA 10 Hour Days
544434 Telemetry IOWA CITY IOWA 12 Hour Nights
544435 ER IOWA CITY IOWA 12 Hour Nights
544436 ER IOWA CITY IOWA 12 Hour Nights
544437 ER IOWA CITY IOWA 12 Hour Days
546768 Med Surg IOWA CITY IOWA 12 Hour Nights
546770 Surgical Tech IOWA CITY IOWA Days
546785 Med Surg IOWA CITY IOWA 12 Hour Day/Night Rotate
546798 Interventional Radiology Tech IOWA CITY IOWA Days
546192 ICU - Per Diem Irvine CALIFORNIA 12 Hour Nights RN/Registered Nurse
547603 ICU Issaquah WASHINGTON 12 Hour Days
545944 ICU Issaquah WASHINGTON 12 Hour Days
531609 CT Tech Jackson MISSISSIPPI 8 Hour Nights
534500 PTA Jacksonville ILLINOIS 12 Hour Day/Night Rotate
548316 OR Jefferson City MISSOURI 10 Hour Days RN/Registered Nurse
546860 Endoscopy Jefferson City MISSOURI 8 Hour Days
545888 Therapy Rehab JEROME IDAHO 8 Hour Days
544861 Dialysis Johnson City TENNESSEE 10 Hour Day/Night Rotate
544944 PCU Johnson City TENNESSEE 12 Hour Days
544947 Cath Lab Johnson City TENNESSEE Days
546393 OR Johnson City TENNESSEE Nights
547069 Step Down Johnson City TENNESSEE 12 Hour Nights
547581 Pulmonary Johnson City TENNESSEE 12 Hour Days
547882 ICU Johnson City TENNESSEE 12 Hour Nights
542775 Med Surg Johnson City TENNESSEE 12 Hour Nights
543225 PCU Johnson City TENNESSEE 12 Hour Nights
539616 PCU Johnson City TENNESSEE 12 Hour Nights
539617 Pulmonary Johnson City TENNESSEE 12 Hour Nights
539618 PCU Johnson City TENNESSEE 12 Hour Days
539620 PCU Johnson City TENNESSEE 12 Hour Nights
534528 Social Worker Johnston PENNSYLVANIA 8 Hour Days
528504 SLP Juneau ALASKA Days
535216 Mammo Tech Juneau ARKANSAS Days
548014 Long Term Care Kane PENNSYLVANIA 12 Hour Nights
547403 Med Surg Tele Kansas City MISSOURI 12 Hour Days
542129 RAD Tech Kapaau HAWAII Varied
517267 PT Kapaau HAWAII Days
517269 PT Kapaau HAWAII Days
546927 ER Kaunakakai HAWAII 12 Hour Day/Night Rotate
546940 Psych Kealakekua HAWAII 12 Hour Day/Night Rotate
547879 Med Surg Kealakekua HAWAII 12 Hour Day/Night Rotate
525386 Vascular Ultrasound Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
527338 RAD Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
534971 Administration Kealakekua HAWAII Days
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.8011 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 z.city asc limit 1800,100 in 1.6917 seconds