ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Tipton" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955500 | 955500 | 2021-01-22 | Tipton | Tennessee | 47167 | 6329 | 69 |
952255 | 952255 | 2021-01-21 | Tipton | Tennessee | 47167 | 6296 | 68 |
949010 | 949010 | 2021-01-20 | Tipton | Tennessee | 47167 | 6268 | 65 |
945764 | 945764 | 2021-01-19 | Tipton | Tennessee | 47167 | 6226 | 65 |
942517 | 942517 | 2021-01-18 | Tipton | Tennessee | 47167 | 6210 | 65 |
939272 | 939272 | 2021-01-17 | Tipton | Tennessee | 47167 | 6190 | 65 |
936027 | 936027 | 2021-01-16 | Tipton | Tennessee | 47167 | 6162 | 65 |
932782 | 932782 | 2021-01-15 | Tipton | Tennessee | 47167 | 6116 | 64 |
929537 | 929537 | 2021-01-14 | Tipton | Tennessee | 47167 | 6056 | 63 |
926292 | 926292 | 2021-01-13 | Tipton | Tennessee | 47167 | 6030 | 63 |
923046 | 923046 | 2021-01-12 | Tipton | Tennessee | 47167 | 5996 | 61 |
919801 | 919801 | 2021-01-11 | Tipton | Tennessee | 47167 | 5954 | 61 |
916556 | 916556 | 2021-01-10 | Tipton | Tennessee | 47167 | 5923 | 60 |
913311 | 913311 | 2021-01-09 | Tipton | Tennessee | 47167 | 5862 | 57 |
910066 | 910066 | 2021-01-08 | Tipton | Tennessee | 47167 | 5836 | 57 |
906821 | 906821 | 2021-01-07 | Tipton | Tennessee | 47167 | 5790 | 56 |
903575 | 903575 | 2021-01-06 | Tipton | Tennessee | 47167 | 5729 | 55 |
900330 | 900330 | 2021-01-05 | Tipton | Tennessee | 47167 | 5679 | 55 |
897085 | 897085 | 2021-01-04 | Tipton | Tennessee | 47167 | 5622 | 55 |
893839 | 893839 | 2021-01-03 | Tipton | Tennessee | 47167 | 5594 | 55 |
890593 | 890593 | 2021-01-02 | Tipton | Tennessee | 47167 | 5556 | 54 |
887346 | 887346 | 2021-01-01 | Tipton | Tennessee | 47167 | 5409 | 53 |
884101 | 884101 | 2020-12-31 | Tipton | Tennessee | 47167 | 5409 | 53 |
880856 | 880856 | 2020-12-30 | Tipton | Tennessee | 47167 | 5388 | 53 |
877611 | 877611 | 2020-12-29 | Tipton | Tennessee | 47167 | 5331 | 52 |
874366 | 874366 | 2020-12-28 | Tipton | Tennessee | 47167 | 5274 | 52 |
871121 | 871121 | 2020-12-27 | Tipton | Tennessee | 47167 | 5260 | 52 |
867876 | 867876 | 2020-12-26 | Tipton | Tennessee | 47167 | 5225 | 51 |
864631 | 864631 | 2020-12-25 | Tipton | Tennessee | 47167 | 5188 | 51 |
861386 | 861386 | 2020-12-24 | Tipton | Tennessee | 47167 | 5085 | 51 |
858141 | 858141 | 2020-12-23 | Tipton | Tennessee | 47167 | 5042 | 51 |
854896 | 854896 | 2020-12-22 | Tipton | Tennessee | 47167 | 5007 | 50 |
851651 | 851651 | 2020-12-21 | Tipton | Tennessee | 47167 | 4979 | 50 |
848406 | 848406 | 2020-12-20 | Tipton | Tennessee | 47167 | 4870 | 49 |
845161 | 845161 | 2020-12-19 | Tipton | Tennessee | 47167 | 4795 | 49 |
841915 | 841915 | 2020-12-18 | Tipton | Tennessee | 47167 | 4755 | 48 |
838670 | 838670 | 2020-12-17 | Tipton | Tennessee | 47167 | 4673 | 47 |
835424 | 835424 | 2020-12-16 | Tipton | Tennessee | 47167 | 4593 | 46 |
832178 | 832178 | 2020-12-15 | Tipton | Tennessee | 47167 | 4521 | 45 |
828931 | 828931 | 2020-12-14 | Tipton | Tennessee | 47167 | 4452 | 43 |
825685 | 825685 | 2020-12-13 | Tipton | Tennessee | 47167 | 4376 | 43 |
822438 | 822438 | 2020-12-12 | Tipton | Tennessee | 47167 | 4297 | 42 |
819192 | 819192 | 2020-12-11 | Tipton | Tennessee | 47167 | 4231 | 42 |
815946 | 815946 | 2020-12-10 | Tipton | Tennessee | 47167 | 4181 | 42 |
812700 | 812700 | 2020-12-09 | Tipton | Tennessee | 47167 | 4120 | 42 |
809456 | 809456 | 2020-12-08 | Tipton | Tennessee | 47167 | 4051 | 41 |
806211 | 806211 | 2020-12-07 | Tipton | Tennessee | 47167 | 4007 | 41 |
802966 | 802966 | 2020-12-06 | Tipton | Tennessee | 47167 | 3959 | 39 |
799721 | 799721 | 2020-12-05 | Tipton | Tennessee | 47167 | 3926 | 39 |
796476 | 796476 | 2020-12-04 | Tipton | Tennessee | 47167 | 3899 | 39 |
793231 | 793231 | 2020-12-03 | Tipton | Tennessee | 47167 | 3858 | 39 |
789986 | 789986 | 2020-12-02 | Tipton | Tennessee | 47167 | 3839 | 39 |
786741 | 786741 | 2020-12-01 | Tipton | Tennessee | 47167 | 3794 | 39 |
783497 | 783497 | 2020-11-30 | Tipton | Tennessee | 47167 | 3753 | 39 |
780252 | 780252 | 2020-11-29 | Tipton | Tennessee | 47167 | 3711 | 39 |
777006 | 777006 | 2020-11-28 | Tipton | Tennessee | 47167 | 3659 | 38 |
773761 | 773761 | 2020-11-27 | Tipton | Tennessee | 47167 | 3577 | 38 |
770516 | 770516 | 2020-11-26 | Tipton | Tennessee | 47167 | 3566 | 38 |
767270 | 767270 | 2020-11-25 | Tipton | Tennessee | 47167 | 3537 | 38 |
764025 | 764025 | 2020-11-24 | Tipton | Tennessee | 47167 | 3491 | 38 |
760780 | 760780 | 2020-11-23 | Tipton | Tennessee | 47167 | 3487 | 36 |
757535 | 757535 | 2020-11-22 | Tipton | Tennessee | 47167 | 3451 | 36 |
754288 | 754288 | 2020-11-21 | Tipton | Tennessee | 47167 | 3367 | 35 |
751042 | 751042 | 2020-11-20 | Tipton | Tennessee | 47167 | 3294 | 35 |
747796 | 747796 | 2020-11-19 | Tipton | Tennessee | 47167 | 3233 | 34 |
744550 | 744550 | 2020-11-18 | Tipton | Tennessee | 47167 | 3204 | 34 |
741303 | 741303 | 2020-11-17 | Tipton | Tennessee | 47167 | 3138 | 33 |
738057 | 738057 | 2020-11-16 | Tipton | Tennessee | 47167 | 3144 | 32 |
734813 | 734813 | 2020-11-15 | Tipton | Tennessee | 47167 | 3065 | 32 |
731567 | 731567 | 2020-11-14 | Tipton | Tennessee | 47167 | 2994 | 32 |
728323 | 728323 | 2020-11-13 | Tipton | Tennessee | 47167 | 2916 | 32 |
725079 | 725079 | 2020-11-12 | Tipton | Tennessee | 47167 | 2857 | 31 |
721836 | 721836 | 2020-11-11 | Tipton | Tennessee | 47167 | 2815 | 31 |
718593 | 718593 | 2020-11-10 | Tipton | Tennessee | 47167 | 2791 | 26 |
715350 | 715350 | 2020-11-09 | Tipton | Tennessee | 47167 | 2775 | 25 |
712106 | 712106 | 2020-11-08 | Tipton | Tennessee | 47167 | 2723 | 25 |
708862 | 708862 | 2020-11-07 | Tipton | Tennessee | 47167 | 2679 | 25 |
705619 | 705619 | 2020-11-06 | Tipton | Tennessee | 47167 | 2617 | 24 |
702376 | 702376 | 2020-11-05 | Tipton | Tennessee | 47167 | 2612 | 24 |
699132 | 699132 | 2020-11-04 | Tipton | Tennessee | 47167 | 2596 | 24 |
695889 | 695889 | 2020-11-03 | Tipton | Tennessee | 47167 | 2566 | 24 |
692647 | 692647 | 2020-11-02 | Tipton | Tennessee | 47167 | 2565 | 23 |
689403 | 689403 | 2020-11-01 | Tipton | Tennessee | 47167 | 2506 | 23 |
686158 | 686158 | 2020-10-31 | Tipton | Tennessee | 47167 | 2503 | 23 |
682915 | 682915 | 2020-10-30 | Tipton | Tennessee | 47167 | 2501 | 23 |
679672 | 679672 | 2020-10-29 | Tipton | Tennessee | 47167 | 2466 | 23 |
676429 | 676429 | 2020-10-28 | Tipton | Tennessee | 47167 | 2439 | 23 |
673186 | 673186 | 2020-10-27 | Tipton | Tennessee | 47167 | 2406 | 23 |
669944 | 669944 | 2020-10-26 | Tipton | Tennessee | 47167 | 2381 | 23 |
666700 | 666700 | 2020-10-25 | Tipton | Tennessee | 47167 | 2367 | 23 |
663455 | 663455 | 2020-10-24 | Tipton | Tennessee | 47167 | 2322 | 22 |
660211 | 660211 | 2020-10-23 | Tipton | Tennessee | 47167 | 2309 | 22 |
656967 | 656967 | 2020-10-22 | Tipton | Tennessee | 47167 | 2260 | 22 |
653722 | 653722 | 2020-10-21 | Tipton | Tennessee | 47167 | 2235 | 22 |
650477 | 650477 | 2020-10-20 | Tipton | Tennessee | 47167 | 2206 | 22 |
647233 | 647233 | 2020-10-19 | Tipton | Tennessee | 47167 | 2192 | 22 |
643987 | 643987 | 2020-10-18 | Tipton | Tennessee | 47167 | 2171 | 22 |
640739 | 640739 | 2020-10-17 | Tipton | Tennessee | 47167 | 2151 | 22 |
637493 | 637493 | 2020-10-16 | Tipton | Tennessee | 47167 | 2128 | 22 |
634247 | 634247 | 2020-10-15 | Tipton | Tennessee | 47167 | 2123 | 22 |
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);