ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where date = "2021-11-09" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|
1898968 | 1898968 | 2021-11-09 | Acadia | Louisiana | 22001 | 10533 | 249 |
1898969 | 1898969 | 2021-11-09 | Allen | Louisiana | 22003 | 4740 | 115 |
1898970 | 1898970 | 2021-11-09 | Ascension | Louisiana | 22005 | 21881 | 243 |
1898971 | 1898971 | 2021-11-09 | Assumption | Louisiana | 22007 | 3670 | 57 |
1898972 | 1898972 | 2021-11-09 | Avoyelles | Louisiana | 22009 | 7343 | 181 |
1898973 | 1898973 | 2021-11-09 | Beauregard | Louisiana | 22011 | 6130 | 124 |
1898974 | 1898974 | 2021-11-09 | Bienville | Louisiana | 22013 | 2505 | 98 |
1898975 | 1898975 | 2021-11-09 | Bossier | Louisiana | 22015 | 21833 | 406 |
1898976 | 1898976 | 2021-11-09 | Caddo | Louisiana | 22017 | 39632 | 965 |
1898977 | 1898977 | 2021-11-09 | Calcasieu | Louisiana | 22019 | 34620 | 618 |
1898978 | 1898978 | 2021-11-09 | Caldwell | Louisiana | 22021 | 2250 | 39 |
1898979 | 1898979 | 2021-11-09 | Cameron | Louisiana | 22023 | 863 | 9 |
1898980 | 1898980 | 2021-11-09 | Catahoula | Louisiana | 22025 | 1781 | 48 |
1898981 | 1898981 | 2021-11-09 | Claiborne | Louisiana | 22027 | 2019 | 65 |
1898982 | 1898982 | 2021-11-09 | Concordia | Louisiana | 22029 | 3236 | 79 |
1898983 | 1898983 | 2021-11-09 | De Soto | Louisiana | 22031 | 4788 | 112 |
1898984 | 1898984 | 2021-11-09 | East Baton Rouge | Louisiana | 22033 | 64109 | 1166 |
1898985 | 1898985 | 2021-11-09 | East Carroll | Louisiana | 22035 | 1609 | 31 |
1898986 | 1898986 | 2021-11-09 | East Feliciana | Louisiana | 22037 | 4500 | 145 |
1898987 | 1898987 | 2021-11-09 | Evangeline | Louisiana | 22039 | 5864 | 141 |
1898988 | 1898988 | 2021-11-09 | Franklin | Louisiana | 22041 | 4709 | 139 |
1898989 | 1898989 | 2021-11-09 | Grant | Louisiana | 22043 | 3841 | 78 |
1898990 | 1898990 | 2021-11-09 | Iberia | Louisiana | 22045 | 12533 | 226 |
1898991 | 1898991 | 2021-11-09 | Iberville | Louisiana | 22047 | 5847 | 125 |
1898992 | 1898992 | 2021-11-09 | Jackson | Louisiana | 22049 | 2784 | 64 |
1898993 | 1898993 | 2021-11-09 | Jefferson | Louisiana | 22051 | 69897 | 1175 |
1898994 | 1898994 | 2021-11-09 | Jefferson Davis | Louisiana | 22053 | 4753 | 127 |
1898995 | 1898995 | 2021-11-09 | LaSalle | Louisiana | 22059 | 2739 | 46 |
1898996 | 1898996 | 2021-11-09 | Lafayette | Louisiana | 22055 | 39225 | 404 |
1898997 | 1898997 | 2021-11-09 | Lafourche | Louisiana | 22057 | 18024 | 315 |
1898998 | 1898998 | 2021-11-09 | Lincoln | Louisiana | 22061 | 7112 | 115 |
1898999 | 1898999 | 2021-11-09 | Livingston | Louisiana | 22063 | 24613 | 380 |
1899000 | 1899000 | 2021-11-09 | Madison | Louisiana | 22065 | 2249 | 52 |
1899001 | 1899001 | 2021-11-09 | Morehouse | Louisiana | 22067 | 4484 | 116 |
1899002 | 1899002 | 2021-11-09 | Natchitoches | Louisiana | 22069 | 6676 | 135 |
1899003 | 1899003 | 2021-11-09 | Orleans | Louisiana | 22071 | 47077 | 995 |
1899004 | 1899004 | 2021-11-09 | Ouachita | Louisiana | 22073 | 31695 | 590 |
1899005 | 1899005 | 2021-11-09 | Plaquemines | Louisiana | 22075 | 4009 | 40 |
1899006 | 1899006 | 2021-11-09 | Pointe Coupee | Louisiana | 22077 | 3932 | 83 |
1899007 | 1899007 | 2021-11-09 | Rapides | Louisiana | 22079 | 21342 | 467 |
1899008 | 1899008 | 2021-11-09 | Red River | Louisiana | 22081 | 1406 | 49 |
1899009 | 1899009 | 2021-11-09 | Richland | Louisiana | 22083 | 4321 | 79 |
1899010 | 1899010 | 2021-11-09 | Sabine | Louisiana | 22085 | 4527 | 93 |
1899011 | 1899011 | 2021-11-09 | St. Bernard | Louisiana | 22087 | 6933 | 98 |
1899012 | 1899012 | 2021-11-09 | St. Charles | Louisiana | 22089 | 8910 | 127 |
1899013 | 1899013 | 2021-11-09 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1899014 | 1899014 | 2021-11-09 | St. James | Louisiana | 22093 | 3537 | 70 |
1899015 | 1899015 | 2021-11-09 | St. John the Baptist | Louisiana | 22095 | 6332 | 171 |
1899016 | 1899016 | 2021-11-09 | St. Landry | Louisiana | 22097 | 14227 | 347 |
1899017 | 1899017 | 2021-11-09 | St. Martin | Louisiana | 22099 | 8442 | 161 |
1899018 | 1899018 | 2021-11-09 | St. Mary | Louisiana | 22101 | 8552 | 221 |
1899019 | 1899019 | 2021-11-09 | St. Tammany | Louisiana | 22103 | 43840 | 729 |
1899020 | 1899020 | 2021-11-09 | Tangipahoa | Louisiana | 22105 | 22845 | 517 |
1899021 | 1899021 | 2021-11-09 | Tensas | Louisiana | 22107 | 532 | 9 |
1899022 | 1899022 | 2021-11-09 | Terrebonne | Louisiana | 22109 | 19496 | 350 |
1899023 | 1899023 | 2021-11-09 | Union | Louisiana | 22111 | 4045 | 105 |
1899024 | 1899024 | 2021-11-09 | Unknown | Louisiana | 581 | 0 | |
1899025 | 1899025 | 2021-11-09 | Vermilion | Louisiana | 22113 | 10281 | 190 |
1899026 | 1899026 | 2021-11-09 | Vernon | Louisiana | 22115 | 6378 | 162 |
1899027 | 1899027 | 2021-11-09 | Washington | Louisiana | 22117 | 8003 | 217 |
1899028 | 1899028 | 2021-11-09 | Webster | Louisiana | 22119 | 6658 | 148 |
1899029 | 1899029 | 2021-11-09 | West Baton Rouge | Louisiana | 22121 | 4403 | 77 |
1899030 | 1899030 | 2021-11-09 | West Carroll | Louisiana | 22123 | 2024 | 50 |
1899031 | 1899031 | 2021-11-09 | West Feliciana | Louisiana | 22125 | 1512 | 40 |
1899032 | 1899032 | 2021-11-09 | Winn | Louisiana | 22127 | 2637 | 58 |
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);