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-12-12 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
2006228 2006228 2021-12-12 Acadia Louisiana 22001 10726 251
2006229 2006229 2021-12-12 Allen Louisiana 22003 4820 118
2006230 2006230 2021-12-12 Ascension Louisiana 22005 22196 249
2006231 2006231 2021-12-12 Assumption Louisiana 22007 3705 57
2006232 2006232 2021-12-12 Avoyelles Louisiana 22009 7414 181
2006233 2006233 2021-12-12 Beauregard Louisiana 22011 6196 127
2006234 2006234 2021-12-12 Bienville Louisiana 22013 2531 99
2006235 2006235 2021-12-12 Bossier Louisiana 22015 22278 410
2006236 2006236 2021-12-12 Caddo Louisiana 22017 40397 982
2006237 2006237 2021-12-12 Calcasieu Louisiana 22019 35137 633
2006238 2006238 2021-12-12 Caldwell Louisiana 22021 2324 41
2006239 2006239 2021-12-12 Cameron Louisiana 22023 867 8
2006240 2006240 2021-12-12 Catahoula Louisiana 22025 1819 48
2006241 2006241 2021-12-12 Claiborne Louisiana 22027 2058 66
2006242 2006242 2021-12-12 Concordia Louisiana 22029 3293 80
2006243 2006243 2021-12-12 De Soto Louisiana 22031 4848 113
2006244 2006244 2021-12-12 East Baton Rouge Louisiana 22033 64936 1174
2006245 2006245 2021-12-12 East Carroll Louisiana 22035 1719 32
2006246 2006246 2021-12-12 East Feliciana Louisiana 22037 4554 145
2006247 2006247 2021-12-12 Evangeline Louisiana 22039 5949 143
2006248 2006248 2021-12-12 Franklin Louisiana 22041 4834 141
2006249 2006249 2021-12-12 Grant Louisiana 22043 3923 78
2006250 2006250 2021-12-12 Iberia Louisiana 22045 12707 228
2006251 2006251 2021-12-12 Iberville Louisiana 22047 5911 129
2006252 2006252 2021-12-12 Jackson Louisiana 22049 2826 64
2006253 2006253 2021-12-12 Jefferson Louisiana 22051 70741 1183
2006254 2006254 2021-12-12 Jefferson Davis Louisiana 22053 4821 130
2006255 2006255 2021-12-12 LaSalle Louisiana 22059 2795 46
2006256 2006256 2021-12-12 Lafayette Louisiana 22055 39840 410
2006257 2006257 2021-12-12 Lafourche Louisiana 22057 18294 321
2006258 2006258 2021-12-12 Lincoln Louisiana 22061 7320 117
2006259 2006259 2021-12-12 Livingston Louisiana 22063 24935 385
2006260 2006260 2021-12-12 Madison Louisiana 22065 2293 55
2006261 2006261 2021-12-12 Morehouse Louisiana 22067 4601 116
2006262 2006262 2021-12-12 Natchitoches Louisiana 22069 6783 137
2006263 2006263 2021-12-12 Orleans Louisiana 22071 47851 1006
2006264 2006264 2021-12-12 Ouachita Louisiana 22073 32470 604
2006265 2006265 2021-12-12 Plaquemines Louisiana 22075 4065 40
2006266 2006266 2021-12-12 Pointe Coupee Louisiana 22077 4012 85
2006267 2006267 2021-12-12 Rapides Louisiana 22079 21670 478
2006268 2006268 2021-12-12 Red River Louisiana 22081 1425 49
2006269 2006269 2021-12-12 Richland Louisiana 22083 4422 80
2006270 2006270 2021-12-12 Sabine Louisiana 22085 4584 96
2006271 2006271 2021-12-12 St. Bernard Louisiana 22087 7074 98
2006272 2006272 2021-12-12 St. Charles Louisiana 22089 9045 128
2006273 2006273 2021-12-12 St. Helena Louisiana 22091 1268 19
2006274 2006274 2021-12-12 St. James Louisiana 22093 3558 70
2006275 2006275 2021-12-12 St. John the Baptist Louisiana 22095 6418 173
2006276 2006276 2021-12-12 St. Landry Louisiana 22097 14469 351
2006277 2006277 2021-12-12 St. Martin Louisiana 22099 8565 163
2006278 2006278 2021-12-12 St. Mary Louisiana 22101 8629 227
2006279 2006279 2021-12-12 St. Tammany Louisiana 22103 44620 738
2006280 2006280 2021-12-12 Tangipahoa Louisiana 22105 23146 530
2006281 2006281 2021-12-12 Tensas Louisiana 22107 564 10
2006282 2006282 2021-12-12 Terrebonne Louisiana 22109 19923 358
2006283 2006283 2021-12-12 Union Louisiana 22111 4245 112
2006284 2006284 2021-12-12 Unknown Louisiana   587 0
2006285 2006285 2021-12-12 Vermilion Louisiana 22113 10429 195
2006286 2006286 2021-12-12 Vernon Louisiana 22115 6531 167
2006287 2006287 2021-12-12 Washington Louisiana 22117 8294 221
2006288 2006288 2021-12-12 Webster Louisiana 22119 6854 152
2006289 2006289 2021-12-12 West Baton Rouge Louisiana 22121 4463 79
2006290 2006290 2021-12-12 West Carroll Louisiana 22123 2185 52
2006291 2006291 2021-12-12 West Feliciana Louisiana 22125 1515 41
2006292 2006292 2021-12-12 Winn Louisiana 22127 2663 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);