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-05 and state = "Louisiana" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Louisiana · 65 ✖
Link rowid date ▲ county state fips cases deaths
303965 303965 2020-07-05 Acadia Louisiana 22001 1016 40
303966 303966 2020-07-05 Allen Louisiana 22003 344 11
303967 303967 2020-07-05 Ascension Louisiana 22005 1331 58
303968 303968 2020-07-05 Assumption Louisiana 22007 381 15
303969 303969 2020-07-05 Avoyelles Louisiana 22009 386 14
303970 303970 2020-07-05 Beauregard Louisiana 22011 247 9
303971 303971 2020-07-05 Bienville Louisiana 22013 233 28
303972 303972 2020-07-05 Bossier Louisiana 22015 1007 35
303973 303973 2020-07-05 Caddo Louisiana 22017 3706 243
303974 303974 2020-07-05 Calcasieu Louisiana 22019 2153 59
303975 303975 2020-07-05 Caldwell Louisiana 22021 112 1
303976 303976 2020-07-05 Cameron Louisiana 22023 58 0
303977 303977 2020-07-05 Catahoula Louisiana 22025 195 3
303978 303978 2020-07-05 Claiborne Louisiana 22027 128 10
303979 303979 2020-07-05 Concordia Louisiana 22029 118 6
303980 303980 2020-07-05 De Soto Louisiana 22031 369 19
303981 303981 2020-07-05 East Baton Rouge Louisiana 22033 5874 274
303982 303982 2020-07-05 East Carroll Louisiana 22035 445 1
303983 303983 2020-07-05 East Feliciana Louisiana 22037 310 33
303984 303984 2020-07-05 Evangeline Louisiana 22039 228 1
303985 303985 2020-07-05 Franklin Louisiana 22041 501 14
303986 303986 2020-07-05 Grant Louisiana 22043 94 1
303987 303987 2020-07-05 Iberia Louisiana 22045 902 44
303988 303988 2020-07-05 Iberville Louisiana 22047 752 43
303989 303989 2020-07-05 Jackson Louisiana 22049 221 16
303990 303990 2020-07-05 Jefferson Louisiana 22051 10024 487
303991 303991 2020-07-05 Jefferson Davis Louisiana 22053 461 9
303992 303992 2020-07-05 LaSalle Louisiana 22059 104 0
303993 303993 2020-07-05 Lafayette Louisiana 22055 2800 48
303994 303994 2020-07-05 Lafourche Louisiana 22057 1284 90
303995 303995 2020-07-05 Lincoln Louisiana 22061 350 19
303996 303996 2020-07-05 Livingston Louisiana 22063 1156 38
303997 303997 2020-07-05 Madison Louisiana 22065 393 3
303998 303998 2020-07-05 Morehouse Louisiana 22067 250 10
303999 303999 2020-07-05 Natchitoches Louisiana 22069 327 14
304000 304000 2020-07-05 Orleans Louisiana 22071 8107 534
304001 304001 2020-07-05 Ouachita Louisiana 22073 2667 80
304002 304002 2020-07-05 Plaquemines Louisiana 22075 278 17
304003 304003 2020-07-05 Pointe Coupee Louisiana 22077 289 28
304004 304004 2020-07-05 Rapides Louisiana 22079 1678 67
304005 304005 2020-07-05 Red River Louisiana 22081 64 8
304006 304006 2020-07-05 Richland Louisiana 22083 211 4
304007 304007 2020-07-05 Sabine Louisiana 22085 98 1
304008 304008 2020-07-05 St. Bernard Louisiana 22087 646 23
304009 304009 2020-07-05 St. Charles Louisiana 22089 796 49
304010 304010 2020-07-05 St. Helena Louisiana 22091 103 1
304011 304011 2020-07-05 St. James Louisiana 22093 404 29
304012 304012 2020-07-05 St. John the Baptist Louisiana 22095 1011 87
304013 304013 2020-07-05 St. Landry Louisiana 22097 763 57
304014 304014 2020-07-05 St. Martin Louisiana 22099 824 27
304015 304015 2020-07-05 St. Mary Louisiana 22101 576 38
304016 304016 2020-07-05 St. Tammany Louisiana 22103 2615 178
304017 304017 2020-07-05 Tangipahoa Louisiana 22105 1513 43
304018 304018 2020-07-05 Tensas Louisiana 22107 26 0
304019 304019 2020-07-05 Terrebonne Louisiana 22109 1228 61
304020 304020 2020-07-05 Union Louisiana 22111 443 25
304021 304021 2020-07-05 Unknown Louisiana   116 108
304022 304022 2020-07-05 Vermilion Louisiana 22113 326 6
304023 304023 2020-07-05 Vernon Louisiana 22115 179 8
304024 304024 2020-07-05 Washington Louisiana 22117 720 47
304025 304025 2020-07-05 Webster Louisiana 22119 434 12
304026 304026 2020-07-05 West Baton Rouge Louisiana 22121 309 30
304027 304027 2020-07-05 West Carroll Louisiana 22123 149 5
304028 304028 2020-07-05 West Feliciana Louisiana 22125 247 14
304029 304029 2020-07-05 Winn Louisiana 22127 254 5

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