Listing all records

Displaying records 1801 through 1900 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
544598 MLT Des Moines IOWA 8 Hour Days
544604 Surgical Tech Duluth MINNESOTA 12 Hour Day/Night Rotate
544608 SLP Syracuse NEW YORK 8 Hour Days
544615 OR Duluth MINNESOTA 8 Hour Day/Night Rotate
544617 Scrub Tech Rio Rancho NEW MEXICO 10 Hour Days
544626 Echo Toledo OHIO 8 Hour Days
544627 Med Surg Tele Akron OHIO 12 Hour Nights
544628 Psych Cleveland OHIO 12 Hour Nights
544632 ER Machias MAINE 12 Hour Nights
544634 APRN Stanley WISCONSIN Days
544636 Interventional Radiology Tech PHOENIX ARIZONA 12 Hour Days
546061 Intermediate Care Hilo HAWAII 12 Hour Day/Night Rotate
544641 PT Monterey CALIFORNIA Days
544644 OR Silver Spring MARYLAND 12 Hour Days
544645 OR Silver Spring MARYLAND 12 Hour Days
544646 OR Silver Spring MARYLAND 12 Hour Days
544647 OR Silver Spring MARYLAND 12 Hour Days
544648 OR Silver Spring MARYLAND Nights
544649 OR Silver Spring MARYLAND Nights
544652 Med Surg Alamosa COLORADO 12 Hour Nights
544658 Med Surg Fayetteville NORTH CAROLINA 12 Hour Nights
544667 Med Surg Fayetteville NORTH CAROLINA 12 Hour Nights
544670 RAD Tech Los Angeles CALIFORNIA 8 Hour Days
544678 Oncology Midland TEXAS Nights
544680 ER Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
547595 First Assist Canton OHIO 12 Hour Days
544701 OB/GYN Socorro NEW MEXICO 8 Hour Day/Night Rotate
544705 ER Des Moines IOWA 12 Hour Nights
544706 NICU Des Moines IOWA 12 Hour Days
544742 Med Surg Spokane WASHINGTON 12 Hour Days
544743 Med Surg Spokane WASHINGTON 12 Hour Days
544750 Med Surg Tele Everett WASHINGTON 12 Hour Nights
544751 Med Surg Tele Everett WASHINGTON 12 Hour Nights
544753 Interventional Radiology Tech Charleston WEST VIRGINIA 10 Hour Days
544772 Home Health Lake Charles LOUISIANA 8 Hour Days
544775 CT Tech Berlin NEW HAMPSHIRE 12 Hour Day/Night Rotate
544788 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
544789 CNA Kealakekua HAWAII 12 Hour Day/Night Rotate
544792 Orthopedics Detroit MICHIGAN 12 Hour Nights
544793 Cath Lab Bartlett TENNESSEE 8 Hour Days
544796 Clinic Fort Defiance ARIZONA 8 Hour Days
544809 Cath Lab Lewiston MAINE Days
544811 Radiation Therapy Lewiston IDAHO 8 Hour Days
544812 Certified Surgical Tech Lewiston IDAHO 10 Hour Days
544817 OR Albany NEW YORK 12 Hour Day/Night Rotate
544818 OR Maywood ILLINOIS 10 Hour Days
544819 ER Schenectady NEW YORK 12 Hour Nights
544832 MLT East St Louis ILLINOIS 8 Hour Evenings
544835 Sterile Processing Technician Grove City OHIO 8 Hour Evenings
544846 OR Espanola NEW MEXICO 10 Hour Days
544848 Pharmacy Tech Cleveland OHIO 8 Hour Days
544850 RAD Tech Albuquerque NEW MEXICO 8 Hour Day/Night Rotate
544852 ER San Angelo TEXAS Varied
544853 Med Surg Kingsport TENNESSEE 12 Hour Nights
544861 Dialysis Johnson City TENNESSEE 10 Hour Day/Night Rotate
544890 ER Concord CALIFORNIA 12 Hour Days
544870 ICU Oxford NORTH CAROLINA 12 Hour Nights
544871 ICU Oxford NORTH CAROLINA 12 Hour Nights
544876 Med Surg Tele Portland OREGON 12 Hour Nights
544877 Med Surg Tele Portland OREGON 12 Hour Nights
544884 CT Tech Nome ALASKA 12 Hour Day/Night Rotate
544886 OR Aspen COLORADO 10 Hour Days
544894 Respiratory Therapist Newark NEW JERSEY 12 Hour Nights
544889 MLT Mason City IOWA 8 Hour Days
544895 RAD Tech Lynwood CALIFORNIA 12 Hour Days
546335 Psych Wailuku HAWAII 12 Hour Nights
544896 OR Santa Monica CALIFORNIA 12 Hour Nights
545305 Cath Lab Honolulu HAWAII Nights
544904 RAD Tech New York NEW YORK 8 Hour Days
544905 Mammo Tech Port Jefferson NEW YORK 8 Hour Days
544908 ER Oceanside CALIFORNIA 12 Hour Nights
544909 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
544910 RAD Tech Oceanside CALIFORNIA 8 Hour Days
544911 PT Apple Valley CALIFORNIA 10 Hour Days
544912 PT Apple Valley CALIFORNIA 10 Hour Days
544915 PT Mission Hills CALIFORNIA 8 Hour Days
544918 Step Down Parma OHIO 12 Hour Nights
544929 CT Tech Titusville FLORIDA 10 Hour Nights
544937 Med Surg Detroit MICHIGAN 12 Hour Nights
544944 PCU Johnson City TENNESSEE 12 Hour Days
544947 Cath Lab Johnson City TENNESSEE Days
544952 Med Surg Boise IDAHO 12 Hour Nights
544954 Telemetry Twin Falls IDAHO 12 Hour Nights
544955 Telemetry Twin Falls IDAHO 12 Hour Days
544972 PT Garden City KANSAS Varied
544975 CT Tech Glendive MONTANA 8 Hour Varied
544977 Scrub Tech Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
544990 PT Buckeye WEST VIRGINIA 8 Hour Days
544994 Surgical Tech Kearney NEBRASKA 8 Hour Days
544995 PCU Omaha NEBRASKA 12 Hour Nights
544996 CT Tech Omaha NEBRASKA 12 Hour Nights
545003 PCU Palm Springs CALIFORNIA 12 Hour Nights
545021 OR Clarkston WASHINGTON 10 Hour Varied
545026 OR Albany NEW YORK 12 Hour Day/Night Rotate
545030 OR Gardner MASSACHUSETTS 10 Hour Days
545033 Echo Technologist Madison WISCONSIN 8 Hour Day/Night Rotate
545035 PCU Concord NEW HAMPSHIRE 12 Hour Nights
545058 ER Dickinson NORTH DAKOTA 12 Hour Day/Night Rotate
545066 PT Newport OREGON 8 Hour Days
545067 Therapy Rehab Crescent City CALIFORNIA 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.491 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 1800,100 in 1.336 seconds