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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536955 | 536955 | 2020-09-15 | Cocke | Tennessee | 47029 | 712 | 9 |
533719 | 533719 | 2020-09-14 | Cocke | Tennessee | 47029 | 712 | 9 |
530484 | 530484 | 2020-09-13 | Cocke | Tennessee | 47029 | 709 | 9 |
527247 | 527247 | 2020-09-12 | Cocke | Tennessee | 47029 | 708 | 9 |
524011 | 524011 | 2020-09-11 | Cocke | Tennessee | 47029 | 706 | 8 |
520775 | 520775 | 2020-09-10 | Cocke | Tennessee | 47029 | 697 | 7 |
517539 | 517539 | 2020-09-09 | Cocke | Tennessee | 47029 | 672 | 7 |
514304 | 514304 | 2020-09-08 | Cocke | Tennessee | 47029 | 671 | 7 |
511071 | 511071 | 2020-09-07 | Cocke | Tennessee | 47029 | 673 | 7 |
507838 | 507838 | 2020-09-06 | Cocke | Tennessee | 47029 | 670 | 7 |
504606 | 504606 | 2020-09-05 | Cocke | Tennessee | 47029 | 665 | 7 |
501372 | 501372 | 2020-09-04 | Cocke | Tennessee | 47029 | 655 | 7 |
498138 | 498138 | 2020-09-03 | Cocke | Tennessee | 47029 | 653 | 7 |
494905 | 494905 | 2020-09-02 | Cocke | Tennessee | 47029 | 652 | 7 |
491671 | 491671 | 2020-09-01 | Cocke | Tennessee | 47029 | 644 | 7 |
488438 | 488438 | 2020-08-31 | Cocke | Tennessee | 47029 | 642 | 7 |
485205 | 485205 | 2020-08-30 | Cocke | Tennessee | 47029 | 641 | 7 |
481970 | 481970 | 2020-08-29 | Cocke | Tennessee | 47029 | 639 | 7 |
478736 | 478736 | 2020-08-28 | Cocke | Tennessee | 47029 | 630 | 7 |
475503 | 475503 | 2020-08-27 | Cocke | Tennessee | 47029 | 622 | 7 |
472270 | 472270 | 2020-08-26 | Cocke | Tennessee | 47029 | 619 | 7 |
469038 | 469038 | 2020-08-25 | Cocke | Tennessee | 47029 | 612 | 6 |
465809 | 465809 | 2020-08-24 | Cocke | Tennessee | 47029 | 606 | 6 |
462580 | 462580 | 2020-08-23 | Cocke | Tennessee | 47029 | 600 | 6 |
459352 | 459352 | 2020-08-22 | Cocke | Tennessee | 47029 | 591 | 6 |
456124 | 456124 | 2020-08-21 | Cocke | Tennessee | 47029 | 588 | 6 |
452896 | 452896 | 2020-08-20 | Cocke | Tennessee | 47029 | 583 | 6 |
449668 | 449668 | 2020-08-19 | Cocke | Tennessee | 47029 | 578 | 6 |
446440 | 446440 | 2020-08-18 | Cocke | Tennessee | 47029 | 560 | 5 |
443214 | 443214 | 2020-08-17 | Cocke | Tennessee | 47029 | 557 | 5 |
439987 | 439987 | 2020-08-16 | Cocke | Tennessee | 47029 | 547 | 5 |
436762 | 436762 | 2020-08-15 | Cocke | Tennessee | 47029 | 535 | 5 |
433535 | 433535 | 2020-08-14 | Cocke | Tennessee | 47029 | 525 | 5 |
430310 | 430310 | 2020-08-13 | Cocke | Tennessee | 47029 | 514 | 5 |
427083 | 427083 | 2020-08-12 | Cocke | Tennessee | 47029 | 485 | 5 |
423860 | 423860 | 2020-08-11 | Cocke | Tennessee | 47029 | 482 | 4 |
420638 | 420638 | 2020-08-10 | Cocke | Tennessee | 47029 | 478 | 3 |
417417 | 417417 | 2020-08-09 | Cocke | Tennessee | 47029 | 475 | 2 |
414196 | 414196 | 2020-08-08 | Cocke | Tennessee | 47029 | 457 | 2 |
410976 | 410976 | 2020-08-07 | Cocke | Tennessee | 47029 | 450 | 2 |
407757 | 407757 | 2020-08-06 | Cocke | Tennessee | 47029 | 439 | 2 |
404537 | 404537 | 2020-08-05 | Cocke | Tennessee | 47029 | 421 | 2 |
401319 | 401319 | 2020-08-04 | Cocke | Tennessee | 47029 | 412 | 1 |
398104 | 398104 | 2020-08-03 | Cocke | Tennessee | 47029 | 400 | 1 |
394887 | 394887 | 2020-08-02 | Cocke | Tennessee | 47029 | 391 | 1 |
391671 | 391671 | 2020-08-01 | Cocke | Tennessee | 47029 | 385 | 1 |
388454 | 388454 | 2020-07-31 | Cocke | Tennessee | 47029 | 369 | 1 |
385237 | 385237 | 2020-07-30 | Cocke | Tennessee | 47029 | 348 | 1 |
382019 | 382019 | 2020-07-29 | Cocke | Tennessee | 47029 | 342 | 1 |
378802 | 378802 | 2020-07-28 | Cocke | Tennessee | 47029 | 325 | 1 |
375586 | 375586 | 2020-07-27 | Cocke | Tennessee | 47029 | 302 | 1 |
372373 | 372373 | 2020-07-26 | Cocke | Tennessee | 47029 | 289 | 1 |
369161 | 369161 | 2020-07-25 | Cocke | Tennessee | 47029 | 265 | 1 |
365952 | 365952 | 2020-07-24 | Cocke | Tennessee | 47029 | 258 | 1 |
362746 | 362746 | 2020-07-23 | Cocke | Tennessee | 47029 | 251 | 1 |
359539 | 359539 | 2020-07-22 | Cocke | Tennessee | 47029 | 238 | 1 |
356335 | 356335 | 2020-07-21 | Cocke | Tennessee | 47029 | 231 | 1 |
353132 | 353132 | 2020-07-20 | Cocke | Tennessee | 47029 | 217 | 1 |
349929 | 349929 | 2020-07-19 | Cocke | Tennessee | 47029 | 210 | 1 |
346729 | 346729 | 2020-07-18 | Cocke | Tennessee | 47029 | 202 | 1 |
343529 | 343529 | 2020-07-17 | Cocke | Tennessee | 47029 | 196 | 1 |
340331 | 340331 | 2020-07-16 | Cocke | Tennessee | 47029 | 180 | 1 |
337134 | 337134 | 2020-07-15 | Cocke | Tennessee | 47029 | 175 | 0 |
333940 | 333940 | 2020-07-14 | Cocke | Tennessee | 47029 | 152 | 0 |
330748 | 330748 | 2020-07-13 | Cocke | Tennessee | 47029 | 146 | 0 |
327562 | 327562 | 2020-07-12 | Cocke | Tennessee | 47029 | 138 | 0 |
324377 | 324377 | 2020-07-11 | Cocke | Tennessee | 47029 | 136 | 0 |
321196 | 321196 | 2020-07-10 | Cocke | Tennessee | 47029 | 130 | 0 |
318018 | 318018 | 2020-07-09 | Cocke | Tennessee | 47029 | 126 | 0 |
314845 | 314845 | 2020-07-08 | Cocke | Tennessee | 47029 | 116 | 0 |
311671 | 311671 | 2020-07-07 | Cocke | Tennessee | 47029 | 105 | 0 |
308502 | 308502 | 2020-07-06 | Cocke | Tennessee | 47029 | 94 | 0 |
305334 | 305334 | 2020-07-05 | Cocke | Tennessee | 47029 | 94 | 0 |
302171 | 302171 | 2020-07-04 | Cocke | Tennessee | 47029 | 91 | 0 |
299007 | 299007 | 2020-07-03 | Cocke | Tennessee | 47029 | 90 | 0 |
295847 | 295847 | 2020-07-02 | Cocke | Tennessee | 47029 | 76 | 0 |
292691 | 292691 | 2020-07-01 | Cocke | Tennessee | 47029 | 70 | 0 |
289539 | 289539 | 2020-06-30 | Cocke | Tennessee | 47029 | 58 | 0 |
286388 | 286388 | 2020-06-29 | Cocke | Tennessee | 47029 | 51 | 0 |
283243 | 283243 | 2020-06-28 | Cocke | Tennessee | 47029 | 48 | 0 |
280097 | 280097 | 2020-06-27 | Cocke | Tennessee | 47029 | 48 | 0 |
276949 | 276949 | 2020-06-26 | Cocke | Tennessee | 47029 | 42 | 0 |
273802 | 273802 | 2020-06-25 | Cocke | Tennessee | 47029 | 36 | 0 |
270663 | 270663 | 2020-06-24 | Cocke | Tennessee | 47029 | 32 | 0 |
267529 | 267529 | 2020-06-23 | Cocke | Tennessee | 47029 | 31 | 0 |
264401 | 264401 | 2020-06-22 | Cocke | Tennessee | 47029 | 31 | 0 |
261273 | 261273 | 2020-06-21 | Cocke | Tennessee | 47029 | 29 | 0 |
258146 | 258146 | 2020-06-20 | Cocke | Tennessee | 47029 | 29 | 0 |
255020 | 255020 | 2020-06-19 | Cocke | Tennessee | 47029 | 27 | 0 |
251905 | 251905 | 2020-06-18 | Cocke | Tennessee | 47029 | 27 | 0 |
248790 | 248790 | 2020-06-17 | Cocke | Tennessee | 47029 | 27 | 0 |
245677 | 245677 | 2020-06-16 | Cocke | Tennessee | 47029 | 27 | 0 |
242565 | 242565 | 2020-06-15 | Cocke | Tennessee | 47029 | 26 | 0 |
239455 | 239455 | 2020-06-14 | Cocke | Tennessee | 47029 | 26 | 0 |
236347 | 236347 | 2020-06-13 | Cocke | Tennessee | 47029 | 26 | 0 |
233241 | 233241 | 2020-06-12 | Cocke | Tennessee | 47029 | 26 | 0 |
230136 | 230136 | 2020-06-11 | Cocke | Tennessee | 47029 | 23 | 0 |
227032 | 227032 | 2020-06-10 | Cocke | Tennessee | 47029 | 22 | 0 |
223932 | 223932 | 2020-06-09 | Cocke | Tennessee | 47029 | 22 | 0 |
220837 | 220837 | 2020-06-08 | Cocke | Tennessee | 47029 | 21 | 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);