Listing all records

Displaying records 3601 through 3700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548297 Neuro Med Surg/Tele Redding CALIFORNIA 12 Hour Nights RN/Registered Nurse
548298 Neuro Intensive Care PHOENIX ARIZONA 12 Hour Nights RN/Registered Nurse
548299 OR Arlington VIRGINIA 10 Hour Days 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
548302 CCU Chillicothe OHIO 12 Hour Nights 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
548306 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548307 OR Greenbrae CALIFORNIA 12 Hour Days RN/Registered Nurse
548308 ER Deridder LOUISIANA 12 Hour Nights RN/Registered Nurse
548309 ER Abilene TEXAS 12 Hour Day/Night Rotate RN/Registered Nurse
548310 ER Memphis TENNESSEE 12 Hour Nights RN/Registered Nurse
548311 ER Dallas TEXAS 12 Hour Nights RN/Registered Nurse
548312 Oncology Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548313 Oncology Falls Church VIRGINIA 12 Hour Varied RN/Registered Nurse
548314 Oncology Falls Church VIRGINIA 12 Hour Varied RN/Registered Nurse
548315 Surgical Tech Detroit MICHIGAN 8 Hour Days Tech/Technologist
548316 OR Jefferson City MISSOURI 10 Hour Days RN/Registered Nurse
548317 ST Muskegon MICHIGAN 12 Hour Days Tech/Technologist
548318 Surgical Tech Bad Axe MICHIGAN 8 Hour Days Tech/Technologist
548319 ICU Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548321 Oncology Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
548322 PICU Bronx NEW YORK 12 Hour Nights 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
548325 SLP Shreveport LOUISIANA 8 Hour Days SLP/Speech Language Pathologist
548326 Pharmacy Tech Panorama City CALIFORNIA 8 Hour Days Tech/Technologist
548327 ICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548328 LPN/LVN Oneonta NEW YORK 12 Hour Days LPN/Licensed Practical Nurse
548329 Oncology Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548330 Oncology Newark NEW JERSEY 8 Hour Days RN/Registered Nurse
548331 ICU Anaheim CALIFORNIA 12 Hour Nights RN/Registered Nurse
548332 Clinic Chandler ARIZONA 8 Hour Days LPN/Licensed Practical Nurse
548333 ICU Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548334 CVICU Petoskey MICHIGAN 12 Hour Nights RN/Registered Nurse
548335 Oncology Albany NEW YORK 12 Hour Nights RN/Registered Nurse
548336 MICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548337 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Nights 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
548340 ER Fresno CALIFORNIA 12 Hour Days RN/Registered Nurse
548341 ER BAKERSFIELD CALIFORNIA 12 Hour Nights RN/Registered Nurse
548342 Telemetry Spokane WASHINGTON 12 Hour Days RN/Registered Nurse
548343 RNFA Peterborough NEW HAMPSHIRE 8 Hour Days RNFA/Registered Nurse First Assist
548344 CVOR Fresno CALIFORNIA 12 Hour Days RN/Registered Nurse
548345 Med Surg New York NEW YORK 12 Hour Nights RN/Registered Nurse
548346 Postpartum Fresno CALIFORNIA 12 Hour Days RN/Registered Nurse
548347 Respiratory Therapist Lynwood CALIFORNIA 12 Hour Nights Respiratory Therapist
548348 Telemetry Spokane WASHINGTON 12 Hour Days RN/Registered Nurse
548349 ER Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548350 CVOR Falls Church VIRGINIA 12 Hour Day/Night Rotate RN/Registered Nurse
548351 NICU Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
548352 Surgical Tech Falls Church VIRGINIA 12 Hour Day/Night Rotate CST/Certified Surgical Technician
548353 Behavioral Health Modesto CALIFORNIA 12 Hour Days RN/Registered Nurse
548354 Psych National City CALIFORNIA 12 Hour Nights RN/Registered Nurse
548355 Neuro Intensive Care Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548356 ER - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548357 Perfusionist Falls Church VIRGINIA 12 Hour Days Perfusionist
548358 Med Surg Tele Cooperstown NEW YORK 12 Hour Days RN/Registered Nurse
548359 ER Oceanside CALIFORNIA 12 Hour Nights RN/Registered Nurse
548360 CVICU Phoenix ARIZONA 12 Hour Nights RN/Registered Nurse
548361 Telemetry BAKERSFIELD CALIFORNIA 12 Hour Nights RN/Registered Nurse
548362 Telemetry Antioch CALIFORNIA 12 Hour Nights RN/Registered Nurse
548363 OR Cleveland OHIO 10 Hour Days RN/Registered Nurse
548364 Med Surg BAKERSFIELD CALIFORNIA 12 Hour Days RN/Registered Nurse
548365 Med Surg BAKERSFIELD CALIFORNIA 12 Hour Days RN/Registered Nurse
548366 ICU Anaheim CALIFORNIA 12 Hour Days RN/Registered Nurse
548367 ER FOLSOM CALIFORNIA 12 Hour Nights RN/Registered Nurse
548368 ICU Anaheim CALIFORNIA 12 Hour Nights RN/Registered Nurse
548369 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548370 ER Chandler ARIZONA 12 Hour Nights RN/Registered Nurse
548371 Med Surg Coos Bay OREGON 12 Hour Nights RN/Registered Nurse
548372 Med Surg Tele Parma OHIO 12 Hour Nights RN/Registered Nurse
548373 Med Surg Tele Westlake OHIO 12 Hour Nights RN/Registered Nurse
548374 Med Surg Tele Concord OHIO 12 Hour Nights RN/Registered Nurse
548375 ICU Chicago ILLINOIS 12 Hour Nights RN/Registered Nurse
548376 Med Surg Tele Cleveland OHIO 12 Hour Nights RN/Registered Nurse
548377 Telemetry Santa Clara CALIFORNIA 12 Hour Days RN/Registered Nurse
548379 Postpartum Fresno CALIFORNIA 12 Hour Nights RN/Registered Nurse
548380 Med Surg Tele Cleveland OHIO 12 Hour Nights RN/Registered Nurse
548381 Med Surg Tele Prescott ARIZONA 12 Hour Nights RN/Registered Nurse
548382 ER North Adams MASSACHUSETTS 12 Hour Days RN/Registered Nurse
548383 Telemetry BAKERSFIELD CALIFORNIA 12 Hour Days RN/Registered Nurse
548384 Telemetry Concord CALIFORNIA 12 Hour Days RN/Registered Nurse
548385 Telemetry Antioch CALIFORNIA 12 Hour Days RN/Registered Nurse
548386 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548387 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
548389 Cardiac Cath Lab Clackamas OREGON 12 Hour Days Advanced Practice
548390 Cardiac Cath Lab Clackamas OREGON 10 Hour Days Advanced Practice
548391 ICU Merced CALIFORNIA 12 Hour Nights RN/Registered Nurse
548393 ICU SAN ANDREAS CALIFORNIA 12 Hour Nights RN/Registered Nurse
548394 OR Abingdon VIRGINIA 8 Hour Day/Night Rotate RN/Registered Nurse
548395 Telemetry Cleveland OHIO 12 Hour Nights RN/Registered Nurse
548396 CVICU SANTA CRUZ CALIFORNIA 12 Hour Nights RN/Registered Nurse
548397 ICU SAN ANDREAS CALIFORNIA 12 Hour Nights RN/Registered Nurse
548398 ICU Columbus OHIO 12 Hour Days RN/Registered Nurse
548399 PCU Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548400 ER Albany NEW YORK 12 Hour Nights RN/Registered Nurse
548401 ER Schenectady 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.6422 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.id asc limit 3600,100 in 1.2264 seconds