latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
56 rows where "date" is on date 2020-04-13 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 |
---|---|---|---|---|---|---|---|---|
30854 | 30854 | Alameda | Alameda | 1 | 2020-04-13 | 902 | 70 | |
30855 | 30855 | Berkeley | Alameda | 1 | 2020-04-13 | 37 | 1 | |
30856 | 30856 | Alpine | Alpine | 3 | 2020-04-13 | 1 | 0 | |
30857 | 30857 | Amador | Amador | 5 | 2020-04-13 | 7 | 0 | |
30858 | 30858 | Butte | Butte | 7 | 2020-04-13 | 13 | 0 | |
30859 | 30859 | Calaveras | Calaveras | 9 | 2020-04-13 | 9 | 0 | |
30860 | 30860 | Colusa | Colusa | 11 | 2020-04-13 | 3 | 0 | TRUE |
30861 | 30861 | Contra Costa | Contra Costa | 13 | 2020-04-13 | 585 | 11 | |
30862 | 30862 | Del Norte | Del Norte | 15 | 2020-04-13 | 2 | 0 | |
30863 | 30863 | El Dorado | El Dorado | 17 | 2020-04-13 | 34 | 0 | |
30864 | 30864 | Fresno | Fresno | 19 | 2020-04-13 | 457 | 5 | |
30865 | 30865 | Glenn | Glenn | 21 | 2020-04-13 | 4 | 0 | |
30866 | 30866 | Humboldt | Humboldt | 23 | 2020-04-13 | 50 | 0 | |
30867 | 30867 | Imperial | Imperial | 25 | 2020-04-13 | 100 | 3 | |
30868 | 30868 | Inyo | Inyo | 27 | 2020-04-13 | 12 | 0 | |
30869 | 30869 | Kern | Kern | 29 | 2020-04-13 | 446 | 3 | |
30870 | 30870 | Kings | Kings | 31 | 2020-04-13 | 12 | 1 | |
30871 | 30871 | Lake | Lake | 33 | 2020-04-13 | 4 | 0 | TRUE |
30872 | 30872 | Long Beach | Los Angeles | 37 | 2020-04-13 | 350 | 14 | |
30873 | 30873 | Los Angeles | Los Angeles | 37 | 2020-04-13 | 8966 | 303 | |
30874 | 30874 | Pasadena | Los Angeles | 37 | 2020-04-13 | 164 | 9 | |
30875 | 30875 | Madera | Madera | 39 | 2020-04-13 | 33 | 2 | |
30876 | 30876 | Marin | Marin | 41 | 2020-04-13 | 170 | 10 | |
30877 | 30877 | Mendocino | Mendocino | 45 | 2020-04-13 | 4 | 0 | |
30878 | 30878 | Merced | Merced | 47 | 2020-04-13 | 69 | 3 | |
30879 | 30879 | Mono | Mono | 51 | 2020-04-13 | 23 | 1 | |
30880 | 30880 | Monterey | Monterey | 53 | 2020-04-13 | 87 | 3 | |
30881 | 30881 | Napa | Napa | 55 | 2020-04-13 | 34 | 2 | |
30882 | 30882 | Nevada | Nevada | 57 | 2020-04-13 | 34 | 1 | |
30883 | 30883 | Orange | Orange | 59 | 2020-04-13 | 1257 | 19 | |
30884 | 30884 | Placer | Placer | 61 | 2020-04-13 | 127 | 5 | |
30885 | 30885 | Plumas | Plumas | 63 | 2020-04-13 | 4 | 0 | |
30886 | 30886 | Riverside | Riverside | 65 | 2020-04-13 | 1751 | 50 | |
30887 | 30887 | Sacramento | Sacramento | 67 | 2020-04-13 | 739 | 27 | |
30888 | 30888 | San Benito | San Benito | 69 | 2020-04-13 | 38 | 2 | |
30889 | 30889 | San Bernardino | San Bernardino | 71 | 2020-04-13 | 977 | 44 | |
30890 | 30890 | San Diego | San Diego | 73 | 2020-04-13 | 1847 | 47 | |
30891 | 30891 | San Francisco | San Francisco | 75 | 2020-04-13 | 957 | 15 | |
30892 | 30892 | San Joaquin | San Joaquin | 77 | 2020-04-13 | 273 | 17 | |
30893 | 30893 | San Luis Obispo | San Luis Obispo | 79 | 2020-04-13 | 117 | 1 | |
30894 | 30894 | San Mateo | San Mateo | 81 | 2020-04-13 | 701 | 21 | |
30895 | 30895 | Santa Barbara | Santa Barbara | 83 | 2020-04-13 | 284 | 2 | |
30896 | 30896 | Santa Clara | Santa Clara | 85 | 2020-04-13 | 1791 | 68 | |
30897 | 30897 | Santa Cruz | Santa Cruz | 87 | 2020-04-13 | 91 | 1 | |
30898 | 30898 | Shasta | Shasta | 89 | 2020-04-13 | 25 | 3 | |
30899 | 30899 | Siskiyou | Siskiyou | 93 | 2020-04-13 | 5 | 0 | |
30900 | 30900 | Solano | Solano | 95 | 2020-04-13 | 135 | 2 | |
30901 | 30901 | Sonoma | Sonoma | 97 | 2020-04-13 | 152 | 2 | |
30902 | 30902 | Stanislaus | Stanislaus | 99 | 2020-04-13 | 146 | 2 | |
30903 | 30903 | Sutter | Sutter | 101 | 2020-04-13 | 23 | 2 | |
30904 | 30904 | Tehama | Tehama | 103 | 2020-04-13 | 1 | 0 | |
30905 | 30905 | Tulare | Tulare | 107 | 2020-04-13 | 264 | 13 | |
30906 | 30906 | Tuolumne | Tuolumne | 109 | 2020-04-13 | 1 | 0 | |
30907 | 30907 | Ventura | Ventura | 111 | 2020-04-13 | 317 | 10 | |
30908 | 30908 | Yolo | Yolo | 113 | 2020-04-13 | 101 | 4 | |
30909 | 30909 | Yuba | Yuba | 115 | 2020-04-13 | 15 | 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 );