Listing all records

Displaying records 601 through 700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
543129 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543130 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543285 SLP South San Francisco CALIFORNIA 8 Hour Days
543308 NICU Walnut Creek CALIFORNIA 12 Hour Days
543371 PACU Fresno CALIFORNIA 12 Hour Days
543373 PACU Fresno CALIFORNIA 12 Hour Days
543374 PACU Fresno CALIFORNIA 12 Hour Days
543380 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
543406 PT Palm Springs CALIFORNIA 8 Hour Days
543407 PT Palm Springs CALIFORNIA 8 Hour Days
543549 Med Surg Tele Concord CALIFORNIA 12 Hour Days
543550 Med Surg Tele Concord CALIFORNIA 12 Hour Days
543575 Nuclear Med Technician Los Angeles CALIFORNIA 8 Hour Days
543633 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
543644 ER Walnut Creek CALIFORNIA 12 Hour Nights
543645 ER Walnut Creek CALIFORNIA 12 Hour Nights
543646 ER Walnut Creek CALIFORNIA 12 Hour Nights
543647 ER Walnut Creek CALIFORNIA 12 Hour Nights
543648 ER Walnut Creek CALIFORNIA 12 Hour Nights
543649 ER Walnut Creek CALIFORNIA 12 Hour Nights
543650 ER Walnut Creek CALIFORNIA 12 Hour Nights
543651 ER Walnut Creek CALIFORNIA 12 Hour Nights
543709 Laboratory Orange CALIFORNIA 8 Hour Days
546032 PT San Jose CALIFORNIA 10 Hour Days
543751 OR Victorville CALIFORNIA 8 Hour Days
543752 PACU Victorville CALIFORNIA 8 Hour Days
543753 CLS Victorville CALIFORNIA 8 Hour Days
543755 NICU Lynwood CALIFORNIA 12 Hour Nights
543757 CT Tech Lynwood CALIFORNIA 12 Hour Days
543758 CT Tech Lynwood CALIFORNIA 12 Hour Days
543759 Neuro Intensive Care Lynwood CALIFORNIA 12 Hour Nights
543760 Neuro Intensive Care Lynwood CALIFORNIA 12 Hour Nights
543769 CLS Lynwood CALIFORNIA 12 Hour Days
543770 CLS Lynwood CALIFORNIA 12 Hour Days
543773 RAD Tech San Diego CALIFORNIA 12 Hour Days
543774 RAD Tech San Diego CALIFORNIA 12 Hour Days
543777 RAD Tech San Diego CALIFORNIA 12 Hour Day/Night Rotate
543778 RAD Tech San Diego CALIFORNIA 12 Hour Day/Night Rotate
543781 OR Redding CALIFORNIA 8 Hour Days
543783 RAD Tech Redding CALIFORNIA 8 Hour Days
543785 Scrub Tech Redding CALIFORNIA 12 Hour Day/Night Rotate
543790 RAD Tech Oceanside CALIFORNIA 8 Hour Days
543831 Cath Lab Tech Salinas CALIFORNIA 8 Hour Days Tech/Technologist
543834 Mammo Tech Salinas CALIFORNIA 8 Hour Days Tech/Technologist
543885 OR National City CALIFORNIA 8 Hour Days
543886 RAD Tech National City CALIFORNIA 12 Hour Nights
543887 CT Tech National City CALIFORNIA 12 Hour Nights
543888 RAD Tech National City CALIFORNIA 12 Hour Days
543889 Cath Lab National City CALIFORNIA 8 Hour Days
543890 Psych National City CALIFORNIA 12 Hour Nights
543891 Psych National City CALIFORNIA 12 Hour Days
543904 PT Crescent City CALIFORNIA 8 Hour Days
543911 COTA Hanford 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 2.9894 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 600,100 in 1.5121 seconds