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 2020-11-06 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 |
---|---|---|---|---|---|---|---|
704131 | 704131 | 2020-11-06 | Acadia | Louisiana | 22001 | 3330 | 106 |
704132 | 704132 | 2020-11-06 | Allen | Louisiana | 22003 | 1877 | 64 |
704133 | 704133 | 2020-11-06 | Ascension | Louisiana | 22005 | 4405 | 100 |
704134 | 704134 | 2020-11-06 | Assumption | Louisiana | 22007 | 828 | 24 |
704135 | 704135 | 2020-11-06 | Avoyelles | Louisiana | 22009 | 1788 | 63 |
704136 | 704136 | 2020-11-06 | Beauregard | Louisiana | 22011 | 1107 | 41 |
704137 | 704137 | 2020-11-06 | Bienville | Louisiana | 22013 | 642 | 35 |
704138 | 704138 | 2020-11-06 | Bossier | Louisiana | 22015 | 4572 | 125 |
704139 | 704139 | 2020-11-06 | Caddo | Louisiana | 22017 | 10679 | 406 |
704140 | 704140 | 2020-11-06 | Calcasieu | Louisiana | 22019 | 8643 | 231 |
704141 | 704141 | 2020-11-06 | Caldwell | Louisiana | 22021 | 400 | 3 |
704142 | 704142 | 2020-11-06 | Cameron | Louisiana | 22023 | 253 | 3 |
704143 | 704143 | 2020-11-06 | Catahoula | Louisiana | 22025 | 465 | 15 |
704144 | 704144 | 2020-11-06 | Claiborne | Louisiana | 22027 | 621 | 26 |
704145 | 704145 | 2020-11-06 | Concordia | Louisiana | 22029 | 637 | 16 |
704146 | 704146 | 2020-11-06 | De Soto | Louisiana | 22031 | 1071 | 35 |
704147 | 704147 | 2020-11-06 | East Baton Rouge | Louisiana | 22033 | 16626 | 461 |
704148 | 704148 | 2020-11-06 | East Carroll | Louisiana | 22035 | 597 | 6 |
704149 | 704149 | 2020-11-06 | East Feliciana | Louisiana | 22037 | 1813 | 79 |
704150 | 704150 | 2020-11-06 | Evangeline | Louisiana | 22039 | 1448 | 40 |
704151 | 704151 | 2020-11-06 | Franklin | Louisiana | 22041 | 1393 | 50 |
704152 | 704152 | 2020-11-06 | Grant | Louisiana | 22043 | 553 | 30 |
704153 | 704153 | 2020-11-06 | Iberia | Louisiana | 22045 | 3116 | 99 |
704154 | 704154 | 2020-11-06 | Iberville | Louisiana | 22047 | 1527 | 61 |
704155 | 704155 | 2020-11-06 | Jackson | Louisiana | 22049 | 903 | 24 |
704156 | 704156 | 2020-11-06 | Jefferson | Louisiana | 22051 | 19077 | 590 |
704157 | 704157 | 2020-11-06 | Jefferson Davis | Louisiana | 22053 | 1384 | 45 |
704158 | 704158 | 2020-11-06 | LaSalle | Louisiana | 22059 | 539 | 11 |
704159 | 704159 | 2020-11-06 | Lafayette | Louisiana | 22055 | 9671 | 140 |
704160 | 704160 | 2020-11-06 | Lafourche | Louisiana | 22057 | 3954 | 131 |
704161 | 704161 | 2020-11-06 | Lincoln | Louisiana | 22061 | 1745 | 52 |
704162 | 704162 | 2020-11-06 | Livingston | Louisiana | 22063 | 4357 | 82 |
704163 | 704163 | 2020-11-06 | Madison | Louisiana | 22065 | 907 | 10 |
704164 | 704164 | 2020-11-06 | Morehouse | Louisiana | 22067 | 916 | 29 |
704165 | 704165 | 2020-11-06 | Natchitoches | Louisiana | 22069 | 1572 | 34 |
704166 | 704166 | 2020-11-06 | Orleans | Louisiana | 22071 | 13719 | 600 |
704167 | 704167 | 2020-11-06 | Ouachita | Louisiana | 22073 | 7297 | 173 |
704168 | 704168 | 2020-11-06 | Plaquemines | Louisiana | 22075 | 913 | 19 |
704169 | 704169 | 2020-11-06 | Pointe Coupee | Louisiana | 22077 | 1155 | 42 |
704170 | 704170 | 2020-11-06 | Rapides | Louisiana | 22079 | 4873 | 163 |
704171 | 704171 | 2020-11-06 | Red River | Louisiana | 22081 | 476 | 25 |
704172 | 704172 | 2020-11-06 | Richland | Louisiana | 22083 | 947 | 20 |
704173 | 704173 | 2020-11-06 | Sabine | Louisiana | 22085 | 1053 | 16 |
704174 | 704174 | 2020-11-06 | St. Bernard | Louisiana | 22087 | 1572 | 32 |
704175 | 704175 | 2020-11-06 | St. Charles | Louisiana | 22089 | 1993 | 64 |
704176 | 704176 | 2020-11-06 | St. Helena | Louisiana | 22091 | 446 | 4 |
704177 | 704177 | 2020-11-06 | St. James | Louisiana | 22093 | 854 | 40 |
704178 | 704178 | 2020-11-06 | St. John the Baptist | Louisiana | 22095 | 1695 | 108 |
704179 | 704179 | 2020-11-06 | St. Landry | Louisiana | 22097 | 3798 | 138 |
704180 | 704180 | 2020-11-06 | St. Martin | Louisiana | 22099 | 2295 | 64 |
704181 | 704181 | 2020-11-06 | St. Mary | Louisiana | 22101 | 2054 | 87 |
704182 | 704182 | 2020-11-06 | St. Tammany | Louisiana | 22103 | 7940 | 274 |
704183 | 704183 | 2020-11-06 | Tangipahoa | Louisiana | 22105 | 5116 | 127 |
704184 | 704184 | 2020-11-06 | Tensas | Louisiana | 22107 | 188 | 3 |
704185 | 704185 | 2020-11-06 | Terrebonne | Louisiana | 22109 | 3922 | 126 |
704186 | 704186 | 2020-11-06 | Union | Louisiana | 22111 | 1156 | 53 |
704187 | 704187 | 2020-11-06 | Unknown | Louisiana | 5328 | 229 | |
704188 | 704188 | 2020-11-06 | Vermilion | Louisiana | 22113 | 2162 | 70 |
704189 | 704189 | 2020-11-06 | Vernon | Louisiana | 22115 | 1145 | 56 |
704190 | 704190 | 2020-11-06 | Washington | Louisiana | 22117 | 1778 | 72 |
704191 | 704191 | 2020-11-06 | Webster | Louisiana | 22119 | 1546 | 42 |
704192 | 704192 | 2020-11-06 | West Baton Rouge | Louisiana | 22121 | 1012 | 42 |
704193 | 704193 | 2020-11-06 | West Carroll | Louisiana | 22123 | 391 | 14 |
704194 | 704194 | 2020-11-06 | West Feliciana | Louisiana | 22125 | 760 | 25 |
704195 | 704195 | 2020-11-06 | Winn | Louisiana | 22127 | 715 | 21 |
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);