Listing all records

Displaying records 1801 through 1900 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547120 Neurology Des Moines IOWA 12 Hour Nights
547260 ICU Portland OREGON 12 Hour Nights
544265 Respiratory Therapist Mishawaka INDIANA 12 Hour Nights
544266 Respiratory Therapist Mishawaka INDIANA 12 Hour Nights
547105 Step Down Dover OHIO 12 Hour Nights
544269 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
544270 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
547122 Med Surg Des Moines IOWA 12 Hour Nights
544344 L&D Ketchum IDAHO 12 Hour Nights
547143 Neuro Med Surg/Tele Peoria ILLINOIS 12 Hour Nights
544354 Med Surg Meridian IDAHO 12 Hour Nights
544359 NICU Queens NEW YORK 12 Hour Nights RN/Registered Nurse
547257 L&D Portland OREGON 12 Hour Nights
545694 Intermediate Care Gainesville FLORIDA 12 Hour Nights
547289 ER CORDOVA ALASKA 12 Hour Nights
547259 ICU Portland OREGON 12 Hour Nights
544405 ER Walnut Creek CALIFORNIA 12 Hour Nights
545879 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
544411 CT Tech New London NEW HAMPSHIRE 12 Hour Nights
544422 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
545706 Med Surg Gainesville FLORIDA 12 Hour Nights
545705 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
544435 ER IOWA CITY IOWA 12 Hour Nights
544436 ER IOWA CITY IOWA 12 Hour Nights
547275 CT Tech Syracuse NEW YORK 12 Hour Nights
545701 RRT- Respiratory 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
545693 ICU Gainesville FLORIDA 12 Hour Nights
544499 Med Surg Tele Wailuku HAWAII 12 Hour Nights
545683 Med Surg 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
547297 Med Surg Tele Denison IOWA 12 Hour Nights
547318 ICU Meridian IDAHO 12 Hour Nights
544529 Med Surg Kula HAWAII 12 Hour Nights
544531 ER Des Moines IOWA 12 Hour Nights
544547 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
544552 ER Newark NEW JERSEY 12 Hour Nights
545635 Med Surg Gainesville FLORIDA 12 Hour Nights
545711 ICU Gainesville FLORIDA 12 Hour Nights
544558 PCU Spokane WASHINGTON 12 Hour Nights
545720 ICU Gainesville FLORIDA 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
547456 Neuro Med Surg/Tele Abilene TEXAS 12 Hour Nights
547481 ER Manchester CONNECTICUT 12 Hour Nights
545723 Med Surg Gainesville FLORIDA 12 Hour Nights
544627 Med Surg Tele Akron OHIO 12 Hour Nights
544628 Psych Cleveland OHIO 12 Hour Nights
544632 ER Machias MAINE 12 Hour Nights
547383 L&D Seattle WASHINGTON 12 Hour Nights
547386 Med Surg Seattle WASHINGTON 12 Hour Nights
547376 PCU Charlottesville VIRGINIA 12 Hour Nights
544652 Med Surg Alamosa COLORADO 12 Hour Nights
544658 Med Surg Fayetteville NORTH CAROLINA 12 Hour Nights
544667 Med Surg Fayetteville NORTH CAROLINA 12 Hour Nights
545883 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
544705 ER Des Moines IOWA 12 Hour Nights
547431 L&D Pueblo COLORADO 12 Hour Nights
544750 Med Surg Tele Everett WASHINGTON 12 Hour Nights
544751 Med Surg Tele Everett WASHINGTON 12 Hour Nights
544792 Orthopedics Detroit MICHIGAN 12 Hour Nights
545730 ICU Gainesville FLORIDA 12 Hour Nights
545728 Med Surg Gainesville FLORIDA 12 Hour Nights
544804 ER Lumberton NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
544819 ER Schenectady NEW YORK 12 Hour Nights
545825 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545824 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
547531 L&D Arcata CALIFORNIA 12 Hour Nights
544853 Med Surg Kingsport TENNESSEE 12 Hour Nights
547457 ICU Abilene TEXAS 12 Hour Nights
544870 ICU Oxford NORTH CAROLINA 12 Hour Nights
544871 ICU Oxford NORTH CAROLINA 12 Hour Nights
544876 Med Surg Tele Portland OREGON 12 Hour Nights
544877 Med Surg Tele Portland OREGON 12 Hour Nights
544894 Respiratory Therapist Newark NEW JERSEY 12 Hour Nights
547471 Med Surg Prince Frederick MARYLAND 12 Hour Nights
546335 Psych Wailuku HAWAII 12 Hour Nights
544896 OR Santa Monica CALIFORNIA 12 Hour Nights
545727 Med Surg Gainesville FLORIDA 12 Hour Nights
545827 Med Surg Gainesville FLORIDA 12 Hour Nights
544908 ER Oceanside CALIFORNIA 12 Hour Nights
545738 ICU Gainesville FLORIDA 12 Hour Nights
545737 ICU Gainesville FLORIDA 12 Hour Nights
544918 Step Down Parma OHIO 12 Hour Nights
544937 Med Surg Detroit MICHIGAN 12 Hour Nights
544952 Med Surg Boise IDAHO 12 Hour Nights
544954 Telemetry Twin Falls IDAHO 12 Hour Nights
545726 Med Surg Gainesville FLORIDA 12 Hour Nights
545709 ICU Gainesville FLORIDA 12 Hour Nights
544995 PCU Omaha NEBRASKA 12 Hour Nights
544996 CT Tech Omaha NEBRASKA 12 Hour Nights
545003 PCU Palm Springs CALIFORNIA 12 Hour Nights
545035 PCU Concord NEW HAMPSHIRE 12 Hour Nights
546819 Med Surg Tele Canton OHIO 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 2.5687 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 desc limit 1800,100 in 1.7231 seconds