ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where cases = 453 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2280770 | 2280770 | 2022-03-06 | Miner | South Dakota | 46097 | 453 | 13 |
2277517 | 2277517 | 2022-03-05 | Miner | South Dakota | 46097 | 453 | 13 |
2274264 | 2274264 | 2022-03-04 | Miner | South Dakota | 46097 | 453 | 13 |
2271011 | 2271011 | 2022-03-03 | Miner | South Dakota | 46097 | 453 | 13 |
2267759 | 2267759 | 2022-03-02 | Miner | South Dakota | 46097 | 453 | 13 |
2264506 | 2264506 | 2022-03-01 | Miner | South Dakota | 46097 | 453 | 13 |
2261256 | 2261256 | 2022-02-28 | Miner | South Dakota | 46097 | 453 | 13 |
2258005 | 2258005 | 2022-02-27 | Miner | South Dakota | 46097 | 453 | 13 |
2254754 | 2254754 | 2022-02-26 | Miner | South Dakota | 46097 | 453 | 13 |
2251503 | 2251503 | 2022-02-25 | Miner | South Dakota | 46097 | 453 | 13 |
2248252 | 2248252 | 2022-02-24 | Miner | South Dakota | 46097 | 453 | 13 |
2245001 | 2245001 | 2022-02-23 | Miner | South Dakota | 46097 | 453 | 13 |
2241750 | 2241750 | 2022-02-22 | Miner | South Dakota | 46097 | 453 | 13 |
2225495 | 2225495 | 2022-02-17 | Miner | South Dakota | 46097 | 453 | 13 |
2222244 | 2222244 | 2022-02-16 | Miner | South Dakota | 46097 | 453 | 13 |
2218993 | 2218993 | 2022-02-15 | Miner | South Dakota | 46097 | 453 | 12 |
2075882 | 2075882 | 2022-01-02 | Sanborn | South Dakota | 46111 | 453 | 3 |
2072631 | 2072631 | 2022-01-01 | Sanborn | South Dakota | 46111 | 453 | 3 |
2069380 | 2069380 | 2021-12-31 | Sanborn | South Dakota | 46111 | 453 | 3 |
2066129 | 2066129 | 2021-12-30 | Sanborn | South Dakota | 46111 | 453 | 3 |
2010845 | 2010845 | 2021-12-13 | Faulk | South Dakota | 46049 | 453 | 15 |
1929586 | 1929586 | 2021-11-18 | Hanson | South Dakota | 46061 | 453 | 5 |
1926372 | 1926372 | 2021-11-17 | Ziebach | South Dakota | 46137 | 453 | 10 |
1923122 | 1923122 | 2021-11-16 | Ziebach | South Dakota | 46137 | 453 | 10 |
1880818 | 1880818 | 2021-11-03 | Buffalo | South Dakota | 46017 | 453 | 14 |
1267028 | 1267028 | 2021-04-28 | Clark | South Dakota | 46025 | 453 | 5 |
1244308 | 1244308 | 2021-04-21 | Douglas | South Dakota | 46043 | 453 | 9 |
1241061 | 1241061 | 2021-04-20 | Douglas | South Dakota | 46043 | 453 | 9 |
1237814 | 1237814 | 2021-04-19 | Douglas | South Dakota | 46043 | 453 | 9 |
1234567 | 1234567 | 2021-04-18 | Douglas | South Dakota | 46043 | 453 | 9 |
1231319 | 1231319 | 2021-04-17 | Douglas | South Dakota | 46043 | 453 | 9 |
1107899 | 1107899 | 2021-03-10 | Aurora | South Dakota | 46003 | 453 | 15 |
1091667 | 1091667 | 2021-03-05 | Aurora | South Dakota | 46003 | 453 | 15 |
1081930 | 1081930 | 2021-03-02 | Aurora | South Dakota | 46003 | 453 | 15 |
1078684 | 1078684 | 2021-03-01 | Aurora | South Dakota | 46003 | 453 | 15 |
1075439 | 1075439 | 2021-02-28 | Aurora | South Dakota | 46003 | 453 | 15 |
1072193 | 1072193 | 2021-02-27 | Aurora | South Dakota | 46003 | 453 | 15 |
1068947 | 1068947 | 2021-02-26 | Aurora | South Dakota | 46003 | 453 | 15 |
1065702 | 1065702 | 2021-02-25 | Aurora | South Dakota | 46003 | 453 | 15 |
1062457 | 1062457 | 2021-02-24 | Aurora | South Dakota | 46003 | 453 | 15 |
1059212 | 1059212 | 2021-02-23 | Aurora | South Dakota | 46003 | 453 | 15 |
965105 | 965105 | 2021-01-25 | Deuel | South Dakota | 46039 | 453 | 7 |
965108 | 965108 | 2021-01-25 | Edmunds | South Dakota | 46045 | 453 | 8 |
961860 | 961860 | 2021-01-24 | Deuel | South Dakota | 46039 | 453 | 7 |
919666 | 919666 | 2021-01-11 | Corson | South Dakota | 46031 | 453 | 11 |
916421 | 916421 | 2021-01-10 | Corson | South Dakota | 46031 | 453 | 11 |
913176 | 913176 | 2021-01-09 | Corson | South Dakota | 46031 | 453 | 11 |
909931 | 909931 | 2021-01-08 | Corson | South Dakota | 46031 | 453 | 11 |
890458 | 890458 | 2021-01-02 | Corson | South Dakota | 46031 | 453 | 11 |
812576 | 812576 | 2020-12-09 | Gregory | South Dakota | 46053 | 453 | 23 |
806087 | 806087 | 2020-12-07 | Gregory | South Dakota | 46053 | 453 | 23 |
802866 | 802866 | 2020-12-06 | Moody | South Dakota | 46101 | 453 | 12 |
728217 | 728217 | 2020-11-13 | McCook | South Dakota | 46087 | 453 | 3 |
708767 | 708767 | 2020-11-07 | Roberts | South Dakota | 46109 | 453 | 8 |
695750 | 695750 | 2020-11-03 | Charles Mix | South Dakota | 46023 | 453 | 1 |
692536 | 692536 | 2020-11-02 | Lake | South Dakota | 46079 | 453 | 9 |
676339 | 676339 | 2020-10-28 | Todd | South Dakota | 46121 | 453 | 6 |
673098 | 673098 | 2020-10-27 | Turner | South Dakota | 46125 | 453 | 11 |
582254 | 582254 | 2020-09-29 | Hughes | South Dakota | 46065 | 453 | 5 |
553108 | 553108 | 2020-09-20 | Meade | South Dakota | 46093 | 453 | 4 |
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);