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-27 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
9700 | 9700 | Alameda | Alameda | 1 | 2021-03-27 | 80221 | 1200 | TRUE |
9701 | 9701 | Berkeley | Alameda | 1 | 2021-03-27 | 3429 | 46 | TRUE |
9702 | 9702 | Alpine | Alpine | 3 | 2021-03-27 | 86 | 0 | TRUE |
9703 | 9703 | Amador | Amador | 5 | 2021-03-27 | 3502 | 45 | |
9704 | 9704 | Butte | Butte | 7 | 2021-03-27 | 11278 | 177 | TRUE |
9705 | 9705 | Calaveras | Calaveras | 9 | 2021-03-27 | 1995 | 51 | TRUE |
9706 | 9706 | Colusa | Colusa | 11 | 2021-03-27 | 2164 | 16 | |
9707 | 9707 | Contra Costa | Contra Costa | 13 | 2021-03-27 | 65065 | 754 | TRUE |
9708 | 9708 | Del Norte | Del Norte | 15 | 2021-03-27 | 1125 | 5 | TRUE |
9709 | 9709 | El Dorado | El Dorado | 17 | 2021-03-27 | 9417 | 107 | TRUE |
9710 | 9710 | Fresno | Fresno | 19 | 2021-03-27 | 98821 | 1592 | |
9711 | 9711 | Glenn | Glenn | 21 | 2021-03-27 | 2252 | 25 | TRUE |
9712 | 9712 | Humboldt | Humboldt | 23 | 2021-03-27 | 3448 | 35 | TRUE |
9713 | 9713 | Imperial | Imperial | 25 | 2021-03-27 | 26998 | 715 | TRUE |
9714 | 9714 | Inyo | Inyo | 27 | 2021-03-27 | 1394 | 37 | TRUE |
9715 | 9715 | Kern | Kern | 29 | 2021-03-27 | 105994 | 1191 | |
9716 | 9716 | Kings | Kings | 31 | 2021-03-27 | 22578 | 241 | TRUE |
9717 | 9717 | Lake | Lake | 33 | 2021-03-27 | 3295 | 43 | TRUE |
9718 | 9718 | Lassen | Lassen | 35 | 2021-03-27 | 5649 | 24 | |
9719 | 9719 | Long Beach | Los Angeles | 37 | 2021-03-27 | 52037 | 908 | TRUE |
9720 | 9720 | Los Angeles | Los Angeles | 37 | 2021-03-27 | 1154610 | 21834 | |
9721 | 9721 | Pasadena | Los Angeles | 37 | 2021-03-27 | 11128 | 335 | TRUE |
9722 | 9722 | Madera | Madera | 39 | 2021-03-27 | 15862 | 231 | TRUE |
9723 | 9723 | Marin | Marin | 41 | 2021-03-27 | 13646 | 203 | |
9724 | 9724 | Mariposa | Mariposa | 43 | 2021-03-27 | 408 | 7 | TRUE |
9725 | 9725 | Mendocino | Mendocino | 45 | 2021-03-27 | 3935 | 46 | TRUE |
9726 | 9726 | Merced | Merced | 47 | 2021-03-27 | 30419 | 434 | TRUE |
9727 | 9727 | Modoc | Modoc | 49 | 2021-03-27 | 472 | 4 | TRUE |
9728 | 9728 | Mono | Mono | 51 | 2021-03-27 | 1261 | 4 | TRUE |
9729 | 9729 | Monterey | Monterey | 53 | 2021-03-27 | 42890 | 340 | |
9730 | 9730 | Napa | Napa | 55 | 2021-03-27 | 9336 | 78 | TRUE |
9731 | 9731 | Nevada | Nevada | 57 | 2021-03-27 | 4219 | 74 | TRUE |
9732 | 9732 | Orange | Orange | 59 | 2021-03-27 | 250189 | 4711 | |
9733 | 9733 | Placer | Placer | 61 | 2021-03-27 | 20736 | 263 | TRUE |
9734 | 9734 | Plumas | Plumas | 63 | 2021-03-27 | 675 | 6 | TRUE |
9735 | 9735 | Riverside | Riverside | 65 | 2021-03-27 | 293831 | 4248 | TRUE |
9736 | 9736 | Sacramento | Sacramento | 67 | 2021-03-27 | 96990 | 1599 | TRUE |
9737 | 9737 | San Benito | San Benito | 69 | 2021-03-27 | 5846 | 61 | |
9738 | 9738 | San Bernardino | San Bernardino | 71 | 2021-03-27 | 290505 | 4727 | |
9739 | 9739 | San Diego | San Diego | 73 | 2021-03-27 | 269275 | 3540 | |
9740 | 9740 | San Francisco | San Francisco | 75 | 2021-03-27 | 34971 | 463 | |
9741 | 9741 | San Joaquin | San Joaquin | 77 | 2021-03-27 | 69448 | 1250 | TRUE |
9742 | 9742 | San Luis Obispo | San Luis Obispo | 79 | 2021-03-27 | 20402 | 255 | TRUE |
9743 | 9743 | San Mateo | San Mateo | 81 | 2021-03-27 | 40186 | 547 | |
9744 | 9744 | Santa Barbara | Santa Barbara | 83 | 2021-03-27 | 33045 | 435 | |
9745 | 9745 | Santa Clara | Santa Clara | 85 | 2021-03-27 | 113537 | 1648 | |
9746 | 9746 | Santa Cruz | Santa Cruz | 87 | 2021-03-27 | 15247 | 200 | TRUE |
9747 | 9747 | Shasta | Shasta | 89 | 2021-03-27 | 11333 | 202 | TRUE |
9748 | 9748 | Sierra | Sierra | 91 | 2021-03-27 | 104 | 0 | TRUE |
9749 | 9749 | Siskiyou | Siskiyou | 93 | 2021-03-27 | 1870 | 15 | TRUE |
9750 | 9750 | Solano | Solano | 95 | 2021-03-27 | 31009 | 191 | TRUE |
9751 | 9751 | Sonoma | Sonoma | 97 | 2021-03-27 | 29122 | 308 | |
9752 | 9752 | Stanislaus | Stanislaus | 99 | 2021-03-27 | 52392 | 992 | |
9753 | 9753 | Sutter | Sutter | 101 | 2021-03-27 | 9110 | 102 | TRUE |
9754 | 9754 | Tehama | Tehama | 103 | 2021-03-27 | 5260 | 54 | |
9755 | 9755 | Trinity | Trinity | 105 | 2021-03-27 | 387 | 5 | TRUE |
9756 | 9756 | Tulare | Tulare | 107 | 2021-03-27 | 48960 | 805 | TRUE |
9757 | 9757 | Tuolumne | Tuolumne | 109 | 2021-03-27 | 4024 | 62 | TRUE |
9758 | 9758 | Ventura | Ventura | 111 | 2021-03-27 | 79472 | 969 | |
9759 | 9759 | Yolo | Yolo | 113 | 2021-03-27 | 13176 | 196 | TRUE |
9760 | 9760 | Yuba | Yuba | 115 | 2021-03-27 | 5953 | 40 | 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 );