ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
744 rows where fips = 20077 and state = "Kansas" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
101880 | 101880 | 2020-04-30 | Harper | Kansas | 20077 | 1 | 0 |
104740 | 104740 | 2020-05-01 | Harper | Kansas | 20077 | 1 | 0 |
107605 | 107605 | 2020-05-02 | Harper | Kansas | 20077 | 1 | 0 |
110476 | 110476 | 2020-05-03 | Harper | Kansas | 20077 | 1 | 0 |
113353 | 113353 | 2020-05-04 | Harper | Kansas | 20077 | 1 | 0 |
116235 | 116235 | 2020-05-05 | Harper | Kansas | 20077 | 1 | 0 |
119196 | 119196 | 2020-05-06 | Harper | Kansas | 20077 | 1 | 0 |
122166 | 122166 | 2020-05-07 | Harper | Kansas | 20077 | 1 | 0 |
125148 | 125148 | 2020-05-08 | Harper | Kansas | 20077 | 1 | 0 |
128136 | 128136 | 2020-05-09 | Harper | Kansas | 20077 | 1 | 0 |
131126 | 131126 | 2020-05-10 | Harper | Kansas | 20077 | 1 | 0 |
134117 | 134117 | 2020-05-11 | Harper | Kansas | 20077 | 1 | 0 |
137107 | 137107 | 2020-05-12 | Harper | Kansas | 20077 | 1 | 0 |
140100 | 140100 | 2020-05-13 | Harper | Kansas | 20077 | 1 | 0 |
143096 | 143096 | 2020-05-14 | Harper | Kansas | 20077 | 1 | 0 |
146096 | 146096 | 2020-05-15 | Harper | Kansas | 20077 | 1 | 0 |
149100 | 149100 | 2020-05-16 | Harper | Kansas | 20077 | 1 | 0 |
152111 | 152111 | 2020-05-17 | Harper | Kansas | 20077 | 1 | 0 |
155123 | 155123 | 2020-05-18 | Harper | Kansas | 20077 | 1 | 0 |
158140 | 158140 | 2020-05-19 | Harper | Kansas | 20077 | 1 | 0 |
161165 | 161165 | 2020-05-20 | Harper | Kansas | 20077 | 1 | 0 |
164194 | 164194 | 2020-05-21 | Harper | Kansas | 20077 | 1 | 0 |
167227 | 167227 | 2020-05-22 | Harper | Kansas | 20077 | 1 | 0 |
170265 | 170265 | 2020-05-23 | Harper | Kansas | 20077 | 1 | 0 |
173306 | 173306 | 2020-05-24 | Harper | Kansas | 20077 | 1 | 0 |
176350 | 176350 | 2020-05-25 | Harper | Kansas | 20077 | 1 | 0 |
179394 | 179394 | 2020-05-26 | Harper | Kansas | 20077 | 1 | 0 |
182439 | 182439 | 2020-05-27 | Harper | Kansas | 20077 | 2 | 0 |
185493 | 185493 | 2020-05-28 | Harper | Kansas | 20077 | 2 | 0 |
188551 | 188551 | 2020-05-29 | Harper | Kansas | 20077 | 2 | 0 |
191615 | 191615 | 2020-05-30 | Harper | Kansas | 20077 | 2 | 0 |
194683 | 194683 | 2020-05-31 | Harper | Kansas | 20077 | 2 | 0 |
197753 | 197753 | 2020-06-01 | Harper | Kansas | 20077 | 2 | 0 |
200825 | 200825 | 2020-06-02 | Harper | Kansas | 20077 | 2 | 0 |
203901 | 203901 | 2020-06-03 | Harper | Kansas | 20077 | 2 | 0 |
206982 | 206982 | 2020-06-04 | Harper | Kansas | 20077 | 2 | 0 |
210063 | 210063 | 2020-06-05 | Harper | Kansas | 20077 | 2 | 0 |
213148 | 213148 | 2020-06-06 | Harper | Kansas | 20077 | 2 | 0 |
216235 | 216235 | 2020-06-07 | Harper | Kansas | 20077 | 2 | 0 |
219327 | 219327 | 2020-06-08 | Harper | Kansas | 20077 | 2 | 0 |
222422 | 222422 | 2020-06-09 | Harper | Kansas | 20077 | 2 | 0 |
225517 | 225517 | 2020-06-10 | Harper | Kansas | 20077 | 2 | 0 |
228619 | 228619 | 2020-06-11 | Harper | Kansas | 20077 | 2 | 0 |
231722 | 231722 | 2020-06-12 | Harper | Kansas | 20077 | 2 | 0 |
234828 | 234828 | 2020-06-13 | Harper | Kansas | 20077 | 2 | 0 |
237935 | 237935 | 2020-06-14 | Harper | Kansas | 20077 | 2 | 0 |
241044 | 241044 | 2020-06-15 | Harper | Kansas | 20077 | 2 | 0 |
244155 | 244155 | 2020-06-16 | Harper | Kansas | 20077 | 2 | 0 |
247268 | 247268 | 2020-06-17 | Harper | Kansas | 20077 | 2 | 0 |
250380 | 250380 | 2020-06-18 | Harper | Kansas | 20077 | 2 | 0 |
253495 | 253495 | 2020-06-19 | Harper | Kansas | 20077 | 2 | 0 |
256615 | 256615 | 2020-06-20 | Harper | Kansas | 20077 | 2 | 0 |
259741 | 259741 | 2020-06-21 | Harper | Kansas | 20077 | 2 | 0 |
262868 | 262868 | 2020-06-22 | Harper | Kansas | 20077 | 2 | 0 |
265996 | 265996 | 2020-06-23 | Harper | Kansas | 20077 | 2 | 0 |
269126 | 269126 | 2020-06-24 | Harper | Kansas | 20077 | 2 | 0 |
272263 | 272263 | 2020-06-25 | Harper | Kansas | 20077 | 2 | 0 |
275406 | 275406 | 2020-06-26 | Harper | Kansas | 20077 | 2 | 0 |
278554 | 278554 | 2020-06-27 | Harper | Kansas | 20077 | 2 | 0 |
281702 | 281702 | 2020-06-28 | Harper | Kansas | 20077 | 2 | 0 |
284847 | 284847 | 2020-06-29 | Harper | Kansas | 20077 | 2 | 0 |
287996 | 287996 | 2020-06-30 | Harper | Kansas | 20077 | 2 | 0 |
297458 | 297458 | 2020-07-03 | Harper | Kansas | 20077 | 2 | 0 |
300620 | 300620 | 2020-07-04 | Harper | Kansas | 20077 | 2 | 0 |
303784 | 303784 | 2020-07-05 | Harper | Kansas | 20077 | 2 | 0 |
306950 | 306950 | 2020-07-06 | Harper | Kansas | 20077 | 2 | 0 |
310118 | 310118 | 2020-07-07 | Harper | Kansas | 20077 | 2 | 0 |
313288 | 313288 | 2020-07-08 | Harper | Kansas | 20077 | 2 | 0 |
316462 | 316462 | 2020-07-09 | Harper | Kansas | 20077 | 2 | 0 |
319635 | 319635 | 2020-07-10 | Harper | Kansas | 20077 | 2 | 0 |
322814 | 322814 | 2020-07-11 | Harper | Kansas | 20077 | 2 | 0 |
325997 | 325997 | 2020-07-12 | Harper | Kansas | 20077 | 2 | 0 |
329183 | 329183 | 2020-07-13 | Harper | Kansas | 20077 | 2 | 0 |
332370 | 332370 | 2020-07-14 | Harper | Kansas | 20077 | 2 | 0 |
335563 | 335563 | 2020-07-15 | Harper | Kansas | 20077 | 2 | 0 |
338759 | 338759 | 2020-07-16 | Harper | Kansas | 20077 | 2 | 0 |
291146 | 291146 | 2020-07-01 | Harper | Kansas | 20077 | 4 | 0 |
294300 | 294300 | 2020-07-02 | Harper | Kansas | 20077 | 4 | 0 |
341955 | 341955 | 2020-07-17 | Harper | Kansas | 20077 | 4 | 0 |
345155 | 345155 | 2020-07-18 | Harper | Kansas | 20077 | 4 | 0 |
348356 | 348356 | 2020-07-19 | Harper | Kansas | 20077 | 4 | 0 |
351556 | 351556 | 2020-07-20 | Harper | Kansas | 20077 | 6 | 0 |
354758 | 354758 | 2020-07-21 | Harper | Kansas | 20077 | 6 | 0 |
357960 | 357960 | 2020-07-22 | Harper | Kansas | 20077 | 6 | 0 |
361165 | 361165 | 2020-07-23 | Harper | Kansas | 20077 | 6 | 0 |
364372 | 364372 | 2020-07-24 | Harper | Kansas | 20077 | 8 | 0 |
367579 | 367579 | 2020-07-25 | Harper | Kansas | 20077 | 8 | 0 |
370789 | 370789 | 2020-07-26 | Harper | Kansas | 20077 | 8 | 0 |
374001 | 374001 | 2020-07-27 | Harper | Kansas | 20077 | 8 | 0 |
377216 | 377216 | 2020-07-28 | Harper | Kansas | 20077 | 8 | 0 |
380433 | 380433 | 2020-07-29 | Harper | Kansas | 20077 | 8 | 0 |
383650 | 383650 | 2020-07-30 | Harper | Kansas | 20077 | 8 | 0 |
386868 | 386868 | 2020-07-31 | Harper | Kansas | 20077 | 8 | 0 |
390085 | 390085 | 2020-08-01 | Harper | Kansas | 20077 | 8 | 0 |
393302 | 393302 | 2020-08-02 | Harper | Kansas | 20077 | 8 | 0 |
396518 | 396518 | 2020-08-03 | Harper | Kansas | 20077 | 9 | 0 |
399733 | 399733 | 2020-08-04 | Harper | Kansas | 20077 | 9 | 0 |
402950 | 402950 | 2020-08-05 | Harper | Kansas | 20077 | 10 | 0 |
406168 | 406168 | 2020-08-06 | Harper | Kansas | 20077 | 10 | 0 |
409387 | 409387 | 2020-08-07 | Harper | Kansas | 20077 | 11 | 0 |
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);