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 |
---|---|---|---|---|---|---|---|
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 |
767126 | 767126 | 2020-11-25 | Brown | South Dakota | 46013 | 3424 | 18 |
763881 | 763881 | 2020-11-24 | Brown | South Dakota | 46013 | 3380 | 17 |
760636 | 760636 | 2020-11-23 | Brown | South Dakota | 46013 | 3321 | 17 |
757391 | 757391 | 2020-11-22 | Brown | South Dakota | 46013 | 3260 | 17 |
754144 | 754144 | 2020-11-21 | Brown | South Dakota | 46013 | 3213 | 14 |
750898 | 750898 | 2020-11-20 | Brown | South Dakota | 46013 | 3142 | 12 |
747652 | 747652 | 2020-11-19 | Brown | South Dakota | 46013 | 3075 | 12 |
744406 | 744406 | 2020-11-18 | Brown | South Dakota | 46013 | 3027 | 10 |
741159 | 741159 | 2020-11-17 | Brown | South Dakota | 46013 | 2980 | 10 |
737913 | 737913 | 2020-11-16 | Brown | South Dakota | 46013 | 2938 | 10 |
734669 | 734669 | 2020-11-15 | Brown | South Dakota | 46013 | 2906 | 10 |
731423 | 731423 | 2020-11-14 | Brown | South Dakota | 46013 | 2847 | 9 |
728179 | 728179 | 2020-11-13 | Brown | South Dakota | 46013 | 2766 | 8 |
724935 | 724935 | 2020-11-12 | Brown | South Dakota | 46013 | 2720 | 8 |
721692 | 721692 | 2020-11-11 | Brown | South Dakota | 46013 | 2644 | 8 |
718449 | 718449 | 2020-11-10 | Brown | South Dakota | 46013 | 2613 | 8 |
715206 | 715206 | 2020-11-09 | Brown | South Dakota | 46013 | 2585 | 8 |
711962 | 711962 | 2020-11-08 | Brown | South Dakota | 46013 | 2556 | 8 |
708718 | 708718 | 2020-11-07 | Brown | South Dakota | 46013 | 2501 | 7 |
705475 | 705475 | 2020-11-06 | Brown | South Dakota | 46013 | 2444 | 6 |
702232 | 702232 | 2020-11-05 | Brown | South Dakota | 46013 | 2376 | 6 |
698988 | 698988 | 2020-11-04 | Brown | South Dakota | 46013 | 2330 | 6 |
695745 | 695745 | 2020-11-03 | Brown | South Dakota | 46013 | 2313 | 6 |
692503 | 692503 | 2020-11-02 | Brown | South Dakota | 46013 | 2274 | 6 |
689259 | 689259 | 2020-11-01 | Brown | South Dakota | 46013 | 2220 | 6 |
686014 | 686014 | 2020-10-31 | Brown | South Dakota | 46013 | 2150 | 6 |
682771 | 682771 | 2020-10-30 | Brown | South Dakota | 46013 | 2095 | 6 |
679528 | 679528 | 2020-10-29 | Brown | South Dakota | 46013 | 2033 | 5 |
676285 | 676285 | 2020-10-28 | Brown | South Dakota | 46013 | 2014 | 4 |
673042 | 673042 | 2020-10-27 | Brown | South Dakota | 46013 | 1983 | 4 |
669800 | 669800 | 2020-10-26 | Brown | South Dakota | 46013 | 1960 | 4 |
666556 | 666556 | 2020-10-25 | Brown | South Dakota | 46013 | 1941 | 4 |
663311 | 663311 | 2020-10-24 | Brown | South Dakota | 46013 | 1909 | 4 |
660067 | 660067 | 2020-10-23 | Brown | South Dakota | 46013 | 1888 | 4 |
656823 | 656823 | 2020-10-22 | Brown | South Dakota | 46013 | 1854 | 4 |
653578 | 653578 | 2020-10-21 | Brown | South Dakota | 46013 | 1823 | 4 |
650333 | 650333 | 2020-10-20 | Brown | South Dakota | 46013 | 1807 | 4 |
647089 | 647089 | 2020-10-19 | Brown | South Dakota | 46013 | 1784 | 4 |
643843 | 643843 | 2020-10-18 | Brown | South Dakota | 46013 | 1752 | 4 |
640595 | 640595 | 2020-10-17 | Brown | South Dakota | 46013 | 1732 | 4 |
637349 | 637349 | 2020-10-16 | Brown | South Dakota | 46013 | 1685 | 4 |
634103 | 634103 | 2020-10-15 | Brown | South Dakota | 46013 | 1650 | 4 |
630858 | 630858 | 2020-10-14 | Brown | South Dakota | 46013 | 1626 | 4 |
627614 | 627614 | 2020-10-13 | Brown | South Dakota | 46013 | 1593 | 4 |
624372 | 624372 | 2020-10-12 | Brown | South Dakota | 46013 | 1575 | 4 |
621129 | 621129 | 2020-10-11 | Brown | South Dakota | 46013 | 1555 | 4 |
617886 | 617886 | 2020-10-10 | Brown | South Dakota | 46013 | 1534 | 4 |
614644 | 614644 | 2020-10-09 | Brown | South Dakota | 46013 | 1488 | 4 |
611403 | 611403 | 2020-10-08 | Brown | South Dakota | 46013 | 1427 | 4 |
608161 | 608161 | 2020-10-07 | Brown | South Dakota | 46013 | 1415 | 4 |
604918 | 604918 | 2020-10-06 | Brown | South Dakota | 46013 | 1380 | 4 |
601676 | 601676 | 2020-10-05 | Brown | South Dakota | 46013 | 1363 | 4 |
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);