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 2021-11-12 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
1908717 1908717 2021-11-12 Acadia Louisiana 22001 10548 249
1908718 1908718 2021-11-12 Allen Louisiana 22003 4747 116
1908719 1908719 2021-11-12 Ascension Louisiana 22005 21914 244
1908720 1908720 2021-11-12 Assumption Louisiana 22007 3677 57
1908721 1908721 2021-11-12 Avoyelles Louisiana 22009 7351 181
1908722 1908722 2021-11-12 Beauregard Louisiana 22011 6138 124
1908723 1908723 2021-11-12 Bienville Louisiana 22013 2507 99
1908724 1908724 2021-11-12 Bossier Louisiana 22015 21874 408
1908725 1908725 2021-11-12 Caddo Louisiana 22017 39713 967
1908726 1908726 2021-11-12 Calcasieu Louisiana 22019 34666 622
1908727 1908727 2021-11-12 Caldwell Louisiana 22021 2261 39
1908728 1908728 2021-11-12 Cameron Louisiana 22023 863 9
1908729 1908729 2021-11-12 Catahoula Louisiana 22025 1782 48
1908730 1908730 2021-11-12 Claiborne Louisiana 22027 2020 66
1908731 1908731 2021-11-12 Concordia Louisiana 22029 3237 79
1908732 1908732 2021-11-12 De Soto Louisiana 22031 4794 112
1908733 1908733 2021-11-12 East Baton Rouge Louisiana 22033 64177 1166
1908734 1908734 2021-11-12 East Carroll Louisiana 22035 1614 31
1908735 1908735 2021-11-12 East Feliciana Louisiana 22037 4501 145
1908736 1908736 2021-11-12 Evangeline Louisiana 22039 5878 141
1908737 1908737 2021-11-12 Franklin Louisiana 22041 4717 139
1908738 1908738 2021-11-12 Grant Louisiana 22043 3845 78
1908739 1908739 2021-11-12 Iberia Louisiana 22045 12548 226
1908740 1908740 2021-11-12 Iberville Louisiana 22047 5853 127
1908741 1908741 2021-11-12 Jackson Louisiana 22049 2800 64
1908742 1908742 2021-11-12 Jefferson Louisiana 22051 69968 1177
1908743 1908743 2021-11-12 Jefferson Davis Louisiana 22053 4760 128
1908744 1908744 2021-11-12 LaSalle Louisiana 22059 2742 46
1908745 1908745 2021-11-12 Lafayette Louisiana 22055 39269 404
1908746 1908746 2021-11-12 Lafourche Louisiana 22057 18047 315
1908747 1908747 2021-11-12 Lincoln Louisiana 22061 7131 116
1908748 1908748 2021-11-12 Livingston Louisiana 22063 24629 381
1908749 1908749 2021-11-12 Madison Louisiana 22065 2254 53
1908750 1908750 2021-11-12 Morehouse Louisiana 22067 4493 116
1908751 1908751 2021-11-12 Natchitoches Louisiana 22069 6687 135
1908752 1908752 2021-11-12 Orleans Louisiana 22071 47173 998
1908753 1908753 2021-11-12 Ouachita Louisiana 22073 31765 591
1908754 1908754 2021-11-12 Plaquemines Louisiana 22075 4015 40
1908755 1908755 2021-11-12 Pointe Coupee Louisiana 22077 3960 83
1908756 1908756 2021-11-12 Rapides Louisiana 22079 21374 470
1908757 1908757 2021-11-12 Red River Louisiana 22081 1407 49
1908758 1908758 2021-11-12 Richland Louisiana 22083 4338 79
1908759 1908759 2021-11-12 Sabine Louisiana 22085 4535 93
1908760 1908760 2021-11-12 St. Bernard Louisiana 22087 6943 98
1908761 1908761 2021-11-12 St. Charles Louisiana 22089 8921 127
1908762 1908762 2021-11-12 St. Helena Louisiana 22091 1264 18
1908763 1908763 2021-11-12 St. James Louisiana 22093 3539 70
1908764 1908764 2021-11-12 St. John the Baptist Louisiana 22095 6338 171
1908765 1908765 2021-11-12 St. Landry Louisiana 22097 14258 347
1908766 1908766 2021-11-12 St. Martin Louisiana 22099 8452 161
1908767 1908767 2021-11-12 St. Mary Louisiana 22101 8558 223
1908768 1908768 2021-11-12 St. Tammany Louisiana 22103 43919 730
1908769 1908769 2021-11-12 Tangipahoa Louisiana 22105 22871 518
1908770 1908770 2021-11-12 Tensas Louisiana 22107 533 9
1908771 1908771 2021-11-12 Terrebonne Louisiana 22109 19527 352
1908772 1908772 2021-11-12 Union Louisiana 22111 4063 106
1908773 1908773 2021-11-12 Unknown Louisiana   582 0
1908774 1908774 2021-11-12 Vermilion Louisiana 22113 10296 191
1908775 1908775 2021-11-12 Vernon Louisiana 22115 6403 162
1908776 1908776 2021-11-12 Washington Louisiana 22117 8033 217
1908777 1908777 2021-11-12 Webster Louisiana 22119 6679 148
1908778 1908778 2021-11-12 West Baton Rouge Louisiana 22121 4409 77
1908779 1908779 2021-11-12 West Carroll Louisiana 22123 2041 50
1908780 1908780 2021-11-12 West Feliciana Louisiana 22125 1512 41
1908781 1908781 2021-11-12 Winn Louisiana 22127 2641 58

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