Listing all records

Displaying records 1 through 100 out of a total 3,709 records. Next

ID Job Specialty City State Shift Title
547903 Surgical Tech Grand Forks NORTH DAKOTA Evenings
547834 Dialysis Tech Everett WASHINGTON 10 Hour Varied
545021 OR Clarkston WASHINGTON 10 Hour Varied
543729 OR Pella IOWA 10 Hour Varied
545020 OR Clarkston WASHINGTON 10 Hour Varied
546884 Respiratory Therapist Sitka ALASKA 10 Hour Varied
542578 Outpatient Clinic Chillicothe OHIO 10 Hour Varied
547499 Cath Lab Pueblo COLORADO 10 Hour Varied
544975 CT Tech Glendive MONTANA 8 Hour Varied
542586 OR Watertown NEW YORK 8 Hour Varied
542691 Lab Supervisor Avalon CALIFORNIA 8 Hour Varied
547873 Endoscopy Columbia MISSOURI 8 Hour Varied
535177 Cath Lab Alameda Oakland CALIFORNIA 8 Hour Varied
538911 CT Tech Alturas CALIFORNIA 8 Hour Varied
529162 Physician Assistant Syracuse NEW YORK 8 Hour Varied
544121 CT Tech Avalon CALIFORNIA 8 Hour Varied
545188 Certified Surgical Tech Paris ILLINOIS 8 Hour Varied
526359 Step Down Orangeburg SOUTH CAROLINA 12 Hour Varied
545242 ICU Scottsbluff NEBRASKA 12 Hour Varied
546037 Pediatrics Hilo HAWAII 12 Hour Varied
548042 ER Pendleton OREGON 12 Hour Varied RN/Registered Nurse
548020 MRI Tech Glenwood Springs COLORADO 12 Hour Varied
544535 Psych Fort Defiance ARIZONA 12 Hour Varied
545532 CT Tech Montrose COLORADO 12 Hour Varied
538581 Long Term Care Canton NEW YORK 12 Hour Varied
544388 ICU Scottsbluff NEBRASKA 12 Hour Varied
525662 Nurse Practicioner Syracuse NEW YORK 12 Hour Varied
548125 Med Surg Tele Cooperstown NEW YORK 12 Hour Varied RN/Registered Nurse
548314 Oncology Falls Church VIRGINIA 12 Hour Varied RN/Registered Nurse
539391 OR Bristol TENNESSEE 12 Hour Varied
509595 Anesthesia Tech Everett WASHINGTON 12 Hour Varied
545533 CT Tech Montrose COLORADO 12 Hour Varied
542070 Med Surg Tele Wailuku HAWAII 12 Hour Varied
548313 Oncology Falls Church VIRGINIA 12 Hour Varied RN/Registered Nurse
546276 Pediatrics Sitka ALASKA Varied
544536 PCU Hilo HAWAII Varied
544192 PT Wrangell ALASKA Varied
547305 PT Plains MONTANA Varied
537821 Dosimetrist Duluth MINNESOTA Varied
520029 PT Petaluma CALIFORNIA Varied
470815 PT Los Gatos CALIFORNIA Varied
547332 SLP Garden City KANSAS Varied
547974 CT Tech TOWNSHEND VERMONT Varied
538598 RAD Tech IOWA CITY IOWA Varied
542129 RAD Tech Kapaau HAWAII Varied
543041 Oncology Janesville WISCONSIN Varied
544852 ER San Angelo TEXAS Varied
547682 Echo Technologist Chambersburg PENNSYLVANIA Varied
518254 PT Cleburne TEXAS Varied
538302 Home Health Plains MONTANA Varied
540588 MLT Watertown NEW YORK Varied
542500 MRI Tech Clarkston WASHINGTON Varied
535095 LPN/LVN Quincy CALIFORNIA Varied
533767 PT Bessemer ALABAMA Varied
546415 Oncology York PENNSYLVANIA Varied
523664 PT San Jose CALIFORNIA Varied
546191 PT Crescent City CALIFORNIA Varied
547271 PT GRAND MARAIS MINNESOTA Varied
544016 Social Worker Sitka ALASKA Varied
502855 Paramedic Cleveland OHIO Varied
542427 PT Lakeport CALIFORNIA Varied
548022 OT Rehab Rushville ILLINOIS Varied
547949 PT Philadelphia PENNSYLVANIA Varied
507007 Administration Scobey MONTANA Varied
519986 PTA Big Stone City SOUTH DAKOTA Varied
547775 Clinic Sitka ALASKA Varied
534605 Therapy Rehab Springfield MISSOURI Varied
542130 Echo Technologist San Angelo TEXAS Varied
535128 Management Tacoma WASHINGTON Varied
542039 OR San Angelo TEXAS Varied
513720 PT Bessemer ALABAMA Varied
546867 PTA Wilton CONNECTICUT Varied
544972 PT Garden City KANSAS Varied
545251 Clinic Sitka ALASKA Varied
545552 PT Wilton CONNECTICUT Varied
543897 PT Naples FLORIDA Varied
526505 PT Plains MONTANA Varied
532855 PT St Johnsbury VERMONT Varied
530433 Surgical Tech Oceanside CALIFORNIA Varied
546811 CT Tech Harrison ARKANSAS 10 Hour Evenings
540012 RAD Tech Farmington CONNECTICUT 10 Hour Evenings
547916 Surgical Tech Glens Falls NEW YORK 10 Hour Evenings
547917 Surgical Tech Glens Falls NEW YORK 10 Hour Evenings
540025 OR Concord CALIFORNIA 10 Hour Evenings
541257 OR Concord CALIFORNIA 10 Hour Evenings
544205 Ultrasound Tech Silver Spring MARYLAND 10 Hour Evenings
547486 MRI Tech Pierce Tacoma WASHINGTON 10 Hour Evenings
547959 Surgical Tech Glens Falls NEW YORK 10 Hour Evenings
543990 CT Tech Boise IDAHO 10 Hour Evenings
544493 Ultrasound Tech Prescott ARIZONA 10 Hour Evenings
545783 RAD Tech Gainesville FLORIDA 10 Hour Evenings
547560 Dialysis Per Diem Brooklyn NEW YORK 10 Hour Evenings RN/Registered Nurse
547808 RAD Tech Cleveland OHIO 10 Hour Day/Night Rotate
547704 Scrub Tech DILLON MONTANA 10 Hour Day/Night Rotate
547955 OR Madison WISCONSIN 10 Hour Day/Night Rotate
546793 Endoscopy Mt. Vernon WASHINGTON 10 Hour Day/Night Rotate
544861 Dialysis Johnson City TENNESSEE 10 Hour Day/Night Rotate
544562 OR Oregon City OREGON 10 Hour Day/Night Rotate
547458 Outpatient Clinic Abilene TEXAS 10 Hour Day/Night Rotate
505341 OT Rehab San Jose CALIFORNIA 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.036 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.shift desc limit 0,100 in 1.0271 seconds