Listing all records

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

ID Job Specialty City State Shift Title
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
547106 Med Surg Tele Akron OHIO 12 Hour Nights
546578 ER Brooklyn NEW YORK 12 Hour Nights
546590 Med Surg Brooklyn NEW YORK 12 Hour Days
547108 Clinic Cleveland OHIO 12 Hour Nights
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
547111 Ophthalmic Tech Duluth MINNESOTA Days
546620 ER Saratoga Springs NEW YORK 12 Hour Nights
547119 RAD Tech REDWOOD CITY CALIFORNIA 8 Hour Days
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
547117 Cardiovascular York PENNSYLVANIA 12 Hour Day/Night Rotate
546913 ER Des Moines IOWA 12 Hour Days
546912 ER Goldendale WASHINGTON 12 Hour Days
546904 Telemetry Cleveland OHIO 12 Hour Nights
546918 Med Surg Tele Charleston WEST VIRGINIA 12 Hour Nights
546903 Med Surg Tele Canton OHIO 12 Hour 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
547122 Med Surg Des Moines IOWA 12 Hour Nights
546874 Med Surg Tele Greensboro NORTH CAROLINA 12 Hour Nights
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
546733 Telemetry Everett WASHINGTON 12 Hour Nights
546735 Telemetry Santa Monica CALIFORNIA 12 Hour Nights
546736 Outpatient Clinic Portland OREGON 8 Hour Days
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.6753 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 asc limit 2600,100 in 1.4385 seconds