Listing all records

Displaying records 101 through 200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
540320 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540328 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Days
540329 ICU Walnut Creek CALIFORNIA 12 Hour Days
540317 PACU Walnut Creek CALIFORNIA 12 Hour Nights
540316 Intermediate Care Walnut Creek CALIFORNIA 12 Hour Nights
540315 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
540314 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Days
540332 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
540312 Intermediate Care Walnut Creek CALIFORNIA 12 Hour Nights
540311 ER Walnut Creek CALIFORNIA 12 Hour Nights
540310 OR Walnut Creek CALIFORNIA 12 Hour Days
540309 L&D Walnut Creek CALIFORNIA 12 Hour Days
540334 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Days
540307 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540336 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540305 OR Walnut Creek CALIFORNIA 12 Hour Nights
540304 L&D Walnut Creek CALIFORNIA 12 Hour Days
540303 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540339 PICU Walnut Creek CALIFORNIA 12 Hour Days
540340 ICU Walnut Creek CALIFORNIA 12 Hour Days
540300 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540299 L&D Walnut Creek CALIFORNIA 12 Hour Days
540298 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
540343 ICU Walnut Creek CALIFORNIA 12 Hour Days
540296 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540295 ER Walnut Creek CALIFORNIA 12 Hour Days
540294 Intermediate Care Walnut Creek CALIFORNIA 12 Hour Nights
540345 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540292 Intermediate Care Walnut Creek CALIFORNIA 12 Hour Days
540291 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540290 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540346 ICU Walnut Creek CALIFORNIA 12 Hour Days
540288 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540287 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Nights
540285 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540284 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540283 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540282 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540280 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540742 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540823 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
540824 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
540272 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Nights
540270 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540269 NICU Walnut Creek CALIFORNIA 12 Hour Nights
541037 L&D Walnut Creek CALIFORNIA 12 Hour Days
540262 PICU Walnut Creek CALIFORNIA 12 Hour Days
540260 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
540259 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Days
540257 NICU Walnut Creek CALIFORNIA 12 Hour Days
541207 ER Walnut Creek CALIFORNIA 12 Hour Nights
540255 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Days
540254 NICU Walnut Creek CALIFORNIA 12 Hour Days
540252 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540251 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540250 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
540249 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Days
540248 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540247 L&D Walnut Creek CALIFORNIA 12 Hour Days
540246 ICU Walnut Creek CALIFORNIA 12 Hour Days
540245 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
540240 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Days
540239 OR Walnut Creek CALIFORNIA 12 Hour Days
540238 ICU Walnut Creek CALIFORNIA 12 Hour Days
540237 ER Walnut Creek CALIFORNIA 12 Hour Nights
540236 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540233 PICU Walnut Creek CALIFORNIA 12 Hour Days
540230 ICU Walnut Creek CALIFORNIA 12 Hour Days
540067 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540225 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540224 Peri-Operative Walnut Creek CALIFORNIA 10 Hour Days
540221 PICU Walnut Creek CALIFORNIA 12 Hour Days
540219 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540217 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540216 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540215 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540209 NICU Walnut Creek CALIFORNIA 12 Hour Days
540204 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
540203 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540200 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540199 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540191 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540190 L&D Walnut Creek CALIFORNIA 12 Hour Days
540188 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540186 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540185 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
540138 NICU Walnut Creek CALIFORNIA 12 Hour Days
540068 NICU Walnut Creek CALIFORNIA 12 Hour Days
540069 NICU Walnut Creek CALIFORNIA 12 Hour Days
540072 ER Walnut Creek CALIFORNIA 12 Hour Nights
540073 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540074 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540075 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540077 OR Walnut Creek CALIFORNIA 12 Hour Days
543944 RAD Tech Walnut Creek CALIFORNIA 10 Hour Days
540082 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540084 OR Walnut Creek CALIFORNIA 12 Hour Days
540086 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540090 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540094 Surgical Tech 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.3889 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 z.city desc limit 100,100 in 1.2821 seconds