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 115
- Michigan 111
- North Carolina 108
- Indiana 102
- New York 102
- Kentucky 96
- Ohio 96
- Tennessee 91
- Mississippi 88
- Georgia 86
- West Virginia 81
- Nebraska 79
- Illinois 73
- Iowa 59
- Missouri 9
fips 15
county 1
- Wayne · 1,296 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281320 | 281320 | 2020-06-28 | Wayne | Georgia | 13305 | 57 | 0 |
281468 | 281468 | 2020-06-28 | Wayne | Illinois | 17191 | 12 | 1 |
281563 | 281563 | 2020-06-28 | Wayne | Indiana | 18177 | 302 | 6 |
281660 | 281660 | 2020-06-28 | Wayne | Iowa | 19185 | 8 | 0 |
281876 | 281876 | 2020-06-28 | Wayne | Kentucky | 21231 | 13 | 0 |
282084 | 282084 | 2020-06-28 | Wayne | Michigan | 26163 | 22645 | 2712 |
282249 | 282249 | 2020-06-28 | Wayne | Mississippi | 28153 | 499 | 10 |
282367 | 282367 | 2020-06-28 | Wayne | Missouri | 29223 | 3 | 0 |
282483 | 282483 | 2020-06-28 | Wayne | Nebraska | 31179 | 28 | 0 |
282620 | 282620 | 2020-06-28 | Wayne | New York | 36117 | 162 | 1 |
282719 | 282719 | 2020-06-28 | Wayne | North Carolina | 37191 | 1767 | 25 |
282859 | 282859 | 2020-06-28 | Wayne | Ohio | 39169 | 350 | 52 |
283035 | 283035 | 2020-06-28 | Wayne | Pennsylvania | 42127 | 139 | 9 |
283319 | 283319 | 2020-06-28 | Wayne | Tennessee | 47181 | 74 | 0 |
283833 | 283833 | 2020-06-28 | Wayne | West Virginia | 54099 | 111 | 9 |
278173 | 278173 | 2020-06-27 | Wayne | Georgia | 13305 | 55 | 0 |
278320 | 278320 | 2020-06-27 | Wayne | Illinois | 17191 | 12 | 1 |
278415 | 278415 | 2020-06-27 | Wayne | Indiana | 18177 | 298 | 6 |
278512 | 278512 | 2020-06-27 | Wayne | Iowa | 19185 | 8 | 0 |
278728 | 278728 | 2020-06-27 | Wayne | Kentucky | 21231 | 13 | 0 |
278936 | 278936 | 2020-06-27 | Wayne | Michigan | 26163 | 22603 | 2710 |
279101 | 279101 | 2020-06-27 | Wayne | Mississippi | 28153 | 468 | 10 |
279219 | 279219 | 2020-06-27 | Wayne | Missouri | 29223 | 3 | 0 |
279336 | 279336 | 2020-06-27 | Wayne | Nebraska | 31179 | 28 | 0 |
279474 | 279474 | 2020-06-27 | Wayne | New York | 36117 | 161 | 1 |
279573 | 279573 | 2020-06-27 | Wayne | North Carolina | 37191 | 1740 | 25 |
279713 | 279713 | 2020-06-27 | Wayne | Ohio | 39169 | 348 | 52 |
279889 | 279889 | 2020-06-27 | Wayne | Pennsylvania | 42127 | 138 | 9 |
280173 | 280173 | 2020-06-27 | Wayne | Tennessee | 47181 | 74 | 0 |
280687 | 280687 | 2020-06-27 | Wayne | West Virginia | 54099 | 110 | 9 |
275025 | 275025 | 2020-06-26 | Wayne | Georgia | 13305 | 53 | 0 |
275172 | 275172 | 2020-06-26 | Wayne | Illinois | 17191 | 12 | 1 |
275267 | 275267 | 2020-06-26 | Wayne | Indiana | 18177 | 297 | 6 |
275364 | 275364 | 2020-06-26 | Wayne | Iowa | 19185 | 7 | 0 |
275580 | 275580 | 2020-06-26 | Wayne | Kentucky | 21231 | 13 | 0 |
275788 | 275788 | 2020-06-26 | Wayne | Michigan | 26163 | 22503 | 2703 |
275953 | 275953 | 2020-06-26 | Wayne | Mississippi | 28153 | 462 | 10 |
276071 | 276071 | 2020-06-26 | Wayne | Missouri | 29223 | 3 | 0 |
276188 | 276188 | 2020-06-26 | Wayne | Nebraska | 31179 | 27 | 0 |
276326 | 276326 | 2020-06-26 | Wayne | New York | 36117 | 159 | 1 |
276425 | 276425 | 2020-06-26 | Wayne | North Carolina | 37191 | 1724 | 24 |
276565 | 276565 | 2020-06-26 | Wayne | Ohio | 39169 | 346 | 52 |
276741 | 276741 | 2020-06-26 | Wayne | Pennsylvania | 42127 | 138 | 9 |
277025 | 277025 | 2020-06-26 | Wayne | Tennessee | 47181 | 71 | 0 |
277539 | 277539 | 2020-06-26 | Wayne | West Virginia | 54099 | 110 | 9 |
271885 | 271885 | 2020-06-25 | Wayne | Georgia | 13305 | 52 | 0 |
272030 | 272030 | 2020-06-25 | Wayne | Illinois | 17191 | 12 | 1 |
272125 | 272125 | 2020-06-25 | Wayne | Indiana | 18177 | 293 | 6 |
272222 | 272222 | 2020-06-25 | Wayne | Iowa | 19185 | 7 | 0 |
272437 | 272437 | 2020-06-25 | Wayne | Kentucky | 21231 | 13 | 0 |
272645 | 272645 | 2020-06-25 | Wayne | Michigan | 26163 | 22476 | 2705 |
272810 | 272810 | 2020-06-25 | Wayne | Mississippi | 28153 | 461 | 9 |
272928 | 272928 | 2020-06-25 | Wayne | Missouri | 29223 | 3 | 0 |
273044 | 273044 | 2020-06-25 | Wayne | Nebraska | 31179 | 27 | 0 |
273180 | 273180 | 2020-06-25 | Wayne | New York | 36117 | 154 | 1 |
273279 | 273279 | 2020-06-25 | Wayne | North Carolina | 37191 | 1712 | 24 |
273418 | 273418 | 2020-06-25 | Wayne | Ohio | 39169 | 343 | 52 |
273594 | 273594 | 2020-06-25 | Wayne | Pennsylvania | 42127 | 133 | 9 |
273878 | 273878 | 2020-06-25 | Wayne | Tennessee | 47181 | 71 | 0 |
274391 | 274391 | 2020-06-25 | Wayne | West Virginia | 54099 | 110 | 9 |
268749 | 268749 | 2020-06-24 | Wayne | Georgia | 13305 | 51 | 0 |
268893 | 268893 | 2020-06-24 | Wayne | Illinois | 17191 | 11 | 1 |
268988 | 268988 | 2020-06-24 | Wayne | Indiana | 18177 | 290 | 6 |
269085 | 269085 | 2020-06-24 | Wayne | Iowa | 19185 | 7 | 0 |
269301 | 269301 | 2020-06-24 | Wayne | Kentucky | 21231 | 13 | 0 |
269508 | 269508 | 2020-06-24 | Wayne | Michigan | 26163 | 22347 | 2695 |
269672 | 269672 | 2020-06-24 | Wayne | Mississippi | 28153 | 446 | 8 |
269790 | 269790 | 2020-06-24 | Wayne | Missouri | 29223 | 3 | 0 |
269905 | 269905 | 2020-06-24 | Wayne | Nebraska | 31179 | 27 | 0 |
270041 | 270041 | 2020-06-24 | Wayne | New York | 36117 | 150 | 1 |
270140 | 270140 | 2020-06-24 | Wayne | North Carolina | 37191 | 1703 | 24 |
270279 | 270279 | 2020-06-24 | Wayne | Ohio | 39169 | 338 | 52 |
270455 | 270455 | 2020-06-24 | Wayne | Pennsylvania | 42127 | 131 | 9 |
270739 | 270739 | 2020-06-24 | Wayne | Tennessee | 47181 | 69 | 0 |
271251 | 271251 | 2020-06-24 | Wayne | West Virginia | 54099 | 108 | 9 |
265619 | 265619 | 2020-06-23 | Wayne | Georgia | 13305 | 49 | 0 |
265763 | 265763 | 2020-06-23 | Wayne | Illinois | 17191 | 11 | 1 |
265858 | 265858 | 2020-06-23 | Wayne | Indiana | 18177 | 281 | 6 |
265955 | 265955 | 2020-06-23 | Wayne | Iowa | 19185 | 6 | 0 |
266168 | 266168 | 2020-06-23 | Wayne | Kentucky | 21231 | 13 | 0 |
266375 | 266375 | 2020-06-23 | Wayne | Michigan | 26163 | 22268 | 2692 |
266539 | 266539 | 2020-06-23 | Wayne | Mississippi | 28153 | 441 | 8 |
266657 | 266657 | 2020-06-23 | Wayne | Missouri | 29223 | 3 | 0 |
266770 | 266770 | 2020-06-23 | Wayne | Nebraska | 31179 | 26 | 0 |
266907 | 266907 | 2020-06-23 | Wayne | New York | 36117 | 145 | 1 |
267006 | 267006 | 2020-06-23 | Wayne | North Carolina | 37191 | 1673 | 23 |
267145 | 267145 | 2020-06-23 | Wayne | Ohio | 39169 | 332 | 52 |
267321 | 267321 | 2020-06-23 | Wayne | Pennsylvania | 42127 | 131 | 9 |
267605 | 267605 | 2020-06-23 | Wayne | Tennessee | 47181 | 67 | 0 |
268117 | 268117 | 2020-06-23 | Wayne | West Virginia | 54099 | 107 | 9 |
262491 | 262491 | 2020-06-22 | Wayne | Georgia | 13305 | 48 | 0 |
262635 | 262635 | 2020-06-22 | Wayne | Illinois | 17191 | 11 | 1 |
262730 | 262730 | 2020-06-22 | Wayne | Indiana | 18177 | 281 | 6 |
262827 | 262827 | 2020-06-22 | Wayne | Iowa | 19185 | 5 | 0 |
263041 | 263041 | 2020-06-22 | Wayne | Kentucky | 21231 | 12 | 0 |
263249 | 263249 | 2020-06-22 | Wayne | Michigan | 26163 | 22203 | 2691 |
263413 | 263413 | 2020-06-22 | Wayne | Mississippi | 28153 | 434 | 8 |
263531 | 263531 | 2020-06-22 | Wayne | Missouri | 29223 | 1 | 0 |
263643 | 263643 | 2020-06-22 | Wayne | Nebraska | 31179 | 26 | 0 |
263779 | 263779 | 2020-06-22 | Wayne | New York | 36117 | 143 | 1 |
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);