Listing all records

Displaying records 1601 through 1700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
543201 Psych Grand Rapids MICHIGAN 8 Hour Evenings RN/Registered Nurse
543291 Surgical Tech Muskegon MICHIGAN 12 Hour Days
546929 Interventional Radiology Tech Detroit MICHIGAN 10 Hour Days
543527 Step Down Lansing MICHIGAN Nights
543703 RAD Tech Commerce Twp MICHIGAN 8 Hour Nights
543787 PICU Detroit MICHIGAN 12 Hour Days
543824 ER Lansing MICHIGAN 12 Hour Nights
544036 Step Down Lansing MICHIGAN 12 Hour Nights
544037 Step Down Lansing MICHIGAN 12 Hour Nights
544060 ICU Pontiac MICHIGAN 12 Hour Nights
541755 Med Surg Tele Pittsfield MASSACHUSETTS 12 Hour Nights
540854 Med Surg Tele Springfield MASSACHUSETTS 8 Hour Nights
540855 Med Surg Tele Springfield MASSACHUSETTS 8 Hour Nights
540856 Med Surg Tele Springfield MASSACHUSETTS 8 Hour Nights
540857 ER Springfield MASSACHUSETTS 12 Hour Days
540859 ER Springfield MASSACHUSETTS 8 Hour Nights
540861 ER Springfield MASSACHUSETTS 8 Hour Nights
541077 CT Tech Springfield MASSACHUSETTS 8 Hour Evenings
543802 Case Manager Attleboro MASSACHUSETTS 8 Hour Days
472729 PT Holyoke MASSACHUSETTS Days
492900 PT Lancaster MASSACHUSETTS Days
525605 RAD Tech Boston MASSACHUSETTS 10 Hour Days Radiology Techs/Technologists
526998 Cardiac ICU Boston MASSACHUSETTS 12 Hour Day/Night Rotate RN/Registered Nurse
529353 PTA Harwich MASSACHUSETTS Days
535301 MLT Pittsfield MASSACHUSETTS 10 Hour Nights
535302 MLT Pittsfield MASSACHUSETTS 8 Hour Days
535465 Med Surg Tele Springfield MASSACHUSETTS 8 Hour Nights
538527 Long Term Care Rochdale MASSACHUSETTS 12 Hour Days
548003 ER Pittsfield MASSACHUSETTS 12 Hour Nights
548004 Pediatrics Pittsfield MASSACHUSETTS 12 Hour Nights
548040 PCU Lowell MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
548080 CVICU Boston MASSACHUSETTS 12 Hour Day/Night Rotate RN/Registered Nurse
548100 PCU Pittsfield MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
548182 CCU Pittsfield MASSACHUSETTS 12 Hour Days RN/Registered Nurse
548184 Psych Salem MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
548296 RNFA Pittsfield MASSACHUSETTS 10 Hour Days RN/Registered Nurse
548382 ER North Adams MASSACHUSETTS 12 Hour Days RN/Registered Nurse
548406 PCU Pittsfield MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
546255 PT Falls River MASSACHUSETTS 12 Hour Day/Night Rotate
547088 Pediatrics Pittsfield MASSACHUSETTS 12 Hour Nights
546712 Respiratory Therapist Springfield MASSACHUSETTS 8 Hour Nights
546713 L&D Springfield MASSACHUSETTS 8 Hour Nights
546714 L&D Springfield MASSACHUSETTS 8 Hour Nights
546767 PTA Charlton MASSACHUSETTS Days
546784 Pediatrics Gardner MASSACHUSETTS 12 Hour Nights
546877 MLT Pittsfield MASSACHUSETTS 8 Hour Days
546942 Perfusionist Boston MASSACHUSETTS 10 Hour Days
546992 Certified Surgical Tech Concord MASSACHUSETTS 8 Hour Days
547060 L&D Pittsfield MASSACHUSETTS 12 Hour Days
547511 Certified Surgical Tech Pittsfield MASSACHUSETTS 8 Hour Days
547532 CCU Concord MASSACHUSETTS 12 Hour Nights
547766 Wound Care Pittsfield MASSACHUSETTS 8 Hour Days
547810 Oncology Milford MASSACHUSETTS 12 Hour Nights
548253 Neuro Intensive Care Boston MASSACHUSETTS 12 Hour Days RN/Registered Nurse
544485 SLP Danvers MASSACHUSETTS Days
545030 OR Gardner MASSACHUSETTS 10 Hour Days
545422 ER Springfield MASSACHUSETTS 8 Hour Nights
546103 OR Springfield MASSACHUSETTS 8 Hour Days
544201 OR Germantown MARYLAND 8 Hour Evenings
544205 Ultrasound Tech Silver Spring MARYLAND 10 Hour Evenings
544264 RAD Tech Silver Spring MARYLAND 8 Hour Evenings
544377 Ultrasound Tech Silver Spring MARYLAND 8 Hour Evenings
544378 Ultrasound Tech Silver Spring MARYLAND 8 Hour Days
544441 Therapy Rehab Baltimore MARYLAND Days
544482 OR Germantown MARYLAND 8 Hour Days
544644 OR Silver Spring MARYLAND 12 Hour Days
544645 OR Silver Spring MARYLAND 12 Hour Days
544646 OR Silver Spring MARYLAND 12 Hour Days
544647 OR Silver Spring MARYLAND 12 Hour Days
544648 OR Silver Spring MARYLAND Nights
544649 OR Silver Spring MARYLAND Nights
545411 RAD Tech Rockville MARYLAND 8 Hour Days
546010 Med Surg Prince Frederick MARYLAND 12 Hour Nights
548160 Med Surg Prince Frederick MARYLAND 12 Hour Nights RN/Registered Nurse
548224 ER Rockville MARYLAND 12 Hour Nights RN/Registered Nurse
541443 COTA Towson MARYLAND Days
543370 Surgical Tech Silver Spring MARYLAND Nights
544375 Ultrasound Tech Silver Spring MARYLAND 10 Hour Nights
476614 PT Crownsville MARYLAND Days
507079 PT Rockville MARYLAND Days
511666 PT Rockville MARYLAND Days
519354 Therapy Rehab Baltimore MARYLAND Days
526144 Therapy Rehab Baltimore MARYLAND Days
526713 CT Tech Silver Spring MARYLAND 10 Hour Days
526794 CT Tech Silver Spring MARYLAND 10 Hour Nights
535037 Cath Lab Rockville MARYLAND 10 Hour Days
535889 PTA Essex MARYLAND Days
536728 Interventional Radiology Germantown MARYLAND 8 Hour Days
536758 OR Germantown MARYLAND 8 Hour Days
538172 MRI Tech Germantown MARYLAND 10 Hour Days
546856 Certified Surgical Tech Berlin MARYLAND 10 Hour Days
546858 CVOR Annapolis MARYLAND 12 Hour Days
547471 Med Surg Prince Frederick MARYLAND 12 Hour Nights
546604 RAD Tech Lewiston MAINE 10 Hour Days
547094 Surgical Tech CVOR Lewiston MAINE 10 Hour Days
547302 MLT York MAINE 8 Hour Day/Night Rotate
547427 ICU York MAINE 12 Hour Nights
547574 Med Surg Lewiston MAINE 12 Hour Days
547575 ICU Lewiston MAINE 12 Hour Days
547880 CNA Bangor MAINE 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.5558 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 1600,100 in 1.7525 seconds