Listing all records

Displaying records 101 through 200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548266 ICU BAKERSFIELD CALIFORNIA 12 Hour Nights RN/Registered Nurse
544359 NICU Queens NEW YORK 12 Hour Nights RN/Registered Nurse
548239 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548058 Dialysis Brooklyn NEW YORK 10 Hour Days RN/Registered Nurse
548056 NICU Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
548069 Psych Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548163 OR Mason City IOWA 8 Hour Days RN/Registered Nurse
548060 ICU Casper WYOMING 12 Hour Days RN/Registered Nurse
548039 OR Petersburg WEST VIRGINIA 8 Hour Days RN/Registered Nurse
530475 Telemetry Panorama City CALIFORNIA 12 Hour Days RN/Registered Nurse
529616 ICU - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548153 Home Health Pomona CALIFORNIA 8 Hour Days RN/Registered Nurse
530071 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
530741 Med Surg Van Nuys CALIFORNIA 12 Hour Nights RN/Registered Nurse
530739 Med Surg Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
528573 Pediatrics Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
531766 PICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
531355 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
546881 ER MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
538592 Telemetry Panorama City CALIFORNIA 12 Hour Days RN/Registered Nurse
536346 CVOR Lumberton NORTH CAROLINA 8 Hour Days RN/Registered Nurse
546907 Telemetry Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
531244 ICU   CALIFORNIA 12 Hour Days RN/Registered Nurse
548253 Neuro Intensive Care Boston MASSACHUSETTS 12 Hour Days RN/Registered Nurse
538137 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
547796 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548254 Home Health Santa Rosa CALIFORNIA 8 Hour Days RN/Registered Nurse
548162 OR Centerville IOWA 8 Hour Days RN/Registered Nurse
547560 Dialysis Per Diem Brooklyn NEW YORK 10 Hour Evenings RN/Registered Nurse
531765 L&D Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548044 Case Manager Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
516546 ER Burbank CALIFORNIA 8 Hour Days RN/Registered Nurse
516920 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548042 ER Pendleton OREGON 12 Hour Varied RN/Registered Nurse
543243 CVOR Falls Church VIRGINIA 12 Hour Days RN/Registered Nurse
548043 OR Bakersfield CALIFORNIA 8 Hour Days RN/Registered Nurse
517353 ER - Per Diem San pedro CALIFORNIA 12 Hour Nights RN/Registered Nurse
517382 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Days RN/Registered Nurse
548046 OR BAKERSFIELD CALIFORNIA 8 Hour Days RN/Registered Nurse
543872 NICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548322 PICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548165 ICU San Jose CALIFORNIA 12 Hour Nights RN/Registered Nurse
544061 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548321 Oncology Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
544397 Med Surg Peoria ILLINOIS 12 Hour Days RN/Registered Nurse
518547 NICU Per Diem/Local Contract Torrance CALIFORNIA 12 Hour Nights RN/Registered Nurse
548054 CVOR STOCKTON CALIFORNIA 12 Hour Days RN/Registered Nurse
544804 ER Lumberton NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
548063 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548052 Med Surg Pontiac MICHIGAN 12 Hour Nights RN/Registered Nurse
548061 PACU Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
546875 Telemetry PHOENIX ARIZONA 12 Hour Nights RN/Registered Nurse
548062 L&D Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
548065 Step Down SANTA CRUZ CALIFORNIA 12 Hour Nights RN/Registered Nurse
543862 PICU Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548040 PCU Lowell MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
541846 PCU Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
541847 Psych Peoria ILLINOIS 8 Hour Days RN/Registered Nurse
542664 ICU - Per Diem Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
530873 Med Surg Tele Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
530323 ICU - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548259 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548261 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548262 ICU Arcata CALIFORNIA 12 Hour Days RN/Registered Nurse
546879 Med Surg Tele Prescott ARIZONA 12 Hour Days RN/Registered Nurse
532090 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
531848 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
531394 Pediatrics Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
531204 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
524582 ICU - Per Diem Oceanside CALIFORNIA 12 Hour Days RN/Registered Nurse
532091 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
531152 Med Surg Tele Farmington CONNECTICUT 12 Hour Nights RN/Registered Nurse
538306 Step Down Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548252 ICU - Per Diem Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
548251 ICU Seattle WASHINGTON 12 Hour Days RN/Registered Nurse
521322 ICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521323 Step Down Oklahoma City OKLAHOMA 12 Hour Days RN/Registered Nurse
521324 CVICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521325 Oncology Oklahoma City OKLAHOMA 12 Hour Days RN/Registered Nurse
521326 PICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521327 Step Down Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521337 Med Surg Oklahoma City OKLAHOMA 12 Hour Days RN/Registered Nurse
521340 Med Surg Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521341 Oncology Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
547469 Med Surg Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
547570 Med Surg Per Diem/Local Contract Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
539941 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548168 Certified Surgical Tech Coos Bay OREGON 10 Hour Days RN/Registered Nurse
546880 Med Surg Show Low ARIZONA 12 Hour Nights RN/Registered Nurse
539477 Telemetry - Per Diem Mission Viejo CALIFORNIA 12 Hour Days RN/Registered Nurse
536558 ER Syracuse NEW YORK 12 Hour Nights RN/Registered Nurse
523478 ICU Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548041 PCU Middletown NEW YORK 12 Hour Nights RN/Registered Nurse
548166 Med Surg Phoenix ARIZONA 12 Hour Nights RN/Registered Nurse
548045 OR NORTHRIDGE CALIFORNIA 12 Hour Nights RN/Registered Nurse
548164 LTAC Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
523775 ICU Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
524038 ICU - Per Diem Burbank CALIFORNIA 12 Hour Days RN/Registered Nurse
524120 PICU Anchorage ALASKA 12 Hour Nights RN/Registered Nurse
540529 Telemetry Los Angeles CALIFORNIA 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.5729 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 a.title desc limit 100,100 in 1.4406 seconds