ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Wyandotte" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535420 | 535420 | 2020-09-15 | Wyandotte | Kansas | 20209 | 6578 | 129 |
532185 | 532185 | 2020-09-14 | Wyandotte | Kansas | 20209 | 6578 | 126 |
528948 | 528948 | 2020-09-13 | Wyandotte | Kansas | 20209 | 6492 | 124 |
525712 | 525712 | 2020-09-12 | Wyandotte | Kansas | 20209 | 6492 | 122 |
522476 | 522476 | 2020-09-11 | Wyandotte | Kansas | 20209 | 6492 | 120 |
519239 | 519239 | 2020-09-10 | Wyandotte | Kansas | 20209 | 6416 | 119 |
516004 | 516004 | 2020-09-09 | Wyandotte | Kansas | 20209 | 6416 | 119 |
512771 | 512771 | 2020-09-08 | Wyandotte | Kansas | 20209 | 6359 | 118 |
509539 | 509539 | 2020-09-07 | Wyandotte | Kansas | 20209 | 6359 | 118 |
506306 | 506306 | 2020-09-06 | Wyandotte | Kansas | 20209 | 6280 | 117 |
503072 | 503072 | 2020-09-05 | Wyandotte | Kansas | 20209 | 6280 | 117 |
499839 | 499839 | 2020-09-04 | Wyandotte | Kansas | 20209 | 6280 | 117 |
496605 | 496605 | 2020-09-03 | Wyandotte | Kansas | 20209 | 6180 | 117 |
493372 | 493372 | 2020-09-02 | Wyandotte | Kansas | 20209 | 6180 | 115 |
490138 | 490138 | 2020-09-01 | Wyandotte | Kansas | 20209 | 6108 | 114 |
486905 | 486905 | 2020-08-31 | Wyandotte | Kansas | 20209 | 6108 | 113 |
483670 | 483670 | 2020-08-30 | Wyandotte | Kansas | 20209 | 6022 | 113 |
480436 | 480436 | 2020-08-29 | Wyandotte | Kansas | 20209 | 6011 | 113 |
477203 | 477203 | 2020-08-28 | Wyandotte | Kansas | 20209 | 6011 | 113 |
473970 | 473970 | 2020-08-27 | Wyandotte | Kansas | 20209 | 5920 | 113 |
470738 | 470738 | 2020-08-26 | Wyandotte | Kansas | 20209 | 5920 | 113 |
467509 | 467509 | 2020-08-25 | Wyandotte | Kansas | 20209 | 5761 | 111 |
464280 | 464280 | 2020-08-24 | Wyandotte | Kansas | 20209 | 5761 | 111 |
461049 | 461049 | 2020-08-23 | Wyandotte | Kansas | 20209 | 5705 | 111 |
457822 | 457822 | 2020-08-22 | Wyandotte | Kansas | 20209 | 5661 | 111 |
454594 | 454594 | 2020-08-21 | Wyandotte | Kansas | 20209 | 5661 | 111 |
451366 | 451366 | 2020-08-20 | Wyandotte | Kansas | 20209 | 5556 | 109 |
448138 | 448138 | 2020-08-19 | Wyandotte | Kansas | 20209 | 5553 | 109 |
444911 | 444911 | 2020-08-18 | Wyandotte | Kansas | 20209 | 5453 | 108 |
441685 | 441685 | 2020-08-17 | Wyandotte | Kansas | 20209 | 5451 | 107 |
438458 | 438458 | 2020-08-16 | Wyandotte | Kansas | 20209 | 5392 | 107 |
435233 | 435233 | 2020-08-15 | Wyandotte | Kansas | 20209 | 5330 | 107 |
432008 | 432008 | 2020-08-14 | Wyandotte | Kansas | 20209 | 5329 | 107 |
428780 | 428780 | 2020-08-13 | Wyandotte | Kansas | 20209 | 5195 | 108 |
425556 | 425556 | 2020-08-12 | Wyandotte | Kansas | 20209 | 5182 | 102 |
422335 | 422335 | 2020-08-11 | Wyandotte | Kansas | 20209 | 5067 | 101 |
419113 | 419113 | 2020-08-10 | Wyandotte | Kansas | 20209 | 5063 | 99 |
415892 | 415892 | 2020-08-09 | Wyandotte | Kansas | 20209 | 5001 | 99 |
412672 | 412672 | 2020-08-08 | Wyandotte | Kansas | 20209 | 4969 | 99 |
409452 | 409452 | 2020-08-07 | Wyandotte | Kansas | 20209 | 4961 | 99 |
406232 | 406232 | 2020-08-06 | Wyandotte | Kansas | 20209 | 4843 | 98 |
403014 | 403014 | 2020-08-05 | Wyandotte | Kansas | 20209 | 4811 | 98 |
399797 | 399797 | 2020-08-04 | Wyandotte | Kansas | 20209 | 4722 | 96 |
396582 | 396582 | 2020-08-03 | Wyandotte | Kansas | 20209 | 4711 | 96 |
393366 | 393366 | 2020-08-02 | Wyandotte | Kansas | 20209 | 4596 | 95 |
390149 | 390149 | 2020-08-01 | Wyandotte | Kansas | 20209 | 4587 | 95 |
386932 | 386932 | 2020-07-31 | Wyandotte | Kansas | 20209 | 4587 | 95 |
383714 | 383714 | 2020-07-30 | Wyandotte | Kansas | 20209 | 4439 | 95 |
380497 | 380497 | 2020-07-29 | Wyandotte | Kansas | 20209 | 4439 | 93 |
377280 | 377280 | 2020-07-28 | Wyandotte | Kansas | 20209 | 4294 | 92 |
374065 | 374065 | 2020-07-27 | Wyandotte | Kansas | 20209 | 4287 | 92 |
370853 | 370853 | 2020-07-26 | Wyandotte | Kansas | 20209 | 4162 | 91 |
367643 | 367643 | 2020-07-25 | Wyandotte | Kansas | 20209 | 4153 | 91 |
364436 | 364436 | 2020-07-24 | Wyandotte | Kansas | 20209 | 4107 | 91 |
361229 | 361229 | 2020-07-23 | Wyandotte | Kansas | 20209 | 3990 | 90 |
358024 | 358024 | 2020-07-22 | Wyandotte | Kansas | 20209 | 3937 | 90 |
354821 | 354821 | 2020-07-21 | Wyandotte | Kansas | 20209 | 3844 | 89 |
351619 | 351619 | 2020-07-20 | Wyandotte | Kansas | 20209 | 3825 | 89 |
348419 | 348419 | 2020-07-19 | Wyandotte | Kansas | 20209 | 3748 | 89 |
345218 | 345218 | 2020-07-18 | Wyandotte | Kansas | 20209 | 3610 | 88 |
342018 | 342018 | 2020-07-17 | Wyandotte | Kansas | 20209 | 3603 | 88 |
338822 | 338822 | 2020-07-16 | Wyandotte | Kansas | 20209 | 3411 | 88 |
335626 | 335626 | 2020-07-15 | Wyandotte | Kansas | 20209 | 3391 | 88 |
332433 | 332433 | 2020-07-14 | Wyandotte | Kansas | 20209 | 3206 | 88 |
329246 | 329246 | 2020-07-13 | Wyandotte | Kansas | 20209 | 3169 | 88 |
326060 | 326060 | 2020-07-12 | Wyandotte | Kansas | 20209 | 3143 | 88 |
322877 | 322877 | 2020-07-11 | Wyandotte | Kansas | 20209 | 3032 | 87 |
319698 | 319698 | 2020-07-10 | Wyandotte | Kansas | 20209 | 2930 | 87 |
316523 | 316523 | 2020-07-09 | Wyandotte | Kansas | 20209 | 2883 | 87 |
313349 | 313349 | 2020-07-08 | Wyandotte | Kansas | 20209 | 2781 | 85 |
310179 | 310179 | 2020-07-07 | Wyandotte | Kansas | 20209 | 2728 | 85 |
307011 | 307011 | 2020-07-06 | Wyandotte | Kansas | 20209 | 2695 | 85 |
303844 | 303844 | 2020-07-05 | Wyandotte | Kansas | 20209 | 2664 | 85 |
300680 | 300680 | 2020-07-04 | Wyandotte | Kansas | 20209 | 2634 | 85 |
297518 | 297518 | 2020-07-03 | Wyandotte | Kansas | 20209 | 2553 | 84 |
294360 | 294360 | 2020-07-02 | Wyandotte | Kansas | 20209 | 2429 | 83 |
291206 | 291206 | 2020-07-01 | Wyandotte | Kansas | 20209 | 2420 | 83 |
288056 | 288056 | 2020-06-30 | Wyandotte | Kansas | 20209 | 2325 | 82 |
284907 | 284907 | 2020-06-29 | Wyandotte | Kansas | 20209 | 2303 | 82 |
281761 | 281761 | 2020-06-28 | Wyandotte | Kansas | 20209 | 2284 | 80 |
278613 | 278613 | 2020-06-27 | Wyandotte | Kansas | 20209 | 2176 | 80 |
275465 | 275465 | 2020-06-26 | Wyandotte | Kansas | 20209 | 2165 | 79 |
272322 | 272322 | 2020-06-25 | Wyandotte | Kansas | 20209 | 2099 | 78 |
269186 | 269186 | 2020-06-24 | Wyandotte | Kansas | 20209 | 2060 | 78 |
266053 | 266053 | 2020-06-23 | Wyandotte | Kansas | 20209 | 1982 | 78 |
262926 | 262926 | 2020-06-22 | Wyandotte | Kansas | 20209 | 1956 | 78 |
259797 | 259797 | 2020-06-21 | Wyandotte | Kansas | 20209 | 1907 | 78 |
256671 | 256671 | 2020-06-20 | Wyandotte | Kansas | 20209 | 1905 | 78 |
253551 | 253551 | 2020-06-19 | Wyandotte | Kansas | 20209 | 1890 | 77 |
250436 | 250436 | 2020-06-18 | Wyandotte | Kansas | 20209 | 1853 | 77 |
247324 | 247324 | 2020-06-17 | Wyandotte | Kansas | 20209 | 1812 | 76 |
244211 | 244211 | 2020-06-16 | Wyandotte | Kansas | 20209 | 1768 | 76 |
241100 | 241100 | 2020-06-15 | Wyandotte | Kansas | 20209 | 1750 | 76 |
237991 | 237991 | 2020-06-14 | Wyandotte | Kansas | 20209 | 1733 | 76 |
234884 | 234884 | 2020-06-13 | Wyandotte | Kansas | 20209 | 1711 | 76 |
231779 | 231779 | 2020-06-12 | Wyandotte | Kansas | 20209 | 1679 | 76 |
228675 | 228675 | 2020-06-11 | Wyandotte | Kansas | 20209 | 1646 | 76 |
225573 | 225573 | 2020-06-10 | Wyandotte | Kansas | 20209 | 1617 | 76 |
222477 | 222477 | 2020-06-09 | Wyandotte | Kansas | 20209 | 1587 | 76 |
219382 | 219382 | 2020-06-08 | Wyandotte | Kansas | 20209 | 1575 | 75 |
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);