ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
707 rows where fips = 46041 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 |
---|---|---|---|---|---|---|---|
214600 | 214600 | 2020-06-06 | Dewey | South Dakota | 46041 | 1 | 0 |
217690 | 217690 | 2020-06-07 | Dewey | South Dakota | 46041 | 1 | 0 |
220782 | 220782 | 2020-06-08 | Dewey | South Dakota | 46041 | 1 | 0 |
223877 | 223877 | 2020-06-09 | Dewey | South Dakota | 46041 | 1 | 0 |
226977 | 226977 | 2020-06-10 | Dewey | South Dakota | 46041 | 1 | 0 |
230081 | 230081 | 2020-06-11 | Dewey | South Dakota | 46041 | 2 | 0 |
233186 | 233186 | 2020-06-12 | Dewey | South Dakota | 46041 | 2 | 0 |
236291 | 236291 | 2020-06-13 | Dewey | South Dakota | 46041 | 2 | 0 |
239399 | 239399 | 2020-06-14 | Dewey | South Dakota | 46041 | 2 | 0 |
242509 | 242509 | 2020-06-15 | Dewey | South Dakota | 46041 | 2 | 0 |
245621 | 245621 | 2020-06-16 | Dewey | South Dakota | 46041 | 4 | 0 |
248734 | 248734 | 2020-06-17 | Dewey | South Dakota | 46041 | 4 | 0 |
251849 | 251849 | 2020-06-18 | Dewey | South Dakota | 46041 | 4 | 0 |
254964 | 254964 | 2020-06-19 | Dewey | South Dakota | 46041 | 4 | 0 |
258090 | 258090 | 2020-06-20 | Dewey | South Dakota | 46041 | 4 | 0 |
261217 | 261217 | 2020-06-21 | Dewey | South Dakota | 46041 | 4 | 0 |
264345 | 264345 | 2020-06-22 | Dewey | South Dakota | 46041 | 4 | 0 |
267473 | 267473 | 2020-06-23 | Dewey | South Dakota | 46041 | 4 | 0 |
270607 | 270607 | 2020-06-24 | Dewey | South Dakota | 46041 | 4 | 0 |
273746 | 273746 | 2020-06-25 | Dewey | South Dakota | 46041 | 4 | 0 |
276893 | 276893 | 2020-06-26 | Dewey | South Dakota | 46041 | 4 | 0 |
280041 | 280041 | 2020-06-27 | Dewey | South Dakota | 46041 | 4 | 0 |
283187 | 283187 | 2020-06-28 | Dewey | South Dakota | 46041 | 4 | 0 |
286332 | 286332 | 2020-06-29 | Dewey | South Dakota | 46041 | 4 | 0 |
289483 | 289483 | 2020-06-30 | Dewey | South Dakota | 46041 | 4 | 0 |
292635 | 292635 | 2020-07-01 | Dewey | South Dakota | 46041 | 5 | 0 |
295791 | 295791 | 2020-07-02 | Dewey | South Dakota | 46041 | 6 | 0 |
298951 | 298951 | 2020-07-03 | Dewey | South Dakota | 46041 | 8 | 0 |
302115 | 302115 | 2020-07-04 | Dewey | South Dakota | 46041 | 8 | 0 |
305278 | 305278 | 2020-07-05 | Dewey | South Dakota | 46041 | 8 | 0 |
308445 | 308445 | 2020-07-06 | Dewey | South Dakota | 46041 | 8 | 0 |
311614 | 311614 | 2020-07-07 | Dewey | South Dakota | 46041 | 9 | 0 |
314787 | 314787 | 2020-07-08 | Dewey | South Dakota | 46041 | 12 | 0 |
317960 | 317960 | 2020-07-09 | Dewey | South Dakota | 46041 | 27 | 0 |
321138 | 321138 | 2020-07-10 | Dewey | South Dakota | 46041 | 33 | 0 |
324318 | 324318 | 2020-07-11 | Dewey | South Dakota | 46041 | 33 | 0 |
327503 | 327503 | 2020-07-12 | Dewey | South Dakota | 46041 | 35 | 0 |
330689 | 330689 | 2020-07-13 | Dewey | South Dakota | 46041 | 37 | 0 |
333881 | 333881 | 2020-07-14 | Dewey | South Dakota | 46041 | 37 | 0 |
337075 | 337075 | 2020-07-15 | Dewey | South Dakota | 46041 | 38 | 0 |
340272 | 340272 | 2020-07-16 | Dewey | South Dakota | 46041 | 40 | 0 |
343470 | 343470 | 2020-07-17 | Dewey | South Dakota | 46041 | 42 | 0 |
346670 | 346670 | 2020-07-18 | Dewey | South Dakota | 46041 | 42 | 0 |
349870 | 349870 | 2020-07-19 | Dewey | South Dakota | 46041 | 45 | 0 |
353073 | 353073 | 2020-07-20 | Dewey | South Dakota | 46041 | 45 | 0 |
356276 | 356276 | 2020-07-21 | Dewey | South Dakota | 46041 | 45 | 0 |
359480 | 359480 | 2020-07-22 | Dewey | South Dakota | 46041 | 47 | 0 |
362686 | 362686 | 2020-07-23 | Dewey | South Dakota | 46041 | 49 | 0 |
365892 | 365892 | 2020-07-24 | Dewey | South Dakota | 46041 | 52 | 0 |
369101 | 369101 | 2020-07-25 | Dewey | South Dakota | 46041 | 53 | 0 |
372313 | 372313 | 2020-07-26 | Dewey | South Dakota | 46041 | 53 | 0 |
375526 | 375526 | 2020-07-27 | Dewey | South Dakota | 46041 | 53 | 0 |
378742 | 378742 | 2020-07-28 | Dewey | South Dakota | 46041 | 53 | 0 |
381959 | 381959 | 2020-07-29 | Dewey | South Dakota | 46041 | 54 | 0 |
385177 | 385177 | 2020-07-30 | Dewey | South Dakota | 46041 | 56 | 0 |
388394 | 388394 | 2020-07-31 | Dewey | South Dakota | 46041 | 58 | 0 |
391611 | 391611 | 2020-08-01 | Dewey | South Dakota | 46041 | 59 | 0 |
394827 | 394827 | 2020-08-02 | Dewey | South Dakota | 46041 | 59 | 0 |
398044 | 398044 | 2020-08-03 | Dewey | South Dakota | 46041 | 61 | 0 |
401259 | 401259 | 2020-08-04 | Dewey | South Dakota | 46041 | 63 | 0 |
404477 | 404477 | 2020-08-05 | Dewey | South Dakota | 46041 | 64 | 0 |
407697 | 407697 | 2020-08-06 | Dewey | South Dakota | 46041 | 65 | 0 |
410916 | 410916 | 2020-08-07 | Dewey | South Dakota | 46041 | 50 | 0 |
414136 | 414136 | 2020-08-08 | Dewey | South Dakota | 46041 | 49 | 0 |
417357 | 417357 | 2020-08-09 | Dewey | South Dakota | 46041 | 48 | 0 |
420578 | 420578 | 2020-08-10 | Dewey | South Dakota | 46041 | 48 | 0 |
423800 | 423800 | 2020-08-11 | Dewey | South Dakota | 46041 | 48 | 0 |
427023 | 427023 | 2020-08-12 | Dewey | South Dakota | 46041 | 49 | 0 |
430249 | 430249 | 2020-08-13 | Dewey | South Dakota | 46041 | 49 | 0 |
433474 | 433474 | 2020-08-14 | Dewey | South Dakota | 46041 | 57 | 0 |
436701 | 436701 | 2020-08-15 | Dewey | South Dakota | 46041 | 57 | 0 |
439926 | 439926 | 2020-08-16 | Dewey | South Dakota | 46041 | 58 | 0 |
443153 | 443153 | 2020-08-17 | Dewey | South Dakota | 46041 | 59 | 0 |
446379 | 446379 | 2020-08-18 | Dewey | South Dakota | 46041 | 59 | 0 |
449607 | 449607 | 2020-08-19 | Dewey | South Dakota | 46041 | 60 | 0 |
452835 | 452835 | 2020-08-20 | Dewey | South Dakota | 46041 | 61 | 0 |
456063 | 456063 | 2020-08-21 | Dewey | South Dakota | 46041 | 62 | 0 |
459291 | 459291 | 2020-08-22 | Dewey | South Dakota | 46041 | 64 | 0 |
462519 | 462519 | 2020-08-23 | Dewey | South Dakota | 46041 | 65 | 0 |
465748 | 465748 | 2020-08-24 | Dewey | South Dakota | 46041 | 65 | 0 |
468976 | 468976 | 2020-08-25 | Dewey | South Dakota | 46041 | 65 | 0 |
472208 | 472208 | 2020-08-26 | Dewey | South Dakota | 46041 | 68 | 0 |
475442 | 475442 | 2020-08-27 | Dewey | South Dakota | 46041 | 72 | 0 |
478675 | 478675 | 2020-08-28 | Dewey | South Dakota | 46041 | 73 | 0 |
481909 | 481909 | 2020-08-29 | Dewey | South Dakota | 46041 | 77 | 0 |
485144 | 485144 | 2020-08-30 | Dewey | South Dakota | 46041 | 79 | 0 |
488377 | 488377 | 2020-08-31 | Dewey | South Dakota | 46041 | 79 | 0 |
491610 | 491610 | 2020-09-01 | Dewey | South Dakota | 46041 | 82 | 0 |
494844 | 494844 | 2020-09-02 | Dewey | South Dakota | 46041 | 84 | 0 |
498077 | 498077 | 2020-09-03 | Dewey | South Dakota | 46041 | 89 | 0 |
501311 | 501311 | 2020-09-04 | Dewey | South Dakota | 46041 | 92 | 0 |
504545 | 504545 | 2020-09-05 | Dewey | South Dakota | 46041 | 91 | 0 |
507777 | 507777 | 2020-09-06 | Dewey | South Dakota | 46041 | 93 | 0 |
511010 | 511010 | 2020-09-07 | Dewey | South Dakota | 46041 | 93 | 0 |
514243 | 514243 | 2020-09-08 | Dewey | South Dakota | 46041 | 93 | 0 |
517478 | 517478 | 2020-09-09 | Dewey | South Dakota | 46041 | 95 | 0 |
520714 | 520714 | 2020-09-10 | Dewey | South Dakota | 46041 | 101 | 0 |
523950 | 523950 | 2020-09-11 | Dewey | South Dakota | 46041 | 102 | 0 |
527186 | 527186 | 2020-09-12 | Dewey | South Dakota | 46041 | 103 | 0 |
530423 | 530423 | 2020-09-13 | Dewey | South Dakota | 46041 | 103 | 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);