ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where county = "East Carroll", deaths = 6 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
739830 | 739830 | 2020-11-17 | East Carroll | Louisiana | 22035 | 648 | 6 |
736586 | 736586 | 2020-11-16 | East Carroll | Louisiana | 22035 | 643 | 6 |
733340 | 733340 | 2020-11-15 | East Carroll | Louisiana | 22035 | 641 | 6 |
730095 | 730095 | 2020-11-14 | East Carroll | Louisiana | 22035 | 627 | 6 |
726852 | 726852 | 2020-11-13 | East Carroll | Louisiana | 22035 | 627 | 6 |
723609 | 723609 | 2020-11-12 | East Carroll | Louisiana | 22035 | 614 | 6 |
720366 | 720366 | 2020-11-11 | East Carroll | Louisiana | 22035 | 606 | 6 |
717123 | 717123 | 2020-11-10 | East Carroll | Louisiana | 22035 | 606 | 6 |
713879 | 713879 | 2020-11-09 | East Carroll | Louisiana | 22035 | 606 | 6 |
710635 | 710635 | 2020-11-08 | East Carroll | Louisiana | 22035 | 601 | 6 |
707391 | 707391 | 2020-11-07 | East Carroll | Louisiana | 22035 | 597 | 6 |
704148 | 704148 | 2020-11-06 | East Carroll | Louisiana | 22035 | 597 | 6 |
700906 | 700906 | 2020-11-05 | East Carroll | Louisiana | 22035 | 593 | 6 |
697662 | 697662 | 2020-11-04 | East Carroll | Louisiana | 22035 | 593 | 6 |
694419 | 694419 | 2020-11-03 | East Carroll | Louisiana | 22035 | 594 | 6 |
691177 | 691177 | 2020-11-02 | East Carroll | Louisiana | 22035 | 591 | 6 |
687932 | 687932 | 2020-11-01 | East Carroll | Louisiana | 22035 | 589 | 6 |
684688 | 684688 | 2020-10-31 | East Carroll | Louisiana | 22035 | 586 | 6 |
681445 | 681445 | 2020-10-30 | East Carroll | Louisiana | 22035 | 586 | 6 |
678201 | 678201 | 2020-10-29 | East Carroll | Louisiana | 22035 | 585 | 6 |
674959 | 674959 | 2020-10-28 | East Carroll | Louisiana | 22035 | 584 | 6 |
671716 | 671716 | 2020-10-27 | East Carroll | Louisiana | 22035 | 586 | 6 |
668474 | 668474 | 2020-10-26 | East Carroll | Louisiana | 22035 | 582 | 6 |
665230 | 665230 | 2020-10-25 | East Carroll | Louisiana | 22035 | 582 | 6 |
661985 | 661985 | 2020-10-24 | East Carroll | Louisiana | 22035 | 578 | 6 |
658741 | 658741 | 2020-10-23 | East Carroll | Louisiana | 22035 | 578 | 6 |
655496 | 655496 | 2020-10-22 | East Carroll | Louisiana | 22035 | 576 | 6 |
652251 | 652251 | 2020-10-21 | East Carroll | Louisiana | 22035 | 575 | 6 |
649006 | 649006 | 2020-10-20 | East Carroll | Louisiana | 22035 | 573 | 6 |
645762 | 645762 | 2020-10-19 | East Carroll | Louisiana | 22035 | 568 | 6 |
642515 | 642515 | 2020-10-18 | East Carroll | Louisiana | 22035 | 564 | 6 |
639268 | 639268 | 2020-10-17 | East Carroll | Louisiana | 22035 | 563 | 6 |
636022 | 636022 | 2020-10-16 | East Carroll | Louisiana | 22035 | 563 | 6 |
632776 | 632776 | 2020-10-15 | East Carroll | Louisiana | 22035 | 558 | 6 |
629532 | 629532 | 2020-10-14 | East Carroll | Louisiana | 22035 | 557 | 6 |
626288 | 626288 | 2020-10-13 | East Carroll | Louisiana | 22035 | 558 | 6 |
623046 | 623046 | 2020-10-12 | East Carroll | Louisiana | 22035 | 554 | 6 |
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);