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-17 sorted by date descending
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 |
---|---|---|---|---|---|---|---|---|
28854 | 28854 | Alameda | Alameda | 1 | 2020-05-17 | 2346 | 113 | |
28855 | 28855 | Berkeley | Alameda | 1 | 2020-05-17 | 70 | 1 | TRUE |
28856 | 28856 | Alpine | Alpine | 3 | 2020-05-17 | 1 | 0 | TRUE |
28857 | 28857 | Amador | Amador | 5 | 2020-05-17 | 9 | 0 | |
28858 | 28858 | Butte | Butte | 7 | 2020-05-17 | 23 | 0 | TRUE |
28859 | 28859 | Calaveras | Calaveras | 9 | 2020-05-17 | 13 | 0 | TRUE |
28860 | 28860 | Colusa | Colusa | 11 | 2020-05-17 | 3 | 0 | TRUE |
28861 | 28861 | Contra Costa | Contra Costa | 13 | 2020-05-17 | 1133 | 33 | |
28862 | 28862 | Del Norte | Del Norte | 15 | 2020-05-17 | 8 | 0 | |
28863 | 28863 | El Dorado | El Dorado | 17 | 2020-05-17 | 64 | 0 | TRUE |
28864 | 28864 | Fresno | Fresno | 19 | 2020-05-17 | 2107 | 16 | TRUE |
28865 | 28865 | Glenn | Glenn | 21 | 2020-05-17 | 9 | 0 | TRUE |
28866 | 28866 | Humboldt | Humboldt | 23 | 2020-05-17 | 77 | 0 | TRUE |
28867 | 28867 | Imperial | Imperial | 25 | 2020-05-17 | 786 | 15 | TRUE |
28868 | 28868 | Inyo | Inyo | 27 | 2020-05-17 | 19 | 1 | TRUE |
28869 | 28869 | Kern | Kern | 29 | 2020-05-17 | 1515 | 25 | |
28870 | 28870 | Kings | Kings | 31 | 2020-05-17 | 399 | 2 | |
28871 | 28871 | Lake | Lake | 33 | 2020-05-17 | 8 | 0 | TRUE |
28872 | 28872 | Lassen | Lassen | 35 | 2020-05-17 | 0 | 0 | |
28873 | 28873 | Long Beach | Los Angeles | 37 | 2020-05-17 | 1298 | 51 | |
28874 | 28874 | Los Angeles | Los Angeles | 37 | 2020-05-17 | 36019 | 1701 | |
28875 | 28875 | Pasadena | Los Angeles | 37 | 2020-05-17 | 694 | 69 | |
28876 | 28876 | Madera | Madera | 39 | 2020-05-17 | 71 | 2 | |
28877 | 28877 | Marin | Marin | 41 | 2020-05-17 | 317 | 14 | |
28878 | 28878 | Mariposa | Mariposa | 43 | 2020-05-17 | 15 | 1 | TRUE |
28879 | 28879 | Mendocino | Mendocino | 45 | 2020-05-17 | 14 | 0 | |
28880 | 28880 | Merced | Merced | 47 | 2020-05-17 | 200 | 6 | TRUE |
28881 | 28881 | Modoc | Modoc | 49 | 2020-05-17 | 0 | 0 | TRUE |
28882 | 28882 | Mono | Mono | 51 | 2020-05-17 | 34 | 1 | |
28883 | 28883 | Monterey | Monterey | 53 | 2020-05-17 | 341 | 8 | |
28884 | 28884 | Napa | Napa | 55 | 2020-05-17 | 90 | 3 | TRUE |
28885 | 28885 | Nevada | Nevada | 57 | 2020-05-17 | 41 | 1 | TRUE |
28886 | 28886 | Orange | Orange | 59 | 2020-05-17 | 4376 | 88 | |
28887 | 28887 | Placer | Placer | 61 | 2020-05-17 | 175 | 8 | |
28888 | 28888 | Plumas | Plumas | 63 | 2020-05-17 | 4 | 0 | TRUE |
28889 | 28889 | Riverside | Riverside | 65 | 2020-05-17 | 5618 | 242 | TRUE |
28890 | 28890 | Sacramento | Sacramento | 67 | 2020-05-17 | 1237 | 55 | |
28891 | 28891 | San Benito | San Benito | 69 | 2020-05-17 | 61 | 2 | |
28892 | 28892 | San Bernardino | San Bernardino | 71 | 2020-05-17 | 3511 | 168 | |
28893 | 28893 | San Diego | San Diego | 73 | 2020-05-17 | 5836 | 209 | |
28894 | 28894 | San Francisco | San Francisco | 75 | 2020-05-17 | 2091 | 36 | |
28895 | 28895 | San Joaquin | San Joaquin | 77 | 2020-05-17 | 687 | 32 | |
28896 | 28896 | San Luis Obispo | San Luis Obispo | 79 | 2020-05-17 | 243 | 1 | |
28897 | 28897 | San Mateo | San Mateo | 81 | 2020-05-17 | 1602 | 66 | TRUE |
28898 | 28898 | Santa Barbara | Santa Barbara | 83 | 2020-05-17 | 1474 | 11 | |
28899 | 28899 | Santa Clara | Santa Clara | 85 | 2020-05-17 | 2490 | 136 | |
28900 | 28900 | Santa Cruz | Santa Cruz | 87 | 2020-05-17 | 159 | 2 | |
28901 | 28901 | Shasta | Shasta | 89 | 2020-05-17 | 34 | 4 | |
28902 | 28902 | Sierra | Sierra | 91 | 2020-05-17 | 0 | 0 | TRUE |
28903 | 28903 | Siskiyou | Siskiyou | 93 | 2020-05-17 | 5 | 0 | |
28904 | 28904 | Solano | Solano | 95 | 2020-05-17 | 410 | 16 | TRUE |
28905 | 28905 | Sonoma | Sonoma | 97 | 2020-05-17 | 373 | 4 | TRUE |
28906 | 28906 | Stanislaus | Stanislaus | 99 | 2020-05-17 | 571 | 24 | |
28907 | 28907 | Sutter | Sutter | 101 | 2020-05-17 | 38 | 2 | TRUE |
28908 | 28908 | Tehama | Tehama | 103 | 2020-05-17 | 2 | 1 | TRUE |
28909 | 28909 | Trinity | Trinity | 105 | 2020-05-17 | 1 | 0 | TRUE |
28910 | 28910 | Tulare | Tulare | 107 | 2020-05-17 | 1430 | 67 | |
28911 | 28911 | Tuolumne | Tuolumne | 109 | 2020-05-17 | 2 | 0 | TRUE |
28912 | 28912 | Ventura | Ventura | 111 | 2020-05-17 | 764 | 25 | TRUE |
28913 | 28913 | Yolo | Yolo | 113 | 2020-05-17 | 184 | 22 | |
28914 | 28914 | Yuba | Yuba | 115 | 2020-05-17 | 25 | 1 | 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 );