Listing all records

Displaying records 501 through 600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
540276 ICU Concord CALIFORNIA 12 Hour Nights
540277 ER Concord CALIFORNIA 12 Hour Nights
540278 CT Tech Concord CALIFORNIA 10 Hour Nights
540279 Med Surg Concord CALIFORNIA 12 Hour Nights
540280 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540281 ICU Concord CALIFORNIA 12 Hour Days
540282 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540283 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540284 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540285 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540286 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540287 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Nights
540288 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540289 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540290 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540291 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540292 Intermediate Care Walnut Creek CALIFORNIA 12 Hour Days
540293 ICU Concord CALIFORNIA 12 Hour Nights
540294 Intermediate Care Walnut Creek CALIFORNIA 12 Hour Nights
540295 ER Walnut Creek CALIFORNIA 12 Hour Days
540296 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540297 ER Concord CALIFORNIA 12 Hour Days
540298 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
540299 L&D Walnut Creek CALIFORNIA 12 Hour Days
540300 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540301 PACU Concord CALIFORNIA 10 Hour Days
540302 Med Surg Concord CALIFORNIA 12 Hour Days
540303 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540304 L&D Walnut Creek CALIFORNIA 12 Hour Days
540305 OR Walnut Creek CALIFORNIA 12 Hour Nights
540306 Med Surg Concord CALIFORNIA 12 Hour Nights
540307 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540308 Case Manager Concord CALIFORNIA 8 Hour Evenings
540309 L&D Walnut Creek CALIFORNIA 12 Hour Days
540310 OR Walnut Creek CALIFORNIA 12 Hour Days
540311 ER Walnut Creek CALIFORNIA 12 Hour Nights
540312 Intermediate Care Walnut Creek CALIFORNIA 12 Hour Nights
540313 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540314 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Days
540315 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
540316 Intermediate Care Walnut Creek CALIFORNIA 12 Hour Nights
540317 PACU Walnut Creek CALIFORNIA 12 Hour Nights
540318 Med Surg Concord CALIFORNIA 12 Hour Days
540319 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540320 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540321 ICU Walnut Creek CALIFORNIA 12 Hour Days
540322 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540323 Telemetry Concord CALIFORNIA 12 Hour Nights
540324 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540325 PT Walnut Creek CALIFORNIA 10 Hour Days
540326 Pediatrics Walnut Creek CALIFORNIA 12 Hour Days
540327 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540328 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Days
540329 ICU Walnut Creek CALIFORNIA 12 Hour Days
540330 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540331 ER Concord CALIFORNIA 12 Hour Nights
540332 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
540333 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540334 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Days
540335 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540336 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540337 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540338 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540339 PICU Walnut Creek CALIFORNIA 12 Hour Days
540340 ICU Walnut Creek CALIFORNIA 12 Hour Days
540341 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540342 Telemetry Concord CALIFORNIA 12 Hour Days
540343 ICU Walnut Creek CALIFORNIA 12 Hour Days
540344 PACU Concord CALIFORNIA 12 Hour Days
540345 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540346 ICU Walnut Creek CALIFORNIA 12 Hour Days
540347 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540348 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540349 Telemetry Concord CALIFORNIA 12 Hour Nights
540350 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540423 Case Manager Oceanside CALIFORNIA 8 Hour Days
540425 CT Tech Oceanside CALIFORNIA 8 Hour Evenings
540529 Telemetry Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
540616 Cath Lab Inglewood CALIFORNIA 10 Hour Days
540619 L&D Lynwood CALIFORNIA 12 Hour Days
540742 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540743 PCU Concord CALIFORNIA 12 Hour Days
540744 PCU Concord CALIFORNIA 12 Hour Days
540747 CT Tech SANTA CRUZ CALIFORNIA 8 Hour Day/Night Rotate
540814 NICU Lynwood CALIFORNIA 12 Hour Nights
540815 Respiratory Care Lynwood CALIFORNIA 12 Hour Nights
540823 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
540824 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
540852 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540895 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540910 Social Worker Concord CALIFORNIA 8 Hour Days
540923 Interventional Radiology Tech Sacramento CALIFORNIA 10 Hour Days
541028 SLP MERCED CALIFORNIA 8 Hour Days
541037 L&D Walnut Creek CALIFORNIA 12 Hour Days
541039 Psych Concord CALIFORNIA 8 Hour Nights
546119 Nuclear Med Technician Whittier CALIFORNIA 8 Hour Days
541844 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
541207 ER Walnut Creek CALIFORNIA 12 Hour Nights
541235 Med Surg National City CALIFORNIA 12 Hour Nights
541257 OR Concord CALIFORNIA 10 Hour Evenings
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.3457 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 500,100 in 1.3475 seconds