ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
738 rows where county = "Grant" and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536899 | 536899 | 2020-09-15 | Grant | South Dakota | 46051 | 66 | 1 |
533663 | 533663 | 2020-09-14 | Grant | South Dakota | 46051 | 64 | 1 |
530428 | 530428 | 2020-09-13 | Grant | South Dakota | 46051 | 63 | 1 |
527191 | 527191 | 2020-09-12 | Grant | South Dakota | 46051 | 60 | 1 |
523955 | 523955 | 2020-09-11 | Grant | South Dakota | 46051 | 58 | 0 |
520719 | 520719 | 2020-09-10 | Grant | South Dakota | 46051 | 55 | 0 |
517483 | 517483 | 2020-09-09 | Grant | South Dakota | 46051 | 52 | 0 |
514248 | 514248 | 2020-09-08 | Grant | South Dakota | 46051 | 51 | 0 |
511015 | 511015 | 2020-09-07 | Grant | South Dakota | 46051 | 51 | 0 |
507782 | 507782 | 2020-09-06 | Grant | South Dakota | 46051 | 51 | 0 |
504550 | 504550 | 2020-09-05 | Grant | South Dakota | 46051 | 50 | 0 |
501316 | 501316 | 2020-09-04 | Grant | South Dakota | 46051 | 47 | 0 |
498082 | 498082 | 2020-09-03 | Grant | South Dakota | 46051 | 45 | 0 |
494849 | 494849 | 2020-09-02 | Grant | South Dakota | 46051 | 44 | 0 |
491615 | 491615 | 2020-09-01 | Grant | South Dakota | 46051 | 42 | 0 |
488382 | 488382 | 2020-08-31 | Grant | South Dakota | 46051 | 42 | 0 |
485149 | 485149 | 2020-08-30 | Grant | South Dakota | 46051 | 42 | 0 |
481914 | 481914 | 2020-08-29 | Grant | South Dakota | 46051 | 41 | 0 |
478680 | 478680 | 2020-08-28 | Grant | South Dakota | 46051 | 41 | 0 |
475447 | 475447 | 2020-08-27 | Grant | South Dakota | 46051 | 41 | 0 |
472213 | 472213 | 2020-08-26 | Grant | South Dakota | 46051 | 39 | 0 |
468981 | 468981 | 2020-08-25 | Grant | South Dakota | 46051 | 39 | 0 |
465753 | 465753 | 2020-08-24 | Grant | South Dakota | 46051 | 39 | 0 |
462524 | 462524 | 2020-08-23 | Grant | South Dakota | 46051 | 39 | 0 |
459296 | 459296 | 2020-08-22 | Grant | South Dakota | 46051 | 39 | 0 |
456068 | 456068 | 2020-08-21 | Grant | South Dakota | 46051 | 38 | 0 |
452840 | 452840 | 2020-08-20 | Grant | South Dakota | 46051 | 34 | 0 |
449612 | 449612 | 2020-08-19 | Grant | South Dakota | 46051 | 34 | 0 |
446384 | 446384 | 2020-08-18 | Grant | South Dakota | 46051 | 34 | 0 |
443158 | 443158 | 2020-08-17 | Grant | South Dakota | 46051 | 33 | 0 |
439931 | 439931 | 2020-08-16 | Grant | South Dakota | 46051 | 33 | 0 |
436706 | 436706 | 2020-08-15 | Grant | South Dakota | 46051 | 32 | 0 |
433479 | 433479 | 2020-08-14 | Grant | South Dakota | 46051 | 31 | 0 |
430254 | 430254 | 2020-08-13 | Grant | South Dakota | 46051 | 28 | 0 |
427028 | 427028 | 2020-08-12 | Grant | South Dakota | 46051 | 27 | 0 |
423805 | 423805 | 2020-08-11 | Grant | South Dakota | 46051 | 27 | 0 |
420583 | 420583 | 2020-08-10 | Grant | South Dakota | 46051 | 27 | 0 |
417362 | 417362 | 2020-08-09 | Grant | South Dakota | 46051 | 26 | 0 |
414141 | 414141 | 2020-08-08 | Grant | South Dakota | 46051 | 26 | 0 |
410921 | 410921 | 2020-08-07 | Grant | South Dakota | 46051 | 24 | 0 |
407702 | 407702 | 2020-08-06 | Grant | South Dakota | 46051 | 24 | 0 |
404482 | 404482 | 2020-08-05 | Grant | South Dakota | 46051 | 23 | 0 |
401264 | 401264 | 2020-08-04 | Grant | South Dakota | 46051 | 23 | 0 |
398049 | 398049 | 2020-08-03 | Grant | South Dakota | 46051 | 23 | 0 |
394832 | 394832 | 2020-08-02 | Grant | South Dakota | 46051 | 23 | 0 |
391616 | 391616 | 2020-08-01 | Grant | South Dakota | 46051 | 19 | 0 |
388399 | 388399 | 2020-07-31 | Grant | South Dakota | 46051 | 18 | 0 |
385182 | 385182 | 2020-07-30 | Grant | South Dakota | 46051 | 18 | 0 |
381964 | 381964 | 2020-07-29 | Grant | South Dakota | 46051 | 18 | 0 |
378747 | 378747 | 2020-07-28 | Grant | South Dakota | 46051 | 18 | 0 |
375531 | 375531 | 2020-07-27 | Grant | South Dakota | 46051 | 18 | 0 |
372318 | 372318 | 2020-07-26 | Grant | South Dakota | 46051 | 18 | 0 |
369106 | 369106 | 2020-07-25 | Grant | South Dakota | 46051 | 18 | 0 |
365897 | 365897 | 2020-07-24 | Grant | South Dakota | 46051 | 18 | 0 |
362691 | 362691 | 2020-07-23 | Grant | South Dakota | 46051 | 18 | 0 |
359485 | 359485 | 2020-07-22 | Grant | South Dakota | 46051 | 17 | 0 |
356281 | 356281 | 2020-07-21 | Grant | South Dakota | 46051 | 17 | 0 |
353078 | 353078 | 2020-07-20 | Grant | South Dakota | 46051 | 17 | 0 |
349875 | 349875 | 2020-07-19 | Grant | South Dakota | 46051 | 17 | 0 |
346675 | 346675 | 2020-07-18 | Grant | South Dakota | 46051 | 17 | 0 |
343475 | 343475 | 2020-07-17 | Grant | South Dakota | 46051 | 17 | 0 |
340277 | 340277 | 2020-07-16 | Grant | South Dakota | 46051 | 18 | 0 |
337080 | 337080 | 2020-07-15 | Grant | South Dakota | 46051 | 18 | 0 |
333886 | 333886 | 2020-07-14 | Grant | South Dakota | 46051 | 18 | 0 |
330694 | 330694 | 2020-07-13 | Grant | South Dakota | 46051 | 17 | 0 |
327508 | 327508 | 2020-07-12 | Grant | South Dakota | 46051 | 17 | 0 |
324323 | 324323 | 2020-07-11 | Grant | South Dakota | 46051 | 16 | 0 |
321143 | 321143 | 2020-07-10 | Grant | South Dakota | 46051 | 16 | 0 |
317965 | 317965 | 2020-07-09 | Grant | South Dakota | 46051 | 16 | 0 |
314792 | 314792 | 2020-07-08 | Grant | South Dakota | 46051 | 14 | 0 |
311619 | 311619 | 2020-07-07 | Grant | South Dakota | 46051 | 14 | 0 |
308450 | 308450 | 2020-07-06 | Grant | South Dakota | 46051 | 13 | 0 |
305283 | 305283 | 2020-07-05 | Grant | South Dakota | 46051 | 13 | 0 |
302120 | 302120 | 2020-07-04 | Grant | South Dakota | 46051 | 13 | 0 |
298956 | 298956 | 2020-07-03 | Grant | South Dakota | 46051 | 13 | 0 |
295796 | 295796 | 2020-07-02 | Grant | South Dakota | 46051 | 13 | 0 |
292640 | 292640 | 2020-07-01 | Grant | South Dakota | 46051 | 13 | 0 |
289488 | 289488 | 2020-06-30 | Grant | South Dakota | 46051 | 13 | 0 |
286337 | 286337 | 2020-06-29 | Grant | South Dakota | 46051 | 13 | 0 |
283192 | 283192 | 2020-06-28 | Grant | South Dakota | 46051 | 13 | 0 |
280046 | 280046 | 2020-06-27 | Grant | South Dakota | 46051 | 13 | 0 |
276898 | 276898 | 2020-06-26 | Grant | South Dakota | 46051 | 13 | 0 |
273751 | 273751 | 2020-06-25 | Grant | South Dakota | 46051 | 13 | 0 |
270612 | 270612 | 2020-06-24 | Grant | South Dakota | 46051 | 13 | 0 |
267478 | 267478 | 2020-06-23 | Grant | South Dakota | 46051 | 13 | 0 |
264350 | 264350 | 2020-06-22 | Grant | South Dakota | 46051 | 13 | 0 |
261222 | 261222 | 2020-06-21 | Grant | South Dakota | 46051 | 13 | 0 |
258095 | 258095 | 2020-06-20 | Grant | South Dakota | 46051 | 13 | 0 |
254969 | 254969 | 2020-06-19 | Grant | South Dakota | 46051 | 13 | 0 |
251854 | 251854 | 2020-06-18 | Grant | South Dakota | 46051 | 13 | 0 |
248739 | 248739 | 2020-06-17 | Grant | South Dakota | 46051 | 13 | 0 |
245626 | 245626 | 2020-06-16 | Grant | South Dakota | 46051 | 13 | 0 |
242514 | 242514 | 2020-06-15 | Grant | South Dakota | 46051 | 13 | 0 |
239404 | 239404 | 2020-06-14 | Grant | South Dakota | 46051 | 13 | 0 |
236296 | 236296 | 2020-06-13 | Grant | South Dakota | 46051 | 13 | 0 |
233191 | 233191 | 2020-06-12 | Grant | South Dakota | 46051 | 13 | 0 |
230086 | 230086 | 2020-06-11 | Grant | South Dakota | 46051 | 13 | 0 |
226982 | 226982 | 2020-06-10 | Grant | South Dakota | 46051 | 13 | 0 |
223882 | 223882 | 2020-06-09 | Grant | South Dakota | 46051 | 13 | 0 |
220787 | 220787 | 2020-06-08 | Grant | South Dakota | 46051 | 13 | 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);