Listing all records

Displaying records 3401 through 3500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546931 SLP Visalia CALIFORNIA 8 Hour Days
513832 Med Surg Tele Wailuku HAWAII 12 Hour Days
517902 Med Surg Tele Wailuku HAWAII 8 Hour Nights
538391 Med Surg Tele Wailuku HAWAII 8 Hour Days
538410 Med Surg Tele Wailuku HAWAII 12 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
539758 Med Surg Tele Wailuku HAWAII 12 Hour Nights
542063 ICU Wailuku HAWAII 12 Hour Nights
542070 Med Surg Tele Wailuku HAWAII 12 Hour Varied
542071 Med Surg Tele Wailuku HAWAII 12 Hour Nights
543465 Telemetry Wailuku HAWAII 12 Hour Nights
543466 Med Surg Tele Wailuku HAWAII 12 Hour Nights
548118 ER Wailuku HAWAII 12 Hour Days RN/Registered Nurse
544499 Med Surg Tele Wailuku HAWAII 12 Hour Nights
544524 Med Surg Tele Wailuku HAWAII 12 Hour Nights
544525 Telemetry Wailuku HAWAII 12 Hour Nights
544526 Step Down Wailuku HAWAII 12 Hour Days
544527 Med Surg Tele Wailuku HAWAII 12 Hour Days
546335 Psych Wailuku HAWAII 12 Hour Nights
543332 CT Tech Waimea HAWAII 12 Hour Day/Night Rotate
543486 Echo Waimea HAWAII 12 Hour Day/Night Rotate
546835 Registered Dietician Waimea HAWAII 12 Hour Day/Night Rotate
541657 Med Surg Walla Walla WASHINGTON 12 Hour Nights
540067 NICU Walnut Creek CALIFORNIA 12 Hour Nights
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
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
540101 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540103 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540109 OR Walnut Creek CALIFORNIA 12 Hour Days
540110 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540114 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540115 ER Walnut Creek CALIFORNIA 12 Hour Nights
540116 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540117 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540118 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540119 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540120 ICU Walnut Creek CALIFORNIA 12 Hour Days
540121 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
540122 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540123 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
540125 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540126 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540128 ICU Walnut Creek CALIFORNIA 12 Hour Days
540136 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Nights
540138 NICU Walnut Creek CALIFORNIA 12 Hour Days
540139 MLT Walnut Creek CALIFORNIA 10 Hour Nights
540140 L&D Walnut Creek CALIFORNIA 12 Hour Days
540143 Cath Lab Walnut Creek CALIFORNIA 10 Hour Days
540145 L&D Walnut Creek CALIFORNIA 12 Hour Days
540148 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
540155 ER Walnut Creek CALIFORNIA 12 Hour Nights
540162 PACU Walnut Creek CALIFORNIA 12 Hour Days
540165 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540166 NICU Walnut Creek CALIFORNIA 12 Hour Days
540168 Pediatrics Walnut Creek CALIFORNIA 12 Hour Nights
540169 L&D Walnut Creek CALIFORNIA 12 Hour Days
540170 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540171 PACU Walnut Creek CALIFORNIA 12 Hour Nights
540172 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540175 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540176 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540180 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
540185 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
540186 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540188 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540190 L&D Walnut Creek CALIFORNIA 12 Hour Days
540191 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540196 Histology Technician Walnut Creek CALIFORNIA 8 Hour Nights
540199 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540200 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540203 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540204 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
540209 NICU Walnut Creek CALIFORNIA 12 Hour Days
540215 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540216 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540217 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540219 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540221 PICU Walnut Creek CALIFORNIA 12 Hour Days
540224 Peri-Operative Walnut Creek CALIFORNIA 10 Hour Days
540225 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540230 ICU Walnut Creek CALIFORNIA 12 Hour Days
540233 PICU Walnut Creek CALIFORNIA 12 Hour Days
540236 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540237 ER Walnut Creek CALIFORNIA 12 Hour Nights
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
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 2.4093 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 asc limit 3400,100 in 1.7386 seconds