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 2020-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
652234 652234 2020-10-21 Acadia Louisiana 22001 3091 100
652235 652235 2020-10-21 Allen Louisiana 22003 1823 54
652236 652236 2020-10-21 Ascension Louisiana 22005 3992 98
652237 652237 2020-10-21 Assumption Louisiana 22007 788 24
652238 652238 2020-10-21 Avoyelles Louisiana 22009 1679 62
652239 652239 2020-10-21 Beauregard Louisiana 22011 1056 40
652240 652240 2020-10-21 Bienville Louisiana 22013 581 33
652241 652241 2020-10-21 Bossier Louisiana 22015 4023 117
652242 652242 2020-10-21 Caddo Louisiana 22017 9784 390
652243 652243 2020-10-21 Calcasieu Louisiana 22019 8256 223
652244 652244 2020-10-21 Caldwell Louisiana 22021 340 3
652245 652245 2020-10-21 Cameron Louisiana 22023 238 2
652246 652246 2020-10-21 Catahoula Louisiana 22025 455 14
652247 652247 2020-10-21 Claiborne Louisiana 22027 593 24
652248 652248 2020-10-21 Concordia Louisiana 22029 576 16
652249 652249 2020-10-21 De Soto Louisiana 22031 1000 35
652250 652250 2020-10-21 East Baton Rouge Louisiana 22033 15846 456
652251 652251 2020-10-21 East Carroll Louisiana 22035 575 6
652252 652252 2020-10-21 East Feliciana Louisiana 22037 1786 75
652253 652253 2020-10-21 Evangeline Louisiana 22039 1389 39
652254 652254 2020-10-21 Franklin Louisiana 22041 1287 44
652255 652255 2020-10-21 Grant Louisiana 22043 522 30
652256 652256 2020-10-21 Iberia Louisiana 22045 3049 93
652257 652257 2020-10-21 Iberville Louisiana 22047 1457 60
652258 652258 2020-10-21 Jackson Louisiana 22049 829 22
652259 652259 2020-10-21 Jefferson Louisiana 22051 18441 581
652260 652260 2020-10-21 Jefferson Davis Louisiana 22053 1323 43
652261 652261 2020-10-21 LaSalle Louisiana 22059 483 10
652262 652262 2020-10-21 Lafayette Louisiana 22055 9345 137
652263 652263 2020-10-21 Lafourche Louisiana 22057 3854 126
652264 652264 2020-10-21 Lincoln Louisiana 22061 1622 48
652265 652265 2020-10-21 Livingston Louisiana 22063 4135 79
652266 652266 2020-10-21 Madison Louisiana 22065 892 8
652267 652267 2020-10-21 Morehouse Louisiana 22067 874 25
652268 652268 2020-10-21 Natchitoches Louisiana 22069 1422 27
652269 652269 2020-10-21 Orleans Louisiana 22071 13289 592
652270 652270 2020-10-21 Ouachita Louisiana 22073 6845 160
652271 652271 2020-10-21 Plaquemines Louisiana 22075 883 19
652272 652272 2020-10-21 Pointe Coupee Louisiana 22077 1119 40
652273 652273 2020-10-21 Rapides Louisiana 22079 4593 154
652274 652274 2020-10-21 Red River Louisiana 22081 405 24
652275 652275 2020-10-21 Richland Louisiana 22083 860 16
652276 652276 2020-10-21 Sabine Louisiana 22085 960 14
652277 652277 2020-10-21 St. Bernard Louisiana 22087 1524 32
652278 652278 2020-10-21 St. Charles Louisiana 22089 1920 63
652279 652279 2020-10-21 St. Helena Louisiana 22091 430 4
652280 652280 2020-10-21 St. James Louisiana 22093 832 40
652281 652281 2020-10-21 St. John the Baptist Louisiana 22095 1623 106
652282 652282 2020-10-21 St. Landry Louisiana 22097 3565 133
652283 652283 2020-10-21 St. Martin Louisiana 22099 2183 63
652284 652284 2020-10-21 St. Mary Louisiana 22101 2001 84
652285 652285 2020-10-21 St. Tammany Louisiana 22103 7580 269
652286 652286 2020-10-21 Tangipahoa Louisiana 22105 4930 122
652287 652287 2020-10-21 Tensas Louisiana 22107 186 2
652288 652288 2020-10-21 Terrebonne Louisiana 22109 3832 123
652289 652289 2020-10-21 Union Louisiana 22111 1079 50
652290 652290 2020-10-21 Unknown Louisiana   3974 206
652291 652291 2020-10-21 Vermilion Louisiana 22113 2097 70
652292 652292 2020-10-21 Vernon Louisiana 22115 1108 55
652293 652293 2020-10-21 Washington Louisiana 22117 1731 70
652294 652294 2020-10-21 Webster Louisiana 22119 1430 38
652295 652295 2020-10-21 West Baton Rouge Louisiana 22121 957 42
652296 652296 2020-10-21 West Carroll Louisiana 22123 369 11
652297 652297 2020-10-21 West Feliciana Louisiana 22125 747 25
652298 652298 2020-10-21 Winn Louisiana 22127 674 19

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