Listing all records

Displaying records 2601 through 2700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546453 Step Down Elkin NORTH CAROLINA 12 Hour Days
546455 Med Surg Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
546459 Orthopedics Madison WISCONSIN 12 Hour Day/Night Rotate
546462 ER Des Moines IOWA 12 Hour Days
546464 Med Surg Bristol TENNESSEE 12 Hour Nights
546466 Med Surg Greeneville TENNESSEE 12 Hour Nights
546469 OR Louisville KENTUCKY 8 Hour Days
546470 ICU East Norriton PENNSYLVANIA 12 Hour Days
546471 Respiratory Therapist East Norriton PENNSYLVANIA 12 Hour Nights
546472 Respiratory Therapist East Norriton PENNSYLVANIA 12 Hour Days
546473 Cath Lab Woonsocket RHODE ISLAND 10 Hour Days
546476 Med Surg Gainesville FLORIDA 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
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
546578 ER Brooklyn NEW YORK 12 Hour Nights
546590 Med Surg 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
546602 CT Tech Minneapolis MINNESOTA 12 Hour Days
546604 RAD Tech Lewiston MAINE 10 Hour Days
546608 Med Surg Spokane WASHINGTON 12 Hour Days
546609 EP Tech Pinehurst NORTH CAROLINA 10 Hour Days
546620 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
546627 CVICU Madison WISCONSIN 8 Hour Day/Night Rotate
546629 PCU Bristol TENNESSEE 12 Hour Days
546630 Med Surg Tele Laconia NEW HAMPSHIRE Nights
546672 Administration Cheyenne WYOMING Days
546635 ER Des Moines IOWA 12 Hour Nights
546637 Sterile Processing Tech Muskegon MICHIGAN Nights
546640 NICU Los Angeles CALIFORNIA 12 Hour Days
546641 Acute Care New York NEW YORK 8 Hour Days
546644 PT San Ramon CALIFORNIA Days
546645 PT San Ramon CALIFORNIA Days
546646 PT San Ramon CALIFORNIA Days
546651 Surgical Tech Louisville KENTUCKY 8 Hour Days
546660 OR Pueblo COLORADO 12 Hour Day/Night Rotate
546843 Telemetry Farmington CONNECTICUT 12 Hour Days
546667 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
546668 Ultrasound Tech Farmington CONNECTICUT 8 Hour Days
546670 Outpatient Clinic Claremont NEW HAMPSHIRE 8 Hour Days
546679 OR Waterloo IOWA 12 Hour Days
546680 Pharmacist Tuba City ARIZONA 12 Hour Day/Night Rotate
546682 RAD Tech Lexington KENTUCKY 10 Hour Days
546683 PCU Birmingham ALABAMA 12 Hour Nights
546684 L&D Detroit MICHIGAN 12 Hour Days
546686 PCU San Luis Obispo CALIFORNIA 12 Hour Nights
546687 PCU San Luis Obispo CALIFORNIA 12 Hour Days
546688 L&D San Antonio TEXAS 12 Hour Nights
546689 OR Templeton CALIFORNIA 10 Hour Days
546690 Surgical Tech Templeton CALIFORNIA 10 Hour Days
546693 Telemetry Oceanside CALIFORNIA 12 Hour Evenings
546694 Interventional Radiology Tech Oceanside CALIFORNIA 10 Hour Days
546695 ER Oceanside CALIFORNIA 12 Hour Nights
546697 Surgical Tech Reno NEVADA 12 Hour Days
546698 ICU East Norriton PENNSYLVANIA 12 Hour Nights
547088 Pediatrics Pittsfield MASSACHUSETTS 12 Hour Nights
546699 Med Surg Spokane WASHINGTON 12 Hour Days
546703 CT Tech Kremmling COLORADO 12 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
546711 OR Muskegon MICHIGAN 10 Hour Days
546712 Respiratory Therapist Springfield MASSACHUSETTS 8 Hour Nights
546713 L&D Springfield MASSACHUSETTS 8 Hour Nights
546714 L&D Springfield MASSACHUSETTS 8 Hour Nights
546717 Med Surg Tele Olympia WASHINGTON 12 Hour Nights
546718 PCU Centralia WASHINGTON 12 Hour Nights
546720 Med Surg Tele Olympia WASHINGTON 12 Hour Nights
546722 Med Surg Olympia WASHINGTON 12 Hour Nights
546724 Oncology Everett WASHINGTON 12 Hour Nights
546725 Telemetry Everett WASHINGTON 12 Hour Nights
546727 Telemetry Everett WASHINGTON 12 Hour Nights
546728 Intermediate Care Everett WASHINGTON 12 Hour Nights
546729 Telemetry Everett WASHINGTON 12 Hour Nights
546730 Telemetry Everett WASHINGTON 12 Hour Nights
546731 Telemetry Everett WASHINGTON 12 Hour Nights
546732 Telemetry Everett WASHINGTON 12 Hour 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.1237 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 2600,100 in 1.5351 seconds