ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Jackson" and state = "Tennessee" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
27942 | 27942 | 2020-04-02 | Jackson | Tennessee | 47087 | 2 | 0 |
30277 | 30277 | 2020-04-03 | Jackson | Tennessee | 47087 | 3 | 0 |
32668 | 32668 | 2020-04-04 | Jackson | Tennessee | 47087 | 3 | 0 |
35105 | 35105 | 2020-04-05 | Jackson | Tennessee | 47087 | 3 | 0 |
37581 | 37581 | 2020-04-06 | Jackson | Tennessee | 47087 | 3 | 0 |
40104 | 40104 | 2020-04-07 | Jackson | Tennessee | 47087 | 3 | 0 |
42666 | 42666 | 2020-04-08 | Jackson | Tennessee | 47087 | 4 | 0 |
45253 | 45253 | 2020-04-09 | Jackson | Tennessee | 47087 | 5 | 0 |
47871 | 47871 | 2020-04-10 | Jackson | Tennessee | 47087 | 5 | 0 |
50529 | 50529 | 2020-04-11 | Jackson | Tennessee | 47087 | 5 | 0 |
53204 | 53204 | 2020-04-12 | Jackson | Tennessee | 47087 | 5 | 0 |
55890 | 55890 | 2020-04-13 | Jackson | Tennessee | 47087 | 7 | 0 |
58593 | 58593 | 2020-04-14 | Jackson | Tennessee | 47087 | 6 | 0 |
61308 | 61308 | 2020-04-15 | Jackson | Tennessee | 47087 | 6 | 0 |
64035 | 64035 | 2020-04-16 | Jackson | Tennessee | 47087 | 6 | 0 |
66781 | 66781 | 2020-04-17 | Jackson | Tennessee | 47087 | 6 | 0 |
69540 | 69540 | 2020-04-18 | Jackson | Tennessee | 47087 | 11 | 0 |
72307 | 72307 | 2020-04-19 | Jackson | Tennessee | 47087 | 6 | 0 |
75082 | 75082 | 2020-04-20 | Jackson | Tennessee | 47087 | 6 | 0 |
77864 | 77864 | 2020-04-21 | Jackson | Tennessee | 47087 | 6 | 0 |
80654 | 80654 | 2020-04-22 | Jackson | Tennessee | 47087 | 6 | 0 |
83453 | 83453 | 2020-04-23 | Jackson | Tennessee | 47087 | 6 | 0 |
86258 | 86258 | 2020-04-24 | Jackson | Tennessee | 47087 | 7 | 0 |
89073 | 89073 | 2020-04-25 | Jackson | Tennessee | 47087 | 7 | 0 |
91890 | 91890 | 2020-04-26 | Jackson | Tennessee | 47087 | 7 | 0 |
94718 | 94718 | 2020-04-27 | Jackson | Tennessee | 47087 | 7 | 0 |
97558 | 97558 | 2020-04-28 | Jackson | Tennessee | 47087 | 7 | 0 |
100408 | 100408 | 2020-04-29 | Jackson | Tennessee | 47087 | 7 | 0 |
103261 | 103261 | 2020-04-30 | Jackson | Tennessee | 47087 | 7 | 0 |
106124 | 106124 | 2020-05-01 | Jackson | Tennessee | 47087 | 7 | 0 |
108991 | 108991 | 2020-05-02 | Jackson | Tennessee | 47087 | 7 | 0 |
111865 | 111865 | 2020-05-03 | Jackson | Tennessee | 47087 | 7 | 0 |
114747 | 114747 | 2020-05-04 | Jackson | Tennessee | 47087 | 7 | 0 |
117703 | 117703 | 2020-05-05 | Jackson | Tennessee | 47087 | 7 | 0 |
120667 | 120667 | 2020-05-06 | Jackson | Tennessee | 47087 | 7 | 0 |
123645 | 123645 | 2020-05-07 | Jackson | Tennessee | 47087 | 8 | 0 |
126628 | 126628 | 2020-05-08 | Jackson | Tennessee | 47087 | 8 | 0 |
129617 | 129617 | 2020-05-09 | Jackson | Tennessee | 47087 | 8 | 0 |
132606 | 132606 | 2020-05-10 | Jackson | Tennessee | 47087 | 10 | 0 |
135597 | 135597 | 2020-05-11 | Jackson | Tennessee | 47087 | 10 | 0 |
138587 | 138587 | 2020-05-12 | Jackson | Tennessee | 47087 | 10 | 0 |
141583 | 141583 | 2020-05-13 | Jackson | Tennessee | 47087 | 10 | 0 |
144580 | 144580 | 2020-05-14 | Jackson | Tennessee | 47087 | 10 | 0 |
147581 | 147581 | 2020-05-15 | Jackson | Tennessee | 47087 | 10 | 0 |
150589 | 150589 | 2020-05-16 | Jackson | Tennessee | 47087 | 11 | 0 |
153600 | 153600 | 2020-05-17 | Jackson | Tennessee | 47087 | 11 | 0 |
156617 | 156617 | 2020-05-18 | Jackson | Tennessee | 47087 | 11 | 0 |
159639 | 159639 | 2020-05-19 | Jackson | Tennessee | 47087 | 13 | 0 |
162666 | 162666 | 2020-05-20 | Jackson | Tennessee | 47087 | 13 | 0 |
165695 | 165695 | 2020-05-21 | Jackson | Tennessee | 47087 | 13 | 0 |
168731 | 168731 | 2020-05-22 | Jackson | Tennessee | 47087 | 14 | 0 |
171770 | 171770 | 2020-05-23 | Jackson | Tennessee | 47087 | 16 | 0 |
174813 | 174813 | 2020-05-24 | Jackson | Tennessee | 47087 | 17 | 0 |
177857 | 177857 | 2020-05-25 | Jackson | Tennessee | 47087 | 17 | 0 |
180900 | 180900 | 2020-05-26 | Jackson | Tennessee | 47087 | 17 | 0 |
183950 | 183950 | 2020-05-27 | Jackson | Tennessee | 47087 | 17 | 0 |
187007 | 187007 | 2020-05-28 | Jackson | Tennessee | 47087 | 17 | 0 |
190071 | 190071 | 2020-05-29 | Jackson | Tennessee | 47087 | 17 | 0 |
193136 | 193136 | 2020-05-30 | Jackson | Tennessee | 47087 | 17 | 0 |
196206 | 196206 | 2020-05-31 | Jackson | Tennessee | 47087 | 17 | 0 |
199279 | 199279 | 2020-06-01 | Jackson | Tennessee | 47087 | 17 | 0 |
202354 | 202354 | 2020-06-02 | Jackson | Tennessee | 47087 | 19 | 0 |
205433 | 205433 | 2020-06-03 | Jackson | Tennessee | 47087 | 19 | 0 |
208515 | 208515 | 2020-06-04 | Jackson | Tennessee | 47087 | 19 | 0 |
211597 | 211597 | 2020-06-05 | Jackson | Tennessee | 47087 | 19 | 0 |
214684 | 214684 | 2020-06-06 | Jackson | Tennessee | 47087 | 19 | 0 |
217774 | 217774 | 2020-06-07 | Jackson | Tennessee | 47087 | 19 | 0 |
220866 | 220866 | 2020-06-08 | Jackson | Tennessee | 47087 | 19 | 0 |
223961 | 223961 | 2020-06-09 | Jackson | Tennessee | 47087 | 19 | 0 |
227061 | 227061 | 2020-06-10 | Jackson | Tennessee | 47087 | 19 | 0 |
230165 | 230165 | 2020-06-11 | Jackson | Tennessee | 47087 | 19 | 0 |
233270 | 233270 | 2020-06-12 | Jackson | Tennessee | 47087 | 19 | 0 |
236376 | 236376 | 2020-06-13 | Jackson | Tennessee | 47087 | 20 | 0 |
239484 | 239484 | 2020-06-14 | Jackson | Tennessee | 47087 | 20 | 0 |
242594 | 242594 | 2020-06-15 | Jackson | Tennessee | 47087 | 20 | 0 |
245706 | 245706 | 2020-06-16 | Jackson | Tennessee | 47087 | 20 | 0 |
248819 | 248819 | 2020-06-17 | Jackson | Tennessee | 47087 | 20 | 0 |
251934 | 251934 | 2020-06-18 | Jackson | Tennessee | 47087 | 21 | 0 |
255049 | 255049 | 2020-06-19 | Jackson | Tennessee | 47087 | 21 | 0 |
258175 | 258175 | 2020-06-20 | Jackson | Tennessee | 47087 | 21 | 0 |
261302 | 261302 | 2020-06-21 | Jackson | Tennessee | 47087 | 21 | 0 |
264430 | 264430 | 2020-06-22 | Jackson | Tennessee | 47087 | 22 | 0 |
267558 | 267558 | 2020-06-23 | Jackson | Tennessee | 47087 | 22 | 0 |
270692 | 270692 | 2020-06-24 | Jackson | Tennessee | 47087 | 22 | 0 |
273831 | 273831 | 2020-06-25 | Jackson | Tennessee | 47087 | 22 | 0 |
276978 | 276978 | 2020-06-26 | Jackson | Tennessee | 47087 | 22 | 0 |
280126 | 280126 | 2020-06-27 | Jackson | Tennessee | 47087 | 22 | 0 |
283272 | 283272 | 2020-06-28 | Jackson | Tennessee | 47087 | 22 | 0 |
286417 | 286417 | 2020-06-29 | Jackson | Tennessee | 47087 | 23 | 0 |
289568 | 289568 | 2020-06-30 | Jackson | Tennessee | 47087 | 26 | 0 |
292720 | 292720 | 2020-07-01 | Jackson | Tennessee | 47087 | 26 | 0 |
295876 | 295876 | 2020-07-02 | Jackson | Tennessee | 47087 | 26 | 0 |
299036 | 299036 | 2020-07-03 | Jackson | Tennessee | 47087 | 26 | 0 |
302200 | 302200 | 2020-07-04 | Jackson | Tennessee | 47087 | 26 | 0 |
305363 | 305363 | 2020-07-05 | Jackson | Tennessee | 47087 | 27 | 0 |
308531 | 308531 | 2020-07-06 | Jackson | Tennessee | 47087 | 29 | 0 |
311700 | 311700 | 2020-07-07 | Jackson | Tennessee | 47087 | 30 | 0 |
314874 | 314874 | 2020-07-08 | Jackson | Tennessee | 47087 | 33 | 0 |
318047 | 318047 | 2020-07-09 | Jackson | Tennessee | 47087 | 41 | 0 |
321225 | 321225 | 2020-07-10 | Jackson | Tennessee | 47087 | 46 | 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);