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 row where "date" is on date 2020-11-12 and name = "Mule Creek State Prison"

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

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
);