ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
625 rows where deaths = 6 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Trousdale 50
- Lawrence 39
- Morgan 38
- Cumberland 27
- Roane 21
- Moore 20
- Van Buren 18
- Putnam 17
- Loudon 16
- Anderson 14
- Humphreys 14
- Claiborne 13
- Clay 13
- Hancock 13
- Lauderdale 13
- Monroe 13
- Wayne 13
- Carroll 12
- Coffee 12
- Carter 11
- Meigs 11
- Rutherford 10
- Sullivan 10
- Bledsoe 9
- Decatur 9
- Jefferson 9
- DeKalb 8
- Hamblen 8
- Lake 8
- Unknown 8
- …
state 1
- Tennessee · 625 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
948960 | 948960 | 2021-01-20 | Hancock | Tennessee | 47067 | 407 | 6 |
945714 | 945714 | 2021-01-19 | Hancock | Tennessee | 47067 | 405 | 6 |
942467 | 942467 | 2021-01-18 | Hancock | Tennessee | 47067 | 405 | 6 |
939222 | 939222 | 2021-01-17 | Hancock | Tennessee | 47067 | 402 | 6 |
935977 | 935977 | 2021-01-16 | Hancock | Tennessee | 47067 | 402 | 6 |
932732 | 932732 | 2021-01-15 | Hancock | Tennessee | 47067 | 398 | 6 |
929487 | 929487 | 2021-01-14 | Hancock | Tennessee | 47067 | 393 | 6 |
926242 | 926242 | 2021-01-13 | Hancock | Tennessee | 47067 | 389 | 6 |
922996 | 922996 | 2021-01-12 | Hancock | Tennessee | 47067 | 384 | 6 |
923026 | 923026 | 2021-01-12 | Moore | Tennessee | 47127 | 775 | 6 |
919751 | 919751 | 2021-01-11 | Hancock | Tennessee | 47067 | 380 | 6 |
919781 | 919781 | 2021-01-11 | Moore | Tennessee | 47127 | 773 | 6 |
916506 | 916506 | 2021-01-10 | Hancock | Tennessee | 47067 | 381 | 6 |
916536 | 916536 | 2021-01-10 | Moore | Tennessee | 47127 | 770 | 6 |
913261 | 913261 | 2021-01-09 | Hancock | Tennessee | 47067 | 376 | 6 |
913291 | 913291 | 2021-01-09 | Moore | Tennessee | 47127 | 764 | 6 |
913316 | 913316 | 2021-01-09 | Van Buren | Tennessee | 47175 | 612 | 6 |
910016 | 910016 | 2021-01-08 | Hancock | Tennessee | 47067 | 368 | 6 |
910046 | 910046 | 2021-01-08 | Moore | Tennessee | 47127 | 755 | 6 |
910071 | 910071 | 2021-01-08 | Van Buren | Tennessee | 47175 | 604 | 6 |
906801 | 906801 | 2021-01-07 | Moore | Tennessee | 47127 | 753 | 6 |
906826 | 906826 | 2021-01-07 | Van Buren | Tennessee | 47175 | 599 | 6 |
903555 | 903555 | 2021-01-06 | Moore | Tennessee | 47127 | 733 | 6 |
903580 | 903580 | 2021-01-06 | Van Buren | Tennessee | 47175 | 581 | 6 |
900310 | 900310 | 2021-01-05 | Moore | Tennessee | 47127 | 728 | 6 |
900335 | 900335 | 2021-01-05 | Van Buren | Tennessee | 47175 | 577 | 6 |
897065 | 897065 | 2021-01-04 | Moore | Tennessee | 47127 | 720 | 6 |
897090 | 897090 | 2021-01-04 | Van Buren | Tennessee | 47175 | 572 | 6 |
893819 | 893819 | 2021-01-03 | Moore | Tennessee | 47127 | 719 | 6 |
893844 | 893844 | 2021-01-03 | Van Buren | Tennessee | 47175 | 569 | 6 |
890573 | 890573 | 2021-01-02 | Moore | Tennessee | 47127 | 715 | 6 |
890598 | 890598 | 2021-01-02 | Van Buren | Tennessee | 47175 | 562 | 6 |
887326 | 887326 | 2021-01-01 | Moore | Tennessee | 47127 | 701 | 6 |
887351 | 887351 | 2021-01-01 | Van Buren | Tennessee | 47175 | 545 | 6 |
884081 | 884081 | 2020-12-31 | Moore | Tennessee | 47127 | 701 | 6 |
884106 | 884106 | 2020-12-31 | Van Buren | Tennessee | 47175 | 545 | 6 |
880836 | 880836 | 2020-12-30 | Moore | Tennessee | 47127 | 684 | 6 |
880861 | 880861 | 2020-12-30 | Van Buren | Tennessee | 47175 | 541 | 6 |
877591 | 877591 | 2020-12-29 | Moore | Tennessee | 47127 | 672 | 6 |
877616 | 877616 | 2020-12-29 | Van Buren | Tennessee | 47175 | 537 | 6 |
874346 | 874346 | 2020-12-28 | Moore | Tennessee | 47127 | 670 | 6 |
874371 | 874371 | 2020-12-28 | Van Buren | Tennessee | 47175 | 536 | 6 |
871101 | 871101 | 2020-12-27 | Moore | Tennessee | 47127 | 666 | 6 |
871126 | 871126 | 2020-12-27 | Van Buren | Tennessee | 47175 | 533 | 6 |
867856 | 867856 | 2020-12-26 | Moore | Tennessee | 47127 | 655 | 6 |
867881 | 867881 | 2020-12-26 | Van Buren | Tennessee | 47175 | 534 | 6 |
864611 | 864611 | 2020-12-25 | Moore | Tennessee | 47127 | 652 | 6 |
864636 | 864636 | 2020-12-25 | Van Buren | Tennessee | 47175 | 530 | 6 |
861366 | 861366 | 2020-12-24 | Moore | Tennessee | 47127 | 637 | 6 |
861391 | 861391 | 2020-12-24 | Van Buren | Tennessee | 47175 | 519 | 6 |
858146 | 858146 | 2020-12-23 | Van Buren | Tennessee | 47175 | 519 | 6 |
845081 | 845081 | 2020-12-19 | Bledsoe | Tennessee | 47007 | 1442 | 6 |
841835 | 841835 | 2020-12-18 | Bledsoe | Tennessee | 47007 | 1431 | 6 |
838590 | 838590 | 2020-12-17 | Bledsoe | Tennessee | 47007 | 1401 | 6 |
838663 | 838663 | 2020-12-17 | Sequatchie | Tennessee | 47153 | 921 | 6 |
835344 | 835344 | 2020-12-16 | Bledsoe | Tennessee | 47007 | 1380 | 6 |
832098 | 832098 | 2020-12-15 | Bledsoe | Tennessee | 47007 | 1371 | 6 |
828851 | 828851 | 2020-12-14 | Bledsoe | Tennessee | 47007 | 1362 | 6 |
828934 | 828934 | 2020-12-14 | Union | Tennessee | 47173 | 1013 | 6 |
825605 | 825605 | 2020-12-13 | Bledsoe | Tennessee | 47007 | 1347 | 6 |
825688 | 825688 | 2020-12-13 | Union | Tennessee | 47173 | 952 | 6 |
822358 | 822358 | 2020-12-12 | Bledsoe | Tennessee | 47007 | 1325 | 6 |
822441 | 822441 | 2020-12-12 | Union | Tennessee | 47173 | 895 | 6 |
819112 | 819112 | 2020-12-11 | Bledsoe | Tennessee | 47007 | 1321 | 6 |
819195 | 819195 | 2020-12-11 | Union | Tennessee | 47173 | 880 | 6 |
815949 | 815949 | 2020-12-10 | Union | Tennessee | 47173 | 862 | 6 |
793195 | 793195 | 2020-12-03 | Lake | Tennessee | 47095 | 1193 | 6 |
793212 | 793212 | 2020-12-03 | Morgan | Tennessee | 47129 | 799 | 6 |
789950 | 789950 | 2020-12-02 | Lake | Tennessee | 47095 | 1189 | 6 |
789967 | 789967 | 2020-12-02 | Morgan | Tennessee | 47129 | 788 | 6 |
786705 | 786705 | 2020-12-01 | Lake | Tennessee | 47095 | 1182 | 6 |
786722 | 786722 | 2020-12-01 | Morgan | Tennessee | 47129 | 780 | 6 |
783461 | 783461 | 2020-11-30 | Lake | Tennessee | 47095 | 1178 | 6 |
783478 | 783478 | 2020-11-30 | Morgan | Tennessee | 47129 | 762 | 6 |
780216 | 780216 | 2020-11-29 | Lake | Tennessee | 47095 | 1178 | 6 |
780233 | 780233 | 2020-11-29 | Morgan | Tennessee | 47129 | 739 | 6 |
776970 | 776970 | 2020-11-28 | Lake | Tennessee | 47095 | 1176 | 6 |
776987 | 776987 | 2020-11-28 | Morgan | Tennessee | 47129 | 730 | 6 |
773725 | 773725 | 2020-11-27 | Lake | Tennessee | 47095 | 1165 | 6 |
773742 | 773742 | 2020-11-27 | Morgan | Tennessee | 47129 | 709 | 6 |
770480 | 770480 | 2020-11-26 | Lake | Tennessee | 47095 | 1163 | 6 |
770497 | 770497 | 2020-11-26 | Morgan | Tennessee | 47129 | 695 | 6 |
767251 | 767251 | 2020-11-25 | Morgan | Tennessee | 47129 | 688 | 6 |
764006 | 764006 | 2020-11-24 | Morgan | Tennessee | 47129 | 679 | 6 |
764029 | 764029 | 2020-11-24 | Unknown | Tennessee | 49 | 6 | |
760761 | 760761 | 2020-11-23 | Morgan | Tennessee | 47129 | 672 | 6 |
757516 | 757516 | 2020-11-22 | Morgan | Tennessee | 47129 | 654 | 6 |
754269 | 754269 | 2020-11-21 | Morgan | Tennessee | 47129 | 639 | 6 |
751023 | 751023 | 2020-11-20 | Morgan | Tennessee | 47129 | 609 | 6 |
747777 | 747777 | 2020-11-19 | Morgan | Tennessee | 47129 | 600 | 6 |
747788 | 747788 | 2020-11-19 | Scott | Tennessee | 47151 | 843 | 6 |
744531 | 744531 | 2020-11-18 | Morgan | Tennessee | 47129 | 594 | 6 |
744542 | 744542 | 2020-11-18 | Scott | Tennessee | 47151 | 802 | 6 |
741284 | 741284 | 2020-11-17 | Morgan | Tennessee | 47129 | 581 | 6 |
741295 | 741295 | 2020-11-17 | Scott | Tennessee | 47151 | 781 | 6 |
738016 | 738016 | 2020-11-16 | Humphreys | Tennessee | 47085 | 606 | 6 |
738038 | 738038 | 2020-11-16 | Morgan | Tennessee | 47129 | 579 | 6 |
738049 | 738049 | 2020-11-16 | Scott | Tennessee | 47151 | 764 | 6 |
734772 | 734772 | 2020-11-15 | Humphreys | Tennessee | 47085 | 591 | 6 |
734794 | 734794 | 2020-11-15 | Morgan | Tennessee | 47129 | 568 | 6 |
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);