ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where county = "Clay", deaths = 32 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2217391 | 2217391 | 2022-02-15 | Clay | Kansas | 20027 | 1945 | 32 |
2214140 | 2214140 | 2022-02-14 | Clay | Kansas | 20027 | 1945 | 32 |
2210888 | 2210888 | 2022-02-13 | Clay | Kansas | 20027 | 1937 | 32 |
2207635 | 2207635 | 2022-02-12 | Clay | Kansas | 20027 | 1937 | 32 |
2204382 | 2204382 | 2022-02-11 | Clay | Kansas | 20027 | 1937 | 32 |
2201129 | 2201129 | 2022-02-10 | Clay | Kansas | 20027 | 1937 | 32 |
2197875 | 2197875 | 2022-02-09 | Clay | Kansas | 20027 | 1937 | 32 |
2194621 | 2194621 | 2022-02-08 | Clay | Kansas | 20027 | 1919 | 32 |
2191367 | 2191367 | 2022-02-07 | Clay | Kansas | 20027 | 1919 | 32 |
2188114 | 2188114 | 2022-02-06 | Clay | Kansas | 20027 | 1911 | 32 |
2184861 | 2184861 | 2022-02-05 | Clay | Kansas | 20027 | 1911 | 32 |
2181609 | 2181609 | 2022-02-04 | Clay | Kansas | 20027 | 1911 | 32 |
2178358 | 2178358 | 2022-02-03 | Clay | Kansas | 20027 | 1897 | 32 |
2175105 | 2175105 | 2022-02-02 | Clay | Kansas | 20027 | 1897 | 32 |
2171852 | 2171852 | 2022-02-01 | Clay | Kansas | 20027 | 1869 | 32 |
2168599 | 2168599 | 2022-01-31 | Clay | Kansas | 20027 | 1869 | 32 |
2165344 | 2165344 | 2022-01-30 | Clay | Kansas | 20027 | 1856 | 32 |
2162089 | 2162089 | 2022-01-29 | Clay | Kansas | 20027 | 1856 | 32 |
2158834 | 2158834 | 2022-01-28 | Clay | Kansas | 20027 | 1856 | 32 |
2155580 | 2155580 | 2022-01-27 | Clay | Kansas | 20027 | 1833 | 32 |
2152327 | 2152327 | 2022-01-26 | Clay | Kansas | 20027 | 1833 | 32 |
2149075 | 2149075 | 2022-01-25 | Clay | Kansas | 20027 | 1790 | 32 |
2145823 | 2145823 | 2022-01-24 | Clay | Kansas | 20027 | 1790 | 32 |
2142568 | 2142568 | 2022-01-23 | Clay | Kansas | 20027 | 1754 | 32 |
2139313 | 2139313 | 2022-01-22 | Clay | Kansas | 20027 | 1754 | 32 |
2136057 | 2136057 | 2022-01-21 | Clay | Kansas | 20027 | 1754 | 32 |
2132805 | 2132805 | 2022-01-20 | Clay | Kansas | 20027 | 1709 | 32 |
2129552 | 2129552 | 2022-01-19 | Clay | Kansas | 20027 | 1709 | 32 |
2126298 | 2126298 | 2022-01-18 | Clay | Kansas | 20027 | 1620 | 32 |
2123046 | 2123046 | 2022-01-17 | Clay | Kansas | 20027 | 1620 | 32 |
2119794 | 2119794 | 2022-01-16 | Clay | Kansas | 20027 | 1620 | 32 |
2116542 | 2116542 | 2022-01-15 | Clay | Kansas | 20027 | 1620 | 32 |
2113291 | 2113291 | 2022-01-14 | Clay | Kansas | 20027 | 1620 | 32 |
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);