ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Union" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388526 | 388526 | 2020-07-31 | Union | Tennessee | 47173 | 110 | 0 |
385309 | 385309 | 2020-07-30 | Union | Tennessee | 47173 | 105 | 0 |
382091 | 382091 | 2020-07-29 | Union | Tennessee | 47173 | 102 | 0 |
378874 | 378874 | 2020-07-28 | Union | Tennessee | 47173 | 93 | 0 |
375658 | 375658 | 2020-07-27 | Union | Tennessee | 47173 | 84 | 0 |
372445 | 372445 | 2020-07-26 | Union | Tennessee | 47173 | 77 | 0 |
369233 | 369233 | 2020-07-25 | Union | Tennessee | 47173 | 76 | 0 |
366024 | 366024 | 2020-07-24 | Union | Tennessee | 47173 | 73 | 0 |
362818 | 362818 | 2020-07-23 | Union | Tennessee | 47173 | 61 | 0 |
359611 | 359611 | 2020-07-22 | Union | Tennessee | 47173 | 59 | 0 |
356407 | 356407 | 2020-07-21 | Union | Tennessee | 47173 | 56 | 0 |
353204 | 353204 | 2020-07-20 | Union | Tennessee | 47173 | 50 | 0 |
350001 | 350001 | 2020-07-19 | Union | Tennessee | 47173 | 46 | 0 |
346801 | 346801 | 2020-07-18 | Union | Tennessee | 47173 | 41 | 0 |
343601 | 343601 | 2020-07-17 | Union | Tennessee | 47173 | 40 | 0 |
340403 | 340403 | 2020-07-16 | Union | Tennessee | 47173 | 32 | 0 |
337206 | 337206 | 2020-07-15 | Union | Tennessee | 47173 | 31 | 0 |
334012 | 334012 | 2020-07-14 | Union | Tennessee | 47173 | 29 | 0 |
330820 | 330820 | 2020-07-13 | Union | Tennessee | 47173 | 28 | 0 |
327634 | 327634 | 2020-07-12 | Union | Tennessee | 47173 | 24 | 0 |
324449 | 324449 | 2020-07-11 | Union | Tennessee | 47173 | 25 | 0 |
321268 | 321268 | 2020-07-10 | Union | Tennessee | 47173 | 22 | 0 |
318090 | 318090 | 2020-07-09 | Union | Tennessee | 47173 | 20 | 0 |
314917 | 314917 | 2020-07-08 | Union | Tennessee | 47173 | 19 | 0 |
311743 | 311743 | 2020-07-07 | Union | Tennessee | 47173 | 19 | 0 |
308574 | 308574 | 2020-07-06 | Union | Tennessee | 47173 | 19 | 0 |
305406 | 305406 | 2020-07-05 | Union | Tennessee | 47173 | 18 | 0 |
302243 | 302243 | 2020-07-04 | Union | Tennessee | 47173 | 18 | 0 |
299079 | 299079 | 2020-07-03 | Union | Tennessee | 47173 | 16 | 0 |
295919 | 295919 | 2020-07-02 | Union | Tennessee | 47173 | 15 | 0 |
292763 | 292763 | 2020-07-01 | Union | Tennessee | 47173 | 13 | 0 |
289611 | 289611 | 2020-06-30 | Union | Tennessee | 47173 | 12 | 0 |
286460 | 286460 | 2020-06-29 | Union | Tennessee | 47173 | 12 | 0 |
283315 | 283315 | 2020-06-28 | Union | Tennessee | 47173 | 11 | 0 |
280169 | 280169 | 2020-06-27 | Union | Tennessee | 47173 | 11 | 0 |
277021 | 277021 | 2020-06-26 | Union | Tennessee | 47173 | 11 | 0 |
273874 | 273874 | 2020-06-25 | Union | Tennessee | 47173 | 10 | 0 |
270735 | 270735 | 2020-06-24 | Union | Tennessee | 47173 | 9 | 0 |
267601 | 267601 | 2020-06-23 | Union | Tennessee | 47173 | 9 | 0 |
264473 | 264473 | 2020-06-22 | Union | Tennessee | 47173 | 10 | 0 |
261345 | 261345 | 2020-06-21 | Union | Tennessee | 47173 | 10 | 0 |
258218 | 258218 | 2020-06-20 | Union | Tennessee | 47173 | 9 | 0 |
255092 | 255092 | 2020-06-19 | Union | Tennessee | 47173 | 9 | 0 |
251977 | 251977 | 2020-06-18 | Union | Tennessee | 47173 | 9 | 0 |
248862 | 248862 | 2020-06-17 | Union | Tennessee | 47173 | 9 | 0 |
245749 | 245749 | 2020-06-16 | Union | Tennessee | 47173 | 9 | 0 |
242637 | 242637 | 2020-06-15 | Union | Tennessee | 47173 | 8 | 0 |
239527 | 239527 | 2020-06-14 | Union | Tennessee | 47173 | 8 | 0 |
236419 | 236419 | 2020-06-13 | Union | Tennessee | 47173 | 8 | 0 |
233313 | 233313 | 2020-06-12 | Union | Tennessee | 47173 | 7 | 0 |
230208 | 230208 | 2020-06-11 | Union | Tennessee | 47173 | 6 | 0 |
227104 | 227104 | 2020-06-10 | Union | Tennessee | 47173 | 5 | 0 |
224004 | 224004 | 2020-06-09 | Union | Tennessee | 47173 | 5 | 0 |
220909 | 220909 | 2020-06-08 | Union | Tennessee | 47173 | 4 | 0 |
217817 | 217817 | 2020-06-07 | Union | Tennessee | 47173 | 4 | 0 |
214727 | 214727 | 2020-06-06 | Union | Tennessee | 47173 | 4 | 0 |
211640 | 211640 | 2020-06-05 | Union | Tennessee | 47173 | 4 | 0 |
208558 | 208558 | 2020-06-04 | Union | Tennessee | 47173 | 4 | 0 |
205476 | 205476 | 2020-06-03 | Union | Tennessee | 47173 | 4 | 0 |
202397 | 202397 | 2020-06-02 | Union | Tennessee | 47173 | 5 | 0 |
199322 | 199322 | 2020-06-01 | Union | Tennessee | 47173 | 4 | 0 |
196249 | 196249 | 2020-05-31 | Union | Tennessee | 47173 | 4 | 0 |
193179 | 193179 | 2020-05-30 | Union | Tennessee | 47173 | 4 | 0 |
190114 | 190114 | 2020-05-29 | Union | Tennessee | 47173 | 4 | 0 |
187050 | 187050 | 2020-05-28 | Union | Tennessee | 47173 | 4 | 0 |
183993 | 183993 | 2020-05-27 | Union | Tennessee | 47173 | 4 | 0 |
180943 | 180943 | 2020-05-26 | Union | Tennessee | 47173 | 4 | 0 |
177900 | 177900 | 2020-05-25 | Union | Tennessee | 47173 | 4 | 0 |
174856 | 174856 | 2020-05-24 | Union | Tennessee | 47173 | 4 | 0 |
171813 | 171813 | 2020-05-23 | Union | Tennessee | 47173 | 4 | 0 |
168774 | 168774 | 2020-05-22 | Union | Tennessee | 47173 | 4 | 0 |
165738 | 165738 | 2020-05-21 | Union | Tennessee | 47173 | 4 | 0 |
162709 | 162709 | 2020-05-20 | Union | Tennessee | 47173 | 4 | 0 |
159682 | 159682 | 2020-05-19 | Union | Tennessee | 47173 | 4 | 0 |
156660 | 156660 | 2020-05-18 | Union | Tennessee | 47173 | 4 | 0 |
153643 | 153643 | 2020-05-17 | Union | Tennessee | 47173 | 4 | 0 |
150632 | 150632 | 2020-05-16 | Union | Tennessee | 47173 | 4 | 0 |
147624 | 147624 | 2020-05-15 | Union | Tennessee | 47173 | 4 | 0 |
144623 | 144623 | 2020-05-14 | Union | Tennessee | 47173 | 4 | 0 |
141626 | 141626 | 2020-05-13 | Union | Tennessee | 47173 | 4 | 0 |
138630 | 138630 | 2020-05-12 | Union | Tennessee | 47173 | 3 | 0 |
135640 | 135640 | 2020-05-11 | Union | Tennessee | 47173 | 3 | 0 |
132649 | 132649 | 2020-05-10 | Union | Tennessee | 47173 | 3 | 0 |
129659 | 129659 | 2020-05-09 | Union | Tennessee | 47173 | 3 | 0 |
126670 | 126670 | 2020-05-08 | Union | Tennessee | 47173 | 3 | 0 |
123687 | 123687 | 2020-05-07 | Union | Tennessee | 47173 | 3 | 0 |
120709 | 120709 | 2020-05-06 | Union | Tennessee | 47173 | 3 | 0 |
117745 | 117745 | 2020-05-05 | Union | Tennessee | 47173 | 3 | 0 |
114789 | 114789 | 2020-05-04 | Union | Tennessee | 47173 | 3 | 0 |
111907 | 111907 | 2020-05-03 | Union | Tennessee | 47173 | 3 | 0 |
109033 | 109033 | 2020-05-02 | Union | Tennessee | 47173 | 3 | 0 |
106166 | 106166 | 2020-05-01 | Union | Tennessee | 47173 | 3 | 0 |
103303 | 103303 | 2020-04-30 | Union | Tennessee | 47173 | 3 | 0 |
100450 | 100450 | 2020-04-29 | Union | Tennessee | 47173 | 3 | 0 |
97600 | 97600 | 2020-04-28 | Union | Tennessee | 47173 | 3 | 0 |
94760 | 94760 | 2020-04-27 | Union | Tennessee | 47173 | 3 | 0 |
91932 | 91932 | 2020-04-26 | Union | Tennessee | 47173 | 3 | 0 |
89115 | 89115 | 2020-04-25 | Union | Tennessee | 47173 | 3 | 0 |
86300 | 86300 | 2020-04-24 | Union | Tennessee | 47173 | 3 | 0 |
83495 | 83495 | 2020-04-23 | Union | Tennessee | 47173 | 3 | 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);