ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
761 rows where county = "Van Buren" and state = "Tennessee" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
55931 | 55931 | 2020-04-13 | Van Buren | Tennessee | 47175 | 1 | 0 |
58634 | 58634 | 2020-04-14 | Van Buren | Tennessee | 47175 | 1 | 0 |
61350 | 61350 | 2020-04-15 | Van Buren | Tennessee | 47175 | 1 | 0 |
64077 | 64077 | 2020-04-16 | Van Buren | Tennessee | 47175 | 1 | 0 |
66824 | 66824 | 2020-04-17 | Van Buren | Tennessee | 47175 | 1 | 0 |
69583 | 69583 | 2020-04-18 | Van Buren | Tennessee | 47175 | 1 | 0 |
72350 | 72350 | 2020-04-19 | Van Buren | Tennessee | 47175 | 1 | 0 |
75125 | 75125 | 2020-04-20 | Van Buren | Tennessee | 47175 | 1 | 0 |
77907 | 77907 | 2020-04-21 | Van Buren | Tennessee | 47175 | 1 | 0 |
80697 | 80697 | 2020-04-22 | Van Buren | Tennessee | 47175 | 1 | 0 |
83496 | 83496 | 2020-04-23 | Van Buren | Tennessee | 47175 | 1 | 0 |
86301 | 86301 | 2020-04-24 | Van Buren | Tennessee | 47175 | 1 | 0 |
89116 | 89116 | 2020-04-25 | Van Buren | Tennessee | 47175 | 2 | 0 |
91933 | 91933 | 2020-04-26 | Van Buren | Tennessee | 47175 | 2 | 0 |
94761 | 94761 | 2020-04-27 | Van Buren | Tennessee | 47175 | 2 | 0 |
97601 | 97601 | 2020-04-28 | Van Buren | Tennessee | 47175 | 2 | 0 |
100451 | 100451 | 2020-04-29 | Van Buren | Tennessee | 47175 | 2 | 0 |
103304 | 103304 | 2020-04-30 | Van Buren | Tennessee | 47175 | 2 | 0 |
106167 | 106167 | 2020-05-01 | Van Buren | Tennessee | 47175 | 2 | 0 |
109034 | 109034 | 2020-05-02 | Van Buren | Tennessee | 47175 | 2 | 0 |
111908 | 111908 | 2020-05-03 | Van Buren | Tennessee | 47175 | 2 | 0 |
114790 | 114790 | 2020-05-04 | Van Buren | Tennessee | 47175 | 2 | 0 |
117746 | 117746 | 2020-05-05 | Van Buren | Tennessee | 47175 | 2 | 0 |
120710 | 120710 | 2020-05-06 | Van Buren | Tennessee | 47175 | 2 | 0 |
123689 | 123689 | 2020-05-07 | Van Buren | Tennessee | 47175 | 2 | 0 |
126672 | 126672 | 2020-05-08 | Van Buren | Tennessee | 47175 | 2 | 0 |
129661 | 129661 | 2020-05-09 | Van Buren | Tennessee | 47175 | 2 | 0 |
132651 | 132651 | 2020-05-10 | Van Buren | Tennessee | 47175 | 2 | 0 |
135642 | 135642 | 2020-05-11 | Van Buren | Tennessee | 47175 | 2 | 0 |
138632 | 138632 | 2020-05-12 | Van Buren | Tennessee | 47175 | 2 | 0 |
141628 | 141628 | 2020-05-13 | Van Buren | Tennessee | 47175 | 2 | 0 |
144625 | 144625 | 2020-05-14 | Van Buren | Tennessee | 47175 | 2 | 0 |
147626 | 147626 | 2020-05-15 | Van Buren | Tennessee | 47175 | 3 | 0 |
150634 | 150634 | 2020-05-16 | Van Buren | Tennessee | 47175 | 3 | 0 |
153645 | 153645 | 2020-05-17 | Van Buren | Tennessee | 47175 | 3 | 0 |
156662 | 156662 | 2020-05-18 | Van Buren | Tennessee | 47175 | 4 | 0 |
159684 | 159684 | 2020-05-19 | Van Buren | Tennessee | 47175 | 4 | 0 |
162711 | 162711 | 2020-05-20 | Van Buren | Tennessee | 47175 | 4 | 0 |
165740 | 165740 | 2020-05-21 | Van Buren | Tennessee | 47175 | 4 | 0 |
168776 | 168776 | 2020-05-22 | Van Buren | Tennessee | 47175 | 4 | 0 |
171815 | 171815 | 2020-05-23 | Van Buren | Tennessee | 47175 | 4 | 0 |
174858 | 174858 | 2020-05-24 | Van Buren | Tennessee | 47175 | 4 | 0 |
177902 | 177902 | 2020-05-25 | Van Buren | Tennessee | 47175 | 4 | 0 |
180945 | 180945 | 2020-05-26 | Van Buren | Tennessee | 47175 | 4 | 0 |
183995 | 183995 | 2020-05-27 | Van Buren | Tennessee | 47175 | 4 | 0 |
187052 | 187052 | 2020-05-28 | Van Buren | Tennessee | 47175 | 4 | 0 |
190116 | 190116 | 2020-05-29 | Van Buren | Tennessee | 47175 | 4 | 0 |
193181 | 193181 | 2020-05-30 | Van Buren | Tennessee | 47175 | 4 | 0 |
196251 | 196251 | 2020-05-31 | Van Buren | Tennessee | 47175 | 4 | 0 |
199324 | 199324 | 2020-06-01 | Van Buren | Tennessee | 47175 | 4 | 0 |
202399 | 202399 | 2020-06-02 | Van Buren | Tennessee | 47175 | 4 | 0 |
205478 | 205478 | 2020-06-03 | Van Buren | Tennessee | 47175 | 4 | 0 |
208560 | 208560 | 2020-06-04 | Van Buren | Tennessee | 47175 | 4 | 0 |
211642 | 211642 | 2020-06-05 | Van Buren | Tennessee | 47175 | 4 | 0 |
214729 | 214729 | 2020-06-06 | Van Buren | Tennessee | 47175 | 4 | 0 |
217819 | 217819 | 2020-06-07 | Van Buren | Tennessee | 47175 | 4 | 0 |
220911 | 220911 | 2020-06-08 | Van Buren | Tennessee | 47175 | 4 | 0 |
224006 | 224006 | 2020-06-09 | Van Buren | Tennessee | 47175 | 4 | 0 |
227106 | 227106 | 2020-06-10 | Van Buren | Tennessee | 47175 | 4 | 0 |
230210 | 230210 | 2020-06-11 | Van Buren | Tennessee | 47175 | 4 | 0 |
233314 | 233314 | 2020-06-12 | Van Buren | Tennessee | 47175 | 4 | 0 |
236420 | 236420 | 2020-06-13 | Van Buren | Tennessee | 47175 | 4 | 0 |
239528 | 239528 | 2020-06-14 | Van Buren | Tennessee | 47175 | 4 | 0 |
242638 | 242638 | 2020-06-15 | Van Buren | Tennessee | 47175 | 5 | 0 |
245750 | 245750 | 2020-06-16 | Van Buren | Tennessee | 47175 | 5 | 0 |
248863 | 248863 | 2020-06-17 | Van Buren | Tennessee | 47175 | 5 | 0 |
251978 | 251978 | 2020-06-18 | Van Buren | Tennessee | 47175 | 5 | 0 |
255093 | 255093 | 2020-06-19 | Van Buren | Tennessee | 47175 | 5 | 0 |
258219 | 258219 | 2020-06-20 | Van Buren | Tennessee | 47175 | 5 | 0 |
261346 | 261346 | 2020-06-21 | Van Buren | Tennessee | 47175 | 5 | 0 |
264474 | 264474 | 2020-06-22 | Van Buren | Tennessee | 47175 | 5 | 0 |
267602 | 267602 | 2020-06-23 | Van Buren | Tennessee | 47175 | 6 | 0 |
270736 | 270736 | 2020-06-24 | Van Buren | Tennessee | 47175 | 6 | 0 |
273875 | 273875 | 2020-06-25 | Van Buren | Tennessee | 47175 | 6 | 0 |
277022 | 277022 | 2020-06-26 | Van Buren | Tennessee | 47175 | 6 | 0 |
280170 | 280170 | 2020-06-27 | Van Buren | Tennessee | 47175 | 6 | 0 |
283316 | 283316 | 2020-06-28 | Van Buren | Tennessee | 47175 | 6 | 0 |
286462 | 286462 | 2020-06-29 | Van Buren | Tennessee | 47175 | 7 | 0 |
289612 | 289612 | 2020-06-30 | Van Buren | Tennessee | 47175 | 7 | 0 |
292765 | 292765 | 2020-07-01 | Van Buren | Tennessee | 47175 | 7 | 0 |
295920 | 295920 | 2020-07-02 | Van Buren | Tennessee | 47175 | 7 | 0 |
299080 | 299080 | 2020-07-03 | Van Buren | Tennessee | 47175 | 8 | 0 |
302244 | 302244 | 2020-07-04 | Van Buren | Tennessee | 47175 | 8 | 0 |
305408 | 305408 | 2020-07-05 | Van Buren | Tennessee | 47175 | 8 | 0 |
308576 | 308576 | 2020-07-06 | Van Buren | Tennessee | 47175 | 7 | 0 |
311745 | 311745 | 2020-07-07 | Van Buren | Tennessee | 47175 | 7 | 0 |
314919 | 314919 | 2020-07-08 | Van Buren | Tennessee | 47175 | 7 | 0 |
318092 | 318092 | 2020-07-09 | Van Buren | Tennessee | 47175 | 7 | 0 |
321270 | 321270 | 2020-07-10 | Van Buren | Tennessee | 47175 | 9 | 0 |
324451 | 324451 | 2020-07-11 | Van Buren | Tennessee | 47175 | 9 | 0 |
327636 | 327636 | 2020-07-12 | Van Buren | Tennessee | 47175 | 9 | 0 |
330822 | 330822 | 2020-07-13 | Van Buren | Tennessee | 47175 | 9 | 0 |
334013 | 334013 | 2020-07-14 | Van Buren | Tennessee | 47175 | 11 | 0 |
337208 | 337208 | 2020-07-15 | Van Buren | Tennessee | 47175 | 14 | 0 |
340404 | 340404 | 2020-07-16 | Van Buren | Tennessee | 47175 | 14 | 0 |
343603 | 343603 | 2020-07-17 | Van Buren | Tennessee | 47175 | 14 | 0 |
346803 | 346803 | 2020-07-18 | Van Buren | Tennessee | 47175 | 14 | 0 |
350003 | 350003 | 2020-07-19 | Van Buren | Tennessee | 47175 | 14 | 0 |
353205 | 353205 | 2020-07-20 | Van Buren | Tennessee | 47175 | 14 | 0 |
356408 | 356408 | 2020-07-21 | Van Buren | Tennessee | 47175 | 15 | 0 |
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);