Listing all records

Displaying records 701 through 800 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
544444 PT Santa Clara CALIFORNIA 10 Hour Days
545979 CT Tech Santa Barbara CALIFORNIA 12 Hour Day/Night Rotate
524261 PT San Ramon CALIFORNIA Days
524265 PTA San Ramon CALIFORNIA Days
529033 PT San Ramon CALIFORNIA Days
532057 PT San Ramon CALIFORNIA Days
546644 PT San Ramon CALIFORNIA Days
546645 PT San Ramon CALIFORNIA Days
546646 PT San Ramon CALIFORNIA Days
523669 PT San Rafael CALIFORNIA Days
517353 ER - Per Diem San pedro CALIFORNIA 12 Hour Nights RN/Registered Nurse
519847 ER - Per Diem San pedro CALIFORNIA 12 Hour Nights RN/Registered Nurse
545275 First Assist San Luis Obispo CALIFORNIA 8 Hour Days
546686 PCU San Luis Obispo CALIFORNIA 12 Hour Nights
546687 PCU San Luis Obispo CALIFORNIA 12 Hour Days
505339 PTA San Jose CALIFORNIA Days
505340 PT San Jose CALIFORNIA Days
505341 OT Rehab San Jose CALIFORNIA Days
505342 OT Rehab San Jose CALIFORNIA Days
522691 PT San Jose CALIFORNIA 12 Hour Day/Night Rotate
523664 PT San Jose CALIFORNIA Varied
542958 PT San Jose CALIFORNIA 10 Hour Days
546032 PT San Jose CALIFORNIA 10 Hour Days
548165 ICU San Jose CALIFORNIA 12 Hour Nights RN/Registered Nurse
548015 CNA San Francisco CALIFORNIA 8 Hour Days
548016 CNA San Francisco CALIFORNIA 8 Hour Days
548059 Surgical Tech SAN FRANCISCO CALIFORNIA 8 Hour Days Tech/Technologist
547082 Social Worker San Francisco CALIFORNIA 8 Hour Days
547083 Social Worker San Francisco CALIFORNIA 8 Hour Days
504074 Case Manager San Francisco CALIFORNIA 8 Hour Days
535174 PT San Francisco CALIFORNIA 8 Hour Days
536775 RAD Tech San Francisco CALIFORNIA 8 Hour Day/Night Rotate
536776 CT Tech San Francisco CALIFORNIA 8 Hour Day/Night Rotate
546926 MICU San Dimas CALIFORNIA 12 Hour Nights
543089 OR San Dimas CALIFORNIA 8 Hour Days
543090 MICU San Dimas CALIFORNIA 12 Hour Nights
543092 MICU San Dimas CALIFORNIA 12 Hour Nights
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
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
547635 SLP San Diego CALIFORNIA 8 Hour Days
401167 Med Surg San Diego CALIFORNIA 12 Hour Nights
527559 RAD Tech San Diego CALIFORNIA 12 Hour Nights
528182 Outpatient Clinic Per Diem San Diego CALIFORNIA 8 Hour Days RN/Registered Nurse
533242 Angiography San Diego CALIFORNIA 8 Hour Days
538179 ICU San Diego CALIFORNIA 12 Hour Day/Night Rotate
538181 Cath Lab San Diego CALIFORNIA 12 Hour Days
538182 Cath Lab San Diego CALIFORNIA 8 Hour Days
539105 Telemetry San Diego CALIFORNIA 12 Hour Days
539106 Telemetry San Diego CALIFORNIA 12 Hour Nights
539107 ICU San Diego CALIFORNIA 12 Hour Nights
547958 Cath Lab San Diego CALIFORNIA 8 Hour Days
545084 RAD Tech San Diego CALIFORNIA 12 Hour Days
542943 CT Tech San Bernardino CALIFORNIA 8 Hour Day/Night Rotate
546688 L&D San Antonio TEXAS 12 Hour Nights
547442 Electrophysiology Tech San Antonio TEXAS 10 Hour Days
547929 L&D San Antonio TEXAS 12 Hour Nights
547964 Mammo Tech San Angelo TEXAS 8 Hour Days
542039 OR San Angelo TEXAS Varied
542130 Echo Technologist San Angelo TEXAS Varied
543330 Ultrasound Tech San Angelo TEXAS 12 Hour Nights
532920 Oncology San Angelo TEXAS Days
538264 OR San Angelo TEXAS 8 Hour Day/Night Rotate
544852 ER San Angelo TEXAS Varied
545414 OT Rehab San Angelo TEXAS 8 Hour Day/Night Rotate
497775 PT San Andreas CALIFORNIA Days
535268 COTA San Andreas CALIFORNIA Days
535269 COTA San Andreas CALIFORNIA Days
548393 ICU SAN ANDREAS CALIFORNIA 12 Hour Nights RN/Registered Nurse
548397 ICU SAN ANDREAS CALIFORNIA 12 Hour Nights RN/Registered Nurse
546986 LPN/LVN SAN ANDREAS CALIFORNIA 8 Hour Days
528615 SLP Salisbury NORTH CAROLINA Days
538132 PT Salisbury MISSOURI Days
546782 CT Tech Salinas CALIFORNIA 12 Hour Nights CT/Computerized Tomography
546783 PT Salinas CALIFORNIA 8 Hour Days PT/Physical Therapist
543831 Cath Lab Tech Salinas CALIFORNIA 8 Hour Days Tech/Technologist
543834 Mammo Tech Salinas CALIFORNIA 8 Hour Days Tech/Technologist
545111 PT Salem OREGON Days
545112 PT Salem OREGON Days
545328 CNA Salem OREGON 12 Hour Nights
548184 Psych Salem MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
548186 Oncology SACRAMENTO CALIFORNIA 12 Hour Nights RN/Registered Nurse
548230 CNA Sacramento CALIFORNIA 8 Hour Evenings CNA/Certified Nursing Assistant
548285 CVOR Sacramento CALIFORNIA 8 Hour Days RN/Registered Nurse
540923 Interventional Radiology Tech Sacramento CALIFORNIA 10 Hour Days
547056 PT Sacramento CALIFORNIA 8 Hour Days
547057 OT Sacramento CALIFORNIA 8 Hour Days
547722 Interventional Radiology Tech Sacramento CALIFORNIA 10 Hour Days
537089 PT Sacramento CALIFORNIA 8 Hour Days
548022 OT Rehab Rushville ILLINOIS Varied
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.5276 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 z.city desc limit 700,100 in 1.5017 seconds