Listing all records

Displaying records 1401 through 1500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
543693 Med Surg Tele Laconia NEW HAMPSHIRE 12 Hour Day/Night Rotate
546228 Pediatrics Concord NEW HAMPSHIRE 12 Hour Nights
546303 MRI Tech Concord NEW HAMPSHIRE 12 Hour Nights
546304 MRI Tech Concord NEW HAMPSHIRE 12 Hour Nights
546630 Med Surg Tele Laconia NEW HAMPSHIRE Nights
546670 Outpatient Clinic Claremont NEW HAMPSHIRE 8 Hour Days
547050 CNA Claremont NEW HAMPSHIRE 8 Hour Evenings
547462 Long Term Care Claremont NEW HAMPSHIRE 8 Hour Days
547463 CNA Claremont NEW HAMPSHIRE 8 Hour Day/Night Rotate
547464 CNA Claremont NEW HAMPSHIRE 8 Hour Evenings
547465 Long Term Care Claremont NEW HAMPSHIRE 8 Hour Evenings
547667 ICU Laconia NEW HAMPSHIRE Nights
547668 ICU Laconia NEW HAMPSHIRE Nights
547670 Psych Nashua NEW HAMPSHIRE 12 Hour Nights
547866 RRT- Respiratory Exeter NEW HAMPSHIRE 12 Hour Nights
546697 Surgical Tech Reno NEVADA 12 Hour Days
514085 Therapy Rehab Sparks NEVADA Days
528766 PT Sparks NEVADA 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
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
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
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
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
541627 PT Butte MONTANA Days
542131 Echo Great Falls MONTANA 8 Hour Days
543900 CT Tech Culbertson 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
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
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
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.6279 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 1400,100 in 1.5831 seconds