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-12-01 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 |
---|---|---|---|---|---|---|---|---|
16776 | 16776 | Alameda | Alameda | 1 | 2020-12-01 | 29732 | 533 | |
16777 | 16777 | Berkeley | Alameda | 1 | 2020-12-01 | 1178 | 10 | |
16778 | 16778 | Alpine | Alpine | 3 | 2020-12-01 | 51 | 0 | TRUE |
16779 | 16779 | Amador | Amador | 5 | 2020-12-01 | 666 | 16 | |
16780 | 16780 | Butte | Butte | 7 | 2020-12-01 | 4177 | 60 | |
16781 | 16781 | Calaveras | Calaveras | 9 | 2020-12-01 | 498 | 22 | |
16782 | 16782 | Colusa | Colusa | 11 | 2020-12-01 | 747 | 6 | |
16783 | 16783 | Contra Costa | Contra Costa | 13 | 2020-12-01 | 24914 | 261 | |
16784 | 16784 | Del Norte | Del Norte | 15 | 2020-12-01 | 313 | 1 | TRUE |
16785 | 16785 | El Dorado | El Dorado | 17 | 2020-12-01 | 2581 | 4 | |
16786 | 16786 | Fresno | Fresno | 19 | 2020-12-01 | 45517 | 488 | |
16787 | 16787 | Glenn | Glenn | 21 | 2020-12-01 | 985 | 10 | |
16788 | 16788 | Humboldt | Humboldt | 23 | 2020-12-01 | 919 | 9 | |
16789 | 16789 | Imperial | Imperial | 25 | 2020-12-01 | 16364 | 356 | |
16790 | 16790 | Inyo | Inyo | 27 | 2020-12-01 | 308 | 16 | |
16791 | 16791 | Kern | Kern | 29 | 2020-12-01 | 42614 | 449 | |
16792 | 16792 | Kings | Kings | 31 | 2020-12-01 | 11434 | 89 | |
16793 | 16793 | Lake | Lake | 33 | 2020-12-01 | 971 | 20 | |
16794 | 16794 | Lassen | Lassen | 35 | 2020-12-01 | 2182 | 3 | |
16795 | 16795 | Long Beach | Los Angeles | 37 | 2020-12-01 | 16786 | 277 | |
16796 | 16796 | Los Angeles | Los Angeles | 37 | 2020-12-01 | 388483 | 7293 | |
16797 | 16797 | Pasadena | Los Angeles | 37 | 2020-12-01 | 3746 | 132 | |
16798 | 16798 | Madera | Madera | 39 | 2020-12-01 | 6346 | 86 | |
16799 | 16799 | Marin | Marin | 41 | 2020-12-01 | 7840 | 129 | |
16800 | 16800 | Mariposa | Mariposa | 43 | 2020-12-01 | 143 | 3 | |
16801 | 16801 | Mendocino | Mendocino | 45 | 2020-12-01 | 1632 | 23 | |
16802 | 16802 | Merced | Merced | 47 | 2020-12-01 | 12281 | 182 | |
16803 | 16803 | Modoc | Modoc | 49 | 2020-12-01 | 156 | 0 | |
16804 | 16804 | Mono | Mono | 51 | 2020-12-01 | 549 | 3 | |
16805 | 16805 | Monterey | Monterey | 53 | 2020-12-01 | 15245 | 123 | |
16806 | 16806 | Napa | Napa | 55 | 2020-12-01 | 3095 | 17 | |
16807 | 16807 | Nevada | Nevada | 57 | 2020-12-01 | 1414 | 10 | |
16808 | 16808 | Orange | Orange | 59 | 2020-12-01 | 79343 | 1577 | |
16809 | 16809 | Placer | Placer | 61 | 2020-12-01 | 6664 | 71 | |
16810 | 16810 | Plumas | Plumas | 63 | 2020-12-01 | 230 | 0 | |
16811 | 16811 | Riverside | Riverside | 65 | 2020-12-01 | 84824 | 1443 | |
16812 | 16812 | Sacramento | Sacramento | 67 | 2020-12-01 | 38999 | 586 | |
16813 | 16813 | San Benito | San Benito | 69 | 2020-12-01 | 1929 | 17 | |
16814 | 16814 | San Bernardino | San Bernardino | 71 | 2020-12-01 | 94106 | 1502 | |
16815 | 16815 | San Diego | San Diego | 73 | 2020-12-01 | 83421 | 1019 | |
16816 | 16816 | San Francisco | San Francisco | 75 | 2020-12-01 | 15639 | 160 | |
16817 | 16817 | San Joaquin | San Joaquin | 77 | 2020-12-01 | 26064 | 510 | |
16818 | 16818 | San Luis Obispo | San Luis Obispo | 79 | 2020-12-01 | 6345 | 38 | |
16819 | 16819 | San Mateo | San Mateo | 81 | 2020-12-01 | 14614 | 170 | |
16820 | 16820 | Santa Barbara | Santa Barbara | 83 | 2020-12-01 | 11631 | 137 | |
16821 | 16821 | Santa Clara | Santa Clara | 85 | 2020-12-01 | 38752 | 444 | |
16822 | 16822 | Santa Cruz | Santa Cruz | 87 | 2020-12-01 | 4610 | 29 | |
16823 | 16823 | Shasta | Shasta | 89 | 2020-12-01 | 5132 | 50 | |
16824 | 16824 | Sierra | Sierra | 91 | 2020-12-01 | 23 | 0 | TRUE |
16825 | 16825 | Siskiyou | Siskiyou | 93 | 2020-12-01 | 737 | 3 | |
16826 | 16826 | Solano | Solano | 95 | 2020-12-01 | 10731 | 81 | |
16827 | 16827 | Sonoma | Sonoma | 97 | 2020-12-01 | 12662 | 160 | |
16828 | 16828 | Stanislaus | Stanislaus | 99 | 2020-12-01 | 22399 | 428 | |
16829 | 16829 | Sutter | Sutter | 101 | 2020-12-01 | 3637 | 19 | |
16830 | 16830 | Tehama | Tehama | 103 | 2020-12-01 | 1736 | 26 | |
16831 | 16831 | Trinity | Trinity | 105 | 2020-12-01 | 168 | 0 | |
16832 | 16832 | Tulare | Tulare | 107 | 2020-12-01 | 21332 | 312 | |
16833 | 16833 | Tuolumne | Tuolumne | 109 | 2020-12-01 | 1104 | 9 | |
16834 | 16834 | Ventura | Ventura | 111 | 2020-12-01 | 20193 | 185 | |
16835 | 16835 | Yolo | Yolo | 113 | 2020-12-01 | 4930 | 77 | |
16836 | 16836 | Yuba | Yuba | 115 | 2020-12-01 | 2221 | 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 );