ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Davison" 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 |
---|---|---|---|---|---|---|---|
1091683 | 1091683 | 2021-03-05 | Davison | South Dakota | 46035 | 2961 | 64 |
1088437 | 1088437 | 2021-03-04 | Davison | South Dakota | 46035 | 2959 | 64 |
1085192 | 1085192 | 2021-03-03 | Davison | South Dakota | 46035 | 2957 | 63 |
1081946 | 1081946 | 2021-03-02 | Davison | South Dakota | 46035 | 2955 | 62 |
1078700 | 1078700 | 2021-03-01 | Davison | South Dakota | 46035 | 2955 | 62 |
1075455 | 1075455 | 2021-02-28 | Davison | South Dakota | 46035 | 2952 | 62 |
1072209 | 1072209 | 2021-02-27 | Davison | South Dakota | 46035 | 2947 | 62 |
1068963 | 1068963 | 2021-02-26 | Davison | South Dakota | 46035 | 2945 | 62 |
1065718 | 1065718 | 2021-02-25 | Davison | South Dakota | 46035 | 2945 | 61 |
1062473 | 1062473 | 2021-02-24 | Davison | South Dakota | 46035 | 2941 | 61 |
1059228 | 1059228 | 2021-02-23 | Davison | South Dakota | 46035 | 2940 | 61 |
1055982 | 1055982 | 2021-02-22 | Davison | South Dakota | 46035 | 2940 | 61 |
1052736 | 1052736 | 2021-02-21 | Davison | South Dakota | 46035 | 2938 | 61 |
1049489 | 1049489 | 2021-02-20 | Davison | South Dakota | 46035 | 2936 | 61 |
1046242 | 1046242 | 2021-02-19 | Davison | South Dakota | 46035 | 2934 | 61 |
1042997 | 1042997 | 2021-02-18 | Davison | South Dakota | 46035 | 2932 | 61 |
1039752 | 1039752 | 2021-02-17 | Davison | South Dakota | 46035 | 2927 | 61 |
1036507 | 1036507 | 2021-02-16 | Davison | South Dakota | 46035 | 2926 | 61 |
1033262 | 1033262 | 2021-02-15 | Davison | South Dakota | 46035 | 2924 | 61 |
1030016 | 1030016 | 2021-02-14 | Davison | South Dakota | 46035 | 2924 | 61 |
1026769 | 1026769 | 2021-02-13 | Davison | South Dakota | 46035 | 2924 | 60 |
1023524 | 1023524 | 2021-02-12 | Davison | South Dakota | 46035 | 2924 | 60 |
1020279 | 1020279 | 2021-02-11 | Davison | South Dakota | 46035 | 2919 | 60 |
1017034 | 1017034 | 2021-02-10 | Davison | South Dakota | 46035 | 2914 | 60 |
1013789 | 1013789 | 2021-02-09 | Davison | South Dakota | 46035 | 2912 | 60 |
1010544 | 1010544 | 2021-02-08 | Davison | South Dakota | 46035 | 2913 | 60 |
1007298 | 1007298 | 2021-02-07 | Davison | South Dakota | 46035 | 2910 | 60 |
1004052 | 1004052 | 2021-02-06 | Davison | South Dakota | 46035 | 2910 | 60 |
1000806 | 1000806 | 2021-02-05 | Davison | South Dakota | 46035 | 2909 | 60 |
997560 | 997560 | 2021-02-04 | Davison | South Dakota | 46035 | 2908 | 60 |
994314 | 994314 | 2021-02-03 | Davison | South Dakota | 46035 | 2905 | 60 |
991068 | 991068 | 2021-02-02 | Davison | South Dakota | 46035 | 2902 | 60 |
987822 | 987822 | 2021-02-01 | Davison | South Dakota | 46035 | 2902 | 60 |
984575 | 984575 | 2021-01-31 | Davison | South Dakota | 46035 | 2899 | 60 |
981328 | 981328 | 2021-01-30 | Davison | South Dakota | 46035 | 2896 | 60 |
978082 | 978082 | 2021-01-29 | Davison | South Dakota | 46035 | 2892 | 60 |
974837 | 974837 | 2021-01-28 | Davison | South Dakota | 46035 | 2888 | 60 |
971592 | 971592 | 2021-01-27 | Davison | South Dakota | 46035 | 2884 | 59 |
968347 | 968347 | 2021-01-26 | Davison | South Dakota | 46035 | 2881 | 57 |
965103 | 965103 | 2021-01-25 | Davison | South Dakota | 46035 | 2879 | 57 |
961858 | 961858 | 2021-01-24 | Davison | South Dakota | 46035 | 2879 | 57 |
958613 | 958613 | 2021-01-23 | Davison | South Dakota | 46035 | 2875 | 57 |
955367 | 955367 | 2021-01-22 | Davison | South Dakota | 46035 | 2868 | 57 |
952122 | 952122 | 2021-01-21 | Davison | South Dakota | 46035 | 2860 | 56 |
948877 | 948877 | 2021-01-20 | Davison | South Dakota | 46035 | 2858 | 56 |
945631 | 945631 | 2021-01-19 | Davison | South Dakota | 46035 | 2854 | 56 |
942384 | 942384 | 2021-01-18 | Davison | South Dakota | 46035 | 2848 | 56 |
939139 | 939139 | 2021-01-17 | Davison | South Dakota | 46035 | 2847 | 56 |
935894 | 935894 | 2021-01-16 | Davison | South Dakota | 46035 | 2846 | 55 |
932649 | 932649 | 2021-01-15 | Davison | South Dakota | 46035 | 2844 | 55 |
929404 | 929404 | 2021-01-14 | Davison | South Dakota | 46035 | 2834 | 54 |
926159 | 926159 | 2021-01-13 | Davison | South Dakota | 46035 | 2832 | 54 |
922913 | 922913 | 2021-01-12 | Davison | South Dakota | 46035 | 2808 | 54 |
919668 | 919668 | 2021-01-11 | Davison | South Dakota | 46035 | 2802 | 54 |
916423 | 916423 | 2021-01-10 | Davison | South Dakota | 46035 | 2798 | 54 |
913178 | 913178 | 2021-01-09 | Davison | South Dakota | 46035 | 2786 | 54 |
909933 | 909933 | 2021-01-08 | Davison | South Dakota | 46035 | 2776 | 54 |
906688 | 906688 | 2021-01-07 | Davison | South Dakota | 46035 | 2762 | 54 |
903442 | 903442 | 2021-01-06 | Davison | South Dakota | 46035 | 2753 | 54 |
900197 | 900197 | 2021-01-05 | Davison | South Dakota | 46035 | 2745 | 54 |
896952 | 896952 | 2021-01-04 | Davison | South Dakota | 46035 | 2737 | 54 |
893706 | 893706 | 2021-01-03 | Davison | South Dakota | 46035 | 2736 | 54 |
890460 | 890460 | 2021-01-02 | Davison | South Dakota | 46035 | 2726 | 54 |
887213 | 887213 | 2021-01-01 | Davison | South Dakota | 46035 | 2718 | 54 |
883968 | 883968 | 2020-12-31 | Davison | South Dakota | 46035 | 2718 | 54 |
880723 | 880723 | 2020-12-30 | Davison | South Dakota | 46035 | 2707 | 53 |
877478 | 877478 | 2020-12-29 | Davison | South Dakota | 46035 | 2701 | 53 |
874233 | 874233 | 2020-12-28 | Davison | South Dakota | 46035 | 2686 | 53 |
870988 | 870988 | 2020-12-27 | Davison | South Dakota | 46035 | 2683 | 53 |
867743 | 867743 | 2020-12-26 | Davison | South Dakota | 46035 | 2678 | 53 |
864498 | 864498 | 2020-12-25 | Davison | South Dakota | 46035 | 2671 | 53 |
861253 | 861253 | 2020-12-24 | Davison | South Dakota | 46035 | 2671 | 53 |
858008 | 858008 | 2020-12-23 | Davison | South Dakota | 46035 | 2658 | 53 |
854763 | 854763 | 2020-12-22 | Davison | South Dakota | 46035 | 2652 | 53 |
851518 | 851518 | 2020-12-21 | Davison | South Dakota | 46035 | 2648 | 53 |
848273 | 848273 | 2020-12-20 | Davison | South Dakota | 46035 | 2647 | 53 |
845028 | 845028 | 2020-12-19 | Davison | South Dakota | 46035 | 2631 | 53 |
841782 | 841782 | 2020-12-18 | Davison | South Dakota | 46035 | 2623 | 53 |
838537 | 838537 | 2020-12-17 | Davison | South Dakota | 46035 | 2617 | 52 |
835291 | 835291 | 2020-12-16 | Davison | South Dakota | 46035 | 2601 | 52 |
832045 | 832045 | 2020-12-15 | Davison | South Dakota | 46035 | 2589 | 52 |
828798 | 828798 | 2020-12-14 | Davison | South Dakota | 46035 | 2583 | 52 |
825552 | 825552 | 2020-12-13 | Davison | South Dakota | 46035 | 2578 | 52 |
822305 | 822305 | 2020-12-12 | Davison | South Dakota | 46035 | 2564 | 51 |
819059 | 819059 | 2020-12-11 | Davison | South Dakota | 46035 | 2550 | 50 |
815813 | 815813 | 2020-12-10 | Davison | South Dakota | 46035 | 2538 | 49 |
812567 | 812567 | 2020-12-09 | Davison | South Dakota | 46035 | 2530 | 48 |
809323 | 809323 | 2020-12-08 | Davison | South Dakota | 46035 | 2520 | 43 |
806078 | 806078 | 2020-12-07 | Davison | South Dakota | 46035 | 2513 | 43 |
802833 | 802833 | 2020-12-06 | Davison | South Dakota | 46035 | 2505 | 43 |
799588 | 799588 | 2020-12-05 | Davison | South Dakota | 46035 | 2493 | 41 |
796343 | 796343 | 2020-12-04 | Davison | South Dakota | 46035 | 2468 | 41 |
793098 | 793098 | 2020-12-03 | Davison | South Dakota | 46035 | 2448 | 41 |
789853 | 789853 | 2020-12-02 | Davison | South Dakota | 46035 | 2435 | 41 |
786608 | 786608 | 2020-12-01 | Davison | South Dakota | 46035 | 2409 | 37 |
783364 | 783364 | 2020-11-30 | Davison | South Dakota | 46035 | 2405 | 37 |
780119 | 780119 | 2020-11-29 | Davison | South Dakota | 46035 | 2385 | 37 |
776873 | 776873 | 2020-11-28 | Davison | South Dakota | 46035 | 2375 | 37 |
773628 | 773628 | 2020-11-27 | Davison | South Dakota | 46035 | 2354 | 33 |
770383 | 770383 | 2020-11-26 | Davison | South Dakota | 46035 | 2292 | 31 |
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);