Listing all records

Displaying records 901 through 1000 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
544871 ICU Oxford NORTH CAROLINA 12 Hour Nights
545133 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
546127 Med Surg Oxford NORTH CAROLINA 12 Hour Days
540451 Surgical Tech CVOR Pinehurst NORTH CAROLINA 10 Hour Days
541403 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
542856 Cath Lab Winston-Salem NORTH CAROLINA 8 Hour Days
542858 Cath Lab Winston-Salem NORTH CAROLINA 8 Hour Days
542877 Step Down Fayetteville NORTH CAROLINA 12 Hour Nights
543747 Med Surg Tele Fayetteville NORTH CAROLINA 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
548104 Telemetry - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548106 ER Cobleskill NEW YORK 12 Hour Nights RN/Registered Nurse
548112 ER Rome NEW YORK 12 Hour Nights RN/Registered Nurse
548117 Postpartum New York NEW YORK 8 Hour Days RN/Registered Nurse
548122 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548123 PCU Cooperstown NEW YORK 12 Hour Nights RN/Registered Nurse
548124 Med Surg Tele Cooperstown NEW YORK 12 Hour Nights RN/Registered Nurse
548125 Med Surg Tele Cooperstown NEW YORK 12 Hour Varied RN/Registered Nurse
548127 ICU Glens Falls NEW YORK 12 Hour Days RN/Registered Nurse
548129 L&D Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548130 ER New York NEW YORK 12 Hour Nights RN/Registered Nurse
548136 ICU Glens Falls NEW YORK 12 Hour Nights RN/Registered Nurse
548141 L&D Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548143 House Supervisor New York NEW YORK 8 Hour Days RN/Registered Nurse
548144 House Supervisor New York NEW YORK 8 Hour Days RN/Registered Nurse
548148 PCU Middletown NEW YORK 12 Hour Nights RN/Registered Nurse
548150 NICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548157 Psych Cooperstown NEW YORK 12 Hour Nights RN/Registered Nurse
548170 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548173 Med Surg Auburn NEW YORK 12 Hour Nights RN/Registered Nurse
548174 Psych Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548176 Med Surg Tele Syracuse NEW YORK 12 Hour Days RN/Registered Nurse
548187 L&D Saratoga Springs NEW YORK 12 Hour Nights 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.6613 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 900,100 in 1.5105 seconds