ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Wilson" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1094453 | 1094453 | 2021-03-06 | Wilson | North Carolina | 37195 | 8543 | 150 |
1091207 | 1091207 | 2021-03-05 | Wilson | North Carolina | 37195 | 8520 | 150 |
1087962 | 1087962 | 2021-03-04 | Wilson | North Carolina | 37195 | 8503 | 150 |
1084717 | 1084717 | 2021-03-03 | Wilson | North Carolina | 37195 | 8478 | 149 |
1081471 | 1081471 | 2021-03-02 | Wilson | North Carolina | 37195 | 8434 | 147 |
1078225 | 1078225 | 2021-03-01 | Wilson | North Carolina | 37195 | 8420 | 147 |
1074980 | 1074980 | 2021-02-28 | Wilson | North Carolina | 37195 | 8389 | 147 |
1071734 | 1071734 | 2021-02-27 | Wilson | North Carolina | 37195 | 8389 | 147 |
1068488 | 1068488 | 2021-02-26 | Wilson | North Carolina | 37195 | 8355 | 147 |
1065243 | 1065243 | 2021-02-25 | Wilson | North Carolina | 37195 | 8338 | 147 |
1061999 | 1061999 | 2021-02-24 | Wilson | North Carolina | 37195 | 8315 | 147 |
1058753 | 1058753 | 2021-02-23 | Wilson | North Carolina | 37195 | 8276 | 145 |
1055507 | 1055507 | 2021-02-22 | Wilson | North Carolina | 37195 | 8237 | 145 |
1052261 | 1052261 | 2021-02-21 | Wilson | North Carolina | 37195 | 8215 | 145 |
1049014 | 1049014 | 2021-02-20 | Wilson | North Carolina | 37195 | 8198 | 145 |
1045767 | 1045767 | 2021-02-19 | Wilson | North Carolina | 37195 | 8171 | 145 |
1042522 | 1042522 | 2021-02-18 | Wilson | North Carolina | 37195 | 8134 | 145 |
1039277 | 1039277 | 2021-02-17 | Wilson | North Carolina | 37195 | 8096 | 141 |
1036032 | 1036032 | 2021-02-16 | Wilson | North Carolina | 37195 | 8054 | 141 |
1032787 | 1032787 | 2021-02-15 | Wilson | North Carolina | 37195 | 8030 | 141 |
1029541 | 1029541 | 2021-02-14 | Wilson | North Carolina | 37195 | 8009 | 141 |
1026294 | 1026294 | 2021-02-13 | Wilson | North Carolina | 37195 | 7983 | 141 |
1023049 | 1023049 | 2021-02-12 | Wilson | North Carolina | 37195 | 7941 | 141 |
1019804 | 1019804 | 2021-02-11 | Wilson | North Carolina | 37195 | 7919 | 141 |
1016559 | 1016559 | 2021-02-10 | Wilson | North Carolina | 37195 | 7872 | 141 |
1013314 | 1013314 | 2021-02-09 | Wilson | North Carolina | 37195 | 7830 | 141 |
1010069 | 1010069 | 2021-02-08 | Wilson | North Carolina | 37195 | 7811 | 141 |
1006823 | 1006823 | 2021-02-07 | Wilson | North Carolina | 37195 | 7790 | 141 |
1003577 | 1003577 | 2021-02-06 | Wilson | North Carolina | 37195 | 7754 | 141 |
1000331 | 1000331 | 2021-02-05 | Wilson | North Carolina | 37195 | 7702 | 141 |
997085 | 997085 | 2021-02-04 | Wilson | North Carolina | 37195 | 7671 | 141 |
993839 | 993839 | 2021-02-03 | Wilson | North Carolina | 37195 | 7628 | 141 |
990593 | 990593 | 2021-02-02 | Wilson | North Carolina | 37195 | 7438 | 133 |
987347 | 987347 | 2021-02-01 | Wilson | North Carolina | 37195 | 7416 | 133 |
984100 | 984100 | 2021-01-31 | Wilson | North Carolina | 37195 | 7396 | 133 |
980853 | 980853 | 2021-01-30 | Wilson | North Carolina | 37195 | 7323 | 130 |
977607 | 977607 | 2021-01-29 | Wilson | North Carolina | 37195 | 7323 | 130 |
974362 | 974362 | 2021-01-28 | Wilson | North Carolina | 37195 | 7268 | 129 |
971117 | 971117 | 2021-01-27 | Wilson | North Carolina | 37195 | 7226 | 124 |
967872 | 967872 | 2021-01-26 | Wilson | North Carolina | 37195 | 7183 | 123 |
964628 | 964628 | 2021-01-25 | Wilson | North Carolina | 37195 | 7157 | 123 |
961383 | 961383 | 2021-01-24 | Wilson | North Carolina | 37195 | 7132 | 123 |
958138 | 958138 | 2021-01-23 | Wilson | North Carolina | 37195 | 7081 | 123 |
954892 | 954892 | 2021-01-22 | Wilson | North Carolina | 37195 | 7013 | 123 |
951647 | 951647 | 2021-01-21 | Wilson | North Carolina | 37195 | 6916 | 123 |
948402 | 948402 | 2021-01-20 | Wilson | North Carolina | 37195 | 6886 | 123 |
945156 | 945156 | 2021-01-19 | Wilson | North Carolina | 37195 | 6850 | 123 |
941909 | 941909 | 2021-01-18 | Wilson | North Carolina | 37195 | 6799 | 123 |
938664 | 938664 | 2021-01-17 | Wilson | North Carolina | 37195 | 6799 | 123 |
935419 | 935419 | 2021-01-16 | Wilson | North Carolina | 37195 | 6754 | 123 |
932174 | 932174 | 2021-01-15 | Wilson | North Carolina | 37195 | 6683 | 123 |
928929 | 928929 | 2021-01-14 | Wilson | North Carolina | 37195 | 6601 | 122 |
925684 | 925684 | 2021-01-13 | Wilson | North Carolina | 37195 | 6511 | 119 |
922438 | 922438 | 2021-01-12 | Wilson | North Carolina | 37195 | 6435 | 119 |
919193 | 919193 | 2021-01-11 | Wilson | North Carolina | 37195 | 6357 | 119 |
915948 | 915948 | 2021-01-10 | Wilson | North Carolina | 37195 | 6317 | 119 |
912703 | 912703 | 2021-01-09 | Wilson | North Carolina | 37195 | 6217 | 118 |
909458 | 909458 | 2021-01-08 | Wilson | North Carolina | 37195 | 6138 | 113 |
906213 | 906213 | 2021-01-07 | Wilson | North Carolina | 37195 | 6034 | 113 |
902967 | 902967 | 2021-01-06 | Wilson | North Carolina | 37195 | 5920 | 109 |
899722 | 899722 | 2021-01-05 | Wilson | North Carolina | 37195 | 5848 | 109 |
896477 | 896477 | 2021-01-04 | Wilson | North Carolina | 37195 | 5778 | 109 |
893231 | 893231 | 2021-01-03 | Wilson | North Carolina | 37195 | 5732 | 108 |
889985 | 889985 | 2021-01-02 | Wilson | North Carolina | 37195 | 5658 | 104 |
886738 | 886738 | 2021-01-01 | Wilson | North Carolina | 37195 | 5516 | 103 |
883493 | 883493 | 2020-12-31 | Wilson | North Carolina | 37195 | 5516 | 103 |
880248 | 880248 | 2020-12-30 | Wilson | North Carolina | 37195 | 5454 | 103 |
877003 | 877003 | 2020-12-29 | Wilson | North Carolina | 37195 | 5384 | 103 |
873758 | 873758 | 2020-12-28 | Wilson | North Carolina | 37195 | 5365 | 103 |
870513 | 870513 | 2020-12-27 | Wilson | North Carolina | 37195 | 5342 | 103 |
867268 | 867268 | 2020-12-26 | Wilson | North Carolina | 37195 | 5336 | 103 |
864023 | 864023 | 2020-12-25 | Wilson | North Carolina | 37195 | 5162 | 103 |
860778 | 860778 | 2020-12-24 | Wilson | North Carolina | 37195 | 5162 | 103 |
857533 | 857533 | 2020-12-23 | Wilson | North Carolina | 37195 | 5162 | 103 |
854288 | 854288 | 2020-12-22 | Wilson | North Carolina | 37195 | 5116 | 100 |
851043 | 851043 | 2020-12-21 | Wilson | North Carolina | 37195 | 5093 | 100 |
847798 | 847798 | 2020-12-20 | Wilson | North Carolina | 37195 | 5055 | 100 |
844553 | 844553 | 2020-12-19 | Wilson | North Carolina | 37195 | 4975 | 97 |
841307 | 841307 | 2020-12-18 | Wilson | North Carolina | 37195 | 4938 | 94 |
838062 | 838062 | 2020-12-17 | Wilson | North Carolina | 37195 | 4851 | 94 |
834816 | 834816 | 2020-12-16 | Wilson | North Carolina | 37195 | 4819 | 89 |
831570 | 831570 | 2020-12-15 | Wilson | North Carolina | 37195 | 4787 | 89 |
828323 | 828323 | 2020-12-14 | Wilson | North Carolina | 37195 | 4747 | 89 |
825077 | 825077 | 2020-12-13 | Wilson | North Carolina | 37195 | 4707 | 89 |
821830 | 821830 | 2020-12-12 | Wilson | North Carolina | 37195 | 4627 | 89 |
818584 | 818584 | 2020-12-11 | Wilson | North Carolina | 37195 | 4576 | 89 |
815338 | 815338 | 2020-12-10 | Wilson | North Carolina | 37195 | 4534 | 89 |
812093 | 812093 | 2020-12-09 | Wilson | North Carolina | 37195 | 4465 | 86 |
808848 | 808848 | 2020-12-08 | Wilson | North Carolina | 37195 | 4417 | 86 |
805603 | 805603 | 2020-12-07 | Wilson | North Carolina | 37195 | 4370 | 85 |
802358 | 802358 | 2020-12-06 | Wilson | North Carolina | 37195 | 4348 | 85 |
799113 | 799113 | 2020-12-05 | Wilson | North Carolina | 37195 | 4289 | 85 |
795868 | 795868 | 2020-12-04 | Wilson | North Carolina | 37195 | 4242 | 82 |
792623 | 792623 | 2020-12-03 | Wilson | North Carolina | 37195 | 4191 | 82 |
789378 | 789378 | 2020-12-02 | Wilson | North Carolina | 37195 | 4119 | 82 |
786133 | 786133 | 2020-12-01 | Wilson | North Carolina | 37195 | 4111 | 81 |
782889 | 782889 | 2020-11-30 | Wilson | North Carolina | 37195 | 4078 | 81 |
779643 | 779643 | 2020-11-29 | Wilson | North Carolina | 37195 | 4041 | 81 |
776398 | 776398 | 2020-11-28 | Wilson | North Carolina | 37195 | 4004 | 77 |
773153 | 773153 | 2020-11-27 | Wilson | North Carolina | 37195 | 3976 | 77 |
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);