Listing all records

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

ID Job Specialty City State Shift Title
546163 L&D Seattle WASHINGTON 12 Hour Nights
544230 ER Denville NEW JERSEY 12 Hour Nights
546172 Med Surg Tele Gallipolis OHIO 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
546167 Med Surg Tele Dothan ALABAMA 12 Hour Nights
548321 Oncology Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
545848 RRT- Respiratory 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
545649 RAD Tech Gainesville FLORIDA 12 Hour Nights
545851 ICU Gainesville FLORIDA 12 Hour Nights
545849 Med Surg Gainesville FLORIDA 12 Hour Nights
546186 Med Surg Tele Cleveland OHIO 12 Hour Nights
545731 ICU 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
545712 Med Surg Gainesville FLORIDA 12 Hour Nights
545128 Med Surg Albuquerque NEW MEXICO 12 Hour Nights
546192 ICU - Per Diem Irvine CALIFORNIA 12 Hour Nights RN/Registered Nurse
545652 Med Surg 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
545732 ICU 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
545655 Med Surg Gainesville FLORIDA 12 Hour Nights
545654 Med Surg Gainesville FLORIDA 12 Hour Nights
545262 PCU Omaha NEBRASKA 12 Hour Nights
544499 Med Surg Tele Wailuku HAWAII 12 Hour Nights
545857 Med Surg Gainesville FLORIDA 12 Hour Nights
545860 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
544529 Med Surg Kula HAWAII 12 Hour Nights
544531 ER Des Moines IOWA 12 Hour Nights
545226 Cardiac Telemetry Farmington NEW MEXICO 12 Hour Nights
545733 Med Surg 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
546217 PCU Sun City ARIZONA 12 Hour Nights
546225 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
546223 ICU Ann Arbor MICHIGAN 12 Hour Nights
545913 ICU Gainesville FLORIDA 12 Hour Nights
545867 Cardiology 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
546228 Pediatrics Concord NEW HAMPSHIRE 12 Hour Nights
545714 ICU Gainesville FLORIDA 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
544705 ER Des Moines IOWA 12 Hour Nights
544750 Med Surg Tele Everett WASHINGTON 12 Hour Nights
544751 Med Surg Tele Everett WASHINGTON 12 Hour Nights
546245 Neuro Intensive Care Seattle WASHINGTON 12 Hour Nights
544792 Orthopedics Detroit MICHIGAN 12 Hour Nights
544804 ER Lumberton NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
545871 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
544819 ER Schenectady NEW YORK 12 Hour Nights
545231 Telemetry Cleveland OHIO 12 Hour Nights
544853 Med Surg Kingsport TENNESSEE 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
546335 Psych Wailuku HAWAII 12 Hour Nights
544896 OR Santa Monica CALIFORNIA 12 Hour Nights
545716 ICU Gainesville FLORIDA 12 Hour Nights
544908 ER Oceanside CALIFORNIA 12 Hour Nights
545877 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
544918 Step Down Parma OHIO 12 Hour Nights
545737 ICU Gainesville FLORIDA 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
545232 Step Down Cleveland OHIO 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
545080 ER Pueblo COLORADO 12 Hour Nights
546264 ER Robbinsdale MINNESOTA 12 Hour Nights
546270 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
545035 PCU Concord NEW HAMPSHIRE 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.6013 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 1800,100 in 1.4281 seconds