ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Plaquemines" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947558 | 947558 | 2021-01-20 | Plaquemines | Louisiana | 22075 | 2004 | 22 |
944311 | 944311 | 2021-01-19 | Plaquemines | Louisiana | 22075 | 1980 | 22 |
941066 | 941066 | 2021-01-18 | Plaquemines | Louisiana | 22075 | 1978 | 22 |
937821 | 937821 | 2021-01-17 | Plaquemines | Louisiana | 22075 | 1975 | 22 |
934576 | 934576 | 2021-01-16 | Plaquemines | Louisiana | 22075 | 1957 | 21 |
931331 | 931331 | 2021-01-15 | Plaquemines | Louisiana | 22075 | 1957 | 21 |
928086 | 928086 | 2021-01-14 | Plaquemines | Louisiana | 22075 | 1944 | 21 |
924840 | 924840 | 2021-01-13 | Plaquemines | Louisiana | 22075 | 1921 | 22 |
921595 | 921595 | 2021-01-12 | Plaquemines | Louisiana | 22075 | 1905 | 22 |
918350 | 918350 | 2021-01-11 | Plaquemines | Louisiana | 22075 | 1864 | 22 |
915105 | 915105 | 2021-01-10 | Plaquemines | Louisiana | 22075 | 1856 | 22 |
911860 | 911860 | 2021-01-09 | Plaquemines | Louisiana | 22075 | 1832 | 21 |
908615 | 908615 | 2021-01-08 | Plaquemines | Louisiana | 22075 | 1832 | 21 |
905369 | 905369 | 2021-01-07 | Plaquemines | Louisiana | 22075 | 1814 | 21 |
902124 | 902124 | 2021-01-06 | Plaquemines | Louisiana | 22075 | 1792 | 21 |
898879 | 898879 | 2021-01-05 | Plaquemines | Louisiana | 22075 | 1752 | 21 |
895634 | 895634 | 2021-01-04 | Plaquemines | Louisiana | 22075 | 1736 | 21 |
892387 | 892387 | 2021-01-03 | Plaquemines | Louisiana | 22075 | 1736 | 21 |
889141 | 889141 | 2021-01-02 | Plaquemines | Louisiana | 22075 | 1708 | 21 |
885895 | 885895 | 2021-01-01 | Plaquemines | Louisiana | 22075 | 1708 | 21 |
882650 | 882650 | 2020-12-31 | Plaquemines | Louisiana | 22075 | 1708 | 21 |
879405 | 879405 | 2020-12-30 | Plaquemines | Louisiana | 22075 | 1695 | 21 |
876160 | 876160 | 2020-12-29 | Plaquemines | Louisiana | 22075 | 1631 | 21 |
872915 | 872915 | 2020-12-28 | Plaquemines | Louisiana | 22075 | 1616 | 20 |
869670 | 869670 | 2020-12-27 | Plaquemines | Louisiana | 22075 | 1610 | 20 |
866425 | 866425 | 2020-12-26 | Plaquemines | Louisiana | 22075 | 1593 | 20 |
863180 | 863180 | 2020-12-25 | Plaquemines | Louisiana | 22075 | 1593 | 20 |
859935 | 859935 | 2020-12-24 | Plaquemines | Louisiana | 22075 | 1593 | 20 |
856690 | 856690 | 2020-12-23 | Plaquemines | Louisiana | 22075 | 1588 | 20 |
853445 | 853445 | 2020-12-22 | Plaquemines | Louisiana | 22075 | 1578 | 20 |
850200 | 850200 | 2020-12-21 | Plaquemines | Louisiana | 22075 | 1555 | 20 |
846955 | 846955 | 2020-12-20 | Plaquemines | Louisiana | 22075 | 1546 | 20 |
843709 | 843709 | 2020-12-19 | Plaquemines | Louisiana | 22075 | 1528 | 20 |
840464 | 840464 | 2020-12-18 | Plaquemines | Louisiana | 22075 | 1528 | 20 |
837219 | 837219 | 2020-12-17 | Plaquemines | Louisiana | 22075 | 1504 | 20 |
833973 | 833973 | 2020-12-16 | Plaquemines | Louisiana | 22075 | 1482 | 20 |
830726 | 830726 | 2020-12-15 | Plaquemines | Louisiana | 22075 | 1470 | 20 |
827480 | 827480 | 2020-12-14 | Plaquemines | Louisiana | 22075 | 1450 | 20 |
824233 | 824233 | 2020-12-13 | Plaquemines | Louisiana | 22075 | 1436 | 20 |
820987 | 820987 | 2020-12-12 | Plaquemines | Louisiana | 22075 | 1413 | 20 |
817741 | 817741 | 2020-12-11 | Plaquemines | Louisiana | 22075 | 1413 | 20 |
814495 | 814495 | 2020-12-10 | Plaquemines | Louisiana | 22075 | 1394 | 20 |
811250 | 811250 | 2020-12-09 | Plaquemines | Louisiana | 22075 | 1376 | 20 |
808005 | 808005 | 2020-12-08 | Plaquemines | Louisiana | 22075 | 1355 | 20 |
804760 | 804760 | 2020-12-07 | Plaquemines | Louisiana | 22075 | 1325 | 20 |
801515 | 801515 | 2020-12-06 | Plaquemines | Louisiana | 22075 | 1321 | 20 |
798270 | 798270 | 2020-12-05 | Plaquemines | Louisiana | 22075 | 1278 | 20 |
795025 | 795025 | 2020-12-04 | Plaquemines | Louisiana | 22075 | 1278 | 20 |
791780 | 791780 | 2020-12-03 | Plaquemines | Louisiana | 22075 | 1258 | 20 |
788535 | 788535 | 2020-12-02 | Plaquemines | Louisiana | 22075 | 1222 | 20 |
785291 | 785291 | 2020-12-01 | Plaquemines | Louisiana | 22075 | 1180 | 20 |
782046 | 782046 | 2020-11-30 | Plaquemines | Louisiana | 22075 | 1147 | 19 |
778800 | 778800 | 2020-11-29 | Plaquemines | Louisiana | 22075 | 1146 | 19 |
775555 | 775555 | 2020-11-28 | Plaquemines | Louisiana | 22075 | 1132 | 19 |
772310 | 772310 | 2020-11-27 | Plaquemines | Louisiana | 22075 | 1132 | 19 |
769065 | 769065 | 2020-11-26 | Plaquemines | Louisiana | 22075 | 1099 | 19 |
765819 | 765819 | 2020-11-25 | Plaquemines | Louisiana | 22075 | 1099 | 19 |
762574 | 762574 | 2020-11-24 | Plaquemines | Louisiana | 22075 | 1084 | 19 |
759329 | 759329 | 2020-11-23 | Plaquemines | Louisiana | 22075 | 1071 | 19 |
756082 | 756082 | 2020-11-22 | Plaquemines | Louisiana | 22075 | 1070 | 19 |
752836 | 752836 | 2020-11-21 | Plaquemines | Louisiana | 22075 | 1057 | 19 |
749590 | 749590 | 2020-11-20 | Plaquemines | Louisiana | 22075 | 1057 | 19 |
746344 | 746344 | 2020-11-19 | Plaquemines | Louisiana | 22075 | 1048 | 19 |
743097 | 743097 | 2020-11-18 | Plaquemines | Louisiana | 22075 | 1036 | 19 |
739850 | 739850 | 2020-11-17 | Plaquemines | Louisiana | 22075 | 1022 | 19 |
736606 | 736606 | 2020-11-16 | Plaquemines | Louisiana | 22075 | 1017 | 19 |
733360 | 733360 | 2020-11-15 | Plaquemines | Louisiana | 22075 | 1017 | 19 |
730115 | 730115 | 2020-11-14 | Plaquemines | Louisiana | 22075 | 1009 | 19 |
726872 | 726872 | 2020-11-13 | Plaquemines | Louisiana | 22075 | 1009 | 19 |
723629 | 723629 | 2020-11-12 | Plaquemines | Louisiana | 22075 | 932 | 19 |
720386 | 720386 | 2020-11-11 | Plaquemines | Louisiana | 22075 | 924 | 19 |
717143 | 717143 | 2020-11-10 | Plaquemines | Louisiana | 22075 | 924 | 19 |
713899 | 713899 | 2020-11-09 | Plaquemines | Louisiana | 22075 | 913 | 19 |
710655 | 710655 | 2020-11-08 | Plaquemines | Louisiana | 22075 | 916 | 19 |
707411 | 707411 | 2020-11-07 | Plaquemines | Louisiana | 22075 | 913 | 19 |
704168 | 704168 | 2020-11-06 | Plaquemines | Louisiana | 22075 | 913 | 19 |
700926 | 700926 | 2020-11-05 | Plaquemines | Louisiana | 22075 | 911 | 19 |
697682 | 697682 | 2020-11-04 | Plaquemines | Louisiana | 22075 | 906 | 19 |
694439 | 694439 | 2020-11-03 | Plaquemines | Louisiana | 22075 | 909 | 19 |
691197 | 691197 | 2020-11-02 | Plaquemines | Louisiana | 22075 | 903 | 19 |
687952 | 687952 | 2020-11-01 | Plaquemines | Louisiana | 22075 | 904 | 19 |
684708 | 684708 | 2020-10-31 | Plaquemines | Louisiana | 22075 | 898 | 19 |
681465 | 681465 | 2020-10-30 | Plaquemines | Louisiana | 22075 | 898 | 19 |
678221 | 678221 | 2020-10-29 | Plaquemines | Louisiana | 22075 | 894 | 19 |
674979 | 674979 | 2020-10-28 | Plaquemines | Louisiana | 22075 | 894 | 19 |
671736 | 671736 | 2020-10-27 | Plaquemines | Louisiana | 22075 | 893 | 19 |
668494 | 668494 | 2020-10-26 | Plaquemines | Louisiana | 22075 | 892 | 19 |
665250 | 665250 | 2020-10-25 | Plaquemines | Louisiana | 22075 | 891 | 19 |
662005 | 662005 | 2020-10-24 | Plaquemines | Louisiana | 22075 | 885 | 19 |
658761 | 658761 | 2020-10-23 | Plaquemines | Louisiana | 22075 | 885 | 19 |
655516 | 655516 | 2020-10-22 | Plaquemines | Louisiana | 22075 | 884 | 19 |
652271 | 652271 | 2020-10-21 | Plaquemines | Louisiana | 22075 | 883 | 19 |
649026 | 649026 | 2020-10-20 | Plaquemines | Louisiana | 22075 | 876 | 19 |
645782 | 645782 | 2020-10-19 | Plaquemines | Louisiana | 22075 | 875 | 19 |
642535 | 642535 | 2020-10-18 | Plaquemines | Louisiana | 22075 | 851 | 19 |
639288 | 639288 | 2020-10-17 | Plaquemines | Louisiana | 22075 | 824 | 19 |
636042 | 636042 | 2020-10-16 | Plaquemines | Louisiana | 22075 | 824 | 19 |
632796 | 632796 | 2020-10-15 | Plaquemines | Louisiana | 22075 | 817 | 19 |
629552 | 629552 | 2020-10-14 | Plaquemines | Louisiana | 22075 | 813 | 19 |
626308 | 626308 | 2020-10-13 | Plaquemines | Louisiana | 22075 | 812 | 19 |
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);