Listing all records

Displaying records 701 through 800 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
534059 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534060 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534061 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534062 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534063 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534093 SLP Freehold NEW JERSEY Days
534108 Echo Oceanside CALIFORNIA 10 Hour Days
534109 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
534167 Surgical Tech Centerville IOWA 8 Hour Days
534169 Med Surg Oneonta NEW YORK 12 Hour Nights
534238 Med Surg Tele Concord CALIFORNIA 8 Hour Days
534242 Med Surg Tele Des Moines IOWA 12 Hour Nights
534249 Oncology Cleveland OHIO 12 Hour Days
534250 Oncology Cleveland OHIO 12 Hour Nights
534255 Electrophysiology York PENNSYLVANIA 12 Hour Days
534331 Neuro Med Surg/Tele PHOENIX ARIZONA 12 Hour Nights
534500 PTA Jacksonville ILLINOIS 12 Hour Day/Night Rotate
534504 PT Raritan NEW JERSEY Days
535905 Psych Concord CALIFORNIA 8 Hour Nights
534528 Social Worker Johnston PENNSYLVANIA 8 Hour Days
534546 RAD Tech Columbus OHIO 8 Hour Day/Night Rotate
534553 Surgical Tech Louisville KENTUCKY 8 Hour Days
538355 Cardiovascular Technologist Chino CALIFORNIA 8 Hour Days
534605 Therapy Rehab Springfield MISSOURI Varied
534628 SLP Pomona CALIFORNIA Days
534629 SLP Pomona CALIFORNIA Days
534655 CT Tech Syracuse NEW YORK 8 Hour Days
534687 Med Surg Tele Concord CALIFORNIA 8 Hour Nights
534694 Psych Woodsville NEW HAMPSHIRE 12 Hour Day/Night Rotate
534700 Therapy Rehab Lewiston IDAHO Days
534706 PT King City CALIFORNIA Days
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
537444 CNA Brooklyn NEW YORK 8 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
535030 Surgical Tech Louisville KENTUCKY 12 Hour Days
534971 Administration Kealakekua HAWAII Days
534972 CT Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
534999 PT Kerrville TEXAS Days
535045 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
535095 LPN/LVN Quincy CALIFORNIA Varied
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
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
540002 MRI Tech Farmington CONNECTICUT 12 Hour Nights
540003 Telemetry Farmington CONNECTICUT 12 Hour Days
540004 PACU Walnut Creek CALIFORNIA 12 Hour Days
540005 OR Farmington CONNECTICUT 10 Hour Days
540006 PCU Walnut Creek CALIFORNIA 12 Hour Nights
540007 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540008 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540009 MLT Farmington CONNECTICUT 8 Hour Evenings
540011 Telemetry Farmington CONNECTICUT 12 Hour Nights
540012 RAD Tech Farmington CONNECTICUT 10 Hour Evenings
540013 Monitor Tech Farmington CONNECTICUT 8 Hour Evenings
540014 Surgical Tech Farmington CONNECTICUT 10 Hour Days
540015 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
540016 Monitor Tech Farmington CONNECTICUT 8 Hour Days
540017 RAD Tech Farmington CONNECTICUT 10 Hour Days
540018 Surgical Tech Farmington CONNECTICUT 8 Hour Days
540019 OR Farmington CONNECTICUT 12 Hour Days
540020 Phlebotomist Farmington CONNECTICUT 8 Hour Days
540021 L&D Walnut Creek CALIFORNIA 12 Hour Days
540022 Interventional Radiology Farmington CONNECTICUT 10 Hour Days
540023 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540024 Phlebotomist Farmington CONNECTICUT 8 Hour Days
540025 OR Concord CALIFORNIA 10 Hour Evenings
540027 OR Concord 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.7078 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 700,100 in 1.4427 seconds