ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where fips = 48449 and state = "Texas" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
30449 | 30449 | 2020-04-03 | Titus | Texas | 48449 | 1 | 0 |
32845 | 32845 | 2020-04-04 | Titus | Texas | 48449 | 1 | 0 |
35283 | 35283 | 2020-04-05 | Titus | Texas | 48449 | 1 | 0 |
37760 | 37760 | 2020-04-06 | Titus | Texas | 48449 | 1 | 0 |
40289 | 40289 | 2020-04-07 | Titus | Texas | 48449 | 2 | 0 |
42857 | 42857 | 2020-04-08 | Titus | Texas | 48449 | 2 | 0 |
45451 | 45451 | 2020-04-09 | Titus | Texas | 48449 | 4 | 0 |
48074 | 48074 | 2020-04-10 | Titus | Texas | 48449 | 6 | 0 |
50732 | 50732 | 2020-04-11 | Titus | Texas | 48449 | 6 | 0 |
53407 | 53407 | 2020-04-12 | Titus | Texas | 48449 | 6 | 0 |
56096 | 56096 | 2020-04-13 | Titus | Texas | 48449 | 6 | 0 |
58801 | 58801 | 2020-04-14 | Titus | Texas | 48449 | 7 | 0 |
61519 | 61519 | 2020-04-15 | Titus | Texas | 48449 | 8 | 0 |
64251 | 64251 | 2020-04-16 | Titus | Texas | 48449 | 8 | 0 |
66998 | 66998 | 2020-04-17 | Titus | Texas | 48449 | 8 | 0 |
69758 | 69758 | 2020-04-18 | Titus | Texas | 48449 | 8 | 0 |
72528 | 72528 | 2020-04-19 | Titus | Texas | 48449 | 9 | 0 |
75304 | 75304 | 2020-04-20 | Titus | Texas | 48449 | 9 | 0 |
78086 | 78086 | 2020-04-21 | Titus | Texas | 48449 | 11 | 0 |
80877 | 80877 | 2020-04-22 | Titus | Texas | 48449 | 12 | 0 |
83678 | 83678 | 2020-04-23 | Titus | Texas | 48449 | 12 | 0 |
86485 | 86485 | 2020-04-24 | Titus | Texas | 48449 | 15 | 0 |
89300 | 89300 | 2020-04-25 | Titus | Texas | 48449 | 15 | 0 |
92117 | 92117 | 2020-04-26 | Titus | Texas | 48449 | 15 | 0 |
94946 | 94946 | 2020-04-27 | Titus | Texas | 48449 | 15 | 0 |
97788 | 97788 | 2020-04-28 | Titus | Texas | 48449 | 15 | 0 |
100638 | 100638 | 2020-04-29 | Titus | Texas | 48449 | 15 | 0 |
103493 | 103493 | 2020-04-30 | Titus | Texas | 48449 | 16 | 0 |
106357 | 106357 | 2020-05-01 | Titus | Texas | 48449 | 17 | 0 |
109226 | 109226 | 2020-05-02 | Titus | Texas | 48449 | 17 | 0 |
112100 | 112100 | 2020-05-03 | Titus | Texas | 48449 | 20 | 0 |
114983 | 114983 | 2020-05-04 | Titus | Texas | 48449 | 20 | 0 |
117942 | 117942 | 2020-05-05 | Titus | Texas | 48449 | 21 | 0 |
120906 | 120906 | 2020-05-06 | Titus | Texas | 48449 | 23 | 0 |
123886 | 123886 | 2020-05-07 | Titus | Texas | 48449 | 27 | 0 |
126871 | 126871 | 2020-05-08 | Titus | Texas | 48449 | 29 | 0 |
129860 | 129860 | 2020-05-09 | Titus | Texas | 48449 | 29 | 0 |
132850 | 132850 | 2020-05-10 | Titus | Texas | 48449 | 35 | 0 |
135841 | 135841 | 2020-05-11 | Titus | Texas | 48449 | 35 | 0 |
138831 | 138831 | 2020-05-12 | Titus | Texas | 48449 | 37 | 0 |
141827 | 141827 | 2020-05-13 | Titus | Texas | 48449 | 59 | 0 |
144824 | 144824 | 2020-05-14 | Titus | Texas | 48449 | 74 | 0 |
147828 | 147828 | 2020-05-15 | Titus | Texas | 48449 | 83 | 1 |
150836 | 150836 | 2020-05-16 | Titus | Texas | 48449 | 96 | 1 |
153847 | 153847 | 2020-05-17 | Titus | Texas | 48449 | 96 | 1 |
156864 | 156864 | 2020-05-18 | Titus | Texas | 48449 | 102 | 1 |
159888 | 159888 | 2020-05-19 | Titus | Texas | 48449 | 129 | 1 |
162916 | 162916 | 2020-05-20 | Titus | Texas | 48449 | 142 | 2 |
165945 | 165945 | 2020-05-21 | Titus | Texas | 48449 | 189 | 2 |
168981 | 168981 | 2020-05-22 | Titus | Texas | 48449 | 248 | 2 |
172021 | 172021 | 2020-05-23 | Titus | Texas | 48449 | 272 | 2 |
175064 | 175064 | 2020-05-24 | Titus | Texas | 48449 | 272 | 2 |
178109 | 178109 | 2020-05-25 | Titus | Texas | 48449 | 299 | 2 |
181153 | 181153 | 2020-05-26 | Titus | Texas | 48449 | 321 | 2 |
184204 | 184204 | 2020-05-27 | Titus | Texas | 48449 | 366 | 2 |
187261 | 187261 | 2020-05-28 | Titus | Texas | 48449 | 443 | 2 |
190325 | 190325 | 2020-05-29 | Titus | Texas | 48449 | 464 | 2 |
193391 | 193391 | 2020-05-30 | Titus | Texas | 48449 | 446 | 2 |
196461 | 196461 | 2020-05-31 | Titus | Texas | 48449 | 495 | 3 |
199534 | 199534 | 2020-06-01 | Titus | Texas | 48449 | 495 | 3 |
202610 | 202610 | 2020-06-02 | Titus | Texas | 48449 | 511 | 3 |
205689 | 205689 | 2020-06-03 | Titus | Texas | 48449 | 541 | 3 |
208771 | 208771 | 2020-06-04 | Titus | Texas | 48449 | 576 | 3 |
211856 | 211856 | 2020-06-05 | Titus | Texas | 48449 | 583 | 3 |
214943 | 214943 | 2020-06-06 | Titus | Texas | 48449 | 616 | 3 |
218033 | 218033 | 2020-06-07 | Titus | Texas | 48449 | 616 | 3 |
221125 | 221125 | 2020-06-08 | Titus | Texas | 48449 | 629 | 3 |
224221 | 224221 | 2020-06-09 | Titus | Texas | 48449 | 635 | 3 |
227321 | 227321 | 2020-06-10 | Titus | Texas | 48449 | 635 | 3 |
230425 | 230425 | 2020-06-11 | Titus | Texas | 48449 | 635 | 3 |
233529 | 233529 | 2020-06-12 | Titus | Texas | 48449 | 655 | 3 |
236636 | 236636 | 2020-06-13 | Titus | Texas | 48449 | 707 | 5 |
239744 | 239744 | 2020-06-14 | Titus | Texas | 48449 | 707 | 5 |
242854 | 242854 | 2020-06-15 | Titus | Texas | 48449 | 714 | 5 |
245966 | 245966 | 2020-06-16 | Titus | Texas | 48449 | 719 | 5 |
249079 | 249079 | 2020-06-17 | Titus | Texas | 48449 | 719 | 5 |
252194 | 252194 | 2020-06-18 | Titus | Texas | 48449 | 719 | 5 |
255310 | 255310 | 2020-06-19 | Titus | Texas | 48449 | 729 | 5 |
258437 | 258437 | 2020-06-20 | Titus | Texas | 48449 | 732 | 5 |
261564 | 261564 | 2020-06-21 | Titus | Texas | 48449 | 739 | 5 |
264693 | 264693 | 2020-06-22 | Titus | Texas | 48449 | 739 | 5 |
267822 | 267822 | 2020-06-23 | Titus | Texas | 48449 | 744 | 5 |
270956 | 270956 | 2020-06-24 | Titus | Texas | 48449 | 752 | 5 |
274096 | 274096 | 2020-06-25 | Titus | Texas | 48449 | 763 | 5 |
277244 | 277244 | 2020-06-26 | Titus | Texas | 48449 | 787 | 5 |
280392 | 280392 | 2020-06-27 | Titus | Texas | 48449 | 787 | 5 |
283538 | 283538 | 2020-06-28 | Titus | Texas | 48449 | 787 | 5 |
286684 | 286684 | 2020-06-29 | Titus | Texas | 48449 | 799 | 5 |
289834 | 289834 | 2020-06-30 | Titus | Texas | 48449 | 799 | 5 |
292987 | 292987 | 2020-07-01 | Titus | Texas | 48449 | 809 | 5 |
296142 | 296142 | 2020-07-02 | Titus | Texas | 48449 | 828 | 5 |
299304 | 299304 | 2020-07-03 | Titus | Texas | 48449 | 852 | 5 |
302468 | 302468 | 2020-07-04 | Titus | Texas | 48449 | 852 | 5 |
305632 | 305632 | 2020-07-05 | Titus | Texas | 48449 | 852 | 5 |
308800 | 308800 | 2020-07-06 | Titus | Texas | 48449 | 875 | 5 |
311969 | 311969 | 2020-07-07 | Titus | Texas | 48449 | 955 | 5 |
315143 | 315143 | 2020-07-08 | Titus | Texas | 48449 | 956 | 6 |
318316 | 318316 | 2020-07-09 | Titus | Texas | 48449 | 956 | 6 |
321495 | 321495 | 2020-07-10 | Titus | Texas | 48449 | 965 | 6 |
324676 | 324676 | 2020-07-11 | Titus | Texas | 48449 | 966 | 6 |
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);