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-24 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
1947718 1947718 2021-11-24 Acadia Louisiana 22001 10623 251
1947719 1947719 2021-11-24 Allen Louisiana 22003 4774 117
1947720 1947720 2021-11-24 Ascension Louisiana 22005 22028 247
1947721 1947721 2021-11-24 Assumption Louisiana 22007 3698 57
1947722 1947722 2021-11-24 Avoyelles Louisiana 22009 7383 181
1947723 1947723 2021-11-24 Beauregard Louisiana 22011 6166 124
1947724 1947724 2021-11-24 Bienville Louisiana 22013 2516 99
1947725 1947725 2021-11-24 Bossier Louisiana 22015 22017 409
1947726 1947726 2021-11-24 Caddo Louisiana 22017 39993 977
1947727 1947727 2021-11-24 Calcasieu Louisiana 22019 34894 624
1947728 1947728 2021-11-24 Caldwell Louisiana 22021 2299 39
1947729 1947729 2021-11-24 Cameron Louisiana 22023 864 9
1947730 1947730 2021-11-24 Catahoula Louisiana 22025 1789 48
1947731 1947731 2021-11-24 Claiborne Louisiana 22027 2030 66
1947732 1947732 2021-11-24 Concordia Louisiana 22029 3249 79
1947733 1947733 2021-11-24 De Soto Louisiana 22031 4822 113
1947734 1947734 2021-11-24 East Baton Rouge Louisiana 22033 64514 1169
1947735 1947735 2021-11-24 East Carroll Louisiana 22035 1647 31
1947736 1947736 2021-11-24 East Feliciana Louisiana 22037 4510 145
1947737 1947737 2021-11-24 Evangeline Louisiana 22039 5904 142
1947738 1947738 2021-11-24 Franklin Louisiana 22041 4768 140
1947739 1947739 2021-11-24 Grant Louisiana 22043 3891 78
1947740 1947740 2021-11-24 Iberia Louisiana 22045 12603 227
1947741 1947741 2021-11-24 Iberville Louisiana 22047 5875 128
1947742 1947742 2021-11-24 Jackson Louisiana 22049 2811 64
1947743 1947743 2021-11-24 Jefferson Louisiana 22051 70252 1180
1947744 1947744 2021-11-24 Jefferson Davis Louisiana 22053 4790 131
1947745 1947745 2021-11-24 LaSalle Louisiana 22059 2781 46
1947746 1947746 2021-11-24 Lafayette Louisiana 22055 39507 407
1947747 1947747 2021-11-24 Lafourche Louisiana 22057 18138 319
1947748 1947748 2021-11-24 Lincoln Louisiana 22061 7214 117
1947749 1947749 2021-11-24 Livingston Louisiana 22063 24751 383
1947750 1947750 2021-11-24 Madison Louisiana 22065 2267 53
1947751 1947751 2021-11-24 Morehouse Louisiana 22067 4529 116
1947752 1947752 2021-11-24 Natchitoches Louisiana 22069 6710 137
1947753 1947753 2021-11-24 Orleans Louisiana 22071 47456 1002
1947754 1947754 2021-11-24 Ouachita Louisiana 22073 32081 597
1947755 1947755 2021-11-24 Plaquemines Louisiana 22075 4030 40
1947756 1947756 2021-11-24 Pointe Coupee Louisiana 22077 3985 84
1947757 1947757 2021-11-24 Rapides Louisiana 22079 21503 474
1947758 1947758 2021-11-24 Red River Louisiana 22081 1415 49
1947759 1947759 2021-11-24 Richland Louisiana 22083 4369 80
1947760 1947760 2021-11-24 Sabine Louisiana 22085 4550 95
1947761 1947761 2021-11-24 St. Bernard Louisiana 22087 7009 98
1947762 1947762 2021-11-24 St. Charles Louisiana 22089 8941 127
1947763 1947763 2021-11-24 St. Helena Louisiana 22091 1264 19
1947764 1947764 2021-11-24 St. James Louisiana 22093 3544 70
1947765 1947765 2021-11-24 St. John the Baptist Louisiana 22095 6368 173
1947766 1947766 2021-11-24 St. Landry Louisiana 22097 14356 349
1947767 1947767 2021-11-24 St. Martin Louisiana 22099 8490 161
1947768 1947768 2021-11-24 St. Mary Louisiana 22101 8584 226
1947769 1947769 2021-11-24 St. Tammany Louisiana 22103 44165 733
1947770 1947770 2021-11-24 Tangipahoa Louisiana 22105 22994 522
1947771 1947771 2021-11-24 Tensas Louisiana 22107 537 10
1947772 1947772 2021-11-24 Terrebonne Louisiana 22109 19647 355
1947773 1947773 2021-11-24 Union Louisiana 22111 4135 107
1947774 1947774 2021-11-24 Unknown Louisiana   584 0
1947775 1947775 2021-11-24 Vermilion Louisiana 22113 10358 193
1947776 1947776 2021-11-24 Vernon Louisiana 22115 6474 163
1947777 1947777 2021-11-24 Washington Louisiana 22117 8171 218
1947778 1947778 2021-11-24 Webster Louisiana 22119 6740 150
1947779 1947779 2021-11-24 West Baton Rouge Louisiana 22121 4436 78
1947780 1947780 2021-11-24 West Carroll Louisiana 22123 2094 52
1947781 1947781 2021-11-24 West Feliciana Louisiana 22125 1512 41
1947782 1947782 2021-11-24 Winn Louisiana 22127 2652 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);