ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 47165 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637492 | 637492 | 2020-10-16 | Sumner | Tennessee | 47165 | 5442 | 106 |
634246 | 634246 | 2020-10-15 | Sumner | Tennessee | 47165 | 5428 | 106 |
631001 | 631001 | 2020-10-14 | Sumner | Tennessee | 47165 | 5360 | 105 |
627757 | 627757 | 2020-10-13 | Sumner | Tennessee | 47165 | 5338 | 105 |
624515 | 624515 | 2020-10-12 | Sumner | Tennessee | 47165 | 5311 | 105 |
621272 | 621272 | 2020-10-11 | Sumner | Tennessee | 47165 | 5243 | 105 |
618029 | 618029 | 2020-10-10 | Sumner | Tennessee | 47165 | 5222 | 105 |
614787 | 614787 | 2020-10-09 | Sumner | Tennessee | 47165 | 5200 | 104 |
611546 | 611546 | 2020-10-08 | Sumner | Tennessee | 47165 | 5169 | 104 |
608304 | 608304 | 2020-10-07 | Sumner | Tennessee | 47165 | 5138 | 104 |
605061 | 605061 | 2020-10-06 | Sumner | Tennessee | 47165 | 5109 | 104 |
601819 | 601819 | 2020-10-05 | Sumner | Tennessee | 47165 | 5088 | 104 |
598576 | 598576 | 2020-10-04 | Sumner | Tennessee | 47165 | 5044 | 103 |
595333 | 595333 | 2020-10-03 | Sumner | Tennessee | 47165 | 5016 | 103 |
592092 | 592092 | 2020-10-02 | Sumner | Tennessee | 47165 | 4989 | 102 |
588851 | 588851 | 2020-10-01 | Sumner | Tennessee | 47165 | 4968 | 102 |
585611 | 585611 | 2020-09-30 | Sumner | Tennessee | 47165 | 4922 | 98 |
582371 | 582371 | 2020-09-29 | Sumner | Tennessee | 47165 | 4895 | 98 |
579131 | 579131 | 2020-09-28 | Sumner | Tennessee | 47165 | 4883 | 98 |
575890 | 575890 | 2020-09-27 | Sumner | Tennessee | 47165 | 4865 | 98 |
572646 | 572646 | 2020-09-26 | Sumner | Tennessee | 47165 | 4819 | 98 |
569404 | 569404 | 2020-09-25 | Sumner | Tennessee | 47165 | 4794 | 97 |
566163 | 566163 | 2020-09-24 | Sumner | Tennessee | 47165 | 4758 | 96 |
562922 | 562922 | 2020-09-23 | Sumner | Tennessee | 47165 | 4750 | 93 |
559685 | 559685 | 2020-09-22 | Sumner | Tennessee | 47165 | 4721 | 93 |
556448 | 556448 | 2020-09-21 | Sumner | Tennessee | 47165 | 4705 | 93 |
553211 | 553211 | 2020-09-20 | Sumner | Tennessee | 47165 | 4686 | 93 |
549972 | 549972 | 2020-09-19 | Sumner | Tennessee | 47165 | 4629 | 93 |
546733 | 546733 | 2020-09-18 | Sumner | Tennessee | 47165 | 4621 | 93 |
543496 | 543496 | 2020-09-17 | Sumner | Tennessee | 47165 | 4585 | 93 |
540260 | 540260 | 2020-09-16 | Sumner | Tennessee | 47165 | 4568 | 92 |
537023 | 537023 | 2020-09-15 | Sumner | Tennessee | 47165 | 4548 | 92 |
533787 | 533787 | 2020-09-14 | Sumner | Tennessee | 47165 | 4532 | 91 |
530552 | 530552 | 2020-09-13 | Sumner | Tennessee | 47165 | 4469 | 91 |
527315 | 527315 | 2020-09-12 | Sumner | Tennessee | 47165 | 4458 | 91 |
524079 | 524079 | 2020-09-11 | Sumner | Tennessee | 47165 | 4433 | 90 |
520843 | 520843 | 2020-09-10 | Sumner | Tennessee | 47165 | 4384 | 89 |
517607 | 517607 | 2020-09-09 | Sumner | Tennessee | 47165 | 4318 | 88 |
514372 | 514372 | 2020-09-08 | Sumner | Tennessee | 47165 | 4300 | 87 |
511139 | 511139 | 2020-09-07 | Sumner | Tennessee | 47165 | 4282 | 87 |
507906 | 507906 | 2020-09-06 | Sumner | Tennessee | 47165 | 4263 | 87 |
504674 | 504674 | 2020-09-05 | Sumner | Tennessee | 47165 | 4246 | 87 |
501440 | 501440 | 2020-09-04 | Sumner | Tennessee | 47165 | 4220 | 87 |
498206 | 498206 | 2020-09-03 | Sumner | Tennessee | 47165 | 4192 | 86 |
494973 | 494973 | 2020-09-02 | Sumner | Tennessee | 47165 | 4136 | 87 |
491739 | 491739 | 2020-09-01 | Sumner | Tennessee | 47165 | 4117 | 87 |
488506 | 488506 | 2020-08-31 | Sumner | Tennessee | 47165 | 4094 | 86 |
485273 | 485273 | 2020-08-30 | Sumner | Tennessee | 47165 | 4065 | 86 |
482038 | 482038 | 2020-08-29 | Sumner | Tennessee | 47165 | 4051 | 86 |
478804 | 478804 | 2020-08-28 | Sumner | Tennessee | 47165 | 4007 | 86 |
475571 | 475571 | 2020-08-27 | Sumner | Tennessee | 47165 | 3972 | 86 |
472338 | 472338 | 2020-08-26 | Sumner | Tennessee | 47165 | 3939 | 83 |
469106 | 469106 | 2020-08-25 | Sumner | Tennessee | 47165 | 3903 | 83 |
465877 | 465877 | 2020-08-24 | Sumner | Tennessee | 47165 | 3889 | 82 |
462648 | 462648 | 2020-08-23 | Sumner | Tennessee | 47165 | 3871 | 82 |
459420 | 459420 | 2020-08-22 | Sumner | Tennessee | 47165 | 3846 | 82 |
456192 | 456192 | 2020-08-21 | Sumner | Tennessee | 47165 | 3808 | 81 |
452964 | 452964 | 2020-08-20 | Sumner | Tennessee | 47165 | 3781 | 80 |
449736 | 449736 | 2020-08-19 | Sumner | Tennessee | 47165 | 3730 | 78 |
446508 | 446508 | 2020-08-18 | Sumner | Tennessee | 47165 | 3665 | 77 |
443282 | 443282 | 2020-08-17 | Sumner | Tennessee | 47165 | 3649 | 76 |
440055 | 440055 | 2020-08-16 | Sumner | Tennessee | 47165 | 3636 | 75 |
436830 | 436830 | 2020-08-15 | Sumner | Tennessee | 47165 | 3622 | 75 |
433603 | 433603 | 2020-08-14 | Sumner | Tennessee | 47165 | 3581 | 74 |
430378 | 430378 | 2020-08-13 | Sumner | Tennessee | 47165 | 3538 | 73 |
427151 | 427151 | 2020-08-12 | Sumner | Tennessee | 47165 | 3501 | 73 |
423928 | 423928 | 2020-08-11 | Sumner | Tennessee | 47165 | 3473 | 73 |
420706 | 420706 | 2020-08-10 | Sumner | Tennessee | 47165 | 3449 | 72 |
417485 | 417485 | 2020-08-09 | Sumner | Tennessee | 47165 | 3433 | 73 |
414264 | 414264 | 2020-08-08 | Sumner | Tennessee | 47165 | 3404 | 73 |
411044 | 411044 | 2020-08-07 | Sumner | Tennessee | 47165 | 3365 | 73 |
407825 | 407825 | 2020-08-06 | Sumner | Tennessee | 47165 | 3316 | 72 |
404605 | 404605 | 2020-08-05 | Sumner | Tennessee | 47165 | 3264 | 71 |
401387 | 401387 | 2020-08-04 | Sumner | Tennessee | 47165 | 3219 | 70 |
398172 | 398172 | 2020-08-03 | Sumner | Tennessee | 47165 | 3178 | 70 |
394955 | 394955 | 2020-08-02 | Sumner | Tennessee | 47165 | 3160 | 69 |
391739 | 391739 | 2020-08-01 | Sumner | Tennessee | 47165 | 3136 | 69 |
388522 | 388522 | 2020-07-31 | Sumner | Tennessee | 47165 | 3106 | 69 |
385305 | 385305 | 2020-07-30 | Sumner | Tennessee | 47165 | 3044 | 68 |
382087 | 382087 | 2020-07-29 | Sumner | Tennessee | 47165 | 3014 | 68 |
378870 | 378870 | 2020-07-28 | Sumner | Tennessee | 47165 | 2962 | 68 |
375654 | 375654 | 2020-07-27 | Sumner | Tennessee | 47165 | 2925 | 68 |
372441 | 372441 | 2020-07-26 | Sumner | Tennessee | 47165 | 2889 | 67 |
369229 | 369229 | 2020-07-25 | Sumner | Tennessee | 47165 | 2833 | 67 |
366020 | 366020 | 2020-07-24 | Sumner | Tennessee | 47165 | 2790 | 67 |
362814 | 362814 | 2020-07-23 | Sumner | Tennessee | 47165 | 2721 | 65 |
359607 | 359607 | 2020-07-22 | Sumner | Tennessee | 47165 | 2670 | 62 |
356403 | 356403 | 2020-07-21 | Sumner | Tennessee | 47165 | 2571 | 62 |
353200 | 353200 | 2020-07-20 | Sumner | Tennessee | 47165 | 2505 | 61 |
349997 | 349997 | 2020-07-19 | Sumner | Tennessee | 47165 | 2458 | 60 |
346797 | 346797 | 2020-07-18 | Sumner | Tennessee | 47165 | 2426 | 60 |
343597 | 343597 | 2020-07-17 | Sumner | Tennessee | 47165 | 2344 | 57 |
340399 | 340399 | 2020-07-16 | Sumner | Tennessee | 47165 | 2264 | 57 |
337202 | 337202 | 2020-07-15 | Sumner | Tennessee | 47165 | 2189 | 57 |
334008 | 334008 | 2020-07-14 | Sumner | Tennessee | 47165 | 2103 | 57 |
330816 | 330816 | 2020-07-13 | Sumner | Tennessee | 47165 | 2040 | 56 |
327630 | 327630 | 2020-07-12 | Sumner | Tennessee | 47165 | 1945 | 56 |
324445 | 324445 | 2020-07-11 | Sumner | Tennessee | 47165 | 1897 | 56 |
321264 | 321264 | 2020-07-10 | Sumner | Tennessee | 47165 | 1874 | 56 |
318086 | 318086 | 2020-07-09 | Sumner | Tennessee | 47165 | 1802 | 56 |
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);