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 319
- Michigan 315
- North Carolina 312
- New York 306
- Indiana 305
- Kentucky 300
- Ohio 300
- Tennessee 295
- Mississippi 292
- Georgia 289
- West Virginia 285
- Nebraska 283
- Illinois 276
- Iowa 262
- Missouri 213
- Utah 176
fips 16
county 1
- Wayne · 4,528 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
941024 | 941024 | 2021-01-18 | Wayne | Kentucky | 21231 | 1800 | 35 |
941233 | 941233 | 2021-01-18 | Wayne | Michigan | 26163 | 93003 | 3859 |
941399 | 941399 | 2021-01-18 | Wayne | Mississippi | 28153 | 2013 | 31 |
941518 | 941518 | 2021-01-18 | Wayne | Missouri | 29223 | 754 | 9 |
941667 | 941667 | 2021-01-18 | Wayne | Nebraska | 31179 | 907 | 6 |
941808 | 941808 | 2021-01-18 | Wayne | New York | 36117 | 3646 | 51 |
941907 | 941907 | 2021-01-18 | Wayne | North Carolina | 37191 | 8461 | 168 |
942052 | 942052 | 2021-01-18 | Wayne | Ohio | 39169 | 6815 | 165 |
942233 | 942233 | 2021-01-18 | Wayne | Pennsylvania | 42127 | 2446 | 36 |
942525 | 942525 | 2021-01-18 | Wayne | Tennessee | 47181 | 2613 | 19 |
942812 | 942812 | 2021-01-18 | Wayne | Utah | 49055 | 87 | 0 |
943053 | 943053 | 2021-01-18 | Wayne | West Virginia | 54099 | 2109 | 26 |
937205 | 937205 | 2021-01-17 | Wayne | Georgia | 13305 | 2667 | 52 |
937359 | 937359 | 2021-01-17 | Wayne | Illinois | 17191 | 1503 | 43 |
937454 | 937454 | 2021-01-17 | Wayne | Indiana | 18177 | 6324 | 160 |
937551 | 937551 | 2021-01-17 | Wayne | Iowa | 19185 | 414 | 21 |
937779 | 937779 | 2021-01-17 | Wayne | Kentucky | 21231 | 1790 | 34 |
937988 | 937988 | 2021-01-17 | Wayne | Michigan | 26163 | 92476 | 3856 |
938154 | 938154 | 2021-01-17 | Wayne | Mississippi | 28153 | 1996 | 30 |
938273 | 938273 | 2021-01-17 | Wayne | Missouri | 29223 | 747 | 9 |
938422 | 938422 | 2021-01-17 | Wayne | Nebraska | 31179 | 907 | 6 |
938563 | 938563 | 2021-01-17 | Wayne | New York | 36117 | 3606 | 50 |
938662 | 938662 | 2021-01-17 | Wayne | North Carolina | 37191 | 8461 | 168 |
938807 | 938807 | 2021-01-17 | Wayne | Ohio | 39169 | 6781 | 164 |
938988 | 938988 | 2021-01-17 | Wayne | Pennsylvania | 42127 | 2432 | 35 |
939280 | 939280 | 2021-01-17 | Wayne | Tennessee | 47181 | 2607 | 19 |
939567 | 939567 | 2021-01-17 | Wayne | Utah | 49055 | 87 | 0 |
939808 | 939808 | 2021-01-17 | Wayne | West Virginia | 54099 | 2100 | 26 |
933960 | 933960 | 2021-01-16 | Wayne | Georgia | 13305 | 2649 | 52 |
934114 | 934114 | 2021-01-16 | Wayne | Illinois | 17191 | 1501 | 43 |
934209 | 934209 | 2021-01-16 | Wayne | Indiana | 18177 | 6294 | 159 |
934306 | 934306 | 2021-01-16 | Wayne | Iowa | 19185 | 414 | 21 |
934534 | 934534 | 2021-01-16 | Wayne | Kentucky | 21231 | 1788 | 34 |
934743 | 934743 | 2021-01-16 | Wayne | Michigan | 26163 | 92476 | 3856 |
934909 | 934909 | 2021-01-16 | Wayne | Mississippi | 28153 | 1987 | 30 |
935028 | 935028 | 2021-01-16 | Wayne | Missouri | 29223 | 745 | 9 |
935177 | 935177 | 2021-01-16 | Wayne | Nebraska | 31179 | 906 | 6 |
935318 | 935318 | 2021-01-16 | Wayne | New York | 36117 | 3568 | 50 |
935417 | 935417 | 2021-01-16 | Wayne | North Carolina | 37191 | 8404 | 164 |
935562 | 935562 | 2021-01-16 | Wayne | Ohio | 39169 | 6729 | 162 |
935743 | 935743 | 2021-01-16 | Wayne | Pennsylvania | 42127 | 2414 | 35 |
936035 | 936035 | 2021-01-16 | Wayne | Tennessee | 47181 | 2600 | 19 |
936322 | 936322 | 2021-01-16 | Wayne | Utah | 49055 | 87 | 0 |
936563 | 936563 | 2021-01-16 | Wayne | West Virginia | 54099 | 2089 | 26 |
930715 | 930715 | 2021-01-15 | Wayne | Georgia | 13305 | 2628 | 52 |
930869 | 930869 | 2021-01-15 | Wayne | Illinois | 17191 | 1487 | 43 |
930964 | 930964 | 2021-01-15 | Wayne | Indiana | 18177 | 6263 | 159 |
931061 | 931061 | 2021-01-15 | Wayne | Iowa | 19185 | 414 | 21 |
931289 | 931289 | 2021-01-15 | Wayne | Kentucky | 21231 | 1779 | 34 |
931498 | 931498 | 2021-01-15 | Wayne | Michigan | 26163 | 92074 | 3839 |
931664 | 931664 | 2021-01-15 | Wayne | Mississippi | 28153 | 1961 | 30 |
931783 | 931783 | 2021-01-15 | Wayne | Missouri | 29223 | 738 | 9 |
931932 | 931932 | 2021-01-15 | Wayne | Nebraska | 31179 | 906 | 6 |
932073 | 932073 | 2021-01-15 | Wayne | New York | 36117 | 3527 | 50 |
932172 | 932172 | 2021-01-15 | Wayne | North Carolina | 37191 | 8346 | 163 |
932317 | 932317 | 2021-01-15 | Wayne | Ohio | 39169 | 6659 | 162 |
932498 | 932498 | 2021-01-15 | Wayne | Pennsylvania | 42127 | 2370 | 34 |
932790 | 932790 | 2021-01-15 | Wayne | Tennessee | 47181 | 2595 | 19 |
933077 | 933077 | 2021-01-15 | Wayne | Utah | 49055 | 87 | 0 |
933318 | 933318 | 2021-01-15 | Wayne | West Virginia | 54099 | 2056 | 25 |
927470 | 927470 | 2021-01-14 | Wayne | Georgia | 13305 | 2590 | 52 |
927624 | 927624 | 2021-01-14 | Wayne | Illinois | 17191 | 1480 | 43 |
927719 | 927719 | 2021-01-14 | Wayne | Indiana | 18177 | 6202 | 158 |
927816 | 927816 | 2021-01-14 | Wayne | Iowa | 19185 | 413 | 21 |
928044 | 928044 | 2021-01-14 | Wayne | Kentucky | 21231 | 1770 | 33 |
928253 | 928253 | 2021-01-14 | Wayne | Michigan | 26163 | 91526 | 3835 |
928419 | 928419 | 2021-01-14 | Wayne | Mississippi | 28153 | 1930 | 29 |
928538 | 928538 | 2021-01-14 | Wayne | Missouri | 29223 | 735 | 9 |
928687 | 928687 | 2021-01-14 | Wayne | Nebraska | 31179 | 905 | 6 |
928828 | 928828 | 2021-01-14 | Wayne | New York | 36117 | 3448 | 50 |
928927 | 928927 | 2021-01-14 | Wayne | North Carolina | 37191 | 8287 | 163 |
929072 | 929072 | 2021-01-14 | Wayne | Ohio | 39169 | 6599 | 162 |
929253 | 929253 | 2021-01-14 | Wayne | Pennsylvania | 42127 | 2349 | 33 |
929545 | 929545 | 2021-01-14 | Wayne | Tennessee | 47181 | 2582 | 19 |
929832 | 929832 | 2021-01-14 | Wayne | Utah | 49055 | 86 | 0 |
930073 | 930073 | 2021-01-14 | Wayne | West Virginia | 54099 | 2041 | 25 |
924224 | 924224 | 2021-01-13 | Wayne | Georgia | 13305 | 2540 | 52 |
924378 | 924378 | 2021-01-13 | Wayne | Illinois | 17191 | 1471 | 43 |
924473 | 924473 | 2021-01-13 | Wayne | Indiana | 18177 | 6156 | 157 |
924570 | 924570 | 2021-01-13 | Wayne | Iowa | 19185 | 413 | 21 |
924798 | 924798 | 2021-01-13 | Wayne | Kentucky | 21231 | 1761 | 30 |
925007 | 925007 | 2021-01-13 | Wayne | Michigan | 26163 | 91162 | 3813 |
925173 | 925173 | 2021-01-13 | Wayne | Mississippi | 28153 | 1911 | 29 |
925292 | 925292 | 2021-01-13 | Wayne | Missouri | 29223 | 729 | 9 |
925441 | 925441 | 2021-01-13 | Wayne | Nebraska | 31179 | 903 | 6 |
925583 | 925583 | 2021-01-13 | Wayne | New York | 36117 | 3395 | 48 |
925682 | 925682 | 2021-01-13 | Wayne | North Carolina | 37191 | 8186 | 156 |
925827 | 925827 | 2021-01-13 | Wayne | Ohio | 39169 | 6558 | 161 |
926008 | 926008 | 2021-01-13 | Wayne | Pennsylvania | 42127 | 2308 | 30 |
926300 | 926300 | 2021-01-13 | Wayne | Tennessee | 47181 | 2580 | 18 |
926587 | 926587 | 2021-01-13 | Wayne | Utah | 49055 | 78 | 0 |
926828 | 926828 | 2021-01-13 | Wayne | West Virginia | 54099 | 2025 | 25 |
920979 | 920979 | 2021-01-12 | Wayne | Georgia | 13305 | 2506 | 52 |
921133 | 921133 | 2021-01-12 | Wayne | Illinois | 17191 | 1450 | 43 |
921228 | 921228 | 2021-01-12 | Wayne | Indiana | 18177 | 6122 | 156 |
921325 | 921325 | 2021-01-12 | Wayne | Iowa | 19185 | 412 | 21 |
921553 | 921553 | 2021-01-12 | Wayne | Kentucky | 21231 | 1739 | 29 |
921762 | 921762 | 2021-01-12 | Wayne | Michigan | 26163 | 90704 | 3807 |
921928 | 921928 | 2021-01-12 | Wayne | Mississippi | 28153 | 1904 | 29 |
922047 | 922047 | 2021-01-12 | Wayne | Missouri | 29223 | 728 | 9 |
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);