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 318
- 22071 317
- 22017 316
- 22089 314
- 22103 314
- 22109 314
- 22015 313
- 22057 313
- 22095 313
- 22087 312
- 22005 311
- 22033 310
- 22117 310
- - 309
- 22007 308
- 22019 308
- 22045 308
- 22047 308
- 22055 308
- 22063 308
- 22075 308
- 22093 308
- 22097 308
- 22119 308
- 22121 308
- 22025 307
- 22031 307
- 22079 307
- 22105 307
- 22009 306
- 22011 306
- 22013 306
- 22027 306
- 22039 306
- 22073 306
- 22101 306
- 22001 305
- 22003 304
- 22043 304
- 22061 304
- 22069 304
- 22083 304
- 22099 304
- 22115 303
- 22049 302
- 22053 302
- 22067 302
- 22111 302
- 22127 302
- 22037 301
- 22059 301
- 22065 301
- 22077 301
- 22113 301
- 22125 300
- 22035 299
- 22041 299
- 22081 298
- 22085 298
- 22029 296
- 22091 296
- 22021 294
- 22123 290
- 22023 289
- 22107 285
county 65
- Jefferson 318
- Orleans 317
- Caddo 316
- St. Charles 314
- St. Tammany 314
- Terrebonne 314
- Bossier 313
- Lafourche 313
- St. John the Baptist 313
- St. Bernard 312
- Ascension 311
- East Baton Rouge 310
- Washington 310
- Unknown 309
- Assumption 308
- Calcasieu 308
- Iberia 308
- Iberville 308
- Lafayette 308
- Livingston 308
- Plaquemines 308
- St. James 308
- St. Landry 308
- Webster 308
- West Baton Rouge 308
- Catahoula 307
- De Soto 307
- Rapides 307
- Tangipahoa 307
- Avoyelles 306
- Beauregard 306
- Bienville 306
- Claiborne 306
- Evangeline 306
- Ouachita 306
- St. Mary 306
- Acadia 305
- Allen 304
- Grant 304
- Lincoln 304
- Natchitoches 304
- Richland 304
- St. Martin 304
- Vernon 303
- Jackson 302
- Jefferson Davis 302
- Morehouse 302
- Union 302
- Winn 302
- East Feliciana 301
- LaSalle 301
- Madison 301
- Pointe Coupee 301
- Vermilion 301
- West Feliciana 300
- East Carroll 299
- Franklin 299
- Red River 298
- Sabine 298
- Concordia 296
- St. Helena 296
- Caldwell 294
- West Carroll 290
- Cameron 289
- Tensas 285
state 1
- Louisiana · 19,833 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947521 | 947521 | 2021-01-20 | Acadia | Louisiana | 22001 | 5627 | 174 |
947522 | 947522 | 2021-01-20 | Allen | Louisiana | 22003 | 2697 | 76 |
947523 | 947523 | 2021-01-20 | Ascension | Louisiana | 22005 | 9607 | 134 |
947524 | 947524 | 2021-01-20 | Assumption | Louisiana | 22007 | 1682 | 29 |
947525 | 947525 | 2021-01-20 | Avoyelles | Louisiana | 22009 | 3262 | 100 |
947526 | 947526 | 2021-01-20 | Beauregard | Louisiana | 22011 | 2433 | 60 |
947527 | 947527 | 2021-01-20 | Bienville | Louisiana | 22013 | 1403 | 63 |
947528 | 947528 | 2021-01-20 | Bossier | Louisiana | 22015 | 10826 | 224 |
947529 | 947529 | 2021-01-20 | Caddo | Louisiana | 22017 | 21265 | 586 |
947530 | 947530 | 2021-01-20 | Calcasieu | Louisiana | 22019 | 16456 | 310 |
947531 | 947531 | 2021-01-20 | Caldwell | Louisiana | 22021 | 1018 | 23 |
947532 | 947532 | 2021-01-20 | Cameron | Louisiana | 22023 | 458 | 4 |
947533 | 947533 | 2021-01-20 | Catahoula | Louisiana | 22025 | 980 | 29 |
947534 | 947534 | 2021-01-20 | Claiborne | Louisiana | 22027 | 1276 | 47 |
947535 | 947535 | 2021-01-20 | Concordia | Louisiana | 22029 | 1642 | 49 |
947536 | 947536 | 2021-01-20 | De Soto | Louisiana | 22031 | 2108 | 56 |
947537 | 947537 | 2021-01-20 | East Baton Rouge | Louisiana | 22033 | 30494 | 648 |
947538 | 947538 | 2021-01-20 | East Carroll | Louisiana | 22035 | 1048 | 19 |
947539 | 947539 | 2021-01-20 | East Feliciana | Louisiana | 22037 | 2713 | 98 |
947540 | 947540 | 2021-01-20 | Evangeline | Louisiana | 22039 | 2973 | 68 |
947541 | 947541 | 2021-01-20 | Franklin | Louisiana | 22041 | 2276 | 93 |
947542 | 947542 | 2021-01-20 | Grant | Louisiana | 22043 | 1759 | 42 |
947543 | 947543 | 2021-01-20 | Iberia | Louisiana | 22045 | 5691 | 132 |
947544 | 947544 | 2021-01-20 | Iberville | Louisiana | 22047 | 3091 | 78 |
947545 | 947545 | 2021-01-20 | Jackson | Louisiana | 22049 | 1540 | 41 |
947546 | 947546 | 2021-01-20 | Jefferson | Louisiana | 22051 | 38283 | 738 |
947547 | 947547 | 2021-01-20 | Jefferson Davis | Louisiana | 22053 | 2595 | 74 |
947548 | 947548 | 2021-01-20 | LaSalle | Louisiana | 22059 | 1279 | 31 |
947549 | 947549 | 2021-01-20 | Lafayette | Louisiana | 22055 | 19507 | 223 |
947550 | 947550 | 2021-01-20 | Lafourche | Louisiana | 22057 | 7570 | 172 |
947551 | 947551 | 2021-01-20 | Lincoln | Louisiana | 22061 | 3788 | 81 |
947552 | 947552 | 2021-01-20 | Livingston | Louisiana | 22063 | 10521 | 147 |
947553 | 947553 | 2021-01-20 | Madison | Louisiana | 22065 | 1480 | 27 |
947554 | 947554 | 2021-01-20 | Morehouse | Louisiana | 22067 | 2471 | 58 |
947555 | 947555 | 2021-01-20 | Natchitoches | Louisiana | 22069 | 3457 | 71 |
947556 | 947556 | 2021-01-20 | Orleans | Louisiana | 22071 | 24844 | 702 |
947557 | 947557 | 2021-01-20 | Ouachita | Louisiana | 22073 | 16252 | 350 |
947558 | 947558 | 2021-01-20 | Plaquemines | Louisiana | 22075 | 2004 | 22 |
947559 | 947559 | 2021-01-20 | Pointe Coupee | Louisiana | 22077 | 2172 | 63 |
947560 | 947560 | 2021-01-20 | Rapides | Louisiana | 22079 | 10022 | 237 |
947561 | 947561 | 2021-01-20 | Red River | Louisiana | 22081 | 754 | 30 |
947562 | 947562 | 2021-01-20 | Richland | Louisiana | 22083 | 2039 | 42 |
947563 | 947563 | 2021-01-20 | Sabine | Louisiana | 22085 | 2418 | 48 |
947564 | 947564 | 2021-01-20 | St. Bernard | Louisiana | 22087 | 2993 | 42 |
947565 | 947565 | 2021-01-20 | St. Charles | Louisiana | 22089 | 4492 | 80 |
947566 | 947566 | 2021-01-20 | St. Helena | Louisiana | 22091 | 813 | 7 |
947567 | 947567 | 2021-01-20 | St. James | Louisiana | 22093 | 1636 | 45 |
947568 | 947568 | 2021-01-20 | St. John the Baptist | Louisiana | 22095 | 3090 | 124 |
947569 | 947569 | 2021-01-20 | St. Landry | Louisiana | 22097 | 7518 | 218 |
947570 | 947570 | 2021-01-20 | St. Martin | Louisiana | 22099 | 4409 | 99 |
947571 | 947571 | 2021-01-20 | St. Mary | Louisiana | 22101 | 3586 | 107 |
947572 | 947572 | 2021-01-20 | St. Tammany | Louisiana | 22103 | 19676 | 407 |
947573 | 947573 | 2021-01-20 | Tangipahoa | Louisiana | 22105 | 10392 | 211 |
947574 | 947574 | 2021-01-20 | Tensas | Louisiana | 22107 | 333 | 5 |
947575 | 947575 | 2021-01-20 | Terrebonne | Louisiana | 22109 | 7755 | 163 |
947576 | 947576 | 2021-01-20 | Union | Louisiana | 22111 | 2139 | 71 |
947577 | 947577 | 2021-01-20 | Unknown | Louisiana | 412 | 0 | |
947578 | 947578 | 2021-01-20 | Vermilion | Louisiana | 22113 | 4284 | 95 |
947579 | 947579 | 2021-01-20 | Vernon | Louisiana | 22115 | 2558 | 82 |
947580 | 947580 | 2021-01-20 | Washington | Louisiana | 22117 | 3633 | 102 |
947581 | 947581 | 2021-01-20 | Webster | Louisiana | 22119 | 3449 | 78 |
947582 | 947582 | 2021-01-20 | West Baton Rouge | Louisiana | 22121 | 2182 | 50 |
947583 | 947583 | 2021-01-20 | West Carroll | Louisiana | 22123 | 1084 | 36 |
947584 | 947584 | 2021-01-20 | West Feliciana | Louisiana | 22125 | 1038 | 28 |
947585 | 947585 | 2021-01-20 | Winn | Louisiana | 22127 | 1329 | 34 |
944274 | 944274 | 2021-01-19 | Acadia | Louisiana | 22001 | 5600 | 173 |
944275 | 944275 | 2021-01-19 | Allen | Louisiana | 22003 | 2672 | 76 |
944276 | 944276 | 2021-01-19 | Ascension | Louisiana | 22005 | 9570 | 132 |
944277 | 944277 | 2021-01-19 | Assumption | Louisiana | 22007 | 1657 | 29 |
944278 | 944278 | 2021-01-19 | Avoyelles | Louisiana | 22009 | 3225 | 100 |
944279 | 944279 | 2021-01-19 | Beauregard | Louisiana | 22011 | 2376 | 59 |
944280 | 944280 | 2021-01-19 | Bienville | Louisiana | 22013 | 1393 | 63 |
944281 | 944281 | 2021-01-19 | Bossier | Louisiana | 22015 | 10712 | 222 |
944282 | 944282 | 2021-01-19 | Caddo | Louisiana | 22017 | 21115 | 576 |
944283 | 944283 | 2021-01-19 | Calcasieu | Louisiana | 22019 | 16266 | 310 |
944284 | 944284 | 2021-01-19 | Caldwell | Louisiana | 22021 | 1013 | 23 |
944285 | 944285 | 2021-01-19 | Cameron | Louisiana | 22023 | 453 | 4 |
944286 | 944286 | 2021-01-19 | Catahoula | Louisiana | 22025 | 980 | 29 |
944287 | 944287 | 2021-01-19 | Claiborne | Louisiana | 22027 | 1279 | 47 |
944288 | 944288 | 2021-01-19 | Concordia | Louisiana | 22029 | 1638 | 48 |
944289 | 944289 | 2021-01-19 | De Soto | Louisiana | 22031 | 2088 | 55 |
944290 | 944290 | 2021-01-19 | East Baton Rouge | Louisiana | 22033 | 30414 | 641 |
944291 | 944291 | 2021-01-19 | East Carroll | Louisiana | 22035 | 1043 | 19 |
944292 | 944292 | 2021-01-19 | East Feliciana | Louisiana | 22037 | 2701 | 98 |
944293 | 944293 | 2021-01-19 | Evangeline | Louisiana | 22039 | 2953 | 68 |
944294 | 944294 | 2021-01-19 | Franklin | Louisiana | 22041 | 2269 | 94 |
944295 | 944295 | 2021-01-19 | Grant | Louisiana | 22043 | 1745 | 42 |
944296 | 944296 | 2021-01-19 | Iberia | Louisiana | 22045 | 5651 | 132 |
944297 | 944297 | 2021-01-19 | Iberville | Louisiana | 22047 | 3080 | 77 |
944298 | 944298 | 2021-01-19 | Jackson | Louisiana | 22049 | 1526 | 41 |
944299 | 944299 | 2021-01-19 | Jefferson | Louisiana | 22051 | 38037 | 737 |
944300 | 944300 | 2021-01-19 | Jefferson Davis | Louisiana | 22053 | 2569 | 72 |
944301 | 944301 | 2021-01-19 | LaSalle | Louisiana | 22059 | 1275 | 29 |
944302 | 944302 | 2021-01-19 | Lafayette | Louisiana | 22055 | 19427 | 218 |
944303 | 944303 | 2021-01-19 | Lafourche | Louisiana | 22057 | 7480 | 170 |
944304 | 944304 | 2021-01-19 | Lincoln | Louisiana | 22061 | 3761 | 80 |
944305 | 944305 | 2021-01-19 | Livingston | Louisiana | 22063 | 10471 | 144 |
944306 | 944306 | 2021-01-19 | Madison | Louisiana | 22065 | 1480 | 26 |
944307 | 944307 | 2021-01-19 | Morehouse | Louisiana | 22067 | 2452 | 57 |
944308 | 944308 | 2021-01-19 | Natchitoches | Louisiana | 22069 | 3404 | 69 |
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);