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-05-12 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 |
---|---|---|---|---|---|---|---|---|
6894 | 6894 | Alameda | Alameda | 1 | 2021-05-12 | 84395 | 1217 | |
6895 | 6895 | Berkeley | Alameda | 1 | 2021-05-12 | 3603 | 46 | |
6896 | 6896 | Alpine | Alpine | 3 | 2021-05-12 | 88 | 0 | TRUE |
6897 | 6897 | Amador | Amador | 5 | 2021-05-12 | 3623 | 47 | TRUE |
6898 | 6898 | Butte | Butte | 7 | 2021-05-12 | 12026 | 182 | |
6899 | 6899 | Calaveras | Calaveras | 9 | 2021-05-12 | 2129 | 54 | |
6900 | 6900 | Colusa | Colusa | 11 | 2021-05-12 | 2234 | 16 | |
6901 | 6901 | Contra Costa | Contra Costa | 13 | 2021-05-12 | 68741 | 793 | |
6902 | 6902 | Del Norte | Del Norte | 15 | 2021-05-12 | 1393 | 7 | |
6903 | 6903 | El Dorado | El Dorado | 17 | 2021-05-12 | 10168 | 112 | |
6904 | 6904 | Fresno | Fresno | 19 | 2021-05-12 | 101336 | 1686 | |
6905 | 6905 | Glenn | Glenn | 21 | 2021-05-12 | 2328 | 25 | |
6906 | 6906 | Humboldt | Humboldt | 23 | 2021-05-12 | 4002 | 41 | |
6907 | 6907 | Imperial | Imperial | 25 | 2021-05-12 | 27848 | 721 | |
6908 | 6908 | Inyo | Inyo | 27 | 2021-05-12 | 1428 | 38 | TRUE |
6909 | 6909 | Kern | Kern | 29 | 2021-05-12 | 109139 | 1373 | |
6910 | 6910 | Kings | Kings | 31 | 2021-05-12 | 22989 | 246 | |
6911 | 6911 | Lake | Lake | 33 | 2021-05-12 | 3458 | 43 | |
6912 | 6912 | Lassen | Lassen | 35 | 2021-05-12 | 5701 | 24 | TRUE |
6913 | 6913 | Long Beach | Los Angeles | 37 | 2021-05-12 | 53145 | 933 | |
6914 | 6914 | Los Angeles | Los Angeles | 37 | 2021-05-12 | 1171849 | 22762 | |
6915 | 6915 | Pasadena | Los Angeles | 37 | 2021-05-12 | 11262 | 346 | |
6916 | 6916 | Madera | Madera | 39 | 2021-05-12 | 16360 | 242 | |
6917 | 6917 | Marin | Marin | 41 | 2021-05-12 | 14056 | 211 | |
6918 | 6918 | Mariposa | Mariposa | 43 | 2021-05-12 | 448 | 7 | |
6919 | 6919 | Mendocino | Mendocino | 45 | 2021-05-12 | 4093 | 49 | |
6920 | 6920 | Merced | Merced | 47 | 2021-05-12 | 31898 | 460 | |
6921 | 6921 | Modoc | Modoc | 49 | 2021-05-12 | 499 | 4 | |
6922 | 6922 | Mono | Mono | 51 | 2021-05-12 | 1284 | 4 | |
6923 | 6923 | Monterey | Monterey | 53 | 2021-05-12 | 43613 | 382 | |
6924 | 6924 | Napa | Napa | 55 | 2021-05-12 | 9868 | 78 | |
6925 | 6925 | Nevada | Nevada | 57 | 2021-05-12 | 4742 | 75 | |
6926 | 6926 | Orange | Orange | 59 | 2021-05-12 | 254457 | 5023 | |
6927 | 6927 | Placer | Placer | 61 | 2021-05-12 | 22665 | 292 | |
6928 | 6928 | Plumas | Plumas | 63 | 2021-05-12 | 710 | 6 | TRUE |
6929 | 6929 | Riverside | Riverside | 65 | 2021-05-12 | 299455 | 4593 | |
6930 | 6930 | Sacramento | Sacramento | 67 | 2021-05-12 | 104720 | 1682 | |
6931 | 6931 | San Benito | San Benito | 69 | 2021-05-12 | 6063 | 63 | |
6932 | 6932 | San Bernardino | San Bernardino | 71 | 2021-05-12 | 296782 | 4807 | |
6933 | 6933 | San Diego | San Diego | 73 | 2021-05-12 | 278401 | 3729 | |
6934 | 6934 | San Francisco | San Francisco | 75 | 2021-05-12 | 36383 | 539 | |
6935 | 6935 | San Joaquin | San Joaquin | 77 | 2021-05-12 | 73220 | 1391 | |
6936 | 6936 | San Luis Obispo | San Luis Obispo | 79 | 2021-05-12 | 21208 | 260 | |
6937 | 6937 | San Mateo | San Mateo | 81 | 2021-05-12 | 41864 | 568 | |
6938 | 6938 | Santa Barbara | Santa Barbara | 83 | 2021-05-12 | 34337 | 450 | |
6939 | 6939 | Santa Clara | Santa Clara | 85 | 2021-05-12 | 117838 | 1686 | |
6940 | 6940 | Santa Cruz | Santa Cruz | 87 | 2021-05-12 | 16150 | 205 | |
6941 | 6941 | Shasta | Shasta | 89 | 2021-05-12 | 12126 | 226 | |
6942 | 6942 | Sierra | Sierra | 91 | 2021-05-12 | 112 | 0 | |
6943 | 6943 | Siskiyou | Siskiyou | 93 | 2021-05-12 | 2234 | 24 | |
6944 | 6944 | Solano | Solano | 95 | 2021-05-12 | 32912 | 216 | |
6945 | 6945 | Sonoma | Sonoma | 97 | 2021-05-12 | 30026 | 314 | |
6946 | 6946 | Stanislaus | Stanislaus | 99 | 2021-05-12 | 55512 | 1060 | |
6947 | 6947 | Sutter | Sutter | 101 | 2021-05-12 | 9433 | 106 | |
6948 | 6948 | Tehama | Tehama | 103 | 2021-05-12 | 5572 | 59 | TRUE |
6949 | 6949 | Trinity | Trinity | 105 | 2021-05-12 | 400 | 5 | TRUE |
6950 | 6950 | Tulare | Tulare | 107 | 2021-05-12 | 49654 | 839 | |
6951 | 6951 | Tuolumne | Tuolumne | 109 | 2021-05-12 | 4131 | 66 | |
6952 | 6952 | Ventura | Ventura | 111 | 2021-05-12 | 80978 | 1013 | |
6953 | 6953 | Yolo | Yolo | 113 | 2021-05-12 | 13831 | 208 | |
6954 | 6954 | Yuba | Yuba | 115 | 2021-05-12 | 6268 | 41 |
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 );