Listing all records

Displaying records 3001 through 3100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547592 Histology Technician Corvallis OREGON 8 Hour Days
527624 Scrub Tech Oceanside CALIFORNIA 10 Hour Days
548158 Scrub Tech Abilene TEXAS 8 Hour Days CST/Certified Surgical Technician
547704 Scrub Tech DILLON MONTANA 10 Hour Day/Night Rotate
539384 Scrub Tech Newark NEW JERSEY 12 Hour Days
547815 Scrub Tech Yuma COLORADO 12 Hour Nights
543785 Scrub Tech Redding CALIFORNIA 12 Hour Day/Night Rotate
543978 Scrub Tech Lamar COLORADO 8 Hour Day/Night Rotate
544617 Scrub Tech Rio Rancho NEW MEXICO 10 Hour Days
544977 Scrub Tech Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
545243 Scrub Tech The Dalles OREGON 12 Hour Day/Night Rotate
545560 Scrub Tech Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
547792 Scrub Tech Pueblo COLORADO 12 Hour Day/Night Rotate
547426 Scrub Tech Kingsport TENNESSEE 8 Hour Days
509595 Anesthesia Tech Everett WASHINGTON 12 Hour Varied
512894 MLT Hickory NORTH CAROLINA 12 Hour Days
515845 MLT Louisville KENTUCKY Nights
532661 MLT Louisville KENTUCKY 8 Hour Evenings
535301 MLT Pittsfield MASSACHUSETTS 10 Hour Nights
535302 MLT Pittsfield MASSACHUSETTS 8 Hour Days
539078 MLT Des Moines IOWA 8 Hour Days
539093 MLT Des Moines IOWA 12 Hour Days
539095 MLT Des Moines IOWA 8 Hour Days
539903 MLT Tuba City ARIZONA 12 Hour Day/Night Rotate
540009 MLT Farmington CONNECTICUT 8 Hour Evenings
540139 MLT Walnut Creek CALIFORNIA 10 Hour Nights
540588 MLT Watertown NEW YORK Varied
540589 MLT Watertown NEW YORK Days
540891 MLT Farmington CONNECTICUT 8 Hour Days
540892 MLT Farmington CONNECTICUT 8 Hour Days
540972 MLT Des Moines IOWA 10 Hour Nights
541109 MLT Syracuse NEW YORK 8 Hour Nights
542345 MLT Westerville OHIO 8 Hour Nights
544226 MLT Denville NEW JERSEY 12 Hour Day/Night Rotate
544446 MLT Los Angeles CALIFORNIA 8 Hour Days
544598 MLT Des Moines IOWA 8 Hour Days
544832 MLT East St Louis ILLINOIS 8 Hour Evenings
544889 MLT Mason City IOWA 8 Hour Days
545413 MLT Ely NEVADA 12 Hour Days
547948 MLT Wolf Point MONTANA 8 Hour Days
545618 MLT Gainesville FLORIDA 8 Hour Nights
545662 MLT Gainesville FLORIDA 12 Hour Nights
545663 MLT Gainesville FLORIDA 12 Hour Nights
545664 MLT Gainesville FLORIDA 8 Hour Days
548018 MLT Aberdeen WASHINGTON 10 Hour Nights
545668 MLT Gainesville FLORIDA 8 Hour Days
545718 MLT Gainesville FLORIDA 8 Hour Nights
545761 MLT Gainesville FLORIDA 8 Hour Nights
545769 MLT Gainesville FLORIDA 8 Hour Evenings
545900 MLT Gainesville FLORIDA 12 Hour Nights
545901 MLT Gainesville FLORIDA 8 Hour Days
546047 MLT Columbus OHIO Nights
547779 MLT Detroit MICHIGAN 8 Hour Evenings
546795 MLT Estes Park COLORADO 12 Hour Nights
546877 MLT Pittsfield MASSACHUSETTS 8 Hour Days
548036 MLT New Bern NORTH CAROLINA 10 Hour Nights
547302 MLT York MAINE 8 Hour Day/Night Rotate
547579 MLT Watertown NEW YORK Nights
525673 Cardiology Louisville KENTUCKY 8 Hour Days
547991 Cardiology Torrance CALIFORNIA 12 Hour Days
539177 Cardiology Albany NEW YORK 12 Hour Nights
547990 Cardiology Torrance CALIFORNIA 12 Hour Days
545389 Cardiology Coos Bay OREGON 8 Hour Days
545627 Cardiology Gainesville FLORIDA 12 Hour Nights
545671 Cardiology Gainesville FLORIDA 12 Hour Nights
545867 Cardiology Gainesville FLORIDA 12 Hour Nights
546142 Cardiology Muskegon MICHIGAN 12 Hour Days
546354 Cardiology Fountain Valley CALIFORNIA 12 Hour Days
531994 Physician New Lisbon WISCONSIN Days
532081 Physician Stanley WISCONSIN 8 Hour Day/Night Rotate
542040 Physician PHiladelphia PENNSYLVANIA 8 Hour Days
541929 Management Corvallis OREGON 12 Hour Day/Night Rotate
535128 Management Tacoma WASHINGTON Varied
548171 Speech Language Redding CALIFORNIA 10 Hour Days RN/Registered Nurse
539310 Speech Language Roseburg OREGON Days
548178 Speech Language Redding CALIFORNIA 10 Hour Days SLP/Speech Language Pathologist
534331 Neuro Med Surg/Tele PHOENIX ARIZONA 12 Hour Nights
537922 Neuro Med Surg/Tele Des Moines IOWA 12 Hour Nights
548297 Neuro Med Surg/Tele Redding CALIFORNIA 12 Hour Nights RN/Registered Nurse
545990 Neuro Med Surg/Tele Madison WISCONSIN 12 Hour Day/Night Rotate
545991 Neuro Med Surg/Tele Madison WISCONSIN 12 Hour Day/Night Rotate
547143 Neuro Med Surg/Tele Peoria ILLINOIS 12 Hour Nights
547456 Neuro Med Surg/Tele Abilene TEXAS 12 Hour Nights
547468 Neuro Med Surg/Tele PHOENIX ARIZONA 12 Hour Nights
548389 Cardiac Cath Lab Clackamas OREGON 12 Hour Days Advanced Practice
548390 Cardiac Cath Lab Clackamas OREGON 10 Hour Days Advanced Practice
526998 Cardiac ICU Boston MASSACHUSETTS 12 Hour Day/Night Rotate RN/Registered Nurse
540706 Cardiac ICU Rockford ILLINOIS 12 Hour Nights
546348 Cardiac ICU Detroit MICHIGAN 12 Hour Nights
546358 Cardiac ICU Rock Hill SOUTH CAROLINA 12 Hour Nights
546639 Cardiac ICU Falls Church VIRGINIA 12 Hour Day/Night Rotate
547530 Cardiac ICU Chillicothe OHIO 12 Hour Nights
548298 Neuro Intensive Care PHOENIX ARIZONA 12 Hour Nights RN/Registered Nurse
540121 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
540250 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
547735 Neuro Intensive Care Palo Alto CALIFORNIA 12 Hour Day/Night Rotate
543178 Neuro Intensive Care New York NEW YORK Days
543759 Neuro Intensive Care Lynwood CALIFORNIA 12 Hour Nights
543760 Neuro Intensive Care Lynwood CALIFORNIA 12 Hour Nights
548253 Neuro Intensive Care Boston MASSACHUSETTS 12 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.4986 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.specialty asc limit 3000,100 in 1.4753 seconds