ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
276 rows where deaths = 20 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Plaquemines 28
- Red River 21
- Assumption 20
- St. Helena 18
- Union 18
- LaSalle 16
- East Carroll 13
- St. Bernard 13
- Webster 12
- West Carroll 12
- Bienville 10
- St. James 10
- Lafayette 7
- West Feliciana 7
- Winn 7
- Jackson 6
- St. Mary 6
- Catahoula 5
- Lincoln 5
- De Soto 4
- Morehouse 4
- Avoyelles 3
- Natchitoches 3
- Pointe Coupee 3
- St. Landry 3
- Bossier 2
- East Feliciana 2
- Evangeline 2
- Richland 2
- Sabine 2
- …
state 1
- Louisiana · 276 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2142825 | 2142825 | 2022-01-23 | St. Helena | Louisiana | 22091 | 1647 | 20 |
2139570 | 2139570 | 2022-01-22 | St. Helena | Louisiana | 22091 | 1647 | 20 |
2136314 | 2136314 | 2022-01-21 | St. Helena | Louisiana | 22091 | 1647 | 20 |
2133062 | 2133062 | 2022-01-20 | St. Helena | Louisiana | 22091 | 1636 | 20 |
2129809 | 2129809 | 2022-01-19 | St. Helena | Louisiana | 22091 | 1570 | 20 |
2126555 | 2126555 | 2022-01-18 | St. Helena | Louisiana | 22091 | 1559 | 20 |
2123303 | 2123303 | 2022-01-17 | St. Helena | Louisiana | 22091 | 1524 | 20 |
2120051 | 2120051 | 2022-01-16 | St. Helena | Louisiana | 22091 | 1524 | 20 |
2116799 | 2116799 | 2022-01-15 | St. Helena | Louisiana | 22091 | 1524 | 20 |
2113548 | 2113548 | 2022-01-14 | St. Helena | Louisiana | 22091 | 1524 | 20 |
2110296 | 2110296 | 2022-01-13 | St. Helena | Louisiana | 22091 | 1435 | 20 |
2107045 | 2107045 | 2022-01-12 | St. Helena | Louisiana | 22091 | 1435 | 20 |
2103794 | 2103794 | 2022-01-11 | St. Helena | Louisiana | 22091 | 1435 | 20 |
2100543 | 2100543 | 2022-01-10 | St. Helena | Louisiana | 22091 | 1430 | 20 |
2097292 | 2097292 | 2022-01-09 | St. Helena | Louisiana | 22091 | 1403 | 20 |
2094040 | 2094040 | 2022-01-08 | St. Helena | Louisiana | 22091 | 1403 | 20 |
2090788 | 2090788 | 2022-01-07 | St. Helena | Louisiana | 22091 | 1403 | 20 |
2087537 | 2087537 | 2022-01-06 | St. Helena | Louisiana | 22091 | 1389 | 20 |
989730 | 989730 | 2021-02-02 | East Carroll | Louisiana | 22035 | 1083 | 20 |
986483 | 986483 | 2021-02-01 | East Carroll | Louisiana | 22035 | 1083 | 20 |
983236 | 983236 | 2021-01-31 | East Carroll | Louisiana | 22035 | 1083 | 20 |
979990 | 979990 | 2021-01-30 | East Carroll | Louisiana | 22035 | 1083 | 20 |
976744 | 976744 | 2021-01-29 | East Carroll | Louisiana | 22035 | 1083 | 20 |
973499 | 973499 | 2021-01-28 | East Carroll | Louisiana | 22035 | 1078 | 20 |
970254 | 970254 | 2021-01-27 | East Carroll | Louisiana | 22035 | 1074 | 20 |
967010 | 967010 | 2021-01-26 | East Carroll | Louisiana | 22035 | 1071 | 20 |
963765 | 963765 | 2021-01-25 | East Carroll | Louisiana | 22035 | 1066 | 20 |
960520 | 960520 | 2021-01-24 | East Carroll | Louisiana | 22035 | 1064 | 20 |
957274 | 957274 | 2021-01-23 | East Carroll | Louisiana | 22035 | 1057 | 20 |
954029 | 954029 | 2021-01-22 | East Carroll | Louisiana | 22035 | 1057 | 20 |
950784 | 950784 | 2021-01-21 | East Carroll | Louisiana | 22035 | 1053 | 20 |
895629 | 895629 | 2021-01-04 | Madison | Louisiana | 22065 | 1349 | 20 |
872888 | 872888 | 2020-12-28 | Caldwell | Louisiana | 22021 | 870 | 20 |
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 |
853420 | 853420 | 2020-12-22 | Catahoula | Louisiana | 22025 | 772 | 20 |
853445 | 853445 | 2020-12-22 | Plaquemines | Louisiana | 22075 | 1578 | 20 |
850175 | 850175 | 2020-12-21 | Catahoula | Louisiana | 22025 | 768 | 20 |
850200 | 850200 | 2020-12-21 | Plaquemines | Louisiana | 22075 | 1555 | 20 |
846930 | 846930 | 2020-12-20 | Catahoula | Louisiana | 22025 | 770 | 20 |
846955 | 846955 | 2020-12-20 | Plaquemines | Louisiana | 22075 | 1546 | 20 |
843684 | 843684 | 2020-12-19 | Catahoula | Louisiana | 22025 | 753 | 20 |
843709 | 843709 | 2020-12-19 | Plaquemines | Louisiana | 22075 | 1528 | 20 |
840439 | 840439 | 2020-12-18 | Catahoula | Louisiana | 22025 | 753 | 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 |
791770 | 791770 | 2020-12-03 | LaSalle | Louisiana | 22059 | 935 | 20 |
791780 | 791780 | 2020-12-03 | Plaquemines | Louisiana | 22075 | 1258 | 20 |
788525 | 788525 | 2020-12-02 | LaSalle | Louisiana | 22059 | 922 | 20 |
788535 | 788535 | 2020-12-02 | Plaquemines | Louisiana | 22075 | 1222 | 20 |
785281 | 785281 | 2020-12-01 | LaSalle | Louisiana | 22059 | 906 | 20 |
785291 | 785291 | 2020-12-01 | Plaquemines | Louisiana | 22075 | 1180 | 20 |
785316 | 785316 | 2020-12-01 | West Carroll | Louisiana | 22123 | 681 | 20 |
782036 | 782036 | 2020-11-30 | LaSalle | Louisiana | 22059 | 890 | 20 |
782071 | 782071 | 2020-11-30 | West Carroll | Louisiana | 22123 | 658 | 20 |
778790 | 778790 | 2020-11-29 | LaSalle | Louisiana | 22059 | 889 | 20 |
778825 | 778825 | 2020-11-29 | West Carroll | Louisiana | 22123 | 648 | 20 |
775545 | 775545 | 2020-11-28 | LaSalle | Louisiana | 22059 | 882 | 20 |
775580 | 775580 | 2020-11-28 | West Carroll | Louisiana | 22123 | 634 | 20 |
772300 | 772300 | 2020-11-27 | LaSalle | Louisiana | 22059 | 882 | 20 |
772335 | 772335 | 2020-11-27 | West Carroll | Louisiana | 22123 | 634 | 20 |
769055 | 769055 | 2020-11-26 | LaSalle | Louisiana | 22059 | 864 | 20 |
769070 | 769070 | 2020-11-26 | Sabine | Louisiana | 22085 | 1393 | 20 |
769090 | 769090 | 2020-11-26 | West Carroll | Louisiana | 22123 | 619 | 20 |
765809 | 765809 | 2020-11-25 | LaSalle | Louisiana | 22059 | 864 | 20 |
765824 | 765824 | 2020-11-25 | Sabine | Louisiana | 22085 | 1393 | 20 |
765844 | 765844 | 2020-11-25 | West Carroll | Louisiana | 22123 | 619 | 20 |
762564 | 762564 | 2020-11-24 | LaSalle | Louisiana | 22059 | 852 | 20 |
762599 | 762599 | 2020-11-24 | West Carroll | Louisiana | 22123 | 617 | 20 |
759319 | 759319 | 2020-11-23 | LaSalle | Louisiana | 22059 | 838 | 20 |
759354 | 759354 | 2020-11-23 | West Carroll | Louisiana | 22123 | 608 | 20 |
756072 | 756072 | 2020-11-22 | LaSalle | Louisiana | 22059 | 836 | 20 |
756107 | 756107 | 2020-11-22 | West Carroll | Louisiana | 22123 | 591 | 20 |
752826 | 752826 | 2020-11-21 | LaSalle | Louisiana | 22059 | 819 | 20 |
752861 | 752861 | 2020-11-21 | West Carroll | Louisiana | 22123 | 556 | 20 |
749580 | 749580 | 2020-11-20 | LaSalle | Louisiana | 22059 | 819 | 20 |
749615 | 749615 | 2020-11-20 | West Carroll | Louisiana | 22123 | 556 | 20 |
746334 | 746334 | 2020-11-19 | LaSalle | Louisiana | 22059 | 811 | 20 |
743087 | 743087 | 2020-11-18 | LaSalle | Louisiana | 22059 | 794 | 20 |
707415 | 707415 | 2020-11-07 | Richland | Louisiana | 22083 | 947 | 20 |
704172 | 704172 | 2020-11-06 | Richland | Louisiana | 22083 | 947 | 20 |
700953 | 700953 | 2020-11-05 | Winn | Louisiana | 22127 | 708 | 20 |
697709 | 697709 | 2020-11-04 | Winn | Louisiana | 22127 | 707 | 20 |
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);