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-05-23 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
1346845 1346845 2021-05-23 Acadia Louisiana 22001 6607 194
1346846 1346846 2021-05-23 Allen Louisiana 22003 3209 92
1346847 1346847 2021-05-23 Ascension Louisiana 22005 12442 166
1346848 1346848 2021-05-23 Assumption Louisiana 22007 2238 36
1346849 1346849 2021-05-23 Avoyelles Louisiana 22009 4246 123
1346850 1346850 2021-05-23 Beauregard Louisiana 22011 3231 78
1346851 1346851 2021-05-23 Bienville Louisiana 22013 1677 82
1346852 1346852 2021-05-23 Bossier Louisiana 22015 14059 303
1346853 1346853 2021-05-23 Caddo Louisiana 22017 26440 745
1346854 1346854 2021-05-23 Calcasieu Louisiana 22019 22710 439
1346855 1346855 2021-05-23 Caldwell Louisiana 22021 1117 29
1346856 1346856 2021-05-23 Cameron Louisiana 22023 605 6
1346857 1346857 2021-05-23 Catahoula Louisiana 22025 1162 38
1346858 1346858 2021-05-23 Claiborne Louisiana 22027 1444 55
1346859 1346859 2021-05-23 Concordia Louisiana 22029 1879 61
1346860 1346860 2021-05-23 De Soto Louisiana 22031 2806 78
1346861 1346861 2021-05-23 East Baton Rouge Louisiana 22033 40049 815
1346862 1346862 2021-05-23 East Carroll Louisiana 22035 1132 26
1346863 1346863 2021-05-23 East Feliciana Louisiana 22037 3192 112
1346864 1346864 2021-05-23 Evangeline Louisiana 22039 3639 93
1346865 1346865 2021-05-23 Franklin Louisiana 22041 2497 106
1346866 1346866 2021-05-23 Grant Louisiana 22043 2186 56
1346867 1346867 2021-05-23 Iberia Louisiana 22045 7213 153
1346868 1346868 2021-05-23 Iberville Louisiana 22047 3859 100
1346869 1346869 2021-05-23 Jackson Louisiana 22049 2002 50
1346870 1346870 2021-05-23 Jefferson Louisiana 22051 46579 896
1346871 1346871 2021-05-23 Jefferson Davis Louisiana 22053 3191 97
1346872 1346872 2021-05-23 LaSalle Louisiana 22059 1582 37
1346873 1346873 2021-05-23 Lafayette Louisiana 22055 23853 280
1346874 1346874 2021-05-23 Lafourche Louisiana 22057 9726 204
1346875 1346875 2021-05-23 Lincoln Louisiana 22061 4558 93
1346876 1346876 2021-05-23 Livingston Louisiana 22063 13601 206
1346877 1346877 2021-05-23 Madison Louisiana 22065 1568 40
1346878 1346878 2021-05-23 Morehouse Louisiana 22067 2844 78
1346879 1346879 2021-05-23 Natchitoches Louisiana 22069 4089 91
1346880 1346880 2021-05-23 Orleans Louisiana 22071 30401 793
1346881 1346881 2021-05-23 Ouachita Louisiana 22073 18667 454
1346882 1346882 2021-05-23 Plaquemines Louisiana 22075 2533 27
1346883 1346883 2021-05-23 Pointe Coupee Louisiana 22077 2670 74
1346884 1346884 2021-05-23 Rapides Louisiana 22079 12358 317
1346885 1346885 2021-05-23 Red River Louisiana 22081 880 38
1346886 1346886 2021-05-23 Richland Louisiana 22083 2462 56
1346887 1346887 2021-05-23 Sabine Louisiana 22085 2963 61
1346888 1346888 2021-05-23 St. Bernard Louisiana 22087 4054 52
1346889 1346889 2021-05-23 St. Charles Louisiana 22089 5479 97
1346890 1346890 2021-05-23 St. Helena Louisiana 22091 941 11
1346891 1346891 2021-05-23 St. James Louisiana 22093 1993 50
1346892 1346892 2021-05-23 St. John the Baptist Louisiana 22095 3764 140
1346893 1346893 2021-05-23 St. Landry Louisiana 22097 8992 258
1346894 1346894 2021-05-23 St. Martin Louisiana 22099 5362 117
1346895 1346895 2021-05-23 St. Mary Louisiana 22101 4784 139
1346896 1346896 2021-05-23 St. Tammany Louisiana 22103 25865 525
1346897 1346897 2021-05-23 Tangipahoa Louisiana 22105 12819 298
1346898 1346898 2021-05-23 Tensas Louisiana 22107 359 8
1346899 1346899 2021-05-23 Terrebonne Louisiana 22109 10422 223
1346900 1346900 2021-05-23 Union Louisiana 22111 2419 79
1346901 1346901 2021-05-23 Unknown Louisiana   410 0
1346902 1346902 2021-05-23 Vermilion Louisiana 22113 5503 119
1346903 1346903 2021-05-23 Vernon Louisiana 22115 3131 103
1346904 1346904 2021-05-23 Washington Louisiana 22117 4393 132
1346905 1346905 2021-05-23 Webster Louisiana 22119 4145 113
1346906 1346906 2021-05-23 West Baton Rouge Louisiana 22121 2905 61
1346907 1346907 2021-05-23 West Carroll Louisiana 22123 1180 41
1346908 1346908 2021-05-23 West Feliciana Louisiana 22125 1165 34
1346909 1346909 2021-05-23 Winn Louisiana 22127 1564 44

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