ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Marion" and state = "Tennessee" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
8059 | 8059 | 2020-03-22 | Marion | Tennessee | 47115 | 1 | 0 |
9277 | 9277 | 2020-03-23 | Marion | Tennessee | 47115 | 1 | 0 |
10610 | 10610 | 2020-03-24 | Marion | Tennessee | 47115 | 1 | 0 |
12089 | 12089 | 2020-03-25 | Marion | Tennessee | 47115 | 1 | 0 |
13714 | 13714 | 2020-03-26 | Marion | Tennessee | 47115 | 2 | 0 |
15466 | 15466 | 2020-03-27 | Marion | Tennessee | 47115 | 2 | 0 |
17329 | 17329 | 2020-03-28 | Marion | Tennessee | 47115 | 4 | 0 |
19277 | 19277 | 2020-03-29 | Marion | Tennessee | 47115 | 5 | 0 |
21333 | 21333 | 2020-03-30 | Marion | Tennessee | 47115 | 6 | 0 |
23472 | 23472 | 2020-03-31 | Marion | Tennessee | 47115 | 6 | 0 |
25674 | 25674 | 2020-04-01 | Marion | Tennessee | 47115 | 8 | 1 |
27953 | 27953 | 2020-04-02 | Marion | Tennessee | 47115 | 13 | 1 |
30288 | 30288 | 2020-04-03 | Marion | Tennessee | 47115 | 14 | 1 |
32679 | 32679 | 2020-04-04 | Marion | Tennessee | 47115 | 16 | 1 |
35116 | 35116 | 2020-04-05 | Marion | Tennessee | 47115 | 16 | 1 |
37592 | 37592 | 2020-04-06 | Marion | Tennessee | 47115 | 20 | 1 |
40115 | 40115 | 2020-04-07 | Marion | Tennessee | 47115 | 21 | 1 |
42677 | 42677 | 2020-04-08 | Marion | Tennessee | 47115 | 21 | 1 |
45264 | 45264 | 2020-04-09 | Marion | Tennessee | 47115 | 22 | 1 |
47882 | 47882 | 2020-04-10 | Marion | Tennessee | 47115 | 22 | 1 |
50540 | 50540 | 2020-04-11 | Marion | Tennessee | 47115 | 24 | 1 |
53215 | 53215 | 2020-04-12 | Marion | Tennessee | 47115 | 24 | 1 |
55902 | 55902 | 2020-04-13 | Marion | Tennessee | 47115 | 26 | 1 |
58605 | 58605 | 2020-04-14 | Marion | Tennessee | 47115 | 26 | 1 |
61320 | 61320 | 2020-04-15 | Marion | Tennessee | 47115 | 27 | 1 |
64047 | 64047 | 2020-04-16 | Marion | Tennessee | 47115 | 27 | 1 |
66793 | 66793 | 2020-04-17 | Marion | Tennessee | 47115 | 28 | 1 |
69552 | 69552 | 2020-04-18 | Marion | Tennessee | 47115 | 28 | 1 |
72319 | 72319 | 2020-04-19 | Marion | Tennessee | 47115 | 28 | 1 |
75094 | 75094 | 2020-04-20 | Marion | Tennessee | 47115 | 28 | 1 |
77876 | 77876 | 2020-04-21 | Marion | Tennessee | 47115 | 28 | 1 |
80666 | 80666 | 2020-04-22 | Marion | Tennessee | 47115 | 28 | 1 |
83465 | 83465 | 2020-04-23 | Marion | Tennessee | 47115 | 28 | 1 |
86270 | 86270 | 2020-04-24 | Marion | Tennessee | 47115 | 28 | 1 |
89085 | 89085 | 2020-04-25 | Marion | Tennessee | 47115 | 28 | 1 |
91902 | 91902 | 2020-04-26 | Marion | Tennessee | 47115 | 28 | 1 |
94730 | 94730 | 2020-04-27 | Marion | Tennessee | 47115 | 28 | 1 |
97570 | 97570 | 2020-04-28 | Marion | Tennessee | 47115 | 28 | 1 |
100420 | 100420 | 2020-04-29 | Marion | Tennessee | 47115 | 28 | 1 |
103273 | 103273 | 2020-04-30 | Marion | Tennessee | 47115 | 29 | 1 |
106136 | 106136 | 2020-05-01 | Marion | Tennessee | 47115 | 29 | 1 |
109003 | 109003 | 2020-05-02 | Marion | Tennessee | 47115 | 29 | 1 |
111877 | 111877 | 2020-05-03 | Marion | Tennessee | 47115 | 29 | 1 |
114759 | 114759 | 2020-05-04 | Marion | Tennessee | 47115 | 29 | 1 |
117715 | 117715 | 2020-05-05 | Marion | Tennessee | 47115 | 29 | 1 |
120679 | 120679 | 2020-05-06 | Marion | Tennessee | 47115 | 29 | 1 |
123657 | 123657 | 2020-05-07 | Marion | Tennessee | 47115 | 29 | 1 |
126640 | 126640 | 2020-05-08 | Marion | Tennessee | 47115 | 29 | 1 |
129629 | 129629 | 2020-05-09 | Marion | Tennessee | 47115 | 29 | 1 |
132618 | 132618 | 2020-05-10 | Marion | Tennessee | 47115 | 29 | 1 |
135609 | 135609 | 2020-05-11 | Marion | Tennessee | 47115 | 29 | 1 |
138599 | 138599 | 2020-05-12 | Marion | Tennessee | 47115 | 29 | 1 |
141595 | 141595 | 2020-05-13 | Marion | Tennessee | 47115 | 29 | 1 |
144592 | 144592 | 2020-05-14 | Marion | Tennessee | 47115 | 30 | 1 |
147593 | 147593 | 2020-05-15 | Marion | Tennessee | 47115 | 30 | 1 |
150601 | 150601 | 2020-05-16 | Marion | Tennessee | 47115 | 31 | 1 |
153612 | 153612 | 2020-05-17 | Marion | Tennessee | 47115 | 32 | 1 |
156629 | 156629 | 2020-05-18 | Marion | Tennessee | 47115 | 33 | 1 |
159651 | 159651 | 2020-05-19 | Marion | Tennessee | 47115 | 34 | 1 |
162678 | 162678 | 2020-05-20 | Marion | Tennessee | 47115 | 34 | 1 |
165707 | 165707 | 2020-05-21 | Marion | Tennessee | 47115 | 35 | 1 |
168743 | 168743 | 2020-05-22 | Marion | Tennessee | 47115 | 35 | 1 |
171782 | 171782 | 2020-05-23 | Marion | Tennessee | 47115 | 36 | 1 |
174825 | 174825 | 2020-05-24 | Marion | Tennessee | 47115 | 36 | 1 |
177869 | 177869 | 2020-05-25 | Marion | Tennessee | 47115 | 36 | 1 |
180912 | 180912 | 2020-05-26 | Marion | Tennessee | 47115 | 37 | 1 |
183962 | 183962 | 2020-05-27 | Marion | Tennessee | 47115 | 37 | 1 |
187019 | 187019 | 2020-05-28 | Marion | Tennessee | 47115 | 38 | 1 |
190083 | 190083 | 2020-05-29 | Marion | Tennessee | 47115 | 39 | 1 |
193148 | 193148 | 2020-05-30 | Marion | Tennessee | 47115 | 40 | 1 |
196218 | 196218 | 2020-05-31 | Marion | Tennessee | 47115 | 40 | 1 |
199291 | 199291 | 2020-06-01 | Marion | Tennessee | 47115 | 40 | 1 |
202366 | 202366 | 2020-06-02 | Marion | Tennessee | 47115 | 42 | 1 |
205445 | 205445 | 2020-06-03 | Marion | Tennessee | 47115 | 42 | 1 |
208527 | 208527 | 2020-06-04 | Marion | Tennessee | 47115 | 44 | 1 |
211609 | 211609 | 2020-06-05 | Marion | Tennessee | 47115 | 44 | 1 |
214696 | 214696 | 2020-06-06 | Marion | Tennessee | 47115 | 45 | 1 |
217786 | 217786 | 2020-06-07 | Marion | Tennessee | 47115 | 45 | 1 |
220878 | 220878 | 2020-06-08 | Marion | Tennessee | 47115 | 45 | 1 |
223973 | 223973 | 2020-06-09 | Marion | Tennessee | 47115 | 45 | 1 |
227073 | 227073 | 2020-06-10 | Marion | Tennessee | 47115 | 46 | 1 |
230177 | 230177 | 2020-06-11 | Marion | Tennessee | 47115 | 47 | 1 |
233282 | 233282 | 2020-06-12 | Marion | Tennessee | 47115 | 48 | 2 |
236388 | 236388 | 2020-06-13 | Marion | Tennessee | 47115 | 49 | 2 |
239496 | 239496 | 2020-06-14 | Marion | Tennessee | 47115 | 49 | 2 |
242606 | 242606 | 2020-06-15 | Marion | Tennessee | 47115 | 49 | 2 |
245718 | 245718 | 2020-06-16 | Marion | Tennessee | 47115 | 49 | 2 |
248831 | 248831 | 2020-06-17 | Marion | Tennessee | 47115 | 49 | 2 |
251946 | 251946 | 2020-06-18 | Marion | Tennessee | 47115 | 49 | 2 |
255061 | 255061 | 2020-06-19 | Marion | Tennessee | 47115 | 48 | 2 |
258187 | 258187 | 2020-06-20 | Marion | Tennessee | 47115 | 49 | 3 |
261314 | 261314 | 2020-06-21 | Marion | Tennessee | 47115 | 50 | 3 |
264442 | 264442 | 2020-06-22 | Marion | Tennessee | 47115 | 50 | 3 |
267570 | 267570 | 2020-06-23 | Marion | Tennessee | 47115 | 53 | 4 |
270704 | 270704 | 2020-06-24 | Marion | Tennessee | 47115 | 54 | 4 |
273843 | 273843 | 2020-06-25 | Marion | Tennessee | 47115 | 56 | 4 |
276990 | 276990 | 2020-06-26 | Marion | Tennessee | 47115 | 56 | 4 |
280138 | 280138 | 2020-06-27 | Marion | Tennessee | 47115 | 57 | 4 |
283284 | 283284 | 2020-06-28 | Marion | Tennessee | 47115 | 57 | 4 |
286429 | 286429 | 2020-06-29 | Marion | Tennessee | 47115 | 61 | 4 |
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);