Listing all records

Displaying records 301 through 400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
544359 NICU Queens NEW YORK 12 Hour Nights RN/Registered Nurse
548321 Oncology Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
528069 PCU Flagstaff ARIZONA 12 Hour Nights RN/Registered Nurse
528182 Outpatient Clinic Per Diem San Diego CALIFORNIA 8 Hour Days RN/Registered Nurse
543872 NICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
544804 ER Lumberton NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
548231 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
528573 Pediatrics Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548237 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548236 Psych New York NEW YORK 12 Hour Nights RN/Registered Nurse
548238 Neuro Intensive Care Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548219 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
544397 Med Surg Peoria ILLINOIS 12 Hour Days RN/Registered Nurse
548223 Psych Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
546301 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548275 MICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
546069 PCU Glendale ARIZONA 12 Hour Days RN/Registered Nurse
548279 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
546561 ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548218 Med Surg Tele Travelers Rest SOUTH CAROLINA 12 Hour Days RN/Registered Nurse
548287 Med Surg Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
529616 ICU - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
529699 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
530475 Telemetry Panorama City CALIFORNIA 12 Hour Days RN/Registered Nurse
548276 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
535911 Telemetry Lubbock TEXAS 12 Hour Days RN/Registered Nurse
546879 Med Surg Tele Prescott ARIZONA 12 Hour Days RN/Registered Nurse
548284 CVOR Redding CALIFORNIA 12 Hour Days RN/Registered Nurse
548153 Home Health Pomona CALIFORNIA 8 Hour Days RN/Registered Nurse
530739 Med Surg Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
530071 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
530911 Pediatric ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
547331 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548295 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
530323 ICU - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
546907 Telemetry Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
548301 ER Oneonta NEW YORK 12 Hour Days RN/Registered Nurse
548289 OR Brownwood TEXAS 8 Hour Days RN/Registered Nurse
542664 ICU - Per Diem Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
530439 ICU - Per Diem Woodland Hills CALIFORNIA 12 Hour Nights RN/Registered Nurse
546882 Step Down South Charleston WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
548292 Med Surg Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548303 OR New York NEW YORK 10 Hour Days RN/Registered Nurse
548309 ER Abilene TEXAS 12 Hour Day/Night Rotate RN/Registered Nurse
548304 Psych Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
530740 Med Surg Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
530741 Med Surg Van Nuys CALIFORNIA 12 Hour Nights RN/Registered Nurse
548306 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
547560 Dialysis Per Diem Brooklyn NEW YORK 10 Hour Evenings RN/Registered Nurse
547723 Med Surg Georgetown SOUTH CAROLINA 12 Hour Days RN/Registered Nurse
548311 ER Dallas TEXAS 12 Hour Nights RN/Registered Nurse
530873 Med Surg Tele Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548297 Neuro Med Surg/Tele Redding CALIFORNIA 12 Hour Nights RN/Registered Nurse
548302 CCU Chillicothe OHIO 12 Hour Nights RN/Registered Nurse
548403 Telemetry Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
531152 Med Surg Tele Farmington CONNECTICUT 12 Hour Nights RN/Registered Nurse
548251 ICU Seattle WASHINGTON 12 Hour Days RN/Registered Nurse
531204 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
531244 ICU   CALIFORNIA 12 Hour Days RN/Registered Nurse
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
548254 Home Health Santa Rosa CALIFORNIA 8 Hour Days RN/Registered Nurse
531394 Pediatrics Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548313 Oncology Falls Church VIRGINIA 12 Hour Varied RN/Registered Nurse
548165 ICU San Jose CALIFORNIA 12 Hour Nights RN/Registered Nurse
548163 OR Mason City IOWA 8 Hour Days RN/Registered Nurse
548323 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548166 Med Surg Phoenix ARIZONA 12 Hour Nights RN/Registered Nurse
547796 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548039 OR Petersburg WEST VIRGINIA 8 Hour Days RN/Registered Nurse
548045 OR NORTHRIDGE CALIFORNIA 12 Hour Nights RN/Registered Nurse
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
531848 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548044 Case Manager Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
548055 ER Glens Falls NEW YORK 12 Hour Nights RN/Registered Nurse
548058 Dialysis Brooklyn NEW YORK 10 Hour Days RN/Registered Nurse
548057 PCU Casper WYOMING 12 Hour Days RN/Registered Nurse
548054 CVOR STOCKTON CALIFORNIA 12 Hour Days RN/Registered Nurse
532090 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
532091 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548324 ICU Amsterdam NEW YORK 12 Hour Nights RN/Registered Nurse
548314 Oncology Falls Church VIRGINIA 12 Hour Varied RN/Registered Nurse
548402 ICU New Lenox ILLINOIS 12 Hour Days RN/Registered Nurse
548182 CCU Pittsfield MASSACHUSETTS 12 Hour Days RN/Registered Nurse
548080 CVICU Boston MASSACHUSETTS 12 Hour Day/Night Rotate RN/Registered Nurse
548078 Case Manager Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
548073 PCU Palm Springs CALIFORNIA 12 Hour Days RN/Registered Nurse
548063 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548085 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Nights RN/Registered Nurse
548084 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548082 PCU Torrance CALIFORNIA 12 Hour Days RN/Registered Nurse
548087 PCU Tucson ARIZONA 12 Hour Nights RN/Registered Nurse
548093 ER Albuquerque NEW MEXICO 12 Hour Nights RN/Registered Nurse
548089 NICU Tucson ARIZONA 12 Hour Nights RN/Registered Nurse
548081 ICU Hartford CONNECTICUT 12 Hour Nights RN/Registered Nurse
548062 L&D Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
548095 ER Sterling COLORADO 12 Hour Nights RN/Registered Nurse
548094 ER ODESSA TEXAS 12 Hour Nights RN/Registered Nurse
548061 PACU 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.3815 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 300,100 in 2.3985 seconds