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 |
---|---|---|---|---|---|---|---|
1091828 | 1091828 | 2021-03-05 | Wilson | Tennessee | 47189 | 16553 | 211 |
1088582 | 1088582 | 2021-03-04 | Wilson | Tennessee | 47189 | 16510 | 211 |
1085337 | 1085337 | 2021-03-03 | Wilson | Tennessee | 47189 | 16479 | 210 |
1082091 | 1082091 | 2021-03-02 | Wilson | Tennessee | 47189 | 16423 | 210 |
1078845 | 1078845 | 2021-03-01 | Wilson | Tennessee | 47189 | 16399 | 210 |
1075600 | 1075600 | 2021-02-28 | Wilson | Tennessee | 47189 | 16371 | 210 |
1072354 | 1072354 | 2021-02-27 | Wilson | Tennessee | 47189 | 16323 | 210 |
1069108 | 1069108 | 2021-02-26 | Wilson | Tennessee | 47189 | 16293 | 212 |
1065863 | 1065863 | 2021-02-25 | Wilson | Tennessee | 47189 | 16258 | 211 |
1062618 | 1062618 | 2021-02-24 | Wilson | Tennessee | 47189 | 16194 | 209 |
1059373 | 1059373 | 2021-02-23 | Wilson | Tennessee | 47189 | 16157 | 208 |
1056127 | 1056127 | 2021-02-22 | Wilson | Tennessee | 47189 | 16114 | 208 |
1052881 | 1052881 | 2021-02-21 | Wilson | Tennessee | 47189 | 16090 | 206 |
1049634 | 1049634 | 2021-02-20 | Wilson | Tennessee | 47189 | 16063 | 206 |
1046387 | 1046387 | 2021-02-19 | Wilson | Tennessee | 47189 | 16029 | 206 |
1043142 | 1043142 | 2021-02-18 | Wilson | Tennessee | 47189 | 15991 | 206 |
1039897 | 1039897 | 2021-02-17 | Wilson | Tennessee | 47189 | 15974 | 205 |
1036652 | 1036652 | 2021-02-16 | Wilson | Tennessee | 47189 | 15957 | 205 |
1033407 | 1033407 | 2021-02-15 | Wilson | Tennessee | 47189 | 15948 | 205 |
1030161 | 1030161 | 2021-02-14 | Wilson | Tennessee | 47189 | 15921 | 205 |
1026914 | 1026914 | 2021-02-13 | Wilson | Tennessee | 47189 | 15884 | 205 |
1023669 | 1023669 | 2021-02-12 | Wilson | Tennessee | 47189 | 15841 | 205 |
1020424 | 1020424 | 2021-02-11 | Wilson | Tennessee | 47189 | 15792 | 204 |
1017179 | 1017179 | 2021-02-10 | Wilson | Tennessee | 47189 | 15731 | 201 |
1013934 | 1013934 | 2021-02-09 | Wilson | Tennessee | 47189 | 15640 | 194 |
1010689 | 1010689 | 2021-02-08 | Wilson | Tennessee | 47189 | 15617 | 193 |
1007443 | 1007443 | 2021-02-07 | Wilson | Tennessee | 47189 | 15602 | 191 |
1004197 | 1004197 | 2021-02-06 | Wilson | Tennessee | 47189 | 15558 | 191 |
1000951 | 1000951 | 2021-02-05 | Wilson | Tennessee | 47189 | 15477 | 191 |
997705 | 997705 | 2021-02-04 | Wilson | Tennessee | 47189 | 15417 | 189 |
994459 | 994459 | 2021-02-03 | Wilson | Tennessee | 47189 | 15354 | 186 |
991213 | 991213 | 2021-02-02 | Wilson | Tennessee | 47189 | 15314 | 185 |
987967 | 987967 | 2021-02-01 | Wilson | Tennessee | 47189 | 15266 | 182 |
984720 | 984720 | 2021-01-31 | Wilson | Tennessee | 47189 | 15223 | 181 |
981473 | 981473 | 2021-01-30 | Wilson | Tennessee | 47189 | 15153 | 179 |
978227 | 978227 | 2021-01-29 | Wilson | Tennessee | 47189 | 15123 | 178 |
974982 | 974982 | 2021-01-28 | Wilson | Tennessee | 47189 | 15046 | 177 |
971737 | 971737 | 2021-01-27 | Wilson | Tennessee | 47189 | 14984 | 175 |
968492 | 968492 | 2021-01-26 | Wilson | Tennessee | 47189 | 14907 | 170 |
965248 | 965248 | 2021-01-25 | Wilson | Tennessee | 47189 | 14878 | 167 |
962003 | 962003 | 2021-01-24 | Wilson | Tennessee | 47189 | 14846 | 164 |
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 |
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);