Listing all records

Displaying records 3601 through 3700 out of a total 3,709 records. Prev Next

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