Listing all records

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

ID Job Specialty City State Shift Title
542687 RAD Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
542908 ICU Cleveland OHIO 12 Hour Day/Night Rotate
542986 RAD Tech Tuba City ARIZONA 12 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
543044 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
543332 CT Tech Waimea HAWAII 12 Hour Day/Night Rotate
547952 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
543387 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
543439 L&D Dickinson NORTH DAKOTA 12 Hour Day/Night Rotate
543486 Echo Waimea HAWAII 12 Hour Day/Night Rotate
543510 Ultrasound Tech Phoenix ARIZONA 12 Hour Day/Night Rotate
543593 Med Surg Cincinnati OHIO 12 Hour Day/Night Rotate
543679 RN House Supervisor Honolulu HAWAII 12 Hour Day/Night Rotate
543693 Med Surg Tele Laconia NEW HAMPSHIRE 12 Hour Day/Night Rotate
543695 L&D WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
543725 OR Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
543750 CLS Reno NEVADA 12 Hour Day/Night Rotate
543777 RAD Tech San Diego CALIFORNIA 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
547583 Dialysis WILLISON NORTH DAKOTA 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
548185 Surgical Tech CVOR Morgantown WEST VIRGINIA 12 Hour Day/Night Rotate CST/Certified Surgical Technician
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
547963 Med Surg Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
544399 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547838 Postpartum Albany OREGON 12 Hour Day/Night Rotate
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
547967 ER Madison WISCONSIN 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
547566 ER Watertown NEW YORK 12 Hour Day/Night Rotate
544884 CT Tech Nome ALASKA 12 Hour Day/Night Rotate
548002 ICU Gillette WYOMING 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
547879 Med Surg Kealakekua HAWAII 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
545342 Home Health Rockford ILLINOIS 12 Hour Day/Night Rotate
545390 CT Tech Berlin NEW HAMPSHIRE 12 Hour Day/Night Rotate
548350 CVOR Falls Church VIRGINIA 12 Hour Day/Night Rotate RN/Registered Nurse
545468 ICU Tuba City ARIZONA 12 Hour Day/Night Rotate
545470 Ultrasound Tech Greenbrae CALIFORNIA 12 Hour Day/Night Rotate
545560 Scrub Tech Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
547576 ER Watertown NEW YORK 12 Hour Day/Night Rotate
546255 PT Falls River MASSACHUSETTS 12 Hour Day/Night Rotate
546277 RAD Tech Albany OREGON 12 Hour Day/Night Rotate
546307 ER Watertown NEW YORK 12 Hour Day/Night Rotate
546308 ER Watertown NEW YORK 12 Hour Day/Night Rotate
546379 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546380 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
546381 Paramedic Lewisburg PENNSYLVANIA 12 Hour Day/Night Rotate
546474 CVOR Corvallis OREGON 12 Hour Day/Night Rotate
546455 Med Surg Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
546459 Orthopedics Madison WISCONSIN 12 Hour Day/Night Rotate
546639 Cardiac ICU Falls Church VIRGINIA 12 Hour Day/Night Rotate
547696 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
546660 OR Pueblo COLORADO 12 Hour Day/Night Rotate
546680 Pharmacist Tuba City ARIZONA 12 Hour Day/Night Rotate
546738 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546785 Med Surg IOWA CITY IOWA 12 Hour Day/Night Rotate
546794 Med Surg Tele Madison WISCONSIN 12 Hour Day/Night Rotate
546832 Therapy Rehab Spring Valley ILLINOIS 12 Hour Day/Night Rotate
546835 Registered Dietician Waimea HAWAII 12 Hour Day/Night Rotate
546866 Surgical Tech Mammoth Lakes CALIFORNIA 12 Hour Day/Night Rotate
546869 Vascular Ultrasound Tech Hilo HAWAII 12 Hour Day/Night Rotate
546870 Vascular Ultrasound Tech Hilo HAWAII 12 Hour Day/Night Rotate
546927 ER Kaunakakai HAWAII 12 Hour Day/Night Rotate
546940 Psych Kealakekua HAWAII 12 Hour Day/Night Rotate
547026 ICU Santa Fe NEW MEXICO 12 Hour Day/Night Rotate
548028 CT Tech Pagosa Springs COLORADO 12 Hour Day/Night Rotate
547117 Cardiovascular York PENNSYLVANIA 12 Hour Day/Night Rotate
547393 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
547448 Med Surg Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
547452 Rehab Abilene TEXAS 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.452 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 2900,100 in 1.5988 seconds