ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 47013 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
333932 | 333932 | 2020-07-14 | Campbell | Tennessee | 47013 | 75 | 1 |
330740 | 330740 | 2020-07-13 | Campbell | Tennessee | 47013 | 72 | 1 |
327554 | 327554 | 2020-07-12 | Campbell | Tennessee | 47013 | 70 | 1 |
324369 | 324369 | 2020-07-11 | Campbell | Tennessee | 47013 | 69 | 1 |
321188 | 321188 | 2020-07-10 | Campbell | Tennessee | 47013 | 67 | 1 |
318010 | 318010 | 2020-07-09 | Campbell | Tennessee | 47013 | 65 | 1 |
314837 | 314837 | 2020-07-08 | Campbell | Tennessee | 47013 | 62 | 1 |
311663 | 311663 | 2020-07-07 | Campbell | Tennessee | 47013 | 54 | 1 |
308494 | 308494 | 2020-07-06 | Campbell | Tennessee | 47013 | 51 | 1 |
305326 | 305326 | 2020-07-05 | Campbell | Tennessee | 47013 | 48 | 1 |
302163 | 302163 | 2020-07-04 | Campbell | Tennessee | 47013 | 48 | 1 |
298999 | 298999 | 2020-07-03 | Campbell | Tennessee | 47013 | 44 | 1 |
295839 | 295839 | 2020-07-02 | Campbell | Tennessee | 47013 | 41 | 1 |
292683 | 292683 | 2020-07-01 | Campbell | Tennessee | 47013 | 39 | 1 |
289531 | 289531 | 2020-06-30 | Campbell | Tennessee | 47013 | 36 | 1 |
286380 | 286380 | 2020-06-29 | Campbell | Tennessee | 47013 | 31 | 1 |
283235 | 283235 | 2020-06-28 | Campbell | Tennessee | 47013 | 31 | 1 |
280089 | 280089 | 2020-06-27 | Campbell | Tennessee | 47013 | 31 | 1 |
276941 | 276941 | 2020-06-26 | Campbell | Tennessee | 47013 | 29 | 1 |
273794 | 273794 | 2020-06-25 | Campbell | Tennessee | 47013 | 28 | 1 |
270655 | 270655 | 2020-06-24 | Campbell | Tennessee | 47013 | 27 | 1 |
267521 | 267521 | 2020-06-23 | Campbell | Tennessee | 47013 | 27 | 1 |
264393 | 264393 | 2020-06-22 | Campbell | Tennessee | 47013 | 26 | 1 |
261265 | 261265 | 2020-06-21 | Campbell | Tennessee | 47013 | 26 | 1 |
258138 | 258138 | 2020-06-20 | Campbell | Tennessee | 47013 | 26 | 1 |
255012 | 255012 | 2020-06-19 | Campbell | Tennessee | 47013 | 26 | 1 |
251897 | 251897 | 2020-06-18 | Campbell | Tennessee | 47013 | 26 | 1 |
248782 | 248782 | 2020-06-17 | Campbell | Tennessee | 47013 | 25 | 1 |
245669 | 245669 | 2020-06-16 | Campbell | Tennessee | 47013 | 25 | 1 |
242557 | 242557 | 2020-06-15 | Campbell | Tennessee | 47013 | 24 | 1 |
239447 | 239447 | 2020-06-14 | Campbell | Tennessee | 47013 | 24 | 1 |
236339 | 236339 | 2020-06-13 | Campbell | Tennessee | 47013 | 24 | 1 |
233233 | 233233 | 2020-06-12 | Campbell | Tennessee | 47013 | 22 | 1 |
230128 | 230128 | 2020-06-11 | Campbell | Tennessee | 47013 | 18 | 1 |
227024 | 227024 | 2020-06-10 | Campbell | Tennessee | 47013 | 18 | 1 |
223924 | 223924 | 2020-06-09 | Campbell | Tennessee | 47013 | 18 | 1 |
220829 | 220829 | 2020-06-08 | Campbell | Tennessee | 47013 | 18 | 1 |
217737 | 217737 | 2020-06-07 | Campbell | Tennessee | 47013 | 18 | 1 |
214647 | 214647 | 2020-06-06 | Campbell | Tennessee | 47013 | 18 | 1 |
211560 | 211560 | 2020-06-05 | Campbell | Tennessee | 47013 | 18 | 1 |
208478 | 208478 | 2020-06-04 | Campbell | Tennessee | 47013 | 18 | 1 |
205396 | 205396 | 2020-06-03 | Campbell | Tennessee | 47013 | 18 | 1 |
202317 | 202317 | 2020-06-02 | Campbell | Tennessee | 47013 | 18 | 1 |
199242 | 199242 | 2020-06-01 | Campbell | Tennessee | 47013 | 18 | 1 |
196169 | 196169 | 2020-05-31 | Campbell | Tennessee | 47013 | 18 | 1 |
193099 | 193099 | 2020-05-30 | Campbell | Tennessee | 47013 | 18 | 1 |
190034 | 190034 | 2020-05-29 | Campbell | Tennessee | 47013 | 17 | 1 |
186970 | 186970 | 2020-05-28 | Campbell | Tennessee | 47013 | 17 | 1 |
183913 | 183913 | 2020-05-27 | Campbell | Tennessee | 47013 | 17 | 1 |
180863 | 180863 | 2020-05-26 | Campbell | Tennessee | 47013 | 17 | 1 |
177820 | 177820 | 2020-05-25 | Campbell | Tennessee | 47013 | 17 | 1 |
174776 | 174776 | 2020-05-24 | Campbell | Tennessee | 47013 | 17 | 1 |
171733 | 171733 | 2020-05-23 | Campbell | Tennessee | 47013 | 17 | 1 |
168694 | 168694 | 2020-05-22 | Campbell | Tennessee | 47013 | 17 | 1 |
165658 | 165658 | 2020-05-21 | Campbell | Tennessee | 47013 | 17 | 1 |
162629 | 162629 | 2020-05-20 | Campbell | Tennessee | 47013 | 17 | 1 |
159602 | 159602 | 2020-05-19 | Campbell | Tennessee | 47013 | 17 | 1 |
156581 | 156581 | 2020-05-18 | Campbell | Tennessee | 47013 | 17 | 1 |
153564 | 153564 | 2020-05-17 | Campbell | Tennessee | 47013 | 17 | 1 |
150553 | 150553 | 2020-05-16 | Campbell | Tennessee | 47013 | 17 | 1 |
147545 | 147545 | 2020-05-15 | Campbell | Tennessee | 47013 | 17 | 1 |
144544 | 144544 | 2020-05-14 | Campbell | Tennessee | 47013 | 17 | 1 |
141547 | 141547 | 2020-05-13 | Campbell | Tennessee | 47013 | 17 | 1 |
138551 | 138551 | 2020-05-12 | Campbell | Tennessee | 47013 | 17 | 1 |
135561 | 135561 | 2020-05-11 | Campbell | Tennessee | 47013 | 17 | 1 |
132570 | 132570 | 2020-05-10 | Campbell | Tennessee | 47013 | 17 | 1 |
129581 | 129581 | 2020-05-09 | Campbell | Tennessee | 47013 | 16 | 1 |
126592 | 126592 | 2020-05-08 | Campbell | Tennessee | 47013 | 16 | 1 |
123609 | 123609 | 2020-05-07 | Campbell | Tennessee | 47013 | 16 | 1 |
120631 | 120631 | 2020-05-06 | Campbell | Tennessee | 47013 | 16 | 1 |
117667 | 117667 | 2020-05-05 | Campbell | Tennessee | 47013 | 17 | 1 |
114711 | 114711 | 2020-05-04 | Campbell | Tennessee | 47013 | 17 | 1 |
111829 | 111829 | 2020-05-03 | Campbell | Tennessee | 47013 | 16 | 1 |
108955 | 108955 | 2020-05-02 | Campbell | Tennessee | 47013 | 16 | 1 |
106088 | 106088 | 2020-05-01 | Campbell | Tennessee | 47013 | 16 | 1 |
103225 | 103225 | 2020-04-30 | Campbell | Tennessee | 47013 | 15 | 1 |
100372 | 100372 | 2020-04-29 | Campbell | Tennessee | 47013 | 14 | 1 |
97522 | 97522 | 2020-04-28 | Campbell | Tennessee | 47013 | 14 | 1 |
94682 | 94682 | 2020-04-27 | Campbell | Tennessee | 47013 | 14 | 1 |
91854 | 91854 | 2020-04-26 | Campbell | Tennessee | 47013 | 14 | 1 |
89037 | 89037 | 2020-04-25 | Campbell | Tennessee | 47013 | 13 | 1 |
86222 | 86222 | 2020-04-24 | Campbell | Tennessee | 47013 | 13 | 1 |
83417 | 83417 | 2020-04-23 | Campbell | Tennessee | 47013 | 13 | 1 |
80618 | 80618 | 2020-04-22 | Campbell | Tennessee | 47013 | 14 | 1 |
77828 | 77828 | 2020-04-21 | Campbell | Tennessee | 47013 | 14 | 1 |
75046 | 75046 | 2020-04-20 | Campbell | Tennessee | 47013 | 14 | 1 |
72271 | 72271 | 2020-04-19 | Campbell | Tennessee | 47013 | 13 | 1 |
69504 | 69504 | 2020-04-18 | Campbell | Tennessee | 47013 | 13 | 1 |
66746 | 66746 | 2020-04-17 | Campbell | Tennessee | 47013 | 13 | 1 |
64000 | 64000 | 2020-04-16 | Campbell | Tennessee | 47013 | 12 | 1 |
61273 | 61273 | 2020-04-15 | Campbell | Tennessee | 47013 | 12 | 1 |
58558 | 58558 | 2020-04-14 | Campbell | Tennessee | 47013 | 12 | 0 |
55855 | 55855 | 2020-04-13 | Campbell | Tennessee | 47013 | 11 | 0 |
53169 | 53169 | 2020-04-12 | Campbell | Tennessee | 47013 | 10 | 0 |
50494 | 50494 | 2020-04-11 | Campbell | Tennessee | 47013 | 10 | 0 |
47836 | 47836 | 2020-04-10 | Campbell | Tennessee | 47013 | 10 | 0 |
45218 | 45218 | 2020-04-09 | Campbell | Tennessee | 47013 | 9 | 0 |
42631 | 42631 | 2020-04-08 | Campbell | Tennessee | 47013 | 6 | 0 |
40070 | 40070 | 2020-04-07 | Campbell | Tennessee | 47013 | 6 | 0 |
37547 | 37547 | 2020-04-06 | Campbell | Tennessee | 47013 | 5 | 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);