Listing all records

Displaying records 1101 through 1200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546937 ER Albany NEW YORK 12 Hour Nights
546938 ER Albany NEW YORK 12 Hour Nights
546939 ER Albany NEW YORK 12 Hour Nights
546984 CVICU Albany NEW YORK 12 Hour Nights
546985 Med Surg Tele Syracuse NEW YORK 12 Hour Days
546993 Med Surg Troy NEW YORK 12 Hour Nights
546994 Med Surg Troy NEW YORK 12 Hour Nights
547023 Med Surg Tele Rome NEW YORK 12 Hour Nights
547024 Med Surg Tele Rome NEW YORK 12 Hour Nights
547031 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547032 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547033 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547034 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547035 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547039 Supervisor Oneonta NEW YORK 8 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
547267 Med Surg Tele Glens Falls NEW YORK 12 Hour Nights
547274 Med Surg Glens Falls NEW YORK 12 Hour Nights
547275 CT Tech Syracuse NEW YORK 12 Hour Nights
547396 Med Surg Tele Potsdam NEW YORK 12 Hour Nights
547408 Ultrasound Tech Cooperstown NEW YORK 10 Hour Days
547414 NICU Bronx NEW YORK 8 Hour Days
547415 Ambulatory Bronx NEW YORK 8 Hour Days
547420 Radiology New York NEW YORK Nights
547422 Med Surg Bronx NEW YORK Days
547423 Ambulatory New York NEW YORK 8 Hour Days
547461 Radiology Tech Auburn 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
547566 ER Watertown NEW YORK 12 Hour Day/Night Rotate
547576 ER Watertown NEW YORK 12 Hour Day/Night Rotate
547579 MLT Watertown NEW YORK Nights
547676 ICU Lowville NEW YORK 12 Hour Nights
547677 Med Surg Lowville NEW YORK 12 Hour Days
547678 Med Surg Lowville NEW YORK 12 Hour Days
547692 Ambulatory New York NEW YORK 8 Hour Days
547711 ER New York NEW YORK 12 Hour Days
547713 Med Surg Queens NEW YORK 12 Hour Nights
547714 Med Surg Queens NEW YORK 12 Hour Nights
547715 Med Surg New York NEW YORK 12 Hour Nights
547716 Med Surg New York NEW YORK 8 Hour Days
547717 L&D Bronx NEW YORK 12 Hour Days
547718 Rehab New York NEW YORK Nights
547719 Med Surg Queens NEW YORK 12 Hour Days
547746 Ambulatory New York NEW YORK 8 Hour Days
547747 Ambulatory New York NEW YORK 8 Hour Days
547748 Med Surg New York NEW YORK 8 Hour Nights
547749 Med Surg New York NEW YORK 8 Hour Nights
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
547754 Med Surg Queens NEW YORK 12 Hour Days
547755 OR Albany NEW YORK 12 Hour Days
547757 Outpatient Clinic Cooperstown NEW YORK 8 Hour Days
547771 Med Surg Tele Rome NEW YORK 12 Hour Nights
547789 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Days
547818 Long Term Care Lowville NEW YORK 12 Hour Days
547819 Long Term Care Lowville NEW YORK 12 Hour Days
547832 PICU Syracuse NEW YORK Nights
547875 Urgent Care Saratoga Springs NEW YORK 12 Hour Days
547916 Surgical Tech Glens Falls NEW YORK 10 Hour Evenings
547917 Surgical Tech Glens Falls NEW YORK 10 Hour Evenings
548267 ICU Auburn NEW YORK 12 Hour Nights RN/Registered Nurse
548264 CNA Lowville NEW YORK 8 Hour Nights CNA/Certified Nursing Assistant
507890 OR New York NEW YORK 12 Hour Days RN/Registered Nurse
509435 ER Bronx NEW YORK 12 Hour Days
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
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.6727 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 1100,100 in 1.6444 seconds