ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
698 rows where fips = 46007 and state = "South Dakota" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
242494 | 242494 | 2020-06-15 | Bennett | South Dakota | 46007 | 1 | 0 |
245606 | 245606 | 2020-06-16 | Bennett | South Dakota | 46007 | 1 | 0 |
248719 | 248719 | 2020-06-17 | Bennett | South Dakota | 46007 | 2 | 0 |
251834 | 251834 | 2020-06-18 | Bennett | South Dakota | 46007 | 2 | 0 |
254949 | 254949 | 2020-06-19 | Bennett | South Dakota | 46007 | 2 | 0 |
258075 | 258075 | 2020-06-20 | Bennett | South Dakota | 46007 | 2 | 0 |
261202 | 261202 | 2020-06-21 | Bennett | South Dakota | 46007 | 2 | 0 |
264330 | 264330 | 2020-06-22 | Bennett | South Dakota | 46007 | 2 | 0 |
267458 | 267458 | 2020-06-23 | Bennett | South Dakota | 46007 | 3 | 0 |
270592 | 270592 | 2020-06-24 | Bennett | South Dakota | 46007 | 3 | 0 |
273731 | 273731 | 2020-06-25 | Bennett | South Dakota | 46007 | 4 | 0 |
276878 | 276878 | 2020-06-26 | Bennett | South Dakota | 46007 | 4 | 0 |
280026 | 280026 | 2020-06-27 | Bennett | South Dakota | 46007 | 5 | 0 |
283172 | 283172 | 2020-06-28 | Bennett | South Dakota | 46007 | 5 | 0 |
286317 | 286317 | 2020-06-29 | Bennett | South Dakota | 46007 | 5 | 0 |
289468 | 289468 | 2020-06-30 | Bennett | South Dakota | 46007 | 4 | 0 |
292620 | 292620 | 2020-07-01 | Bennett | South Dakota | 46007 | 4 | 0 |
295776 | 295776 | 2020-07-02 | Bennett | South Dakota | 46007 | 4 | 0 |
298935 | 298935 | 2020-07-03 | Bennett | South Dakota | 46007 | 4 | 0 |
302099 | 302099 | 2020-07-04 | Bennett | South Dakota | 46007 | 4 | 0 |
305262 | 305262 | 2020-07-05 | Bennett | South Dakota | 46007 | 4 | 0 |
308429 | 308429 | 2020-07-06 | Bennett | South Dakota | 46007 | 4 | 0 |
311598 | 311598 | 2020-07-07 | Bennett | South Dakota | 46007 | 4 | 0 |
314770 | 314770 | 2020-07-08 | Bennett | South Dakota | 46007 | 4 | 0 |
317943 | 317943 | 2020-07-09 | Bennett | South Dakota | 46007 | 4 | 0 |
321121 | 321121 | 2020-07-10 | Bennett | South Dakota | 46007 | 4 | 0 |
324301 | 324301 | 2020-07-11 | Bennett | South Dakota | 46007 | 4 | 0 |
327486 | 327486 | 2020-07-12 | Bennett | South Dakota | 46007 | 4 | 0 |
330672 | 330672 | 2020-07-13 | Bennett | South Dakota | 46007 | 4 | 0 |
333864 | 333864 | 2020-07-14 | Bennett | South Dakota | 46007 | 4 | 0 |
337058 | 337058 | 2020-07-15 | Bennett | South Dakota | 46007 | 4 | 0 |
340255 | 340255 | 2020-07-16 | Bennett | South Dakota | 46007 | 4 | 0 |
343453 | 343453 | 2020-07-17 | Bennett | South Dakota | 46007 | 4 | 0 |
346653 | 346653 | 2020-07-18 | Bennett | South Dakota | 46007 | 4 | 0 |
349853 | 349853 | 2020-07-19 | Bennett | South Dakota | 46007 | 5 | 0 |
353056 | 353056 | 2020-07-20 | Bennett | South Dakota | 46007 | 5 | 0 |
356259 | 356259 | 2020-07-21 | Bennett | South Dakota | 46007 | 5 | 0 |
359463 | 359463 | 2020-07-22 | Bennett | South Dakota | 46007 | 5 | 0 |
362669 | 362669 | 2020-07-23 | Bennett | South Dakota | 46007 | 5 | 0 |
365875 | 365875 | 2020-07-24 | Bennett | South Dakota | 46007 | 5 | 0 |
369084 | 369084 | 2020-07-25 | Bennett | South Dakota | 46007 | 5 | 0 |
372296 | 372296 | 2020-07-26 | Bennett | South Dakota | 46007 | 5 | 0 |
375509 | 375509 | 2020-07-27 | Bennett | South Dakota | 46007 | 5 | 0 |
378725 | 378725 | 2020-07-28 | Bennett | South Dakota | 46007 | 5 | 0 |
381942 | 381942 | 2020-07-29 | Bennett | South Dakota | 46007 | 5 | 0 |
385160 | 385160 | 2020-07-30 | Bennett | South Dakota | 46007 | 5 | 0 |
388377 | 388377 | 2020-07-31 | Bennett | South Dakota | 46007 | 5 | 0 |
391594 | 391594 | 2020-08-01 | Bennett | South Dakota | 46007 | 5 | 0 |
394810 | 394810 | 2020-08-02 | Bennett | South Dakota | 46007 | 6 | 0 |
398027 | 398027 | 2020-08-03 | Bennett | South Dakota | 46007 | 6 | 0 |
401242 | 401242 | 2020-08-04 | Bennett | South Dakota | 46007 | 6 | 0 |
404460 | 404460 | 2020-08-05 | Bennett | South Dakota | 46007 | 6 | 0 |
407680 | 407680 | 2020-08-06 | Bennett | South Dakota | 46007 | 6 | 0 |
410899 | 410899 | 2020-08-07 | Bennett | South Dakota | 46007 | 6 | 0 |
414119 | 414119 | 2020-08-08 | Bennett | South Dakota | 46007 | 6 | 0 |
417340 | 417340 | 2020-08-09 | Bennett | South Dakota | 46007 | 6 | 0 |
420561 | 420561 | 2020-08-10 | Bennett | South Dakota | 46007 | 6 | 0 |
423783 | 423783 | 2020-08-11 | Bennett | South Dakota | 46007 | 6 | 0 |
427006 | 427006 | 2020-08-12 | Bennett | South Dakota | 46007 | 6 | 0 |
430232 | 430232 | 2020-08-13 | Bennett | South Dakota | 46007 | 6 | 0 |
433457 | 433457 | 2020-08-14 | Bennett | South Dakota | 46007 | 6 | 0 |
436684 | 436684 | 2020-08-15 | Bennett | South Dakota | 46007 | 6 | 0 |
439909 | 439909 | 2020-08-16 | Bennett | South Dakota | 46007 | 6 | 0 |
443136 | 443136 | 2020-08-17 | Bennett | South Dakota | 46007 | 6 | 0 |
446362 | 446362 | 2020-08-18 | Bennett | South Dakota | 46007 | 6 | 0 |
449590 | 449590 | 2020-08-19 | Bennett | South Dakota | 46007 | 6 | 0 |
452818 | 452818 | 2020-08-20 | Bennett | South Dakota | 46007 | 6 | 0 |
456046 | 456046 | 2020-08-21 | Bennett | South Dakota | 46007 | 6 | 0 |
459274 | 459274 | 2020-08-22 | Bennett | South Dakota | 46007 | 6 | 0 |
462502 | 462502 | 2020-08-23 | Bennett | South Dakota | 46007 | 6 | 0 |
465731 | 465731 | 2020-08-24 | Bennett | South Dakota | 46007 | 11 | 0 |
468959 | 468959 | 2020-08-25 | Bennett | South Dakota | 46007 | 11 | 0 |
472191 | 472191 | 2020-08-26 | Bennett | South Dakota | 46007 | 13 | 0 |
475425 | 475425 | 2020-08-27 | Bennett | South Dakota | 46007 | 18 | 0 |
478658 | 478658 | 2020-08-28 | Bennett | South Dakota | 46007 | 20 | 0 |
481892 | 481892 | 2020-08-29 | Bennett | South Dakota | 46007 | 21 | 0 |
485127 | 485127 | 2020-08-30 | Bennett | South Dakota | 46007 | 22 | 0 |
488360 | 488360 | 2020-08-31 | Bennett | South Dakota | 46007 | 23 | 0 |
491593 | 491593 | 2020-09-01 | Bennett | South Dakota | 46007 | 23 | 0 |
494827 | 494827 | 2020-09-02 | Bennett | South Dakota | 46007 | 24 | 0 |
498060 | 498060 | 2020-09-03 | Bennett | South Dakota | 46007 | 29 | 0 |
501294 | 501294 | 2020-09-04 | Bennett | South Dakota | 46007 | 30 | 0 |
504528 | 504528 | 2020-09-05 | Bennett | South Dakota | 46007 | 32 | 0 |
507760 | 507760 | 2020-09-06 | Bennett | South Dakota | 46007 | 33 | 0 |
510993 | 510993 | 2020-09-07 | Bennett | South Dakota | 46007 | 33 | 0 |
514226 | 514226 | 2020-09-08 | Bennett | South Dakota | 46007 | 34 | 0 |
517461 | 517461 | 2020-09-09 | Bennett | South Dakota | 46007 | 35 | 0 |
520697 | 520697 | 2020-09-10 | Bennett | South Dakota | 46007 | 37 | 1 |
523933 | 523933 | 2020-09-11 | Bennett | South Dakota | 46007 | 42 | 1 |
527169 | 527169 | 2020-09-12 | Bennett | South Dakota | 46007 | 42 | 1 |
530406 | 530406 | 2020-09-13 | Bennett | South Dakota | 46007 | 44 | 1 |
533641 | 533641 | 2020-09-14 | Bennett | South Dakota | 46007 | 44 | 1 |
536877 | 536877 | 2020-09-15 | Bennett | South Dakota | 46007 | 44 | 1 |
540114 | 540114 | 2020-09-16 | Bennett | South Dakota | 46007 | 45 | 1 |
543350 | 543350 | 2020-09-17 | Bennett | South Dakota | 46007 | 45 | 1 |
546587 | 546587 | 2020-09-18 | Bennett | South Dakota | 46007 | 57 | 1 |
549826 | 549826 | 2020-09-19 | Bennett | South Dakota | 46007 | 63 | 1 |
553065 | 553065 | 2020-09-20 | Bennett | South Dakota | 46007 | 63 | 1 |
556302 | 556302 | 2020-09-21 | Bennett | South Dakota | 46007 | 62 | 1 |
559539 | 559539 | 2020-09-22 | Bennett | South Dakota | 46007 | 62 | 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);