latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
33,021 rows sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
fips >30
county >30
- Los Angeles 1,686
- Alameda 1,118
- Orange 586
- Santa Clara 586
- San Benito 581
- Humboldt 564
- Sacramento 564
- Solano 560
- Calaveras 559
- Contra Costa 559
- Marin 559
- Placer 559
- Riverside 559
- San Diego 559
- San Francisco 559
- San Mateo 559
- Santa Cruz 559
- Shasta 559
- Sonoma 559
- Stanislaus 559
- Ventura 559
- Yolo 559
- Fresno 555
- San Joaquin 551
- Madera 545
- Imperial 541
- Tulare 541
- Amador 539
- San Luis Obispo 538
- San Bernardino 537
- …
agency >30
- Los Angeles 586
- Orange 586
- Santa Clara 586
- San Benito 581
- Humboldt 564
- Sacramento 564
- Solano 560
- Alameda 559
- Berkeley 559
- Calaveras 559
- Contra Costa 559
- Long Beach 559
- Marin 559
- Placer 559
- Riverside 559
- San Diego 559
- San Francisco 559
- San Mateo 559
- Santa Cruz 559
- Shasta 559
- Sonoma 559
- Stanislaus 559
- Ventura 559
- Yolo 559
- Fresno 555
- San Joaquin 551
- Madera 545
- Imperial 541
- Pasadena 541
- Tulare 541
- …
Link | rowid | agency | county | fips | date | confirmed_cases | deaths ▼ | did_not_update |
---|---|---|---|---|---|---|---|---|
3 | 3 | Alpine | Alpine | 3 | 2021-09-02 | 89 | 0 | TRUE |
49 | 49 | Sierra | Sierra | 91 | 2021-09-02 | 198 | 0 | |
64 | 64 | Alpine | Alpine | 3 | 2021-09-01 | 89 | 0 | TRUE |
110 | 110 | Sierra | Sierra | 91 | 2021-09-01 | 191 | 0 | |
125 | 125 | Alpine | Alpine | 3 | 2021-08-31 | 89 | 0 | TRUE |
171 | 171 | Sierra | Sierra | 91 | 2021-08-31 | 188 | 0 | TRUE |
186 | 186 | Alpine | Alpine | 3 | 2021-08-30 | 89 | 0 | TRUE |
232 | 232 | Sierra | Sierra | 91 | 2021-08-30 | 188 | 0 | TRUE |
247 | 247 | Alpine | Alpine | 3 | 2021-08-29 | 89 | 0 | TRUE |
293 | 293 | Sierra | Sierra | 91 | 2021-08-29 | 188 | 0 | TRUE |
308 | 308 | Alpine | Alpine | 3 | 2021-08-28 | 89 | 0 | TRUE |
354 | 354 | Sierra | Sierra | 91 | 2021-08-28 | 188 | 0 | TRUE |
369 | 369 | Alpine | Alpine | 3 | 2021-08-27 | 89 | 0 | TRUE |
415 | 415 | Sierra | Sierra | 91 | 2021-08-27 | 188 | 0 | |
430 | 430 | Alpine | Alpine | 3 | 2021-08-26 | 89 | 0 | TRUE |
476 | 476 | Sierra | Sierra | 91 | 2021-08-26 | 188 | 0 | |
491 | 491 | Alpine | Alpine | 3 | 2021-08-25 | 89 | 0 | TRUE |
537 | 537 | Sierra | Sierra | 91 | 2021-08-25 | 175 | 0 | |
552 | 552 | Alpine | Alpine | 3 | 2021-08-24 | 89 | 0 | TRUE |
598 | 598 | Sierra | Sierra | 91 | 2021-08-24 | 174 | 0 | TRUE |
613 | 613 | Alpine | Alpine | 3 | 2021-08-23 | 89 | 0 | TRUE |
659 | 659 | Sierra | Sierra | 91 | 2021-08-23 | 174 | 0 | |
674 | 674 | Alpine | Alpine | 3 | 2021-08-22 | 89 | 0 | TRUE |
720 | 720 | Sierra | Sierra | 91 | 2021-08-22 | 160 | 0 | TRUE |
735 | 735 | Alpine | Alpine | 3 | 2021-08-21 | 89 | 0 | TRUE |
781 | 781 | Sierra | Sierra | 91 | 2021-08-21 | 160 | 0 | TRUE |
796 | 796 | Alpine | Alpine | 3 | 2021-08-20 | 89 | 0 | TRUE |
842 | 842 | Sierra | Sierra | 91 | 2021-08-20 | 160 | 0 | |
857 | 857 | Alpine | Alpine | 3 | 2021-08-19 | 89 | 0 | TRUE |
903 | 903 | Sierra | Sierra | 91 | 2021-08-19 | 158 | 0 | |
918 | 918 | Alpine | Alpine | 3 | 2021-08-18 | 89 | 0 | TRUE |
964 | 964 | Sierra | Sierra | 91 | 2021-08-18 | 154 | 0 | |
979 | 979 | Alpine | Alpine | 3 | 2021-08-17 | 89 | 0 | TRUE |
1025 | 1025 | Sierra | Sierra | 91 | 2021-08-17 | 154 | 0 | |
1040 | 1040 | Alpine | Alpine | 3 | 2021-08-16 | 89 | 0 | TRUE |
1086 | 1086 | Sierra | Sierra | 91 | 2021-08-16 | 152 | 0 | |
1101 | 1101 | Alpine | Alpine | 3 | 2021-08-15 | 89 | 0 | TRUE |
1147 | 1147 | Sierra | Sierra | 91 | 2021-08-15 | 150 | 0 | TRUE |
1162 | 1162 | Alpine | Alpine | 3 | 2021-08-14 | 89 | 0 | TRUE |
1208 | 1208 | Sierra | Sierra | 91 | 2021-08-14 | 150 | 0 | TRUE |
1223 | 1223 | Alpine | Alpine | 3 | 2021-08-13 | 89 | 0 | TRUE |
1269 | 1269 | Sierra | Sierra | 91 | 2021-08-13 | 150 | 0 | |
1284 | 1284 | Alpine | Alpine | 3 | 2021-08-12 | 89 | 0 | TRUE |
1330 | 1330 | Sierra | Sierra | 91 | 2021-08-12 | 150 | 0 | |
1345 | 1345 | Alpine | Alpine | 3 | 2021-08-11 | 89 | 0 | TRUE |
1391 | 1391 | Sierra | Sierra | 91 | 2021-08-11 | 146 | 0 | |
1406 | 1406 | Alpine | Alpine | 3 | 2021-08-10 | 89 | 0 | TRUE |
1452 | 1452 | Sierra | Sierra | 91 | 2021-08-10 | 143 | 0 | |
1467 | 1467 | Alpine | Alpine | 3 | 2021-08-09 | 89 | 0 | TRUE |
1513 | 1513 | Sierra | Sierra | 91 | 2021-08-09 | 140 | 0 | |
1528 | 1528 | Alpine | Alpine | 3 | 2021-08-08 | 89 | 0 | TRUE |
1574 | 1574 | Sierra | Sierra | 91 | 2021-08-08 | 138 | 0 | TRUE |
1589 | 1589 | Alpine | Alpine | 3 | 2021-08-07 | 89 | 0 | TRUE |
1635 | 1635 | Sierra | Sierra | 91 | 2021-08-07 | 138 | 0 | TRUE |
1650 | 1650 | Alpine | Alpine | 3 | 2021-08-06 | 89 | 0 | TRUE |
1696 | 1696 | Sierra | Sierra | 91 | 2021-08-06 | 138 | 0 | TRUE |
1711 | 1711 | Alpine | Alpine | 3 | 2021-08-05 | 89 | 0 | TRUE |
1757 | 1757 | Sierra | Sierra | 91 | 2021-08-05 | 138 | 0 | |
1772 | 1772 | Alpine | Alpine | 3 | 2021-08-04 | 89 | 0 | TRUE |
1818 | 1818 | Sierra | Sierra | 91 | 2021-08-04 | 137 | 0 | TRUE |
1833 | 1833 | Alpine | Alpine | 3 | 2021-08-03 | 89 | 0 | TRUE |
1879 | 1879 | Sierra | Sierra | 91 | 2021-08-03 | 137 | 0 | |
1894 | 1894 | Alpine | Alpine | 3 | 2021-08-02 | 89 | 0 | TRUE |
1940 | 1940 | Sierra | Sierra | 91 | 2021-08-02 | 133 | 0 | |
1955 | 1955 | Alpine | Alpine | 3 | 2021-08-01 | 89 | 0 | TRUE |
2001 | 2001 | Sierra | Sierra | 91 | 2021-08-01 | 131 | 0 | TRUE |
2016 | 2016 | Alpine | Alpine | 3 | 2021-07-31 | 89 | 0 | TRUE |
2062 | 2062 | Sierra | Sierra | 91 | 2021-07-31 | 131 | 0 | TRUE |
2077 | 2077 | Alpine | Alpine | 3 | 2021-07-30 | 89 | 0 | TRUE |
2123 | 2123 | Sierra | Sierra | 91 | 2021-07-30 | 131 | 0 | |
2138 | 2138 | Alpine | Alpine | 3 | 2021-07-29 | 89 | 0 | TRUE |
2184 | 2184 | Sierra | Sierra | 91 | 2021-07-29 | 129 | 0 | |
2199 | 2199 | Alpine | Alpine | 3 | 2021-07-28 | 89 | 0 | TRUE |
2245 | 2245 | Sierra | Sierra | 91 | 2021-07-28 | 126 | 0 | TRUE |
2260 | 2260 | Alpine | Alpine | 3 | 2021-07-27 | 89 | 0 | TRUE |
2306 | 2306 | Sierra | Sierra | 91 | 2021-07-27 | 126 | 0 | TRUE |
2321 | 2321 | Alpine | Alpine | 3 | 2021-07-26 | 89 | 0 | TRUE |
2367 | 2367 | Sierra | Sierra | 91 | 2021-07-26 | 126 | 0 | |
2382 | 2382 | Alpine | Alpine | 3 | 2021-07-25 | 89 | 0 | TRUE |
2428 | 2428 | Sierra | Sierra | 91 | 2021-07-25 | 125 | 0 | TRUE |
2443 | 2443 | Alpine | Alpine | 3 | 2021-07-24 | 89 | 0 | TRUE |
2489 | 2489 | Sierra | Sierra | 91 | 2021-07-24 | 125 | 0 | TRUE |
2504 | 2504 | Alpine | Alpine | 3 | 2021-07-23 | 89 | 0 | TRUE |
2550 | 2550 | Sierra | Sierra | 91 | 2021-07-23 | 125 | 0 | |
2565 | 2565 | Alpine | Alpine | 3 | 2021-07-22 | 89 | 0 | TRUE |
2611 | 2611 | Sierra | Sierra | 91 | 2021-07-22 | 124 | 0 | TRUE |
2626 | 2626 | Alpine | Alpine | 3 | 2021-07-21 | 89 | 0 | TRUE |
2672 | 2672 | Sierra | Sierra | 91 | 2021-07-21 | 124 | 0 | TRUE |
2687 | 2687 | Alpine | Alpine | 3 | 2021-07-20 | 89 | 0 | TRUE |
2733 | 2733 | Sierra | Sierra | 91 | 2021-07-20 | 124 | 0 | TRUE |
2748 | 2748 | Alpine | Alpine | 3 | 2021-07-19 | 89 | 0 | TRUE |
2794 | 2794 | Sierra | Sierra | 91 | 2021-07-19 | 124 | 0 | TRUE |
2809 | 2809 | Alpine | Alpine | 3 | 2021-07-18 | 89 | 0 | TRUE |
2855 | 2855 | Sierra | Sierra | 91 | 2021-07-18 | 124 | 0 | TRUE |
2870 | 2870 | Alpine | Alpine | 3 | 2021-07-17 | 89 | 0 | TRUE |
2916 | 2916 | Sierra | Sierra | 91 | 2021-07-17 | 124 | 0 | TRUE |
2931 | 2931 | Alpine | Alpine | 3 | 2021-07-16 | 89 | 0 | TRUE |
2977 | 2977 | Sierra | Sierra | 91 | 2021-07-16 | 124 | 0 | TRUE |
2992 | 2992 | Alpine | Alpine | 3 | 2021-07-15 | 89 | 0 | TRUE |
3038 | 3038 | Sierra | Sierra | 91 | 2021-07-15 | 124 | 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 );