Listing all records

Displaying records 401 through 500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
534706 PT King City CALIFORNIA Days
534713 PT Redding CALIFORNIA 8 Hour Days
534798 MRI Tech Langhorne PENNSYLVANIA 8 Hour Evenings
534799 Sonographer Mason City IOWA 12 Hour Days
534888 Home Health Lawton OKLAHOMA 8 Hour Days
534901 Telemetry Boise IDAHO 12 Hour Nights
534902 Telemetry Boise IDAHO 12 Hour Nights
534903 Telemetry Boise IDAHO 12 Hour Nights
534904 Telemetry Boise IDAHO 12 Hour Nights
534923 PT thermopolis WYOMING Days
534924 PT thermopolis WYOMING Days
534941 Med Surg Cape Girardeau MISSOURI Nights
534942 Med Surg Cape Girardeau MISSOURI Nights
534971 Administration Kealakekua HAWAII Days
534972 CT Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
534999 PT Kerrville TEXAS Days
535030 Surgical Tech Louisville KENTUCKY 12 Hour Days
535037 Cath Lab Rockville MARYLAND 10 Hour Days
535045 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
535095 LPN/LVN Quincy CALIFORNIA Varied
535099 Radiology Bronx NEW YORK 12 Hour Days
535128 Management Tacoma WASHINGTON Varied
535143 OT Rehab Devils Lake NORTH DAKOTA 8 Hour Days
535174 PT San Francisco CALIFORNIA 8 Hour Days
535176 Cath Lab Alameda Oakland CALIFORNIA 8 Hour Days
535177 Cath Lab Alameda Oakland CALIFORNIA 8 Hour Varied
535178 Interventional Radiology Tech Columbus OHIO 8 Hour Days
535179 CT Tech Columbus OHIO 12 Hour Days
535216 Mammo Tech Juneau ARKANSAS Days
535227 Orthopedics Des Moines IOWA 12 Hour Nights
535231 Cath Lab Sioux City IOWA 8 Hour Days
535266 Med Surg Ogdensburg NEW YORK 12 Hour Nights
535268 COTA San Andreas CALIFORNIA Days
535269 COTA San Andreas CALIFORNIA Days
535270 PTA Modesto CALIFORNIA Days
535271 PTA Modesto CALIFORNIA Days
535301 MLT Pittsfield MASSACHUSETTS 10 Hour Nights
535302 MLT Pittsfield MASSACHUSETTS 8 Hour Days
535334 SLP Pasco WASHINGTON 12 Hour Day/Night Rotate
535387 Rehab Clive IOWA 12 Hour Nights
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
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
535905 Psych Concord CALIFORNIA 8 Hour Nights
535906 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
535908 SLP Plano TEXAS Days
535909 PT Blue Hill NEBRASKA Days
535911 Telemetry Lubbock TEXAS 12 Hour Days RN/Registered Nurse
535912 CT Tech Detroit MICHIGAN 12 Hour Nights
535919 Ultrasound Tech Lawton OKLAHOMA 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
536346 CVOR Lumberton NORTH CAROLINA 8 Hour Days RN/Registered Nurse
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
536558 ER Syracuse NEW YORK 12 Hour Nights RN/Registered Nurse
536589 OR New York NEW YORK 12 Hour Nights
536590 OR New York NEW YORK 12 Hour Nights
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
536775 RAD Tech San Francisco CALIFORNIA 8 Hour Day/Night Rotate
536776 CT Tech San Francisco CALIFORNIA 8 Hour Day/Night Rotate
536801 Med Surg Tele Cleveland OHIO 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.4935 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 400,100 in 1.0086 seconds