Listing all records

Displaying records 2401 through 2500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
544850 RAD Tech Albuquerque NEW MEXICO 8 Hour Day/Night Rotate
545082 Vascular Ultrasound Tech Artesia NEW MEXICO Days
545128 Med Surg Albuquerque NEW MEXICO 12 Hour Nights
545226 Cardiac Telemetry Farmington NEW MEXICO 12 Hour Nights
545610 Med Surg HOBBS NEW MEXICO 12 Hour Nights
545560 Scrub Tech Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
546110 PTA Clovis NEW MEXICO 8 Hour Days
548247 ER Artesia NEW MEXICO 12 Hour Nights RN/Registered Nurse
541860 PT Lovington NEW MEXICO 8 Hour Days
527987 Case Manager Albuquerque NEW MEXICO 10 Hour Days
545126 Med Surg Espanola NEW MEXICO Nights
547945 Cardiac Telemetry Farmington NEW MEXICO 12 Hour Nights
548093 ER Albuquerque NEW MEXICO 12 Hour Nights RN/Registered Nurse
548096 Med Surg Espanola NEW MEXICO 12 Hour Nights RN/Registered Nurse
548138 ER Truth or Consequences NEW MEXICO 12 Hour Days RN/Registered Nurse
546309 ER Santa Rosa NEW MEXICO 12 Hour Nights
546310 ER Santa Rosa NEW MEXICO 12 Hour Nights
547026 ICU Santa Fe NEW MEXICO 12 Hour Day/Night Rotate
547066 PCU Rio Rancho NEW MEXICO 12 Hour Nights
547374 PCU Albuquerque NEW MEXICO 12 Hour Days
547377 PCU Albuquerque NEW MEXICO 12 Hour Days
547489 CT Tech Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
547515 Medical Assistant Ruidoso NEW MEXICO 8 Hour Days
547822 Interventional Radiology Tech Farmington NEW MEXICO 8 Hour Days
541326 Certified Surgical Tech Albuquerque NEW MEXICO 12 Hour Nights
541332 PCU Albuquerque NEW MEXICO 12 Hour Nights
542340 Home Health Santa Fe NEW MEXICO 8 Hour Days RN/Registered Nurse
542497 PT Clovis NEW MEXICO 8 Hour Days
543296 OR Albuquerque NEW MEXICO 12 Hour Days
543297 OR Albuquerque NEW MEXICO Nights
543725 OR Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
543807 PACU Albuquerque NEW MEXICO 12 Hour Nights
540482 OR New York NEW YORK 12 Hour Nights
540488 SNF Staten Island NEW YORK 8 Hour Nights
540498 Pediatric ER New York NEW YORK 12 Hour Nights
540501 Supervisor New York NEW YORK 8 Hour Days
540588 MLT Watertown NEW YORK Varied
540589 MLT Watertown NEW YORK Days
540994 Outpatient Clinic Watertown NEW YORK 8 Hour Day/Night Rotate
541109 MLT Syracuse NEW YORK 8 Hour Nights
542442 Med Surg Oneonta NEW YORK 12 Hour Days
541437 Echo Syracuse NEW YORK 8 Hour Days
541730 First Assist Brooklyn NEW YORK 8 Hour Days
541734 Med Surg Brooklyn NEW YORK 12 Hour Evenings
543965 ICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
541984 Med Surg New York NEW YORK Days
542029 Med Surg Bronx NEW YORK 10 Hour Days
542085 PT Oneonta NEW YORK 8 Hour Days
542114 Med Surg Tele Syracuse NEW YORK Nights
542137 Med Surg Brooklyn NEW YORK 12 Hour Nights
542138 Med Surg Brooklyn NEW YORK 12 Hour Nights
542390 Pediatric ER New York NEW YORK 12 Hour Nights
542586 OR Watertown NEW YORK 8 Hour Varied
542713 Med Surg Tele Potsdam NEW YORK 12 Hour Nights
542740 ICU Saratoga Springs NEW YORK 12 Hour Nights
542811 ER Bronx NEW YORK 12 Hour Days
542814 ER Bronx NEW YORK 12 Hour Nights
542972 Acute Care New York NEW YORK Days
542981 Med Surg Watertown NEW YORK 12 Hour Nights
543032 Long Term Care Lowville NEW YORK 12 Hour Nights
543046 Histology Technician Watertown NEW YORK Days
548322 PICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
543147 Med Surg Tele Potsdam NEW YORK 12 Hour Nights
543178 Neuro Intensive Care New York NEW YORK Days
543186 Med Surg Oneonta NEW YORK 12 Hour Days
543230 OR Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
543318 CT Tech Staten Island NEW YORK 8 Hour Evenings
543343 CT Tech Staten Island NEW YORK 8 Hour Days
543378 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
547756 Outpatient Clinic Cooperstown NEW YORK 8 Hour Days
543475 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Nights
543872 NICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
547059 ER Rome NEW YORK 12 Hour Nights
543730 Med Surg Tele Cooperstown NEW YORK 12 Hour Nights
543903 Adult Care Rockaway Park NEW YORK 8 Hour Days
543861 L&D Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
543862 PICU Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
543933 Med Surg Bronx NEW YORK 12 Hour Days
543935 Acute Care Brooklyn NEW YORK 8 Hour Days
544061 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
544067 Med Surg Tele Glens Falls NEW YORK 12 Hour Nights
547956 Surgical Tech Glens Falls NEW YORK 10 Hour Days
547959 Surgical Tech Glens Falls NEW YORK 10 Hour Evenings
547969 Surgical Tech Auburn NEW YORK 10 Hour Days
547970 Pediatric ER Bronx NEW YORK Nights
547971 Acute Care Bronx NEW YORK Days
547972 Cardiac Telemetry Albany NEW YORK 12 Hour Nights
547973 Med Surg Oneonta NEW YORK 12 Hour Days
548041 PCU Middletown NEW YORK 12 Hour Nights RN/Registered Nurse
548047 Respiratory Therapist Schenectady NEW YORK 12 Hour Nights Respiratory Therapist
548050 Respiratory Therapist Stony Brook NEW YORK 12 Hour Nights Respiratory Therapist
548053 NICU New York NEW YORK 12 Hour Days RN/Registered Nurse
548055 ER Glens Falls NEW YORK 12 Hour Nights RN/Registered Nurse
548058 Dialysis Brooklyn NEW YORK 10 Hour Days RN/Registered Nurse
548063 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548069 Psych Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548074 ICU - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548086 Ultrasound Tech Cobleskill NEW YORK 8 Hour Days Tech/Technologist
548099 Telemetry - Per Diem Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548103 L&D New York NEW YORK 12 Hour Days RN/Registered Nurse
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.5132 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 2400,100 in 1.6194 seconds