Listing all records

Displaying records 501 through 600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
535418 Respiratory Therapist Mason City IOWA 12 Hour Days
535463 ICU Sioux City IOWA 12 Hour Nights
535465 Med Surg Tele Springfield MASSACHUSETTS 8 Hour Nights
535536 CNA Cincinnati OHIO Days
536828 Radiation Therapy Los Angeles CALIFORNIA 8 Hour Days
535556 PT Athens GEORGIA 8 Hour Days
535604 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
535635 Therapy Rehab Stockton CALIFORNIA Days
535638 Rehab Cape Girardeau MISSOURI Nights
535640 PT NORTHRIDGE CALIFORNIA 8 Hour Days
535651 COTA Rock Rapids IOWA Days
535674 Cath Lab Passaic NEW JERSEY 8 Hour Days
535732 Pharmacist New York NEW YORK 8 Hour Nights
535783 PCU Tucson ARIZONA 12 Hour Nights
535889 PTA Essex MARYLAND Days
539199 Med Surg Dyersville IOWA 12 Hour Nights
535906 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
535908 SLP Plano TEXAS Days
535909 PT Blue Hill NEBRASKA Days
538243 PT Lansing MICHIGAN 8 Hour Days
535912 CT Tech Detroit MICHIGAN 12 Hour Nights
535919 Ultrasound Tech Lawton OKLAHOMA 8 Hour Days
538242 PT Lansing MICHIGAN 8 Hour Days
545463 Vascular Ultrasound Tech Hettinger NORTH DAKOTA 8 Hour Days
536150 Lab Tech King Renton WASHINGTON 8 Hour Days
536159 Long Term Care Honakaa HAWAII 8 Hour Day/Night Rotate
536164 Med Surg Glendale ARIZONA 12 Hour Days
536227 CT Tech Melrose Park ILLINOIS 8 Hour Evenings
536228 RAD Tech Maywood ILLINOIS 8 Hour Nights
536231 CT Tech Maywood ILLINOIS 8 Hour Evenings
536253 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Nights
536307 MRI Tech Janesville WISCONSIN 8 Hour Days
536431 ICU Ann Arbor MICHIGAN 12 Hour Nights
536437 Cath Lab York PENNSYLVANIA 12 Hour Days
536440 Infusion Oncology Maywood ILLINOIS 8 Hour Days
536463 ICU Lexington KENTUCKY 12 Hour Nights
536499 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536500 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536501 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536502 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536503 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536504 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536505 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536506 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536507 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536508 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
536509 CVOR Fresno CALIFORNIA 12 Hour Days
536510 CVOR Fresno CALIFORNIA 12 Hour Days
538181 Cath Lab San Diego CALIFORNIA 12 Hour Days
538179 ICU San Diego CALIFORNIA 12 Hour Day/Night Rotate
539378 RAD Tech Louisville KENTUCKY 12 Hour Nights
539320 Oncology York PENNSYLVANIA 12 Hour Day/Night Rotate
536650 Med Surg IOWA CITY IOWA 12 Hour Nights
536704 Dialysis Dover NEW JERSEY 12 Hour Day/Night Rotate
536708 Surgical Tech Hartford CONNECTICUT 12 Hour Days
536728 Interventional Radiology Germantown MARYLAND 8 Hour Days
536731 Surgical Tech Fresno CALIFORNIA 10 Hour Days
536752 CT Tech Roseburg OREGON 12 Hour Nights
536753 PT NORTHRIDGE CALIFORNIA 8 Hour Days
536758 OR Germantown MARYLAND 8 Hour Days
539384 Scrub Tech Newark NEW JERSEY 12 Hour Days
536776 CT Tech San Francisco CALIFORNIA 8 Hour Day/Night Rotate
536801 Med Surg Tele Cleveland OHIO 12 Hour Nights
536850 Cath Lab Cleveland OHIO 8 Hour Days
536873 Telemetry Cleveland OHIO 12 Hour Nights
536932 RAD Tech Maywood ILLINOIS 8 Hour Days
537089 PT Sacramento CALIFORNIA 8 Hour Days
537141 ICU Ogdensburg NEW YORK 12 Hour Nights
537185 CT Tech Syracuse NEW YORK Nights
542041 ICU Ann Arbor MICHIGAN 12 Hour Nights
537193 Med Surg Bloomington INDIANA 12 Hour Nights
537278 PT Sonoma CALIFORNIA 8 Hour Days
537353 OR Chino CALIFORNIA 12 Hour Day/Night Rotate
537419 Med Surg Tele Des Moines IOWA 12 Hour Nights
537420 Med Surg Tele Des Moines IOWA 12 Hour Nights
537423 Neurology Des Moines IOWA 12 Hour Nights
537424 Neurology Des Moines IOWA 12 Hour Nights
537431 Med Surg Des Moines IOWA 12 Hour Nights
537432 Med Surg Des Moines IOWA 12 Hour Nights
540912 Med Surg Dubuque IOWA 12 Hour Nights
539617 Pulmonary Johnson City TENNESSEE 12 Hour Nights
539616 PCU Johnson City TENNESSEE 12 Hour Nights
537453 MRI Tech Falls Church VIRGINIA 12 Hour Days
537460 Phlebotomist Farmington CONNECTICUT 8 Hour Days
537493 Med Surg Tele Waterbury CONNECTICUT 12 Hour Nights
537494 Med Surg Tele Waterbury CONNECTICUT 12 Hour Nights
537514 CT Tech The Dalles OREGON 12 Hour Day/Night Rotate
537715 OR Farmington CONNECTICUT 10 Hour Days
537716 OR Farmington CONNECTICUT 10 Hour Days
537738 PT Vidalia GEORGIA 12 Hour Days
539618 PCU Johnson City TENNESSEE 12 Hour Days
538136 Echo Mason City IOWA 12 Hour Days
537758 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Days
537759 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Evenings
545194 OR Paris ILLINOIS 8 Hour Evenings
537785 SLP Fargo NORTH DAKOTA Days
537792 L&D Ogdensburg NEW YORK 12 Hour Nights
537821 Dosimetrist Duluth MINNESOTA Varied
537901 ER Avalon CALIFORNIA 12 Hour Day/Night Rotate
537902 SNF Avalon CALIFORNIA 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.636 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 500,100 in 1.638 seconds