ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 47029 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 |
---|---|---|---|---|---|---|---|
6921 | 6921 | 2020-03-21 | Cocke | Tennessee | 47029 | 1 | 0 |
8044 | 8044 | 2020-03-22 | Cocke | Tennessee | 47029 | 1 | 0 |
9262 | 9262 | 2020-03-23 | Cocke | Tennessee | 47029 | 1 | 0 |
10590 | 10590 | 2020-03-24 | Cocke | Tennessee | 47029 | 1 | 0 |
12067 | 12067 | 2020-03-25 | Cocke | Tennessee | 47029 | 1 | 0 |
13691 | 13691 | 2020-03-26 | Cocke | Tennessee | 47029 | 1 | 0 |
15443 | 15443 | 2020-03-27 | Cocke | Tennessee | 47029 | 1 | 0 |
17304 | 17304 | 2020-03-28 | Cocke | Tennessee | 47029 | 1 | 0 |
19249 | 19249 | 2020-03-29 | Cocke | Tennessee | 47029 | 1 | 0 |
21302 | 21302 | 2020-03-30 | Cocke | Tennessee | 47029 | 1 | 0 |
23440 | 23440 | 2020-03-31 | Cocke | Tennessee | 47029 | 1 | 0 |
25639 | 25639 | 2020-04-01 | Cocke | Tennessee | 47029 | 1 | 0 |
27917 | 27917 | 2020-04-02 | Cocke | Tennessee | 47029 | 1 | 0 |
30252 | 30252 | 2020-04-03 | Cocke | Tennessee | 47029 | 1 | 0 |
32643 | 32643 | 2020-04-04 | Cocke | Tennessee | 47029 | 1 | 0 |
35079 | 35079 | 2020-04-05 | Cocke | Tennessee | 47029 | 1 | 0 |
37555 | 37555 | 2020-04-06 | Cocke | Tennessee | 47029 | 1 | 0 |
40078 | 40078 | 2020-04-07 | Cocke | Tennessee | 47029 | 2 | 0 |
42639 | 42639 | 2020-04-08 | Cocke | Tennessee | 47029 | 2 | 0 |
45226 | 45226 | 2020-04-09 | Cocke | Tennessee | 47029 | 3 | 0 |
47844 | 47844 | 2020-04-10 | Cocke | Tennessee | 47029 | 3 | 0 |
50502 | 50502 | 2020-04-11 | Cocke | Tennessee | 47029 | 3 | 0 |
53177 | 53177 | 2020-04-12 | Cocke | Tennessee | 47029 | 3 | 0 |
55863 | 55863 | 2020-04-13 | Cocke | Tennessee | 47029 | 5 | 0 |
58566 | 58566 | 2020-04-14 | Cocke | Tennessee | 47029 | 7 | 0 |
61281 | 61281 | 2020-04-15 | Cocke | Tennessee | 47029 | 8 | 0 |
64008 | 64008 | 2020-04-16 | Cocke | Tennessee | 47029 | 11 | 0 |
66754 | 66754 | 2020-04-17 | Cocke | Tennessee | 47029 | 11 | 0 |
69512 | 69512 | 2020-04-18 | Cocke | Tennessee | 47029 | 11 | 0 |
72279 | 72279 | 2020-04-19 | Cocke | Tennessee | 47029 | 11 | 0 |
75054 | 75054 | 2020-04-20 | Cocke | Tennessee | 47029 | 11 | 0 |
77836 | 77836 | 2020-04-21 | Cocke | Tennessee | 47029 | 11 | 0 |
80626 | 80626 | 2020-04-22 | Cocke | Tennessee | 47029 | 13 | 0 |
83425 | 83425 | 2020-04-23 | Cocke | Tennessee | 47029 | 14 | 0 |
86230 | 86230 | 2020-04-24 | Cocke | Tennessee | 47029 | 14 | 0 |
89045 | 89045 | 2020-04-25 | Cocke | Tennessee | 47029 | 14 | 0 |
91862 | 91862 | 2020-04-26 | Cocke | Tennessee | 47029 | 14 | 0 |
94690 | 94690 | 2020-04-27 | Cocke | Tennessee | 47029 | 14 | 0 |
97530 | 97530 | 2020-04-28 | Cocke | Tennessee | 47029 | 16 | 0 |
100380 | 100380 | 2020-04-29 | Cocke | Tennessee | 47029 | 16 | 0 |
103233 | 103233 | 2020-04-30 | Cocke | Tennessee | 47029 | 16 | 0 |
106096 | 106096 | 2020-05-01 | Cocke | Tennessee | 47029 | 16 | 0 |
108963 | 108963 | 2020-05-02 | Cocke | Tennessee | 47029 | 16 | 0 |
111837 | 111837 | 2020-05-03 | Cocke | Tennessee | 47029 | 16 | 0 |
114719 | 114719 | 2020-05-04 | Cocke | Tennessee | 47029 | 19 | 0 |
117675 | 117675 | 2020-05-05 | Cocke | Tennessee | 47029 | 19 | 0 |
120639 | 120639 | 2020-05-06 | Cocke | Tennessee | 47029 | 16 | 0 |
123617 | 123617 | 2020-05-07 | Cocke | Tennessee | 47029 | 17 | 0 |
126600 | 126600 | 2020-05-08 | Cocke | Tennessee | 47029 | 17 | 0 |
129589 | 129589 | 2020-05-09 | Cocke | Tennessee | 47029 | 17 | 0 |
132578 | 132578 | 2020-05-10 | Cocke | Tennessee | 47029 | 17 | 0 |
135569 | 135569 | 2020-05-11 | Cocke | Tennessee | 47029 | 18 | 0 |
138559 | 138559 | 2020-05-12 | Cocke | Tennessee | 47029 | 19 | 0 |
141555 | 141555 | 2020-05-13 | Cocke | Tennessee | 47029 | 19 | 0 |
144552 | 144552 | 2020-05-14 | Cocke | Tennessee | 47029 | 20 | 0 |
147553 | 147553 | 2020-05-15 | Cocke | Tennessee | 47029 | 20 | 0 |
150561 | 150561 | 2020-05-16 | Cocke | Tennessee | 47029 | 20 | 0 |
153572 | 153572 | 2020-05-17 | Cocke | Tennessee | 47029 | 20 | 0 |
156589 | 156589 | 2020-05-18 | Cocke | Tennessee | 47029 | 20 | 0 |
159610 | 159610 | 2020-05-19 | Cocke | Tennessee | 47029 | 20 | 0 |
162637 | 162637 | 2020-05-20 | Cocke | Tennessee | 47029 | 20 | 0 |
165666 | 165666 | 2020-05-21 | Cocke | Tennessee | 47029 | 20 | 0 |
168702 | 168702 | 2020-05-22 | Cocke | Tennessee | 47029 | 20 | 0 |
171741 | 171741 | 2020-05-23 | Cocke | Tennessee | 47029 | 20 | 0 |
174784 | 174784 | 2020-05-24 | Cocke | Tennessee | 47029 | 20 | 0 |
177828 | 177828 | 2020-05-25 | Cocke | Tennessee | 47029 | 20 | 0 |
180871 | 180871 | 2020-05-26 | Cocke | Tennessee | 47029 | 20 | 0 |
183921 | 183921 | 2020-05-27 | Cocke | Tennessee | 47029 | 20 | 0 |
186978 | 186978 | 2020-05-28 | Cocke | Tennessee | 47029 | 20 | 0 |
190042 | 190042 | 2020-05-29 | Cocke | Tennessee | 47029 | 20 | 0 |
193107 | 193107 | 2020-05-30 | Cocke | Tennessee | 47029 | 20 | 0 |
196177 | 196177 | 2020-05-31 | Cocke | Tennessee | 47029 | 20 | 0 |
199250 | 199250 | 2020-06-01 | Cocke | Tennessee | 47029 | 20 | 0 |
202325 | 202325 | 2020-06-02 | Cocke | Tennessee | 47029 | 21 | 0 |
205404 | 205404 | 2020-06-03 | Cocke | Tennessee | 47029 | 21 | 0 |
208486 | 208486 | 2020-06-04 | Cocke | Tennessee | 47029 | 21 | 0 |
211568 | 211568 | 2020-06-05 | Cocke | Tennessee | 47029 | 21 | 0 |
214655 | 214655 | 2020-06-06 | Cocke | Tennessee | 47029 | 21 | 0 |
217745 | 217745 | 2020-06-07 | Cocke | Tennessee | 47029 | 21 | 0 |
220837 | 220837 | 2020-06-08 | Cocke | Tennessee | 47029 | 21 | 0 |
223932 | 223932 | 2020-06-09 | Cocke | Tennessee | 47029 | 22 | 0 |
227032 | 227032 | 2020-06-10 | Cocke | Tennessee | 47029 | 22 | 0 |
230136 | 230136 | 2020-06-11 | Cocke | Tennessee | 47029 | 23 | 0 |
233241 | 233241 | 2020-06-12 | Cocke | Tennessee | 47029 | 26 | 0 |
236347 | 236347 | 2020-06-13 | Cocke | Tennessee | 47029 | 26 | 0 |
239455 | 239455 | 2020-06-14 | Cocke | Tennessee | 47029 | 26 | 0 |
242565 | 242565 | 2020-06-15 | Cocke | Tennessee | 47029 | 26 | 0 |
245677 | 245677 | 2020-06-16 | Cocke | Tennessee | 47029 | 27 | 0 |
248790 | 248790 | 2020-06-17 | Cocke | Tennessee | 47029 | 27 | 0 |
251905 | 251905 | 2020-06-18 | Cocke | Tennessee | 47029 | 27 | 0 |
255020 | 255020 | 2020-06-19 | Cocke | Tennessee | 47029 | 27 | 0 |
258146 | 258146 | 2020-06-20 | Cocke | Tennessee | 47029 | 29 | 0 |
261273 | 261273 | 2020-06-21 | Cocke | Tennessee | 47029 | 29 | 0 |
264401 | 264401 | 2020-06-22 | Cocke | Tennessee | 47029 | 31 | 0 |
267529 | 267529 | 2020-06-23 | Cocke | Tennessee | 47029 | 31 | 0 |
270663 | 270663 | 2020-06-24 | Cocke | Tennessee | 47029 | 32 | 0 |
273802 | 273802 | 2020-06-25 | Cocke | Tennessee | 47029 | 36 | 0 |
276949 | 276949 | 2020-06-26 | Cocke | Tennessee | 47029 | 42 | 0 |
280097 | 280097 | 2020-06-27 | Cocke | Tennessee | 47029 | 48 | 0 |
283243 | 283243 | 2020-06-28 | Cocke | Tennessee | 47029 | 48 | 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);