Listing all records

Displaying records 2201 through 2300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
538132 PT Salisbury MISSOURI Days
538580 Echo Technologist Columbia MISSOURI Days
546860 Endoscopy Jefferson City MISSOURI 8 Hour Days
546987 Echo Osage Beach MISSOURI 8 Hour Days
547403 Med Surg Tele Kansas City MISSOURI 12 Hour Days
547564 Echo Technologist Cape Girardeau MISSOURI Days
547650 Telemetry Hannibal MISSOURI 12 Hour Days
547730 PT Bolivar MISSOURI 8 Hour Days
547786 CVOR North Kansas City MISSOURI 8 Hour Days
547872 Med Surg Columbia MISSOURI 12 Hour Nights
547873 Endoscopy Columbia MISSOURI 8 Hour Varied
547946 L&D Perryville MISSOURI 12 Hour Nights
547996 Med Surg Perryville MISSOURI 12 Hour Days
547997 Med Surg Perryville MISSOURI 12 Hour Days
548316 OR Jefferson City MISSOURI 10 Hour Days RN/Registered Nurse
540565 Cath Lab Cape Girardeau MISSOURI Days
542272 Med Surg Excelsior Springs MISSOURI 12 Hour Nights
542273 Med Surg Excelsior Springs MISSOURI 12 Hour Nights
543455 OR Cape Girardeau MISSOURI Days
543591 SLP Milan MISSOURI Days
545565 Therapy Rehab Springfield MISSOURI 8 Hour Days
545566 Therapy Rehab Springfield MISSOURI 8 Hour Days
546014 PT Bolivar MISSOURI 8 Hour Days
544290 Infusion Oncology Sidney MONTANA Days
544489 CT Tech Culbertson MONTANA Days
544975 CT Tech Glendive MONTANA 8 Hour Varied
545300 Med Surg Helena MONTANA 12 Hour Nights
545380 L&D Lewistown MONTANA Nights
547948 MLT Wolf Point MONTANA 8 Hour Days
548008 Respiratory Therapist Plains MONTANA Days
465120 Long Term Care Conrad MONTANA 8 Hour Evenings
484007 CT Tech Wolf Point MONTANA 12 Hour Day/Night Rotate
487151 Long Term Care Conrad MONTANA 12 Hour Day/Night Rotate
507007 Administration Scobey MONTANA Varied
541886 Rehab Chesterfield MONTANA 12 Hour Days
526505 PT Plains MONTANA Varied
538302 Home Health Plains MONTANA Varied
539974 ER Philipsburg MONTANA 12 Hour Nights
547305 PT Plains MONTANA Varied
547385 Med Surg Missoula MONTANA 12 Hour Nights
547580 Therapy Rehab Helena MONTANA Days
547704 Scrub Tech DILLON MONTANA 10 Hour Day/Night Rotate
547793 ICU Bozeman MONTANA 12 Hour Day/Night Rotate
541627 PT Butte MONTANA Days
542131 Echo Great Falls MONTANA 8 Hour Days
543900 CT Tech Culbertson MONTANA Days
541359 Vascular Ultrasound Tech Kearney NEBRASKA 8 Hour Days
542474 Sterile Processing Technician Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
543991 OR Omaha NEBRASKA 10 Hour Days
490405 Long Term Care Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
492265 Long Term Care Scottsbluff NEBRASKA Nights
535909 PT Blue Hill NEBRASKA Days
538194 CT Tech Omaha NEBRASKA 12 Hour Nights
538195 CT Tech Omaha NEBRASKA 12 Hour Days
538460 PCU Grand Island NEBRASKA 12 Hour Nights
544388 ICU Scottsbluff NEBRASKA 12 Hour Varied
544977 Scrub Tech Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
544994 Surgical Tech Kearney NEBRASKA 8 Hour Days
544995 PCU Omaha NEBRASKA 12 Hour Nights
544996 CT Tech Omaha NEBRASKA 12 Hour Nights
545242 ICU Scottsbluff NEBRASKA 12 Hour Varied
545262 PCU Omaha NEBRASKA 12 Hour Nights
547963 Med Surg Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
546455 Med Surg Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
547351 PT Falls City NEBRASKA 8 Hour Days
547352 PT Falls City NEBRASKA 8 Hour Days
547654 PCU Kearney NEBRASKA 12 Hour Nights
547655 Med Surg Kearney NEBRASKA 12 Hour Nights
547656 Rehab Omaha NEBRASKA 12 Hour Days
547657 PCU Omaha NEBRASKA 12 Hour Nights
547658 PCU Omaha NEBRASKA 12 Hour Nights
547659 PCU Omaha NEBRASKA 12 Hour Days
547662 Surgical Tech Omaha NEBRASKA 8 Hour Days
547707 ICU North Platte NEBRASKA Nights
546697 Surgical Tech Reno NEVADA 12 Hour Days
544240 RAD Tech Reno NEVADA 12 Hour Days
544241 RAD Tech Reno NEVADA 12 Hour Days
544242 CT Tech Reno NEVADA 12 Hour Nights
544243 CT Tech Reno NEVADA 12 Hour Nights
544245 CVOR Reno NEVADA 12 Hour Day/Night Rotate
545237 Surgical Tech CVOR Reno NEVADA 10 Hour Days
545413 MLT Ely NEVADA 12 Hour Days
543750 CLS Reno NEVADA 12 Hour Day/Night Rotate
514085 Therapy Rehab Sparks NEVADA Days
528766 PT Sparks NEVADA Days
496817 Surgical Tech Peterborough NEW HAMPSHIRE 8 Hour Days
548240 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548241 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548242 Med Surg Peterborough NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548248 ER Keene NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548239 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
545014 Medical Assistant Claremont NEW HAMPSHIRE 12 Hour Days
532394 ICU Nashua NEW HAMPSHIRE 12 Hour Nights
534694 Psych Woodsville NEW HAMPSHIRE 12 Hour Day/Night Rotate
543152 Ultrasound Tech Concord NEW HAMPSHIRE 8 Hour Days
542299 ER Laconia NEW HAMPSHIRE Nights
543153 Ultrasound Tech Concord NEW HAMPSHIRE 8 Hour Days
543494 Med Surg Nashua NEW HAMPSHIRE 12 Hour Nights
543585 CT Tech Laconia NEW HAMPSHIRE 12 Hour Days
543592 PACU Nashua NEW HAMPSHIRE 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.6189 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 2200,100 in 1.3816 seconds