Listing all records

Displaying records 2801 through 2900 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547031 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547032 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547033 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547034 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547035 Med Surg Tele Auburn NEW YORK 12 Hour Nights
548160 Med Surg Prince Frederick MARYLAND 12 Hour Nights RN/Registered Nurse
547043 Med Surg Tele Beachwood OHIO 12 Hour Nights
548379 Postpartum Fresno CALIFORNIA 12 Hour Nights RN/Registered Nurse
547046 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
548014 Long Term Care Kane PENNSYLVANIA 12 Hour Nights
547127 Med Surg Coos Bay OREGON 12 Hour Nights
547066 PCU Rio Rancho NEW MEXICO 12 Hour Nights
547068 CT Tech Pella IOWA 12 Hour Nights
547069 Step Down Johnson City TENNESSEE 12 Hour Nights
547076 CT Tech Farmington CONNECTICUT 12 Hour Nights
547077 CT Tech Farmington CONNECTICUT 12 Hour Nights
547084 ICU Pendleton OREGON 12 Hour Nights
547085 ICU Pendleton OREGON 12 Hour Nights
547086 Med Surg Pendleton OREGON 12 Hour Nights
547087 Med Surg Pendleton OREGON 12 Hour Nights
547089 Med Surg Portland OREGON 12 Hour Nights
548005 Med Surg Tele Des Moines IOWA 12 Hour Nights
547104 Med Surg Tele Cleveland OHIO 12 Hour Nights
547105 Step Down Dover OHIO 12 Hour Nights
547106 Med Surg Tele Akron OHIO 12 Hour Nights
547107 Step Down Cleveland OHIO 12 Hour Nights
547108 Clinic Cleveland OHIO 12 Hour Nights
547120 Neurology Des Moines IOWA 12 Hour Nights
547122 Med Surg Des Moines IOWA 12 Hour Nights
547123 Med Surg Des Moines IOWA 12 Hour Nights
547124 Orthopedics Des Moines IOWA 12 Hour Nights
547125 Orthopedics Des Moines IOWA 12 Hour Nights
547796 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
547138 ER Arlington WASHINGTON 12 Hour Nights
547143 Neuro Med Surg/Tele Peoria ILLINOIS 12 Hour Nights
547183 OR Brooklyn NEW YORK 12 Hour Nights
503607 CT Tech Nome ALASKA 12 Hour Day/Night Rotate
517887 CRNA Alturas CALIFORNIA 12 Hour Day/Night Rotate
541929 Management Corvallis OREGON 12 Hour Day/Night Rotate
542655 Long Term Care Hilo HAWAII 12 Hour Day/Night Rotate
547646 L&D Seaside OREGON 12 Hour Day/Night Rotate
525386 Vascular Ultrasound Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
534500 PTA Jacksonville ILLINOIS 12 Hour Day/Night Rotate
548185 Surgical Tech CVOR Morgantown WEST VIRGINIA 12 Hour Day/Night Rotate CST/Certified Surgical Technician
534694 Psych Woodsville NEW HAMPSHIRE 12 Hour Day/Night Rotate
547696 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547709 Pediatrics Alturas CALIFORNIA 12 Hour Day/Night Rotate
534972 CT Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
535045 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
535334 SLP Pasco WASHINGTON 12 Hour Day/Night Rotate
540104 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
547878 Echo Technologist Abilene TEXAS 12 Hour Day/Night Rotate
540152 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
547805 ER Cleveland OHIO 12 Hour Day/Night Rotate
548030 Sterile Processing Technician Wenatchee WASHINGTON 12 Hour Day/Night Rotate
543778 RAD Tech San Diego CALIFORNIA 12 Hour Day/Night Rotate
543785 Scrub Tech Redding CALIFORNIA 12 Hour Day/Night Rotate
544144 Med Surg Tele Glenwood Springs COLORADO 12 Hour Day/Night Rotate
544145 Med Surg Tele Glenwood Springs COLORADO 12 Hour Day/Night Rotate
544897 CNA Breckenridge MINNESOTA 12 Hour Day/Night Rotate
544167 PT Garden City KANSAS 12 Hour Day/Night Rotate
544224 Dialysis Dover NEW JERSEY 12 Hour Day/Night Rotate
544226 MLT Denville NEW JERSEY 12 Hour Day/Night Rotate
544228 CT Tech Denville NEW JERSEY 12 Hour Day/Night Rotate
544229 Dialysis Denville NEW JERSEY 12 Hour Day/Night Rotate
544232 ER Denville NEW JERSEY 12 Hour Day/Night Rotate
544245 CVOR Reno NEVADA 12 Hour Day/Night Rotate
544288 Dialysis Honolulu HAWAII 12 Hour Day/Night Rotate
544312 BMT Cleveland OHIO 12 Hour Day/Night Rotate
544313 Telemetry Cleveland OHIO 12 Hour Day/Night Rotate
544399 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
548080 CVICU Boston MASSACHUSETTS 12 Hour Day/Night Rotate RN/Registered Nurse
544574 ICU Cleveland OHIO 12 Hour Day/Night Rotate
544586 Medical Assistant Claremont NEW HAMPSHIRE 12 Hour Day/Night Rotate
545524 Postpartum Hilo HAWAII 12 Hour Day/Night Rotate
544604 Surgical Tech Duluth MINNESOTA 12 Hour Day/Night Rotate
546061 Intermediate Care Hilo HAWAII 12 Hour Day/Night Rotate
547817 Respiratory Therapist Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
544680 ER Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
544775 CT Tech Berlin NEW HAMPSHIRE 12 Hour Day/Night Rotate
544788 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
544789 CNA Kealakekua HAWAII 12 Hour Day/Night Rotate
544817 OR Albany NEW YORK 12 Hour Day/Night Rotate
544884 CT Tech Nome ALASKA 12 Hour Day/Night Rotate
548098 Med Surg Tele Chandler ARIZONA 12 Hour Day/Night Rotate RN/Registered Nurse
547879 Med Surg Kealakekua HAWAII 12 Hour Day/Night Rotate
544977 Scrub Tech Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
545026 OR Albany NEW YORK 12 Hour Day/Night Rotate
545058 ER Dickinson NORTH DAKOTA 12 Hour Day/Night Rotate
545079 ER Pueblo COLORADO 12 Hour Day/Night Rotate
545149 Med Surg Hettinger NORTH DAKOTA 12 Hour Day/Night Rotate
545185 CVOR Houston TEXAS 12 Hour Day/Night Rotate
545243 Scrub Tech The Dalles OREGON 12 Hour Day/Night Rotate
545244 Echo Technologist Tulsa OKLAHOMA 12 Hour Day/Night Rotate
547735 Neuro Intensive Care Palo Alto CALIFORNIA 12 Hour Day/Night Rotate
545342 Home Health Rockford ILLINOIS 12 Hour Day/Night Rotate
547838 Postpartum Albany OREGON 12 Hour Day/Night Rotate
545390 CT Tech Berlin NEW HAMPSHIRE 12 Hour Day/Night Rotate
545468 ICU Tuba City ARIZONA 12 Hour Day/Night Rotate
545470 Ultrasound Tech Greenbrae CALIFORNIA 12 Hour Day/Night Rotate
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.6157 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 a.shift asc limit 2800,100 in 1.3915 seconds