Listing all records

Displaying records 2101 through 2200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
539755 Med Surg Tele Wailuku HAWAII 12 Hour Nights
539756 Med Surg Tele Wailuku HAWAII 12 Hour Nights
539757 Med Surg Tele Wailuku HAWAII 12 Hour Nights
539758 Med Surg Tele Wailuku HAWAII 12 Hour Nights
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
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
544789 CNA Kealakekua HAWAII 12 Hour Day/Night Rotate
546335 Psych Wailuku HAWAII 12 Hour Nights
545305 Cath Lab Honolulu HAWAII Nights
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
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
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
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
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
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
544929 CT Tech Titusville FLORIDA 10 Hour Nights
545405 Surgical Tech CVOR Weston FLORIDA 12 Hour Days
545617 Med Surg Gainesville FLORIDA 12 Hour Days
545618 MLT Gainesville FLORIDA 8 Hour Nights
545619 Med Surg Gainesville FLORIDA 12 Hour Nights
545620 Med Surg Gainesville FLORIDA 12 Hour Nights
545627 Cardiology Gainesville FLORIDA 12 Hour Nights
545628 Med Surg Gainesville FLORIDA 12 Hour Days
545629 ICU Gainesville FLORIDA 12 Hour Nights
545630 Sterile Processing Technician Gainesville FLORIDA 8 Hour Evenings
545631 ICU Gainesville FLORIDA 12 Hour Nights
545632 Med Surg Gainesville FLORIDA 12 Hour Days
545633 Med Surg Gainesville FLORIDA 12 Hour Nights
545634 Med Surg Gainesville FLORIDA 12 Hour Days
545635 Med Surg Gainesville FLORIDA 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.353 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 desc limit 2100,100 in 1.8334 seconds