ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Finney" and state = "Kansas" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
18298 | 18298 | 2020-03-29 | Finney | Kansas | 20055 | 1 | 0 |
20311 | 20311 | 2020-03-30 | Finney | Kansas | 20055 | 1 | 0 |
22409 | 22409 | 2020-03-31 | Finney | Kansas | 20055 | 1 | 0 |
24584 | 24584 | 2020-04-01 | Finney | Kansas | 20055 | 1 | 0 |
26828 | 26828 | 2020-04-02 | Finney | Kansas | 20055 | 3 | 0 |
29142 | 29142 | 2020-04-03 | Finney | Kansas | 20055 | 4 | 0 |
31514 | 31514 | 2020-04-04 | Finney | Kansas | 20055 | 9 | 0 |
33927 | 33927 | 2020-04-05 | Finney | Kansas | 20055 | 10 | 0 |
36384 | 36384 | 2020-04-06 | Finney | Kansas | 20055 | 10 | 0 |
38886 | 38886 | 2020-04-07 | Finney | Kansas | 20055 | 10 | 0 |
41433 | 41433 | 2020-04-08 | Finney | Kansas | 20055 | 11 | 0 |
44009 | 44009 | 2020-04-09 | Finney | Kansas | 20055 | 12 | 0 |
46616 | 46616 | 2020-04-10 | Finney | Kansas | 20055 | 12 | 0 |
49251 | 49251 | 2020-04-11 | Finney | Kansas | 20055 | 15 | 0 |
51915 | 51915 | 2020-04-12 | Finney | Kansas | 20055 | 15 | 0 |
54597 | 54597 | 2020-04-13 | Finney | Kansas | 20055 | 16 | 0 |
57291 | 57291 | 2020-04-14 | Finney | Kansas | 20055 | 17 | 1 |
59999 | 59999 | 2020-04-15 | Finney | Kansas | 20055 | 17 | 1 |
62720 | 62720 | 2020-04-16 | Finney | Kansas | 20055 | 19 | 1 |
65456 | 65456 | 2020-04-17 | Finney | Kansas | 20055 | 25 | 1 |
68205 | 68205 | 2020-04-18 | Finney | Kansas | 20055 | 35 | 1 |
70966 | 70966 | 2020-04-19 | Finney | Kansas | 20055 | 35 | 1 |
73737 | 73737 | 2020-04-20 | Finney | Kansas | 20055 | 41 | 1 |
76517 | 76517 | 2020-04-21 | Finney | Kansas | 20055 | 41 | 1 |
79302 | 79302 | 2020-04-22 | Finney | Kansas | 20055 | 56 | 1 |
82095 | 82095 | 2020-04-23 | Finney | Kansas | 20055 | 87 | 1 |
84896 | 84896 | 2020-04-24 | Finney | Kansas | 20055 | 107 | 1 |
87705 | 87705 | 2020-04-25 | Finney | Kansas | 20055 | 139 | 1 |
90521 | 90521 | 2020-04-26 | Finney | Kansas | 20055 | 140 | 1 |
93342 | 93342 | 2020-04-27 | Finney | Kansas | 20055 | 202 | 1 |
96174 | 96174 | 2020-04-28 | Finney | Kansas | 20055 | 248 | 1 |
99020 | 99020 | 2020-04-29 | Finney | Kansas | 20055 | 270 | 1 |
101871 | 101871 | 2020-04-30 | Finney | Kansas | 20055 | 317 | 1 |
104731 | 104731 | 2020-05-01 | Finney | Kansas | 20055 | 386 | 1 |
107596 | 107596 | 2020-05-02 | Finney | Kansas | 20055 | 503 | 3 |
110467 | 110467 | 2020-05-03 | Finney | Kansas | 20055 | 550 | 3 |
113344 | 113344 | 2020-05-04 | Finney | Kansas | 20055 | 586 | 3 |
116226 | 116226 | 2020-05-05 | Finney | Kansas | 20055 | 630 | 3 |
119187 | 119187 | 2020-05-06 | Finney | Kansas | 20055 | 630 | 3 |
122157 | 122157 | 2020-05-07 | Finney | Kansas | 20055 | 630 | 3 |
125139 | 125139 | 2020-05-08 | Finney | Kansas | 20055 | 861 | 4 |
128127 | 128127 | 2020-05-09 | Finney | Kansas | 20055 | 902 | 4 |
131117 | 131117 | 2020-05-10 | Finney | Kansas | 20055 | 902 | 4 |
134108 | 134108 | 2020-05-11 | Finney | Kansas | 20055 | 905 | 4 |
137098 | 137098 | 2020-05-12 | Finney | Kansas | 20055 | 1031 | 4 |
140091 | 140091 | 2020-05-13 | Finney | Kansas | 20055 | 1031 | 4 |
143087 | 143087 | 2020-05-14 | Finney | Kansas | 20055 | 1101 | 5 |
146087 | 146087 | 2020-05-15 | Finney | Kansas | 20055 | 1234 | 5 |
149091 | 149091 | 2020-05-16 | Finney | Kansas | 20055 | 1234 | 5 |
152102 | 152102 | 2020-05-17 | Finney | Kansas | 20055 | 1234 | 5 |
155114 | 155114 | 2020-05-18 | Finney | Kansas | 20055 | 1316 | 6 |
158131 | 158131 | 2020-05-19 | Finney | Kansas | 20055 | 1331 | 6 |
161156 | 161156 | 2020-05-20 | Finney | Kansas | 20055 | 1363 | 6 |
164185 | 164185 | 2020-05-21 | Finney | Kansas | 20055 | 1398 | 6 |
167218 | 167218 | 2020-05-22 | Finney | Kansas | 20055 | 1418 | 6 |
170256 | 170256 | 2020-05-23 | Finney | Kansas | 20055 | 1418 | 6 |
173297 | 173297 | 2020-05-24 | Finney | Kansas | 20055 | 1418 | 6 |
176341 | 176341 | 2020-05-25 | Finney | Kansas | 20055 | 1418 | 6 |
179385 | 179385 | 2020-05-26 | Finney | Kansas | 20055 | 1451 | 8 |
182430 | 182430 | 2020-05-27 | Finney | Kansas | 20055 | 1458 | 8 |
185484 | 185484 | 2020-05-28 | Finney | Kansas | 20055 | 1466 | 8 |
188542 | 188542 | 2020-05-29 | Finney | Kansas | 20055 | 1481 | 8 |
191606 | 191606 | 2020-05-30 | Finney | Kansas | 20055 | 1481 | 8 |
194674 | 194674 | 2020-05-31 | Finney | Kansas | 20055 | 1481 | 8 |
197744 | 197744 | 2020-06-01 | Finney | Kansas | 20055 | 1502 | 8 |
200816 | 200816 | 2020-06-02 | Finney | Kansas | 20055 | 1504 | 10 |
203892 | 203892 | 2020-06-03 | Finney | Kansas | 20055 | 1518 | 10 |
206973 | 206973 | 2020-06-04 | Finney | Kansas | 20055 | 1522 | 10 |
210054 | 210054 | 2020-06-05 | Finney | Kansas | 20055 | 1526 | 10 |
213139 | 213139 | 2020-06-06 | Finney | Kansas | 20055 | 1526 | 10 |
216226 | 216226 | 2020-06-07 | Finney | Kansas | 20055 | 1526 | 10 |
219318 | 219318 | 2020-06-08 | Finney | Kansas | 20055 | 1536 | 10 |
222413 | 222413 | 2020-06-09 | Finney | Kansas | 20055 | 1536 | 10 |
225508 | 225508 | 2020-06-10 | Finney | Kansas | 20055 | 1537 | 10 |
228610 | 228610 | 2020-06-11 | Finney | Kansas | 20055 | 1537 | 10 |
231713 | 231713 | 2020-06-12 | Finney | Kansas | 20055 | 1538 | 10 |
234819 | 234819 | 2020-06-13 | Finney | Kansas | 20055 | 1538 | 10 |
237926 | 237926 | 2020-06-14 | Finney | Kansas | 20055 | 1538 | 10 |
241035 | 241035 | 2020-06-15 | Finney | Kansas | 20055 | 1540 | 10 |
244146 | 244146 | 2020-06-16 | Finney | Kansas | 20055 | 1543 | 10 |
247259 | 247259 | 2020-06-17 | Finney | Kansas | 20055 | 1545 | 10 |
250371 | 250371 | 2020-06-18 | Finney | Kansas | 20055 | 1545 | 10 |
253486 | 253486 | 2020-06-19 | Finney | Kansas | 20055 | 1546 | 10 |
256606 | 256606 | 2020-06-20 | Finney | Kansas | 20055 | 1546 | 10 |
259732 | 259732 | 2020-06-21 | Finney | Kansas | 20055 | 1546 | 10 |
262859 | 262859 | 2020-06-22 | Finney | Kansas | 20055 | 1554 | 10 |
265987 | 265987 | 2020-06-23 | Finney | Kansas | 20055 | 1558 | 10 |
269117 | 269117 | 2020-06-24 | Finney | Kansas | 20055 | 1558 | 10 |
272254 | 272254 | 2020-06-25 | Finney | Kansas | 20055 | 1562 | 10 |
275397 | 275397 | 2020-06-26 | Finney | Kansas | 20055 | 1563 | 10 |
278545 | 278545 | 2020-06-27 | Finney | Kansas | 20055 | 1563 | 10 |
281693 | 281693 | 2020-06-28 | Finney | Kansas | 20055 | 1563 | 10 |
284838 | 284838 | 2020-06-29 | Finney | Kansas | 20055 | 1563 | 10 |
287987 | 287987 | 2020-06-30 | Finney | Kansas | 20055 | 1570 | 10 |
291137 | 291137 | 2020-07-01 | Finney | Kansas | 20055 | 1574 | 10 |
294291 | 294291 | 2020-07-02 | Finney | Kansas | 20055 | 1575 | 10 |
297449 | 297449 | 2020-07-03 | Finney | Kansas | 20055 | 1575 | 10 |
300611 | 300611 | 2020-07-04 | Finney | Kansas | 20055 | 1575 | 10 |
303775 | 303775 | 2020-07-05 | Finney | Kansas | 20055 | 1575 | 10 |
306940 | 306940 | 2020-07-06 | Finney | Kansas | 20055 | 1584 | 10 |
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);