ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where deaths = 8, fips = 20073 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1229768 | 1229768 | 2021-04-17 | Greenwood | Kansas | 20073 | 589 | 8 |
1226520 | 1226520 | 2021-04-16 | Greenwood | Kansas | 20073 | 589 | 8 |
1223273 | 1223273 | 2021-04-15 | Greenwood | Kansas | 20073 | 589 | 8 |
1220025 | 1220025 | 2021-04-14 | Greenwood | Kansas | 20073 | 589 | 8 |
1216777 | 1216777 | 2021-04-13 | Greenwood | Kansas | 20073 | 589 | 8 |
1213530 | 1213530 | 2021-04-12 | Greenwood | Kansas | 20073 | 589 | 8 |
1210282 | 1210282 | 2021-04-11 | Greenwood | Kansas | 20073 | 589 | 8 |
1207033 | 1207033 | 2021-04-10 | Greenwood | Kansas | 20073 | 589 | 8 |
1203785 | 1203785 | 2021-04-09 | Greenwood | Kansas | 20073 | 589 | 8 |
1200537 | 1200537 | 2021-04-08 | Greenwood | Kansas | 20073 | 589 | 8 |
1197288 | 1197288 | 2021-04-07 | Greenwood | Kansas | 20073 | 589 | 8 |
1194040 | 1194040 | 2021-04-06 | Greenwood | Kansas | 20073 | 589 | 8 |
1190790 | 1190790 | 2021-04-05 | Greenwood | Kansas | 20073 | 589 | 8 |
1187543 | 1187543 | 2021-04-04 | Greenwood | Kansas | 20073 | 589 | 8 |
1184296 | 1184296 | 2021-04-03 | Greenwood | Kansas | 20073 | 589 | 8 |
1181049 | 1181049 | 2021-04-02 | Greenwood | Kansas | 20073 | 589 | 8 |
1177802 | 1177802 | 2021-04-01 | Greenwood | Kansas | 20073 | 589 | 8 |
1174555 | 1174555 | 2021-03-31 | Greenwood | Kansas | 20073 | 589 | 8 |
1171308 | 1171308 | 2021-03-30 | Greenwood | Kansas | 20073 | 589 | 8 |
1168060 | 1168060 | 2021-03-29 | Greenwood | Kansas | 20073 | 589 | 8 |
1164812 | 1164812 | 2021-03-28 | Greenwood | Kansas | 20073 | 589 | 8 |
1161564 | 1161564 | 2021-03-27 | Greenwood | Kansas | 20073 | 589 | 8 |
1158316 | 1158316 | 2021-03-26 | Greenwood | Kansas | 20073 | 589 | 8 |
1155069 | 1155069 | 2021-03-25 | Greenwood | Kansas | 20073 | 589 | 8 |
1151822 | 1151822 | 2021-03-24 | Greenwood | Kansas | 20073 | 589 | 8 |
1148575 | 1148575 | 2021-03-23 | Greenwood | Kansas | 20073 | 589 | 8 |
1145328 | 1145328 | 2021-03-22 | Greenwood | Kansas | 20073 | 589 | 8 |
1142081 | 1142081 | 2021-03-21 | Greenwood | Kansas | 20073 | 589 | 8 |
1138835 | 1138835 | 2021-03-20 | Greenwood | Kansas | 20073 | 589 | 8 |
1135589 | 1135589 | 2021-03-19 | Greenwood | Kansas | 20073 | 589 | 8 |
1132342 | 1132342 | 2021-03-18 | Greenwood | Kansas | 20073 | 589 | 8 |
1129094 | 1129094 | 2021-03-17 | Greenwood | Kansas | 20073 | 589 | 8 |
1125848 | 1125848 | 2021-03-16 | Greenwood | Kansas | 20073 | 589 | 8 |
1122602 | 1122602 | 2021-03-15 | Greenwood | Kansas | 20073 | 589 | 8 |
1119355 | 1119355 | 2021-03-14 | Greenwood | Kansas | 20073 | 589 | 8 |
1116108 | 1116108 | 2021-03-13 | Greenwood | Kansas | 20073 | 589 | 8 |
1112862 | 1112862 | 2021-03-12 | Greenwood | Kansas | 20073 | 589 | 8 |
1109616 | 1109616 | 2021-03-11 | Greenwood | Kansas | 20073 | 589 | 8 |
1106370 | 1106370 | 2021-03-10 | Greenwood | Kansas | 20073 | 589 | 8 |
1103124 | 1103124 | 2021-03-09 | Greenwood | Kansas | 20073 | 589 | 8 |
1099878 | 1099878 | 2021-03-08 | Greenwood | Kansas | 20073 | 589 | 8 |
1096630 | 1096630 | 2021-03-07 | Greenwood | Kansas | 20073 | 589 | 8 |
1093384 | 1093384 | 2021-03-06 | Greenwood | Kansas | 20073 | 589 | 8 |
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);