Listing all records

Displaying records 2701 through 2800 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
530850 Home Health Hayward CALIFORNIA 8 Hour Days
531037 Nuclear Medicine Oceanside CALIFORNIA 8 Hour Days
531204 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
531244 ICU   CALIFORNIA 12 Hour Days RN/Registered Nurse
531507 Therapy Rehab Modesto CALIFORNIA Days
531848 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
532057 PT San Ramon CALIFORNIA Days
532090 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
532091 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
532355 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
532598 PTA Hanford CALIFORNIA Days
532657 Cath Lab Walnut Creek CALIFORNIA 10 Hour Days
533242 Angiography San Diego CALIFORNIA 8 Hour Days
533910 PT Hayward CALIFORNIA 8 Hour Days
534108 Echo Oceanside CALIFORNIA 10 Hour Days
534109 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
534238 Med Surg Tele Concord CALIFORNIA 8 Hour Days
535905 Psych Concord CALIFORNIA 8 Hour Nights
538355 Cardiovascular Technologist Chino CALIFORNIA 8 Hour Days
534628 SLP Pomona CALIFORNIA Days
534629 SLP Pomona CALIFORNIA Days
534687 Med Surg Tele Concord CALIFORNIA 8 Hour Nights
534706 PT King City CALIFORNIA Days
534713 PT Redding CALIFORNIA 8 Hour Days
535095 LPN/LVN Quincy CALIFORNIA 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.5528 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 desc limit 2700,100 in 2.6583 seconds