ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Washington" and fips = 22117 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921617 | 921617 | 2021-01-12 | Washington | Louisiana | 22117 | 3413 | 97 |
918372 | 918372 | 2021-01-11 | Washington | Louisiana | 22117 | 3389 | 97 |
915127 | 915127 | 2021-01-10 | Washington | Louisiana | 22117 | 3381 | 96 |
911882 | 911882 | 2021-01-09 | Washington | Louisiana | 22117 | 3353 | 96 |
908637 | 908637 | 2021-01-08 | Washington | Louisiana | 22117 | 3353 | 96 |
905391 | 905391 | 2021-01-07 | Washington | Louisiana | 22117 | 3326 | 90 |
902146 | 902146 | 2021-01-06 | Washington | Louisiana | 22117 | 3267 | 90 |
898901 | 898901 | 2021-01-05 | Washington | Louisiana | 22117 | 3231 | 90 |
895656 | 895656 | 2021-01-04 | Washington | Louisiana | 22117 | 3206 | 90 |
892409 | 892409 | 2021-01-03 | Washington | Louisiana | 22117 | 3197 | 87 |
889163 | 889163 | 2021-01-02 | Washington | Louisiana | 22117 | 3135 | 87 |
885917 | 885917 | 2021-01-01 | Washington | Louisiana | 22117 | 3135 | 87 |
882672 | 882672 | 2020-12-31 | Washington | Louisiana | 22117 | 3135 | 87 |
879427 | 879427 | 2020-12-30 | Washington | Louisiana | 22117 | 3107 | 87 |
876182 | 876182 | 2020-12-29 | Washington | Louisiana | 22117 | 3070 | 86 |
872937 | 872937 | 2020-12-28 | Washington | Louisiana | 22117 | 3041 | 86 |
869692 | 869692 | 2020-12-27 | Washington | Louisiana | 22117 | 3030 | 86 |
866447 | 866447 | 2020-12-26 | Washington | Louisiana | 22117 | 2998 | 86 |
863202 | 863202 | 2020-12-25 | Washington | Louisiana | 22117 | 2998 | 86 |
859957 | 859957 | 2020-12-24 | Washington | Louisiana | 22117 | 2998 | 86 |
856712 | 856712 | 2020-12-23 | Washington | Louisiana | 22117 | 2970 | 83 |
853467 | 853467 | 2020-12-22 | Washington | Louisiana | 22117 | 2897 | 82 |
850222 | 850222 | 2020-12-21 | Washington | Louisiana | 22117 | 2852 | 82 |
846977 | 846977 | 2020-12-20 | Washington | Louisiana | 22117 | 2832 | 82 |
843731 | 843731 | 2020-12-19 | Washington | Louisiana | 22117 | 2809 | 82 |
840486 | 840486 | 2020-12-18 | Washington | Louisiana | 22117 | 2809 | 82 |
837241 | 837241 | 2020-12-17 | Washington | Louisiana | 22117 | 2772 | 82 |
833995 | 833995 | 2020-12-16 | Washington | Louisiana | 22117 | 2709 | 82 |
830748 | 830748 | 2020-12-15 | Washington | Louisiana | 22117 | 2655 | 81 |
827502 | 827502 | 2020-12-14 | Washington | Louisiana | 22117 | 2602 | 81 |
824255 | 824255 | 2020-12-13 | Washington | Louisiana | 22117 | 2583 | 81 |
821009 | 821009 | 2020-12-12 | Washington | Louisiana | 22117 | 2541 | 80 |
817763 | 817763 | 2020-12-11 | Washington | Louisiana | 22117 | 2541 | 80 |
814517 | 814517 | 2020-12-10 | Washington | Louisiana | 22117 | 2501 | 80 |
811272 | 811272 | 2020-12-09 | Washington | Louisiana | 22117 | 2480 | 79 |
808027 | 808027 | 2020-12-08 | Washington | Louisiana | 22117 | 2438 | 79 |
804782 | 804782 | 2020-12-07 | Washington | Louisiana | 22117 | 2424 | 79 |
801537 | 801537 | 2020-12-06 | Washington | Louisiana | 22117 | 2405 | 79 |
798292 | 798292 | 2020-12-05 | Washington | Louisiana | 22117 | 2367 | 80 |
795047 | 795047 | 2020-12-04 | Washington | Louisiana | 22117 | 2367 | 80 |
791802 | 791802 | 2020-12-03 | Washington | Louisiana | 22117 | 2354 | 79 |
788557 | 788557 | 2020-12-02 | Washington | Louisiana | 22117 | 2343 | 79 |
785313 | 785313 | 2020-12-01 | Washington | Louisiana | 22117 | 2313 | 79 |
782068 | 782068 | 2020-11-30 | Washington | Louisiana | 22117 | 2278 | 78 |
778822 | 778822 | 2020-11-29 | Washington | Louisiana | 22117 | 2275 | 78 |
775577 | 775577 | 2020-11-28 | Washington | Louisiana | 22117 | 2264 | 78 |
772332 | 772332 | 2020-11-27 | Washington | Louisiana | 22117 | 2264 | 78 |
769087 | 769087 | 2020-11-26 | Washington | Louisiana | 22117 | 2211 | 77 |
765841 | 765841 | 2020-11-25 | Washington | Louisiana | 22117 | 2211 | 77 |
762596 | 762596 | 2020-11-24 | Washington | Louisiana | 22117 | 2200 | 76 |
759351 | 759351 | 2020-11-23 | Washington | Louisiana | 22117 | 2173 | 76 |
756104 | 756104 | 2020-11-22 | Washington | Louisiana | 22117 | 2166 | 75 |
752858 | 752858 | 2020-11-21 | Washington | Louisiana | 22117 | 2150 | 75 |
749612 | 749612 | 2020-11-20 | Washington | Louisiana | 22117 | 2150 | 75 |
746366 | 746366 | 2020-11-19 | Washington | Louisiana | 22117 | 2096 | 75 |
743119 | 743119 | 2020-11-18 | Washington | Louisiana | 22117 | 2094 | 74 |
739872 | 739872 | 2020-11-17 | Washington | Louisiana | 22117 | 2061 | 74 |
736628 | 736628 | 2020-11-16 | Washington | Louisiana | 22117 | 2059 | 74 |
733382 | 733382 | 2020-11-15 | Washington | Louisiana | 22117 | 2053 | 74 |
730137 | 730137 | 2020-11-14 | Washington | Louisiana | 22117 | 2038 | 74 |
726894 | 726894 | 2020-11-13 | Washington | Louisiana | 22117 | 2038 | 74 |
723651 | 723651 | 2020-11-12 | Washington | Louisiana | 22117 | 1800 | 73 |
720408 | 720408 | 2020-11-11 | Washington | Louisiana | 22117 | 1797 | 72 |
717165 | 717165 | 2020-11-10 | Washington | Louisiana | 22117 | 1797 | 72 |
713921 | 713921 | 2020-11-09 | Washington | Louisiana | 22117 | 1787 | 72 |
710677 | 710677 | 2020-11-08 | Washington | Louisiana | 22117 | 1783 | 72 |
707433 | 707433 | 2020-11-07 | Washington | Louisiana | 22117 | 1778 | 72 |
704190 | 704190 | 2020-11-06 | Washington | Louisiana | 22117 | 1778 | 72 |
700948 | 700948 | 2020-11-05 | Washington | Louisiana | 22117 | 1770 | 72 |
697704 | 697704 | 2020-11-04 | Washington | Louisiana | 22117 | 1771 | 72 |
694461 | 694461 | 2020-11-03 | Washington | Louisiana | 22117 | 1764 | 72 |
691219 | 691219 | 2020-11-02 | Washington | Louisiana | 22117 | 1759 | 72 |
687974 | 687974 | 2020-11-01 | Washington | Louisiana | 22117 | 1757 | 72 |
684730 | 684730 | 2020-10-31 | Washington | Louisiana | 22117 | 1753 | 72 |
681487 | 681487 | 2020-10-30 | Washington | Louisiana | 22117 | 1753 | 72 |
678243 | 678243 | 2020-10-29 | Washington | Louisiana | 22117 | 1751 | 72 |
675001 | 675001 | 2020-10-28 | Washington | Louisiana | 22117 | 1752 | 71 |
671758 | 671758 | 2020-10-27 | Washington | Louisiana | 22117 | 1747 | 71 |
668516 | 668516 | 2020-10-26 | Washington | Louisiana | 22117 | 1748 | 71 |
665272 | 665272 | 2020-10-25 | Washington | Louisiana | 22117 | 1748 | 71 |
662027 | 662027 | 2020-10-24 | Washington | Louisiana | 22117 | 1737 | 71 |
658783 | 658783 | 2020-10-23 | Washington | Louisiana | 22117 | 1737 | 71 |
655538 | 655538 | 2020-10-22 | Washington | Louisiana | 22117 | 1732 | 70 |
652293 | 652293 | 2020-10-21 | Washington | Louisiana | 22117 | 1731 | 70 |
649048 | 649048 | 2020-10-20 | Washington | Louisiana | 22117 | 1725 | 70 |
645804 | 645804 | 2020-10-19 | Washington | Louisiana | 22117 | 1720 | 70 |
642557 | 642557 | 2020-10-18 | Washington | Louisiana | 22117 | 1720 | 68 |
639310 | 639310 | 2020-10-17 | Washington | Louisiana | 22117 | 1708 | 68 |
636064 | 636064 | 2020-10-16 | Washington | Louisiana | 22117 | 1708 | 68 |
632818 | 632818 | 2020-10-15 | Washington | Louisiana | 22117 | 1710 | 68 |
629574 | 629574 | 2020-10-14 | Washington | Louisiana | 22117 | 1703 | 68 |
626330 | 626330 | 2020-10-13 | Washington | Louisiana | 22117 | 1699 | 68 |
623088 | 623088 | 2020-10-12 | Washington | Louisiana | 22117 | 1691 | 68 |
619844 | 619844 | 2020-10-11 | Washington | Louisiana | 22117 | 1692 | 67 |
616602 | 616602 | 2020-10-10 | Washington | Louisiana | 22117 | 1683 | 67 |
613361 | 613361 | 2020-10-09 | Washington | Louisiana | 22117 | 1683 | 67 |
610119 | 610119 | 2020-10-08 | Washington | Louisiana | 22117 | 1682 | 67 |
606877 | 606877 | 2020-10-07 | Washington | Louisiana | 22117 | 1675 | 67 |
603635 | 603635 | 2020-10-06 | Washington | Louisiana | 22117 | 1665 | 67 |
600392 | 600392 | 2020-10-05 | Washington | Louisiana | 22117 | 1659 | 67 |
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);