ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Denton" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176884 | 2176884 | 2022-02-02 | Denton | Texas | 48121 | 165595 | 1193 |
2173630 | 2173630 | 2022-02-01 | Denton | Texas | 48121 | 164946 | 1186 |
2170378 | 2170378 | 2022-01-31 | Denton | Texas | 48121 | 162119 | 1179 |
2167124 | 2167124 | 2022-01-30 | Denton | Texas | 48121 | 160314 | 1179 |
2163869 | 2163869 | 2022-01-29 | Denton | Texas | 48121 | 160096 | 1173 |
2160614 | 2160614 | 2022-01-28 | Denton | Texas | 48121 | 160096 | 1170 |
2157358 | 2157358 | 2022-01-27 | Denton | Texas | 48121 | 158688 | 1164 |
2154105 | 2154105 | 2022-01-26 | Denton | Texas | 48121 | 157735 | 1158 |
2150853 | 2150853 | 2022-01-25 | Denton | Texas | 48121 | 155602 | 1149 |
2147601 | 2147601 | 2022-01-24 | Denton | Texas | 48121 | 154269 | 1145 |
2144347 | 2144347 | 2022-01-23 | Denton | Texas | 48121 | 153245 | 1139 |
2141092 | 2141092 | 2022-01-22 | Denton | Texas | 48121 | 151067 | 1137 |
2137836 | 2137836 | 2022-01-21 | Denton | Texas | 48121 | 149226 | 1130 |
2134582 | 2134582 | 2022-01-20 | Denton | Texas | 48121 | 147504 | 1128 |
2131330 | 2131330 | 2022-01-19 | Denton | Texas | 48121 | 146253 | 1127 |
2128076 | 2128076 | 2022-01-18 | Denton | Texas | 48121 | 144701 | 1124 |
2124824 | 2124824 | 2022-01-17 | Denton | Texas | 48121 | 142954 | 1119 |
2121572 | 2121572 | 2022-01-16 | Denton | Texas | 48121 | 140457 | 1119 |
2118320 | 2118320 | 2022-01-15 | Denton | Texas | 48121 | 139269 | 1117 |
2115069 | 2115069 | 2022-01-14 | Denton | Texas | 48121 | 136846 | 1113 |
2111817 | 2111817 | 2022-01-13 | Denton | Texas | 48121 | 138621 | 1113 |
2108565 | 2108565 | 2022-01-12 | Denton | Texas | 48121 | 136117 | 1108 |
2105314 | 2105314 | 2022-01-11 | Denton | Texas | 48121 | 133641 | 1103 |
2102063 | 2102063 | 2022-01-10 | Denton | Texas | 48121 | 131984 | 1101 |
2098812 | 2098812 | 2022-01-09 | Denton | Texas | 48121 | 130639 | 1101 |
2095560 | 2095560 | 2022-01-08 | Denton | Texas | 48121 | 129486 | 1100 |
2092308 | 2092308 | 2022-01-07 | Denton | Texas | 48121 | 127874 | 1096 |
2089056 | 2089056 | 2022-01-06 | Denton | Texas | 48121 | 126785 | 1094 |
2085805 | 2085805 | 2022-01-05 | Denton | Texas | 48121 | 124870 | 1093 |
2082553 | 2082553 | 2022-01-04 | Denton | Texas | 48121 | 123507 | 1093 |
2079301 | 2079301 | 2022-01-03 | Denton | Texas | 48121 | 121828 | 1093 |
2076050 | 2076050 | 2022-01-02 | Denton | Texas | 48121 | 116830 | 1088 |
2072799 | 2072799 | 2022-01-01 | Denton | Texas | 48121 | 116830 | 1088 |
2069548 | 2069548 | 2021-12-31 | Denton | Texas | 48121 | 116830 | 1088 |
2066297 | 2066297 | 2021-12-30 | Denton | Texas | 48121 | 116830 | 1088 |
2063047 | 2063047 | 2021-12-29 | Denton | Texas | 48121 | 116189 | 1085 |
2059797 | 2059797 | 2021-12-28 | Denton | Texas | 48121 | 115923 | 1085 |
2056548 | 2056548 | 2021-12-27 | Denton | Texas | 48121 | 115364 | 1083 |
2053299 | 2053299 | 2021-12-26 | Denton | Texas | 48121 | 114212 | 1081 |
2050049 | 2050049 | 2021-12-25 | Denton | Texas | 48121 | 114212 | 1081 |
2046799 | 2046799 | 2021-12-24 | Denton | Texas | 48121 | 114212 | 1081 |
2043549 | 2043549 | 2021-12-23 | Denton | Texas | 48121 | 114212 | 1081 |
2040300 | 2040300 | 2021-12-22 | Denton | Texas | 48121 | 114212 | 1079 |
2037050 | 2037050 | 2021-12-21 | Denton | Texas | 48121 | 113923 | 1079 |
2033800 | 2033800 | 2021-12-20 | Denton | Texas | 48121 | 113623 | 1079 |
2030550 | 2030550 | 2021-12-19 | Denton | Texas | 48121 | 113461 | 1079 |
2027299 | 2027299 | 2021-12-18 | Denton | Texas | 48121 | 113461 | 1079 |
2024048 | 2024048 | 2021-12-17 | Denton | Texas | 48121 | 113461 | 1078 |
2020797 | 2020797 | 2021-12-16 | Denton | Texas | 48121 | 113343 | 1077 |
2017546 | 2017546 | 2021-12-15 | Denton | Texas | 48121 | 113141 | 1077 |
2014296 | 2014296 | 2021-12-14 | Denton | Texas | 48121 | 112941 | 1074 |
2011045 | 2011045 | 2021-12-13 | Denton | Texas | 48121 | 112750 | 1074 |
2007794 | 2007794 | 2021-12-12 | Denton | Texas | 48121 | 112576 | 1074 |
2004543 | 2004543 | 2021-12-11 | Denton | Texas | 48121 | 112576 | 1074 |
2001292 | 2001292 | 2021-12-10 | Denton | Texas | 48121 | 112576 | 1073 |
1998042 | 1998042 | 2021-12-09 | Denton | Texas | 48121 | 112396 | 1072 |
1994791 | 1994791 | 2021-12-08 | Denton | Texas | 48121 | 112171 | 1070 |
1991540 | 1991540 | 2021-12-07 | Denton | Texas | 48121 | 111961 | 1069 |
1988289 | 1988289 | 2021-12-06 | Denton | Texas | 48121 | 111758 | 1068 |
1985039 | 1985039 | 2021-12-05 | Denton | Texas | 48121 | 111621 | 1068 |
1981789 | 1981789 | 2021-12-04 | Denton | Texas | 48121 | 111621 | 1066 |
1978539 | 1978539 | 2021-12-03 | Denton | Texas | 48121 | 111621 | 1066 |
1975289 | 1975289 | 2021-12-02 | Denton | Texas | 48121 | 111445 | 1065 |
1972040 | 1972040 | 2021-12-01 | Denton | Texas | 48121 | 111194 | 1062 |
1968790 | 1968790 | 2021-11-30 | Denton | Texas | 48121 | 110970 | 1059 |
1965539 | 1965539 | 2021-11-29 | Denton | Texas | 48121 | 110758 | 1057 |
1962287 | 1962287 | 2021-11-28 | Denton | Texas | 48121 | 110593 | 1052 |
1959036 | 1959036 | 2021-11-27 | Denton | Texas | 48121 | 110593 | 1052 |
1955785 | 1955785 | 2021-11-26 | Denton | Texas | 48121 | 110593 | 1052 |
1952534 | 1952534 | 2021-11-25 | Denton | Texas | 48121 | 110593 | 1052 |
1949283 | 1949283 | 2021-11-24 | Denton | Texas | 48121 | 110593 | 1052 |
1946032 | 1946032 | 2021-11-23 | Denton | Texas | 48121 | 110452 | 1046 |
1942781 | 1942781 | 2021-11-22 | Denton | Texas | 48121 | 110306 | 1044 |
1939531 | 1939531 | 2021-11-21 | Denton | Texas | 48121 | 110130 | 1044 |
1936281 | 1936281 | 2021-11-20 | Denton | Texas | 48121 | 110130 | 1043 |
1933031 | 1933031 | 2021-11-19 | Denton | Texas | 48121 | 110130 | 1043 |
1929780 | 1929780 | 2021-11-18 | Denton | Texas | 48121 | 109942 | 1041 |
1926530 | 1926530 | 2021-11-17 | Denton | Texas | 48121 | 109828 | 1038 |
1923280 | 1923280 | 2021-11-16 | Denton | Texas | 48121 | 109616 | 1038 |
1920031 | 1920031 | 2021-11-15 | Denton | Texas | 48121 | 109372 | 1035 |
1916781 | 1916781 | 2021-11-14 | Denton | Texas | 48121 | 109169 | 1035 |
1913531 | 1913531 | 2021-11-13 | Denton | Texas | 48121 | 109169 | 1034 |
1910281 | 1910281 | 2021-11-12 | Denton | Texas | 48121 | 109169 | 1032 |
1907032 | 1907032 | 2021-11-11 | Denton | Texas | 48121 | 108998 | 1030 |
1903783 | 1903783 | 2021-11-10 | Denton | Texas | 48121 | 108998 | 1025 |
1900533 | 1900533 | 2021-11-09 | Denton | Texas | 48121 | 108794 | 1025 |
1897283 | 1897283 | 2021-11-08 | Denton | Texas | 48121 | 108626 | 1024 |
1894033 | 1894033 | 2021-11-07 | Denton | Texas | 48121 | 108474 | 1023 |
1890783 | 1890783 | 2021-11-06 | Denton | Texas | 48121 | 108474 | 1022 |
1887533 | 1887533 | 2021-11-05 | Denton | Texas | 48121 | 108474 | 1018 |
1884283 | 1884283 | 2021-11-04 | Denton | Texas | 48121 | 108398 | 1016 |
1881034 | 1881034 | 2021-11-03 | Denton | Texas | 48121 | 108279 | 1015 |
1877785 | 1877785 | 2021-11-02 | Denton | Texas | 48121 | 108131 | 1015 |
1874536 | 1874536 | 2021-11-01 | Denton | Texas | 48121 | 107958 | 1014 |
1871287 | 1871287 | 2021-10-31 | Denton | Texas | 48121 | 107757 | 1014 |
1868038 | 1868038 | 2021-10-30 | Denton | Texas | 48121 | 107757 | 1013 |
1864789 | 1864789 | 2021-10-29 | Denton | Texas | 48121 | 107757 | 1012 |
1861540 | 1861540 | 2021-10-28 | Denton | Texas | 48121 | 107539 | 1009 |
1858291 | 1858291 | 2021-10-27 | Denton | Texas | 48121 | 107337 | 1005 |
1855042 | 1855042 | 2021-10-26 | Denton | Texas | 48121 | 107129 | 1002 |
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);