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.
31 rows where confirmed_cases = 225 and name = "Pelican Bay State Prison"
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_confirmed_cases, date (date)
Link | rowid ▼ | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28112 | 28112 | 2021-04-23 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 1 | 0 | 0 |
28113 | 28113 | 2021-04-24 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28114 | 28114 | 2021-04-25 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28115 | 28115 | 2021-04-26 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28116 | 28116 | 2021-04-27 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28117 | 28117 | 2021-04-28 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28118 | 28118 | 2021-04-29 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28119 | 28119 | 2021-04-30 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28120 | 28120 | 2021-05-01 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28121 | 28121 | 2021-05-02 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28122 | 28122 | 2021-05-03 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28123 | 28123 | 2021-05-04 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28124 | 28124 | 2021-05-05 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28125 | 28125 | 2021-05-06 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28126 | 28126 | 2021-05-07 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28127 | 28127 | 2021-05-08 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28128 | 28128 | 2021-05-09 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28129 | 28129 | 2021-05-10 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28130 | 28130 | 2021-05-11 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28131 | 28131 | 2021-05-12 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28132 | 28132 | 2021-05-13 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28133 | 28133 | 2021-05-14 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28134 | 28134 | 2021-05-15 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28135 | 28135 | 2021-05-16 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28136 | 28136 | 2021-05-17 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28137 | 28137 | 2021-05-18 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28138 | 28138 | 2021-05-19 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28139 | 28139 | 2021-05-20 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28140 | 28140 | 2021-05-21 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28141 | 28141 | 2021-05-22 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 0 |
28142 | 28142 | 2021-05-23 | PBSP | Pelican Bay State Prison | Crescent City | Del Norte | 15 | 95531 | -124.1583686 | 41.8504388 | 225 | 0 | 0 | 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 );