ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where county = "Deuel" and deaths = 7 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 |
---|---|---|---|---|---|---|---|
968349 | 968349 | 2021-01-26 | Deuel | South Dakota | 46039 | 455 | 7 |
965105 | 965105 | 2021-01-25 | Deuel | South Dakota | 46039 | 453 | 7 |
961860 | 961860 | 2021-01-24 | Deuel | South Dakota | 46039 | 453 | 7 |
958615 | 958615 | 2021-01-23 | Deuel | South Dakota | 46039 | 452 | 7 |
955369 | 955369 | 2021-01-22 | Deuel | South Dakota | 46039 | 451 | 7 |
952124 | 952124 | 2021-01-21 | Deuel | South Dakota | 46039 | 450 | 7 |
948879 | 948879 | 2021-01-20 | Deuel | South Dakota | 46039 | 450 | 7 |
945633 | 945633 | 2021-01-19 | Deuel | South Dakota | 46039 | 449 | 7 |
942386 | 942386 | 2021-01-18 | Deuel | South Dakota | 46039 | 449 | 7 |
939141 | 939141 | 2021-01-17 | Deuel | South Dakota | 46039 | 449 | 7 |
935896 | 935896 | 2021-01-16 | Deuel | South Dakota | 46039 | 447 | 7 |
932651 | 932651 | 2021-01-15 | Deuel | South Dakota | 46039 | 447 | 7 |
929406 | 929406 | 2021-01-14 | Deuel | South Dakota | 46039 | 444 | 7 |
926161 | 926161 | 2021-01-13 | Deuel | South Dakota | 46039 | 444 | 7 |
922915 | 922915 | 2021-01-12 | Deuel | South Dakota | 46039 | 439 | 7 |
919670 | 919670 | 2021-01-11 | Deuel | South Dakota | 46039 | 438 | 7 |
916425 | 916425 | 2021-01-10 | Deuel | South Dakota | 46039 | 437 | 7 |
913180 | 913180 | 2021-01-09 | Deuel | South Dakota | 46039 | 433 | 7 |
909935 | 909935 | 2021-01-08 | Deuel | South Dakota | 46039 | 429 | 7 |
906690 | 906690 | 2021-01-07 | Deuel | South Dakota | 46039 | 428 | 7 |
903444 | 903444 | 2021-01-06 | Deuel | South Dakota | 46039 | 425 | 7 |
900199 | 900199 | 2021-01-05 | Deuel | South Dakota | 46039 | 422 | 7 |
896954 | 896954 | 2021-01-04 | Deuel | South Dakota | 46039 | 417 | 7 |
893708 | 893708 | 2021-01-03 | Deuel | South Dakota | 46039 | 417 | 7 |
890462 | 890462 | 2021-01-02 | Deuel | South Dakota | 46039 | 413 | 7 |
887215 | 887215 | 2021-01-01 | Deuel | South Dakota | 46039 | 412 | 7 |
883970 | 883970 | 2020-12-31 | Deuel | South Dakota | 46039 | 412 | 7 |
880725 | 880725 | 2020-12-30 | Deuel | South Dakota | 46039 | 411 | 7 |
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);