ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where "date" is on date 2021-11-04 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1881784 | 1881784 | 2021-11-04 | Alameda | California | 6001 | 122349 | 1441 |
1881785 | 1881785 | 2021-11-04 | Alpine | California | 6003 | 105 | 0 |
1881786 | 1881786 | 2021-11-04 | Amador | California | 6005 | 5608 | 66 |
1881787 | 1881787 | 2021-11-04 | Butte | California | 6007 | 24608 | 284 |
1881788 | 1881788 | 2021-11-04 | Calaveras | California | 6009 | 4146 | 82 |
1881789 | 1881789 | 2021-11-04 | Colusa | California | 6011 | 3147 | 20 |
1881790 | 1881790 | 2021-11-04 | Contra Costa | California | 6013 | 101433 | 1025 |
1881791 | 1881791 | 2021-11-04 | Del Norte | California | 6015 | 3750 | 42 |
1881792 | 1881792 | 2021-11-04 | El Dorado | California | 6017 | 17639 | 156 |
1881793 | 1881793 | 2021-11-04 | Fresno | California | 6019 | 151137 | 2166 |
1881794 | 1881794 | 2021-11-04 | Glenn | California | 6021 | 4476 | 46 |
1881795 | 1881795 | 2021-11-04 | Humboldt | California | 6023 | 9535 | 116 |
1881796 | 1881796 | 2021-11-04 | Imperial | California | 6025 | 36752 | 765 |
1881797 | 1881797 | 2021-11-04 | Inyo | California | 6027 | 2382 | 41 |
1881798 | 1881798 | 2021-11-04 | Kern | California | 6029 | 150971 | 1699 |
1881799 | 1881799 | 2021-11-04 | Kings | California | 6031 | 34009 | 341 |
1881800 | 1881800 | 2021-11-04 | Lake | California | 6033 | 6830 | 106 |
1881801 | 1881801 | 2021-11-04 | Lassen | California | 6035 | 7732 | 52 |
1881802 | 1881802 | 2021-11-04 | Los Angeles | California | 6037 | 1499097 | 26695 |
1881803 | 1881803 | 2021-11-04 | Madera | California | 6039 | 24921 | 291 |
1881804 | 1881804 | 2021-11-04 | Marin | California | 6041 | 17947 | 247 |
1881805 | 1881805 | 2021-11-04 | Mariposa | California | 6043 | 1455 | 17 |
1881806 | 1881806 | 2021-11-04 | Mendocino | California | 6045 | 8003 | 89 |
1881807 | 1881807 | 2021-11-04 | Merced | California | 6047 | 43956 | 606 |
1881808 | 1881808 | 2021-11-04 | Modoc | California | 6049 | 930 | 9 |
1881809 | 1881809 | 2021-11-04 | Mono | California | 6051 | 1738 | 4 |
1881810 | 1881810 | 2021-11-04 | Monterey | California | 6053 | 51446 | 606 |
1881811 | 1881811 | 2021-11-04 | Napa | California | 6055 | 13053 | 103 |
1881812 | 1881812 | 2021-11-04 | Nevada | California | 6057 | 9448 | 91 |
1881813 | 1881813 | 2021-11-04 | Orange | California | 6059 | 327827 | 5612 |
1881814 | 1881814 | 2021-11-04 | Placer | California | 6061 | 40617 | 438 |
1881815 | 1881815 | 2021-11-04 | Plumas | California | 6063 | 1780 | 7 |
1881816 | 1881816 | 2021-11-04 | Riverside | California | 6065 | 377219 | 5226 |
1881817 | 1881817 | 2021-11-04 | Sacramento | California | 6067 | 163189 | 2357 |
1881818 | 1881818 | 2021-11-04 | San Benito | California | 6069 | 7597 | 75 |
1881819 | 1881819 | 2021-11-04 | San Bernardino | California | 6071 | 363592 | 5815 |
1881820 | 1881820 | 2021-11-04 | San Diego | California | 6073 | 394654 | 4241 |
1881821 | 1881821 | 2021-11-04 | San Francisco | California | 6075 | 55203 | 663 |
1881822 | 1881822 | 2021-11-04 | San Joaquin | California | 6077 | 104673 | 1779 |
1881823 | 1881823 | 2021-11-04 | San Luis Obispo | California | 6079 | 30540 | 349 |
1881824 | 1881824 | 2021-11-04 | San Mateo | California | 6081 | 54977 | 625 |
1881825 | 1881825 | 2021-11-04 | Santa Barbara | California | 6083 | 45915 | 531 |
1881826 | 1881826 | 2021-11-04 | Santa Clara | California | 6085 | 147658 | 1898 |
1881827 | 1881827 | 2021-11-04 | Santa Cruz | California | 6087 | 21358 | 222 |
1881828 | 1881828 | 2021-11-04 | Shasta | California | 6089 | 24940 | 377 |
1881829 | 1881829 | 2021-11-04 | Sierra | California | 6091 | 202 | 0 |
1881830 | 1881830 | 2021-11-04 | Siskiyou | California | 6093 | 4755 | 66 |
1881831 | 1881831 | 2021-11-04 | Solano | California | 6095 | 46648 | 351 |
1881832 | 1881832 | 2021-11-04 | Sonoma | California | 6097 | 41859 | 408 |
1881833 | 1881833 | 2021-11-04 | Stanislaus | California | 6099 | 87998 | 1359 |
1881834 | 1881834 | 2021-11-04 | Sutter | California | 6101 | 14228 | 179 |
1881835 | 1881835 | 2021-11-04 | Tehama | California | 6103 | 9964 | 118 |
1881836 | 1881836 | 2021-11-04 | Trinity | California | 6105 | 926 | 11 |
1881837 | 1881837 | 2021-11-04 | Tulare | California | 6107 | 83261 | 1007 |
1881838 | 1881838 | 2021-11-04 | Tuolumne | California | 6109 | 7438 | 129 |
1881839 | 1881839 | 2021-11-04 | Ventura | California | 6111 | 102107 | 1178 |
1881840 | 1881840 | 2021-11-04 | Yolo | California | 6113 | 20920 | 250 |
1881841 | 1881841 | 2021-11-04 | Yuba | California | 6115 | 10842 | 83 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);