ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 46121 and state = "South Dakota" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
15430 | 15430 | 2020-03-27 | Todd | South Dakota | 46121 | 1 | 0 |
17288 | 17288 | 2020-03-28 | Todd | South Dakota | 46121 | 1 | 0 |
19232 | 19232 | 2020-03-29 | Todd | South Dakota | 46121 | 1 | 0 |
21285 | 21285 | 2020-03-30 | Todd | South Dakota | 46121 | 1 | 0 |
23423 | 23423 | 2020-03-31 | Todd | South Dakota | 46121 | 1 | 0 |
25621 | 25621 | 2020-04-01 | Todd | South Dakota | 46121 | 1 | 0 |
27899 | 27899 | 2020-04-02 | Todd | South Dakota | 46121 | 1 | 0 |
30234 | 30234 | 2020-04-03 | Todd | South Dakota | 46121 | 1 | 0 |
32625 | 32625 | 2020-04-04 | Todd | South Dakota | 46121 | 1 | 0 |
35061 | 35061 | 2020-04-05 | Todd | South Dakota | 46121 | 1 | 0 |
37536 | 37536 | 2020-04-06 | Todd | South Dakota | 46121 | 1 | 0 |
40059 | 40059 | 2020-04-07 | Todd | South Dakota | 46121 | 1 | 0 |
42620 | 42620 | 2020-04-08 | Todd | South Dakota | 46121 | 1 | 0 |
45208 | 45208 | 2020-04-09 | Todd | South Dakota | 46121 | 1 | 0 |
47826 | 47826 | 2020-04-10 | Todd | South Dakota | 46121 | 1 | 0 |
50484 | 50484 | 2020-04-11 | Todd | South Dakota | 46121 | 1 | 0 |
53158 | 53158 | 2020-04-12 | Todd | South Dakota | 46121 | 1 | 0 |
55844 | 55844 | 2020-04-13 | Todd | South Dakota | 46121 | 1 | 0 |
58547 | 58547 | 2020-04-14 | Todd | South Dakota | 46121 | 1 | 0 |
61262 | 61262 | 2020-04-15 | Todd | South Dakota | 46121 | 1 | 0 |
63989 | 63989 | 2020-04-16 | Todd | South Dakota | 46121 | 1 | 0 |
66735 | 66735 | 2020-04-17 | Todd | South Dakota | 46121 | 1 | 0 |
69493 | 69493 | 2020-04-18 | Todd | South Dakota | 46121 | 1 | 0 |
72260 | 72260 | 2020-04-19 | Todd | South Dakota | 46121 | 1 | 0 |
75035 | 75035 | 2020-04-20 | Todd | South Dakota | 46121 | 1 | 0 |
77817 | 77817 | 2020-04-21 | Todd | South Dakota | 46121 | 1 | 0 |
80607 | 80607 | 2020-04-22 | Todd | South Dakota | 46121 | 1 | 0 |
83406 | 83406 | 2020-04-23 | Todd | South Dakota | 46121 | 1 | 0 |
86211 | 86211 | 2020-04-24 | Todd | South Dakota | 46121 | 1 | 0 |
89026 | 89026 | 2020-04-25 | Todd | South Dakota | 46121 | 1 | 0 |
91843 | 91843 | 2020-04-26 | Todd | South Dakota | 46121 | 1 | 0 |
94671 | 94671 | 2020-04-27 | Todd | South Dakota | 46121 | 1 | 0 |
97511 | 97511 | 2020-04-28 | Todd | South Dakota | 46121 | 1 | 0 |
100361 | 100361 | 2020-04-29 | Todd | South Dakota | 46121 | 1 | 0 |
103214 | 103214 | 2020-04-30 | Todd | South Dakota | 46121 | 1 | 0 |
106077 | 106077 | 2020-05-01 | Todd | South Dakota | 46121 | 2 | 0 |
108944 | 108944 | 2020-05-02 | Todd | South Dakota | 46121 | 3 | 0 |
111818 | 111818 | 2020-05-03 | Todd | South Dakota | 46121 | 3 | 0 |
114700 | 114700 | 2020-05-04 | Todd | South Dakota | 46121 | 3 | 0 |
117656 | 117656 | 2020-05-05 | Todd | South Dakota | 46121 | 6 | 0 |
120619 | 120619 | 2020-05-06 | Todd | South Dakota | 46121 | 7 | 0 |
123597 | 123597 | 2020-05-07 | Todd | South Dakota | 46121 | 7 | 0 |
126580 | 126580 | 2020-05-08 | Todd | South Dakota | 46121 | 8 | 0 |
129569 | 129569 | 2020-05-09 | Todd | South Dakota | 46121 | 8 | 0 |
132558 | 132558 | 2020-05-10 | Todd | South Dakota | 46121 | 9 | 0 |
135549 | 135549 | 2020-05-11 | Todd | South Dakota | 46121 | 10 | 0 |
138539 | 138539 | 2020-05-12 | Todd | South Dakota | 46121 | 13 | 0 |
141535 | 141535 | 2020-05-13 | Todd | South Dakota | 46121 | 14 | 0 |
144531 | 144531 | 2020-05-14 | Todd | South Dakota | 46121 | 13 | 0 |
147532 | 147532 | 2020-05-15 | Todd | South Dakota | 46121 | 15 | 0 |
150540 | 150540 | 2020-05-16 | Todd | South Dakota | 46121 | 16 | 0 |
153551 | 153551 | 2020-05-17 | Todd | South Dakota | 46121 | 16 | 0 |
156568 | 156568 | 2020-05-18 | Todd | South Dakota | 46121 | 17 | 0 |
159589 | 159589 | 2020-05-19 | Todd | South Dakota | 46121 | 17 | 0 |
162616 | 162616 | 2020-05-20 | Todd | South Dakota | 46121 | 17 | 0 |
165645 | 165645 | 2020-05-21 | Todd | South Dakota | 46121 | 17 | 0 |
168681 | 168681 | 2020-05-22 | Todd | South Dakota | 46121 | 17 | 0 |
171720 | 171720 | 2020-05-23 | Todd | South Dakota | 46121 | 17 | 0 |
174763 | 174763 | 2020-05-24 | Todd | South Dakota | 46121 | 18 | 0 |
177807 | 177807 | 2020-05-25 | Todd | South Dakota | 46121 | 18 | 0 |
180850 | 180850 | 2020-05-26 | Todd | South Dakota | 46121 | 20 | 0 |
183900 | 183900 | 2020-05-27 | Todd | South Dakota | 46121 | 22 | 1 |
186957 | 186957 | 2020-05-28 | Todd | South Dakota | 46121 | 23 | 1 |
190021 | 190021 | 2020-05-29 | Todd | South Dakota | 46121 | 23 | 1 |
193086 | 193086 | 2020-05-30 | Todd | South Dakota | 46121 | 26 | 1 |
196156 | 196156 | 2020-05-31 | Todd | South Dakota | 46121 | 27 | 1 |
199229 | 199229 | 2020-06-01 | Todd | South Dakota | 46121 | 27 | 1 |
202304 | 202304 | 2020-06-02 | Todd | South Dakota | 46121 | 28 | 1 |
205383 | 205383 | 2020-06-03 | Todd | South Dakota | 46121 | 28 | 1 |
208465 | 208465 | 2020-06-04 | Todd | South Dakota | 46121 | 31 | 1 |
211547 | 211547 | 2020-06-05 | Todd | South Dakota | 46121 | 33 | 1 |
214634 | 214634 | 2020-06-06 | Todd | South Dakota | 46121 | 36 | 1 |
217724 | 217724 | 2020-06-07 | Todd | South Dakota | 46121 | 37 | 1 |
220816 | 220816 | 2020-06-08 | Todd | South Dakota | 46121 | 38 | 1 |
223911 | 223911 | 2020-06-09 | Todd | South Dakota | 46121 | 42 | 1 |
227011 | 227011 | 2020-06-10 | Todd | South Dakota | 46121 | 44 | 1 |
230115 | 230115 | 2020-06-11 | Todd | South Dakota | 46121 | 45 | 1 |
233220 | 233220 | 2020-06-12 | Todd | South Dakota | 46121 | 46 | 1 |
236326 | 236326 | 2020-06-13 | Todd | South Dakota | 46121 | 47 | 1 |
239434 | 239434 | 2020-06-14 | Todd | South Dakota | 46121 | 47 | 1 |
242544 | 242544 | 2020-06-15 | Todd | South Dakota | 46121 | 47 | 1 |
245656 | 245656 | 2020-06-16 | Todd | South Dakota | 46121 | 48 | 1 |
248769 | 248769 | 2020-06-17 | Todd | South Dakota | 46121 | 50 | 1 |
251884 | 251884 | 2020-06-18 | Todd | South Dakota | 46121 | 50 | 1 |
254999 | 254999 | 2020-06-19 | Todd | South Dakota | 46121 | 50 | 1 |
258125 | 258125 | 2020-06-20 | Todd | South Dakota | 46121 | 50 | 1 |
261252 | 261252 | 2020-06-21 | Todd | South Dakota | 46121 | 50 | 1 |
264380 | 264380 | 2020-06-22 | Todd | South Dakota | 46121 | 50 | 1 |
267508 | 267508 | 2020-06-23 | Todd | South Dakota | 46121 | 50 | 1 |
270642 | 270642 | 2020-06-24 | Todd | South Dakota | 46121 | 51 | 1 |
273781 | 273781 | 2020-06-25 | Todd | South Dakota | 46121 | 52 | 1 |
276928 | 276928 | 2020-06-26 | Todd | South Dakota | 46121 | 53 | 1 |
280076 | 280076 | 2020-06-27 | Todd | South Dakota | 46121 | 56 | 1 |
283222 | 283222 | 2020-06-28 | Todd | South Dakota | 46121 | 56 | 1 |
286367 | 286367 | 2020-06-29 | Todd | South Dakota | 46121 | 57 | 1 |
289518 | 289518 | 2020-06-30 | Todd | South Dakota | 46121 | 57 | 1 |
292670 | 292670 | 2020-07-01 | Todd | South Dakota | 46121 | 57 | 1 |
295826 | 295826 | 2020-07-02 | Todd | South Dakota | 46121 | 57 | 1 |
298986 | 298986 | 2020-07-03 | Todd | South Dakota | 46121 | 57 | 1 |
302150 | 302150 | 2020-07-04 | Todd | South Dakota | 46121 | 57 | 1 |
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);