ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
12,212 rows where county = "Wayne" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 16
- Pennsylvania 307
- Michigan 303
- North Carolina 300
- New York 294
- Indiana 293
- Kentucky 288
- Ohio 288
- Tennessee 283
- Mississippi 280
- Georgia 277
- West Virginia 273
- Nebraska 271
- Illinois 264
- Iowa 250
- Missouri 201
- Utah 164
fips 16
county 1
- Wayne · 4,336 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
902082 | 902082 | 2021-01-06 | Wayne | Kentucky | 21231 | 1633 | 27 |
902291 | 902291 | 2021-01-06 | Wayne | Michigan | 26163 | 88055 | 3711 |
902457 | 902457 | 2021-01-06 | Wayne | Mississippi | 28153 | 1786 | 27 |
902576 | 902576 | 2021-01-06 | Wayne | Missouri | 29223 | 690 | 7 |
902725 | 902725 | 2021-01-06 | Wayne | Nebraska | 31179 | 889 | 6 |
902866 | 902866 | 2021-01-06 | Wayne | New York | 36117 | 2942 | 43 |
902965 | 902965 | 2021-01-06 | Wayne | North Carolina | 37191 | 7768 | 151 |
903110 | 903110 | 2021-01-06 | Wayne | Ohio | 39169 | 6167 | 154 |
903291 | 903291 | 2021-01-06 | Wayne | Pennsylvania | 42127 | 2046 | 19 |
903583 | 903583 | 2021-01-06 | Wayne | Tennessee | 47181 | 2503 | 18 |
903870 | 903870 | 2021-01-06 | Wayne | Utah | 49055 | 72 | 0 |
904111 | 904111 | 2021-01-06 | Wayne | West Virginia | 54099 | 1846 | 22 |
898263 | 898263 | 2021-01-05 | Wayne | Georgia | 13305 | 2256 | 49 |
898417 | 898417 | 2021-01-05 | Wayne | Illinois | 17191 | 1382 | 42 |
898512 | 898512 | 2021-01-05 | Wayne | Indiana | 18177 | 5799 | 151 |
898609 | 898609 | 2021-01-05 | Wayne | Iowa | 19185 | 394 | 21 |
898837 | 898837 | 2021-01-05 | Wayne | Kentucky | 21231 | 1581 | 27 |
899046 | 899046 | 2021-01-05 | Wayne | Michigan | 26163 | 87285 | 3704 |
899212 | 899212 | 2021-01-05 | Wayne | Mississippi | 28153 | 1765 | 27 |
899331 | 899331 | 2021-01-05 | Wayne | Missouri | 29223 | 687 | 7 |
899480 | 899480 | 2021-01-05 | Wayne | Nebraska | 31179 | 885 | 6 |
899621 | 899621 | 2021-01-05 | Wayne | New York | 36117 | 2886 | 43 |
899720 | 899720 | 2021-01-05 | Wayne | North Carolina | 37191 | 7727 | 151 |
899865 | 899865 | 2021-01-05 | Wayne | Ohio | 39169 | 6110 | 153 |
900046 | 900046 | 2021-01-05 | Wayne | Pennsylvania | 42127 | 2029 | 19 |
900338 | 900338 | 2021-01-05 | Wayne | Tennessee | 47181 | 2496 | 18 |
900625 | 900625 | 2021-01-05 | Wayne | Utah | 49055 | 71 | 0 |
900866 | 900866 | 2021-01-05 | Wayne | West Virginia | 54099 | 1806 | 21 |
895018 | 895018 | 2021-01-04 | Wayne | Georgia | 13305 | 2234 | 49 |
895172 | 895172 | 2021-01-04 | Wayne | Illinois | 17191 | 1365 | 42 |
895267 | 895267 | 2021-01-04 | Wayne | Indiana | 18177 | 5762 | 149 |
895364 | 895364 | 2021-01-04 | Wayne | Iowa | 19185 | 390 | 21 |
895592 | 895592 | 2021-01-04 | Wayne | Kentucky | 21231 | 1529 | 27 |
895801 | 895801 | 2021-01-04 | Wayne | Michigan | 26163 | 86904 | 3684 |
895967 | 895967 | 2021-01-04 | Wayne | Mississippi | 28153 | 1747 | 27 |
896086 | 896086 | 2021-01-04 | Wayne | Missouri | 29223 | 686 | 6 |
896235 | 896235 | 2021-01-04 | Wayne | Nebraska | 31179 | 884 | 6 |
896376 | 896376 | 2021-01-04 | Wayne | New York | 36117 | 2827 | 42 |
896475 | 896475 | 2021-01-04 | Wayne | North Carolina | 37191 | 7704 | 150 |
896620 | 896620 | 2021-01-04 | Wayne | Ohio | 39169 | 6062 | 153 |
896801 | 896801 | 2021-01-04 | Wayne | Pennsylvania | 42127 | 1971 | 18 |
897093 | 897093 | 2021-01-04 | Wayne | Tennessee | 47181 | 2478 | 17 |
897380 | 897380 | 2021-01-04 | Wayne | Utah | 49055 | 71 | 0 |
897621 | 897621 | 2021-01-04 | Wayne | West Virginia | 54099 | 1773 | 21 |
891771 | 891771 | 2021-01-03 | Wayne | Georgia | 13305 | 2224 | 49 |
891925 | 891925 | 2021-01-03 | Wayne | Illinois | 17191 | 1358 | 41 |
892020 | 892020 | 2021-01-03 | Wayne | Indiana | 18177 | 5734 | 149 |
892117 | 892117 | 2021-01-03 | Wayne | Iowa | 19185 | 389 | 21 |
892345 | 892345 | 2021-01-03 | Wayne | Kentucky | 21231 | 1500 | 25 |
892554 | 892554 | 2021-01-03 | Wayne | Michigan | 26163 | 86022 | 3669 |
892720 | 892720 | 2021-01-03 | Wayne | Mississippi | 28153 | 1735 | 27 |
892839 | 892839 | 2021-01-03 | Wayne | Missouri | 29223 | 686 | 6 |
892988 | 892988 | 2021-01-03 | Wayne | Nebraska | 31179 | 883 | 6 |
893130 | 893130 | 2021-01-03 | Wayne | New York | 36117 | 2768 | 41 |
893229 | 893229 | 2021-01-03 | Wayne | North Carolina | 37191 | 7656 | 150 |
893374 | 893374 | 2021-01-03 | Wayne | Ohio | 39169 | 5999 | 153 |
893555 | 893555 | 2021-01-03 | Wayne | Pennsylvania | 42127 | 1968 | 18 |
893847 | 893847 | 2021-01-03 | Wayne | Tennessee | 47181 | 2469 | 17 |
894134 | 894134 | 2021-01-03 | Wayne | Utah | 49055 | 70 | 0 |
894375 | 894375 | 2021-01-03 | Wayne | West Virginia | 54099 | 1768 | 21 |
888524 | 888524 | 2021-01-02 | Wayne | Georgia | 13305 | 2193 | 49 |
888679 | 888679 | 2021-01-02 | Wayne | Illinois | 17191 | 1354 | 41 |
888774 | 888774 | 2021-01-02 | Wayne | Indiana | 18177 | 5717 | 148 |
888871 | 888871 | 2021-01-02 | Wayne | Iowa | 19185 | 386 | 21 |
889099 | 889099 | 2021-01-02 | Wayne | Kentucky | 21231 | 1483 | 23 |
889308 | 889308 | 2021-01-02 | Wayne | Michigan | 26163 | 86022 | 3669 |
889474 | 889474 | 2021-01-02 | Wayne | Mississippi | 28153 | 1715 | 27 |
889593 | 889593 | 2021-01-02 | Wayne | Missouri | 29223 | 677 | 6 |
889742 | 889742 | 2021-01-02 | Wayne | Nebraska | 31179 | 883 | 6 |
889884 | 889884 | 2021-01-02 | Wayne | New York | 36117 | 2700 | 39 |
889983 | 889983 | 2021-01-02 | Wayne | North Carolina | 37191 | 7586 | 150 |
890128 | 890128 | 2021-01-02 | Wayne | Ohio | 39169 | 5914 | 147 |
890309 | 890309 | 2021-01-02 | Wayne | Pennsylvania | 42127 | 1951 | 18 |
890601 | 890601 | 2021-01-02 | Wayne | Tennessee | 47181 | 2453 | 17 |
890888 | 890888 | 2021-01-02 | Wayne | Utah | 49055 | 70 | 0 |
891129 | 891129 | 2021-01-02 | Wayne | West Virginia | 54099 | 1757 | 21 |
885279 | 885279 | 2021-01-01 | Wayne | Georgia | 13305 | 2151 | 49 |
885433 | 885433 | 2021-01-01 | Wayne | Illinois | 17191 | 1336 | 41 |
885528 | 885528 | 2021-01-01 | Wayne | Indiana | 18177 | 5684 | 148 |
885625 | 885625 | 2021-01-01 | Wayne | Iowa | 19185 | 384 | 21 |
885853 | 885853 | 2021-01-01 | Wayne | Kentucky | 21231 | 1455 | 20 |
886062 | 886062 | 2021-01-01 | Wayne | Michigan | 26163 | 84967 | 3626 |
886228 | 886228 | 2021-01-01 | Wayne | Mississippi | 28153 | 1698 | 27 |
886347 | 886347 | 2021-01-01 | Wayne | Missouri | 29223 | 670 | 6 |
886496 | 886496 | 2021-01-01 | Wayne | Nebraska | 31179 | 883 | 6 |
886637 | 886637 | 2021-01-01 | Wayne | New York | 36117 | 2632 | 39 |
886736 | 886736 | 2021-01-01 | Wayne | North Carolina | 37191 | 7422 | 145 |
886881 | 886881 | 2021-01-01 | Wayne | Ohio | 39169 | 5829 | 146 |
887062 | 887062 | 2021-01-01 | Wayne | Pennsylvania | 42127 | 1867 | 18 |
887354 | 887354 | 2021-01-01 | Wayne | Tennessee | 47181 | 2417 | 17 |
887641 | 887641 | 2021-01-01 | Wayne | Utah | 49055 | 70 | 0 |
887882 | 887882 | 2021-01-01 | Wayne | West Virginia | 54099 | 1742 | 21 |
882034 | 882034 | 2020-12-31 | Wayne | Georgia | 13305 | 2112 | 49 |
882188 | 882188 | 2020-12-31 | Wayne | Illinois | 17191 | 1336 | 41 |
882283 | 882283 | 2020-12-31 | Wayne | Indiana | 18177 | 5615 | 144 |
882380 | 882380 | 2020-12-31 | Wayne | Iowa | 19185 | 381 | 21 |
882608 | 882608 | 2020-12-31 | Wayne | Kentucky | 21231 | 1455 | 20 |
882817 | 882817 | 2020-12-31 | Wayne | Michigan | 26163 | 84967 | 3626 |
882983 | 882983 | 2020-12-31 | Wayne | Mississippi | 28153 | 1671 | 27 |
883102 | 883102 | 2020-12-31 | Wayne | Missouri | 29223 | 663 | 6 |
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);