Listing all records

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

ID Job Specialty City State Shift Title
547676 ICU Lowville NEW YORK 12 Hour Nights
547677 Med Surg Lowville NEW YORK 12 Hour Days
547678 Med Surg Lowville NEW YORK 12 Hour Days
547818 Long Term Care Lowville NEW YORK 12 Hour Days
547819 Long Term Care Lowville NEW YORK 12 Hour Days
543032 Long Term Care Lowville NEW YORK 12 Hour Nights
541606 Surgical Tech CVOR Lubbock TEXAS 10 Hour Days
535911 Telemetry Lubbock TEXAS 12 Hour Days RN/Registered Nurse
546343 Med Surg Tele Lubbock TEXAS 12 Hour Days
546948 Echo Lufkin TEXAS 8 Hour Day/Night Rotate
548097 Med Surg Tele Lufkin TEXAS 12 Hour Days RN/Registered Nurse
548282 ICU Lufkin TEXAS 12 Hour Nights RN/Registered Nurse
547135 PT Lufkin TEXAS 8 Hour Days
536346 CVOR Lumberton NORTH CAROLINA 8 Hour Days RN/Registered Nurse
544804 ER Lumberton NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
544895 RAD Tech Lynwood CALIFORNIA 12 Hour Days
545453 ER Lynwood CALIFORNIA 12 Hour Nights
548257 PACU Lynwood CALIFORNIA 12 Hour Days RN/Registered Nurse
548258 PACU Lynwood CALIFORNIA 12 Hour Days RN/Registered Nurse
547569 NICU Lynwood CALIFORNIA 12 Hour Nights
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
548347 Respiratory Therapist Lynwood CALIFORNIA 12 Hour Nights Respiratory Therapist
548410 Respiratory Therapist Lynwood CALIFORNIA 12 Hour Nights Respiratory Therapist
544632 ER Machias MAINE 12 Hour Nights
546451 Therapy Rehab Macon GEORGIA 8 Hour Nights
547330 Surgical Tech Macon GEORGIA 8 Hour Days
544168 COTA Madera CALIFORNIA Days
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
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
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
544177 Surgical Tech Madison WISCONSIN 8 Hour Day/Night Rotate
538824 Medical Assistant Madison WISCONSIN 8 Hour Evenings
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
546866 Surgical Tech Mammoth Lakes CALIFORNIA 12 Hour Day/Night Rotate
547806 PT Mammoth Lakes CALIFORNIA Days
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
511950 Med Surg Manchester CONNECTICUT 12 Hour Nights
513409 ER Manchester CONNECTICUT 12 Hour Nights
514124 ER Manchester CONNECTICUT 12 Hour Nights
527927 PT Mandan NORTH DAKOTA 8 Hour Day/Night Rotate
546361 Laboratory Manhasset NEW YORK 8 Hour Days
546362 Laboratory Manhasset NEW YORK 8 Hour Days
546352 CT Tech Manteca CALIFORNIA 8 Hour Days
546294 Administration Marion INDIANA 12 Hour Nights
548139 Newborn Nursery Marion INDIANA 12 Hour Nights RN/Registered Nurse
531433 Long Term Care Marion VIRGINIA Nights
539692 CNA Marion VIRGINIA 12 Hour Days
539693 CNA Marion VIRGINIA 12 Hour Nights
547568 CCU Marshall MICHIGAN 12 Hour Nights
507931 PT Martinez CALIFORNIA 8 Hour Days
531899 CT Tech Marysville OHIO 12 Hour Nights
547007 CT Tech Maryville ILLINOIS 12 Hour Nights
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
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.3823 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 2100,100 in 1.3761 seconds