Listing all records

Displaying records 201 through 300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547709 Pediatrics Alturas CALIFORNIA 12 Hour Day/Night Rotate
547720 OR Concord CALIFORNIA 8 Hour Days
546191 PT Crescent City CALIFORNIA Varied
547735 Neuro Intensive Care Palo Alto CALIFORNIA 12 Hour Day/Night Rotate
546192 ICU - Per Diem Irvine CALIFORNIA 12 Hour Nights RN/Registered Nurse
546448 Nuclear Med Technician Santa Monica CALIFORNIA 12 Hour Days
546440 Ophthalmic Tech Beverly Hills CALIFORNIA 8 Hour Days
546212 Outpatient Clinic Susanville CALIFORNIA 10 Hour Days
546414 Home Health Hayward CALIFORNIA 8 Hour Days
546213 Outpatient Clinic Susanville CALIFORNIA 10 Hour Days
547773 Rehab PARAMOUNT CALIFORNIA 12 Hour Days
547774 Rehab PARAMOUNT CALIFORNIA 12 Hour Nights
546220 PT Crescent City CALIFORNIA 8 Hour Days
547782 PT Indio CALIFORNIA 8 Hour Days
547796 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
546221 PTA Crescent City CALIFORNIA 8 Hour Day/Night Rotate
546368 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548254 Home Health Santa Rosa CALIFORNIA 8 Hour Days RN/Registered Nurse
547806 PT Mammoth Lakes CALIFORNIA Days
546337 Medical Assistant Playa Vista CALIFORNIA 8 Hour Days
546357 CVOR Lakewood CALIFORNIA 8 Hour Days
546356 CVOR Lakewood CALIFORNIA 8 Hour Days
546355 CVOR Lakewood CALIFORNIA 8 Hour Days
546354 Cardiology Fountain Valley CALIFORNIA 12 Hour Days
546353 RAD Tech Turlock CALIFORNIA 8 Hour Days
546352 CT Tech Manteca CALIFORNIA 8 Hour Days
546340 Certified Surgical Tech Torrance CALIFORNIA 10 Hour Days
546332 Sterile Processing Technician Fresno CALIFORNIA 8 Hour Days
546321 PT Mission Hills CALIFORNIA 8 Hour Days
547883 PTA Daly City CALIFORNIA 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
547847 PCU Tarzana CALIFORNIA 12 Hour Nights
546286 PT Hayward CALIFORNIA 8 Hour Days
546301 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
547722 Interventional Radiology Tech Sacramento CALIFORNIA 10 Hour Days
545420 PT REDWOOD CITY CALIFORNIA 8 Hour Days
544121 CT Tech Avalon CALIFORNIA 8 Hour Varied
545453 ER Lynwood CALIFORNIA 12 Hour Nights
545470 Ultrasound Tech Greenbrae CALIFORNIA 12 Hour Day/Night Rotate
545514 L&D Arcata CALIFORNIA 12 Hour Nights
545515 L&D Arcata CALIFORNIA 12 Hour Nights
545317 PT SANTA ROSA CALIFORNIA 8 Hour Days
545316 SLP Eureka CALIFORNIA 8 Hour Days
545315 CT Tech Eureka CALIFORNIA 10 Hour Days
545314 Interventional Radiology SANTA ROSA CALIFORNIA Days
545313 Surgical Tech SANTA ROSA CALIFORNIA 8 Hour Days
545310 OR SANTA ROSA CALIFORNIA 12 Hour Nights
545280 LPN/LVN SANTA MARIA CALIFORNIA 8 Hour Days
545278 First Assist Templeton CALIFORNIA 10 Hour Days
545277 Surgical Tech Templeton CALIFORNIA 10 Hour Days
545275 First Assist San Luis Obispo CALIFORNIA 8 Hour Days
545606 Interventional Radiology Tech Mission Viejo CALIFORNIA 10 Hour Days
545611 Cath Lab Mission Viejo CALIFORNIA 10 Hour Days
546081 Case Manager Santa Monica CALIFORNIA 8 Hour Days
545613 EP Tech Mission Viejo CALIFORNIA 10 Hour Days
546800 ER Walnut Creek CALIFORNIA 12 Hour Nights
544405 ER Walnut Creek CALIFORNIA 12 Hour Nights
546281 Home Health Hayward CALIFORNIA 8 Hour Days
544444 PT Santa Clara CALIFORNIA 10 Hour Days
544446 MLT Los Angeles CALIFORNIA 8 Hour Days
545196 Social Worker Concord CALIFORNIA 8 Hour Days
546036 PT Burbank CALIFORNIA 8 Hour Days
544557 Cath Lab Burbank CALIFORNIA 8 Hour Days
546035 PT Burbank CALIFORNIA 8 Hour Days
546423 PT Hayward CALIFORNIA 8 Hour Days
544168 COTA Madera CALIFORNIA Days
544570 ICU Burbank CALIFORNIA 12 Hour Nights
545997 LPN/LVN King City CALIFORNIA 12 Hour Days
545096 ER Burbank CALIFORNIA 12 Hour Nights
545992 Pediatrics King City CALIFORNIA 12 Hour Nights
545989 Long Term Care King City CALIFORNIA 12 Hour Nights
545988 Long Term Care King City CALIFORNIA 12 Hour Days
545084 RAD Tech San Diego CALIFORNIA 12 Hour Days
544641 PT Monterey CALIFORNIA Days
545067 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
544670 RAD Tech Los Angeles CALIFORNIA 8 Hour Days
545979 CT Tech Santa Barbara CALIFORNIA 12 Hour Day/Night Rotate
545003 PCU Palm Springs CALIFORNIA 12 Hour Nights
544735 Surgical Tech MERCED CALIFORNIA 12 Hour Days
544915 PT Mission Hills CALIFORNIA 8 Hour Days
544912 PT Apple Valley CALIFORNIA 10 Hour Days
544911 PT Apple Valley CALIFORNIA 10 Hour Days
544910 RAD Tech Oceanside CALIFORNIA 8 Hour Days
544909 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
544908 ER Oceanside CALIFORNIA 12 Hour Nights
545943 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
544896 OR Santa Monica CALIFORNIA 12 Hour Nights
544895 RAD Tech Lynwood CALIFORNIA 12 Hour Days
544890 ER Concord CALIFORNIA 12 Hour Days
545951 PT Sunnyvale CALIFORNIA Days
545950 PT Sunnyvale CALIFORNIA Days
540068 NICU Walnut Creek CALIFORNIA 12 Hour Days
543407 PT Palm Springs CALIFORNIA 8 Hour Days
543406 PT Palm Springs CALIFORNIA 8 Hour Days
543380 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
543374 PACU Fresno CALIFORNIA 12 Hour Days
543373 PACU Fresno CALIFORNIA 12 Hour Days
543371 PACU Fresno CALIFORNIA 12 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.5724 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 200,100 in 2.7919 seconds