Listing all records

Displaying records 1501 through 1600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545945 Med Surg Gainesville FLORIDA 12 Hour Days
545946 Med Surg Gainesville FLORIDA 12 Hour Days
545961 Med Surg Gainesville FLORIDA 12 Hour Days
545962 ICU Gainesville FLORIDA 12 Hour Days
545963 Med Surg Gainesville FLORIDA 12 Hour Nights
545964 Ultrasound Tech Gainesville FLORIDA 12 Hour Days
545965 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545966 Pediatrics Gainesville FLORIDA 12 Hour Nights
545967 Pediatric ER Gainesville FLORIDA 12 Hour Evenings
545968 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545969 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545970 Med Surg Gainesville FLORIDA 12 Hour Nights
545971 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545972 Med Surg Gainesville FLORIDA 12 Hour Nights
545973 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545974 Med Surg Gainesville FLORIDA 12 Hour Days
545975 ICU Gainesville FLORIDA 12 Hour Nights
545976 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545977 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545978 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545981 Med Surg Gainesville FLORIDA 12 Hour Nights
545982 ICU Gainesville FLORIDA 12 Hour Nights
545983 Med Surg Gainesville FLORIDA 12 Hour Nights
545984 ICU Gainesville FLORIDA 12 Hour Nights
526053 RAD Tech Clearwater FLORIDA 8 Hour Days RN/Registered Nurse
546234 PT Blountstown FLORIDA Days
546431 Med Surg Gainesville FLORIDA 12 Hour Days
546476 Med Surg Gainesville FLORIDA 12 Hour Nights
546762 Interventional Radiology Tech Gainesville FLORIDA 10 Hour Days
547368 Home Health Sarasota FLORIDA 8 Hour Days
547369 Interventional Radiology Tech Clearwater FLORIDA 10 Hour Days
547633 CT Tech Titusville FLORIDA 12 Hour Nights
547825 Interventional Radiology Vero Beach FLORIDA 10 Hour Days
547858 RAD Tech Winter Haven FLORIDA 8 Hour Days
547867 PT Winter Park FLORIDA Days
542596 Interventional Radiology Tech Daytona Beach FLORIDA 8 Hour Days
543293 PT Hudson FLORIDA Days
543897 PT Naples FLORIDA Varied
542701 PT Athens GEORGIA 8 Hour Days
543480 Therapy Rehab Athens GEORGIA 8 Hour Days
543183 Surgical Tech Athens GEORGIA 8 Hour Days
543184 Surgical Tech Athens GEORGIA 8 Hour Days
543468 PT Athens GEORGIA 8 Hour Days
521399 LPN/LVN Atlanta GEORGIA 8 Hour Days LVN
535556 PT Athens GEORGIA 8 Hour Days
537738 PT Vidalia GEORGIA 12 Hour Days
539455 PT Athens GEORGIA 8 Hour Days
539875 Therapy Rehab Athens GEORGIA 8 Hour Days
546451 Therapy Rehab Macon GEORGIA 8 Hour Nights
546995 OR Athens GEORGIA 8 Hour Days
547063 SLP Athens GEORGIA 8 Hour Days
547330 Surgical Tech Macon GEORGIA 8 Hour Days
547683 OT Athens GEORGIA 8 Hour Days
547853 Med Surg Valdosta GEORGIA 12 Hour Nights
547854 Med Surg Valdosta GEORGIA 12 Hour Days
547869 PT Savannah GEORGIA Days
546256 PACU Hilo HAWAII 12 Hour Day/Night Rotate
546835 Registered Dietician Waimea 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
546927 ER Kaunakakai HAWAII 12 Hour Day/Night Rotate
546940 Psych Kealakekua HAWAII 12 Hour Day/Night Rotate
547497 Pediatrics Hilo HAWAII 12 Hour Nights
547625 CNA Kula HAWAII 8 Hour Days
547804 EEG Tech Hilo HAWAII 12 Hour Days
547835 Nuclear Med Technician Hilo HAWAII 8 Hour Days
547836 OR Honolulu HAWAII 8 Hour Day/Night Rotate
547837 Surgical Tech Honolulu HAWAII 8 Hour Day/Night Rotate
547879 Med Surg Kealakekua HAWAII 12 Hour Day/Night Rotate
540802 Long Term Care Hilo HAWAII 12 Hour Day/Night Rotate
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
542129 RAD Tech Kapaau HAWAII Varied
542171 Angiography Hilo HAWAII 12 Hour Day/Night Rotate
542458 Clinic Pahala HAWAII 12 Hour Day/Night Rotate
542572 ER Honolulu HAWAII 12 Hour Days RN/Registered Nurse
542685 Postpartum Kealakekua HAWAII 12 Hour Nights
542687 RAD Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
543332 CT Tech Waimea HAWAII 12 Hour Day/Night Rotate
543465 Telemetry Wailuku HAWAII 12 Hour Nights
543466 Med Surg Tele Wailuku HAWAII 12 Hour Nights
543486 Echo Waimea HAWAII 12 Hour Day/Night Rotate
543679 RN House Supervisor Honolulu HAWAII 12 Hour Day/Night Rotate
548009 RAD Tech Honolulu HAWAII 8 Hour Day/Night Rotate
548118 ER Wailuku HAWAII 12 Hour Days RN/Registered Nurse
548120 Med Surg Tele Honolulu HAWAII 12 Hour Days RN/Registered Nurse
548121 Med Surg Kula HAWAII 12 Hour Nights RN/Registered Nurse
544288 Dialysis Honolulu HAWAII 12 Hour Day/Night Rotate
544474 ER Hilo HAWAII 12 Hour Nights
544499 Med Surg Tele Wailuku HAWAII 12 Hour Nights
544524 Med Surg Tele Wailuku HAWAII 12 Hour Nights
544525 Telemetry Wailuku HAWAII 12 Hour Nights
544526 Step Down Wailuku HAWAII 12 Hour Days
544527 Med Surg Tele Wailuku HAWAII 12 Hour Days
544529 Med Surg Kula 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
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.5749 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 y.name asc limit 1500,100 in 1.3542 seconds