ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where deaths = 57 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
state 1
- South Dakota · 120 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2316561 | 2316561 | 2022-03-17 | Yankton | South Dakota | 46135 | 5901 | 57 |
2313308 | 2313308 | 2022-03-16 | Yankton | South Dakota | 46135 | 5900 | 57 |
2309992 | 2309992 | 2022-03-15 | Beadle | South Dakota | 46005 | 4575 | 57 |
2310055 | 2310055 | 2022-03-15 | Yankton | South Dakota | 46135 | 5899 | 57 |
2306739 | 2306739 | 2022-03-14 | Beadle | South Dakota | 46005 | 4573 | 57 |
2306802 | 2306802 | 2022-03-14 | Yankton | South Dakota | 46135 | 5900 | 57 |
2303488 | 2303488 | 2022-03-13 | Beadle | South Dakota | 46005 | 4573 | 57 |
2303518 | 2303518 | 2022-03-13 | Hughes | South Dakota | 46065 | 4295 | 57 |
2303551 | 2303551 | 2022-03-13 | Yankton | South Dakota | 46135 | 5902 | 57 |
2300236 | 2300236 | 2022-03-12 | Beadle | South Dakota | 46005 | 4573 | 57 |
2300266 | 2300266 | 2022-03-12 | Hughes | South Dakota | 46065 | 4295 | 57 |
2300299 | 2300299 | 2022-03-12 | Yankton | South Dakota | 46135 | 5902 | 57 |
2296984 | 2296984 | 2022-03-11 | Beadle | South Dakota | 46005 | 4573 | 57 |
2297014 | 2297014 | 2022-03-11 | Hughes | South Dakota | 46065 | 4295 | 57 |
2297047 | 2297047 | 2022-03-11 | Yankton | South Dakota | 46135 | 5902 | 57 |
2293732 | 2293732 | 2022-03-10 | Beadle | South Dakota | 46005 | 4571 | 57 |
2293762 | 2293762 | 2022-03-10 | Hughes | South Dakota | 46065 | 4293 | 57 |
2290480 | 2290480 | 2022-03-09 | Beadle | South Dakota | 46005 | 4567 | 57 |
2290510 | 2290510 | 2022-03-09 | Hughes | South Dakota | 46065 | 4292 | 57 |
2287228 | 2287228 | 2022-03-08 | Beadle | South Dakota | 46005 | 4565 | 57 |
2287258 | 2287258 | 2022-03-08 | Hughes | South Dakota | 46065 | 4289 | 57 |
2283976 | 2283976 | 2022-03-07 | Beadle | South Dakota | 46005 | 4565 | 57 |
2218977 | 2218977 | 2022-02-15 | Hughes | South Dakota | 46065 | 4235 | 57 |
2215726 | 2215726 | 2022-02-14 | Hughes | South Dakota | 46065 | 4229 | 57 |
2212475 | 2212475 | 2022-02-13 | Hughes | South Dakota | 46065 | 4227 | 57 |
2209222 | 2209222 | 2022-02-12 | Hughes | South Dakota | 46065 | 4227 | 57 |
2205969 | 2205969 | 2022-02-11 | Hughes | South Dakota | 46065 | 4227 | 57 |
2202716 | 2202716 | 2022-02-10 | Hughes | South Dakota | 46065 | 4221 | 57 |
2199462 | 2199462 | 2022-02-09 | Hughes | South Dakota | 46065 | 4207 | 57 |
2196208 | 2196208 | 2022-02-08 | Hughes | South Dakota | 46065 | 4194 | 57 |
2192954 | 2192954 | 2022-02-07 | Hughes | South Dakota | 46065 | 4187 | 57 |
2189700 | 2189700 | 2022-02-06 | Hughes | South Dakota | 46065 | 4175 | 57 |
2186447 | 2186447 | 2022-02-05 | Hughes | South Dakota | 46065 | 4175 | 57 |
2183195 | 2183195 | 2022-02-04 | Hughes | South Dakota | 46065 | 4175 | 57 |
2179943 | 2179943 | 2022-02-03 | Hughes | South Dakota | 46065 | 4166 | 57 |
2179957 | 2179957 | 2022-02-03 | Meade | South Dakota | 46093 | 6732 | 57 |
2176692 | 2176692 | 2022-02-02 | Hughes | South Dakota | 46065 | 4155 | 57 |
2176706 | 2176706 | 2022-02-02 | Meade | South Dakota | 46093 | 6708 | 57 |
2176711 | 2176711 | 2022-02-02 | Oglala Lakota | South Dakota | 46102 | 3664 | 57 |
2173438 | 2173438 | 2022-02-01 | Hughes | South Dakota | 46065 | 4149 | 57 |
2173452 | 2173452 | 2022-02-01 | Meade | South Dakota | 46093 | 6678 | 57 |
2173457 | 2173457 | 2022-02-01 | Oglala Lakota | South Dakota | 46102 | 3663 | 57 |
2170186 | 2170186 | 2022-01-31 | Hughes | South Dakota | 46065 | 4119 | 57 |
2170200 | 2170200 | 2022-01-31 | Meade | South Dakota | 46093 | 6602 | 57 |
2170205 | 2170205 | 2022-01-31 | Oglala Lakota | South Dakota | 46102 | 3550 | 57 |
2166932 | 2166932 | 2022-01-30 | Hughes | South Dakota | 46065 | 4105 | 57 |
2166946 | 2166946 | 2022-01-30 | Meade | South Dakota | 46093 | 6562 | 57 |
2163677 | 2163677 | 2022-01-29 | Hughes | South Dakota | 46065 | 4105 | 57 |
2163691 | 2163691 | 2022-01-29 | Meade | South Dakota | 46093 | 6562 | 57 |
2160422 | 2160422 | 2022-01-28 | Hughes | South Dakota | 46065 | 4105 | 57 |
2160436 | 2160436 | 2022-01-28 | Meade | South Dakota | 46093 | 6562 | 57 |
2157166 | 2157166 | 2022-01-27 | Hughes | South Dakota | 46065 | 4087 | 57 |
2157180 | 2157180 | 2022-01-27 | Meade | South Dakota | 46093 | 6520 | 57 |
2153913 | 2153913 | 2022-01-26 | Hughes | South Dakota | 46065 | 4063 | 57 |
2153927 | 2153927 | 2022-01-26 | Meade | South Dakota | 46093 | 6461 | 57 |
2150675 | 2150675 | 2022-01-25 | Meade | South Dakota | 46093 | 6397 | 57 |
2147423 | 2147423 | 2022-01-24 | Meade | South Dakota | 46093 | 6282 | 57 |
2144169 | 2144169 | 2022-01-23 | Meade | South Dakota | 46093 | 6217 | 57 |
2140914 | 2140914 | 2022-01-22 | Meade | South Dakota | 46093 | 6217 | 57 |
2137658 | 2137658 | 2022-01-21 | Meade | South Dakota | 46093 | 6217 | 57 |
2108373 | 2108373 | 2022-01-12 | Hughes | South Dakota | 46065 | 3795 | 57 |
1471579 | 1471579 | 2021-06-30 | Turner | South Dakota | 46125 | 1182 | 57 |
1468334 | 1468334 | 2021-06-29 | Turner | South Dakota | 46125 | 1182 | 57 |
1465089 | 1465089 | 2021-06-28 | Turner | South Dakota | 46125 | 1182 | 57 |
1461844 | 1461844 | 2021-06-27 | Turner | South Dakota | 46125 | 1182 | 57 |
1458599 | 1458599 | 2021-06-26 | Turner | South Dakota | 46125 | 1182 | 57 |
1455354 | 1455354 | 2021-06-25 | Turner | South Dakota | 46125 | 1182 | 57 |
1452109 | 1452109 | 2021-06-24 | Turner | South Dakota | 46125 | 1182 | 57 |
1448863 | 1448863 | 2021-06-23 | Turner | South Dakota | 46125 | 1182 | 57 |
1445618 | 1445618 | 2021-06-22 | Turner | South Dakota | 46125 | 1182 | 57 |
1442373 | 1442373 | 2021-06-21 | Turner | South Dakota | 46125 | 1182 | 57 |
1439128 | 1439128 | 2021-06-20 | Turner | South Dakota | 46125 | 1182 | 57 |
1435881 | 1435881 | 2021-06-19 | Turner | South Dakota | 46125 | 1182 | 57 |
1432634 | 1432634 | 2021-06-18 | Turner | South Dakota | 46125 | 1182 | 57 |
1429388 | 1429388 | 2021-06-17 | Turner | South Dakota | 46125 | 1182 | 57 |
1426143 | 1426143 | 2021-06-16 | Turner | South Dakota | 46125 | 1182 | 57 |
1422896 | 1422896 | 2021-06-15 | Turner | South Dakota | 46125 | 1182 | 57 |
1419650 | 1419650 | 2021-06-14 | Turner | South Dakota | 46125 | 1182 | 57 |
1416405 | 1416405 | 2021-06-13 | Turner | South Dakota | 46125 | 1182 | 57 |
1413159 | 1413159 | 2021-06-12 | Turner | South Dakota | 46125 | 1181 | 57 |
1409914 | 1409914 | 2021-06-11 | Turner | South Dakota | 46125 | 1181 | 57 |
1406669 | 1406669 | 2021-06-10 | Turner | South Dakota | 46125 | 1181 | 57 |
1403423 | 1403423 | 2021-06-09 | Turner | South Dakota | 46125 | 1181 | 57 |
1400178 | 1400178 | 2021-06-08 | Turner | South Dakota | 46125 | 1181 | 57 |
1396933 | 1396933 | 2021-06-07 | Turner | South Dakota | 46125 | 1181 | 57 |
1393686 | 1393686 | 2021-06-06 | Turner | South Dakota | 46125 | 1181 | 57 |
1390441 | 1390441 | 2021-06-05 | Turner | South Dakota | 46125 | 1181 | 57 |
1387196 | 1387196 | 2021-06-04 | Turner | South Dakota | 46125 | 1181 | 57 |
1383951 | 1383951 | 2021-06-03 | Turner | South Dakota | 46125 | 1181 | 57 |
1380705 | 1380705 | 2021-06-02 | Turner | South Dakota | 46125 | 1181 | 57 |
1377460 | 1377460 | 2021-06-01 | Turner | South Dakota | 46125 | 1180 | 57 |
1374214 | 1374214 | 2021-05-31 | Turner | South Dakota | 46125 | 1180 | 57 |
1370969 | 1370969 | 2021-05-30 | Turner | South Dakota | 46125 | 1180 | 57 |
1367723 | 1367723 | 2021-05-29 | Turner | South Dakota | 46125 | 1180 | 57 |
1364477 | 1364477 | 2021-05-28 | Turner | South Dakota | 46125 | 1180 | 57 |
968347 | 968347 | 2021-01-26 | Davison | South Dakota | 46035 | 2881 | 57 |
965103 | 965103 | 2021-01-25 | Davison | South Dakota | 46035 | 2879 | 57 |
961858 | 961858 | 2021-01-24 | Davison | South Dakota | 46035 | 2879 | 57 |
958613 | 958613 | 2021-01-23 | Davison | South Dakota | 46035 | 2875 | 57 |
955367 | 955367 | 2021-01-22 | Davison | South Dakota | 46035 | 2868 | 57 |
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);