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

37,252 rows where state = "Louisiana" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

state

  • Louisiana · 37,252 ✖
Link rowid date ▲ county state fips cases deaths
1817736 1817736 2021-10-15 Acadia Louisiana 22001 10379 249
1817737 1817737 2021-10-15 Allen Louisiana 22003 4672 112
1817738 1817738 2021-10-15 Ascension Louisiana 22005 21640 235
1817739 1817739 2021-10-15 Assumption Louisiana 22007 3619 57
1817740 1817740 2021-10-15 Avoyelles Louisiana 22009 7036 177
1817741 1817741 2021-10-15 Beauregard Louisiana 22011 6026 122
1817742 1817742 2021-10-15 Bienville Louisiana 22013 2474 95
1817743 1817743 2021-10-15 Bossier Louisiana 22015 21522 397
1817744 1817744 2021-10-15 Caddo Louisiana 22017 39076 938
1817745 1817745 2021-10-15 Calcasieu Louisiana 22019 34107 602
1817746 1817746 2021-10-15 Caldwell Louisiana 22021 2212 38
1817747 1817747 2021-10-15 Cameron Louisiana 22023 857 9
1817748 1817748 2021-10-15 Catahoula Louisiana 22025 1775 48
1817749 1817749 2021-10-15 Claiborne Louisiana 22027 1998 63
1817750 1817750 2021-10-15 Concordia Louisiana 22029 3185 77
1817751 1817751 2021-10-15 De Soto Louisiana 22031 4701 107
1817752 1817752 2021-10-15 East Baton Rouge Louisiana 22033 63370 1147
1817753 1817753 2021-10-15 East Carroll Louisiana 22035 1587 30
1817754 1817754 2021-10-15 East Feliciana Louisiana 22037 4459 142
1817755 1817755 2021-10-15 Evangeline Louisiana 22039 5744 139
1817756 1817756 2021-10-15 Franklin Louisiana 22041 4646 137
1817757 1817757 2021-10-15 Grant Louisiana 22043 3794 77
1817758 1817758 2021-10-15 Iberia Louisiana 22045 12346 223
1817759 1817759 2021-10-15 Iberville Louisiana 22047 5782 122
1817760 1817760 2021-10-15 Jackson Louisiana 22049 2747 63
1817761 1817761 2021-10-15 Jefferson Louisiana 22051 69122 1150
1817762 1817762 2021-10-15 Jefferson Davis Louisiana 22053 4676 124
1817763 1817763 2021-10-15 LaSalle Louisiana 22059 2698 45
1817764 1817764 2021-10-15 Lafayette Louisiana 22055 38387 399
1817765 1817765 2021-10-15 Lafourche Louisiana 22057 17754 306
1817766 1817766 2021-10-15 Lincoln Louisiana 22061 7001 115
1817767 1817767 2021-10-15 Livingston Louisiana 22063 24327 369
1817768 1817768 2021-10-15 Madison Louisiana 22065 2219 52
1817769 1817769 2021-10-15 Morehouse Louisiana 22067 4418 114
1817770 1817770 2021-10-15 Natchitoches Louisiana 22069 6540 133
1817771 1817771 2021-10-15 Orleans Louisiana 22071 46408 985
1817772 1817772 2021-10-15 Ouachita Louisiana 22073 31224 578
1817773 1817773 2021-10-15 Plaquemines Louisiana 22075 3803 38
1817774 1817774 2021-10-15 Pointe Coupee Louisiana 22077 3825 83
1817775 1817775 2021-10-15 Rapides Louisiana 22079 21022 455
1817776 1817776 2021-10-15 Red River Louisiana 22081 1397 48
1817777 1817777 2021-10-15 Richland Louisiana 22083 4269 77
1817778 1817778 2021-10-15 Sabine Louisiana 22085 4458 86
1817779 1817779 2021-10-15 St. Bernard Louisiana 22087 6852 97
1817780 1817780 2021-10-15 St. Charles Louisiana 22089 8811 124
1817781 1817781 2021-10-15 St. Helena Louisiana 22091 1259 18
1817782 1817782 2021-10-15 St. James Louisiana 22093 3442 70
1817783 1817783 2021-10-15 St. John the Baptist Louisiana 22095 6270 168
1817784 1817784 2021-10-15 St. Landry Louisiana 22097 13904 342
1817785 1817785 2021-10-15 St. Martin Louisiana 22099 8331 160
1817786 1817786 2021-10-15 St. Mary Louisiana 22101 8498 217
1817787 1817787 2021-10-15 St. Tammany Louisiana 22103 43240 710
1817788 1817788 2021-10-15 Tangipahoa Louisiana 22105 22581 497
1817789 1817789 2021-10-15 Tensas Louisiana 22107 516 8
1817790 1817790 2021-10-15 Terrebonne Louisiana 22109 19243 329
1817791 1817791 2021-10-15 Union Louisiana 22111 3954 103
1817792 1817792 2021-10-15 Unknown Louisiana   575 0
1817793 1817793 2021-10-15 Vermilion Louisiana 22113 10090 184
1817794 1817794 2021-10-15 Vernon Louisiana 22115 6196 159
1817795 1817795 2021-10-15 Washington Louisiana 22117 7908 209
1817796 1817796 2021-10-15 Webster Louisiana 22119 6492 146
1817797 1817797 2021-10-15 West Baton Rouge Louisiana 22121 4356 72
1817798 1817798 2021-10-15 West Carroll Louisiana 22123 1941 47
1817799 1817799 2021-10-15 West Feliciana Louisiana 22125 1508 40
1817800 1817800 2021-10-15 Winn Louisiana 22127 2605 58
1814488 1814488 2021-10-14 Acadia Louisiana 22001 10371 249
1814489 1814489 2021-10-14 Allen Louisiana 22003 4669 111
1814490 1814490 2021-10-14 Ascension Louisiana 22005 21632 234
1814491 1814491 2021-10-14 Assumption Louisiana 22007 3615 57
1814492 1814492 2021-10-14 Avoyelles Louisiana 22009 7034 177
1814493 1814493 2021-10-14 Beauregard Louisiana 22011 6024 122
1814494 1814494 2021-10-14 Bienville Louisiana 22013 2472 95
1814495 1814495 2021-10-14 Bossier Louisiana 22015 21506 396
1814496 1814496 2021-10-14 Caddo Louisiana 22017 39027 936
1814497 1814497 2021-10-14 Calcasieu Louisiana 22019 34061 601
1814498 1814498 2021-10-14 Caldwell Louisiana 22021 2209 38
1814499 1814499 2021-10-14 Cameron Louisiana 22023 857 9
1814500 1814500 2021-10-14 Catahoula Louisiana 22025 1774 48
1814501 1814501 2021-10-14 Claiborne Louisiana 22027 1996 63
1814502 1814502 2021-10-14 Concordia Louisiana 22029 3182 77
1814503 1814503 2021-10-14 De Soto Louisiana 22031 4698 107
1814504 1814504 2021-10-14 East Baton Rouge Louisiana 22033 63337 1146
1814505 1814505 2021-10-14 East Carroll Louisiana 22035 1581 30
1814506 1814506 2021-10-14 East Feliciana Louisiana 22037 4459 142
1814507 1814507 2021-10-14 Evangeline Louisiana 22039 5723 139
1814508 1814508 2021-10-14 Franklin Louisiana 22041 4645 136
1814509 1814509 2021-10-14 Grant Louisiana 22043 3792 77
1814510 1814510 2021-10-14 Iberia Louisiana 22045 12342 223
1814511 1814511 2021-10-14 Iberville Louisiana 22047 5777 122
1814512 1814512 2021-10-14 Jackson Louisiana 22049 2746 63
1814513 1814513 2021-10-14 Jefferson Louisiana 22051 69076 1149
1814514 1814514 2021-10-14 Jefferson Davis Louisiana 22053 4671 124
1814515 1814515 2021-10-14 LaSalle Louisiana 22059 2697 45
1814516 1814516 2021-10-14 Lafayette Louisiana 22055 38362 398
1814517 1814517 2021-10-14 Lafourche Louisiana 22057 17749 305
1814518 1814518 2021-10-14 Lincoln Louisiana 22061 6998 115
1814519 1814519 2021-10-14 Livingston Louisiana 22063 24317 369
1814520 1814520 2021-10-14 Madison Louisiana 22065 2216 52
1814521 1814521 2021-10-14 Morehouse Louisiana 22067 4417 114
1814522 1814522 2021-10-14 Natchitoches Louisiana 22069 6535 133

Next page

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