Listing all records

Displaying records 101 through 200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547326 CVOR Ann Arbor MICHIGAN 10 Hour Days
546923 CT Tech Ann Arbor MICHIGAN 12 Hour Nights
536431 ICU Ann Arbor MICHIGAN 12 Hour Nights
542041 ICU Ann Arbor MICHIGAN 12 Hour Nights
538400 CT Tech Ann Arbor MICHIGAN 12 Hour Nights
538591 CT Tech Ann Arbor MICHIGAN 12 Hour Days
546858 CVOR Annapolis MARYLAND 12 Hour Days
547933 Med Surg Anniston ALABAMA 12 Hour Nights
548385 Telemetry Antioch CALIFORNIA 12 Hour Days RN/Registered Nurse
548362 Telemetry Antioch CALIFORNIA 12 Hour Nights RN/Registered Nurse
541551 PT Apple Valley CALIFORNIA 8 Hour Days
541550 PT Apple Valley CALIFORNIA 8 Hour Days
544912 PT Apple Valley CALIFORNIA 10 Hour Days
544911 PT Apple Valley CALIFORNIA 10 Hour Days
545515 L&D Arcata CALIFORNIA 12 Hour Nights
545514 L&D Arcata CALIFORNIA 12 Hour Nights
547531 L&D Arcata CALIFORNIA 12 Hour Nights
548262 ICU Arcata CALIFORNIA 12 Hour Days RN/Registered Nurse
544196 Interventional Radiology Tech Arlington VIRGINIA 10 Hour Days
548213 ICU Arlington WASHINGTON 12 Hour Days RN/Registered Nurse
548299 OR Arlington VIRGINIA 10 Hour Days RN/Registered Nurse
547138 ER Arlington WASHINGTON 12 Hour Nights
547479 CT Tech Arlington VIRGINIA 10 Hour Days
545082 Vascular Ultrasound Tech Artesia NEW MEXICO Days
548247 ER Artesia NEW MEXICO 12 Hour Nights RN/Registered Nurse
544886 OR Aspen COLORADO 10 Hour Days
547365 RAD Tech Aspen COLORADO 8 Hour Days
546995 OR Athens GEORGIA 8 Hour Days
547063 SLP Athens GEORGIA 8 Hour Days
547683 OT Athens GEORGIA 8 Hour Days
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
535556 PT Athens GEORGIA 8 Hour Days
539875 Therapy Rehab Athens GEORGIA 8 Hour Days
539455 PT Athens GEORGIA 8 Hour Days
521399 LPN/LVN Atlanta GEORGIA 8 Hour Days LVN
543802 Case Manager Attleboro MASSACHUSETTS 8 Hour Days
548267 ICU Auburn NEW YORK 12 Hour Nights RN/Registered Nurse
546759 L&D Auburn NEW YORK 12 Hour Nights
546190 Interventional Radiology Auburn NEW YORK 8 Hour Days
547031 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547032 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547033 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547034 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547035 Med Surg Tele Auburn NEW YORK 12 Hour Nights
546761 ER Auburn NEW YORK 12 Hour Nights
546760 ER Auburn NEW YORK 12 Hour Nights
547461 Radiology Tech Auburn NEW YORK 12 Hour Days
548173 Med Surg Auburn NEW YORK 12 Hour Nights RN/Registered Nurse
547969 Surgical Tech Auburn NEW YORK 10 Hour Days
537901 ER Avalon CALIFORNIA 12 Hour Day/Night Rotate
537902 SNF Avalon CALIFORNIA 12 Hour Days
538185 CNA Avalon CALIFORNIA 12 Hour Days
538394 ER Avalon CALIFORNIA 12 Hour Day/Night Rotate
539068 ER Avalon CALIFORNIA Nights
544121 CT Tech Avalon CALIFORNIA 8 Hour Varied
542691 Lab Supervisor Avalon CALIFORNIA 8 Hour Varied
531884 PTA Avoca IOWA Days
539734 PTA Avoca IOWA Days
548318 Surgical Tech Bad Axe MICHIGAN 8 Hour Days Tech/Technologist
547666 PT Bad Axe MICHIGAN 8 Hour Days
524667 CT Tech Baker City OREGON 8 Hour Nights
548266 ICU BAKERSFIELD CALIFORNIA 12 Hour Nights RN/Registered Nurse
548146 Med Surg Bakersfield CALIFORNIA 12 Hour Nights RN/Registered Nurse
548142 OR Bakersfield CALIFORNIA 8 Hour Day/Night Rotate RN/Registered Nurse
548192 Case Manager BAKERSFIELD CALIFORNIA 8 Hour Days RN/Registered Nurse
548046 OR BAKERSFIELD CALIFORNIA 8 Hour Days RN/Registered Nurse
548043 OR Bakersfield CALIFORNIA 8 Hour Days RN/Registered Nurse
548038 Telemetry BAKERSFIELD CALIFORNIA 12 Hour Nights
548383 Telemetry BAKERSFIELD CALIFORNIA 12 Hour Days RN/Registered Nurse
548341 ER BAKERSFIELD CALIFORNIA 12 Hour Nights RN/Registered Nurse
548361 Telemetry BAKERSFIELD CALIFORNIA 12 Hour Nights RN/Registered Nurse
548364 Med Surg BAKERSFIELD CALIFORNIA 12 Hour Days RN/Registered Nurse
548365 Med Surg BAKERSFIELD CALIFORNIA 12 Hour Days RN/Registered Nurse
464113 SLP Ballinger TEXAS Days
507014 Therapy Rehab Ballinger TEXAS Days
526144 Therapy Rehab Baltimore MARYLAND Days
519354 Therapy Rehab Baltimore MARYLAND Days
544441 Therapy Rehab Baltimore MARYLAND Days
444999 PACU Bangor MAINE 12 Hour Days
547880 CNA Bangor MAINE 12 Hour Nights
544793 Cath Lab Bartlett TENNESSEE 8 Hour Days
547043 Med Surg Tele Beachwood OHIO 12 Hour Nights
544043 Med Surg Tele Beachwood OHIO 12 Hour Days
543519 MRI Tech Beachwood OHIO 8 Hour Nights
538402 CT Tech Bellefontaine OHIO 12 Hour Nights
548066 ICU Bellefontaine OHIO 12 Hour Nights RN/Registered Nurse
533521 PTA Belton TEXAS Days
545390 CT Tech Berlin NEW HAMPSHIRE 12 Hour Day/Night Rotate
544775 CT Tech Berlin NEW HAMPSHIRE 12 Hour Day/Night Rotate
546856 Certified Surgical Tech Berlin MARYLAND 10 Hour Days
548013 Outpatient Clinic Berlin NEW HAMPSHIRE 8 Hour Days
545960 Cath Lab Berwyn ILLINOIS 8 Hour Days
548031 Cath Lab Berwyn ILLINOIS 8 Hour Days
547529 Sterile Processing Tech Berwyn ILLINOIS 8 Hour Evenings
533767 PT Bessemer ALABAMA Varied
513720 PT Bessemer ALABAMA Varied
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.4829 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 100,100 in 2.1 seconds