ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Gates" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111072 | 2111072 | 2022-01-13 | Gates | North Carolina | 37073 | 1395 | 18 |
2107820 | 2107820 | 2022-01-12 | Gates | North Carolina | 37073 | 1372 | 18 |
2104569 | 2104569 | 2022-01-11 | Gates | North Carolina | 37073 | 1354 | 18 |
2101318 | 2101318 | 2022-01-10 | Gates | North Carolina | 37073 | 1339 | 18 |
2098067 | 2098067 | 2022-01-09 | Gates | North Carolina | 37073 | 1307 | 18 |
2094815 | 2094815 | 2022-01-08 | Gates | North Carolina | 37073 | 1307 | 18 |
2091563 | 2091563 | 2022-01-07 | Gates | North Carolina | 37073 | 1307 | 18 |
2088312 | 2088312 | 2022-01-06 | Gates | North Carolina | 37073 | 1296 | 18 |
2085060 | 2085060 | 2022-01-05 | Gates | North Carolina | 37073 | 1277 | 18 |
2081808 | 2081808 | 2022-01-04 | Gates | North Carolina | 37073 | 1262 | 18 |
2078556 | 2078556 | 2022-01-03 | Gates | North Carolina | 37073 | 1262 | 18 |
2075305 | 2075305 | 2022-01-02 | Gates | North Carolina | 37073 | 1237 | 18 |
2072054 | 2072054 | 2022-01-01 | Gates | North Carolina | 37073 | 1237 | 18 |
2068803 | 2068803 | 2021-12-31 | Gates | North Carolina | 37073 | 1237 | 18 |
2065552 | 2065552 | 2021-12-30 | Gates | North Carolina | 37073 | 1223 | 18 |
2062302 | 2062302 | 2021-12-29 | Gates | North Carolina | 37073 | 1216 | 18 |
2059053 | 2059053 | 2021-12-28 | Gates | North Carolina | 37073 | 1215 | 18 |
2055804 | 2055804 | 2021-12-27 | Gates | North Carolina | 37073 | 1192 | 18 |
2052554 | 2052554 | 2021-12-26 | Gates | North Carolina | 37073 | 1192 | 18 |
2049304 | 2049304 | 2021-12-25 | Gates | North Carolina | 37073 | 1192 | 18 |
2046054 | 2046054 | 2021-12-24 | Gates | North Carolina | 37073 | 1192 | 18 |
2042804 | 2042804 | 2021-12-23 | Gates | North Carolina | 37073 | 1192 | 18 |
2039555 | 2039555 | 2021-12-22 | Gates | North Carolina | 37073 | 1192 | 18 |
2036305 | 2036305 | 2021-12-21 | Gates | North Carolina | 37073 | 1190 | 18 |
2033055 | 2033055 | 2021-12-20 | Gates | North Carolina | 37073 | 1188 | 18 |
2029805 | 2029805 | 2021-12-19 | Gates | North Carolina | 37073 | 1185 | 18 |
2026554 | 2026554 | 2021-12-18 | Gates | North Carolina | 37073 | 1185 | 18 |
2023303 | 2023303 | 2021-12-17 | Gates | North Carolina | 37073 | 1185 | 18 |
2020052 | 2020052 | 2021-12-16 | Gates | North Carolina | 37073 | 1182 | 18 |
2016801 | 2016801 | 2021-12-15 | Gates | North Carolina | 37073 | 1179 | 18 |
2013551 | 2013551 | 2021-12-14 | Gates | North Carolina | 37073 | 1177 | 18 |
2010300 | 2010300 | 2021-12-13 | Gates | North Carolina | 37073 | 1173 | 18 |
2007049 | 2007049 | 2021-12-12 | Gates | North Carolina | 37073 | 1161 | 18 |
2003798 | 2003798 | 2021-12-11 | Gates | North Carolina | 37073 | 1161 | 18 |
2000547 | 2000547 | 2021-12-10 | Gates | North Carolina | 37073 | 1161 | 18 |
1997297 | 1997297 | 2021-12-09 | Gates | North Carolina | 37073 | 1158 | 18 |
1994046 | 1994046 | 2021-12-08 | Gates | North Carolina | 37073 | 1156 | 18 |
1990795 | 1990795 | 2021-12-07 | Gates | North Carolina | 37073 | 1150 | 18 |
1987544 | 1987544 | 2021-12-06 | Gates | North Carolina | 37073 | 1145 | 18 |
1984294 | 1984294 | 2021-12-05 | Gates | North Carolina | 37073 | 1141 | 18 |
1981044 | 1981044 | 2021-12-04 | Gates | North Carolina | 37073 | 1141 | 18 |
1977794 | 1977794 | 2021-12-03 | Gates | North Carolina | 37073 | 1141 | 18 |
1974544 | 1974544 | 2021-12-02 | Gates | North Carolina | 37073 | 1139 | 18 |
1971295 | 1971295 | 2021-12-01 | Gates | North Carolina | 37073 | 1139 | 18 |
1968045 | 1968045 | 2021-11-30 | Gates | North Carolina | 37073 | 1137 | 18 |
1964794 | 1964794 | 2021-11-29 | Gates | North Carolina | 37073 | 1137 | 18 |
1961542 | 1961542 | 2021-11-28 | Gates | North Carolina | 37073 | 1133 | 18 |
1958291 | 1958291 | 2021-11-27 | Gates | North Carolina | 37073 | 1133 | 18 |
1955040 | 1955040 | 2021-11-26 | Gates | North Carolina | 37073 | 1133 | 18 |
1951789 | 1951789 | 2021-11-25 | Gates | North Carolina | 37073 | 1133 | 18 |
1948538 | 1948538 | 2021-11-24 | Gates | North Carolina | 37073 | 1133 | 18 |
1945287 | 1945287 | 2021-11-23 | Gates | North Carolina | 37073 | 1128 | 18 |
1942036 | 1942036 | 2021-11-22 | Gates | North Carolina | 37073 | 1128 | 18 |
1938786 | 1938786 | 2021-11-21 | Gates | North Carolina | 37073 | 1124 | 18 |
1935536 | 1935536 | 2021-11-20 | Gates | North Carolina | 37073 | 1124 | 18 |
1932286 | 1932286 | 2021-11-19 | Gates | North Carolina | 37073 | 1124 | 18 |
1929035 | 1929035 | 2021-11-18 | Gates | North Carolina | 37073 | 1119 | 18 |
1925785 | 1925785 | 2021-11-17 | Gates | North Carolina | 37073 | 1118 | 18 |
1922536 | 1922536 | 2021-11-16 | Gates | North Carolina | 37073 | 1116 | 18 |
1919286 | 1919286 | 2021-11-15 | Gates | North Carolina | 37073 | 1115 | 18 |
1916036 | 1916036 | 2021-11-14 | Gates | North Carolina | 37073 | 1111 | 18 |
1912786 | 1912786 | 2021-11-13 | Gates | North Carolina | 37073 | 1111 | 18 |
1909536 | 1909536 | 2021-11-12 | Gates | North Carolina | 37073 | 1111 | 18 |
1906287 | 1906287 | 2021-11-11 | Gates | North Carolina | 37073 | 1109 | 18 |
1903038 | 1903038 | 2021-11-10 | Gates | North Carolina | 37073 | 1109 | 18 |
1899788 | 1899788 | 2021-11-09 | Gates | North Carolina | 37073 | 1108 | 18 |
1896538 | 1896538 | 2021-11-08 | Gates | North Carolina | 37073 | 1106 | 18 |
1893288 | 1893288 | 2021-11-07 | Gates | North Carolina | 37073 | 1100 | 18 |
1890038 | 1890038 | 2021-11-06 | Gates | North Carolina | 37073 | 1100 | 18 |
1886788 | 1886788 | 2021-11-05 | Gates | North Carolina | 37073 | 1100 | 18 |
1883539 | 1883539 | 2021-11-04 | Gates | North Carolina | 37073 | 1099 | 18 |
1880290 | 1880290 | 2021-11-03 | Gates | North Carolina | 37073 | 1096 | 18 |
1877041 | 1877041 | 2021-11-02 | Gates | North Carolina | 37073 | 1089 | 18 |
1873792 | 1873792 | 2021-11-01 | Gates | North Carolina | 37073 | 1089 | 18 |
1870543 | 1870543 | 2021-10-31 | Gates | North Carolina | 37073 | 1088 | 19 |
1867294 | 1867294 | 2021-10-30 | Gates | North Carolina | 37073 | 1088 | 19 |
1864045 | 1864045 | 2021-10-29 | Gates | North Carolina | 37073 | 1088 | 19 |
1860796 | 1860796 | 2021-10-28 | Gates | North Carolina | 37073 | 1087 | 19 |
1857547 | 1857547 | 2021-10-27 | Gates | North Carolina | 37073 | 1086 | 19 |
1854298 | 1854298 | 2021-10-26 | Gates | North Carolina | 37073 | 1085 | 19 |
1851049 | 1851049 | 2021-10-25 | Gates | North Carolina | 37073 | 1082 | 19 |
1847799 | 1847799 | 2021-10-24 | Gates | North Carolina | 37073 | 1077 | 19 |
1844549 | 1844549 | 2021-10-23 | Gates | North Carolina | 37073 | 1077 | 19 |
1841299 | 1841299 | 2021-10-22 | Gates | North Carolina | 37073 | 1077 | 19 |
1838050 | 1838050 | 2021-10-21 | Gates | North Carolina | 37073 | 1076 | 19 |
1834801 | 1834801 | 2021-10-20 | Gates | North Carolina | 37073 | 1073 | 19 |
1831552 | 1831552 | 2021-10-19 | Gates | North Carolina | 37073 | 1071 | 18 |
1828303 | 1828303 | 2021-10-18 | Gates | North Carolina | 37073 | 1066 | 18 |
1825054 | 1825054 | 2021-10-17 | Gates | North Carolina | 37073 | 1059 | 18 |
1821805 | 1821805 | 2021-10-16 | Gates | North Carolina | 37073 | 1059 | 18 |
1818556 | 1818556 | 2021-10-15 | Gates | North Carolina | 37073 | 1059 | 18 |
1815307 | 1815307 | 2021-10-14 | Gates | North Carolina | 37073 | 1056 | 18 |
1812059 | 1812059 | 2021-10-13 | Gates | North Carolina | 37073 | 1054 | 18 |
1808810 | 1808810 | 2021-10-12 | Gates | North Carolina | 37073 | 1047 | 18 |
1805559 | 1805559 | 2021-10-11 | Gates | North Carolina | 37073 | 1042 | 18 |
1802310 | 1802310 | 2021-10-10 | Gates | North Carolina | 37073 | 1025 | 17 |
1799061 | 1799061 | 2021-10-09 | Gates | North Carolina | 37073 | 1025 | 17 |
1795812 | 1795812 | 2021-10-08 | Gates | North Carolina | 37073 | 1025 | 17 |
1792563 | 1792563 | 2021-10-07 | Gates | North Carolina | 37073 | 1021 | 17 |
1789314 | 1789314 | 2021-10-06 | Gates | North Carolina | 37073 | 1013 | 17 |
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);