Listing all records

Displaying records 901 through 1000 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
540052 Psych Concord CALIFORNIA 8 Hour Evenings
540054 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540059 PACU Concord CALIFORNIA 10 Hour Days
546228 Pediatrics Concord NEW HAMPSHIRE 12 Hour Nights
546303 MRI Tech Concord NEW HAMPSHIRE 12 Hour Nights
546304 MRI Tech Concord NEW HAMPSHIRE 12 Hour Nights
546992 Certified Surgical Tech Concord MASSACHUSETTS 8 Hour Days
547532 CCU Concord MASSACHUSETTS 12 Hour Nights
547720 OR Concord CALIFORNIA 8 Hour Days
548374 Med Surg Tele Concord OHIO 12 Hour Nights RN/Registered Nurse
548384 Telemetry Concord CALIFORNIA 12 Hour Days RN/Registered Nurse
465120 Long Term Care Conrad MONTANA 8 Hour Evenings
487151 Long Term Care Conrad MONTANA 12 Hour Day/Night Rotate
547522 CT Tech Cook MINNESOTA 12 Hour Day/Night Rotate
547408 Ultrasound Tech Cooperstown NEW YORK 10 Hour Days
547757 Outpatient Clinic Cooperstown NEW YORK 8 Hour Days
548123 PCU Cooperstown NEW YORK 12 Hour Nights RN/Registered Nurse
548124 Med Surg Tele Cooperstown NEW YORK 12 Hour Nights RN/Registered Nurse
548125 Med Surg Tele Cooperstown NEW YORK 12 Hour Varied RN/Registered Nurse
548157 Psych Cooperstown NEW YORK 12 Hour Nights RN/Registered Nurse
548358 Med Surg Tele Cooperstown NEW YORK 12 Hour Days RN/Registered Nurse
546181 SLP Cooperstown NEW YORK 8 Hour Days
547756 Outpatient Clinic Cooperstown NEW YORK 8 Hour Days
543730 Med Surg Tele Cooperstown NEW YORK 12 Hour Nights
545140 PCU Coos Bay OREGON 12 Hour Nights
545389 Cardiology Coos Bay OREGON 8 Hour Days
547127 Med Surg Coos Bay OREGON 12 Hour Nights
547295 Oncology Coos Bay OREGON 10 Hour Days
547512 Med Surg Coos Bay OREGON 12 Hour Nights
547540 PCU Coos Bay OREGON 12 Hour Days
547895 OR Coos Bay OREGON 10 Hour Days
548168 Certified Surgical Tech Coos Bay OREGON 10 Hour Days RN/Registered Nurse
548155 OR Coos Bay OREGON 10 Hour Days RN/Registered Nurse
548371 Med Surg Coos Bay OREGON 12 Hour Nights RN/Registered Nurse
547289 ER CORDOVA ALASKA 12 Hour Nights
546474 CVOR Corvallis OREGON 12 Hour Day/Night Rotate
547592 Histology Technician Corvallis OREGON 8 Hour Days
547594 Urgent Care Corvallis OREGON 8 Hour Days
548019 CNA Corvallis OREGON 12 Hour Day/Night Rotate
545083 Cath Lab Corvallis OREGON 8 Hour Day/Night Rotate
541929 Management Corvallis OREGON 12 Hour Day/Night Rotate
539873 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
548011 SLP Crescent City CALIFORNIA 8 Hour Days
548012 PT Crescent City CALIFORNIA 8 Hour Days
543633 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
543904 PT Crescent City CALIFORNIA 8 Hour Days
546191 PT Crescent City CALIFORNIA Varied
546220 PT Crescent City CALIFORNIA 8 Hour Days
546221 PTA Crescent City CALIFORNIA 8 Hour Day/Night Rotate
547064 COTA Crescent City CALIFORNIA 8 Hour Days
547607 OT Crescent City CALIFORNIA 8 Hour Days
547608 OT Crescent City CALIFORNIA 8 Hour Days
545067 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
476614 PT Crownsville MARYLAND Days
544489 CT Tech Culbertson MONTANA Days
543900 CT Tech Culbertson MONTANA Days
547321 Med Surg Tele Cuyahoga Falls OHIO 12 Hour Nights
548311 ER Dallas TEXAS 12 Hour Nights RN/Registered Nurse
547883 PTA Daly City CALIFORNIA Days
544485 SLP Danvers MASSACHUSETTS Days
547888 Cath Lab Danville KENTUCKY 10 Hour Days
542596 Interventional Radiology Tech Daytona Beach FLORIDA 8 Hour Days
547297 Med Surg Tele Denison IOWA 12 Hour Nights
544226 MLT Denville NEW JERSEY 12 Hour Day/Night Rotate
544227 Nuclear Med Technician Denville NEW JERSEY 8 Hour Days
544228 CT Tech Denville NEW JERSEY 12 Hour Day/Night Rotate
544229 Dialysis Denville NEW JERSEY 12 Hour Day/Night Rotate
544230 ER Denville NEW JERSEY 12 Hour Nights
544231 ER Denville NEW JERSEY 12 Hour Days
544232 ER Denville NEW JERSEY 12 Hour Day/Night Rotate
544233 CCU Denville NEW JERSEY 12 Hour Nights
544234 Surgical Tech Denville NEW JERSEY 12 Hour Days
544235 Sterile Processing Tech Denville NEW JERSEY 8 Hour Days
538043 Respiratory Therapist Denville NEW JERSEY 12 Hour Nights
538044 Respiratory Therapist Denville NEW JERSEY 12 Hour Nights
538045 Respiratory Therapist Denville NEW JERSEY 12 Hour Nights
540812 CT Tech Denville NEW JERSEY 8 Hour Days
540813 CT Tech Denville NEW JERSEY 12 Hour Nights
543312 RAD Tech Denville NEW JERSEY Nights
548308 ER Deridder LOUISIANA 12 Hour Nights RN/Registered Nurse
548005 Med Surg Tele Des Moines IOWA 12 Hour Nights
548006 Med Surg Tele Des Moines IOWA 12 Hour Days
548007 Med Surg Tele Des Moines IOWA 12 Hour Days
548033 Med Surg Tele Des Moines IOWA 12 Hour Days
540582 Med Surg Des Moines IOWA 12 Hour Nights
540583 Orthopedics Des Moines IOWA 12 Hour Nights
540972 MLT Des Moines IOWA 10 Hour Nights
541071 Med Surg Tele Des Moines IOWA 12 Hour Nights
541072 Orthopedics Des Moines IOWA 12 Hour Nights
541076 Med Surg Des Moines IOWA 12 Hour Nights
541078 Oncology Des Moines IOWA 12 Hour Nights
543024 Interventional Radiology Des Moines IOWA 10 Hour Days
542387 Med Surg Des Moines IOWA 12 Hour Days
542466 Neurology Des Moines IOWA 12 Hour Nights
546461 ER Des Moines IOWA 12 Hour Days
546462 ER Des Moines IOWA 12 Hour Days
546635 ER Des Moines IOWA 12 Hour Nights
546913 ER Des Moines IOWA 12 Hour Days
547120 Neurology Des Moines IOWA 12 Hour Nights
547122 Med Surg Des Moines IOWA 12 Hour Nights
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.6388 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 900,100 in 1.5681 seconds