ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Monroe" and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111003 | 2111003 | 2022-01-13 | Monroe | New York | 36055 | 132655 | 1386 |
2107751 | 2107751 | 2022-01-12 | Monroe | New York | 36055 | 131210 | 1379 |
2104500 | 2104500 | 2022-01-11 | Monroe | New York | 36055 | 129692 | 1376 |
2101249 | 2101249 | 2022-01-10 | Monroe | New York | 36055 | 128761 | 1372 |
2097998 | 2097998 | 2022-01-09 | Monroe | New York | 36055 | 127633 | 1371 |
2094746 | 2094746 | 2022-01-08 | Monroe | New York | 36055 | 125928 | 1369 |
2091494 | 2091494 | 2022-01-07 | Monroe | New York | 36055 | 123693 | 1366 |
2088243 | 2088243 | 2022-01-06 | Monroe | New York | 36055 | 121595 | 1360 |
2084991 | 2084991 | 2022-01-05 | Monroe | New York | 36055 | 119547 | 1358 |
2081739 | 2081739 | 2022-01-04 | Monroe | New York | 36055 | 117798 | 1356 |
2078487 | 2078487 | 2022-01-03 | Monroe | New York | 36055 | 117028 | 1354 |
2075236 | 2075236 | 2022-01-02 | Monroe | New York | 36055 | 116229 | 1353 |
2071985 | 2071985 | 2022-01-01 | Monroe | New York | 36055 | 115241 | 1352 |
2068734 | 2068734 | 2021-12-31 | Monroe | New York | 36055 | 113677 | 1349 |
2065483 | 2065483 | 2021-12-30 | Monroe | New York | 36055 | 112312 | 1346 |
2062233 | 2062233 | 2021-12-29 | Monroe | New York | 36055 | 111022 | 1344 |
2058984 | 2058984 | 2021-12-28 | Monroe | New York | 36055 | 109990 | 1338 |
2055735 | 2055735 | 2021-12-27 | Monroe | New York | 36055 | 109701 | 1334 |
2052485 | 2052485 | 2021-12-26 | Monroe | New York | 36055 | 109438 | 1321 |
2049235 | 2049235 | 2021-12-25 | Monroe | New York | 36055 | 108555 | 1319 |
2045985 | 2045985 | 2021-12-24 | Monroe | New York | 36055 | 108555 | 1319 |
2042735 | 2042735 | 2021-12-23 | Monroe | New York | 36055 | 108044 | 1315 |
2039486 | 2039486 | 2021-12-22 | Monroe | New York | 36055 | 107495 | 1309 |
2036236 | 2036236 | 2021-12-21 | Monroe | New York | 36055 | 107009 | 1307 |
2032986 | 2032986 | 2021-12-20 | Monroe | New York | 36055 | 106766 | 1304 |
2029736 | 2029736 | 2021-12-19 | Monroe | New York | 36055 | 106460 | 1299 |
2026485 | 2026485 | 2021-12-18 | Monroe | New York | 36055 | 106086 | 1297 |
2023234 | 2023234 | 2021-12-17 | Monroe | New York | 36055 | 105603 | 1296 |
2019983 | 2019983 | 2021-12-16 | Monroe | New York | 36055 | 105132 | 1291 |
2016732 | 2016732 | 2021-12-15 | Monroe | New York | 36055 | 104711 | 1289 |
2013482 | 2013482 | 2021-12-14 | Monroe | New York | 36055 | 104331 | 1283 |
2010231 | 2010231 | 2021-12-13 | Monroe | New York | 36055 | 104069 | 1282 |
2006980 | 2006980 | 2021-12-12 | Monroe | New York | 36055 | 103794 | 1280 |
2003729 | 2003729 | 2021-12-11 | Monroe | New York | 36055 | 103401 | 1276 |
2000478 | 2000478 | 2021-12-10 | Monroe | New York | 36055 | 103053 | 1275 |
1997228 | 1997228 | 2021-12-09 | Monroe | New York | 36055 | 102529 | 1271 |
1993977 | 1993977 | 2021-12-08 | Monroe | New York | 36055 | 101905 | 1270 |
1990726 | 1990726 | 2021-12-07 | Monroe | New York | 36055 | 101435 | 1267 |
1987475 | 1987475 | 2021-12-06 | Monroe | New York | 36055 | 101005 | 1265 |
1984225 | 1984225 | 2021-12-05 | Monroe | New York | 36055 | 100650 | 1262 |
1980975 | 1980975 | 2021-12-04 | Monroe | New York | 36055 | 100150 | 1259 |
1977725 | 1977725 | 2021-12-03 | Monroe | New York | 36055 | 99511 | 1257 |
1974475 | 1974475 | 2021-12-02 | Monroe | New York | 36055 | 98937 | 1257 |
1971226 | 1971226 | 2021-12-01 | Monroe | New York | 36055 | 98225 | 1256 |
1967976 | 1967976 | 2021-11-30 | Monroe | New York | 36055 | 97659 | 1253 |
1964725 | 1964725 | 2021-11-29 | Monroe | New York | 36055 | 97296 | 1251 |
1961473 | 1961473 | 2021-11-28 | Monroe | New York | 36055 | 96982 | 1248 |
1958222 | 1958222 | 2021-11-27 | Monroe | New York | 36055 | 96727 | 1246 |
1954971 | 1954971 | 2021-11-26 | Monroe | New York | 36055 | 96418 | 1244 |
1951720 | 1951720 | 2021-11-25 | Monroe | New York | 36055 | 96019 | 1244 |
1948469 | 1948469 | 2021-11-24 | Monroe | New York | 36055 | 95456 | 1243 |
1945218 | 1945218 | 2021-11-23 | Monroe | New York | 36055 | 95017 | 1241 |
1941967 | 1941967 | 2021-11-22 | Monroe | New York | 36055 | 94695 | 1239 |
1938717 | 1938717 | 2021-11-21 | Monroe | New York | 36055 | 94311 | 1234 |
1935467 | 1935467 | 2021-11-20 | Monroe | New York | 36055 | 93822 | 1234 |
1932217 | 1932217 | 2021-11-19 | Monroe | New York | 36055 | 93378 | 1233 |
1928966 | 1928966 | 2021-11-18 | Monroe | New York | 36055 | 92915 | 1233 |
1925716 | 1925716 | 2021-11-17 | Monroe | New York | 36055 | 92362 | 1231 |
1922467 | 1922467 | 2021-11-16 | Monroe | New York | 36055 | 91980 | 1230 |
1919217 | 1919217 | 2021-11-15 | Monroe | New York | 36055 | 91610 | 1229 |
1915967 | 1915967 | 2021-11-14 | Monroe | New York | 36055 | 91267 | 1227 |
1912717 | 1912717 | 2021-11-13 | Monroe | New York | 36055 | 90875 | 1226 |
1909467 | 1909467 | 2021-11-12 | Monroe | New York | 36055 | 90395 | 1223 |
1906218 | 1906218 | 2021-11-11 | Monroe | New York | 36055 | 89895 | 1222 |
1902969 | 1902969 | 2021-11-10 | Monroe | New York | 36055 | 89422 | 1220 |
1899719 | 1899719 | 2021-11-09 | Monroe | New York | 36055 | 89031 | 1219 |
1896469 | 1896469 | 2021-11-08 | Monroe | New York | 36055 | 88778 | 1216 |
1893219 | 1893219 | 2021-11-07 | Monroe | New York | 36055 | 88522 | 1213 |
1889969 | 1889969 | 2021-11-06 | Monroe | New York | 36055 | 88123 | 1213 |
1886719 | 1886719 | 2021-11-05 | Monroe | New York | 36055 | 87761 | 1209 |
1883470 | 1883470 | 2021-11-04 | Monroe | New York | 36055 | 87446 | 1206 |
1880221 | 1880221 | 2021-11-03 | Monroe | New York | 36055 | 87080 | 1205 |
1876972 | 1876972 | 2021-11-02 | Monroe | New York | 36055 | 86835 | 1202 |
1873723 | 1873723 | 2021-11-01 | Monroe | New York | 36055 | 86670 | 1202 |
1870474 | 1870474 | 2021-10-31 | Monroe | New York | 36055 | 86489 | 1199 |
1867225 | 1867225 | 2021-10-30 | Monroe | New York | 36055 | 86230 | 1198 |
1863976 | 1863976 | 2021-10-29 | Monroe | New York | 36055 | 85994 | 1196 |
1860727 | 1860727 | 2021-10-28 | Monroe | New York | 36055 | 85674 | 1194 |
1857478 | 1857478 | 2021-10-27 | Monroe | New York | 36055 | 85442 | 1191 |
1854229 | 1854229 | 2021-10-26 | Monroe | New York | 36055 | 85205 | 1189 |
1850980 | 1850980 | 2021-10-25 | Monroe | New York | 36055 | 85121 | 1189 |
1847730 | 1847730 | 2021-10-24 | Monroe | New York | 36055 | 84942 | 1189 |
1844480 | 1844480 | 2021-10-23 | Monroe | New York | 36055 | 84785 | 1189 |
1841230 | 1841230 | 2021-10-22 | Monroe | New York | 36055 | 84533 | 1188 |
1837981 | 1837981 | 2021-10-21 | Monroe | New York | 36055 | 84298 | 1188 |
1834732 | 1834732 | 2021-10-20 | Monroe | New York | 36055 | 84046 | 1184 |
1831483 | 1831483 | 2021-10-19 | Monroe | New York | 36055 | 83831 | 1183 |
1828234 | 1828234 | 2021-10-18 | Monroe | New York | 36055 | 83709 | 1182 |
1824985 | 1824985 | 2021-10-17 | Monroe | New York | 36055 | 83520 | 1180 |
1821736 | 1821736 | 2021-10-16 | Monroe | New York | 36055 | 83300 | 1179 |
1818487 | 1818487 | 2021-10-15 | Monroe | New York | 36055 | 83034 | 1179 |
1815238 | 1815238 | 2021-10-14 | Monroe | New York | 36055 | 82768 | 1178 |
1811990 | 1811990 | 2021-10-13 | Monroe | New York | 36055 | 82481 | 1178 |
1808741 | 1808741 | 2021-10-12 | Monroe | New York | 36055 | 82259 | 1177 |
1805490 | 1805490 | 2021-10-11 | Monroe | New York | 36055 | 82092 | 1175 |
1802241 | 1802241 | 2021-10-10 | Monroe | New York | 36055 | 81835 | 1173 |
1798992 | 1798992 | 2021-10-09 | Monroe | New York | 36055 | 81721 | 1172 |
1795743 | 1795743 | 2021-10-08 | Monroe | New York | 36055 | 81504 | 1172 |
1792494 | 1792494 | 2021-10-07 | Monroe | New York | 36055 | 81251 | 1171 |
1789245 | 1789245 | 2021-10-06 | Monroe | New York | 36055 | 80975 | 1169 |
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);