ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Brown" 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 |
---|---|---|---|---|---|---|---|
1091672 | 1091672 | 2021-03-05 | Brown | South Dakota | 46013 | 5161 | 89 |
1088426 | 1088426 | 2021-03-04 | Brown | South Dakota | 46013 | 5157 | 89 |
1085181 | 1085181 | 2021-03-03 | Brown | South Dakota | 46013 | 5147 | 89 |
1081935 | 1081935 | 2021-03-02 | Brown | South Dakota | 46013 | 5142 | 88 |
1078689 | 1078689 | 2021-03-01 | Brown | South Dakota | 46013 | 5132 | 88 |
1075444 | 1075444 | 2021-02-28 | Brown | South Dakota | 46013 | 5129 | 88 |
1072198 | 1072198 | 2021-02-27 | Brown | South Dakota | 46013 | 5126 | 88 |
1068952 | 1068952 | 2021-02-26 | Brown | South Dakota | 46013 | 5117 | 88 |
1065707 | 1065707 | 2021-02-25 | Brown | South Dakota | 46013 | 5110 | 88 |
1062462 | 1062462 | 2021-02-24 | Brown | South Dakota | 46013 | 5107 | 85 |
1059217 | 1059217 | 2021-02-23 | Brown | South Dakota | 46013 | 5095 | 85 |
1055971 | 1055971 | 2021-02-22 | Brown | South Dakota | 46013 | 5090 | 85 |
1052725 | 1052725 | 2021-02-21 | Brown | South Dakota | 46013 | 5085 | 85 |
1049478 | 1049478 | 2021-02-20 | Brown | South Dakota | 46013 | 5084 | 85 |
1046231 | 1046231 | 2021-02-19 | Brown | South Dakota | 46013 | 5080 | 84 |
1042986 | 1042986 | 2021-02-18 | Brown | South Dakota | 46013 | 5076 | 84 |
1039741 | 1039741 | 2021-02-17 | Brown | South Dakota | 46013 | 5071 | 83 |
1036496 | 1036496 | 2021-02-16 | Brown | South Dakota | 46013 | 5070 | 83 |
1033251 | 1033251 | 2021-02-15 | Brown | South Dakota | 46013 | 5066 | 83 |
1030005 | 1030005 | 2021-02-14 | Brown | South Dakota | 46013 | 5062 | 83 |
1026758 | 1026758 | 2021-02-13 | Brown | South Dakota | 46013 | 5055 | 81 |
1023513 | 1023513 | 2021-02-12 | Brown | South Dakota | 46013 | 5052 | 80 |
1020268 | 1020268 | 2021-02-11 | Brown | South Dakota | 46013 | 5038 | 80 |
1017023 | 1017023 | 2021-02-10 | Brown | South Dakota | 46013 | 5027 | 79 |
1013778 | 1013778 | 2021-02-09 | Brown | South Dakota | 46013 | 5018 | 79 |
1010533 | 1010533 | 2021-02-08 | Brown | South Dakota | 46013 | 5017 | 79 |
1007287 | 1007287 | 2021-02-07 | Brown | South Dakota | 46013 | 5016 | 79 |
1004041 | 1004041 | 2021-02-06 | Brown | South Dakota | 46013 | 5008 | 79 |
1000795 | 1000795 | 2021-02-05 | Brown | South Dakota | 46013 | 4992 | 79 |
997549 | 997549 | 2021-02-04 | Brown | South Dakota | 46013 | 4986 | 80 |
994303 | 994303 | 2021-02-03 | Brown | South Dakota | 46013 | 4966 | 80 |
991057 | 991057 | 2021-02-02 | Brown | South Dakota | 46013 | 4952 | 80 |
987811 | 987811 | 2021-02-01 | Brown | South Dakota | 46013 | 4940 | 80 |
984564 | 984564 | 2021-01-31 | Brown | South Dakota | 46013 | 4937 | 80 |
981317 | 981317 | 2021-01-30 | Brown | South Dakota | 46013 | 4925 | 79 |
978071 | 978071 | 2021-01-29 | Brown | South Dakota | 46013 | 4915 | 79 |
974826 | 974826 | 2021-01-28 | Brown | South Dakota | 46013 | 4899 | 79 |
971581 | 971581 | 2021-01-27 | Brown | South Dakota | 46013 | 4879 | 77 |
968336 | 968336 | 2021-01-26 | Brown | South Dakota | 46013 | 4860 | 75 |
965092 | 965092 | 2021-01-25 | Brown | South Dakota | 46013 | 4846 | 75 |
961847 | 961847 | 2021-01-24 | Brown | South Dakota | 46013 | 4844 | 75 |
958602 | 958602 | 2021-01-23 | Brown | South Dakota | 46013 | 4832 | 75 |
955356 | 955356 | 2021-01-22 | Brown | South Dakota | 46013 | 4825 | 75 |
952111 | 952111 | 2021-01-21 | Brown | South Dakota | 46013 | 4811 | 75 |
948866 | 948866 | 2021-01-20 | Brown | South Dakota | 46013 | 4797 | 75 |
945620 | 945620 | 2021-01-19 | Brown | South Dakota | 46013 | 4785 | 75 |
942373 | 942373 | 2021-01-18 | Brown | South Dakota | 46013 | 4773 | 75 |
939128 | 939128 | 2021-01-17 | Brown | South Dakota | 46013 | 4769 | 75 |
935883 | 935883 | 2021-01-16 | Brown | South Dakota | 46013 | 4755 | 72 |
932638 | 932638 | 2021-01-15 | Brown | South Dakota | 46013 | 4741 | 72 |
929393 | 929393 | 2021-01-14 | Brown | South Dakota | 46013 | 4723 | 70 |
926148 | 926148 | 2021-01-13 | Brown | South Dakota | 46013 | 4705 | 68 |
922902 | 922902 | 2021-01-12 | Brown | South Dakota | 46013 | 4682 | 68 |
919657 | 919657 | 2021-01-11 | Brown | South Dakota | 46013 | 4666 | 68 |
916412 | 916412 | 2021-01-10 | Brown | South Dakota | 46013 | 4657 | 68 |
913167 | 913167 | 2021-01-09 | Brown | South Dakota | 46013 | 4629 | 66 |
909922 | 909922 | 2021-01-08 | Brown | South Dakota | 46013 | 4613 | 66 |
906677 | 906677 | 2021-01-07 | Brown | South Dakota | 46013 | 4593 | 65 |
903431 | 903431 | 2021-01-06 | Brown | South Dakota | 46013 | 4570 | 63 |
900186 | 900186 | 2021-01-05 | Brown | South Dakota | 46013 | 4534 | 63 |
896941 | 896941 | 2021-01-04 | Brown | South Dakota | 46013 | 4505 | 63 |
893695 | 893695 | 2021-01-03 | Brown | South Dakota | 46013 | 4498 | 63 |
890449 | 890449 | 2021-01-02 | Brown | South Dakota | 46013 | 4458 | 61 |
887202 | 887202 | 2021-01-01 | Brown | South Dakota | 46013 | 4426 | 60 |
883957 | 883957 | 2020-12-31 | Brown | South Dakota | 46013 | 4426 | 60 |
880712 | 880712 | 2020-12-30 | Brown | South Dakota | 46013 | 4399 | 57 |
877467 | 877467 | 2020-12-29 | Brown | South Dakota | 46013 | 4374 | 57 |
874222 | 874222 | 2020-12-28 | Brown | South Dakota | 46013 | 4341 | 57 |
870977 | 870977 | 2020-12-27 | Brown | South Dakota | 46013 | 4317 | 57 |
867732 | 867732 | 2020-12-26 | Brown | South Dakota | 46013 | 4298 | 57 |
864487 | 864487 | 2020-12-25 | Brown | South Dakota | 46013 | 4287 | 54 |
861242 | 861242 | 2020-12-24 | Brown | South Dakota | 46013 | 4287 | 54 |
857997 | 857997 | 2020-12-23 | Brown | South Dakota | 46013 | 4263 | 54 |
854752 | 854752 | 2020-12-22 | Brown | South Dakota | 46013 | 4245 | 53 |
851507 | 851507 | 2020-12-21 | Brown | South Dakota | 46013 | 4224 | 53 |
848262 | 848262 | 2020-12-20 | Brown | South Dakota | 46013 | 4209 | 51 |
845017 | 845017 | 2020-12-19 | Brown | South Dakota | 46013 | 4195 | 50 |
841771 | 841771 | 2020-12-18 | Brown | South Dakota | 46013 | 4178 | 49 |
838526 | 838526 | 2020-12-17 | Brown | South Dakota | 46013 | 4159 | 47 |
835280 | 835280 | 2020-12-16 | Brown | South Dakota | 46013 | 4120 | 47 |
832034 | 832034 | 2020-12-15 | Brown | South Dakota | 46013 | 4092 | 44 |
828787 | 828787 | 2020-12-14 | Brown | South Dakota | 46013 | 4079 | 44 |
825541 | 825541 | 2020-12-13 | Brown | South Dakota | 46013 | 4067 | 44 |
822294 | 822294 | 2020-12-12 | Brown | South Dakota | 46013 | 4055 | 44 |
819048 | 819048 | 2020-12-11 | Brown | South Dakota | 46013 | 4021 | 35 |
815802 | 815802 | 2020-12-10 | Brown | South Dakota | 46013 | 3993 | 34 |
812556 | 812556 | 2020-12-09 | Brown | South Dakota | 46013 | 3962 | 32 |
809312 | 809312 | 2020-12-08 | Brown | South Dakota | 46013 | 3915 | 30 |
806067 | 806067 | 2020-12-07 | Brown | South Dakota | 46013 | 3893 | 30 |
802822 | 802822 | 2020-12-06 | Brown | South Dakota | 46013 | 3862 | 30 |
799577 | 799577 | 2020-12-05 | Brown | South Dakota | 46013 | 3828 | 30 |
796332 | 796332 | 2020-12-04 | Brown | South Dakota | 46013 | 3792 | 29 |
793087 | 793087 | 2020-12-03 | Brown | South Dakota | 46013 | 3748 | 26 |
789842 | 789842 | 2020-12-02 | Brown | South Dakota | 46013 | 3729 | 24 |
786597 | 786597 | 2020-12-01 | Brown | South Dakota | 46013 | 3657 | 21 |
783353 | 783353 | 2020-11-30 | Brown | South Dakota | 46013 | 3641 | 21 |
780108 | 780108 | 2020-11-29 | Brown | South Dakota | 46013 | 3609 | 21 |
776862 | 776862 | 2020-11-28 | Brown | South Dakota | 46013 | 3588 | 21 |
773617 | 773617 | 2020-11-27 | Brown | South Dakota | 46013 | 3544 | 20 |
770372 | 770372 | 2020-11-26 | Brown | South Dakota | 46013 | 3424 | 18 |
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);