Listing all records

Displaying records 3201 through 3300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
541258 ICU Concord CALIFORNIA 12 Hour Days
541312 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
541550 PT Apple Valley CALIFORNIA 8 Hour Days
541551 PT Apple Valley CALIFORNIA 8 Hour Days
541578 Cath Lab Tarzana CALIFORNIA 8 Hour Days
541591 RAD Tech Petaluma CALIFORNIA 8 Hour Days
541610 PT Hesperia CALIFORNIA 8 Hour Days
541634 NICU Greenbrae CALIFORNIA 12 Hour Days
541642 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
541643 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
541652 PT SANTA ROSA CALIFORNIA 8 Hour Days
541654 Surgical Tech SANTA ROSA CALIFORNIA 8 Hour Days
542958 PT San Jose CALIFORNIA 10 Hour Days
541700 L&D Eureka CALIFORNIA 12 Hour Nights
541705 PT Eureka CALIFORNIA 8 Hour Days
541750 PT Union City CALIFORNIA 8 Hour Days
542449 PTA Lakeport CALIFORNIA 8 Hour Days
542156 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
542160 CT Tech Lynwood CALIFORNIA 12 Hour Day/Night Rotate
542347 Ultrasound Tech Greenbrae CALIFORNIA 12 Hour Day/Night Rotate
542380 PT SANTA ROSA CALIFORNIA 8 Hour Days
542427 PT Lakeport CALIFORNIA Varied
542430 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
542523 Surgical Tech CVOR Los Angeles CALIFORNIA 12 Hour Days
542691 Lab Supervisor Avalon CALIFORNIA 8 Hour Varied
542734 PT Hayward CALIFORNIA 8 Hour Days
542758 Med Surg Tele Concord CALIFORNIA 12 Hour Days
542780 SLP Oakhurst CALIFORNIA Days
542838 Case Manager Eureka CALIFORNIA 8 Hour Days
542846 Interventional Radiology Tech Oceanside CALIFORNIA 10 Hour Days
542873 PT Monterey CALIFORNIA Days
542997 Cath Lab Concord CALIFORNIA 10 Hour Days
542943 CT Tech San Bernardino CALIFORNIA 8 Hour Day/Night Rotate
542944 ER Concord CALIFORNIA 12 Hour Nights
543005 CT Tech Oceanside CALIFORNIA 10 Hour Days
543006 CVOR Oceanside CALIFORNIA 8 Hour Days
543038 Telemetry San Diego CALIFORNIA 12 Hour Day/Night Rotate
543039 CLS San Diego CALIFORNIA 12 Hour Day/Night Rotate
543040 CT Tech San Diego CALIFORNIA 12 Hour Day/Night Rotate
543286 RAD Tech Lynwood CALIFORNIA 8 Hour Nights
543087 PTA Ukiah CALIFORNIA 8 Hour Days
543089 OR San Dimas CALIFORNIA 8 Hour Days
543090 MICU San Dimas CALIFORNIA 12 Hour Nights
543092 MICU San Dimas CALIFORNIA 12 Hour Nights
543124 Cath Lab Fresno CALIFORNIA 12 Hour Days
543127 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543128 Surgical Tech Fresno CALIFORNIA 10 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.8025 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 3200,100 in 1.8188 seconds