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.
71 rows where confirmed_cases = 1003 and name = "California City Correctional Facility"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1420 | 1420 | 2021-04-07 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 1 | 2 | 0 |
1421 | 1421 | 2021-04-08 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1422 | 1422 | 2021-04-09 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1423 | 1423 | 2021-04-10 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1424 | 1424 | 2021-04-11 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1425 | 1425 | 2021-04-12 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1426 | 1426 | 2021-04-13 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1427 | 1427 | 2021-04-14 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1428 | 1428 | 2021-04-15 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1429 | 1429 | 2021-04-16 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1430 | 1430 | 2021-04-17 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1431 | 1431 | 2021-04-18 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1432 | 1432 | 2021-04-19 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1433 | 1433 | 2021-04-20 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1434 | 1434 | 2021-04-21 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1435 | 1435 | 2021-04-22 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1436 | 1436 | 2021-04-23 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1437 | 1437 | 2021-04-24 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1438 | 1438 | 2021-04-25 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1439 | 1439 | 2021-04-26 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1440 | 1440 | 2021-04-27 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1441 | 1441 | 2021-04-28 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1442 | 1442 | 2021-04-29 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1443 | 1443 | 2021-04-30 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1444 | 1444 | 2021-05-01 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1445 | 1445 | 2021-05-02 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1446 | 1446 | 2021-05-03 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1447 | 1447 | 2021-05-04 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1448 | 1448 | 2021-05-05 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1449 | 1449 | 2021-05-06 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1450 | 1450 | 2021-05-07 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1451 | 1451 | 2021-05-08 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1452 | 1452 | 2021-05-09 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1453 | 1453 | 2021-05-10 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1454 | 1454 | 2021-05-11 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1455 | 1455 | 2021-05-12 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1456 | 1456 | 2021-05-13 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1457 | 1457 | 2021-05-14 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1458 | 1458 | 2021-05-15 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1459 | 1459 | 2021-05-16 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1460 | 1460 | 2021-05-17 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1461 | 1461 | 2021-05-18 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1462 | 1462 | 2021-05-19 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1463 | 1463 | 2021-05-20 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1464 | 1464 | 2021-05-21 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1465 | 1465 | 2021-05-22 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1466 | 1466 | 2021-05-23 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1467 | 1467 | 2021-05-24 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1468 | 1468 | 2021-05-25 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1469 | 1469 | 2021-05-26 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1470 | 1470 | 2021-05-27 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1471 | 1471 | 2021-05-28 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1472 | 1472 | 2021-05-29 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1473 | 1473 | 2021-05-30 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1474 | 1474 | 2021-05-31 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1475 | 1475 | 2021-06-01 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1476 | 1476 | 2021-06-02 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1477 | 1477 | 2021-06-03 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1478 | 1478 | 2021-06-04 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1479 | 1479 | 2021-06-05 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1480 | 1480 | 2021-06-06 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1481 | 1481 | 2021-06-07 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1482 | 1482 | 2021-06-08 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1483 | 1483 | 2021-06-09 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1484 | 1484 | 2021-06-10 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1485 | 1485 | 2021-06-11 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1486 | 1486 | 2021-06-12 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1487 | 1487 | 2021-06-13 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1488 | 1488 | 2021-06-14 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1489 | 1489 | 2021-06-15 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 0 |
1490 | 1490 | 2021-06-16 | CAC | California City Correctional Facility | California City | Kern | 29 | 93505 | -117.858308 | 35.152328 | 1003 | 0 | 2 | 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 );