ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where cases = 628 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- South Dakota · 42 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2378342 | 2378342 | 2022-04-05 | Jackson | South Dakota | 46071 | 628 | 21 |
2375088 | 2375088 | 2022-04-04 | Jackson | South Dakota | 46071 | 628 | 21 |
2371836 | 2371836 | 2022-04-03 | Jackson | South Dakota | 46071 | 628 | 21 |
2368583 | 2368583 | 2022-04-02 | Jackson | South Dakota | 46071 | 628 | 21 |
2365330 | 2365330 | 2022-04-01 | Jackson | South Dakota | 46071 | 628 | 21 |
2362077 | 2362077 | 2022-03-31 | Jackson | South Dakota | 46071 | 628 | 21 |
2358823 | 2358823 | 2022-03-30 | Jackson | South Dakota | 46071 | 628 | 21 |
2355569 | 2355569 | 2022-03-29 | Jackson | South Dakota | 46071 | 628 | 21 |
2352316 | 2352316 | 2022-03-28 | Jackson | South Dakota | 46071 | 628 | 21 |
2349064 | 2349064 | 2022-03-27 | Jackson | South Dakota | 46071 | 628 | 21 |
2345811 | 2345811 | 2022-03-26 | Jackson | South Dakota | 46071 | 628 | 21 |
2342558 | 2342558 | 2022-03-25 | Jackson | South Dakota | 46071 | 628 | 21 |
2339305 | 2339305 | 2022-03-24 | Jackson | South Dakota | 46071 | 628 | 21 |
2336051 | 2336051 | 2022-03-23 | Jackson | South Dakota | 46071 | 628 | 21 |
2332797 | 2332797 | 2022-03-22 | Jackson | South Dakota | 46071 | 628 | 21 |
2329544 | 2329544 | 2022-03-21 | Jackson | South Dakota | 46071 | 628 | 21 |
2326292 | 2326292 | 2022-03-20 | Jackson | South Dakota | 46071 | 628 | 21 |
2323039 | 2323039 | 2022-03-19 | Jackson | South Dakota | 46071 | 628 | 21 |
2319785 | 2319785 | 2022-03-18 | Jackson | South Dakota | 46071 | 628 | 21 |
2316531 | 2316531 | 2022-03-17 | Jackson | South Dakota | 46071 | 628 | 21 |
2313278 | 2313278 | 2022-03-16 | Jackson | South Dakota | 46071 | 628 | 21 |
2310025 | 2310025 | 2022-03-15 | Jackson | South Dakota | 46071 | 628 | 21 |
2306772 | 2306772 | 2022-03-14 | Jackson | South Dakota | 46071 | 628 | 21 |
2303521 | 2303521 | 2022-03-13 | Jackson | South Dakota | 46071 | 628 | 21 |
2300269 | 2300269 | 2022-03-12 | Jackson | South Dakota | 46071 | 628 | 21 |
2297017 | 2297017 | 2022-03-11 | Jackson | South Dakota | 46071 | 628 | 21 |
1806099 | 1806099 | 2021-10-11 | Deuel | South Dakota | 46039 | 628 | 11 |
1802849 | 1802849 | 2021-10-10 | Deuel | South Dakota | 46039 | 628 | 11 |
1799600 | 1799600 | 2021-10-09 | Deuel | South Dakota | 46039 | 628 | 11 |
1796351 | 1796351 | 2021-10-08 | Deuel | South Dakota | 46039 | 628 | 11 |
1793102 | 1793102 | 2021-10-07 | Deuel | South Dakota | 46039 | 628 | 11 |
1737876 | 1737876 | 2021-09-20 | Gregory | South Dakota | 46053 | 628 | 30 |
1734626 | 1734626 | 2021-09-19 | Gregory | South Dakota | 46053 | 628 | 30 |
1731376 | 1731376 | 2021-09-18 | Gregory | South Dakota | 46053 | 628 | 30 |
1728126 | 1728126 | 2021-09-17 | Gregory | South Dakota | 46053 | 628 | 30 |
1205357 | 1205357 | 2021-04-09 | Lyman | South Dakota | 46085 | 628 | 11 |
1202109 | 1202109 | 2021-04-08 | Lyman | South Dakota | 46085 | 628 | 11 |
1202117 | 1202117 | 2021-04-08 | Moody | South Dakota | 46101 | 628 | 17 |
1192371 | 1192371 | 2021-04-05 | Moody | South Dakota | 46101 | 628 | 17 |
1046263 | 1046263 | 2021-02-19 | Kingsbury | South Dakota | 46077 | 628 | 14 |
890507 | 890507 | 2021-01-02 | Walworth | South Dakota | 46129 | 628 | 14 |
812583 | 812583 | 2020-12-09 | Hutchinson | South Dakota | 46067 | 628 | 13 |
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);