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-13 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 |
---|---|---|---|---|---|---|---|---|
17874 | 17874 | Alameda | Alameda | 1 | 2020-11-13 | 24864 | 464 | |
17875 | 17875 | Berkeley | Alameda | 1 | 2020-11-13 | 868 | 10 | |
17876 | 17876 | Alpine | Alpine | 3 | 2020-11-13 | 30 | 0 | TRUE |
17877 | 17877 | Amador | Amador | 5 | 2020-11-13 | 368 | 15 | |
17878 | 17878 | Butte | Butte | 7 | 2020-11-13 | 3402 | 56 | |
17879 | 17879 | Calaveras | Calaveras | 9 | 2020-11-13 | 390 | 21 | |
17880 | 17880 | Colusa | Colusa | 11 | 2020-11-13 | 599 | 6 | |
17881 | 17881 | Contra Costa | Contra Costa | 13 | 2020-11-13 | 20868 | 253 | |
17882 | 17882 | Del Norte | Del Norte | 15 | 2020-11-13 | 220 | 1 | |
17883 | 17883 | El Dorado | El Dorado | 17 | 2020-11-13 | 1637 | 4 | |
17884 | 17884 | Fresno | Fresno | 19 | 2020-11-13 | 37257 | 460 | |
17885 | 17885 | Glenn | Glenn | 21 | 2020-11-13 | 770 | 6 | |
17886 | 17886 | Humboldt | Humboldt | 23 | 2020-11-13 | 658 | 9 | |
17887 | 17887 | Imperial | Imperial | 25 | 2020-11-13 | 13846 | 348 | |
17888 | 17888 | Inyo | Inyo | 27 | 2020-11-13 | 261 | 16 | |
17889 | 17889 | Kern | Kern | 29 | 2020-11-13 | 36227 | 432 | |
17890 | 17890 | Kings | Kings | 31 | 2020-11-13 | 9372 | 86 | |
17891 | 17891 | Lake | Lake | 33 | 2020-11-13 | 776 | 17 | |
17892 | 17892 | Lassen | Lassen | 35 | 2020-11-13 | 1061 | 1 | |
17893 | 17893 | Long Beach | Los Angeles | 37 | 2020-11-13 | 14097 | 265 | |
17894 | 17894 | Los Angeles | Los Angeles | 37 | 2020-11-13 | 315826 | 6852 | |
17895 | 17895 | Pasadena | Los Angeles | 37 | 2020-11-13 | 3054 | 129 | |
17896 | 17896 | Madera | Madera | 39 | 2020-11-13 | 5426 | 76 | |
17897 | 17897 | Marin | Marin | 41 | 2020-11-13 | 7344 | 127 | |
17898 | 17898 | Mariposa | Mariposa | 43 | 2020-11-13 | 89 | 2 | |
17899 | 17899 | Mendocino | Mendocino | 45 | 2020-11-13 | 1269 | 22 | TRUE |
17900 | 17900 | Merced | Merced | 47 | 2020-11-13 | 10313 | 164 | |
17901 | 17901 | Modoc | Modoc | 49 | 2020-11-13 | 92 | 0 | |
17902 | 17902 | Mono | Mono | 51 | 2020-11-13 | 480 | 2 | |
17903 | 17903 | Monterey | Monterey | 53 | 2020-11-13 | 12701 | 107 | |
17904 | 17904 | Napa | Napa | 55 | 2020-11-13 | 2432 | 16 | |
17905 | 17905 | Nevada | Nevada | 57 | 2020-11-13 | 822 | 9 | |
17906 | 17906 | Orange | Orange | 59 | 2020-11-13 | 64058 | 1522 | |
17907 | 17907 | Placer | Placer | 61 | 2020-11-13 | 5134 | 63 | |
17908 | 17908 | Plumas | Plumas | 63 | 2020-11-13 | 136 | 0 | |
17909 | 17909 | Riverside | Riverside | 65 | 2020-11-13 | 74180 | 1367 | |
17910 | 17910 | Sacramento | Sacramento | 67 | 2020-11-13 | 29837 | 520 | |
17911 | 17911 | San Benito | San Benito | 69 | 2020-11-13 | 1581 | 15 | |
17912 | 17912 | San Bernardino | San Bernardino | 71 | 2020-11-13 | 73001 | 1308 | |
17913 | 17913 | San Diego | San Diego | 73 | 2020-11-13 | 62945 | 921 | |
17914 | 17914 | San Francisco | San Francisco | 75 | 2020-11-13 | 13404 | 153 | |
17915 | 17915 | San Joaquin | San Joaquin | 77 | 2020-11-13 | 23517 | 501 | |
17916 | 17916 | San Luis Obispo | San Luis Obispo | 79 | 2020-11-13 | 5038 | 33 | |
17917 | 17917 | San Mateo | San Mateo | 81 | 2020-11-13 | 12332 | 168 | |
17918 | 17918 | Santa Barbara | Santa Barbara | 83 | 2020-11-13 | 10415 | 131 | |
17919 | 17919 | Santa Clara | Santa Clara | 85 | 2020-11-13 | 29075 | 390 | |
17920 | 17920 | Santa Cruz | Santa Cruz | 87 | 2020-11-13 | 3356 | 26 | |
17921 | 17921 | Shasta | Shasta | 89 | 2020-11-13 | 2980 | 36 | |
17922 | 17922 | Sierra | Sierra | 91 | 2020-11-13 | 11 | 0 | TRUE |
17923 | 17923 | Siskiyou | Siskiyou | 93 | 2020-11-13 | 372 | 1 | |
17924 | 17924 | Solano | Solano | 95 | 2020-11-13 | 8729 | 79 | |
17925 | 17925 | Sonoma | Sonoma | 97 | 2020-11-13 | 10747 | 149 | |
17926 | 17926 | Stanislaus | Stanislaus | 99 | 2020-11-13 | 18992 | 411 | |
17927 | 17927 | Sutter | Sutter | 101 | 2020-11-13 | 2134 | 12 | |
17928 | 17928 | Tehama | Tehama | 103 | 2020-11-13 | 1111 | 19 | |
17929 | 17929 | Trinity | Trinity | 105 | 2020-11-13 | 68 | 0 | |
17930 | 17930 | Tulare | Tulare | 107 | 2020-11-13 | 18896 | 300 | |
17931 | 17931 | Tuolumne | Tuolumne | 109 | 2020-11-13 | 467 | 8 | |
17932 | 17932 | Ventura | Ventura | 111 | 2020-11-13 | 16029 | 172 | |
17933 | 17933 | Yolo | Yolo | 113 | 2020-11-13 | 3720 | 66 | |
17934 | 17934 | Yuba | Yuba | 115 | 2020-11-13 | 1529 | 10 |
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 );