Listing all records

Displaying records 2901 through 3000 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545257 CT Tech Roseburg OREGON 10 Hour Nights
516937 SLP Roseburg OREGON Days
533177 CT Tech Roseburg OREGON 8 Hour Days
536752 CT Tech Roseburg OREGON 12 Hour Nights
539310 Speech Language Roseburg OREGON Days
548079 PICU Roseville CALIFORNIA 12 Hour Nights RN/Registered Nurse
547515 Medical Assistant Ruidoso NEW MEXICO 8 Hour Days
547988 Intermediate Care Rumford MAINE 12 Hour Days
547989 Intermediate Care Rumford MAINE 12 Hour Days
548022 OT Rehab Rushville ILLINOIS Varied
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
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
540923 Interventional Radiology Tech Sacramento CALIFORNIA 10 Hour Days
548184 Psych Salem MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
545111 PT Salem OREGON Days
545112 PT Salem OREGON Days
545328 CNA Salem OREGON 12 Hour Nights
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
528615 SLP Salisbury NORTH CAROLINA Days
538132 PT Salisbury MISSOURI Days
497775 PT San Andreas CALIFORNIA Days
535268 COTA San Andreas CALIFORNIA Days
535269 COTA San Andreas CALIFORNIA Days
546986 LPN/LVN SAN ANDREAS CALIFORNIA 8 Hour Days
548393 ICU SAN ANDREAS CALIFORNIA 12 Hour Nights RN/Registered Nurse
548397 ICU SAN ANDREAS CALIFORNIA 12 Hour Nights RN/Registered Nurse
547964 Mammo Tech San Angelo TEXAS 8 Hour Days
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
542039 OR San Angelo TEXAS Varied
542130 Echo Technologist San Angelo TEXAS Varied
543330 Ultrasound Tech San Angelo TEXAS 12 Hour Nights
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
542943 CT Tech San Bernardino CALIFORNIA 8 Hour Day/Night Rotate
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
547958 Cath Lab 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
547635 SLP San Diego CALIFORNIA 8 Hour Days
545084 RAD Tech San Diego CALIFORNIA 12 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
546926 MICU San Dimas CALIFORNIA 12 Hour Nights
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
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
548165 ICU San Jose CALIFORNIA 12 Hour Nights RN/Registered Nurse
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
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
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
523669 PT San Rafael CALIFORNIA Days
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
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.3427 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 asc limit 2900,100 in 1.5857 seconds