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 >30
county >30
- Jefferson 676
- Orleans 675
- Caddo 674
- St. Charles 672
- St. Tammany 672
- Terrebonne 672
- Bossier 671
- Lafourche 671
- St. John the Baptist 671
- St. Bernard 670
- Ascension 669
- East Baton Rouge 668
- Washington 668
- Assumption 666
- Calcasieu 666
- Iberia 666
- Iberville 666
- Lafayette 666
- Livingston 666
- Plaquemines 666
- St. James 666
- St. Landry 666
- Unknown 666
- Webster 666
- West Baton Rouge 666
- Catahoula 665
- De Soto 665
- Rapides 665
- Tangipahoa 665
- Avoyelles 664
- …
state 1
- Louisiana · 43,102 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110251 | 2110251 | 2022-01-13 | Acadia | Louisiana | 22001 | 12312 | 258 |
2110252 | 2110252 | 2022-01-13 | Allen | Louisiana | 22003 | 5409 | 119 |
2110253 | 2110253 | 2022-01-13 | Ascension | Louisiana | 22005 | 27518 | 253 |
2110254 | 2110254 | 2022-01-13 | Assumption | Louisiana | 22007 | 4427 | 57 |
2110255 | 2110255 | 2022-01-13 | Avoyelles | Louisiana | 22009 | 8482 | 179 |
2110256 | 2110256 | 2022-01-13 | Beauregard | Louisiana | 22011 | 6857 | 130 |
2110257 | 2110257 | 2022-01-13 | Bienville | Louisiana | 22013 | 2968 | 100 |
2110258 | 2110258 | 2022-01-13 | Bossier | Louisiana | 22015 | 27522 | 417 |
2110259 | 2110259 | 2022-01-13 | Caddo | Louisiana | 22017 | 51919 | 1000 |
2110260 | 2110260 | 2022-01-13 | Calcasieu | Louisiana | 22019 | 41198 | 641 |
2110261 | 2110261 | 2022-01-13 | Caldwell | Louisiana | 22021 | 2490 | 43 |
2110262 | 2110262 | 2022-01-13 | Cameron | Louisiana | 22023 | 984 | 8 |
2110263 | 2110263 | 2022-01-13 | Catahoula | Louisiana | 22025 | 2042 | 49 |
2110264 | 2110264 | 2022-01-13 | Claiborne | Louisiana | 22027 | 2429 | 67 |
2110265 | 2110265 | 2022-01-13 | Concordia | Louisiana | 22029 | 3808 | 80 |
2110266 | 2110266 | 2022-01-13 | De Soto | Louisiana | 22031 | 5735 | 119 |
2110267 | 2110267 | 2022-01-13 | East Baton Rouge | Louisiana | 22033 | 83046 | 1190 |
2110268 | 2110268 | 2022-01-13 | East Carroll | Louisiana | 22035 | 1900 | 33 |
2110269 | 2110269 | 2022-01-13 | East Feliciana | Louisiana | 22037 | 5249 | 153 |
2110270 | 2110270 | 2022-01-13 | Evangeline | Louisiana | 22039 | 6681 | 144 |
2110271 | 2110271 | 2022-01-13 | Franklin | Louisiana | 22041 | 5345 | 144 |
2110272 | 2110272 | 2022-01-13 | Grant | Louisiana | 22043 | 4307 | 80 |
2110273 | 2110273 | 2022-01-13 | Iberia | Louisiana | 22045 | 15165 | 234 |
2110274 | 2110274 | 2022-01-13 | Iberville | Louisiana | 22047 | 7134 | 129 |
2110275 | 2110275 | 2022-01-13 | Jackson | Louisiana | 22049 | 3149 | 65 |
2110276 | 2110276 | 2022-01-13 | Jefferson | Louisiana | 22051 | 92879 | 1202 |
2110277 | 2110277 | 2022-01-13 | Jefferson Davis | Louisiana | 22053 | 5407 | 133 |
2110278 | 2110278 | 2022-01-13 | LaSalle | Louisiana | 22059 | 3087 | 46 |
2110279 | 2110279 | 2022-01-13 | Lafayette | Louisiana | 22055 | 47529 | 420 |
2110280 | 2110280 | 2022-01-13 | Lafourche | Louisiana | 22057 | 21140 | 323 |
2110281 | 2110281 | 2022-01-13 | Lincoln | Louisiana | 22061 | 8709 | 121 |
2110282 | 2110282 | 2022-01-13 | Livingston | Louisiana | 22063 | 28406 | 396 |
2110283 | 2110283 | 2022-01-13 | Madison | Louisiana | 22065 | 2646 | 55 |
2110284 | 2110284 | 2022-01-13 | Morehouse | Louisiana | 22067 | 5302 | 120 |
2110285 | 2110285 | 2022-01-13 | Natchitoches | Louisiana | 22069 | 8164 | 142 |
2110286 | 2110286 | 2022-01-13 | Orleans | Louisiana | 22071 | 70360 | 1019 |
2110287 | 2110287 | 2022-01-13 | Ouachita | Louisiana | 22073 | 37857 | 617 |
2110288 | 2110288 | 2022-01-13 | Plaquemines | Louisiana | 22075 | 5161 | 41 |
2110289 | 2110289 | 2022-01-13 | Pointe Coupee | Louisiana | 22077 | 4630 | 85 |
2110290 | 2110290 | 2022-01-13 | Rapides | Louisiana | 22079 | 25243 | 486 |
2110291 | 2110291 | 2022-01-13 | Red River | Louisiana | 22081 | 1713 | 49 |
2110292 | 2110292 | 2022-01-13 | Richland | Louisiana | 22083 | 4904 | 81 |
2110293 | 2110293 | 2022-01-13 | Sabine | Louisiana | 22085 | 5234 | 100 |
2110294 | 2110294 | 2022-01-13 | St. Bernard | Louisiana | 22087 | 9060 | 101 |
2110295 | 2110295 | 2022-01-13 | St. Charles | Louisiana | 22089 | 11238 | 129 |
2110296 | 2110296 | 2022-01-13 | St. Helena | Louisiana | 22091 | 1435 | 20 |
2110297 | 2110297 | 2022-01-13 | St. James | Louisiana | 22093 | 4408 | 71 |
2110298 | 2110298 | 2022-01-13 | St. John the Baptist | Louisiana | 22095 | 8329 | 173 |
2110299 | 2110299 | 2022-01-13 | St. Landry | Louisiana | 22097 | 16488 | 354 |
2110300 | 2110300 | 2022-01-13 | St. Martin | Louisiana | 22099 | 10068 | 164 |
2110301 | 2110301 | 2022-01-13 | St. Mary | Louisiana | 22101 | 10220 | 236 |
2110302 | 2110302 | 2022-01-13 | St. Tammany | Louisiana | 22103 | 55677 | 748 |
2110303 | 2110303 | 2022-01-13 | Tangipahoa | Louisiana | 22105 | 26921 | 538 |
2110304 | 2110304 | 2022-01-13 | Tensas | Louisiana | 22107 | 685 | 10 |
2110305 | 2110305 | 2022-01-13 | Terrebonne | Louisiana | 22109 | 23565 | 369 |
2110306 | 2110306 | 2022-01-13 | Union | Louisiana | 22111 | 5028 | 114 |
2110307 | 2110307 | 2022-01-13 | Unknown | Louisiana | 33238 | 0 | |
2110308 | 2110308 | 2022-01-13 | Vermilion | Louisiana | 22113 | 11951 | 196 |
2110309 | 2110309 | 2022-01-13 | Vernon | Louisiana | 22115 | 7327 | 168 |
2110310 | 2110310 | 2022-01-13 | Washington | Louisiana | 22117 | 9549 | 222 |
2110311 | 2110311 | 2022-01-13 | Webster | Louisiana | 22119 | 8196 | 155 |
2110312 | 2110312 | 2022-01-13 | West Baton Rouge | Louisiana | 22121 | 5558 | 79 |
2110313 | 2110313 | 2022-01-13 | West Carroll | Louisiana | 22123 | 2408 | 53 |
2110314 | 2110314 | 2022-01-13 | West Feliciana | Louisiana | 22125 | 1542 | 41 |
2110315 | 2110315 | 2022-01-13 | Winn | Louisiana | 22127 | 3127 | 58 |
2107000 | 2107000 | 2022-01-12 | Acadia | Louisiana | 22001 | 12312 | 258 |
2107001 | 2107001 | 2022-01-12 | Allen | Louisiana | 22003 | 5409 | 119 |
2107002 | 2107002 | 2022-01-12 | Ascension | Louisiana | 22005 | 27518 | 253 |
2107003 | 2107003 | 2022-01-12 | Assumption | Louisiana | 22007 | 4427 | 57 |
2107004 | 2107004 | 2022-01-12 | Avoyelles | Louisiana | 22009 | 8482 | 179 |
2107005 | 2107005 | 2022-01-12 | Beauregard | Louisiana | 22011 | 6857 | 129 |
2107006 | 2107006 | 2022-01-12 | Bienville | Louisiana | 22013 | 2968 | 100 |
2107007 | 2107007 | 2022-01-12 | Bossier | Louisiana | 22015 | 27522 | 416 |
2107008 | 2107008 | 2022-01-12 | Caddo | Louisiana | 22017 | 51919 | 1000 |
2107009 | 2107009 | 2022-01-12 | Calcasieu | Louisiana | 22019 | 41198 | 641 |
2107010 | 2107010 | 2022-01-12 | Caldwell | Louisiana | 22021 | 2490 | 43 |
2107011 | 2107011 | 2022-01-12 | Cameron | Louisiana | 22023 | 984 | 8 |
2107012 | 2107012 | 2022-01-12 | Catahoula | Louisiana | 22025 | 2042 | 49 |
2107013 | 2107013 | 2022-01-12 | Claiborne | Louisiana | 22027 | 2429 | 67 |
2107014 | 2107014 | 2022-01-12 | Concordia | Louisiana | 22029 | 3808 | 80 |
2107015 | 2107015 | 2022-01-12 | De Soto | Louisiana | 22031 | 5735 | 119 |
2107016 | 2107016 | 2022-01-12 | East Baton Rouge | Louisiana | 22033 | 83046 | 1188 |
2107017 | 2107017 | 2022-01-12 | East Carroll | Louisiana | 22035 | 1900 | 33 |
2107018 | 2107018 | 2022-01-12 | East Feliciana | Louisiana | 22037 | 5249 | 153 |
2107019 | 2107019 | 2022-01-12 | Evangeline | Louisiana | 22039 | 6681 | 144 |
2107020 | 2107020 | 2022-01-12 | Franklin | Louisiana | 22041 | 5345 | 144 |
2107021 | 2107021 | 2022-01-12 | Grant | Louisiana | 22043 | 4307 | 80 |
2107022 | 2107022 | 2022-01-12 | Iberia | Louisiana | 22045 | 15165 | 234 |
2107023 | 2107023 | 2022-01-12 | Iberville | Louisiana | 22047 | 7134 | 129 |
2107024 | 2107024 | 2022-01-12 | Jackson | Louisiana | 22049 | 3149 | 65 |
2107025 | 2107025 | 2022-01-12 | Jefferson | Louisiana | 22051 | 92879 | 1202 |
2107026 | 2107026 | 2022-01-12 | Jefferson Davis | Louisiana | 22053 | 5407 | 133 |
2107027 | 2107027 | 2022-01-12 | LaSalle | Louisiana | 22059 | 3087 | 46 |
2107028 | 2107028 | 2022-01-12 | Lafayette | Louisiana | 22055 | 47529 | 420 |
2107029 | 2107029 | 2022-01-12 | Lafourche | Louisiana | 22057 | 21140 | 321 |
2107030 | 2107030 | 2022-01-12 | Lincoln | Louisiana | 22061 | 8709 | 121 |
2107031 | 2107031 | 2022-01-12 | Livingston | Louisiana | 22063 | 28406 | 394 |
2107032 | 2107032 | 2022-01-12 | Madison | Louisiana | 22065 | 2646 | 55 |
2107033 | 2107033 | 2022-01-12 | Morehouse | Louisiana | 22067 | 5302 | 119 |
2107034 | 2107034 | 2022-01-12 | Natchitoches | Louisiana | 22069 | 8164 | 142 |
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);