Listing all records

Displaying records 201 through 300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
540824 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
540823 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
540742 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540280 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540282 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540283 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540284 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540285 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540287 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Nights
540288 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540346 ICU Walnut Creek CALIFORNIA 12 Hour Days
540290 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540291 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540292 Intermediate Care Walnut Creek CALIFORNIA 12 Hour Days
540345 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540294 Intermediate Care Walnut Creek CALIFORNIA 12 Hour Nights
540295 ER Walnut Creek CALIFORNIA 12 Hour Days
540296 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540343 ICU Walnut Creek CALIFORNIA 12 Hour Days
540298 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
540299 L&D Walnut Creek CALIFORNIA 12 Hour Days
540300 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540340 ICU Walnut Creek CALIFORNIA 12 Hour Days
540339 PICU Walnut Creek CALIFORNIA 12 Hour Days
540303 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540304 L&D Walnut Creek CALIFORNIA 12 Hour Days
540305 OR Walnut Creek CALIFORNIA 12 Hour Nights
540336 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540307 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540334 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Days
540309 L&D Walnut Creek CALIFORNIA 12 Hour Days
540310 OR Walnut Creek CALIFORNIA 12 Hour Days
540311 ER Walnut Creek CALIFORNIA 12 Hour Nights
540312 Intermediate Care Walnut Creek CALIFORNIA 12 Hour Nights
540332 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
540314 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Days
540315 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
540316 Intermediate Care Walnut Creek CALIFORNIA 12 Hour Nights
540317 PACU Walnut Creek CALIFORNIA 12 Hour Nights
540329 ICU Walnut Creek CALIFORNIA 12 Hour Days
540328 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Days
540320 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540321 ICU Walnut Creek CALIFORNIA 12 Hour Days
540326 Pediatrics Walnut Creek CALIFORNIA 12 Hour Days
540325 PT Walnut Creek CALIFORNIA 10 Hour Days
546800 ER Walnut Creek CALIFORNIA 12 Hour Nights
544405 ER Walnut Creek CALIFORNIA 12 Hour Nights
540066 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540064 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
540058 OR Walnut Creek CALIFORNIA 12 Hour Days
540057 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540056 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540053 OR Walnut Creek CALIFORNIA 12 Hour Nights
540049 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Nights
540046 Peri-Operative Walnut Creek CALIFORNIA 10 Hour Days
540044 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540039 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
540037 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540036 L&D Walnut Creek CALIFORNIA 12 Hour Nights
532657 Cath Lab Walnut Creek CALIFORNIA 10 Hour Days
540031 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540030 L&D Walnut Creek CALIFORNIA 12 Hour Days
540023 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540021 L&D Walnut Creek CALIFORNIA 12 Hour Days
536253 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Nights
540015 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
541845 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540010 OR Walnut Creek CALIFORNIA 12 Hour Days
540008 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540007 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540006 PCU Walnut Creek CALIFORNIA 12 Hour Nights
535906 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
540004 PACU Walnut Creek CALIFORNIA 12 Hour Days
547467 NICU Walnut Creek CALIFORNIA 12 Hour Days
540001 ER Walnut Creek CALIFORNIA 12 Hour Days
540000 ER Walnut Creek CALIFORNIA 12 Hour Nights
547073 NICU Walnut Creek CALIFORNIA 12 Hour Days
547072 NICU Walnut Creek CALIFORNIA 12 Hour Days
547071 PICU Walnut Creek CALIFORNIA 12 Hour Days
547070 PICU Walnut Creek CALIFORNIA 12 Hour Days
546802 NICU Walnut Creek CALIFORNIA 12 Hour Nights
546801 PICU Walnut Creek CALIFORNIA 12 Hour Days
546667 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
541657 Med Surg Walla Walla WASHINGTON 12 Hour Nights
543486 Echo Waimea HAWAII 12 Hour Day/Night Rotate
543332 CT Tech Waimea HAWAII 12 Hour Day/Night Rotate
546835 Registered Dietician Waimea HAWAII 12 Hour Day/Night Rotate
543466 Med Surg Tele Wailuku HAWAII 12 Hour Nights
543465 Telemetry Wailuku HAWAII 12 Hour Nights
542071 Med Surg Tele Wailuku HAWAII 12 Hour Nights
542070 Med Surg Tele Wailuku HAWAII 12 Hour Varied
542063 ICU Wailuku HAWAII 12 Hour Nights
538410 Med Surg Tele Wailuku HAWAII 12 Hour Nights
538391 Med Surg Tele Wailuku HAWAII 8 Hour Days
513832 Med Surg Tele Wailuku HAWAII 12 Hour Days
517902 Med Surg Tele Wailuku HAWAII 8 Hour Nights
539754 L&D Wailuku HAWAII 8 Hour Nights
539755 Med Surg Tele Wailuku HAWAII 12 Hour Nights
539756 Med Surg Tele Wailuku HAWAII 12 Hour Nights
539757 Med Surg Tele Wailuku HAWAII 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.5484 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 200,100 in 1.366 seconds