ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Wilson" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
958758 | 958758 | 2021-01-23 | Wilson | Tennessee | 47189 | 14797 | 164 |
955512 | 955512 | 2021-01-22 | Wilson | Tennessee | 47189 | 14728 | 164 |
952267 | 952267 | 2021-01-21 | Wilson | Tennessee | 47189 | 14674 | 160 |
949022 | 949022 | 2021-01-20 | Wilson | Tennessee | 47189 | 14622 | 159 |
945776 | 945776 | 2021-01-19 | Wilson | Tennessee | 47189 | 14511 | 158 |
942529 | 942529 | 2021-01-18 | Wilson | Tennessee | 47189 | 14449 | 157 |
939284 | 939284 | 2021-01-17 | Wilson | Tennessee | 47189 | 14405 | 155 |
936039 | 936039 | 2021-01-16 | Wilson | Tennessee | 47189 | 14327 | 154 |
932794 | 932794 | 2021-01-15 | Wilson | Tennessee | 47189 | 14242 | 154 |
929549 | 929549 | 2021-01-14 | Wilson | Tennessee | 47189 | 14171 | 152 |
926304 | 926304 | 2021-01-13 | Wilson | Tennessee | 47189 | 14048 | 149 |
923058 | 923058 | 2021-01-12 | Wilson | Tennessee | 47189 | 13980 | 147 |
919813 | 919813 | 2021-01-11 | Wilson | Tennessee | 47189 | 13903 | 142 |
916568 | 916568 | 2021-01-10 | Wilson | Tennessee | 47189 | 13819 | 141 |
913323 | 913323 | 2021-01-09 | Wilson | Tennessee | 47189 | 13674 | 141 |
910078 | 910078 | 2021-01-08 | Wilson | Tennessee | 47189 | 13569 | 140 |
906833 | 906833 | 2021-01-07 | Wilson | Tennessee | 47189 | 13470 | 138 |
903587 | 903587 | 2021-01-06 | Wilson | Tennessee | 47189 | 13283 | 137 |
900342 | 900342 | 2021-01-05 | Wilson | Tennessee | 47189 | 13118 | 135 |
897097 | 897097 | 2021-01-04 | Wilson | Tennessee | 47189 | 13011 | 133 |
893851 | 893851 | 2021-01-03 | Wilson | Tennessee | 47189 | 12913 | 130 |
890605 | 890605 | 2021-01-02 | Wilson | Tennessee | 47189 | 12828 | 128 |
887358 | 887358 | 2021-01-01 | Wilson | Tennessee | 47189 | 12476 | 128 |
884113 | 884113 | 2020-12-31 | Wilson | Tennessee | 47189 | 12476 | 128 |
880868 | 880868 | 2020-12-30 | Wilson | Tennessee | 47189 | 12325 | 125 |
877623 | 877623 | 2020-12-29 | Wilson | Tennessee | 47189 | 12178 | 123 |
874378 | 874378 | 2020-12-28 | Wilson | Tennessee | 47189 | 12038 | 122 |
871133 | 871133 | 2020-12-27 | Wilson | Tennessee | 47189 | 11965 | 121 |
867888 | 867888 | 2020-12-26 | Wilson | Tennessee | 47189 | 11922 | 118 |
864643 | 864643 | 2020-12-25 | Wilson | Tennessee | 47189 | 11814 | 118 |
861398 | 861398 | 2020-12-24 | Wilson | Tennessee | 47189 | 11595 | 118 |
858153 | 858153 | 2020-12-23 | Wilson | Tennessee | 47189 | 11495 | 118 |
854908 | 854908 | 2020-12-22 | Wilson | Tennessee | 47189 | 11339 | 115 |
851663 | 851663 | 2020-12-21 | Wilson | Tennessee | 47189 | 11229 | 115 |
848418 | 848418 | 2020-12-20 | Wilson | Tennessee | 47189 | 10989 | 112 |
845173 | 845173 | 2020-12-19 | Wilson | Tennessee | 47189 | 10770 | 109 |
841927 | 841927 | 2020-12-18 | Wilson | Tennessee | 47189 | 10597 | 107 |
838682 | 838682 | 2020-12-17 | Wilson | Tennessee | 47189 | 10397 | 106 |
835436 | 835436 | 2020-12-16 | Wilson | Tennessee | 47189 | 10204 | 103 |
832190 | 832190 | 2020-12-15 | Wilson | Tennessee | 47189 | 9929 | 103 |
828943 | 828943 | 2020-12-14 | Wilson | Tennessee | 47189 | 9772 | 101 |
825697 | 825697 | 2020-12-13 | Wilson | Tennessee | 47189 | 9512 | 100 |
822450 | 822450 | 2020-12-12 | Wilson | Tennessee | 47189 | 9283 | 99 |
819204 | 819204 | 2020-12-11 | Wilson | Tennessee | 47189 | 9156 | 99 |
815958 | 815958 | 2020-12-10 | Wilson | Tennessee | 47189 | 8966 | 99 |
812712 | 812712 | 2020-12-09 | Wilson | Tennessee | 47189 | 8870 | 94 |
809468 | 809468 | 2020-12-08 | Wilson | Tennessee | 47189 | 8672 | 94 |
806223 | 806223 | 2020-12-07 | Wilson | Tennessee | 47189 | 8551 | 91 |
802978 | 802978 | 2020-12-06 | Wilson | Tennessee | 47189 | 8319 | 89 |
799733 | 799733 | 2020-12-05 | Wilson | Tennessee | 47189 | 8237 | 88 |
796488 | 796488 | 2020-12-04 | Wilson | Tennessee | 47189 | 8127 | 88 |
793243 | 793243 | 2020-12-03 | Wilson | Tennessee | 47189 | 8016 | 84 |
789998 | 789998 | 2020-12-02 | Wilson | Tennessee | 47189 | 7943 | 83 |
786753 | 786753 | 2020-12-01 | Wilson | Tennessee | 47189 | 7883 | 82 |
783509 | 783509 | 2020-11-30 | Wilson | Tennessee | 47189 | 7779 | 80 |
780264 | 780264 | 2020-11-29 | Wilson | Tennessee | 47189 | 7526 | 78 |
777018 | 777018 | 2020-11-28 | Wilson | Tennessee | 47189 | 7481 | 78 |
773773 | 773773 | 2020-11-27 | Wilson | Tennessee | 47189 | 7316 | 78 |
770528 | 770528 | 2020-11-26 | Wilson | Tennessee | 47189 | 7200 | 78 |
767282 | 767282 | 2020-11-25 | Wilson | Tennessee | 47189 | 7084 | 77 |
764037 | 764037 | 2020-11-24 | Wilson | Tennessee | 47189 | 7050 | 76 |
760792 | 760792 | 2020-11-23 | Wilson | Tennessee | 47189 | 7055 | 74 |
757547 | 757547 | 2020-11-22 | Wilson | Tennessee | 47189 | 6924 | 74 |
754300 | 754300 | 2020-11-21 | Wilson | Tennessee | 47189 | 6794 | 74 |
751054 | 751054 | 2020-11-20 | Wilson | Tennessee | 47189 | 6681 | 73 |
747808 | 747808 | 2020-11-19 | Wilson | Tennessee | 47189 | 6581 | 71 |
744562 | 744562 | 2020-11-18 | Wilson | Tennessee | 47189 | 6476 | 70 |
741315 | 741315 | 2020-11-17 | Wilson | Tennessee | 47189 | 6377 | 69 |
738069 | 738069 | 2020-11-16 | Wilson | Tennessee | 47189 | 6344 | 69 |
734825 | 734825 | 2020-11-15 | Wilson | Tennessee | 47189 | 6168 | 69 |
731579 | 731579 | 2020-11-14 | Wilson | Tennessee | 47189 | 6057 | 68 |
728334 | 728334 | 2020-11-13 | Wilson | Tennessee | 47189 | 5906 | 68 |
725091 | 725091 | 2020-11-12 | Wilson | Tennessee | 47189 | 5832 | 68 |
721848 | 721848 | 2020-11-11 | Wilson | Tennessee | 47189 | 5751 | 67 |
718605 | 718605 | 2020-11-10 | Wilson | Tennessee | 47189 | 5664 | 66 |
715362 | 715362 | 2020-11-09 | Wilson | Tennessee | 47189 | 5607 | 67 |
712118 | 712118 | 2020-11-08 | Wilson | Tennessee | 47189 | 5471 | 67 |
708874 | 708874 | 2020-11-07 | Wilson | Tennessee | 47189 | 5374 | 67 |
705630 | 705630 | 2020-11-06 | Wilson | Tennessee | 47189 | 5237 | 66 |
702387 | 702387 | 2020-11-05 | Wilson | Tennessee | 47189 | 5214 | 65 |
699144 | 699144 | 2020-11-04 | Wilson | Tennessee | 47189 | 5166 | 65 |
695900 | 695900 | 2020-11-03 | Wilson | Tennessee | 47189 | 5114 | 66 |
692658 | 692658 | 2020-11-02 | Wilson | Tennessee | 47189 | 5065 | 65 |
689414 | 689414 | 2020-11-01 | Wilson | Tennessee | 47189 | 4999 | 64 |
686169 | 686169 | 2020-10-31 | Wilson | Tennessee | 47189 | 4959 | 64 |
682926 | 682926 | 2020-10-30 | Wilson | Tennessee | 47189 | 4950 | 64 |
679683 | 679683 | 2020-10-29 | Wilson | Tennessee | 47189 | 4920 | 63 |
676440 | 676440 | 2020-10-28 | Wilson | Tennessee | 47189 | 4847 | 60 |
673197 | 673197 | 2020-10-27 | Wilson | Tennessee | 47189 | 4785 | 60 |
669955 | 669955 | 2020-10-26 | Wilson | Tennessee | 47189 | 4731 | 59 |
666712 | 666712 | 2020-10-25 | Wilson | Tennessee | 47189 | 4690 | 59 |
663467 | 663467 | 2020-10-24 | Wilson | Tennessee | 47189 | 4629 | 56 |
660223 | 660223 | 2020-10-23 | Wilson | Tennessee | 47189 | 4577 | 56 |
656979 | 656979 | 2020-10-22 | Wilson | Tennessee | 47189 | 4514 | 55 |
653734 | 653734 | 2020-10-21 | Wilson | Tennessee | 47189 | 4455 | 53 |
650489 | 650489 | 2020-10-20 | Wilson | Tennessee | 47189 | 4431 | 53 |
647245 | 647245 | 2020-10-19 | Wilson | Tennessee | 47189 | 4402 | 53 |
643999 | 643999 | 2020-10-18 | Wilson | Tennessee | 47189 | 4318 | 53 |
640751 | 640751 | 2020-10-17 | Wilson | Tennessee | 47189 | 4254 | 53 |
637504 | 637504 | 2020-10-16 | Wilson | Tennessee | 47189 | 4184 | 52 |
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);