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 418
- Orleans 418
- Caddo 416
- St. Charles 415
- St. Tammany 415
- Terrebonne 415
- St. John the Baptist 414
- Bossier 413
- Lafourche 413
- St. Bernard 413
- Ascension 411
- Washington 411
- East Baton Rouge 410
- Unknown 410
- Plaquemines 409
- St. James 409
- St. Landry 409
- Webster 409
- West Baton Rouge 409
- Assumption 408
- Calcasieu 408
- Iberia 408
- Iberville 408
- Lafayette 408
- Livingston 408
- Rapides 408
- Tangipahoa 408
- Catahoula 407
- De Soto 407
- Ouachita 407
- …
state 1
- Louisiana · 26,363 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1275452 | 1275452 | 2021-05-01 | Orleans | Louisiana | 22071 | 29878 | 792 |
1275453 | 1275453 | 2021-05-01 | Ouachita | Louisiana | 22073 | 18301 | 448 |
1275454 | 1275454 | 2021-05-01 | Plaquemines | Louisiana | 22075 | 2517 | 26 |
1275455 | 1275455 | 2021-05-01 | Pointe Coupee | Louisiana | 22077 | 2612 | 73 |
1275456 | 1275456 | 2021-05-01 | Rapides | Louisiana | 22079 | 11974 | 314 |
1275457 | 1275457 | 2021-05-01 | Red River | Louisiana | 22081 | 874 | 38 |
1275458 | 1275458 | 2021-05-01 | Richland | Louisiana | 22083 | 2416 | 54 |
1275459 | 1275459 | 2021-05-01 | Sabine | Louisiana | 22085 | 2925 | 60 |
1275460 | 1275460 | 2021-05-01 | St. Bernard | Louisiana | 22087 | 4003 | 50 |
1275461 | 1275461 | 2021-05-01 | St. Charles | Louisiana | 22089 | 5373 | 93 |
1275462 | 1275462 | 2021-05-01 | St. Helena | Louisiana | 22091 | 922 | 10 |
1275463 | 1275463 | 2021-05-01 | St. James | Louisiana | 22093 | 1955 | 50 |
1275464 | 1275464 | 2021-05-01 | St. John the Baptist | Louisiana | 22095 | 3696 | 137 |
1275465 | 1275465 | 2021-05-01 | St. Landry | Louisiana | 22097 | 8813 | 253 |
1275466 | 1275466 | 2021-05-01 | St. Martin | Louisiana | 22099 | 5208 | 116 |
1275467 | 1275467 | 2021-05-01 | St. Mary | Louisiana | 22101 | 4665 | 134 |
1275468 | 1275468 | 2021-05-01 | St. Tammany | Louisiana | 22103 | 25568 | 520 |
1275469 | 1275469 | 2021-05-01 | Tangipahoa | Louisiana | 22105 | 12610 | 292 |
1275470 | 1275470 | 2021-05-01 | Tensas | Louisiana | 22107 | 360 | 8 |
1275471 | 1275471 | 2021-05-01 | Terrebonne | Louisiana | 22109 | 10100 | 220 |
1275472 | 1275472 | 2021-05-01 | Union | Louisiana | 22111 | 2379 | 77 |
1275473 | 1275473 | 2021-05-01 | Unknown | Louisiana | 411 | 0 | |
1275474 | 1275474 | 2021-05-01 | Vermilion | Louisiana | 22113 | 5324 | 119 |
1275475 | 1275475 | 2021-05-01 | Vernon | Louisiana | 22115 | 3058 | 101 |
1275476 | 1275476 | 2021-05-01 | Washington | Louisiana | 22117 | 4357 | 129 |
1275477 | 1275477 | 2021-05-01 | Webster | Louisiana | 22119 | 4086 | 112 |
1275478 | 1275478 | 2021-05-01 | West Baton Rouge | Louisiana | 22121 | 2841 | 59 |
1275479 | 1275479 | 2021-05-01 | West Carroll | Louisiana | 22123 | 1173 | 41 |
1275480 | 1275480 | 2021-05-01 | West Feliciana | Louisiana | 22125 | 1153 | 34 |
1275481 | 1275481 | 2021-05-01 | Winn | Louisiana | 22127 | 1535 | 43 |
1272170 | 1272170 | 2021-04-30 | Acadia | Louisiana | 22001 | 6481 | 192 |
1272171 | 1272171 | 2021-04-30 | Allen | Louisiana | 22003 | 3168 | 91 |
1272172 | 1272172 | 2021-04-30 | Ascension | Louisiana | 22005 | 12080 | 164 |
1272173 | 1272173 | 2021-04-30 | Assumption | Louisiana | 22007 | 2173 | 36 |
1272174 | 1272174 | 2021-04-30 | Avoyelles | Louisiana | 22009 | 4178 | 123 |
1272175 | 1272175 | 2021-04-30 | Beauregard | Louisiana | 22011 | 3166 | 77 |
1272176 | 1272176 | 2021-04-30 | Bienville | Louisiana | 22013 | 1660 | 81 |
1272177 | 1272177 | 2021-04-30 | Bossier | Louisiana | 22015 | 13752 | 298 |
1272178 | 1272178 | 2021-04-30 | Caddo | Louisiana | 22017 | 25830 | 740 |
1272179 | 1272179 | 2021-04-30 | Calcasieu | Louisiana | 22019 | 22340 | 426 |
1272180 | 1272180 | 2021-04-30 | Caldwell | Louisiana | 22021 | 1107 | 29 |
1272181 | 1272181 | 2021-04-30 | Cameron | Louisiana | 22023 | 599 | 6 |
1272182 | 1272182 | 2021-04-30 | Catahoula | Louisiana | 22025 | 1153 | 38 |
1272183 | 1272183 | 2021-04-30 | Claiborne | Louisiana | 22027 | 1435 | 55 |
1272184 | 1272184 | 2021-04-30 | Concordia | Louisiana | 22029 | 1854 | 60 |
1272185 | 1272185 | 2021-04-30 | De Soto | Louisiana | 22031 | 2763 | 78 |
1272186 | 1272186 | 2021-04-30 | East Baton Rouge | Louisiana | 22033 | 39099 | 799 |
1272187 | 1272187 | 2021-04-30 | East Carroll | Louisiana | 22035 | 1124 | 25 |
1272188 | 1272188 | 2021-04-30 | East Feliciana | Louisiana | 22037 | 3147 | 112 |
1272189 | 1272189 | 2021-04-30 | Evangeline | Louisiana | 22039 | 3580 | 92 |
1272190 | 1272190 | 2021-04-30 | Franklin | Louisiana | 22041 | 2477 | 105 |
1272191 | 1272191 | 2021-04-30 | Grant | Louisiana | 22043 | 2132 | 55 |
1272192 | 1272192 | 2021-04-30 | Iberia | Louisiana | 22045 | 6971 | 153 |
1272193 | 1272193 | 2021-04-30 | Iberville | Louisiana | 22047 | 3796 | 98 |
1272194 | 1272194 | 2021-04-30 | Jackson | Louisiana | 22049 | 1904 | 50 |
1272195 | 1272195 | 2021-04-30 | Jefferson | Louisiana | 22051 | 45903 | 891 |
1272196 | 1272196 | 2021-04-30 | Jefferson Davis | Louisiana | 22053 | 3149 | 96 |
1272197 | 1272197 | 2021-04-30 | LaSalle | Louisiana | 22059 | 1528 | 36 |
1272198 | 1272198 | 2021-04-30 | Lafayette | Louisiana | 22055 | 23220 | 276 |
1272199 | 1272199 | 2021-04-30 | Lafourche | Louisiana | 22057 | 9514 | 203 |
1272200 | 1272200 | 2021-04-30 | Lincoln | Louisiana | 22061 | 4482 | 92 |
1272201 | 1272201 | 2021-04-30 | Livingston | Louisiana | 22063 | 13311 | 204 |
1272202 | 1272202 | 2021-04-30 | Madison | Louisiana | 22065 | 1563 | 39 |
1272203 | 1272203 | 2021-04-30 | Morehouse | Louisiana | 22067 | 2815 | 73 |
1272204 | 1272204 | 2021-04-30 | Natchitoches | Louisiana | 22069 | 4040 | 86 |
1272205 | 1272205 | 2021-04-30 | Orleans | Louisiana | 22071 | 29878 | 792 |
1272206 | 1272206 | 2021-04-30 | Ouachita | Louisiana | 22073 | 18301 | 448 |
1272207 | 1272207 | 2021-04-30 | Plaquemines | Louisiana | 22075 | 2517 | 26 |
1272208 | 1272208 | 2021-04-30 | Pointe Coupee | Louisiana | 22077 | 2612 | 73 |
1272209 | 1272209 | 2021-04-30 | Rapides | Louisiana | 22079 | 11974 | 314 |
1272210 | 1272210 | 2021-04-30 | Red River | Louisiana | 22081 | 874 | 38 |
1272211 | 1272211 | 2021-04-30 | Richland | Louisiana | 22083 | 2416 | 54 |
1272212 | 1272212 | 2021-04-30 | Sabine | Louisiana | 22085 | 2925 | 60 |
1272213 | 1272213 | 2021-04-30 | St. Bernard | Louisiana | 22087 | 4003 | 50 |
1272214 | 1272214 | 2021-04-30 | St. Charles | Louisiana | 22089 | 5373 | 93 |
1272215 | 1272215 | 2021-04-30 | St. Helena | Louisiana | 22091 | 922 | 10 |
1272216 | 1272216 | 2021-04-30 | St. James | Louisiana | 22093 | 1955 | 50 |
1272217 | 1272217 | 2021-04-30 | St. John the Baptist | Louisiana | 22095 | 3696 | 137 |
1272218 | 1272218 | 2021-04-30 | St. Landry | Louisiana | 22097 | 8813 | 253 |
1272219 | 1272219 | 2021-04-30 | St. Martin | Louisiana | 22099 | 5208 | 116 |
1272220 | 1272220 | 2021-04-30 | St. Mary | Louisiana | 22101 | 4665 | 134 |
1272221 | 1272221 | 2021-04-30 | St. Tammany | Louisiana | 22103 | 25568 | 520 |
1272222 | 1272222 | 2021-04-30 | Tangipahoa | Louisiana | 22105 | 12610 | 292 |
1272223 | 1272223 | 2021-04-30 | Tensas | Louisiana | 22107 | 360 | 8 |
1272224 | 1272224 | 2021-04-30 | Terrebonne | Louisiana | 22109 | 10100 | 220 |
1272225 | 1272225 | 2021-04-30 | Union | Louisiana | 22111 | 2379 | 77 |
1272226 | 1272226 | 2021-04-30 | Unknown | Louisiana | 411 | 0 | |
1272227 | 1272227 | 2021-04-30 | Vermilion | Louisiana | 22113 | 5324 | 119 |
1272228 | 1272228 | 2021-04-30 | Vernon | Louisiana | 22115 | 3058 | 101 |
1272229 | 1272229 | 2021-04-30 | Washington | Louisiana | 22117 | 4357 | 129 |
1272230 | 1272230 | 2021-04-30 | Webster | Louisiana | 22119 | 4086 | 112 |
1272231 | 1272231 | 2021-04-30 | West Baton Rouge | Louisiana | 22121 | 2841 | 59 |
1272232 | 1272232 | 2021-04-30 | West Carroll | Louisiana | 22123 | 1173 | 41 |
1272233 | 1272233 | 2021-04-30 | West Feliciana | Louisiana | 22125 | 1153 | 34 |
1272234 | 1272234 | 2021-04-30 | Winn | Louisiana | 22127 | 1535 | 43 |
1268923 | 1268923 | 2021-04-29 | Acadia | Louisiana | 22001 | 6470 | 192 |
1268924 | 1268924 | 2021-04-29 | Allen | Louisiana | 22003 | 3170 | 91 |
1268925 | 1268925 | 2021-04-29 | Ascension | Louisiana | 22005 | 12021 | 164 |
1268926 | 1268926 | 2021-04-29 | Assumption | Louisiana | 22007 | 2170 | 36 |
1268927 | 1268927 | 2021-04-29 | Avoyelles | Louisiana | 22009 | 4175 | 123 |
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);