Listing all records

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

ID Job Specialty City State Shift Title
548131 Respiratory Therapist Keene NEW HAMPSHIRE 12 Hour Nights Respiratory Therapist
544994 Surgical Tech Kearney NEBRASKA 8 Hour Days
541359 Vascular Ultrasound Tech Kearney NEBRASKA 8 Hour Days
547654 PCU Kearney NEBRASKA 12 Hour Nights
547655 Med Surg Kearney NEBRASKA 12 Hour Nights
546940 Psych Kealakekua HAWAII 12 Hour Day/Night Rotate
547879 Med Surg Kealakekua HAWAII 12 Hour Day/Night Rotate
544789 CNA 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
534972 CT Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
542685 Postpartum Kealakekua HAWAII 12 Hour Nights
542687 RAD Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
546927 ER Kaunakakai HAWAII 12 Hour Day/Night Rotate
542129 RAD Tech Kapaau HAWAII Varied
517267 PT Kapaau HAWAII Days
517269 PT Kapaau HAWAII Days
547403 Med Surg Tele Kansas City MISSOURI 12 Hour Days
548014 Long Term Care Kane PENNSYLVANIA 12 Hour Nights
528504 SLP Juneau ALASKA Days
535216 Mammo Tech Juneau ARKANSAS Days
534528 Social Worker Johnston PENNSYLVANIA 8 Hour Days
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
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
545888 Therapy Rehab JEROME IDAHO 8 Hour Days
548316 OR Jefferson City MISSOURI 10 Hour Days RN/Registered Nurse
546860 Endoscopy Jefferson City MISSOURI 8 Hour Days
534500 PTA Jacksonville ILLINOIS 12 Hour Day/Night Rotate
531609 CT Tech Jackson MISSISSIPPI 8 Hour Nights
547603 ICU Issaquah WASHINGTON 12 Hour Days
545944 ICU Issaquah WASHINGTON 12 Hour Days
546192 ICU - Per Diem Irvine CALIFORNIA 12 Hour Nights RN/Registered Nurse
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
544435 ER IOWA CITY IOWA 12 Hour Nights
544436 ER IOWA CITY IOWA 12 Hour Nights
544437 ER IOWA CITY IOWA 12 Hour Days
542423 OR IOWA CITY IOWA 10 Hour Days
544434 Telemetry IOWA CITY IOWA 12 Hour Nights
518165 Endoscopy IOWA CITY IOWA Days
536650 Med Surg IOWA CITY IOWA 12 Hour Nights
538598 RAD Tech IOWA CITY IOWA Varied
531763 PT Inman SOUTH CAROLINA Days
542353 Therapy Rehab Inman SOUTH CAROLINA Days
540616 Cath Lab Inglewood CALIFORNIA 10 Hour Days
547782 PT Indio CALIFORNIA 8 Hour Days
548111 Respiratory Therapist Indianapolis INDIANA 12 Hour Nights Respiratory Therapist
548169 Interventional Radiology Tech Indianaplis INDIANA 10 Hour Nights Radiology Techs/Technologists
548108 Case Manager Indianaplis INDIANA 8 Hour Days RN/Registered Nurse
543293 PT Hudson FLORIDA Days
530820 CT Tech Hudson NEW YORK 12 Hour Nights
527053 CVOR Houston TEXAS 8 Hour Days RN/Registered Nurse
545185 CVOR Houston TEXAS 12 Hour Day/Night Rotate
546681 PACU Hot Springs ARKANSAS 8 Hour Days
516484 PT Hot Springs VIRGINIA Days
542007 Med Surg Hot Springs ARKANSAS 12 Hour Nights
546949 RAD Tech Hot Springs ARKANSAS 8 Hour Days
547836 OR Honolulu HAWAII 8 Hour Day/Night Rotate
547837 Surgical Tech Honolulu 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
548009 RAD Tech Honolulu HAWAII 8 Hour Day/Night Rotate
548120 Med Surg Tele Honolulu HAWAII 12 Hour Days RN/Registered Nurse
544288 Dialysis Honolulu HAWAII 12 Hour Day/Night Rotate
545305 Cath Lab Honolulu HAWAII Nights
542572 ER Honolulu HAWAII 12 Hour Days RN/Registered Nurse
543679 RN House Supervisor Honolulu HAWAII 12 Hour Day/Night Rotate
533310 Long Term Care Honakaa HAWAII 8 Hour Day/Night Rotate
536159 Long Term Care Honakaa HAWAII 8 Hour Day/Night Rotate
472729 PT Holyoke MASSACHUSETTS Days
545610 Med Surg HOBBS NEW MEXICO 12 Hour Nights
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
546256 PACU Hilo HAWAII 12 Hour Day/Night Rotate
546869 Vascular Ultrasound Tech Hilo HAWAII 12 Hour Day/Night Rotate
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.5185 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 desc limit 1800,100 in 1.6911 seconds