ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Cumberland" 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 |
---|---|---|---|---|---|---|---|
5026 | 5026 | 2020-03-19 | Cumberland | Tennessee | 47035 | 1 | 0 |
5910 | 5910 | 2020-03-20 | Cumberland | Tennessee | 47035 | 2 | 0 |
6922 | 6922 | 2020-03-21 | Cumberland | Tennessee | 47035 | 2 | 0 |
8045 | 8045 | 2020-03-22 | Cumberland | Tennessee | 47035 | 2 | 0 |
9263 | 9263 | 2020-03-23 | Cumberland | Tennessee | 47035 | 2 | 0 |
10591 | 10591 | 2020-03-24 | Cumberland | Tennessee | 47035 | 3 | 0 |
12068 | 12068 | 2020-03-25 | Cumberland | Tennessee | 47035 | 3 | 0 |
13692 | 13692 | 2020-03-26 | Cumberland | Tennessee | 47035 | 6 | 0 |
15444 | 15444 | 2020-03-27 | Cumberland | Tennessee | 47035 | 6 | 0 |
17305 | 17305 | 2020-03-28 | Cumberland | Tennessee | 47035 | 6 | 0 |
19251 | 19251 | 2020-03-29 | Cumberland | Tennessee | 47035 | 9 | 0 |
21304 | 21304 | 2020-03-30 | Cumberland | Tennessee | 47035 | 11 | 0 |
23442 | 23442 | 2020-03-31 | Cumberland | Tennessee | 47035 | 11 | 0 |
25641 | 25641 | 2020-04-01 | Cumberland | Tennessee | 47035 | 14 | 0 |
27919 | 27919 | 2020-04-02 | Cumberland | Tennessee | 47035 | 16 | 0 |
30254 | 30254 | 2020-04-03 | Cumberland | Tennessee | 47035 | 22 | 0 |
32645 | 32645 | 2020-04-04 | Cumberland | Tennessee | 47035 | 23 | 0 |
35081 | 35081 | 2020-04-05 | Cumberland | Tennessee | 47035 | 26 | 0 |
37557 | 37557 | 2020-04-06 | Cumberland | Tennessee | 47035 | 26 | 0 |
40080 | 40080 | 2020-04-07 | Cumberland | Tennessee | 47035 | 32 | 0 |
42641 | 42641 | 2020-04-08 | Cumberland | Tennessee | 47035 | 33 | 0 |
45228 | 45228 | 2020-04-09 | Cumberland | Tennessee | 47035 | 34 | 0 |
47846 | 47846 | 2020-04-10 | Cumberland | Tennessee | 47035 | 39 | 0 |
50504 | 50504 | 2020-04-11 | Cumberland | Tennessee | 47035 | 40 | 0 |
53179 | 53179 | 2020-04-12 | Cumberland | Tennessee | 47035 | 40 | 0 |
55865 | 55865 | 2020-04-13 | Cumberland | Tennessee | 47035 | 43 | 0 |
58568 | 58568 | 2020-04-14 | Cumberland | Tennessee | 47035 | 51 | 0 |
61283 | 61283 | 2020-04-15 | Cumberland | Tennessee | 47035 | 53 | 0 |
64010 | 64010 | 2020-04-16 | Cumberland | Tennessee | 47035 | 55 | 0 |
66756 | 66756 | 2020-04-17 | Cumberland | Tennessee | 47035 | 56 | 0 |
69515 | 69515 | 2020-04-18 | Cumberland | Tennessee | 47035 | 57 | 0 |
72282 | 72282 | 2020-04-19 | Cumberland | Tennessee | 47035 | 57 | 0 |
75057 | 75057 | 2020-04-20 | Cumberland | Tennessee | 47035 | 58 | 0 |
77839 | 77839 | 2020-04-21 | Cumberland | Tennessee | 47035 | 59 | 0 |
80629 | 80629 | 2020-04-22 | Cumberland | Tennessee | 47035 | 60 | 0 |
83428 | 83428 | 2020-04-23 | Cumberland | Tennessee | 47035 | 61 | 0 |
86233 | 86233 | 2020-04-24 | Cumberland | Tennessee | 47035 | 67 | 0 |
89048 | 89048 | 2020-04-25 | Cumberland | Tennessee | 47035 | 67 | 0 |
91865 | 91865 | 2020-04-26 | Cumberland | Tennessee | 47035 | 67 | 0 |
94693 | 94693 | 2020-04-27 | Cumberland | Tennessee | 47035 | 68 | 0 |
97533 | 97533 | 2020-04-28 | Cumberland | Tennessee | 47035 | 70 | 1 |
100383 | 100383 | 2020-04-29 | Cumberland | Tennessee | 47035 | 74 | 1 |
103236 | 103236 | 2020-04-30 | Cumberland | Tennessee | 47035 | 74 | 1 |
106099 | 106099 | 2020-05-01 | Cumberland | Tennessee | 47035 | 74 | 1 |
108966 | 108966 | 2020-05-02 | Cumberland | Tennessee | 47035 | 74 | 1 |
111840 | 111840 | 2020-05-03 | Cumberland | Tennessee | 47035 | 80 | 1 |
114722 | 114722 | 2020-05-04 | Cumberland | Tennessee | 47035 | 84 | 1 |
117678 | 117678 | 2020-05-05 | Cumberland | Tennessee | 47035 | 84 | 1 |
120642 | 120642 | 2020-05-06 | Cumberland | Tennessee | 47035 | 85 | 1 |
123620 | 123620 | 2020-05-07 | Cumberland | Tennessee | 47035 | 84 | 1 |
126603 | 126603 | 2020-05-08 | Cumberland | Tennessee | 47035 | 84 | 1 |
129592 | 129592 | 2020-05-09 | Cumberland | Tennessee | 47035 | 85 | 1 |
132581 | 132581 | 2020-05-10 | Cumberland | Tennessee | 47035 | 85 | 1 |
135572 | 135572 | 2020-05-11 | Cumberland | Tennessee | 47035 | 84 | 1 |
138562 | 138562 | 2020-05-12 | Cumberland | Tennessee | 47035 | 86 | 1 |
141558 | 141558 | 2020-05-13 | Cumberland | Tennessee | 47035 | 87 | 1 |
144555 | 144555 | 2020-05-14 | Cumberland | Tennessee | 47035 | 87 | 1 |
147556 | 147556 | 2020-05-15 | Cumberland | Tennessee | 47035 | 88 | 1 |
150564 | 150564 | 2020-05-16 | Cumberland | Tennessee | 47035 | 88 | 1 |
153575 | 153575 | 2020-05-17 | Cumberland | Tennessee | 47035 | 89 | 1 |
156592 | 156592 | 2020-05-18 | Cumberland | Tennessee | 47035 | 93 | 1 |
159613 | 159613 | 2020-05-19 | Cumberland | Tennessee | 47035 | 94 | 1 |
162640 | 162640 | 2020-05-20 | Cumberland | Tennessee | 47035 | 94 | 1 |
165669 | 165669 | 2020-05-21 | Cumberland | Tennessee | 47035 | 96 | 1 |
168705 | 168705 | 2020-05-22 | Cumberland | Tennessee | 47035 | 97 | 1 |
171744 | 171744 | 2020-05-23 | Cumberland | Tennessee | 47035 | 107 | 1 |
174787 | 174787 | 2020-05-24 | Cumberland | Tennessee | 47035 | 109 | 1 |
177831 | 177831 | 2020-05-25 | Cumberland | Tennessee | 47035 | 109 | 1 |
180874 | 180874 | 2020-05-26 | Cumberland | Tennessee | 47035 | 111 | 1 |
183924 | 183924 | 2020-05-27 | Cumberland | Tennessee | 47035 | 111 | 1 |
186981 | 186981 | 2020-05-28 | Cumberland | Tennessee | 47035 | 111 | 1 |
190045 | 190045 | 2020-05-29 | Cumberland | Tennessee | 47035 | 111 | 1 |
193110 | 193110 | 2020-05-30 | Cumberland | Tennessee | 47035 | 112 | 1 |
196180 | 196180 | 2020-05-31 | Cumberland | Tennessee | 47035 | 112 | 1 |
199253 | 199253 | 2020-06-01 | Cumberland | Tennessee | 47035 | 112 | 1 |
202328 | 202328 | 2020-06-02 | Cumberland | Tennessee | 47035 | 118 | 1 |
205407 | 205407 | 2020-06-03 | Cumberland | Tennessee | 47035 | 119 | 1 |
208489 | 208489 | 2020-06-04 | Cumberland | Tennessee | 47035 | 120 | 2 |
211571 | 211571 | 2020-06-05 | Cumberland | Tennessee | 47035 | 120 | 2 |
214658 | 214658 | 2020-06-06 | Cumberland | Tennessee | 47035 | 124 | 2 |
217748 | 217748 | 2020-06-07 | Cumberland | Tennessee | 47035 | 125 | 2 |
220840 | 220840 | 2020-06-08 | Cumberland | Tennessee | 47035 | 125 | 2 |
223935 | 223935 | 2020-06-09 | Cumberland | Tennessee | 47035 | 126 | 2 |
227035 | 227035 | 2020-06-10 | Cumberland | Tennessee | 47035 | 127 | 2 |
230139 | 230139 | 2020-06-11 | Cumberland | Tennessee | 47035 | 129 | 2 |
233244 | 233244 | 2020-06-12 | Cumberland | Tennessee | 47035 | 130 | 2 |
236350 | 236350 | 2020-06-13 | Cumberland | Tennessee | 47035 | 131 | 2 |
239458 | 239458 | 2020-06-14 | Cumberland | Tennessee | 47035 | 131 | 2 |
242568 | 242568 | 2020-06-15 | Cumberland | Tennessee | 47035 | 133 | 2 |
245680 | 245680 | 2020-06-16 | Cumberland | Tennessee | 47035 | 137 | 2 |
248793 | 248793 | 2020-06-17 | Cumberland | Tennessee | 47035 | 137 | 3 |
251908 | 251908 | 2020-06-18 | Cumberland | Tennessee | 47035 | 138 | 3 |
255023 | 255023 | 2020-06-19 | Cumberland | Tennessee | 47035 | 137 | 3 |
258149 | 258149 | 2020-06-20 | Cumberland | Tennessee | 47035 | 137 | 3 |
261276 | 261276 | 2020-06-21 | Cumberland | Tennessee | 47035 | 142 | 3 |
264404 | 264404 | 2020-06-22 | Cumberland | Tennessee | 47035 | 145 | 3 |
267532 | 267532 | 2020-06-23 | Cumberland | Tennessee | 47035 | 148 | 3 |
270666 | 270666 | 2020-06-24 | Cumberland | Tennessee | 47035 | 152 | 3 |
273805 | 273805 | 2020-06-25 | Cumberland | Tennessee | 47035 | 155 | 3 |
276952 | 276952 | 2020-06-26 | Cumberland | Tennessee | 47035 | 159 | 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);