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.
63 rows where new_confirmed_cases = 2 and y = "37.8947278"
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_deaths, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4356 | 4356 | 2020-11-16 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 14 | 2 | 1 | 0 |
4359 | 4359 | 2020-11-19 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 20 | 2 | 1 | 0 |
4360 | 4360 | 2020-11-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 22 | 2 | 1 | 0 |
4371 | 4371 | 2020-12-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 30 | 2 | 1 | 0 |
4373 | 4373 | 2020-12-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 36 | 2 | 1 | 0 |
4376 | 4376 | 2020-12-06 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 39 | 2 | 1 | 0 |
4378 | 4378 | 2020-12-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 41 | 2 | 1 | 0 |
4382 | 4382 | 2020-12-12 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 51 | 2 | 1 | 0 |
4392 | 4392 | 2020-12-22 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 191 | 2 | 3 | 0 |
4397 | 4397 | 2020-12-27 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 349 | 2 | 4 | 0 |
4415 | 4415 | 2021-01-14 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 566 | 2 | 11 | 1 |
4427 | 4427 | 2021-01-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 595 | 2 | 13 | 1 |
4435 | 4435 | 2021-02-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 614 | 2 | 15 | 1 |
4441 | 4441 | 2021-02-09 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 617 | 2 | 18 | 0 |
4499 | 4499 | 2021-04-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 628 | 2 | 18 | 0 |
4630 | 4630 | 2021-08-17 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 654 | 2 | 19 | 0 |
4665 | 4665 | 2021-09-21 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 659 | 2 | 19 | 0 |
4770 | 4770 | 2022-01-04 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 682 | 2 | 19 | 0 |
4771 | 4771 | 2022-01-05 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 684 | 2 | 19 | 0 |
4772 | 4772 | 2022-01-06 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 686 | 2 | 19 | 0 |
4776 | 4776 | 2022-01-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 732 | 2 | 19 | 0 |
4780 | 4780 | 2022-01-14 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 742 | 2 | 19 | 0 |
4784 | 4784 | 2022-01-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 806 | 2 | 19 | 0 |
4793 | 4793 | 2022-01-27 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 864 | 2 | 19 | 0 |
4798 | 4798 | 2022-02-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 879 | 2 | 20 | 0 |
4806 | 4806 | 2022-02-09 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 884 | 2 | 20 | 0 |
4822 | 4822 | 2022-02-25 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 891 | 2 | 20 | 0 |
4888 | 4888 | 2022-05-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 901 | 2 | 20 | 0 |
4904 | 4904 | 2022-05-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1006 | 2 | 20 | 0 |
4907 | 4907 | 2022-05-21 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1054 | 2 | 20 | 0 |
4926 | 4926 | 2022-06-09 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1272 | 2 | 22 | 0 |
4931 | 4931 | 2022-06-14 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1285 | 2 | 22 | 0 |
4935 | 4935 | 2022-06-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1293 | 2 | 22 | 0 |
4940 | 4940 | 2022-06-23 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1318 | 2 | 22 | 0 |
4941 | 4941 | 2022-06-24 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1320 | 2 | 22 | 0 |
4943 | 4943 | 2022-06-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1334 | 2 | 22 | 0 |
4948 | 4948 | 2022-07-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1352 | 2 | 22 | 0 |
4951 | 4951 | 2022-07-04 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1356 | 2 | 22 | 0 |
4952 | 4952 | 2022-07-05 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1358 | 2 | 22 | 0 |
4953 | 4953 | 2022-07-06 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1360 | 2 | 22 | 0 |
4955 | 4955 | 2022-07-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1363 | 2 | 22 | 0 |
4958 | 4958 | 2022-07-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1365 | 2 | 22 | 0 |
4960 | 4960 | 2022-07-13 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1370 | 2 | 22 | 0 |
4967 | 4967 | 2022-07-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1377 | 2 | 22 | 0 |
4970 | 4970 | 2022-07-23 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1381 | 2 | 22 | 0 |
4974 | 4974 | 2022-07-27 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1384 | 2 | 22 | 0 |
4975 | 4975 | 2022-07-28 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1386 | 2 | 22 | 0 |
4991 | 4991 | 2022-08-13 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1396 | 2 | 22 | 0 |
5001 | 5001 | 2022-08-23 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1399 | 2 | 22 | 0 |
5016 | 5016 | 2022-09-07 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1734 | 2 | 22 | 0 |
5020 | 5020 | 2022-09-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1756 | 2 | 22 | 0 |
5024 | 5024 | 2022-09-15 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1778 | 2 | 22 | 0 |
5027 | 5027 | 2022-09-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1792 | 2 | 22 | 0 |
5033 | 5033 | 2022-09-24 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1802 | 2 | 22 | 0 |
5044 | 5044 | 2022-10-05 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1833 | 2 | 22 | 0 |
5047 | 5047 | 2022-10-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1835 | 2 | 22 | 0 |
5049 | 5049 | 2022-10-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1837 | 2 | 22 | 0 |
5111 | 5111 | 2022-12-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1870 | 2 | 23 | 0 |
5112 | 5112 | 2022-12-12 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1872 | 2 | 23 | 0 |
5116 | 5116 | 2022-12-16 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1878 | 2 | 23 | 0 |
5118 | 5118 | 2022-12-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1884 | 2 | 23 | 0 |
5122 | 5122 | 2022-12-22 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1896 | 2 | 23 | 0 |
5128 | 5128 | 2022-12-28 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1908 | 2 | 23 | 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 );