ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 20111 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386885 | 386885 | 2020-07-31 | Lyon | Kansas | 20111 | 644 | 11 |
383667 | 383667 | 2020-07-30 | Lyon | Kansas | 20111 | 640 | 11 |
380450 | 380450 | 2020-07-29 | Lyon | Kansas | 20111 | 629 | 10 |
377233 | 377233 | 2020-07-28 | Lyon | Kansas | 20111 | 624 | 9 |
374018 | 374018 | 2020-07-27 | Lyon | Kansas | 20111 | 620 | 8 |
370806 | 370806 | 2020-07-26 | Lyon | Kansas | 20111 | 600 | 8 |
367596 | 367596 | 2020-07-25 | Lyon | Kansas | 20111 | 600 | 8 |
364389 | 364389 | 2020-07-24 | Lyon | Kansas | 20111 | 600 | 8 |
361182 | 361182 | 2020-07-23 | Lyon | Kansas | 20111 | 594 | 8 |
357977 | 357977 | 2020-07-22 | Lyon | Kansas | 20111 | 586 | 7 |
354775 | 354775 | 2020-07-21 | Lyon | Kansas | 20111 | 576 | 7 |
351573 | 351573 | 2020-07-20 | Lyon | Kansas | 20111 | 570 | 7 |
348373 | 348373 | 2020-07-19 | Lyon | Kansas | 20111 | 550 | 7 |
345172 | 345172 | 2020-07-18 | Lyon | Kansas | 20111 | 550 | 7 |
341972 | 341972 | 2020-07-17 | Lyon | Kansas | 20111 | 550 | 7 |
338776 | 338776 | 2020-07-16 | Lyon | Kansas | 20111 | 543 | 7 |
335580 | 335580 | 2020-07-15 | Lyon | Kansas | 20111 | 536 | 7 |
332387 | 332387 | 2020-07-14 | Lyon | Kansas | 20111 | 533 | 7 |
329200 | 329200 | 2020-07-13 | Lyon | Kansas | 20111 | 532 | 7 |
326014 | 326014 | 2020-07-12 | Lyon | Kansas | 20111 | 523 | 7 |
322831 | 322831 | 2020-07-11 | Lyon | Kansas | 20111 | 523 | 7 |
319652 | 319652 | 2020-07-10 | Lyon | Kansas | 20111 | 523 | 7 |
316478 | 316478 | 2020-07-09 | Lyon | Kansas | 20111 | 515 | 7 |
313304 | 313304 | 2020-07-08 | Lyon | Kansas | 20111 | 511 | 7 |
310134 | 310134 | 2020-07-07 | Lyon | Kansas | 20111 | 510 | 7 |
306966 | 306966 | 2020-07-06 | Lyon | Kansas | 20111 | 510 | 7 |
303799 | 303799 | 2020-07-05 | Lyon | Kansas | 20111 | 502 | 7 |
300635 | 300635 | 2020-07-04 | Lyon | Kansas | 20111 | 502 | 7 |
297473 | 297473 | 2020-07-03 | Lyon | Kansas | 20111 | 502 | 7 |
294315 | 294315 | 2020-07-02 | Lyon | Kansas | 20111 | 502 | 7 |
291161 | 291161 | 2020-07-01 | Lyon | Kansas | 20111 | 499 | 7 |
288011 | 288011 | 2020-06-30 | Lyon | Kansas | 20111 | 497 | 7 |
284862 | 284862 | 2020-06-29 | Lyon | Kansas | 20111 | 497 | 7 |
281717 | 281717 | 2020-06-28 | Lyon | Kansas | 20111 | 493 | 7 |
278569 | 278569 | 2020-06-27 | Lyon | Kansas | 20111 | 493 | 7 |
275421 | 275421 | 2020-06-26 | Lyon | Kansas | 20111 | 493 | 7 |
272278 | 272278 | 2020-06-25 | Lyon | Kansas | 20111 | 491 | 7 |
269141 | 269141 | 2020-06-24 | Lyon | Kansas | 20111 | 489 | 7 |
266010 | 266010 | 2020-06-23 | Lyon | Kansas | 20111 | 487 | 7 |
262882 | 262882 | 2020-06-22 | Lyon | Kansas | 20111 | 487 | 7 |
259755 | 259755 | 2020-06-21 | Lyon | Kansas | 20111 | 485 | 6 |
256629 | 256629 | 2020-06-20 | Lyon | Kansas | 20111 | 485 | 6 |
253509 | 253509 | 2020-06-19 | Lyon | Kansas | 20111 | 485 | 6 |
250394 | 250394 | 2020-06-18 | Lyon | Kansas | 20111 | 480 | 6 |
247282 | 247282 | 2020-06-17 | Lyon | Kansas | 20111 | 477 | 6 |
244169 | 244169 | 2020-06-16 | Lyon | Kansas | 20111 | 476 | 6 |
241058 | 241058 | 2020-06-15 | Lyon | Kansas | 20111 | 473 | 6 |
237949 | 237949 | 2020-06-14 | Lyon | Kansas | 20111 | 465 | 6 |
234842 | 234842 | 2020-06-13 | Lyon | Kansas | 20111 | 465 | 6 |
231736 | 231736 | 2020-06-12 | Lyon | Kansas | 20111 | 465 | 6 |
228633 | 228633 | 2020-06-11 | Lyon | Kansas | 20111 | 463 | 6 |
225531 | 225531 | 2020-06-10 | Lyon | Kansas | 20111 | 459 | 6 |
222436 | 222436 | 2020-06-09 | Lyon | Kansas | 20111 | 459 | 6 |
219341 | 219341 | 2020-06-08 | Lyon | Kansas | 20111 | 458 | 6 |
216249 | 216249 | 2020-06-07 | Lyon | Kansas | 20111 | 444 | 6 |
213162 | 213162 | 2020-06-06 | Lyon | Kansas | 20111 | 444 | 6 |
210077 | 210077 | 2020-06-05 | Lyon | Kansas | 20111 | 444 | 6 |
206996 | 206996 | 2020-06-04 | Lyon | Kansas | 20111 | 438 | 6 |
203915 | 203915 | 2020-06-03 | Lyon | Kansas | 20111 | 433 | 5 |
200839 | 200839 | 2020-06-02 | Lyon | Kansas | 20111 | 430 | 5 |
197767 | 197767 | 2020-06-01 | Lyon | Kansas | 20111 | 426 | 4 |
194697 | 194697 | 2020-05-31 | Lyon | Kansas | 20111 | 408 | 3 |
191629 | 191629 | 2020-05-30 | Lyon | Kansas | 20111 | 408 | 3 |
188565 | 188565 | 2020-05-29 | Lyon | Kansas | 20111 | 408 | 3 |
185507 | 185507 | 2020-05-28 | Lyon | Kansas | 20111 | 398 | 3 |
182453 | 182453 | 2020-05-27 | Lyon | Kansas | 20111 | 393 | 3 |
179408 | 179408 | 2020-05-26 | Lyon | Kansas | 20111 | 391 | 3 |
176364 | 176364 | 2020-05-25 | Lyon | Kansas | 20111 | 379 | 3 |
173320 | 173320 | 2020-05-24 | Lyon | Kansas | 20111 | 379 | 3 |
170279 | 170279 | 2020-05-23 | Lyon | Kansas | 20111 | 379 | 3 |
167241 | 167241 | 2020-05-22 | Lyon | Kansas | 20111 | 379 | 3 |
164206 | 164206 | 2020-05-21 | Lyon | Kansas | 20111 | 375 | 3 |
161177 | 161177 | 2020-05-20 | Lyon | Kansas | 20111 | 371 | 3 |
158152 | 158152 | 2020-05-19 | Lyon | Kansas | 20111 | 369 | 3 |
155135 | 155135 | 2020-05-18 | Lyon | Kansas | 20111 | 363 | 3 |
152123 | 152123 | 2020-05-17 | Lyon | Kansas | 20111 | 363 | 3 |
149112 | 149112 | 2020-05-16 | Lyon | Kansas | 20111 | 363 | 3 |
146108 | 146108 | 2020-05-15 | Lyon | Kansas | 20111 | 355 | 3 |
143108 | 143108 | 2020-05-14 | Lyon | Kansas | 20111 | 336 | 2 |
140112 | 140112 | 2020-05-13 | Lyon | Kansas | 20111 | 336 | 2 |
137119 | 137119 | 2020-05-12 | Lyon | Kansas | 20111 | 334 | 2 |
134129 | 134129 | 2020-05-11 | Lyon | Kansas | 20111 | 334 | 2 |
131138 | 131138 | 2020-05-10 | Lyon | Kansas | 20111 | 330 | 2 |
128148 | 128148 | 2020-05-09 | Lyon | Kansas | 20111 | 326 | 2 |
125160 | 125160 | 2020-05-08 | Lyon | Kansas | 20111 | 323 | 2 |
122178 | 122178 | 2020-05-07 | Lyon | Kansas | 20111 | 311 | 2 |
119208 | 119208 | 2020-05-06 | Lyon | Kansas | 20111 | 271 | 2 |
116247 | 116247 | 2020-05-05 | Lyon | Kansas | 20111 | 265 | 2 |
113365 | 113365 | 2020-05-04 | Lyon | Kansas | 20111 | 255 | 2 |
110488 | 110488 | 2020-05-03 | Lyon | Kansas | 20111 | 248 | 1 |
107617 | 107617 | 2020-05-02 | Lyon | Kansas | 20111 | 245 | 1 |
104752 | 104752 | 2020-05-01 | Lyon | Kansas | 20111 | 218 | 1 |
101892 | 101892 | 2020-04-30 | Lyon | Kansas | 20111 | 218 | 1 |
99040 | 99040 | 2020-04-29 | Lyon | Kansas | 20111 | 184 | 1 |
96194 | 96194 | 2020-04-28 | Lyon | Kansas | 20111 | 177 | 1 |
93362 | 93362 | 2020-04-27 | Lyon | Kansas | 20111 | 177 | 1 |
90541 | 90541 | 2020-04-26 | Lyon | Kansas | 20111 | 158 | 1 |
87725 | 87725 | 2020-04-25 | Lyon | Kansas | 20111 | 158 | 1 |
84916 | 84916 | 2020-04-24 | Lyon | Kansas | 20111 | 158 | 1 |
82114 | 82114 | 2020-04-23 | Lyon | Kansas | 20111 | 158 | 1 |
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);