Listing all records

Displaying records 2601 through 2700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
542785 Case Manager Glens Falls NEW YORK 8 Hour Days
541809 Med Surg Oneonta NEW YORK 12 Hour Nights
541810 Med Surg Oneonta NEW YORK 12 Hour Nights
522473 CNA Lowville NEW YORK 8 Hour Evenings
522479 CNA Lowville NEW YORK 8 Hour Evenings
523478 ICU Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
525187 CVICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
525662 Nurse Practicioner Syracuse NEW YORK 12 Hour Varied
525929 Nurse Practicioner Brooklyn NEW YORK 8 Hour Days
527684 PICU New York NEW YORK 12 Hour Days RN/Registered Nurse
525987 Supervisor New York NEW YORK 8 Hour Days
525988 Supervisor New York NEW YORK 8 Hour Days
526102 ICU New York NEW YORK 12 Hour Days RN/Registered Nurse
547698 ICU Saratoga Springs NEW YORK 12 Hour Nights
527935 OR Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
527995 Oncology Albany NEW YORK 12 Hour Nights
528573 Pediatrics Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
529162 Physician Assistant Syracuse NEW YORK 8 Hour Varied
530911 Pediatric ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
534643 Med Surg New York NEW YORK 12 Hour Nights
530820 CT Tech Hudson NEW YORK 12 Hour Nights
530873 Med Surg Tele Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
531138 ICU Ogdensburg NEW YORK 12 Hour Nights
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
531618 Med Surg Massena NEW YORK 12 Hour Nights
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
532671 ER Bronx NEW YORK 12 Hour Days
534169 Med Surg Oneonta NEW YORK 12 Hour Nights
534655 CT Tech Syracuse NEW YORK 8 Hour Days
537444 CNA Brooklyn NEW YORK 8 Hour Nights
535099 Radiology Bronx NEW YORK 12 Hour Days
535266 Med Surg Ogdensburg NEW YORK 12 Hour Nights
535732 Pharmacist New York NEW YORK 8 Hour Nights
536558 ER Syracuse NEW YORK 12 Hour Nights RN/Registered Nurse
536589 OR New York NEW YORK 12 Hour Nights
536590 OR New York NEW YORK 12 Hour Nights
537141 ICU Ogdensburg NEW YORK 12 Hour Nights
537185 CT Tech Syracuse NEW YORK Nights
537445 CNA Brooklyn NEW YORK 8 Hour Nights
537446 CNA Brooklyn NEW YORK 8 Hour Days
537741 Psych New York NEW YORK 12 Hour Days
537792 L&D Ogdensburg NEW YORK 12 Hour Nights
538306 Step Down Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
537958 MRI Tech Staten Island NEW YORK 8 Hour Evenings
543428 ICU Ogdensburg NEW YORK 12 Hour Nights
538261 ICU Ogdensburg NEW YORK 12 Hour Nights
538497 Laboratory New York NEW YORK 8 Hour Evenings
538498 CT Tech Riverhead NEW YORK 8 Hour Nights
546759 L&D Auburn NEW YORK 12 Hour Nights
538581 Long Term Care Canton NEW YORK 12 Hour Varied
538622 ER New York NEW YORK 12 Hour Nights
538624 ER New York NEW YORK 12 Hour Nights
538625 Med Surg Brooklyn NEW YORK 12 Hour Days
538686 Laboratory New York NEW YORK 8 Hour Days
543405 ICU Rome NEW YORK 12 Hour Nights
539176 ICU Albany NEW YORK 12 Hour Days
539177 Cardiology Albany NEW YORK 12 Hour Nights
539178 Med Surg Troy NEW YORK 12 Hour Nights
539293 Supervisor Brooklyn NEW YORK 8 Hour Days
539294 Radiology Queens NEW YORK 8 Hour Days
539450 Med Surg New York NEW YORK 8 Hour Evenings
539559 Laboratory New York NEW YORK 8 Hour Evenings
539926 Med Surg Schenectady NEW YORK 12 Hour Days
546190 Interventional Radiology Auburn NEW YORK 8 Hour Days
546205 Long Term Care Watertown NEW YORK 12 Hour Day/Night Rotate
546225 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
546233 Long Term Care Watertown NEW YORK 8 Hour Evenings
546307 ER Watertown NEW YORK 12 Hour Day/Night Rotate
546308 ER Watertown NEW YORK 12 Hour Day/Night Rotate
546360 Sonographer Forest Hills NEW YORK 8 Hour Days
546361 Laboratory Manhasset NEW YORK 8 Hour Days
546362 Laboratory Manhasset NEW YORK 8 Hour Days
546410 ICU Ogdensburg NEW YORK 12 Hour Nights
546411 ICU Ogdensburg 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
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
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.9434 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 2600,100 in 1.6404 seconds