Listing all records

Displaying records 101 through 200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548166 Med Surg Phoenix ARIZONA 12 Hour Nights RN/Registered Nurse
548222 Certified Surgical Tech Sun City ARIZONA 10 Hour Days CST/Certified Surgical Technician
548200 Respiratory Therapist Mesa ARIZONA 12 Hour Days Respiratory Therapist
548198 ER Casa Grande ARIZONA 12 Hour Nights RN/Registered Nurse
548133 Cath Lab Mesa ARIZONA 12 Hour Days RN/Registered Nurse
548098 Med Surg Tele Chandler ARIZONA 12 Hour Day/Night Rotate RN/Registered Nurse
548089 NICU Tucson ARIZONA 12 Hour Nights RN/Registered Nurse
548088 ER Tucson ARIZONA 12 Hour Nights RN/Registered Nurse
548087 PCU Tucson ARIZONA 12 Hour Nights RN/Registered Nurse
543510 Ultrasound Tech Phoenix ARIZONA 12 Hour Day/Night Rotate
542986 RAD Tech Tuba City ARIZONA 12 Hour Day/Night Rotate
542618 PCU Sun City West ARIZONA 12 Hour Days
542617 PCU Sun City West ARIZONA 12 Hour Nights
542211 Telemetry CHANDLER ARIZONA 12 Hour Nights
541829 RAD Tech CHANDLER ARIZONA 12 Hour Day/Night Rotate
540745 Telemetry Prescott ARIZONA 12 Hour Day/Night Rotate
540746 Med Surg Prescott ARIZONA 12 Hour Day/Night Rotate
540748 Med Surg Tele Prescott ARIZONA 12 Hour Days
540749 Med Surg Tele Prescott ARIZONA 12 Hour Day/Night Rotate
540770 Telemetry Prescott ARIZONA 12 Hour Days
541068 Cath Lab PHOENIX ARIZONA 12 Hour Days
542008 CVICU Little Rock ARKANSAS 12 Hour Days
541058 OR Sherwood ARKANSAS 10 Hour Days
542007 Med Surg Hot Springs ARKANSAS 12 Hour Nights
535216 Mammo Tech Juneau ARKANSAS Days
538454 CVICU Little Rock ARKANSAS 12 Hour Nights
519153 CVICU Little Rock ARKANSAS 12 Hour Nights
545299 CVICU Little Rock ARKANSAS 12 Hour Nights
546681 PACU Hot Springs ARKANSAS 8 Hour Days
546949 RAD Tech Hot Springs ARKANSAS 8 Hour Days
546812 Med Surg Harrison ARKANSAS 12 Hour Nights
546811 CT Tech Harrison ARKANSAS 10 Hour Evenings
548403 Telemetry Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
546986 LPN/LVN SAN ANDREAS CALIFORNIA 8 Hour Days
546988 Radiation Therapy NORTHRIDGE CALIFORNIA 8 Hour Days
546977 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
546976 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
546951 Surgical Tech Long Beach CALIFORNIA 12 Hour Nights
547056 PT Sacramento CALIFORNIA 8 Hour Days
546931 SLP Visalia CALIFORNIA 8 Hour Days
547057 OT Sacramento CALIFORNIA 8 Hour Days
546926 MICU San Dimas CALIFORNIA 12 Hour Nights
547064 COTA Crescent City CALIFORNIA 8 Hour Days
547070 PICU Walnut Creek CALIFORNIA 12 Hour Days
547071 PICU Walnut Creek CALIFORNIA 12 Hour Days
547072 NICU Walnut Creek CALIFORNIA 12 Hour Days
547073 NICU Walnut Creek CALIFORNIA 12 Hour Days
546881 ER MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
547082 Social Worker San Francisco CALIFORNIA 8 Hour Days
546868 ER MERCED CALIFORNIA 12 Hour Days
546866 Surgical Tech Mammoth Lakes CALIFORNIA 12 Hour Day/Night Rotate
547083 Social Worker San Francisco CALIFORNIA 8 Hour Days
547119 RAD Tech REDWOOD CITY CALIFORNIA 8 Hour Days
546802 NICU Walnut Creek CALIFORNIA 12 Hour Nights
546801 PICU Walnut Creek CALIFORNIA 12 Hour Days
547136 Pediatrics Quincy CALIFORNIA Nights
546783 PT Salinas CALIFORNIA 8 Hour Days PT/Physical Therapist
546782 CT Tech Salinas CALIFORNIA 12 Hour Nights CT/Computerized Tomography
546753 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
546735 Telemetry Santa Monica CALIFORNIA 12 Hour Nights
547329 NICU Mission Hills CALIFORNIA 12 Hour Nights
547331 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
547384 Registered Dietician Los Angeles CALIFORNIA 8 Hour Days
547397 SLP Pomona CALIFORNIA Days
546695 ER Oceanside CALIFORNIA 12 Hour Nights
546694 Interventional Radiology Tech Oceanside CALIFORNIA 10 Hour Days
546693 Telemetry Oceanside CALIFORNIA 12 Hour Evenings
548153 Home Health Pomona CALIFORNIA 8 Hour Days RN/Registered Nurse
546692 Med Surg Oceanside CALIFORNIA 12 Hour Days
546690 Surgical Tech Templeton CALIFORNIA 10 Hour Days
546689 OR Templeton CALIFORNIA 10 Hour Days
546687 PCU San Luis Obispo CALIFORNIA 12 Hour Days
546686 PCU San Luis Obispo CALIFORNIA 12 Hour Nights
547485 PT Union City CALIFORNIA 8 Hour Days
546667 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
546646 PT San Ramon CALIFORNIA Days
546645 PT San Ramon CALIFORNIA Days
546644 PT San Ramon CALIFORNIA Days
546640 NICU Los Angeles CALIFORNIA 12 Hour Days
547531 L&D Arcata CALIFORNIA 12 Hour Nights
547569 NICU Lynwood CALIFORNIA 12 Hour Nights
547570 Med Surg Per Diem/Local Contract Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
547586 PICU Santa Clara CALIFORNIA 12 Hour Nights
547607 OT Crescent City CALIFORNIA 8 Hour Days
547608 OT Crescent City CALIFORNIA 8 Hour Days
547610 PICU Santa Clara CALIFORNIA 12 Hour Days
547611 PICU Santa Clara CALIFORNIA 12 Hour Nights
547612 PICU Santa Clara CALIFORNIA 12 Hour Nights
547613 PICU Santa Clara CALIFORNIA 12 Hour Nights
547614 PICU Santa Clara CALIFORNIA 12 Hour Nights
547616 PICU Santa Clara CALIFORNIA 12 Hour Days
547618 PICU Santa Clara CALIFORNIA 12 Hour Days
547620 PICU Santa Clara CALIFORNIA 12 Hour Days
547621 PICU Santa Clara CALIFORNIA 12 Hour Days
547635 SLP San Diego CALIFORNIA 8 Hour Days
547636 Surgical Tech CVOR Los Angeles CALIFORNIA 12 Hour Days
547647 Nuclear Med Technician Los Angeles CALIFORNIA 8 Hour Days
547664 ICU Oceanside CALIFORNIA 12 Hour Nights
547665 Oncology Oceanside CALIFORNIA 12 Hour Nights
547685 Electrophysiology Tech Monterey CALIFORNIA 8 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.5142 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 100,100 in 1.5206 seconds