Listing all records

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

ID Job Specialty City State Shift Title
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
544508 Cath Lab Edgewood KENTUCKY 10 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
544530 Med Surg Waterloo IOWA 12 Hour Nights
544531 ER Des Moines IOWA 12 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
544552 ER Newark NEW JERSEY 12 Hour Nights
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
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
544626 Echo Toledo OHIO 8 Hour Days
544627 Med Surg Tele Akron OHIO 12 Hour Nights
544628 Psych Cleveland OHIO 12 Hour Nights
544632 ER Machias MAINE 12 Hour Nights
544634 APRN Stanley WISCONSIN Days
544636 Interventional Radiology Tech PHOENIX ARIZONA 12 Hour Days
544641 PT Monterey CALIFORNIA Days
544644 OR Silver Spring MARYLAND 12 Hour Days
544645 OR Silver Spring MARYLAND 12 Hour Days
544646 OR Silver Spring MARYLAND 12 Hour Days
544647 OR Silver Spring MARYLAND 12 Hour Days
544648 OR Silver Spring MARYLAND Nights
544649 OR Silver Spring MARYLAND Nights
544652 Med Surg Alamosa COLORADO 12 Hour Nights
544658 Med Surg Fayetteville NORTH CAROLINA 12 Hour Nights
544667 Med Surg Fayetteville NORTH CAROLINA 12 Hour Nights
544670 RAD Tech Los Angeles CALIFORNIA 8 Hour Days
544678 Oncology Midland TEXAS Nights
544680 ER Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
544701 OB/GYN Socorro NEW MEXICO 8 Hour Day/Night Rotate
544705 ER Des Moines IOWA 12 Hour Nights
544706 NICU Des Moines IOWA 12 Hour Days
544735 Surgical Tech MERCED CALIFORNIA 12 Hour Days
544742 Med Surg Spokane WASHINGTON 12 Hour Days
544743 Med Surg Spokane WASHINGTON 12 Hour Days
544750 Med Surg Tele Everett WASHINGTON 12 Hour Nights
544751 Med Surg Tele Everett WASHINGTON 12 Hour Nights
544753 Interventional Radiology Tech Charleston WEST VIRGINIA 10 Hour Days
544768 OR ODESSA TEXAS 12 Hour Days
544772 Home Health Lake Charles LOUISIANA 8 Hour Days
544775 CT Tech Berlin NEW HAMPSHIRE 12 Hour Day/Night Rotate
544788 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
544789 CNA Kealakekua HAWAII 12 Hour Day/Night Rotate
544792 Orthopedics Detroit MICHIGAN 12 Hour Nights
544793 Cath Lab Bartlett TENNESSEE 8 Hour Days
544796 Clinic Fort Defiance ARIZONA 8 Hour Days
544804 ER Lumberton NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
544809 Cath Lab Lewiston MAINE Days
544811 Radiation Therapy Lewiston IDAHO 8 Hour Days
544812 Certified Surgical Tech Lewiston IDAHO 10 Hour Days
544817 OR Albany NEW YORK 12 Hour Day/Night Rotate
544818 OR Maywood ILLINOIS 10 Hour Days
544819 ER Schenectady NEW YORK 12 Hour Nights
544832 MLT East St Louis ILLINOIS 8 Hour Evenings
544835 Sterile Processing Technician Grove City OHIO 8 Hour Evenings
544846 OR Espanola NEW MEXICO 10 Hour Days
544848 Pharmacy Tech Cleveland OHIO 8 Hour Days
544850 RAD Tech Albuquerque NEW MEXICO 8 Hour Day/Night Rotate
544852 ER San Angelo TEXAS Varied
544853 Med Surg Kingsport TENNESSEE 12 Hour Nights
544861 Dialysis Johnson City TENNESSEE 10 Hour Day/Night Rotate
544870 ICU Oxford NORTH CAROLINA 12 Hour Nights
544871 ICU Oxford NORTH CAROLINA 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.5094 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 1700,100 in 1.4198 seconds