Listing all records

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

ID Job Specialty City State Shift Title
546742 Telemetry Charleston WEST VIRGINIA 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
546760 ER Auburn NEW YORK 12 Hour Nights
543890 Psych National City CALIFORNIA 12 Hour Nights
545705 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
546733 Telemetry Everett WASHINGTON 12 Hour Nights
545515 L&D Arcata CALIFORNIA 12 Hour Nights
545328 CNA Salem OREGON 12 Hour Nights
543974 ER Newark NEW JERSEY 12 Hour Nights
545706 Med Surg Gainesville FLORIDA 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
546812 Med Surg Harrison ARKANSAS 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
545709 ICU Gainesville FLORIDA 12 Hour Nights
544116 Telemetry Cleveland OHIO 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
544198 Med Surg Tele Euclid OHIO 12 Hour Nights
544199 Step Down Fayetteville NORTH CAROLINA 12 Hour Nights
545711 ICU Gainesville FLORIDA 12 Hour Nights
545579 ER Willoughby OHIO 12 Hour Nights
546859 Telemetry Everett WASHINGTON 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
545712 Med Surg Gainesville FLORIDA 12 Hour Nights
544215 Med Surg Tele Pueblo COLORADO 12 Hour Nights
544217 Med Surg Pella IOWA 12 Hour Nights
545773 Intermediate Care Gainesville FLORIDA 12 Hour Nights
546880 Med Surg Show Low ARIZONA 12 Hour Nights RN/Registered Nurse
544222 ICU Passaic NEW JERSEY 12 Hour Nights
544225 Med Surg Dover NEW JERSEY 12 Hour Nights
544230 ER Denville NEW JERSEY 12 Hour Nights
546899 Telemetry Spokane WASHINGTON 12 Hour Nights
544233 CCU Denville NEW JERSEY 12 Hour Nights
546898 Telemetry Cleveland OHIO 12 Hour Nights
545605 ER Peoria ILLINOIS 12 Hour Nights
546904 Telemetry Cleveland OHIO 12 Hour Nights
546903 Med Surg Tele Canton OHIO 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
545597 Med Surg Peoria ILLINOIS 12 Hour Nights
546925 ER East Norriton PENNSYLVANIA 12 Hour Nights
545714 ICU Gainesville FLORIDA 12 Hour Nights
544265 Respiratory Therapist Mishawaka INDIANA 12 Hour Nights
544266 Respiratory Therapist Mishawaka INDIANA 12 Hour Nights
546923 CT Tech Ann Arbor MICHIGAN 12 Hour Nights
544269 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
544270 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
546926 MICU San Dimas CALIFORNIA 12 Hour Nights
544344 L&D Ketchum IDAHO 12 Hour Nights
546934 RAD Tech Dubuque IOWA 12 Hour Nights
544354 Med Surg Meridian IDAHO 12 Hour Nights
544359 NICU Queens NEW YORK 12 Hour Nights RN/Registered Nurse
545619 Med Surg Gainesville FLORIDA 12 Hour Nights
546943 Med Surg Tele Cleveland OHIO 12 Hour Nights
544405 ER Walnut Creek CALIFORNIA 12 Hour Nights
545776 Pediatric ER 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
545778 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
546686 PCU San Luis Obispo CALIFORNIA 12 Hour Nights
544435 ER IOWA CITY IOWA 12 Hour Nights
544436 ER IOWA CITY IOWA 12 Hour Nights
546971 Radiology PHOENIX ARIZONA 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
545771 Intermediate Care 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
546993 Med Surg Troy NEW YORK 12 Hour Nights
547008 Oncology Everett WASHINGTON 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
545621 ER Massena NEW YORK 12 Hour Nights
544558 PCU Spokane WASHINGTON 12 Hour Nights
545620 Med Surg Gainesville FLORIDA 12 Hour Nights
544566 Med Surg Portland OREGON 12 Hour Nights
544570 ICU Burbank CALIFORNIA 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.2734 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 1700,100 in 1.218 seconds