ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Brazoria" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388554 | 388554 | 2020-07-31 | Brazoria | Texas | 48039 | 6384 | 67 |
385337 | 385337 | 2020-07-30 | Brazoria | Texas | 48039 | 6218 | 62 |
382119 | 382119 | 2020-07-29 | Brazoria | Texas | 48039 | 6032 | 60 |
378902 | 378902 | 2020-07-28 | Brazoria | Texas | 48039 | 5896 | 52 |
375686 | 375686 | 2020-07-27 | Brazoria | Texas | 48039 | 5573 | 50 |
372473 | 372473 | 2020-07-26 | Brazoria | Texas | 48039 | 5443 | 38 |
369261 | 369261 | 2020-07-25 | Brazoria | Texas | 48039 | 5299 | 37 |
366052 | 366052 | 2020-07-24 | Brazoria | Texas | 48039 | 5277 | 36 |
362846 | 362846 | 2020-07-23 | Brazoria | Texas | 48039 | 5177 | 35 |
359639 | 359639 | 2020-07-22 | Brazoria | Texas | 48039 | 5068 | 34 |
356434 | 356434 | 2020-07-21 | Brazoria | Texas | 48039 | 4896 | 34 |
353231 | 353231 | 2020-07-20 | Brazoria | Texas | 48039 | 4767 | 34 |
350029 | 350029 | 2020-07-19 | Brazoria | Texas | 48039 | 4675 | 32 |
346829 | 346829 | 2020-07-18 | Brazoria | Texas | 48039 | 4545 | 31 |
343629 | 343629 | 2020-07-17 | Brazoria | Texas | 48039 | 4359 | 29 |
340430 | 340430 | 2020-07-16 | Brazoria | Texas | 48039 | 4190 | 28 |
337234 | 337234 | 2020-07-15 | Brazoria | Texas | 48039 | 3988 | 28 |
334039 | 334039 | 2020-07-14 | Brazoria | Texas | 48039 | 3834 | 28 |
330848 | 330848 | 2020-07-13 | Brazoria | Texas | 48039 | 3550 | 28 |
327662 | 327662 | 2020-07-12 | Brazoria | Texas | 48039 | 3458 | 25 |
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 |
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);