ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 46065 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 |
---|---|---|---|---|---|---|---|
9250 | 9250 | 2020-03-23 | Hughes | South Dakota | 46065 | 1 | 0 |
10577 | 10577 | 2020-03-24 | Hughes | South Dakota | 46065 | 1 | 0 |
12051 | 12051 | 2020-03-25 | Hughes | South Dakota | 46065 | 1 | 0 |
13673 | 13673 | 2020-03-26 | Hughes | South Dakota | 46065 | 1 | 0 |
15422 | 15422 | 2020-03-27 | Hughes | South Dakota | 46065 | 1 | 0 |
17279 | 17279 | 2020-03-28 | Hughes | South Dakota | 46065 | 1 | 0 |
19222 | 19222 | 2020-03-29 | Hughes | South Dakota | 46065 | 1 | 0 |
21274 | 21274 | 2020-03-30 | Hughes | South Dakota | 46065 | 1 | 0 |
23412 | 23412 | 2020-03-31 | Hughes | South Dakota | 46065 | 1 | 0 |
25610 | 25610 | 2020-04-01 | Hughes | South Dakota | 46065 | 2 | 0 |
27886 | 27886 | 2020-04-02 | Hughes | South Dakota | 46065 | 3 | 0 |
30221 | 30221 | 2020-04-03 | Hughes | South Dakota | 46065 | 3 | 0 |
32612 | 32612 | 2020-04-04 | Hughes | South Dakota | 46065 | 3 | 0 |
35048 | 35048 | 2020-04-05 | Hughes | South Dakota | 46065 | 3 | 0 |
37523 | 37523 | 2020-04-06 | Hughes | South Dakota | 46065 | 3 | 0 |
40046 | 40046 | 2020-04-07 | Hughes | South Dakota | 46065 | 3 | 0 |
42606 | 42606 | 2020-04-08 | Hughes | South Dakota | 46065 | 3 | 0 |
45193 | 45193 | 2020-04-09 | Hughes | South Dakota | 46065 | 4 | 0 |
47810 | 47810 | 2020-04-10 | Hughes | South Dakota | 46065 | 4 | 0 |
50467 | 50467 | 2020-04-11 | Hughes | South Dakota | 46065 | 4 | 0 |
53140 | 53140 | 2020-04-12 | Hughes | South Dakota | 46065 | 5 | 0 |
55825 | 55825 | 2020-04-13 | Hughes | South Dakota | 46065 | 5 | 0 |
58528 | 58528 | 2020-04-14 | Hughes | South Dakota | 46065 | 5 | 0 |
61243 | 61243 | 2020-04-15 | Hughes | South Dakota | 46065 | 5 | 0 |
63969 | 63969 | 2020-04-16 | Hughes | South Dakota | 46065 | 5 | 0 |
66715 | 66715 | 2020-04-17 | Hughes | South Dakota | 46065 | 5 | 0 |
69473 | 69473 | 2020-04-18 | Hughes | South Dakota | 46065 | 5 | 0 |
72240 | 72240 | 2020-04-19 | Hughes | South Dakota | 46065 | 5 | 0 |
75015 | 75015 | 2020-04-20 | Hughes | South Dakota | 46065 | 5 | 0 |
77797 | 77797 | 2020-04-21 | Hughes | South Dakota | 46065 | 5 | 0 |
80587 | 80587 | 2020-04-22 | Hughes | South Dakota | 46065 | 6 | 0 |
83386 | 83386 | 2020-04-23 | Hughes | South Dakota | 46065 | 7 | 0 |
86190 | 86190 | 2020-04-24 | Hughes | South Dakota | 46065 | 7 | 0 |
89004 | 89004 | 2020-04-25 | Hughes | South Dakota | 46065 | 7 | 0 |
91821 | 91821 | 2020-04-26 | Hughes | South Dakota | 46065 | 7 | 0 |
94649 | 94649 | 2020-04-27 | Hughes | South Dakota | 46065 | 7 | 0 |
97489 | 97489 | 2020-04-28 | Hughes | South Dakota | 46065 | 7 | 0 |
100339 | 100339 | 2020-04-29 | Hughes | South Dakota | 46065 | 7 | 0 |
103192 | 103192 | 2020-04-30 | Hughes | South Dakota | 46065 | 8 | 0 |
106055 | 106055 | 2020-05-01 | Hughes | South Dakota | 46065 | 9 | 0 |
108922 | 108922 | 2020-05-02 | Hughes | South Dakota | 46065 | 13 | 0 |
111796 | 111796 | 2020-05-03 | Hughes | South Dakota | 46065 | 13 | 0 |
114678 | 114678 | 2020-05-04 | Hughes | South Dakota | 46065 | 13 | 0 |
117634 | 117634 | 2020-05-05 | Hughes | South Dakota | 46065 | 13 | 0 |
120597 | 120597 | 2020-05-06 | Hughes | South Dakota | 46065 | 13 | 0 |
123575 | 123575 | 2020-05-07 | Hughes | South Dakota | 46065 | 14 | 0 |
126558 | 126558 | 2020-05-08 | Hughes | South Dakota | 46065 | 15 | 0 |
129547 | 129547 | 2020-05-09 | Hughes | South Dakota | 46065 | 15 | 0 |
132536 | 132536 | 2020-05-10 | Hughes | South Dakota | 46065 | 15 | 0 |
135527 | 135527 | 2020-05-11 | Hughes | South Dakota | 46065 | 15 | 0 |
138517 | 138517 | 2020-05-12 | Hughes | South Dakota | 46065 | 15 | 0 |
141513 | 141513 | 2020-05-13 | Hughes | South Dakota | 46065 | 15 | 0 |
144509 | 144509 | 2020-05-14 | Hughes | South Dakota | 46065 | 15 | 0 |
147510 | 147510 | 2020-05-15 | Hughes | South Dakota | 46065 | 16 | 0 |
150518 | 150518 | 2020-05-16 | Hughes | South Dakota | 46065 | 16 | 0 |
153529 | 153529 | 2020-05-17 | Hughes | South Dakota | 46065 | 16 | 0 |
156546 | 156546 | 2020-05-18 | Hughes | South Dakota | 46065 | 16 | 0 |
159567 | 159567 | 2020-05-19 | Hughes | South Dakota | 46065 | 17 | 0 |
162594 | 162594 | 2020-05-20 | Hughes | South Dakota | 46065 | 17 | 0 |
165623 | 165623 | 2020-05-21 | Hughes | South Dakota | 46065 | 17 | 0 |
168659 | 168659 | 2020-05-22 | Hughes | South Dakota | 46065 | 17 | 0 |
171698 | 171698 | 2020-05-23 | Hughes | South Dakota | 46065 | 17 | 0 |
174740 | 174740 | 2020-05-24 | Hughes | South Dakota | 46065 | 19 | 0 |
177784 | 177784 | 2020-05-25 | Hughes | South Dakota | 46065 | 19 | 0 |
180827 | 180827 | 2020-05-26 | Hughes | South Dakota | 46065 | 19 | 0 |
183877 | 183877 | 2020-05-27 | Hughes | South Dakota | 46065 | 19 | 0 |
186934 | 186934 | 2020-05-28 | Hughes | South Dakota | 46065 | 19 | 0 |
189997 | 189997 | 2020-05-29 | Hughes | South Dakota | 46065 | 19 | 0 |
193062 | 193062 | 2020-05-30 | Hughes | South Dakota | 46065 | 19 | 0 |
196132 | 196132 | 2020-05-31 | Hughes | South Dakota | 46065 | 19 | 0 |
199205 | 199205 | 2020-06-01 | Hughes | South Dakota | 46065 | 19 | 0 |
202280 | 202280 | 2020-06-02 | Hughes | South Dakota | 46065 | 19 | 0 |
205359 | 205359 | 2020-06-03 | Hughes | South Dakota | 46065 | 19 | 0 |
208441 | 208441 | 2020-06-04 | Hughes | South Dakota | 46065 | 19 | 0 |
211523 | 211523 | 2020-06-05 | Hughes | South Dakota | 46065 | 19 | 0 |
214610 | 214610 | 2020-06-06 | Hughes | South Dakota | 46065 | 19 | 0 |
217700 | 217700 | 2020-06-07 | Hughes | South Dakota | 46065 | 20 | 0 |
220792 | 220792 | 2020-06-08 | Hughes | South Dakota | 46065 | 20 | 0 |
223887 | 223887 | 2020-06-09 | Hughes | South Dakota | 46065 | 21 | 0 |
226987 | 226987 | 2020-06-10 | Hughes | South Dakota | 46065 | 21 | 0 |
230091 | 230091 | 2020-06-11 | Hughes | South Dakota | 46065 | 21 | 0 |
233196 | 233196 | 2020-06-12 | Hughes | South Dakota | 46065 | 21 | 0 |
236301 | 236301 | 2020-06-13 | Hughes | South Dakota | 46065 | 21 | 0 |
239409 | 239409 | 2020-06-14 | Hughes | South Dakota | 46065 | 22 | 0 |
242519 | 242519 | 2020-06-15 | Hughes | South Dakota | 46065 | 22 | 0 |
245631 | 245631 | 2020-06-16 | Hughes | South Dakota | 46065 | 23 | 0 |
248744 | 248744 | 2020-06-17 | Hughes | South Dakota | 46065 | 25 | 0 |
251859 | 251859 | 2020-06-18 | Hughes | South Dakota | 46065 | 27 | 0 |
254974 | 254974 | 2020-06-19 | Hughes | South Dakota | 46065 | 29 | 0 |
258100 | 258100 | 2020-06-20 | Hughes | South Dakota | 46065 | 31 | 0 |
261227 | 261227 | 2020-06-21 | Hughes | South Dakota | 46065 | 32 | 0 |
264355 | 264355 | 2020-06-22 | Hughes | South Dakota | 46065 | 32 | 0 |
267483 | 267483 | 2020-06-23 | Hughes | South Dakota | 46065 | 33 | 0 |
270617 | 270617 | 2020-06-24 | Hughes | South Dakota | 46065 | 38 | 0 |
273756 | 273756 | 2020-06-25 | Hughes | South Dakota | 46065 | 42 | 0 |
276903 | 276903 | 2020-06-26 | Hughes | South Dakota | 46065 | 42 | 0 |
280051 | 280051 | 2020-06-27 | Hughes | South Dakota | 46065 | 49 | 0 |
283197 | 283197 | 2020-06-28 | Hughes | South Dakota | 46065 | 51 | 0 |
286342 | 286342 | 2020-06-29 | Hughes | South Dakota | 46065 | 52 | 0 |
289493 | 289493 | 2020-06-30 | Hughes | South Dakota | 46065 | 55 | 0 |
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);