ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Jackson" and fips = 47087 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388483 | 388483 | 2020-07-31 | Jackson | Tennessee | 47087 | 105 | 1 |
385266 | 385266 | 2020-07-30 | Jackson | Tennessee | 47087 | 103 | 0 |
382048 | 382048 | 2020-07-29 | Jackson | Tennessee | 47087 | 103 | 0 |
378831 | 378831 | 2020-07-28 | Jackson | Tennessee | 47087 | 99 | 0 |
375615 | 375615 | 2020-07-27 | Jackson | Tennessee | 47087 | 97 | 0 |
372402 | 372402 | 2020-07-26 | Jackson | Tennessee | 47087 | 97 | 0 |
369190 | 369190 | 2020-07-25 | Jackson | Tennessee | 47087 | 93 | 0 |
365981 | 365981 | 2020-07-24 | Jackson | Tennessee | 47087 | 93 | 0 |
362775 | 362775 | 2020-07-23 | Jackson | Tennessee | 47087 | 91 | 0 |
359568 | 359568 | 2020-07-22 | Jackson | Tennessee | 47087 | 90 | 0 |
356364 | 356364 | 2020-07-21 | Jackson | Tennessee | 47087 | 87 | 0 |
353161 | 353161 | 2020-07-20 | Jackson | Tennessee | 47087 | 72 | 0 |
349958 | 349958 | 2020-07-19 | Jackson | Tennessee | 47087 | 72 | 0 |
346758 | 346758 | 2020-07-18 | Jackson | Tennessee | 47087 | 72 | 0 |
343558 | 343558 | 2020-07-17 | Jackson | Tennessee | 47087 | 67 | 0 |
340360 | 340360 | 2020-07-16 | Jackson | Tennessee | 47087 | 65 | 0 |
337163 | 337163 | 2020-07-15 | Jackson | Tennessee | 47087 | 62 | 0 |
333969 | 333969 | 2020-07-14 | Jackson | Tennessee | 47087 | 52 | 0 |
330777 | 330777 | 2020-07-13 | Jackson | Tennessee | 47087 | 50 | 0 |
327591 | 327591 | 2020-07-12 | Jackson | Tennessee | 47087 | 47 | 0 |
324406 | 324406 | 2020-07-11 | Jackson | Tennessee | 47087 | 47 | 0 |
321225 | 321225 | 2020-07-10 | Jackson | Tennessee | 47087 | 46 | 0 |
318047 | 318047 | 2020-07-09 | Jackson | Tennessee | 47087 | 41 | 0 |
314874 | 314874 | 2020-07-08 | Jackson | Tennessee | 47087 | 33 | 0 |
311700 | 311700 | 2020-07-07 | Jackson | Tennessee | 47087 | 30 | 0 |
308531 | 308531 | 2020-07-06 | Jackson | Tennessee | 47087 | 29 | 0 |
305363 | 305363 | 2020-07-05 | Jackson | Tennessee | 47087 | 27 | 0 |
302200 | 302200 | 2020-07-04 | Jackson | Tennessee | 47087 | 26 | 0 |
299036 | 299036 | 2020-07-03 | Jackson | Tennessee | 47087 | 26 | 0 |
295876 | 295876 | 2020-07-02 | Jackson | Tennessee | 47087 | 26 | 0 |
292720 | 292720 | 2020-07-01 | Jackson | Tennessee | 47087 | 26 | 0 |
289568 | 289568 | 2020-06-30 | Jackson | Tennessee | 47087 | 26 | 0 |
286417 | 286417 | 2020-06-29 | Jackson | Tennessee | 47087 | 23 | 0 |
283272 | 283272 | 2020-06-28 | Jackson | Tennessee | 47087 | 22 | 0 |
280126 | 280126 | 2020-06-27 | Jackson | Tennessee | 47087 | 22 | 0 |
276978 | 276978 | 2020-06-26 | Jackson | Tennessee | 47087 | 22 | 0 |
273831 | 273831 | 2020-06-25 | Jackson | Tennessee | 47087 | 22 | 0 |
270692 | 270692 | 2020-06-24 | Jackson | Tennessee | 47087 | 22 | 0 |
267558 | 267558 | 2020-06-23 | Jackson | Tennessee | 47087 | 22 | 0 |
264430 | 264430 | 2020-06-22 | Jackson | Tennessee | 47087 | 22 | 0 |
261302 | 261302 | 2020-06-21 | Jackson | Tennessee | 47087 | 21 | 0 |
258175 | 258175 | 2020-06-20 | Jackson | Tennessee | 47087 | 21 | 0 |
255049 | 255049 | 2020-06-19 | Jackson | Tennessee | 47087 | 21 | 0 |
251934 | 251934 | 2020-06-18 | Jackson | Tennessee | 47087 | 21 | 0 |
248819 | 248819 | 2020-06-17 | Jackson | Tennessee | 47087 | 20 | 0 |
245706 | 245706 | 2020-06-16 | Jackson | Tennessee | 47087 | 20 | 0 |
242594 | 242594 | 2020-06-15 | Jackson | Tennessee | 47087 | 20 | 0 |
239484 | 239484 | 2020-06-14 | Jackson | Tennessee | 47087 | 20 | 0 |
236376 | 236376 | 2020-06-13 | Jackson | Tennessee | 47087 | 20 | 0 |
233270 | 233270 | 2020-06-12 | Jackson | Tennessee | 47087 | 19 | 0 |
230165 | 230165 | 2020-06-11 | Jackson | Tennessee | 47087 | 19 | 0 |
227061 | 227061 | 2020-06-10 | Jackson | Tennessee | 47087 | 19 | 0 |
223961 | 223961 | 2020-06-09 | Jackson | Tennessee | 47087 | 19 | 0 |
220866 | 220866 | 2020-06-08 | Jackson | Tennessee | 47087 | 19 | 0 |
217774 | 217774 | 2020-06-07 | Jackson | Tennessee | 47087 | 19 | 0 |
214684 | 214684 | 2020-06-06 | Jackson | Tennessee | 47087 | 19 | 0 |
211597 | 211597 | 2020-06-05 | Jackson | Tennessee | 47087 | 19 | 0 |
208515 | 208515 | 2020-06-04 | Jackson | Tennessee | 47087 | 19 | 0 |
205433 | 205433 | 2020-06-03 | Jackson | Tennessee | 47087 | 19 | 0 |
202354 | 202354 | 2020-06-02 | Jackson | Tennessee | 47087 | 19 | 0 |
199279 | 199279 | 2020-06-01 | Jackson | Tennessee | 47087 | 17 | 0 |
196206 | 196206 | 2020-05-31 | Jackson | Tennessee | 47087 | 17 | 0 |
193136 | 193136 | 2020-05-30 | Jackson | Tennessee | 47087 | 17 | 0 |
190071 | 190071 | 2020-05-29 | Jackson | Tennessee | 47087 | 17 | 0 |
187007 | 187007 | 2020-05-28 | Jackson | Tennessee | 47087 | 17 | 0 |
183950 | 183950 | 2020-05-27 | Jackson | Tennessee | 47087 | 17 | 0 |
180900 | 180900 | 2020-05-26 | Jackson | Tennessee | 47087 | 17 | 0 |
177857 | 177857 | 2020-05-25 | Jackson | Tennessee | 47087 | 17 | 0 |
174813 | 174813 | 2020-05-24 | Jackson | Tennessee | 47087 | 17 | 0 |
171770 | 171770 | 2020-05-23 | Jackson | Tennessee | 47087 | 16 | 0 |
168731 | 168731 | 2020-05-22 | Jackson | Tennessee | 47087 | 14 | 0 |
165695 | 165695 | 2020-05-21 | Jackson | Tennessee | 47087 | 13 | 0 |
162666 | 162666 | 2020-05-20 | Jackson | Tennessee | 47087 | 13 | 0 |
159639 | 159639 | 2020-05-19 | Jackson | Tennessee | 47087 | 13 | 0 |
156617 | 156617 | 2020-05-18 | Jackson | Tennessee | 47087 | 11 | 0 |
153600 | 153600 | 2020-05-17 | Jackson | Tennessee | 47087 | 11 | 0 |
150589 | 150589 | 2020-05-16 | Jackson | Tennessee | 47087 | 11 | 0 |
147581 | 147581 | 2020-05-15 | Jackson | Tennessee | 47087 | 10 | 0 |
144580 | 144580 | 2020-05-14 | Jackson | Tennessee | 47087 | 10 | 0 |
141583 | 141583 | 2020-05-13 | Jackson | Tennessee | 47087 | 10 | 0 |
138587 | 138587 | 2020-05-12 | Jackson | Tennessee | 47087 | 10 | 0 |
135597 | 135597 | 2020-05-11 | Jackson | Tennessee | 47087 | 10 | 0 |
132606 | 132606 | 2020-05-10 | Jackson | Tennessee | 47087 | 10 | 0 |
129617 | 129617 | 2020-05-09 | Jackson | Tennessee | 47087 | 8 | 0 |
126628 | 126628 | 2020-05-08 | Jackson | Tennessee | 47087 | 8 | 0 |
123645 | 123645 | 2020-05-07 | Jackson | Tennessee | 47087 | 8 | 0 |
120667 | 120667 | 2020-05-06 | Jackson | Tennessee | 47087 | 7 | 0 |
117703 | 117703 | 2020-05-05 | Jackson | Tennessee | 47087 | 7 | 0 |
114747 | 114747 | 2020-05-04 | Jackson | Tennessee | 47087 | 7 | 0 |
111865 | 111865 | 2020-05-03 | Jackson | Tennessee | 47087 | 7 | 0 |
108991 | 108991 | 2020-05-02 | Jackson | Tennessee | 47087 | 7 | 0 |
106124 | 106124 | 2020-05-01 | Jackson | Tennessee | 47087 | 7 | 0 |
103261 | 103261 | 2020-04-30 | Jackson | Tennessee | 47087 | 7 | 0 |
100408 | 100408 | 2020-04-29 | Jackson | Tennessee | 47087 | 7 | 0 |
97558 | 97558 | 2020-04-28 | Jackson | Tennessee | 47087 | 7 | 0 |
94718 | 94718 | 2020-04-27 | Jackson | Tennessee | 47087 | 7 | 0 |
91890 | 91890 | 2020-04-26 | Jackson | Tennessee | 47087 | 7 | 0 |
89073 | 89073 | 2020-04-25 | Jackson | Tennessee | 47087 | 7 | 0 |
86258 | 86258 | 2020-04-24 | Jackson | Tennessee | 47087 | 7 | 0 |
83453 | 83453 | 2020-04-23 | Jackson | Tennessee | 47087 | 6 | 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);