ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
273 rows where deaths = 18 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- St. Helena 39
- Jackson 28
- Lincoln 20
- Plaquemines 20
- Winn 20
- Catahoula 16
- West Feliciana 12
- Caldwell 11
- De Soto 11
- Richland 8
- Assumption 7
- Madison 6
- St. Bernard 6
- East Carroll 5
- Tangipahoa 5
- West Carroll 5
- Claiborne 4
- St. James 4
- Washington 4
- Grant 3
- Sabine 3
- St. Martin 3
- Terrebonne 3
- Acadia 2
- Avoyelles 2
- Beauregard 2
- Bienville 2
- Bossier 2
- Livingston 2
- Natchitoches 2
- …
state 1
- Louisiana · 273 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1928260 | 1928260 | 2021-11-18 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1925010 | 1925010 | 2021-11-17 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1921761 | 1921761 | 2021-11-16 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1918511 | 1918511 | 2021-11-15 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1915261 | 1915261 | 2021-11-14 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1912011 | 1912011 | 2021-11-13 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1908762 | 1908762 | 2021-11-12 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1905513 | 1905513 | 2021-11-11 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1902263 | 1902263 | 2021-11-10 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1899013 | 1899013 | 2021-11-09 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1895763 | 1895763 | 2021-11-08 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1892513 | 1892513 | 2021-11-07 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1889263 | 1889263 | 2021-11-06 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1886013 | 1886013 | 2021-11-05 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1882764 | 1882764 | 2021-11-04 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1879515 | 1879515 | 2021-11-03 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1876266 | 1876266 | 2021-11-02 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1873017 | 1873017 | 2021-11-01 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1869768 | 1869768 | 2021-10-31 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1866519 | 1866519 | 2021-10-30 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1863270 | 1863270 | 2021-10-29 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1860021 | 1860021 | 2021-10-28 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1856772 | 1856772 | 2021-10-27 | St. Helena | Louisiana | 22091 | 1263 | 18 |
1853523 | 1853523 | 2021-10-26 | St. Helena | Louisiana | 22091 | 1262 | 18 |
1850274 | 1850274 | 2021-10-25 | St. Helena | Louisiana | 22091 | 1262 | 18 |
1847024 | 1847024 | 2021-10-24 | St. Helena | Louisiana | 22091 | 1262 | 18 |
1843774 | 1843774 | 2021-10-23 | St. Helena | Louisiana | 22091 | 1262 | 18 |
1840524 | 1840524 | 2021-10-22 | St. Helena | Louisiana | 22091 | 1262 | 18 |
1837275 | 1837275 | 2021-10-21 | St. Helena | Louisiana | 22091 | 1262 | 18 |
1834026 | 1834026 | 2021-10-20 | St. Helena | Louisiana | 22091 | 1260 | 18 |
1830777 | 1830777 | 2021-10-19 | St. Helena | Louisiana | 22091 | 1260 | 18 |
1827528 | 1827528 | 2021-10-18 | St. Helena | Louisiana | 22091 | 1259 | 18 |
1824279 | 1824279 | 2021-10-17 | St. Helena | Louisiana | 22091 | 1259 | 18 |
1821030 | 1821030 | 2021-10-16 | St. Helena | Louisiana | 22091 | 1259 | 18 |
1817781 | 1817781 | 2021-10-15 | St. Helena | Louisiana | 22091 | 1259 | 18 |
1814533 | 1814533 | 2021-10-14 | St. Helena | Louisiana | 22091 | 1259 | 18 |
1811284 | 1811284 | 2021-10-13 | St. Helena | Louisiana | 22091 | 1259 | 18 |
1808035 | 1808035 | 2021-10-12 | St. Helena | Louisiana | 22091 | 1258 | 18 |
1804784 | 1804784 | 2021-10-11 | St. Helena | Louisiana | 22091 | 1258 | 18 |
918330 | 918330 | 2021-01-11 | East Carroll | Louisiana | 22035 | 1019 | 18 |
915085 | 915085 | 2021-01-10 | East Carroll | Louisiana | 22035 | 1020 | 18 |
911840 | 911840 | 2021-01-09 | East Carroll | Louisiana | 22035 | 1007 | 18 |
908595 | 908595 | 2021-01-08 | East Carroll | Louisiana | 22035 | 1007 | 18 |
905349 | 905349 | 2021-01-07 | East Carroll | Louisiana | 22035 | 998 | 18 |
889136 | 889136 | 2021-01-02 | Madison | Louisiana | 22065 | 1307 | 18 |
885890 | 885890 | 2021-01-01 | Madison | Louisiana | 22065 | 1307 | 18 |
882645 | 882645 | 2020-12-31 | Madison | Louisiana | 22065 | 1307 | 18 |
879400 | 879400 | 2020-12-30 | Madison | Louisiana | 22065 | 1291 | 18 |
876155 | 876155 | 2020-12-29 | Madison | Louisiana | 22065 | 1262 | 18 |
872910 | 872910 | 2020-12-28 | Madison | Louisiana | 22065 | 1258 | 18 |
856663 | 856663 | 2020-12-23 | Caldwell | Louisiana | 22021 | 858 | 18 |
853418 | 853418 | 2020-12-22 | Caldwell | Louisiana | 22021 | 852 | 18 |
850173 | 850173 | 2020-12-21 | Caldwell | Louisiana | 22021 | 848 | 18 |
846928 | 846928 | 2020-12-20 | Caldwell | Louisiana | 22021 | 847 | 18 |
843682 | 843682 | 2020-12-19 | Caldwell | Louisiana | 22021 | 828 | 18 |
840437 | 840437 | 2020-12-18 | Caldwell | Louisiana | 22021 | 828 | 18 |
837192 | 837192 | 2020-12-17 | Caldwell | Louisiana | 22021 | 815 | 18 |
833946 | 833946 | 2020-12-16 | Caldwell | Louisiana | 22021 | 785 | 18 |
830699 | 830699 | 2020-12-15 | Caldwell | Louisiana | 22021 | 780 | 18 |
827453 | 827453 | 2020-12-14 | Caldwell | Louisiana | 22021 | 768 | 18 |
824206 | 824206 | 2020-12-13 | Caldwell | Louisiana | 22021 | 763 | 18 |
798245 | 798245 | 2020-12-05 | Catahoula | Louisiana | 22025 | 660 | 18 |
795000 | 795000 | 2020-12-04 | Catahoula | Louisiana | 22025 | 660 | 18 |
791755 | 791755 | 2020-12-03 | Catahoula | Louisiana | 22025 | 655 | 18 |
788510 | 788510 | 2020-12-02 | Catahoula | Louisiana | 22025 | 643 | 18 |
785266 | 785266 | 2020-12-01 | Catahoula | Louisiana | 22025 | 644 | 18 |
782021 | 782021 | 2020-11-30 | Catahoula | Louisiana | 22025 | 624 | 18 |
778775 | 778775 | 2020-11-29 | Catahoula | Louisiana | 22025 | 627 | 18 |
775530 | 775530 | 2020-11-28 | Catahoula | Louisiana | 22025 | 625 | 18 |
772285 | 772285 | 2020-11-27 | Catahoula | Louisiana | 22025 | 625 | 18 |
769040 | 769040 | 2020-11-26 | Catahoula | Louisiana | 22025 | 612 | 18 |
765794 | 765794 | 2020-11-25 | Catahoula | Louisiana | 22025 | 612 | 18 |
762549 | 762549 | 2020-11-24 | Catahoula | Louisiana | 22025 | 604 | 18 |
759304 | 759304 | 2020-11-23 | Catahoula | Louisiana | 22025 | 599 | 18 |
756057 | 756057 | 2020-11-22 | Catahoula | Louisiana | 22025 | 597 | 18 |
752811 | 752811 | 2020-11-21 | Catahoula | Louisiana | 22025 | 582 | 18 |
749565 | 749565 | 2020-11-20 | Catahoula | Louisiana | 22025 | 582 | 18 |
739855 | 739855 | 2020-11-17 | Sabine | Louisiana | 22085 | 1249 | 18 |
739875 | 739875 | 2020-11-17 | West Carroll | Louisiana | 22123 | 473 | 18 |
736611 | 736611 | 2020-11-16 | Sabine | Louisiana | 22085 | 1232 | 18 |
736631 | 736631 | 2020-11-16 | West Carroll | Louisiana | 22123 | 461 | 18 |
733365 | 733365 | 2020-11-15 | Sabine | Louisiana | 22085 | 1227 | 18 |
733385 | 733385 | 2020-11-15 | West Carroll | Louisiana | 22123 | 457 | 18 |
730140 | 730140 | 2020-11-14 | West Carroll | Louisiana | 22123 | 441 | 18 |
726897 | 726897 | 2020-11-13 | West Carroll | Louisiana | 22123 | 441 | 18 |
697686 | 697686 | 2020-11-04 | Richland | Louisiana | 22083 | 930 | 18 |
694443 | 694443 | 2020-11-03 | Richland | Louisiana | 22083 | 923 | 18 |
691201 | 691201 | 2020-11-02 | Richland | Louisiana | 22083 | 918 | 18 |
687956 | 687956 | 2020-11-01 | Richland | Louisiana | 22083 | 911 | 18 |
684712 | 684712 | 2020-10-31 | Richland | Louisiana | 22083 | 901 | 18 |
681469 | 681469 | 2020-10-30 | Richland | Louisiana | 22083 | 901 | 18 |
678225 | 678225 | 2020-10-29 | Richland | Louisiana | 22083 | 895 | 18 |
674983 | 674983 | 2020-10-28 | Richland | Louisiana | 22083 | 889 | 18 |
593913 | 593913 | 2020-10-03 | Winn | Louisiana | 22127 | 639 | 18 |
590672 | 590672 | 2020-10-02 | Winn | Louisiana | 22127 | 639 | 18 |
587431 | 587431 | 2020-10-01 | Winn | Louisiana | 22127 | 635 | 18 |
584191 | 584191 | 2020-09-30 | Winn | Louisiana | 22127 | 634 | 18 |
580951 | 580951 | 2020-09-29 | Winn | Louisiana | 22127 | 632 | 18 |
577710 | 577710 | 2020-09-28 | Winn | Louisiana | 22127 | 627 | 18 |
574468 | 574468 | 2020-09-27 | Winn | Louisiana | 22127 | 628 | 18 |
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);