ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 48041 and state = "Texas" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
3673 | 3673 | 2020-03-17 | Brazos | Texas | 48041 | 1 | 0 |
4296 | 4296 | 2020-03-18 | Brazos | Texas | 48041 | 3 | 0 |
5047 | 5047 | 2020-03-19 | Brazos | Texas | 48041 | 4 | 0 |
5936 | 5936 | 2020-03-20 | Brazos | Texas | 48041 | 6 | 0 |
6954 | 6954 | 2020-03-21 | Brazos | Texas | 48041 | 10 | 0 |
8084 | 8084 | 2020-03-22 | Brazos | Texas | 48041 | 12 | 0 |
9302 | 9302 | 2020-03-23 | Brazos | Texas | 48041 | 12 | 0 |
10636 | 10636 | 2020-03-24 | Brazos | Texas | 48041 | 12 | 0 |
12119 | 12119 | 2020-03-25 | Brazos | Texas | 48041 | 16 | 0 |
13747 | 13747 | 2020-03-26 | Brazos | Texas | 48041 | 28 | 0 |
15500 | 15500 | 2020-03-27 | Brazos | Texas | 48041 | 31 | 0 |
17367 | 17367 | 2020-03-28 | Brazos | Texas | 48041 | 36 | 0 |
19317 | 19317 | 2020-03-29 | Brazos | Texas | 48041 | 44 | 2 |
21376 | 21376 | 2020-03-30 | Brazos | Texas | 48041 | 44 | 2 |
23515 | 23515 | 2020-03-31 | Brazos | Texas | 48041 | 46 | 2 |
25719 | 25719 | 2020-04-01 | Brazos | Texas | 48041 | 63 | 3 |
27999 | 27999 | 2020-04-02 | Brazos | Texas | 48041 | 68 | 4 |
30334 | 30334 | 2020-04-03 | Brazos | Texas | 48041 | 72 | 4 |
32727 | 32727 | 2020-04-04 | Brazos | Texas | 48041 | 72 | 5 |
35165 | 35165 | 2020-04-05 | Brazos | Texas | 48041 | 75 | 5 |
37641 | 37641 | 2020-04-06 | Brazos | Texas | 48041 | 94 | 7 |
40163 | 40163 | 2020-04-07 | Brazos | Texas | 48041 | 94 | 7 |
42726 | 42726 | 2020-04-08 | Brazos | Texas | 48041 | 108 | 7 |
45315 | 45315 | 2020-04-09 | Brazos | Texas | 48041 | 114 | 9 |
47933 | 47933 | 2020-04-10 | Brazos | Texas | 48041 | 116 | 9 |
50590 | 50590 | 2020-04-11 | Brazos | Texas | 48041 | 134 | 10 |
53265 | 53265 | 2020-04-12 | Brazos | Texas | 48041 | 140 | 11 |
55953 | 55953 | 2020-04-13 | Brazos | Texas | 48041 | 143 | 12 |
58657 | 58657 | 2020-04-14 | Brazos | Texas | 48041 | 149 | 13 |
61374 | 61374 | 2020-04-15 | Brazos | Texas | 48041 | 151 | 13 |
64101 | 64101 | 2020-04-16 | Brazos | Texas | 48041 | 151 | 13 |
66848 | 66848 | 2020-04-17 | Brazos | Texas | 48041 | 164 | 15 |
69607 | 69607 | 2020-04-18 | Brazos | Texas | 48041 | 169 | 16 |
72374 | 72374 | 2020-04-19 | Brazos | Texas | 48041 | 170 | 16 |
75149 | 75149 | 2020-04-20 | Brazos | Texas | 48041 | 170 | 16 |
77931 | 77931 | 2020-04-21 | Brazos | Texas | 48041 | 173 | 16 |
80721 | 80721 | 2020-04-22 | Brazos | Texas | 48041 | 177 | 16 |
83520 | 83520 | 2020-04-23 | Brazos | Texas | 48041 | 177 | 16 |
86325 | 86325 | 2020-04-24 | Brazos | Texas | 48041 | 181 | 16 |
89140 | 89140 | 2020-04-25 | Brazos | Texas | 48041 | 181 | 16 |
91957 | 91957 | 2020-04-26 | Brazos | Texas | 48041 | 182 | 16 |
94785 | 94785 | 2020-04-27 | Brazos | Texas | 48041 | 182 | 16 |
97625 | 97625 | 2020-04-28 | Brazos | Texas | 48041 | 188 | 16 |
100475 | 100475 | 2020-04-29 | Brazos | Texas | 48041 | 193 | 16 |
103328 | 103328 | 2020-04-30 | Brazos | Texas | 48041 | 197 | 16 |
106191 | 106191 | 2020-05-01 | Brazos | Texas | 48041 | 202 | 16 |
109058 | 109058 | 2020-05-02 | Brazos | Texas | 48041 | 208 | 16 |
111932 | 111932 | 2020-05-03 | Brazos | Texas | 48041 | 208 | 16 |
114814 | 114814 | 2020-05-04 | Brazos | Texas | 48041 | 209 | 16 |
117771 | 117771 | 2020-05-05 | Brazos | Texas | 48041 | 219 | 17 |
120735 | 120735 | 2020-05-06 | Brazos | Texas | 48041 | 232 | 17 |
123714 | 123714 | 2020-05-07 | Brazos | Texas | 48041 | 243 | 17 |
126697 | 126697 | 2020-05-08 | Brazos | Texas | 48041 | 256 | 18 |
129686 | 129686 | 2020-05-09 | Brazos | Texas | 48041 | 265 | 18 |
132676 | 132676 | 2020-05-10 | Brazos | Texas | 48041 | 271 | 18 |
135667 | 135667 | 2020-05-11 | Brazos | Texas | 48041 | 278 | 18 |
138657 | 138657 | 2020-05-12 | Brazos | Texas | 48041 | 287 | 18 |
141653 | 141653 | 2020-05-13 | Brazos | Texas | 48041 | 301 | 18 |
144650 | 144650 | 2020-05-14 | Brazos | Texas | 48041 | 305 | 18 |
147652 | 147652 | 2020-05-15 | Brazos | Texas | 48041 | 312 | 18 |
150660 | 150660 | 2020-05-16 | Brazos | Texas | 48041 | 318 | 18 |
153671 | 153671 | 2020-05-17 | Brazos | Texas | 48041 | 325 | 18 |
156688 | 156688 | 2020-05-18 | Brazos | Texas | 48041 | 333 | 18 |
159710 | 159710 | 2020-05-19 | Brazos | Texas | 48041 | 341 | 18 |
162737 | 162737 | 2020-05-20 | Brazos | Texas | 48041 | 362 | 18 |
165766 | 165766 | 2020-05-21 | Brazos | Texas | 48041 | 373 | 18 |
168802 | 168802 | 2020-05-22 | Brazos | Texas | 48041 | 383 | 18 |
171841 | 171841 | 2020-05-23 | Brazos | Texas | 48041 | 436 | 19 |
174884 | 174884 | 2020-05-24 | Brazos | Texas | 48041 | 438 | 19 |
177928 | 177928 | 2020-05-25 | Brazos | Texas | 48041 | 441 | 19 |
180971 | 180971 | 2020-05-26 | Brazos | Texas | 48041 | 444 | 19 |
184021 | 184021 | 2020-05-27 | Brazos | Texas | 48041 | 455 | 19 |
187078 | 187078 | 2020-05-28 | Brazos | Texas | 48041 | 463 | 19 |
190142 | 190142 | 2020-05-29 | Brazos | Texas | 48041 | 470 | 19 |
193207 | 193207 | 2020-05-30 | Brazos | Texas | 48041 | 477 | 19 |
196277 | 196277 | 2020-05-31 | Brazos | Texas | 48041 | 483 | 19 |
199350 | 199350 | 2020-06-01 | Brazos | Texas | 48041 | 487 | 19 |
202425 | 202425 | 2020-06-02 | Brazos | Texas | 48041 | 501 | 19 |
205504 | 205504 | 2020-06-03 | Brazos | Texas | 48041 | 517 | 21 |
208586 | 208586 | 2020-06-04 | Brazos | Texas | 48041 | 532 | 22 |
211669 | 211669 | 2020-06-05 | Brazos | Texas | 48041 | 565 | 22 |
214756 | 214756 | 2020-06-06 | Brazos | Texas | 48041 | 605 | 22 |
217846 | 217846 | 2020-06-07 | Brazos | Texas | 48041 | 626 | 22 |
220938 | 220938 | 2020-06-08 | Brazos | Texas | 48041 | 634 | 22 |
224033 | 224033 | 2020-06-09 | Brazos | Texas | 48041 | 665 | 24 |
227133 | 227133 | 2020-06-10 | Brazos | Texas | 48041 | 684 | 24 |
230237 | 230237 | 2020-06-11 | Brazos | Texas | 48041 | 710 | 24 |
233341 | 233341 | 2020-06-12 | Brazos | Texas | 48041 | 721 | 24 |
236447 | 236447 | 2020-06-13 | Brazos | Texas | 48041 | 781 | 25 |
239555 | 239555 | 2020-06-14 | Brazos | Texas | 48041 | 803 | 25 |
242665 | 242665 | 2020-06-15 | Brazos | Texas | 48041 | 821 | 25 |
245777 | 245777 | 2020-06-16 | Brazos | Texas | 48041 | 880 | 25 |
248890 | 248890 | 2020-06-17 | Brazos | Texas | 48041 | 1025 | 25 |
252005 | 252005 | 2020-06-18 | Brazos | Texas | 48041 | 1095 | 25 |
255120 | 255120 | 2020-06-19 | Brazos | Texas | 48041 | 1163 | 25 |
258246 | 258246 | 2020-06-20 | Brazos | Texas | 48041 | 1225 | 25 |
261373 | 261373 | 2020-06-21 | Brazos | Texas | 48041 | 1244 | 25 |
264501 | 264501 | 2020-06-22 | Brazos | Texas | 48041 | 1260 | 25 |
267629 | 267629 | 2020-06-23 | Brazos | Texas | 48041 | 1305 | 25 |
270763 | 270763 | 2020-06-24 | Brazos | Texas | 48041 | 1377 | 26 |
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);