ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Wayne" 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 |
---|---|---|---|---|---|---|---|
1055505 | 1055505 | 2021-02-22 | Wayne | North Carolina | 37191 | 10152 | 210 |
1052259 | 1052259 | 2021-02-21 | Wayne | North Carolina | 37191 | 10143 | 210 |
1049012 | 1049012 | 2021-02-20 | Wayne | North Carolina | 37191 | 10126 | 210 |
1045765 | 1045765 | 2021-02-19 | Wayne | North Carolina | 37191 | 10105 | 208 |
1042520 | 1042520 | 2021-02-18 | Wayne | North Carolina | 37191 | 10055 | 203 |
1039275 | 1039275 | 2021-02-17 | Wayne | North Carolina | 37191 | 10015 | 203 |
1036030 | 1036030 | 2021-02-16 | Wayne | North Carolina | 37191 | 9985 | 200 |
1032785 | 1032785 | 2021-02-15 | Wayne | North Carolina | 37191 | 9963 | 198 |
1029539 | 1029539 | 2021-02-14 | Wayne | North Carolina | 37191 | 9950 | 198 |
1026292 | 1026292 | 2021-02-13 | Wayne | North Carolina | 37191 | 9925 | 197 |
1023047 | 1023047 | 2021-02-12 | Wayne | North Carolina | 37191 | 9873 | 197 |
1019802 | 1019802 | 2021-02-11 | Wayne | North Carolina | 37191 | 9820 | 196 |
1016557 | 1016557 | 2021-02-10 | Wayne | North Carolina | 37191 | 9788 | 194 |
1013312 | 1013312 | 2021-02-09 | Wayne | North Carolina | 37191 | 9763 | 193 |
1010067 | 1010067 | 2021-02-08 | Wayne | North Carolina | 37191 | 9740 | 191 |
1006821 | 1006821 | 2021-02-07 | Wayne | North Carolina | 37191 | 9720 | 191 |
1003575 | 1003575 | 2021-02-06 | Wayne | North Carolina | 37191 | 9693 | 190 |
1000329 | 1000329 | 2021-02-05 | Wayne | North Carolina | 37191 | 9655 | 188 |
997083 | 997083 | 2021-02-04 | Wayne | North Carolina | 37191 | 9601 | 188 |
993837 | 993837 | 2021-02-03 | Wayne | North Carolina | 37191 | 9517 | 187 |
990591 | 990591 | 2021-02-02 | Wayne | North Carolina | 37191 | 9319 | 187 |
987345 | 987345 | 2021-02-01 | Wayne | North Carolina | 37191 | 9310 | 186 |
984098 | 984098 | 2021-01-31 | Wayne | North Carolina | 37191 | 9281 | 185 |
980851 | 980851 | 2021-01-30 | Wayne | North Carolina | 37191 | 9118 | 185 |
977605 | 977605 | 2021-01-29 | Wayne | North Carolina | 37191 | 9118 | 185 |
974360 | 974360 | 2021-01-28 | Wayne | North Carolina | 37191 | 9055 | 182 |
971115 | 971115 | 2021-01-27 | Wayne | North Carolina | 37191 | 8964 | 180 |
967870 | 967870 | 2021-01-26 | Wayne | North Carolina | 37191 | 8902 | 177 |
964626 | 964626 | 2021-01-25 | Wayne | North Carolina | 37191 | 8877 | 176 |
961381 | 961381 | 2021-01-24 | Wayne | North Carolina | 37191 | 8837 | 176 |
958136 | 958136 | 2021-01-23 | Wayne | North Carolina | 37191 | 8790 | 176 |
954890 | 954890 | 2021-01-22 | Wayne | North Carolina | 37191 | 8737 | 174 |
951645 | 951645 | 2021-01-21 | Wayne | North Carolina | 37191 | 8633 | 172 |
948400 | 948400 | 2021-01-20 | Wayne | North Carolina | 37191 | 8590 | 168 |
945154 | 945154 | 2021-01-19 | Wayne | North Carolina | 37191 | 8513 | 168 |
941907 | 941907 | 2021-01-18 | Wayne | North Carolina | 37191 | 8461 | 168 |
938662 | 938662 | 2021-01-17 | Wayne | North Carolina | 37191 | 8461 | 168 |
935417 | 935417 | 2021-01-16 | Wayne | North Carolina | 37191 | 8404 | 164 |
932172 | 932172 | 2021-01-15 | Wayne | North Carolina | 37191 | 8346 | 163 |
928927 | 928927 | 2021-01-14 | Wayne | North Carolina | 37191 | 8287 | 163 |
925682 | 925682 | 2021-01-13 | Wayne | North Carolina | 37191 | 8186 | 156 |
922436 | 922436 | 2021-01-12 | Wayne | North Carolina | 37191 | 8148 | 156 |
919191 | 919191 | 2021-01-11 | Wayne | North Carolina | 37191 | 8098 | 156 |
915946 | 915946 | 2021-01-10 | Wayne | North Carolina | 37191 | 8072 | 156 |
912701 | 912701 | 2021-01-09 | Wayne | North Carolina | 37191 | 8022 | 154 |
909456 | 909456 | 2021-01-08 | Wayne | North Carolina | 37191 | 7943 | 153 |
906211 | 906211 | 2021-01-07 | Wayne | North Carolina | 37191 | 7867 | 151 |
902965 | 902965 | 2021-01-06 | Wayne | North Carolina | 37191 | 7768 | 151 |
899720 | 899720 | 2021-01-05 | Wayne | North Carolina | 37191 | 7727 | 151 |
896475 | 896475 | 2021-01-04 | Wayne | North Carolina | 37191 | 7704 | 150 |
893229 | 893229 | 2021-01-03 | Wayne | North Carolina | 37191 | 7656 | 150 |
889983 | 889983 | 2021-01-02 | Wayne | North Carolina | 37191 | 7586 | 150 |
886736 | 886736 | 2021-01-01 | Wayne | North Carolina | 37191 | 7422 | 145 |
883491 | 883491 | 2020-12-31 | Wayne | North Carolina | 37191 | 7422 | 145 |
880246 | 880246 | 2020-12-30 | Wayne | North Carolina | 37191 | 7362 | 145 |
877001 | 877001 | 2020-12-29 | Wayne | North Carolina | 37191 | 7293 | 145 |
873756 | 873756 | 2020-12-28 | Wayne | North Carolina | 37191 | 7261 | 145 |
870511 | 870511 | 2020-12-27 | Wayne | North Carolina | 37191 | 7209 | 145 |
867266 | 867266 | 2020-12-26 | Wayne | North Carolina | 37191 | 7182 | 145 |
864021 | 864021 | 2020-12-25 | Wayne | North Carolina | 37191 | 7010 | 137 |
860776 | 860776 | 2020-12-24 | Wayne | North Carolina | 37191 | 7010 | 137 |
857531 | 857531 | 2020-12-23 | Wayne | North Carolina | 37191 | 7010 | 137 |
854286 | 854286 | 2020-12-22 | Wayne | North Carolina | 37191 | 6981 | 136 |
851041 | 851041 | 2020-12-21 | Wayne | North Carolina | 37191 | 6947 | 135 |
847796 | 847796 | 2020-12-20 | Wayne | North Carolina | 37191 | 6920 | 135 |
844551 | 844551 | 2020-12-19 | Wayne | North Carolina | 37191 | 6859 | 131 |
841305 | 841305 | 2020-12-18 | Wayne | North Carolina | 37191 | 6814 | 131 |
838060 | 838060 | 2020-12-17 | Wayne | North Carolina | 37191 | 6718 | 131 |
834814 | 834814 | 2020-12-16 | Wayne | North Carolina | 37191 | 6689 | 129 |
831568 | 831568 | 2020-12-15 | Wayne | North Carolina | 37191 | 6666 | 127 |
828321 | 828321 | 2020-12-14 | Wayne | North Carolina | 37191 | 6640 | 127 |
825075 | 825075 | 2020-12-13 | Wayne | North Carolina | 37191 | 6605 | 127 |
821828 | 821828 | 2020-12-12 | Wayne | North Carolina | 37191 | 6498 | 126 |
818582 | 818582 | 2020-12-11 | Wayne | North Carolina | 37191 | 6438 | 124 |
815336 | 815336 | 2020-12-10 | Wayne | North Carolina | 37191 | 6369 | 121 |
812091 | 812091 | 2020-12-09 | Wayne | North Carolina | 37191 | 6305 | 120 |
808846 | 808846 | 2020-12-08 | Wayne | North Carolina | 37191 | 6240 | 120 |
805601 | 805601 | 2020-12-07 | Wayne | North Carolina | 37191 | 6172 | 119 |
802356 | 802356 | 2020-12-06 | Wayne | North Carolina | 37191 | 6124 | 119 |
799111 | 799111 | 2020-12-05 | Wayne | North Carolina | 37191 | 6043 | 119 |
795866 | 795866 | 2020-12-04 | Wayne | North Carolina | 37191 | 6001 | 117 |
792621 | 792621 | 2020-12-03 | Wayne | North Carolina | 37191 | 5969 | 117 |
789376 | 789376 | 2020-12-02 | Wayne | North Carolina | 37191 | 5887 | 117 |
786131 | 786131 | 2020-12-01 | Wayne | North Carolina | 37191 | 5837 | 113 |
782887 | 782887 | 2020-11-30 | Wayne | North Carolina | 37191 | 5799 | 112 |
779641 | 779641 | 2020-11-29 | Wayne | North Carolina | 37191 | 5779 | 112 |
776396 | 776396 | 2020-11-28 | Wayne | North Carolina | 37191 | 5728 | 112 |
773151 | 773151 | 2020-11-27 | Wayne | North Carolina | 37191 | 5687 | 112 |
769906 | 769906 | 2020-11-26 | Wayne | North Carolina | 37191 | 5581 | 112 |
766660 | 766660 | 2020-11-25 | Wayne | North Carolina | 37191 | 5581 | 112 |
763415 | 763415 | 2020-11-24 | Wayne | North Carolina | 37191 | 5555 | 110 |
760170 | 760170 | 2020-11-23 | Wayne | North Carolina | 37191 | 5513 | 110 |
756924 | 756924 | 2020-11-22 | Wayne | North Carolina | 37191 | 5476 | 110 |
753677 | 753677 | 2020-11-21 | Wayne | North Carolina | 37191 | 5403 | 110 |
750431 | 750431 | 2020-11-20 | Wayne | North Carolina | 37191 | 5357 | 110 |
747185 | 747185 | 2020-11-19 | Wayne | North Carolina | 37191 | 5309 | 109 |
743939 | 743939 | 2020-11-18 | Wayne | North Carolina | 37191 | 5261 | 106 |
740692 | 740692 | 2020-11-17 | Wayne | North Carolina | 37191 | 5233 | 106 |
737447 | 737447 | 2020-11-16 | Wayne | North Carolina | 37191 | 5196 | 105 |
734203 | 734203 | 2020-11-15 | Wayne | North Carolina | 37191 | 5165 | 105 |
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);