Listing all records

Displaying records 2701 through 2800 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
547444 Med Surg Bloomington INDIANA 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
547106 Med Surg Tele Akron OHIO 12 Hour Nights
546781 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
546992 Certified Surgical Tech Concord MASSACHUSETTS 8 Hour Days
547007 CT Tech Maryville ILLINOIS 12 Hour Nights
546805 OR Peoria ILLINOIS Nights
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
547877 APRN Portage WISCONSIN Days
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
546801 PICU Walnut Creek CALIFORNIA 12 Hour Days
546802 NICU Walnut Creek CALIFORNIA 12 Hour 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
546844 Telemetry Farmington CONNECTICUT 12 Hour Days
546845 Med Surg Peoria ILLINOIS 12 Hour Nights
546856 Certified Surgical Tech Berlin MARYLAND 10 Hour Days
546858 CVOR Annapolis MARYLAND 12 Hour Days
546859 Telemetry Everett WASHINGTON 12 Hour Nights
546860 Endoscopy Jefferson City MISSOURI 8 Hour Days
546862 OT Syracuse NEW YORK 8 Hour Days
546866 Surgical Tech Mammoth Lakes CALIFORNIA 12 Hour Day/Night Rotate
546867 PTA Wilton CONNECTICUT Varied
546868 ER MERCED CALIFORNIA 12 Hour Days
546869 Vascular Ultrasound Tech Hilo HAWAII 12 Hour Day/Night Rotate
546870 Vascular Ultrasound Tech Hilo HAWAII 12 Hour Day/Night Rotate
546874 Med Surg Tele Greensboro NORTH CAROLINA 12 Hour Nights
546877 MLT Pittsfield MASSACHUSETTS 8 Hour Days
547122 Med Surg Des Moines IOWA 12 Hour Nights
547120 Neurology Des Moines IOWA 12 Hour Nights
547136 Pediatrics Quincy CALIFORNIA Nights
547126 ER Des Moines IOWA 12 Hour Days
546884 Respiratory Therapist Sitka ALASKA 10 Hour Varied
546886 PT Globe ARIZONA Days
546897 Cath Lab New Bern NORTH CAROLINA 8 Hour Days
546898 Telemetry Cleveland OHIO 12 Hour Nights
546899 Telemetry Spokane WASHINGTON 12 Hour Nights
546902 Telemetry Cleveland OHIO 12 Hour Nights
546903 Med Surg Tele Canton OHIO 12 Hour Nights
546904 Telemetry Cleveland OHIO 12 Hour Nights
547119 RAD Tech REDWOOD CITY CALIFORNIA 8 Hour Days
547117 Cardiovascular York PENNSYLVANIA 12 Hour Day/Night Rotate
546912 ER Goldendale WASHINGTON 12 Hour Days
546913 ER Des Moines IOWA 12 Hour Days
547907 Med Surg New York NEW YORK Nights
546915 Med Surg Hilo HAWAII 12 Hour Nights
546918 Med Surg Tele Charleston WEST VIRGINIA 12 Hour Nights
546919 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
546920 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
546923 CT Tech Ann Arbor MICHIGAN 12 Hour Nights
546924 Cath Lab Detroit MICHIGAN 8 Hour Days
546925 ER East Norriton PENNSYLVANIA 12 Hour Nights
546926 MICU San Dimas CALIFORNIA 12 Hour Nights
546927 ER Kaunakakai HAWAII 12 Hour Day/Night Rotate
546928 Med Surg Tele Mt. Vernon WASHINGTON 12 Hour Nights
546931 SLP Visalia CALIFORNIA 8 Hour Days
546934 RAD Tech Dubuque IOWA 12 Hour Nights
546937 ER Albany NEW YORK 12 Hour Nights
546938 ER Albany NEW YORK 12 Hour Nights
546939 ER Albany NEW YORK 12 Hour Nights
546940 Psych Kealakekua HAWAII 12 Hour Day/Night Rotate
546942 Perfusionist Boston MASSACHUSETTS 10 Hour Days
546943 Med Surg Tele Cleveland OHIO 12 Hour Nights
546946 CT Tech Brattleboro VERMONT 12 Hour Nights
546948 Echo Lufkin TEXAS 8 Hour Day/Night Rotate
546949 RAD Tech Hot Springs ARKANSAS 8 Hour Days
546951 Surgical Tech Long Beach CALIFORNIA 12 Hour Nights
546958 Med Surg Tele Princeton WEST VIRGINIA 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 1.6268 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 2700,100 in 1.8393 seconds