Listing all records

Displaying records 801 through 900 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
540222 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540223 ER Concord CALIFORNIA 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
540231 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540232 Psych Concord CALIFORNIA 8 Hour Nights
540234 ICU Concord CALIFORNIA 12 Hour Nights
540235 ICU Concord CALIFORNIA 12 Hour Days
540241 ICU Concord CALIFORNIA 12 Hour Days
540242 ICU Concord CALIFORNIA 12 Hour Nights
540243 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540244 ICU Concord CALIFORNIA 12 Hour Days
540253 Case Manager Concord CALIFORNIA 8 Hour Days
540256 ER Concord CALIFORNIA 12 Hour Days
540258 ICU Concord CALIFORNIA 12 Hour Nights
540261 Telemetry Concord CALIFORNIA 12 Hour Nights
540263 CT Tech Concord CALIFORNIA 10 Hour Nights
540264 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540265 Med Surg Concord CALIFORNIA 12 Hour Days
540266 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540267 Med Surg Concord CALIFORNIA 12 Hour Nights
540268 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540271 Med Surg Concord CALIFORNIA 12 Hour Days
540273 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540274 ICU Concord CALIFORNIA 12 Hour Days
540275 ICU Concord CALIFORNIA 12 Hour Days
540276 ICU Concord CALIFORNIA 12 Hour Nights
540277 ER Concord CALIFORNIA 12 Hour Nights
540278 CT Tech Concord CALIFORNIA 10 Hour Nights
540279 Med Surg Concord CALIFORNIA 12 Hour Nights
540281 ICU Concord CALIFORNIA 12 Hour Days
540286 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540289 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540293 ICU Concord CALIFORNIA 12 Hour Nights
540297 ER Concord CALIFORNIA 12 Hour Days
540301 PACU Concord CALIFORNIA 10 Hour Days
540302 Med Surg Concord CALIFORNIA 12 Hour Days
540306 Med Surg Concord CALIFORNIA 12 Hour Nights
540308 Case Manager Concord CALIFORNIA 8 Hour Evenings
540313 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540318 Med Surg Concord CALIFORNIA 12 Hour Days
540319 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540322 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540323 Telemetry Concord CALIFORNIA 12 Hour Nights
540324 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540327 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540330 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540331 ER Concord CALIFORNIA 12 Hour Nights
540333 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540335 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540337 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540338 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540341 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540342 Telemetry Concord CALIFORNIA 12 Hour Days
540344 PACU Concord CALIFORNIA 12 Hour Days
540347 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540348 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540349 Telemetry Concord CALIFORNIA 12 Hour Nights
540350 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540743 PCU Concord CALIFORNIA 12 Hour Days
540744 PCU Concord CALIFORNIA 12 Hour Days
540852 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540895 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540910 Social Worker Concord CALIFORNIA 8 Hour Days
541039 Psych Concord CALIFORNIA 8 Hour Nights
541844 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
541257 OR Concord CALIFORNIA 10 Hour Evenings
541258 ICU Concord CALIFORNIA 12 Hour Days
541312 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
543152 Ultrasound Tech Concord NEW HAMPSHIRE 8 Hour Days
542156 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
542758 Med Surg Tele Concord CALIFORNIA 12 Hour Days
542997 Cath Lab Concord CALIFORNIA 10 Hour Days
542944 ER Concord CALIFORNIA 12 Hour Nights
543153 Ultrasound Tech Concord NEW HAMPSHIRE 8 Hour Days
543549 Med Surg Tele Concord CALIFORNIA 12 Hour Days
543550 Med Surg Tele Concord CALIFORNIA 12 Hour Days
543945 RAD Tech Concord CALIFORNIA 10 Hour Days
534238 Med Surg Tele Concord CALIFORNIA 8 Hour Days
535905 Psych Concord CALIFORNIA 8 Hour Nights
534687 Med Surg Tele Concord CALIFORNIA 8 Hour Nights
539110 PCU Concord CALIFORNIA 12 Hour Nights
539111 OR Concord CALIFORNIA 10 Hour Days
539112 Social Worker Concord CALIFORNIA 8 Hour Days
540025 OR Concord CALIFORNIA 10 Hour Evenings
540026 OR Concord CALIFORNIA 8 Hour Days
540027 OR Concord CALIFORNIA 12 Hour Days
540028 OR Concord CALIFORNIA 10 Hour Days
540029 PCU Concord CALIFORNIA 8 Hour Days
540033 Med Surg Tele Concord CALIFORNIA 8 Hour Days
540034 PCU Concord CALIFORNIA 8 Hour Nights
540035 PCU Concord CALIFORNIA 8 Hour Days
540038 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540042 ICU Concord CALIFORNIA 12 Hour Days
540047 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540048 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540050 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540051 Psych Concord CALIFORNIA 8 Hour Evenings
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.7722 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 800,100 in 1.4641 seconds