ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 46103 and state = "South Dakota" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9254 | 9254 | 2020-03-23 | Pennington | South Dakota | 46103 | 1 | 0 |
10581 | 10581 | 2020-03-24 | Pennington | South Dakota | 46103 | 1 | 0 |
12057 | 12057 | 2020-03-25 | Pennington | South Dakota | 46103 | 1 | 0 |
13679 | 13679 | 2020-03-26 | Pennington | South Dakota | 46103 | 1 | 0 |
15429 | 15429 | 2020-03-27 | Pennington | South Dakota | 46103 | 3 | 0 |
17287 | 17287 | 2020-03-28 | Pennington | South Dakota | 46103 | 3 | 0 |
19230 | 19230 | 2020-03-29 | Pennington | South Dakota | 46103 | 4 | 0 |
21283 | 21283 | 2020-03-30 | Pennington | South Dakota | 46103 | 5 | 0 |
23421 | 23421 | 2020-03-31 | Pennington | South Dakota | 46103 | 5 | 0 |
25619 | 25619 | 2020-04-01 | Pennington | South Dakota | 46103 | 5 | 0 |
27896 | 27896 | 2020-04-02 | Pennington | South Dakota | 46103 | 6 | 0 |
30231 | 30231 | 2020-04-03 | Pennington | South Dakota | 46103 | 6 | 0 |
32622 | 32622 | 2020-04-04 | Pennington | South Dakota | 46103 | 6 | 0 |
35058 | 35058 | 2020-04-05 | Pennington | South Dakota | 46103 | 6 | 0 |
37533 | 37533 | 2020-04-06 | Pennington | South Dakota | 46103 | 6 | 0 |
40056 | 40056 | 2020-04-07 | Pennington | South Dakota | 46103 | 6 | 0 |
42617 | 42617 | 2020-04-08 | Pennington | South Dakota | 46103 | 6 | 0 |
45205 | 45205 | 2020-04-09 | Pennington | South Dakota | 46103 | 7 | 0 |
47823 | 47823 | 2020-04-10 | Pennington | South Dakota | 46103 | 8 | 0 |
50480 | 50480 | 2020-04-11 | Pennington | South Dakota | 46103 | 8 | 0 |
53153 | 53153 | 2020-04-12 | Pennington | South Dakota | 46103 | 8 | 0 |
55839 | 55839 | 2020-04-13 | Pennington | South Dakota | 46103 | 9 | 0 |
58542 | 58542 | 2020-04-14 | Pennington | South Dakota | 46103 | 9 | 0 |
61257 | 61257 | 2020-04-15 | Pennington | South Dakota | 46103 | 9 | 0 |
63984 | 63984 | 2020-04-16 | Pennington | South Dakota | 46103 | 10 | 0 |
66730 | 66730 | 2020-04-17 | Pennington | South Dakota | 46103 | 10 | 0 |
69488 | 69488 | 2020-04-18 | Pennington | South Dakota | 46103 | 10 | 0 |
72255 | 72255 | 2020-04-19 | Pennington | South Dakota | 46103 | 10 | 0 |
75030 | 75030 | 2020-04-20 | Pennington | South Dakota | 46103 | 11 | 0 |
77812 | 77812 | 2020-04-21 | Pennington | South Dakota | 46103 | 11 | 0 |
80602 | 80602 | 2020-04-22 | Pennington | South Dakota | 46103 | 11 | 0 |
83401 | 83401 | 2020-04-23 | Pennington | South Dakota | 46103 | 11 | 0 |
86205 | 86205 | 2020-04-24 | Pennington | South Dakota | 46103 | 11 | 0 |
89020 | 89020 | 2020-04-25 | Pennington | South Dakota | 46103 | 11 | 0 |
91837 | 91837 | 2020-04-26 | Pennington | South Dakota | 46103 | 12 | 0 |
94665 | 94665 | 2020-04-27 | Pennington | South Dakota | 46103 | 12 | 0 |
97505 | 97505 | 2020-04-28 | Pennington | South Dakota | 46103 | 12 | 0 |
100355 | 100355 | 2020-04-29 | Pennington | South Dakota | 46103 | 12 | 0 |
103208 | 103208 | 2020-04-30 | Pennington | South Dakota | 46103 | 11 | 0 |
106071 | 106071 | 2020-05-01 | Pennington | South Dakota | 46103 | 13 | 0 |
108938 | 108938 | 2020-05-02 | Pennington | South Dakota | 46103 | 13 | 0 |
111812 | 111812 | 2020-05-03 | Pennington | South Dakota | 46103 | 14 | 0 |
114694 | 114694 | 2020-05-04 | Pennington | South Dakota | 46103 | 14 | 0 |
117650 | 117650 | 2020-05-05 | Pennington | South Dakota | 46103 | 16 | 0 |
120613 | 120613 | 2020-05-06 | Pennington | South Dakota | 46103 | 16 | 0 |
123591 | 123591 | 2020-05-07 | Pennington | South Dakota | 46103 | 17 | 0 |
126574 | 126574 | 2020-05-08 | Pennington | South Dakota | 46103 | 18 | 0 |
129563 | 129563 | 2020-05-09 | Pennington | South Dakota | 46103 | 19 | 0 |
132552 | 132552 | 2020-05-10 | Pennington | South Dakota | 46103 | 26 | 0 |
135543 | 135543 | 2020-05-11 | Pennington | South Dakota | 46103 | 27 | 0 |
138533 | 138533 | 2020-05-12 | Pennington | South Dakota | 46103 | 32 | 0 |
141529 | 141529 | 2020-05-13 | Pennington | South Dakota | 46103 | 36 | 0 |
144525 | 144525 | 2020-05-14 | Pennington | South Dakota | 46103 | 40 | 0 |
147526 | 147526 | 2020-05-15 | Pennington | South Dakota | 46103 | 43 | 0 |
150534 | 150534 | 2020-05-16 | Pennington | South Dakota | 46103 | 49 | 0 |
153545 | 153545 | 2020-05-17 | Pennington | South Dakota | 46103 | 52 | 0 |
156562 | 156562 | 2020-05-18 | Pennington | South Dakota | 46103 | 58 | 0 |
159583 | 159583 | 2020-05-19 | Pennington | South Dakota | 46103 | 74 | 1 |
162610 | 162610 | 2020-05-20 | Pennington | South Dakota | 46103 | 85 | 1 |
165639 | 165639 | 2020-05-21 | Pennington | South Dakota | 46103 | 85 | 1 |
168675 | 168675 | 2020-05-22 | Pennington | South Dakota | 46103 | 127 | 1 |
171714 | 171714 | 2020-05-23 | Pennington | South Dakota | 46103 | 138 | 2 |
174757 | 174757 | 2020-05-24 | Pennington | South Dakota | 46103 | 152 | 2 |
177801 | 177801 | 2020-05-25 | Pennington | South Dakota | 46103 | 156 | 2 |
180844 | 180844 | 2020-05-26 | Pennington | South Dakota | 46103 | 162 | 2 |
183894 | 183894 | 2020-05-27 | Pennington | South Dakota | 46103 | 172 | 2 |
186951 | 186951 | 2020-05-28 | Pennington | South Dakota | 46103 | 186 | 2 |
190015 | 190015 | 2020-05-29 | Pennington | South Dakota | 46103 | 201 | 2 |
193080 | 193080 | 2020-05-30 | Pennington | South Dakota | 46103 | 218 | 3 |
196150 | 196150 | 2020-05-31 | Pennington | South Dakota | 46103 | 227 | 3 |
199223 | 199223 | 2020-06-01 | Pennington | South Dakota | 46103 | 235 | 3 |
202298 | 202298 | 2020-06-02 | Pennington | South Dakota | 46103 | 241 | 3 |
205377 | 205377 | 2020-06-03 | Pennington | South Dakota | 46103 | 257 | 3 |
208459 | 208459 | 2020-06-04 | Pennington | South Dakota | 46103 | 275 | 4 |
211541 | 211541 | 2020-06-05 | Pennington | South Dakota | 46103 | 284 | 4 |
214628 | 214628 | 2020-06-06 | Pennington | South Dakota | 46103 | 297 | 4 |
217718 | 217718 | 2020-06-07 | Pennington | South Dakota | 46103 | 305 | 4 |
220810 | 220810 | 2020-06-08 | Pennington | South Dakota | 46103 | 314 | 4 |
223905 | 223905 | 2020-06-09 | Pennington | South Dakota | 46103 | 321 | 5 |
227005 | 227005 | 2020-06-10 | Pennington | South Dakota | 46103 | 335 | 5 |
230109 | 230109 | 2020-06-11 | Pennington | South Dakota | 46103 | 351 | 6 |
233214 | 233214 | 2020-06-12 | Pennington | South Dakota | 46103 | 362 | 6 |
236320 | 236320 | 2020-06-13 | Pennington | South Dakota | 46103 | 378 | 7 |
239428 | 239428 | 2020-06-14 | Pennington | South Dakota | 46103 | 386 | 7 |
242538 | 242538 | 2020-06-15 | Pennington | South Dakota | 46103 | 392 | 7 |
245650 | 245650 | 2020-06-16 | Pennington | South Dakota | 46103 | 402 | 8 |
248763 | 248763 | 2020-06-17 | Pennington | South Dakota | 46103 | 424 | 8 |
251878 | 251878 | 2020-06-18 | Pennington | South Dakota | 46103 | 430 | 8 |
254993 | 254993 | 2020-06-19 | Pennington | South Dakota | 46103 | 437 | 10 |
258119 | 258119 | 2020-06-20 | Pennington | South Dakota | 46103 | 446 | 10 |
261246 | 261246 | 2020-06-21 | Pennington | South Dakota | 46103 | 457 | 10 |
264374 | 264374 | 2020-06-22 | Pennington | South Dakota | 46103 | 462 | 10 |
267502 | 267502 | 2020-06-23 | Pennington | South Dakota | 46103 | 466 | 11 |
270636 | 270636 | 2020-06-24 | Pennington | South Dakota | 46103 | 475 | 11 |
273775 | 273775 | 2020-06-25 | Pennington | South Dakota | 46103 | 482 | 12 |
276922 | 276922 | 2020-06-26 | Pennington | South Dakota | 46103 | 486 | 13 |
280070 | 280070 | 2020-06-27 | Pennington | South Dakota | 46103 | 497 | 15 |
283216 | 283216 | 2020-06-28 | Pennington | South Dakota | 46103 | 507 | 15 |
286361 | 286361 | 2020-06-29 | Pennington | South Dakota | 46103 | 513 | 15 |
289512 | 289512 | 2020-06-30 | Pennington | South Dakota | 46103 | 518 | 15 |
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);