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 2022-01-11 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2102814 | 2102814 | 2022-01-11 | Alameda | California | 6001 | 170455 | 1582 |
2102815 | 2102815 | 2022-01-11 | Alpine | California | 6003 | 116 | 0 |
2102816 | 2102816 | 2022-01-11 | Amador | California | 6005 | 6370 | 71 |
2102817 | 2102817 | 2022-01-11 | Butte | California | 6007 | 28573 | 347 |
2102818 | 2102818 | 2022-01-11 | Calaveras | California | 6009 | 5117 | 93 |
2102819 | 2102819 | 2022-01-11 | Colusa | California | 6011 | 3501 | 21 |
2102820 | 2102820 | 2022-01-11 | Contra Costa | California | 6013 | 133185 | 1077 |
2102821 | 2102821 | 2022-01-11 | Del Norte | California | 6015 | 4174 | 43 |
2102822 | 2102822 | 2022-01-11 | El Dorado | California | 6017 | 21654 | 172 |
2102823 | 2102823 | 2022-01-11 | Fresno | California | 6019 | 175064 | 2404 |
2102824 | 2102824 | 2022-01-11 | Glenn | California | 6021 | 4929 | 55 |
2102825 | 2102825 | 2022-01-11 | Humboldt | California | 6023 | 12741 | 125 |
2102826 | 2102826 | 2022-01-11 | Imperial | California | 6025 | 45751 | 810 |
2102827 | 2102827 | 2022-01-11 | Inyo | California | 6027 | 3281 | 49 |
2102828 | 2102828 | 2022-01-11 | Kern | California | 6029 | 175585 | 1936 |
2102829 | 2102829 | 2022-01-11 | Kings | California | 6031 | 38569 | 389 |
2102830 | 2102830 | 2022-01-11 | Lake | California | 6033 | 7613 | 117 |
2102831 | 2102831 | 2022-01-11 | Lassen | California | 6035 | 8244 | 61 |
2102832 | 2102832 | 2022-01-11 | Los Angeles | California | 6037 | 2046912 | 27812 |
2102833 | 2102833 | 2022-01-11 | Madera | California | 6039 | 28949 | 328 |
2102834 | 2102834 | 2022-01-11 | Marin | California | 6041 | 25024 | 251 |
2102835 | 2102835 | 2022-01-11 | Mariposa | California | 6043 | 2000 | 18 |
2102836 | 2102836 | 2022-01-11 | Mendocino | California | 6045 | 9923 | 109 |
2102837 | 2102837 | 2022-01-11 | Merced | California | 6047 | 50999 | 713 |
2102838 | 2102838 | 2022-01-11 | Modoc | California | 6049 | 1175 | 11 |
2102839 | 2102839 | 2022-01-11 | Mono | California | 6051 | 2448 | 4 |
2102840 | 2102840 | 2022-01-11 | Monterey | California | 6053 | 59371 | 652 |
2102841 | 2102841 | 2022-01-11 | Napa | California | 6055 | 16990 | 109 |
2102842 | 2102842 | 2022-01-11 | Nevada | California | 6057 | 11709 | 110 |
2102843 | 2102843 | 2022-01-11 | Orange | California | 6059 | 428232 | 5911 |
2102844 | 2102844 | 2022-01-11 | Placer | California | 6061 | 50094 | 498 |
2102845 | 2102845 | 2022-01-11 | Plumas | California | 6063 | 2155 | 12 |
2102846 | 2102846 | 2022-01-11 | Riverside | California | 6065 | 464032 | 5635 |
2102847 | 2102847 | 2022-01-11 | Sacramento | California | 6067 | 205252 | 2574 |
2102848 | 2102848 | 2022-01-11 | San Benito | California | 6069 | 9716 | 83 |
2102849 | 2102849 | 2022-01-11 | San Bernardino | California | 6071 | 450602 | 6184 |
2102850 | 2102850 | 2022-01-11 | San Diego | California | 6073 | 556680 | 4500 |
2102851 | 2102851 | 2022-01-11 | San Francisco | California | 6075 | 86701 | 690 |
2102852 | 2102852 | 2022-01-11 | San Joaquin | California | 6077 | 126047 | 1927 |
2102853 | 2102853 | 2022-01-11 | San Luis Obispo | California | 6079 | 38316 | 371 |
2102854 | 2102854 | 2022-01-11 | San Mateo | California | 6081 | 79755 | 638 |
2102855 | 2102855 | 2022-01-11 | Santa Barbara | California | 6083 | 60914 | 578 |
2102856 | 2102856 | 2022-01-11 | Santa Clara | California | 6085 | 208256 | 1972 |
2102857 | 2102857 | 2022-01-11 | Santa Cruz | California | 6087 | 28201 | 232 |
2102858 | 2102858 | 2022-01-11 | Shasta | California | 6089 | 27933 | 500 |
2102859 | 2102859 | 2022-01-11 | Sierra | California | 6091 | 246 | 0 |
2102860 | 2102860 | 2022-01-11 | Siskiyou | California | 6093 | 5316 | 81 |
2102861 | 2102861 | 2022-01-11 | Solano | California | 6095 | 57379 | 385 |
2102862 | 2102862 | 2022-01-11 | Sonoma | California | 6097 | 55226 | 421 |
2102863 | 2102863 | 2022-01-11 | Stanislaus | California | 6099 | 102843 | 1499 |
2102864 | 2102864 | 2022-01-11 | Sutter | California | 6101 | 16441 | 203 |
2102865 | 2102865 | 2022-01-11 | Tehama | California | 6103 | 11025 | 140 |
2102866 | 2102866 | 2022-01-11 | Trinity | California | 6105 | 1063 | 19 |
2102867 | 2102867 | 2022-01-11 | Tulare | California | 6107 | 93873 | 1186 |
2102868 | 2102868 | 2022-01-11 | Tuolumne | California | 6109 | 9151 | 151 |
2102869 | 2102869 | 2022-01-11 | Ventura | California | 6111 | 131458 | 1217 |
2102870 | 2102870 | 2022-01-11 | Yolo | California | 6113 | 27711 | 270 |
2102871 | 2102871 | 2022-01-11 | Yuba | California | 6115 | 12627 | 101 |
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);