ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
738 rows where fips = 46051 and state = "South Dakota" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
120594 | 120594 | 2020-05-06 | Grant | South Dakota | 46051 | 2 | 0 |
123572 | 123572 | 2020-05-07 | Grant | South Dakota | 46051 | 2 | 0 |
126555 | 126555 | 2020-05-08 | Grant | South Dakota | 46051 | 2 | 0 |
129544 | 129544 | 2020-05-09 | Grant | South Dakota | 46051 | 2 | 0 |
132533 | 132533 | 2020-05-10 | Grant | South Dakota | 46051 | 3 | 0 |
135524 | 135524 | 2020-05-11 | Grant | South Dakota | 46051 | 3 | 0 |
138514 | 138514 | 2020-05-12 | Grant | South Dakota | 46051 | 3 | 0 |
141510 | 141510 | 2020-05-13 | Grant | South Dakota | 46051 | 4 | 0 |
144506 | 144506 | 2020-05-14 | Grant | South Dakota | 46051 | 5 | 0 |
147507 | 147507 | 2020-05-15 | Grant | South Dakota | 46051 | 7 | 0 |
150515 | 150515 | 2020-05-16 | Grant | South Dakota | 46051 | 9 | 0 |
153526 | 153526 | 2020-05-17 | Grant | South Dakota | 46051 | 9 | 0 |
156543 | 156543 | 2020-05-18 | Grant | South Dakota | 46051 | 9 | 0 |
159564 | 159564 | 2020-05-19 | Grant | South Dakota | 46051 | 9 | 0 |
162591 | 162591 | 2020-05-20 | Grant | South Dakota | 46051 | 9 | 0 |
165620 | 165620 | 2020-05-21 | Grant | South Dakota | 46051 | 9 | 0 |
168656 | 168656 | 2020-05-22 | Grant | South Dakota | 46051 | 10 | 0 |
171695 | 171695 | 2020-05-23 | Grant | South Dakota | 46051 | 10 | 0 |
174737 | 174737 | 2020-05-24 | Grant | South Dakota | 46051 | 10 | 0 |
177781 | 177781 | 2020-05-25 | Grant | South Dakota | 46051 | 10 | 0 |
180824 | 180824 | 2020-05-26 | Grant | South Dakota | 46051 | 11 | 0 |
183874 | 183874 | 2020-05-27 | Grant | South Dakota | 46051 | 11 | 0 |
186931 | 186931 | 2020-05-28 | Grant | South Dakota | 46051 | 11 | 0 |
189994 | 189994 | 2020-05-29 | Grant | South Dakota | 46051 | 13 | 0 |
193059 | 193059 | 2020-05-30 | Grant | South Dakota | 46051 | 13 | 0 |
196128 | 196128 | 2020-05-31 | Grant | South Dakota | 46051 | 13 | 0 |
199201 | 199201 | 2020-06-01 | Grant | South Dakota | 46051 | 13 | 0 |
202276 | 202276 | 2020-06-02 | Grant | South Dakota | 46051 | 13 | 0 |
205354 | 205354 | 2020-06-03 | Grant | South Dakota | 46051 | 13 | 0 |
208436 | 208436 | 2020-06-04 | Grant | South Dakota | 46051 | 13 | 0 |
211518 | 211518 | 2020-06-05 | Grant | South Dakota | 46051 | 13 | 0 |
214605 | 214605 | 2020-06-06 | Grant | South Dakota | 46051 | 13 | 0 |
217695 | 217695 | 2020-06-07 | Grant | South Dakota | 46051 | 13 | 0 |
220787 | 220787 | 2020-06-08 | Grant | South Dakota | 46051 | 13 | 0 |
223882 | 223882 | 2020-06-09 | Grant | South Dakota | 46051 | 13 | 0 |
226982 | 226982 | 2020-06-10 | Grant | South Dakota | 46051 | 13 | 0 |
230086 | 230086 | 2020-06-11 | Grant | South Dakota | 46051 | 13 | 0 |
233191 | 233191 | 2020-06-12 | Grant | South Dakota | 46051 | 13 | 0 |
236296 | 236296 | 2020-06-13 | Grant | South Dakota | 46051 | 13 | 0 |
239404 | 239404 | 2020-06-14 | Grant | South Dakota | 46051 | 13 | 0 |
242514 | 242514 | 2020-06-15 | Grant | South Dakota | 46051 | 13 | 0 |
245626 | 245626 | 2020-06-16 | Grant | South Dakota | 46051 | 13 | 0 |
248739 | 248739 | 2020-06-17 | Grant | South Dakota | 46051 | 13 | 0 |
251854 | 251854 | 2020-06-18 | Grant | South Dakota | 46051 | 13 | 0 |
254969 | 254969 | 2020-06-19 | Grant | South Dakota | 46051 | 13 | 0 |
258095 | 258095 | 2020-06-20 | Grant | South Dakota | 46051 | 13 | 0 |
261222 | 261222 | 2020-06-21 | Grant | South Dakota | 46051 | 13 | 0 |
264350 | 264350 | 2020-06-22 | Grant | South Dakota | 46051 | 13 | 0 |
267478 | 267478 | 2020-06-23 | Grant | South Dakota | 46051 | 13 | 0 |
270612 | 270612 | 2020-06-24 | Grant | South Dakota | 46051 | 13 | 0 |
273751 | 273751 | 2020-06-25 | Grant | South Dakota | 46051 | 13 | 0 |
276898 | 276898 | 2020-06-26 | Grant | South Dakota | 46051 | 13 | 0 |
280046 | 280046 | 2020-06-27 | Grant | South Dakota | 46051 | 13 | 0 |
283192 | 283192 | 2020-06-28 | Grant | South Dakota | 46051 | 13 | 0 |
286337 | 286337 | 2020-06-29 | Grant | South Dakota | 46051 | 13 | 0 |
289488 | 289488 | 2020-06-30 | Grant | South Dakota | 46051 | 13 | 0 |
292640 | 292640 | 2020-07-01 | Grant | South Dakota | 46051 | 13 | 0 |
295796 | 295796 | 2020-07-02 | Grant | South Dakota | 46051 | 13 | 0 |
298956 | 298956 | 2020-07-03 | Grant | South Dakota | 46051 | 13 | 0 |
302120 | 302120 | 2020-07-04 | Grant | South Dakota | 46051 | 13 | 0 |
305283 | 305283 | 2020-07-05 | Grant | South Dakota | 46051 | 13 | 0 |
308450 | 308450 | 2020-07-06 | Grant | South Dakota | 46051 | 13 | 0 |
311619 | 311619 | 2020-07-07 | Grant | South Dakota | 46051 | 14 | 0 |
314792 | 314792 | 2020-07-08 | Grant | South Dakota | 46051 | 14 | 0 |
317965 | 317965 | 2020-07-09 | Grant | South Dakota | 46051 | 16 | 0 |
321143 | 321143 | 2020-07-10 | Grant | South Dakota | 46051 | 16 | 0 |
324323 | 324323 | 2020-07-11 | Grant | South Dakota | 46051 | 16 | 0 |
327508 | 327508 | 2020-07-12 | Grant | South Dakota | 46051 | 17 | 0 |
330694 | 330694 | 2020-07-13 | Grant | South Dakota | 46051 | 17 | 0 |
333886 | 333886 | 2020-07-14 | Grant | South Dakota | 46051 | 18 | 0 |
337080 | 337080 | 2020-07-15 | Grant | South Dakota | 46051 | 18 | 0 |
340277 | 340277 | 2020-07-16 | Grant | South Dakota | 46051 | 18 | 0 |
343475 | 343475 | 2020-07-17 | Grant | South Dakota | 46051 | 17 | 0 |
346675 | 346675 | 2020-07-18 | Grant | South Dakota | 46051 | 17 | 0 |
349875 | 349875 | 2020-07-19 | Grant | South Dakota | 46051 | 17 | 0 |
353078 | 353078 | 2020-07-20 | Grant | South Dakota | 46051 | 17 | 0 |
356281 | 356281 | 2020-07-21 | Grant | South Dakota | 46051 | 17 | 0 |
359485 | 359485 | 2020-07-22 | Grant | South Dakota | 46051 | 17 | 0 |
362691 | 362691 | 2020-07-23 | Grant | South Dakota | 46051 | 18 | 0 |
365897 | 365897 | 2020-07-24 | Grant | South Dakota | 46051 | 18 | 0 |
369106 | 369106 | 2020-07-25 | Grant | South Dakota | 46051 | 18 | 0 |
372318 | 372318 | 2020-07-26 | Grant | South Dakota | 46051 | 18 | 0 |
375531 | 375531 | 2020-07-27 | Grant | South Dakota | 46051 | 18 | 0 |
378747 | 378747 | 2020-07-28 | Grant | South Dakota | 46051 | 18 | 0 |
381964 | 381964 | 2020-07-29 | Grant | South Dakota | 46051 | 18 | 0 |
385182 | 385182 | 2020-07-30 | Grant | South Dakota | 46051 | 18 | 0 |
388399 | 388399 | 2020-07-31 | Grant | South Dakota | 46051 | 18 | 0 |
391616 | 391616 | 2020-08-01 | Grant | South Dakota | 46051 | 19 | 0 |
394832 | 394832 | 2020-08-02 | Grant | South Dakota | 46051 | 23 | 0 |
398049 | 398049 | 2020-08-03 | Grant | South Dakota | 46051 | 23 | 0 |
401264 | 401264 | 2020-08-04 | Grant | South Dakota | 46051 | 23 | 0 |
404482 | 404482 | 2020-08-05 | Grant | South Dakota | 46051 | 23 | 0 |
407702 | 407702 | 2020-08-06 | Grant | South Dakota | 46051 | 24 | 0 |
410921 | 410921 | 2020-08-07 | Grant | South Dakota | 46051 | 24 | 0 |
414141 | 414141 | 2020-08-08 | Grant | South Dakota | 46051 | 26 | 0 |
417362 | 417362 | 2020-08-09 | Grant | South Dakota | 46051 | 26 | 0 |
420583 | 420583 | 2020-08-10 | Grant | South Dakota | 46051 | 27 | 0 |
423805 | 423805 | 2020-08-11 | Grant | South Dakota | 46051 | 27 | 0 |
427028 | 427028 | 2020-08-12 | Grant | South Dakota | 46051 | 27 | 0 |
430254 | 430254 | 2020-08-13 | Grant | South Dakota | 46051 | 28 | 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);