cdcr-prison-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- date
- The date when the data were collected in ISO 8601 format.
- code
- The unique identifier of the prison institution.
- name
- The name of the prison institution.
- city
- The city where the prison institution is located.
- county
- The county where the prison institution is located.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- zipcode
- The ZIP Code where the agency is located.
- x
- The longitude of the area's centroid.
- y
- The latitude of the area's centroid.
- confirmed_cases
- The cumulative number of confirmed coronavirus case at that time.
- new_confirmed_cases
- The net change in confirmed cases over the previous date.
- deaths
- The cumulative number of deaths at that time.
- new_deaths
- The net change in deaths over the previous date.
1,026 rows where name = "California Health Care Facility" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4205 | 4205 | 2020-06-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 0 | 0 | 0 | 0 |
4206 | 4206 | 2020-06-19 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 0 | 0 | 0 | 0 |
4207 | 4207 | 2020-06-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 0 | 0 | 0 | 0 |
4208 | 4208 | 2020-06-21 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 0 | 0 | 0 | 0 |
4209 | 4209 | 2020-06-22 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 0 | 0 | 0 | 0 |
4210 | 4210 | 2020-06-23 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 0 | 0 | 0 | 0 |
4211 | 4211 | 2020-06-24 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 0 | 0 | 0 | 0 |
4212 | 4212 | 2020-06-25 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 0 | 0 | 0 | 0 |
4213 | 4213 | 2020-06-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 0 | 0 | 0 | 0 |
4214 | 4214 | 2020-06-27 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 0 | 0 | 0 | 0 |
4215 | 4215 | 2020-06-28 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 0 | 0 | 0 | 0 |
4216 | 4216 | 2020-06-29 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 0 | 0 | 0 | 0 |
4217 | 4217 | 2020-06-30 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 0 | 0 | 0 | 0 |
4218 | 4218 | 2020-07-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 0 | 0 | 0 | 0 |
4219 | 4219 | 2020-07-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 0 | 0 | 0 | 0 |
4220 | 4220 | 2020-07-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 0 | 0 | 0 | 0 |
4221 | 4221 | 2020-07-04 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1 | 1 | 0 | 0 |
4222 | 4222 | 2020-07-05 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1 | 0 | 0 | 0 |
4223 | 4223 | 2020-07-06 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1 | 0 | 0 | 0 |
4224 | 4224 | 2020-07-07 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 2 | 1 | 0 | 0 |
4225 | 4225 | 2020-07-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 2 | 0 | 0 | 0 |
4226 | 4226 | 2020-07-09 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 2 | 0 | 0 | 0 |
4227 | 4227 | 2020-07-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 3 | 1 | 0 | 0 |
4228 | 4228 | 2020-07-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 3 | 0 | 0 | 0 |
4229 | 4229 | 2020-07-12 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 3 | 0 | 0 | 0 |
4230 | 4230 | 2020-07-13 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 3 | 0 | 0 | 0 |
4231 | 4231 | 2020-07-14 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 3 | 0 | 0 | 0 |
4232 | 4232 | 2020-07-15 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 3 | 0 | 0 | 0 |
4233 | 4233 | 2020-07-16 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 3 | 0 | 0 | 0 |
4234 | 4234 | 2020-07-17 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 3 | 0 | 0 | 0 |
4235 | 4235 | 2020-07-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 3 | 0 | 0 | 0 |
4236 | 4236 | 2020-07-19 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 3 | 0 | 0 | 0 |
4237 | 4237 | 2020-07-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 3 | 0 | 0 | 0 |
4238 | 4238 | 2020-07-21 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 3 | 0 | 0 | 0 |
4239 | 4239 | 2020-07-22 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 3 | 0 | 0 | 0 |
4240 | 4240 | 2020-07-23 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 3 | 0 | 0 | 0 |
4241 | 4241 | 2020-07-24 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 1 | 0 | 0 |
4242 | 4242 | 2020-07-25 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4243 | 4243 | 2020-07-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4244 | 4244 | 2020-07-27 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4245 | 4245 | 2020-07-28 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4246 | 4246 | 2020-07-29 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4247 | 4247 | 2020-07-30 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4248 | 4248 | 2020-07-31 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4249 | 4249 | 2020-08-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4250 | 4250 | 2020-08-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4251 | 4251 | 2020-08-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4252 | 4252 | 2020-08-04 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4253 | 4253 | 2020-08-05 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4254 | 4254 | 2020-08-06 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4255 | 4255 | 2020-08-07 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4256 | 4256 | 2020-08-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4257 | 4257 | 2020-08-09 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4258 | 4258 | 2020-08-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4259 | 4259 | 2020-08-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4260 | 4260 | 2020-08-12 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4261 | 4261 | 2020-08-13 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4262 | 4262 | 2020-08-14 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4263 | 4263 | 2020-08-15 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4264 | 4264 | 2020-08-16 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4265 | 4265 | 2020-08-17 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4266 | 4266 | 2020-08-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4267 | 4267 | 2020-08-19 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4268 | 4268 | 2020-08-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 4 | 0 | 0 | 0 |
4269 | 4269 | 2020-08-21 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 5 | 1 | 0 | 0 |
4270 | 4270 | 2020-08-22 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 5 | 0 | 0 | 0 |
4271 | 4271 | 2020-08-23 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 5 | 0 | 0 | 0 |
4272 | 4272 | 2020-08-24 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 6 | 1 | 0 | 0 |
4273 | 4273 | 2020-08-25 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 6 | 0 | 1 | 1 |
4274 | 4274 | 2020-08-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 6 | 0 | 1 | 0 |
4275 | 4275 | 2020-08-27 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 6 | 0 | 1 | 0 |
4276 | 4276 | 2020-08-28 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 6 | 0 | 1 | 0 |
4277 | 4277 | 2020-08-29 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 6 | 0 | 1 | 0 |
4278 | 4278 | 2020-08-30 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 6 | 0 | 1 | 0 |
4279 | 4279 | 2020-08-31 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 6 | 0 | 1 | 0 |
4280 | 4280 | 2020-09-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 6 | 0 | 1 | 0 |
4281 | 4281 | 2020-09-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 1 | 1 | 0 |
4282 | 4282 | 2020-09-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4283 | 4283 | 2020-09-04 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4284 | 4284 | 2020-09-05 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4285 | 4285 | 2020-09-06 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4286 | 4286 | 2020-09-07 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4287 | 4287 | 2020-09-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4288 | 4288 | 2020-09-09 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4289 | 4289 | 2020-09-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4290 | 4290 | 2020-09-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4291 | 4291 | 2020-09-12 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4292 | 4292 | 2020-09-13 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4293 | 4293 | 2020-09-14 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4294 | 4294 | 2020-09-15 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4295 | 4295 | 2020-09-16 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4296 | 4296 | 2020-09-17 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4297 | 4297 | 2020-09-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4298 | 4298 | 2020-09-19 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4299 | 4299 | 2020-09-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4300 | 4300 | 2020-09-21 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4301 | 4301 | 2020-09-22 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4302 | 4302 | 2020-09-23 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4303 | 4303 | 2020-09-24 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
4304 | 4304 | 2020-09-25 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 7 | 0 | 1 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdcr-prison-totals" ( [date] TEXT, [code] TEXT, [name] TEXT, [city] TEXT, [county] TEXT, [fips] INTEGER, [zipcode] INTEGER, [x] FLOAT, [y] FLOAT, [confirmed_cases] INTEGER, [new_confirmed_cases] INTEGER, [deaths] INTEGER, [new_deaths] INTEGER );