ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 46005 and state = "South Dakota" sorted by fips descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▲ | cases | deaths |
---|---|---|---|---|---|---|---|
1124 | 1124 | 2020-03-10 | Beadle | South Dakota | 46005 | 1 | 0 |
1319 | 1319 | 2020-03-11 | Beadle | South Dakota | 46005 | 1 | 0 |
1565 | 1565 | 2020-03-12 | Beadle | South Dakota | 46005 | 1 | 0 |
1865 | 1865 | 2020-03-13 | Beadle | South Dakota | 46005 | 1 | 0 |
2229 | 2229 | 2020-03-14 | Beadle | South Dakota | 46005 | 1 | 0 |
2654 | 2654 | 2020-03-15 | Beadle | South Dakota | 46005 | 1 | 0 |
3120 | 3120 | 2020-03-16 | Beadle | South Dakota | 46005 | 1 | 0 |
3653 | 3653 | 2020-03-17 | Beadle | South Dakota | 46005 | 1 | 0 |
4273 | 4273 | 2020-03-18 | Beadle | South Dakota | 46005 | 1 | 0 |
5018 | 5018 | 2020-03-19 | Beadle | South Dakota | 46005 | 4 | 0 |
5899 | 5899 | 2020-03-20 | Beadle | South Dakota | 46005 | 4 | 0 |
6909 | 6909 | 2020-03-21 | Beadle | South Dakota | 46005 | 4 | 0 |
8030 | 8030 | 2020-03-22 | Beadle | South Dakota | 46005 | 10 | 0 |
9244 | 9244 | 2020-03-23 | Beadle | South Dakota | 46005 | 12 | 0 |
10570 | 10570 | 2020-03-24 | Beadle | South Dakota | 46005 | 13 | 0 |
12044 | 12044 | 2020-03-25 | Beadle | South Dakota | 46005 | 13 | 0 |
13666 | 13666 | 2020-03-26 | Beadle | South Dakota | 46005 | 14 | 0 |
15414 | 15414 | 2020-03-27 | Beadle | South Dakota | 46005 | 16 | 0 |
17269 | 17269 | 2020-03-28 | Beadle | South Dakota | 46005 | 16 | 0 |
19209 | 19209 | 2020-03-29 | Beadle | South Dakota | 46005 | 20 | 0 |
21261 | 21261 | 2020-03-30 | Beadle | South Dakota | 46005 | 20 | 0 |
23399 | 23399 | 2020-03-31 | Beadle | South Dakota | 46005 | 20 | 0 |
25597 | 25597 | 2020-04-01 | Beadle | South Dakota | 46005 | 21 | 0 |
27873 | 27873 | 2020-04-02 | Beadle | South Dakota | 46005 | 21 | 1 |
30208 | 30208 | 2020-04-03 | Beadle | South Dakota | 46005 | 21 | 1 |
32599 | 32599 | 2020-04-04 | Beadle | South Dakota | 46005 | 21 | 1 |
35035 | 35035 | 2020-04-05 | Beadle | South Dakota | 46005 | 21 | 1 |
37510 | 37510 | 2020-04-06 | Beadle | South Dakota | 46005 | 21 | 1 |
40033 | 40033 | 2020-04-07 | Beadle | South Dakota | 46005 | 21 | 1 |
42593 | 42593 | 2020-04-08 | Beadle | South Dakota | 46005 | 21 | 1 |
45179 | 45179 | 2020-04-09 | Beadle | South Dakota | 46005 | 21 | 2 |
47796 | 47796 | 2020-04-10 | Beadle | South Dakota | 46005 | 22 | 2 |
50453 | 50453 | 2020-04-11 | Beadle | South Dakota | 46005 | 21 | 2 |
53126 | 53126 | 2020-04-12 | Beadle | South Dakota | 46005 | 21 | 2 |
55811 | 55811 | 2020-04-13 | Beadle | South Dakota | 46005 | 21 | 2 |
58514 | 58514 | 2020-04-14 | Beadle | South Dakota | 46005 | 21 | 2 |
61229 | 61229 | 2020-04-15 | Beadle | South Dakota | 46005 | 21 | 2 |
63955 | 63955 | 2020-04-16 | Beadle | South Dakota | 46005 | 21 | 2 |
66701 | 66701 | 2020-04-17 | Beadle | South Dakota | 46005 | 21 | 2 |
69459 | 69459 | 2020-04-18 | Beadle | South Dakota | 46005 | 21 | 2 |
72226 | 72226 | 2020-04-19 | Beadle | South Dakota | 46005 | 21 | 2 |
75001 | 75001 | 2020-04-20 | Beadle | South Dakota | 46005 | 21 | 2 |
77783 | 77783 | 2020-04-21 | Beadle | South Dakota | 46005 | 21 | 2 |
80573 | 80573 | 2020-04-22 | Beadle | South Dakota | 46005 | 21 | 2 |
83372 | 83372 | 2020-04-23 | Beadle | South Dakota | 46005 | 21 | 2 |
86176 | 86176 | 2020-04-24 | Beadle | South Dakota | 46005 | 21 | 2 |
88990 | 88990 | 2020-04-25 | Beadle | South Dakota | 46005 | 21 | 2 |
91806 | 91806 | 2020-04-26 | Beadle | South Dakota | 46005 | 21 | 2 |
94633 | 94633 | 2020-04-27 | Beadle | South Dakota | 46005 | 21 | 2 |
97472 | 97472 | 2020-04-28 | Beadle | South Dakota | 46005 | 21 | 2 |
100321 | 100321 | 2020-04-29 | Beadle | South Dakota | 46005 | 21 | 2 |
103174 | 103174 | 2020-04-30 | Beadle | South Dakota | 46005 | 21 | 2 |
106037 | 106037 | 2020-05-01 | Beadle | South Dakota | 46005 | 21 | 2 |
108904 | 108904 | 2020-05-02 | Beadle | South Dakota | 46005 | 21 | 2 |
111778 | 111778 | 2020-05-03 | Beadle | South Dakota | 46005 | 21 | 2 |
114660 | 114660 | 2020-05-04 | Beadle | South Dakota | 46005 | 21 | 2 |
117616 | 117616 | 2020-05-05 | Beadle | South Dakota | 46005 | 21 | 2 |
120578 | 120578 | 2020-05-06 | Beadle | South Dakota | 46005 | 21 | 2 |
123556 | 123556 | 2020-05-07 | Beadle | South Dakota | 46005 | 21 | 2 |
126539 | 126539 | 2020-05-08 | Beadle | South Dakota | 46005 | 21 | 2 |
129528 | 129528 | 2020-05-09 | Beadle | South Dakota | 46005 | 21 | 2 |
132517 | 132517 | 2020-05-10 | Beadle | South Dakota | 46005 | 21 | 2 |
135508 | 135508 | 2020-05-11 | Beadle | South Dakota | 46005 | 21 | 2 |
138498 | 138498 | 2020-05-12 | Beadle | South Dakota | 46005 | 22 | 2 |
141494 | 141494 | 2020-05-13 | Beadle | South Dakota | 46005 | 22 | 2 |
144490 | 144490 | 2020-05-14 | Beadle | South Dakota | 46005 | 22 | 2 |
147491 | 147491 | 2020-05-15 | Beadle | South Dakota | 46005 | 22 | 2 |
150499 | 150499 | 2020-05-16 | Beadle | South Dakota | 46005 | 30 | 2 |
153510 | 153510 | 2020-05-17 | Beadle | South Dakota | 46005 | 31 | 2 |
156527 | 156527 | 2020-05-18 | Beadle | South Dakota | 46005 | 37 | 2 |
159548 | 159548 | 2020-05-19 | Beadle | South Dakota | 46005 | 43 | 2 |
162575 | 162575 | 2020-05-20 | Beadle | South Dakota | 46005 | 68 | 2 |
165604 | 165604 | 2020-05-21 | Beadle | South Dakota | 46005 | 68 | 2 |
168640 | 168640 | 2020-05-22 | Beadle | South Dakota | 46005 | 98 | 2 |
171679 | 171679 | 2020-05-23 | Beadle | South Dakota | 46005 | 118 | 2 |
174721 | 174721 | 2020-05-24 | Beadle | South Dakota | 46005 | 131 | 2 |
177765 | 177765 | 2020-05-25 | Beadle | South Dakota | 46005 | 132 | 2 |
180808 | 180808 | 2020-05-26 | Beadle | South Dakota | 46005 | 150 | 2 |
183858 | 183858 | 2020-05-27 | Beadle | South Dakota | 46005 | 163 | 2 |
186915 | 186915 | 2020-05-28 | Beadle | South Dakota | 46005 | 190 | 2 |
189977 | 189977 | 2020-05-29 | Beadle | South Dakota | 46005 | 222 | 3 |
193042 | 193042 | 2020-05-30 | Beadle | South Dakota | 46005 | 252 | 5 |
196111 | 196111 | 2020-05-31 | Beadle | South Dakota | 46005 | 261 | 5 |
199184 | 199184 | 2020-06-01 | Beadle | South Dakota | 46005 | 275 | 5 |
202259 | 202259 | 2020-06-02 | Beadle | South Dakota | 46005 | 276 | 5 |
205336 | 205336 | 2020-06-03 | Beadle | South Dakota | 46005 | 308 | 5 |
208417 | 208417 | 2020-06-04 | Beadle | South Dakota | 46005 | 341 | 5 |
211499 | 211499 | 2020-06-05 | Beadle | South Dakota | 46005 | 343 | 5 |
214585 | 214585 | 2020-06-06 | Beadle | South Dakota | 46005 | 361 | 5 |
217675 | 217675 | 2020-06-07 | Beadle | South Dakota | 46005 | 382 | 5 |
220767 | 220767 | 2020-06-08 | Beadle | South Dakota | 46005 | 385 | 5 |
223862 | 223862 | 2020-06-09 | Beadle | South Dakota | 46005 | 386 | 5 |
226962 | 226962 | 2020-06-10 | Beadle | South Dakota | 46005 | 398 | 6 |
230066 | 230066 | 2020-06-11 | Beadle | South Dakota | 46005 | 411 | 6 |
233171 | 233171 | 2020-06-12 | Beadle | South Dakota | 46005 | 418 | 6 |
236276 | 236276 | 2020-06-13 | Beadle | South Dakota | 46005 | 434 | 6 |
239384 | 239384 | 2020-06-14 | Beadle | South Dakota | 46005 | 446 | 6 |
242493 | 242493 | 2020-06-15 | Beadle | South Dakota | 46005 | 448 | 6 |
245605 | 245605 | 2020-06-16 | Beadle | South Dakota | 46005 | 452 | 6 |
248718 | 248718 | 2020-06-17 | Beadle | South Dakota | 46005 | 467 | 6 |
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);