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-03 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 |
---|---|---|---|---|---|---|---|---|
14763 | 14763 | Alameda | Alameda | 1 | 2021-01-03 | 53106 | 859 | |
14764 | 14764 | Berkeley | Alameda | 1 | 2021-01-03 | 1958 | 34 | |
14765 | 14765 | Alpine | Alpine | 3 | 2021-01-03 | 67 | 0 | TRUE |
14766 | 14766 | Amador | Amador | 5 | 2021-01-03 | 2671 | 24 | |
14767 | 14767 | Butte | Butte | 7 | 2021-01-03 | 7837 | 96 | TRUE |
14768 | 14768 | Calaveras | Calaveras | 9 | 2021-01-03 | 853 | 22 | TRUE |
14769 | 14769 | Colusa | Colusa | 11 | 2021-01-03 | 1351 | 8 | TRUE |
14770 | 14770 | Contra Costa | Contra Costa | 13 | 2021-01-03 | 42628 | 347 | |
14771 | 14771 | Del Norte | Del Norte | 15 | 2021-01-03 | 776 | 2 | |
14772 | 14772 | El Dorado | El Dorado | 17 | 2021-01-03 | 5719 | 24 | TRUE |
14773 | 14773 | Fresno | Fresno | 19 | 2021-01-03 | 74398 | 711 | |
14774 | 14774 | Glenn | Glenn | 21 | 2021-01-03 | 1449 | 14 | TRUE |
14775 | 14775 | Humboldt | Humboldt | 23 | 2021-01-03 | 1764 | 22 | TRUE |
14776 | 14776 | Imperial | Imperial | 25 | 2021-01-03 | 22219 | 420 | TRUE |
14777 | 14777 | Inyo | Inyo | 27 | 2021-01-03 | 635 | 20 | TRUE |
14778 | 14778 | Kern | Kern | 29 | 2021-01-03 | 71033 | 512 | |
14779 | 14779 | Kings | Kings | 31 | 2021-01-03 | 16628 | 110 | |
14780 | 14780 | Lake | Lake | 33 | 2021-01-03 | 1883 | 24 | TRUE |
14781 | 14781 | Lassen | Lassen | 35 | 2021-01-03 | 4691 | 10 | TRUE |
14782 | 14782 | Long Beach | Los Angeles | 37 | 2021-01-03 | 33271 | 401 | TRUE |
14783 | 14783 | Los Angeles | Los Angeles | 37 | 2021-01-03 | 778417 | 10205 | |
14784 | 14784 | Pasadena | Los Angeles | 37 | 2021-01-03 | 7010 | 167 | |
14785 | 14785 | Madera | Madera | 39 | 2021-01-03 | 10491 | 117 | TRUE |
14786 | 14786 | Marin | Marin | 41 | 2021-01-03 | 10119 | 139 | |
14787 | 14787 | Mariposa | Mariposa | 43 | 2021-01-03 | 267 | 4 | |
14788 | 14788 | Mendocino | Mendocino | 45 | 2021-01-03 | 2626 | 30 | |
14789 | 14789 | Merced | Merced | 47 | 2021-01-03 | 19444 | 260 | TRUE |
14790 | 14790 | Modoc | Modoc | 49 | 2021-01-03 | 337 | 1 | |
14791 | 14791 | Mono | Mono | 51 | 2021-01-03 | 911 | 4 | TRUE |
14792 | 14792 | Monterey | Monterey | 53 | 2021-01-03 | 28351 | 196 | |
14793 | 14793 | Napa | Napa | 55 | 2021-01-03 | 5741 | 28 | TRUE |
14794 | 14794 | Nevada | Nevada | 57 | 2021-01-03 | 2609 | 50 | TRUE |
14795 | 14795 | Orange | Orange | 59 | 2021-01-03 | 161589 | 1901 | TRUE |
14796 | 14796 | Placer | Placer | 61 | 2021-01-03 | 13755 | 125 | TRUE |
14797 | 14797 | Plumas | Plumas | 63 | 2021-01-03 | 486 | 4 | TRUE |
14798 | 14798 | Riverside | Riverside | 65 | 2021-01-03 | 180553 | 1985 | TRUE |
14799 | 14799 | Sacramento | Sacramento | 67 | 2021-01-03 | 65245 | 857 | TRUE |
14800 | 14800 | San Benito | San Benito | 69 | 2021-01-03 | 3853 | 29 | |
14801 | 14801 | San Bernardino | San Bernardino | 71 | 2021-01-03 | 195663 | 2869 | |
14802 | 14802 | San Diego | San Diego | 73 | 2021-01-03 | 168020 | 1592 | |
14803 | 14803 | San Francisco | San Francisco | 75 | 2021-01-03 | 24216 | 194 | |
14804 | 14804 | San Joaquin | San Joaquin | 77 | 2021-01-03 | 45583 | 651 | TRUE |
14805 | 14805 | San Luis Obispo | San Luis Obispo | 79 | 2021-01-03 | 10397 | 82 | TRUE |
14806 | 14806 | San Mateo | San Mateo | 81 | 2021-01-03 | 24589 | 227 | TRUE |
14807 | 14807 | Santa Barbara | Santa Barbara | 83 | 2021-01-03 | 17391 | 160 | TRUE |
14808 | 14808 | Santa Clara | Santa Clara | 85 | 2021-01-03 | 77138 | 936 | |
14809 | 14809 | Santa Cruz | Santa Cruz | 87 | 2021-01-03 | 8749 | 83 | TRUE |
14810 | 14810 | Shasta | Shasta | 89 | 2021-01-03 | 8060 | 78 | TRUE |
14811 | 14811 | Sierra | Sierra | 91 | 2021-01-03 | 47 | 0 | TRUE |
14812 | 14812 | Siskiyou | Siskiyou | 93 | 2021-01-03 | 1176 | 11 | TRUE |
14813 | 14813 | Solano | Solano | 95 | 2021-01-03 | 19211 | 98 | TRUE |
14814 | 14814 | Sonoma | Sonoma | 97 | 2021-01-03 | 19386 | 196 | |
14815 | 14815 | Stanislaus | Stanislaus | 99 | 2021-01-03 | 35800 | 624 | |
14816 | 14816 | Sutter | Sutter | 101 | 2021-01-03 | 6505 | 52 | TRUE |
14817 | 14817 | Tehama | Tehama | 103 | 2021-01-03 | 3344 | 37 | TRUE |
14818 | 14818 | Trinity | Trinity | 105 | 2021-01-03 | 276 | 4 | TRUE |
14819 | 14819 | Tulare | Tulare | 107 | 2021-01-03 | 33443 | 406 | TRUE |
14820 | 14820 | Tuolumne | Tuolumne | 109 | 2021-01-03 | 2962 | 21 | TRUE |
14821 | 14821 | Ventura | Ventura | 111 | 2021-01-03 | 39559 | 263 | TRUE |
14822 | 14822 | Yolo | Yolo | 113 | 2021-01-03 | 8402 | 117 | |
14823 | 14823 | Yuba | Yuba | 115 | 2021-01-03 | 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 );