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 219
- Michigan 215
- North Carolina 212
- New York 206
- Indiana 205
- Kentucky 200
- Ohio 200
- Tennessee 195
- Mississippi 192
- Georgia 189
- West Virginia 185
- Nebraska 183
- Illinois 176
- Iowa 162
- Missouri 113
- Utah 76
fips 16
county 1
- Wayne · 2,928 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
616538 | 616538 | 2020-10-10 | Wayne | Kentucky | 21231 | 197 | 0 |
616747 | 616747 | 2020-10-10 | Wayne | Michigan | 26163 | 36900 | 3008 |
616913 | 616913 | 2020-10-10 | Wayne | Mississippi | 28153 | 952 | 21 |
617032 | 617032 | 2020-10-10 | Wayne | Missouri | 29223 | 260 | 1 |
617182 | 617182 | 2020-10-10 | Wayne | Nebraska | 31179 | 247 | 0 |
617322 | 617322 | 2020-10-10 | Wayne | New York | 36117 | 361 | 3 |
617421 | 617421 | 2020-10-10 | Wayne | North Carolina | 37191 | 3800 | 74 |
617566 | 617566 | 2020-10-10 | Wayne | Ohio | 39169 | 1043 | 68 |
617746 | 617746 | 2020-10-10 | Wayne | Pennsylvania | 42127 | 264 | 12 |
618038 | 618038 | 2020-10-10 | Wayne | Tennessee | 47181 | 1541 | 6 |
618323 | 618323 | 2020-10-10 | Wayne | Utah | 49055 | 7 | 0 |
618565 | 618565 | 2020-10-10 | Wayne | West Virginia | 54099 | 437 | 11 |
612724 | 612724 | 2020-10-09 | Wayne | Georgia | 13305 | 1266 | 29 |
612878 | 612878 | 2020-10-09 | Wayne | Illinois | 17191 | 345 | 7 |
612973 | 612973 | 2020-10-09 | Wayne | Indiana | 18177 | 1281 | 16 |
613070 | 613070 | 2020-10-09 | Wayne | Iowa | 19185 | 101 | 3 |
613297 | 613297 | 2020-10-09 | Wayne | Kentucky | 21231 | 196 | 0 |
613506 | 613506 | 2020-10-09 | Wayne | Michigan | 26163 | 36687 | 3006 |
613672 | 613672 | 2020-10-09 | Wayne | Mississippi | 28153 | 950 | 21 |
613791 | 613791 | 2020-10-09 | Wayne | Missouri | 29223 | 247 | 1 |
613940 | 613940 | 2020-10-09 | Wayne | Nebraska | 31179 | 211 | 0 |
614080 | 614080 | 2020-10-09 | Wayne | New York | 36117 | 357 | 3 |
614179 | 614179 | 2020-10-09 | Wayne | North Carolina | 37191 | 3751 | 74 |
614324 | 614324 | 2020-10-09 | Wayne | Ohio | 39169 | 1035 | 68 |
614504 | 614504 | 2020-10-09 | Wayne | Pennsylvania | 42127 | 263 | 12 |
614796 | 614796 | 2020-10-09 | Wayne | Tennessee | 47181 | 1540 | 6 |
615081 | 615081 | 2020-10-09 | Wayne | Utah | 49055 | 6 | 0 |
615323 | 615323 | 2020-10-09 | Wayne | West Virginia | 54099 | 428 | 11 |
609482 | 609482 | 2020-10-08 | Wayne | Georgia | 13305 | 1263 | 30 |
609636 | 609636 | 2020-10-08 | Wayne | Illinois | 17191 | 343 | 6 |
609731 | 609731 | 2020-10-08 | Wayne | Indiana | 18177 | 1257 | 16 |
609828 | 609828 | 2020-10-08 | Wayne | Iowa | 19185 | 98 | 3 |
610055 | 610055 | 2020-10-08 | Wayne | Kentucky | 21231 | 195 | 0 |
610264 | 610264 | 2020-10-08 | Wayne | Michigan | 26163 | 36564 | 3004 |
610430 | 610430 | 2020-10-08 | Wayne | Mississippi | 28153 | 946 | 21 |
610549 | 610549 | 2020-10-08 | Wayne | Missouri | 29223 | 243 | 0 |
610699 | 610699 | 2020-10-08 | Wayne | Nebraska | 31179 | 211 | 0 |
610839 | 610839 | 2020-10-08 | Wayne | New York | 36117 | 347 | 3 |
610938 | 610938 | 2020-10-08 | Wayne | North Carolina | 37191 | 3712 | 73 |
611083 | 611083 | 2020-10-08 | Wayne | Ohio | 39169 | 1019 | 68 |
611263 | 611263 | 2020-10-08 | Wayne | Pennsylvania | 42127 | 260 | 12 |
611555 | 611555 | 2020-10-08 | Wayne | Tennessee | 47181 | 1538 | 6 |
611840 | 611840 | 2020-10-08 | Wayne | Utah | 49055 | 2 | 0 |
612082 | 612082 | 2020-10-08 | Wayne | West Virginia | 54099 | 425 | 10 |
606239 | 606239 | 2020-10-07 | Wayne | Georgia | 13305 | 1260 | 31 |
606393 | 606393 | 2020-10-07 | Wayne | Illinois | 17191 | 336 | 6 |
606488 | 606488 | 2020-10-07 | Wayne | Indiana | 18177 | 1233 | 16 |
606585 | 606585 | 2020-10-07 | Wayne | Iowa | 19185 | 97 | 3 |
606813 | 606813 | 2020-10-07 | Wayne | Kentucky | 21231 | 193 | 0 |
607022 | 607022 | 2020-10-07 | Wayne | Michigan | 26163 | 36402 | 3003 |
607188 | 607188 | 2020-10-07 | Wayne | Mississippi | 28153 | 942 | 21 |
607307 | 607307 | 2020-10-07 | Wayne | Missouri | 29223 | 241 | 0 |
607457 | 607457 | 2020-10-07 | Wayne | Nebraska | 31179 | 210 | 0 |
607597 | 607597 | 2020-10-07 | Wayne | New York | 36117 | 339 | 3 |
607696 | 607696 | 2020-10-07 | Wayne | North Carolina | 37191 | 3678 | 73 |
607841 | 607841 | 2020-10-07 | Wayne | Ohio | 39169 | 1005 | 68 |
608021 | 608021 | 2020-10-07 | Wayne | Pennsylvania | 42127 | 260 | 11 |
608313 | 608313 | 2020-10-07 | Wayne | Tennessee | 47181 | 1529 | 6 |
608598 | 608598 | 2020-10-07 | Wayne | Utah | 49055 | 2 | 0 |
608840 | 608840 | 2020-10-07 | Wayne | West Virginia | 54099 | 425 | 10 |
602997 | 602997 | 2020-10-06 | Wayne | Georgia | 13305 | 1255 | 31 |
603151 | 603151 | 2020-10-06 | Wayne | Illinois | 17191 | 328 | 6 |
603246 | 603246 | 2020-10-06 | Wayne | Indiana | 18177 | 1218 | 16 |
603343 | 603343 | 2020-10-06 | Wayne | Iowa | 19185 | 94 | 3 |
603571 | 603571 | 2020-10-06 | Wayne | Kentucky | 21231 | 189 | 0 |
603779 | 603779 | 2020-10-06 | Wayne | Michigan | 26163 | 36263 | 3004 |
603945 | 603945 | 2020-10-06 | Wayne | Mississippi | 28153 | 940 | 21 |
604064 | 604064 | 2020-10-06 | Wayne | Missouri | 29223 | 236 | 0 |
604214 | 604214 | 2020-10-06 | Wayne | Nebraska | 31179 | 207 | 0 |
604354 | 604354 | 2020-10-06 | Wayne | New York | 36117 | 337 | 3 |
604453 | 604453 | 2020-10-06 | Wayne | North Carolina | 37191 | 3620 | 73 |
604598 | 604598 | 2020-10-06 | Wayne | Ohio | 39169 | 989 | 68 |
604778 | 604778 | 2020-10-06 | Wayne | Pennsylvania | 42127 | 257 | 11 |
605070 | 605070 | 2020-10-06 | Wayne | Tennessee | 47181 | 1527 | 6 |
605355 | 605355 | 2020-10-06 | Wayne | Utah | 49055 | 2 | 0 |
605597 | 605597 | 2020-10-06 | Wayne | West Virginia | 54099 | 426 | 10 |
599754 | 599754 | 2020-10-05 | Wayne | Georgia | 13305 | 1252 | 31 |
599908 | 599908 | 2020-10-05 | Wayne | Illinois | 17191 | 325 | 6 |
600003 | 600003 | 2020-10-05 | Wayne | Indiana | 18177 | 1211 | 16 |
600100 | 600100 | 2020-10-05 | Wayne | Iowa | 19185 | 94 | 3 |
600328 | 600328 | 2020-10-05 | Wayne | Kentucky | 21231 | 186 | 0 |
600537 | 600537 | 2020-10-05 | Wayne | Michigan | 26163 | 36078 | 3000 |
600703 | 600703 | 2020-10-05 | Wayne | Mississippi | 28153 | 934 | 21 |
600822 | 600822 | 2020-10-05 | Wayne | Missouri | 29223 | 232 | 0 |
600972 | 600972 | 2020-10-05 | Wayne | Nebraska | 31179 | 206 | 0 |
601112 | 601112 | 2020-10-05 | Wayne | New York | 36117 | 335 | 3 |
601211 | 601211 | 2020-10-05 | Wayne | North Carolina | 37191 | 3582 | 71 |
601356 | 601356 | 2020-10-05 | Wayne | Ohio | 39169 | 981 | 68 |
601536 | 601536 | 2020-10-05 | Wayne | Pennsylvania | 42127 | 256 | 11 |
601828 | 601828 | 2020-10-05 | Wayne | Tennessee | 47181 | 1521 | 6 |
602113 | 602113 | 2020-10-05 | Wayne | Utah | 49055 | 2 | 0 |
602355 | 602355 | 2020-10-05 | Wayne | West Virginia | 54099 | 421 | 10 |
596511 | 596511 | 2020-10-04 | Wayne | Georgia | 13305 | 1156 | 31 |
596666 | 596666 | 2020-10-04 | Wayne | Illinois | 17191 | 317 | 5 |
596761 | 596761 | 2020-10-04 | Wayne | Indiana | 18177 | 1199 | 15 |
596858 | 596858 | 2020-10-04 | Wayne | Iowa | 19185 | 91 | 3 |
597086 | 597086 | 2020-10-04 | Wayne | Kentucky | 21231 | 185 | 0 |
597294 | 597294 | 2020-10-04 | Wayne | Michigan | 26163 | 35888 | 2997 |
597460 | 597460 | 2020-10-04 | Wayne | Mississippi | 28153 | 929 | 21 |
597579 | 597579 | 2020-10-04 | Wayne | Missouri | 29223 | 232 | 0 |
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);