ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Codington" and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091680 | 1091680 | 2021-03-05 | Codington | South Dakota | 46029 | 4018 | 77 |
1088434 | 1088434 | 2021-03-04 | Codington | South Dakota | 46029 | 4012 | 77 |
1085189 | 1085189 | 2021-03-03 | Codington | South Dakota | 46029 | 4007 | 77 |
1081943 | 1081943 | 2021-03-02 | Codington | South Dakota | 46029 | 4001 | 77 |
1078697 | 1078697 | 2021-03-01 | Codington | South Dakota | 46029 | 3989 | 77 |
1075452 | 1075452 | 2021-02-28 | Codington | South Dakota | 46029 | 3986 | 77 |
1072206 | 1072206 | 2021-02-27 | Codington | South Dakota | 46029 | 3984 | 77 |
1068960 | 1068960 | 2021-02-26 | Codington | South Dakota | 46029 | 3974 | 77 |
1065715 | 1065715 | 2021-02-25 | Codington | South Dakota | 46029 | 3970 | 77 |
1062470 | 1062470 | 2021-02-24 | Codington | South Dakota | 46029 | 3965 | 77 |
1059225 | 1059225 | 2021-02-23 | Codington | South Dakota | 46029 | 3948 | 77 |
1055979 | 1055979 | 2021-02-22 | Codington | South Dakota | 46029 | 3927 | 77 |
1052733 | 1052733 | 2021-02-21 | Codington | South Dakota | 46029 | 3927 | 77 |
1049486 | 1049486 | 2021-02-20 | Codington | South Dakota | 46029 | 3923 | 76 |
1046239 | 1046239 | 2021-02-19 | Codington | South Dakota | 46029 | 3918 | 76 |
1042994 | 1042994 | 2021-02-18 | Codington | South Dakota | 46029 | 3912 | 76 |
1039749 | 1039749 | 2021-02-17 | Codington | South Dakota | 46029 | 3897 | 76 |
1036504 | 1036504 | 2021-02-16 | Codington | South Dakota | 46029 | 3889 | 76 |
1033259 | 1033259 | 2021-02-15 | Codington | South Dakota | 46029 | 3878 | 76 |
1030013 | 1030013 | 2021-02-14 | Codington | South Dakota | 46029 | 3872 | 76 |
1026766 | 1026766 | 2021-02-13 | Codington | South Dakota | 46029 | 3863 | 76 |
1023521 | 1023521 | 2021-02-12 | Codington | South Dakota | 46029 | 3856 | 76 |
1020276 | 1020276 | 2021-02-11 | Codington | South Dakota | 46029 | 3839 | 76 |
1017031 | 1017031 | 2021-02-10 | Codington | South Dakota | 46029 | 3825 | 76 |
1013786 | 1013786 | 2021-02-09 | Codington | South Dakota | 46029 | 3806 | 75 |
1010541 | 1010541 | 2021-02-08 | Codington | South Dakota | 46029 | 3795 | 75 |
1007295 | 1007295 | 2021-02-07 | Codington | South Dakota | 46029 | 3788 | 75 |
1004049 | 1004049 | 2021-02-06 | Codington | South Dakota | 46029 | 3784 | 75 |
1000803 | 1000803 | 2021-02-05 | Codington | South Dakota | 46029 | 3773 | 74 |
997557 | 997557 | 2021-02-04 | Codington | South Dakota | 46029 | 3769 | 74 |
994311 | 994311 | 2021-02-03 | Codington | South Dakota | 46029 | 3766 | 74 |
991065 | 991065 | 2021-02-02 | Codington | South Dakota | 46029 | 3755 | 74 |
987819 | 987819 | 2021-02-01 | Codington | South Dakota | 46029 | 3754 | 74 |
984572 | 984572 | 2021-01-31 | Codington | South Dakota | 46029 | 3750 | 74 |
981325 | 981325 | 2021-01-30 | Codington | South Dakota | 46029 | 3734 | 74 |
978079 | 978079 | 2021-01-29 | Codington | South Dakota | 46029 | 3730 | 74 |
974834 | 974834 | 2021-01-28 | Codington | South Dakota | 46029 | 3726 | 74 |
971589 | 971589 | 2021-01-27 | Codington | South Dakota | 46029 | 3720 | 74 |
968344 | 968344 | 2021-01-26 | Codington | South Dakota | 46029 | 3717 | 73 |
965100 | 965100 | 2021-01-25 | Codington | South Dakota | 46029 | 3713 | 73 |
961855 | 961855 | 2021-01-24 | Codington | South Dakota | 46029 | 3711 | 73 |
958610 | 958610 | 2021-01-23 | Codington | South Dakota | 46029 | 3710 | 73 |
955364 | 955364 | 2021-01-22 | Codington | South Dakota | 46029 | 3705 | 73 |
952119 | 952119 | 2021-01-21 | Codington | South Dakota | 46029 | 3701 | 73 |
948874 | 948874 | 2021-01-20 | Codington | South Dakota | 46029 | 3686 | 73 |
945628 | 945628 | 2021-01-19 | Codington | South Dakota | 46029 | 3682 | 73 |
942381 | 942381 | 2021-01-18 | Codington | South Dakota | 46029 | 3673 | 73 |
939136 | 939136 | 2021-01-17 | Codington | South Dakota | 46029 | 3661 | 73 |
935891 | 935891 | 2021-01-16 | Codington | South Dakota | 46029 | 3661 | 73 |
932646 | 932646 | 2021-01-15 | Codington | South Dakota | 46029 | 3652 | 73 |
929401 | 929401 | 2021-01-14 | Codington | South Dakota | 46029 | 3641 | 73 |
926156 | 926156 | 2021-01-13 | Codington | South Dakota | 46029 | 3632 | 73 |
922910 | 922910 | 2021-01-12 | Codington | South Dakota | 46029 | 3614 | 72 |
919665 | 919665 | 2021-01-11 | Codington | South Dakota | 46029 | 3607 | 72 |
916420 | 916420 | 2021-01-10 | Codington | South Dakota | 46029 | 3596 | 72 |
913175 | 913175 | 2021-01-09 | Codington | South Dakota | 46029 | 3583 | 71 |
909930 | 909930 | 2021-01-08 | Codington | South Dakota | 46029 | 3574 | 71 |
906685 | 906685 | 2021-01-07 | Codington | South Dakota | 46029 | 3566 | 71 |
903439 | 903439 | 2021-01-06 | Codington | South Dakota | 46029 | 3543 | 71 |
900194 | 900194 | 2021-01-05 | Codington | South Dakota | 46029 | 3508 | 70 |
896949 | 896949 | 2021-01-04 | Codington | South Dakota | 46029 | 3494 | 70 |
893703 | 893703 | 2021-01-03 | Codington | South Dakota | 46029 | 3491 | 70 |
890457 | 890457 | 2021-01-02 | Codington | South Dakota | 46029 | 3472 | 70 |
887210 | 887210 | 2021-01-01 | Codington | South Dakota | 46029 | 3452 | 70 |
883965 | 883965 | 2020-12-31 | Codington | South Dakota | 46029 | 3452 | 70 |
880720 | 880720 | 2020-12-30 | Codington | South Dakota | 46029 | 3421 | 68 |
877475 | 877475 | 2020-12-29 | Codington | South Dakota | 46029 | 3414 | 68 |
874230 | 874230 | 2020-12-28 | Codington | South Dakota | 46029 | 3392 | 68 |
870985 | 870985 | 2020-12-27 | Codington | South Dakota | 46029 | 3377 | 68 |
867740 | 867740 | 2020-12-26 | Codington | South Dakota | 46029 | 3365 | 68 |
864495 | 864495 | 2020-12-25 | Codington | South Dakota | 46029 | 3345 | 68 |
861250 | 861250 | 2020-12-24 | Codington | South Dakota | 46029 | 3345 | 68 |
858005 | 858005 | 2020-12-23 | Codington | South Dakota | 46029 | 3332 | 68 |
854760 | 854760 | 2020-12-22 | Codington | South Dakota | 46029 | 3311 | 68 |
851515 | 851515 | 2020-12-21 | Codington | South Dakota | 46029 | 3285 | 68 |
848270 | 848270 | 2020-12-20 | Codington | South Dakota | 46029 | 3278 | 66 |
845025 | 845025 | 2020-12-19 | Codington | South Dakota | 46029 | 3262 | 66 |
841779 | 841779 | 2020-12-18 | Codington | South Dakota | 46029 | 3237 | 64 |
838534 | 838534 | 2020-12-17 | Codington | South Dakota | 46029 | 3228 | 64 |
835288 | 835288 | 2020-12-16 | Codington | South Dakota | 46029 | 3204 | 64 |
832042 | 832042 | 2020-12-15 | Codington | South Dakota | 46029 | 3168 | 59 |
828795 | 828795 | 2020-12-14 | Codington | South Dakota | 46029 | 3139 | 59 |
825549 | 825549 | 2020-12-13 | Codington | South Dakota | 46029 | 3130 | 59 |
822302 | 822302 | 2020-12-12 | Codington | South Dakota | 46029 | 3096 | 59 |
819056 | 819056 | 2020-12-11 | Codington | South Dakota | 46029 | 3071 | 58 |
815810 | 815810 | 2020-12-10 | Codington | South Dakota | 46029 | 3031 | 57 |
812564 | 812564 | 2020-12-09 | Codington | South Dakota | 46029 | 2988 | 57 |
809320 | 809320 | 2020-12-08 | Codington | South Dakota | 46029 | 2936 | 57 |
806075 | 806075 | 2020-12-07 | Codington | South Dakota | 46029 | 2911 | 57 |
802830 | 802830 | 2020-12-06 | Codington | South Dakota | 46029 | 2888 | 57 |
799585 | 799585 | 2020-12-05 | Codington | South Dakota | 46029 | 2872 | 57 |
796340 | 796340 | 2020-12-04 | Codington | South Dakota | 46029 | 2827 | 55 |
793095 | 793095 | 2020-12-03 | Codington | South Dakota | 46029 | 2779 | 53 |
789850 | 789850 | 2020-12-02 | Codington | South Dakota | 46029 | 2745 | 51 |
786605 | 786605 | 2020-12-01 | Codington | South Dakota | 46029 | 2700 | 50 |
783361 | 783361 | 2020-11-30 | Codington | South Dakota | 46029 | 2686 | 50 |
780116 | 780116 | 2020-11-29 | Codington | South Dakota | 46029 | 2645 | 50 |
776870 | 776870 | 2020-11-28 | Codington | South Dakota | 46029 | 2626 | 50 |
773625 | 773625 | 2020-11-27 | Codington | South Dakota | 46029 | 2611 | 46 |
770380 | 770380 | 2020-11-26 | Codington | South Dakota | 46029 | 2548 | 42 |
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);