latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
61 rows where "date" is on date 2021-03-22 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
10005 | 10005 | Alameda | Alameda | 1 | 2021-03-22 | 79783 | 1196 | |
10006 | 10006 | Berkeley | Alameda | 1 | 2021-03-22 | 3408 | 45 | |
10007 | 10007 | Alpine | Alpine | 3 | 2021-03-22 | 86 | 0 | TRUE |
10008 | 10008 | Amador | Amador | 5 | 2021-03-22 | 3490 | 45 | |
10009 | 10009 | Butte | Butte | 7 | 2021-03-22 | 11211 | 173 | |
10010 | 10010 | Calaveras | Calaveras | 9 | 2021-03-22 | 1972 | 51 | |
10011 | 10011 | Colusa | Colusa | 11 | 2021-03-22 | 2158 | 15 | |
10012 | 10012 | Contra Costa | Contra Costa | 13 | 2021-03-22 | 64695 | 734 | |
10013 | 10013 | Del Norte | Del Norte | 15 | 2021-03-22 | 1103 | 5 | |
10014 | 10014 | El Dorado | El Dorado | 17 | 2021-03-22 | 9374 | 107 | |
10015 | 10015 | Fresno | Fresno | 19 | 2021-03-22 | 98348 | 1568 | |
10016 | 10016 | Glenn | Glenn | 21 | 2021-03-22 | 2240 | 24 | |
10017 | 10017 | Humboldt | Humboldt | 23 | 2021-03-22 | 3426 | 34 | |
10018 | 10018 | Imperial | Imperial | 25 | 2021-03-22 | 26920 | 699 | |
10019 | 10019 | Inyo | Inyo | 27 | 2021-03-22 | 1388 | 37 | |
10020 | 10020 | Kern | Kern | 29 | 2021-03-22 | 105542 | 1094 | |
10021 | 10021 | Kings | Kings | 31 | 2021-03-22 | 22524 | 238 | |
10022 | 10022 | Lake | Lake | 33 | 2021-03-22 | 3274 | 43 | |
10023 | 10023 | Lassen | Lassen | 35 | 2021-03-22 | 5637 | 24 | |
10024 | 10024 | Long Beach | Los Angeles | 37 | 2021-03-22 | 51780 | 896 | |
10025 | 10025 | Los Angeles | Los Angeles | 37 | 2021-03-22 | 1151894 | 21588 | |
10026 | 10026 | Pasadena | Los Angeles | 37 | 2021-03-22 | 11080 | 331 | |
10027 | 10027 | Madera | Madera | 39 | 2021-03-22 | 15814 | 226 | |
10028 | 10028 | Marin | Marin | 41 | 2021-03-22 | 13552 | 199 | |
10029 | 10029 | Mariposa | Mariposa | 43 | 2021-03-22 | 403 | 7 | |
10030 | 10030 | Mendocino | Mendocino | 45 | 2021-03-22 | 3920 | 46 | |
10031 | 10031 | Merced | Merced | 47 | 2021-03-22 | 30257 | 429 | |
10032 | 10032 | Modoc | Modoc | 49 | 2021-03-22 | 469 | 4 | |
10033 | 10033 | Mono | Mono | 51 | 2021-03-22 | 1250 | 4 | |
10034 | 10034 | Monterey | Monterey | 53 | 2021-03-22 | 42734 | 337 | TRUE |
10035 | 10035 | Napa | Napa | 55 | 2021-03-22 | 9279 | 75 | |
10036 | 10036 | Nevada | Nevada | 57 | 2021-03-22 | 4179 | 74 | |
10037 | 10037 | Orange | Orange | 59 | 2021-03-22 | 249641 | 4608 | |
10038 | 10038 | Placer | Placer | 61 | 2021-03-22 | 20603 | 248 | |
10039 | 10039 | Plumas | Plumas | 63 | 2021-03-22 | 672 | 6 | |
10040 | 10040 | Riverside | Riverside | 65 | 2021-03-22 | 293149 | 4141 | |
10041 | 10041 | Sacramento | Sacramento | 67 | 2021-03-22 | 96377 | 1582 | |
10042 | 10042 | San Benito | San Benito | 69 | 2021-03-22 | 5830 | 61 | |
10043 | 10043 | San Bernardino | San Bernardino | 71 | 2021-03-22 | 289846 | 4714 | |
10044 | 10044 | San Diego | San Diego | 73 | 2021-03-22 | 267917 | 3494 | |
10045 | 10045 | San Francisco | San Francisco | 75 | 2021-03-22 | 34781 | 451 | |
10046 | 10046 | San Joaquin | San Joaquin | 77 | 2021-03-22 | 68855 | 1231 | |
10047 | 10047 | San Luis Obispo | San Luis Obispo | 79 | 2021-03-22 | 20260 | 253 | |
10048 | 10048 | San Mateo | San Mateo | 81 | 2021-03-22 | 39837 | 543 | |
10049 | 10049 | Santa Barbara | Santa Barbara | 83 | 2021-03-22 | 32873 | 435 | |
10050 | 10050 | Santa Clara | Santa Clara | 85 | 2021-03-22 | 112965 | 1641 | |
10051 | 10051 | Santa Cruz | Santa Cruz | 87 | 2021-03-22 | 15225 | 197 | |
10052 | 10052 | Shasta | Shasta | 89 | 2021-03-22 | 11179 | 199 | |
10053 | 10053 | Sierra | Sierra | 91 | 2021-03-22 | 103 | 0 | |
10054 | 10054 | Siskiyou | Siskiyou | 93 | 2021-03-22 | 1853 | 15 | |
10055 | 10055 | Solano | Solano | 95 | 2021-03-22 | 30834 | 187 | |
10056 | 10056 | Sonoma | Sonoma | 97 | 2021-03-22 | 29006 | 308 | |
10057 | 10057 | Stanislaus | Stanislaus | 99 | 2021-03-22 | 52137 | 980 | |
10058 | 10058 | Sutter | Sutter | 101 | 2021-03-22 | 9060 | 102 | |
10059 | 10059 | Tehama | Tehama | 103 | 2021-03-22 | 5213 | 54 | TRUE |
10060 | 10060 | Trinity | Trinity | 105 | 2021-03-22 | 385 | 5 | |
10061 | 10061 | Tulare | Tulare | 107 | 2021-03-22 | 48832 | 799 | |
10062 | 10062 | Tuolumne | Tuolumne | 109 | 2021-03-22 | 4014 | 62 | |
10063 | 10063 | Ventura | Ventura | 111 | 2021-03-22 | 79219 | 950 | |
10064 | 10064 | Yolo | Yolo | 113 | 2021-03-22 | 13122 | 191 | |
10065 | 10065 | Yuba | Yuba | 115 | 2021-03-22 | 5912 | 40 |
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 );