Listing all records

Displaying records 3401 through 3500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
548347 Respiratory Therapist Lynwood CALIFORNIA 12 Hour Nights Respiratory Therapist
548351 NICU Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
548353 Behavioral Health Modesto CALIFORNIA 12 Hour Days RN/Registered Nurse
548354 Psych National City CALIFORNIA 12 Hour Nights RN/Registered Nurse
548356 ER - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548359 ER Oceanside CALIFORNIA 12 Hour Nights RN/Registered Nurse
548361 Telemetry BAKERSFIELD CALIFORNIA 12 Hour Nights RN/Registered Nurse
548362 Telemetry Antioch CALIFORNIA 12 Hour Nights RN/Registered Nurse
548364 Med Surg BAKERSFIELD CALIFORNIA 12 Hour Days RN/Registered Nurse
548365 Med Surg BAKERSFIELD CALIFORNIA 12 Hour Days RN/Registered Nurse
548366 ICU Anaheim CALIFORNIA 12 Hour Days RN/Registered Nurse
548367 ER FOLSOM CALIFORNIA 12 Hour Nights RN/Registered Nurse
548368 ICU Anaheim CALIFORNIA 12 Hour Nights RN/Registered Nurse
548377 Telemetry Santa Clara CALIFORNIA 12 Hour Days RN/Registered Nurse
548379 Postpartum Fresno CALIFORNIA 12 Hour Nights RN/Registered Nurse
548383 Telemetry BAKERSFIELD CALIFORNIA 12 Hour Days RN/Registered Nurse
548384 Telemetry Concord CALIFORNIA 12 Hour Days RN/Registered Nurse
548385 Telemetry Antioch CALIFORNIA 12 Hour Days RN/Registered Nurse
548386 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548387 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
548391 ICU Merced CALIFORNIA 12 Hour Nights RN/Registered Nurse
548393 ICU SAN ANDREAS CALIFORNIA 12 Hour Nights RN/Registered Nurse
548396 CVICU SANTA CRUZ CALIFORNIA 12 Hour Nights RN/Registered Nurse
548397 ICU SAN ANDREAS CALIFORNIA 12 Hour Nights RN/Registered Nurse
548405 Telemetry Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
548410 Respiratory Therapist Lynwood CALIFORNIA 12 Hour Nights Respiratory Therapist
546191 PT Crescent City CALIFORNIA Varied
546192 ICU - Per Diem Irvine CALIFORNIA 12 Hour Nights RN/Registered Nurse
546212 Outpatient Clinic Susanville CALIFORNIA 10 Hour Days
546213 Outpatient Clinic Susanville CALIFORNIA 10 Hour Days
546220 PT Crescent City CALIFORNIA 8 Hour Days
546221 PTA Crescent City CALIFORNIA 8 Hour Day/Night Rotate
546337 Medical Assistant Playa Vista CALIFORNIA 8 Hour Days
547626 Certified Surgical Tech Santa Monica CALIFORNIA 12 Hour Days
546282 PT Hayward CALIFORNIA 8 Hour Days
546283 PT Hayward CALIFORNIA 8 Hour Days
546286 PT Hayward CALIFORNIA 8 Hour Days
546301 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
546321 PT Mission Hills CALIFORNIA 8 Hour Days
546332 Sterile Processing Technician Fresno CALIFORNIA 8 Hour Days
546340 Certified Surgical Tech Torrance CALIFORNIA 10 Hour Days
546352 CT Tech Manteca CALIFORNIA 8 Hour Days
546353 RAD Tech Turlock CALIFORNIA 8 Hour Days
546354 Cardiology Fountain Valley CALIFORNIA 12 Hour Days
546355 CVOR Lakewood CALIFORNIA 8 Hour Days
546356 CVOR Lakewood CALIFORNIA 8 Hour Days
546357 CVOR Lakewood CALIFORNIA 8 Hour Days
546368 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
546414 Home Health Hayward CALIFORNIA 8 Hour Days
546440 Ophthalmic Tech Beverly Hills CALIFORNIA 8 Hour Days
546448 Nuclear Med Technician Santa Monica CALIFORNIA 12 Hour Days
548403 Telemetry Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
546640 NICU Los Angeles CALIFORNIA 12 Hour Days
546644 PT San Ramon CALIFORNIA 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.9644 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 3400,100 in 1.3895 seconds