ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50,902 rows where state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 65
- 22051 794
- 22071 794
- 22017 792
- 22089 791
- 22103 791
- 22109 791
- 22095 790
- 22015 789
- 22057 789
- 22087 789
- 22005 787
- 22117 787
- 22033 786
- 22075 785
- 22093 785
- 22097 785
- 22119 785
- 22121 785
- - 785
- 22007 784
- 22019 784
- 22045 784
- 22047 784
- 22055 784
- 22063 784
- 22079 784
- 22105 784
- 22025 783
- 22031 783
- 22073 783
- 22101 783
- 22009 782
- 22011 782
- 22013 782
- 22027 782
- 22039 782
- 22001 781
- 22083 781
- 22099 781
- 22003 780
- 22043 780
- 22061 780
- 22069 780
- 22115 780
- 22111 779
- 22127 779
- 22049 778
- 22053 778
- 22067 778
- 22077 778
- 22113 778
- 22037 777
- 22059 777
- 22065 777
- 22125 777
- 22035 775
- 22041 775
- 22081 775
- 22085 775
- 22091 773
- 22029 772
- 22021 770
- 22123 767
- 22023 765
- 22107 762
county 65
- Jefferson 794
- Orleans 794
- Caddo 792
- St. Charles 791
- St. Tammany 791
- Terrebonne 791
- St. John the Baptist 790
- Bossier 789
- Lafourche 789
- St. Bernard 789
- Ascension 787
- Washington 787
- East Baton Rouge 786
- Plaquemines 785
- St. James 785
- St. Landry 785
- Unknown 785
- Webster 785
- West Baton Rouge 785
- Assumption 784
- Calcasieu 784
- Iberia 784
- Iberville 784
- Lafayette 784
- Livingston 784
- Rapides 784
- Tangipahoa 784
- Catahoula 783
- De Soto 783
- Ouachita 783
- St. Mary 783
- Avoyelles 782
- Beauregard 782
- Bienville 782
- Claiborne 782
- Evangeline 782
- Acadia 781
- Richland 781
- St. Martin 781
- Allen 780
- Grant 780
- Lincoln 780
- Natchitoches 780
- Vernon 780
- Union 779
- Winn 779
- Jackson 778
- Jefferson Davis 778
- Morehouse 778
- Pointe Coupee 778
- Vermilion 778
- East Feliciana 777
- LaSalle 777
- Madison 777
- West Feliciana 777
- East Carroll 775
- Franklin 775
- Red River 775
- Sabine 775
- St. Helena 773
- Concordia 772
- Caldwell 770
- West Carroll 767
- Cameron 765
- Tensas 762
state 1
- Louisiana · 50,802 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497476 | 2497476 | 2022-05-12 | Orleans | Louisiana | 22071 | 90134 | 1109 |
2497477 | 2497477 | 2022-05-12 | Ouachita | Louisiana | 22073 | 50759 | 754 |
2497478 | 2497478 | 2022-05-12 | Plaquemines | Louisiana | 22075 | 6505 | 45 |
2497479 | 2497479 | 2022-05-12 | Pointe Coupee | Louisiana | 22077 | 6293 | 93 |
2497480 | 2497480 | 2022-05-12 | Rapides | Louisiana | 22079 | 32783 | 577 |
2497481 | 2497481 | 2022-05-12 | Red River | Louisiana | 22081 | 2111 | 53 |
2497482 | 2497482 | 2022-05-12 | Richland | Louisiana | 22083 | 6730 | 97 |
2497483 | 2497483 | 2022-05-12 | Sabine | Louisiana | 22085 | 6342 | 113 |
2497484 | 2497484 | 2022-05-12 | St. Bernard | Louisiana | 22087 | 11431 | 111 |
2497485 | 2497485 | 2022-05-12 | St. Charles | Louisiana | 22089 | 13909 | 145 |
2497486 | 2497486 | 2022-05-12 | St. Helena | Louisiana | 22091 | 1919 | 23 |
2497487 | 2497487 | 2022-05-12 | St. James | Louisiana | 22093 | 5804 | 77 |
2497488 | 2497488 | 2022-05-12 | St. John the Baptist | Louisiana | 22095 | 10622 | 184 |
2497489 | 2497489 | 2022-05-12 | St. Landry | Louisiana | 22097 | 22275 | 416 |
2497490 | 2497490 | 2022-05-12 | St. Martin | Louisiana | 22099 | 12977 | 188 |
2497491 | 2497491 | 2022-05-12 | St. Mary | Louisiana | 22101 | 12522 | 262 |
2497492 | 2497492 | 2022-05-12 | St. Tammany | Louisiana | 22103 | 73013 | 851 |
2497493 | 2497493 | 2022-05-12 | Tangipahoa | Louisiana | 22105 | 34874 | 599 |
2497494 | 2497494 | 2022-05-12 | Tensas | Louisiana | 22107 | 988 | 11 |
2497495 | 2497495 | 2022-05-12 | Terrebonne | Louisiana | 22109 | 30992 | 419 |
2497496 | 2497496 | 2022-05-12 | Union | Louisiana | 22111 | 6928 | 135 |
2497497 | 2497497 | 2022-05-12 | Unknown | Louisiana | 983 | 0 | |
2497498 | 2497498 | 2022-05-12 | Vermilion | Louisiana | 22113 | 15328 | 224 |
2497499 | 2497499 | 2022-05-12 | Vernon | Louisiana | 22115 | 9938 | 191 |
2497500 | 2497500 | 2022-05-12 | Washington | Louisiana | 22117 | 12991 | 249 |
2497501 | 2497501 | 2022-05-12 | Webster | Louisiana | 22119 | 11141 | 186 |
2497502 | 2497502 | 2022-05-12 | West Baton Rouge | Louisiana | 22121 | 7334 | 90 |
2497503 | 2497503 | 2022-05-12 | West Carroll | Louisiana | 22123 | 3629 | 66 |
2497504 | 2497504 | 2022-05-12 | West Feliciana | Louisiana | 22125 | 2835 | 46 |
2497505 | 2497505 | 2022-05-12 | Winn | Louisiana | 22127 | 4450 | 64 |
2494183 | 2494183 | 2022-05-11 | Acadia | Louisiana | 22001 | 15904 | 294 |
2494184 | 2494184 | 2022-05-11 | Allen | Louisiana | 22003 | 7877 | 140 |
2494185 | 2494185 | 2022-05-11 | Ascension | Louisiana | 22005 | 34994 | 293 |
2494186 | 2494186 | 2022-05-11 | Assumption | Louisiana | 22007 | 5573 | 70 |
2494187 | 2494187 | 2022-05-11 | Avoyelles | Louisiana | 22009 | 11598 | 208 |
2494188 | 2494188 | 2022-05-11 | Beauregard | Louisiana | 22011 | 9267 | 143 |
2494189 | 2494189 | 2022-05-11 | Bienville | Louisiana | 22013 | 3990 | 110 |
2494190 | 2494190 | 2022-05-11 | Bossier | Louisiana | 22015 | 37665 | 493 |
2494191 | 2494191 | 2022-05-11 | Caddo | Louisiana | 22017 | 67523 | 1155 |
2494192 | 2494192 | 2022-05-11 | Calcasieu | Louisiana | 22019 | 54825 | 706 |
2494193 | 2494193 | 2022-05-11 | Caldwell | Louisiana | 22021 | 3624 | 55 |
2494194 | 2494194 | 2022-05-11 | Cameron | Louisiana | 22023 | 1199 | 8 |
2494195 | 2494195 | 2022-05-11 | Catahoula | Louisiana | 22025 | 2698 | 55 |
2494196 | 2494196 | 2022-05-11 | Claiborne | Louisiana | 22027 | 3280 | 78 |
2494197 | 2494197 | 2022-05-11 | Concordia | Louisiana | 22029 | 5097 | 89 |
2494198 | 2494198 | 2022-05-11 | De Soto | Louisiana | 22031 | 7359 | 135 |
2494199 | 2494199 | 2022-05-11 | East Baton Rouge | Louisiana | 22033 | 111538 | 1349 |
2494200 | 2494200 | 2022-05-11 | East Carroll | Louisiana | 22035 | 2538 | 38 |
2494201 | 2494201 | 2022-05-11 | East Feliciana | Louisiana | 22037 | 7324 | 170 |
2494202 | 2494202 | 2022-05-11 | Evangeline | Louisiana | 22039 | 8397 | 159 |
2494203 | 2494203 | 2022-05-11 | Franklin | Louisiana | 22041 | 7349 | 178 |
2494204 | 2494204 | 2022-05-11 | Grant | Louisiana | 22043 | 5859 | 94 |
2494205 | 2494205 | 2022-05-11 | Iberia | Louisiana | 22045 | 19134 | 263 |
2494206 | 2494206 | 2022-05-11 | Iberville | Louisiana | 22047 | 9019 | 153 |
2494207 | 2494207 | 2022-05-11 | Jackson | Louisiana | 22049 | 4409 | 76 |
2494208 | 2494208 | 2022-05-11 | Jefferson | Louisiana | 22051 | 115098 | 1341 |
2494209 | 2494209 | 2022-05-11 | Jefferson Davis | Louisiana | 22053 | 6941 | 157 |
2494210 | 2494210 | 2022-05-11 | LaSalle | Louisiana | 22059 | 4273 | 61 |
2494211 | 2494211 | 2022-05-11 | Lafayette | Louisiana | 22055 | 62802 | 500 |
2494212 | 2494212 | 2022-05-11 | Lafourche | Louisiana | 22057 | 27869 | 372 |
2494213 | 2494213 | 2022-05-11 | Lincoln | Louisiana | 22061 | 12264 | 144 |
2494214 | 2494214 | 2022-05-11 | Livingston | Louisiana | 22063 | 37211 | 466 |
2494215 | 2494215 | 2022-05-11 | Madison | Louisiana | 22065 | 3262 | 59 |
2494216 | 2494216 | 2022-05-11 | Morehouse | Louisiana | 22067 | 6871 | 134 |
2494217 | 2494217 | 2022-05-11 | Natchitoches | Louisiana | 22069 | 10155 | 167 |
2494218 | 2494218 | 2022-05-11 | Orleans | Louisiana | 22071 | 89868 | 1108 |
2494219 | 2494219 | 2022-05-11 | Ouachita | Louisiana | 22073 | 50746 | 754 |
2494220 | 2494220 | 2022-05-11 | Plaquemines | Louisiana | 22075 | 6483 | 45 |
2494221 | 2494221 | 2022-05-11 | Pointe Coupee | Louisiana | 22077 | 6293 | 93 |
2494222 | 2494222 | 2022-05-11 | Rapides | Louisiana | 22079 | 32774 | 577 |
2494223 | 2494223 | 2022-05-11 | Red River | Louisiana | 22081 | 2111 | 53 |
2494224 | 2494224 | 2022-05-11 | Richland | Louisiana | 22083 | 6729 | 97 |
2494225 | 2494225 | 2022-05-11 | Sabine | Louisiana | 22085 | 6341 | 113 |
2494226 | 2494226 | 2022-05-11 | St. Bernard | Louisiana | 22087 | 11417 | 111 |
2494227 | 2494227 | 2022-05-11 | St. Charles | Louisiana | 22089 | 13897 | 145 |
2494228 | 2494228 | 2022-05-11 | St. Helena | Louisiana | 22091 | 1918 | 23 |
2494229 | 2494229 | 2022-05-11 | St. James | Louisiana | 22093 | 5801 | 77 |
2494230 | 2494230 | 2022-05-11 | St. John the Baptist | Louisiana | 22095 | 10605 | 184 |
2494231 | 2494231 | 2022-05-11 | St. Landry | Louisiana | 22097 | 22264 | 416 |
2494232 | 2494232 | 2022-05-11 | St. Martin | Louisiana | 22099 | 12976 | 188 |
2494233 | 2494233 | 2022-05-11 | St. Mary | Louisiana | 22101 | 12516 | 262 |
2494234 | 2494234 | 2022-05-11 | St. Tammany | Louisiana | 22103 | 72921 | 851 |
2494235 | 2494235 | 2022-05-11 | Tangipahoa | Louisiana | 22105 | 34861 | 599 |
2494236 | 2494236 | 2022-05-11 | Tensas | Louisiana | 22107 | 988 | 11 |
2494237 | 2494237 | 2022-05-11 | Terrebonne | Louisiana | 22109 | 30976 | 419 |
2494238 | 2494238 | 2022-05-11 | Union | Louisiana | 22111 | 6925 | 135 |
2494239 | 2494239 | 2022-05-11 | Unknown | Louisiana | 983 | 0 | |
2494240 | 2494240 | 2022-05-11 | Vermilion | Louisiana | 22113 | 15323 | 224 |
2494241 | 2494241 | 2022-05-11 | Vernon | Louisiana | 22115 | 9936 | 191 |
2494242 | 2494242 | 2022-05-11 | Washington | Louisiana | 22117 | 12989 | 249 |
2494243 | 2494243 | 2022-05-11 | Webster | Louisiana | 22119 | 11138 | 186 |
2494244 | 2494244 | 2022-05-11 | West Baton Rouge | Louisiana | 22121 | 7333 | 90 |
2494245 | 2494245 | 2022-05-11 | West Carroll | Louisiana | 22123 | 3629 | 66 |
2494246 | 2494246 | 2022-05-11 | West Feliciana | Louisiana | 22125 | 2835 | 46 |
2494247 | 2494247 | 2022-05-11 | Winn | Louisiana | 22127 | 4447 | 64 |
2490925 | 2490925 | 2022-05-10 | Acadia | Louisiana | 22001 | 15902 | 294 |
2490926 | 2490926 | 2022-05-10 | Allen | Louisiana | 22003 | 7877 | 140 |
2490927 | 2490927 | 2022-05-10 | Ascension | Louisiana | 22005 | 34976 | 293 |
2490928 | 2490928 | 2022-05-10 | Assumption | Louisiana | 22007 | 5570 | 70 |
2490929 | 2490929 | 2022-05-10 | Avoyelles | Louisiana | 22009 | 11592 | 208 |
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);