ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 47013 sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2235 | 2235 | 2020-03-14 | Campbell | Tennessee | 47013 | 1 | 0 |
2660 | 2660 | 2020-03-15 | Campbell | Tennessee | 47013 | 1 | 0 |
3126 | 3126 | 2020-03-16 | Campbell | Tennessee | 47013 | 1 | 0 |
3659 | 3659 | 2020-03-17 | Campbell | Tennessee | 47013 | 1 | 0 |
4279 | 4279 | 2020-03-18 | Campbell | Tennessee | 47013 | 1 | 0 |
5024 | 5024 | 2020-03-19 | Campbell | Tennessee | 47013 | 1 | 0 |
5908 | 5908 | 2020-03-20 | Campbell | Tennessee | 47013 | 1 | 0 |
6918 | 6918 | 2020-03-21 | Campbell | Tennessee | 47013 | 2 | 0 |
8040 | 8040 | 2020-03-22 | Campbell | Tennessee | 47013 | 2 | 0 |
9258 | 9258 | 2020-03-23 | Campbell | Tennessee | 47013 | 2 | 0 |
10585 | 10585 | 2020-03-24 | Campbell | Tennessee | 47013 | 2 | 0 |
12062 | 12062 | 2020-03-25 | Campbell | Tennessee | 47013 | 2 | 0 |
13685 | 13685 | 2020-03-26 | Campbell | Tennessee | 47013 | 2 | 0 |
15437 | 15437 | 2020-03-27 | Campbell | Tennessee | 47013 | 4 | 0 |
17297 | 17297 | 2020-03-28 | Campbell | Tennessee | 47013 | 4 | 0 |
19242 | 19242 | 2020-03-29 | Campbell | Tennessee | 47013 | 4 | 0 |
21295 | 21295 | 2020-03-30 | Campbell | Tennessee | 47013 | 4 | 0 |
23433 | 23433 | 2020-03-31 | Campbell | Tennessee | 47013 | 4 | 0 |
25631 | 25631 | 2020-04-01 | Campbell | Tennessee | 47013 | 4 | 0 |
27909 | 27909 | 2020-04-02 | Campbell | Tennessee | 47013 | 4 | 0 |
30244 | 30244 | 2020-04-03 | Campbell | Tennessee | 47013 | 4 | 0 |
32635 | 32635 | 2020-04-04 | Campbell | Tennessee | 47013 | 5 | 0 |
35071 | 35071 | 2020-04-05 | Campbell | Tennessee | 47013 | 5 | 0 |
37547 | 37547 | 2020-04-06 | Campbell | Tennessee | 47013 | 5 | 0 |
40070 | 40070 | 2020-04-07 | Campbell | Tennessee | 47013 | 6 | 0 |
42631 | 42631 | 2020-04-08 | Campbell | Tennessee | 47013 | 6 | 0 |
45218 | 45218 | 2020-04-09 | Campbell | Tennessee | 47013 | 9 | 0 |
47836 | 47836 | 2020-04-10 | Campbell | Tennessee | 47013 | 10 | 0 |
50494 | 50494 | 2020-04-11 | Campbell | Tennessee | 47013 | 10 | 0 |
53169 | 53169 | 2020-04-12 | Campbell | Tennessee | 47013 | 10 | 0 |
55855 | 55855 | 2020-04-13 | Campbell | Tennessee | 47013 | 11 | 0 |
58558 | 58558 | 2020-04-14 | Campbell | Tennessee | 47013 | 12 | 0 |
61273 | 61273 | 2020-04-15 | Campbell | Tennessee | 47013 | 12 | 1 |
64000 | 64000 | 2020-04-16 | Campbell | Tennessee | 47013 | 12 | 1 |
66746 | 66746 | 2020-04-17 | Campbell | Tennessee | 47013 | 13 | 1 |
69504 | 69504 | 2020-04-18 | Campbell | Tennessee | 47013 | 13 | 1 |
72271 | 72271 | 2020-04-19 | Campbell | Tennessee | 47013 | 13 | 1 |
75046 | 75046 | 2020-04-20 | Campbell | Tennessee | 47013 | 14 | 1 |
77828 | 77828 | 2020-04-21 | Campbell | Tennessee | 47013 | 14 | 1 |
80618 | 80618 | 2020-04-22 | Campbell | Tennessee | 47013 | 14 | 1 |
83417 | 83417 | 2020-04-23 | Campbell | Tennessee | 47013 | 13 | 1 |
86222 | 86222 | 2020-04-24 | Campbell | Tennessee | 47013 | 13 | 1 |
89037 | 89037 | 2020-04-25 | Campbell | Tennessee | 47013 | 13 | 1 |
91854 | 91854 | 2020-04-26 | Campbell | Tennessee | 47013 | 14 | 1 |
94682 | 94682 | 2020-04-27 | Campbell | Tennessee | 47013 | 14 | 1 |
97522 | 97522 | 2020-04-28 | Campbell | Tennessee | 47013 | 14 | 1 |
100372 | 100372 | 2020-04-29 | Campbell | Tennessee | 47013 | 14 | 1 |
103225 | 103225 | 2020-04-30 | Campbell | Tennessee | 47013 | 15 | 1 |
106088 | 106088 | 2020-05-01 | Campbell | Tennessee | 47013 | 16 | 1 |
108955 | 108955 | 2020-05-02 | Campbell | Tennessee | 47013 | 16 | 1 |
111829 | 111829 | 2020-05-03 | Campbell | Tennessee | 47013 | 16 | 1 |
114711 | 114711 | 2020-05-04 | Campbell | Tennessee | 47013 | 17 | 1 |
117667 | 117667 | 2020-05-05 | Campbell | Tennessee | 47013 | 17 | 1 |
120631 | 120631 | 2020-05-06 | Campbell | Tennessee | 47013 | 16 | 1 |
123609 | 123609 | 2020-05-07 | Campbell | Tennessee | 47013 | 16 | 1 |
126592 | 126592 | 2020-05-08 | Campbell | Tennessee | 47013 | 16 | 1 |
129581 | 129581 | 2020-05-09 | Campbell | Tennessee | 47013 | 16 | 1 |
132570 | 132570 | 2020-05-10 | Campbell | Tennessee | 47013 | 17 | 1 |
135561 | 135561 | 2020-05-11 | Campbell | Tennessee | 47013 | 17 | 1 |
138551 | 138551 | 2020-05-12 | Campbell | Tennessee | 47013 | 17 | 1 |
141547 | 141547 | 2020-05-13 | Campbell | Tennessee | 47013 | 17 | 1 |
144544 | 144544 | 2020-05-14 | Campbell | Tennessee | 47013 | 17 | 1 |
147545 | 147545 | 2020-05-15 | Campbell | Tennessee | 47013 | 17 | 1 |
150553 | 150553 | 2020-05-16 | Campbell | Tennessee | 47013 | 17 | 1 |
153564 | 153564 | 2020-05-17 | Campbell | Tennessee | 47013 | 17 | 1 |
156581 | 156581 | 2020-05-18 | Campbell | Tennessee | 47013 | 17 | 1 |
159602 | 159602 | 2020-05-19 | Campbell | Tennessee | 47013 | 17 | 1 |
162629 | 162629 | 2020-05-20 | Campbell | Tennessee | 47013 | 17 | 1 |
165658 | 165658 | 2020-05-21 | Campbell | Tennessee | 47013 | 17 | 1 |
168694 | 168694 | 2020-05-22 | Campbell | Tennessee | 47013 | 17 | 1 |
171733 | 171733 | 2020-05-23 | Campbell | Tennessee | 47013 | 17 | 1 |
174776 | 174776 | 2020-05-24 | Campbell | Tennessee | 47013 | 17 | 1 |
177820 | 177820 | 2020-05-25 | Campbell | Tennessee | 47013 | 17 | 1 |
180863 | 180863 | 2020-05-26 | Campbell | Tennessee | 47013 | 17 | 1 |
183913 | 183913 | 2020-05-27 | Campbell | Tennessee | 47013 | 17 | 1 |
186970 | 186970 | 2020-05-28 | Campbell | Tennessee | 47013 | 17 | 1 |
190034 | 190034 | 2020-05-29 | Campbell | Tennessee | 47013 | 17 | 1 |
193099 | 193099 | 2020-05-30 | Campbell | Tennessee | 47013 | 18 | 1 |
196169 | 196169 | 2020-05-31 | Campbell | Tennessee | 47013 | 18 | 1 |
199242 | 199242 | 2020-06-01 | Campbell | Tennessee | 47013 | 18 | 1 |
202317 | 202317 | 2020-06-02 | Campbell | Tennessee | 47013 | 18 | 1 |
205396 | 205396 | 2020-06-03 | Campbell | Tennessee | 47013 | 18 | 1 |
208478 | 208478 | 2020-06-04 | Campbell | Tennessee | 47013 | 18 | 1 |
211560 | 211560 | 2020-06-05 | Campbell | Tennessee | 47013 | 18 | 1 |
214647 | 214647 | 2020-06-06 | Campbell | Tennessee | 47013 | 18 | 1 |
217737 | 217737 | 2020-06-07 | Campbell | Tennessee | 47013 | 18 | 1 |
220829 | 220829 | 2020-06-08 | Campbell | Tennessee | 47013 | 18 | 1 |
223924 | 223924 | 2020-06-09 | Campbell | Tennessee | 47013 | 18 | 1 |
227024 | 227024 | 2020-06-10 | Campbell | Tennessee | 47013 | 18 | 1 |
230128 | 230128 | 2020-06-11 | Campbell | Tennessee | 47013 | 18 | 1 |
233233 | 233233 | 2020-06-12 | Campbell | Tennessee | 47013 | 22 | 1 |
236339 | 236339 | 2020-06-13 | Campbell | Tennessee | 47013 | 24 | 1 |
239447 | 239447 | 2020-06-14 | Campbell | Tennessee | 47013 | 24 | 1 |
242557 | 242557 | 2020-06-15 | Campbell | Tennessee | 47013 | 24 | 1 |
245669 | 245669 | 2020-06-16 | Campbell | Tennessee | 47013 | 25 | 1 |
248782 | 248782 | 2020-06-17 | Campbell | Tennessee | 47013 | 25 | 1 |
251897 | 251897 | 2020-06-18 | Campbell | Tennessee | 47013 | 26 | 1 |
255012 | 255012 | 2020-06-19 | Campbell | Tennessee | 47013 | 26 | 1 |
258138 | 258138 | 2020-06-20 | Campbell | Tennessee | 47013 | 26 | 1 |
261265 | 261265 | 2020-06-21 | Campbell | Tennessee | 47013 | 26 | 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);