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 Medical Facility" sorted by new_deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, deaths, date (date)
Link | rowid | date | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7184 | 7184 | 2020-03-11 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7185 | 7185 | 2020-03-12 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7186 | 7186 | 2020-03-13 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7187 | 7187 | 2020-03-14 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7188 | 7188 | 2020-03-15 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7189 | 7189 | 2020-03-16 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7190 | 7190 | 2020-03-17 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7191 | 7191 | 2020-03-18 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7192 | 7192 | 2020-03-19 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7193 | 7193 | 2020-03-20 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7194 | 7194 | 2020-03-21 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7195 | 7195 | 2020-03-22 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7196 | 7196 | 2020-03-23 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7197 | 7197 | 2020-03-24 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7198 | 7198 | 2020-03-25 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7199 | 7199 | 2020-03-26 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7200 | 7200 | 2020-03-27 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7201 | 7201 | 2020-03-28 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7202 | 7202 | 2020-03-29 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7203 | 7203 | 2020-03-30 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7204 | 7204 | 2020-03-31 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7205 | 7205 | 2020-04-01 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7206 | 7206 | 2020-04-02 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7207 | 7207 | 2020-04-03 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7208 | 7208 | 2020-04-04 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7209 | 7209 | 2020-04-05 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7210 | 7210 | 2020-04-06 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7211 | 7211 | 2020-04-07 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7212 | 7212 | 2020-04-08 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7213 | 7213 | 2020-04-09 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7214 | 7214 | 2020-04-10 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7215 | 7215 | 2020-04-11 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7216 | 7216 | 2020-04-12 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7217 | 7217 | 2020-04-13 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7218 | 7218 | 2020-04-14 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7219 | 7219 | 2020-04-15 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7220 | 7220 | 2020-04-16 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7221 | 7221 | 2020-04-17 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7222 | 7222 | 2020-04-18 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7223 | 7223 | 2020-04-19 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7224 | 7224 | 2020-04-20 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7225 | 7225 | 2020-04-21 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7226 | 7226 | 2020-04-22 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7227 | 7227 | 2020-04-23 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7228 | 7228 | 2020-04-24 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7229 | 7229 | 2020-04-25 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7230 | 7230 | 2020-04-26 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7231 | 7231 | 2020-04-27 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7232 | 7232 | 2020-04-28 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7233 | 7233 | 2020-04-29 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7234 | 7234 | 2020-04-30 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7235 | 7235 | 2020-05-01 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7236 | 7236 | 2020-05-02 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7237 | 7237 | 2020-05-03 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7238 | 7238 | 2020-05-04 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7239 | 7239 | 2020-05-05 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7240 | 7240 | 2020-05-06 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7241 | 7241 | 2020-05-07 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7242 | 7242 | 2020-05-08 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7243 | 7243 | 2020-05-09 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7244 | 7244 | 2020-05-10 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7245 | 7245 | 2020-05-11 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7246 | 7246 | 2020-05-12 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7247 | 7247 | 2020-05-13 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7248 | 7248 | 2020-05-14 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7249 | 7249 | 2020-05-15 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7250 | 7250 | 2020-05-16 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7251 | 7251 | 2020-05-17 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7252 | 7252 | 2020-05-18 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7253 | 7253 | 2020-05-19 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7254 | 7254 | 2020-05-20 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7255 | 7255 | 2020-05-21 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7256 | 7256 | 2020-05-22 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7257 | 7257 | 2020-05-23 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7258 | 7258 | 2020-05-24 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7259 | 7259 | 2020-05-25 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7260 | 7260 | 2020-05-26 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7261 | 7261 | 2020-05-27 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7262 | 7262 | 2020-05-28 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7263 | 7263 | 2020-05-29 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7264 | 7264 | 2020-05-30 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7265 | 7265 | 2020-05-31 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7266 | 7266 | 2020-06-01 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7267 | 7267 | 2020-06-02 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7268 | 7268 | 2020-06-03 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7269 | 7269 | 2020-06-04 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7270 | 7270 | 2020-06-05 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7271 | 7271 | 2020-06-06 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7272 | 7272 | 2020-06-07 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7273 | 7273 | 2020-06-08 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7274 | 7274 | 2020-06-09 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7275 | 7275 | 2020-06-10 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7276 | 7276 | 2020-06-11 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7277 | 7277 | 2020-06-12 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7278 | 7278 | 2020-06-13 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7279 | 7279 | 2020-06-14 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7280 | 7280 | 2020-06-15 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7281 | 7281 | 2020-06-16 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7282 | 7282 | 2020-06-17 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 0 | 0 | 0 |
7283 | 7283 | 2020-06-18 | CMF | California Medical Facility | Vacaville | Solano | 95 | 95687 | -121.9793527 | 38.333213 | 0 | 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 );