ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Union" and fips = 47173 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
17351 | 17351 | 2020-03-28 | Union | Tennessee | 47173 | 1 | 0 |
19301 | 19301 | 2020-03-29 | Union | Tennessee | 47173 | 1 | 0 |
21358 | 21358 | 2020-03-30 | Union | Tennessee | 47173 | 1 | 0 |
23497 | 23497 | 2020-03-31 | Union | Tennessee | 47173 | 1 | 0 |
25700 | 25700 | 2020-04-01 | Union | Tennessee | 47173 | 1 | 0 |
27980 | 27980 | 2020-04-02 | Union | Tennessee | 47173 | 1 | 0 |
30315 | 30315 | 2020-04-03 | Union | Tennessee | 47173 | 1 | 0 |
32707 | 32707 | 2020-04-04 | Union | Tennessee | 47173 | 1 | 0 |
35144 | 35144 | 2020-04-05 | Union | Tennessee | 47173 | 1 | 0 |
37620 | 37620 | 2020-04-06 | Union | Tennessee | 47173 | 1 | 0 |
40143 | 40143 | 2020-04-07 | Union | Tennessee | 47173 | 1 | 0 |
42705 | 42705 | 2020-04-08 | Union | Tennessee | 47173 | 2 | 0 |
45292 | 45292 | 2020-04-09 | Union | Tennessee | 47173 | 2 | 0 |
47910 | 47910 | 2020-04-10 | Union | Tennessee | 47173 | 3 | 0 |
50568 | 50568 | 2020-04-11 | Union | Tennessee | 47173 | 3 | 0 |
53243 | 53243 | 2020-04-12 | Union | Tennessee | 47173 | 3 | 0 |
55930 | 55930 | 2020-04-13 | Union | Tennessee | 47173 | 3 | 0 |
58633 | 58633 | 2020-04-14 | Union | Tennessee | 47173 | 3 | 0 |
61349 | 61349 | 2020-04-15 | Union | Tennessee | 47173 | 3 | 0 |
64076 | 64076 | 2020-04-16 | Union | Tennessee | 47173 | 3 | 0 |
66823 | 66823 | 2020-04-17 | Union | Tennessee | 47173 | 3 | 0 |
69582 | 69582 | 2020-04-18 | Union | Tennessee | 47173 | 3 | 0 |
72349 | 72349 | 2020-04-19 | Union | Tennessee | 47173 | 3 | 0 |
75124 | 75124 | 2020-04-20 | Union | Tennessee | 47173 | 3 | 0 |
77906 | 77906 | 2020-04-21 | Union | Tennessee | 47173 | 3 | 0 |
80696 | 80696 | 2020-04-22 | Union | Tennessee | 47173 | 3 | 0 |
83495 | 83495 | 2020-04-23 | Union | Tennessee | 47173 | 3 | 0 |
86300 | 86300 | 2020-04-24 | Union | Tennessee | 47173 | 3 | 0 |
89115 | 89115 | 2020-04-25 | Union | Tennessee | 47173 | 3 | 0 |
91932 | 91932 | 2020-04-26 | Union | Tennessee | 47173 | 3 | 0 |
94760 | 94760 | 2020-04-27 | Union | Tennessee | 47173 | 3 | 0 |
97600 | 97600 | 2020-04-28 | Union | Tennessee | 47173 | 3 | 0 |
100450 | 100450 | 2020-04-29 | Union | Tennessee | 47173 | 3 | 0 |
103303 | 103303 | 2020-04-30 | Union | Tennessee | 47173 | 3 | 0 |
106166 | 106166 | 2020-05-01 | Union | Tennessee | 47173 | 3 | 0 |
109033 | 109033 | 2020-05-02 | Union | Tennessee | 47173 | 3 | 0 |
111907 | 111907 | 2020-05-03 | Union | Tennessee | 47173 | 3 | 0 |
114789 | 114789 | 2020-05-04 | Union | Tennessee | 47173 | 3 | 0 |
117745 | 117745 | 2020-05-05 | Union | Tennessee | 47173 | 3 | 0 |
120709 | 120709 | 2020-05-06 | Union | Tennessee | 47173 | 3 | 0 |
123687 | 123687 | 2020-05-07 | Union | Tennessee | 47173 | 3 | 0 |
126670 | 126670 | 2020-05-08 | Union | Tennessee | 47173 | 3 | 0 |
129659 | 129659 | 2020-05-09 | Union | Tennessee | 47173 | 3 | 0 |
132649 | 132649 | 2020-05-10 | Union | Tennessee | 47173 | 3 | 0 |
135640 | 135640 | 2020-05-11 | Union | Tennessee | 47173 | 3 | 0 |
138630 | 138630 | 2020-05-12 | Union | Tennessee | 47173 | 3 | 0 |
141626 | 141626 | 2020-05-13 | Union | Tennessee | 47173 | 4 | 0 |
144623 | 144623 | 2020-05-14 | Union | Tennessee | 47173 | 4 | 0 |
147624 | 147624 | 2020-05-15 | Union | Tennessee | 47173 | 4 | 0 |
150632 | 150632 | 2020-05-16 | Union | Tennessee | 47173 | 4 | 0 |
153643 | 153643 | 2020-05-17 | Union | Tennessee | 47173 | 4 | 0 |
156660 | 156660 | 2020-05-18 | Union | Tennessee | 47173 | 4 | 0 |
159682 | 159682 | 2020-05-19 | Union | Tennessee | 47173 | 4 | 0 |
162709 | 162709 | 2020-05-20 | Union | Tennessee | 47173 | 4 | 0 |
165738 | 165738 | 2020-05-21 | Union | Tennessee | 47173 | 4 | 0 |
168774 | 168774 | 2020-05-22 | Union | Tennessee | 47173 | 4 | 0 |
171813 | 171813 | 2020-05-23 | Union | Tennessee | 47173 | 4 | 0 |
174856 | 174856 | 2020-05-24 | Union | Tennessee | 47173 | 4 | 0 |
177900 | 177900 | 2020-05-25 | Union | Tennessee | 47173 | 4 | 0 |
180943 | 180943 | 2020-05-26 | Union | Tennessee | 47173 | 4 | 0 |
183993 | 183993 | 2020-05-27 | Union | Tennessee | 47173 | 4 | 0 |
187050 | 187050 | 2020-05-28 | Union | Tennessee | 47173 | 4 | 0 |
190114 | 190114 | 2020-05-29 | Union | Tennessee | 47173 | 4 | 0 |
193179 | 193179 | 2020-05-30 | Union | Tennessee | 47173 | 4 | 0 |
196249 | 196249 | 2020-05-31 | Union | Tennessee | 47173 | 4 | 0 |
199322 | 199322 | 2020-06-01 | Union | Tennessee | 47173 | 4 | 0 |
202397 | 202397 | 2020-06-02 | Union | Tennessee | 47173 | 5 | 0 |
205476 | 205476 | 2020-06-03 | Union | Tennessee | 47173 | 4 | 0 |
208558 | 208558 | 2020-06-04 | Union | Tennessee | 47173 | 4 | 0 |
211640 | 211640 | 2020-06-05 | Union | Tennessee | 47173 | 4 | 0 |
214727 | 214727 | 2020-06-06 | Union | Tennessee | 47173 | 4 | 0 |
217817 | 217817 | 2020-06-07 | Union | Tennessee | 47173 | 4 | 0 |
220909 | 220909 | 2020-06-08 | Union | Tennessee | 47173 | 4 | 0 |
224004 | 224004 | 2020-06-09 | Union | Tennessee | 47173 | 5 | 0 |
227104 | 227104 | 2020-06-10 | Union | Tennessee | 47173 | 5 | 0 |
230208 | 230208 | 2020-06-11 | Union | Tennessee | 47173 | 6 | 0 |
233313 | 233313 | 2020-06-12 | Union | Tennessee | 47173 | 7 | 0 |
236419 | 236419 | 2020-06-13 | Union | Tennessee | 47173 | 8 | 0 |
239527 | 239527 | 2020-06-14 | Union | Tennessee | 47173 | 8 | 0 |
242637 | 242637 | 2020-06-15 | Union | Tennessee | 47173 | 8 | 0 |
245749 | 245749 | 2020-06-16 | Union | Tennessee | 47173 | 9 | 0 |
248862 | 248862 | 2020-06-17 | Union | Tennessee | 47173 | 9 | 0 |
251977 | 251977 | 2020-06-18 | Union | Tennessee | 47173 | 9 | 0 |
255092 | 255092 | 2020-06-19 | Union | Tennessee | 47173 | 9 | 0 |
258218 | 258218 | 2020-06-20 | Union | Tennessee | 47173 | 9 | 0 |
261345 | 261345 | 2020-06-21 | Union | Tennessee | 47173 | 10 | 0 |
264473 | 264473 | 2020-06-22 | Union | Tennessee | 47173 | 10 | 0 |
267601 | 267601 | 2020-06-23 | Union | Tennessee | 47173 | 9 | 0 |
270735 | 270735 | 2020-06-24 | Union | Tennessee | 47173 | 9 | 0 |
273874 | 273874 | 2020-06-25 | Union | Tennessee | 47173 | 10 | 0 |
277021 | 277021 | 2020-06-26 | Union | Tennessee | 47173 | 11 | 0 |
280169 | 280169 | 2020-06-27 | Union | Tennessee | 47173 | 11 | 0 |
283315 | 283315 | 2020-06-28 | Union | Tennessee | 47173 | 11 | 0 |
286460 | 286460 | 2020-06-29 | Union | Tennessee | 47173 | 12 | 0 |
289611 | 289611 | 2020-06-30 | Union | Tennessee | 47173 | 12 | 0 |
292763 | 292763 | 2020-07-01 | Union | Tennessee | 47173 | 13 | 0 |
295919 | 295919 | 2020-07-02 | Union | Tennessee | 47173 | 15 | 0 |
299079 | 299079 | 2020-07-03 | Union | Tennessee | 47173 | 16 | 0 |
302243 | 302243 | 2020-07-04 | Union | Tennessee | 47173 | 18 | 0 |
305406 | 305406 | 2020-07-05 | Union | Tennessee | 47173 | 18 | 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);