ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 47045 and state = "Tennessee" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5028 | 5028 | 2020-03-19 | Dyer | Tennessee | 47045 | 1 | 0 |
5913 | 5913 | 2020-03-20 | Dyer | Tennessee | 47045 | 1 | 0 |
6925 | 6925 | 2020-03-21 | Dyer | Tennessee | 47045 | 2 | 0 |
8048 | 8048 | 2020-03-22 | Dyer | Tennessee | 47045 | 2 | 0 |
9266 | 9266 | 2020-03-23 | Dyer | Tennessee | 47045 | 2 | 0 |
10595 | 10595 | 2020-03-24 | Dyer | Tennessee | 47045 | 2 | 0 |
12072 | 12072 | 2020-03-25 | Dyer | Tennessee | 47045 | 2 | 0 |
13696 | 13696 | 2020-03-26 | Dyer | Tennessee | 47045 | 3 | 0 |
15448 | 15448 | 2020-03-27 | Dyer | Tennessee | 47045 | 3 | 0 |
17309 | 17309 | 2020-03-28 | Dyer | Tennessee | 47045 | 3 | 0 |
19255 | 19255 | 2020-03-29 | Dyer | Tennessee | 47045 | 3 | 0 |
21308 | 21308 | 2020-03-30 | Dyer | Tennessee | 47045 | 3 | 0 |
23446 | 23446 | 2020-03-31 | Dyer | Tennessee | 47045 | 3 | 0 |
25645 | 25645 | 2020-04-01 | Dyer | Tennessee | 47045 | 3 | 0 |
27923 | 27923 | 2020-04-02 | Dyer | Tennessee | 47045 | 5 | 0 |
30258 | 30258 | 2020-04-03 | Dyer | Tennessee | 47045 | 5 | 0 |
32649 | 32649 | 2020-04-04 | Dyer | Tennessee | 47045 | 7 | 0 |
35085 | 35085 | 2020-04-05 | Dyer | Tennessee | 47045 | 9 | 0 |
37561 | 37561 | 2020-04-06 | Dyer | Tennessee | 47045 | 9 | 0 |
40084 | 40084 | 2020-04-07 | Dyer | Tennessee | 47045 | 10 | 0 |
42646 | 42646 | 2020-04-08 | Dyer | Tennessee | 47045 | 11 | 0 |
45233 | 45233 | 2020-04-09 | Dyer | Tennessee | 47045 | 14 | 0 |
47851 | 47851 | 2020-04-10 | Dyer | Tennessee | 47045 | 15 | 0 |
50509 | 50509 | 2020-04-11 | Dyer | Tennessee | 47045 | 18 | 0 |
53184 | 53184 | 2020-04-12 | Dyer | Tennessee | 47045 | 18 | 0 |
55870 | 55870 | 2020-04-13 | Dyer | Tennessee | 47045 | 22 | 0 |
58573 | 58573 | 2020-04-14 | Dyer | Tennessee | 47045 | 22 | 0 |
61288 | 61288 | 2020-04-15 | Dyer | Tennessee | 47045 | 24 | 0 |
64015 | 64015 | 2020-04-16 | Dyer | Tennessee | 47045 | 24 | 0 |
66761 | 66761 | 2020-04-17 | Dyer | Tennessee | 47045 | 24 | 0 |
69520 | 69520 | 2020-04-18 | Dyer | Tennessee | 47045 | 25 | 0 |
72287 | 72287 | 2020-04-19 | Dyer | Tennessee | 47045 | 28 | 0 |
75062 | 75062 | 2020-04-20 | Dyer | Tennessee | 47045 | 28 | 0 |
77844 | 77844 | 2020-04-21 | Dyer | Tennessee | 47045 | 28 | 0 |
80634 | 80634 | 2020-04-22 | Dyer | Tennessee | 47045 | 29 | 0 |
83433 | 83433 | 2020-04-23 | Dyer | Tennessee | 47045 | 30 | 0 |
86238 | 86238 | 2020-04-24 | Dyer | Tennessee | 47045 | 30 | 0 |
89053 | 89053 | 2020-04-25 | Dyer | Tennessee | 47045 | 31 | 0 |
91870 | 91870 | 2020-04-26 | Dyer | Tennessee | 47045 | 31 | 0 |
94698 | 94698 | 2020-04-27 | Dyer | Tennessee | 47045 | 32 | 0 |
97538 | 97538 | 2020-04-28 | Dyer | Tennessee | 47045 | 33 | 0 |
100388 | 100388 | 2020-04-29 | Dyer | Tennessee | 47045 | 34 | 0 |
103241 | 103241 | 2020-04-30 | Dyer | Tennessee | 47045 | 34 | 0 |
106104 | 106104 | 2020-05-01 | Dyer | Tennessee | 47045 | 36 | 0 |
108971 | 108971 | 2020-05-02 | Dyer | Tennessee | 47045 | 36 | 0 |
111845 | 111845 | 2020-05-03 | Dyer | Tennessee | 47045 | 36 | 0 |
114727 | 114727 | 2020-05-04 | Dyer | Tennessee | 47045 | 39 | 0 |
117683 | 117683 | 2020-05-05 | Dyer | Tennessee | 47045 | 40 | 0 |
120647 | 120647 | 2020-05-06 | Dyer | Tennessee | 47045 | 38 | 0 |
123625 | 123625 | 2020-05-07 | Dyer | Tennessee | 47045 | 39 | 0 |
126608 | 126608 | 2020-05-08 | Dyer | Tennessee | 47045 | 41 | 0 |
129597 | 129597 | 2020-05-09 | Dyer | Tennessee | 47045 | 41 | 0 |
132586 | 132586 | 2020-05-10 | Dyer | Tennessee | 47045 | 41 | 0 |
135577 | 135577 | 2020-05-11 | Dyer | Tennessee | 47045 | 43 | 0 |
138567 | 138567 | 2020-05-12 | Dyer | Tennessee | 47045 | 43 | 0 |
141563 | 141563 | 2020-05-13 | Dyer | Tennessee | 47045 | 44 | 0 |
144560 | 144560 | 2020-05-14 | Dyer | Tennessee | 47045 | 44 | 0 |
147561 | 147561 | 2020-05-15 | Dyer | Tennessee | 47045 | 44 | 0 |
150569 | 150569 | 2020-05-16 | Dyer | Tennessee | 47045 | 44 | 0 |
153580 | 153580 | 2020-05-17 | Dyer | Tennessee | 47045 | 44 | 0 |
156597 | 156597 | 2020-05-18 | Dyer | Tennessee | 47045 | 44 | 0 |
159618 | 159618 | 2020-05-19 | Dyer | Tennessee | 47045 | 45 | 0 |
162645 | 162645 | 2020-05-20 | Dyer | Tennessee | 47045 | 45 | 0 |
165674 | 165674 | 2020-05-21 | Dyer | Tennessee | 47045 | 45 | 0 |
168710 | 168710 | 2020-05-22 | Dyer | Tennessee | 47045 | 46 | 0 |
171749 | 171749 | 2020-05-23 | Dyer | Tennessee | 47045 | 48 | 0 |
174792 | 174792 | 2020-05-24 | Dyer | Tennessee | 47045 | 48 | 0 |
177836 | 177836 | 2020-05-25 | Dyer | Tennessee | 47045 | 48 | 0 |
180879 | 180879 | 2020-05-26 | Dyer | Tennessee | 47045 | 48 | 0 |
183929 | 183929 | 2020-05-27 | Dyer | Tennessee | 47045 | 49 | 0 |
186986 | 186986 | 2020-05-28 | Dyer | Tennessee | 47045 | 50 | 0 |
190050 | 190050 | 2020-05-29 | Dyer | Tennessee | 47045 | 50 | 0 |
193115 | 193115 | 2020-05-30 | Dyer | Tennessee | 47045 | 50 | 0 |
196185 | 196185 | 2020-05-31 | Dyer | Tennessee | 47045 | 50 | 0 |
199258 | 199258 | 2020-06-01 | Dyer | Tennessee | 47045 | 50 | 0 |
202333 | 202333 | 2020-06-02 | Dyer | Tennessee | 47045 | 55 | 0 |
205412 | 205412 | 2020-06-03 | Dyer | Tennessee | 47045 | 57 | 0 |
208494 | 208494 | 2020-06-04 | Dyer | Tennessee | 47045 | 57 | 0 |
211576 | 211576 | 2020-06-05 | Dyer | Tennessee | 47045 | 59 | 0 |
214663 | 214663 | 2020-06-06 | Dyer | Tennessee | 47045 | 60 | 0 |
217753 | 217753 | 2020-06-07 | Dyer | Tennessee | 47045 | 61 | 0 |
220845 | 220845 | 2020-06-08 | Dyer | Tennessee | 47045 | 67 | 0 |
223940 | 223940 | 2020-06-09 | Dyer | Tennessee | 47045 | 70 | 0 |
227040 | 227040 | 2020-06-10 | Dyer | Tennessee | 47045 | 71 | 0 |
230144 | 230144 | 2020-06-11 | Dyer | Tennessee | 47045 | 73 | 0 |
233249 | 233249 | 2020-06-12 | Dyer | Tennessee | 47045 | 82 | 0 |
236355 | 236355 | 2020-06-13 | Dyer | Tennessee | 47045 | 86 | 0 |
239463 | 239463 | 2020-06-14 | Dyer | Tennessee | 47045 | 91 | 0 |
242573 | 242573 | 2020-06-15 | Dyer | Tennessee | 47045 | 99 | 0 |
245685 | 245685 | 2020-06-16 | Dyer | Tennessee | 47045 | 106 | 0 |
248798 | 248798 | 2020-06-17 | Dyer | Tennessee | 47045 | 116 | 0 |
251913 | 251913 | 2020-06-18 | Dyer | Tennessee | 47045 | 122 | 0 |
255028 | 255028 | 2020-06-19 | Dyer | Tennessee | 47045 | 141 | 0 |
258154 | 258154 | 2020-06-20 | Dyer | Tennessee | 47045 | 145 | 0 |
261281 | 261281 | 2020-06-21 | Dyer | Tennessee | 47045 | 158 | 0 |
264409 | 264409 | 2020-06-22 | Dyer | Tennessee | 47045 | 164 | 0 |
267537 | 267537 | 2020-06-23 | Dyer | Tennessee | 47045 | 174 | 0 |
270671 | 270671 | 2020-06-24 | Dyer | Tennessee | 47045 | 181 | 0 |
273810 | 273810 | 2020-06-25 | Dyer | Tennessee | 47045 | 181 | 0 |
276957 | 276957 | 2020-06-26 | Dyer | Tennessee | 47045 | 184 | 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);