Listing all records

Displaying records 901 through 1000 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
547932 Telemetry - Per Diem Oceanside CALIFORNIA 12 Hour Nights
547940 Nuclear Med Technician Mission Viejo CALIFORNIA 8 Hour Days
547958 Cath Lab San Diego CALIFORNIA 8 Hour Days
547978 Surgical Tech Santa Monica CALIFORNIA 8 Hour Days
547979 Surgical Tech Santa Monica CALIFORNIA 8 Hour Days
547990 Cardiology Torrance CALIFORNIA 12 Hour Days
547991 Cardiology Torrance CALIFORNIA 12 Hour Days
547992 Case Manager Torrance CALIFORNIA 8 Hour Days
547993 LTAC Torrance CALIFORNIA 8 Hour Evenings
548161 Surgical Tech MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
548164 LTAC Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
548165 ICU San Jose CALIFORNIA 12 Hour Nights RN/Registered Nurse
548010 CT Tech Fort Bragg CALIFORNIA 12 Hour Day/Night Rotate
548011 SLP Crescent City CALIFORNIA 8 Hour Days
548012 PT Crescent City CALIFORNIA 8 Hour Days
548015 CNA San Francisco CALIFORNIA 8 Hour Days
548016 CNA San Francisco CALIFORNIA 8 Hour Days
548017 PACU Chico CALIFORNIA 10 Hour Days
548026 PT Escondido CALIFORNIA 8 Hour Days
548027 PTA Escondido CALIFORNIA 8 Hour Days
548038 Telemetry BAKERSFIELD CALIFORNIA 12 Hour Nights
548043 OR Bakersfield CALIFORNIA 8 Hour Days RN/Registered Nurse
548044 Case Manager Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
548045 OR NORTHRIDGE CALIFORNIA 12 Hour Nights RN/Registered Nurse
548046 OR BAKERSFIELD CALIFORNIA 8 Hour Days RN/Registered Nurse
548048 LPN/LVN Rancho Cordova CALIFORNIA 12 Hour Nights LVN
548051 CNA - Per Diem Los Angeles CALIFORNIA 12 Hour Days CNA/Certified Nursing Assistant
548054 CVOR STOCKTON CALIFORNIA 12 Hour Days RN/Registered Nurse
548056 NICU Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
548059 Surgical Tech SAN FRANCISCO CALIFORNIA 8 Hour Days Tech/Technologist
548061 PACU Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
548065 Step Down SANTA CRUZ CALIFORNIA 12 Hour Nights RN/Registered Nurse
548073 PCU Palm Springs CALIFORNIA 12 Hour Days RN/Registered Nurse
548076 Case Manager Burbank CALIFORNIA 8 Hour Days RN/Registered Nurse
548078 Case Manager Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
548079 PICU Roseville CALIFORNIA 12 Hour Nights RN/Registered Nurse
548082 PCU Torrance CALIFORNIA 12 Hour Days RN/Registered Nurse
548084 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548085 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Nights RN/Registered Nurse
548101 PCU Redding CALIFORNIA 12 Hour Nights RN/Registered Nurse
548110 Med Surg Redding CALIFORNIA 12 Hour Nights RN/Registered Nurse
548114 Telemetry MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
548135 CVICU Stockton CALIFORNIA 12 Hour Nights RN/Registered Nurse
548137 Med Surg Modesto CALIFORNIA 12 Hour Nights RN/Registered Nurse
548142 OR Bakersfield CALIFORNIA 8 Hour Day/Night Rotate RN/Registered Nurse
548146 Med Surg Bakersfield CALIFORNIA 12 Hour Nights RN/Registered Nurse
548149 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548154 Home Health Los Angeles Downey CALIFORNIA 8 Hour Days RN/Registered Nurse
548171 Speech Language Redding CALIFORNIA 10 Hour Days RN/Registered Nurse
548172 PT Red Bluff CALIFORNIA 8 Hour Days RN/Registered Nurse
548177 ICU Rancho Cordova CALIFORNIA 12 Hour Nights RN/Registered Nurse
548178 Speech Language Redding CALIFORNIA 10 Hour Days SLP/Speech Language Pathologist
548181 ICU Redding CALIFORNIA 12 Hour Days RN/Registered Nurse
548183 Home Health Anaheim CALIFORNIA 8 Hour Days RN/Registered Nurse
548186 Oncology SACRAMENTO CALIFORNIA 12 Hour Nights RN/Registered Nurse
548192 Case Manager BAKERSFIELD CALIFORNIA 8 Hour Days RN/Registered Nurse
548197 Med Surg Tele Vacaville CALIFORNIA 12 Hour Days RN/Registered Nurse
548207 ER Mission Hills CALIFORNIA 12 Hour Evenings RN/Registered Nurse
548208 CVICU Santa Clara CALIFORNIA 12 Hour Days RN/Registered Nurse
548212 CCU Redding CALIFORNIA 12 Hour Days RN/Registered Nurse
548220 CNA Camarillo CALIFORNIA 12 Hour Days CNA/Certified Nursing Assistant
548230 CNA Sacramento CALIFORNIA 8 Hour Evenings CNA/Certified Nursing Assistant
548232 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548274 ER Oceanside CALIFORNIA 12 Hour Nights RN/Registered Nurse
548276 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548279 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548284 CVOR Redding CALIFORNIA 12 Hour Days RN/Registered Nurse
548285 CVOR Sacramento CALIFORNIA 8 Hour Days RN/Registered Nurse
548287 Med Surg Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
548288 OR Victorville CALIFORNIA 8 Hour Days RN/Registered Nurse
548290 Telemetry - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548291 Telemetry - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548295 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548297 Neuro Med Surg/Tele Redding CALIFORNIA 12 Hour Nights RN/Registered Nurse
548306 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548307 OR Greenbrae CALIFORNIA 12 Hour Days RN/Registered Nurse
548319 ICU Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548326 Pharmacy Tech Panorama City CALIFORNIA 8 Hour Days Tech/Technologist
548331 ICU Anaheim CALIFORNIA 12 Hour Nights RN/Registered Nurse
548333 ICU Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548337 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Nights RN/Registered Nurse
548340 ER Fresno CALIFORNIA 12 Hour Days RN/Registered Nurse
548341 ER BAKERSFIELD CALIFORNIA 12 Hour Nights RN/Registered Nurse
548344 CVOR Fresno CALIFORNIA 12 Hour Days RN/Registered Nurse
548346 Postpartum Fresno CALIFORNIA 12 Hour Days 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.4544 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 900,100 in 1.4014 seconds