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-08-21 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
454715 454715 2020-08-21 Acadia Louisiana 22001 2735 92
454716 454716 2020-08-21 Allen Louisiana 22003 1402 36
454717 454717 2020-08-21 Ascension Louisiana 22005 3175 85
454718 454718 2020-08-21 Assumption Louisiana 22007 628 20
454719 454719 2020-08-21 Avoyelles Louisiana 22009 1196 40
454720 454720 2020-08-21 Beauregard Louisiana 22011 928 28
454721 454721 2020-08-21 Bienville Louisiana 22013 401 30
454722 454722 2020-08-21 Bossier Louisiana 22015 2520 87
454723 454723 2020-08-21 Caddo Louisiana 22017 7112 306
454724 454724 2020-08-21 Calcasieu Louisiana 22019 7235 166
454725 454725 2020-08-21 Caldwell Louisiana 22021 263 3
454726 454726 2020-08-21 Cameron Louisiana 22023 174 1
454727 454727 2020-08-21 Catahoula Louisiana 22025 338 6
454728 454728 2020-08-21 Claiborne Louisiana 22027 320 12
454729 454729 2020-08-21 Concordia Louisiana 22029 393 9
454730 454730 2020-08-21 De Soto Louisiana 22031 802 30
454731 454731 2020-08-21 East Baton Rouge Louisiana 22033 13226 395
454732 454732 2020-08-21 East Carroll Louisiana 22035 527 2
454733 454733 2020-08-21 East Feliciana Louisiana 22037 708 43
454734 454734 2020-08-21 Evangeline Louisiana 22039 995 20
454735 454735 2020-08-21 Franklin Louisiana 22041 1024 24
454736 454736 2020-08-21 Grant Louisiana 22043 374 25
454737 454737 2020-08-21 Iberia Louisiana 22045 2648 81
454738 454738 2020-08-21 Iberville Louisiana 22047 1318 52
454739 454739 2020-08-21 Jackson Louisiana 22049 409 20
454740 454740 2020-08-21 Jefferson Louisiana 22051 16006 537
454741 454741 2020-08-21 Jefferson Davis Louisiana 22053 1111 32
454742 454742 2020-08-21 LaSalle Louisiana 22059 363 4
454743 454743 2020-08-21 Lafayette Louisiana 22055 8103 103
454744 454744 2020-08-21 Lafourche Louisiana 22057 3073 107
454745 454745 2020-08-21 Lincoln Louisiana 22061 867 38
454746 454746 2020-08-21 Livingston Louisiana 22063 3236 60
454747 454747 2020-08-21 Madison Louisiana 22065 650 6
454748 454748 2020-08-21 Morehouse Louisiana 22067 563 15
454749 454749 2020-08-21 Natchitoches Louisiana 22069 874 20
454750 454750 2020-08-21 Orleans Louisiana 22071 11134 569
454751 454751 2020-08-21 Ouachita Louisiana 22073 5308 122
454752 454752 2020-08-21 Plaquemines Louisiana 22075 481 19
454753 454753 2020-08-21 Pointe Coupee Louisiana 22077 874 36
454754 454754 2020-08-21 Rapides Louisiana 22079 3642 130
454755 454755 2020-08-21 Red River Louisiana 22081 298 19
454756 454756 2020-08-21 Richland Louisiana 22083 657 8
454757 454757 2020-08-21 Sabine Louisiana 22085 709 13
454758 454758 2020-08-21 St. Bernard Louisiana 22087 1169 24
454759 454759 2020-08-21 St. Charles Louisiana 22089 1568 54
454760 454760 2020-08-21 St. Helena Louisiana 22091 303 2
454761 454761 2020-08-21 St. James Louisiana 22093 745 33
454762 454762 2020-08-21 St. John the Baptist Louisiana 22095 1484 94
454763 454763 2020-08-21 St. Landry Louisiana 22097 2976 105
454764 454764 2020-08-21 St. Martin Louisiana 22099 1827 50
454765 454765 2020-08-21 St. Mary Louisiana 22101 1711 65
454766 454766 2020-08-21 St. Tammany Louisiana 22103 5760 226
454767 454767 2020-08-21 Tangipahoa Louisiana 22105 3899 88
454768 454768 2020-08-21 Tensas Louisiana 22107 124 1
454769 454769 2020-08-21 Terrebonne Louisiana 22109 3285 93
454770 454770 2020-08-21 Union Louisiana 22111 772 36
454771 454771 2020-08-21 Unknown Louisiana   382 141
454772 454772 2020-08-21 Vermilion Louisiana 22113 1768 32
454773 454773 2020-08-21 Vernon Louisiana 22115 869 35
454774 454774 2020-08-21 Washington Louisiana 22117 1383 59
454775 454775 2020-08-21 Webster Louisiana 22119 977 19
454776 454776 2020-08-21 West Baton Rouge Louisiana 22121 771 38
454777 454777 2020-08-21 West Carroll Louisiana 22123 317 8
454778 454778 2020-08-21 West Feliciana Louisiana 22125 466 18
454779 454779 2020-08-21 Winn Louisiana 22127 505 15

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