ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where date = "2022-03-24" 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 |
---|---|---|---|---|---|---|---|
2337926 | 2337926 | 2022-03-24 | Acadia | Louisiana | 22001 | 15838 | 290 |
2337927 | 2337927 | 2022-03-24 | Allen | Louisiana | 22003 | 7861 | 137 |
2337928 | 2337928 | 2022-03-24 | Ascension | Louisiana | 22005 | 34780 | 291 |
2337929 | 2337929 | 2022-03-24 | Assumption | Louisiana | 22007 | 5552 | 69 |
2337930 | 2337930 | 2022-03-24 | Avoyelles | Louisiana | 22009 | 11568 | 206 |
2337931 | 2337931 | 2022-03-24 | Beauregard | Louisiana | 22011 | 9244 | 142 |
2337932 | 2337932 | 2022-03-24 | Bienville | Louisiana | 22013 | 3971 | 111 |
2337933 | 2337933 | 2022-03-24 | Bossier | Louisiana | 22015 | 37450 | 487 |
2337934 | 2337934 | 2022-03-24 | Caddo | Louisiana | 22017 | 67158 | 1135 |
2337935 | 2337935 | 2022-03-24 | Calcasieu | Louisiana | 22019 | 54584 | 701 |
2337936 | 2337936 | 2022-03-24 | Caldwell | Louisiana | 22021 | 3365 | 54 |
2337937 | 2337937 | 2022-03-24 | Cameron | Louisiana | 22023 | 1198 | 8 |
2337938 | 2337938 | 2022-03-24 | Catahoula | Louisiana | 22025 | 2692 | 55 |
2337939 | 2337939 | 2022-03-24 | Claiborne | Louisiana | 22027 | 3275 | 74 |
2337940 | 2337940 | 2022-03-24 | Concordia | Louisiana | 22029 | 5083 | 88 |
2337941 | 2337941 | 2022-03-24 | De Soto | Louisiana | 22031 | 7316 | 135 |
2337942 | 2337942 | 2022-03-24 | East Baton Rouge | Louisiana | 22033 | 110602 | 1333 |
2337943 | 2337943 | 2022-03-24 | East Carroll | Louisiana | 22035 | 2531 | 38 |
2337944 | 2337944 | 2022-03-24 | East Feliciana | Louisiana | 22037 | 7295 | 170 |
2337945 | 2337945 | 2022-03-24 | Evangeline | Louisiana | 22039 | 8376 | 156 |
2337946 | 2337946 | 2022-03-24 | Franklin | Louisiana | 22041 | 7334 | 176 |
2337947 | 2337947 | 2022-03-24 | Grant | Louisiana | 22043 | 5850 | 93 |
2337948 | 2337948 | 2022-03-24 | Iberia | Louisiana | 22045 | 19040 | 262 |
2337949 | 2337949 | 2022-03-24 | Iberville | Louisiana | 22047 | 8975 | 150 |
2337950 | 2337950 | 2022-03-24 | Jackson | Louisiana | 22049 | 4371 | 74 |
2337951 | 2337951 | 2022-03-24 | Jefferson | Louisiana | 22051 | 113368 | 1326 |
2337952 | 2337952 | 2022-03-24 | Jefferson Davis | Louisiana | 22053 | 6931 | 156 |
2337953 | 2337953 | 2022-03-24 | LaSalle | Louisiana | 22059 | 4215 | 56 |
2337954 | 2337954 | 2022-03-24 | Lafayette | Louisiana | 22055 | 62222 | 493 |
2337955 | 2337955 | 2022-03-24 | Lafourche | Louisiana | 22057 | 27700 | 366 |
2337956 | 2337956 | 2022-03-24 | Lincoln | Louisiana | 22061 | 12198 | 143 |
2337957 | 2337957 | 2022-03-24 | Livingston | Louisiana | 22063 | 37065 | 461 |
2337958 | 2337958 | 2022-03-24 | Madison | Louisiana | 22065 | 3255 | 58 |
2337959 | 2337959 | 2022-03-24 | Morehouse | Louisiana | 22067 | 6846 | 133 |
2337960 | 2337960 | 2022-03-24 | Natchitoches | Louisiana | 22069 | 10101 | 165 |
2337961 | 2337961 | 2022-03-24 | Orleans | Louisiana | 22071 | 87238 | 1105 |
2337962 | 2337962 | 2022-03-24 | Ouachita | Louisiana | 22073 | 50481 | 731 |
2337963 | 2337963 | 2022-03-24 | Plaquemines | Louisiana | 22075 | 6406 | 45 |
2337964 | 2337964 | 2022-03-24 | Pointe Coupee | Louisiana | 22077 | 6264 | 92 |
2337965 | 2337965 | 2022-03-24 | Rapides | Louisiana | 22079 | 32696 | 572 |
2337966 | 2337966 | 2022-03-24 | Red River | Louisiana | 22081 | 2105 | 52 |
2337967 | 2337967 | 2022-03-24 | Richland | Louisiana | 22083 | 6700 | 95 |
2337968 | 2337968 | 2022-03-24 | Sabine | Louisiana | 22085 | 6326 | 109 |
2337969 | 2337969 | 2022-03-24 | St. Bernard | Louisiana | 22087 | 11195 | 109 |
2337970 | 2337970 | 2022-03-24 | St. Charles | Louisiana | 22089 | 13783 | 143 |
2337971 | 2337971 | 2022-03-24 | St. Helena | Louisiana | 22091 | 1911 | 23 |
2337972 | 2337972 | 2022-03-24 | St. James | Louisiana | 22093 | 5774 | 76 |
2337973 | 2337973 | 2022-03-24 | St. John the Baptist | Louisiana | 22095 | 10490 | 184 |
2337974 | 2337974 | 2022-03-24 | St. Landry | Louisiana | 22097 | 22153 | 412 |
2337975 | 2337975 | 2022-03-24 | St. Martin | Louisiana | 22099 | 12925 | 185 |
2337976 | 2337976 | 2022-03-24 | St. Mary | Louisiana | 22101 | 12458 | 260 |
2337977 | 2337977 | 2022-03-24 | St. Tammany | Louisiana | 22103 | 71938 | 842 |
2337978 | 2337978 | 2022-03-24 | Tangipahoa | Louisiana | 22105 | 34620 | 592 |
2337979 | 2337979 | 2022-03-24 | Tensas | Louisiana | 22107 | 985 | 11 |
2337980 | 2337980 | 2022-03-24 | Terrebonne | Louisiana | 22109 | 30808 | 408 |
2337981 | 2337981 | 2022-03-24 | Union | Louisiana | 22111 | 6907 | 130 |
2337982 | 2337982 | 2022-03-24 | Unknown | Louisiana | 978 | 0 | |
2337983 | 2337983 | 2022-03-24 | Vermilion | Louisiana | 22113 | 15235 | 223 |
2337984 | 2337984 | 2022-03-24 | Vernon | Louisiana | 22115 | 9917 | 188 |
2337985 | 2337985 | 2022-03-24 | Washington | Louisiana | 22117 | 12926 | 246 |
2337986 | 2337986 | 2022-03-24 | Webster | Louisiana | 22119 | 11084 | 182 |
2337987 | 2337987 | 2022-03-24 | West Baton Rouge | Louisiana | 22121 | 7287 | 87 |
2337988 | 2337988 | 2022-03-24 | West Carroll | Louisiana | 22123 | 3619 | 65 |
2337989 | 2337989 | 2022-03-24 | West Feliciana | Louisiana | 22125 | 2830 | 44 |
2337990 | 2337990 | 2022-03-24 | Winn | Louisiana | 22127 | 4427 | 62 |
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);