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 state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
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);