ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 47003 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955418 | 955418 | 2021-01-22 | Bedford | Tennessee | 47003 | 5403 | 91 |
952173 | 952173 | 2021-01-21 | Bedford | Tennessee | 47003 | 5386 | 90 |
948928 | 948928 | 2021-01-20 | Bedford | Tennessee | 47003 | 5356 | 90 |
945682 | 945682 | 2021-01-19 | Bedford | Tennessee | 47003 | 5328 | 89 |
942435 | 942435 | 2021-01-18 | Bedford | Tennessee | 47003 | 5325 | 89 |
939190 | 939190 | 2021-01-17 | Bedford | Tennessee | 47003 | 5320 | 86 |
935945 | 935945 | 2021-01-16 | Bedford | Tennessee | 47003 | 5303 | 86 |
932700 | 932700 | 2021-01-15 | Bedford | Tennessee | 47003 | 5238 | 85 |
929455 | 929455 | 2021-01-14 | Bedford | Tennessee | 47003 | 5207 | 85 |
926210 | 926210 | 2021-01-13 | Bedford | Tennessee | 47003 | 5160 | 84 |
922964 | 922964 | 2021-01-12 | Bedford | Tennessee | 47003 | 5138 | 83 |
919719 | 919719 | 2021-01-11 | Bedford | Tennessee | 47003 | 5104 | 79 |
916474 | 916474 | 2021-01-10 | Bedford | Tennessee | 47003 | 5084 | 76 |
913229 | 913229 | 2021-01-09 | Bedford | Tennessee | 47003 | 5020 | 76 |
909984 | 909984 | 2021-01-08 | Bedford | Tennessee | 47003 | 4987 | 75 |
906739 | 906739 | 2021-01-07 | Bedford | Tennessee | 47003 | 4955 | 75 |
903493 | 903493 | 2021-01-06 | Bedford | Tennessee | 47003 | 4867 | 74 |
900248 | 900248 | 2021-01-05 | Bedford | Tennessee | 47003 | 4822 | 69 |
897003 | 897003 | 2021-01-04 | Bedford | Tennessee | 47003 | 4789 | 65 |
893757 | 893757 | 2021-01-03 | Bedford | Tennessee | 47003 | 4761 | 64 |
890511 | 890511 | 2021-01-02 | Bedford | Tennessee | 47003 | 4723 | 63 |
887264 | 887264 | 2021-01-01 | Bedford | Tennessee | 47003 | 4548 | 61 |
884019 | 884019 | 2020-12-31 | Bedford | Tennessee | 47003 | 4548 | 61 |
880774 | 880774 | 2020-12-30 | Bedford | Tennessee | 47003 | 4500 | 60 |
877529 | 877529 | 2020-12-29 | Bedford | Tennessee | 47003 | 4448 | 60 |
874284 | 874284 | 2020-12-28 | Bedford | Tennessee | 47003 | 4430 | 59 |
871039 | 871039 | 2020-12-27 | Bedford | Tennessee | 47003 | 4422 | 59 |
867794 | 867794 | 2020-12-26 | Bedford | Tennessee | 47003 | 4407 | 57 |
864549 | 864549 | 2020-12-25 | Bedford | Tennessee | 47003 | 4379 | 57 |
861304 | 861304 | 2020-12-24 | Bedford | Tennessee | 47003 | 4292 | 57 |
858059 | 858059 | 2020-12-23 | Bedford | Tennessee | 47003 | 4259 | 57 |
854814 | 854814 | 2020-12-22 | Bedford | Tennessee | 47003 | 4217 | 55 |
851569 | 851569 | 2020-12-21 | Bedford | Tennessee | 47003 | 4196 | 54 |
848324 | 848324 | 2020-12-20 | Bedford | Tennessee | 47003 | 4107 | 54 |
845079 | 845079 | 2020-12-19 | Bedford | Tennessee | 47003 | 4038 | 54 |
841833 | 841833 | 2020-12-18 | Bedford | Tennessee | 47003 | 4020 | 54 |
838588 | 838588 | 2020-12-17 | Bedford | Tennessee | 47003 | 3951 | 52 |
835342 | 835342 | 2020-12-16 | Bedford | Tennessee | 47003 | 3893 | 49 |
832096 | 832096 | 2020-12-15 | Bedford | Tennessee | 47003 | 3772 | 46 |
828849 | 828849 | 2020-12-14 | Bedford | Tennessee | 47003 | 3635 | 46 |
825603 | 825603 | 2020-12-13 | Bedford | Tennessee | 47003 | 3579 | 46 |
822356 | 822356 | 2020-12-12 | Bedford | Tennessee | 47003 | 3487 | 46 |
819110 | 819110 | 2020-12-11 | Bedford | Tennessee | 47003 | 3449 | 46 |
815864 | 815864 | 2020-12-10 | Bedford | Tennessee | 47003 | 3375 | 45 |
812618 | 812618 | 2020-12-09 | Bedford | Tennessee | 47003 | 3303 | 43 |
809374 | 809374 | 2020-12-08 | Bedford | Tennessee | 47003 | 3218 | 42 |
806129 | 806129 | 2020-12-07 | Bedford | Tennessee | 47003 | 3171 | 41 |
802884 | 802884 | 2020-12-06 | Bedford | Tennessee | 47003 | 3046 | 40 |
799639 | 799639 | 2020-12-05 | Bedford | Tennessee | 47003 | 3020 | 39 |
796394 | 796394 | 2020-12-04 | Bedford | Tennessee | 47003 | 2981 | 34 |
793149 | 793149 | 2020-12-03 | Bedford | Tennessee | 47003 | 2957 | 34 |
789904 | 789904 | 2020-12-02 | Bedford | Tennessee | 47003 | 2949 | 34 |
786659 | 786659 | 2020-12-01 | Bedford | Tennessee | 47003 | 2922 | 32 |
783415 | 783415 | 2020-11-30 | Bedford | Tennessee | 47003 | 2851 | 32 |
780170 | 780170 | 2020-11-29 | Bedford | Tennessee | 47003 | 2788 | 30 |
776924 | 776924 | 2020-11-28 | Bedford | Tennessee | 47003 | 2756 | 30 |
773679 | 773679 | 2020-11-27 | Bedford | Tennessee | 47003 | 2701 | 30 |
770434 | 770434 | 2020-11-26 | Bedford | Tennessee | 47003 | 2643 | 30 |
767188 | 767188 | 2020-11-25 | Bedford | Tennessee | 47003 | 2595 | 30 |
763943 | 763943 | 2020-11-24 | Bedford | Tennessee | 47003 | 2564 | 28 |
760698 | 760698 | 2020-11-23 | Bedford | Tennessee | 47003 | 2544 | 28 |
757453 | 757453 | 2020-11-22 | Bedford | Tennessee | 47003 | 2503 | 28 |
754206 | 754206 | 2020-11-21 | Bedford | Tennessee | 47003 | 2458 | 27 |
750960 | 750960 | 2020-11-20 | Bedford | Tennessee | 47003 | 2412 | 27 |
747714 | 747714 | 2020-11-19 | Bedford | Tennessee | 47003 | 2381 | 28 |
744468 | 744468 | 2020-11-18 | Bedford | Tennessee | 47003 | 2368 | 28 |
741221 | 741221 | 2020-11-17 | Bedford | Tennessee | 47003 | 2343 | 24 |
737975 | 737975 | 2020-11-16 | Bedford | Tennessee | 47003 | 2333 | 24 |
734731 | 734731 | 2020-11-15 | Bedford | Tennessee | 47003 | 2248 | 24 |
731485 | 731485 | 2020-11-14 | Bedford | Tennessee | 47003 | 2201 | 24 |
728241 | 728241 | 2020-11-13 | Bedford | Tennessee | 47003 | 2153 | 24 |
724997 | 724997 | 2020-11-12 | Bedford | Tennessee | 47003 | 2122 | 24 |
721754 | 721754 | 2020-11-11 | Bedford | Tennessee | 47003 | 2101 | 24 |
718511 | 718511 | 2020-11-10 | Bedford | Tennessee | 47003 | 2071 | 24 |
715268 | 715268 | 2020-11-09 | Bedford | Tennessee | 47003 | 2051 | 23 |
712024 | 712024 | 2020-11-08 | Bedford | Tennessee | 47003 | 1992 | 23 |
708780 | 708780 | 2020-11-07 | Bedford | Tennessee | 47003 | 1972 | 23 |
705537 | 705537 | 2020-11-06 | Bedford | Tennessee | 47003 | 1926 | 23 |
702294 | 702294 | 2020-11-05 | Bedford | Tennessee | 47003 | 1925 | 23 |
699050 | 699050 | 2020-11-04 | Bedford | Tennessee | 47003 | 1914 | 23 |
695807 | 695807 | 2020-11-03 | Bedford | Tennessee | 47003 | 1861 | 23 |
692565 | 692565 | 2020-11-02 | Bedford | Tennessee | 47003 | 1847 | 23 |
689321 | 689321 | 2020-11-01 | Bedford | Tennessee | 47003 | 1830 | 23 |
686076 | 686076 | 2020-10-31 | Bedford | Tennessee | 47003 | 1822 | 23 |
682833 | 682833 | 2020-10-30 | Bedford | Tennessee | 47003 | 1805 | 22 |
679590 | 679590 | 2020-10-29 | Bedford | Tennessee | 47003 | 1789 | 20 |
676347 | 676347 | 2020-10-28 | Bedford | Tennessee | 47003 | 1763 | 20 |
673104 | 673104 | 2020-10-27 | Bedford | Tennessee | 47003 | 1753 | 20 |
669862 | 669862 | 2020-10-26 | Bedford | Tennessee | 47003 | 1745 | 20 |
666618 | 666618 | 2020-10-25 | Bedford | Tennessee | 47003 | 1709 | 20 |
663373 | 663373 | 2020-10-24 | Bedford | Tennessee | 47003 | 1681 | 20 |
660129 | 660129 | 2020-10-23 | Bedford | Tennessee | 47003 | 1650 | 20 |
656885 | 656885 | 2020-10-22 | Bedford | Tennessee | 47003 | 1617 | 20 |
653640 | 653640 | 2020-10-21 | Bedford | Tennessee | 47003 | 1606 | 20 |
650395 | 650395 | 2020-10-20 | Bedford | Tennessee | 47003 | 1596 | 20 |
647151 | 647151 | 2020-10-19 | Bedford | Tennessee | 47003 | 1590 | 20 |
643905 | 643905 | 2020-10-18 | Bedford | Tennessee | 47003 | 1573 | 20 |
640657 | 640657 | 2020-10-17 | Bedford | Tennessee | 47003 | 1562 | 20 |
637411 | 637411 | 2020-10-16 | Bedford | Tennessee | 47003 | 1551 | 20 |
634165 | 634165 | 2020-10-15 | Bedford | Tennessee | 47003 | 1548 | 19 |
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);