ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

65 rows where "date" is on date 2021-10-21 and state = "Louisiana" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

state 1

  • Louisiana · 65 ✖
Link rowid date ▲ county state fips cases deaths
1837230 1837230 2021-10-21 Acadia Louisiana 22001 10417 249
1837231 1837231 2021-10-21 Allen Louisiana 22003 4697 113
1837232 1837232 2021-10-21 Ascension Louisiana 22005 21700 239
1837233 1837233 2021-10-21 Assumption Louisiana 22007 3640 57
1837234 1837234 2021-10-21 Avoyelles Louisiana 22009 7065 177
1837235 1837235 2021-10-21 Beauregard Louisiana 22011 6056 122
1837236 1837236 2021-10-21 Bienville Louisiana 22013 2481 96
1837237 1837237 2021-10-21 Bossier Louisiana 22015 21613 400
1837238 1837238 2021-10-21 Caddo Louisiana 22017 39227 955
1837239 1837239 2021-10-21 Calcasieu Louisiana 22019 34290 610
1837240 1837240 2021-10-21 Caldwell Louisiana 22021 2218 38
1837241 1837241 2021-10-21 Cameron Louisiana 22023 860 9
1837242 1837242 2021-10-21 Catahoula Louisiana 22025 1775 48
1837243 1837243 2021-10-21 Claiborne Louisiana 22027 2002 63
1837244 1837244 2021-10-21 Concordia Louisiana 22029 3196 78
1837245 1837245 2021-10-21 De Soto Louisiana 22031 4716 107
1837246 1837246 2021-10-21 East Baton Rouge Louisiana 22033 63606 1156
1837247 1837247 2021-10-21 East Carroll Louisiana 22035 1589 30
1837248 1837248 2021-10-21 East Feliciana Louisiana 22037 4475 144
1837249 1837249 2021-10-21 Evangeline Louisiana 22039 5792 139
1837250 1837250 2021-10-21 Franklin Louisiana 22041 4669 137
1837251 1837251 2021-10-21 Grant Louisiana 22043 3810 77
1837252 1837252 2021-10-21 Iberia Louisiana 22045 12395 224
1837253 1837253 2021-10-21 Iberville Louisiana 22047 5796 124
1837254 1837254 2021-10-21 Jackson Louisiana 22049 2753 63
1837255 1837255 2021-10-21 Jefferson Louisiana 22051 69295 1156
1837256 1837256 2021-10-21 Jefferson Davis Louisiana 22053 4695 126
1837257 1837257 2021-10-21 LaSalle Louisiana 22059 2714 46
1837258 1837258 2021-10-21 Lafayette Louisiana 22055 38623 400
1837259 1837259 2021-10-21 Lafourche Louisiana 22057 17810 309
1837260 1837260 2021-10-21 Lincoln Louisiana 22061 7030 115
1837261 1837261 2021-10-21 Livingston Louisiana 22063 24412 372
1837262 1837262 2021-10-21 Madison Louisiana 22065 2229 52
1837263 1837263 2021-10-21 Morehouse Louisiana 22067 4447 115
1837264 1837264 2021-10-21 Natchitoches Louisiana 22069 6550 133
1837265 1837265 2021-10-21 Orleans Louisiana 22071 46574 992
1837266 1837266 2021-10-21 Ouachita Louisiana 22073 31374 582
1837267 1837267 2021-10-21 Plaquemines Louisiana 22075 3809 40
1837268 1837268 2021-10-21 Pointe Coupee Louisiana 22077 3846 83
1837269 1837269 2021-10-21 Rapides Louisiana 22079 21110 460
1837270 1837270 2021-10-21 Red River Louisiana 22081 1400 48
1837271 1837271 2021-10-21 Richland Louisiana 22083 4290 78
1837272 1837272 2021-10-21 Sabine Louisiana 22085 4489 88
1837273 1837273 2021-10-21 St. Bernard Louisiana 22087 6872 98
1837274 1837274 2021-10-21 St. Charles Louisiana 22089 8845 127
1837275 1837275 2021-10-21 St. Helena Louisiana 22091 1262 18
1837276 1837276 2021-10-21 St. James Louisiana 22093 3484 70
1837277 1837277 2021-10-21 St. John the Baptist Louisiana 22095 6285 170
1837278 1837278 2021-10-21 St. Landry Louisiana 22097 13983 344
1837279 1837279 2021-10-21 St. Martin Louisiana 22099 8365 160
1837280 1837280 2021-10-21 St. Mary Louisiana 22101 8516 221
1837281 1837281 2021-10-21 St. Tammany Louisiana 22103 43370 715
1837282 1837282 2021-10-21 Tangipahoa Louisiana 22105 22674 502
1837283 1837283 2021-10-21 Tensas Louisiana 22107 519 8
1837284 1837284 2021-10-21 Terrebonne Louisiana 22109 19308 336
1837285 1837285 2021-10-21 Union Louisiana 22111 3981 103
1837286 1837286 2021-10-21 Unknown Louisiana   576 0
1837287 1837287 2021-10-21 Vermilion Louisiana 22113 10148 187
1837288 1837288 2021-10-21 Vernon Louisiana 22115 6261 160
1837289 1837289 2021-10-21 Washington Louisiana 22117 7929 211
1837290 1837290 2021-10-21 Webster Louisiana 22119 6580 147
1837291 1837291 2021-10-21 West Baton Rouge Louisiana 22121 4366 74
1837292 1837292 2021-10-21 West Carroll Louisiana 22123 1968 47
1837293 1837293 2021-10-21 West Feliciana Louisiana 22125 1509 40
1837294 1837294 2021-10-21 Winn Louisiana 22127 2614 58

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);