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-04-29 sorted by fips
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 |
---|---|---|---|---|---|---|---|---|
29952 | 29952 | Alameda | Alameda | 1 | 2020-04-29 | 1530 | 93 | |
29953 | 29953 | Berkeley | Alameda | 1 | 2020-04-29 | 52 | 1 | |
29954 | 29954 | Alpine | Alpine | 3 | 2020-04-29 | 1 | 0 | TRUE |
29955 | 29955 | Amador | Amador | 5 | 2020-04-29 | 8 | 0 | |
29956 | 29956 | Butte | Butte | 7 | 2020-04-29 | 16 | 0 | |
29957 | 29957 | Calaveras | Calaveras | 9 | 2020-04-29 | 13 | 0 | |
29958 | 29958 | Colusa | Colusa | 11 | 2020-04-29 | 3 | 0 | |
29959 | 29959 | Contra Costa | Contra Costa | 13 | 2020-04-29 | 872 | 25 | |
29960 | 29960 | Del Norte | Del Norte | 15 | 2020-04-29 | 3 | 0 | |
29961 | 29961 | El Dorado | El Dorado | 17 | 2020-04-29 | 44 | 0 | |
29962 | 29962 | Fresno | Fresno | 19 | 2020-04-29 | 1042 | 7 | |
29963 | 29963 | Glenn | Glenn | 21 | 2020-04-29 | 5 | 0 | |
29964 | 29964 | Humboldt | Humboldt | 23 | 2020-04-29 | 54 | 0 | |
29965 | 29965 | Imperial | Imperial | 25 | 2020-04-29 | 319 | 8 | |
29966 | 29966 | Inyo | Inyo | 27 | 2020-04-29 | 19 | 1 | |
29967 | 29967 | Kern | Kern | 29 | 2020-04-29 | 866 | 6 | |
29968 | 29968 | Kings | Kings | 31 | 2020-04-29 | 96 | 1 | |
29969 | 29969 | Lake | Lake | 33 | 2020-04-29 | 6 | 0 | |
29970 | 29970 | Lassen | Lassen | 35 | 2020-04-29 | 0 | 0 | |
29971 | 29971 | Long Beach | Los Angeles | 37 | 2020-04-29 | 629 | 36 | |
29972 | 29972 | Los Angeles | Los Angeles | 37 | 2020-04-29 | 21500 | 987 | |
29973 | 29973 | Pasadena | Los Angeles | 37 | 2020-04-29 | 393 | 42 | |
29974 | 29974 | Madera | Madera | 39 | 2020-04-29 | 46 | 2 | |
29975 | 29975 | Marin | Marin | 41 | 2020-04-29 | 235 | 13 | |
29976 | 29976 | Mariposa | Mariposa | 43 | 2020-04-29 | 1 | 0 | |
29977 | 29977 | Mendocino | Mendocino | 45 | 2020-04-29 | 12 | 0 | |
29978 | 29978 | Merced | Merced | 47 | 2020-04-29 | 118 | 3 | |
29979 | 29979 | Modoc | Modoc | 49 | 2020-04-29 | 0 | 0 | TRUE |
29980 | 29980 | Mono | Mono | 51 | 2020-04-29 | 26 | 1 | |
29981 | 29981 | Monterey | Monterey | 53 | 2020-04-29 | 206 | 5 | |
29982 | 29982 | Napa | Napa | 55 | 2020-04-29 | 67 | 2 | |
29983 | 29983 | Nevada | Nevada | 57 | 2020-04-29 | 41 | 1 | |
29984 | 29984 | Orange | Orange | 59 | 2020-04-29 | 2232 | 44 | |
29985 | 29985 | Placer | Placer | 61 | 2020-04-29 | 145 | 8 | |
29986 | 29986 | Plumas | Plumas | 63 | 2020-04-29 | 4 | 0 | |
29987 | 29987 | Riverside | Riverside | 65 | 2020-04-29 | 3942 | 143 | |
29988 | 29988 | Sacramento | Sacramento | 67 | 2020-04-29 | 1068 | 42 | |
29989 | 29989 | San Benito | San Benito | 69 | 2020-04-29 | 50 | 2 | |
29990 | 29990 | San Bernardino | San Bernardino | 71 | 2020-04-29 | 1928 | 101 | |
29991 | 29991 | San Diego | San Diego | 73 | 2020-04-29 | 3432 | 120 | |
29992 | 29992 | San Francisco | San Francisco | 75 | 2020-04-29 | 1490 | 23 | |
29993 | 29993 | San Joaquin | San Joaquin | 77 | 2020-04-29 | 536 | 25 | |
29994 | 29994 | San Luis Obispo | San Luis Obispo | 79 | 2020-04-29 | 181 | 1 | |
29995 | 29995 | San Mateo | San Mateo | 81 | 2020-04-29 | 1136 | 48 | |
29996 | 29996 | Santa Barbara | Santa Barbara | 83 | 2020-04-29 | 485 | 8 | |
29997 | 29997 | Santa Clara | Santa Clara | 85 | 2020-04-29 | 2212 | 110 | |
29998 | 29998 | Santa Cruz | Santa Cruz | 87 | 2020-04-29 | 127 | 2 | |
29999 | 29999 | Shasta | Shasta | 89 | 2020-04-29 | 31 | 4 | |
30000 | 30000 | Sierra | Sierra | 91 | 2020-04-29 | 0 | 0 | |
30001 | 30001 | Siskiyou | Siskiyou | 93 | 2020-04-29 | 5 | 0 | |
30002 | 30002 | Solano | Solano | 95 | 2020-04-29 | 254 | 5 | |
30003 | 30003 | Sonoma | Sonoma | 97 | 2020-04-29 | 232 | 2 | |
30004 | 30004 | Stanislaus | Stanislaus | 99 | 2020-04-29 | 339 | 11 | |
30005 | 30005 | Sutter | Sutter | 101 | 2020-04-29 | 30 | 2 | |
30006 | 30006 | Tehama | Tehama | 103 | 2020-04-29 | 1 | 1 | |
30007 | 30007 | Trinity | Trinity | 105 | 2020-04-29 | 0 | 0 | |
30008 | 30008 | Tulare | Tulare | 107 | 2020-04-29 | 626 | 36 | |
30009 | 30009 | Tuolumne | Tuolumne | 109 | 2020-04-29 | 2 | 0 | |
30010 | 30010 | Ventura | Ventura | 111 | 2020-04-29 | 517 | 17 | |
30011 | 30011 | Yolo | Yolo | 113 | 2020-04-29 | 163 | 16 | |
30012 | 30012 | Yuba | Yuba | 115 | 2020-04-29 | 17 | 1 |
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 );