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 15
- Pennsylvania 126
- Michigan 121
- North Carolina 119
- New York 113
- Indiana 112
- Ohio 107
- Kentucky 106
- Tennessee 102
- Mississippi 98
- Georgia 96
- West Virginia 92
- Nebraska 90
- Illinois 83
- Iowa 69
- Missouri 19
fips 15
county 1
- Wayne · 1,453 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
317251 | 317251 | 2020-07-09 | Wayne | Nebraska | 31179 | 31 | 0 |
317388 | 317388 | 2020-07-09 | Wayne | New York | 36117 | 195 | 1 |
317487 | 317487 | 2020-07-09 | Wayne | North Carolina | 37191 | 1942 | 30 |
317628 | 317628 | 2020-07-09 | Wayne | Ohio | 39169 | 367 | 52 |
317806 | 317806 | 2020-07-09 | Wayne | Pennsylvania | 42127 | 141 | 8 |
318095 | 318095 | 2020-07-09 | Wayne | Tennessee | 47181 | 99 | 0 |
318612 | 318612 | 2020-07-09 | Wayne | West Virginia | 54099 | 121 | 9 |
312901 | 312901 | 2020-07-08 | Wayne | Georgia | 13305 | 122 | 0 |
313053 | 313053 | 2020-07-08 | Wayne | Illinois | 17191 | 15 | 1 |
313148 | 313148 | 2020-07-08 | Wayne | Indiana | 18177 | 321 | 6 |
313245 | 313245 | 2020-07-08 | Wayne | Iowa | 19185 | 10 | 0 |
313465 | 313465 | 2020-07-08 | Wayne | Kentucky | 21231 | 22 | 0 |
313674 | 313674 | 2020-07-08 | Wayne | Michigan | 26163 | 23621 | 2745 |
313839 | 313839 | 2020-07-08 | Wayne | Mississippi | 28153 | 551 | 16 |
313958 | 313958 | 2020-07-08 | Wayne | Missouri | 29223 | 5 | 0 |
314077 | 314077 | 2020-07-08 | Wayne | Nebraska | 31179 | 28 | 0 |
314214 | 314214 | 2020-07-08 | Wayne | New York | 36117 | 193 | 1 |
314313 | 314313 | 2020-07-08 | Wayne | North Carolina | 37191 | 1935 | 30 |
314455 | 314455 | 2020-07-08 | Wayne | Ohio | 39169 | 365 | 52 |
314633 | 314633 | 2020-07-08 | Wayne | Pennsylvania | 42127 | 141 | 8 |
314922 | 314922 | 2020-07-08 | Wayne | Tennessee | 47181 | 90 | 0 |
315439 | 315439 | 2020-07-08 | Wayne | West Virginia | 54099 | 120 | 9 |
309731 | 309731 | 2020-07-07 | Wayne | Georgia | 13305 | 119 | 0 |
309883 | 309883 | 2020-07-07 | Wayne | Illinois | 17191 | 15 | 1 |
309978 | 309978 | 2020-07-07 | Wayne | Indiana | 18177 | 320 | 6 |
310075 | 310075 | 2020-07-07 | Wayne | Iowa | 19185 | 10 | 0 |
310295 | 310295 | 2020-07-07 | Wayne | Kentucky | 21231 | 20 | 0 |
310504 | 310504 | 2020-07-07 | Wayne | Michigan | 26163 | 23459 | 2743 |
310669 | 310669 | 2020-07-07 | Wayne | Mississippi | 28153 | 545 | 15 |
310787 | 310787 | 2020-07-07 | Wayne | Missouri | 29223 | 5 | 0 |
310906 | 310906 | 2020-07-07 | Wayne | Nebraska | 31179 | 28 | 0 |
311043 | 311043 | 2020-07-07 | Wayne | New York | 36117 | 191 | 1 |
311142 | 311142 | 2020-07-07 | Wayne | North Carolina | 37191 | 1926 | 29 |
311283 | 311283 | 2020-07-07 | Wayne | Ohio | 39169 | 363 | 52 |
311461 | 311461 | 2020-07-07 | Wayne | Pennsylvania | 42127 | 141 | 9 |
311748 | 311748 | 2020-07-07 | Wayne | Tennessee | 47181 | 89 | 0 |
312264 | 312264 | 2020-07-07 | Wayne | West Virginia | 54099 | 120 | 9 |
306563 | 306563 | 2020-07-06 | Wayne | Georgia | 13305 | 113 | 0 |
306715 | 306715 | 2020-07-06 | Wayne | Illinois | 17191 | 14 | 1 |
306810 | 306810 | 2020-07-06 | Wayne | Indiana | 18177 | 318 | 6 |
306907 | 306907 | 2020-07-06 | Wayne | Iowa | 19185 | 10 | 0 |
307127 | 307127 | 2020-07-06 | Wayne | Kentucky | 21231 | 20 | 0 |
307336 | 307336 | 2020-07-06 | Wayne | Michigan | 26163 | 23283 | 2732 |
307501 | 307501 | 2020-07-06 | Wayne | Mississippi | 28153 | 545 | 13 |
307619 | 307619 | 2020-07-06 | Wayne | Missouri | 29223 | 5 | 0 |
307738 | 307738 | 2020-07-06 | Wayne | Nebraska | 31179 | 28 | 0 |
307875 | 307875 | 2020-07-06 | Wayne | New York | 36117 | 186 | 1 |
307974 | 307974 | 2020-07-06 | Wayne | North Carolina | 37191 | 1913 | 28 |
308114 | 308114 | 2020-07-06 | Wayne | Ohio | 39169 | 363 | 51 |
308292 | 308292 | 2020-07-06 | Wayne | Pennsylvania | 42127 | 141 | 9 |
308579 | 308579 | 2020-07-06 | Wayne | Tennessee | 47181 | 88 | 0 |
309095 | 309095 | 2020-07-06 | Wayne | West Virginia | 54099 | 120 | 9 |
303399 | 303399 | 2020-07-05 | Wayne | Georgia | 13305 | 103 | 0 |
303550 | 303550 | 2020-07-05 | Wayne | Illinois | 17191 | 14 | 1 |
303645 | 303645 | 2020-07-05 | Wayne | Indiana | 18177 | 316 | 6 |
303742 | 303742 | 2020-07-05 | Wayne | Iowa | 19185 | 10 | 0 |
303960 | 303960 | 2020-07-05 | Wayne | Kentucky | 21231 | 16 | 0 |
304169 | 304169 | 2020-07-05 | Wayne | Michigan | 26163 | 23206 | 2730 |
304334 | 304334 | 2020-07-05 | Wayne | Mississippi | 28153 | 545 | 13 |
304452 | 304452 | 2020-07-05 | Wayne | Missouri | 29223 | 4 | 0 |
304571 | 304571 | 2020-07-05 | Wayne | Nebraska | 31179 | 28 | 0 |
304708 | 304708 | 2020-07-05 | Wayne | New York | 36117 | 185 | 1 |
304807 | 304807 | 2020-07-05 | Wayne | North Carolina | 37191 | 1897 | 28 |
304947 | 304947 | 2020-07-05 | Wayne | Ohio | 39169 | 362 | 51 |
305125 | 305125 | 2020-07-05 | Wayne | Pennsylvania | 42127 | 141 | 9 |
305411 | 305411 | 2020-07-05 | Wayne | Tennessee | 47181 | 86 | 0 |
305927 | 305927 | 2020-07-05 | Wayne | West Virginia | 54099 | 117 | 9 |
300235 | 300235 | 2020-07-04 | Wayne | Georgia | 13305 | 99 | 0 |
300386 | 300386 | 2020-07-04 | Wayne | Illinois | 17191 | 14 | 1 |
300481 | 300481 | 2020-07-04 | Wayne | Indiana | 18177 | 314 | 6 |
300578 | 300578 | 2020-07-04 | Wayne | Iowa | 19185 | 10 | 0 |
300796 | 300796 | 2020-07-04 | Wayne | Kentucky | 21231 | 16 | 0 |
301005 | 301005 | 2020-07-04 | Wayne | Michigan | 26163 | 23147 | 2730 |
301170 | 301170 | 2020-07-04 | Wayne | Mississippi | 28153 | 542 | 13 |
301288 | 301288 | 2020-07-04 | Wayne | Missouri | 29223 | 4 | 0 |
301408 | 301408 | 2020-07-04 | Wayne | Nebraska | 31179 | 28 | 0 |
301545 | 301545 | 2020-07-04 | Wayne | New York | 36117 | 183 | 1 |
301644 | 301644 | 2020-07-04 | Wayne | North Carolina | 37191 | 1879 | 28 |
301784 | 301784 | 2020-07-04 | Wayne | Ohio | 39169 | 360 | 51 |
301962 | 301962 | 2020-07-04 | Wayne | Pennsylvania | 42127 | 141 | 9 |
302247 | 302247 | 2020-07-04 | Wayne | Tennessee | 47181 | 82 | 0 |
302763 | 302763 | 2020-07-04 | Wayne | West Virginia | 54099 | 115 | 9 |
297073 | 297073 | 2020-07-03 | Wayne | Georgia | 13305 | 90 | 0 |
297224 | 297224 | 2020-07-03 | Wayne | Illinois | 17191 | 14 | 1 |
297319 | 297319 | 2020-07-03 | Wayne | Indiana | 18177 | 312 | 6 |
297416 | 297416 | 2020-07-03 | Wayne | Iowa | 19185 | 10 | 0 |
297634 | 297634 | 2020-07-03 | Wayne | Kentucky | 21231 | 16 | 0 |
297842 | 297842 | 2020-07-03 | Wayne | Michigan | 26163 | 23078 | 2730 |
298007 | 298007 | 2020-07-03 | Wayne | Mississippi | 28153 | 535 | 13 |
298125 | 298125 | 2020-07-03 | Wayne | Missouri | 29223 | 4 | 0 |
298245 | 298245 | 2020-07-03 | Wayne | Nebraska | 31179 | 28 | 0 |
298382 | 298382 | 2020-07-03 | Wayne | New York | 36117 | 181 | 1 |
298481 | 298481 | 2020-07-03 | Wayne | North Carolina | 37191 | 1864 | 28 |
298621 | 298621 | 2020-07-03 | Wayne | Ohio | 39169 | 359 | 51 |
298798 | 298798 | 2020-07-03 | Wayne | Pennsylvania | 42127 | 142 | 9 |
299083 | 299083 | 2020-07-03 | Wayne | Tennessee | 47181 | 82 | 0 |
299599 | 299599 | 2020-07-03 | Wayne | West Virginia | 54099 | 115 | 9 |
293917 | 293917 | 2020-07-02 | Wayne | Georgia | 13305 | 81 | 0 |
294066 | 294066 | 2020-07-02 | Wayne | Illinois | 17191 | 14 | 1 |
294161 | 294161 | 2020-07-02 | Wayne | Indiana | 18177 | 307 | 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);