Listing all records

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

ID Job Specialty City State Shift Title
547059 ER Rome NEW YORK 12 Hour Nights
547060 L&D Pittsfield MASSACHUSETTS 12 Hour Days
547061 Sterile Processing Tech Muskegon MICHIGAN Nights
547062 Sterile Processing Tech Muskegon MICHIGAN Nights
547063 SLP Athens GEORGIA 8 Hour Days
547064 COTA Crescent City CALIFORNIA 8 Hour Days
547065 Med Surg Grand Forks NORTH DAKOTA 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
547088 Pediatrics Pittsfield MASSACHUSETTS 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
547118 Interventional Radiology Tech CHANDLER ARIZONA 8 Hour Days
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
547127 Med Surg Coos Bay OREGON 12 Hour Nights
547135 PT Lufkin TEXAS 8 Hour Days
547136 Pediatrics Quincy CALIFORNIA Nights
547138 ER Arlington WASHINGTON 12 Hour Nights
547141 RAD Tech Farmington CONNECTICUT 8 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
547187 Med Surg Brooklyn NEW YORK 8 Hour Nights
547188 Med Surg Brooklyn NEW YORK 12 Hour Days
547189 Surgical Tech Brooklyn NEW YORK 8 Hour Nights
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
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
547297 Med Surg Tele Denison IOWA 12 Hour Nights
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
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.7206 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 2800,100 in 1.487 seconds