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 2020-09-23 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 |
---|---|---|---|---|---|---|---|---|
20985 | 20985 | Alameda | Alameda | 1 | 2020-09-23 | 20127 | 414 | |
20986 | 20986 | Berkeley | Alameda | 1 | 2020-09-23 | 680 | 10 | |
20987 | 20987 | Alpine | Alpine | 3 | 2020-09-23 | 2 | 0 | TRUE |
20988 | 20988 | Amador | Amador | 5 | 2020-09-23 | 252 | 15 | |
20989 | 20989 | Butte | Butte | 7 | 2020-09-23 | 2790 | 43 | |
20990 | 20990 | Calaveras | Calaveras | 9 | 2020-09-23 | 314 | 14 | TRUE |
20991 | 20991 | Colusa | Colusa | 11 | 2020-09-23 | 524 | 6 | |
20992 | 20992 | Contra Costa | Contra Costa | 13 | 2020-09-23 | 16238 | 204 | |
20993 | 20993 | Del Norte | Del Norte | 15 | 2020-09-23 | 138 | 1 | |
20994 | 20994 | El Dorado | El Dorado | 17 | 2020-09-23 | 1087 | 4 | |
20995 | 20995 | Fresno | Fresno | 19 | 2020-09-23 | 30179 | 362 | |
20996 | 20996 | Glenn | Glenn | 21 | 2020-09-23 | 571 | 3 | |
20997 | 20997 | Humboldt | Humboldt | 23 | 2020-09-23 | 490 | 6 | |
20998 | 20998 | Imperial | Imperial | 25 | 2020-09-23 | 11658 | 317 | |
20999 | 20999 | Inyo | Inyo | 27 | 2020-09-23 | 187 | 15 | |
21000 | 21000 | Kern | Kern | 29 | 2020-09-23 | 31712 | 360 | |
21001 | 21001 | Kings | Kings | 31 | 2020-09-23 | 7561 | 77 | |
21002 | 21002 | Lake | Lake | 33 | 2020-09-23 | 530 | 11 | |
21003 | 21003 | Lassen | Lassen | 35 | 2020-09-23 | 735 | 0 | |
21004 | 21004 | Long Beach | Los Angeles | 37 | 2020-09-23 | 11684 | 240 | |
21005 | 21005 | Los Angeles | Los Angeles | 37 | 2020-09-23 | 249182 | 6063 | |
21006 | 21006 | Pasadena | Los Angeles | 37 | 2020-09-23 | 2542 | 122 | |
21007 | 21007 | Madera | Madera | 39 | 2020-09-23 | 4424 | 65 | |
21008 | 21008 | Marin | Marin | 41 | 2020-09-23 | 6641 | 114 | |
21009 | 21009 | Mariposa | Mariposa | 43 | 2020-09-23 | 75 | 2 | |
21010 | 21010 | Mendocino | Mendocino | 45 | 2020-09-23 | 894 | 18 | |
21011 | 21011 | Merced | Merced | 47 | 2020-09-23 | 8828 | 140 | |
21012 | 21012 | Modoc | Modoc | 49 | 2020-09-23 | 25 | 0 | |
21013 | 21013 | Mono | Mono | 51 | 2020-09-23 | 165 | 2 | |
21014 | 21014 | Monterey | Monterey | 53 | 2020-09-23 | 9701 | 70 | |
21015 | 21015 | Napa | Napa | 55 | 2020-09-23 | 1652 | 12 | |
21016 | 21016 | Nevada | Nevada | 57 | 2020-09-23 | 528 | 6 | |
21017 | 21017 | Orange | Orange | 59 | 2020-09-23 | 52538 | 1176 | |
21018 | 21018 | Placer | Placer | 61 | 2020-09-23 | 3523 | 43 | |
21019 | 21019 | Plumas | Plumas | 63 | 2020-09-23 | 50 | 0 | TRUE |
21020 | 21020 | Riverside | Riverside | 65 | 2020-09-23 | 57695 | 1173 | |
21021 | 21021 | Sacramento | Sacramento | 67 | 2020-09-23 | 21872 | 399 | |
21022 | 21022 | San Benito | San Benito | 69 | 2020-09-23 | 1314 | 11 | |
21023 | 21023 | San Bernardino | San Bernardino | 71 | 2020-09-23 | 53121 | 1093 | |
21024 | 21024 | San Diego | San Diego | 73 | 2020-09-23 | 45425 | 767 | |
21025 | 21025 | San Francisco | San Francisco | 75 | 2020-09-23 | 10901 | 99 | |
21026 | 21026 | San Joaquin | San Joaquin | 77 | 2020-09-23 | 20060 | 434 | |
21027 | 21027 | San Luis Obispo | San Luis Obispo | 79 | 2020-09-23 | 3479 | 29 | |
21028 | 21028 | San Mateo | San Mateo | 81 | 2020-09-23 | 9664 | 144 | |
21029 | 21029 | Santa Barbara | Santa Barbara | 83 | 2020-09-23 | 8973 | 113 | |
21030 | 21030 | Santa Clara | Santa Clara | 85 | 2020-09-23 | 21132 | 298 | |
21031 | 21031 | Santa Cruz | Santa Cruz | 87 | 2020-09-23 | 2294 | 9 | |
21032 | 21032 | Shasta | Shasta | 89 | 2020-09-23 | 751 | 14 | |
21033 | 21033 | Sierra | Sierra | 91 | 2020-09-23 | 6 | 0 | |
21034 | 21034 | Siskiyou | Siskiyou | 93 | 2020-09-23 | 163 | 0 | |
21035 | 21035 | Solano | Solano | 95 | 2020-09-23 | 6232 | 60 | |
21036 | 21036 | Sonoma | Sonoma | 97 | 2020-09-23 | 7225 | 120 | |
21037 | 21037 | Stanislaus | Stanislaus | 99 | 2020-09-23 | 16425 | 342 | |
21038 | 21038 | Sutter | Sutter | 101 | 2020-09-23 | 1689 | 11 | |
21039 | 21039 | Tehama | Tehama | 103 | 2020-09-23 | 529 | 4 | |
21040 | 21040 | Trinity | Trinity | 105 | 2020-09-23 | 15 | 0 | |
21041 | 21041 | Tulare | Tulare | 107 | 2020-09-23 | 15829 | 259 | |
21042 | 21042 | Tuolumne | Tuolumne | 109 | 2020-09-23 | 227 | 4 | |
21043 | 21043 | Ventura | Ventura | 111 | 2020-09-23 | 12385 | 146 | |
21044 | 21044 | Yolo | Yolo | 113 | 2020-09-23 | 2773 | 55 | |
21045 | 21045 | Yuba | Yuba | 115 | 2020-09-23 | 1136 | 7 |
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 );