ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where deaths = 8, fips = 46007 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955353 | 955353 | 2021-01-22 | Bennett | South Dakota | 46007 | 376 | 8 |
952108 | 952108 | 2021-01-21 | Bennett | South Dakota | 46007 | 373 | 8 |
948863 | 948863 | 2021-01-20 | Bennett | South Dakota | 46007 | 374 | 8 |
945617 | 945617 | 2021-01-19 | Bennett | South Dakota | 46007 | 372 | 8 |
942370 | 942370 | 2021-01-18 | Bennett | South Dakota | 46007 | 372 | 8 |
939125 | 939125 | 2021-01-17 | Bennett | South Dakota | 46007 | 372 | 8 |
935880 | 935880 | 2021-01-16 | Bennett | South Dakota | 46007 | 371 | 8 |
932635 | 932635 | 2021-01-15 | Bennett | South Dakota | 46007 | 370 | 8 |
929390 | 929390 | 2021-01-14 | Bennett | South Dakota | 46007 | 370 | 8 |
926145 | 926145 | 2021-01-13 | Bennett | South Dakota | 46007 | 370 | 8 |
922899 | 922899 | 2021-01-12 | Bennett | South Dakota | 46007 | 369 | 8 |
919654 | 919654 | 2021-01-11 | Bennett | South Dakota | 46007 | 369 | 8 |
916409 | 916409 | 2021-01-10 | Bennett | South Dakota | 46007 | 367 | 8 |
913164 | 913164 | 2021-01-09 | Bennett | South Dakota | 46007 | 362 | 8 |
909919 | 909919 | 2021-01-08 | Bennett | South Dakota | 46007 | 363 | 8 |
906674 | 906674 | 2021-01-07 | Bennett | South Dakota | 46007 | 361 | 8 |
903428 | 903428 | 2021-01-06 | Bennett | South Dakota | 46007 | 360 | 8 |
900183 | 900183 | 2021-01-05 | Bennett | South Dakota | 46007 | 356 | 8 |
896938 | 896938 | 2021-01-04 | Bennett | South Dakota | 46007 | 355 | 8 |
893692 | 893692 | 2021-01-03 | Bennett | South Dakota | 46007 | 355 | 8 |
890446 | 890446 | 2021-01-02 | Bennett | South Dakota | 46007 | 356 | 8 |
887199 | 887199 | 2021-01-01 | Bennett | South Dakota | 46007 | 355 | 8 |
883954 | 883954 | 2020-12-31 | Bennett | South Dakota | 46007 | 355 | 8 |
880709 | 880709 | 2020-12-30 | Bennett | South Dakota | 46007 | 354 | 8 |
877464 | 877464 | 2020-12-29 | Bennett | South Dakota | 46007 | 353 | 8 |
874219 | 874219 | 2020-12-28 | Bennett | South Dakota | 46007 | 351 | 8 |
870974 | 870974 | 2020-12-27 | Bennett | South Dakota | 46007 | 351 | 8 |
867729 | 867729 | 2020-12-26 | Bennett | South Dakota | 46007 | 351 | 8 |
864484 | 864484 | 2020-12-25 | Bennett | South Dakota | 46007 | 351 | 8 |
861239 | 861239 | 2020-12-24 | Bennett | South Dakota | 46007 | 351 | 8 |
857994 | 857994 | 2020-12-23 | Bennett | South Dakota | 46007 | 351 | 8 |
854749 | 854749 | 2020-12-22 | Bennett | South Dakota | 46007 | 347 | 8 |
851504 | 851504 | 2020-12-21 | Bennett | South Dakota | 46007 | 347 | 8 |
848259 | 848259 | 2020-12-20 | Bennett | South Dakota | 46007 | 347 | 8 |
845014 | 845014 | 2020-12-19 | Bennett | South Dakota | 46007 | 347 | 8 |
841768 | 841768 | 2020-12-18 | Bennett | South Dakota | 46007 | 346 | 8 |
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);