ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where county = "New York City" 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 |
---|---|---|---|---|---|---|---|
2111006 | 2111006 | 2022-01-13 | New York City | New York | 2038543 | 36374 | |
2107754 | 2107754 | 2022-01-12 | New York City | New York | 2005338 | 36224 | |
2104503 | 2104503 | 2022-01-11 | New York City | New York | 1978014 | 36089 | |
2101252 | 2101252 | 2022-01-10 | New York City | New York | 1949382 | 35906 | |
2098001 | 2098001 | 2022-01-09 | New York City | New York | 1914011 | 35883 | |
2094749 | 2094749 | 2022-01-08 | New York City | New York | 1871370 | 35793 | |
2091497 | 2091497 | 2022-01-07 | New York City | New York | 1823779 | 35793 | |
2088246 | 2088246 | 2022-01-06 | New York City | New York | 1779501 | 35683 | |
2084994 | 2084994 | 2022-01-05 | New York City | New York | 1737167 | 35605 | |
2081742 | 2081742 | 2022-01-04 | New York City | New York | 1697200 | 35514 | |
2078490 | 2078490 | 2022-01-03 | New York City | New York | 1668333 | 35463 | |
2075239 | 2075239 | 2022-01-02 | New York City | New York | 1630332 | 35448 | |
2071988 | 2071988 | 2022-01-01 | New York City | New York | 1594682 | 35402 | |
2068737 | 2068737 | 2021-12-31 | New York City | New York | 1549341 | 35382 | |
2065486 | 2065486 | 2021-12-30 | New York City | New York | 1503957 | 35349 | |
2062236 | 2062236 | 2021-12-29 | New York City | New York | 1463101 | 35304 | |
2058987 | 2058987 | 2021-12-28 | New York City | New York | 1430241 | 35204 | |
2055738 | 2055738 | 2021-12-27 | New York City | New York | 1394411 | 35200 | |
2052488 | 2052488 | 2021-12-26 | New York City | New York | 1372339 | 35151 | |
2049238 | 2049238 | 2021-12-25 | New York City | New York | 1317511 | 35151 | |
2045988 | 2045988 | 2021-12-24 | New York City | New York | 1317511 | 35151 | |
2042738 | 2042738 | 2021-12-23 | New York City | New York | 1302298 | 35151 | |
2039489 | 2039489 | 2021-12-22 | New York City | New York | 1284470 | 35126 | |
2036239 | 2036239 | 2021-12-21 | New York City | New York | 1267713 | 35100 | |
2032989 | 2032989 | 2021-12-20 | New York City | New York | 1249755 | 35067 | |
2029739 | 2029739 | 2021-12-19 | New York City | New York | 1237462 | 35066 | |
2026488 | 2026488 | 2021-12-18 | New York City | New York | 1219276 | 35045 | |
2023237 | 2023237 | 2021-12-17 | New York City | New York | 1219276 | 35045 | |
2019986 | 2019986 | 2021-12-16 | New York City | New York | 1209454 | 35020 | |
2016735 | 2016735 | 2021-12-15 | New York City | New York | 1201892 | 35016 | |
2013485 | 2013485 | 2021-12-14 | New York City | New York | 1197369 | 34992 | |
2010234 | 2010234 | 2021-12-13 | New York City | New York | 1193580 | 34971 | |
2006983 | 2006983 | 2021-12-12 | New York City | New York | 1183680 | 34956 | |
2003732 | 2003732 | 2021-12-11 | New York City | New York | 1183680 | 34956 | |
2000481 | 2000481 | 2021-12-10 | New York City | New York | 1183680 | 34956 | |
1997231 | 1997231 | 2021-12-09 | New York City | New York | 1180458 | 34940 | |
1993980 | 1993980 | 2021-12-08 | New York City | New York | 1177016 | 34925 | |
1990729 | 1990729 | 2021-12-07 | New York City | New York | 1175008 | 34905 | |
1987478 | 1987478 | 2021-12-06 | New York City | New York | 1172522 | 34883 | |
1984228 | 1984228 | 2021-12-05 | New York City | New York | 1165550 | 34867 | |
1980978 | 1980978 | 2021-12-04 | New York City | New York | 1165550 | 34867 | |
1977728 | 1977728 | 2021-12-03 | New York City | New York | 1165550 | 34867 | |
1974478 | 1974478 | 2021-12-02 | New York City | New York | 1163161 | 34856 | |
1971229 | 1971229 | 2021-12-01 | New York City | New York | 1160766 | 34848 | |
1967979 | 1967979 | 2021-11-30 | New York City | New York | 1159083 | 34828 | |
1964728 | 1964728 | 2021-11-29 | New York City | New York | 1157609 | 34808 | |
1961476 | 1961476 | 2021-11-28 | New York City | New York | 1153447 | 34794 | |
1958225 | 1958225 | 2021-11-27 | New York City | New York | 1153447 | 34794 | |
1954974 | 1954974 | 2021-11-26 | New York City | New York | 1153447 | 34794 | |
1951723 | 1951723 | 2021-11-25 | New York City | New York | 1150184 | 34773 | |
1948472 | 1948472 | 2021-11-24 | New York City | New York | 1150184 | 34773 | |
1945221 | 1945221 | 2021-11-23 | New York City | New York | 1148868 | 34757 | |
1941970 | 1941970 | 2021-11-22 | New York City | New York | 1147379 | 34747 | |
1938720 | 1938720 | 2021-11-21 | New York City | New York | 1146157 | 34747 | |
1935470 | 1935470 | 2021-11-20 | New York City | New York | 1142844 | 34738 | |
1932220 | 1932220 | 2021-11-19 | New York City | New York | 1142844 | 34738 | |
1928969 | 1928969 | 2021-11-18 | New York City | New York | 1141269 | 34725 | |
1925719 | 1925719 | 2021-11-17 | New York City | New York | 1139671 | 34717 | |
1922470 | 1922470 | 2021-11-16 | New York City | New York | 1138567 | 34705 | |
1919220 | 1919220 | 2021-11-15 | New York City | New York | 1137465 | 34688 | |
1915970 | 1915970 | 2021-11-14 | New York City | New York | 1133838 | 34679 | |
1912720 | 1912720 | 2021-11-13 | New York City | New York | 1133838 | 34679 | |
1909470 | 1909470 | 2021-11-12 | New York City | New York | 1133838 | 34679 | |
1906221 | 1906221 | 2021-11-11 | New York City | New York | 1132591 | 34665 | |
1902972 | 1902972 | 2021-11-10 | New York City | New York | 1131209 | 34659 | |
1899722 | 1899722 | 2021-11-09 | New York City | New York | 1130334 | 34647 | |
1896472 | 1896472 | 2021-11-08 | New York City | New York | 1129381 | 34634 | |
1893222 | 1893222 | 2021-11-07 | New York City | New York | 1126321 | 34621 | |
1889972 | 1889972 | 2021-11-06 | New York City | New York | 1126321 | 34621 | |
1886722 | 1886722 | 2021-11-05 | New York City | New York | 1126321 | 34621 | |
1883473 | 1883473 | 2021-11-04 | New York City | New York | 1125344 | 34602 | |
1880224 | 1880224 | 2021-11-03 | New York City | New York | 1124370 | 34601 | |
1876975 | 1876975 | 2021-11-02 | New York City | New York | 1123586 | 34589 | |
1873726 | 1873726 | 2021-11-01 | New York City | New York | 1122970 | 34580 | |
1870477 | 1870477 | 2021-10-31 | New York City | New York | 1119470 | 34557 | |
1867228 | 1867228 | 2021-10-30 | New York City | New York | 1119470 | 34557 | |
1863979 | 1863979 | 2021-10-29 | New York City | New York | 1119470 | 34557 | |
1860730 | 1860730 | 2021-10-28 | New York City | New York | 1117924 | 34544 | |
1857481 | 1857481 | 2021-10-27 | New York City | New York | 1117924 | 34544 | |
1854232 | 1854232 | 2021-10-26 | New York City | New York | 1117283 | 34533 | |
1850983 | 1850983 | 2021-10-25 | New York City | New York | 1116428 | 34531 | |
1847733 | 1847733 | 2021-10-24 | New York City | New York | 1113762 | 34502 | |
1844483 | 1844483 | 2021-10-23 | New York City | New York | 1113762 | 34502 | |
1841233 | 1841233 | 2021-10-22 | New York City | New York | 1113762 | 34502 | |
1837984 | 1837984 | 2021-10-21 | New York City | New York | 1112797 | 34483 | |
1834735 | 1834735 | 2021-10-20 | New York City | New York | 1111610 | 34480 | |
1831486 | 1831486 | 2021-10-19 | New York City | New York | 1110370 | 34467 | |
1828237 | 1828237 | 2021-10-18 | New York City | New York | 1108926 | 34460 | |
1824988 | 1824988 | 2021-10-17 | New York City | New York | 1105853 | 34438 | |
1821739 | 1821739 | 2021-10-16 | New York City | New York | 1105853 | 34438 | |
1818490 | 1818490 | 2021-10-15 | New York City | New York | 1105853 | 34438 | |
1815241 | 1815241 | 2021-10-14 | New York City | New York | 1103818 | 34442 | |
1811993 | 1811993 | 2021-10-13 | New York City | New York | 1102649 | 34434 | |
1808744 | 1808744 | 2021-10-12 | New York City | New York | 1101644 | 34402 | |
1805493 | 1805493 | 2021-10-11 | New York City | New York | 1100739 | 34384 | |
1802244 | 1802244 | 2021-10-10 | New York City | New York | 1096640 | 34355 | |
1798995 | 1798995 | 2021-10-09 | New York City | New York | 1096640 | 34355 | |
1795746 | 1795746 | 2021-10-08 | New York City | New York | 1096640 | 34355 | |
1792497 | 1792497 | 2021-10-07 | New York City | New York | 1095144 | 34333 | |
1789248 | 1789248 | 2021-10-06 | New York City | New York | 1093220 | 34334 |
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);