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-12-05 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
798233 798233 2020-12-05 Acadia Louisiana 22001 4197 118
798234 798234 2020-12-05 Allen Louisiana 22003 2150 68
798235 798235 2020-12-05 Ascension Louisiana 22005 6074 109
798236 798236 2020-12-05 Assumption Louisiana 22007 1067 25
798237 798237 2020-12-05 Avoyelles Louisiana 22009 2220 70
798238 798238 2020-12-05 Beauregard Louisiana 22011 1461 50
798239 798239 2020-12-05 Bienville Louisiana 22013 853 37
798240 798240 2020-12-05 Bossier Louisiana 22015 6734 158
798241 798241 2020-12-05 Caddo Louisiana 22017 14271 449
798242 798242 2020-12-05 Calcasieu Louisiana 22019 10939 252
798243 798243 2020-12-05 Caldwell Louisiana 22021 682 11
798244 798244 2020-12-05 Cameron Louisiana 22023 305 3
798245 798245 2020-12-05 Catahoula Louisiana 22025 660 18
798246 798246 2020-12-05 Claiborne Louisiana 22027 773 32
798247 798247 2020-12-05 Concordia Louisiana 22029 1063 31
798248 798248 2020-12-05 De Soto Louisiana 22031 1366 39
798249 798249 2020-12-05 East Baton Rouge Louisiana 22033 20941 522
798250 798250 2020-12-05 East Carroll Louisiana 22035 849 11
798251 798251 2020-12-05 East Feliciana Louisiana 22037 2206 85
798252 798252 2020-12-05 Evangeline Louisiana 22039 2067 46
798253 798253 2020-12-05 Franklin Louisiana 22041 1778 65
798254 798254 2020-12-05 Grant Louisiana 22043 944 32
798255 798255 2020-12-05 Iberia Louisiana 22045 3862 110
798256 798256 2020-12-05 Iberville Louisiana 22047 2133 66
798257 798257 2020-12-05 Jackson Louisiana 22049 1195 33
798258 798258 2020-12-05 Jefferson Louisiana 22051 24588 631
798259 798259 2020-12-05 Jefferson Davis Louisiana 22053 1829 52
798260 798260 2020-12-05 LaSalle Louisiana 22059 950 21
798261 798261 2020-12-05 Lafayette Louisiana 22055 12877 157
798262 798262 2020-12-05 Lafourche Louisiana 22057 5001 142
798263 798263 2020-12-05 Lincoln Louisiana 22061 2697 61
798264 798264 2020-12-05 Livingston Louisiana 22063 6445 96
798265 798265 2020-12-05 Madison Louisiana 22065 1118 15
798266 798266 2020-12-05 Morehouse Louisiana 22067 1528 35
798267 798267 2020-12-05 Natchitoches Louisiana 22069 2163 51
798268 798268 2020-12-05 Orleans Louisiana 22071 16733 649
798269 798269 2020-12-05 Ouachita Louisiana 22073 10648 217
798270 798270 2020-12-05 Plaquemines Louisiana 22075 1278 20
798271 798271 2020-12-05 Pointe Coupee Louisiana 22077 1484 49
798272 798272 2020-12-05 Rapides Louisiana 22079 6562 194
798273 798273 2020-12-05 Red River Louisiana 22081 582 26
798274 798274 2020-12-05 Richland Louisiana 22083 1449 32
798275 798275 2020-12-05 Sabine Louisiana 22085 1619 21
798276 798276 2020-12-05 St. Bernard Louisiana 22087 1921 34
798277 798277 2020-12-05 St. Charles Louisiana 22089 2812 70
798278 798278 2020-12-05 St. Helena Louisiana 22091 556 4
798279 798279 2020-12-05 St. James Louisiana 22093 1035 40
798280 798280 2020-12-05 St. John the Baptist Louisiana 22095 2094 116
798281 798281 2020-12-05 St. Landry Louisiana 22097 5332 165
798282 798282 2020-12-05 St. Martin Louisiana 22099 2879 73
798283 798283 2020-12-05 St. Mary Louisiana 22101 2441 96
798284 798284 2020-12-05 St. Tammany Louisiana 22103 11128 298
798285 798285 2020-12-05 Tangipahoa Louisiana 22105 7052 145
798286 798286 2020-12-05 Tensas Louisiana 22107 221 3
798287 798287 2020-12-05 Terrebonne Louisiana 22109 4743 139
798288 798288 2020-12-05 Union Louisiana 22111 1471 59
798289 798289 2020-12-05 Unknown Louisiana   404 0
798290 798290 2020-12-05 Vermilion Louisiana 22113 2741 76
798291 798291 2020-12-05 Vernon Louisiana 22115 1508 66
798292 798292 2020-12-05 Washington Louisiana 22117 2367 80
798293 798293 2020-12-05 Webster Louisiana 22119 2138 59
798294 798294 2020-12-05 West Baton Rouge Louisiana 22121 1425 44
798295 798295 2020-12-05 West Carroll Louisiana 22123 718 21
798296 798296 2020-12-05 West Feliciana Louisiana 22125 820 25
798297 798297 2020-12-05 Winn Louisiana 22127 1030 26

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