ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Wayne" and fips = 39169 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176345 | 2176345 | 2022-02-02 | Wayne | Ohio | 39169 | 22655 | 389 |
2173091 | 2173091 | 2022-02-01 | Wayne | Ohio | 39169 | 22605 | 389 |
2169839 | 2169839 | 2022-01-31 | Wayne | Ohio | 39169 | 22565 | 380 |
2166584 | 2166584 | 2022-01-30 | Wayne | Ohio | 39169 | 22524 | 380 |
2163329 | 2163329 | 2022-01-29 | Wayne | Ohio | 39169 | 22486 | 380 |
2160074 | 2160074 | 2022-01-28 | Wayne | Ohio | 39169 | 22424 | 380 |
2156819 | 2156819 | 2022-01-27 | Wayne | Ohio | 39169 | 22378 | 371 |
2153566 | 2153566 | 2022-01-26 | Wayne | Ohio | 39169 | 22281 | 371 |
2150314 | 2150314 | 2022-01-25 | Wayne | Ohio | 39169 | 22121 | 371 |
2147062 | 2147062 | 2022-01-24 | Wayne | Ohio | 39169 | 22093 | 365 |
2143808 | 2143808 | 2022-01-23 | Wayne | Ohio | 39169 | 22031 | 365 |
2140553 | 2140553 | 2022-01-22 | Wayne | Ohio | 39169 | 21965 | 365 |
2137297 | 2137297 | 2022-01-21 | Wayne | Ohio | 39169 | 21858 | 365 |
2134043 | 2134043 | 2022-01-20 | Wayne | Ohio | 39169 | 21740 | 356 |
2130791 | 2130791 | 2022-01-19 | Wayne | Ohio | 39169 | 21565 | 356 |
2127537 | 2127537 | 2022-01-18 | Wayne | Ohio | 39169 | 21380 | 356 |
2124285 | 2124285 | 2022-01-17 | Wayne | Ohio | 39169 | 21275 | 354 |
2121033 | 2121033 | 2022-01-16 | Wayne | Ohio | 39169 | 21166 | 354 |
2117781 | 2117781 | 2022-01-15 | Wayne | Ohio | 39169 | 21002 | 354 |
2114530 | 2114530 | 2022-01-14 | Wayne | Ohio | 39169 | 20573 | 354 |
2111278 | 2111278 | 2022-01-13 | Wayne | Ohio | 39169 | 20278 | 346 |
2108026 | 2108026 | 2022-01-12 | Wayne | Ohio | 39169 | 20132 | 346 |
2104775 | 2104775 | 2022-01-11 | Wayne | Ohio | 39169 | 19995 | 346 |
2101524 | 2101524 | 2022-01-10 | Wayne | Ohio | 39169 | 19788 | 343 |
2098273 | 2098273 | 2022-01-09 | Wayne | Ohio | 39169 | 19676 | 343 |
2095021 | 2095021 | 2022-01-08 | Wayne | Ohio | 39169 | 19483 | 343 |
2091769 | 2091769 | 2022-01-07 | Wayne | Ohio | 39169 | 19308 | 343 |
2088517 | 2088517 | 2022-01-06 | Wayne | Ohio | 39169 | 19189 | 336 |
2085266 | 2085266 | 2022-01-05 | Wayne | Ohio | 39169 | 18989 | 336 |
2082014 | 2082014 | 2022-01-04 | Wayne | Ohio | 39169 | 18772 | 336 |
2078762 | 2078762 | 2022-01-03 | Wayne | Ohio | 39169 | 18509 | 331 |
2075511 | 2075511 | 2022-01-02 | Wayne | Ohio | 39169 | 18359 | 331 |
2072260 | 2072260 | 2022-01-01 | Wayne | Ohio | 39169 | 18059 | 331 |
2069009 | 2069009 | 2021-12-31 | Wayne | Ohio | 39169 | 18059 | 331 |
2065758 | 2065758 | 2021-12-30 | Wayne | Ohio | 39169 | 17866 | 325 |
2062508 | 2062508 | 2021-12-29 | Wayne | Ohio | 39169 | 17780 | 325 |
2059258 | 2059258 | 2021-12-28 | Wayne | Ohio | 39169 | 17618 | 325 |
2056009 | 2056009 | 2021-12-27 | Wayne | Ohio | 39169 | 17478 | 325 |
2052760 | 2052760 | 2021-12-26 | Wayne | Ohio | 39169 | 17420 | 325 |
2049510 | 2049510 | 2021-12-25 | Wayne | Ohio | 39169 | 17264 | 325 |
2046260 | 2046260 | 2021-12-24 | Wayne | Ohio | 39169 | 17264 | 325 |
2043010 | 2043010 | 2021-12-23 | Wayne | Ohio | 39169 | 17193 | 319 |
2039761 | 2039761 | 2021-12-22 | Wayne | Ohio | 39169 | 17060 | 319 |
2036511 | 2036511 | 2021-12-21 | Wayne | Ohio | 39169 | 16975 | 319 |
2033261 | 2033261 | 2021-12-20 | Wayne | Ohio | 39169 | 16877 | 318 |
2030011 | 2030011 | 2021-12-19 | Wayne | Ohio | 39169 | 16837 | 318 |
2026760 | 2026760 | 2021-12-18 | Wayne | Ohio | 39169 | 16792 | 318 |
2023509 | 2023509 | 2021-12-17 | Wayne | Ohio | 39169 | 16735 | 318 |
2020258 | 2020258 | 2021-12-16 | Wayne | Ohio | 39169 | 16649 | 312 |
2017007 | 2017007 | 2021-12-15 | Wayne | Ohio | 39169 | 16589 | 312 |
2013757 | 2013757 | 2021-12-14 | Wayne | Ohio | 39169 | 16493 | 312 |
2010506 | 2010506 | 2021-12-13 | Wayne | Ohio | 39169 | 16418 | 311 |
2007255 | 2007255 | 2021-12-12 | Wayne | Ohio | 39169 | 16357 | 311 |
2004004 | 2004004 | 2021-12-11 | Wayne | Ohio | 39169 | 16324 | 311 |
2000753 | 2000753 | 2021-12-10 | Wayne | Ohio | 39169 | 16268 | 311 |
1997503 | 1997503 | 2021-12-09 | Wayne | Ohio | 39169 | 16183 | 307 |
1994252 | 1994252 | 2021-12-08 | Wayne | Ohio | 39169 | 16103 | 307 |
1991001 | 1991001 | 2021-12-07 | Wayne | Ohio | 39169 | 16008 | 307 |
1987750 | 1987750 | 2021-12-06 | Wayne | Ohio | 39169 | 15914 | 307 |
1984500 | 1984500 | 2021-12-05 | Wayne | Ohio | 39169 | 15873 | 307 |
1981250 | 1981250 | 2021-12-04 | Wayne | Ohio | 39169 | 15829 | 307 |
1978000 | 1978000 | 2021-12-03 | Wayne | Ohio | 39169 | 15740 | 307 |
1974750 | 1974750 | 2021-12-02 | Wayne | Ohio | 39169 | 15664 | 306 |
1971501 | 1971501 | 2021-12-01 | Wayne | Ohio | 39169 | 15562 | 306 |
1968251 | 1968251 | 2021-11-30 | Wayne | Ohio | 39169 | 15482 | 306 |
1965000 | 1965000 | 2021-11-29 | Wayne | Ohio | 39169 | 15432 | 304 |
1961748 | 1961748 | 2021-11-28 | Wayne | Ohio | 39169 | 15383 | 304 |
1958497 | 1958497 | 2021-11-27 | Wayne | Ohio | 39169 | 15351 | 304 |
1955246 | 1955246 | 2021-11-26 | Wayne | Ohio | 39169 | 15292 | 304 |
1951995 | 1951995 | 2021-11-25 | Wayne | Ohio | 39169 | 15202 | 304 |
1948744 | 1948744 | 2021-11-24 | Wayne | Ohio | 39169 | 15202 | 304 |
1945493 | 1945493 | 2021-11-23 | Wayne | Ohio | 39169 | 15135 | 304 |
1942242 | 1942242 | 2021-11-22 | Wayne | Ohio | 39169 | 15068 | 304 |
1938992 | 1938992 | 2021-11-21 | Wayne | Ohio | 39169 | 15026 | 304 |
1935742 | 1935742 | 2021-11-20 | Wayne | Ohio | 39169 | 14975 | 304 |
1932492 | 1932492 | 2021-11-19 | Wayne | Ohio | 39169 | 14918 | 304 |
1929241 | 1929241 | 2021-11-18 | Wayne | Ohio | 39169 | 14864 | 299 |
1925991 | 1925991 | 2021-11-17 | Wayne | Ohio | 39169 | 14791 | 299 |
1922741 | 1922741 | 2021-11-16 | Wayne | Ohio | 39169 | 14724 | 299 |
1919492 | 1919492 | 2021-11-15 | Wayne | Ohio | 39169 | 14650 | 293 |
1916242 | 1916242 | 2021-11-14 | Wayne | Ohio | 39169 | 14609 | 293 |
1912992 | 1912992 | 2021-11-13 | Wayne | Ohio | 39169 | 14577 | 293 |
1909742 | 1909742 | 2021-11-12 | Wayne | Ohio | 39169 | 14529 | 293 |
1906493 | 1906493 | 2021-11-11 | Wayne | Ohio | 39169 | 14488 | 289 |
1903244 | 1903244 | 2021-11-10 | Wayne | Ohio | 39169 | 14433 | 289 |
1899994 | 1899994 | 2021-11-09 | Wayne | Ohio | 39169 | 14373 | 289 |
1896744 | 1896744 | 2021-11-08 | Wayne | Ohio | 39169 | 14334 | 284 |
1893494 | 1893494 | 2021-11-07 | Wayne | Ohio | 39169 | 14305 | 284 |
1890244 | 1890244 | 2021-11-06 | Wayne | Ohio | 39169 | 14267 | 284 |
1886994 | 1886994 | 2021-11-05 | Wayne | Ohio | 39169 | 14257 | 284 |
1883744 | 1883744 | 2021-11-04 | Wayne | Ohio | 39169 | 14216 | 282 |
1880495 | 1880495 | 2021-11-03 | Wayne | Ohio | 39169 | 14174 | 282 |
1877246 | 1877246 | 2021-11-02 | Wayne | Ohio | 39169 | 14129 | 282 |
1873997 | 1873997 | 2021-11-01 | Wayne | Ohio | 39169 | 14085 | 279 |
1870748 | 1870748 | 2021-10-31 | Wayne | Ohio | 39169 | 14048 | 279 |
1867499 | 1867499 | 2021-10-30 | Wayne | Ohio | 39169 | 14030 | 279 |
1864250 | 1864250 | 2021-10-29 | Wayne | Ohio | 39169 | 13991 | 279 |
1861001 | 1861001 | 2021-10-28 | Wayne | Ohio | 39169 | 13962 | 275 |
1857752 | 1857752 | 2021-10-27 | Wayne | Ohio | 39169 | 13921 | 275 |
1854503 | 1854503 | 2021-10-26 | Wayne | Ohio | 39169 | 13888 | 275 |
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);