ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Franklin" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922988 | 922988 | 2021-01-12 | Franklin | Tennessee | 47051 | 3941 | 51 |
919743 | 919743 | 2021-01-11 | Franklin | Tennessee | 47051 | 3925 | 51 |
916498 | 916498 | 2021-01-10 | Franklin | Tennessee | 47051 | 3913 | 51 |
913253 | 913253 | 2021-01-09 | Franklin | Tennessee | 47051 | 3874 | 50 |
910008 | 910008 | 2021-01-08 | Franklin | Tennessee | 47051 | 3847 | 50 |
906763 | 906763 | 2021-01-07 | Franklin | Tennessee | 47051 | 3806 | 49 |
903517 | 903517 | 2021-01-06 | Franklin | Tennessee | 47051 | 3751 | 49 |
900272 | 900272 | 2021-01-05 | Franklin | Tennessee | 47051 | 3726 | 48 |
897027 | 897027 | 2021-01-04 | Franklin | Tennessee | 47051 | 3689 | 48 |
893781 | 893781 | 2021-01-03 | Franklin | Tennessee | 47051 | 3664 | 48 |
890535 | 890535 | 2021-01-02 | Franklin | Tennessee | 47051 | 3638 | 48 |
887288 | 887288 | 2021-01-01 | Franklin | Tennessee | 47051 | 3549 | 48 |
884043 | 884043 | 2020-12-31 | Franklin | Tennessee | 47051 | 3549 | 48 |
880798 | 880798 | 2020-12-30 | Franklin | Tennessee | 47051 | 3491 | 48 |
877553 | 877553 | 2020-12-29 | Franklin | Tennessee | 47051 | 3448 | 48 |
874308 | 874308 | 2020-12-28 | Franklin | Tennessee | 47051 | 3423 | 46 |
871063 | 871063 | 2020-12-27 | Franklin | Tennessee | 47051 | 3379 | 46 |
867818 | 867818 | 2020-12-26 | Franklin | Tennessee | 47051 | 3362 | 46 |
864573 | 864573 | 2020-12-25 | Franklin | Tennessee | 47051 | 3336 | 46 |
861328 | 861328 | 2020-12-24 | Franklin | Tennessee | 47051 | 3265 | 46 |
858083 | 858083 | 2020-12-23 | Franklin | Tennessee | 47051 | 3234 | 45 |
854838 | 854838 | 2020-12-22 | Franklin | Tennessee | 47051 | 3195 | 45 |
851593 | 851593 | 2020-12-21 | Franklin | Tennessee | 47051 | 3168 | 44 |
848348 | 848348 | 2020-12-20 | Franklin | Tennessee | 47051 | 3107 | 44 |
845103 | 845103 | 2020-12-19 | Franklin | Tennessee | 47051 | 3041 | 44 |
841857 | 841857 | 2020-12-18 | Franklin | Tennessee | 47051 | 3001 | 43 |
838612 | 838612 | 2020-12-17 | Franklin | Tennessee | 47051 | 2922 | 43 |
835366 | 835366 | 2020-12-16 | Franklin | Tennessee | 47051 | 2864 | 41 |
832120 | 832120 | 2020-12-15 | Franklin | Tennessee | 47051 | 2809 | 41 |
828873 | 828873 | 2020-12-14 | Franklin | Tennessee | 47051 | 2758 | 41 |
825627 | 825627 | 2020-12-13 | Franklin | Tennessee | 47051 | 2702 | 41 |
822380 | 822380 | 2020-12-12 | Franklin | Tennessee | 47051 | 2626 | 41 |
819134 | 819134 | 2020-12-11 | Franklin | Tennessee | 47051 | 2587 | 41 |
815888 | 815888 | 2020-12-10 | Franklin | Tennessee | 47051 | 2536 | 41 |
812642 | 812642 | 2020-12-09 | Franklin | Tennessee | 47051 | 2514 | 41 |
809398 | 809398 | 2020-12-08 | Franklin | Tennessee | 47051 | 2446 | 41 |
806153 | 806153 | 2020-12-07 | Franklin | Tennessee | 47051 | 2412 | 40 |
802908 | 802908 | 2020-12-06 | Franklin | Tennessee | 47051 | 2350 | 40 |
799663 | 799663 | 2020-12-05 | Franklin | Tennessee | 47051 | 2297 | 40 |
796418 | 796418 | 2020-12-04 | Franklin | Tennessee | 47051 | 2283 | 40 |
793173 | 793173 | 2020-12-03 | Franklin | Tennessee | 47051 | 2245 | 38 |
789928 | 789928 | 2020-12-02 | Franklin | Tennessee | 47051 | 2231 | 38 |
786683 | 786683 | 2020-12-01 | Franklin | Tennessee | 47051 | 2210 | 36 |
783439 | 783439 | 2020-11-30 | Franklin | Tennessee | 47051 | 2179 | 35 |
780194 | 780194 | 2020-11-29 | Franklin | Tennessee | 47051 | 2119 | 34 |
776948 | 776948 | 2020-11-28 | Franklin | Tennessee | 47051 | 2086 | 34 |
773703 | 773703 | 2020-11-27 | Franklin | Tennessee | 47051 | 2044 | 34 |
770458 | 770458 | 2020-11-26 | Franklin | Tennessee | 47051 | 2008 | 34 |
767212 | 767212 | 2020-11-25 | Franklin | Tennessee | 47051 | 1961 | 33 |
763967 | 763967 | 2020-11-24 | Franklin | Tennessee | 47051 | 1942 | 32 |
760722 | 760722 | 2020-11-23 | Franklin | Tennessee | 47051 | 1936 | 32 |
757477 | 757477 | 2020-11-22 | Franklin | Tennessee | 47051 | 1896 | 31 |
754230 | 754230 | 2020-11-21 | Franklin | Tennessee | 47051 | 1874 | 29 |
750984 | 750984 | 2020-11-20 | Franklin | Tennessee | 47051 | 1844 | 29 |
747738 | 747738 | 2020-11-19 | Franklin | Tennessee | 47051 | 1821 | 29 |
744492 | 744492 | 2020-11-18 | Franklin | Tennessee | 47051 | 1793 | 29 |
741245 | 741245 | 2020-11-17 | Franklin | Tennessee | 47051 | 1760 | 29 |
737999 | 737999 | 2020-11-16 | Franklin | Tennessee | 47051 | 1739 | 29 |
734755 | 734755 | 2020-11-15 | Franklin | Tennessee | 47051 | 1678 | 29 |
731509 | 731509 | 2020-11-14 | Franklin | Tennessee | 47051 | 1647 | 29 |
728265 | 728265 | 2020-11-13 | Franklin | Tennessee | 47051 | 1608 | 29 |
725021 | 725021 | 2020-11-12 | Franklin | Tennessee | 47051 | 1559 | 28 |
721778 | 721778 | 2020-11-11 | Franklin | Tennessee | 47051 | 1543 | 28 |
718535 | 718535 | 2020-11-10 | Franklin | Tennessee | 47051 | 1520 | 27 |
715292 | 715292 | 2020-11-09 | Franklin | Tennessee | 47051 | 1511 | 27 |
712048 | 712048 | 2020-11-08 | Franklin | Tennessee | 47051 | 1481 | 27 |
708804 | 708804 | 2020-11-07 | Franklin | Tennessee | 47051 | 1468 | 27 |
705561 | 705561 | 2020-11-06 | Franklin | Tennessee | 47051 | 1433 | 27 |
702318 | 702318 | 2020-11-05 | Franklin | Tennessee | 47051 | 1426 | 27 |
699074 | 699074 | 2020-11-04 | Franklin | Tennessee | 47051 | 1417 | 26 |
695831 | 695831 | 2020-11-03 | Franklin | Tennessee | 47051 | 1391 | 26 |
692589 | 692589 | 2020-11-02 | Franklin | Tennessee | 47051 | 1373 | 25 |
689345 | 689345 | 2020-11-01 | Franklin | Tennessee | 47051 | 1357 | 25 |
686100 | 686100 | 2020-10-31 | Franklin | Tennessee | 47051 | 1357 | 25 |
682857 | 682857 | 2020-10-30 | Franklin | Tennessee | 47051 | 1351 | 24 |
679614 | 679614 | 2020-10-29 | Franklin | Tennessee | 47051 | 1336 | 23 |
676371 | 676371 | 2020-10-28 | Franklin | Tennessee | 47051 | 1314 | 23 |
673128 | 673128 | 2020-10-27 | Franklin | Tennessee | 47051 | 1305 | 22 |
669886 | 669886 | 2020-10-26 | Franklin | Tennessee | 47051 | 1302 | 20 |
666642 | 666642 | 2020-10-25 | Franklin | Tennessee | 47051 | 1295 | 19 |
663397 | 663397 | 2020-10-24 | Franklin | Tennessee | 47051 | 1278 | 19 |
660153 | 660153 | 2020-10-23 | Franklin | Tennessee | 47051 | 1263 | 17 |
656909 | 656909 | 2020-10-22 | Franklin | Tennessee | 47051 | 1244 | 16 |
653664 | 653664 | 2020-10-21 | Franklin | Tennessee | 47051 | 1234 | 16 |
650419 | 650419 | 2020-10-20 | Franklin | Tennessee | 47051 | 1228 | 16 |
647175 | 647175 | 2020-10-19 | Franklin | Tennessee | 47051 | 1211 | 15 |
643929 | 643929 | 2020-10-18 | Franklin | Tennessee | 47051 | 1190 | 15 |
640681 | 640681 | 2020-10-17 | Franklin | Tennessee | 47051 | 1181 | 15 |
637435 | 637435 | 2020-10-16 | Franklin | Tennessee | 47051 | 1173 | 14 |
634189 | 634189 | 2020-10-15 | Franklin | Tennessee | 47051 | 1169 | 14 |
630944 | 630944 | 2020-10-14 | Franklin | Tennessee | 47051 | 1154 | 14 |
627700 | 627700 | 2020-10-13 | Franklin | Tennessee | 47051 | 1144 | 13 |
624458 | 624458 | 2020-10-12 | Franklin | Tennessee | 47051 | 1139 | 12 |
621215 | 621215 | 2020-10-11 | Franklin | Tennessee | 47051 | 1124 | 12 |
617972 | 617972 | 2020-10-10 | Franklin | Tennessee | 47051 | 1109 | 12 |
614730 | 614730 | 2020-10-09 | Franklin | Tennessee | 47051 | 1099 | 12 |
611489 | 611489 | 2020-10-08 | Franklin | Tennessee | 47051 | 1080 | 12 |
608247 | 608247 | 2020-10-07 | Franklin | Tennessee | 47051 | 1073 | 11 |
605004 | 605004 | 2020-10-06 | Franklin | Tennessee | 47051 | 1056 | 10 |
601762 | 601762 | 2020-10-05 | Franklin | Tennessee | 47051 | 1052 | 10 |
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);