ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where "date" is on date 2021-03-13 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Acadia 1
- Allen 1
- Ascension 1
- Assumption 1
- Avoyelles 1
- Beauregard 1
- Bienville 1
- Bossier 1
- Caddo 1
- Calcasieu 1
- Caldwell 1
- Cameron 1
- Catahoula 1
- Claiborne 1
- Concordia 1
- De Soto 1
- East Baton Rouge 1
- East Carroll 1
- East Feliciana 1
- Evangeline 1
- Franklin 1
- Grant 1
- Iberia 1
- Iberville 1
- Jackson 1
- Jefferson 1
- Jefferson Davis 1
- LaSalle 1
- Lafayette 1
- Lafourche 1
- …
state 1
- Louisiana · 65 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1116298 | 1116298 | 2021-03-13 | Acadia | Louisiana | 22001 | 6165 | 187 |
1116299 | 1116299 | 2021-03-13 | Allen | Louisiana | 22003 | 3028 | 90 |
1116300 | 1116300 | 2021-03-13 | Ascension | Louisiana | 22005 | 11152 | 153 |
1116301 | 1116301 | 2021-03-13 | Assumption | Louisiana | 22007 | 2110 | 34 |
1116302 | 1116302 | 2021-03-13 | Avoyelles | Louisiana | 22009 | 3966 | 118 |
1116303 | 1116303 | 2021-03-13 | Beauregard | Louisiana | 22011 | 2886 | 70 |
1116304 | 1116304 | 2021-03-13 | Bienville | Louisiana | 22013 | 1618 | 77 |
1116305 | 1116305 | 2021-03-13 | Bossier | Louisiana | 22015 | 13139 | 277 |
1116306 | 1116306 | 2021-03-13 | Caddo | Louisiana | 22017 | 24911 | 697 |
1116307 | 1116307 | 2021-03-13 | Calcasieu | Louisiana | 22019 | 20232 | 372 |
1116308 | 1116308 | 2021-03-13 | Caldwell | Louisiana | 22021 | 1087 | 26 |
1116309 | 1116309 | 2021-03-13 | Cameron | Louisiana | 22023 | 552 | 6 |
1116310 | 1116310 | 2021-03-13 | Catahoula | Louisiana | 22025 | 1064 | 35 |
1116311 | 1116311 | 2021-03-13 | Claiborne | Louisiana | 22027 | 1409 | 50 |
1116312 | 1116312 | 2021-03-13 | Concordia | Louisiana | 22029 | 1797 | 60 |
1116313 | 1116313 | 2021-03-13 | De Soto | Louisiana | 22031 | 2669 | 75 |
1116314 | 1116314 | 2021-03-13 | East Baton Rouge | Louisiana | 22033 | 36342 | 750 |
1116315 | 1116315 | 2021-03-13 | East Carroll | Louisiana | 22035 | 1115 | 23 |
1116316 | 1116316 | 2021-03-13 | East Feliciana | Louisiana | 22037 | 3039 | 107 |
1116317 | 1116317 | 2021-03-13 | Evangeline | Louisiana | 22039 | 3372 | 82 |
1116318 | 1116318 | 2021-03-13 | Franklin | Louisiana | 22041 | 2456 | 104 |
1116319 | 1116319 | 2021-03-13 | Grant | Louisiana | 22043 | 2030 | 52 |
1116320 | 1116320 | 2021-03-13 | Iberia | Louisiana | 22045 | 6567 | 148 |
1116321 | 1116321 | 2021-03-13 | Iberville | Louisiana | 22047 | 3533 | 92 |
1116322 | 1116322 | 2021-03-13 | Jackson | Louisiana | 22049 | 1815 | 48 |
1116323 | 1116323 | 2021-03-13 | Jefferson | Louisiana | 22051 | 44467 | 862 |
1116324 | 1116324 | 2021-03-13 | Jefferson Davis | Louisiana | 22053 | 2931 | 88 |
1116325 | 1116325 | 2021-03-13 | LaSalle | Louisiana | 22059 | 1434 | 34 |
1116326 | 1116326 | 2021-03-13 | Lafayette | Louisiana | 22055 | 21861 | 265 |
1116327 | 1116327 | 2021-03-13 | Lafourche | Louisiana | 22057 | 9270 | 198 |
1116328 | 1116328 | 2021-03-13 | Lincoln | Louisiana | 22061 | 4256 | 89 |
1116329 | 1116329 | 2021-03-13 | Livingston | Louisiana | 22063 | 12538 | 188 |
1116330 | 1116330 | 2021-03-13 | Madison | Louisiana | 22065 | 1557 | 36 |
1116331 | 1116331 | 2021-03-13 | Morehouse | Louisiana | 22067 | 2729 | 70 |
1116332 | 1116332 | 2021-03-13 | Natchitoches | Louisiana | 22069 | 3882 | 81 |
1116333 | 1116333 | 2021-03-13 | Orleans | Louisiana | 22071 | 28844 | 770 |
1116334 | 1116334 | 2021-03-13 | Ouachita | Louisiana | 22073 | 17753 | 427 |
1116335 | 1116335 | 2021-03-13 | Plaquemines | Louisiana | 22075 | 2394 | 25 |
1116336 | 1116336 | 2021-03-13 | Pointe Coupee | Louisiana | 22077 | 2393 | 70 |
1116337 | 1116337 | 2021-03-13 | Rapides | Louisiana | 22079 | 11360 | 300 |
1116338 | 1116338 | 2021-03-13 | Red River | Louisiana | 22081 | 863 | 37 |
1116339 | 1116339 | 2021-03-13 | Richland | Louisiana | 22083 | 2366 | 51 |
1116340 | 1116340 | 2021-03-13 | Sabine | Louisiana | 22085 | 2803 | 56 |
1116341 | 1116341 | 2021-03-13 | St. Bernard | Louisiana | 22087 | 3837 | 47 |
1116342 | 1116342 | 2021-03-13 | St. Charles | Louisiana | 22089 | 5187 | 90 |
1116343 | 1116343 | 2021-03-13 | St. Helena | Louisiana | 22091 | 884 | 8 |
1116344 | 1116344 | 2021-03-13 | St. James | Louisiana | 22093 | 1876 | 49 |
1116345 | 1116345 | 2021-03-13 | St. John the Baptist | Louisiana | 22095 | 3566 | 134 |
1116346 | 1116346 | 2021-03-13 | St. Landry | Louisiana | 22097 | 8394 | 246 |
1116347 | 1116347 | 2021-03-13 | St. Martin | Louisiana | 22099 | 4888 | 114 |
1116348 | 1116348 | 2021-03-13 | St. Mary | Louisiana | 22101 | 4245 | 124 |
1116349 | 1116349 | 2021-03-13 | St. Tammany | Louisiana | 22103 | 24629 | 504 |
1116350 | 1116350 | 2021-03-13 | Tangipahoa | Louisiana | 22105 | 12109 | 277 |
1116351 | 1116351 | 2021-03-13 | Tensas | Louisiana | 22107 | 356 | 6 |
1116352 | 1116352 | 2021-03-13 | Terrebonne | Louisiana | 22109 | 9715 | 210 |
1116353 | 1116353 | 2021-03-13 | Union | Louisiana | 22111 | 2314 | 77 |
1116354 | 1116354 | 2021-03-13 | Unknown | Louisiana | 421 | 0 | |
1116355 | 1116355 | 2021-03-13 | Vermilion | Louisiana | 22113 | 4970 | 109 |
1116356 | 1116356 | 2021-03-13 | Vernon | Louisiana | 22115 | 2910 | 97 |
1116357 | 1116357 | 2021-03-13 | Washington | Louisiana | 22117 | 4154 | 122 |
1116358 | 1116358 | 2021-03-13 | Webster | Louisiana | 22119 | 3951 | 101 |
1116359 | 1116359 | 2021-03-13 | West Baton Rouge | Louisiana | 22121 | 2560 | 55 |
1116360 | 1116360 | 2021-03-13 | West Carroll | Louisiana | 22123 | 1163 | 39 |
1116361 | 1116361 | 2021-03-13 | West Feliciana | Louisiana | 22125 | 1116 | 32 |
1116362 | 1116362 | 2021-03-13 | Winn | Louisiana | 22127 | 1482 | 40 |
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);