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-01-17 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
936850 | 936850 | 2021-01-17 | Alameda | California | 6001 | 66604 | 757 |
936851 | 936851 | 2021-01-17 | Alpine | California | 6003 | 71 | 0 |
936852 | 936852 | 2021-01-17 | Amador | California | 6005 | 2985 | 29 |
936853 | 936853 | 2021-01-17 | Butte | California | 6007 | 9359 | 121 |
936854 | 936854 | 2021-01-17 | Calaveras | California | 6009 | 1596 | 23 |
936855 | 936855 | 2021-01-17 | Colusa | California | 6011 | 1691 | 9 |
936856 | 936856 | 2021-01-17 | Contra Costa | California | 6013 | 52146 | 449 |
936857 | 936857 | 2021-01-17 | Del Norte | California | 6015 | 857 | 2 |
936858 | 936858 | 2021-01-17 | El Dorado | California | 6017 | 7575 | 44 |
936859 | 936859 | 2021-01-17 | Fresno | California | 6019 | 81294 | 932 |
936860 | 936860 | 2021-01-17 | Glenn | California | 6021 | 2177 | 19 |
936861 | 936861 | 2021-01-17 | Humboldt | California | 6023 | 2294 | 24 |
936862 | 936862 | 2021-01-17 | Imperial | California | 6025 | 25140 | 462 |
936863 | 936863 | 2021-01-17 | Inyo | California | 6027 | 845 | 29 |
936864 | 936864 | 2021-01-17 | Kern | California | 6029 | 85362 | 565 |
936865 | 936865 | 2021-01-17 | Kings | California | 6031 | 19254 | 133 |
936866 | 936866 | 2021-01-17 | Lake | California | 6033 | 2504 | 28 |
936867 | 936867 | 2021-01-17 | Lassen | California | 6035 | 5094 | 13 |
936868 | 936868 | 2021-01-17 | Los Angeles | California | 6037 | 1015063 | 13848 |
936869 | 936869 | 2021-01-17 | Madera | California | 6039 | 13193 | 130 |
936870 | 936870 | 2021-01-17 | Marin | California | 6041 | 11569 | 153 |
936871 | 936871 | 2021-01-17 | Mariposa | California | 6043 | 344 | 4 |
936872 | 936872 | 2021-01-17 | Mendocino | California | 6045 | 3114 | 32 |
936873 | 936873 | 2021-01-17 | Merced | California | 6047 | 23492 | 296 |
936874 | 936874 | 2021-01-17 | Modoc | California | 6049 | 378 | 3 |
936875 | 936875 | 2021-01-17 | Mono | California | 6051 | 1079 | 4 |
936876 | 936876 | 2021-01-17 | Monterey | California | 6053 | 35418 | 250 |
936877 | 936877 | 2021-01-17 | Napa | California | 6055 | 7357 | 39 |
936878 | 936878 | 2021-01-17 | Nevada | California | 6057 | 3144 | 73 |
936879 | 936879 | 2021-01-17 | Orange | California | 6059 | 223088 | 2367 |
936880 | 936880 | 2021-01-17 | Placer | California | 6061 | 16995 | 173 |
936881 | 936881 | 2021-01-17 | Plumas | California | 6063 | 502 | 5 |
936882 | 936882 | 2021-01-17 | Riverside | California | 6065 | 239412 | 2517 |
936883 | 936883 | 2021-01-17 | Sacramento | California | 6067 | 79121 | 1080 |
936884 | 936884 | 2021-01-17 | San Benito | California | 6069 | 4882 | 43 |
936885 | 936885 | 2021-01-17 | San Bernardino | California | 6071 | 251213 | 1560 |
936886 | 936886 | 2021-01-17 | San Diego | California | 6073 | 211850 | 2103 |
936887 | 936887 | 2021-01-17 | San Francisco | California | 6075 | 28856 | 254 |
936888 | 936888 | 2021-01-17 | San Joaquin | California | 6077 | 56642 | 748 |
936889 | 936889 | 2021-01-17 | San Luis Obispo | California | 6079 | 15466 | 128 |
936890 | 936890 | 2021-01-17 | San Mateo | California | 6081 | 31805 | 294 |
936891 | 936891 | 2021-01-17 | Santa Barbara | California | 6083 | 24481 | 231 |
936892 | 936892 | 2021-01-17 | Santa Clara | California | 6085 | 92625 | 1066 |
936893 | 936893 | 2021-01-17 | Santa Cruz | California | 6087 | 12026 | 113 |
936894 | 936894 | 2021-01-17 | Shasta | California | 6089 | 9594 | 117 |
936895 | 936895 | 2021-01-17 | Sierra | California | 6091 | 38 | 0 |
936896 | 936896 | 2021-01-17 | Siskiyou | California | 6093 | 1408 | 13 |
936897 | 936897 | 2021-01-17 | Solano | California | 6095 | 24737 | 105 |
936898 | 936898 | 2021-01-17 | Sonoma | California | 6097 | 23607 | 234 |
936899 | 936899 | 2021-01-17 | Stanislaus | California | 6099 | 46463 | 739 |
936900 | 936900 | 2021-01-17 | Sutter | California | 6101 | 7560 | 77 |
936901 | 936901 | 2021-01-17 | Tehama | California | 6103 | 3783 | 42 |
936902 | 936902 | 2021-01-17 | Trinity | California | 6105 | 262 | 4 |
936903 | 936903 | 2021-01-17 | Tulare | California | 6107 | 40655 | 501 |
936904 | 936904 | 2021-01-17 | Tuolumne | California | 6109 | 3304 | 38 |
936905 | 936905 | 2021-01-17 | Ventura | California | 6111 | 60368 | 412 |
936906 | 936906 | 2021-01-17 | Yolo | California | 6113 | 10406 | 131 |
936907 | 936907 | 2021-01-17 | Yuba | California | 6115 | 4818 | 27 |
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);