ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 46047 and state = "South Dakota" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- 2020-04-26 1
- 2020-04-27 1
- …
state 1
- South Dakota · 776 ✖
fips 1
- 46047 · 776 ✖
county 1
- Fall River 776
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
19219 | 19219 | 2020-03-29 | Fall River | South Dakota | 46047 | 1 | 0 |
21271 | 21271 | 2020-03-30 | Fall River | South Dakota | 46047 | 1 | 0 |
23409 | 23409 | 2020-03-31 | Fall River | South Dakota | 46047 | 1 | 0 |
25607 | 25607 | 2020-04-01 | Fall River | South Dakota | 46047 | 1 | 0 |
27883 | 27883 | 2020-04-02 | Fall River | South Dakota | 46047 | 1 | 0 |
30218 | 30218 | 2020-04-03 | Fall River | South Dakota | 46047 | 1 | 0 |
32609 | 32609 | 2020-04-04 | Fall River | South Dakota | 46047 | 1 | 0 |
35045 | 35045 | 2020-04-05 | Fall River | South Dakota | 46047 | 1 | 0 |
37520 | 37520 | 2020-04-06 | Fall River | South Dakota | 46047 | 1 | 0 |
40043 | 40043 | 2020-04-07 | Fall River | South Dakota | 46047 | 1 | 0 |
42603 | 42603 | 2020-04-08 | Fall River | South Dakota | 46047 | 1 | 0 |
45190 | 45190 | 2020-04-09 | Fall River | South Dakota | 46047 | 1 | 0 |
47807 | 47807 | 2020-04-10 | Fall River | South Dakota | 46047 | 1 | 0 |
50464 | 50464 | 2020-04-11 | Fall River | South Dakota | 46047 | 1 | 0 |
53137 | 53137 | 2020-04-12 | Fall River | South Dakota | 46047 | 1 | 0 |
55822 | 55822 | 2020-04-13 | Fall River | South Dakota | 46047 | 1 | 0 |
58525 | 58525 | 2020-04-14 | Fall River | South Dakota | 46047 | 1 | 0 |
61240 | 61240 | 2020-04-15 | Fall River | South Dakota | 46047 | 1 | 0 |
63966 | 63966 | 2020-04-16 | Fall River | South Dakota | 46047 | 1 | 0 |
66712 | 66712 | 2020-04-17 | Fall River | South Dakota | 46047 | 1 | 0 |
69470 | 69470 | 2020-04-18 | Fall River | South Dakota | 46047 | 1 | 0 |
72237 | 72237 | 2020-04-19 | Fall River | South Dakota | 46047 | 1 | 0 |
75012 | 75012 | 2020-04-20 | Fall River | South Dakota | 46047 | 1 | 0 |
77794 | 77794 | 2020-04-21 | Fall River | South Dakota | 46047 | 1 | 0 |
80584 | 80584 | 2020-04-22 | Fall River | South Dakota | 46047 | 1 | 0 |
83383 | 83383 | 2020-04-23 | Fall River | South Dakota | 46047 | 1 | 0 |
86187 | 86187 | 2020-04-24 | Fall River | South Dakota | 46047 | 1 | 0 |
89001 | 89001 | 2020-04-25 | Fall River | South Dakota | 46047 | 1 | 0 |
91817 | 91817 | 2020-04-26 | Fall River | South Dakota | 46047 | 1 | 0 |
94645 | 94645 | 2020-04-27 | Fall River | South Dakota | 46047 | 1 | 0 |
97485 | 97485 | 2020-04-28 | Fall River | South Dakota | 46047 | 1 | 0 |
100335 | 100335 | 2020-04-29 | Fall River | South Dakota | 46047 | 1 | 0 |
103188 | 103188 | 2020-04-30 | Fall River | South Dakota | 46047 | 1 | 0 |
106051 | 106051 | 2020-05-01 | Fall River | South Dakota | 46047 | 1 | 0 |
108918 | 108918 | 2020-05-02 | Fall River | South Dakota | 46047 | 1 | 0 |
111792 | 111792 | 2020-05-03 | Fall River | South Dakota | 46047 | 2 | 0 |
114674 | 114674 | 2020-05-04 | Fall River | South Dakota | 46047 | 2 | 0 |
117630 | 117630 | 2020-05-05 | Fall River | South Dakota | 46047 | 2 | 0 |
120592 | 120592 | 2020-05-06 | Fall River | South Dakota | 46047 | 2 | 0 |
123570 | 123570 | 2020-05-07 | Fall River | South Dakota | 46047 | 2 | 0 |
126553 | 126553 | 2020-05-08 | Fall River | South Dakota | 46047 | 2 | 0 |
129542 | 129542 | 2020-05-09 | Fall River | South Dakota | 46047 | 2 | 0 |
132531 | 132531 | 2020-05-10 | Fall River | South Dakota | 46047 | 2 | 0 |
135522 | 135522 | 2020-05-11 | Fall River | South Dakota | 46047 | 2 | 0 |
138512 | 138512 | 2020-05-12 | Fall River | South Dakota | 46047 | 2 | 0 |
141508 | 141508 | 2020-05-13 | Fall River | South Dakota | 46047 | 2 | 0 |
144504 | 144504 | 2020-05-14 | Fall River | South Dakota | 46047 | 2 | 0 |
147505 | 147505 | 2020-05-15 | Fall River | South Dakota | 46047 | 2 | 0 |
150513 | 150513 | 2020-05-16 | Fall River | South Dakota | 46047 | 2 | 0 |
153524 | 153524 | 2020-05-17 | Fall River | South Dakota | 46047 | 2 | 0 |
156541 | 156541 | 2020-05-18 | Fall River | South Dakota | 46047 | 2 | 0 |
159562 | 159562 | 2020-05-19 | Fall River | South Dakota | 46047 | 3 | 0 |
162589 | 162589 | 2020-05-20 | Fall River | South Dakota | 46047 | 4 | 0 |
165618 | 165618 | 2020-05-21 | Fall River | South Dakota | 46047 | 4 | 0 |
168654 | 168654 | 2020-05-22 | Fall River | South Dakota | 46047 | 4 | 0 |
171693 | 171693 | 2020-05-23 | Fall River | South Dakota | 46047 | 4 | 0 |
174735 | 174735 | 2020-05-24 | Fall River | South Dakota | 46047 | 4 | 0 |
177779 | 177779 | 2020-05-25 | Fall River | South Dakota | 46047 | 4 | 0 |
180822 | 180822 | 2020-05-26 | Fall River | South Dakota | 46047 | 4 | 0 |
183872 | 183872 | 2020-05-27 | Fall River | South Dakota | 46047 | 4 | 0 |
186929 | 186929 | 2020-05-28 | Fall River | South Dakota | 46047 | 4 | 0 |
189992 | 189992 | 2020-05-29 | Fall River | South Dakota | 46047 | 4 | 0 |
193057 | 193057 | 2020-05-30 | Fall River | South Dakota | 46047 | 4 | 0 |
196126 | 196126 | 2020-05-31 | Fall River | South Dakota | 46047 | 4 | 0 |
199199 | 199199 | 2020-06-01 | Fall River | South Dakota | 46047 | 4 | 0 |
202274 | 202274 | 2020-06-02 | Fall River | South Dakota | 46047 | 5 | 0 |
205352 | 205352 | 2020-06-03 | Fall River | South Dakota | 46047 | 6 | 0 |
208434 | 208434 | 2020-06-04 | Fall River | South Dakota | 46047 | 6 | 0 |
211516 | 211516 | 2020-06-05 | Fall River | South Dakota | 46047 | 6 | 0 |
214603 | 214603 | 2020-06-06 | Fall River | South Dakota | 46047 | 6 | 0 |
217693 | 217693 | 2020-06-07 | Fall River | South Dakota | 46047 | 6 | 0 |
220785 | 220785 | 2020-06-08 | Fall River | South Dakota | 46047 | 6 | 0 |
223880 | 223880 | 2020-06-09 | Fall River | South Dakota | 46047 | 6 | 0 |
226980 | 226980 | 2020-06-10 | Fall River | South Dakota | 46047 | 6 | 0 |
230084 | 230084 | 2020-06-11 | Fall River | South Dakota | 46047 | 6 | 0 |
233189 | 233189 | 2020-06-12 | Fall River | South Dakota | 46047 | 6 | 0 |
236294 | 236294 | 2020-06-13 | Fall River | South Dakota | 46047 | 6 | 0 |
239402 | 239402 | 2020-06-14 | Fall River | South Dakota | 46047 | 6 | 0 |
242512 | 242512 | 2020-06-15 | Fall River | South Dakota | 46047 | 6 | 0 |
245624 | 245624 | 2020-06-16 | Fall River | South Dakota | 46047 | 6 | 0 |
248737 | 248737 | 2020-06-17 | Fall River | South Dakota | 46047 | 6 | 0 |
251852 | 251852 | 2020-06-18 | Fall River | South Dakota | 46047 | 6 | 0 |
254967 | 254967 | 2020-06-19 | Fall River | South Dakota | 46047 | 6 | 0 |
258093 | 258093 | 2020-06-20 | Fall River | South Dakota | 46047 | 6 | 0 |
261220 | 261220 | 2020-06-21 | Fall River | South Dakota | 46047 | 6 | 0 |
264348 | 264348 | 2020-06-22 | Fall River | South Dakota | 46047 | 7 | 0 |
267476 | 267476 | 2020-06-23 | Fall River | South Dakota | 46047 | 7 | 0 |
270610 | 270610 | 2020-06-24 | Fall River | South Dakota | 46047 | 7 | 0 |
273749 | 273749 | 2020-06-25 | Fall River | South Dakota | 46047 | 9 | 0 |
276896 | 276896 | 2020-06-26 | Fall River | South Dakota | 46047 | 10 | 0 |
280044 | 280044 | 2020-06-27 | Fall River | South Dakota | 46047 | 10 | 0 |
283190 | 283190 | 2020-06-28 | Fall River | South Dakota | 46047 | 11 | 0 |
286335 | 286335 | 2020-06-29 | Fall River | South Dakota | 46047 | 12 | 0 |
289486 | 289486 | 2020-06-30 | Fall River | South Dakota | 46047 | 12 | 0 |
292638 | 292638 | 2020-07-01 | Fall River | South Dakota | 46047 | 12 | 0 |
295794 | 295794 | 2020-07-02 | Fall River | South Dakota | 46047 | 12 | 0 |
298954 | 298954 | 2020-07-03 | Fall River | South Dakota | 46047 | 12 | 0 |
302118 | 302118 | 2020-07-04 | Fall River | South Dakota | 46047 | 12 | 0 |
305281 | 305281 | 2020-07-05 | Fall River | South Dakota | 46047 | 12 | 0 |
308448 | 308448 | 2020-07-06 | Fall River | South Dakota | 46047 | 12 | 0 |
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);