ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where deaths = 2 and fips = 47155 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
245740 | 245740 | 2020-06-16 | Sevier | Tennessee | 47155 | 285 | 2 |
242628 | 242628 | 2020-06-15 | Sevier | Tennessee | 47155 | 248 | 2 |
239518 | 239518 | 2020-06-14 | Sevier | Tennessee | 47155 | 233 | 2 |
236410 | 236410 | 2020-06-13 | Sevier | Tennessee | 47155 | 229 | 2 |
233304 | 233304 | 2020-06-12 | Sevier | Tennessee | 47155 | 206 | 2 |
230199 | 230199 | 2020-06-11 | Sevier | Tennessee | 47155 | 184 | 2 |
227095 | 227095 | 2020-06-10 | Sevier | Tennessee | 47155 | 178 | 2 |
223995 | 223995 | 2020-06-09 | Sevier | Tennessee | 47155 | 158 | 2 |
220900 | 220900 | 2020-06-08 | Sevier | Tennessee | 47155 | 129 | 2 |
217808 | 217808 | 2020-06-07 | Sevier | Tennessee | 47155 | 110 | 2 |
214718 | 214718 | 2020-06-06 | Sevier | Tennessee | 47155 | 109 | 2 |
211631 | 211631 | 2020-06-05 | Sevier | Tennessee | 47155 | 100 | 2 |
208549 | 208549 | 2020-06-04 | Sevier | Tennessee | 47155 | 97 | 2 |
205467 | 205467 | 2020-06-03 | Sevier | Tennessee | 47155 | 94 | 2 |
202388 | 202388 | 2020-06-02 | Sevier | Tennessee | 47155 | 90 | 2 |
199313 | 199313 | 2020-06-01 | Sevier | Tennessee | 47155 | 81 | 2 |
196240 | 196240 | 2020-05-31 | Sevier | Tennessee | 47155 | 81 | 2 |
193170 | 193170 | 2020-05-30 | Sevier | Tennessee | 47155 | 81 | 2 |
190105 | 190105 | 2020-05-29 | Sevier | Tennessee | 47155 | 80 | 2 |
187041 | 187041 | 2020-05-28 | Sevier | Tennessee | 47155 | 76 | 2 |
183984 | 183984 | 2020-05-27 | Sevier | Tennessee | 47155 | 75 | 2 |
180934 | 180934 | 2020-05-26 | Sevier | Tennessee | 47155 | 75 | 2 |
177891 | 177891 | 2020-05-25 | Sevier | Tennessee | 47155 | 72 | 2 |
174847 | 174847 | 2020-05-24 | Sevier | Tennessee | 47155 | 72 | 2 |
171804 | 171804 | 2020-05-23 | Sevier | Tennessee | 47155 | 72 | 2 |
168765 | 168765 | 2020-05-22 | Sevier | Tennessee | 47155 | 70 | 2 |
165729 | 165729 | 2020-05-21 | Sevier | Tennessee | 47155 | 69 | 2 |
162700 | 162700 | 2020-05-20 | Sevier | Tennessee | 47155 | 68 | 2 |
159673 | 159673 | 2020-05-19 | Sevier | Tennessee | 47155 | 68 | 2 |
156651 | 156651 | 2020-05-18 | Sevier | Tennessee | 47155 | 69 | 2 |
153634 | 153634 | 2020-05-17 | Sevier | Tennessee | 47155 | 68 | 2 |
150623 | 150623 | 2020-05-16 | Sevier | Tennessee | 47155 | 68 | 2 |
147615 | 147615 | 2020-05-15 | Sevier | Tennessee | 47155 | 66 | 2 |
144614 | 144614 | 2020-05-14 | Sevier | Tennessee | 47155 | 65 | 2 |
141617 | 141617 | 2020-05-13 | Sevier | Tennessee | 47155 | 65 | 2 |
138621 | 138621 | 2020-05-12 | Sevier | Tennessee | 47155 | 65 | 2 |
135631 | 135631 | 2020-05-11 | Sevier | Tennessee | 47155 | 65 | 2 |
132640 | 132640 | 2020-05-10 | Sevier | Tennessee | 47155 | 65 | 2 |
129650 | 129650 | 2020-05-09 | Sevier | Tennessee | 47155 | 65 | 2 |
126661 | 126661 | 2020-05-08 | Sevier | Tennessee | 47155 | 65 | 2 |
123678 | 123678 | 2020-05-07 | Sevier | Tennessee | 47155 | 63 | 2 |
120700 | 120700 | 2020-05-06 | Sevier | Tennessee | 47155 | 60 | 2 |
117736 | 117736 | 2020-05-05 | Sevier | Tennessee | 47155 | 60 | 2 |
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);