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-05-13 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
140265 140265 2020-05-13 Acadia Louisiana 22001 151 11
140266 140266 2020-05-13 Allen Louisiana 22003 94 10
140267 140267 2020-05-13 Ascension Louisiana 22005 704 48
140268 140268 2020-05-13 Assumption Louisiana 22007 231 11
140269 140269 2020-05-13 Avoyelles Louisiana 22009 79 9
140270 140270 2020-05-13 Beauregard Louisiana 22011 48 4
140271 140271 2020-05-13 Bienville Louisiana 22013 80 20
140272 140272 2020-05-13 Bossier Louisiana 22015 324 22
140273 140273 2020-05-13 Caddo Louisiana 22017 1800 140
140274 140274 2020-05-13 Calcasieu Louisiana 22019 505 40
140275 140275 2020-05-13 Caldwell Louisiana 22021 48 0
140276 140276 2020-05-13 Cameron Louisiana 22023 3 0
140277 140277 2020-05-13 Catahoula Louisiana 22025 103 3
140278 140278 2020-05-13 Claiborne Louisiana 22027 59 10
140279 140279 2020-05-13 Concordia Louisiana 22029 51 4
140280 140280 2020-05-13 De Soto Louisiana 22031 221 14
140281 140281 2020-05-13 East Baton Rouge Louisiana 22033 2487 199
140282 140282 2020-05-13 East Carroll Louisiana 22035 25 0
140283 140283 2020-05-13 East Feliciana Louisiana 22037 145 21
140284 140284 2020-05-13 Evangeline Louisiana 22039 74 1
140285 140285 2020-05-13 Franklin Louisiana 22041 256 7
140286 140286 2020-05-13 Grant Louisiana 22043 18 1
140287 140287 2020-05-13 Iberia Louisiana 22045 352 26
140288 140288 2020-05-13 Iberville Louisiana 22047 507 38
140289 140289 2020-05-13 Jackson Louisiana 22049 67 8
140290 140290 2020-05-13 Jefferson Louisiana 22051 6833 408
140291 140291 2020-05-13 Jefferson Davis Louisiana 22053 69 6
140292 140292 2020-05-13 LaSalle Louisiana 22059 35 0
140293 140293 2020-05-13 Lafayette Louisiana 22055 537 22
140294 140294 2020-05-13 Lafourche Louisiana 22057 716 60
140295 140295 2020-05-13 Lincoln Louisiana 22061 115 13
140296 140296 2020-05-13 Livingston Louisiana 22063 293 23
140297 140297 2020-05-13 Madison Louisiana 22065 14 0
140298 140298 2020-05-13 Morehouse Louisiana 22067 87 5
140299 140299 2020-05-13 Natchitoches Louisiana 22069 100 9
140300 140300 2020-05-13 Orleans Louisiana 22071 6753 481
140301 140301 2020-05-13 Ouachita Louisiana 22073 861 31
140302 140302 2020-05-13 Plaquemines Louisiana 22075 191 16
140303 140303 2020-05-13 Pointe Coupee Louisiana 22077 139 16
140304 140304 2020-05-13 Rapides Louisiana 22079 394 13
140305 140305 2020-05-13 Red River Louisiana 22081 37 6
140306 140306 2020-05-13 Richland Louisiana 22083 104 1
140307 140307 2020-05-13 Sabine Louisiana 22085 28 0
140308 140308 2020-05-13 St. Bernard Louisiana 22087 515 18
140309 140309 2020-05-13 St. Charles Louisiana 22089 600 43
140310 140310 2020-05-13 St. Helena Louisiana 22091 38 1
140311 140311 2020-05-13 St. James Louisiana 22093 268 22
140312 140312 2020-05-13 St. John the Baptist Louisiana 22095 808 77
140313 140313 2020-05-13 St. Landry Louisiana 22097 241 51
140314 140314 2020-05-13 St. Martin Louisiana 22099 276 22
140315 140315 2020-05-13 St. Mary Louisiana 22101 257 26
140316 140316 2020-05-13 St. Tammany Louisiana 22103 1492 142
140317 140317 2020-05-13 Tangipahoa Louisiana 22105 687 30
140318 140318 2020-05-13 Tensas Louisiana 22107 6 0
140319 140319 2020-05-13 Terrebonne Louisiana 22109 542 39
140320 140320 2020-05-13 Union Louisiana 22111 227 11
140321 140321 2020-05-13 Unknown Louisiana   130 66
140322 140322 2020-05-13 Vermilion Louisiana 22113 42 2
140323 140323 2020-05-13 Vernon Louisiana 22115 19 2
140324 140324 2020-05-13 Washington Louisiana 22117 350 29
140325 140325 2020-05-13 Webster Louisiana 22119 112 4
140326 140326 2020-05-13 West Baton Rouge Louisiana 22121 124 30
140327 140327 2020-05-13 West Carroll Louisiana 22123 5 0
140328 140328 2020-05-13 West Feliciana Louisiana 22125 187 7
140329 140329 2020-05-13 Winn Louisiana 22127 64 2

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