Listing all records

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

ID Job Specialty City State Shift Title
544889 MLT Mason City IOWA 8 Hour Days
525066 PT Mason City IOWA 8 Hour Days
525077 LPN/LVN Mason City IOWA 12 Hour Days
525078 LPN/LVN Mason City IOWA 12 Hour Nights
528026 Med Surg Mason City IOWA 12 Hour Nights
528028 Med Surg Mason City IOWA 12 Hour Nights
528477 Respiratory Therapist Mason City IOWA 12 Hour Days
532546 MRI Tech Mason City IOWA 12 Hour Days
532907 Ultrasound Tech Mason City IOWA 8 Hour Days
533009 Cath Lab Mason City IOWA 8 Hour Days
533010 Cath Lab Mason City IOWA 8 Hour Days
533011 Respiratory Therapist Mason City IOWA 12 Hour Days
533012 Respiratory Therapist Mason City IOWA 12 Hour Days
533013 Respiratory Therapist Mason City IOWA 12 Hour Nights
533014 Respiratory Therapist Mason City IOWA 12 Hour Nights
534799 Sonographer Mason City IOWA 12 Hour Days
535418 Respiratory Therapist Mason City IOWA 12 Hour Days
538136 Echo Mason City IOWA 12 Hour Days
538542 Cath Lab Mason City IOWA 8 Hour Days
538714 Respiratory Therapist Mason City IOWA 12 Hour Nights
539712 Home Health Mason City IOWA 8 Hour Days
540626 OR Mason City IOWA 8 Hour Days
540627 OR Mason City IOWA 8 Hour Days
540628 OR Mason City IOWA 8 Hour Days
542642 Cath Lab Mason City IOWA 8 Hour Days
543126 Cath Lab Mason City IOWA 8 Hour Days
548163 OR Mason City IOWA 8 Hour Days RN/Registered Nurse
547007 CT Tech Maryville ILLINOIS 12 Hour Nights
531899 CT Tech Marysville OHIO 12 Hour Nights
507931 PT Martinez CALIFORNIA 8 Hour Days
547568 CCU Marshall MICHIGAN 12 Hour Nights
546294 Administration Marion INDIANA 12 Hour Nights
531433 Long Term Care Marion VIRGINIA Nights
539692 CNA Marion VIRGINIA 12 Hour Days
539693 CNA Marion VIRGINIA 12 Hour Nights
548139 Newborn Nursery Marion INDIANA 12 Hour Nights RN/Registered Nurse
546352 CT Tech Manteca CALIFORNIA 8 Hour Days
546361 Laboratory Manhasset NEW YORK 8 Hour Days
546362 Laboratory Manhasset NEW YORK 8 Hour Days
527927 PT Mandan NORTH DAKOTA 8 Hour Day/Night Rotate
511950 Med Surg Manchester CONNECTICUT 12 Hour Nights
513409 ER Manchester CONNECTICUT 12 Hour Nights
514124 ER Manchester CONNECTICUT 12 Hour Nights
547480 ER Manchester CONNECTICUT 12 Hour Nights
547481 ER Manchester CONNECTICUT 12 Hour Nights
547549 Med Surg Tele Manchester CONNECTICUT 12 Hour Nights
547550 ER Manchester CONNECTICUT 12 Hour Nights
546866 Surgical Tech Mammoth Lakes CALIFORNIA 12 Hour Day/Night Rotate
547806 PT Mammoth Lakes CALIFORNIA Days
546459 Orthopedics Madison WISCONSIN 12 Hour Day/Night Rotate
546627 CVICU Madison WISCONSIN 8 Hour Day/Night Rotate
546794 Med Surg Tele Madison WISCONSIN 12 Hour Day/Night Rotate
547494 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547696 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547902 SLP Madison WISCONSIN 8 Hour Days
544177 Surgical Tech Madison WISCONSIN 8 Hour Day/Night Rotate
538824 Medical Assistant Madison WISCONSIN 8 Hour Evenings
547952 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547953 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547955 OR Madison WISCONSIN 10 Hour Day/Night Rotate
547962 PICU Madison WISCONSIN 12 Hour Day/Night Rotate
547967 ER Madison WISCONSIN 12 Hour Day/Night Rotate
548294 OR Madison WISCONSIN 12 Hour Days RN/Registered Nurse
544399 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
545033 Echo Technologist Madison WISCONSIN 8 Hour Day/Night Rotate
545990 Neuro Med Surg/Tele Madison WISCONSIN 12 Hour Day/Night Rotate
545991 Neuro Med Surg/Tele Madison WISCONSIN 12 Hour Day/Night Rotate
542081 Med Surg Tele Madison WISCONSIN 12 Hour Day/Night Rotate
542658 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
542669 Oncology Madison WISCONSIN 12 Hour Day/Night Rotate
542670 Oncology Madison WISCONSIN 12 Hour Day/Night Rotate
544168 COTA Madera CALIFORNIA Days
546451 Therapy Rehab Macon GEORGIA 8 Hour Nights
547330 Surgical Tech Macon GEORGIA 8 Hour Days
544632 ER Machias MAINE 12 Hour Nights
544895 RAD Tech Lynwood CALIFORNIA 12 Hour Days
545453 ER Lynwood CALIFORNIA 12 Hour Nights
547569 NICU Lynwood CALIFORNIA 12 Hour Nights
548347 Respiratory Therapist Lynwood CALIFORNIA 12 Hour Nights Respiratory Therapist
548410 Respiratory Therapist Lynwood CALIFORNIA 12 Hour Nights Respiratory Therapist
548257 PACU Lynwood CALIFORNIA 12 Hour Days RN/Registered Nurse
548258 PACU Lynwood CALIFORNIA 12 Hour Days RN/Registered Nurse
540619 L&D Lynwood CALIFORNIA 12 Hour Days
540814 NICU Lynwood CALIFORNIA 12 Hour Nights
540815 Respiratory Care Lynwood CALIFORNIA 12 Hour Nights
542160 CT Tech Lynwood CALIFORNIA 12 Hour Day/Night Rotate
543286 RAD Tech Lynwood CALIFORNIA 8 Hour Nights
543755 NICU Lynwood CALIFORNIA 12 Hour Nights
543757 CT Tech Lynwood CALIFORNIA 12 Hour Days
543758 CT Tech Lynwood CALIFORNIA 12 Hour Days
543759 Neuro Intensive Care Lynwood CALIFORNIA 12 Hour Nights
543760 Neuro Intensive Care Lynwood CALIFORNIA 12 Hour Nights
543769 CLS Lynwood CALIFORNIA 12 Hour Days
543770 CLS Lynwood CALIFORNIA 12 Hour Days
544804 ER Lumberton NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
536346 CVOR Lumberton NORTH CAROLINA 8 Hour Days RN/Registered Nurse
547135 PT Lufkin TEXAS 8 Hour Days
548097 Med Surg Tele Lufkin TEXAS 12 Hour Days RN/Registered Nurse
548282 ICU Lufkin TEXAS 12 Hour Nights RN/Registered Nurse
546948 Echo Lufkin TEXAS 8 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 2.1327 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 desc limit 1500,100 in 1.4857 seconds