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-07-27 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
374186 374186 2020-07-27 Acadia Louisiana 22001 2215 63
374187 374187 2020-07-27 Allen Louisiana 22003 993 16
374188 374188 2020-07-27 Ascension Louisiana 22005 2335 65
374189 374189 2020-07-27 Assumption Louisiana 22007 509 18
374190 374190 2020-07-27 Avoyelles Louisiana 22009 842 24
374191 374191 2020-07-27 Beauregard Louisiana 22011 648 13
374192 374192 2020-07-27 Bienville Louisiana 22013 340 29
374193 374193 2020-07-27 Bossier Louisiana 22015 1894 60
374194 374194 2020-07-27 Caddo Louisiana 22017 5745 266
374195 374195 2020-07-27 Calcasieu Louisiana 22019 5626 107
374196 374196 2020-07-27 Caldwell Louisiana 22021 178 1
374197 374197 2020-07-27 Cameron Louisiana 22023 157 0
374198 374198 2020-07-27 Catahoula Louisiana 22025 243 3
374199 374199 2020-07-27 Claiborne Louisiana 22027 200 10
374200 374200 2020-07-27 Concordia Louisiana 22029 238 7
374201 374201 2020-07-27 De Soto Louisiana 22031 582 24
374202 374202 2020-07-27 East Baton Rouge Louisiana 22033 9985 310
374203 374203 2020-07-27 East Carroll Louisiana 22035 489 1
374204 374204 2020-07-27 East Feliciana Louisiana 22037 468 35
374205 374205 2020-07-27 Evangeline Louisiana 22039 641 2
374206 374206 2020-07-27 Franklin Louisiana 22041 729 16
374207 374207 2020-07-27 Grant Louisiana 22043 244 3
374208 374208 2020-07-27 Iberia Louisiana 22045 2057 58
374209 374209 2020-07-27 Iberville Louisiana 22047 1047 46
374210 374210 2020-07-27 Jackson Louisiana 22049 340 18
374211 374211 2020-07-27 Jefferson Louisiana 22051 13680 510
374212 374212 2020-07-27 Jefferson Davis Louisiana 22053 910 22
374213 374213 2020-07-27 LaSalle Louisiana 22059 197 2
374214 374214 2020-07-27 Lafayette Louisiana 22055 5888 78
374215 374215 2020-07-27 Lafourche Louisiana 22057 2393 95
374216 374216 2020-07-27 Lincoln Louisiana 22061 641 23
374217 374217 2020-07-27 Livingston Louisiana 22063 2380 47
374218 374218 2020-07-27 Madison Louisiana 22065 526 6
374219 374219 2020-07-27 Morehouse Louisiana 22067 396 11
374220 374220 2020-07-27 Natchitoches Louisiana 22069 602 15
374221 374221 2020-07-27 Orleans Louisiana 22071 10011 552
374222 374222 2020-07-27 Ouachita Louisiana 22073 4144 99
374223 374223 2020-07-27 Plaquemines Louisiana 22075 381 18
374224 374224 2020-07-27 Pointe Coupee Louisiana 22077 646 29
374225 374225 2020-07-27 Rapides Louisiana 22079 2743 98
374226 374226 2020-07-27 Red River Louisiana 22081 169 9
374227 374227 2020-07-27 Richland Louisiana 22083 477 5
374228 374228 2020-07-27 Sabine Louisiana 22085 469 6
374229 374229 2020-07-27 St. Bernard Louisiana 22087 976 23
374230 374230 2020-07-27 St. Charles Louisiana 22089 1261 50
374231 374231 2020-07-27 St. Helena Louisiana 22091 224 1
374232 374232 2020-07-27 St. James Louisiana 22093 591 30
374233 374233 2020-07-27 St. John the Baptist Louisiana 22095 1291 88
374234 374234 2020-07-27 St. Landry Louisiana 22097 1927 69
374235 374235 2020-07-27 St. Martin Louisiana 22099 1429 36
374236 374236 2020-07-27 St. Mary Louisiana 22101 1312 42
374237 374237 2020-07-27 St. Tammany Louisiana 22103 4375 195
374238 374238 2020-07-27 Tangipahoa Louisiana 22105 2895 56
374239 374239 2020-07-27 Tensas Louisiana 22107 52 0
374240 374240 2020-07-27 Terrebonne Louisiana 22109 2519 72
374241 374241 2020-07-27 Union Louisiana 22111 547 31
374242 374242 2020-07-27 Unknown Louisiana   122 112
374243 374243 2020-07-27 Vermilion Louisiana 22113 1142 14
374244 374244 2020-07-27 Vernon Louisiana 22115 599 19
374245 374245 2020-07-27 Washington Louisiana 22117 1123 56
374246 374246 2020-07-27 Webster Louisiana 22119 770 12
374247 374247 2020-07-27 West Baton Rouge Louisiana 22121 573 33
374248 374248 2020-07-27 West Carroll Louisiana 22123 226 5
374249 374249 2020-07-27 West Feliciana Louisiana 22125 319 15
374250 374250 2020-07-27 Winn Louisiana 22127 358 7

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