ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Sevier" and state = "Tennessee" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3132 | 3132 | 2020-03-16 | Sevier | Tennessee | 47155 | 1 | 0 |
3665 | 3665 | 2020-03-17 | Sevier | Tennessee | 47155 | 1 | 0 |
4287 | 4287 | 2020-03-18 | Sevier | Tennessee | 47155 | 1 | 0 |
5035 | 5035 | 2020-03-19 | Sevier | Tennessee | 47155 | 1 | 0 |
5923 | 5923 | 2020-03-20 | Sevier | Tennessee | 47155 | 1 | 0 |
6940 | 6940 | 2020-03-21 | Sevier | Tennessee | 47155 | 2 | 0 |
8070 | 8070 | 2020-03-22 | Sevier | Tennessee | 47155 | 3 | 0 |
9288 | 9288 | 2020-03-23 | Sevier | Tennessee | 47155 | 3 | 0 |
10622 | 10622 | 2020-03-24 | Sevier | Tennessee | 47155 | 3 | 0 |
12101 | 12101 | 2020-03-25 | Sevier | Tennessee | 47155 | 3 | 0 |
13727 | 13727 | 2020-03-26 | Sevier | Tennessee | 47155 | 3 | 0 |
15479 | 15479 | 2020-03-27 | Sevier | Tennessee | 47155 | 6 | 0 |
17343 | 17343 | 2020-03-28 | Sevier | Tennessee | 47155 | 6 | 0 |
19293 | 19293 | 2020-03-29 | Sevier | Tennessee | 47155 | 6 | 0 |
21350 | 21350 | 2020-03-30 | Sevier | Tennessee | 47155 | 7 | 0 |
23489 | 23489 | 2020-03-31 | Sevier | Tennessee | 47155 | 7 | 0 |
25692 | 25692 | 2020-04-01 | Sevier | Tennessee | 47155 | 9 | 0 |
27972 | 27972 | 2020-04-02 | Sevier | Tennessee | 47155 | 10 | 0 |
30307 | 30307 | 2020-04-03 | Sevier | Tennessee | 47155 | 13 | 0 |
32698 | 32698 | 2020-04-04 | Sevier | Tennessee | 47155 | 13 | 0 |
35135 | 35135 | 2020-04-05 | Sevier | Tennessee | 47155 | 14 | 0 |
37611 | 37611 | 2020-04-06 | Sevier | Tennessee | 47155 | 16 | 0 |
40134 | 40134 | 2020-04-07 | Sevier | Tennessee | 47155 | 18 | 0 |
42696 | 42696 | 2020-04-08 | Sevier | Tennessee | 47155 | 19 | 0 |
45283 | 45283 | 2020-04-09 | Sevier | Tennessee | 47155 | 21 | 0 |
47901 | 47901 | 2020-04-10 | Sevier | Tennessee | 47155 | 21 | 0 |
50559 | 50559 | 2020-04-11 | Sevier | Tennessee | 47155 | 21 | 0 |
53234 | 53234 | 2020-04-12 | Sevier | Tennessee | 47155 | 21 | 0 |
55921 | 55921 | 2020-04-13 | Sevier | Tennessee | 47155 | 22 | 0 |
58624 | 58624 | 2020-04-14 | Sevier | Tennessee | 47155 | 22 | 0 |
61340 | 61340 | 2020-04-15 | Sevier | Tennessee | 47155 | 22 | 0 |
64067 | 64067 | 2020-04-16 | Sevier | Tennessee | 47155 | 22 | 0 |
66814 | 66814 | 2020-04-17 | Sevier | Tennessee | 47155 | 24 | 1 |
69573 | 69573 | 2020-04-18 | Sevier | Tennessee | 47155 | 24 | 1 |
72340 | 72340 | 2020-04-19 | Sevier | Tennessee | 47155 | 24 | 1 |
75115 | 75115 | 2020-04-20 | Sevier | Tennessee | 47155 | 26 | 1 |
77897 | 77897 | 2020-04-21 | Sevier | Tennessee | 47155 | 29 | 1 |
80687 | 80687 | 2020-04-22 | Sevier | Tennessee | 47155 | 33 | 1 |
83486 | 83486 | 2020-04-23 | Sevier | Tennessee | 47155 | 34 | 1 |
86291 | 86291 | 2020-04-24 | Sevier | Tennessee | 47155 | 35 | 1 |
89106 | 89106 | 2020-04-25 | Sevier | Tennessee | 47155 | 42 | 1 |
91923 | 91923 | 2020-04-26 | Sevier | Tennessee | 47155 | 45 | 1 |
94751 | 94751 | 2020-04-27 | Sevier | Tennessee | 47155 | 46 | 1 |
97591 | 97591 | 2020-04-28 | Sevier | Tennessee | 47155 | 46 | 1 |
100441 | 100441 | 2020-04-29 | Sevier | Tennessee | 47155 | 48 | 1 |
103294 | 103294 | 2020-04-30 | Sevier | Tennessee | 47155 | 49 | 1 |
106157 | 106157 | 2020-05-01 | Sevier | Tennessee | 47155 | 49 | 1 |
109024 | 109024 | 2020-05-02 | Sevier | Tennessee | 47155 | 49 | 1 |
111898 | 111898 | 2020-05-03 | Sevier | Tennessee | 47155 | 51 | 1 |
114780 | 114780 | 2020-05-04 | Sevier | Tennessee | 47155 | 58 | 1 |
117736 | 117736 | 2020-05-05 | Sevier | Tennessee | 47155 | 60 | 2 |
120700 | 120700 | 2020-05-06 | Sevier | Tennessee | 47155 | 60 | 2 |
123678 | 123678 | 2020-05-07 | Sevier | Tennessee | 47155 | 63 | 2 |
126661 | 126661 | 2020-05-08 | Sevier | Tennessee | 47155 | 65 | 2 |
129650 | 129650 | 2020-05-09 | Sevier | Tennessee | 47155 | 65 | 2 |
132640 | 132640 | 2020-05-10 | Sevier | Tennessee | 47155 | 65 | 2 |
135631 | 135631 | 2020-05-11 | Sevier | Tennessee | 47155 | 65 | 2 |
138621 | 138621 | 2020-05-12 | Sevier | Tennessee | 47155 | 65 | 2 |
141617 | 141617 | 2020-05-13 | Sevier | Tennessee | 47155 | 65 | 2 |
144614 | 144614 | 2020-05-14 | Sevier | Tennessee | 47155 | 65 | 2 |
147615 | 147615 | 2020-05-15 | Sevier | Tennessee | 47155 | 66 | 2 |
150623 | 150623 | 2020-05-16 | Sevier | Tennessee | 47155 | 68 | 2 |
153634 | 153634 | 2020-05-17 | Sevier | Tennessee | 47155 | 68 | 2 |
156651 | 156651 | 2020-05-18 | Sevier | Tennessee | 47155 | 69 | 2 |
159673 | 159673 | 2020-05-19 | Sevier | Tennessee | 47155 | 68 | 2 |
162700 | 162700 | 2020-05-20 | Sevier | Tennessee | 47155 | 68 | 2 |
165729 | 165729 | 2020-05-21 | Sevier | Tennessee | 47155 | 69 | 2 |
168765 | 168765 | 2020-05-22 | Sevier | Tennessee | 47155 | 70 | 2 |
171804 | 171804 | 2020-05-23 | Sevier | Tennessee | 47155 | 72 | 2 |
174847 | 174847 | 2020-05-24 | Sevier | Tennessee | 47155 | 72 | 2 |
177891 | 177891 | 2020-05-25 | Sevier | Tennessee | 47155 | 72 | 2 |
180934 | 180934 | 2020-05-26 | Sevier | Tennessee | 47155 | 75 | 2 |
183984 | 183984 | 2020-05-27 | Sevier | Tennessee | 47155 | 75 | 2 |
187041 | 187041 | 2020-05-28 | Sevier | Tennessee | 47155 | 76 | 2 |
190105 | 190105 | 2020-05-29 | Sevier | Tennessee | 47155 | 80 | 2 |
193170 | 193170 | 2020-05-30 | Sevier | Tennessee | 47155 | 81 | 2 |
196240 | 196240 | 2020-05-31 | Sevier | Tennessee | 47155 | 81 | 2 |
199313 | 199313 | 2020-06-01 | Sevier | Tennessee | 47155 | 81 | 2 |
202388 | 202388 | 2020-06-02 | Sevier | Tennessee | 47155 | 90 | 2 |
205467 | 205467 | 2020-06-03 | Sevier | Tennessee | 47155 | 94 | 2 |
208549 | 208549 | 2020-06-04 | Sevier | Tennessee | 47155 | 97 | 2 |
211631 | 211631 | 2020-06-05 | Sevier | Tennessee | 47155 | 100 | 2 |
214718 | 214718 | 2020-06-06 | Sevier | Tennessee | 47155 | 109 | 2 |
217808 | 217808 | 2020-06-07 | Sevier | Tennessee | 47155 | 110 | 2 |
220900 | 220900 | 2020-06-08 | Sevier | Tennessee | 47155 | 129 | 2 |
223995 | 223995 | 2020-06-09 | Sevier | Tennessee | 47155 | 158 | 2 |
227095 | 227095 | 2020-06-10 | Sevier | Tennessee | 47155 | 178 | 2 |
230199 | 230199 | 2020-06-11 | Sevier | Tennessee | 47155 | 184 | 2 |
233304 | 233304 | 2020-06-12 | Sevier | Tennessee | 47155 | 206 | 2 |
236410 | 236410 | 2020-06-13 | Sevier | Tennessee | 47155 | 229 | 2 |
239518 | 239518 | 2020-06-14 | Sevier | Tennessee | 47155 | 233 | 2 |
242628 | 242628 | 2020-06-15 | Sevier | Tennessee | 47155 | 248 | 2 |
245740 | 245740 | 2020-06-16 | Sevier | Tennessee | 47155 | 285 | 2 |
248853 | 248853 | 2020-06-17 | Sevier | Tennessee | 47155 | 297 | 3 |
251968 | 251968 | 2020-06-18 | Sevier | Tennessee | 47155 | 342 | 3 |
255083 | 255083 | 2020-06-19 | Sevier | Tennessee | 47155 | 387 | 3 |
258209 | 258209 | 2020-06-20 | Sevier | Tennessee | 47155 | 411 | 3 |
261336 | 261336 | 2020-06-21 | Sevier | Tennessee | 47155 | 420 | 3 |
264464 | 264464 | 2020-06-22 | Sevier | Tennessee | 47155 | 422 | 3 |
267592 | 267592 | 2020-06-23 | Sevier | Tennessee | 47155 | 464 | 3 |
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);