Listing all records

Displaying records 3401 through 3500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547871 L&D Cincinnati OHIO Nights
547970 Pediatric ER Bronx NEW YORK Nights
472729 PT Holyoke MASSACHUSETTS Days
474328 PT North Manchester INDIANA Days
475928 PT Lewiston IDAHO Days
476614 PT Crownsville MARYLAND Days
491571 Therapy Rehab E Lamberton MINNESOTA Days
492900 PT Lancaster MASSACHUSETTS Days
495103 SLP South Bend INDIANA Days
496231 COTA Oakhurst CALIFORNIA Days
504432 PT Honolulu HAWAII Days
505339 PTA San Jose CALIFORNIA Days
505340 PT San Jose CALIFORNIA Days
505341 OT Rehab San Jose CALIFORNIA Days
505342 OT Rehab San Jose CALIFORNIA Days
516937 SLP Roseburg OREGON Days
517267 PT Kapaau HAWAII Days
517269 PT Kapaau HAWAII Days
517691 SLP Vernon CONNECTICUT Days
518165 Endoscopy IOWA CITY IOWA Days
518534 COTA NEWMAN CALIFORNIA Days
523666 PTA Freemont CALIFORNIA Days
523668 PT Oakland CALIFORNIA Days
523669 PT San Rafael CALIFORNIA Days
524151 PTA Ramsey NEW JERSEY Days
524261 PT San Ramon CALIFORNIA Days
524265 PTA San Ramon CALIFORNIA Days
526144 Therapy Rehab Baltimore MARYLAND Days
526368 COTA Colfax WISCONSIN Days
526396 Therapy Rehab Cedar Falls IOWA Days
526586 PT Lewiston IDAHO Days
531763 PT Inman SOUTH CAROLINA Days
532052 PT Carrizo Springs TEXAS Days
532598 PTA Hanford CALIFORNIA Days
532920 Oncology San Angelo TEXAS Days
533274 PT Lawton OKLAHOMA Days
533275 PT Lawton OKLAHOMA Days
533521 PTA Belton TEXAS Days
534093 SLP Freehold NEW JERSEY Days
534504 PT Raritan NEW JERSEY Days
534628 SLP Pomona CALIFORNIA Days
534629 SLP Pomona CALIFORNIA Days
534700 Therapy Rehab Lewiston IDAHO Days
534706 PT King City CALIFORNIA Days
534923 PT thermopolis WYOMING Days
534924 PT thermopolis WYOMING Days
534971 Administration Kealakekua HAWAII Days
534999 PT Kerrville TEXAS Days
535216 Mammo Tech Juneau ARKANSAS Days
535268 COTA San Andreas CALIFORNIA Days
535269 COTA San Andreas CALIFORNIA Days
535270 PTA Modesto CALIFORNIA Days
535271 PTA Modesto CALIFORNIA Days
535536 CNA Cincinnati OHIO Days
535635 Therapy Rehab Stockton CALIFORNIA Days
543293 PT Hudson FLORIDA Days
543455 OR Cape Girardeau MISSOURI Days
543900 CT Tech Culbertson MONTANA Days
543901 Med Surg Tele The Dalles OREGON Days
543911 COTA Hanford CALIFORNIA Days
543977 Sterile Processing Tech Lamar COLORADO Days
544168 COTA Madera CALIFORNIA Days
544290 Infusion Oncology Sidney MONTANA Days
544403 First Assist Lancaster OHIO Days
544441 Therapy Rehab Baltimore MARYLAND Days
544485 SLP Danvers MASSACHUSETTS Days
544489 CT Tech Culbertson MONTANA Days
544634 APRN Stanley WISCONSIN Days
544641 PT Monterey CALIFORNIA Days
544809 Cath Lab Lewiston MAINE Days
544947 Cath Lab Johnson City TENNESSEE Days
545082 Vascular Ultrasound Tech Artesia NEW MEXICO Days
545111 PT Salem OREGON Days
545112 PT Salem OREGON Days
545217 CT Tech York MAINE Days
545314 Interventional Radiology SANTA ROSA CALIFORNIA Days
545331 PT Sumter SOUTH CAROLINA Days
545339 APRN Plymouth WISCONSIN Days
545371 Step Down Cincinnati OHIO Days
545440 OT Rehab thermopolis WYOMING Days
547519 Hospice Amarillo TEXAS Days
547539 Case Manager Vail COLORADO Days
547564 Echo Technologist Cape Girardeau MISSOURI Days
547580 Therapy Rehab Helena MONTANA Days
547697 PT Norristown PENNSYLVANIA Days
547708 Surgical Tech CVOR Zanesville OHIO Days
547745 SLP Philadelphia PENNSYLVANIA Days
547777 Histology Technician State College PENNSYLVANIA Days
547806 PT Mammoth Lakes CALIFORNIA Days
547816 Angiography Grand Forks NORTH DAKOTA Days
547867 PT Winter Park FLORIDA Days
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
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.5127 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 3400,100 in 1.5891 seconds