Listing all records

Displaying records 2801 through 2900 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
540046 Peri-Operative Walnut Creek CALIFORNIA 10 Hour Days
540047 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540048 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540049 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Nights
540050 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540051 Psych Concord CALIFORNIA 8 Hour Evenings
540052 Psych Concord CALIFORNIA 8 Hour Evenings
540053 OR Walnut Creek CALIFORNIA 12 Hour Nights
540054 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540056 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540057 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540058 OR Walnut Creek CALIFORNIA 12 Hour Days
540059 PACU Concord CALIFORNIA 10 Hour Days
540064 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
540066 NICU Walnut Creek CALIFORNIA 12 Hour Nights
544121 CT Tech Avalon CALIFORNIA 8 Hour Varied
544168 COTA Madera CALIFORNIA Days
544405 ER Walnut Creek CALIFORNIA 12 Hour Nights
544444 PT Santa Clara CALIFORNIA 10 Hour Days
544446 MLT Los Angeles CALIFORNIA 8 Hour Days
544557 Cath Lab Burbank CALIFORNIA 8 Hour Days
544570 ICU Burbank CALIFORNIA 12 Hour Nights
544641 PT Monterey CALIFORNIA Days
544670 RAD Tech Los Angeles CALIFORNIA 8 Hour Days
544735 Surgical Tech MERCED CALIFORNIA 12 Hour 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.6703 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 2800,100 in 1.5407 seconds