ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 48039 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324477 | 324477 | 2020-07-11 | Brazoria | Texas | 48039 | 3358 | 25 |
321296 | 321296 | 2020-07-10 | Brazoria | Texas | 48039 | 3272 | 24 |
318118 | 318118 | 2020-07-09 | Brazoria | Texas | 48039 | 3146 | 24 |
314945 | 314945 | 2020-07-08 | Brazoria | Texas | 48039 | 3036 | 23 |
311771 | 311771 | 2020-07-07 | Brazoria | Texas | 48039 | 2925 | 22 |
308602 | 308602 | 2020-07-06 | Brazoria | Texas | 48039 | 2829 | 22 |
305434 | 305434 | 2020-07-05 | Brazoria | Texas | 48039 | 2715 | 22 |
302270 | 302270 | 2020-07-04 | Brazoria | Texas | 48039 | 2626 | 22 |
299106 | 299106 | 2020-07-03 | Brazoria | Texas | 48039 | 2516 | 22 |
295946 | 295946 | 2020-07-02 | Brazoria | Texas | 48039 | 2438 | 22 |
292791 | 292791 | 2020-07-01 | Brazoria | Texas | 48039 | 2336 | 21 |
289638 | 289638 | 2020-06-30 | Brazoria | Texas | 48039 | 2269 | 21 |
286488 | 286488 | 2020-06-29 | Brazoria | Texas | 48039 | 2217 | 21 |
283342 | 283342 | 2020-06-28 | Brazoria | Texas | 48039 | 2161 | 21 |
280196 | 280196 | 2020-06-27 | Brazoria | Texas | 48039 | 2064 | 21 |
277048 | 277048 | 2020-06-26 | Brazoria | Texas | 48039 | 1986 | 20 |
273901 | 273901 | 2020-06-25 | Brazoria | Texas | 48039 | 1913 | 19 |
270762 | 270762 | 2020-06-24 | Brazoria | Texas | 48039 | 1838 | 19 |
267628 | 267628 | 2020-06-23 | Brazoria | Texas | 48039 | 1814 | 19 |
264500 | 264500 | 2020-06-22 | Brazoria | Texas | 48039 | 1762 | 19 |
261372 | 261372 | 2020-06-21 | Brazoria | Texas | 48039 | 1728 | 19 |
258245 | 258245 | 2020-06-20 | Brazoria | Texas | 48039 | 1669 | 19 |
255119 | 255119 | 2020-06-19 | Brazoria | Texas | 48039 | 1609 | 18 |
252004 | 252004 | 2020-06-18 | Brazoria | Texas | 48039 | 1558 | 18 |
248889 | 248889 | 2020-06-17 | Brazoria | Texas | 48039 | 1525 | 18 |
245776 | 245776 | 2020-06-16 | Brazoria | Texas | 48039 | 1495 | 18 |
242664 | 242664 | 2020-06-15 | Brazoria | Texas | 48039 | 1184 | 18 |
239554 | 239554 | 2020-06-14 | Brazoria | Texas | 48039 | 1151 | 17 |
236446 | 236446 | 2020-06-13 | Brazoria | Texas | 48039 | 1109 | 16 |
233340 | 233340 | 2020-06-12 | Brazoria | Texas | 48039 | 1095 | 16 |
230236 | 230236 | 2020-06-11 | Brazoria | Texas | 48039 | 1058 | 16 |
227132 | 227132 | 2020-06-10 | Brazoria | Texas | 48039 | 1035 | 16 |
224032 | 224032 | 2020-06-09 | Brazoria | Texas | 48039 | 1015 | 14 |
220937 | 220937 | 2020-06-08 | Brazoria | Texas | 48039 | 990 | 13 |
217845 | 217845 | 2020-06-07 | Brazoria | Texas | 48039 | 1003 | 14 |
214755 | 214755 | 2020-06-06 | Brazoria | Texas | 48039 | 990 | 13 |
211668 | 211668 | 2020-06-05 | Brazoria | Texas | 48039 | 990 | 13 |
208585 | 208585 | 2020-06-04 | Brazoria | Texas | 48039 | 967 | 12 |
205503 | 205503 | 2020-06-03 | Brazoria | Texas | 48039 | 957 | 12 |
202424 | 202424 | 2020-06-02 | Brazoria | Texas | 48039 | 941 | 12 |
199349 | 199349 | 2020-06-01 | Brazoria | Texas | 48039 | 929 | 12 |
196276 | 196276 | 2020-05-31 | Brazoria | Texas | 48039 | 917 | 12 |
193206 | 193206 | 2020-05-30 | Brazoria | Texas | 48039 | 907 | 12 |
190141 | 190141 | 2020-05-29 | Brazoria | Texas | 48039 | 894 | 12 |
187077 | 187077 | 2020-05-28 | Brazoria | Texas | 48039 | 882 | 12 |
184020 | 184020 | 2020-05-27 | Brazoria | Texas | 48039 | 861 | 12 |
180970 | 180970 | 2020-05-26 | Brazoria | Texas | 48039 | 853 | 12 |
177927 | 177927 | 2020-05-25 | Brazoria | Texas | 48039 | 843 | 12 |
174883 | 174883 | 2020-05-24 | Brazoria | Texas | 48039 | 838 | 12 |
171840 | 171840 | 2020-05-23 | Brazoria | Texas | 48039 | 835 | 12 |
168801 | 168801 | 2020-05-22 | Brazoria | Texas | 48039 | 825 | 12 |
165765 | 165765 | 2020-05-21 | Brazoria | Texas | 48039 | 816 | 11 |
162736 | 162736 | 2020-05-20 | Brazoria | Texas | 48039 | 805 | 11 |
159709 | 159709 | 2020-05-19 | Brazoria | Texas | 48039 | 795 | 11 |
156687 | 156687 | 2020-05-18 | Brazoria | Texas | 48039 | 786 | 11 |
153670 | 153670 | 2020-05-17 | Brazoria | Texas | 48039 | 767 | 11 |
150659 | 150659 | 2020-05-16 | Brazoria | Texas | 48039 | 727 | 10 |
147651 | 147651 | 2020-05-15 | Brazoria | Texas | 48039 | 721 | 9 |
144649 | 144649 | 2020-05-14 | Brazoria | Texas | 48039 | 712 | 9 |
141652 | 141652 | 2020-05-13 | Brazoria | Texas | 48039 | 710 | 9 |
138656 | 138656 | 2020-05-12 | Brazoria | Texas | 48039 | 686 | 9 |
135666 | 135666 | 2020-05-11 | Brazoria | Texas | 48039 | 673 | 9 |
132675 | 132675 | 2020-05-10 | Brazoria | Texas | 48039 | 661 | 9 |
129685 | 129685 | 2020-05-09 | Brazoria | Texas | 48039 | 656 | 9 |
126696 | 126696 | 2020-05-08 | Brazoria | Texas | 48039 | 644 | 9 |
123713 | 123713 | 2020-05-07 | Brazoria | Texas | 48039 | 613 | 8 |
120734 | 120734 | 2020-05-06 | Brazoria | Texas | 48039 | 588 | 7 |
117770 | 117770 | 2020-05-05 | Brazoria | Texas | 48039 | 570 | 7 |
114813 | 114813 | 2020-05-04 | Brazoria | Texas | 48039 | 566 | 7 |
111931 | 111931 | 2020-05-03 | Brazoria | Texas | 48039 | 551 | 6 |
109057 | 109057 | 2020-05-02 | Brazoria | Texas | 48039 | 542 | 6 |
106190 | 106190 | 2020-05-01 | Brazoria | Texas | 48039 | 537 | 6 |
103327 | 103327 | 2020-04-30 | Brazoria | Texas | 48039 | 509 | 6 |
100474 | 100474 | 2020-04-29 | Brazoria | Texas | 48039 | 485 | 6 |
97624 | 97624 | 2020-04-28 | Brazoria | Texas | 48039 | 476 | 6 |
94784 | 94784 | 2020-04-27 | Brazoria | Texas | 48039 | 464 | 5 |
91956 | 91956 | 2020-04-26 | Brazoria | Texas | 48039 | 449 | 3 |
89139 | 89139 | 2020-04-25 | Brazoria | Texas | 48039 | 445 | 3 |
86324 | 86324 | 2020-04-24 | Brazoria | Texas | 48039 | 417 | 3 |
83519 | 83519 | 2020-04-23 | Brazoria | Texas | 48039 | 392 | 3 |
80720 | 80720 | 2020-04-22 | Brazoria | Texas | 48039 | 382 | 3 |
77930 | 77930 | 2020-04-21 | Brazoria | Texas | 48039 | 345 | 3 |
75148 | 75148 | 2020-04-20 | Brazoria | Texas | 48039 | 333 | 3 |
72373 | 72373 | 2020-04-19 | Brazoria | Texas | 48039 | 315 | 3 |
69606 | 69606 | 2020-04-18 | Brazoria | Texas | 48039 | 304 | 3 |
66847 | 66847 | 2020-04-17 | Brazoria | Texas | 48039 | 302 | 3 |
64100 | 64100 | 2020-04-16 | Brazoria | Texas | 48039 | 272 | 3 |
61373 | 61373 | 2020-04-15 | Brazoria | Texas | 48039 | 272 | 3 |
58656 | 58656 | 2020-04-14 | Brazoria | Texas | 48039 | 259 | 3 |
55952 | 55952 | 2020-04-13 | Brazoria | Texas | 48039 | 250 | 2 |
53264 | 53264 | 2020-04-12 | Brazoria | Texas | 48039 | 225 | 2 |
50589 | 50589 | 2020-04-11 | Brazoria | Texas | 48039 | 225 | 2 |
47932 | 47932 | 2020-04-10 | Brazoria | Texas | 48039 | 199 | 2 |
45314 | 45314 | 2020-04-09 | Brazoria | Texas | 48039 | 199 | 2 |
42725 | 42725 | 2020-04-08 | Brazoria | Texas | 48039 | 184 | 1 |
40162 | 40162 | 2020-04-07 | Brazoria | Texas | 48039 | 167 | 1 |
37640 | 37640 | 2020-04-06 | Brazoria | Texas | 48039 | 151 | 1 |
35164 | 35164 | 2020-04-05 | Brazoria | Texas | 48039 | 144 | 1 |
32726 | 32726 | 2020-04-04 | Brazoria | Texas | 48039 | 136 | 1 |
30333 | 30333 | 2020-04-03 | Brazoria | Texas | 48039 | 123 | 1 |
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);