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 |
---|---|---|---|---|---|---|---|
635884 | 635884 | 2020-10-16 | Wyandotte | Kansas | 20209 | 7933 | 145 |
632638 | 632638 | 2020-10-15 | Wyandotte | Kansas | 20209 | 7845 | 145 |
629394 | 629394 | 2020-10-14 | Wyandotte | Kansas | 20209 | 7810 | 143 |
626150 | 626150 | 2020-10-13 | Wyandotte | Kansas | 20209 | 7721 | 134 |
622908 | 622908 | 2020-10-12 | Wyandotte | Kansas | 20209 | 7721 | 134 |
619664 | 619664 | 2020-10-11 | Wyandotte | Kansas | 20209 | 7594 | 134 |
616422 | 616422 | 2020-10-10 | Wyandotte | Kansas | 20209 | 7594 | 134 |
613181 | 613181 | 2020-10-09 | Wyandotte | Kansas | 20209 | 7594 | 134 |
609939 | 609939 | 2020-10-08 | Wyandotte | Kansas | 20209 | 7477 | 134 |
606697 | 606697 | 2020-10-07 | Wyandotte | Kansas | 20209 | 7477 | 134 |
603455 | 603455 | 2020-10-06 | Wyandotte | Kansas | 20209 | 7353 | 134 |
600212 | 600212 | 2020-10-05 | Wyandotte | Kansas | 20209 | 7353 | 134 |
596970 | 596970 | 2020-10-04 | Wyandotte | Kansas | 20209 | 7271 | 134 |
593728 | 593728 | 2020-10-03 | Wyandotte | Kansas | 20209 | 7271 | 134 |
590487 | 590487 | 2020-10-02 | Wyandotte | Kansas | 20209 | 7271 | 134 |
587246 | 587246 | 2020-10-01 | Wyandotte | Kansas | 20209 | 7163 | 134 |
584006 | 584006 | 2020-09-30 | Wyandotte | Kansas | 20209 | 7163 | 134 |
580766 | 580766 | 2020-09-29 | Wyandotte | Kansas | 20209 | 7095 | 134 |
577525 | 577525 | 2020-09-28 | Wyandotte | Kansas | 20209 | 7095 | 134 |
574283 | 574283 | 2020-09-27 | Wyandotte | Kansas | 20209 | 6996 | 134 |
571040 | 571040 | 2020-09-26 | Wyandotte | Kansas | 20209 | 6989 | 134 |
567798 | 567798 | 2020-09-25 | Wyandotte | Kansas | 20209 | 6989 | 134 |
564558 | 564558 | 2020-09-24 | Wyandotte | Kansas | 20209 | 6906 | 134 |
561318 | 561318 | 2020-09-23 | Wyandotte | Kansas | 20209 | 6906 | 134 |
558082 | 558082 | 2020-09-22 | Wyandotte | Kansas | 20209 | 6822 | 134 |
554845 | 554845 | 2020-09-21 | Wyandotte | Kansas | 20209 | 6822 | 133 |
551606 | 551606 | 2020-09-20 | Wyandotte | Kansas | 20209 | 6739 | 133 |
548367 | 548367 | 2020-09-19 | Wyandotte | Kansas | 20209 | 6739 | 133 |
545129 | 545129 | 2020-09-18 | Wyandotte | Kansas | 20209 | 6739 | 133 |
541893 | 541893 | 2020-09-17 | Wyandotte | Kansas | 20209 | 6652 | 133 |
538657 | 538657 | 2020-09-16 | Wyandotte | Kansas | 20209 | 6652 | 133 |
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 |
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);