Listing all records

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

ID Job Specialty City State Shift Title
543944 RAD Tech Walnut Creek CALIFORNIA 10 Hour Days
543945 RAD Tech Concord CALIFORNIA 10 Hour Days
544010 OR Oceanside CALIFORNIA 10 Hour Days
544012 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
544049 Med Surg Palm Springs CALIFORNIA 12 Hour Nights
544050 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
544051 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
544052 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
401167 Med Surg San Diego CALIFORNIA 12 Hour Nights
447084 CT Tech La Palma CALIFORNIA 12 Hour Day/Night Rotate
462914 Wound Care Los Alamitos CALIFORNIA 8 Hour Days
470815 PT Los Gatos CALIFORNIA Varied
479983 PT YUBA CITY CALIFORNIA Days
484788 PTA Merced CALIFORNIA Days
496231 COTA Oakhurst CALIFORNIA Days
497771 PT Sonora CALIFORNIA Days
497775 PT San Andreas CALIFORNIA Days
548246 Med Surg Tele CARMICHAEL CALIFORNIA 12 Hour Nights RN/Registered Nurse
548266 ICU BAKERSFIELD CALIFORNIA 12 Hour Nights RN/Registered Nurse
504074 Case Manager San Francisco CALIFORNIA 8 Hour 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
507931 PT Martinez CALIFORNIA 8 Hour Days
512644 PT SUNNYVALE CALIFORNIA 8 Hour Days
515247 PT Hanford CALIFORNIA Days
516543 Case Manager SUNNYVALE CALIFORNIA 8 Hour Days
516544 Case Manager SUNNYVALE CALIFORNIA 8 Hour Days
516546 ER Burbank CALIFORNIA 8 Hour Days RN/Registered Nurse
516920 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
517294 Surgical Tech Oceanside CALIFORNIA 10 Hour Days
517353 ER - Per Diem San pedro CALIFORNIA 12 Hour Nights RN/Registered Nurse
517382 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Days RN/Registered Nurse
517474 Ortho Tech Oceanside CALIFORNIA 8 Hour Days
517887 CRNA Alturas CALIFORNIA 12 Hour Day/Night Rotate
518108 Case Manager Burbank CALIFORNIA 8 Hour Days
518534 COTA NEWMAN CALIFORNIA Days
518547 NICU Per Diem/Local Contract Torrance CALIFORNIA 12 Hour Nights RN/Registered Nurse
541964 Cath Lab Whittier CALIFORNIA 8 Hour Days
541845 NICU Walnut Creek CALIFORNIA 12 Hour Nights
541840 PT SANTA MARIA CALIFORNIA 8 Hour Days
519847 ER - Per Diem San pedro CALIFORNIA 12 Hour Nights RN/Registered Nurse
520029 PT Petaluma CALIFORNIA Varied
548256 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548257 PACU Lynwood CALIFORNIA 12 Hour Days RN/Registered Nurse
548258 PACU Lynwood CALIFORNIA 12 Hour Days RN/Registered Nurse
548259 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548261 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548262 ICU Arcata CALIFORNIA 12 Hour Days RN/Registered Nurse
520208 PT NEWMAN CALIFORNIA Days
520291 CT Tech Oceanside CALIFORNIA 10 Hour Days
541765 CVOR Oceanside CALIFORNIA 8 Hour Nights
524582 ICU - Per Diem Oceanside CALIFORNIA 12 Hour Days RN/Registered Nurse
547467 NICU Walnut Creek CALIFORNIA 12 Hour Days
522372 PT Weaverville CALIFORNIA Days
522691 PT San Jose CALIFORNIA 12 Hour Day/Night Rotate
523059 CVOR Tech Los Angeles CALIFORNIA 10 Hour Days CST/Certified Surgical Technician
523664 PT San Jose CALIFORNIA Varied
523666 PTA Freemont CALIFORNIA Days
523668 PT Oakland CALIFORNIA Days
523669 PT San Rafael CALIFORNIA Days
523775 ICU Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
524038 ICU - Per Diem Burbank CALIFORNIA 12 Hour Days RN/Registered Nurse
524261 PT San Ramon CALIFORNIA Days
524265 PTA San Ramon CALIFORNIA Days
530342 ICU Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
524588 ICU - Per Diem Oceanside CALIFORNIA 12 Hour Days RN/Registered Nurse
525235 CT Tech Oceanside CALIFORNIA 10 Hour Days
527493 Telemetry Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
525930 RAD Tech Los Angeles CALIFORNIA 10 Hour Days Radiology Techs/Technologists
526099 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
526101 ICU Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
526268 Interventional Radiology Tech Fresno CALIFORNIA 12 Hour Days
526545 ICU - Per Diem Woodland Hills CALIFORNIA 12 Hour Nights RN/Registered Nurse
527184 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Days RN/Registered Nurse
527222 PT Freemont CALIFORNIA Days
527223 PTA Hayward CALIFORNIA Days
527324 PT Palm Springs CALIFORNIA Days
527559 RAD Tech San Diego CALIFORNIA 12 Hour Nights
527570 Med Surg Tele Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
527624 Scrub Tech Oceanside CALIFORNIA 10 Hour Days
527625 Sterile Processing Technician Oceanside CALIFORNIA 10 Hour Nights
527789 RAD Tech Oceanside CALIFORNIA 8 Hour Days
530725 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
528182 Outpatient Clinic Per Diem San Diego CALIFORNIA 8 Hour Days RN/Registered Nurse
528482 SLP Fresno CALIFORNIA Days
528610 OR Oceanside CALIFORNIA 10 Hour Days
529033 PT San Ramon CALIFORNIA Days
529616 ICU - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
529699 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
530475 Telemetry Panorama City CALIFORNIA 12 Hour Days RN/Registered Nurse
529991 Therapy Rehab Los Angeles CALIFORNIA Days
530739 Med Surg Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
530071 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
530323 ICU - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
530433 Surgical Tech Oceanside CALIFORNIA Varied
530439 ICU - Per Diem Woodland Hills CALIFORNIA 12 Hour Nights RN/Registered Nurse
530740 Med Surg Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
530741 Med Surg Van Nuys CALIFORNIA 12 Hour Nights RN/Registered Nurse
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.2998 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 y.name asc limit 700,100 in 1.4258 seconds