ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Brookings" 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 |
---|---|---|---|---|---|---|---|
1091671 | 1091671 | 2021-03-05 | Brookings | South Dakota | 46011 | 3609 | 37 |
1088425 | 1088425 | 2021-03-04 | Brookings | South Dakota | 46011 | 3602 | 37 |
1085180 | 1085180 | 2021-03-03 | Brookings | South Dakota | 46011 | 3599 | 37 |
1081934 | 1081934 | 2021-03-02 | Brookings | South Dakota | 46011 | 3592 | 37 |
1078688 | 1078688 | 2021-03-01 | Brookings | South Dakota | 46011 | 3588 | 37 |
1075443 | 1075443 | 2021-02-28 | Brookings | South Dakota | 46011 | 3588 | 37 |
1072197 | 1072197 | 2021-02-27 | Brookings | South Dakota | 46011 | 3581 | 37 |
1068951 | 1068951 | 2021-02-26 | Brookings | South Dakota | 46011 | 3579 | 37 |
1065706 | 1065706 | 2021-02-25 | Brookings | South Dakota | 46011 | 3575 | 37 |
1062461 | 1062461 | 2021-02-24 | Brookings | South Dakota | 46011 | 3571 | 36 |
1059216 | 1059216 | 2021-02-23 | Brookings | South Dakota | 46011 | 3566 | 36 |
1055970 | 1055970 | 2021-02-22 | Brookings | South Dakota | 46011 | 3564 | 36 |
1052724 | 1052724 | 2021-02-21 | Brookings | South Dakota | 46011 | 3564 | 36 |
1049477 | 1049477 | 2021-02-20 | Brookings | South Dakota | 46011 | 3557 | 36 |
1046230 | 1046230 | 2021-02-19 | Brookings | South Dakota | 46011 | 3552 | 36 |
1042985 | 1042985 | 2021-02-18 | Brookings | South Dakota | 46011 | 3548 | 35 |
1039740 | 1039740 | 2021-02-17 | Brookings | South Dakota | 46011 | 3542 | 35 |
1036495 | 1036495 | 2021-02-16 | Brookings | South Dakota | 46011 | 3542 | 35 |
1033250 | 1033250 | 2021-02-15 | Brookings | South Dakota | 46011 | 3535 | 35 |
1030004 | 1030004 | 2021-02-14 | Brookings | South Dakota | 46011 | 3535 | 35 |
1026757 | 1026757 | 2021-02-13 | Brookings | South Dakota | 46011 | 3531 | 35 |
1023512 | 1023512 | 2021-02-12 | Brookings | South Dakota | 46011 | 3519 | 35 |
1020267 | 1020267 | 2021-02-11 | Brookings | South Dakota | 46011 | 3509 | 35 |
1017022 | 1017022 | 2021-02-10 | Brookings | South Dakota | 46011 | 3495 | 35 |
1013777 | 1013777 | 2021-02-09 | Brookings | South Dakota | 46011 | 3483 | 35 |
1010532 | 1010532 | 2021-02-08 | Brookings | South Dakota | 46011 | 3478 | 35 |
1007286 | 1007286 | 2021-02-07 | Brookings | South Dakota | 46011 | 3475 | 35 |
1004040 | 1004040 | 2021-02-06 | Brookings | South Dakota | 46011 | 3468 | 35 |
1000794 | 1000794 | 2021-02-05 | Brookings | South Dakota | 46011 | 3459 | 35 |
997548 | 997548 | 2021-02-04 | Brookings | South Dakota | 46011 | 3450 | 34 |
994302 | 994302 | 2021-02-03 | Brookings | South Dakota | 46011 | 3440 | 34 |
991056 | 991056 | 2021-02-02 | Brookings | South Dakota | 46011 | 3430 | 34 |
987810 | 987810 | 2021-02-01 | Brookings | South Dakota | 46011 | 3423 | 34 |
984563 | 984563 | 2021-01-31 | Brookings | South Dakota | 46011 | 3422 | 34 |
981316 | 981316 | 2021-01-30 | Brookings | South Dakota | 46011 | 3414 | 34 |
978070 | 978070 | 2021-01-29 | Brookings | South Dakota | 46011 | 3412 | 34 |
974825 | 974825 | 2021-01-28 | Brookings | South Dakota | 46011 | 3404 | 34 |
971580 | 971580 | 2021-01-27 | Brookings | South Dakota | 46011 | 3389 | 33 |
968335 | 968335 | 2021-01-26 | Brookings | South Dakota | 46011 | 3375 | 33 |
965091 | 965091 | 2021-01-25 | Brookings | South Dakota | 46011 | 3369 | 33 |
961846 | 961846 | 2021-01-24 | Brookings | South Dakota | 46011 | 3366 | 33 |
958601 | 958601 | 2021-01-23 | Brookings | South Dakota | 46011 | 3363 | 32 |
955355 | 955355 | 2021-01-22 | Brookings | South Dakota | 46011 | 3353 | 32 |
952110 | 952110 | 2021-01-21 | Brookings | South Dakota | 46011 | 3341 | 32 |
948865 | 948865 | 2021-01-20 | Brookings | South Dakota | 46011 | 3329 | 32 |
945619 | 945619 | 2021-01-19 | Brookings | South Dakota | 46011 | 3309 | 32 |
942372 | 942372 | 2021-01-18 | Brookings | South Dakota | 46011 | 3306 | 32 |
939127 | 939127 | 2021-01-17 | Brookings | South Dakota | 46011 | 3299 | 32 |
935882 | 935882 | 2021-01-16 | Brookings | South Dakota | 46011 | 3283 | 32 |
932637 | 932637 | 2021-01-15 | Brookings | South Dakota | 46011 | 3268 | 32 |
929392 | 929392 | 2021-01-14 | Brookings | South Dakota | 46011 | 3254 | 32 |
926147 | 926147 | 2021-01-13 | Brookings | South Dakota | 46011 | 3237 | 31 |
922901 | 922901 | 2021-01-12 | Brookings | South Dakota | 46011 | 3214 | 31 |
919656 | 919656 | 2021-01-11 | Brookings | South Dakota | 46011 | 3201 | 31 |
916411 | 916411 | 2021-01-10 | Brookings | South Dakota | 46011 | 3188 | 31 |
913166 | 913166 | 2021-01-09 | Brookings | South Dakota | 46011 | 3173 | 31 |
909921 | 909921 | 2021-01-08 | Brookings | South Dakota | 46011 | 3156 | 31 |
906676 | 906676 | 2021-01-07 | Brookings | South Dakota | 46011 | 3131 | 31 |
903430 | 903430 | 2021-01-06 | Brookings | South Dakota | 46011 | 3092 | 30 |
900185 | 900185 | 2021-01-05 | Brookings | South Dakota | 46011 | 3068 | 30 |
896940 | 896940 | 2021-01-04 | Brookings | South Dakota | 46011 | 3044 | 30 |
893694 | 893694 | 2021-01-03 | Brookings | South Dakota | 46011 | 3035 | 30 |
890448 | 890448 | 2021-01-02 | Brookings | South Dakota | 46011 | 2999 | 30 |
887201 | 887201 | 2021-01-01 | Brookings | South Dakota | 46011 | 2981 | 30 |
883956 | 883956 | 2020-12-31 | Brookings | South Dakota | 46011 | 2981 | 30 |
880711 | 880711 | 2020-12-30 | Brookings | South Dakota | 46011 | 2956 | 29 |
877466 | 877466 | 2020-12-29 | Brookings | South Dakota | 46011 | 2926 | 29 |
874221 | 874221 | 2020-12-28 | Brookings | South Dakota | 46011 | 2908 | 29 |
870976 | 870976 | 2020-12-27 | Brookings | South Dakota | 46011 | 2901 | 29 |
867731 | 867731 | 2020-12-26 | Brookings | South Dakota | 46011 | 2881 | 29 |
864486 | 864486 | 2020-12-25 | Brookings | South Dakota | 46011 | 2875 | 29 |
861241 | 861241 | 2020-12-24 | Brookings | South Dakota | 46011 | 2875 | 29 |
857996 | 857996 | 2020-12-23 | Brookings | South Dakota | 46011 | 2858 | 28 |
854751 | 854751 | 2020-12-22 | Brookings | South Dakota | 46011 | 2848 | 28 |
851506 | 851506 | 2020-12-21 | Brookings | South Dakota | 46011 | 2827 | 28 |
848261 | 848261 | 2020-12-20 | Brookings | South Dakota | 46011 | 2815 | 24 |
845016 | 845016 | 2020-12-19 | Brookings | South Dakota | 46011 | 2804 | 24 |
841770 | 841770 | 2020-12-18 | Brookings | South Dakota | 46011 | 2793 | 24 |
838525 | 838525 | 2020-12-17 | Brookings | South Dakota | 46011 | 2784 | 24 |
835279 | 835279 | 2020-12-16 | Brookings | South Dakota | 46011 | 2769 | 24 |
832033 | 832033 | 2020-12-15 | Brookings | South Dakota | 46011 | 2735 | 24 |
828786 | 828786 | 2020-12-14 | Brookings | South Dakota | 46011 | 2730 | 24 |
825540 | 825540 | 2020-12-13 | Brookings | South Dakota | 46011 | 2721 | 24 |
822293 | 822293 | 2020-12-12 | Brookings | South Dakota | 46011 | 2701 | 24 |
819047 | 819047 | 2020-12-11 | Brookings | South Dakota | 46011 | 2685 | 23 |
815801 | 815801 | 2020-12-10 | Brookings | South Dakota | 46011 | 2659 | 23 |
812555 | 812555 | 2020-12-09 | Brookings | South Dakota | 46011 | 2642 | 21 |
809311 | 809311 | 2020-12-08 | Brookings | South Dakota | 46011 | 2620 | 20 |
806066 | 806066 | 2020-12-07 | Brookings | South Dakota | 46011 | 2614 | 20 |
802821 | 802821 | 2020-12-06 | Brookings | South Dakota | 46011 | 2594 | 20 |
799576 | 799576 | 2020-12-05 | Brookings | South Dakota | 46011 | 2570 | 18 |
796331 | 796331 | 2020-12-04 | Brookings | South Dakota | 46011 | 2546 | 18 |
793086 | 793086 | 2020-12-03 | Brookings | South Dakota | 46011 | 2515 | 18 |
789841 | 789841 | 2020-12-02 | Brookings | South Dakota | 46011 | 2483 | 16 |
786596 | 786596 | 2020-12-01 | Brookings | South Dakota | 46011 | 2461 | 16 |
783352 | 783352 | 2020-11-30 | Brookings | South Dakota | 46011 | 2448 | 16 |
780107 | 780107 | 2020-11-29 | Brookings | South Dakota | 46011 | 2429 | 16 |
776861 | 776861 | 2020-11-28 | Brookings | South Dakota | 46011 | 2404 | 16 |
773616 | 773616 | 2020-11-27 | Brookings | South Dakota | 46011 | 2382 | 16 |
770371 | 770371 | 2020-11-26 | Brookings | South Dakota | 46011 | 2311 | 16 |
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);