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-03-08 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 |
---|---|---|---|---|---|---|---|---|
10859 | 10859 | Alameda | Alameda | 1 | 2021-03-08 | 78647 | 1183 | |
10860 | 10860 | Berkeley | Alameda | 1 | 2021-03-08 | 3326 | 45 | |
10861 | 10861 | Alpine | Alpine | 3 | 2021-03-08 | 85 | 0 | |
10862 | 10862 | Amador | Amador | 5 | 2021-03-08 | 3460 | 41 | |
10863 | 10863 | Butte | Butte | 7 | 2021-03-08 | 11082 | 169 | |
10864 | 10864 | Calaveras | Calaveras | 9 | 2021-03-08 | 1933 | 49 | |
10865 | 10865 | Colusa | Colusa | 11 | 2021-03-08 | 2144 | 13 | |
10866 | 10866 | Contra Costa | Contra Costa | 13 | 2021-03-08 | 63493 | 708 | |
10867 | 10867 | Del Norte | Del Norte | 15 | 2021-03-08 | 1034 | 5 | |
10868 | 10868 | El Dorado | El Dorado | 17 | 2021-03-08 | 9239 | 100 | |
10869 | 10869 | Fresno | Fresno | 19 | 2021-03-08 | 96945 | 1488 | |
10870 | 10870 | Glenn | Glenn | 21 | 2021-03-08 | 2203 | 23 | |
10871 | 10871 | Humboldt | Humboldt | 23 | 2021-03-08 | 3308 | 33 | |
10872 | 10872 | Imperial | Imperial | 25 | 2021-03-08 | 26721 | 661 | |
10873 | 10873 | Inyo | Inyo | 27 | 2021-03-08 | 1344 | 37 | |
10874 | 10874 | Kern | Kern | 29 | 2021-03-08 | 104307 | 942 | |
10875 | 10875 | Kings | Kings | 31 | 2021-03-08 | 22211 | 229 | |
10876 | 10876 | Lake | Lake | 33 | 2021-03-08 | 3175 | 42 | |
10877 | 10877 | Lassen | Lassen | 35 | 2021-03-08 | 5629 | 24 | |
10878 | 10878 | Long Beach | Los Angeles | 37 | 2021-03-08 | 51516 | 863 | |
10879 | 10879 | Los Angeles | Los Angeles | 37 | 2021-03-08 | 1141560 | 20858 | |
10880 | 10880 | Pasadena | Los Angeles | 37 | 2021-03-08 | 10993 | 320 | |
10881 | 10881 | Madera | Madera | 39 | 2021-03-08 | 15614 | 214 | |
10882 | 10882 | Marin | Marin | 41 | 2021-03-08 | 13382 | 198 | |
10883 | 10883 | Mariposa | Mariposa | 43 | 2021-03-08 | 396 | 7 | |
10884 | 10884 | Mendocino | Mendocino | 45 | 2021-03-08 | 3845 | 44 | |
10885 | 10885 | Merced | Merced | 47 | 2021-03-08 | 29557 | 415 | |
10886 | 10886 | Modoc | Modoc | 49 | 2021-03-08 | 462 | 4 | |
10887 | 10887 | Mono | Mono | 51 | 2021-03-08 | 1222 | 4 | |
10888 | 10888 | Monterey | Monterey | 53 | 2021-03-08 | 42404 | 331 | |
10889 | 10889 | Napa | Napa | 55 | 2021-03-08 | 9110 | 72 | |
10890 | 10890 | Nevada | Nevada | 57 | 2021-03-08 | 4060 | 74 | |
10891 | 10891 | Orange | Orange | 59 | 2021-03-08 | 247914 | 4252 | |
10892 | 10892 | Placer | Placer | 61 | 2021-03-08 | 20162 | 232 | |
10893 | 10893 | Plumas | Plumas | 63 | 2021-03-08 | 658 | 6 | |
10894 | 10894 | Riverside | Riverside | 65 | 2021-03-08 | 291040 | 3912 | |
10895 | 10895 | Sacramento | Sacramento | 67 | 2021-03-08 | 94561 | 1521 | |
10896 | 10896 | San Benito | San Benito | 69 | 2021-03-08 | 5738 | 61 | |
10897 | 10897 | San Bernardino | San Bernardino | 71 | 2021-03-08 | 288044 | 4669 | |
10898 | 10898 | San Diego | San Diego | 73 | 2021-03-08 | 263275 | 3390 | |
10899 | 10899 | San Francisco | San Francisco | 75 | 2021-03-08 | 34359 | 436 | |
10900 | 10900 | San Joaquin | San Joaquin | 77 | 2021-03-08 | 67395 | 1189 | |
10901 | 10901 | San Luis Obispo | San Luis Obispo | 79 | 2021-03-08 | 19860 | 247 | |
10902 | 10902 | San Mateo | San Mateo | 81 | 2021-03-08 | 39184 | 525 | |
10903 | 10903 | Santa Barbara | Santa Barbara | 83 | 2021-03-08 | 32414 | 424 | |
10904 | 10904 | Santa Clara | Santa Clara | 85 | 2021-03-08 | 111405 | 1611 | |
10905 | 10905 | Santa Cruz | Santa Cruz | 87 | 2021-03-08 | 14863 | 187 | |
10906 | 10906 | Shasta | Shasta | 89 | 2021-03-08 | 11084 | 179 | TRUE |
10907 | 10907 | Sierra | Sierra | 91 | 2021-03-08 | 100 | 0 | |
10908 | 10908 | Siskiyou | Siskiyou | 93 | 2021-03-08 | 1804 | 14 | |
10909 | 10909 | Solano | Solano | 95 | 2021-03-08 | 30404 | 167 | |
10910 | 10910 | Sonoma | Sonoma | 97 | 2021-03-08 | 28448 | 303 | TRUE |
10911 | 10911 | Stanislaus | Stanislaus | 99 | 2021-03-08 | 51238 | 959 | |
10912 | 10912 | Sutter | Sutter | 101 | 2021-03-08 | 8943 | 98 | |
10913 | 10913 | Tehama | Tehama | 103 | 2021-03-08 | 5128 | 52 | |
10914 | 10914 | Trinity | Trinity | 105 | 2021-03-08 | 375 | 5 | |
10915 | 10915 | Tulare | Tulare | 107 | 2021-03-08 | 48319 | 773 | |
10916 | 10916 | Tuolumne | Tuolumne | 109 | 2021-03-08 | 3982 | 59 | |
10917 | 10917 | Ventura | Ventura | 111 | 2021-03-08 | 78271 | 895 | |
10918 | 10918 | Yolo | Yolo | 113 | 2021-03-08 | 12851 | 186 | |
10919 | 10919 | Yuba | Yuba | 115 | 2021-03-08 | 5831 | 39 |
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 );