ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where deaths = 199 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 8
- Washington 11
- Iberia 5
- Bossier 4
- Avoyelles 3
- Vermilion 3
- Rapides 2
- Acadia 1
- East Baton Rouge 1
state 1
- Louisiana · 30 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2233862 | 2233862 | 2022-02-20 | Avoyelles | Louisiana | 22009 | 11511 | 199 |
2230611 | 2230611 | 2022-02-19 | Avoyelles | Louisiana | 22009 | 11511 | 199 |
2227360 | 2227360 | 2022-02-18 | Avoyelles | Louisiana | 22009 | 11511 | 199 |
2142837 | 2142837 | 2022-01-23 | Vermilion | Louisiana | 22113 | 13079 | 199 |
2139582 | 2139582 | 2022-01-22 | Vermilion | Louisiana | 22113 | 13079 | 199 |
2136326 | 2136326 | 2022-01-21 | Vermilion | Louisiana | 22113 | 13079 | 199 |
1778806 | 1778806 | 2021-10-03 | Washington | Louisiana | 22117 | 7829 | 199 |
1775556 | 1775556 | 2021-10-02 | Washington | Louisiana | 22117 | 7829 | 199 |
1772306 | 1772306 | 2021-10-01 | Washington | Louisiana | 22117 | 7829 | 199 |
1769057 | 1769057 | 2021-09-30 | Washington | Louisiana | 22117 | 7819 | 199 |
1765808 | 1765808 | 2021-09-29 | Washington | Louisiana | 22117 | 7805 | 199 |
1762559 | 1762559 | 2021-09-28 | Washington | Louisiana | 22117 | 7788 | 199 |
1759311 | 1759311 | 2021-09-27 | Washington | Louisiana | 22117 | 7786 | 199 |
1756063 | 1756063 | 2021-09-26 | Washington | Louisiana | 22117 | 7753 | 199 |
1752815 | 1752815 | 2021-09-25 | Washington | Louisiana | 22117 | 7753 | 199 |
1749566 | 1749566 | 2021-09-24 | Washington | Louisiana | 22117 | 7753 | 199 |
1746316 | 1746316 | 2021-09-23 | Washington | Louisiana | 22117 | 7748 | 199 |
1694301 | 1694301 | 2021-09-07 | Iberia | Louisiana | 22045 | 11700 | 199 |
1691052 | 1691052 | 2021-09-06 | Iberia | Louisiana | 22045 | 11586 | 199 |
1687802 | 1687802 | 2021-09-05 | Iberia | Louisiana | 22045 | 11586 | 199 |
1684552 | 1684552 | 2021-09-04 | Iberia | Louisiana | 22045 | 11586 | 199 |
1681301 | 1681301 | 2021-09-03 | Iberia | Louisiana | 22045 | 11586 | 199 |
1554596 | 1554596 | 2021-07-26 | Acadia | Louisiana | 22001 | 7168 | 199 |
892357 | 892357 | 2021-01-03 | Bossier | Louisiana | 22015 | 9144 | 199 |
889111 | 889111 | 2021-01-02 | Bossier | Louisiana | 22015 | 8979 | 199 |
885865 | 885865 | 2021-01-01 | Bossier | Louisiana | 22015 | 8979 | 199 |
882620 | 882620 | 2020-12-31 | Bossier | Louisiana | 22015 | 8979 | 199 |
820989 | 820989 | 2020-12-12 | Rapides | Louisiana | 22079 | 7007 | 199 |
817743 | 817743 | 2020-12-11 | Rapides | Louisiana | 22079 | 7007 | 199 |
140281 | 140281 | 2020-05-13 | East Baton Rouge | Louisiana | 22033 | 2487 | 199 |
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);