ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 46035 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 468 ✖
- 2 23
- 3 19
- 3252 14
- 9 12
- 6 9
- 3245 9
- 7 7
- 3247 7
- 3253 7
- 3258 7
- 3260 7
- 3267 7
- 5867 7
- 5874 7
- 5880 7
- 5887 7
- 5890 7
- 5893 7
- 5897 7
- 3239 6
- 3246 6
- 33 5
- 35 5
- 4006 5
- 5813 5
- 5861 5
- 5 4
- 30 4
- 2924 4
- 3227 4
- 3232 4
- 3392 4
- 3646 4
- 4437 4
- 4533 4
- 5048 4
- 5845 4
- 16 3
- 57 3
- 81 3
- 94 3
- 101 3
- 3124 3
- 3219 3
- 3242 3
- 3250 3
- 3281 3
- 3296 3
- 3329 3
- 3454 3
- 3520 3
- 3566 3
- 3611 3
- 3673 3
- 3704 3
- 3742 3
- 3786 3
- 3847 3
- 3947 3
- 4098 3
- 4217 3
- 4338 3
- 4750 3
- 5397 3
- 5616 3
- 5732 3
- 5796 3
- 5834 3
- 5846 3
- 5849 3
- 5907 3
- 8 2
- 20 2
- 27 2
- 32 2
- 41 2
- 44 2
- 47 2
- 88 2
- 93 2
- 96 2
- 97 2
- 99 2
- 100 2
- 104 2
- 108 2
- 165 2
- 171 2
- 2292 2
- 2671 2
- 2718 2
- 2879 2
- 2902 2
- 2910 2
- 2940 2
- 2945 2
- 2955 2
- 3000 2
- 3091 2
- 3154 2
- 3176 2
- 3204 2
- 3206 2
- 3226 2
- 3238 2
- 3248 2
- 3251 2
- 3829 2
- 5858 2
- 4 1
- 10 1
- 11 1
- 13 1
- 14 1
- 15 1
- 24 1
- 31 1
- 34 1
- 36 1
- 37 1
- 39 1
- 40 1
- 43 1
- 46 1
- 50 1
- 51 1
- 52 1
- 54 1
- 55 1
- 56 1
- 65 1
- 66 1
- 67 1
- 69 1
- 71 1
- 73 1
- 75 1
- 76 1
- 78 1
- 83 1
- 84 1
- 86 1
- 87 1
- 106 1
- 112 1
- 113 1
- 121 1
- 126 1
- 133 1
- 135 1
- 136 1
- 142 1
- 143 1
- 146 1
- 148 1
- 152 1
- 155 1
- 158 1
- 162 1
- 164 1
- 169 1
- 176 1
- 181 1
- 186 1
- 197 1
- 200 1
- 204 1
- 210 1
- 225 1
- 230 1
- 249 1
- 258 1
- 283 1
- 295 1
- 305 1
- 320 1
- 329 1
- 359 1
- 380 1
- 396 1
- 412 1
- 423 1
- 434 1
- 460 1
- 474 1
- 505 1
- 530 1
- 561 1
- 575 1
- 585 1
- 615 1
- 635 1
- 654 1
- 689 1
- 704 1
- 732 1
- 740 1
- 753 1
- 770 1
- 812 1
- 824 1
- 847 1
- 863 1
- 873 1
- 915 1
- 957 1
- 999 1
- 1047 1
- 1099 1
- 1143 1
- 1189 1
- 1202 1
- 1238 1
- 1334 1
- 1390 1
- 1467 1
- 1503 1
- 1542 1
- 1599 1
- 1662 1
- 1717 1
- 1803 1
- 1870 1
- 1912 1
- 1983 1
- 2045 1
- 2076 1
- 2156 1
- 2197 1
- 2214 1
- 2247 1
- 2274 1
- 2354 1
- 2375 1
- 2385 1
- 2405 1
- 2409 1
- 2435 1
- 2448 1
- 2468 1
- 2493 1
- 2505 1
- 2513 1
- 2520 1
- 2530 1
- 2538 1
- 2550 1
- 2564 1
- 2578 1
- 2583 1
- 2589 1
- 2601 1
- 2617 1
- 2623 1
- 2631 1
- 2647 1
- 2648 1
- 2652 1
- 2658 1
- 2678 1
- 2683 1
- 2686 1
- 2701 1
- 2707 1
- 2726 1
- 2736 1
- 2737 1
- 2745 1
- 2753 1
- 2762 1
- 2776 1
- 2786 1
- 2798 1
- 2802 1
- 2808 1
- 2832 1
- 2834 1
- 2844 1
- 2846 1
- 2847 1
- 2848 1
- 2854 1
- 2858 1
- 2860 1
- 2868 1
- 2875 1
- 2881 1
- 2884 1
- 2888 1
- 2892 1
- 2896 1
- 2899 1
- 2905 1
- 2908 1
- 2909 1
- 2912 1
- 2913 1
- 2914 1
- 2919 1
- 2926 1
- 2927 1
- 2932 1
- 2934 1
- 2936 1
- 2938 1
- 2941 1
- 2947 1
- 2952 1
- 2957 1
- 2959 1
- 2961 1
- 2967 1
- 2971 1
- 2972 1
- 2973 1
- 2982 1
- 2988 1
- 2992 1
- 2999 1
- 3007 1
- 3011 1
- 3013 1
- 3019 1
- 3029 1
- 3034 1
- 3035 1
- 3038 1
- 3047 1
- 3059 1
- 3071 1
- 3085 1
- 3097 1
- 3115 1
- 3122 1
- 3128 1
- 3130 1
- 3133 1
- 3139 1
- 3150 1
- 3156 1
- 3161 1
- 3162 1
- 3166 1
- 3170 1
- 3184 1
- 3187 1
- 3194 1
- 3198 1
- 3201 1
- 3213 1
- 3214 1
- 3220 1
- 3224 1
- 3230 1
- 3231 1
- 3233 1
- 3236 1
- 3240 1
- 3249 1
- 3276 1
- 3277 1
- 3284 1
- 3287 1
- 3291 1
- 3293 1
- 3300 1
- 3312 1
- 3316 1
- 3321 1
- 3339 1
- 3353 1
- 3371 1
- 3381 1
- 3401 1
- 3421 1
- 3440 1
- 3462 1
- 3480 1
- 3502 1
- 3510 1
- 3525 1
- 3537 1
- 3542 1
- 3556 1
- 3578 1
- 3581 1
- 3592 1
- 3607 1
- 3618 1
- 3630 1
- 3638 1
- 3644 1
- 3649 1
- 3664 1
- 3667 1
- 3677 1
- 3689 1
- 3694 1
- 3701 1
- 3712 1
- 3721 1
- 3730 1
- 3735 1
- 3751 1
- 3762 1
- 3770 1
- 3781 1
- 3799 1
- 3812 1
- 3874 1
- 3898 1
- 3913 1
- 3934 1
- 3965 1
- 3987 1
- 4014 1
- 4046 1
- 4064 1
- 4077 1
- 4114 1
- 4150 1
- 4170 1
- 4188 1
- 4230 1
- 4260 1
- 4287 1
- 4313 1
- 4350 1
- 4400 1
- 4420 1
- 4459 1
- 4489 1
- 4518 1
- 4548 1
- 4599 1
- 4634 1
- 4686 1
- 4793 1
- 4867 1
- 4943 1
- 4994 1
- 5098 1
- 5243 1
- 5331 1
- 5457 1
- 5528 1
- 5565 1
- 5592 1
- 5641 1
- 5676 1
- 5700 1
- 5713 1
- 5739 1
- 5758 1
- 5770 1
- 5787 1
- 5797 1
- 5806 1
- 5808 1
- 5816 1
- 5822 1
- 5827 1
- 5837 1
- 5840 1
- 5844 1
- 5848 1
- 5852 1
- 5859 1
state 1
- South Dakota 795
fips 1
- 46035 · 795 ✖
county 1
- Davison 795
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1126 | 1126 | 2020-03-10 | Davison | South Dakota | 46035 | 2 | 1 |
1322 | 1322 | 2020-03-11 | Davison | South Dakota | 46035 | 2 | 1 |
1568 | 1568 | 2020-03-12 | Davison | South Dakota | 46035 | 2 | 1 |
1868 | 1868 | 2020-03-13 | Davison | South Dakota | 46035 | 2 | 1 |
2232 | 2232 | 2020-03-14 | Davison | South Dakota | 46035 | 2 | 1 |
2657 | 2657 | 2020-03-15 | Davison | South Dakota | 46035 | 2 | 1 |
3123 | 3123 | 2020-03-16 | Davison | South Dakota | 46035 | 2 | 1 |
3656 | 3656 | 2020-03-17 | Davison | South Dakota | 46035 | 2 | 1 |
4276 | 4276 | 2020-03-18 | Davison | South Dakota | 46035 | 2 | 1 |
5021 | 5021 | 2020-03-19 | Davison | South Dakota | 46035 | 2 | 1 |
5902 | 5902 | 2020-03-20 | Davison | South Dakota | 46035 | 2 | 1 |
6912 | 6912 | 2020-03-21 | Davison | South Dakota | 46035 | 2 | 1 |
8034 | 8034 | 2020-03-22 | Davison | South Dakota | 46035 | 2 | 1 |
9249 | 9249 | 2020-03-23 | Davison | South Dakota | 46035 | 2 | 1 |
10576 | 10576 | 2020-03-24 | Davison | South Dakota | 46035 | 2 | 1 |
12050 | 12050 | 2020-03-25 | Davison | South Dakota | 46035 | 2 | 1 |
13672 | 13672 | 2020-03-26 | Davison | South Dakota | 46035 | 2 | 1 |
15420 | 15420 | 2020-03-27 | Davison | South Dakota | 46035 | 2 | 1 |
17275 | 17275 | 2020-03-28 | Davison | South Dakota | 46035 | 2 | 1 |
19217 | 19217 | 2020-03-29 | Davison | South Dakota | 46035 | 2 | 1 |
21269 | 21269 | 2020-03-30 | Davison | South Dakota | 46035 | 2 | 1 |
23407 | 23407 | 2020-03-31 | Davison | South Dakota | 46035 | 2 | 1 |
25605 | 25605 | 2020-04-01 | Davison | South Dakota | 46035 | 2 | 1 |
27881 | 27881 | 2020-04-02 | Davison | South Dakota | 46035 | 3 | 1 |
30216 | 30216 | 2020-04-03 | Davison | South Dakota | 46035 | 3 | 1 |
32607 | 32607 | 2020-04-04 | Davison | South Dakota | 46035 | 3 | 1 |
35043 | 35043 | 2020-04-05 | Davison | South Dakota | 46035 | 3 | 1 |
37518 | 37518 | 2020-04-06 | Davison | South Dakota | 46035 | 3 | 1 |
40041 | 40041 | 2020-04-07 | Davison | South Dakota | 46035 | 3 | 1 |
42601 | 42601 | 2020-04-08 | Davison | South Dakota | 46035 | 3 | 1 |
45188 | 45188 | 2020-04-09 | Davison | South Dakota | 46035 | 3 | 1 |
47805 | 47805 | 2020-04-10 | Davison | South Dakota | 46035 | 3 | 1 |
50462 | 50462 | 2020-04-11 | Davison | South Dakota | 46035 | 3 | 1 |
53135 | 53135 | 2020-04-12 | Davison | South Dakota | 46035 | 3 | 1 |
55820 | 55820 | 2020-04-13 | Davison | South Dakota | 46035 | 3 | 1 |
58523 | 58523 | 2020-04-14 | Davison | South Dakota | 46035 | 3 | 1 |
61238 | 61238 | 2020-04-15 | Davison | South Dakota | 46035 | 3 | 1 |
63964 | 63964 | 2020-04-16 | Davison | South Dakota | 46035 | 3 | 1 |
66710 | 66710 | 2020-04-17 | Davison | South Dakota | 46035 | 3 | 1 |
69468 | 69468 | 2020-04-18 | Davison | South Dakota | 46035 | 3 | 1 |
72235 | 72235 | 2020-04-19 | Davison | South Dakota | 46035 | 3 | 1 |
75010 | 75010 | 2020-04-20 | Davison | South Dakota | 46035 | 3 | 1 |
77792 | 77792 | 2020-04-21 | Davison | South Dakota | 46035 | 4 | 1 |
80582 | 80582 | 2020-04-22 | Davison | South Dakota | 46035 | 5 | 1 |
83381 | 83381 | 2020-04-23 | Davison | South Dakota | 46035 | 5 | 1 |
86185 | 86185 | 2020-04-24 | Davison | South Dakota | 46035 | 5 | 1 |
88999 | 88999 | 2020-04-25 | Davison | South Dakota | 46035 | 5 | 1 |
91815 | 91815 | 2020-04-26 | Davison | South Dakota | 46035 | 6 | 1 |
94642 | 94642 | 2020-04-27 | Davison | South Dakota | 46035 | 6 | 1 |
97482 | 97482 | 2020-04-28 | Davison | South Dakota | 46035 | 6 | 1 |
100331 | 100331 | 2020-04-29 | Davison | South Dakota | 46035 | 6 | 1 |
103184 | 103184 | 2020-04-30 | Davison | South Dakota | 46035 | 6 | 1 |
106047 | 106047 | 2020-05-01 | Davison | South Dakota | 46035 | 6 | 1 |
108914 | 108914 | 2020-05-02 | Davison | South Dakota | 46035 | 6 | 1 |
111788 | 111788 | 2020-05-03 | Davison | South Dakota | 46035 | 6 | 1 |
114670 | 114670 | 2020-05-04 | Davison | South Dakota | 46035 | 6 | 1 |
117626 | 117626 | 2020-05-05 | Davison | South Dakota | 46035 | 7 | 1 |
120588 | 120588 | 2020-05-06 | Davison | South Dakota | 46035 | 7 | 1 |
123566 | 123566 | 2020-05-07 | Davison | South Dakota | 46035 | 7 | 1 |
126549 | 126549 | 2020-05-08 | Davison | South Dakota | 46035 | 7 | 1 |
129538 | 129538 | 2020-05-09 | Davison | South Dakota | 46035 | 7 | 1 |
132527 | 132527 | 2020-05-10 | Davison | South Dakota | 46035 | 7 | 1 |
135518 | 135518 | 2020-05-11 | Davison | South Dakota | 46035 | 7 | 1 |
138508 | 138508 | 2020-05-12 | Davison | South Dakota | 46035 | 8 | 1 |
141504 | 141504 | 2020-05-13 | Davison | South Dakota | 46035 | 8 | 1 |
144500 | 144500 | 2020-05-14 | Davison | South Dakota | 46035 | 9 | 1 |
147501 | 147501 | 2020-05-15 | Davison | South Dakota | 46035 | 9 | 1 |
150509 | 150509 | 2020-05-16 | Davison | South Dakota | 46035 | 9 | 1 |
153520 | 153520 | 2020-05-17 | Davison | South Dakota | 46035 | 9 | 1 |
156537 | 156537 | 2020-05-18 | Davison | South Dakota | 46035 | 9 | 1 |
159558 | 159558 | 2020-05-19 | Davison | South Dakota | 46035 | 9 | 1 |
162585 | 162585 | 2020-05-20 | Davison | South Dakota | 46035 | 9 | 1 |
165614 | 165614 | 2020-05-21 | Davison | South Dakota | 46035 | 9 | 2 |
168650 | 168650 | 2020-05-22 | Davison | South Dakota | 46035 | 9 | 2 |
171689 | 171689 | 2020-05-23 | Davison | South Dakota | 46035 | 9 | 1 |
174731 | 174731 | 2020-05-24 | Davison | South Dakota | 46035 | 9 | 1 |
177775 | 177775 | 2020-05-25 | Davison | South Dakota | 46035 | 9 | 1 |
180818 | 180818 | 2020-05-26 | Davison | South Dakota | 46035 | 10 | 1 |
183868 | 183868 | 2020-05-27 | Davison | South Dakota | 46035 | 11 | 1 |
186925 | 186925 | 2020-05-28 | Davison | South Dakota | 46035 | 13 | 1 |
189987 | 189987 | 2020-05-29 | Davison | South Dakota | 46035 | 14 | 1 |
193052 | 193052 | 2020-05-30 | Davison | South Dakota | 46035 | 15 | 1 |
196121 | 196121 | 2020-05-31 | Davison | South Dakota | 46035 | 16 | 1 |
199194 | 199194 | 2020-06-01 | Davison | South Dakota | 46035 | 16 | 1 |
202269 | 202269 | 2020-06-02 | Davison | South Dakota | 46035 | 16 | 1 |
205347 | 205347 | 2020-06-03 | Davison | South Dakota | 46035 | 20 | 1 |
208429 | 208429 | 2020-06-04 | Davison | South Dakota | 46035 | 20 | 1 |
211511 | 211511 | 2020-06-05 | Davison | South Dakota | 46035 | 24 | 1 |
214597 | 214597 | 2020-06-06 | Davison | South Dakota | 46035 | 27 | 1 |
217687 | 217687 | 2020-06-07 | Davison | South Dakota | 46035 | 27 | 1 |
220779 | 220779 | 2020-06-08 | Davison | South Dakota | 46035 | 30 | 1 |
223874 | 223874 | 2020-06-09 | Davison | South Dakota | 46035 | 30 | 1 |
226974 | 226974 | 2020-06-10 | Davison | South Dakota | 46035 | 30 | 1 |
230078 | 230078 | 2020-06-11 | Davison | South Dakota | 46035 | 30 | 1 |
233183 | 233183 | 2020-06-12 | Davison | South Dakota | 46035 | 31 | 1 |
236288 | 236288 | 2020-06-13 | Davison | South Dakota | 46035 | 32 | 1 |
239396 | 239396 | 2020-06-14 | Davison | South Dakota | 46035 | 32 | 1 |
242506 | 242506 | 2020-06-15 | Davison | South Dakota | 46035 | 33 | 1 |
245618 | 245618 | 2020-06-16 | Davison | South Dakota | 46035 | 33 | 1 |
248731 | 248731 | 2020-06-17 | Davison | South Dakota | 46035 | 33 | 1 |
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);