ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where fips = 46097 and state = "South Dakota" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
47820 | 47820 | 2020-04-10 | Miner | South Dakota | 46097 | 1 | 0 |
50477 | 50477 | 2020-04-11 | Miner | South Dakota | 46097 | 1 | 0 |
53150 | 53150 | 2020-04-12 | Miner | South Dakota | 46097 | 1 | 0 |
55836 | 55836 | 2020-04-13 | Miner | South Dakota | 46097 | 1 | 0 |
58539 | 58539 | 2020-04-14 | Miner | South Dakota | 46097 | 1 | 0 |
61254 | 61254 | 2020-04-15 | Miner | South Dakota | 46097 | 1 | 0 |
63980 | 63980 | 2020-04-16 | Miner | South Dakota | 46097 | 1 | 0 |
66726 | 66726 | 2020-04-17 | Miner | South Dakota | 46097 | 1 | 0 |
69484 | 69484 | 2020-04-18 | Miner | South Dakota | 46097 | 1 | 0 |
72251 | 72251 | 2020-04-19 | Miner | South Dakota | 46097 | 1 | 0 |
75026 | 75026 | 2020-04-20 | Miner | South Dakota | 46097 | 1 | 0 |
77808 | 77808 | 2020-04-21 | Miner | South Dakota | 46097 | 1 | 0 |
80598 | 80598 | 2020-04-22 | Miner | South Dakota | 46097 | 1 | 0 |
83397 | 83397 | 2020-04-23 | Miner | South Dakota | 46097 | 1 | 0 |
86201 | 86201 | 2020-04-24 | Miner | South Dakota | 46097 | 1 | 0 |
89016 | 89016 | 2020-04-25 | Miner | South Dakota | 46097 | 1 | 0 |
91833 | 91833 | 2020-04-26 | Miner | South Dakota | 46097 | 1 | 0 |
94661 | 94661 | 2020-04-27 | Miner | South Dakota | 46097 | 1 | 0 |
97501 | 97501 | 2020-04-28 | Miner | South Dakota | 46097 | 1 | 0 |
100351 | 100351 | 2020-04-29 | Miner | South Dakota | 46097 | 1 | 0 |
103204 | 103204 | 2020-04-30 | Miner | South Dakota | 46097 | 1 | 0 |
106067 | 106067 | 2020-05-01 | Miner | South Dakota | 46097 | 1 | 0 |
108934 | 108934 | 2020-05-02 | Miner | South Dakota | 46097 | 1 | 0 |
111808 | 111808 | 2020-05-03 | Miner | South Dakota | 46097 | 1 | 0 |
114690 | 114690 | 2020-05-04 | Miner | South Dakota | 46097 | 1 | 0 |
117646 | 117646 | 2020-05-05 | Miner | South Dakota | 46097 | 1 | 0 |
120609 | 120609 | 2020-05-06 | Miner | South Dakota | 46097 | 1 | 0 |
123587 | 123587 | 2020-05-07 | Miner | South Dakota | 46097 | 1 | 0 |
126570 | 126570 | 2020-05-08 | Miner | South Dakota | 46097 | 1 | 0 |
129559 | 129559 | 2020-05-09 | Miner | South Dakota | 46097 | 1 | 0 |
132548 | 132548 | 2020-05-10 | Miner | South Dakota | 46097 | 1 | 0 |
135539 | 135539 | 2020-05-11 | Miner | South Dakota | 46097 | 1 | 0 |
138529 | 138529 | 2020-05-12 | Miner | South Dakota | 46097 | 1 | 0 |
141525 | 141525 | 2020-05-13 | Miner | South Dakota | 46097 | 1 | 0 |
144521 | 144521 | 2020-05-14 | Miner | South Dakota | 46097 | 1 | 0 |
147522 | 147522 | 2020-05-15 | Miner | South Dakota | 46097 | 1 | 0 |
150530 | 150530 | 2020-05-16 | Miner | South Dakota | 46097 | 1 | 0 |
153541 | 153541 | 2020-05-17 | Miner | South Dakota | 46097 | 1 | 0 |
156558 | 156558 | 2020-05-18 | Miner | South Dakota | 46097 | 1 | 0 |
159579 | 159579 | 2020-05-19 | Miner | South Dakota | 46097 | 1 | 0 |
162606 | 162606 | 2020-05-20 | Miner | South Dakota | 46097 | 1 | 0 |
165635 | 165635 | 2020-05-21 | Miner | South Dakota | 46097 | 1 | 0 |
168671 | 168671 | 2020-05-22 | Miner | South Dakota | 46097 | 1 | 0 |
171710 | 171710 | 2020-05-23 | Miner | South Dakota | 46097 | 1 | 0 |
174753 | 174753 | 2020-05-24 | Miner | South Dakota | 46097 | 1 | 0 |
177797 | 177797 | 2020-05-25 | Miner | South Dakota | 46097 | 1 | 0 |
180840 | 180840 | 2020-05-26 | Miner | South Dakota | 46097 | 1 | 0 |
183890 | 183890 | 2020-05-27 | Miner | South Dakota | 46097 | 1 | 0 |
186947 | 186947 | 2020-05-28 | Miner | South Dakota | 46097 | 1 | 0 |
190011 | 190011 | 2020-05-29 | Miner | South Dakota | 46097 | 1 | 0 |
193076 | 193076 | 2020-05-30 | Miner | South Dakota | 46097 | 1 | 0 |
196146 | 196146 | 2020-05-31 | Miner | South Dakota | 46097 | 1 | 0 |
199219 | 199219 | 2020-06-01 | Miner | South Dakota | 46097 | 2 | 0 |
202294 | 202294 | 2020-06-02 | Miner | South Dakota | 46097 | 2 | 0 |
205373 | 205373 | 2020-06-03 | Miner | South Dakota | 46097 | 2 | 0 |
208455 | 208455 | 2020-06-04 | Miner | South Dakota | 46097 | 2 | 0 |
211537 | 211537 | 2020-06-05 | Miner | South Dakota | 46097 | 2 | 0 |
214624 | 214624 | 2020-06-06 | Miner | South Dakota | 46097 | 2 | 0 |
217714 | 217714 | 2020-06-07 | Miner | South Dakota | 46097 | 3 | 0 |
220806 | 220806 | 2020-06-08 | Miner | South Dakota | 46097 | 3 | 0 |
223901 | 223901 | 2020-06-09 | Miner | South Dakota | 46097 | 3 | 0 |
227001 | 227001 | 2020-06-10 | Miner | South Dakota | 46097 | 3 | 0 |
230105 | 230105 | 2020-06-11 | Miner | South Dakota | 46097 | 3 | 0 |
233210 | 233210 | 2020-06-12 | Miner | South Dakota | 46097 | 3 | 0 |
236316 | 236316 | 2020-06-13 | Miner | South Dakota | 46097 | 3 | 0 |
239424 | 239424 | 2020-06-14 | Miner | South Dakota | 46097 | 3 | 0 |
242534 | 242534 | 2020-06-15 | Miner | South Dakota | 46097 | 3 | 0 |
245646 | 245646 | 2020-06-16 | Miner | South Dakota | 46097 | 3 | 0 |
248759 | 248759 | 2020-06-17 | Miner | South Dakota | 46097 | 3 | 0 |
251874 | 251874 | 2020-06-18 | Miner | South Dakota | 46097 | 3 | 0 |
254989 | 254989 | 2020-06-19 | Miner | South Dakota | 46097 | 4 | 0 |
258115 | 258115 | 2020-06-20 | Miner | South Dakota | 46097 | 5 | 0 |
261242 | 261242 | 2020-06-21 | Miner | South Dakota | 46097 | 5 | 0 |
264370 | 264370 | 2020-06-22 | Miner | South Dakota | 46097 | 5 | 0 |
267498 | 267498 | 2020-06-23 | Miner | South Dakota | 46097 | 5 | 0 |
270632 | 270632 | 2020-06-24 | Miner | South Dakota | 46097 | 5 | 0 |
273771 | 273771 | 2020-06-25 | Miner | South Dakota | 46097 | 7 | 0 |
276918 | 276918 | 2020-06-26 | Miner | South Dakota | 46097 | 8 | 0 |
280066 | 280066 | 2020-06-27 | Miner | South Dakota | 46097 | 8 | 0 |
283212 | 283212 | 2020-06-28 | Miner | South Dakota | 46097 | 9 | 0 |
286357 | 286357 | 2020-06-29 | Miner | South Dakota | 46097 | 9 | 0 |
289508 | 289508 | 2020-06-30 | Miner | South Dakota | 46097 | 9 | 0 |
292660 | 292660 | 2020-07-01 | Miner | South Dakota | 46097 | 9 | 0 |
295816 | 295816 | 2020-07-02 | Miner | South Dakota | 46097 | 9 | 0 |
298976 | 298976 | 2020-07-03 | Miner | South Dakota | 46097 | 9 | 0 |
302140 | 302140 | 2020-07-04 | Miner | South Dakota | 46097 | 9 | 0 |
305303 | 305303 | 2020-07-05 | Miner | South Dakota | 46097 | 10 | 0 |
308471 | 308471 | 2020-07-06 | Miner | South Dakota | 46097 | 10 | 0 |
311640 | 311640 | 2020-07-07 | Miner | South Dakota | 46097 | 10 | 0 |
314814 | 314814 | 2020-07-08 | Miner | South Dakota | 46097 | 10 | 0 |
317987 | 317987 | 2020-07-09 | Miner | South Dakota | 46097 | 10 | 0 |
321165 | 321165 | 2020-07-10 | Miner | South Dakota | 46097 | 10 | 0 |
324345 | 324345 | 2020-07-11 | Miner | South Dakota | 46097 | 10 | 0 |
327530 | 327530 | 2020-07-12 | Miner | South Dakota | 46097 | 10 | 0 |
330716 | 330716 | 2020-07-13 | Miner | South Dakota | 46097 | 10 | 0 |
333908 | 333908 | 2020-07-14 | Miner | South Dakota | 46097 | 10 | 0 |
337102 | 337102 | 2020-07-15 | Miner | South Dakota | 46097 | 10 | 0 |
340299 | 340299 | 2020-07-16 | Miner | South Dakota | 46097 | 10 | 0 |
343497 | 343497 | 2020-07-17 | Miner | South Dakota | 46097 | 10 | 0 |
346697 | 346697 | 2020-07-18 | Miner | South Dakota | 46097 | 10 | 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);