Listing all records

Displaying records 1101 through 1200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546260 Oncology Oklahoma City OKLAHOMA 12 Hour Days
540140 L&D Walnut Creek CALIFORNIA 12 Hour Days
540141 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540142 Intermediate Care Concord CALIFORNIA 12 Hour Days
543371 PACU Fresno CALIFORNIA 12 Hour Days
540144 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540145 L&D Walnut Creek CALIFORNIA 12 Hour Days
540147 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540149 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540150 Telemetry Concord CALIFORNIA 12 Hour Days
543884 ICU Philadelphia PENNSYLVANIA 12 Hour Days
540153 Med Surg Tele Concord CALIFORNIA 12 Hour Days
547070 PICU Walnut Creek CALIFORNIA 12 Hour Days
540156 ER Concord CALIFORNIA 12 Hour Days
547072 NICU Walnut Creek CALIFORNIA 12 Hour Days
547073 NICU Walnut Creek CALIFORNIA 12 Hour Days
540160 Med Surg Concord CALIFORNIA 12 Hour Days
540161 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540162 PACU Walnut Creek CALIFORNIA 12 Hour Days
540166 NICU Walnut Creek CALIFORNIA 12 Hour Days
540169 L&D Walnut Creek CALIFORNIA 12 Hour Days
547186 Med Surg Brooklyn NEW YORK 12 Hour Days
547226 L&D Brooklyn NEW YORK 12 Hour Days
547185 Med Surg Brooklyn NEW YORK 12 Hour Days
540176 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540179 Case Manager Concord CALIFORNIA 12 Hour Days
540180 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
540181 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540182 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540183 Med Surg Tele Concord CALIFORNIA 12 Hour Days
547290 ER Norton VIRGINIA 12 Hour Days
540185 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
540187 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540190 L&D Walnut Creek CALIFORNIA 12 Hour Days
547311 Telemetry Twin Falls IDAHO 12 Hour Days
540192 OR Concord CALIFORNIA 12 Hour Days
540195 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540198 ER Concord CALIFORNIA 12 Hour Days
547340 Patient Care Coordinator Hillsboro OREGON 12 Hour Days
547339 Patient Care Coordinator Hillsboro OREGON 12 Hour Days
540205 Med Surg Tele Concord CALIFORNIA 12 Hour Days
547446 Rehab Seguin TEXAS 12 Hour Days
540207 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540208 ICU Concord CALIFORNIA 12 Hour Days
540209 NICU Walnut Creek CALIFORNIA 12 Hour Days
540212 Intermediate Care Concord CALIFORNIA 12 Hour Days
540213 ER Concord CALIFORNIA 12 Hour Days
540217 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
547382 L&D Seattle WASHINGTON 12 Hour Days
547381 L&D Seattle WASHINGTON 12 Hour Days
547374 PCU Albuquerque NEW MEXICO 12 Hour Days
540221 PICU Walnut Creek CALIFORNIA 12 Hour Days
540222 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540223 ER Concord CALIFORNIA 12 Hour Days
547409 Postpartum ODESSA TEXAS 12 Hour Days
540226 Telemetry Concord CALIFORNIA 12 Hour Days
540227 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540228 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540229 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540230 ICU Walnut Creek CALIFORNIA 12 Hour Days
540231 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540233 PICU Walnut Creek CALIFORNIA 12 Hour Days
540235 ICU Concord CALIFORNIA 12 Hour Days
540238 ICU Walnut Creek CALIFORNIA 12 Hour Days
540239 OR Walnut Creek CALIFORNIA 12 Hour Days
540240 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Days
540241 ICU Concord CALIFORNIA 12 Hour Days
540244 ICU Concord CALIFORNIA 12 Hour Days
540246 ICU Walnut Creek CALIFORNIA 12 Hour Days
540247 L&D Walnut Creek CALIFORNIA 12 Hour Days
540248 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540249 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Days
540254 NICU Walnut Creek CALIFORNIA 12 Hour Days
540256 ER Concord CALIFORNIA 12 Hour Days
545661 Med Surg Gainesville FLORIDA 12 Hour Days
543196 ER Newark NEW JERSEY 12 Hour Days
545745 Med Surg Gainesville FLORIDA 12 Hour Days
540748 Med Surg Tele Prescott ARIZONA 12 Hour Days
545707 Med Surg Gainesville FLORIDA 12 Hour Days
545634 Med Surg Gainesville FLORIDA 12 Hour Days
545656 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545646 Med Surg Gainesville FLORIDA 12 Hour Days
545632 Med Surg Gainesville FLORIDA 12 Hour Days
540770 Telemetry Prescott ARIZONA 12 Hour Days
545336 Ultrasound Tech Abingdon VIRGINIA 12 Hour Days
542573 Surgical Tech Louisville KENTUCKY 12 Hour Days
545659 Med Surg Gainesville FLORIDA 12 Hour Days
545660 Med Surg Gainesville FLORIDA 12 Hour Days
545666 Surgical Tech CVOR Gainesville FLORIDA 12 Hour Days
545667 Med Surg Gainesville FLORIDA 12 Hour Days
545756 Med Surg Gainesville FLORIDA 12 Hour Days
545678 ICU Gainesville FLORIDA 12 Hour Days
545670 Med Surg Gainesville FLORIDA 12 Hour Days
540857 ER Springfield MASSACHUSETTS 12 Hour Days
545698 Med Surg Gainesville FLORIDA 12 Hour Days
540895 Med Surg Tele Concord CALIFORNIA 12 Hour Days
545704 Med Surg Gainesville FLORIDA 12 Hour Days
545710 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545721 Med Surg Gainesville FLORIDA 12 Hour Days
541037 L&D Walnut Creek CALIFORNIA 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.4753 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.shift asc limit 1100,100 in 1.4171 seconds