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 2022-04-10 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
2393239 2393239 2022-04-10 Acadia Louisiana 22001 15859 292
2393240 2393240 2022-04-10 Allen Louisiana 22003 7869 137
2393241 2393241 2022-04-10 Ascension Louisiana 22005 34800 293
2393242 2393242 2022-04-10 Assumption Louisiana 22007 5556 69
2393243 2393243 2022-04-10 Avoyelles Louisiana 22009 11572 206
2393244 2393244 2022-04-10 Beauregard Louisiana 22011 9248 142
2393245 2393245 2022-04-10 Bienville Louisiana 22013 3976 111
2393246 2393246 2022-04-10 Bossier Louisiana 22015 37486 491
2393247 2393247 2022-04-10 Caddo Louisiana 22017 67209 1143
2393248 2393248 2022-04-10 Calcasieu Louisiana 22019 54639 704
2393249 2393249 2022-04-10 Caldwell Louisiana 22021 3581 55
2393250 2393250 2022-04-10 Cameron Louisiana 22023 1198 8
2393251 2393251 2022-04-10 Catahoula Louisiana 22025 2694 55
2393252 2393252 2022-04-10 Claiborne Louisiana 22027 3277 76
2393253 2393253 2022-04-10 Concordia Louisiana 22029 5088 89
2393254 2393254 2022-04-10 De Soto Louisiana 22031 7321 135
2393255 2393255 2022-04-10 East Baton Rouge Louisiana 22033 110776 1340
2393256 2393256 2022-04-10 East Carroll Louisiana 22035 2536 38
2393257 2393257 2022-04-10 East Feliciana Louisiana 22037 7301 170
2393258 2393258 2022-04-10 Evangeline Louisiana 22039 8381 157
2393259 2393259 2022-04-10 Franklin Louisiana 22041 7339 178
2393260 2393260 2022-04-10 Grant Louisiana 22043 5853 94
2393261 2393261 2022-04-10 Iberia Louisiana 22045 19050 264
2393262 2393262 2022-04-10 Iberville Louisiana 22047 8981 152
2393263 2393263 2022-04-10 Jackson Louisiana 22049 4386 75
2393264 2393264 2022-04-10 Jefferson Louisiana 22051 113560 1332
2393265 2393265 2022-04-10 Jefferson Davis Louisiana 22053 6932 157
2393266 2393266 2022-04-10 LaSalle Louisiana 22059 4238 57
2393267 2393267 2022-04-10 Lafayette Louisiana 22055 62317 498
2393268 2393268 2022-04-10 Lafourche Louisiana 22057 27737 366
2393269 2393269 2022-04-10 Lincoln Louisiana 22061 12209 144
2393270 2393270 2022-04-10 Livingston Louisiana 22063 37089 464
2393271 2393271 2022-04-10 Madison Louisiana 22065 3256 59
2393272 2393272 2022-04-10 Morehouse Louisiana 22067 6848 134
2393273 2393273 2022-04-10 Natchitoches Louisiana 22069 10108 166
2393274 2393274 2022-04-10 Orleans Louisiana 22071 87521 1108
2393275 2393275 2022-04-10 Ouachita Louisiana 22073 50539 742
2393276 2393276 2022-04-10 Plaquemines Louisiana 22075 6420 45
2393277 2393277 2022-04-10 Pointe Coupee Louisiana 22077 6269 92
2393278 2393278 2022-04-10 Rapides Louisiana 22079 32718 575
2393279 2393279 2022-04-10 Red River Louisiana 22081 2107 52
2393280 2393280 2022-04-10 Richland Louisiana 22083 6705 95
2393281 2393281 2022-04-10 Sabine Louisiana 22085 6328 110
2393282 2393282 2022-04-10 St. Bernard Louisiana 22087 11221 111
2393283 2393283 2022-04-10 St. Charles Louisiana 22089 13802 144
2393284 2393284 2022-04-10 St. Helena Louisiana 22091 1912 23
2393285 2393285 2022-04-10 St. James Louisiana 22093 5774 76
2393286 2393286 2022-04-10 St. John the Baptist Louisiana 22095 10510 184
2393287 2393287 2022-04-10 St. Landry Louisiana 22097 22165 415
2393288 2393288 2022-04-10 St. Martin Louisiana 22099 12938 186
2393289 2393289 2022-04-10 St. Mary Louisiana 22101 12471 261
2393290 2393290 2022-04-10 St. Tammany Louisiana 22103 72051 848
2393291 2393291 2022-04-10 Tangipahoa Louisiana 22105 34668 595
2393292 2393292 2022-04-10 Tensas Louisiana 22107 986 11
2393293 2393293 2022-04-10 Terrebonne Louisiana 22109 30833 413
2393294 2393294 2022-04-10 Union Louisiana 22111 6911 131
2393295 2393295 2022-04-10 Unknown Louisiana   979 0
2393296 2393296 2022-04-10 Vermilion Louisiana 22113 15244 223
2393297 2393297 2022-04-10 Vernon Louisiana 22115 9924 191
2393298 2393298 2022-04-10 Washington Louisiana 22117 12942 248
2393299 2393299 2022-04-10 Webster Louisiana 22119 11096 183
2393300 2393300 2022-04-10 West Baton Rouge Louisiana 22121 7292 90
2393301 2393301 2022-04-10 West Carroll Louisiana 22123 3623 65
2393302 2393302 2022-04-10 West Feliciana Louisiana 22125 2831 46
2393303 2393303 2022-04-10 Winn Louisiana 22127 4429 63

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