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-11-26 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
769028 769028 2020-11-26 Acadia Louisiana 22001 3884 116
769029 769029 2020-11-26 Allen Louisiana 22003 2074 67
769030 769030 2020-11-26 Ascension Louisiana 22005 5527 107
769031 769031 2020-11-26 Assumption Louisiana 22007 1004 25
769032 769032 2020-11-26 Avoyelles Louisiana 22009 2052 68
769033 769033 2020-11-26 Beauregard Louisiana 22011 1330 49
769034 769034 2020-11-26 Bienville Louisiana 22013 746 37
769035 769035 2020-11-26 Bossier Louisiana 22015 6079 149
769036 769036 2020-11-26 Caddo Louisiana 22017 12879 444
769037 769037 2020-11-26 Calcasieu Louisiana 22019 10254 243
769038 769038 2020-11-26 Caldwell Louisiana 22021 621 8
769039 769039 2020-11-26 Cameron Louisiana 22023 287 3
769040 769040 2020-11-26 Catahoula Louisiana 22025 612 18
769041 769041 2020-11-26 Claiborne Louisiana 22027 731 29
769042 769042 2020-11-26 Concordia Louisiana 22029 962 25
769043 769043 2020-11-26 De Soto Louisiana 22031 1230 39
769044 769044 2020-11-26 East Baton Rouge Louisiana 22033 19395 506
769045 769045 2020-11-26 East Carroll Louisiana 22035 731 9
769046 769046 2020-11-26 East Feliciana Louisiana 22037 2090 84
769047 769047 2020-11-26 Evangeline Louisiana 22039 1861 44
769048 769048 2020-11-26 Franklin Louisiana 22041 1694 63
769049 769049 2020-11-26 Grant Louisiana 22043 797 32
769050 769050 2020-11-26 Iberia Louisiana 22045 3603 105
769051 769051 2020-11-26 Iberville Louisiana 22047 1878 65
769052 769052 2020-11-26 Jackson Louisiana 22049 1132 31
769053 769053 2020-11-26 Jefferson Louisiana 22051 21666 628
769054 769054 2020-11-26 Jefferson Davis Louisiana 22053 1686 50
769055 769055 2020-11-26 LaSalle Louisiana 22059 864 20
769056 769056 2020-11-26 Lafayette Louisiana 22055 11778 146
769057 769057 2020-11-26 Lafourche Louisiana 22057 4594 138
769058 769058 2020-11-26 Lincoln Louisiana 22061 2465 58
769059 769059 2020-11-26 Livingston Louisiana 22063 5773 89
769060 769060 2020-11-26 Madison Louisiana 22065 1034 13
769061 769061 2020-11-26 Morehouse Louisiana 22067 1330 30
769062 769062 2020-11-26 Natchitoches Louisiana 22069 2004 45
769063 769063 2020-11-26 Orleans Louisiana 22071 15388 646
769064 769064 2020-11-26 Ouachita Louisiana 22073 9688 207
769065 769065 2020-11-26 Plaquemines Louisiana 22075 1099 19
769066 769066 2020-11-26 Pointe Coupee Louisiana 22077 1349 49
769067 769067 2020-11-26 Rapides Louisiana 22079 6167 188
769068 769068 2020-11-26 Red River Louisiana 22081 566 26
769069 769069 2020-11-26 Richland Louisiana 22083 1362 26
769070 769070 2020-11-26 Sabine Louisiana 22085 1393 20
769071 769071 2020-11-26 St. Bernard Louisiana 22087 1778 34
769072 769072 2020-11-26 St. Charles Louisiana 22089 2480 70
769073 769073 2020-11-26 St. Helena Louisiana 22091 509 4
769074 769074 2020-11-26 St. James Louisiana 22093 965 40
769075 769075 2020-11-26 St. John the Baptist Louisiana 22095 1921 114
769076 769076 2020-11-26 St. Landry Louisiana 22097 4844 153
769077 769077 2020-11-26 St. Martin Louisiana 22099 2669 71
769078 769078 2020-11-26 St. Mary Louisiana 22101 2338 95
769079 769079 2020-11-26 St. Tammany Louisiana 22103 9931 290
769080 769080 2020-11-26 Tangipahoa Louisiana 22105 6435 142
769081 769081 2020-11-26 Tensas Louisiana 22107 212 3
769082 769082 2020-11-26 Terrebonne Louisiana 22109 4413 136
769083 769083 2020-11-26 Union Louisiana 22111 1393 56
769084 769084 2020-11-26 Unknown Louisiana   361 0
769085 769085 2020-11-26 Vermilion Louisiana 22113 2521 74
769086 769086 2020-11-26 Vernon Louisiana 22115 1399 61
769087 769087 2020-11-26 Washington Louisiana 22117 2211 77
769088 769088 2020-11-26 Webster Louisiana 22119 1950 52
769089 769089 2020-11-26 West Baton Rouge Louisiana 22121 1293 43
769090 769090 2020-11-26 West Carroll Louisiana 22123 619 20
769091 769091 2020-11-26 West Feliciana Louisiana 22125 789 25
769092 769092 2020-11-26 Winn Louisiana 22127 948 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);