Listing all records

Displaying records 2701 through 2800 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546593 ER Brooklyn NEW YORK 12 Hour Nights
546596 Med Surg Tele Rome NEW YORK 12 Hour Nights
546597 Med Surg Saratoga Springs NEW YORK 12 Hour Nights
546598 ER Saratoga Springs NEW YORK 12 Hour Nights
546599 ER Saratoga Springs NEW YORK 12 Hour Nights
546619 Acute Care Queens NEW YORK 8 Hour Days
546620 ER Saratoga Springs NEW YORK 12 Hour Nights
546621 ER Saratoga Springs NEW YORK 12 Hour Nights
546622 ER Saratoga Springs NEW YORK 12 Hour Days
546623 ER Saratoga Springs NEW YORK 12 Hour Days
546624 ER Saratoga Springs NEW YORK 12 Hour Days
546625 ER Saratoga Springs NEW YORK 12 Hour Days
548400 ER Albany NEW YORK 12 Hour Nights RN/Registered Nurse
548401 ER Schenectady NEW YORK 12 Hour Days RN/Registered Nurse
546641 Acute Care New York NEW YORK 8 Hour Days
546705 Med Surg Albany NEW YORK 12 Hour Nights
546706 Med Surg Albany NEW YORK 12 Hour Nights
546707 Med Surg Albany NEW YORK 12 Hour Nights
546708 ICU Albany NEW YORK 12 Hour Nights
546709 ER Albany NEW YORK 12 Hour Nights
546710 ER Albany NEW YORK 12 Hour Nights
546760 ER Auburn NEW YORK 12 Hour Nights
546761 ER Auburn NEW YORK 12 Hour Nights
546778 Ambulatory Syracuse NEW YORK 8 Hour Days RN/Registered Nurse
546789 RAD Tech Syracuse NEW YORK 8 Hour Evenings
546807 OT Saranac Lake NEW YORK 8 Hour Days
546833 Med Surg Ogdensburg NEW YORK 12 Hour Nights
546862 OT Syracuse NEW YORK 8 Hour Days
547907 Med Surg New York NEW YORK Nights
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
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.5954 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 2700,100 in 1.7065 seconds