Listing all records

Displaying records 2701 through 2800 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
535227 Orthopedics Des Moines IOWA 12 Hour Nights
537419 Med Surg Tele Des Moines IOWA 12 Hour Nights
537420 Med Surg Tele Des Moines IOWA 12 Hour Nights
537423 Neurology Des Moines IOWA 12 Hour Nights
537424 Neurology Des Moines IOWA 12 Hour Nights
537431 Med Surg Des Moines IOWA 12 Hour Nights
537432 Med Surg Des Moines IOWA 12 Hour Nights
537922 Neuro Med Surg/Tele Des Moines IOWA 12 Hour Nights
538590 ER Des Moines IOWA 12 Hour Nights
539078 MLT Des Moines IOWA 8 Hour Days
539093 MLT Des Moines IOWA 12 Hour Days
539095 MLT Des Moines IOWA 8 Hour Days
539670 Med Surg Tele Des Moines IOWA 12 Hour Nights
539713 Oncology Des Moines IOWA 12 Hour Nights
539714 Oncology Des Moines IOWA 12 Hour Nights
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
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
548308 ER Deridder LOUISIANA 12 Hour Nights RN/Registered Nurse
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
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
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
547297 Med Surg Tele Denison IOWA 12 Hour Nights
542596 Interventional Radiology Tech Daytona Beach FLORIDA 8 Hour Days
547888 Cath Lab Danville KENTUCKY 10 Hour Days
544485 SLP Danvers MASSACHUSETTS Days
547883 PTA Daly City CALIFORNIA Days
548311 ER Dallas TEXAS 12 Hour Nights RN/Registered Nurse
547321 Med Surg Tele Cuyahoga Falls OHIO 12 Hour Nights
543900 CT Tech Culbertson MONTANA Days
544489 CT Tech Culbertson MONTANA Days
476614 PT Crownsville MARYLAND Days
539873 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
545067 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
548011 SLP Crescent City CALIFORNIA 8 Hour Days
548012 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
543633 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
543904 PT Crescent City CALIFORNIA 8 Hour Days
548019 CNA Corvallis OREGON 12 Hour Day/Night Rotate
541929 Management Corvallis OREGON 12 Hour Day/Night Rotate
545083 Cath Lab Corvallis OREGON 8 Hour Day/Night Rotate
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
547289 ER CORDOVA ALASKA 12 Hour Nights
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
545140 PCU Coos Bay OREGON 12 Hour Nights
545389 Cardiology Coos Bay OREGON 8 Hour Days
546181 SLP Cooperstown NEW YORK 8 Hour Days
547408 Ultrasound Tech Cooperstown NEW YORK 10 Hour Days
547757 Outpatient Clinic 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
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
547522 CT Tech Cook MINNESOTA 12 Hour Day/Night Rotate
465120 Long Term Care Conrad MONTANA 8 Hour Evenings
487151 Long Term Care Conrad MONTANA 12 Hour Day/Night Rotate
534238 Med Surg Tele Concord CALIFORNIA 8 Hour Days
535905 Psych Concord CALIFORNIA 8 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.3619 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 2700,100 in 1.5278 seconds