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-09 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
811213 811213 2020-12-09 Acadia Louisiana 22001 4368 120
811214 811214 2020-12-09 Allen Louisiana 22003 2195 69
811215 811215 2020-12-09 Ascension Louisiana 22005 6500 110
811216 811216 2020-12-09 Assumption Louisiana 22007 1124 25
811217 811217 2020-12-09 Avoyelles Louisiana 22009 2272 70
811218 811218 2020-12-09 Beauregard Louisiana 22011 1530 50
811219 811219 2020-12-09 Bienville Louisiana 22013 907 37
811220 811220 2020-12-09 Bossier Louisiana 22015 7062 163
811221 811221 2020-12-09 Caddo Louisiana 22017 14744 468
811222 811222 2020-12-09 Calcasieu Louisiana 22019 11447 260
811223 811223 2020-12-09 Caldwell Louisiana 22021 717 12
811224 811224 2020-12-09 Cameron Louisiana 22023 326 3
811225 811225 2020-12-09 Catahoula Louisiana 22025 694 19
811226 811226 2020-12-09 Claiborne Louisiana 22027 813 32
811227 811227 2020-12-09 Concordia Louisiana 22029 1127 32
811228 811228 2020-12-09 De Soto Louisiana 22031 1436 41
811229 811229 2020-12-09 East Baton Rouge Louisiana 22033 21750 536
811230 811230 2020-12-09 East Carroll Louisiana 22035 874 11
811231 811231 2020-12-09 East Feliciana Louisiana 22037 2260 86
811232 811232 2020-12-09 Evangeline Louisiana 22039 2172 48
811233 811233 2020-12-09 Franklin Louisiana 22041 1825 69
811234 811234 2020-12-09 Grant Louisiana 22043 1062 32
811235 811235 2020-12-09 Iberia Louisiana 22045 4043 110
811236 811236 2020-12-09 Iberville Louisiana 22047 2260 66
811237 811237 2020-12-09 Jackson Louisiana 22049 1237 33
811238 811238 2020-12-09 Jefferson Louisiana 22051 25767 639
811239 811239 2020-12-09 Jefferson Davis Louisiana 22053 1931 56
811240 811240 2020-12-09 LaSalle Louisiana 22059 990 22
811241 811241 2020-12-09 Lafayette Louisiana 22055 13555 164
811242 811242 2020-12-09 Lafourche Louisiana 22057 5244 144
811243 811243 2020-12-09 Lincoln Louisiana 22061 2830 61
811244 811244 2020-12-09 Livingston Louisiana 22063 6961 101
811245 811245 2020-12-09 Madison Louisiana 22065 1144 15
811246 811246 2020-12-09 Morehouse Louisiana 22067 1632 36
811247 811247 2020-12-09 Natchitoches Louisiana 22069 2345 52
811248 811248 2020-12-09 Orleans Louisiana 22071 17374 652
811249 811249 2020-12-09 Ouachita Louisiana 22073 11171 221
811250 811250 2020-12-09 Plaquemines Louisiana 22075 1376 20
811251 811251 2020-12-09 Pointe Coupee Louisiana 22077 1588 49
811252 811252 2020-12-09 Rapides Louisiana 22079 6891 197
811253 811253 2020-12-09 Red River Louisiana 22081 602 26
811254 811254 2020-12-09 Richland Louisiana 22083 1496 33
811255 811255 2020-12-09 Sabine Louisiana 22085 1709 31
811256 811256 2020-12-09 St. Bernard Louisiana 22087 1989 35
811257 811257 2020-12-09 St. Charles Louisiana 22089 2909 71
811258 811258 2020-12-09 St. Helena Louisiana 22091 584 4
811259 811259 2020-12-09 St. James Louisiana 22093 1105 40
811260 811260 2020-12-09 St. John the Baptist Louisiana 22095 2161 116
811261 811261 2020-12-09 St. Landry Louisiana 22097 5517 170
811262 811262 2020-12-09 St. Martin Louisiana 22099 3084 75
811263 811263 2020-12-09 St. Mary Louisiana 22101 2518 97
811264 811264 2020-12-09 St. Tammany Louisiana 22103 11780 302
811265 811265 2020-12-09 Tangipahoa Louisiana 22105 7459 147
811266 811266 2020-12-09 Tensas Louisiana 22107 231 3
811267 811267 2020-12-09 Terrebonne Louisiana 22109 4929 140
811268 811268 2020-12-09 Union Louisiana 22111 1525 61
811269 811269 2020-12-09 Unknown Louisiana   389 0
811270 811270 2020-12-09 Vermilion Louisiana 22113 2869 78
811271 811271 2020-12-09 Vernon Louisiana 22115 1620 66
811272 811272 2020-12-09 Washington Louisiana 22117 2480 79
811273 811273 2020-12-09 Webster Louisiana 22119 2231 59
811274 811274 2020-12-09 West Baton Rouge Louisiana 22121 1508 46
811275 811275 2020-12-09 West Carroll Louisiana 22123 747 23
811276 811276 2020-12-09 West Feliciana Louisiana 22125 849 25
811277 811277 2020-12-09 Winn Louisiana 22127 1079 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);