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-07-20 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
24950 | 24950 | Alameda | Alameda | 1 | 2020-07-20 | 9217 | 216 | |
24951 | 24951 | Berkeley | Alameda | 1 | 2020-07-20 | 330 | 6 | |
24952 | 24952 | Alpine | Alpine | 3 | 2020-07-20 | 2 | 0 | TRUE |
24953 | 24953 | Amador | Amador | 5 | 2020-07-20 | 57 | 0 | |
24954 | 24954 | Butte | Butte | 7 | 2020-07-20 | 586 | 5 | |
24955 | 24955 | Calaveras | Calaveras | 9 | 2020-07-20 | 87 | 0 | TRUE |
24956 | 24956 | Colusa | Colusa | 11 | 2020-07-20 | 223 | 0 | |
24957 | 24957 | Contra Costa | Contra Costa | 13 | 2020-07-20 | 5815 | 99 | |
24958 | 24958 | Del Norte | Del Norte | 15 | 2020-07-20 | 66 | 0 | TRUE |
24959 | 24959 | El Dorado | El Dorado | 17 | 2020-07-20 | 443 | 1 | |
24960 | 24960 | Fresno | Fresno | 19 | 2020-07-20 | 17985 | 100 | |
24961 | 24961 | Glenn | Glenn | 21 | 2020-07-20 | 219 | 1 | |
24962 | 24962 | Humboldt | Humboldt | 23 | 2020-07-20 | 189 | 4 | |
24963 | 24963 | Imperial | Imperial | 25 | 2020-07-20 | 8606 | 163 | |
24964 | 24964 | Inyo | Inyo | 27 | 2020-07-20 | 40 | 1 | |
24965 | 24965 | Kern | Kern | 29 | 2020-07-20 | 9234 | 105 | |
24966 | 24966 | Kings | Kings | 31 | 2020-07-20 | 3398 | 42 | |
24967 | 24967 | Lake | Lake | 33 | 2020-07-20 | 151 | 1 | |
24968 | 24968 | Lassen | Lassen | 35 | 2020-07-20 | 512 | 0 | |
24969 | 24969 | Long Beach | Los Angeles | 37 | 2020-07-20 | 6522 | 159 | |
24970 | 24970 | Los Angeles | Los Angeles | 37 | 2020-07-20 | 150900 | 3844 | |
24971 | 24971 | Pasadena | Los Angeles | 37 | 2020-07-20 | 1700 | 102 | |
24972 | 24972 | Madera | Madera | 39 | 2020-07-20 | 1414 | 13 | |
24973 | 24973 | Marin | Marin | 41 | 2020-07-20 | 4376 | 43 | |
24974 | 24974 | Mariposa | Mariposa | 43 | 2020-07-20 | 38 | 1 | |
24975 | 24975 | Mendocino | Mendocino | 45 | 2020-07-20 | 207 | 3 | |
24976 | 24976 | Merced | Merced | 47 | 2020-07-20 | 2694 | 22 | |
24977 | 24977 | Modoc | Modoc | 49 | 2020-07-20 | 0 | 0 | TRUE |
24978 | 24978 | Mono | Mono | 51 | 2020-07-20 | 84 | 1 | |
24979 | 24979 | Monterey | Monterey | 53 | 2020-07-20 | 3353 | 19 | |
24980 | 24980 | Napa | Napa | 55 | 2020-07-20 | 632 | 7 | |
24981 | 24981 | Nevada | Nevada | 57 | 2020-07-20 | 228 | 1 | |
24982 | 24982 | Orange | Orange | 59 | 2020-07-20 | 29986 | 493 | |
24983 | 24983 | Placer | Placer | 61 | 2020-07-20 | 1403 | 11 | |
24984 | 24984 | Plumas | Plumas | 63 | 2020-07-20 | 24 | 0 | |
24985 | 24985 | Riverside | Riverside | 65 | 2020-07-20 | 29983 | 588 | |
24986 | 24986 | Sacramento | Sacramento | 67 | 2020-07-20 | 7326 | 96 | |
24987 | 24987 | San Benito | San Benito | 69 | 2020-07-20 | 458 | 2 | |
24988 | 24988 | San Bernardino | San Bernardino | 71 | 2020-07-20 | 24099 | 538 | |
24989 | 24989 | San Diego | San Diego | 73 | 2020-07-20 | 24135 | 478 | |
24990 | 24990 | San Francisco | San Francisco | 75 | 2020-07-20 | 5305 | 52 | |
24991 | 24991 | San Joaquin | San Joaquin | 77 | 2020-07-20 | 8321 | 94 | |
24992 | 24992 | San Luis Obispo | San Luis Obispo | 79 | 2020-07-20 | 1306 | 6 | |
24993 | 24993 | San Mateo | San Mateo | 81 | 2020-07-20 | 4551 | 114 | |
24994 | 24994 | Santa Barbara | Santa Barbara | 83 | 2020-07-20 | 4991 | 32 | |
24995 | 24995 | Santa Clara | Santa Clara | 85 | 2020-07-20 | 9414 | 182 | |
24996 | 24996 | Santa Cruz | Santa Cruz | 87 | 2020-07-20 | 772 | 3 | TRUE |
24997 | 24997 | Shasta | Shasta | 89 | 2020-07-20 | 250 | 7 | |
24998 | 24998 | Sierra | Sierra | 91 | 2020-07-20 | 1 | 0 | |
24999 | 24999 | Siskiyou | Siskiyou | 93 | 2020-07-20 | 51 | 0 | |
25000 | 25000 | Solano | Solano | 95 | 2020-07-20 | 2759 | 34 | |
25001 | 25001 | Sonoma | Sonoma | 97 | 2020-07-20 | 2212 | 20 | |
25002 | 25002 | Stanislaus | Stanislaus | 99 | 2020-07-20 | 6508 | 71 | |
25003 | 25003 | Sutter | Sutter | 101 | 2020-07-20 | 539 | 4 | |
25004 | 25004 | Tehama | Tehama | 103 | 2020-07-20 | 151 | 1 | |
25005 | 25005 | Trinity | Trinity | 105 | 2020-07-20 | 2 | 0 | |
25006 | 25006 | Tulare | Tulare | 107 | 2020-07-20 | 6896 | 167 | |
25007 | 25007 | Tuolumne | Tuolumne | 109 | 2020-07-20 | 101 | 0 | |
25008 | 25008 | Ventura | Ventura | 111 | 2020-07-20 | 5748 | 58 | |
25009 | 25009 | Yolo | Yolo | 113 | 2020-07-20 | 1196 | 34 | |
25010 | 25010 | Yuba | Yuba | 115 | 2020-07-20 | 289 | 3 |
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 );