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 = "2021-09-15" and state = "Louisiana" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Louisiana · 65 ✖
Link rowid date ▲ county state fips cases deaths
1720262 1720262 2021-09-15 Acadia Louisiana 22001 10014 232
1720263 1720263 2021-09-15 Allen Louisiana 22003 4442 103
1720264 1720264 2021-09-15 Ascension Louisiana 22005 20996 220
1720265 1720265 2021-09-15 Assumption Louisiana 22007 3493 54
1720266 1720266 2021-09-15 Avoyelles Louisiana 22009 6794 163
1720267 1720267 2021-09-15 Beauregard Louisiana 22011 5649 105
1720268 1720268 2021-09-15 Bienville Louisiana 22013 2344 87
1720269 1720269 2021-09-15 Bossier Louisiana 22015 20481 366
1720270 1720270 2021-09-15 Caddo Louisiana 22017 37203 885
1720271 1720271 2021-09-15 Calcasieu Louisiana 22019 32554 551
1720272 1720272 2021-09-15 Caldwell Louisiana 22021 1977 36
1720273 1720273 2021-09-15 Cameron Louisiana 22023 831 8
1720274 1720274 2021-09-15 Catahoula Louisiana 22025 1675 45
1720275 1720275 2021-09-15 Claiborne Louisiana 22027 1932 59
1720276 1720276 2021-09-15 Concordia Louisiana 22029 2999 73
1720277 1720277 2021-09-15 De Soto Louisiana 22031 4493 105
1720278 1720278 2021-09-15 East Baton Rouge Louisiana 22033 61375 1086
1720279 1720279 2021-09-15 East Carroll Louisiana 22035 1475 30
1720280 1720280 2021-09-15 East Feliciana Louisiana 22037 4371 136
1720281 1720281 2021-09-15 Evangeline Louisiana 22039 5479 114
1720282 1720282 2021-09-15 Franklin Louisiana 22041 4064 132
1720283 1720283 2021-09-15 Grant Louisiana 22043 3622 72
1720284 1720284 2021-09-15 Iberia Louisiana 22045 12018 212
1720285 1720285 2021-09-15 Iberville Louisiana 22047 5650 120
1720286 1720286 2021-09-15 Jackson Louisiana 22049 2607 59
1720287 1720287 2021-09-15 Jefferson Louisiana 22051 67305 1084
1720288 1720288 2021-09-15 Jefferson Davis Louisiana 22053 4468 114
1720289 1720289 2021-09-15 LaSalle Louisiana 22059 2543 43
1720290 1720290 2021-09-15 Lafayette Louisiana 22055 37065 378
1720291 1720291 2021-09-15 Lafourche Louisiana 22057 17098 269
1720292 1720292 2021-09-15 Lincoln Louisiana 22061 6540 106
1720293 1720293 2021-09-15 Livingston Louisiana 22063 23540 341
1720294 1720294 2021-09-15 Madison Louisiana 22065 2094 50
1720295 1720295 2021-09-15 Morehouse Louisiana 22067 4255 103
1720296 1720296 2021-09-15 Natchitoches Louisiana 22069 6067 118
1720297 1720297 2021-09-15 Orleans Louisiana 22071 44850 940
1720298 1720298 2021-09-15 Ouachita Louisiana 22073 29166 528
1720299 1720299 2021-09-15 Plaquemines Louisiana 22075 3705 35
1720300 1720300 2021-09-15 Pointe Coupee Louisiana 22077 3694 81
1720301 1720301 2021-09-15 Rapides Louisiana 22079 20165 425
1720302 1720302 2021-09-15 Red River Louisiana 22081 1314 42
1720303 1720303 2021-09-15 Richland Louisiana 22083 3999 72
1720304 1720304 2021-09-15 Sabine Louisiana 22085 4197 73
1720305 1720305 2021-09-15 St. Bernard Louisiana 22087 6624 88
1720306 1720306 2021-09-15 St. Charles Louisiana 22089 8572 117
1720307 1720307 2021-09-15 St. Helena Louisiana 22091 1247 14
1720308 1720308 2021-09-15 St. James Louisiana 22093 3307 62
1720309 1720309 2021-09-15 St. John the Baptist Louisiana 22095 6078 156
1720310 1720310 2021-09-15 St. Landry Louisiana 22097 13322 317
1720311 1720311 2021-09-15 St. Martin Louisiana 22099 8065 153
1720312 1720312 2021-09-15 St. Mary Louisiana 22101 8155 204
1720313 1720313 2021-09-15 St. Tammany Louisiana 22103 41594 655
1720314 1720314 2021-09-15 Tangipahoa Louisiana 22105 21803 453
1720315 1720315 2021-09-15 Tensas Louisiana 22107 472 8
1720316 1720316 2021-09-15 Terrebonne Louisiana 22109 18649 288
1720317 1720317 2021-09-15 Union Louisiana 22111 3721 93
1720318 1720318 2021-09-15 Unknown Louisiana   522 0
1720319 1720319 2021-09-15 Vermilion Louisiana 22113 9691 168
1720320 1720320 2021-09-15 Vernon Louisiana 22115 5657 143
1720321 1720321 2021-09-15 Washington Louisiana 22117 7618 193
1720322 1720322 2021-09-15 Webster Louisiana 22119 6113 138
1720323 1720323 2021-09-15 West Baton Rouge Louisiana 22121 4254 71
1720324 1720324 2021-09-15 West Carroll Louisiana 22123 1800 46
1720325 1720325 2021-09-15 West Feliciana Louisiana 22125 1418 39
1720326 1720326 2021-09-15 Winn Louisiana 22127 2510 57

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