ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where deaths = 197 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
county 9
- Acadia 11
- Lafourche 3
- St. Landry 3
- Iberia 2
- Avoyelles 1
- Calcasieu 1
- Rapides 1
- Tangipahoa 1
- Vermilion 1
state 1
- Louisiana · 24 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2224109 | 2224109 | 2022-02-17 | Avoyelles | Louisiana | 22009 | 11503 | 197 |
2129821 | 2129821 | 2022-01-19 | Vermilion | Louisiana | 22113 | 12808 | 197 |
1678053 | 1678053 | 2021-09-02 | Iberia | Louisiana | 22045 | 11496 | 197 |
1674806 | 1674806 | 2021-09-01 | Iberia | Louisiana | 22045 | 11458 | 197 |
1505889 | 1505889 | 2021-07-11 | Acadia | Louisiana | 22001 | 6869 | 197 |
1502643 | 1502643 | 2021-07-10 | Acadia | Louisiana | 22001 | 6869 | 197 |
1499397 | 1499397 | 2021-07-09 | Acadia | Louisiana | 22001 | 6869 | 197 |
1496150 | 1496150 | 2021-07-08 | Acadia | Louisiana | 22001 | 6858 | 197 |
1492904 | 1492904 | 2021-07-07 | Acadia | Louisiana | 22001 | 6848 | 197 |
1489657 | 1489657 | 2021-07-06 | Acadia | Louisiana | 22001 | 6832 | 197 |
1486410 | 1486410 | 2021-07-05 | Acadia | Louisiana | 22001 | 6819 | 197 |
1483164 | 1483164 | 2021-07-04 | Acadia | Louisiana | 22001 | 6819 | 197 |
1479917 | 1479917 | 2021-07-03 | Acadia | Louisiana | 22001 | 6819 | 197 |
1476671 | 1476671 | 2021-07-02 | Acadia | Louisiana | 22001 | 6819 | 197 |
1473425 | 1473425 | 2021-07-01 | Acadia | Louisiana | 22001 | 6810 | 197 |
1070883 | 1070883 | 2021-02-27 | Lafourche | Louisiana | 22057 | 9102 | 197 |
1067638 | 1067638 | 2021-02-26 | Lafourche | Louisiana | 22057 | 9102 | 197 |
1064393 | 1064393 | 2021-02-25 | Lafourche | Louisiana | 22057 | 9085 | 197 |
918365 | 918365 | 2021-01-11 | Tangipahoa | Louisiana | 22105 | 9697 | 197 |
876171 | 876171 | 2020-12-29 | St. Landry | Louisiana | 22097 | 6365 | 197 |
872926 | 872926 | 2020-12-28 | St. Landry | Louisiana | 22097 | 6340 | 197 |
869681 | 869681 | 2020-12-27 | St. Landry | Louisiana | 22097 | 6325 | 197 |
811252 | 811252 | 2020-12-09 | Rapides | Louisiana | 22079 | 6891 | 197 |
519369 | 519369 | 2020-09-10 | Calcasieu | Louisiana | 22019 | 7580 | 197 |
Advanced export
JSON shape: default, array, newline-delimited
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);