Listing all records

Displaying records 3501 through 3600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548138 ER Truth or Consequences NEW MEXICO 12 Hour Days RN/Registered Nurse
548139 Newborn Nursery Marion INDIANA 12 Hour Nights RN/Registered Nurse
548334 CVICU Petoskey MICHIGAN 12 Hour Nights RN/Registered Nurse
548141 L&D Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548142 OR Bakersfield CALIFORNIA 8 Hour Day/Night Rotate RN/Registered Nurse
548143 House Supervisor New York NEW YORK 8 Hour Days RN/Registered Nurse
548144 House Supervisor New York NEW YORK 8 Hour Days RN/Registered Nurse
548145 Telemetry Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548146 Med Surg Bakersfield CALIFORNIA 12 Hour Nights RN/Registered Nurse
548147 PCU Casper WYOMING 12 Hour Days RN/Registered Nurse
548148 PCU Middletown NEW YORK 12 Hour Nights RN/Registered Nurse
548149 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548150 NICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548151 L&D Silverdale WASHINGTON 12 Hour Days RN/Registered Nurse
548152 ICU Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
548154 Home Health Los Angeles Downey CALIFORNIA 8 Hour Days RN/Registered Nurse
548155 OR Coos Bay OREGON 10 Hour Days RN/Registered Nurse
548156 Med Surg Weirton WEST VIRGINIA 12 Hour Days RN/Registered Nurse
548157 Psych Cooperstown NEW YORK 12 Hour Nights RN/Registered Nurse
548336 MICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548159 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548160 Med Surg Prince Frederick MARYLAND 12 Hour Nights RN/Registered Nurse
548170 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548171 Speech Language Redding CALIFORNIA 10 Hour Days RN/Registered Nurse
548172 PT Red Bluff CALIFORNIA 8 Hour Days RN/Registered Nurse
548173 Med Surg Auburn NEW YORK 12 Hour Nights RN/Registered Nurse
548174 Psych Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548176 Med Surg Tele Syracuse NEW YORK 12 Hour Days RN/Registered Nurse
548177 ICU Rancho Cordova CALIFORNIA 12 Hour Nights RN/Registered Nurse
548358 Med Surg Tele Cooperstown NEW YORK 12 Hour Days RN/Registered Nurse
548179 Case Manager Falls Church VIRGINIA 8 Hour Days RN/Registered Nurse
548180 Pediatric ER Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
548181 ICU Redding CALIFORNIA 12 Hour Days RN/Registered Nurse
548182 CCU Pittsfield MASSACHUSETTS 12 Hour Days RN/Registered Nurse
548183 Home Health Anaheim CALIFORNIA 8 Hour Days RN/Registered Nurse
548184 Psych Salem MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
548335 Oncology Albany NEW YORK 12 Hour Nights RN/Registered Nurse
548186 Oncology SACRAMENTO CALIFORNIA 12 Hour Nights RN/Registered Nurse
548187 L&D Saratoga Springs NEW YORK 12 Hour Nights RN/Registered Nurse
548188 Med Surg Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548189 Med Surg Saratoga Springs NEW YORK 12 Hour Nights RN/Registered Nurse
548190 Psych Lewiston MAINE 12 Hour Nights RN/Registered Nurse
548191 ER New London NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548192 Case Manager BAKERSFIELD CALIFORNIA 8 Hour Days RN/Registered Nurse
548193 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548194 OR Norman OKLAHOMA 12 Hour Days RN/Registered Nurse
548337 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Nights RN/Registered Nurse
548196 ICU Ranson WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
548197 Med Surg Tele Vacaville CALIFORNIA 12 Hour Days RN/Registered Nurse
548198 ER Casa Grande ARIZONA 12 Hour Nights RN/Registered Nurse
548199 Med Surg Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548312 Oncology Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548290 Telemetry - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548202 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548329 Oncology Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548303 OR New York NEW YORK 10 Hour Days RN/Registered Nurse
548304 Psych Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548207 ER Mission Hills CALIFORNIA 12 Hour Evenings RN/Registered Nurse
548208 CVICU Santa Clara CALIFORNIA 12 Hour Days RN/Registered Nurse
548302 CCU Chillicothe OHIO 12 Hour Nights RN/Registered Nurse
548299 OR Arlington VIRGINIA 10 Hour Days RN/Registered Nurse
548311 ER Dallas TEXAS 12 Hour Nights RN/Registered Nurse
548212 CCU Redding CALIFORNIA 12 Hour Days RN/Registered Nurse
548213 ICU Arlington WASHINGTON 12 Hour Days RN/Registered Nurse
548214 Psych Peoria ILLINOIS 12 Hour Evenings RN/Registered Nurse
548215 ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548216 Med Surg Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548217 Telemetry New York NEW YORK 12 Hour Days RN/Registered Nurse
548218 Med Surg Tele Travelers Rest SOUTH CAROLINA 12 Hour Days RN/Registered Nurse
548219 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548298 Neuro Intensive Care PHOENIX ARIZONA 12 Hour Nights RN/Registered Nurse
548294 OR Madison WISCONSIN 12 Hour Days RN/Registered Nurse
548338 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548223 Psych Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548224 ER Rockville MARYLAND 12 Hour Nights RN/Registered Nurse
548339 Psych Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548340 ER Fresno CALIFORNIA 12 Hour Days RN/Registered Nurse
548227 First Assist Peterborough NEW HAMPSHIRE 8 Hour Days RN/Registered Nurse
548355 Neuro Intensive Care Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548229 ICU Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548297 Neuro Med Surg/Tele Redding CALIFORNIA 12 Hour Nights RN/Registered Nurse
548231 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548232 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548234 Psych Centreville ILLINOIS 12 Hour Nights RN/Registered Nurse
548235 ER Greensboro NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
548236 Psych New York NEW YORK 12 Hour Nights RN/Registered Nurse
548237 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548238 Neuro Intensive Care Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548274 ER Oceanside CALIFORNIA 12 Hour Nights RN/Registered Nurse
548275 MICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548276 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548279 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548281 ICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548282 ICU Lufkin TEXAS 12 Hour Nights RN/Registered Nurse
548295 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548284 CVOR Redding CALIFORNIA 12 Hour Days RN/Registered Nurse
548285 CVOR Sacramento CALIFORNIA 8 Hour Days RN/Registered Nurse
548287 Med Surg Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
548288 OR Victorville CALIFORNIA 8 Hour Days RN/Registered Nurse
548289 OR Brownwood TEXAS 8 Hour Days RN/Registered Nurse
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.8202 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.title asc limit 3500,100 in 1.4987 seconds