ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where fips = 46111 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 |
---|---|---|---|---|---|---|---|
50482 | 50482 | 2020-04-11 | Sanborn | South Dakota | 46111 | 1 | 0 |
53155 | 53155 | 2020-04-12 | Sanborn | South Dakota | 46111 | 1 | 0 |
55841 | 55841 | 2020-04-13 | Sanborn | South Dakota | 46111 | 2 | 0 |
58544 | 58544 | 2020-04-14 | Sanborn | South Dakota | 46111 | 2 | 0 |
61259 | 61259 | 2020-04-15 | Sanborn | South Dakota | 46111 | 3 | 0 |
63986 | 63986 | 2020-04-16 | Sanborn | South Dakota | 46111 | 3 | 0 |
66732 | 66732 | 2020-04-17 | Sanborn | South Dakota | 46111 | 3 | 0 |
69490 | 69490 | 2020-04-18 | Sanborn | South Dakota | 46111 | 3 | 0 |
72257 | 72257 | 2020-04-19 | Sanborn | South Dakota | 46111 | 3 | 0 |
75032 | 75032 | 2020-04-20 | Sanborn | South Dakota | 46111 | 3 | 0 |
77814 | 77814 | 2020-04-21 | Sanborn | South Dakota | 46111 | 3 | 0 |
80604 | 80604 | 2020-04-22 | Sanborn | South Dakota | 46111 | 3 | 0 |
83403 | 83403 | 2020-04-23 | Sanborn | South Dakota | 46111 | 3 | 0 |
86207 | 86207 | 2020-04-24 | Sanborn | South Dakota | 46111 | 3 | 0 |
89022 | 89022 | 2020-04-25 | Sanborn | South Dakota | 46111 | 3 | 0 |
91839 | 91839 | 2020-04-26 | Sanborn | South Dakota | 46111 | 3 | 0 |
94667 | 94667 | 2020-04-27 | Sanborn | South Dakota | 46111 | 3 | 0 |
97507 | 97507 | 2020-04-28 | Sanborn | South Dakota | 46111 | 3 | 0 |
100357 | 100357 | 2020-04-29 | Sanborn | South Dakota | 46111 | 3 | 0 |
103210 | 103210 | 2020-04-30 | Sanborn | South Dakota | 46111 | 3 | 0 |
106073 | 106073 | 2020-05-01 | Sanborn | South Dakota | 46111 | 3 | 0 |
108940 | 108940 | 2020-05-02 | Sanborn | South Dakota | 46111 | 3 | 0 |
111814 | 111814 | 2020-05-03 | Sanborn | South Dakota | 46111 | 3 | 0 |
114696 | 114696 | 2020-05-04 | Sanborn | South Dakota | 46111 | 3 | 0 |
117652 | 117652 | 2020-05-05 | Sanborn | South Dakota | 46111 | 3 | 0 |
120615 | 120615 | 2020-05-06 | Sanborn | South Dakota | 46111 | 3 | 0 |
123593 | 123593 | 2020-05-07 | Sanborn | South Dakota | 46111 | 3 | 0 |
126576 | 126576 | 2020-05-08 | Sanborn | South Dakota | 46111 | 3 | 0 |
129565 | 129565 | 2020-05-09 | Sanborn | South Dakota | 46111 | 3 | 0 |
132554 | 132554 | 2020-05-10 | Sanborn | South Dakota | 46111 | 3 | 0 |
135545 | 135545 | 2020-05-11 | Sanborn | South Dakota | 46111 | 3 | 0 |
138535 | 138535 | 2020-05-12 | Sanborn | South Dakota | 46111 | 3 | 0 |
141531 | 141531 | 2020-05-13 | Sanborn | South Dakota | 46111 | 3 | 0 |
144527 | 144527 | 2020-05-14 | Sanborn | South Dakota | 46111 | 3 | 0 |
147528 | 147528 | 2020-05-15 | Sanborn | South Dakota | 46111 | 4 | 0 |
150536 | 150536 | 2020-05-16 | Sanborn | South Dakota | 46111 | 5 | 0 |
153547 | 153547 | 2020-05-17 | Sanborn | South Dakota | 46111 | 5 | 0 |
156564 | 156564 | 2020-05-18 | Sanborn | South Dakota | 46111 | 6 | 0 |
159585 | 159585 | 2020-05-19 | Sanborn | South Dakota | 46111 | 6 | 0 |
162612 | 162612 | 2020-05-20 | Sanborn | South Dakota | 46111 | 7 | 0 |
165641 | 165641 | 2020-05-21 | Sanborn | South Dakota | 46111 | 7 | 0 |
168677 | 168677 | 2020-05-22 | Sanborn | South Dakota | 46111 | 8 | 0 |
171716 | 171716 | 2020-05-23 | Sanborn | South Dakota | 46111 | 9 | 0 |
174759 | 174759 | 2020-05-24 | Sanborn | South Dakota | 46111 | 10 | 0 |
177803 | 177803 | 2020-05-25 | Sanborn | South Dakota | 46111 | 11 | 0 |
180846 | 180846 | 2020-05-26 | Sanborn | South Dakota | 46111 | 11 | 0 |
183896 | 183896 | 2020-05-27 | Sanborn | South Dakota | 46111 | 11 | 0 |
186953 | 186953 | 2020-05-28 | Sanborn | South Dakota | 46111 | 12 | 0 |
190017 | 190017 | 2020-05-29 | Sanborn | South Dakota | 46111 | 12 | 0 |
193082 | 193082 | 2020-05-30 | Sanborn | South Dakota | 46111 | 13 | 0 |
196152 | 196152 | 2020-05-31 | Sanborn | South Dakota | 46111 | 13 | 0 |
199225 | 199225 | 2020-06-01 | Sanborn | South Dakota | 46111 | 13 | 0 |
202300 | 202300 | 2020-06-02 | Sanborn | South Dakota | 46111 | 13 | 0 |
205379 | 205379 | 2020-06-03 | Sanborn | South Dakota | 46111 | 13 | 0 |
208461 | 208461 | 2020-06-04 | Sanborn | South Dakota | 46111 | 13 | 0 |
211543 | 211543 | 2020-06-05 | Sanborn | South Dakota | 46111 | 13 | 0 |
214630 | 214630 | 2020-06-06 | Sanborn | South Dakota | 46111 | 13 | 0 |
217720 | 217720 | 2020-06-07 | Sanborn | South Dakota | 46111 | 13 | 0 |
220812 | 220812 | 2020-06-08 | Sanborn | South Dakota | 46111 | 13 | 0 |
223907 | 223907 | 2020-06-09 | Sanborn | South Dakota | 46111 | 13 | 0 |
227007 | 227007 | 2020-06-10 | Sanborn | South Dakota | 46111 | 13 | 0 |
230111 | 230111 | 2020-06-11 | Sanborn | South Dakota | 46111 | 13 | 0 |
233216 | 233216 | 2020-06-12 | Sanborn | South Dakota | 46111 | 13 | 0 |
236322 | 236322 | 2020-06-13 | Sanborn | South Dakota | 46111 | 13 | 0 |
239430 | 239430 | 2020-06-14 | Sanborn | South Dakota | 46111 | 13 | 0 |
242540 | 242540 | 2020-06-15 | Sanborn | South Dakota | 46111 | 13 | 0 |
245652 | 245652 | 2020-06-16 | Sanborn | South Dakota | 46111 | 13 | 0 |
248765 | 248765 | 2020-06-17 | Sanborn | South Dakota | 46111 | 13 | 0 |
251880 | 251880 | 2020-06-18 | Sanborn | South Dakota | 46111 | 13 | 0 |
254995 | 254995 | 2020-06-19 | Sanborn | South Dakota | 46111 | 12 | 0 |
258121 | 258121 | 2020-06-20 | Sanborn | South Dakota | 46111 | 12 | 0 |
261248 | 261248 | 2020-06-21 | Sanborn | South Dakota | 46111 | 12 | 0 |
264376 | 264376 | 2020-06-22 | Sanborn | South Dakota | 46111 | 12 | 0 |
267504 | 267504 | 2020-06-23 | Sanborn | South Dakota | 46111 | 12 | 0 |
270638 | 270638 | 2020-06-24 | Sanborn | South Dakota | 46111 | 12 | 0 |
273777 | 273777 | 2020-06-25 | Sanborn | South Dakota | 46111 | 12 | 0 |
276924 | 276924 | 2020-06-26 | Sanborn | South Dakota | 46111 | 12 | 0 |
280072 | 280072 | 2020-06-27 | Sanborn | South Dakota | 46111 | 12 | 0 |
283218 | 283218 | 2020-06-28 | Sanborn | South Dakota | 46111 | 12 | 0 |
286363 | 286363 | 2020-06-29 | Sanborn | South Dakota | 46111 | 12 | 0 |
289514 | 289514 | 2020-06-30 | Sanborn | South Dakota | 46111 | 12 | 0 |
292666 | 292666 | 2020-07-01 | Sanborn | South Dakota | 46111 | 12 | 0 |
295822 | 295822 | 2020-07-02 | Sanborn | South Dakota | 46111 | 12 | 0 |
298982 | 298982 | 2020-07-03 | Sanborn | South Dakota | 46111 | 12 | 0 |
302146 | 302146 | 2020-07-04 | Sanborn | South Dakota | 46111 | 12 | 0 |
305309 | 305309 | 2020-07-05 | Sanborn | South Dakota | 46111 | 12 | 0 |
308477 | 308477 | 2020-07-06 | Sanborn | South Dakota | 46111 | 12 | 0 |
311646 | 311646 | 2020-07-07 | Sanborn | South Dakota | 46111 | 12 | 0 |
314820 | 314820 | 2020-07-08 | Sanborn | South Dakota | 46111 | 12 | 0 |
317993 | 317993 | 2020-07-09 | Sanborn | South Dakota | 46111 | 12 | 0 |
321171 | 321171 | 2020-07-10 | Sanborn | South Dakota | 46111 | 12 | 0 |
324352 | 324352 | 2020-07-11 | Sanborn | South Dakota | 46111 | 12 | 0 |
327537 | 327537 | 2020-07-12 | Sanborn | South Dakota | 46111 | 12 | 0 |
330723 | 330723 | 2020-07-13 | Sanborn | South Dakota | 46111 | 12 | 0 |
333915 | 333915 | 2020-07-14 | Sanborn | South Dakota | 46111 | 12 | 0 |
337109 | 337109 | 2020-07-15 | Sanborn | South Dakota | 46111 | 12 | 0 |
340306 | 340306 | 2020-07-16 | Sanborn | South Dakota | 46111 | 12 | 0 |
343504 | 343504 | 2020-07-17 | Sanborn | South Dakota | 46111 | 12 | 0 |
346704 | 346704 | 2020-07-18 | Sanborn | South Dakota | 46111 | 12 | 0 |
349904 | 349904 | 2020-07-19 | Sanborn | South Dakota | 46111 | 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);