ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 47163 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 |
---|---|---|---|---|---|---|---|
1130 | 1130 | 2020-03-10 | Sullivan | Tennessee | 47163 | 1 | 0 |
1326 | 1326 | 2020-03-11 | Sullivan | Tennessee | 47163 | 1 | 0 |
1573 | 1573 | 2020-03-12 | Sullivan | Tennessee | 47163 | 1 | 0 |
1877 | 1877 | 2020-03-13 | Sullivan | Tennessee | 47163 | 1 | 0 |
2242 | 2242 | 2020-03-14 | Sullivan | Tennessee | 47163 | 1 | 0 |
2667 | 2667 | 2020-03-15 | Sullivan | Tennessee | 47163 | 1 | 0 |
3134 | 3134 | 2020-03-16 | Sullivan | Tennessee | 47163 | 1 | 0 |
3667 | 3667 | 2020-03-17 | Sullivan | Tennessee | 47163 | 1 | 0 |
4289 | 4289 | 2020-03-18 | Sullivan | Tennessee | 47163 | 1 | 0 |
5037 | 5037 | 2020-03-19 | Sullivan | Tennessee | 47163 | 1 | 0 |
5925 | 5925 | 2020-03-20 | Sullivan | Tennessee | 47163 | 1 | 0 |
6942 | 6942 | 2020-03-21 | Sullivan | Tennessee | 47163 | 1 | 0 |
8072 | 8072 | 2020-03-22 | Sullivan | Tennessee | 47163 | 1 | 0 |
9290 | 9290 | 2020-03-23 | Sullivan | Tennessee | 47163 | 1 | 0 |
10624 | 10624 | 2020-03-24 | Sullivan | Tennessee | 47163 | 2 | 0 |
12103 | 12103 | 2020-03-25 | Sullivan | Tennessee | 47163 | 2 | 0 |
13729 | 13729 | 2020-03-26 | Sullivan | Tennessee | 47163 | 4 | 0 |
15482 | 15482 | 2020-03-27 | Sullivan | Tennessee | 47163 | 6 | 0 |
17346 | 17346 | 2020-03-28 | Sullivan | Tennessee | 47163 | 6 | 0 |
19296 | 19296 | 2020-03-29 | Sullivan | Tennessee | 47163 | 8 | 0 |
21353 | 21353 | 2020-03-30 | Sullivan | Tennessee | 47163 | 11 | 0 |
23492 | 23492 | 2020-03-31 | Sullivan | Tennessee | 47163 | 11 | 0 |
25695 | 25695 | 2020-04-01 | Sullivan | Tennessee | 47163 | 17 | 0 |
27975 | 27975 | 2020-04-02 | Sullivan | Tennessee | 47163 | 17 | 1 |
30310 | 30310 | 2020-04-03 | Sullivan | Tennessee | 47163 | 18 | 1 |
32702 | 32702 | 2020-04-04 | Sullivan | Tennessee | 47163 | 18 | 1 |
35139 | 35139 | 2020-04-05 | Sullivan | Tennessee | 47163 | 21 | 1 |
37615 | 37615 | 2020-04-06 | Sullivan | Tennessee | 47163 | 25 | 1 |
40138 | 40138 | 2020-04-07 | Sullivan | Tennessee | 47163 | 26 | 1 |
42700 | 42700 | 2020-04-08 | Sullivan | Tennessee | 47163 | 27 | 1 |
45287 | 45287 | 2020-04-09 | Sullivan | Tennessee | 47163 | 34 | 1 |
47905 | 47905 | 2020-04-10 | Sullivan | Tennessee | 47163 | 35 | 1 |
50563 | 50563 | 2020-04-11 | Sullivan | Tennessee | 47163 | 37 | 1 |
53238 | 53238 | 2020-04-12 | Sullivan | Tennessee | 47163 | 37 | 1 |
55925 | 55925 | 2020-04-13 | Sullivan | Tennessee | 47163 | 42 | 1 |
58628 | 58628 | 2020-04-14 | Sullivan | Tennessee | 47163 | 43 | 1 |
61344 | 61344 | 2020-04-15 | Sullivan | Tennessee | 47163 | 43 | 1 |
64071 | 64071 | 2020-04-16 | Sullivan | Tennessee | 47163 | 45 | 1 |
66818 | 66818 | 2020-04-17 | Sullivan | Tennessee | 47163 | 45 | 1 |
69577 | 69577 | 2020-04-18 | Sullivan | Tennessee | 47163 | 45 | 1 |
72344 | 72344 | 2020-04-19 | Sullivan | Tennessee | 47163 | 45 | 1 |
75119 | 75119 | 2020-04-20 | Sullivan | Tennessee | 47163 | 45 | 1 |
77901 | 77901 | 2020-04-21 | Sullivan | Tennessee | 47163 | 45 | 1 |
80691 | 80691 | 2020-04-22 | Sullivan | Tennessee | 47163 | 47 | 1 |
83490 | 83490 | 2020-04-23 | Sullivan | Tennessee | 47163 | 47 | 1 |
86295 | 86295 | 2020-04-24 | Sullivan | Tennessee | 47163 | 47 | 1 |
89110 | 89110 | 2020-04-25 | Sullivan | Tennessee | 47163 | 48 | 1 |
91927 | 91927 | 2020-04-26 | Sullivan | Tennessee | 47163 | 47 | 1 |
94755 | 94755 | 2020-04-27 | Sullivan | Tennessee | 47163 | 47 | 1 |
97595 | 97595 | 2020-04-28 | Sullivan | Tennessee | 47163 | 47 | 1 |
100445 | 100445 | 2020-04-29 | Sullivan | Tennessee | 47163 | 48 | 1 |
103298 | 103298 | 2020-04-30 | Sullivan | Tennessee | 47163 | 49 | 1 |
106161 | 106161 | 2020-05-01 | Sullivan | Tennessee | 47163 | 49 | 1 |
109028 | 109028 | 2020-05-02 | Sullivan | Tennessee | 47163 | 49 | 1 |
111902 | 111902 | 2020-05-03 | Sullivan | Tennessee | 47163 | 51 | 1 |
114784 | 114784 | 2020-05-04 | Sullivan | Tennessee | 47163 | 57 | 1 |
117740 | 117740 | 2020-05-05 | Sullivan | Tennessee | 47163 | 59 | 1 |
120704 | 120704 | 2020-05-06 | Sullivan | Tennessee | 47163 | 52 | 1 |
123682 | 123682 | 2020-05-07 | Sullivan | Tennessee | 47163 | 52 | 1 |
126665 | 126665 | 2020-05-08 | Sullivan | Tennessee | 47163 | 54 | 1 |
129654 | 129654 | 2020-05-09 | Sullivan | Tennessee | 47163 | 54 | 1 |
132644 | 132644 | 2020-05-10 | Sullivan | Tennessee | 47163 | 54 | 1 |
135635 | 135635 | 2020-05-11 | Sullivan | Tennessee | 47163 | 54 | 1 |
138625 | 138625 | 2020-05-12 | Sullivan | Tennessee | 47163 | 54 | 2 |
141621 | 141621 | 2020-05-13 | Sullivan | Tennessee | 47163 | 54 | 2 |
144618 | 144618 | 2020-05-14 | Sullivan | Tennessee | 47163 | 56 | 2 |
147619 | 147619 | 2020-05-15 | Sullivan | Tennessee | 47163 | 57 | 2 |
150627 | 150627 | 2020-05-16 | Sullivan | Tennessee | 47163 | 57 | 2 |
153638 | 153638 | 2020-05-17 | Sullivan | Tennessee | 47163 | 57 | 2 |
156655 | 156655 | 2020-05-18 | Sullivan | Tennessee | 47163 | 57 | 2 |
159677 | 159677 | 2020-05-19 | Sullivan | Tennessee | 47163 | 57 | 2 |
162704 | 162704 | 2020-05-20 | Sullivan | Tennessee | 47163 | 57 | 2 |
165733 | 165733 | 2020-05-21 | Sullivan | Tennessee | 47163 | 60 | 2 |
168769 | 168769 | 2020-05-22 | Sullivan | Tennessee | 47163 | 61 | 2 |
171808 | 171808 | 2020-05-23 | Sullivan | Tennessee | 47163 | 61 | 2 |
174851 | 174851 | 2020-05-24 | Sullivan | Tennessee | 47163 | 61 | 2 |
177895 | 177895 | 2020-05-25 | Sullivan | Tennessee | 47163 | 61 | 2 |
180938 | 180938 | 2020-05-26 | Sullivan | Tennessee | 47163 | 62 | 2 |
183988 | 183988 | 2020-05-27 | Sullivan | Tennessee | 47163 | 60 | 2 |
187045 | 187045 | 2020-05-28 | Sullivan | Tennessee | 47163 | 60 | 2 |
190109 | 190109 | 2020-05-29 | Sullivan | Tennessee | 47163 | 60 | 2 |
193174 | 193174 | 2020-05-30 | Sullivan | Tennessee | 47163 | 60 | 2 |
196244 | 196244 | 2020-05-31 | Sullivan | Tennessee | 47163 | 60 | 2 |
199317 | 199317 | 2020-06-01 | Sullivan | Tennessee | 47163 | 60 | 2 |
202392 | 202392 | 2020-06-02 | Sullivan | Tennessee | 47163 | 60 | 2 |
205471 | 205471 | 2020-06-03 | Sullivan | Tennessee | 47163 | 60 | 2 |
208553 | 208553 | 2020-06-04 | Sullivan | Tennessee | 47163 | 60 | 2 |
211635 | 211635 | 2020-06-05 | Sullivan | Tennessee | 47163 | 60 | 2 |
214722 | 214722 | 2020-06-06 | Sullivan | Tennessee | 47163 | 62 | 2 |
217812 | 217812 | 2020-06-07 | Sullivan | Tennessee | 47163 | 62 | 2 |
220904 | 220904 | 2020-06-08 | Sullivan | Tennessee | 47163 | 62 | 2 |
223999 | 223999 | 2020-06-09 | Sullivan | Tennessee | 47163 | 66 | 2 |
227099 | 227099 | 2020-06-10 | Sullivan | Tennessee | 47163 | 67 | 2 |
230203 | 230203 | 2020-06-11 | Sullivan | Tennessee | 47163 | 67 | 2 |
233308 | 233308 | 2020-06-12 | Sullivan | Tennessee | 47163 | 70 | 2 |
236414 | 236414 | 2020-06-13 | Sullivan | Tennessee | 47163 | 69 | 2 |
239522 | 239522 | 2020-06-14 | Sullivan | Tennessee | 47163 | 70 | 2 |
242632 | 242632 | 2020-06-15 | Sullivan | Tennessee | 47163 | 70 | 2 |
245744 | 245744 | 2020-06-16 | Sullivan | Tennessee | 47163 | 70 | 2 |
248857 | 248857 | 2020-06-17 | Sullivan | Tennessee | 47163 | 71 | 2 |
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);