ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
175 rows where deaths = 67 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Sabine 24
- Claiborne 20
- Morehouse 16
- Washington 14
- Allen 12
- Avoyelles 12
- West Baton Rouge 9
- Concordia 7
- De Soto 5
- Jefferson Davis 5
- Richland 5
- St. James 5
- East Feliciana 4
- Terrebonne 4
- Assumption 3
- Bienville 3
- Bossier 2
- Evangeline 2
- Pointe Coupee 2
- St. Charles 2
- Union 2
- Vermilion 2
- Ascension 1
- Beauregard 1
- Grant 1
- Jackson 1
- Lafayette 1
- Livingston 1
- Ouachita 1
- Rapides 1
- …
state 1
- Louisiana · 175 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2220857 | 2220857 | 2022-02-16 | Assumption | Louisiana | 22007 | 5499 | 67 |
2217606 | 2217606 | 2022-02-15 | Assumption | Louisiana | 22007 | 5493 | 67 |
2214355 | 2214355 | 2022-02-14 | Assumption | Louisiana | 22007 | 5482 | 67 |
2178594 | 2178594 | 2022-02-03 | Jackson | Louisiana | 22049 | 4150 | 67 |
2168824 | 2168824 | 2022-01-31 | Claiborne | Louisiana | 22027 | 3068 | 67 |
2165569 | 2165569 | 2022-01-30 | Claiborne | Louisiana | 22027 | 3053 | 67 |
2162314 | 2162314 | 2022-01-29 | Claiborne | Louisiana | 22027 | 3053 | 67 |
2159059 | 2159059 | 2022-01-28 | Claiborne | Louisiana | 22027 | 3053 | 67 |
2155805 | 2155805 | 2022-01-27 | Claiborne | Louisiana | 22027 | 3030 | 67 |
2152552 | 2152552 | 2022-01-26 | Claiborne | Louisiana | 22027 | 3009 | 67 |
2149300 | 2149300 | 2022-01-25 | Claiborne | Louisiana | 22027 | 2836 | 67 |
2146048 | 2146048 | 2022-01-24 | Claiborne | Louisiana | 22027 | 2814 | 67 |
2142793 | 2142793 | 2022-01-23 | Claiborne | Louisiana | 22027 | 2778 | 67 |
2139538 | 2139538 | 2022-01-22 | Claiborne | Louisiana | 22027 | 2778 | 67 |
2136282 | 2136282 | 2022-01-21 | Claiborne | Louisiana | 22027 | 2778 | 67 |
2133030 | 2133030 | 2022-01-20 | Claiborne | Louisiana | 22027 | 2750 | 67 |
2129777 | 2129777 | 2022-01-19 | Claiborne | Louisiana | 22027 | 2721 | 67 |
2126523 | 2126523 | 2022-01-18 | Claiborne | Louisiana | 22027 | 2695 | 67 |
2123271 | 2123271 | 2022-01-17 | Claiborne | Louisiana | 22027 | 2558 | 67 |
2120019 | 2120019 | 2022-01-16 | Claiborne | Louisiana | 22027 | 2558 | 67 |
2116767 | 2116767 | 2022-01-15 | Claiborne | Louisiana | 22027 | 2558 | 67 |
2113516 | 2113516 | 2022-01-14 | Claiborne | Louisiana | 22027 | 2558 | 67 |
2110264 | 2110264 | 2022-01-13 | Claiborne | Louisiana | 22027 | 2429 | 67 |
2107013 | 2107013 | 2022-01-12 | Claiborne | Louisiana | 22027 | 2429 | 67 |
1759298 | 1759298 | 2021-09-27 | St. James | Louisiana | 22093 | 3380 | 67 |
1756050 | 1756050 | 2021-09-26 | St. James | Louisiana | 22093 | 3373 | 67 |
1752802 | 1752802 | 2021-09-25 | St. James | Louisiana | 22093 | 3373 | 67 |
1749553 | 1749553 | 2021-09-24 | St. James | Louisiana | 22093 | 3373 | 67 |
1746303 | 1746303 | 2021-09-23 | St. James | Louisiana | 22093 | 3369 | 67 |
1697569 | 1697569 | 2021-09-08 | Sabine | Louisiana | 22085 | 4085 | 67 |
1694293 | 1694293 | 2021-09-07 | Concordia | Louisiana | 22029 | 2882 | 67 |
1694321 | 1694321 | 2021-09-07 | Sabine | Louisiana | 22085 | 4036 | 67 |
1691044 | 1691044 | 2021-09-06 | Concordia | Louisiana | 22029 | 2873 | 67 |
1691072 | 1691072 | 2021-09-06 | Sabine | Louisiana | 22085 | 3995 | 67 |
1687794 | 1687794 | 2021-09-05 | Concordia | Louisiana | 22029 | 2873 | 67 |
1687822 | 1687822 | 2021-09-05 | Sabine | Louisiana | 22085 | 3995 | 67 |
1684544 | 1684544 | 2021-09-04 | Concordia | Louisiana | 22029 | 2873 | 67 |
1684572 | 1684572 | 2021-09-04 | Sabine | Louisiana | 22085 | 3995 | 67 |
1681293 | 1681293 | 2021-09-03 | Concordia | Louisiana | 22029 | 2873 | 67 |
1681321 | 1681321 | 2021-09-03 | Sabine | Louisiana | 22085 | 3995 | 67 |
1678045 | 1678045 | 2021-09-02 | Concordia | Louisiana | 22029 | 2840 | 67 |
1678073 | 1678073 | 2021-09-02 | Sabine | Louisiana | 22085 | 3936 | 67 |
1674798 | 1674798 | 2021-09-01 | Concordia | Louisiana | 22029 | 2835 | 67 |
1674805 | 1674805 | 2021-09-01 | Grant | Louisiana | 22043 | 3398 | 67 |
1674826 | 1674826 | 2021-09-01 | Sabine | Louisiana | 22085 | 3901 | 67 |
1671576 | 1671576 | 2021-08-31 | Richland | Louisiana | 22083 | 3559 | 67 |
1671577 | 1671577 | 2021-08-31 | Sabine | Louisiana | 22085 | 3770 | 67 |
1668329 | 1668329 | 2021-08-30 | Richland | Louisiana | 22083 | 3559 | 67 |
1668330 | 1668330 | 2021-08-30 | Sabine | Louisiana | 22085 | 3770 | 67 |
1665082 | 1665082 | 2021-08-29 | Richland | Louisiana | 22083 | 3559 | 67 |
1665083 | 1665083 | 2021-08-29 | Sabine | Louisiana | 22085 | 3770 | 67 |
1661834 | 1661834 | 2021-08-28 | Richland | Louisiana | 22083 | 3559 | 67 |
1661835 | 1661835 | 2021-08-28 | Sabine | Louisiana | 22085 | 3770 | 67 |
1658586 | 1658586 | 2021-08-27 | Richland | Louisiana | 22083 | 3559 | 67 |
1658587 | 1658587 | 2021-08-27 | Sabine | Louisiana | 22085 | 3770 | 67 |
1655339 | 1655339 | 2021-08-26 | Sabine | Louisiana | 22085 | 3758 | 67 |
1652092 | 1652092 | 2021-08-25 | Sabine | Louisiana | 22085 | 3721 | 67 |
1648843 | 1648843 | 2021-08-24 | Sabine | Louisiana | 22085 | 3700 | 67 |
1648862 | 1648862 | 2021-08-24 | West Baton Rouge | Louisiana | 22121 | 4082 | 67 |
1645595 | 1645595 | 2021-08-23 | Sabine | Louisiana | 22085 | 3671 | 67 |
1645614 | 1645614 | 2021-08-23 | West Baton Rouge | Louisiana | 22121 | 4069 | 67 |
1642346 | 1642346 | 2021-08-22 | Sabine | Louisiana | 22085 | 3619 | 67 |
1642365 | 1642365 | 2021-08-22 | West Baton Rouge | Louisiana | 22121 | 4008 | 67 |
1639096 | 1639096 | 2021-08-21 | Sabine | Louisiana | 22085 | 3619 | 67 |
1639115 | 1639115 | 2021-08-21 | West Baton Rouge | Louisiana | 22121 | 4008 | 67 |
1635846 | 1635846 | 2021-08-20 | Sabine | Louisiana | 22085 | 3619 | 67 |
1635865 | 1635865 | 2021-08-20 | West Baton Rouge | Louisiana | 22121 | 4008 | 67 |
1632596 | 1632596 | 2021-08-19 | Sabine | Louisiana | 22085 | 3588 | 67 |
1632597 | 1632597 | 2021-08-19 | St. Bernard | Louisiana | 22087 | 5884 | 67 |
1632615 | 1632615 | 2021-08-19 | West Baton Rouge | Louisiana | 22121 | 3986 | 67 |
1629349 | 1629349 | 2021-08-18 | Sabine | Louisiana | 22085 | 3529 | 67 |
1629368 | 1629368 | 2021-08-18 | West Baton Rouge | Louisiana | 22121 | 3961 | 67 |
1626102 | 1626102 | 2021-08-17 | Sabine | Louisiana | 22085 | 3493 | 67 |
1626121 | 1626121 | 2021-08-17 | West Baton Rouge | Louisiana | 22121 | 3907 | 67 |
1622855 | 1622855 | 2021-08-16 | Sabine | Louisiana | 22085 | 3487 | 67 |
1622874 | 1622874 | 2021-08-16 | West Baton Rouge | Louisiana | 22121 | 3894 | 67 |
1106565 | 1106565 | 2021-03-10 | Beauregard | Louisiana | 22011 | 2879 | 67 |
1087116 | 1087116 | 2021-03-04 | Morehouse | Louisiana | 22067 | 2719 | 67 |
1083870 | 1083870 | 2021-03-03 | Morehouse | Louisiana | 22067 | 2717 | 67 |
1080624 | 1080624 | 2021-03-02 | Morehouse | Louisiana | 22067 | 2716 | 67 |
1077379 | 1077379 | 2021-03-01 | Morehouse | Louisiana | 22067 | 2714 | 67 |
1074133 | 1074133 | 2021-02-28 | Morehouse | Louisiana | 22067 | 2710 | 67 |
1070887 | 1070887 | 2021-02-27 | Morehouse | Louisiana | 22067 | 2702 | 67 |
1067642 | 1067642 | 2021-02-26 | Morehouse | Louisiana | 22067 | 2702 | 67 |
1064397 | 1064397 | 2021-02-25 | Morehouse | Louisiana | 22067 | 2695 | 67 |
1061152 | 1061152 | 2021-02-24 | Morehouse | Louisiana | 22067 | 2694 | 67 |
1057906 | 1057906 | 2021-02-23 | Morehouse | Louisiana | 22067 | 2693 | 67 |
1054660 | 1054660 | 2021-02-22 | Morehouse | Louisiana | 22067 | 2689 | 67 |
1051413 | 1051413 | 2021-02-21 | Morehouse | Louisiana | 22067 | 2681 | 67 |
1048166 | 1048166 | 2021-02-20 | Morehouse | Louisiana | 22067 | 2681 | 67 |
1044921 | 1044921 | 2021-02-19 | Morehouse | Louisiana | 22067 | 2681 | 67 |
1041676 | 1041676 | 2021-02-18 | Morehouse | Louisiana | 22067 | 2678 | 67 |
1038431 | 1038431 | 2021-02-17 | Morehouse | Louisiana | 22067 | 2680 | 67 |
1018963 | 1018963 | 2021-02-11 | Pointe Coupee | Louisiana | 22077 | 2319 | 67 |
1015718 | 1015718 | 2021-02-10 | Pointe Coupee | Louisiana | 22077 | 2303 | 67 |
1005958 | 1005958 | 2021-02-07 | De Soto | Louisiana | 22031 | 2552 | 67 |
1002703 | 1002703 | 2021-02-06 | Bienville | Louisiana | 22013 | 1537 | 67 |
1002712 | 1002712 | 2021-02-06 | De Soto | Louisiana | 22031 | 2544 | 67 |
999457 | 999457 | 2021-02-05 | Bienville | Louisiana | 22013 | 1537 | 67 |
999466 | 999466 | 2021-02-05 | De Soto | Louisiana | 22031 | 2544 | 67 |
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);