ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where cases = 377 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2030374 | 2030374 | 2021-12-19 | Miner | South Dakota | 46097 | 377 | 12 |
2027123 | 2027123 | 2021-12-18 | Miner | South Dakota | 46097 | 377 | 12 |
2023872 | 2023872 | 2021-12-17 | Miner | South Dakota | 46097 | 377 | 12 |
1835356 | 1835356 | 2021-10-20 | Jackson | South Dakota | 46071 | 377 | 16 |
1828858 | 1828858 | 2021-10-18 | Jackson | South Dakota | 46071 | 377 | 16 |
1825609 | 1825609 | 2021-10-17 | Jackson | South Dakota | 46071 | 377 | 16 |
1822360 | 1822360 | 2021-10-16 | Jackson | South Dakota | 46071 | 377 | 16 |
1819111 | 1819111 | 2021-10-15 | Jackson | South Dakota | 46071 | 377 | 16 |
1741152 | 1741152 | 2021-09-21 | Perkins | South Dakota | 46105 | 377 | 14 |
1741165 | 1741165 | 2021-09-21 | Ziebach | South Dakota | 46137 | 377 | 9 |
1737903 | 1737903 | 2021-09-20 | Perkins | South Dakota | 46105 | 377 | 14 |
1734653 | 1734653 | 2021-09-19 | Perkins | South Dakota | 46105 | 377 | 14 |
1731403 | 1731403 | 2021-09-18 | Perkins | South Dakota | 46105 | 377 | 14 |
1728153 | 1728153 | 2021-09-17 | Perkins | South Dakota | 46105 | 377 | 14 |
1715130 | 1715130 | 2021-09-13 | Faulk | South Dakota | 46049 | 377 | 14 |
1711884 | 1711884 | 2021-09-12 | Faulk | South Dakota | 46049 | 377 | 14 |
1708637 | 1708637 | 2021-09-11 | Faulk | South Dakota | 46049 | 377 | 14 |
1705390 | 1705390 | 2021-09-10 | Faulk | South Dakota | 46049 | 377 | 14 |
1702140 | 1702140 | 2021-09-09 | Faulk | South Dakota | 46049 | 377 | 14 |
1698891 | 1698891 | 2021-09-08 | Faulk | South Dakota | 46049 | 377 | 14 |
1695643 | 1695643 | 2021-09-07 | Faulk | South Dakota | 46049 | 377 | 14 |
1692395 | 1692395 | 2021-09-06 | Faulk | South Dakota | 46049 | 377 | 14 |
1689146 | 1689146 | 2021-09-05 | Faulk | South Dakota | 46049 | 377 | 14 |
1685896 | 1685896 | 2021-09-04 | Faulk | South Dakota | 46049 | 377 | 14 |
1682645 | 1682645 | 2021-09-03 | Faulk | South Dakota | 46049 | 377 | 14 |
1679395 | 1679395 | 2021-09-02 | Faulk | South Dakota | 46049 | 377 | 14 |
1676147 | 1676147 | 2021-09-01 | Faulk | South Dakota | 46049 | 377 | 14 |
1672900 | 1672900 | 2021-08-31 | Faulk | South Dakota | 46049 | 377 | 14 |
1669652 | 1669652 | 2021-08-30 | Faulk | South Dakota | 46049 | 377 | 14 |
1666405 | 1666405 | 2021-08-29 | Faulk | South Dakota | 46049 | 377 | 14 |
1663157 | 1663157 | 2021-08-28 | Faulk | South Dakota | 46049 | 377 | 14 |
1659909 | 1659909 | 2021-08-27 | Faulk | South Dakota | 46049 | 377 | 14 |
1653413 | 1653413 | 2021-08-25 | Faulk | South Dakota | 46049 | 377 | 14 |
1124142 | 1124142 | 2021-03-15 | Clark | South Dakota | 46025 | 377 | 5 |
1120896 | 1120896 | 2021-03-14 | Clark | South Dakota | 46025 | 377 | 5 |
1117649 | 1117649 | 2021-03-13 | Clark | South Dakota | 46025 | 377 | 5 |
1114402 | 1114402 | 2021-03-12 | Clark | South Dakota | 46025 | 377 | 5 |
1111156 | 1111156 | 2021-03-11 | Clark | South Dakota | 46025 | 377 | 5 |
1107910 | 1107910 | 2021-03-10 | Clark | South Dakota | 46025 | 377 | 5 |
1098214 | 1098214 | 2021-03-07 | Potter | South Dakota | 46107 | 377 | 4 |
1091720 | 1091720 | 2021-03-05 | Potter | South Dakota | 46107 | 377 | 4 |
1004038 | 1004038 | 2021-02-06 | Bennett | South Dakota | 46007 | 377 | 9 |
1000792 | 1000792 | 2021-02-05 | Bennett | South Dakota | 46007 | 377 | 9 |
997546 | 997546 | 2021-02-04 | Bennett | South Dakota | 46007 | 377 | 9 |
994300 | 994300 | 2021-02-03 | Bennett | South Dakota | 46007 | 377 | 9 |
991054 | 991054 | 2021-02-02 | Bennett | South Dakota | 46007 | 377 | 9 |
987808 | 987808 | 2021-02-01 | Bennett | South Dakota | 46007 | 377 | 9 |
984561 | 984561 | 2021-01-31 | Bennett | South Dakota | 46007 | 377 | 9 |
971578 | 971578 | 2021-01-27 | Bennett | South Dakota | 46007 | 377 | 9 |
968333 | 968333 | 2021-01-26 | Bennett | South Dakota | 46007 | 377 | 9 |
799572 | 799572 | 2020-12-05 | Aurora | South Dakota | 46003 | 377 | 5 |
780110 | 780110 | 2020-11-29 | Buffalo | South Dakota | 46017 | 377 | 8 |
776871 | 776871 | 2020-11-28 | Corson | South Dakota | 46031 | 377 | 5 |
643899 | 643899 | 2020-10-18 | Turner | South Dakota | 46125 | 377 | 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);