ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
252 rows where deaths = 22 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Jackson 37
- Plaquemines 33
- Morehouse 17
- St. Martin 16
- Assumption 14
- East Carroll 12
- St. Bernard 11
- Caldwell 10
- LaSalle 8
- Natchitoches 8
- Pointe Coupee 7
- St. Helena 7
- Webster 7
- Catahoula 5
- Jefferson Davis 5
- Lafayette 5
- Red River 5
- Ouachita 4
- West Feliciana 4
- Bossier 3
- Vernon 3
- Winn 3
- Bienville 2
- East Feliciana 2
- Franklin 2
- Lincoln 2
- St. James 2
- West Baton Rouge 2
- West Carroll 2
- Acadia 1
- …
state 1
- Louisiana · 252 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2211145 | 2211145 | 2022-02-13 | St. Helena | Louisiana | 22091 | 1874 | 22 |
2207892 | 2207892 | 2022-02-12 | St. Helena | Louisiana | 22091 | 1874 | 22 |
2204639 | 2204639 | 2022-02-11 | St. Helena | Louisiana | 22091 | 1874 | 22 |
2201386 | 2201386 | 2022-02-10 | St. Helena | Louisiana | 22091 | 1868 | 22 |
2198132 | 2198132 | 2022-02-09 | St. Helena | Louisiana | 22091 | 1858 | 22 |
2194878 | 2194878 | 2022-02-08 | St. Helena | Louisiana | 22091 | 1853 | 22 |
2191624 | 2191624 | 2022-02-07 | St. Helena | Louisiana | 22091 | 1852 | 22 |
1041660 | 1041660 | 2021-02-18 | East Carroll | Louisiana | 22035 | 1096 | 22 |
1038415 | 1038415 | 2021-02-17 | East Carroll | Louisiana | 22035 | 1097 | 22 |
1035170 | 1035170 | 2021-02-16 | East Carroll | Louisiana | 22035 | 1096 | 22 |
1031924 | 1031924 | 2021-02-15 | East Carroll | Louisiana | 22035 | 1096 | 22 |
1028677 | 1028677 | 2021-02-14 | East Carroll | Louisiana | 22035 | 1096 | 22 |
1028697 | 1028697 | 2021-02-14 | Plaquemines | Louisiana | 22075 | 2230 | 22 |
1025432 | 1025432 | 2021-02-13 | East Carroll | Louisiana | 22035 | 1096 | 22 |
1025452 | 1025452 | 2021-02-13 | Plaquemines | Louisiana | 22075 | 2223 | 22 |
1022187 | 1022187 | 2021-02-12 | East Carroll | Louisiana | 22035 | 1096 | 22 |
1022207 | 1022207 | 2021-02-12 | Plaquemines | Louisiana | 22075 | 2223 | 22 |
1018942 | 1018942 | 2021-02-11 | East Carroll | Louisiana | 22035 | 1095 | 22 |
1018962 | 1018962 | 2021-02-11 | Plaquemines | Louisiana | 22075 | 2209 | 22 |
1015697 | 1015697 | 2021-02-10 | East Carroll | Louisiana | 22035 | 1094 | 22 |
1015717 | 1015717 | 2021-02-10 | Plaquemines | Louisiana | 22075 | 2196 | 22 |
1012452 | 1012452 | 2021-02-09 | East Carroll | Louisiana | 22035 | 1092 | 22 |
1012472 | 1012472 | 2021-02-09 | Plaquemines | Louisiana | 22075 | 2193 | 22 |
1009206 | 1009206 | 2021-02-08 | East Carroll | Louisiana | 22035 | 1093 | 22 |
1009226 | 1009226 | 2021-02-08 | Plaquemines | Louisiana | 22075 | 2177 | 22 |
1005960 | 1005960 | 2021-02-07 | East Carroll | Louisiana | 22035 | 1090 | 22 |
1005980 | 1005980 | 2021-02-07 | Plaquemines | Louisiana | 22075 | 2181 | 22 |
1002734 | 1002734 | 2021-02-06 | Plaquemines | Louisiana | 22075 | 2167 | 22 |
999488 | 999488 | 2021-02-05 | Plaquemines | Louisiana | 22075 | 2167 | 22 |
996242 | 996242 | 2021-02-04 | Plaquemines | Louisiana | 22075 | 2165 | 22 |
992996 | 992996 | 2021-02-03 | Plaquemines | Louisiana | 22075 | 2154 | 22 |
989750 | 989750 | 2021-02-02 | Plaquemines | Louisiana | 22075 | 2144 | 22 |
986503 | 986503 | 2021-02-01 | Plaquemines | Louisiana | 22075 | 2130 | 22 |
983256 | 983256 | 2021-01-31 | Plaquemines | Louisiana | 22075 | 2127 | 22 |
980010 | 980010 | 2021-01-30 | Plaquemines | Louisiana | 22075 | 2112 | 22 |
976764 | 976764 | 2021-01-29 | Plaquemines | Louisiana | 22075 | 2112 | 22 |
973519 | 973519 | 2021-01-28 | Plaquemines | Louisiana | 22075 | 2102 | 22 |
970274 | 970274 | 2021-01-27 | Plaquemines | Louisiana | 22075 | 2082 | 22 |
967030 | 967030 | 2021-01-26 | Plaquemines | Louisiana | 22075 | 2068 | 22 |
963785 | 963785 | 2021-01-25 | Plaquemines | Louisiana | 22075 | 2045 | 22 |
960540 | 960540 | 2021-01-24 | Plaquemines | Louisiana | 22075 | 2037 | 22 |
957294 | 957294 | 2021-01-23 | Plaquemines | Louisiana | 22075 | 2024 | 22 |
954049 | 954049 | 2021-01-22 | Plaquemines | Louisiana | 22075 | 2024 | 22 |
950804 | 950804 | 2021-01-21 | Plaquemines | Louisiana | 22075 | 2021 | 22 |
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 |
934549 | 934549 | 2021-01-16 | Caldwell | Louisiana | 22021 | 1011 | 22 |
931304 | 931304 | 2021-01-15 | Caldwell | Louisiana | 22021 | 1011 | 22 |
928059 | 928059 | 2021-01-14 | Caldwell | Louisiana | 22021 | 1001 | 22 |
924813 | 924813 | 2021-01-13 | Caldwell | Louisiana | 22021 | 999 | 22 |
924840 | 924840 | 2021-01-13 | Plaquemines | Louisiana | 22075 | 1921 | 22 |
921568 | 921568 | 2021-01-12 | Caldwell | Louisiana | 22021 | 998 | 22 |
921595 | 921595 | 2021-01-12 | Plaquemines | Louisiana | 22075 | 1905 | 22 |
918323 | 918323 | 2021-01-11 | Caldwell | Louisiana | 22021 | 980 | 22 |
918350 | 918350 | 2021-01-11 | Plaquemines | Louisiana | 22075 | 1864 | 22 |
915078 | 915078 | 2021-01-10 | Caldwell | Louisiana | 22021 | 979 | 22 |
915105 | 915105 | 2021-01-10 | Plaquemines | Louisiana | 22075 | 1856 | 22 |
911833 | 911833 | 2021-01-09 | Caldwell | Louisiana | 22021 | 977 | 22 |
908588 | 908588 | 2021-01-08 | Caldwell | Louisiana | 22021 | 977 | 22 |
905342 | 905342 | 2021-01-07 | Caldwell | Louisiana | 22021 | 961 | 22 |
898874 | 898874 | 2021-01-05 | Madison | Louisiana | 22065 | 1355 | 22 |
889116 | 889116 | 2021-01-02 | Catahoula | Louisiana | 22025 | 853 | 22 |
885870 | 885870 | 2021-01-01 | Catahoula | Louisiana | 22025 | 853 | 22 |
882625 | 882625 | 2020-12-31 | Catahoula | Louisiana | 22025 | 853 | 22 |
879380 | 879380 | 2020-12-30 | Catahoula | Louisiana | 22025 | 845 | 22 |
876135 | 876135 | 2020-12-29 | Catahoula | Louisiana | 22025 | 808 | 22 |
830716 | 830716 | 2020-12-15 | LaSalle | Louisiana | 22059 | 1059 | 22 |
827470 | 827470 | 2020-12-14 | LaSalle | Louisiana | 22059 | 1046 | 22 |
824223 | 824223 | 2020-12-13 | LaSalle | Louisiana | 22059 | 1045 | 22 |
820977 | 820977 | 2020-12-12 | LaSalle | Louisiana | 22059 | 1021 | 22 |
817731 | 817731 | 2020-12-11 | LaSalle | Louisiana | 22059 | 1021 | 22 |
814485 | 814485 | 2020-12-10 | LaSalle | Louisiana | 22059 | 1004 | 22 |
811240 | 811240 | 2020-12-09 | LaSalle | Louisiana | 22059 | 990 | 22 |
807995 | 807995 | 2020-12-08 | LaSalle | Louisiana | 22059 | 987 | 22 |
804785 | 804785 | 2020-12-07 | West Carroll | Louisiana | 22123 | 739 | 22 |
801540 | 801540 | 2020-12-06 | West Carroll | Louisiana | 22123 | 729 | 22 |
733387 | 733387 | 2020-11-15 | Winn | Louisiana | 22127 | 846 | 22 |
730142 | 730142 | 2020-11-14 | Winn | Louisiana | 22127 | 812 | 22 |
726899 | 726899 | 2020-11-13 | Winn | Louisiana | 22127 | 812 | 22 |
655503 | 655503 | 2020-10-22 | Jackson | Louisiana | 22049 | 847 | 22 |
652258 | 652258 | 2020-10-21 | Jackson | Louisiana | 22049 | 829 | 22 |
649013 | 649013 | 2020-10-20 | Jackson | Louisiana | 22049 | 814 | 22 |
645769 | 645769 | 2020-10-19 | Jackson | Louisiana | 22049 | 809 | 22 |
642522 | 642522 | 2020-10-18 | Jackson | Louisiana | 22049 | 806 | 22 |
639275 | 639275 | 2020-10-17 | Jackson | Louisiana | 22049 | 787 | 22 |
636029 | 636029 | 2020-10-16 | Jackson | Louisiana | 22049 | 787 | 22 |
632783 | 632783 | 2020-10-15 | Jackson | Louisiana | 22049 | 780 | 22 |
629539 | 629539 | 2020-10-14 | Jackson | Louisiana | 22049 | 758 | 22 |
626295 | 626295 | 2020-10-13 | Jackson | Louisiana | 22049 | 753 | 22 |
623053 | 623053 | 2020-10-12 | Jackson | Louisiana | 22049 | 744 | 22 |
619809 | 619809 | 2020-10-11 | Jackson | Louisiana | 22049 | 745 | 22 |
616567 | 616567 | 2020-10-10 | Jackson | Louisiana | 22049 | 719 | 22 |
613326 | 613326 | 2020-10-09 | Jackson | Louisiana | 22049 | 719 | 22 |
610084 | 610084 | 2020-10-08 | Jackson | Louisiana | 22049 | 718 | 22 |
610093 | 610093 | 2020-10-08 | Morehouse | Louisiana | 22067 | 836 | 22 |
606842 | 606842 | 2020-10-07 | Jackson | Louisiana | 22049 | 703 | 22 |
606851 | 606851 | 2020-10-07 | Morehouse | Louisiana | 22067 | 833 | 22 |
603600 | 603600 | 2020-10-06 | Jackson | Louisiana | 22049 | 688 | 22 |
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);