ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
765 rows where fips = 46031 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 |
---|---|---|---|---|---|---|---|
45187 | 45187 | 2020-04-09 | Corson | South Dakota | 46031 | 1 | 0 |
47804 | 47804 | 2020-04-10 | Corson | South Dakota | 46031 | 1 | 0 |
50461 | 50461 | 2020-04-11 | Corson | South Dakota | 46031 | 1 | 0 |
53134 | 53134 | 2020-04-12 | Corson | South Dakota | 46031 | 1 | 0 |
55819 | 55819 | 2020-04-13 | Corson | South Dakota | 46031 | 1 | 0 |
58522 | 58522 | 2020-04-14 | Corson | South Dakota | 46031 | 1 | 0 |
61237 | 61237 | 2020-04-15 | Corson | South Dakota | 46031 | 1 | 0 |
63963 | 63963 | 2020-04-16 | Corson | South Dakota | 46031 | 1 | 0 |
66709 | 66709 | 2020-04-17 | Corson | South Dakota | 46031 | 1 | 0 |
69467 | 69467 | 2020-04-18 | Corson | South Dakota | 46031 | 1 | 0 |
72234 | 72234 | 2020-04-19 | Corson | South Dakota | 46031 | 1 | 0 |
75009 | 75009 | 2020-04-20 | Corson | South Dakota | 46031 | 1 | 0 |
77791 | 77791 | 2020-04-21 | Corson | South Dakota | 46031 | 1 | 0 |
80581 | 80581 | 2020-04-22 | Corson | South Dakota | 46031 | 1 | 0 |
83380 | 83380 | 2020-04-23 | Corson | South Dakota | 46031 | 1 | 0 |
86184 | 86184 | 2020-04-24 | Corson | South Dakota | 46031 | 1 | 0 |
88998 | 88998 | 2020-04-25 | Corson | South Dakota | 46031 | 1 | 0 |
91814 | 91814 | 2020-04-26 | Corson | South Dakota | 46031 | 1 | 0 |
94641 | 94641 | 2020-04-27 | Corson | South Dakota | 46031 | 1 | 0 |
97481 | 97481 | 2020-04-28 | Corson | South Dakota | 46031 | 1 | 0 |
100330 | 100330 | 2020-04-29 | Corson | South Dakota | 46031 | 1 | 0 |
103183 | 103183 | 2020-04-30 | Corson | South Dakota | 46031 | 1 | 0 |
106046 | 106046 | 2020-05-01 | Corson | South Dakota | 46031 | 1 | 0 |
108913 | 108913 | 2020-05-02 | Corson | South Dakota | 46031 | 1 | 0 |
111787 | 111787 | 2020-05-03 | Corson | South Dakota | 46031 | 1 | 0 |
114669 | 114669 | 2020-05-04 | Corson | South Dakota | 46031 | 1 | 0 |
117625 | 117625 | 2020-05-05 | Corson | South Dakota | 46031 | 1 | 0 |
120587 | 120587 | 2020-05-06 | Corson | South Dakota | 46031 | 1 | 0 |
123565 | 123565 | 2020-05-07 | Corson | South Dakota | 46031 | 1 | 0 |
126548 | 126548 | 2020-05-08 | Corson | South Dakota | 46031 | 1 | 0 |
129537 | 129537 | 2020-05-09 | Corson | South Dakota | 46031 | 1 | 0 |
132526 | 132526 | 2020-05-10 | Corson | South Dakota | 46031 | 1 | 0 |
135517 | 135517 | 2020-05-11 | Corson | South Dakota | 46031 | 1 | 0 |
138507 | 138507 | 2020-05-12 | Corson | South Dakota | 46031 | 2 | 0 |
141503 | 141503 | 2020-05-13 | Corson | South Dakota | 46031 | 2 | 0 |
144499 | 144499 | 2020-05-14 | Corson | South Dakota | 46031 | 2 | 0 |
147500 | 147500 | 2020-05-15 | Corson | South Dakota | 46031 | 3 | 0 |
150508 | 150508 | 2020-05-16 | Corson | South Dakota | 46031 | 3 | 0 |
153519 | 153519 | 2020-05-17 | Corson | South Dakota | 46031 | 3 | 0 |
156536 | 156536 | 2020-05-18 | Corson | South Dakota | 46031 | 4 | 0 |
159557 | 159557 | 2020-05-19 | Corson | South Dakota | 46031 | 4 | 0 |
162584 | 162584 | 2020-05-20 | Corson | South Dakota | 46031 | 4 | 0 |
165613 | 165613 | 2020-05-21 | Corson | South Dakota | 46031 | 4 | 0 |
168649 | 168649 | 2020-05-22 | Corson | South Dakota | 46031 | 4 | 0 |
171688 | 171688 | 2020-05-23 | Corson | South Dakota | 46031 | 4 | 0 |
174730 | 174730 | 2020-05-24 | Corson | South Dakota | 46031 | 4 | 0 |
177774 | 177774 | 2020-05-25 | Corson | South Dakota | 46031 | 4 | 0 |
180817 | 180817 | 2020-05-26 | Corson | South Dakota | 46031 | 4 | 0 |
183867 | 183867 | 2020-05-27 | Corson | South Dakota | 46031 | 4 | 0 |
186924 | 186924 | 2020-05-28 | Corson | South Dakota | 46031 | 4 | 0 |
189986 | 189986 | 2020-05-29 | Corson | South Dakota | 46031 | 4 | 0 |
193051 | 193051 | 2020-05-30 | Corson | South Dakota | 46031 | 4 | 0 |
196120 | 196120 | 2020-05-31 | Corson | South Dakota | 46031 | 4 | 0 |
199193 | 199193 | 2020-06-01 | Corson | South Dakota | 46031 | 4 | 0 |
202268 | 202268 | 2020-06-02 | Corson | South Dakota | 46031 | 4 | 0 |
205346 | 205346 | 2020-06-03 | Corson | South Dakota | 46031 | 4 | 0 |
208427 | 208427 | 2020-06-04 | Corson | South Dakota | 46031 | 4 | 0 |
211509 | 211509 | 2020-06-05 | Corson | South Dakota | 46031 | 4 | 0 |
214595 | 214595 | 2020-06-06 | Corson | South Dakota | 46031 | 4 | 0 |
217685 | 217685 | 2020-06-07 | Corson | South Dakota | 46031 | 4 | 0 |
220777 | 220777 | 2020-06-08 | Corson | South Dakota | 46031 | 4 | 0 |
223872 | 223872 | 2020-06-09 | Corson | South Dakota | 46031 | 4 | 0 |
226972 | 226972 | 2020-06-10 | Corson | South Dakota | 46031 | 6 | 0 |
230076 | 230076 | 2020-06-11 | Corson | South Dakota | 46031 | 8 | 0 |
233181 | 233181 | 2020-06-12 | Corson | South Dakota | 46031 | 9 | 0 |
236286 | 236286 | 2020-06-13 | Corson | South Dakota | 46031 | 10 | 0 |
239394 | 239394 | 2020-06-14 | Corson | South Dakota | 46031 | 11 | 0 |
242504 | 242504 | 2020-06-15 | Corson | South Dakota | 46031 | 11 | 0 |
245616 | 245616 | 2020-06-16 | Corson | South Dakota | 46031 | 11 | 0 |
248729 | 248729 | 2020-06-17 | Corson | South Dakota | 46031 | 12 | 0 |
251844 | 251844 | 2020-06-18 | Corson | South Dakota | 46031 | 12 | 0 |
254959 | 254959 | 2020-06-19 | Corson | South Dakota | 46031 | 13 | 0 |
258085 | 258085 | 2020-06-20 | Corson | South Dakota | 46031 | 15 | 0 |
261212 | 261212 | 2020-06-21 | Corson | South Dakota | 46031 | 15 | 0 |
264340 | 264340 | 2020-06-22 | Corson | South Dakota | 46031 | 15 | 0 |
267468 | 267468 | 2020-06-23 | Corson | South Dakota | 46031 | 16 | 0 |
270602 | 270602 | 2020-06-24 | Corson | South Dakota | 46031 | 16 | 0 |
273741 | 273741 | 2020-06-25 | Corson | South Dakota | 46031 | 17 | 0 |
276888 | 276888 | 2020-06-26 | Corson | South Dakota | 46031 | 17 | 0 |
280036 | 280036 | 2020-06-27 | Corson | South Dakota | 46031 | 17 | 0 |
283182 | 283182 | 2020-06-28 | Corson | South Dakota | 46031 | 17 | 0 |
286327 | 286327 | 2020-06-29 | Corson | South Dakota | 46031 | 17 | 0 |
289478 | 289478 | 2020-06-30 | Corson | South Dakota | 46031 | 18 | 0 |
292630 | 292630 | 2020-07-01 | Corson | South Dakota | 46031 | 18 | 0 |
295786 | 295786 | 2020-07-02 | Corson | South Dakota | 46031 | 18 | 0 |
298946 | 298946 | 2020-07-03 | Corson | South Dakota | 46031 | 18 | 0 |
302110 | 302110 | 2020-07-04 | Corson | South Dakota | 46031 | 19 | 0 |
305273 | 305273 | 2020-07-05 | Corson | South Dakota | 46031 | 19 | 0 |
308440 | 308440 | 2020-07-06 | Corson | South Dakota | 46031 | 19 | 0 |
311609 | 311609 | 2020-07-07 | Corson | South Dakota | 46031 | 19 | 0 |
314782 | 314782 | 2020-07-08 | Corson | South Dakota | 46031 | 19 | 0 |
317955 | 317955 | 2020-07-09 | Corson | South Dakota | 46031 | 19 | 0 |
321133 | 321133 | 2020-07-10 | Corson | South Dakota | 46031 | 19 | 0 |
324313 | 324313 | 2020-07-11 | Corson | South Dakota | 46031 | 20 | 0 |
327498 | 327498 | 2020-07-12 | Corson | South Dakota | 46031 | 20 | 0 |
330684 | 330684 | 2020-07-13 | Corson | South Dakota | 46031 | 20 | 0 |
333876 | 333876 | 2020-07-14 | Corson | South Dakota | 46031 | 20 | 0 |
337070 | 337070 | 2020-07-15 | Corson | South Dakota | 46031 | 22 | 0 |
340267 | 340267 | 2020-07-16 | Corson | South Dakota | 46031 | 22 | 0 |
343465 | 343465 | 2020-07-17 | Corson | South Dakota | 46031 | 22 | 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);