ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
745 rows where fips = 46037 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 |
---|---|---|---|---|---|---|---|
100332 | 100332 | 2020-04-29 | Day | South Dakota | 46037 | 1 | 0 |
103185 | 103185 | 2020-04-30 | Day | South Dakota | 46037 | 1 | 0 |
106048 | 106048 | 2020-05-01 | Day | South Dakota | 46037 | 4 | 0 |
108915 | 108915 | 2020-05-02 | Day | South Dakota | 46037 | 8 | 0 |
111789 | 111789 | 2020-05-03 | Day | South Dakota | 46037 | 8 | 0 |
114671 | 114671 | 2020-05-04 | Day | South Dakota | 46037 | 8 | 0 |
117627 | 117627 | 2020-05-05 | Day | South Dakota | 46037 | 8 | 0 |
120589 | 120589 | 2020-05-06 | Day | South Dakota | 46037 | 10 | 0 |
123567 | 123567 | 2020-05-07 | Day | South Dakota | 46037 | 10 | 0 |
126550 | 126550 | 2020-05-08 | Day | South Dakota | 46037 | 10 | 0 |
129539 | 129539 | 2020-05-09 | Day | South Dakota | 46037 | 10 | 0 |
132528 | 132528 | 2020-05-10 | Day | South Dakota | 46037 | 10 | 0 |
135519 | 135519 | 2020-05-11 | Day | South Dakota | 46037 | 10 | 0 |
138509 | 138509 | 2020-05-12 | Day | South Dakota | 46037 | 10 | 0 |
141505 | 141505 | 2020-05-13 | Day | South Dakota | 46037 | 10 | 0 |
144501 | 144501 | 2020-05-14 | Day | South Dakota | 46037 | 10 | 0 |
147502 | 147502 | 2020-05-15 | Day | South Dakota | 46037 | 10 | 0 |
150510 | 150510 | 2020-05-16 | Day | South Dakota | 46037 | 10 | 0 |
153521 | 153521 | 2020-05-17 | Day | South Dakota | 46037 | 11 | 0 |
156538 | 156538 | 2020-05-18 | Day | South Dakota | 46037 | 11 | 0 |
159559 | 159559 | 2020-05-19 | Day | South Dakota | 46037 | 11 | 0 |
162586 | 162586 | 2020-05-20 | Day | South Dakota | 46037 | 11 | 0 |
165615 | 165615 | 2020-05-21 | Day | South Dakota | 46037 | 11 | 0 |
168651 | 168651 | 2020-05-22 | Day | South Dakota | 46037 | 11 | 0 |
171690 | 171690 | 2020-05-23 | Day | South Dakota | 46037 | 12 | 0 |
174732 | 174732 | 2020-05-24 | Day | South Dakota | 46037 | 12 | 0 |
177776 | 177776 | 2020-05-25 | Day | South Dakota | 46037 | 12 | 0 |
180819 | 180819 | 2020-05-26 | Day | South Dakota | 46037 | 12 | 0 |
183869 | 183869 | 2020-05-27 | Day | South Dakota | 46037 | 13 | 0 |
186926 | 186926 | 2020-05-28 | Day | South Dakota | 46037 | 13 | 0 |
189988 | 189988 | 2020-05-29 | Day | South Dakota | 46037 | 13 | 0 |
193053 | 193053 | 2020-05-30 | Day | South Dakota | 46037 | 13 | 0 |
196122 | 196122 | 2020-05-31 | Day | South Dakota | 46037 | 13 | 0 |
199195 | 199195 | 2020-06-01 | Day | South Dakota | 46037 | 13 | 0 |
202270 | 202270 | 2020-06-02 | Day | South Dakota | 46037 | 13 | 0 |
205348 | 205348 | 2020-06-03 | Day | South Dakota | 46037 | 13 | 0 |
208430 | 208430 | 2020-06-04 | Day | South Dakota | 46037 | 14 | 0 |
211512 | 211512 | 2020-06-05 | Day | South Dakota | 46037 | 14 | 0 |
214598 | 214598 | 2020-06-06 | Day | South Dakota | 46037 | 13 | 0 |
217688 | 217688 | 2020-06-07 | Day | South Dakota | 46037 | 13 | 0 |
220780 | 220780 | 2020-06-08 | Day | South Dakota | 46037 | 13 | 0 |
223875 | 223875 | 2020-06-09 | Day | South Dakota | 46037 | 13 | 0 |
226975 | 226975 | 2020-06-10 | Day | South Dakota | 46037 | 13 | 0 |
230079 | 230079 | 2020-06-11 | Day | South Dakota | 46037 | 13 | 0 |
233184 | 233184 | 2020-06-12 | Day | South Dakota | 46037 | 13 | 0 |
236289 | 236289 | 2020-06-13 | Day | South Dakota | 46037 | 13 | 0 |
239397 | 239397 | 2020-06-14 | Day | South Dakota | 46037 | 13 | 0 |
242507 | 242507 | 2020-06-15 | Day | South Dakota | 46037 | 13 | 0 |
245619 | 245619 | 2020-06-16 | Day | South Dakota | 46037 | 13 | 0 |
248732 | 248732 | 2020-06-17 | Day | South Dakota | 46037 | 13 | 0 |
251847 | 251847 | 2020-06-18 | Day | South Dakota | 46037 | 13 | 0 |
254962 | 254962 | 2020-06-19 | Day | South Dakota | 46037 | 13 | 0 |
258088 | 258088 | 2020-06-20 | Day | South Dakota | 46037 | 13 | 0 |
261215 | 261215 | 2020-06-21 | Day | South Dakota | 46037 | 13 | 0 |
264343 | 264343 | 2020-06-22 | Day | South Dakota | 46037 | 13 | 0 |
267471 | 267471 | 2020-06-23 | Day | South Dakota | 46037 | 13 | 0 |
270605 | 270605 | 2020-06-24 | Day | South Dakota | 46037 | 13 | 0 |
273744 | 273744 | 2020-06-25 | Day | South Dakota | 46037 | 13 | 0 |
276891 | 276891 | 2020-06-26 | Day | South Dakota | 46037 | 13 | 0 |
280039 | 280039 | 2020-06-27 | Day | South Dakota | 46037 | 15 | 0 |
283185 | 283185 | 2020-06-28 | Day | South Dakota | 46037 | 16 | 0 |
286330 | 286330 | 2020-06-29 | Day | South Dakota | 46037 | 16 | 0 |
289481 | 289481 | 2020-06-30 | Day | South Dakota | 46037 | 16 | 0 |
292633 | 292633 | 2020-07-01 | Day | South Dakota | 46037 | 16 | 0 |
295789 | 295789 | 2020-07-02 | Day | South Dakota | 46037 | 17 | 0 |
298949 | 298949 | 2020-07-03 | Day | South Dakota | 46037 | 17 | 0 |
302113 | 302113 | 2020-07-04 | Day | South Dakota | 46037 | 17 | 0 |
305276 | 305276 | 2020-07-05 | Day | South Dakota | 46037 | 18 | 0 |
308443 | 308443 | 2020-07-06 | Day | South Dakota | 46037 | 18 | 0 |
311612 | 311612 | 2020-07-07 | Day | South Dakota | 46037 | 19 | 0 |
314785 | 314785 | 2020-07-08 | Day | South Dakota | 46037 | 19 | 0 |
317958 | 317958 | 2020-07-09 | Day | South Dakota | 46037 | 19 | 0 |
321136 | 321136 | 2020-07-10 | Day | South Dakota | 46037 | 19 | 0 |
324316 | 324316 | 2020-07-11 | Day | South Dakota | 46037 | 19 | 0 |
327501 | 327501 | 2020-07-12 | Day | South Dakota | 46037 | 19 | 0 |
330687 | 330687 | 2020-07-13 | Day | South Dakota | 46037 | 19 | 0 |
333879 | 333879 | 2020-07-14 | Day | South Dakota | 46037 | 19 | 0 |
337073 | 337073 | 2020-07-15 | Day | South Dakota | 46037 | 19 | 0 |
340270 | 340270 | 2020-07-16 | Day | South Dakota | 46037 | 19 | 0 |
343468 | 343468 | 2020-07-17 | Day | South Dakota | 46037 | 19 | 0 |
346668 | 346668 | 2020-07-18 | Day | South Dakota | 46037 | 19 | 0 |
349868 | 349868 | 2020-07-19 | Day | South Dakota | 46037 | 19 | 0 |
353071 | 353071 | 2020-07-20 | Day | South Dakota | 46037 | 19 | 0 |
356274 | 356274 | 2020-07-21 | Day | South Dakota | 46037 | 19 | 0 |
359478 | 359478 | 2020-07-22 | Day | South Dakota | 46037 | 20 | 0 |
362684 | 362684 | 2020-07-23 | Day | South Dakota | 46037 | 20 | 0 |
365890 | 365890 | 2020-07-24 | Day | South Dakota | 46037 | 20 | 0 |
369099 | 369099 | 2020-07-25 | Day | South Dakota | 46037 | 21 | 0 |
372311 | 372311 | 2020-07-26 | Day | South Dakota | 46037 | 21 | 0 |
375524 | 375524 | 2020-07-27 | Day | South Dakota | 46037 | 21 | 0 |
378740 | 378740 | 2020-07-28 | Day | South Dakota | 46037 | 21 | 0 |
381957 | 381957 | 2020-07-29 | Day | South Dakota | 46037 | 21 | 0 |
385175 | 385175 | 2020-07-30 | Day | South Dakota | 46037 | 21 | 0 |
388392 | 388392 | 2020-07-31 | Day | South Dakota | 46037 | 21 | 0 |
391609 | 391609 | 2020-08-01 | Day | South Dakota | 46037 | 21 | 0 |
394825 | 394825 | 2020-08-02 | Day | South Dakota | 46037 | 21 | 0 |
398042 | 398042 | 2020-08-03 | Day | South Dakota | 46037 | 21 | 0 |
401257 | 401257 | 2020-08-04 | Day | South Dakota | 46037 | 21 | 0 |
404475 | 404475 | 2020-08-05 | Day | South Dakota | 46037 | 21 | 0 |
407695 | 407695 | 2020-08-06 | Day | South Dakota | 46037 | 21 | 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);