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 2021-04-10 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
8846 | 8846 | Alameda | Alameda | 1 | 2021-04-10 | 81634 | 1207 | |
8847 | 8847 | Berkeley | Alameda | 1 | 2021-04-10 | 3493 | 46 | |
8848 | 8848 | Alpine | Alpine | 3 | 2021-04-10 | 88 | 0 | TRUE |
8849 | 8849 | Amador | Amador | 5 | 2021-04-10 | 3569 | 46 | TRUE |
8850 | 8850 | Butte | Butte | 7 | 2021-04-10 | 11482 | 178 | TRUE |
8851 | 8851 | Calaveras | Calaveras | 9 | 2021-04-10 | 2036 | 51 | TRUE |
8852 | 8852 | Colusa | Colusa | 11 | 2021-04-10 | 2178 | 16 | TRUE |
8853 | 8853 | Contra Costa | Contra Costa | 13 | 2021-04-10 | 66262 | 764 | |
8854 | 8854 | Del Norte | Del Norte | 15 | 2021-04-10 | 1245 | 5 | TRUE |
8855 | 8855 | El Dorado | El Dorado | 17 | 2021-04-10 | 9580 | 108 | TRUE |
8856 | 8856 | Fresno | Fresno | 19 | 2021-04-10 | 99734 | 1630 | |
8857 | 8857 | Glenn | Glenn | 21 | 2021-04-10 | 2284 | 25 | TRUE |
8858 | 8858 | Humboldt | Humboldt | 23 | 2021-04-10 | 3518 | 36 | TRUE |
8859 | 8859 | Imperial | Imperial | 25 | 2021-04-10 | 27401 | 716 | TRUE |
8860 | 8860 | Inyo | Inyo | 27 | 2021-04-10 | 1412 | 38 | TRUE |
8861 | 8861 | Kern | Kern | 29 | 2021-04-10 | 107172 | 1304 | |
8862 | 8862 | Kings | Kings | 31 | 2021-04-10 | 22701 | 243 | |
8863 | 8863 | Lake | Lake | 33 | 2021-04-10 | 3340 | 43 | TRUE |
8864 | 8864 | Lassen | Lassen | 35 | 2021-04-10 | 5660 | 24 | TRUE |
8865 | 8865 | Long Beach | Los Angeles | 37 | 2021-04-10 | 52479 | 920 | TRUE |
8866 | 8866 | Los Angeles | Los Angeles | 37 | 2021-04-10 | 1161651 | 22208 | TRUE |
8867 | 8867 | Pasadena | Los Angeles | 37 | 2021-04-10 | 11169 | 339 | TRUE |
8868 | 8868 | Madera | Madera | 39 | 2021-04-10 | 16029 | 236 | TRUE |
8869 | 8869 | Marin | Marin | 41 | 2021-04-10 | 13797 | 205 | |
8870 | 8870 | Mariposa | Mariposa | 43 | 2021-04-10 | 415 | 7 | TRUE |
8871 | 8871 | Mendocino | Mendocino | 45 | 2021-04-10 | 3966 | 47 | TRUE |
8872 | 8872 | Merced | Merced | 47 | 2021-04-10 | 31009 | 448 | |
8873 | 8873 | Modoc | Modoc | 49 | 2021-04-10 | 482 | 4 | TRUE |
8874 | 8874 | Mono | Mono | 51 | 2021-04-10 | 1270 | 4 | |
8875 | 8875 | Monterey | Monterey | 53 | 2021-04-10 | 43157 | 347 | TRUE |
8876 | 8876 | Napa | Napa | 55 | 2021-04-10 | 9547 | 75 | TRUE |
8877 | 8877 | Nevada | Nevada | 57 | 2021-04-10 | 4379 | 75 | TRUE |
8878 | 8878 | Orange | Orange | 59 | 2021-04-10 | 252120 | 4831 | |
8879 | 8879 | Placer | Placer | 61 | 2021-04-10 | 21389 | 279 | TRUE |
8880 | 8880 | Plumas | Plumas | 63 | 2021-04-10 | 687 | 6 | TRUE |
8881 | 8881 | Riverside | Riverside | 65 | 2021-04-10 | 296090 | 4481 | TRUE |
8882 | 8882 | Sacramento | Sacramento | 67 | 2021-04-10 | 99668 | 1638 | TRUE |
8883 | 8883 | San Benito | San Benito | 69 | 2021-04-10 | 5918 | 62 | |
8884 | 8884 | San Bernardino | San Bernardino | 71 | 2021-04-10 | 292558 | 4764 | |
8885 | 8885 | San Diego | San Diego | 73 | 2021-04-10 | 273057 | 3613 | |
8886 | 8886 | San Francisco | San Francisco | 75 | 2021-04-10 | 35482 | 496 | |
8887 | 8887 | San Joaquin | San Joaquin | 77 | 2021-04-10 | 70746 | 1328 | TRUE |
8888 | 8888 | San Luis Obispo | San Luis Obispo | 79 | 2021-04-10 | 20723 | 256 | TRUE |
8889 | 8889 | San Mateo | San Mateo | 81 | 2021-04-10 | 40754 | 556 | TRUE |
8890 | 8890 | Santa Barbara | Santa Barbara | 83 | 2021-04-10 | 33655 | 441 | |
8891 | 8891 | Santa Clara | Santa Clara | 85 | 2021-04-10 | 115237 | 1667 | |
8892 | 8892 | Santa Cruz | Santa Cruz | 87 | 2021-04-10 | 15334 | 202 | TRUE |
8893 | 8893 | Shasta | Shasta | 89 | 2021-04-10 | 11509 | 213 | TRUE |
8894 | 8894 | Sierra | Sierra | 91 | 2021-04-10 | 107 | 0 | TRUE |
8895 | 8895 | Siskiyou | Siskiyou | 93 | 2021-04-10 | 1899 | 19 | TRUE |
8896 | 8896 | Solano | Solano | 95 | 2021-04-10 | 31527 | 203 | TRUE |
8897 | 8897 | Sonoma | Sonoma | 97 | 2021-04-10 | 29448 | 309 | TRUE |
8898 | 8898 | Stanislaus | Stanislaus | 99 | 2021-04-10 | 53445 | 1017 | |
8899 | 8899 | Sutter | Sutter | 101 | 2021-04-10 | 9225 | 102 | TRUE |
8900 | 8900 | Tehama | Tehama | 103 | 2021-04-10 | 5359 | 56 | TRUE |
8901 | 8901 | Trinity | Trinity | 105 | 2021-04-10 | 395 | 5 | TRUE |
8902 | 8902 | Tulare | Tulare | 107 | 2021-04-10 | 49231 | 821 | TRUE |
8903 | 8903 | Tuolumne | Tuolumne | 109 | 2021-04-10 | 4052 | 64 | TRUE |
8904 | 8904 | Ventura | Ventura | 111 | 2021-04-10 | 79963 | 990 | |
8905 | 8905 | Yolo | Yolo | 113 | 2021-04-10 | 13364 | 199 | TRUE |
8906 | 8906 | Yuba | Yuba | 115 | 2021-04-10 | 6064 | 40 | 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 );