Listing all records

Displaying records 2001 through 2100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547575 ICU Lewiston MAINE 12 Hour Days
547880 CNA Bangor MAINE 12 Hour Nights
547980 Med Surg Tele Lewiston MAINE 12 Hour Nights
547981 Med Surg Tele Lewiston MAINE 12 Hour Nights
547988 Intermediate Care Rumford MAINE 12 Hour Days
547989 Intermediate Care Rumford MAINE 12 Hour Days
548190 Psych Lewiston MAINE 12 Hour Nights RN/Registered Nurse
444999 PACU Bangor MAINE 12 Hour Days
533322 Long Term Care Lewiston MAINE 12 Hour Nights
538553 Long Term Care Lewiston MAINE 12 Hour Days
542905 Med Surg Lewiston MAINE 12 Hour Days
543822 Certified Surgical Tech York MAINE 8 Hour Days
543913 Echo Technologist Lewiston MAINE 8 Hour Days
544632 ER Machias MAINE 12 Hour Nights
544809 Cath Lab Lewiston MAINE Days
545217 CT Tech York MAINE 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
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
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
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
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
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
547923 OR Muskegon MICHIGAN 10 Hour Days
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.3702 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 2000,100 in 1.3416 seconds