ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
761 rows where fips = 46069 and state = "South Dakota" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
55827 | 55827 | 2020-04-13 | Hyde | South Dakota | 46069 | 1 | 0 |
58530 | 58530 | 2020-04-14 | Hyde | South Dakota | 46069 | 1 | 0 |
61245 | 61245 | 2020-04-15 | Hyde | South Dakota | 46069 | 1 | 0 |
63971 | 63971 | 2020-04-16 | Hyde | South Dakota | 46069 | 1 | 0 |
66717 | 66717 | 2020-04-17 | Hyde | South Dakota | 46069 | 1 | 0 |
69475 | 69475 | 2020-04-18 | Hyde | South Dakota | 46069 | 1 | 0 |
72242 | 72242 | 2020-04-19 | Hyde | South Dakota | 46069 | 1 | 0 |
75017 | 75017 | 2020-04-20 | Hyde | South Dakota | 46069 | 1 | 0 |
77799 | 77799 | 2020-04-21 | Hyde | South Dakota | 46069 | 1 | 0 |
80589 | 80589 | 2020-04-22 | Hyde | South Dakota | 46069 | 1 | 0 |
83388 | 83388 | 2020-04-23 | Hyde | South Dakota | 46069 | 1 | 0 |
86192 | 86192 | 2020-04-24 | Hyde | South Dakota | 46069 | 1 | 0 |
89006 | 89006 | 2020-04-25 | Hyde | South Dakota | 46069 | 1 | 0 |
91823 | 91823 | 2020-04-26 | Hyde | South Dakota | 46069 | 1 | 0 |
94651 | 94651 | 2020-04-27 | Hyde | South Dakota | 46069 | 1 | 0 |
97491 | 97491 | 2020-04-28 | Hyde | South Dakota | 46069 | 1 | 0 |
100341 | 100341 | 2020-04-29 | Hyde | South Dakota | 46069 | 1 | 0 |
103194 | 103194 | 2020-04-30 | Hyde | South Dakota | 46069 | 1 | 0 |
106057 | 106057 | 2020-05-01 | Hyde | South Dakota | 46069 | 1 | 0 |
108924 | 108924 | 2020-05-02 | Hyde | South Dakota | 46069 | 1 | 0 |
111798 | 111798 | 2020-05-03 | Hyde | South Dakota | 46069 | 1 | 0 |
114680 | 114680 | 2020-05-04 | Hyde | South Dakota | 46069 | 1 | 0 |
117636 | 117636 | 2020-05-05 | Hyde | South Dakota | 46069 | 1 | 0 |
120599 | 120599 | 2020-05-06 | Hyde | South Dakota | 46069 | 1 | 0 |
123577 | 123577 | 2020-05-07 | Hyde | South Dakota | 46069 | 1 | 0 |
126560 | 126560 | 2020-05-08 | Hyde | South Dakota | 46069 | 1 | 0 |
129549 | 129549 | 2020-05-09 | Hyde | South Dakota | 46069 | 1 | 0 |
132538 | 132538 | 2020-05-10 | Hyde | South Dakota | 46069 | 1 | 0 |
135529 | 135529 | 2020-05-11 | Hyde | South Dakota | 46069 | 1 | 0 |
138519 | 138519 | 2020-05-12 | Hyde | South Dakota | 46069 | 1 | 0 |
141515 | 141515 | 2020-05-13 | Hyde | South Dakota | 46069 | 1 | 0 |
144511 | 144511 | 2020-05-14 | Hyde | South Dakota | 46069 | 1 | 0 |
147512 | 147512 | 2020-05-15 | Hyde | South Dakota | 46069 | 1 | 0 |
150520 | 150520 | 2020-05-16 | Hyde | South Dakota | 46069 | 1 | 0 |
153531 | 153531 | 2020-05-17 | Hyde | South Dakota | 46069 | 1 | 0 |
156548 | 156548 | 2020-05-18 | Hyde | South Dakota | 46069 | 1 | 0 |
159569 | 159569 | 2020-05-19 | Hyde | South Dakota | 46069 | 1 | 0 |
162596 | 162596 | 2020-05-20 | Hyde | South Dakota | 46069 | 1 | 0 |
165625 | 165625 | 2020-05-21 | Hyde | South Dakota | 46069 | 1 | 0 |
168661 | 168661 | 2020-05-22 | Hyde | South Dakota | 46069 | 1 | 0 |
171700 | 171700 | 2020-05-23 | Hyde | South Dakota | 46069 | 1 | 0 |
174742 | 174742 | 2020-05-24 | Hyde | South Dakota | 46069 | 1 | 0 |
177786 | 177786 | 2020-05-25 | Hyde | South Dakota | 46069 | 1 | 0 |
180829 | 180829 | 2020-05-26 | Hyde | South Dakota | 46069 | 1 | 0 |
183879 | 183879 | 2020-05-27 | Hyde | South Dakota | 46069 | 1 | 0 |
186936 | 186936 | 2020-05-28 | Hyde | South Dakota | 46069 | 1 | 0 |
189999 | 189999 | 2020-05-29 | Hyde | South Dakota | 46069 | 1 | 0 |
193064 | 193064 | 2020-05-30 | Hyde | South Dakota | 46069 | 1 | 0 |
196134 | 196134 | 2020-05-31 | Hyde | South Dakota | 46069 | 1 | 0 |
199207 | 199207 | 2020-06-01 | Hyde | South Dakota | 46069 | 1 | 0 |
202282 | 202282 | 2020-06-02 | Hyde | South Dakota | 46069 | 1 | 0 |
205361 | 205361 | 2020-06-03 | Hyde | South Dakota | 46069 | 1 | 0 |
208443 | 208443 | 2020-06-04 | Hyde | South Dakota | 46069 | 1 | 0 |
211525 | 211525 | 2020-06-05 | Hyde | South Dakota | 46069 | 1 | 0 |
214612 | 214612 | 2020-06-06 | Hyde | South Dakota | 46069 | 1 | 0 |
217702 | 217702 | 2020-06-07 | Hyde | South Dakota | 46069 | 1 | 0 |
220794 | 220794 | 2020-06-08 | Hyde | South Dakota | 46069 | 2 | 0 |
223889 | 223889 | 2020-06-09 | Hyde | South Dakota | 46069 | 3 | 0 |
226989 | 226989 | 2020-06-10 | Hyde | South Dakota | 46069 | 3 | 0 |
230093 | 230093 | 2020-06-11 | Hyde | South Dakota | 46069 | 3 | 0 |
233198 | 233198 | 2020-06-12 | Hyde | South Dakota | 46069 | 3 | 0 |
236303 | 236303 | 2020-06-13 | Hyde | South Dakota | 46069 | 3 | 0 |
239411 | 239411 | 2020-06-14 | Hyde | South Dakota | 46069 | 3 | 0 |
242521 | 242521 | 2020-06-15 | Hyde | South Dakota | 46069 | 3 | 0 |
245633 | 245633 | 2020-06-16 | Hyde | South Dakota | 46069 | 3 | 0 |
248746 | 248746 | 2020-06-17 | Hyde | South Dakota | 46069 | 3 | 0 |
251861 | 251861 | 2020-06-18 | Hyde | South Dakota | 46069 | 3 | 0 |
254976 | 254976 | 2020-06-19 | Hyde | South Dakota | 46069 | 3 | 0 |
258102 | 258102 | 2020-06-20 | Hyde | South Dakota | 46069 | 3 | 0 |
261229 | 261229 | 2020-06-21 | Hyde | South Dakota | 46069 | 3 | 0 |
264357 | 264357 | 2020-06-22 | Hyde | South Dakota | 46069 | 3 | 0 |
267485 | 267485 | 2020-06-23 | Hyde | South Dakota | 46069 | 3 | 0 |
270619 | 270619 | 2020-06-24 | Hyde | South Dakota | 46069 | 3 | 0 |
273758 | 273758 | 2020-06-25 | Hyde | South Dakota | 46069 | 3 | 0 |
276905 | 276905 | 2020-06-26 | Hyde | South Dakota | 46069 | 3 | 0 |
280053 | 280053 | 2020-06-27 | Hyde | South Dakota | 46069 | 3 | 0 |
283199 | 283199 | 2020-06-28 | Hyde | South Dakota | 46069 | 3 | 0 |
286344 | 286344 | 2020-06-29 | Hyde | South Dakota | 46069 | 3 | 0 |
289495 | 289495 | 2020-06-30 | Hyde | South Dakota | 46069 | 3 | 0 |
292647 | 292647 | 2020-07-01 | Hyde | South Dakota | 46069 | 3 | 0 |
295803 | 295803 | 2020-07-02 | Hyde | South Dakota | 46069 | 3 | 0 |
298963 | 298963 | 2020-07-03 | Hyde | South Dakota | 46069 | 3 | 0 |
302127 | 302127 | 2020-07-04 | Hyde | South Dakota | 46069 | 3 | 0 |
305290 | 305290 | 2020-07-05 | Hyde | South Dakota | 46069 | 3 | 0 |
308458 | 308458 | 2020-07-06 | Hyde | South Dakota | 46069 | 3 | 0 |
311627 | 311627 | 2020-07-07 | Hyde | South Dakota | 46069 | 3 | 0 |
314800 | 314800 | 2020-07-08 | Hyde | South Dakota | 46069 | 3 | 0 |
317973 | 317973 | 2020-07-09 | Hyde | South Dakota | 46069 | 3 | 0 |
321151 | 321151 | 2020-07-10 | Hyde | South Dakota | 46069 | 3 | 0 |
324331 | 324331 | 2020-07-11 | Hyde | South Dakota | 46069 | 3 | 0 |
327516 | 327516 | 2020-07-12 | Hyde | South Dakota | 46069 | 3 | 0 |
330702 | 330702 | 2020-07-13 | Hyde | South Dakota | 46069 | 3 | 0 |
333894 | 333894 | 2020-07-14 | Hyde | South Dakota | 46069 | 3 | 0 |
337088 | 337088 | 2020-07-15 | Hyde | South Dakota | 46069 | 3 | 0 |
340285 | 340285 | 2020-07-16 | Hyde | South Dakota | 46069 | 3 | 0 |
343483 | 343483 | 2020-07-17 | Hyde | South Dakota | 46069 | 3 | 0 |
346683 | 346683 | 2020-07-18 | Hyde | South Dakota | 46069 | 3 | 0 |
349883 | 349883 | 2020-07-19 | Hyde | South Dakota | 46069 | 3 | 0 |
353086 | 353086 | 2020-07-20 | Hyde | South Dakota | 46069 | 3 | 0 |
356289 | 356289 | 2020-07-21 | Hyde | South Dakota | 46069 | 3 | 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);