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 new_confirmed_cases descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, deaths, new_deaths, date (date)
Link | rowid | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases ▲ | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4105 | 4105 | 2020-03-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 0 | 0 | ||
5012 | 5012 | 2022-09-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1683 | 80 | 22 | 0 |
4394 | 4394 | 2020-12-24 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 338 | 79 | 3 | 0 |
4393 | 4393 | 2020-12-23 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 259 | 68 | 3 | 0 |
4402 | 4402 | 2021-01-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 503 | 62 | 5 | 0 |
4386 | 4386 | 2020-12-16 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 131 | 58 | 2 | 0 |
5007 | 5007 | 2022-08-29 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1465 | 57 | 22 | 0 |
5010 | 5010 | 2022-09-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1592 | 57 | 22 | 0 |
5009 | 5009 | 2022-08-31 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1535 | 55 | 22 | 0 |
4387 | 4387 | 2020-12-17 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 180 | 49 | 2 | 0 |
4781 | 4781 | 2022-01-15 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 791 | 49 | 19 | 0 |
4909 | 4909 | 2022-05-23 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1101 | 47 | 20 | 0 |
4400 | 4400 | 2020-12-30 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 407 | 45 | 4 | 0 |
4774 | 4774 | 2022-01-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 730 | 44 | 19 | 0 |
5014 | 5014 | 2022-09-05 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1727 | 41 | 22 | 0 |
4906 | 4906 | 2022-05-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1052 | 38 | 20 | 0 |
4401 | 4401 | 2020-12-31 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 441 | 34 | 5 | 1 |
4916 | 4916 | 2022-05-30 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1218 | 27 | 22 | 1 |
4913 | 4913 | 2022-05-27 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1177 | 26 | 20 | 0 |
4790 | 4790 | 2022-01-24 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 858 | 25 | 19 | 0 |
4903 | 4903 | 2022-05-17 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1004 | 25 | 20 | 0 |
4788 | 4788 | 2022-01-22 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 832 | 22 | 19 | 0 |
4405 | 4405 | 2021-01-04 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 529 | 19 | 7 | 0 |
4912 | 4912 | 2022-05-26 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1151 | 19 | 20 | 0 |
5022 | 5022 | 2022-09-13 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1775 | 19 | 22 | 0 |
4911 | 4911 | 2022-05-25 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1132 | 18 | 20 | 0 |
5036 | 5036 | 2022-09-27 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1820 | 18 | 22 | 0 |
4384 | 4384 | 2020-12-14 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 69 | 17 | 2 | 0 |
4407 | 4407 | 2021-01-06 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 550 | 17 | 9 | 2 |
4936 | 4936 | 2022-06-19 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1310 | 17 | 22 | 0 |
4901 | 4901 | 2022-05-15 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 969 | 16 | 20 | 0 |
5008 | 5008 | 2022-08-30 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1480 | 15 | 22 | 0 |
4896 | 4896 | 2022-05-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 935 | 14 | 20 | 0 |
4419 | 4419 | 2021-01-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 580 | 13 | 12 | 0 |
4910 | 4910 | 2022-05-24 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1114 | 13 | 20 | 0 |
4914 | 4914 | 2022-05-28 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1190 | 13 | 21 | 1 |
4946 | 4946 | 2022-06-29 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1349 | 13 | 22 | 0 |
4783 | 4783 | 2022-01-17 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 804 | 12 | 19 | 0 |
4942 | 4942 | 2022-06-25 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1332 | 12 | 22 | 0 |
4797 | 4797 | 2022-01-31 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 877 | 11 | 20 | 1 |
5011 | 5011 | 2022-09-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1603 | 11 | 22 | 0 |
5026 | 5026 | 2022-09-17 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1790 | 11 | 22 | 0 |
4902 | 4902 | 2022-05-16 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 979 | 10 | 20 | 0 |
4919 | 4919 | 2022-06-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1233 | 10 | 22 | 0 |
4920 | 4920 | 2022-06-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1243 | 10 | 22 | 0 |
5018 | 5018 | 2022-09-09 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1749 | 10 | 22 | 0 |
4399 | 4399 | 2020-12-29 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 362 | 9 | 4 | 0 |
4395 | 4395 | 2020-12-25 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 346 | 8 | 3 | 0 |
4777 | 4777 | 2022-01-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 740 | 8 | 19 | 0 |
4905 | 4905 | 2022-05-19 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1014 | 8 | 20 | 0 |
4921 | 4921 | 2022-06-04 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1251 | 8 | 22 | 0 |
4923 | 4923 | 2022-06-06 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1262 | 8 | 22 | 0 |
4927 | 4927 | 2022-06-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1280 | 8 | 22 | 0 |
4428 | 4428 | 2021-01-27 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 602 | 7 | 13 | 0 |
5119 | 5119 | 2022-12-19 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1891 | 7 | 23 | 0 |
4937 | 4937 | 2022-06-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1316 | 6 | 22 | 0 |
5056 | 5056 | 2022-10-17 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1845 | 6 | 22 | 0 |
4412 | 4412 | 2021-01-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 559 | 5 | 10 | 0 |
4414 | 4414 | 2021-01-13 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 564 | 5 | 10 | 0 |
4421 | 4421 | 2021-01-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 588 | 5 | 12 | 0 |
4426 | 4426 | 2021-01-25 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 593 | 5 | 12 | 0 |
4897 | 4897 | 2022-05-11 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 940 | 5 | 20 | 0 |
4898 | 4898 | 2022-05-12 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 945 | 5 | 20 | 0 |
4918 | 4918 | 2022-06-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1223 | 5 | 22 | 0 |
4932 | 4932 | 2022-06-15 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1290 | 5 | 22 | 0 |
5002 | 5002 | 2022-08-24 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1404 | 5 | 22 | 0 |
5015 | 5015 | 2022-09-06 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1732 | 5 | 22 | 0 |
5017 | 5017 | 2022-09-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1739 | 5 | 22 | 0 |
5019 | 5019 | 2022-09-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1754 | 5 | 22 | 0 |
5043 | 5043 | 2022-10-04 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1831 | 5 | 22 | 0 |
5127 | 5127 | 2022-12-27 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1906 | 5 | 23 | 0 |
4365 | 4365 | 2020-11-25 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 27 | 4 | 1 | 0 |
4372 | 4372 | 2020-12-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 34 | 4 | 1 | 0 |
4379 | 4379 | 2020-12-09 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 45 | 4 | 1 | 0 |
4380 | 4380 | 2020-12-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 49 | 4 | 1 | 0 |
4385 | 4385 | 2020-12-15 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 73 | 4 | 2 | 0 |
4390 | 4390 | 2020-12-20 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 188 | 4 | 3 | 1 |
4398 | 4398 | 2020-12-28 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 353 | 4 | 4 | 0 |
4404 | 4404 | 2021-01-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 510 | 4 | 7 | 1 |
4406 | 4406 | 2021-01-05 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 533 | 4 | 7 | 0 |
4431 | 4431 | 2021-01-30 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 607 | 4 | 14 | 0 |
4769 | 4769 | 2022-01-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 680 | 4 | 19 | 0 |
4889 | 4889 | 2022-05-03 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 905 | 4 | 20 | 0 |
4891 | 4891 | 2022-05-05 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 909 | 4 | 20 | 0 |
4894 | 4894 | 2022-05-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 917 | 4 | 20 | 0 |
4895 | 4895 | 2022-05-09 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 921 | 4 | 20 | 0 |
4899 | 4899 | 2022-05-13 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 949 | 4 | 20 | 0 |
4900 | 4900 | 2022-05-14 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 953 | 4 | 20 | 0 |
4924 | 4924 | 2022-06-07 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1266 | 4 | 22 | 0 |
4925 | 4925 | 2022-06-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1270 | 4 | 22 | 0 |
5117 | 5117 | 2022-12-17 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 1882 | 4 | 23 | 0 |
4357 | 4357 | 2020-11-17 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 17 | 3 | 1 | 0 |
4388 | 4388 | 2020-12-18 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 183 | 3 | 2 | 0 |
4403 | 4403 | 2021-01-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 506 | 3 | 6 | 1 |
4409 | 4409 | 2021-01-08 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 554 | 3 | 9 | 0 |
4420 | 4420 | 2021-01-19 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 583 | 3 | 12 | 0 |
4432 | 4432 | 2021-01-31 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 610 | 3 | 14 | 0 |
4531 | 4531 | 2021-05-10 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 635 | 3 | 19 | 0 |
4767 | 4767 | 2022-01-01 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 673 | 3 | 19 | 0 |
4768 | 4768 | 2022-01-02 | CHCF | California Health Care Facility | Stockton | San Joaquin | 77 | 95201 | -121.1848441 | 37.8947278 | 676 | 3 | 19 | 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 );