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-12-10 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1998792 | 1998792 | 2021-12-10 | Alameda | California | 6001 | 126762 | 1516 |
1998793 | 1998793 | 2021-12-10 | Alpine | California | 6003 | 109 | 0 |
1998794 | 1998794 | 2021-12-10 | Amador | California | 6005 | 5858 | 69 |
1998795 | 1998795 | 2021-12-10 | Butte | California | 6007 | 25830 | 326 |
1998796 | 1998796 | 2021-12-10 | Calaveras | California | 6009 | 4539 | 89 |
1998797 | 1998797 | 2021-12-10 | Colusa | California | 6011 | 3314 | 21 |
1998798 | 1998798 | 2021-12-10 | Contra Costa | California | 6013 | 105074 | 1061 |
1998799 | 1998799 | 2021-12-10 | Del Norte | California | 6015 | 3915 | 42 |
1998800 | 1998800 | 2021-12-10 | El Dorado | California | 6017 | 18636 | 170 |
1998801 | 1998801 | 2021-12-10 | Fresno | California | 6019 | 158802 | 2294 |
1998802 | 1998802 | 2021-12-10 | Glenn | California | 6021 | 4622 | 51 |
1998803 | 1998803 | 2021-12-10 | Humboldt | California | 6023 | 10455 | 120 |
1998804 | 1998804 | 2021-12-10 | Imperial | California | 6025 | 39462 | 781 |
1998805 | 1998805 | 2021-12-10 | Inyo | California | 6027 | 2611 | 46 |
1998806 | 1998806 | 2021-12-10 | Kern | California | 6029 | 159721 | 1870 |
1998807 | 1998807 | 2021-12-10 | Kings | California | 6031 | 35733 | 373 |
1998808 | 1998808 | 2021-12-10 | Lake | California | 6033 | 7090 | 114 |
1998809 | 1998809 | 2021-12-10 | Lassen | California | 6035 | 8019 | 61 |
1998810 | 1998810 | 2021-12-10 | Los Angeles | California | 6037 | 1544488 | 27304 |
1998811 | 1998811 | 2021-12-10 | Madera | California | 6039 | 26666 | 315 |
1998812 | 1998812 | 2021-12-10 | Marin | California | 6041 | 18895 | 249 |
1998813 | 1998813 | 2021-12-10 | Mariposa | California | 6043 | 1648 | 18 |
1998814 | 1998814 | 2021-12-10 | Mendocino | California | 6045 | 8817 | 100 |
1998815 | 1998815 | 2021-12-10 | Merced | California | 6047 | 46068 | 685 |
1998816 | 1998816 | 2021-12-10 | Modoc | California | 6049 | 1071 | 10 |
1998817 | 1998817 | 2021-12-10 | Mono | California | 6051 | 1946 | 4 |
1998818 | 1998818 | 2021-12-10 | Monterey | California | 6053 | 53328 | 636 |
1998819 | 1998819 | 2021-12-10 | Napa | California | 6055 | 13583 | 107 |
1998820 | 1998820 | 2021-12-10 | Nevada | California | 6057 | 10238 | 106 |
1998821 | 1998821 | 2021-12-10 | Orange | California | 6059 | 337937 | 5814 |
1998822 | 1998822 | 2021-12-10 | Placer | California | 6061 | 43002 | 481 |
1998823 | 1998823 | 2021-12-10 | Plumas | California | 6063 | 1990 | 12 |
1998824 | 1998824 | 2021-12-10 | Riverside | California | 6065 | 393195 | 5502 |
1998825 | 1998825 | 2021-12-10 | Sacramento | California | 6067 | 170836 | 2479 |
1998826 | 1998826 | 2021-12-10 | San Benito | California | 6069 | 8004 | 79 |
1998827 | 1998827 | 2021-12-10 | San Bernardino | California | 6071 | 380385 | 6007 |
1998828 | 1998828 | 2021-12-10 | San Diego | California | 6073 | 415069 | 4374 |
1998829 | 1998829 | 2021-12-10 | San Francisco | California | 6075 | 57773 | 678 |
1998830 | 1998830 | 2021-12-10 | San Joaquin | California | 6077 | 108876 | 1842 |
1998831 | 1998831 | 2021-12-10 | San Luis Obispo | California | 6079 | 31940 | 366 |
1998832 | 1998832 | 2021-12-10 | San Mateo | California | 6081 | 57192 | 631 |
1998833 | 1998833 | 2021-12-10 | Santa Barbara | California | 6083 | 48090 | 559 |
1998834 | 1998834 | 2021-12-10 | Santa Clara | California | 6085 | 154536 | 1942 |
1998835 | 1998835 | 2021-12-10 | Santa Cruz | California | 6087 | 22684 | 225 |
1998836 | 1998836 | 2021-12-10 | Shasta | California | 6089 | 26472 | 470 |
1998837 | 1998837 | 2021-12-10 | Sierra | California | 6091 | 222 | 0 |
1998838 | 1998838 | 2021-12-10 | Siskiyou | California | 6093 | 4982 | 74 |
1998839 | 1998839 | 2021-12-10 | Solano | California | 6095 | 48216 | 365 |
1998840 | 1998840 | 2021-12-10 | Sonoma | California | 6097 | 43811 | 414 |
1998841 | 1998841 | 2021-12-10 | Stanislaus | California | 6099 | 92709 | 1452 |
1998842 | 1998842 | 2021-12-10 | Sutter | California | 6101 | 14771 | 187 |
1998843 | 1998843 | 2021-12-10 | Tehama | California | 6103 | 10363 | 134 |
1998844 | 1998844 | 2021-12-10 | Trinity | California | 6105 | 1028 | 17 |
1998845 | 1998845 | 2021-12-10 | Tulare | California | 6107 | 87521 | 1103 |
1998846 | 1998846 | 2021-12-10 | Tuolumne | California | 6109 | 7979 | 146 |
1998847 | 1998847 | 2021-12-10 | Ventura | California | 6111 | 105311 | 1195 |
1998848 | 1998848 | 2021-12-10 | Yolo | California | 6113 | 21914 | 267 |
1998849 | 1998849 | 2021-12-10 | Yuba | California | 6115 | 11376 | 92 |
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);