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 county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2674 | 2674 | 2020-03-15 | Denton | Texas | 48121 | 1 | 0 |
3142 | 3142 | 2020-03-16 | Denton | Texas | 48121 | 1 | 0 |
3676 | 3676 | 2020-03-17 | Denton | Texas | 48121 | 1 | 0 |
4299 | 4299 | 2020-03-18 | Denton | Texas | 48121 | 5 | 0 |
5053 | 5053 | 2020-03-19 | Denton | Texas | 48121 | 9 | 0 |
5944 | 5944 | 2020-03-20 | Denton | Texas | 48121 | 15 | 0 |
6964 | 6964 | 2020-03-21 | Denton | Texas | 48121 | 24 | 0 |
8094 | 8094 | 2020-03-22 | Denton | Texas | 48121 | 30 | 0 |
9312 | 9312 | 2020-03-23 | Denton | Texas | 48121 | 36 | 0 |
10648 | 10648 | 2020-03-24 | Denton | Texas | 48121 | 38 | 0 |
12133 | 12133 | 2020-03-25 | Denton | Texas | 48121 | 70 | 0 |
13762 | 13762 | 2020-03-26 | Denton | Texas | 48121 | 83 | 1 |
15516 | 15516 | 2020-03-27 | Denton | Texas | 48121 | 137 | 1 |
17385 | 17385 | 2020-03-28 | Denton | Texas | 48121 | 148 | 2 |
19336 | 19336 | 2020-03-29 | Denton | Texas | 48121 | 165 | 2 |
21395 | 21395 | 2020-03-30 | Denton | Texas | 48121 | 191 | 3 |
23534 | 23534 | 2020-03-31 | Denton | Texas | 48121 | 206 | 4 |
25742 | 25742 | 2020-04-01 | Denton | Texas | 48121 | 231 | 4 |
28022 | 28022 | 2020-04-02 | Denton | Texas | 48121 | 254 | 5 |
30357 | 30357 | 2020-04-03 | Denton | Texas | 48121 | 273 | 6 |
32750 | 32750 | 2020-04-04 | Denton | Texas | 48121 | 288 | 6 |
35188 | 35188 | 2020-04-05 | Denton | Texas | 48121 | 304 | 7 |
37664 | 37664 | 2020-04-06 | Denton | Texas | 48121 | 337 | 7 |
40189 | 40189 | 2020-04-07 | Denton | Texas | 48121 | 366 | 7 |
42753 | 42753 | 2020-04-08 | Denton | Texas | 48121 | 398 | 7 |
45342 | 45342 | 2020-04-09 | Denton | Texas | 48121 | 426 | 9 |
47962 | 47962 | 2020-04-10 | Denton | Texas | 48121 | 426 | 9 |
50619 | 50619 | 2020-04-11 | Denton | Texas | 48121 | 454 | 10 |
53294 | 53294 | 2020-04-12 | Denton | Texas | 48121 | 482 | 13 |
55982 | 55982 | 2020-04-13 | Denton | Texas | 48121 | 507 | 13 |
58686 | 58686 | 2020-04-14 | Denton | Texas | 48121 | 521 | 14 |
61403 | 61403 | 2020-04-15 | Denton | Texas | 48121 | 521 | 14 |
64130 | 64130 | 2020-04-16 | Denton | Texas | 48121 | 564 | 15 |
66877 | 66877 | 2020-04-17 | Denton | Texas | 48121 | 585 | 15 |
69637 | 69637 | 2020-04-18 | Denton | Texas | 48121 | 592 | 16 |
72405 | 72405 | 2020-04-19 | Denton | Texas | 48121 | 593 | 16 |
75180 | 75180 | 2020-04-20 | Denton | Texas | 48121 | 598 | 17 |
77962 | 77962 | 2020-04-21 | Denton | Texas | 48121 | 619 | 18 |
80753 | 80753 | 2020-04-22 | Denton | Texas | 48121 | 644 | 19 |
83553 | 83553 | 2020-04-23 | Denton | Texas | 48121 | 661 | 19 |
86358 | 86358 | 2020-04-24 | Denton | Texas | 48121 | 661 | 19 |
89173 | 89173 | 2020-04-25 | Denton | Texas | 48121 | 702 | 20 |
91990 | 91990 | 2020-04-26 | Denton | Texas | 48121 | 713 | 20 |
94819 | 94819 | 2020-04-27 | Denton | Texas | 48121 | 725 | 20 |
97659 | 97659 | 2020-04-28 | Denton | Texas | 48121 | 738 | 20 |
100509 | 100509 | 2020-04-29 | Denton | Texas | 48121 | 748 | 20 |
103362 | 103362 | 2020-04-30 | Denton | Texas | 48121 | 765 | 21 |
106226 | 106226 | 2020-05-01 | Denton | Texas | 48121 | 786 | 22 |
109095 | 109095 | 2020-05-02 | Denton | Texas | 48121 | 799 | 22 |
111969 | 111969 | 2020-05-03 | Denton | Texas | 48121 | 803 | 22 |
114851 | 114851 | 2020-05-04 | Denton | Texas | 48121 | 806 | 22 |
117810 | 117810 | 2020-05-05 | Denton | Texas | 48121 | 832 | 22 |
120774 | 120774 | 2020-05-06 | Denton | Texas | 48121 | 846 | 22 |
123753 | 123753 | 2020-05-07 | Denton | Texas | 48121 | 872 | 23 |
126736 | 126736 | 2020-05-08 | Denton | Texas | 48121 | 902 | 25 |
129725 | 129725 | 2020-05-09 | Denton | Texas | 48121 | 914 | 25 |
132715 | 132715 | 2020-05-10 | Denton | Texas | 48121 | 922 | 25 |
135706 | 135706 | 2020-05-11 | Denton | Texas | 48121 | 946 | 25 |
138696 | 138696 | 2020-05-12 | Denton | Texas | 48121 | 968 | 25 |
141692 | 141692 | 2020-05-13 | Denton | Texas | 48121 | 989 | 25 |
144689 | 144689 | 2020-05-14 | Denton | Texas | 48121 | 1016 | 28 |
147691 | 147691 | 2020-05-15 | Denton | Texas | 48121 | 1040 | 28 |
150699 | 150699 | 2020-05-16 | Denton | Texas | 48121 | 1051 | 28 |
153710 | 153710 | 2020-05-17 | Denton | Texas | 48121 | 1069 | 28 |
156727 | 156727 | 2020-05-18 | Denton | Texas | 48121 | 1088 | 28 |
159749 | 159749 | 2020-05-19 | Denton | Texas | 48121 | 1116 | 28 |
162776 | 162776 | 2020-05-20 | Denton | Texas | 48121 | 1161 | 28 |
165805 | 165805 | 2020-05-21 | Denton | Texas | 48121 | 1188 | 29 |
168841 | 168841 | 2020-05-22 | Denton | Texas | 48121 | 1205 | 30 |
171880 | 171880 | 2020-05-23 | Denton | Texas | 48121 | 1212 | 30 |
174923 | 174923 | 2020-05-24 | Denton | Texas | 48121 | 1224 | 30 |
177967 | 177967 | 2020-05-25 | Denton | Texas | 48121 | 1233 | 30 |
181010 | 181010 | 2020-05-26 | Denton | Texas | 48121 | 1255 | 30 |
184060 | 184060 | 2020-05-27 | Denton | Texas | 48121 | 1285 | 30 |
187117 | 187117 | 2020-05-28 | Denton | Texas | 48121 | 1318 | 30 |
190181 | 190181 | 2020-05-29 | Denton | Texas | 48121 | 1329 | 30 |
193246 | 193246 | 2020-05-30 | Denton | Texas | 48121 | 1357 | 31 |
196316 | 196316 | 2020-05-31 | Denton | Texas | 48121 | 1373 | 31 |
199389 | 199389 | 2020-06-01 | Denton | Texas | 48121 | 1398 | 32 |
202464 | 202464 | 2020-06-02 | Denton | Texas | 48121 | 1416 | 32 |
205543 | 205543 | 2020-06-03 | Denton | Texas | 48121 | 1435 | 32 |
208625 | 208625 | 2020-06-04 | Denton | Texas | 48121 | 1454 | 32 |
211709 | 211709 | 2020-06-05 | Denton | Texas | 48121 | 1467 | 33 |
214796 | 214796 | 2020-06-06 | Denton | Texas | 48121 | 1486 | 33 |
217886 | 217886 | 2020-06-07 | Denton | Texas | 48121 | 1500 | 33 |
220978 | 220978 | 2020-06-08 | Denton | Texas | 48121 | 1524 | 34 |
224073 | 224073 | 2020-06-09 | Denton | Texas | 48121 | 1559 | 35 |
227173 | 227173 | 2020-06-10 | Denton | Texas | 48121 | 1599 | 36 |
230277 | 230277 | 2020-06-11 | Denton | Texas | 48121 | 1632 | 36 |
233381 | 233381 | 2020-06-12 | Denton | Texas | 48121 | 1687 | 36 |
236487 | 236487 | 2020-06-13 | Denton | Texas | 48121 | 1719 | 36 |
239595 | 239595 | 2020-06-14 | Denton | Texas | 48121 | 1736 | 36 |
242705 | 242705 | 2020-06-15 | Denton | Texas | 48121 | 1772 | 36 |
245817 | 245817 | 2020-06-16 | Denton | Texas | 48121 | 1812 | 36 |
248930 | 248930 | 2020-06-17 | Denton | Texas | 48121 | 1893 | 36 |
252045 | 252045 | 2020-06-18 | Denton | Texas | 48121 | 1980 | 36 |
255160 | 255160 | 2020-06-19 | Denton | Texas | 48121 | 2054 | 36 |
258287 | 258287 | 2020-06-20 | Denton | Texas | 48121 | 2113 | 36 |
261414 | 261414 | 2020-06-21 | Denton | Texas | 48121 | 2163 | 36 |
264542 | 264542 | 2020-06-22 | Denton | Texas | 48121 | 2219 | 36 |
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);