Listing all records

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

ID Job Specialty City State Shift Title
548185 Surgical Tech CVOR Morgantown WEST VIRGINIA 12 Hour Day/Night Rotate CST/Certified Surgical Technician
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
548195 Surgical Tech CVOR York PENNSYLVANIA 12 Hour Days CST/Certified Surgical Technician
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
548200 Respiratory Therapist Mesa ARIZONA 12 Hour Days Respiratory Therapist
548201 Medical Assistant Longview WASHINGTON 8 Hour Days Medical Assistant
548202 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548203 Technician Hartford CONNECTICUT 8 Hour Days Tech/Technologist
548205 CNA Oneonta NEW YORK 8 Hour Evenings CNA/Certified Nursing Assistant
548206 CNA Oneonta NEW YORK 8 Hour Evenings CNA/Certified Nursing Assistant
548207 ER Mission Hills CALIFORNIA 12 Hour Evenings RN/Registered Nurse
548208 CVICU Santa Clara CALIFORNIA 12 Hour Days RN/Registered Nurse
548209 OB South Charleston WEST VIRGINIA 10 Hour Days CNA/Certified Nursing Assistant
548210 CNA South Charleston WEST VIRGINIA 10 Hour Days CNA/Certified Nursing Assistant
548211 RRT- Respiratory Claremont NEW HAMPSHIRE 12 Hour Nights Respiratory Therapist
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
548220 CNA Camarillo CALIFORNIA 12 Hour Days CNA/Certified Nursing Assistant
548221 Social Worker Greensboro NORTH CAROLINA 8 Hour Days Social Worker
548222 Certified Surgical Tech Sun City ARIZONA 10 Hour Days CST/Certified Surgical Technician
548223 Psych Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548224 ER Rockville MARYLAND 12 Hour Nights RN/Registered Nurse
548225 CST Lebanon NEW HAMPSHIRE 10 Hour Days CST/Certified Surgical Technician
548226 CST Peoria ILLINOIS 10 Hour Days CST/Certified Surgical Technician
548227 First Assist Peterborough NEW HAMPSHIRE 8 Hour Days RN/Registered Nurse
548228 EP Tech Evanston ILLINOIS 8 Hour Days Advanced Practice
548229 ICU Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548230 CNA Sacramento CALIFORNIA 8 Hour Evenings CNA/Certified Nursing Assistant
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
548239 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548240 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548241 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548242 Med Surg Peterborough NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548243 Surgical Tech Wenatchee WASHINGTON 12 Hour Days ORT/Operating Room Technician
548244 Surgical Tech GILBERT ARIZONA 12 Hour Nights Tech/Technologist
548245 Surgical Tech Gilbert ARIZONA 12 Hour Nights RN/Registered Nurse
548246 Med Surg Tele CARMICHAEL CALIFORNIA 12 Hour Nights RN/Registered Nurse
548247 ER Artesia NEW MEXICO 12 Hour Nights RN/Registered Nurse
548248 ER Keene NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548249 Med Surg Pontiac MICHIGAN 12 Hour Days RN/Registered Nurse
548250 CST Pontiac MICHIGAN 8 Hour Days CST/Certified Surgical Technician
548251 ICU Seattle WASHINGTON 12 Hour Days RN/Registered Nurse
548252 ICU - Per Diem Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
548253 Neuro Intensive Care Boston MASSACHUSETTS 12 Hour Days RN/Registered Nurse
548254 Home Health Santa Rosa CALIFORNIA 8 Hour Days RN/Registered Nurse
548256 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548257 PACU Lynwood CALIFORNIA 12 Hour Days RN/Registered Nurse
548258 PACU Lynwood CALIFORNIA 12 Hour Days RN/Registered Nurse
548259 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548261 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548262 ICU Arcata CALIFORNIA 12 Hour Days RN/Registered Nurse
548263 CNA Hampton IOWA 12 Hour Evenings CNA/Certified Nursing Assistant
548264 CNA Lowville NEW YORK 8 Hour Nights CNA/Certified Nursing Assistant
548265 ICU Columbus OHIO 12 Hour Nights RN/Registered Nurse
548266 ICU BAKERSFIELD CALIFORNIA 12 Hour Nights RN/Registered Nurse
548267 ICU Auburn NEW YORK 12 Hour Nights RN/Registered Nurse
548269 PCU Chillicothe OHIO 12 Hour Nights RN/Registered Nurse
548272 Surgical Tech Tuba City ARIZONA 10 Hour Days Tech/Technologist
548273 Surgical Tech Tuba City ARIZONA 10 Hour Days Tech/Technologist
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
548283 Nurse Practicioner Syracuse NEW YORK 8 Hour Days NP/Nurse Practitioner
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
548290 Telemetry - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548291 Telemetry - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548292 Med Surg Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548294 OR Madison WISCONSIN 12 Hour Days RN/Registered Nurse
548295 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548296 RNFA Pittsfield MASSACHUSETTS 10 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.8248 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.id asc limit 3500,100 in 1.2368 seconds