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-08 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1894783 | 1894783 | 2021-11-08 | Alameda | California | 6001 | 122895 | 1460 |
1894784 | 1894784 | 2021-11-08 | Alpine | California | 6003 | 105 | 0 |
1894785 | 1894785 | 2021-11-08 | Amador | California | 6005 | 5643 | 66 |
1894786 | 1894786 | 2021-11-08 | Butte | California | 6007 | 24808 | 288 |
1894787 | 1894787 | 2021-11-08 | Calaveras | California | 6009 | 4217 | 82 |
1894788 | 1894788 | 2021-11-08 | Colusa | California | 6011 | 3159 | 20 |
1894789 | 1894789 | 2021-11-08 | Contra Costa | California | 6013 | 101861 | 1028 |
1894790 | 1894790 | 2021-11-08 | Del Norte | California | 6015 | 3764 | 42 |
1894791 | 1894791 | 2021-11-08 | El Dorado | California | 6017 | 17764 | 156 |
1894792 | 1894792 | 2021-11-08 | Fresno | California | 6019 | 152527 | 2179 |
1894793 | 1894793 | 2021-11-08 | Glenn | California | 6021 | 4499 | 46 |
1894794 | 1894794 | 2021-11-08 | Humboldt | California | 6023 | 9660 | 117 |
1894795 | 1894795 | 2021-11-08 | Imperial | California | 6025 | 37024 | 765 |
1894796 | 1894796 | 2021-11-08 | Inyo | California | 6027 | 2432 | 41 |
1894797 | 1894797 | 2021-11-08 | Kern | California | 6029 | 152418 | 1706 |
1894798 | 1894798 | 2021-11-08 | Kings | California | 6031 | 34307 | 344 |
1894799 | 1894799 | 2021-11-08 | Lake | California | 6033 | 6879 | 106 |
1894800 | 1894800 | 2021-11-08 | Lassen | California | 6035 | 7748 | 52 |
1894801 | 1894801 | 2021-11-08 | Los Angeles | California | 6037 | 1504368 | 26752 |
1894802 | 1894802 | 2021-11-08 | Madera | California | 6039 | 25253 | 291 |
1894803 | 1894803 | 2021-11-08 | Marin | California | 6041 | 18050 | 247 |
1894804 | 1894804 | 2021-11-08 | Mariposa | California | 6043 | 1482 | 17 |
1894805 | 1894805 | 2021-11-08 | Mendocino | California | 6045 | 8113 | 90 |
1894806 | 1894806 | 2021-11-08 | Merced | California | 6047 | 44316 | 608 |
1894807 | 1894807 | 2021-11-08 | Modoc | California | 6049 | 935 | 9 |
1894808 | 1894808 | 2021-11-08 | Mono | California | 6051 | 1758 | 4 |
1894809 | 1894809 | 2021-11-08 | Monterey | California | 6053 | 51576 | 606 |
1894810 | 1894810 | 2021-11-08 | Napa | California | 6055 | 13157 | 103 |
1894811 | 1894811 | 2021-11-08 | Nevada | California | 6057 | 9571 | 92 |
1894812 | 1894812 | 2021-11-08 | Orange | California | 6059 | 329084 | 5618 |
1894813 | 1894813 | 2021-11-08 | Placer | California | 6061 | 40951 | 439 |
1894814 | 1894814 | 2021-11-08 | Plumas | California | 6063 | 1828 | 7 |
1894815 | 1894815 | 2021-11-08 | Riverside | California | 6065 | 379119 | 5240 |
1894816 | 1894816 | 2021-11-08 | Sacramento | California | 6067 | 164427 | 2364 |
1894817 | 1894817 | 2021-11-08 | San Benito | California | 6069 | 7638 | 75 |
1894818 | 1894818 | 2021-11-08 | San Bernardino | California | 6071 | 365855 | 5832 |
1894819 | 1894819 | 2021-11-08 | San Diego | California | 6073 | 396868 | 4250 |
1894820 | 1894820 | 2021-11-08 | San Francisco | California | 6075 | 55578 | 666 |
1894821 | 1894821 | 2021-11-08 | San Joaquin | California | 6077 | 105181 | 1794 |
1894822 | 1894822 | 2021-11-08 | San Luis Obispo | California | 6079 | 30718 | 350 |
1894823 | 1894823 | 2021-11-08 | San Mateo | California | 6081 | 55181 | 626 |
1894824 | 1894824 | 2021-11-08 | Santa Barbara | California | 6083 | 46196 | 532 |
1894825 | 1894825 | 2021-11-08 | Santa Clara | California | 6085 | 148453 | 1899 |
1894826 | 1894826 | 2021-11-08 | Santa Cruz | California | 6087 | 21480 | 222 |
1894827 | 1894827 | 2021-11-08 | Shasta | California | 6089 | 25204 | 391 |
1894828 | 1894828 | 2021-11-08 | Sierra | California | 6091 | 205 | 0 |
1894829 | 1894829 | 2021-11-08 | Siskiyou | California | 6093 | 4777 | 68 |
1894830 | 1894830 | 2021-11-08 | Solano | California | 6095 | 46819 | 350 |
1894831 | 1894831 | 2021-11-08 | Sonoma | California | 6097 | 42163 | 408 |
1894832 | 1894832 | 2021-11-08 | Stanislaus | California | 6099 | 89222 | 1378 |
1894833 | 1894833 | 2021-11-08 | Sutter | California | 6101 | 14316 | 180 |
1894834 | 1894834 | 2021-11-08 | Tehama | California | 6103 | 10054 | 121 |
1894835 | 1894835 | 2021-11-08 | Trinity | California | 6105 | 938 | 13 |
1894836 | 1894836 | 2021-11-08 | Tulare | California | 6107 | 83818 | 1020 |
1894837 | 1894837 | 2021-11-08 | Tuolumne | California | 6109 | 7518 | 131 |
1894838 | 1894838 | 2021-11-08 | Ventura | California | 6111 | 102510 | 1182 |
1894839 | 1894839 | 2021-11-08 | Yolo | California | 6113 | 21061 | 255 |
1894840 | 1894840 | 2021-11-08 | Yuba | California | 6115 | 10912 | 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);