Listing all records

Displaying records 301 through 400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
543821 Med Surg Tele Bristol TENNESSEE 12 Hour Days
419839 Med Surg Bristol TENNESSEE 12 Hour Nights
539391 OR Bristol TENNESSEE 12 Hour Varied
543820 Oncology Bristol TENNESSEE 12 Hour Nights
509435 ER Bronx NEW YORK 12 Hour Days
535099 Radiology Bronx NEW YORK 12 Hour Days
532671 ER Bronx NEW YORK 12 Hour Days
547717 L&D Bronx NEW YORK 12 Hour Days
547422 Med Surg Bronx NEW YORK Days
547415 Ambulatory Bronx NEW YORK 8 Hour Days
547414 NICU Bronx NEW YORK 8 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
545192 Acute Care Bronx NEW YORK 12 Hour Nights
545169 Acute Care Bronx NEW YORK 12 Hour Days
542814 ER Bronx NEW YORK 12 Hour Nights
542811 ER Bronx NEW YORK 12 Hour Days
542029 Med Surg Bronx NEW YORK 10 Hour Days
543965 ICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548322 PICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
543933 Med Surg Bronx NEW YORK 12 Hour Days
544061 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
542138 Med Surg Brooklyn NEW YORK 12 Hour Nights
542137 Med Surg Brooklyn NEW YORK 12 Hour Nights
541734 Med Surg Brooklyn NEW YORK 12 Hour Evenings
541730 First Assist Brooklyn NEW YORK 8 Hour Days
543230 OR Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
543935 Acute Care Brooklyn NEW YORK 8 Hour Days
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
548058 Dialysis Brooklyn NEW YORK 10 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
548099 Telemetry - Per Diem Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548104 Telemetry - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548122 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548188 Med Surg Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548193 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548202 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548215 ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548216 Med Surg Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548223 Psych Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548229 ICU Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548238 Neuro Intensive Care Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548292 Med Surg Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548304 Psych Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
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
509928 NICU Brooklyn NEW YORK 12 Hour Nights
539293 Supervisor Brooklyn NEW YORK 8 Hour Days
542491 Med Surg Brooklyn NEW YORK 12 Hour Nights
538625 Med Surg Brooklyn NEW YORK 12 Hour Days
541846 PCU Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
538306 Step Down Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
537446 CNA Brooklyn NEW YORK 8 Hour Days
537445 CNA Brooklyn NEW YORK 8 Hour Nights
523478 ICU Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
537444 CNA Brooklyn NEW YORK 8 Hour Nights
525187 CVICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
525929 Nurse Practicioner Brooklyn NEW YORK 8 Hour Days
531766 PICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
531765 L&D Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
531394 Pediatrics Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
531355 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
531354 ER - Per Diem Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
530873 Med Surg Tele Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
527935 OR Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
530911 Pediatric ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
528573 Pediatrics Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
547753 Med Surg Brooklyn NEW YORK Nights
547752 Med Surg Brooklyn NEW YORK Nights
547751 NICU Brooklyn NEW YORK 12 Hour Nights
547750 NICU Brooklyn NEW YORK 12 Hour Nights
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
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.5127 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 asc limit 300,100 in 1.4393 seconds