ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
675 rows where county = "Jones" and fips = 46075 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
314803 | 314803 | 2020-07-08 | Jones | South Dakota | 46075 | 1 | 0 |
317976 | 317976 | 2020-07-09 | Jones | South Dakota | 46075 | 1 | 0 |
321154 | 321154 | 2020-07-10 | Jones | South Dakota | 46075 | 1 | 0 |
324334 | 324334 | 2020-07-11 | Jones | South Dakota | 46075 | 1 | 0 |
327519 | 327519 | 2020-07-12 | Jones | South Dakota | 46075 | 1 | 0 |
330705 | 330705 | 2020-07-13 | Jones | South Dakota | 46075 | 1 | 0 |
333897 | 333897 | 2020-07-14 | Jones | South Dakota | 46075 | 1 | 0 |
337091 | 337091 | 2020-07-15 | Jones | South Dakota | 46075 | 1 | 0 |
340288 | 340288 | 2020-07-16 | Jones | South Dakota | 46075 | 1 | 0 |
343486 | 343486 | 2020-07-17 | Jones | South Dakota | 46075 | 1 | 0 |
346686 | 346686 | 2020-07-18 | Jones | South Dakota | 46075 | 1 | 0 |
349886 | 349886 | 2020-07-19 | Jones | South Dakota | 46075 | 1 | 0 |
353089 | 353089 | 2020-07-20 | Jones | South Dakota | 46075 | 1 | 0 |
356292 | 356292 | 2020-07-21 | Jones | South Dakota | 46075 | 1 | 0 |
359496 | 359496 | 2020-07-22 | Jones | South Dakota | 46075 | 1 | 0 |
362702 | 362702 | 2020-07-23 | Jones | South Dakota | 46075 | 1 | 0 |
365908 | 365908 | 2020-07-24 | Jones | South Dakota | 46075 | 1 | 0 |
369117 | 369117 | 2020-07-25 | Jones | South Dakota | 46075 | 1 | 0 |
372329 | 372329 | 2020-07-26 | Jones | South Dakota | 46075 | 1 | 0 |
375542 | 375542 | 2020-07-27 | Jones | South Dakota | 46075 | 1 | 0 |
378758 | 378758 | 2020-07-28 | Jones | South Dakota | 46075 | 1 | 0 |
381975 | 381975 | 2020-07-29 | Jones | South Dakota | 46075 | 1 | 0 |
385193 | 385193 | 2020-07-30 | Jones | South Dakota | 46075 | 1 | 0 |
388410 | 388410 | 2020-07-31 | Jones | South Dakota | 46075 | 2 | 0 |
391627 | 391627 | 2020-08-01 | Jones | South Dakota | 46075 | 2 | 0 |
394843 | 394843 | 2020-08-02 | Jones | South Dakota | 46075 | 2 | 0 |
398060 | 398060 | 2020-08-03 | Jones | South Dakota | 46075 | 2 | 0 |
401275 | 401275 | 2020-08-04 | Jones | South Dakota | 46075 | 2 | 0 |
404493 | 404493 | 2020-08-05 | Jones | South Dakota | 46075 | 2 | 0 |
407713 | 407713 | 2020-08-06 | Jones | South Dakota | 46075 | 2 | 0 |
410932 | 410932 | 2020-08-07 | Jones | South Dakota | 46075 | 2 | 0 |
414152 | 414152 | 2020-08-08 | Jones | South Dakota | 46075 | 2 | 0 |
417373 | 417373 | 2020-08-09 | Jones | South Dakota | 46075 | 2 | 0 |
420594 | 420594 | 2020-08-10 | Jones | South Dakota | 46075 | 2 | 0 |
423816 | 423816 | 2020-08-11 | Jones | South Dakota | 46075 | 2 | 0 |
427039 | 427039 | 2020-08-12 | Jones | South Dakota | 46075 | 2 | 0 |
430266 | 430266 | 2020-08-13 | Jones | South Dakota | 46075 | 2 | 0 |
433491 | 433491 | 2020-08-14 | Jones | South Dakota | 46075 | 2 | 0 |
436718 | 436718 | 2020-08-15 | Jones | South Dakota | 46075 | 2 | 0 |
439943 | 439943 | 2020-08-16 | Jones | South Dakota | 46075 | 2 | 0 |
443170 | 443170 | 2020-08-17 | Jones | South Dakota | 46075 | 2 | 0 |
446396 | 446396 | 2020-08-18 | Jones | South Dakota | 46075 | 2 | 0 |
449624 | 449624 | 2020-08-19 | Jones | South Dakota | 46075 | 2 | 0 |
452852 | 452852 | 2020-08-20 | Jones | South Dakota | 46075 | 2 | 0 |
456080 | 456080 | 2020-08-21 | Jones | South Dakota | 46075 | 2 | 0 |
459308 | 459308 | 2020-08-22 | Jones | South Dakota | 46075 | 3 | 0 |
462536 | 462536 | 2020-08-23 | Jones | South Dakota | 46075 | 3 | 0 |
465765 | 465765 | 2020-08-24 | Jones | South Dakota | 46075 | 3 | 0 |
468993 | 468993 | 2020-08-25 | Jones | South Dakota | 46075 | 3 | 0 |
472225 | 472225 | 2020-08-26 | Jones | South Dakota | 46075 | 3 | 0 |
475459 | 475459 | 2020-08-27 | Jones | South Dakota | 46075 | 3 | 0 |
478692 | 478692 | 2020-08-28 | Jones | South Dakota | 46075 | 3 | 0 |
481926 | 481926 | 2020-08-29 | Jones | South Dakota | 46075 | 3 | 0 |
485161 | 485161 | 2020-08-30 | Jones | South Dakota | 46075 | 3 | 0 |
488394 | 488394 | 2020-08-31 | Jones | South Dakota | 46075 | 3 | 0 |
491627 | 491627 | 2020-09-01 | Jones | South Dakota | 46075 | 3 | 0 |
494861 | 494861 | 2020-09-02 | Jones | South Dakota | 46075 | 5 | 0 |
498094 | 498094 | 2020-09-03 | Jones | South Dakota | 46075 | 5 | 0 |
501328 | 501328 | 2020-09-04 | Jones | South Dakota | 46075 | 5 | 0 |
504562 | 504562 | 2020-09-05 | Jones | South Dakota | 46075 | 5 | 0 |
507794 | 507794 | 2020-09-06 | Jones | South Dakota | 46075 | 6 | 0 |
511027 | 511027 | 2020-09-07 | Jones | South Dakota | 46075 | 6 | 0 |
514260 | 514260 | 2020-09-08 | Jones | South Dakota | 46075 | 6 | 0 |
517495 | 517495 | 2020-09-09 | Jones | South Dakota | 46075 | 6 | 0 |
520731 | 520731 | 2020-09-10 | Jones | South Dakota | 46075 | 6 | 0 |
523967 | 523967 | 2020-09-11 | Jones | South Dakota | 46075 | 6 | 0 |
527203 | 527203 | 2020-09-12 | Jones | South Dakota | 46075 | 6 | 0 |
530440 | 530440 | 2020-09-13 | Jones | South Dakota | 46075 | 6 | 0 |
533675 | 533675 | 2020-09-14 | Jones | South Dakota | 46075 | 6 | 0 |
536911 | 536911 | 2020-09-15 | Jones | South Dakota | 46075 | 6 | 0 |
540148 | 540148 | 2020-09-16 | Jones | South Dakota | 46075 | 6 | 0 |
543384 | 543384 | 2020-09-17 | Jones | South Dakota | 46075 | 6 | 0 |
546621 | 546621 | 2020-09-18 | Jones | South Dakota | 46075 | 6 | 0 |
549860 | 549860 | 2020-09-19 | Jones | South Dakota | 46075 | 7 | 0 |
553099 | 553099 | 2020-09-20 | Jones | South Dakota | 46075 | 7 | 0 |
556336 | 556336 | 2020-09-21 | Jones | South Dakota | 46075 | 7 | 0 |
559573 | 559573 | 2020-09-22 | Jones | South Dakota | 46075 | 7 | 0 |
562810 | 562810 | 2020-09-23 | Jones | South Dakota | 46075 | 7 | 0 |
566051 | 566051 | 2020-09-24 | Jones | South Dakota | 46075 | 7 | 0 |
569292 | 569292 | 2020-09-25 | Jones | South Dakota | 46075 | 10 | 0 |
572534 | 572534 | 2020-09-26 | Jones | South Dakota | 46075 | 13 | 0 |
575778 | 575778 | 2020-09-27 | Jones | South Dakota | 46075 | 13 | 0 |
579019 | 579019 | 2020-09-28 | Jones | South Dakota | 46075 | 13 | 0 |
582259 | 582259 | 2020-09-29 | Jones | South Dakota | 46075 | 14 | 0 |
585499 | 585499 | 2020-09-30 | Jones | South Dakota | 46075 | 14 | 0 |
588739 | 588739 | 2020-10-01 | Jones | South Dakota | 46075 | 17 | 0 |
591980 | 591980 | 2020-10-02 | Jones | South Dakota | 46075 | 17 | 0 |
595221 | 595221 | 2020-10-03 | Jones | South Dakota | 46075 | 18 | 0 |
598464 | 598464 | 2020-10-04 | Jones | South Dakota | 46075 | 18 | 0 |
601707 | 601707 | 2020-10-05 | Jones | South Dakota | 46075 | 19 | 0 |
604949 | 604949 | 2020-10-06 | Jones | South Dakota | 46075 | 19 | 0 |
608192 | 608192 | 2020-10-07 | Jones | South Dakota | 46075 | 20 | 0 |
611434 | 611434 | 2020-10-08 | Jones | South Dakota | 46075 | 20 | 0 |
614675 | 614675 | 2020-10-09 | Jones | South Dakota | 46075 | 20 | 0 |
617917 | 617917 | 2020-10-10 | Jones | South Dakota | 46075 | 20 | 0 |
621160 | 621160 | 2020-10-11 | Jones | South Dakota | 46075 | 20 | 0 |
624403 | 624403 | 2020-10-12 | Jones | South Dakota | 46075 | 20 | 0 |
627645 | 627645 | 2020-10-13 | Jones | South Dakota | 46075 | 22 | 0 |
630889 | 630889 | 2020-10-14 | Jones | South Dakota | 46075 | 23 | 0 |
634134 | 634134 | 2020-10-15 | Jones | South Dakota | 46075 | 24 | 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);