ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Bell" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324472 | 324472 | 2020-07-11 | Bell | Texas | 48027 | 2083 | 14 |
321291 | 321291 | 2020-07-10 | Bell | Texas | 48027 | 1992 | 14 |
318113 | 318113 | 2020-07-09 | Bell | Texas | 48027 | 1886 | 13 |
314940 | 314940 | 2020-07-08 | Bell | Texas | 48027 | 1746 | 13 |
311766 | 311766 | 2020-07-07 | Bell | Texas | 48027 | 1628 | 13 |
308597 | 308597 | 2020-07-06 | Bell | Texas | 48027 | 1523 | 13 |
305429 | 305429 | 2020-07-05 | Bell | Texas | 48027 | 1523 | 13 |
302265 | 302265 | 2020-07-04 | Bell | Texas | 48027 | 1523 | 13 |
299101 | 299101 | 2020-07-03 | Bell | Texas | 48027 | 1480 | 13 |
295941 | 295941 | 2020-07-02 | Bell | Texas | 48027 | 1394 | 13 |
292786 | 292786 | 2020-07-01 | Bell | Texas | 48027 | 1315 | 13 |
289633 | 289633 | 2020-06-30 | Bell | Texas | 48027 | 1209 | 13 |
286483 | 286483 | 2020-06-29 | Bell | Texas | 48027 | 1128 | 13 |
283337 | 283337 | 2020-06-28 | Bell | Texas | 48027 | 1128 | 12 |
280191 | 280191 | 2020-06-27 | Bell | Texas | 48027 | 1128 | 12 |
277043 | 277043 | 2020-06-26 | Bell | Texas | 48027 | 1077 | 12 |
273896 | 273896 | 2020-06-25 | Bell | Texas | 48027 | 1009 | 12 |
270757 | 270757 | 2020-06-24 | Bell | Texas | 48027 | 925 | 11 |
267623 | 267623 | 2020-06-23 | Bell | Texas | 48027 | 875 | 11 |
264495 | 264495 | 2020-06-22 | Bell | Texas | 48027 | 822 | 10 |
261367 | 261367 | 2020-06-21 | Bell | Texas | 48027 | 822 | 10 |
258240 | 258240 | 2020-06-20 | Bell | Texas | 48027 | 818 | 10 |
255114 | 255114 | 2020-06-19 | Bell | Texas | 48027 | 769 | 10 |
251999 | 251999 | 2020-06-18 | Bell | Texas | 48027 | 722 | 9 |
248884 | 248884 | 2020-06-17 | Bell | Texas | 48027 | 672 | 9 |
245771 | 245771 | 2020-06-16 | Bell | Texas | 48027 | 651 | 7 |
242659 | 242659 | 2020-06-15 | Bell | Texas | 48027 | 629 | 7 |
239549 | 239549 | 2020-06-14 | Bell | Texas | 48027 | 629 | 6 |
236441 | 236441 | 2020-06-13 | Bell | Texas | 48027 | 605 | 6 |
233335 | 233335 | 2020-06-12 | Bell | Texas | 48027 | 574 | 6 |
230231 | 230231 | 2020-06-11 | Bell | Texas | 48027 | 530 | 6 |
227127 | 227127 | 2020-06-10 | Bell | Texas | 48027 | 507 | 6 |
224027 | 224027 | 2020-06-09 | Bell | Texas | 48027 | 476 | 6 |
220932 | 220932 | 2020-06-08 | Bell | Texas | 48027 | 446 | 5 |
217840 | 217840 | 2020-06-07 | Bell | Texas | 48027 | 446 | 5 |
214750 | 214750 | 2020-06-06 | Bell | Texas | 48027 | 446 | 5 |
211663 | 211663 | 2020-06-05 | Bell | Texas | 48027 | 432 | 5 |
208580 | 208580 | 2020-06-04 | Bell | Texas | 48027 | 423 | 5 |
205498 | 205498 | 2020-06-03 | Bell | Texas | 48027 | 411 | 5 |
202419 | 202419 | 2020-06-02 | Bell | Texas | 48027 | 391 | 4 |
199344 | 199344 | 2020-06-01 | Bell | Texas | 48027 | 378 | 4 |
196271 | 196271 | 2020-05-31 | Bell | Texas | 48027 | 362 | 4 |
193201 | 193201 | 2020-05-30 | Bell | Texas | 48027 | 356 | 4 |
190136 | 190136 | 2020-05-29 | Bell | Texas | 48027 | 345 | 3 |
187072 | 187072 | 2020-05-28 | Bell | Texas | 48027 | 335 | 3 |
184015 | 184015 | 2020-05-27 | Bell | Texas | 48027 | 329 | 3 |
180965 | 180965 | 2020-05-26 | Bell | Texas | 48027 | 309 | 3 |
177922 | 177922 | 2020-05-25 | Bell | Texas | 48027 | 298 | 3 |
174878 | 174878 | 2020-05-24 | Bell | Texas | 48027 | 298 | 3 |
171835 | 171835 | 2020-05-23 | Bell | Texas | 48027 | 298 | 3 |
168796 | 168796 | 2020-05-22 | Bell | Texas | 48027 | 282 | 3 |
165760 | 165760 | 2020-05-21 | Bell | Texas | 48027 | 282 | 3 |
162731 | 162731 | 2020-05-20 | Bell | Texas | 48027 | 267 | 3 |
159704 | 159704 | 2020-05-19 | Bell | Texas | 48027 | 260 | 3 |
156682 | 156682 | 2020-05-18 | Bell | Texas | 48027 | 248 | 3 |
153665 | 153665 | 2020-05-17 | Bell | Texas | 48027 | 248 | 3 |
150654 | 150654 | 2020-05-16 | Bell | Texas | 48027 | 248 | 3 |
147646 | 147646 | 2020-05-15 | Bell | Texas | 48027 | 242 | 3 |
144644 | 144644 | 2020-05-14 | Bell | Texas | 48027 | 237 | 3 |
141647 | 141647 | 2020-05-13 | Bell | Texas | 48027 | 231 | 3 |
138651 | 138651 | 2020-05-12 | Bell | Texas | 48027 | 223 | 3 |
135661 | 135661 | 2020-05-11 | Bell | Texas | 48027 | 220 | 3 |
132670 | 132670 | 2020-05-10 | Bell | Texas | 48027 | 220 | 3 |
129680 | 129680 | 2020-05-09 | Bell | Texas | 48027 | 220 | 3 |
126691 | 126691 | 2020-05-08 | Bell | Texas | 48027 | 218 | 3 |
123708 | 123708 | 2020-05-07 | Bell | Texas | 48027 | 213 | 3 |
120729 | 120729 | 2020-05-06 | Bell | Texas | 48027 | 210 | 3 |
117765 | 117765 | 2020-05-05 | Bell | Texas | 48027 | 210 | 3 |
114808 | 114808 | 2020-05-04 | Bell | Texas | 48027 | 194 | 3 |
111926 | 111926 | 2020-05-03 | Bell | Texas | 48027 | 194 | 3 |
109052 | 109052 | 2020-05-02 | Bell | Texas | 48027 | 193 | 3 |
106185 | 106185 | 2020-05-01 | Bell | Texas | 48027 | 189 | 3 |
103322 | 103322 | 2020-04-30 | Bell | Texas | 48027 | 189 | 3 |
100469 | 100469 | 2020-04-29 | Bell | Texas | 48027 | 180 | 3 |
97619 | 97619 | 2020-04-28 | Bell | Texas | 48027 | 173 | 3 |
94779 | 94779 | 2020-04-27 | Bell | Texas | 48027 | 165 | 3 |
91951 | 91951 | 2020-04-26 | Bell | Texas | 48027 | 165 | 3 |
89134 | 89134 | 2020-04-25 | Bell | Texas | 48027 | 165 | 3 |
86319 | 86319 | 2020-04-24 | Bell | Texas | 48027 | 161 | 3 |
83514 | 83514 | 2020-04-23 | Bell | Texas | 48027 | 153 | 3 |
80715 | 80715 | 2020-04-22 | Bell | Texas | 48027 | 145 | 3 |
77925 | 77925 | 2020-04-21 | Bell | Texas | 48027 | 135 | 3 |
75143 | 75143 | 2020-04-20 | Bell | Texas | 48027 | 126 | 3 |
72368 | 72368 | 2020-04-19 | Bell | Texas | 48027 | 126 | 3 |
69601 | 69601 | 2020-04-18 | Bell | Texas | 48027 | 126 | 3 |
66842 | 66842 | 2020-04-17 | Bell | Texas | 48027 | 124 | 3 |
64095 | 64095 | 2020-04-16 | Bell | Texas | 48027 | 115 | 3 |
61368 | 61368 | 2020-04-15 | Bell | Texas | 48027 | 110 | 3 |
58652 | 58652 | 2020-04-14 | Bell | Texas | 48027 | 107 | 3 |
55948 | 55948 | 2020-04-13 | Bell | Texas | 48027 | 101 | 3 |
53260 | 53260 | 2020-04-12 | Bell | Texas | 48027 | 101 | 3 |
50585 | 50585 | 2020-04-11 | Bell | Texas | 48027 | 91 | 3 |
47928 | 47928 | 2020-04-10 | Bell | Texas | 48027 | 84 | 3 |
45310 | 45310 | 2020-04-09 | Bell | Texas | 48027 | 84 | 3 |
42721 | 42721 | 2020-04-08 | Bell | Texas | 48027 | 74 | 2 |
40158 | 40158 | 2020-04-07 | Bell | Texas | 48027 | 68 | 2 |
37636 | 37636 | 2020-04-06 | Bell | Texas | 48027 | 68 | 2 |
35160 | 35160 | 2020-04-05 | Bell | Texas | 48027 | 58 | 1 |
32722 | 32722 | 2020-04-04 | Bell | Texas | 48027 | 51 | 1 |
30329 | 30329 | 2020-04-03 | Bell | Texas | 48027 | 51 | 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);