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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
410979 | 410979 | 2020-08-07 | Cumberland | Tennessee | 47035 | 412 | 6 |
407760 | 407760 | 2020-08-06 | Cumberland | Tennessee | 47035 | 398 | 6 |
404540 | 404540 | 2020-08-05 | Cumberland | Tennessee | 47035 | 397 | 6 |
401322 | 401322 | 2020-08-04 | Cumberland | Tennessee | 47035 | 385 | 6 |
398107 | 398107 | 2020-08-03 | Cumberland | Tennessee | 47035 | 379 | 6 |
394890 | 394890 | 2020-08-02 | Cumberland | Tennessee | 47035 | 375 | 6 |
391674 | 391674 | 2020-08-01 | Cumberland | Tennessee | 47035 | 374 | 6 |
388457 | 388457 | 2020-07-31 | Cumberland | Tennessee | 47035 | 365 | 6 |
385240 | 385240 | 2020-07-30 | Cumberland | Tennessee | 47035 | 356 | 6 |
382022 | 382022 | 2020-07-29 | Cumberland | Tennessee | 47035 | 346 | 6 |
378805 | 378805 | 2020-07-28 | Cumberland | Tennessee | 47035 | 337 | 6 |
375589 | 375589 | 2020-07-27 | Cumberland | Tennessee | 47035 | 325 | 6 |
372376 | 372376 | 2020-07-26 | Cumberland | Tennessee | 47035 | 300 | 6 |
369164 | 369164 | 2020-07-25 | Cumberland | Tennessee | 47035 | 290 | 6 |
365955 | 365955 | 2020-07-24 | Cumberland | Tennessee | 47035 | 287 | 6 |
362749 | 362749 | 2020-07-23 | Cumberland | Tennessee | 47035 | 287 | 6 |
359542 | 359542 | 2020-07-22 | Cumberland | Tennessee | 47035 | 276 | 6 |
356338 | 356338 | 2020-07-21 | Cumberland | Tennessee | 47035 | 273 | 6 |
353135 | 353135 | 2020-07-20 | Cumberland | Tennessee | 47035 | 255 | 6 |
349932 | 349932 | 2020-07-19 | Cumberland | Tennessee | 47035 | 253 | 6 |
346732 | 346732 | 2020-07-18 | Cumberland | Tennessee | 47035 | 252 | 6 |
343532 | 343532 | 2020-07-17 | Cumberland | Tennessee | 47035 | 247 | 6 |
340334 | 340334 | 2020-07-16 | Cumberland | Tennessee | 47035 | 244 | 5 |
337137 | 337137 | 2020-07-15 | Cumberland | Tennessee | 47035 | 241 | 5 |
333943 | 333943 | 2020-07-14 | Cumberland | Tennessee | 47035 | 228 | 5 |
330751 | 330751 | 2020-07-13 | Cumberland | Tennessee | 47035 | 229 | 4 |
327565 | 327565 | 2020-07-12 | Cumberland | Tennessee | 47035 | 221 | 4 |
324380 | 324380 | 2020-07-11 | Cumberland | Tennessee | 47035 | 213 | 4 |
321199 | 321199 | 2020-07-10 | Cumberland | Tennessee | 47035 | 200 | 4 |
318021 | 318021 | 2020-07-09 | Cumberland | Tennessee | 47035 | 196 | 4 |
314848 | 314848 | 2020-07-08 | Cumberland | Tennessee | 47035 | 193 | 4 |
311674 | 311674 | 2020-07-07 | Cumberland | Tennessee | 47035 | 188 | 4 |
308505 | 308505 | 2020-07-06 | Cumberland | Tennessee | 47035 | 183 | 4 |
305337 | 305337 | 2020-07-05 | Cumberland | Tennessee | 47035 | 181 | 4 |
302174 | 302174 | 2020-07-04 | Cumberland | Tennessee | 47035 | 180 | 4 |
299010 | 299010 | 2020-07-03 | Cumberland | Tennessee | 47035 | 178 | 4 |
295850 | 295850 | 2020-07-02 | Cumberland | Tennessee | 47035 | 174 | 4 |
292694 | 292694 | 2020-07-01 | Cumberland | Tennessee | 47035 | 173 | 3 |
289542 | 289542 | 2020-06-30 | Cumberland | Tennessee | 47035 | 168 | 3 |
286391 | 286391 | 2020-06-29 | Cumberland | Tennessee | 47035 | 165 | 3 |
283246 | 283246 | 2020-06-28 | Cumberland | Tennessee | 47035 | 159 | 3 |
280100 | 280100 | 2020-06-27 | Cumberland | Tennessee | 47035 | 159 | 3 |
276952 | 276952 | 2020-06-26 | Cumberland | Tennessee | 47035 | 159 | 3 |
273805 | 273805 | 2020-06-25 | Cumberland | Tennessee | 47035 | 155 | 3 |
270666 | 270666 | 2020-06-24 | Cumberland | Tennessee | 47035 | 152 | 3 |
267532 | 267532 | 2020-06-23 | Cumberland | Tennessee | 47035 | 148 | 3 |
264404 | 264404 | 2020-06-22 | Cumberland | Tennessee | 47035 | 145 | 3 |
261276 | 261276 | 2020-06-21 | Cumberland | Tennessee | 47035 | 142 | 3 |
258149 | 258149 | 2020-06-20 | Cumberland | Tennessee | 47035 | 137 | 3 |
255023 | 255023 | 2020-06-19 | Cumberland | Tennessee | 47035 | 137 | 3 |
251908 | 251908 | 2020-06-18 | Cumberland | Tennessee | 47035 | 138 | 3 |
248793 | 248793 | 2020-06-17 | Cumberland | Tennessee | 47035 | 137 | 3 |
245680 | 245680 | 2020-06-16 | Cumberland | Tennessee | 47035 | 137 | 2 |
242568 | 242568 | 2020-06-15 | Cumberland | Tennessee | 47035 | 133 | 2 |
239458 | 239458 | 2020-06-14 | Cumberland | Tennessee | 47035 | 131 | 2 |
236350 | 236350 | 2020-06-13 | Cumberland | Tennessee | 47035 | 131 | 2 |
233244 | 233244 | 2020-06-12 | Cumberland | Tennessee | 47035 | 130 | 2 |
230139 | 230139 | 2020-06-11 | Cumberland | Tennessee | 47035 | 129 | 2 |
227035 | 227035 | 2020-06-10 | Cumberland | Tennessee | 47035 | 127 | 2 |
223935 | 223935 | 2020-06-09 | Cumberland | Tennessee | 47035 | 126 | 2 |
220840 | 220840 | 2020-06-08 | Cumberland | Tennessee | 47035 | 125 | 2 |
217748 | 217748 | 2020-06-07 | Cumberland | Tennessee | 47035 | 125 | 2 |
214658 | 214658 | 2020-06-06 | Cumberland | Tennessee | 47035 | 124 | 2 |
211571 | 211571 | 2020-06-05 | Cumberland | Tennessee | 47035 | 120 | 2 |
208489 | 208489 | 2020-06-04 | Cumberland | Tennessee | 47035 | 120 | 2 |
205407 | 205407 | 2020-06-03 | Cumberland | Tennessee | 47035 | 119 | 1 |
202328 | 202328 | 2020-06-02 | Cumberland | Tennessee | 47035 | 118 | 1 |
199253 | 199253 | 2020-06-01 | Cumberland | Tennessee | 47035 | 112 | 1 |
196180 | 196180 | 2020-05-31 | Cumberland | Tennessee | 47035 | 112 | 1 |
193110 | 193110 | 2020-05-30 | Cumberland | Tennessee | 47035 | 112 | 1 |
190045 | 190045 | 2020-05-29 | Cumberland | Tennessee | 47035 | 111 | 1 |
186981 | 186981 | 2020-05-28 | Cumberland | Tennessee | 47035 | 111 | 1 |
183924 | 183924 | 2020-05-27 | Cumberland | Tennessee | 47035 | 111 | 1 |
180874 | 180874 | 2020-05-26 | Cumberland | Tennessee | 47035 | 111 | 1 |
177831 | 177831 | 2020-05-25 | Cumberland | Tennessee | 47035 | 109 | 1 |
174787 | 174787 | 2020-05-24 | Cumberland | Tennessee | 47035 | 109 | 1 |
171744 | 171744 | 2020-05-23 | Cumberland | Tennessee | 47035 | 107 | 1 |
168705 | 168705 | 2020-05-22 | Cumberland | Tennessee | 47035 | 97 | 1 |
165669 | 165669 | 2020-05-21 | Cumberland | Tennessee | 47035 | 96 | 1 |
162640 | 162640 | 2020-05-20 | Cumberland | Tennessee | 47035 | 94 | 1 |
159613 | 159613 | 2020-05-19 | Cumberland | Tennessee | 47035 | 94 | 1 |
156592 | 156592 | 2020-05-18 | Cumberland | Tennessee | 47035 | 93 | 1 |
153575 | 153575 | 2020-05-17 | Cumberland | Tennessee | 47035 | 89 | 1 |
150564 | 150564 | 2020-05-16 | Cumberland | Tennessee | 47035 | 88 | 1 |
147556 | 147556 | 2020-05-15 | Cumberland | Tennessee | 47035 | 88 | 1 |
144555 | 144555 | 2020-05-14 | Cumberland | Tennessee | 47035 | 87 | 1 |
141558 | 141558 | 2020-05-13 | Cumberland | Tennessee | 47035 | 87 | 1 |
138562 | 138562 | 2020-05-12 | Cumberland | Tennessee | 47035 | 86 | 1 |
135572 | 135572 | 2020-05-11 | Cumberland | Tennessee | 47035 | 84 | 1 |
132581 | 132581 | 2020-05-10 | Cumberland | Tennessee | 47035 | 85 | 1 |
129592 | 129592 | 2020-05-09 | Cumberland | Tennessee | 47035 | 85 | 1 |
126603 | 126603 | 2020-05-08 | Cumberland | Tennessee | 47035 | 84 | 1 |
123620 | 123620 | 2020-05-07 | Cumberland | Tennessee | 47035 | 84 | 1 |
120642 | 120642 | 2020-05-06 | Cumberland | Tennessee | 47035 | 85 | 1 |
117678 | 117678 | 2020-05-05 | Cumberland | Tennessee | 47035 | 84 | 1 |
114722 | 114722 | 2020-05-04 | Cumberland | Tennessee | 47035 | 84 | 1 |
111840 | 111840 | 2020-05-03 | Cumberland | Tennessee | 47035 | 80 | 1 |
108966 | 108966 | 2020-05-02 | Cumberland | Tennessee | 47035 | 74 | 1 |
106099 | 106099 | 2020-05-01 | Cumberland | Tennessee | 47035 | 74 | 1 |
103236 | 103236 | 2020-04-30 | Cumberland | Tennessee | 47035 | 74 | 1 |
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);