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 confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|
24550 | 24550 | Modoc | Modoc | 49 | 2020-07-27 | 0 | 0 | TRUE |
24611 | 24611 | Modoc | Modoc | 49 | 2020-07-26 | 0 | 0 | TRUE |
24672 | 24672 | Modoc | Modoc | 49 | 2020-07-25 | 0 | 0 | TRUE |
24733 | 24733 | Modoc | Modoc | 49 | 2020-07-24 | 0 | 0 | TRUE |
24794 | 24794 | Modoc | Modoc | 49 | 2020-07-23 | 0 | 0 | TRUE |
24855 | 24855 | Modoc | Modoc | 49 | 2020-07-22 | 0 | 0 | TRUE |
24916 | 24916 | Modoc | Modoc | 49 | 2020-07-21 | 0 | 0 | TRUE |
24977 | 24977 | Modoc | Modoc | 49 | 2020-07-20 | 0 | 0 | TRUE |
25038 | 25038 | Modoc | Modoc | 49 | 2020-07-19 | 0 | 0 | TRUE |
25099 | 25099 | Modoc | Modoc | 49 | 2020-07-18 | 0 | 0 | TRUE |
25160 | 25160 | Modoc | Modoc | 49 | 2020-07-17 | 0 | 0 | TRUE |
25221 | 25221 | Modoc | Modoc | 49 | 2020-07-16 | 0 | 0 | |
25282 | 25282 | Modoc | Modoc | 49 | 2020-07-15 | 0 | 0 | TRUE |
25343 | 25343 | Modoc | Modoc | 49 | 2020-07-14 | 0 | 0 | TRUE |
25404 | 25404 | Modoc | Modoc | 49 | 2020-07-13 | 0 | 0 | TRUE |
25465 | 25465 | Modoc | Modoc | 49 | 2020-07-12 | 0 | 0 | TRUE |
25526 | 25526 | Modoc | Modoc | 49 | 2020-07-11 | 0 | 0 | TRUE |
25587 | 25587 | Modoc | Modoc | 49 | 2020-07-10 | 0 | 0 | TRUE |
25648 | 25648 | Modoc | Modoc | 49 | 2020-07-09 | 0 | 0 | TRUE |
25709 | 25709 | Modoc | Modoc | 49 | 2020-07-08 | 0 | 0 | TRUE |
25770 | 25770 | Modoc | Modoc | 49 | 2020-07-07 | 0 | 0 | TRUE |
25831 | 25831 | Modoc | Modoc | 49 | 2020-07-06 | 0 | 0 | |
25892 | 25892 | Modoc | Modoc | 49 | 2020-07-05 | 0 | 0 | TRUE |
25953 | 25953 | Modoc | Modoc | 49 | 2020-07-04 | 0 | 0 | |
26014 | 26014 | Modoc | Modoc | 49 | 2020-07-03 | 0 | 0 | |
26075 | 26075 | Modoc | Modoc | 49 | 2020-07-02 | 0 | 0 | TRUE |
26136 | 26136 | Modoc | Modoc | 49 | 2020-07-01 | 0 | 0 | TRUE |
26197 | 26197 | Modoc | Modoc | 49 | 2020-06-30 | 0 | 0 | TRUE |
26258 | 26258 | Modoc | Modoc | 49 | 2020-06-29 | 0 | 0 | TRUE |
26319 | 26319 | Modoc | Modoc | 49 | 2020-06-28 | 0 | 0 | TRUE |
26380 | 26380 | Modoc | Modoc | 49 | 2020-06-27 | 0 | 0 | TRUE |
26441 | 26441 | Modoc | Modoc | 49 | 2020-06-26 | 0 | 0 | TRUE |
26502 | 26502 | Modoc | Modoc | 49 | 2020-06-25 | 0 | 0 | TRUE |
26563 | 26563 | Modoc | Modoc | 49 | 2020-06-24 | 0 | 0 | TRUE |
26624 | 26624 | Modoc | Modoc | 49 | 2020-06-23 | 0 | 0 | TRUE |
26685 | 26685 | Modoc | Modoc | 49 | 2020-06-22 | 0 | 0 | TRUE |
26746 | 26746 | Modoc | Modoc | 49 | 2020-06-21 | 0 | 0 | TRUE |
26807 | 26807 | Modoc | Modoc | 49 | 2020-06-20 | 0 | 0 | TRUE |
26868 | 26868 | Modoc | Modoc | 49 | 2020-06-19 | 0 | 0 | |
26929 | 26929 | Modoc | Modoc | 49 | 2020-06-18 | 0 | 0 | TRUE |
26990 | 26990 | Modoc | Modoc | 49 | 2020-06-17 | 0 | 0 | TRUE |
27051 | 27051 | Modoc | Modoc | 49 | 2020-06-16 | 0 | 0 | TRUE |
27112 | 27112 | Modoc | Modoc | 49 | 2020-06-15 | 0 | 0 | |
27173 | 27173 | Modoc | Modoc | 49 | 2020-06-14 | 0 | 0 | TRUE |
27234 | 27234 | Modoc | Modoc | 49 | 2020-06-13 | 0 | 0 | TRUE |
27295 | 27295 | Modoc | Modoc | 49 | 2020-06-12 | 0 | 0 | TRUE |
27356 | 27356 | Modoc | Modoc | 49 | 2020-06-11 | 0 | 0 | TRUE |
27417 | 27417 | Modoc | Modoc | 49 | 2020-06-10 | 0 | 0 | TRUE |
27478 | 27478 | Modoc | Modoc | 49 | 2020-06-09 | 0 | 0 | TRUE |
27539 | 27539 | Modoc | Modoc | 49 | 2020-06-08 | 0 | 0 | TRUE |
27600 | 27600 | Modoc | Modoc | 49 | 2020-06-07 | 0 | 0 | TRUE |
27661 | 27661 | Modoc | Modoc | 49 | 2020-06-06 | 0 | 0 | TRUE |
27722 | 27722 | Modoc | Modoc | 49 | 2020-06-05 | 0 | 0 | TRUE |
27783 | 27783 | Modoc | Modoc | 49 | 2020-06-04 | 0 | 0 | |
27844 | 27844 | Modoc | Modoc | 49 | 2020-06-03 | 0 | 0 | |
27905 | 27905 | Modoc | Modoc | 49 | 2020-06-02 | 0 | 0 | |
27966 | 27966 | Modoc | Modoc | 49 | 2020-06-01 | 0 | 0 | |
28027 | 28027 | Modoc | Modoc | 49 | 2020-05-31 | 0 | 0 | TRUE |
28088 | 28088 | Modoc | Modoc | 49 | 2020-05-30 | 0 | 0 | TRUE |
28149 | 28149 | Modoc | Modoc | 49 | 2020-05-29 | 0 | 0 | TRUE |
28210 | 28210 | Modoc | Modoc | 49 | 2020-05-28 | 0 | 0 | |
28271 | 28271 | Modoc | Modoc | 49 | 2020-05-27 | 0 | 0 | TRUE |
28332 | 28332 | Modoc | Modoc | 49 | 2020-05-26 | 0 | 0 | |
28393 | 28393 | Modoc | Modoc | 49 | 2020-05-25 | 0 | 0 | TRUE |
28454 | 28454 | Modoc | Modoc | 49 | 2020-05-24 | 0 | 0 | TRUE |
28515 | 28515 | Modoc | Modoc | 49 | 2020-05-23 | 0 | 0 | TRUE |
28576 | 28576 | Modoc | Modoc | 49 | 2020-05-22 | 0 | 0 | |
28628 | 28628 | Lassen | Lassen | 35 | 2020-05-21 | 0 | 0 | |
28637 | 28637 | Modoc | Modoc | 49 | 2020-05-21 | 0 | 0 | |
28658 | 28658 | Sierra | Sierra | 91 | 2020-05-21 | 0 | 0 | |
28689 | 28689 | Lassen | Lassen | 35 | 2020-05-20 | 0 | 0 | |
28698 | 28698 | Modoc | Modoc | 49 | 2020-05-20 | 0 | 0 | |
28719 | 28719 | Sierra | Sierra | 91 | 2020-05-20 | 0 | 0 | |
28750 | 28750 | Lassen | Lassen | 35 | 2020-05-19 | 0 | 0 | TRUE |
28759 | 28759 | Modoc | Modoc | 49 | 2020-05-19 | 0 | 0 | |
28780 | 28780 | Sierra | Sierra | 91 | 2020-05-19 | 0 | 0 | |
28811 | 28811 | Lassen | Lassen | 35 | 2020-05-18 | 0 | 0 | TRUE |
28820 | 28820 | Modoc | Modoc | 49 | 2020-05-18 | 0 | 0 | TRUE |
28841 | 28841 | Sierra | Sierra | 91 | 2020-05-18 | 0 | 0 | TRUE |
28872 | 28872 | Lassen | Lassen | 35 | 2020-05-17 | 0 | 0 | |
28881 | 28881 | Modoc | Modoc | 49 | 2020-05-17 | 0 | 0 | TRUE |
28902 | 28902 | Sierra | Sierra | 91 | 2020-05-17 | 0 | 0 | TRUE |
28933 | 28933 | Lassen | Lassen | 35 | 2020-05-16 | 0 | 0 | TRUE |
28942 | 28942 | Modoc | Modoc | 49 | 2020-05-16 | 0 | 0 | TRUE |
28963 | 28963 | Sierra | Sierra | 91 | 2020-05-16 | 0 | 0 | TRUE |
28994 | 28994 | Lassen | Lassen | 35 | 2020-05-15 | 0 | 0 | |
29003 | 29003 | Modoc | Modoc | 49 | 2020-05-15 | 0 | 0 | |
29024 | 29024 | Sierra | Sierra | 91 | 2020-05-15 | 0 | 0 | |
29055 | 29055 | Lassen | Lassen | 35 | 2020-05-14 | 0 | 0 | TRUE |
29064 | 29064 | Modoc | Modoc | 49 | 2020-05-14 | 0 | 0 | TRUE |
29085 | 29085 | Sierra | Sierra | 91 | 2020-05-14 | 0 | 0 | |
29116 | 29116 | Lassen | Lassen | 35 | 2020-05-13 | 0 | 0 | |
29125 | 29125 | Modoc | Modoc | 49 | 2020-05-13 | 0 | 0 | |
29146 | 29146 | Sierra | Sierra | 91 | 2020-05-13 | 0 | 0 | |
29177 | 29177 | Lassen | Lassen | 35 | 2020-05-12 | 0 | 0 | |
29186 | 29186 | Modoc | Modoc | 49 | 2020-05-12 | 0 | 0 | TRUE |
29207 | 29207 | Sierra | Sierra | 91 | 2020-05-12 | 0 | 0 | |
29238 | 29238 | Lassen | Lassen | 35 | 2020-05-11 | 0 | 0 | TRUE |
29247 | 29247 | Modoc | Modoc | 49 | 2020-05-11 | 0 | 0 | TRUE |
29268 | 29268 | Sierra | Sierra | 91 | 2020-05-11 | 0 | 0 | TRUE |
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 );