Listing all records

Displaying records 3301 through 3400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548327 ICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548339 Psych Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548349 ER Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548355 Neuro Intensive Care Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548409 ER Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
545171 Med Surg Brooklyn NEW YORK 8 Hour Evenings
545173 Med Surg Brooklyn NEW YORK 12 Hour Days
545178 Med Surg Brooklyn NEW YORK 8 Hour Evenings
545179 Med Surg Brooklyn NEW YORK 12 Hour Days
541730 First Assist Brooklyn NEW YORK 8 Hour Days
541734 Med Surg Brooklyn NEW YORK 12 Hour Evenings
542137 Med Surg Brooklyn NEW YORK 12 Hour Nights
542138 Med Surg Brooklyn NEW YORK 12 Hour Nights
543230 OR Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
543872 NICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
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
543935 Acute Care Brooklyn NEW YORK 8 Hour Days
544061 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
546489 OR Brooklyn NEW YORK 8 Hour Days
546552 Dialysis Brooklyn NEW YORK 10 Hour Nights
546554 Dialysis Brooklyn NEW YORK 12 Hour Days
546561 ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
546565 NICU Brooklyn NEW YORK 12 Hour Nights
546566 ICU Brooklyn NEW YORK 12 Hour Days
546567 ICU Brooklyn NEW YORK 12 Hour Days
546568 NICU Brooklyn NEW YORK 12 Hour Days
546569 Med Surg Brooklyn NEW YORK 12 Hour Nights
546570 ICU Brooklyn NEW YORK 12 Hour Nights
546571 MICU Brooklyn NEW YORK 12 Hour Nights
546572 Med Surg Brooklyn NEW YORK 12 Hour Nights
546573 MICU Brooklyn NEW YORK 12 Hour Days
546574 MICU Brooklyn NEW YORK 12 Hour Days
546575 NICU Brooklyn NEW YORK 12 Hour Nights
546576 MICU Brooklyn NEW YORK 12 Hour Days
546577 ICU Brooklyn NEW YORK 12 Hour Nights
546578 ER Brooklyn NEW YORK 12 Hour Nights
546590 Med Surg Brooklyn NEW YORK 12 Hour Days
546591 MICU Brooklyn NEW YORK 12 Hour Days
546593 ER Brooklyn NEW YORK 12 Hour Nights
547152 OR Brooklyn NEW YORK 8 Hour Days
547183 OR Brooklyn NEW YORK 12 Hour Nights
547185 Med Surg Brooklyn NEW YORK 12 Hour Days
547186 Med Surg Brooklyn NEW YORK 12 Hour Days
547187 Med Surg Brooklyn NEW YORK 8 Hour Nights
547188 Med Surg Brooklyn NEW YORK 12 Hour Days
547189 Surgical Tech Brooklyn NEW YORK 8 Hour Nights
547226 L&D Brooklyn NEW YORK 12 Hour Days
547235 NICU Brooklyn NEW YORK 12 Hour Days
547469 Med Surg Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
547560 Dialysis Per Diem Brooklyn NEW YORK 10 Hour Evenings RN/Registered Nurse
547750 NICU Brooklyn NEW YORK 12 Hour Nights
547751 NICU Brooklyn NEW YORK 12 Hour Nights
547752 Med Surg Brooklyn NEW YORK Nights
547753 Med Surg Brooklyn NEW YORK Nights
509928 NICU Brooklyn NEW YORK 12 Hour Nights
542491 Med Surg Brooklyn NEW YORK 12 Hour Nights
541846 PCU Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
523478 ICU Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
525187 CVICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
525929 Nurse Practicioner Brooklyn NEW YORK 8 Hour Days
527935 OR Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
528573 Pediatrics Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
530911 Pediatric ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
530873 Med Surg Tele Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
531354 ER - Per Diem Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
531355 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
531394 Pediatrics Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
531765 L&D Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
531766 PICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
537444 CNA Brooklyn NEW YORK 8 Hour Nights
537445 CNA Brooklyn NEW YORK 8 Hour Nights
537446 CNA Brooklyn NEW YORK 8 Hour Days
538306 Step Down Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
538625 Med Surg Brooklyn NEW YORK 12 Hour Days
539293 Supervisor Brooklyn NEW YORK 8 Hour Days
509435 ER Bronx NEW YORK 12 Hour Days
532671 ER Bronx NEW YORK 12 Hour Days
535099 Radiology Bronx NEW YORK 12 Hour Days
543965 ICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
542029 Med Surg Bronx NEW YORK 10 Hour Days
542811 ER Bronx NEW YORK 12 Hour Days
542814 ER Bronx NEW YORK 12 Hour Nights
548322 PICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
543933 Med Surg Bronx NEW YORK 12 Hour Days
547970 Pediatric ER Bronx NEW YORK Nights
547971 Acute Care Bronx NEW YORK Days
548129 L&D Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548141 L&D Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548150 NICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548174 Psych Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548199 Med Surg Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548231 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548237 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548275 MICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548281 ICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548300 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548336 MICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548338 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
545169 Acute Care Bronx NEW YORK 12 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.5301 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 3300,100 in 1.3541 seconds