Listing all records

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

ID Job Specialty City State Shift Title
542873 PT Monterey CALIFORNIA Days
544641 PT Monterey CALIFORNIA Days
531507 Therapy Rehab Modesto CALIFORNIA Days
535270 PTA Modesto CALIFORNIA Days
535271 PTA Modesto CALIFORNIA Days
548137 Med Surg Modesto CALIFORNIA 12 Hour Nights RN/Registered Nurse
548353 Behavioral Health Modesto CALIFORNIA 12 Hour Days RN/Registered Nurse
547385 Med Surg Missoula MONTANA 12 Hour Nights
547940 Nuclear Med Technician Mission Viejo CALIFORNIA 8 Hour Days
539477 Telemetry - Per Diem Mission Viejo CALIFORNIA 12 Hour Days RN/Registered Nurse
545606 Interventional Radiology Tech Mission Viejo CALIFORNIA 10 Hour Days
545611 Cath Lab Mission Viejo CALIFORNIA 10 Hour Days
545613 EP Tech Mission Viejo CALIFORNIA 10 Hour Days
544915 PT Mission Hills CALIFORNIA 8 Hour Days
546321 PT Mission Hills CALIFORNIA 8 Hour Days
547329 NICU Mission Hills CALIFORNIA 12 Hour Nights
548207 ER Mission Hills CALIFORNIA 12 Hour Evenings RN/Registered Nurse
524675 CVOR Mishawaka INDIANA 12 Hour Days
539715 Respiratory Therapist Mishawaka INDIANA 12 Hour Days
544265 Respiratory Therapist Mishawaka INDIANA 12 Hour Nights
544266 Respiratory Therapist Mishawaka INDIANA 12 Hour Nights
545190 Pharmacy Tech Mishawaka INDIANA 8 Hour Nights
545425 L&D Mishawaka INDIANA 12 Hour Days
545426 NICU Mishawaka INDIANA 12 Hour Days
545427 NICU Mishawaka INDIANA 12 Hour Nights
544964 Nuclear Med Technician Mishawaka INDIANA 8 Hour Days
546602 CT Tech Minneapolis MINNESOTA 12 Hour Days
547947 Echo Minneapolis MINNESOTA 8 Hour Days
547810 Oncology Milford MASSACHUSETTS 12 Hour Nights
543591 SLP Milan MISSOURI Days
544678 Oncology Midland TEXAS Nights
548041 PCU Middletown NEW YORK 12 Hour Nights RN/Registered Nurse
548148 PCU Middletown NEW YORK 12 Hour Nights RN/Registered Nurse
542657 PT Middletown OHIO Days
547957 OR Mesquite TEXAS 8 Hour Days
547725 Med Surg Mesa ARIZONA 12 Hour Days
547728 PCU Mesa ARIZONA 12 Hour Nights
547729 PCU Mesa ARIZONA 12 Hour Days
539674 Med Surg Mesa ARIZONA 12 Hour Nights
547904 ICU Mesa ARIZONA 12 Hour Nights
546005 PCU Mesa ARIZONA 12 Hour Days
548133 Cath Lab Mesa ARIZONA 12 Hour Days RN/Registered Nurse
548200 Respiratory Therapist Mesa ARIZONA 12 Hour Days Respiratory Therapist
547318 ICU Meridian IDAHO 12 Hour Nights
547889 RRT- Respiratory Meridian IDAHO 12 Hour Nights
544354 Med Surg Meridian IDAHO 12 Hour Nights
544735 Surgical Tech MERCED CALIFORNIA 12 Hour Days
548161 Surgical Tech MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
548114 Telemetry MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
548391 ICU Merced CALIFORNIA 12 Hour Nights RN/Registered Nurse
541028 SLP MERCED CALIFORNIA 8 Hour Days
484788 PTA Merced CALIFORNIA Days
546868 ER MERCED CALIFORNIA 12 Hour Days
546881 ER MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
547246 Postpartum Memphis TENNESSEE 12 Hour Nights
545292 CVICU Memphis TENNESSEE 12 Hour Nights
545526 Med Surg Memphis TENNESSEE 12 Hour Days
547977 ICU Memphis TENNESSEE 12 Hour Nights
548310 ER Memphis TENNESSEE 12 Hour Nights RN/Registered Nurse
532545 CT Tech Melrose Park ILLINOIS 8 Hour Evenings
536227 CT Tech Melrose Park ILLINOIS 8 Hour Evenings
547886 CT Tech McCall IDAHO 12 Hour Nights
547887 CT Tech McCall IDAHO Days
546367 OR Maywood ILLINOIS 10 Hour Days
524930 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
524932 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
524933 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
524972 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
524989 Telemetry Maywood ILLINOIS 12 Hour Nights
532473 ICU Maywood ILLINOIS 12 Hour Nights
535604 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536228 RAD Tech Maywood ILLINOIS 8 Hour Nights
536231 CT Tech Maywood ILLINOIS 8 Hour Evenings
536440 Infusion Oncology Maywood ILLINOIS 8 Hour Days
536499 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536500 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536501 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536502 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536503 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536504 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536505 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536506 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536507 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536508 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536932 RAD Tech Maywood ILLINOIS 8 Hour Days
540632 OR Maywood ILLINOIS 10 Hour Days
544293 OR Maywood ILLINOIS 10 Hour Days
544294 OR Maywood ILLINOIS 10 Hour Days
544818 OR Maywood ILLINOIS 10 Hour Days
544162 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
545369 Step Down Mayfield Heights OHIO 12 Hour Nights
546020 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
546021 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
540821 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
541384 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
517904 Med Surg Tele Maui Wailuku HAWAII 12 Hour Nights
517913 Med Surg Tele Maui Wailuku HAWAII 12 Hour Nights
531618 Med Surg Massena NEW YORK 12 Hour Nights
545621 ER Massena NEW YORK 12 Hour Nights
545252 GI 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.5883 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 1400,100 in 1.6408 seconds