Listing all records

Displaying records 2901 through 3000 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547226 L&D Brooklyn NEW YORK 12 Hour Days
547235 NICU Brooklyn NEW YORK 12 Hour Days
547244 CT Tech Birmingham ALABAMA 10 Hour Nights
547245 Ultrasound Tech Detroit MICHIGAN 8 Hour Days
547246 Postpartum Memphis TENNESSEE 12 Hour Nights
547247 Surgical Tech Detroit MICHIGAN 8 Hour Days
547424 Long Term Care GRAND MARAIS MINNESOTA 8 Hour Nights
547255 CT Tech Mullins SOUTH CAROLINA 12 Hour Nights
547257 L&D Portland OREGON 12 Hour Nights
547258 ICU Portland OREGON 12 Hour Nights
547259 ICU Portland OREGON 12 Hour Nights
547260 ICU Portland OREGON 12 Hour Nights
547267 Med Surg Tele Glens Falls NEW YORK 12 Hour Nights
547271 PT GRAND MARAIS MINNESOTA Varied
547272 Step Down Fairmont WEST VIRGINIA 12 Hour Nights
547273 Certified Surgical Tech Peoria ILLINOIS 8 Hour Days
547274 Med Surg Glens Falls NEW YORK 12 Hour Nights
547275 CT Tech Syracuse NEW YORK 12 Hour Nights
547276 Sterile Processing Tech Muskegon MICHIGAN Nights
547277 CT Tech Sioux City IOWA 10 Hour Nights
547279 ER Muskegon MICHIGAN 12 Hour Nights
547280 ER Muskegon MICHIGAN 12 Hour Nights
547281 ICU Muskegon MICHIGAN 12 Hour Nights
547282 ICU Muskegon MICHIGAN 12 Hour Nights
547289 ER CORDOVA ALASKA 12 Hour Nights
547290 ER Norton VIRGINIA 12 Hour Days
547293 Radiology Clarkston WASHINGTON 8 Hour Days
547295 Oncology Coos Bay OREGON 10 Hour Days
547805 ER Cleveland OHIO 12 Hour Day/Night Rotate
547302 MLT York MAINE 8 Hour Day/Night Rotate
547305 PT Plains MONTANA Varied
547308 Telemetry Nampa IDAHO 12 Hour Nights
547311 Telemetry Twin Falls IDAHO 12 Hour Days
547314 Certified Surgical Tech Boise IDAHO 8 Hour Days
547316 Med Surg Boise IDAHO 12 Hour Nights
547318 ICU Meridian IDAHO 12 Hour Nights
547319 Telemetry Nampa IDAHO 12 Hour Nights
547320 First Assist Opelika ALABAMA 8 Hour Days
547321 Med Surg Tele Cuyahoga Falls OHIO 12 Hour Nights
547323 Med Surg Tele Raeford NORTH CAROLINA 12 Hour Nights
547324 Telemetry Portland OREGON 12 Hour Nights
547326 CVOR Ann Arbor MICHIGAN 10 Hour Days
547329 NICU Mission Hills CALIFORNIA 12 Hour Nights
547330 Surgical Tech Macon GEORGIA 8 Hour Days
547651 Med Surg Tele Spartanburg SOUTH CAROLINA 12 Hour Nights
547332 SLP Garden City KANSAS Varied
547339 Patient Care Coordinator Hillsboro OREGON 12 Hour Days
547340 Patient Care Coordinator Hillsboro OREGON 12 Hour Days
547341 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547342 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547343 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547344 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547347 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547348 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547349 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547351 PT Falls City NEBRASKA 8 Hour Days
547352 PT Falls City NEBRASKA 8 Hour Days
547365 RAD Tech Aspen COLORADO 8 Hour Days
547368 Home Health Sarasota FLORIDA 8 Hour Days
547369 Interventional Radiology Tech Clearwater FLORIDA 10 Hour Days
547374 PCU Albuquerque NEW MEXICO 12 Hour Days
547376 PCU Charlottesville VIRGINIA 12 Hour Nights
547377 PCU Albuquerque NEW MEXICO 12 Hour Days
547381 L&D Seattle WASHINGTON 12 Hour Days
547382 L&D Seattle WASHINGTON 12 Hour Days
547808 RAD Tech Cleveland OHIO 10 Hour Day/Night Rotate
547384 Registered Dietician Los Angeles CALIFORNIA 8 Hour Days
547385 Med Surg Missoula MONTANA 12 Hour Nights
547386 Med Surg Seattle WASHINGTON 12 Hour Nights
547389 CT Tech Cleveland OHIO 8 Hour Nights
547390 CT Tech Cleveland OHIO 8 Hour Evenings
547392 Cath Lab Cleveland OHIO Days
547393 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
547394 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
547396 Med Surg Tele Potsdam NEW YORK 12 Hour Nights
547397 SLP Pomona CALIFORNIA Days
547402 Cath Lab Tech Fort Smith ARIZONA 8 Hour Day/Night Rotate
547403 Med Surg Tele Kansas City MISSOURI 12 Hour Days
547408 Ultrasound Tech Cooperstown NEW YORK 10 Hour Days
547409 Postpartum ODESSA TEXAS 12 Hour Days
547414 NICU Bronx NEW YORK 8 Hour Days
547809 RAD Tech Cleveland OHIO 8 Hour Days
547420 Radiology New York NEW YORK Nights
547422 Med Surg Bronx NEW YORK Days
547423 Ambulatory New York NEW YORK 8 Hour Days
547425 CVOR Kingsport TENNESSEE 8 Hour Days
547426 Scrub Tech Kingsport TENNESSEE 8 Hour Days
547427 ICU York MAINE 12 Hour Nights
547431 L&D Pueblo COLORADO 12 Hour Nights
547436 CT Tech Olympia WASHINGTON 12 Hour Nights
547440 Electrophysiology Tech Birmingham ALABAMA 10 Hour Days
547442 Electrophysiology Tech San Antonio TEXAS 10 Hour Days
547444 Med Surg Bloomington INDIANA 12 Hour Nights
547445 PT Seguin TEXAS 8 Hour Days
547446 Rehab Seguin TEXAS 12 Hour Days
547448 Med Surg Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
547451 LPN/LVN Abilene TEXAS 8 Hour Day/Night Rotate
547452 Rehab Abilene TEXAS 12 Hour Day/Night Rotate
547453 Surgical Tech CVOR Abilene TEXAS 8 Hour Days
547454 ICU Abilene TEXAS 12 Hour Day/Night Rotate
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.6544 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 2900,100 in 1.6803 seconds