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-01-01 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 |
---|---|---|---|---|---|---|---|---|
14885 | 14885 | Alameda | Alameda | 1 | 2021-01-01 | 51634 | 839 | |
14886 | 14886 | Berkeley | Alameda | 1 | 2021-01-01 | 1902 | 32 | TRUE |
14887 | 14887 | Alpine | Alpine | 3 | 2021-01-01 | 67 | 0 | TRUE |
14888 | 14888 | Amador | Amador | 5 | 2021-01-01 | 2562 | 24 | |
14889 | 14889 | Butte | Butte | 7 | 2021-01-01 | 7589 | 96 | TRUE |
14890 | 14890 | Calaveras | Calaveras | 9 | 2021-01-01 | 853 | 22 | TRUE |
14891 | 14891 | Colusa | Colusa | 11 | 2021-01-01 | 1351 | 8 | TRUE |
14892 | 14892 | Contra Costa | Contra Costa | 13 | 2021-01-01 | 41599 | 347 | |
14893 | 14893 | Del Norte | Del Norte | 15 | 2021-01-01 | 769 | 2 | |
14894 | 14894 | El Dorado | El Dorado | 17 | 2021-01-01 | 5719 | 24 | TRUE |
14895 | 14895 | Fresno | Fresno | 19 | 2021-01-01 | 72801 | 711 | |
14896 | 14896 | Glenn | Glenn | 21 | 2021-01-01 | 1449 | 14 | TRUE |
14897 | 14897 | Humboldt | Humboldt | 23 | 2021-01-01 | 1764 | 22 | TRUE |
14898 | 14898 | Imperial | Imperial | 25 | 2021-01-01 | 22219 | 420 | TRUE |
14899 | 14899 | Inyo | Inyo | 27 | 2021-01-01 | 635 | 20 | TRUE |
14900 | 14900 | Kern | Kern | 29 | 2021-01-01 | 69484 | 512 | |
14901 | 14901 | Kings | Kings | 31 | 2021-01-01 | 16394 | 110 | |
14902 | 14902 | Lake | Lake | 33 | 2021-01-01 | 1883 | 24 | |
14903 | 14903 | Lassen | Lassen | 35 | 2021-01-01 | 4691 | 10 | TRUE |
14904 | 14904 | Long Beach | Los Angeles | 37 | 2021-01-01 | 32368 | 395 | TRUE |
14905 | 14905 | Los Angeles | Los Angeles | 37 | 2021-01-01 | 751335 | 9990 | |
14906 | 14906 | Pasadena | Los Angeles | 37 | 2021-01-01 | 6879 | 167 | TRUE |
14907 | 14907 | Madera | Madera | 39 | 2021-01-01 | 10491 | 117 | TRUE |
14908 | 14908 | Marin | Marin | 41 | 2021-01-01 | 9900 | 139 | |
14909 | 14909 | Mariposa | Mariposa | 43 | 2021-01-01 | 255 | 4 | |
14910 | 14910 | Mendocino | Mendocino | 45 | 2021-01-01 | 2558 | 27 | |
14911 | 14911 | Merced | Merced | 47 | 2021-01-01 | 19444 | 260 | |
14912 | 14912 | Modoc | Modoc | 49 | 2021-01-01 | 326 | 1 | |
14913 | 14913 | Mono | Mono | 51 | 2021-01-01 | 911 | 4 | |
14914 | 14914 | Monterey | Monterey | 53 | 2021-01-01 | 28064 | 196 | |
14915 | 14915 | Napa | Napa | 55 | 2021-01-01 | 5741 | 28 | TRUE |
14916 | 14916 | Nevada | Nevada | 57 | 2021-01-01 | 2609 | 50 | TRUE |
14917 | 14917 | Orange | Orange | 59 | 2021-01-01 | 157183 | 1875 | TRUE |
14918 | 14918 | Placer | Placer | 61 | 2021-01-01 | 13755 | 125 | TRUE |
14919 | 14919 | Plumas | Plumas | 63 | 2021-01-01 | 486 | 4 | TRUE |
14920 | 14920 | Riverside | Riverside | 65 | 2021-01-01 | 180553 | 1985 | TRUE |
14921 | 14921 | Sacramento | Sacramento | 67 | 2021-01-01 | 65245 | 857 | TRUE |
14922 | 14922 | San Benito | San Benito | 69 | 2021-01-01 | 3739 | 29 | |
14923 | 14923 | San Bernardino | San Bernardino | 71 | 2021-01-01 | 194377 | 2762 | TRUE |
14924 | 14924 | San Diego | San Diego | 73 | 2021-01-01 | 160073 | 1592 | |
14925 | 14925 | San Francisco | San Francisco | 75 | 2021-01-01 | 23521 | 189 | |
14926 | 14926 | San Joaquin | San Joaquin | 77 | 2021-01-01 | 45583 | 651 | TRUE |
14927 | 14927 | San Luis Obispo | San Luis Obispo | 79 | 2021-01-01 | 10397 | 82 | TRUE |
14928 | 14928 | San Mateo | San Mateo | 81 | 2021-01-01 | 24589 | 227 | TRUE |
14929 | 14929 | Santa Barbara | Santa Barbara | 83 | 2021-01-01 | 17391 | 160 | TRUE |
14930 | 14930 | Santa Clara | Santa Clara | 85 | 2021-01-01 | 75231 | 895 | |
14931 | 14931 | Santa Cruz | Santa Cruz | 87 | 2021-01-01 | 8749 | 83 | TRUE |
14932 | 14932 | Shasta | Shasta | 89 | 2021-01-01 | 8060 | 78 | TRUE |
14933 | 14933 | Sierra | Sierra | 91 | 2021-01-01 | 47 | 0 | TRUE |
14934 | 14934 | Siskiyou | Siskiyou | 93 | 2021-01-01 | 1176 | 11 | TRUE |
14935 | 14935 | Solano | Solano | 95 | 2021-01-01 | 19211 | 98 | TRUE |
14936 | 14936 | Sonoma | Sonoma | 97 | 2021-01-01 | 19360 | 196 | |
14937 | 14937 | Stanislaus | Stanislaus | 99 | 2021-01-01 | 34465 | 616 | TRUE |
14938 | 14938 | Sutter | Sutter | 101 | 2021-01-01 | 6505 | 52 | TRUE |
14939 | 14939 | Tehama | Tehama | 103 | 2021-01-01 | 3344 | 37 | |
14940 | 14940 | Trinity | Trinity | 105 | 2021-01-01 | 276 | 4 | TRUE |
14941 | 14941 | Tulare | Tulare | 107 | 2021-01-01 | 33443 | 406 | TRUE |
14942 | 14942 | Tuolumne | Tuolumne | 109 | 2021-01-01 | 2962 | 21 | TRUE |
14943 | 14943 | Ventura | Ventura | 111 | 2021-01-01 | 39559 | 263 | TRUE |
14944 | 14944 | Yolo | Yolo | 113 | 2021-01-01 | 8238 | 111 | TRUE |
14945 | 14945 | Yuba | Yuba | 115 | 2021-01-01 | 3898 | 19 | 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 );