Listing all records

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

ID Job Specialty City State Shift Title
545311 ICU Colville WASHINGTON 12 Hour Nights
544235 Sterile Processing Tech Denville NEW JERSEY 8 Hour Days
544240 RAD Tech Reno NEVADA 12 Hour Days
544241 RAD Tech Reno NEVADA 12 Hour Days
544242 CT Tech Reno NEVADA 12 Hour Nights
544243 CT Tech Reno NEVADA 12 Hour Nights
544245 CVOR Reno NEVADA 12 Hour Day/Night Rotate
545125 RAD Tech Gig Harbor WASHINGTON 8 Hour Day/Night Rotate
544251 OR Farmington CONNECTICUT 10 Hour Days
545273 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Days
544263 Surgical Tech Westerville OHIO 12 Hour Days
544264 RAD Tech Silver Spring MARYLAND 8 Hour Evenings
544265 Respiratory Therapist Mishawaka INDIANA 12 Hour Nights
544266 Respiratory Therapist Mishawaka INDIANA 12 Hour Nights
544267 Med Surg Tele Syracuse NEW YORK 12 Hour Days
544268 Med Surg Tele Syracuse NEW YORK 12 Hour Days
544269 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
544270 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
544288 Dialysis Honolulu HAWAII 12 Hour Day/Night Rotate
544290 Infusion Oncology Sidney MONTANA Days
544293 OR Maywood ILLINOIS 10 Hour Days
544294 OR Maywood ILLINOIS 10 Hour Days
544303 Ultrasound Tech Portland OREGON 10 Hour Days
544310 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
544311 Cath Lab Charleston WEST VIRGINIA 12 Hour Days
544312 BMT Cleveland OHIO 12 Hour Day/Night Rotate
544313 Telemetry Cleveland OHIO 12 Hour Day/Night Rotate
544316 Cath Lab Willoughby OHIO 10 Hour Days
544343 CT Tech Boise IDAHO 10 Hour Nights
544344 L&D Ketchum IDAHO 12 Hour Nights
545314 Interventional Radiology SANTA ROSA CALIFORNIA Days
544347 Certified Surgical Tech Lewiston IDAHO 10 Hour Days
544354 Med Surg Meridian IDAHO 12 Hour Nights
546423 PT Hayward CALIFORNIA 8 Hour Days
544768 OR ODESSA TEXAS 12 Hour Days
544376 Sterile Processing Technician Langhorne PENNSYLVANIA Nights
544377 Ultrasound Tech Silver Spring MARYLAND 8 Hour Evenings
544378 Ultrasound Tech Silver Spring MARYLAND 8 Hour Days
544388 ICU Scottsbluff NEBRASKA 12 Hour Varied
544389 Lab Tech Syracuse NEW YORK 8 Hour Days
544390 Lab Tech Syracuse NEW YORK 8 Hour Days
545112 PT Salem OREGON Days
544399 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
544403 First Assist Lancaster OHIO Days
544405 ER Walnut Creek CALIFORNIA 12 Hour Nights
544409 CT Tech Springfield VERMONT 8 Hour Nights
545315 CT Tech Eureka CALIFORNIA 10 Hour Days
544422 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
545252 GI Lab Mason City IOWA 8 Hour Days
544433 Ambulatory Syracuse NEW YORK 8 Hour Days
544435 ER IOWA CITY IOWA 12 Hour Nights
544436 ER IOWA CITY IOWA 12 Hour Nights
544437 ER IOWA CITY IOWA 12 Hour Days
544441 Therapy Rehab Baltimore MARYLAND Days
544444 PT Santa Clara CALIFORNIA 10 Hour Days
544446 MLT Los Angeles CALIFORNIA 8 Hour Days
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
544482 OR Germantown MARYLAND 8 Hour Days
544485 SLP Danvers MASSACHUSETTS Days
544489 CT Tech Culbertson MONTANA Days
544493 Ultrasound Tech Prescott ARIZONA 10 Hour Evenings
544499 Med Surg Tele Wailuku HAWAII 12 Hour Nights
544502 Interventional Radiology Tech Fayetteville NORTH CAROLINA 10 Hour Days
544504 PT Everett WASHINGTON 8 Hour Days
545316 SLP Eureka CALIFORNIA 8 Hour Days
544509 Cath Lab Edgewood KENTUCKY 10 Hour Days
544514 CT Tech Vernon Rockville CONNECTICUT 8 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
544526 Step Down Wailuku HAWAII 12 Hour Days
544527 Med Surg Tele Wailuku HAWAII 12 Hour Days
544529 Med Surg Kula HAWAII 12 Hour Nights
544531 ER Des Moines IOWA 12 Hour Nights
547870 Med Surg Tele Rome NEW YORK 10 Hour Nights
544535 Psych Fort Defiance ARIZONA 12 Hour Varied
544536 PCU Hilo HAWAII Varied
544543 CT Tech Riverhead NEW YORK 10 Hour Nights
544547 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
545331 PT Sumter SOUTH CAROLINA Days
544553 Cath Lab Passaic NEW JERSEY 8 Hour Days
544557 Cath Lab Burbank CALIFORNIA 8 Hour Days
544558 PCU Spokane WASHINGTON 12 Hour Nights
544562 OR Oregon City OREGON 10 Hour Day/Night Rotate
544565 Outpatient Clinic Portland OREGON 8 Hour Days
544566 Med Surg Portland OREGON 12 Hour Nights
544570 ICU Burbank CALIFORNIA 12 Hour Nights
544572 Step Down Willoughby OHIO 12 Hour Nights
544574 ICU Cleveland OHIO 12 Hour Day/Night Rotate
544586 Medical Assistant Claremont NEW HAMPSHIRE 12 Hour Day/Night Rotate
544595 Surgical Tech Anchorage ALASKA 10 Hour Days
545524 Postpartum Hilo HAWAII 12 Hour Day/Night Rotate
544598 MLT Des Moines IOWA 8 Hour Days
544604 Surgical Tech Duluth MINNESOTA 12 Hour Day/Night Rotate
544608 SLP Syracuse NEW YORK 8 Hour Days
544615 OR Duluth MINNESOTA 8 Hour Day/Night Rotate
544617 Scrub Tech Rio Rancho NEW MEXICO 10 Hour Days
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.4715 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 1700,100 in 1.5881 seconds