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-06 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
10981 | 10981 | Alameda | Alameda | 1 | 2021-03-06 | 78424 | 1182 | |
10982 | 10982 | Berkeley | Alameda | 1 | 2021-03-06 | 3312 | 45 | |
10983 | 10983 | Alpine | Alpine | 3 | 2021-03-06 | 84 | 0 | TRUE |
10984 | 10984 | Amador | Amador | 5 | 2021-03-06 | 3455 | 41 | TRUE |
10985 | 10985 | Butte | Butte | 7 | 2021-03-06 | 11065 | 169 | TRUE |
10986 | 10986 | Calaveras | Calaveras | 9 | 2021-03-06 | 1928 | 49 | TRUE |
10987 | 10987 | Colusa | Colusa | 11 | 2021-03-06 | 2142 | 13 | TRUE |
10988 | 10988 | Contra Costa | Contra Costa | 13 | 2021-03-06 | 63297 | 708 | |
10989 | 10989 | Del Norte | Del Norte | 15 | 2021-03-06 | 1027 | 5 | |
10990 | 10990 | El Dorado | El Dorado | 17 | 2021-03-06 | 9204 | 100 | |
10991 | 10991 | Fresno | Fresno | 19 | 2021-03-06 | 96679 | 1488 | |
10992 | 10992 | Glenn | Glenn | 21 | 2021-03-06 | 2196 | 23 | |
10993 | 10993 | Humboldt | Humboldt | 23 | 2021-03-06 | 3266 | 33 | |
10994 | 10994 | Imperial | Imperial | 25 | 2021-03-06 | 26708 | 641 | |
10995 | 10995 | Inyo | Inyo | 27 | 2021-03-06 | 1334 | 37 | |
10996 | 10996 | Kern | Kern | 29 | 2021-03-06 | 104181 | 942 | TRUE |
10997 | 10997 | Kings | Kings | 31 | 2021-03-06 | 22175 | 227 | |
10998 | 10998 | Lake | Lake | 33 | 2021-03-06 | 3160 | 41 | TRUE |
10999 | 10999 | Lassen | Lassen | 35 | 2021-03-06 | 5623 | 24 | TRUE |
11000 | 11000 | Long Beach | Los Angeles | 37 | 2021-03-06 | 51475 | 863 | |
11001 | 11001 | Los Angeles | Los Angeles | 37 | 2021-03-06 | 1139410 | 20832 | |
11002 | 11002 | Pasadena | Los Angeles | 37 | 2021-03-06 | 10983 | 320 | |
11003 | 11003 | Madera | Madera | 39 | 2021-03-06 | 15540 | 214 | |
11004 | 11004 | Marin | Marin | 41 | 2021-03-06 | 13358 | 198 | |
11005 | 11005 | Mariposa | Mariposa | 43 | 2021-03-06 | 395 | 7 | TRUE |
11006 | 11006 | Mendocino | Mendocino | 45 | 2021-03-06 | 3839 | 44 | |
11007 | 11007 | Merced | Merced | 47 | 2021-03-06 | 29376 | 413 | TRUE |
11008 | 11008 | Modoc | Modoc | 49 | 2021-03-06 | 460 | 4 | TRUE |
11009 | 11009 | Mono | Mono | 51 | 2021-03-06 | 1219 | 4 | TRUE |
11010 | 11010 | Monterey | Monterey | 53 | 2021-03-06 | 42404 | 331 | |
11011 | 11011 | Napa | Napa | 55 | 2021-03-06 | 9073 | 72 | TRUE |
11012 | 11012 | Nevada | Nevada | 57 | 2021-03-06 | 4022 | 74 | TRUE |
11013 | 11013 | Orange | Orange | 59 | 2021-03-06 | 247641 | 4173 | |
11014 | 11014 | Placer | Placer | 61 | 2021-03-06 | 20035 | 232 | TRUE |
11015 | 11015 | Plumas | Plumas | 63 | 2021-03-06 | 654 | 6 | TRUE |
11016 | 11016 | Riverside | Riverside | 65 | 2021-03-06 | 290904 | 3892 | TRUE |
11017 | 11017 | Sacramento | Sacramento | 67 | 2021-03-06 | 94129 | 1510 | TRUE |
11018 | 11018 | San Benito | San Benito | 69 | 2021-03-06 | 5723 | 61 | |
11019 | 11019 | San Bernardino | San Bernardino | 71 | 2021-03-06 | 287782 | 4655 | |
11020 | 11020 | San Diego | San Diego | 73 | 2021-03-06 | 262781 | 3385 | |
11021 | 11021 | San Francisco | San Francisco | 75 | 2021-03-06 | 34286 | 432 | |
11022 | 11022 | San Joaquin | San Joaquin | 77 | 2021-03-06 | 67284 | 1182 | TRUE |
11023 | 11023 | San Luis Obispo | San Luis Obispo | 79 | 2021-03-06 | 19835 | 246 | TRUE |
11024 | 11024 | San Mateo | San Mateo | 81 | 2021-03-06 | 39048 | 525 | |
11025 | 11025 | Santa Barbara | Santa Barbara | 83 | 2021-03-06 | 32301 | 423 | |
11026 | 11026 | Santa Clara | Santa Clara | 85 | 2021-03-06 | 111159 | 1607 | |
11027 | 11027 | Santa Cruz | Santa Cruz | 87 | 2021-03-06 | 14790 | 187 | TRUE |
11028 | 11028 | Shasta | Shasta | 89 | 2021-03-06 | 11084 | 179 | TRUE |
11029 | 11029 | Sierra | Sierra | 91 | 2021-03-06 | 100 | 0 | TRUE |
11030 | 11030 | Siskiyou | Siskiyou | 93 | 2021-03-06 | 1790 | 14 | TRUE |
11031 | 11031 | Solano | Solano | 95 | 2021-03-06 | 30305 | 167 | TRUE |
11032 | 11032 | Sonoma | Sonoma | 97 | 2021-03-06 | 28326 | 303 | |
11033 | 11033 | Stanislaus | Stanislaus | 99 | 2021-03-06 | 51018 | 957 | |
11034 | 11034 | Sutter | Sutter | 101 | 2021-03-06 | 8923 | 98 | TRUE |
11035 | 11035 | Tehama | Tehama | 103 | 2021-03-06 | 5118 | 52 | TRUE |
11036 | 11036 | Trinity | Trinity | 105 | 2021-03-06 | 373 | 5 | TRUE |
11037 | 11037 | Tulare | Tulare | 107 | 2021-03-06 | 48203 | 770 | TRUE |
11038 | 11038 | Tuolumne | Tuolumne | 109 | 2021-03-06 | 3972 | 59 | TRUE |
11039 | 11039 | Ventura | Ventura | 111 | 2021-03-06 | 78050 | 883 | |
11040 | 11040 | Yolo | Yolo | 113 | 2021-03-06 | 12778 | 185 | TRUE |
11041 | 11041 | Yuba | Yuba | 115 | 2021-03-06 | 5795 | 39 | 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 );