Listing all records

Displaying records 101 through 200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
527222 PT Freemont CALIFORNIA Days
517474 Ortho Tech Oceanside CALIFORNIA 8 Hour Days
517691 SLP Vernon CONNECTICUT Days
517854 CT Tech Akron OHIO 10 Hour Days
517887 CRNA Alturas CALIFORNIA 12 Hour Day/Night Rotate
517902 Med Surg Tele Wailuku HAWAII 8 Hour Nights
517904 Med Surg Tele Maui Wailuku HAWAII 12 Hour Nights
517913 Med Surg Tele Maui Wailuku HAWAII 12 Hour Nights
528766 PT Sparks NEVADA Days
518165 Endoscopy IOWA CITY IOWA Days
518254 PT Cleburne TEXAS Varied
518534 COTA NEWMAN CALIFORNIA Days
527625 Sterile Processing Technician Oceanside CALIFORNIA 10 Hour Nights
541964 Cath Lab Whittier CALIFORNIA 8 Hour Days
541958 CVICU Spokane WASHINGTON 12 Hour Nights
541949 Med Surg Boise IDAHO 12 Hour Nights
541929 Management Corvallis OREGON 12 Hour Day/Night Rotate
529033 PT San Ramon CALIFORNIA Days
527624 Scrub Tech Oceanside CALIFORNIA 10 Hour Days
542655 Long Term Care Hilo HAWAII 12 Hour Day/Night Rotate
545014 Medical Assistant Claremont NEW HAMPSHIRE 12 Hour Days
541891 Telemetry Farmington CONNECTICUT 12 Hour Nights
541886 Rehab Chesterfield MONTANA 12 Hour Days
541860 PT Lovington NEW MEXICO 8 Hour Days
527593 PT Pinehurst NORTH CAROLINA 8 Hour Days
527559 RAD Tech San Diego CALIFORNIA 12 Hour Nights
541845 NICU Walnut Creek CALIFORNIA 12 Hour Nights
542785 Case Manager Glens Falls NEW YORK 8 Hour Days
542786 Step Down Kingsport TENNESSEE 12 Hour Nights
541840 PT SANTA MARIA CALIFORNIA 8 Hour Days
543820 Oncology Bristol TENNESSEE 12 Hour Nights
519045 Med Surg Kula HAWAII 8 Hour Nights
519146 Med Surg Kula HAWAII 8 Hour Days
519153 CVICU Little Rock ARKANSAS 12 Hour Nights
519354 Therapy Rehab Baltimore MARYLAND Days
541809 Med Surg Oneonta NEW YORK 12 Hour Nights
541810 Med Surg Oneonta NEW YORK 12 Hour Nights
527927 PT Mandan NORTH DAKOTA 8 Hour Day/Night Rotate
541798 L&D Newton IOWA 12 Hour Nights
519983 PT Big Stone City SOUTH DAKOTA 8 Hour Days
524932 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
525066 PT Mason City IOWA 8 Hour Days
541792 ER Newark NEW JERSEY 12 Hour Day/Night Rotate
519986 PTA Big Stone City SOUTH DAKOTA Varied
519987 Therapy Rehab Big Stone City SOUTH DAKOTA 8 Hour Days
520029 PT Petaluma CALIFORNIA Varied
528005 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
524992 Med Surg Boise IDAHO Nights
525235 CT Tech Oceanside CALIFORNIA 10 Hour Days
525081 MRI Tech Grove City OHIO 12 Hour Days
525078 LPN/LVN Mason City IOWA 12 Hour Nights
524989 Telemetry Maywood ILLINOIS 12 Hour Nights
524930 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
541786 ICU The Dalles OREGON 12 Hour Day/Night Rotate
541782 ICU Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
541779 Telemetry Farmington CONNECTICUT 12 Hour Days
520208 PT NEWMAN CALIFORNIA Days
520291 CT Tech Oceanside CALIFORNIA 10 Hour Days
541769 Oncology Pueblo COLORADO 12 Hour Days
525386 Vascular Ultrasound Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
541765 CVOR Oceanside CALIFORNIA 8 Hour Nights
525646 Med Surg Boise IDAHO 12 Hour Nights
521068 Echo Columbia SOUTH CAROLINA 8 Hour Days
547467 NICU Walnut Creek CALIFORNIA 12 Hour Days
543590 L&D Devils Lake NORTH DAKOTA 12 Hour Day/Night Rotate
521294 Ultrasound Tech Bethel ALASKA Days
521297 ER Bethel ALASKA 12 Hour Day/Night Rotate
528446 PTA Killeen TEXAS Days
528477 Respiratory Therapist Mason City IOWA 12 Hour Days
526268 Interventional Radiology Tech Fresno CALIFORNIA 12 Hour Days
528482 SLP Fresno CALIFORNIA Days
526356 Telemetry Boise IDAHO 12 Hour Nights
526144 Therapy Rehab Baltimore MARYLAND Days
525673 Cardiology Louisville KENTUCKY 8 Hour Days
526396 Therapy Rehab Cedar Falls IOWA Days
526368 COTA Colfax WISCONSIN Days
521665 Surgical Tech Louisville KENTUCKY 12 Hour Day/Night Rotate
521981 Step Down Oklahoma City OKLAHOMA 12 Hour Days
521994 Step Down Oklahoma City OKLAHOMA 12 Hour Days
522368 Clinic Bethel ALASKA Days
522372 PT Weaverville CALIFORNIA Days
522373 LPN/LVN Bethel ALASKA Days
522473 CNA Lowville NEW YORK 8 Hour Evenings
522479 CNA Lowville NEW YORK 8 Hour Evenings
522691 PT San Jose CALIFORNIA 12 Hour Day/Night Rotate
524703 CT Tech Pontiac MICHIGAN 8 Hour Nights
523400 Med Surg Kula HAWAII 8 Hour Nights
523403 Med Surg Kula HAWAII 8 Hour Nights
528028 Med Surg Mason City IOWA 12 Hour Nights
523531 PTA Oakland NEW JERSEY Days
523664 PT San Jose CALIFORNIA Varied
523666 PTA Freemont CALIFORNIA Days
523668 PT Oakland CALIFORNIA Days
523669 PT San Rafael CALIFORNIA Days
527125 Therapy Rehab Shelby MISSISSIPPI Days
527092 PT Boardman OHIO Days
527226 ER Everett WASHINGTON 12 Hour Nights
524151 PTA Ramsey NEW JERSEY Days
524261 PT San Ramon CALIFORNIA Days
524265 PTA San Ramon 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.5225 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 asc limit 100,100 in 1.3726 seconds