Listing all records

Displaying records 2801 through 2900 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546946 CT Tech Brattleboro VERMONT 12 Hour Nights
546948 Echo Lufkin TEXAS 8 Hour Day/Night Rotate
546949 RAD Tech Hot Springs ARKANSAS 8 Hour Days
546951 Surgical Tech Long Beach CALIFORNIA 12 Hour Nights
546958 Med Surg Tele Princeton WEST VIRGINIA 12 Hour Nights
546966 CT Tech Silverdale WASHINGTON 10 Hour Nights
546971 Radiology PHOENIX ARIZONA 12 Hour Nights
546973 Interventional Radiology Tech York PENNSYLVANIA 8 Hour Days
546976 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
546977 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
546984 CVICU Albany NEW YORK 12 Hour Nights
546985 Med Surg Tele Syracuse NEW YORK 12 Hour Days
547666 PT Bad Axe MICHIGAN 8 Hour Days
546986 LPN/LVN SAN ANDREAS CALIFORNIA 8 Hour Days
546987 Echo Osage Beach MISSOURI 8 Hour Days
546988 Radiation Therapy NORTHRIDGE CALIFORNIA 8 Hour Days
546992 Certified Surgical Tech Concord MASSACHUSETTS 8 Hour Days
546993 Med Surg Troy NEW YORK 12 Hour Nights
546994 Med Surg Troy NEW YORK 12 Hour Nights
546995 OR Athens GEORGIA 8 Hour Days
546996 Mammo Tech Morgantown WEST VIRGINIA 8 Hour Days
546999 Rehab Sioux City IOWA 12 Hour Nights
547000 Med Surg Dubuque IOWA 12 Hour Days
547002 Med Surg Dubuque IOWA 12 Hour Days
547006 CVOR Charlottesville VIRGINIA 10 Hour Days
547007 CT Tech Maryville ILLINOIS 12 Hour Nights
547008 Oncology Everett WASHINGTON 12 Hour Nights
547009 Wound Care Anchorage ALASKA 8 Hour Days
547013 Med Surg Tele Cleveland OHIO 12 Hour Days
547014 Med Surg Tele Cleveland OHIO 12 Hour Days
547015 Med Surg Tele Cleveland OHIO 12 Hour Days
547016 Med Surg Tele Cleveland OHIO 12 Hour Days
547021 Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
547022 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
547023 Med Surg Tele Rome NEW YORK 12 Hour Nights
547024 Med Surg Tele Rome NEW YORK 12 Hour Nights
547026 ICU Santa Fe NEW MEXICO 12 Hour Day/Night Rotate
547031 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547032 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547033 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547034 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547036 Surgical Tech Falls Church VIRGINIA 8 Hour Day/Night Rotate
547065 Med Surg Grand Forks NORTH DAKOTA Days
547039 Supervisor Oneonta NEW YORK 8 Hour Nights
547043 Med Surg Tele Beachwood OHIO 12 Hour Nights
547045 Cath Lab New Bern NORTH CAROLINA 10 Hour Days
547046 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
547050 CNA Claremont NEW HAMPSHIRE 8 Hour Evenings
547051 RAD Tech Phoenix ARIZONA 12 Hour Days
547056 PT Sacramento CALIFORNIA 8 Hour Days
547057 OT Sacramento CALIFORNIA 8 Hour Days
548028 CT Tech Pagosa Springs COLORADO 12 Hour Day/Night Rotate
547061 Sterile Processing Tech Muskegon MICHIGAN Nights
547062 Sterile Processing Tech Muskegon MICHIGAN Nights
547127 Med Surg Coos Bay OREGON 12 Hour Nights
547063 SLP Athens GEORGIA 8 Hour Days
547064 COTA Crescent City CALIFORNIA 8 Hour Days
547066 PCU Rio Rancho NEW MEXICO 12 Hour Nights
547068 CT Tech Pella IOWA 12 Hour Nights
547069 Step Down Johnson City TENNESSEE 12 Hour Nights
547070 PICU Walnut Creek CALIFORNIA 12 Hour Days
547071 PICU Walnut Creek CALIFORNIA 12 Hour Days
547072 NICU Walnut Creek CALIFORNIA 12 Hour Days
547073 NICU Walnut Creek CALIFORNIA 12 Hour Days
547074 Social Worker Farmington CONNECTICUT 8 Hour Days
547075 Social Worker Farmington CONNECTICUT 8 Hour Days
547076 CT Tech Farmington CONNECTICUT 12 Hour Nights
547077 CT Tech Farmington CONNECTICUT 12 Hour Nights
547082 Social Worker San Francisco CALIFORNIA 8 Hour Days
547083 Social Worker San Francisco CALIFORNIA 8 Hour Days
547084 ICU Pendleton OREGON 12 Hour Nights
547085 ICU Pendleton OREGON 12 Hour Nights
547086 Med Surg Pendleton OREGON 12 Hour Nights
547087 Med Surg Pendleton OREGON 12 Hour Nights
547089 Med Surg Portland OREGON 12 Hour Nights
547094 Surgical Tech CVOR Lewiston MAINE 10 Hour Days
547099 PT Laurinburg NORTH CAROLINA 8 Hour Days
547100 Therapy Rehab Abbeville SOUTH CAROLINA 8 Hour Days
547104 Med Surg Tele Cleveland OHIO 12 Hour Nights
547105 Step Down Dover OHIO 12 Hour Nights
547106 Med Surg Tele Akron OHIO 12 Hour Nights
547107 Step Down Cleveland OHIO 12 Hour Nights
547108 Clinic Cleveland OHIO 12 Hour Nights
547111 Ophthalmic Tech Duluth MINNESOTA Days
547114 Outpatient Clinic Wichita Falls TEXAS 8 Hour Days
547117 Cardiovascular York PENNSYLVANIA 12 Hour Day/Night Rotate
547119 RAD Tech REDWOOD CITY CALIFORNIA 8 Hour Days
547120 Neurology Des Moines IOWA 12 Hour Nights
547122 Med Surg Des Moines IOWA 12 Hour Nights
547123 Med Surg Des Moines IOWA 12 Hour Nights
547124 Orthopedics Des Moines IOWA 12 Hour Nights
547125 Orthopedics Des Moines IOWA 12 Hour Nights
547126 ER Des Moines IOWA 12 Hour Days
547136 Pediatrics Quincy CALIFORNIA Nights
547138 ER Arlington WASHINGTON 12 Hour Nights
547143 Neuro Med Surg/Tele Peoria ILLINOIS 12 Hour Nights
547152 OR Brooklyn NEW YORK 8 Hour Days
547183 OR Brooklyn NEW YORK 12 Hour Nights
547185 Med Surg Brooklyn NEW YORK 12 Hour Days
547186 Med Surg Brooklyn NEW YORK 12 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.4928 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 desc limit 2800,100 in 1.3079 seconds