latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
23 rows where "date" is on date 2020-02-28 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips 23
county 23
- Alameda 1
- Calaveras 1
- Contra Costa 1
- Fresno 1
- Humboldt 1
- Los Angeles 1
- Marin 1
- Orange 1
- Placer 1
- Riverside 1
- Sacramento 1
- San Benito 1
- San Diego 1
- San Francisco 1
- San Mateo 1
- Santa Clara 1
- Santa Cruz 1
- Shasta 1
- Solano 1
- Sonoma 1
- Stanislaus 1
- Ventura 1
- Yolo 1
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
31092 | 31092 | 2020-02-28 | Alameda | 1 | 3 | 0 | 2 | 0 |
31093 | 31093 | 2020-02-28 | Calaveras | 9 | 0 | 0 | 0 | 0 |
31094 | 31094 | 2020-02-28 | Contra Costa | 13 | 0 | 0 | 0 | 0 |
31095 | 31095 | 2020-02-28 | Fresno | 19 | 1 | 0 | 0 | 0 |
31096 | 31096 | 2020-02-28 | Humboldt | 23 | 1 | 0 | 0 | 0 |
31097 | 31097 | 2020-02-28 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31098 | 31098 | 2020-02-28 | Marin | 41 | 0 | 0 | 0 | 0 |
31099 | 31099 | 2020-02-28 | Orange | 59 | 1 | 0 | 0 | 0 |
31100 | 31100 | 2020-02-28 | Placer | 61 | 0 | 0 | 0 | 0 |
31101 | 31101 | 2020-02-28 | Riverside | 65 | 0 | 0 | 0 | 0 |
31102 | 31102 | 2020-02-28 | Sacramento | 67 | 1 | 0 | 0 | 0 |
31103 | 31103 | 2020-02-28 | San Benito | 69 | 2 | 0 | 0 | 0 |
31104 | 31104 | 2020-02-28 | San Diego | 73 | 0 | 0 | 0 | 0 |
31105 | 31105 | 2020-02-28 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31106 | 31106 | 2020-02-28 | San Mateo | 81 | 0 | 0 | 0 | 0 |
31107 | 31107 | 2020-02-28 | Santa Clara | 85 | 12 | 2 | 2 | 0 |
31108 | 31108 | 2020-02-28 | Santa Cruz | 87 | 0 | 0 | 0 | 0 |
31109 | 31109 | 2020-02-28 | Shasta | 89 | 0 | 0 | 0 | 0 |
31110 | 31110 | 2020-02-28 | Solano | 95 | 2 | 0 | 1 | 0 |
31111 | 31111 | 2020-02-28 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31112 | 31112 | 2020-02-28 | Stanislaus | 99 | 0 | 0 | 0 | 0 |
31113 | 31113 | 2020-02-28 | Ventura | 111 | 0 | 0 | 0 | 0 |
31114 | 31114 | 2020-02-28 | Yolo | 113 | 0 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );