ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Scott" and fips = 47151 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923038 | 923038 | 2021-01-12 | Scott | Tennessee | 47151 | 2176 | 30 |
919793 | 919793 | 2021-01-11 | Scott | Tennessee | 47151 | 2172 | 29 |
916548 | 916548 | 2021-01-10 | Scott | Tennessee | 47151 | 2168 | 28 |
913303 | 913303 | 2021-01-09 | Scott | Tennessee | 47151 | 2153 | 28 |
910058 | 910058 | 2021-01-08 | Scott | Tennessee | 47151 | 2137 | 27 |
906813 | 906813 | 2021-01-07 | Scott | Tennessee | 47151 | 2131 | 26 |
903567 | 903567 | 2021-01-06 | Scott | Tennessee | 47151 | 2106 | 26 |
900322 | 900322 | 2021-01-05 | Scott | Tennessee | 47151 | 2078 | 25 |
897077 | 897077 | 2021-01-04 | Scott | Tennessee | 47151 | 2067 | 25 |
893831 | 893831 | 2021-01-03 | Scott | Tennessee | 47151 | 2061 | 25 |
890585 | 890585 | 2021-01-02 | Scott | Tennessee | 47151 | 2048 | 25 |
887338 | 887338 | 2021-01-01 | Scott | Tennessee | 47151 | 1994 | 23 |
884093 | 884093 | 2020-12-31 | Scott | Tennessee | 47151 | 1994 | 23 |
880848 | 880848 | 2020-12-30 | Scott | Tennessee | 47151 | 1967 | 22 |
877603 | 877603 | 2020-12-29 | Scott | Tennessee | 47151 | 1937 | 21 |
874358 | 874358 | 2020-12-28 | Scott | Tennessee | 47151 | 1924 | 20 |
871113 | 871113 | 2020-12-27 | Scott | Tennessee | 47151 | 1911 | 20 |
867868 | 867868 | 2020-12-26 | Scott | Tennessee | 47151 | 1898 | 20 |
864623 | 864623 | 2020-12-25 | Scott | Tennessee | 47151 | 1894 | 20 |
861378 | 861378 | 2020-12-24 | Scott | Tennessee | 47151 | 1849 | 20 |
858133 | 858133 | 2020-12-23 | Scott | Tennessee | 47151 | 1844 | 20 |
854888 | 854888 | 2020-12-22 | Scott | Tennessee | 47151 | 1812 | 19 |
851643 | 851643 | 2020-12-21 | Scott | Tennessee | 47151 | 1801 | 17 |
848398 | 848398 | 2020-12-20 | Scott | Tennessee | 47151 | 1772 | 16 |
845153 | 845153 | 2020-12-19 | Scott | Tennessee | 47151 | 1737 | 15 |
841907 | 841907 | 2020-12-18 | Scott | Tennessee | 47151 | 1685 | 14 |
838662 | 838662 | 2020-12-17 | Scott | Tennessee | 47151 | 1657 | 12 |
835416 | 835416 | 2020-12-16 | Scott | Tennessee | 47151 | 1616 | 12 |
832170 | 832170 | 2020-12-15 | Scott | Tennessee | 47151 | 1580 | 12 |
828923 | 828923 | 2020-12-14 | Scott | Tennessee | 47151 | 1552 | 12 |
825677 | 825677 | 2020-12-13 | Scott | Tennessee | 47151 | 1491 | 11 |
822430 | 822430 | 2020-12-12 | Scott | Tennessee | 47151 | 1429 | 11 |
819184 | 819184 | 2020-12-11 | Scott | Tennessee | 47151 | 1415 | 10 |
815938 | 815938 | 2020-12-10 | Scott | Tennessee | 47151 | 1376 | 9 |
812692 | 812692 | 2020-12-09 | Scott | Tennessee | 47151 | 1342 | 9 |
809448 | 809448 | 2020-12-08 | Scott | Tennessee | 47151 | 1290 | 9 |
806203 | 806203 | 2020-12-07 | Scott | Tennessee | 47151 | 1271 | 9 |
802958 | 802958 | 2020-12-06 | Scott | Tennessee | 47151 | 1228 | 8 |
799713 | 799713 | 2020-12-05 | Scott | Tennessee | 47151 | 1198 | 8 |
796468 | 796468 | 2020-12-04 | Scott | Tennessee | 47151 | 1177 | 8 |
793223 | 793223 | 2020-12-03 | Scott | Tennessee | 47151 | 1173 | 7 |
789978 | 789978 | 2020-12-02 | Scott | Tennessee | 47151 | 1171 | 7 |
786733 | 786733 | 2020-12-01 | Scott | Tennessee | 47151 | 1144 | 7 |
783489 | 783489 | 2020-11-30 | Scott | Tennessee | 47151 | 1119 | 7 |
780244 | 780244 | 2020-11-29 | Scott | Tennessee | 47151 | 1085 | 7 |
776998 | 776998 | 2020-11-28 | Scott | Tennessee | 47151 | 1072 | 7 |
773753 | 773753 | 2020-11-27 | Scott | Tennessee | 47151 | 1050 | 7 |
770508 | 770508 | 2020-11-26 | Scott | Tennessee | 47151 | 1022 | 7 |
767262 | 767262 | 2020-11-25 | Scott | Tennessee | 47151 | 996 | 7 |
764017 | 764017 | 2020-11-24 | Scott | Tennessee | 47151 | 966 | 7 |
760772 | 760772 | 2020-11-23 | Scott | Tennessee | 47151 | 958 | 7 |
757527 | 757527 | 2020-11-22 | Scott | Tennessee | 47151 | 940 | 7 |
754280 | 754280 | 2020-11-21 | Scott | Tennessee | 47151 | 911 | 7 |
751034 | 751034 | 2020-11-20 | Scott | Tennessee | 47151 | 875 | 7 |
747788 | 747788 | 2020-11-19 | Scott | Tennessee | 47151 | 843 | 6 |
744542 | 744542 | 2020-11-18 | Scott | Tennessee | 47151 | 802 | 6 |
741295 | 741295 | 2020-11-17 | Scott | Tennessee | 47151 | 781 | 6 |
738049 | 738049 | 2020-11-16 | Scott | Tennessee | 47151 | 764 | 6 |
734805 | 734805 | 2020-11-15 | Scott | Tennessee | 47151 | 721 | 6 |
731559 | 731559 | 2020-11-14 | Scott | Tennessee | 47151 | 692 | 6 |
728315 | 728315 | 2020-11-13 | Scott | Tennessee | 47151 | 675 | 6 |
725071 | 725071 | 2020-11-12 | Scott | Tennessee | 47151 | 637 | 5 |
721828 | 721828 | 2020-11-11 | Scott | Tennessee | 47151 | 605 | 5 |
718585 | 718585 | 2020-11-10 | Scott | Tennessee | 47151 | 591 | 5 |
715342 | 715342 | 2020-11-09 | Scott | Tennessee | 47151 | 574 | 5 |
712098 | 712098 | 2020-11-08 | Scott | Tennessee | 47151 | 543 | 5 |
708854 | 708854 | 2020-11-07 | Scott | Tennessee | 47151 | 515 | 5 |
705611 | 705611 | 2020-11-06 | Scott | Tennessee | 47151 | 489 | 5 |
702368 | 702368 | 2020-11-05 | Scott | Tennessee | 47151 | 483 | 5 |
699124 | 699124 | 2020-11-04 | Scott | Tennessee | 47151 | 465 | 5 |
695881 | 695881 | 2020-11-03 | Scott | Tennessee | 47151 | 449 | 5 |
692639 | 692639 | 2020-11-02 | Scott | Tennessee | 47151 | 437 | 5 |
689395 | 689395 | 2020-11-01 | Scott | Tennessee | 47151 | 423 | 5 |
686150 | 686150 | 2020-10-31 | Scott | Tennessee | 47151 | 422 | 5 |
682907 | 682907 | 2020-10-30 | Scott | Tennessee | 47151 | 416 | 5 |
679664 | 679664 | 2020-10-29 | Scott | Tennessee | 47151 | 408 | 5 |
676421 | 676421 | 2020-10-28 | Scott | Tennessee | 47151 | 400 | 5 |
673178 | 673178 | 2020-10-27 | Scott | Tennessee | 47151 | 394 | 5 |
669936 | 669936 | 2020-10-26 | Scott | Tennessee | 47151 | 386 | 5 |
666692 | 666692 | 2020-10-25 | Scott | Tennessee | 47151 | 384 | 5 |
663447 | 663447 | 2020-10-24 | Scott | Tennessee | 47151 | 374 | 5 |
660203 | 660203 | 2020-10-23 | Scott | Tennessee | 47151 | 362 | 5 |
656959 | 656959 | 2020-10-22 | Scott | Tennessee | 47151 | 351 | 4 |
653714 | 653714 | 2020-10-21 | Scott | Tennessee | 47151 | 344 | 4 |
650469 | 650469 | 2020-10-20 | Scott | Tennessee | 47151 | 332 | 4 |
647225 | 647225 | 2020-10-19 | Scott | Tennessee | 47151 | 324 | 4 |
643979 | 643979 | 2020-10-18 | Scott | Tennessee | 47151 | 314 | 4 |
640731 | 640731 | 2020-10-17 | Scott | Tennessee | 47151 | 311 | 4 |
637485 | 637485 | 2020-10-16 | Scott | Tennessee | 47151 | 300 | 3 |
634239 | 634239 | 2020-10-15 | Scott | Tennessee | 47151 | 299 | 3 |
630994 | 630994 | 2020-10-14 | Scott | Tennessee | 47151 | 294 | 3 |
627750 | 627750 | 2020-10-13 | Scott | Tennessee | 47151 | 283 | 3 |
624508 | 624508 | 2020-10-12 | Scott | Tennessee | 47151 | 280 | 3 |
621265 | 621265 | 2020-10-11 | Scott | Tennessee | 47151 | 274 | 3 |
618022 | 618022 | 2020-10-10 | Scott | Tennessee | 47151 | 271 | 3 |
614780 | 614780 | 2020-10-09 | Scott | Tennessee | 47151 | 263 | 3 |
611539 | 611539 | 2020-10-08 | Scott | Tennessee | 47151 | 264 | 3 |
608297 | 608297 | 2020-10-07 | Scott | Tennessee | 47151 | 255 | 3 |
605054 | 605054 | 2020-10-06 | Scott | Tennessee | 47151 | 249 | 3 |
601812 | 601812 | 2020-10-05 | Scott | Tennessee | 47151 | 245 | 3 |
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);