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-05-16 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
28915 | 28915 | Alameda | Alameda | 1 | 2020-05-16 | 2292 | 113 | |
28916 | 28916 | Berkeley | Alameda | 1 | 2020-05-16 | 69 | 1 | |
28917 | 28917 | Alpine | Alpine | 3 | 2020-05-16 | 1 | 0 | TRUE |
28918 | 28918 | Amador | Amador | 5 | 2020-05-16 | 9 | 0 | TRUE |
28919 | 28919 | Butte | Butte | 7 | 2020-05-16 | 22 | 0 | TRUE |
28920 | 28920 | Calaveras | Calaveras | 9 | 2020-05-16 | 13 | 0 | TRUE |
28921 | 28921 | Colusa | Colusa | 11 | 2020-05-16 | 3 | 0 | TRUE |
28922 | 28922 | Contra Costa | Contra Costa | 13 | 2020-05-16 | 1112 | 33 | |
28923 | 28923 | Del Norte | Del Norte | 15 | 2020-05-16 | 5 | 0 | |
28924 | 28924 | El Dorado | El Dorado | 17 | 2020-05-16 | 64 | 0 | TRUE |
28925 | 28925 | Fresno | Fresno | 19 | 2020-05-16 | 2053 | 16 | |
28926 | 28926 | Glenn | Glenn | 21 | 2020-05-16 | 9 | 0 | TRUE |
28927 | 28927 | Humboldt | Humboldt | 23 | 2020-05-16 | 77 | 0 | |
28928 | 28928 | Imperial | Imperial | 25 | 2020-05-16 | 786 | 15 | TRUE |
28929 | 28929 | Inyo | Inyo | 27 | 2020-05-16 | 19 | 1 | TRUE |
28930 | 28930 | Kern | Kern | 29 | 2020-05-16 | 1473 | 25 | |
28931 | 28931 | Kings | Kings | 31 | 2020-05-16 | 392 | 2 | |
28932 | 28932 | Lake | Lake | 33 | 2020-05-16 | 8 | 0 | TRUE |
28933 | 28933 | Lassen | Lassen | 35 | 2020-05-16 | 0 | 0 | TRUE |
28934 | 28934 | Long Beach | Los Angeles | 37 | 2020-05-16 | 1271 | 51 | |
28935 | 28935 | Los Angeles | Los Angeles | 37 | 2020-05-16 | 35419 | 1673 | |
28936 | 28936 | Pasadena | Los Angeles | 37 | 2020-05-16 | 684 | 69 | |
28937 | 28937 | Madera | Madera | 39 | 2020-05-16 | 70 | 2 | |
28938 | 28938 | Marin | Marin | 41 | 2020-05-16 | 299 | 14 | |
28939 | 28939 | Mariposa | Mariposa | 43 | 2020-05-16 | 15 | 1 | TRUE |
28940 | 28940 | Mendocino | Mendocino | 45 | 2020-05-16 | 13 | 0 | TRUE |
28941 | 28941 | Merced | Merced | 47 | 2020-05-16 | 200 | 6 | TRUE |
28942 | 28942 | Modoc | Modoc | 49 | 2020-05-16 | 0 | 0 | TRUE |
28943 | 28943 | Mono | Mono | 51 | 2020-05-16 | 33 | 1 | TRUE |
28944 | 28944 | Monterey | Monterey | 53 | 2020-05-16 | 328 | 8 | |
28945 | 28945 | Napa | Napa | 55 | 2020-05-16 | 90 | 3 | |
28946 | 28946 | Nevada | Nevada | 57 | 2020-05-16 | 41 | 1 | TRUE |
28947 | 28947 | Orange | Orange | 59 | 2020-05-16 | 4222 | 86 | |
28948 | 28948 | Placer | Placer | 61 | 2020-05-16 | 174 | 8 | |
28949 | 28949 | Plumas | Plumas | 63 | 2020-05-16 | 4 | 0 | TRUE |
28950 | 28950 | Riverside | Riverside | 65 | 2020-05-16 | 5618 | 242 | TRUE |
28951 | 28951 | Sacramento | Sacramento | 67 | 2020-05-16 | 1222 | 54 | |
28952 | 28952 | San Benito | San Benito | 69 | 2020-05-16 | 61 | 2 | |
28953 | 28953 | San Bernardino | San Bernardino | 71 | 2020-05-16 | 3463 | 166 | |
28954 | 28954 | San Diego | San Diego | 73 | 2020-05-16 | 5662 | 209 | |
28955 | 28955 | San Francisco | San Francisco | 75 | 2020-05-16 | 2054 | 36 | |
28956 | 28956 | San Joaquin | San Joaquin | 77 | 2020-05-16 | 668 | 31 | |
28957 | 28957 | San Luis Obispo | San Luis Obispo | 79 | 2020-05-16 | 243 | 1 | |
28958 | 28958 | San Mateo | San Mateo | 81 | 2020-05-16 | 1602 | 66 | |
28959 | 28959 | Santa Barbara | Santa Barbara | 83 | 2020-05-16 | 1418 | 11 | |
28960 | 28960 | Santa Clara | Santa Clara | 85 | 2020-05-16 | 2483 | 135 | |
28961 | 28961 | Santa Cruz | Santa Cruz | 87 | 2020-05-16 | 157 | 2 | |
28962 | 28962 | Shasta | Shasta | 89 | 2020-05-16 | 34 | 4 | |
28963 | 28963 | Sierra | Sierra | 91 | 2020-05-16 | 0 | 0 | TRUE |
28964 | 28964 | Siskiyou | Siskiyou | 93 | 2020-05-16 | 5 | 0 | |
28965 | 28965 | Solano | Solano | 95 | 2020-05-16 | 410 | 16 | TRUE |
28966 | 28966 | Sonoma | Sonoma | 97 | 2020-05-16 | 373 | 4 | |
28967 | 28967 | Stanislaus | Stanislaus | 99 | 2020-05-16 | 559 | 24 | |
28968 | 28968 | Sutter | Sutter | 101 | 2020-05-16 | 38 | 2 | |
28969 | 28969 | Tehama | Tehama | 103 | 2020-05-16 | 2 | 1 | TRUE |
28970 | 28970 | Trinity | Trinity | 105 | 2020-05-16 | 1 | 0 | TRUE |
28971 | 28971 | Tulare | Tulare | 107 | 2020-05-16 | 1426 | 67 | |
28972 | 28972 | Tuolumne | Tuolumne | 109 | 2020-05-16 | 2 | 0 | TRUE |
28973 | 28973 | Ventura | Ventura | 111 | 2020-05-16 | 764 | 25 | TRUE |
28974 | 28974 | Yolo | Yolo | 113 | 2020-05-16 | 183 | 22 | |
28975 | 28975 | Yuba | Yuba | 115 | 2020-05-16 | 25 | 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 );