ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 22031 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947536 | 947536 | 2021-01-20 | De Soto | Louisiana | 22031 | 2108 | 56 |
944289 | 944289 | 2021-01-19 | De Soto | Louisiana | 22031 | 2088 | 55 |
941044 | 941044 | 2021-01-18 | De Soto | Louisiana | 22031 | 2081 | 55 |
937799 | 937799 | 2021-01-17 | De Soto | Louisiana | 22031 | 2071 | 54 |
934554 | 934554 | 2021-01-16 | De Soto | Louisiana | 22031 | 2031 | 54 |
931309 | 931309 | 2021-01-15 | De Soto | Louisiana | 22031 | 2031 | 54 |
928064 | 928064 | 2021-01-14 | De Soto | Louisiana | 22031 | 2004 | 54 |
924818 | 924818 | 2021-01-13 | De Soto | Louisiana | 22031 | 1987 | 54 |
921573 | 921573 | 2021-01-12 | De Soto | Louisiana | 22031 | 1975 | 54 |
918328 | 918328 | 2021-01-11 | De Soto | Louisiana | 22031 | 1958 | 54 |
915083 | 915083 | 2021-01-10 | De Soto | Louisiana | 22031 | 1954 | 54 |
911838 | 911838 | 2021-01-09 | De Soto | Louisiana | 22031 | 1916 | 54 |
908593 | 908593 | 2021-01-08 | De Soto | Louisiana | 22031 | 1916 | 54 |
905347 | 905347 | 2021-01-07 | De Soto | Louisiana | 22031 | 1888 | 53 |
902102 | 902102 | 2021-01-06 | De Soto | Louisiana | 22031 | 1865 | 53 |
898857 | 898857 | 2021-01-05 | De Soto | Louisiana | 22031 | 1825 | 52 |
895612 | 895612 | 2021-01-04 | De Soto | Louisiana | 22031 | 1805 | 52 |
892365 | 892365 | 2021-01-03 | De Soto | Louisiana | 22031 | 1801 | 51 |
889119 | 889119 | 2021-01-02 | De Soto | Louisiana | 22031 | 1764 | 51 |
885873 | 885873 | 2021-01-01 | De Soto | Louisiana | 22031 | 1764 | 51 |
882628 | 882628 | 2020-12-31 | De Soto | Louisiana | 22031 | 1764 | 51 |
879383 | 879383 | 2020-12-30 | De Soto | Louisiana | 22031 | 1738 | 51 |
876138 | 876138 | 2020-12-29 | De Soto | Louisiana | 22031 | 1708 | 51 |
872893 | 872893 | 2020-12-28 | De Soto | Louisiana | 22031 | 1685 | 50 |
869648 | 869648 | 2020-12-27 | De Soto | Louisiana | 22031 | 1686 | 49 |
866403 | 866403 | 2020-12-26 | De Soto | Louisiana | 22031 | 1665 | 49 |
863158 | 863158 | 2020-12-25 | De Soto | Louisiana | 22031 | 1665 | 49 |
859913 | 859913 | 2020-12-24 | De Soto | Louisiana | 22031 | 1665 | 49 |
856668 | 856668 | 2020-12-23 | De Soto | Louisiana | 22031 | 1651 | 45 |
853423 | 853423 | 2020-12-22 | De Soto | Louisiana | 22031 | 1633 | 45 |
850178 | 850178 | 2020-12-21 | De Soto | Louisiana | 22031 | 1610 | 45 |
846933 | 846933 | 2020-12-20 | De Soto | Louisiana | 22031 | 1599 | 45 |
843687 | 843687 | 2020-12-19 | De Soto | Louisiana | 22031 | 1578 | 44 |
840442 | 840442 | 2020-12-18 | De Soto | Louisiana | 22031 | 1578 | 44 |
837197 | 837197 | 2020-12-17 | De Soto | Louisiana | 22031 | 1558 | 44 |
833951 | 833951 | 2020-12-16 | De Soto | Louisiana | 22031 | 1541 | 44 |
830704 | 830704 | 2020-12-15 | De Soto | Louisiana | 22031 | 1513 | 43 |
827458 | 827458 | 2020-12-14 | De Soto | Louisiana | 22031 | 1500 | 43 |
824211 | 824211 | 2020-12-13 | De Soto | Louisiana | 22031 | 1488 | 43 |
820965 | 820965 | 2020-12-12 | De Soto | Louisiana | 22031 | 1472 | 43 |
817719 | 817719 | 2020-12-11 | De Soto | Louisiana | 22031 | 1472 | 43 |
814473 | 814473 | 2020-12-10 | De Soto | Louisiana | 22031 | 1452 | 42 |
811228 | 811228 | 2020-12-09 | De Soto | Louisiana | 22031 | 1436 | 41 |
807983 | 807983 | 2020-12-08 | De Soto | Louisiana | 22031 | 1415 | 41 |
804738 | 804738 | 2020-12-07 | De Soto | Louisiana | 22031 | 1406 | 41 |
801493 | 801493 | 2020-12-06 | De Soto | Louisiana | 22031 | 1401 | 41 |
798248 | 798248 | 2020-12-05 | De Soto | Louisiana | 22031 | 1366 | 39 |
795003 | 795003 | 2020-12-04 | De Soto | Louisiana | 22031 | 1366 | 39 |
791758 | 791758 | 2020-12-03 | De Soto | Louisiana | 22031 | 1341 | 39 |
788513 | 788513 | 2020-12-02 | De Soto | Louisiana | 22031 | 1320 | 39 |
785269 | 785269 | 2020-12-01 | De Soto | Louisiana | 22031 | 1283 | 39 |
782024 | 782024 | 2020-11-30 | De Soto | Louisiana | 22031 | 1262 | 39 |
778778 | 778778 | 2020-11-29 | De Soto | Louisiana | 22031 | 1260 | 39 |
775533 | 775533 | 2020-11-28 | De Soto | Louisiana | 22031 | 1253 | 39 |
772288 | 772288 | 2020-11-27 | De Soto | Louisiana | 22031 | 1253 | 39 |
769043 | 769043 | 2020-11-26 | De Soto | Louisiana | 22031 | 1230 | 39 |
765797 | 765797 | 2020-11-25 | De Soto | Louisiana | 22031 | 1230 | 39 |
762552 | 762552 | 2020-11-24 | De Soto | Louisiana | 22031 | 1216 | 38 |
759307 | 759307 | 2020-11-23 | De Soto | Louisiana | 22031 | 1194 | 38 |
756060 | 756060 | 2020-11-22 | De Soto | Louisiana | 22031 | 1191 | 37 |
752814 | 752814 | 2020-11-21 | De Soto | Louisiana | 22031 | 1178 | 37 |
749568 | 749568 | 2020-11-20 | De Soto | Louisiana | 22031 | 1178 | 37 |
746322 | 746322 | 2020-11-19 | De Soto | Louisiana | 22031 | 1163 | 37 |
743075 | 743075 | 2020-11-18 | De Soto | Louisiana | 22031 | 1154 | 37 |
739828 | 739828 | 2020-11-17 | De Soto | Louisiana | 22031 | 1142 | 37 |
736584 | 736584 | 2020-11-16 | De Soto | Louisiana | 22031 | 1133 | 37 |
733338 | 733338 | 2020-11-15 | De Soto | Louisiana | 22031 | 1131 | 37 |
730093 | 730093 | 2020-11-14 | De Soto | Louisiana | 22031 | 1123 | 37 |
726850 | 726850 | 2020-11-13 | De Soto | Louisiana | 22031 | 1123 | 37 |
723607 | 723607 | 2020-11-12 | De Soto | Louisiana | 22031 | 1094 | 35 |
720364 | 720364 | 2020-11-11 | De Soto | Louisiana | 22031 | 1087 | 35 |
717121 | 717121 | 2020-11-10 | De Soto | Louisiana | 22031 | 1087 | 35 |
713877 | 713877 | 2020-11-09 | De Soto | Louisiana | 22031 | 1083 | 35 |
710633 | 710633 | 2020-11-08 | De Soto | Louisiana | 22031 | 1081 | 35 |
707389 | 707389 | 2020-11-07 | De Soto | Louisiana | 22031 | 1071 | 35 |
704146 | 704146 | 2020-11-06 | De Soto | Louisiana | 22031 | 1071 | 35 |
700904 | 700904 | 2020-11-05 | De Soto | Louisiana | 22031 | 1069 | 35 |
697660 | 697660 | 2020-11-04 | De Soto | Louisiana | 22031 | 1058 | 35 |
694417 | 694417 | 2020-11-03 | De Soto | Louisiana | 22031 | 1054 | 35 |
691175 | 691175 | 2020-11-02 | De Soto | Louisiana | 22031 | 1045 | 35 |
687930 | 687930 | 2020-11-01 | De Soto | Louisiana | 22031 | 1045 | 35 |
684686 | 684686 | 2020-10-31 | De Soto | Louisiana | 22031 | 1037 | 35 |
681443 | 681443 | 2020-10-30 | De Soto | Louisiana | 22031 | 1037 | 35 |
678199 | 678199 | 2020-10-29 | De Soto | Louisiana | 22031 | 1030 | 35 |
674957 | 674957 | 2020-10-28 | De Soto | Louisiana | 22031 | 1030 | 35 |
671714 | 671714 | 2020-10-27 | De Soto | Louisiana | 22031 | 1027 | 35 |
668472 | 668472 | 2020-10-26 | De Soto | Louisiana | 22031 | 1015 | 35 |
665228 | 665228 | 2020-10-25 | De Soto | Louisiana | 22031 | 1017 | 35 |
661983 | 661983 | 2020-10-24 | De Soto | Louisiana | 22031 | 1009 | 35 |
658739 | 658739 | 2020-10-23 | De Soto | Louisiana | 22031 | 1009 | 35 |
655494 | 655494 | 2020-10-22 | De Soto | Louisiana | 22031 | 1007 | 35 |
652249 | 652249 | 2020-10-21 | De Soto | Louisiana | 22031 | 1000 | 35 |
649004 | 649004 | 2020-10-20 | De Soto | Louisiana | 22031 | 995 | 35 |
645760 | 645760 | 2020-10-19 | De Soto | Louisiana | 22031 | 991 | 35 |
642513 | 642513 | 2020-10-18 | De Soto | Louisiana | 22031 | 987 | 35 |
639266 | 639266 | 2020-10-17 | De Soto | Louisiana | 22031 | 979 | 35 |
636020 | 636020 | 2020-10-16 | De Soto | Louisiana | 22031 | 979 | 35 |
632774 | 632774 | 2020-10-15 | De Soto | Louisiana | 22031 | 975 | 35 |
629530 | 629530 | 2020-10-14 | De Soto | Louisiana | 22031 | 964 | 35 |
626286 | 626286 | 2020-10-13 | De Soto | Louisiana | 22031 | 964 | 35 |
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);