Listing all records

Displaying records 1701 through 1800 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
543760 Neuro Intensive Care Lynwood CALIFORNIA 12 Hour Nights
543765 ER Bristol PENNSYLVANIA 12 Hour Nights
543766 ER Bristol PENNSYLVANIA 12 Hour Nights
545909 ICU Gainesville FLORIDA 12 Hour Nights
545910 ICU Gainesville FLORIDA 12 Hour Nights
543791 Med Surg Spokane WASHINGTON 12 Hour Nights
543807 PACU Albuquerque NEW MEXICO 12 Hour Nights
543824 ER Lansing MICHIGAN 12 Hour Nights
545726 Med Surg Gainesville FLORIDA 12 Hour Nights
543882 ER Philadelphia PENNSYLVANIA 12 Hour Nights
543886 RAD Tech National City CALIFORNIA 12 Hour Nights
543887 CT Tech National City CALIFORNIA 12 Hour Nights
543890 Psych National City CALIFORNIA 12 Hour Nights
544792 Orthopedics Detroit MICHIGAN 12 Hour Nights
545308 Med Surg Olympia WASHINGTON 12 Hour Nights
545307 Med Surg Olympia WASHINGTON 12 Hour Nights
545733 Med Surg Gainesville FLORIDA 12 Hour Nights
545730 ICU Gainesville FLORIDA 12 Hour Nights
545729 Med Surg Gainesville FLORIDA 12 Hour Nights
543974 ER Newark NEW JERSEY 12 Hour Nights
544031 Telemetry Portland OREGON 12 Hour Nights
544034 PCU Spokane WASHINGTON 12 Hour Nights
544036 Step Down Lansing MICHIGAN 12 Hour Nights
544037 Step Down Lansing MICHIGAN 12 Hour Nights
544049 Med Surg Palm Springs CALIFORNIA 12 Hour Nights
544050 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
544051 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
544052 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
544060 ICU Pontiac MICHIGAN 12 Hour Nights
544067 Med Surg Tele Glens Falls NEW YORK 12 Hour Nights
544530 Med Surg Waterloo IOWA 12 Hour Nights
544091 Med Surg Norman OKLAHOMA 12 Hour Nights
544116 Telemetry Cleveland OHIO 12 Hour Nights
545936 Med Surg Gainesville FLORIDA 12 Hour Nights
545813 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545742 Med Surg Gainesville FLORIDA 12 Hour Nights
545914 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545913 ICU Gainesville FLORIDA 12 Hour Nights
544149 Long Term Care Moscow IDAHO 12 Hour Nights
544153 Med Surg Saratoga Springs NEW YORK 12 Hour Nights
544158 PACU Cleveland OHIO 12 Hour Nights
544162 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
545328 CNA Salem OREGON 12 Hour Nights
544804 ER Lumberton NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
544198 Med Surg Tele Euclid OHIO 12 Hour Nights
544199 Step Down Fayetteville NORTH CAROLINA 12 Hour Nights
544208 Med Surg Grove City OHIO 12 Hour Nights
544209 Med Surg Grove City OHIO 12 Hour Nights
547027 Long Term Care Claremont NEW HAMPSHIRE 12 Hour Nights
544215 Med Surg Tele Pueblo COLORADO 12 Hour Nights
544217 Med Surg Pella IOWA 12 Hour Nights
544222 ICU Passaic NEW JERSEY 12 Hour Nights
544225 Med Surg Dover NEW JERSEY 12 Hour Nights
545923 Med Surg Gainesville FLORIDA 12 Hour Nights
545922 Med Surg Gainesville FLORIDA 12 Hour Nights
544230 ER Denville NEW JERSEY 12 Hour Nights
544233 CCU Denville NEW JERSEY 12 Hour Nights
544242 CT Tech Reno NEVADA 12 Hour Nights
544243 CT Tech Reno NEVADA 12 Hour Nights
548321 Oncology Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
545750 Intermediate Care Gainesville FLORIDA 12 Hour Nights
544265 Respiratory Therapist Mishawaka INDIANA 12 Hour Nights
544266 Respiratory Therapist Mishawaka INDIANA 12 Hour Nights
544269 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
544270 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
545752 Med Surg Gainesville FLORIDA 12 Hour Nights
544344 L&D Ketchum IDAHO 12 Hour Nights
544354 Med Surg Meridian IDAHO 12 Hour Nights
544359 NICU Queens NEW YORK 12 Hour Nights RN/Registered Nurse
545605 ER Peoria ILLINOIS 12 Hour Nights
545773 Intermediate Care Gainesville FLORIDA 12 Hour Nights
544405 ER Walnut Creek CALIFORNIA 12 Hour Nights
544411 CT Tech New London NEW HAMPSHIRE 12 Hour Nights
544422 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
544435 ER IOWA CITY IOWA 12 Hour Nights
544436 ER IOWA CITY IOWA 12 Hour Nights
545343 PCU Concord NEW HAMPSHIRE 12 Hour Nights
545758 Med Surg Gainesville FLORIDA 12 Hour Nights
544449 Med Surg Tele Des Moines IOWA 12 Hour Nights
544450 Med Surg Tele Des Moines IOWA 12 Hour Nights
544474 ER Hilo HAWAII 12 Hour Nights
544481 Lab Tech Syracuse NEW YORK 12 Hour Nights
544499 Med Surg Tele Wailuku HAWAII 12 Hour Nights
545760 ICU Gainesville FLORIDA 12 Hour Nights
544518 PCU Fayetteville NORTH CAROLINA 12 Hour Nights
544524 Med Surg Tele Wailuku HAWAII 12 Hour Nights
544525 Telemetry Wailuku HAWAII 12 Hour Nights
544529 Med Surg Kula HAWAII 12 Hour Nights
544531 ER Des Moines IOWA 12 Hour Nights
545631 ICU Gainesville FLORIDA 12 Hour Nights
544547 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
544552 ER Newark NEW JERSEY 12 Hour Nights
544558 PCU Spokane WASHINGTON 12 Hour Nights
544566 Med Surg Portland OREGON 12 Hour Nights
544570 ICU Burbank CALIFORNIA 12 Hour Nights
544572 Step Down Willoughby OHIO 12 Hour Nights
545937 Med Surg Gainesville FLORIDA 12 Hour Nights
545764 ICU Gainesville FLORIDA 12 Hour Nights
545939 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545815 RRT- Respiratory Gainesville FLORIDA 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.5556 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 1700,100 in 1.7776 seconds