Listing all records

Displaying records 1001 through 1100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548188 Med Surg Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548189 Med Surg Saratoga Springs NEW YORK 12 Hour Nights RN/Registered Nurse
548193 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548199 Med Surg Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548202 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548205 CNA Oneonta NEW YORK 8 Hour Evenings CNA/Certified Nursing Assistant
548206 CNA Oneonta NEW YORK 8 Hour Evenings CNA/Certified Nursing Assistant
548215 ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548216 Med Surg Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548217 Telemetry New York NEW YORK 12 Hour Days RN/Registered Nurse
548219 Psych New York 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
548231 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548236 Psych New York NEW YORK 12 Hour Nights RN/Registered Nurse
548237 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548238 Neuro Intensive Care Brooklyn 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
548283 Nurse Practicioner Syracuse NEW YORK 8 Hour Days NP/Nurse Practitioner
548292 Med Surg Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548300 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548301 ER Oneonta NEW YORK 12 Hour Days RN/Registered Nurse
548303 OR New York NEW YORK 10 Hour Days RN/Registered Nurse
548304 Psych Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548323 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548324 ICU Amsterdam NEW YORK 12 Hour Nights RN/Registered Nurse
548327 ICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548328 LPN/LVN Oneonta NEW YORK 12 Hour Days LPN/Licensed Practical Nurse
548335 Oncology Albany 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
548339 Psych Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548345 Med Surg New York NEW YORK 12 Hour Nights 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
548358 Med Surg Tele Cooperstown NEW YORK 12 Hour Days RN/Registered Nurse
548369 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548407 OR Queens NEW YORK 12 Hour Days RN/Registered Nurse
548409 ER Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
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
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
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 2.1596 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 1000,100 in 1.5062 seconds