Listing all records

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

ID Job Specialty City State Shift Title
546660 OR Pueblo COLORADO 12 Hour Day/Night Rotate
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
546672 Administration Cheyenne WYOMING Days
546674 Interventional Radiology Des Moines IOWA 8 Hour Days
546679 OR Waterloo IOWA 12 Hour Days
546680 Pharmacist Tuba City ARIZONA 12 Hour Day/Night Rotate
546681 PACU Hot Springs ARKANSAS 8 Hour Days
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
546692 Med Surg Oceanside CALIFORNIA 12 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
546699 Med Surg Spokane WASHINGTON 12 Hour Days
546703 CT Tech Kremmling COLORADO 12 Hour Days
546704 CT Tech Des Moines IOWA 10 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
546737 Med Surg Tele Cleveland OHIO 12 Hour Nights
546738 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546739 Med Surg Tele Charleston WEST VIRGINIA 12 Hour Nights
546740 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
546742 Telemetry Charleston WEST VIRGINIA 12 Hour Nights
546743 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
546744 PCU Charleston WEST VIRGINIA 12 Hour Nights
546750 Med Surg Charlottesville VIRGINIA 12 Hour Nights
546753 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
546757 OR Petoskey MICHIGAN 10 Hour Days
546759 L&D Auburn NEW YORK 12 Hour Nights
546760 ER Auburn NEW YORK 12 Hour Nights
546761 ER Auburn NEW YORK 12 Hour Nights
546762 Interventional Radiology Tech Gainesville FLORIDA 10 Hour Days
546763 Oncology Oklahoma City OKLAHOMA 12 Hour Days
546767 PTA Charlton MASSACHUSETTS Days
546768 Med Surg IOWA CITY IOWA 12 Hour Nights
546770 Surgical Tech IOWA CITY IOWA Days
546778 Ambulatory Syracuse NEW YORK 8 Hour Days RN/Registered Nurse
546781 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
546782 CT Tech Salinas CALIFORNIA 12 Hour Nights CT/Computerized Tomography
546783 PT Salinas CALIFORNIA 8 Hour Days PT/Physical Therapist
546784 Pediatrics Gardner MASSACHUSETTS 12 Hour Nights
546785 Med Surg IOWA CITY IOWA 12 Hour Day/Night Rotate
546787 CT Tech Robinson ILLINOIS 8 Hour Evenings
546788 Long Term Care Westminster COLORADO 12 Hour Nights
546789 RAD Tech Syracuse NEW YORK 8 Hour Evenings
546793 Endoscopy Mt. Vernon WASHINGTON 10 Hour Day/Night Rotate
546794 Med Surg Tele Madison WISCONSIN 12 Hour Day/Night Rotate
546795 MLT Estes Park COLORADO 12 Hour Nights
546798 Interventional Radiology Tech IOWA CITY IOWA Days
546799 Ambulatory Fort Defiance ARIZONA 8 Hour Days
546800 ER Walnut Creek CALIFORNIA 12 Hour Nights
546801 PICU Walnut Creek CALIFORNIA 12 Hour Days
546802 NICU Walnut Creek CALIFORNIA 12 Hour Nights
546805 OR Peoria ILLINOIS Nights
546807 OT Saranac Lake NEW YORK 8 Hour Days
546811 CT Tech Harrison ARKANSAS 10 Hour Evenings
546812 Med Surg Harrison ARKANSAS 12 Hour Nights
546813 Clinic Cleveland OHIO 12 Hour Nights
546819 Med Surg Tele Canton OHIO 12 Hour Nights
546825 Surgical Tech CVOR Parkersburg WEST VIRGINIA 10 Hour Days
546827 CVOR Parkersburg WEST VIRGINIA 12 Hour Days
546830 Clinic Peoria ILLINOIS 8 Hour Days
546832 Therapy Rehab Spring Valley ILLINOIS 12 Hour Day/Night Rotate
546833 Med Surg Ogdensburg NEW YORK 12 Hour Nights
546835 Registered Dietician Waimea HAWAII 12 Hour Day/Night Rotate
546843 Telemetry Farmington CONNECTICUT 12 Hour Days
546844 Telemetry Farmington CONNECTICUT 12 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.7846 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 2600,100 in 1.2849 seconds