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-07-07 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
1492904 1492904 2021-07-07 Acadia Louisiana 22001 6848 197
1492905 1492905 2021-07-07 Allen Louisiana 22003 3282 92
1492906 1492906 2021-07-07 Ascension Louisiana 22005 13090 169
1492907 1492907 2021-07-07 Assumption Louisiana 22007 2350 36
1492908 1492908 2021-07-07 Avoyelles Louisiana 22009 4373 125
1492909 1492909 2021-07-07 Beauregard Louisiana 22011 3349 79
1492910 1492910 2021-07-07 Bienville Louisiana 22013 1717 84
1492911 1492911 2021-07-07 Bossier Louisiana 22015 14569 310
1492912 1492912 2021-07-07 Caddo Louisiana 22017 27371 763
1492913 1492913 2021-07-07 Calcasieu Louisiana 22019 23387 456
1492914 1492914 2021-07-07 Caldwell Louisiana 22021 1142 29
1492915 1492915 2021-07-07 Cameron Louisiana 22023 635 7
1492916 1492916 2021-07-07 Catahoula Louisiana 22025 1196 38
1492917 1492917 2021-07-07 Claiborne Louisiana 22027 1486 55
1492918 1492918 2021-07-07 Concordia Louisiana 22029 1932 62
1492919 1492919 2021-07-07 De Soto Louisiana 22031 2914 78
1492920 1492920 2021-07-07 East Baton Rouge Louisiana 22033 41595 843
1492921 1492921 2021-07-07 East Carroll Louisiana 22035 1144 27
1492922 1492922 2021-07-07 East Feliciana Louisiana 22037 3286 115
1492923 1492923 2021-07-07 Evangeline Louisiana 22039 3715 99
1492924 1492924 2021-07-07 Franklin Louisiana 22041 2844 107
1492925 1492925 2021-07-07 Grant Louisiana 22043 2282 58
1492926 1492926 2021-07-07 Iberia Louisiana 22045 7513 161
1492927 1492927 2021-07-07 Iberville Louisiana 22047 3988 100
1492928 1492928 2021-07-07 Jackson Louisiana 22049 2088 52
1492929 1492929 2021-07-07 Jefferson Louisiana 22051 47877 911
1492930 1492930 2021-07-07 Jefferson Davis Louisiana 22053 3259 97
1492931 1492931 2021-07-07 LaSalle Louisiana 22059 1719 37
1492932 1492932 2021-07-07 Lafayette Louisiana 22055 24815 294
1492933 1492933 2021-07-07 Lafourche Louisiana 22057 10353 205
1492934 1492934 2021-07-07 Lincoln Louisiana 22061 4754 94
1492935 1492935 2021-07-07 Livingston Louisiana 22063 14659 212
1492936 1492936 2021-07-07 Madison Louisiana 22065 1582 40
1492937 1492937 2021-07-07 Morehouse Louisiana 22067 2891 78
1492938 1492938 2021-07-07 Natchitoches Louisiana 22069 4183 95
1492939 1492939 2021-07-07 Orleans Louisiana 22071 31302 805
1492940 1492940 2021-07-07 Ouachita Louisiana 22073 19201 466
1492941 1492941 2021-07-07 Plaquemines Louisiana 22075 2579 27
1492942 1492942 2021-07-07 Pointe Coupee Louisiana 22077 2752 75
1492943 1492943 2021-07-07 Rapides Louisiana 22079 12827 328
1492944 1492944 2021-07-07 Red River Louisiana 22081 911 38
1492945 1492945 2021-07-07 Richland Louisiana 22083 2554 57
1492946 1492946 2021-07-07 Sabine Louisiana 22085 3016 64
1492947 1492947 2021-07-07 St. Bernard Louisiana 22087 4182 54
1492948 1492948 2021-07-07 St. Charles Louisiana 22089 5722 98
1492949 1492949 2021-07-07 St. Helena Louisiana 22091 996 12
1492950 1492950 2021-07-07 St. James Louisiana 22093 2056 51
1492951 1492951 2021-07-07 St. John the Baptist Louisiana 22095 3916 141
1492952 1492952 2021-07-07 St. Landry Louisiana 22097 9251 262
1492953 1492953 2021-07-07 St. Martin Louisiana 22099 5646 118
1492954 1492954 2021-07-07 St. Mary Louisiana 22101 5189 143
1492955 1492955 2021-07-07 St. Tammany Louisiana 22103 26781 530
1492956 1492956 2021-07-07 Tangipahoa Louisiana 22105 13434 308
1492957 1492957 2021-07-07 Tensas Louisiana 22107 372 8
1492958 1492958 2021-07-07 Terrebonne Louisiana 22109 11107 228
1492959 1492959 2021-07-07 Union Louisiana 22111 2478 81
1492960 1492960 2021-07-07 Unknown Louisiana   386 0
1492961 1492961 2021-07-07 Vermilion Louisiana 22113 5832 126
1492962 1492962 2021-07-07 Vernon Louisiana 22115 3245 106
1492963 1492963 2021-07-07 Washington Louisiana 22117 4540 134
1492964 1492964 2021-07-07 Webster Louisiana 22119 4300 115
1492965 1492965 2021-07-07 West Baton Rouge Louisiana 22121 3027 63
1492966 1492966 2021-07-07 West Carroll Louisiana 22123 1201 41
1492967 1492967 2021-07-07 West Feliciana Louisiana 22125 1216 34
1492968 1492968 2021-07-07 Winn Louisiana 22127 1596 47

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