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 2022-04-21 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
2429052 2429052 2022-04-21 Acadia Louisiana 22001 15878 292
2429053 2429053 2022-04-21 Allen Louisiana 22003 7874 137
2429054 2429054 2022-04-21 Ascension Louisiana 22005 34843 293
2429055 2429055 2022-04-21 Assumption Louisiana 22007 5560 70
2429056 2429056 2022-04-21 Avoyelles Louisiana 22009 11581 207
2429057 2429057 2022-04-21 Beauregard Louisiana 22011 9253 142
2429058 2429058 2022-04-21 Bienville Louisiana 22013 3979 110
2429059 2429059 2022-04-21 Bossier Louisiana 22015 37520 492
2429060 2429060 2022-04-21 Caddo Louisiana 22017 67286 1146
2429061 2429061 2022-04-21 Calcasieu Louisiana 22019 54683 705
2429062 2429062 2022-04-21 Caldwell Louisiana 22021 3599 55
2429063 2429063 2022-04-21 Cameron Louisiana 22023 1198 8
2429064 2429064 2022-04-21 Catahoula Louisiana 22025 2694 55
2429065 2429065 2022-04-21 Claiborne Louisiana 22027 3279 76
2429066 2429066 2022-04-21 Concordia Louisiana 22029 5094 89
2429067 2429067 2022-04-21 De Soto Louisiana 22031 7329 135
2429068 2429068 2022-04-21 East Baton Rouge Louisiana 22033 110933 1343
2429069 2429069 2022-04-21 East Carroll Louisiana 22035 2537 38
2429070 2429070 2022-04-21 East Feliciana Louisiana 22037 7307 170
2429071 2429071 2022-04-21 Evangeline Louisiana 22039 8387 158
2429072 2429072 2022-04-21 Franklin Louisiana 22041 7344 178
2429073 2429073 2022-04-21 Grant Louisiana 22043 5855 94
2429074 2429074 2022-04-21 Iberia Louisiana 22045 19063 264
2429075 2429075 2022-04-21 Iberville Louisiana 22047 8990 153
2429076 2429076 2022-04-21 Jackson Louisiana 22049 4396 75
2429077 2429077 2022-04-21 Jefferson Louisiana 22051 113902 1336
2429078 2429078 2022-04-21 Jefferson Davis Louisiana 22053 6935 157
2429079 2429079 2022-04-21 LaSalle Louisiana 22059 4251 59
2429080 2429080 2022-04-21 Lafayette Louisiana 22055 62584 500
2429081 2429081 2022-04-21 Lafourche Louisiana 22057 27768 368
2429082 2429082 2022-04-21 Lincoln Louisiana 22061 12219 145
2429083 2429083 2022-04-21 Livingston Louisiana 22063 37120 463
2429084 2429084 2022-04-21 Madison Louisiana 22065 3256 59
2429085 2429085 2022-04-21 Morehouse Louisiana 22067 6852 134
2429086 2429086 2022-04-21 Natchitoches Louisiana 22069 10118 166
2429087 2429087 2022-04-21 Orleans Louisiana 22071 88083 1107
2429088 2429088 2022-04-21 Ouachita Louisiana 22073 50602 748
2429089 2429089 2022-04-21 Plaquemines Louisiana 22075 6436 45
2429090 2429090 2022-04-21 Pointe Coupee Louisiana 22077 6274 93
2429091 2429091 2022-04-21 Rapides Louisiana 22079 32730 575
2429092 2429092 2022-04-21 Red River Louisiana 22081 2109 53
2429093 2429093 2022-04-21 Richland Louisiana 22083 6720 96
2429094 2429094 2022-04-21 Sabine Louisiana 22085 6333 111
2429095 2429095 2022-04-21 St. Bernard Louisiana 22087 11267 111
2429096 2429096 2022-04-21 St. Charles Louisiana 22089 13823 145
2429097 2429097 2022-04-21 St. Helena Louisiana 22091 1913 23
2429098 2429098 2022-04-21 St. James Louisiana 22093 5776 77
2429099 2429099 2022-04-21 St. John the Baptist Louisiana 22095 10526 184
2429100 2429100 2022-04-21 St. Landry Louisiana 22097 22204 416
2429101 2429101 2022-04-21 St. Martin Louisiana 22099 12949 186
2429102 2429102 2022-04-21 St. Mary Louisiana 22101 12489 262
2429103 2429103 2022-04-21 St. Tammany Louisiana 22103 72262 849
2429104 2429104 2022-04-21 Tangipahoa Louisiana 22105 34713 597
2429105 2429105 2022-04-21 Tensas Louisiana 22107 987 11
2429106 2429106 2022-04-21 Terrebonne Louisiana 22109 30865 416
2429107 2429107 2022-04-21 Union Louisiana 22111 6914 133
2429108 2429108 2022-04-21 Unknown Louisiana   980 0
2429109 2429109 2022-04-21 Vermilion Louisiana 22113 15296 223
2429110 2429110 2022-04-21 Vernon Louisiana 22115 9932 191
2429111 2429111 2022-04-21 Washington Louisiana 22117 12948 248
2429112 2429112 2022-04-21 Webster Louisiana 22119 11100 184
2429113 2429113 2022-04-21 West Baton Rouge Louisiana 22121 7304 90
2429114 2429114 2022-04-21 West Carroll Louisiana 22123 3625 65
2429115 2429115 2022-04-21 West Feliciana Louisiana 22125 2831 46
2429116 2429116 2022-04-21 Winn Louisiana 22127 4435 63

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