ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,113 rows where county = "Wilson" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 4
- North Carolina 790
- Tennessee 786
- Texas 780
- Kansas 657
county 1
- Wilson · 3,013 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
370851 | 370851 | 2020-07-26 | Wilson | Kansas | 20205 | 7 | 0 |
374063 | 374063 | 2020-07-27 | Wilson | Kansas | 20205 | 9 | 0 |
377278 | 377278 | 2020-07-28 | Wilson | Kansas | 20205 | 9 | 0 |
380495 | 380495 | 2020-07-29 | Wilson | Kansas | 20205 | 8 | 0 |
383712 | 383712 | 2020-07-30 | Wilson | Kansas | 20205 | 8 | 0 |
386930 | 386930 | 2020-07-31 | Wilson | Kansas | 20205 | 10 | 0 |
390147 | 390147 | 2020-08-01 | Wilson | Kansas | 20205 | 10 | 0 |
393364 | 393364 | 2020-08-02 | Wilson | Kansas | 20205 | 10 | 0 |
396580 | 396580 | 2020-08-03 | Wilson | Kansas | 20205 | 10 | 0 |
399795 | 399795 | 2020-08-04 | Wilson | Kansas | 20205 | 10 | 0 |
403012 | 403012 | 2020-08-05 | Wilson | Kansas | 20205 | 9 | 0 |
406230 | 406230 | 2020-08-06 | Wilson | Kansas | 20205 | 9 | 0 |
409450 | 409450 | 2020-08-07 | Wilson | Kansas | 20205 | 9 | 0 |
412670 | 412670 | 2020-08-08 | Wilson | Kansas | 20205 | 9 | 0 |
415890 | 415890 | 2020-08-09 | Wilson | Kansas | 20205 | 9 | 0 |
419111 | 419111 | 2020-08-10 | Wilson | Kansas | 20205 | 10 | 0 |
422333 | 422333 | 2020-08-11 | Wilson | Kansas | 20205 | 10 | 0 |
425554 | 425554 | 2020-08-12 | Wilson | Kansas | 20205 | 11 | 0 |
428778 | 428778 | 2020-08-13 | Wilson | Kansas | 20205 | 11 | 0 |
432006 | 432006 | 2020-08-14 | Wilson | Kansas | 20205 | 14 | 0 |
435231 | 435231 | 2020-08-15 | Wilson | Kansas | 20205 | 14 | 0 |
438456 | 438456 | 2020-08-16 | Wilson | Kansas | 20205 | 14 | 0 |
441683 | 441683 | 2020-08-17 | Wilson | Kansas | 20205 | 15 | 0 |
444909 | 444909 | 2020-08-18 | Wilson | Kansas | 20205 | 15 | 0 |
448136 | 448136 | 2020-08-19 | Wilson | Kansas | 20205 | 15 | 0 |
451364 | 451364 | 2020-08-20 | Wilson | Kansas | 20205 | 15 | 0 |
454592 | 454592 | 2020-08-21 | Wilson | Kansas | 20205 | 16 | 0 |
457820 | 457820 | 2020-08-22 | Wilson | Kansas | 20205 | 16 | 0 |
461047 | 461047 | 2020-08-23 | Wilson | Kansas | 20205 | 16 | 0 |
464278 | 464278 | 2020-08-24 | Wilson | Kansas | 20205 | 17 | 0 |
467507 | 467507 | 2020-08-25 | Wilson | Kansas | 20205 | 17 | 0 |
470736 | 470736 | 2020-08-26 | Wilson | Kansas | 20205 | 20 | 0 |
473968 | 473968 | 2020-08-27 | Wilson | Kansas | 20205 | 20 | 0 |
477201 | 477201 | 2020-08-28 | Wilson | Kansas | 20205 | 21 | 0 |
480434 | 480434 | 2020-08-29 | Wilson | Kansas | 20205 | 21 | 0 |
483668 | 483668 | 2020-08-30 | Wilson | Kansas | 20205 | 21 | 0 |
486903 | 486903 | 2020-08-31 | Wilson | Kansas | 20205 | 23 | 0 |
490136 | 490136 | 2020-09-01 | Wilson | Kansas | 20205 | 23 | 0 |
493370 | 493370 | 2020-09-02 | Wilson | Kansas | 20205 | 30 | 0 |
496603 | 496603 | 2020-09-03 | Wilson | Kansas | 20205 | 30 | 0 |
499837 | 499837 | 2020-09-04 | Wilson | Kansas | 20205 | 30 | 0 |
503070 | 503070 | 2020-09-05 | Wilson | Kansas | 20205 | 30 | 0 |
506304 | 506304 | 2020-09-06 | Wilson | Kansas | 20205 | 30 | 0 |
509537 | 509537 | 2020-09-07 | Wilson | Kansas | 20205 | 31 | 0 |
512769 | 512769 | 2020-09-08 | Wilson | Kansas | 20205 | 31 | 0 |
516002 | 516002 | 2020-09-09 | Wilson | Kansas | 20205 | 32 | 0 |
519237 | 519237 | 2020-09-10 | Wilson | Kansas | 20205 | 32 | 0 |
522474 | 522474 | 2020-09-11 | Wilson | Kansas | 20205 | 52 | 0 |
525710 | 525710 | 2020-09-12 | Wilson | Kansas | 20205 | 52 | 0 |
528946 | 528946 | 2020-09-13 | Wilson | Kansas | 20205 | 52 | 1 |
532183 | 532183 | 2020-09-14 | Wilson | Kansas | 20205 | 56 | 1 |
535418 | 535418 | 2020-09-15 | Wilson | Kansas | 20205 | 56 | 1 |
538655 | 538655 | 2020-09-16 | Wilson | Kansas | 20205 | 58 | 1 |
541891 | 541891 | 2020-09-17 | Wilson | Kansas | 20205 | 58 | 1 |
545127 | 545127 | 2020-09-18 | Wilson | Kansas | 20205 | 58 | 2 |
548365 | 548365 | 2020-09-19 | Wilson | Kansas | 20205 | 58 | 2 |
551604 | 551604 | 2020-09-20 | Wilson | Kansas | 20205 | 58 | 2 |
554843 | 554843 | 2020-09-21 | Wilson | Kansas | 20205 | 59 | 2 |
558080 | 558080 | 2020-09-22 | Wilson | Kansas | 20205 | 59 | 2 |
561316 | 561316 | 2020-09-23 | Wilson | Kansas | 20205 | 59 | 2 |
564556 | 564556 | 2020-09-24 | Wilson | Kansas | 20205 | 59 | 2 |
567796 | 567796 | 2020-09-25 | Wilson | Kansas | 20205 | 60 | 2 |
571038 | 571038 | 2020-09-26 | Wilson | Kansas | 20205 | 60 | 2 |
574281 | 574281 | 2020-09-27 | Wilson | Kansas | 20205 | 60 | 2 |
577523 | 577523 | 2020-09-28 | Wilson | Kansas | 20205 | 62 | 2 |
580764 | 580764 | 2020-09-29 | Wilson | Kansas | 20205 | 62 | 2 |
584004 | 584004 | 2020-09-30 | Wilson | Kansas | 20205 | 64 | 2 |
587244 | 587244 | 2020-10-01 | Wilson | Kansas | 20205 | 64 | 2 |
590485 | 590485 | 2020-10-02 | Wilson | Kansas | 20205 | 65 | 2 |
593726 | 593726 | 2020-10-03 | Wilson | Kansas | 20205 | 65 | 2 |
596968 | 596968 | 2020-10-04 | Wilson | Kansas | 20205 | 65 | 2 |
600210 | 600210 | 2020-10-05 | Wilson | Kansas | 20205 | 69 | 2 |
603453 | 603453 | 2020-10-06 | Wilson | Kansas | 20205 | 69 | 2 |
606695 | 606695 | 2020-10-07 | Wilson | Kansas | 20205 | 76 | 2 |
609937 | 609937 | 2020-10-08 | Wilson | Kansas | 20205 | 76 | 2 |
613179 | 613179 | 2020-10-09 | Wilson | Kansas | 20205 | 85 | 2 |
616420 | 616420 | 2020-10-10 | Wilson | Kansas | 20205 | 85 | 2 |
619662 | 619662 | 2020-10-11 | Wilson | Kansas | 20205 | 85 | 2 |
622906 | 622906 | 2020-10-12 | Wilson | Kansas | 20205 | 85 | 2 |
626148 | 626148 | 2020-10-13 | Wilson | Kansas | 20205 | 85 | 2 |
629392 | 629392 | 2020-10-14 | Wilson | Kansas | 20205 | 101 | 2 |
632636 | 632636 | 2020-10-15 | Wilson | Kansas | 20205 | 101 | 2 |
635882 | 635882 | 2020-10-16 | Wilson | Kansas | 20205 | 104 | 2 |
639128 | 639128 | 2020-10-17 | Wilson | Kansas | 20205 | 104 | 2 |
642375 | 642375 | 2020-10-18 | Wilson | Kansas | 20205 | 104 | 2 |
645622 | 645622 | 2020-10-19 | Wilson | Kansas | 20205 | 106 | 2 |
648866 | 648866 | 2020-10-20 | Wilson | Kansas | 20205 | 106 | 2 |
652111 | 652111 | 2020-10-21 | Wilson | Kansas | 20205 | 111 | 2 |
655356 | 655356 | 2020-10-22 | Wilson | Kansas | 20205 | 111 | 2 |
658601 | 658601 | 2020-10-23 | Wilson | Kansas | 20205 | 113 | 2 |
661845 | 661845 | 2020-10-24 | Wilson | Kansas | 20205 | 113 | 2 |
665090 | 665090 | 2020-10-25 | Wilson | Kansas | 20205 | 113 | 2 |
668334 | 668334 | 2020-10-26 | Wilson | Kansas | 20205 | 114 | 2 |
671576 | 671576 | 2020-10-27 | Wilson | Kansas | 20205 | 114 | 2 |
674819 | 674819 | 2020-10-28 | Wilson | Kansas | 20205 | 118 | 3 |
678061 | 678061 | 2020-10-29 | Wilson | Kansas | 20205 | 118 | 3 |
681305 | 681305 | 2020-10-30 | Wilson | Kansas | 20205 | 124 | 3 |
684548 | 684548 | 2020-10-31 | Wilson | Kansas | 20205 | 124 | 3 |
687792 | 687792 | 2020-11-01 | Wilson | Kansas | 20205 | 124 | 3 |
691037 | 691037 | 2020-11-02 | Wilson | Kansas | 20205 | 127 | 3 |
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);