latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
39 rows where "date" is on date 2020-03-20 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, did_not_update
fips >30
county >30
- Los Angeles 3
- Alameda 2
- Amador 1
- Calaveras 1
- Contra Costa 1
- El Dorado 1
- Fresno 1
- Humboldt 1
- Imperial 1
- Kern 1
- Madera 1
- Marin 1
- Mendocino 1
- Monterey 1
- Nevada 1
- Orange 1
- Placer 1
- Riverside 1
- Sacramento 1
- San Benito 1
- San Bernardino 1
- San Diego 1
- San Francisco 1
- San Joaquin 1
- San Luis Obispo 1
- San Mateo 1
- Santa Barbara 1
- Santa Clara 1
- Santa Cruz 1
- Shasta 1
- …
agency >30
- Alameda 1
- Amador 1
- Berkeley 1
- Calaveras 1
- Contra Costa 1
- El Dorado 1
- Fresno 1
- Humboldt 1
- Imperial 1
- Kern 1
- Long Beach 1
- Los Angeles 1
- Madera 1
- Marin 1
- Mendocino 1
- Monterey 1
- Nevada 1
- Orange 1
- Pasadena 1
- Placer 1
- Riverside 1
- Sacramento 1
- San Benito 1
- San Bernardino 1
- San Diego 1
- San Francisco 1
- San Joaquin 1
- San Luis Obispo 1
- San Mateo 1
- Santa Barbara 1
- …
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
32104 | 32104 | Alameda | Alameda | 1 | 2020-03-20 | 72 | 4 | |
32105 | 32105 | Berkeley | Alameda | 1 | 2020-03-20 | 4 | 0 | |
32106 | 32106 | Amador | Amador | 5 | 2020-03-20 | 1 | 0 | |
32107 | 32107 | Calaveras | Calaveras | 9 | 2020-03-20 | 2 | 0 | |
32108 | 32108 | Contra Costa | Contra Costa | 13 | 2020-03-20 | 47 | 1 | |
32109 | 32109 | El Dorado | El Dorado | 17 | 2020-03-20 | 2 | 0 | |
32110 | 32110 | Fresno | Fresno | 19 | 2020-03-20 | 90 | 0 | |
32111 | 32111 | Humboldt | Humboldt | 23 | 2020-03-20 | 2 | 0 | |
32112 | 32112 | Imperial | Imperial | 25 | 2020-03-20 | 4 | 0 | |
32113 | 32113 | Kern | Kern | 29 | 2020-03-20 | 3 | 0 | |
32114 | 32114 | Long Beach | Los Angeles | 37 | 2020-03-20 | 14 | 0 | |
32115 | 32115 | Los Angeles | Los Angeles | 37 | 2020-03-20 | 278 | 2 | |
32116 | 32116 | Pasadena | Los Angeles | 37 | 2020-03-20 | 3 | 0 | |
32117 | 32117 | Madera | Madera | 39 | 2020-03-20 | 3 | 0 | |
32118 | 32118 | Marin | Marin | 41 | 2020-03-20 | 38 | 0 | |
32119 | 32119 | Mendocino | Mendocino | 45 | 2020-03-20 | 1 | 0 | TRUE |
32120 | 32120 | Monterey | Monterey | 53 | 2020-03-20 | 5 | 0 | |
32121 | 32121 | Nevada | Nevada | 57 | 2020-03-20 | 1 | 0 | |
32122 | 32122 | Orange | Orange | 59 | 2020-03-20 | 64 | 0 | |
32123 | 32123 | Placer | Placer | 61 | 2020-03-20 | 9 | 1 | |
32124 | 32124 | Riverside | Riverside | 65 | 2020-03-20 | 28 | 4 | |
32125 | 32125 | Sacramento | Sacramento | 67 | 2020-03-20 | 53 | 3 | |
32126 | 32126 | San Benito | San Benito | 69 | 2020-03-20 | 5 | 1 | TRUE |
32127 | 32127 | San Bernardino | San Bernardino | 71 | 2020-03-20 | 9 | 0 | |
32128 | 32128 | San Diego | San Diego | 73 | 2020-03-20 | 100 | 0 | |
32129 | 32129 | San Francisco | San Francisco | 75 | 2020-03-20 | 76 | 0 | |
32130 | 32130 | San Joaquin | San Joaquin | 77 | 2020-03-20 | 17 | 2 | |
32131 | 32131 | San Luis Obispo | San Luis Obispo | 79 | 2020-03-20 | 16 | 0 | |
32132 | 32132 | San Mateo | San Mateo | 81 | 2020-03-20 | 100 | 1 | |
32133 | 32133 | Santa Barbara | Santa Barbara | 83 | 2020-03-20 | 9 | 0 | |
32134 | 32134 | Santa Clara | Santa Clara | 85 | 2020-03-20 | 506 | 12 | |
32135 | 32135 | Santa Cruz | Santa Cruz | 87 | 2020-03-20 | 15 | 0 | |
32136 | 32136 | Shasta | Shasta | 89 | 2020-03-20 | 1 | 0 | |
32137 | 32137 | Solano | Solano | 95 | 2020-03-20 | 13 | 0 | |
32138 | 32138 | Sonoma | Sonoma | 97 | 2020-03-20 | 22 | 1 | |
32139 | 32139 | Stanislaus | Stanislaus | 99 | 2020-03-20 | 5 | 0 | |
32140 | 32140 | Tulare | Tulare | 107 | 2020-03-20 | 11 | 0 | |
32141 | 32141 | Ventura | Ventura | 111 | 2020-03-20 | 19 | 0 | |
32142 | 32142 | Yolo | Yolo | 113 | 2020-03-20 | 6 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );