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 463
- 22071 462
- 22017 461
- 22089 459
- 22103 459
- 22109 459
- 22015 458
- 22057 458
- 22095 458
- 22087 457
- 22005 456
- 22033 455
- 22117 455
- - 454
- 22007 453
- 22019 453
- 22045 453
- 22047 453
- 22055 453
- 22063 453
- 22075 453
- 22093 453
- 22097 453
- 22119 453
- 22121 453
- 22025 452
- 22031 452
- 22079 452
- 22105 452
- 22009 451
- 22011 451
- 22013 451
- 22027 451
- 22039 451
- 22073 451
- 22101 451
- 22001 450
- 22003 449
- 22043 449
- 22061 449
- 22069 449
- 22083 449
- 22099 449
- 22115 448
- 22049 447
- 22053 447
- 22067 447
- 22111 447
- 22127 447
- 22037 446
- 22059 446
- 22065 446
- 22077 446
- 22113 446
- 22125 445
- 22035 444
- 22041 444
- 22081 443
- 22085 443
- 22029 441
- 22091 441
- 22021 439
- 22123 435
- 22023 434
- 22107 430
county 65
- Jefferson 463
- Orleans 462
- Caddo 461
- St. Charles 459
- St. Tammany 459
- Terrebonne 459
- Bossier 458
- Lafourche 458
- St. John the Baptist 458
- St. Bernard 457
- Ascension 456
- East Baton Rouge 455
- Washington 455
- Unknown 454
- Assumption 453
- Calcasieu 453
- Iberia 453
- Iberville 453
- Lafayette 453
- Livingston 453
- Plaquemines 453
- St. James 453
- St. Landry 453
- Webster 453
- West Baton Rouge 453
- Catahoula 452
- De Soto 452
- Rapides 452
- Tangipahoa 452
- Avoyelles 451
- Beauregard 451
- Bienville 451
- Claiborne 451
- Evangeline 451
- Ouachita 451
- St. Mary 451
- Acadia 450
- Allen 449
- Grant 449
- Lincoln 449
- Natchitoches 449
- Richland 449
- St. Martin 449
- Vernon 448
- Jackson 447
- Jefferson Davis 447
- Morehouse 447
- Union 447
- Winn 447
- East Feliciana 446
- LaSalle 446
- Madison 446
- Pointe Coupee 446
- Vermilion 446
- West Feliciana 445
- East Carroll 444
- Franklin 444
- Red River 443
- Sabine 443
- Concordia 441
- St. Helena 441
- Caldwell 439
- West Carroll 435
- Cameron 434
- Tensas 430
state 1
- Louisiana · 29,258 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418250 | 1418250 | 2021-06-14 | Acadia | Louisiana | 22001 | 6738 | 195 |
1418251 | 1418251 | 2021-06-14 | Allen | Louisiana | 22003 | 3255 | 92 |
1418252 | 1418252 | 2021-06-14 | Ascension | Louisiana | 22005 | 12735 | 167 |
1418253 | 1418253 | 2021-06-14 | Assumption | Louisiana | 22007 | 2307 | 36 |
1418254 | 1418254 | 2021-06-14 | Avoyelles | Louisiana | 22009 | 4330 | 123 |
1418255 | 1418255 | 2021-06-14 | Beauregard | Louisiana | 22011 | 3279 | 77 |
1418256 | 1418256 | 2021-06-14 | Bienville | Louisiana | 22013 | 1697 | 82 |
1418257 | 1418257 | 2021-06-14 | Bossier | Louisiana | 22015 | 14316 | 308 |
1418258 | 1418258 | 2021-06-14 | Caddo | Louisiana | 22017 | 26972 | 759 |
1418259 | 1418259 | 2021-06-14 | Calcasieu | Louisiana | 22019 | 22991 | 447 |
1418260 | 1418260 | 2021-06-14 | Caldwell | Louisiana | 22021 | 1128 | 29 |
1418261 | 1418261 | 2021-06-14 | Cameron | Louisiana | 22023 | 623 | 7 |
1418262 | 1418262 | 2021-06-14 | Catahoula | Louisiana | 22025 | 1175 | 38 |
1418263 | 1418263 | 2021-06-14 | Claiborne | Louisiana | 22027 | 1469 | 55 |
1418264 | 1418264 | 2021-06-14 | Concordia | Louisiana | 22029 | 1908 | 61 |
1418265 | 1418265 | 2021-06-14 | De Soto | Louisiana | 22031 | 2874 | 78 |
1418266 | 1418266 | 2021-06-14 | East Baton Rouge | Louisiana | 22033 | 40635 | 829 |
1418267 | 1418267 | 2021-06-14 | East Carroll | Louisiana | 22035 | 1136 | 27 |
1418268 | 1418268 | 2021-06-14 | East Feliciana | Louisiana | 22037 | 3226 | 114 |
1418269 | 1418269 | 2021-06-14 | Evangeline | Louisiana | 22039 | 3670 | 95 |
1418270 | 1418270 | 2021-06-14 | Franklin | Louisiana | 22041 | 2523 | 107 |
1418271 | 1418271 | 2021-06-14 | Grant | Louisiana | 22043 | 2239 | 58 |
1418272 | 1418272 | 2021-06-14 | Iberia | Louisiana | 22045 | 7343 | 159 |
1418273 | 1418273 | 2021-06-14 | Iberville | Louisiana | 22047 | 3903 | 100 |
1418274 | 1418274 | 2021-06-14 | Jackson | Louisiana | 22049 | 2048 | 51 |
1418275 | 1418275 | 2021-06-14 | Jefferson | Louisiana | 22051 | 47212 | 901 |
1418276 | 1418276 | 2021-06-14 | Jefferson Davis | Louisiana | 22053 | 3232 | 97 |
1418277 | 1418277 | 2021-06-14 | LaSalle | Louisiana | 22059 | 1675 | 37 |
1418278 | 1418278 | 2021-06-14 | Lafayette | Louisiana | 22055 | 24301 | 292 |
1418279 | 1418279 | 2021-06-14 | Lafourche | Louisiana | 22057 | 9959 | 205 |
1418280 | 1418280 | 2021-06-14 | Lincoln | Louisiana | 22061 | 4631 | 93 |
1418281 | 1418281 | 2021-06-14 | Livingston | Louisiana | 22063 | 14087 | 209 |
1418282 | 1418282 | 2021-06-14 | Madison | Louisiana | 22065 | 1570 | 40 |
1418283 | 1418283 | 2021-06-14 | Morehouse | Louisiana | 22067 | 2865 | 78 |
1418284 | 1418284 | 2021-06-14 | Natchitoches | Louisiana | 22069 | 4144 | 93 |
1418285 | 1418285 | 2021-06-14 | Orleans | Louisiana | 22071 | 30861 | 799 |
1418286 | 1418286 | 2021-06-14 | Ouachita | Louisiana | 22073 | 18889 | 458 |
1418287 | 1418287 | 2021-06-14 | Plaquemines | Louisiana | 22075 | 2559 | 27 |
1418288 | 1418288 | 2021-06-14 | Pointe Coupee | Louisiana | 22077 | 2689 | 75 |
1418289 | 1418289 | 2021-06-14 | Rapides | Louisiana | 22079 | 12622 | 324 |
1418290 | 1418290 | 2021-06-14 | Red River | Louisiana | 22081 | 898 | 38 |
1418291 | 1418291 | 2021-06-14 | Richland | Louisiana | 22083 | 2489 | 56 |
1418292 | 1418292 | 2021-06-14 | Sabine | Louisiana | 22085 | 2987 | 62 |
1418293 | 1418293 | 2021-06-14 | St. Bernard | Louisiana | 22087 | 4109 | 54 |
1418294 | 1418294 | 2021-06-14 | St. Charles | Louisiana | 22089 | 5586 | 97 |
1418295 | 1418295 | 2021-06-14 | St. Helena | Louisiana | 22091 | 975 | 12 |
1418296 | 1418296 | 2021-06-14 | St. James | Louisiana | 22093 | 2017 | 50 |
1418297 | 1418297 | 2021-06-14 | St. John the Baptist | Louisiana | 22095 | 3831 | 141 |
1418298 | 1418298 | 2021-06-14 | St. Landry | Louisiana | 22097 | 9118 | 261 |
1418299 | 1418299 | 2021-06-14 | St. Martin | Louisiana | 22099 | 5478 | 118 |
1418300 | 1418300 | 2021-06-14 | St. Mary | Louisiana | 22101 | 4935 | 141 |
1418301 | 1418301 | 2021-06-14 | St. Tammany | Louisiana | 22103 | 26169 | 528 |
1418302 | 1418302 | 2021-06-14 | Tangipahoa | Louisiana | 22105 | 13026 | 302 |
1418303 | 1418303 | 2021-06-14 | Tensas | Louisiana | 22107 | 369 | 8 |
1418304 | 1418304 | 2021-06-14 | Terrebonne | Louisiana | 22109 | 10790 | 225 |
1418305 | 1418305 | 2021-06-14 | Union | Louisiana | 22111 | 2435 | 81 |
1418306 | 1418306 | 2021-06-14 | Unknown | Louisiana | 394 | 0 | |
1418307 | 1418307 | 2021-06-14 | Vermilion | Louisiana | 22113 | 5709 | 125 |
1418308 | 1418308 | 2021-06-14 | Vernon | Louisiana | 22115 | 3187 | 104 |
1418309 | 1418309 | 2021-06-14 | Washington | Louisiana | 22117 | 4441 | 134 |
1418310 | 1418310 | 2021-06-14 | Webster | Louisiana | 22119 | 4220 | 113 |
1418311 | 1418311 | 2021-06-14 | West Baton Rouge | Louisiana | 22121 | 2961 | 62 |
1418312 | 1418312 | 2021-06-14 | West Carroll | Louisiana | 22123 | 1186 | 41 |
1418313 | 1418313 | 2021-06-14 | West Feliciana | Louisiana | 22125 | 1206 | 34 |
1418314 | 1418314 | 2021-06-14 | Winn | Louisiana | 22127 | 1576 | 46 |
1415004 | 1415004 | 2021-06-13 | Acadia | Louisiana | 22001 | 6737 | 195 |
1415005 | 1415005 | 2021-06-13 | Allen | Louisiana | 22003 | 3255 | 92 |
1415006 | 1415006 | 2021-06-13 | Ascension | Louisiana | 22005 | 12712 | 167 |
1415007 | 1415007 | 2021-06-13 | Assumption | Louisiana | 22007 | 2303 | 36 |
1415008 | 1415008 | 2021-06-13 | Avoyelles | Louisiana | 22009 | 4326 | 123 |
1415009 | 1415009 | 2021-06-13 | Beauregard | Louisiana | 22011 | 3279 | 77 |
1415010 | 1415010 | 2021-06-13 | Bienville | Louisiana | 22013 | 1693 | 82 |
1415011 | 1415011 | 2021-06-13 | Bossier | Louisiana | 22015 | 14301 | 308 |
1415012 | 1415012 | 2021-06-13 | Caddo | Louisiana | 22017 | 26944 | 759 |
1415013 | 1415013 | 2021-06-13 | Calcasieu | Louisiana | 22019 | 22956 | 447 |
1415014 | 1415014 | 2021-06-13 | Caldwell | Louisiana | 22021 | 1128 | 29 |
1415015 | 1415015 | 2021-06-13 | Cameron | Louisiana | 22023 | 623 | 7 |
1415016 | 1415016 | 2021-06-13 | Catahoula | Louisiana | 22025 | 1174 | 38 |
1415017 | 1415017 | 2021-06-13 | Claiborne | Louisiana | 22027 | 1467 | 55 |
1415018 | 1415018 | 2021-06-13 | Concordia | Louisiana | 22029 | 1908 | 61 |
1415019 | 1415019 | 2021-06-13 | De Soto | Louisiana | 22031 | 2870 | 78 |
1415020 | 1415020 | 2021-06-13 | East Baton Rouge | Louisiana | 22033 | 40591 | 829 |
1415021 | 1415021 | 2021-06-13 | East Carroll | Louisiana | 22035 | 1135 | 27 |
1415022 | 1415022 | 2021-06-13 | East Feliciana | Louisiana | 22037 | 3225 | 112 |
1415023 | 1415023 | 2021-06-13 | Evangeline | Louisiana | 22039 | 3668 | 94 |
1415024 | 1415024 | 2021-06-13 | Franklin | Louisiana | 22041 | 2523 | 107 |
1415025 | 1415025 | 2021-06-13 | Grant | Louisiana | 22043 | 2231 | 58 |
1415026 | 1415026 | 2021-06-13 | Iberia | Louisiana | 22045 | 7337 | 159 |
1415027 | 1415027 | 2021-06-13 | Iberville | Louisiana | 22047 | 3901 | 100 |
1415028 | 1415028 | 2021-06-13 | Jackson | Louisiana | 22049 | 2045 | 51 |
1415029 | 1415029 | 2021-06-13 | Jefferson | Louisiana | 22051 | 47175 | 901 |
1415030 | 1415030 | 2021-06-13 | Jefferson Davis | Louisiana | 22053 | 3230 | 97 |
1415031 | 1415031 | 2021-06-13 | LaSalle | Louisiana | 22059 | 1671 | 37 |
1415032 | 1415032 | 2021-06-13 | Lafayette | Louisiana | 22055 | 24265 | 291 |
1415033 | 1415033 | 2021-06-13 | Lafourche | Louisiana | 22057 | 9936 | 205 |
1415034 | 1415034 | 2021-06-13 | Lincoln | Louisiana | 22061 | 4631 | 93 |
1415035 | 1415035 | 2021-06-13 | Livingston | Louisiana | 22063 | 14042 | 209 |
1415036 | 1415036 | 2021-06-13 | Madison | Louisiana | 22065 | 1570 | 40 |
1415037 | 1415037 | 2021-06-13 | Morehouse | Louisiana | 22067 | 2863 | 78 |
1415038 | 1415038 | 2021-06-13 | Natchitoches | Louisiana | 22069 | 4142 | 93 |
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);