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-11-29 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
16898 | 16898 | Alameda | Alameda | 1 | 2020-11-29 | 28943 | 525 | |
16899 | 16899 | Berkeley | Alameda | 1 | 2020-11-29 | 1158 | 10 | |
16900 | 16900 | Alpine | Alpine | 3 | 2020-11-29 | 50 | 0 | TRUE |
16901 | 16901 | Amador | Amador | 5 | 2020-11-29 | 590 | 16 | |
16902 | 16902 | Butte | Butte | 7 | 2020-11-29 | 4008 | 59 | TRUE |
16903 | 16903 | Calaveras | Calaveras | 9 | 2020-11-29 | 450 | 22 | TRUE |
16904 | 16904 | Colusa | Colusa | 11 | 2020-11-29 | 694 | 6 | TRUE |
16905 | 16905 | Contra Costa | Contra Costa | 13 | 2020-11-29 | 24275 | 261 | |
16906 | 16906 | Del Norte | Del Norte | 15 | 2020-11-29 | 313 | 1 | TRUE |
16907 | 16907 | El Dorado | El Dorado | 17 | 2020-11-29 | 2315 | 4 | TRUE |
16908 | 16908 | Fresno | Fresno | 19 | 2020-11-29 | 43468 | 481 | TRUE |
16909 | 16909 | Glenn | Glenn | 21 | 2020-11-29 | 884 | 8 | TRUE |
16910 | 16910 | Humboldt | Humboldt | 23 | 2020-11-29 | 850 | 9 | TRUE |
16911 | 16911 | Imperial | Imperial | 25 | 2020-11-29 | 15862 | 356 | TRUE |
16912 | 16912 | Inyo | Inyo | 27 | 2020-11-29 | 290 | 16 | TRUE |
16913 | 16913 | Kern | Kern | 29 | 2020-11-29 | 41827 | 448 | |
16914 | 16914 | Kings | Kings | 31 | 2020-11-29 | 11270 | 87 | |
16915 | 16915 | Lake | Lake | 33 | 2020-11-29 | 886 | 19 | TRUE |
16916 | 16916 | Lassen | Lassen | 35 | 2020-11-29 | 1773 | 3 | TRUE |
16917 | 16917 | Long Beach | Los Angeles | 37 | 2020-11-29 | 15713 | 274 | TRUE |
16918 | 16918 | Los Angeles | Los Angeles | 37 | 2020-11-29 | 376495 | 7233 | |
16919 | 16919 | Pasadena | Los Angeles | 37 | 2020-11-29 | 3671 | 132 | |
16920 | 16920 | Madera | Madera | 39 | 2020-11-29 | 6047 | 85 | TRUE |
16921 | 16921 | Marin | Marin | 41 | 2020-11-29 | 7777 | 129 | |
16922 | 16922 | Mariposa | Mariposa | 43 | 2020-11-29 | 131 | 2 | |
16923 | 16923 | Mendocino | Mendocino | 45 | 2020-11-29 | 1580 | 23 | |
16924 | 16924 | Merced | Merced | 47 | 2020-11-29 | 11537 | 179 | TRUE |
16925 | 16925 | Modoc | Modoc | 49 | 2020-11-29 | 143 | 0 | |
16926 | 16926 | Mono | Mono | 51 | 2020-11-29 | 548 | 3 | |
16927 | 16927 | Monterey | Monterey | 53 | 2020-11-29 | 15089 | 122 | |
16928 | 16928 | Napa | Napa | 55 | 2020-11-29 | 2931 | 16 | TRUE |
16929 | 16929 | Nevada | Nevada | 57 | 2020-11-29 | 1183 | 9 | TRUE |
16930 | 16930 | Orange | Orange | 59 | 2020-11-29 | 77819 | 1577 | |
16931 | 16931 | Placer | Placer | 61 | 2020-11-29 | 6354 | 68 | TRUE |
16932 | 16932 | Plumas | Plumas | 63 | 2020-11-29 | 215 | 0 | TRUE |
16933 | 16933 | Riverside | Riverside | 65 | 2020-11-29 | 82286 | 1437 | TRUE |
16934 | 16934 | Sacramento | Sacramento | 67 | 2020-11-29 | 36630 | 576 | TRUE |
16935 | 16935 | San Benito | San Benito | 69 | 2020-11-29 | 1880 | 16 | |
16936 | 16936 | San Bernardino | San Bernardino | 71 | 2020-11-29 | 93019 | 1472 | |
16937 | 16937 | San Diego | San Diego | 73 | 2020-11-29 | 81084 | 997 | |
16938 | 16938 | San Francisco | San Francisco | 75 | 2020-11-29 | 15417 | 160 | |
16939 | 16939 | San Joaquin | San Joaquin | 77 | 2020-11-29 | 25675 | 502 | TRUE |
16940 | 16940 | San Luis Obispo | San Luis Obispo | 79 | 2020-11-29 | 6129 | 36 | TRUE |
16941 | 16941 | San Mateo | San Mateo | 81 | 2020-11-29 | 14148 | 170 | TRUE |
16942 | 16942 | Santa Barbara | Santa Barbara | 83 | 2020-11-29 | 11205 | 135 | TRUE |
16943 | 16943 | Santa Clara | Santa Clara | 85 | 2020-11-29 | 36512 | 436 | |
16944 | 16944 | Santa Cruz | Santa Cruz | 87 | 2020-11-29 | 4424 | 28 | TRUE |
16945 | 16945 | Shasta | Shasta | 89 | 2020-11-29 | 4718 | 47 | TRUE |
16946 | 16946 | Sierra | Sierra | 91 | 2020-11-29 | 19 | 0 | TRUE |
16947 | 16947 | Siskiyou | Siskiyou | 93 | 2020-11-29 | 624 | 2 | TRUE |
16948 | 16948 | Solano | Solano | 95 | 2020-11-29 | 10036 | 81 | TRUE |
16949 | 16949 | Sonoma | Sonoma | 97 | 2020-11-29 | 12198 | 157 | |
16950 | 16950 | Stanislaus | Stanislaus | 99 | 2020-11-29 | 21714 | 424 | |
16951 | 16951 | Sutter | Sutter | 101 | 2020-11-29 | 3332 | 16 | TRUE |
16952 | 16952 | Tehama | Tehama | 103 | 2020-11-29 | 1589 | 25 | TRUE |
16953 | 16953 | Trinity | Trinity | 105 | 2020-11-29 | 158 | 0 | TRUE |
16954 | 16954 | Tulare | Tulare | 107 | 2020-11-29 | 20550 | 308 | TRUE |
16955 | 16955 | Tuolumne | Tuolumne | 109 | 2020-11-29 | 1035 | 8 | |
16956 | 16956 | Ventura | Ventura | 111 | 2020-11-29 | 18394 | 175 | TRUE |
16957 | 16957 | Yolo | Yolo | 113 | 2020-11-29 | 4827 | 76 | |
16958 | 16958 | Yuba | Yuba | 115 | 2020-11-29 | 2036 | 10 | 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 );