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-08 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
807968 807968 2020-12-08 Acadia Louisiana 22001 4307 119
807969 807969 2020-12-08 Allen Louisiana 22003 2180 69
807970 807970 2020-12-08 Ascension Louisiana 22005 6263 109
807971 807971 2020-12-08 Assumption Louisiana 22007 1106 25
807972 807972 2020-12-08 Avoyelles Louisiana 22009 2284 70
807973 807973 2020-12-08 Beauregard Louisiana 22011 1511 50
807974 807974 2020-12-08 Bienville Louisiana 22013 896 37
807975 807975 2020-12-08 Bossier Louisiana 22015 6976 160
807976 807976 2020-12-08 Caddo Louisiana 22017 14649 466
807977 807977 2020-12-08 Calcasieu Louisiana 22019 11183 260
807978 807978 2020-12-08 Caldwell Louisiana 22021 714 12
807979 807979 2020-12-08 Cameron Louisiana 22023 318 3
807980 807980 2020-12-08 Catahoula Louisiana 22025 683 19
807981 807981 2020-12-08 Claiborne Louisiana 22027 798 32
807982 807982 2020-12-08 Concordia Louisiana 22029 1101 32
807983 807983 2020-12-08 De Soto Louisiana 22031 1415 41
807984 807984 2020-12-08 East Baton Rouge Louisiana 22033 21419 532
807985 807985 2020-12-08 East Carroll Louisiana 22035 873 11
807986 807986 2020-12-08 East Feliciana Louisiana 22037 2239 86
807987 807987 2020-12-08 Evangeline Louisiana 22039 2163 47
807988 807988 2020-12-08 Franklin Louisiana 22041 1814 68
807989 807989 2020-12-08 Grant Louisiana 22043 998 32
807990 807990 2020-12-08 Iberia Louisiana 22045 4000 110
807991 807991 2020-12-08 Iberville Louisiana 22047 2191 66
807992 807992 2020-12-08 Jackson Louisiana 22049 1218 33
807993 807993 2020-12-08 Jefferson Louisiana 22051 25316 633
807994 807994 2020-12-08 Jefferson Davis Louisiana 22053 1904 55
807995 807995 2020-12-08 LaSalle Louisiana 22059 987 22
807996 807996 2020-12-08 Lafayette Louisiana 22055 13225 163
807997 807997 2020-12-08 Lafourche Louisiana 22057 5153 144
807998 807998 2020-12-08 Lincoln Louisiana 22061 2801 61
807999 807999 2020-12-08 Livingston Louisiana 22063 6618 100
808000 808000 2020-12-08 Madison Louisiana 22065 1136 15
808001 808001 2020-12-08 Morehouse Louisiana 22067 1617 35
808002 808002 2020-12-08 Natchitoches Louisiana 22069 2320 52
808003 808003 2020-12-08 Orleans Louisiana 22071 17194 651
808004 808004 2020-12-08 Ouachita Louisiana 22073 11008 221
808005 808005 2020-12-08 Plaquemines Louisiana 22075 1355 20
808006 808006 2020-12-08 Pointe Coupee Louisiana 22077 1526 49
808007 808007 2020-12-08 Rapides Louisiana 22079 6709 196
808008 808008 2020-12-08 Red River Louisiana 22081 600 26
808009 808009 2020-12-08 Richland Louisiana 22083 1485 33
808010 808010 2020-12-08 Sabine Louisiana 22085 1680 29
808011 808011 2020-12-08 St. Bernard Louisiana 22087 1976 34
808012 808012 2020-12-08 St. Charles Louisiana 22089 2884 70
808013 808013 2020-12-08 St. Helena Louisiana 22091 562 4
808014 808014 2020-12-08 St. James Louisiana 22093 1095 40
808015 808015 2020-12-08 St. John the Baptist Louisiana 22095 2144 116
808016 808016 2020-12-08 St. Landry Louisiana 22097 5482 170
808017 808017 2020-12-08 St. Martin Louisiana 22099 2961 75
808018 808018 2020-12-08 St. Mary Louisiana 22101 2515 97
808019 808019 2020-12-08 St. Tammany Louisiana 22103 11502 301
808020 808020 2020-12-08 Tangipahoa Louisiana 22105 7248 147
808021 808021 2020-12-08 Tensas Louisiana 22107 228 3
808022 808022 2020-12-08 Terrebonne Louisiana 22109 4906 140
808023 808023 2020-12-08 Union Louisiana 22111 1512 59
808024 808024 2020-12-08 Unknown Louisiana   422 0
808025 808025 2020-12-08 Vermilion Louisiana 22113 2841 78
808026 808026 2020-12-08 Vernon Louisiana 22115 1596 66
808027 808027 2020-12-08 Washington Louisiana 22117 2438 79
808028 808028 2020-12-08 Webster Louisiana 22119 2228 59
808029 808029 2020-12-08 West Baton Rouge Louisiana 22121 1457 46
808030 808030 2020-12-08 West Carroll Louisiana 22123 747 23
808031 808031 2020-12-08 West Feliciana Louisiana 22125 816 25
808032 808032 2020-12-08 Winn Louisiana 22127 1069 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);