Listing all records

Displaying records 801 through 900 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
535174 PT San Francisco CALIFORNIA 8 Hour Days
535176 Cath Lab Alameda Oakland CALIFORNIA 8 Hour Days
535177 Cath Lab Alameda Oakland CALIFORNIA 8 Hour Varied
535268 COTA San Andreas CALIFORNIA Days
535269 COTA San Andreas CALIFORNIA Days
535270 PTA Modesto CALIFORNIA Days
535271 PTA Modesto CALIFORNIA Days
536828 Radiation Therapy Los Angeles CALIFORNIA 8 Hour Days
535635 Therapy Rehab Stockton CALIFORNIA Days
535640 PT NORTHRIDGE CALIFORNIA 8 Hour Days
535906 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
536253 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Nights
536509 CVOR Fresno CALIFORNIA 12 Hour Days
536510 CVOR Fresno CALIFORNIA 12 Hour Days
538592 Telemetry Panorama City CALIFORNIA 12 Hour Days RN/Registered Nurse
536731 Surgical Tech Fresno CALIFORNIA 10 Hour Days
536753 PT NORTHRIDGE CALIFORNIA 8 Hour Days
536775 RAD Tech San Francisco CALIFORNIA 8 Hour Day/Night Rotate
536776 CT Tech San Francisco CALIFORNIA 8 Hour Day/Night Rotate
537089 PT Sacramento CALIFORNIA 8 Hour Days
537278 PT Sonoma CALIFORNIA 8 Hour Days
537353 OR Chino CALIFORNIA 12 Hour Day/Night Rotate
537901 ER Avalon CALIFORNIA 12 Hour Day/Night Rotate
537902 SNF Avalon CALIFORNIA 12 Hour Days
538057 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
538064 Long Term Care Alturas CALIFORNIA 12 Hour Day/Night Rotate
538137 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
538179 ICU San Diego CALIFORNIA 12 Hour Day/Night Rotate
538181 Cath Lab San Diego CALIFORNIA 12 Hour Days
538182 Cath Lab San Diego CALIFORNIA 8 Hour Days
538185 CNA Avalon CALIFORNIA 12 Hour Days
538356 RAD Tech Chino CALIFORNIA 8 Hour Days
538394 ER Avalon CALIFORNIA 12 Hour Day/Night Rotate
538440 COTA Monterey CALIFORNIA Days
539948 Social Worker Fresno CALIFORNIA Days
538911 CT Tech Alturas CALIFORNIA 8 Hour Varied
539068 ER Avalon CALIFORNIA Nights
539105 Telemetry San Diego CALIFORNIA 12 Hour Days
539106 Telemetry San Diego CALIFORNIA 12 Hour Nights
539107 ICU San Diego CALIFORNIA 12 Hour Nights
539110 PCU Concord CALIFORNIA 12 Hour Nights
539111 OR Concord CALIFORNIA 10 Hour Days
539112 Social Worker Concord CALIFORNIA 8 Hour Days
539151 Surgical Tech Fresno CALIFORNIA 10 Hour Days
539306 PT Sunnyvale CALIFORNIA Days
539477 Telemetry - Per Diem Mission Viejo CALIFORNIA 12 Hour Days RN/Registered Nurse
539873 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
540446 Case Manager Napa CALIFORNIA 8 Hour Days
539941 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
540000 ER Walnut Creek CALIFORNIA 12 Hour Nights
540001 ER Walnut Creek CALIFORNIA 12 Hour Days
540004 PACU Walnut Creek CALIFORNIA 12 Hour Days
540006 PCU Walnut Creek CALIFORNIA 12 Hour Nights
540007 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540008 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540010 OR Walnut Creek CALIFORNIA 12 Hour Days
540015 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
540021 L&D Walnut Creek CALIFORNIA 12 Hour Days
540023 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540025 OR Concord CALIFORNIA 10 Hour Evenings
540026 OR Concord CALIFORNIA 8 Hour Days
540027 OR Concord CALIFORNIA 12 Hour Days
540028 OR Concord CALIFORNIA 10 Hour Days
540029 PCU Concord CALIFORNIA 8 Hour Days
540030 L&D Walnut Creek CALIFORNIA 12 Hour Days
540031 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540033 Med Surg Tele Concord CALIFORNIA 8 Hour Days
540034 PCU Concord CALIFORNIA 8 Hour Nights
540035 PCU Concord CALIFORNIA 8 Hour Days
540036 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540037 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540038 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540039 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
540042 ICU Concord CALIFORNIA 12 Hour Days
540044 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
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.8147 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 800,100 in 1.6839 seconds