ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 22097 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717062 | 1717062 | 2021-09-14 | St. Landry | Louisiana | 22097 | 13226 | 317 |
1713816 | 1713816 | 2021-09-13 | St. Landry | Louisiana | 22097 | 13208 | 313 |
1710569 | 1710569 | 2021-09-12 | St. Landry | Louisiana | 22097 | 13083 | 313 |
1707322 | 1707322 | 2021-09-11 | St. Landry | Louisiana | 22097 | 13083 | 313 |
1704074 | 1704074 | 2021-09-10 | St. Landry | Louisiana | 22097 | 13083 | 313 |
1700824 | 1700824 | 2021-09-09 | St. Landry | Louisiana | 22097 | 13065 | 313 |
1697575 | 1697575 | 2021-09-08 | St. Landry | Louisiana | 22097 | 12966 | 312 |
1694327 | 1694327 | 2021-09-07 | St. Landry | Louisiana | 22097 | 12874 | 309 |
1691078 | 1691078 | 2021-09-06 | St. Landry | Louisiana | 22097 | 12746 | 309 |
1687828 | 1687828 | 2021-09-05 | St. Landry | Louisiana | 22097 | 12746 | 309 |
1684578 | 1684578 | 2021-09-04 | St. Landry | Louisiana | 22097 | 12746 | 309 |
1681327 | 1681327 | 2021-09-03 | St. Landry | Louisiana | 22097 | 12746 | 309 |
1678079 | 1678079 | 2021-09-02 | St. Landry | Louisiana | 22097 | 12678 | 309 |
1674832 | 1674832 | 2021-09-01 | St. Landry | Louisiana | 22097 | 12636 | 306 |
1671583 | 1671583 | 2021-08-31 | St. Landry | Louisiana | 22097 | 12418 | 296 |
1668336 | 1668336 | 2021-08-30 | St. Landry | Louisiana | 22097 | 12418 | 296 |
1665089 | 1665089 | 2021-08-29 | St. Landry | Louisiana | 22097 | 12418 | 296 |
1661841 | 1661841 | 2021-08-28 | St. Landry | Louisiana | 22097 | 12418 | 296 |
1658593 | 1658593 | 2021-08-27 | St. Landry | Louisiana | 22097 | 12418 | 296 |
1655345 | 1655345 | 2021-08-26 | St. Landry | Louisiana | 22097 | 12379 | 294 |
1652098 | 1652098 | 2021-08-25 | St. Landry | Louisiana | 22097 | 12258 | 291 |
1648849 | 1648849 | 2021-08-24 | St. Landry | Louisiana | 22097 | 12160 | 289 |
1645601 | 1645601 | 2021-08-23 | St. Landry | Louisiana | 22097 | 12075 | 284 |
1642352 | 1642352 | 2021-08-22 | St. Landry | Louisiana | 22097 | 11901 | 283 |
1639102 | 1639102 | 2021-08-21 | St. Landry | Louisiana | 22097 | 11901 | 283 |
1635852 | 1635852 | 2021-08-20 | St. Landry | Louisiana | 22097 | 11901 | 283 |
1632602 | 1632602 | 2021-08-19 | St. Landry | Louisiana | 22097 | 11814 | 279 |
1629355 | 1629355 | 2021-08-18 | St. Landry | Louisiana | 22097 | 11723 | 277 |
1626108 | 1626108 | 2021-08-17 | St. Landry | Louisiana | 22097 | 11589 | 277 |
1622861 | 1622861 | 2021-08-16 | St. Landry | Louisiana | 22097 | 11545 | 277 |
1619614 | 1619614 | 2021-08-15 | St. Landry | Louisiana | 22097 | 11261 | 277 |
1616366 | 1616366 | 2021-08-14 | St. Landry | Louisiana | 22097 | 11261 | 277 |
1613117 | 1613117 | 2021-08-13 | St. Landry | Louisiana | 22097 | 11261 | 277 |
1609869 | 1609869 | 2021-08-12 | St. Landry | Louisiana | 22097 | 11166 | 276 |
1606620 | 1606620 | 2021-08-11 | St. Landry | Louisiana | 22097 | 11085 | 274 |
1603371 | 1603371 | 2021-08-10 | St. Landry | Louisiana | 22097 | 11038 | 273 |
1600122 | 1600122 | 2021-08-09 | St. Landry | Louisiana | 22097 | 10938 | 271 |
1596874 | 1596874 | 2021-08-08 | St. Landry | Louisiana | 22097 | 10661 | 270 |
1593625 | 1593625 | 2021-08-07 | St. Landry | Louisiana | 22097 | 10661 | 270 |
1590376 | 1590376 | 2021-08-06 | St. Landry | Louisiana | 22097 | 10661 | 270 |
1587127 | 1587127 | 2021-08-05 | St. Landry | Louisiana | 22097 | 10506 | 270 |
1583877 | 1583877 | 2021-08-04 | St. Landry | Louisiana | 22097 | 10437 | 269 |
1580627 | 1580627 | 2021-08-03 | St. Landry | Louisiana | 22097 | 10339 | 269 |
1577378 | 1577378 | 2021-08-02 | St. Landry | Louisiana | 22097 | 10267 | 268 |
1574130 | 1574130 | 2021-08-01 | St. Landry | Louisiana | 22097 | 10098 | 269 |
1570882 | 1570882 | 2021-07-31 | St. Landry | Louisiana | 22097 | 10098 | 269 |
1567634 | 1567634 | 2021-07-30 | St. Landry | Louisiana | 22097 | 10098 | 269 |
1564386 | 1564386 | 2021-07-29 | St. Landry | Louisiana | 22097 | 10004 | 267 |
1561138 | 1561138 | 2021-07-28 | St. Landry | Louisiana | 22097 | 9952 | 267 |
1557891 | 1557891 | 2021-07-27 | St. Landry | Louisiana | 22097 | 9867 | 267 |
1554644 | 1554644 | 2021-07-26 | St. Landry | Louisiana | 22097 | 9795 | 267 |
1551397 | 1551397 | 2021-07-25 | St. Landry | Louisiana | 22097 | 9661 | 266 |
1548150 | 1548150 | 2021-07-24 | St. Landry | Louisiana | 22097 | 9661 | 266 |
1544903 | 1544903 | 2021-07-23 | St. Landry | Louisiana | 22097 | 9661 | 266 |
1541655 | 1541655 | 2021-07-22 | St. Landry | Louisiana | 22097 | 9616 | 266 |
1538408 | 1538408 | 2021-07-21 | St. Landry | Louisiana | 22097 | 9567 | 265 |
1535160 | 1535160 | 2021-07-20 | St. Landry | Louisiana | 22097 | 9492 | 264 |
1531913 | 1531913 | 2021-07-19 | St. Landry | Louisiana | 22097 | 9458 | 263 |
1528666 | 1528666 | 2021-07-18 | St. Landry | Louisiana | 22097 | 9401 | 263 |
1525419 | 1525419 | 2021-07-17 | St. Landry | Louisiana | 22097 | 9401 | 263 |
1522171 | 1522171 | 2021-07-16 | St. Landry | Louisiana | 22097 | 9401 | 263 |
1518923 | 1518923 | 2021-07-15 | St. Landry | Louisiana | 22097 | 9377 | 263 |
1515676 | 1515676 | 2021-07-14 | St. Landry | Louisiana | 22097 | 9354 | 263 |
1512430 | 1512430 | 2021-07-13 | St. Landry | Louisiana | 22097 | 9339 | 263 |
1509183 | 1509183 | 2021-07-12 | St. Landry | Louisiana | 22097 | 9329 | 262 |
1505937 | 1505937 | 2021-07-11 | St. Landry | Louisiana | 22097 | 9283 | 262 |
1502691 | 1502691 | 2021-07-10 | St. Landry | Louisiana | 22097 | 9283 | 262 |
1499445 | 1499445 | 2021-07-09 | St. Landry | Louisiana | 22097 | 9283 | 262 |
1496198 | 1496198 | 2021-07-08 | St. Landry | Louisiana | 22097 | 9261 | 262 |
1492952 | 1492952 | 2021-07-07 | St. Landry | Louisiana | 22097 | 9251 | 262 |
1489705 | 1489705 | 2021-07-06 | St. Landry | Louisiana | 22097 | 9229 | 262 |
1486458 | 1486458 | 2021-07-05 | St. Landry | Louisiana | 22097 | 9223 | 262 |
1483212 | 1483212 | 2021-07-04 | St. Landry | Louisiana | 22097 | 9223 | 262 |
1479965 | 1479965 | 2021-07-03 | St. Landry | Louisiana | 22097 | 9223 | 262 |
1476719 | 1476719 | 2021-07-02 | St. Landry | Louisiana | 22097 | 9223 | 262 |
1473473 | 1473473 | 2021-07-01 | St. Landry | Louisiana | 22097 | 9210 | 262 |
1470227 | 1470227 | 2021-06-30 | St. Landry | Louisiana | 22097 | 9190 | 262 |
1466982 | 1466982 | 2021-06-29 | St. Landry | Louisiana | 22097 | 9184 | 262 |
1463737 | 1463737 | 2021-06-28 | St. Landry | Louisiana | 22097 | 9183 | 262 |
1460492 | 1460492 | 2021-06-27 | St. Landry | Louisiana | 22097 | 9167 | 261 |
1457247 | 1457247 | 2021-06-26 | St. Landry | Louisiana | 22097 | 9167 | 261 |
1454002 | 1454002 | 2021-06-25 | St. Landry | Louisiana | 22097 | 9167 | 261 |
1450756 | 1450756 | 2021-06-24 | St. Landry | Louisiana | 22097 | 9164 | 261 |
1447511 | 1447511 | 2021-06-23 | St. Landry | Louisiana | 22097 | 9162 | 261 |
1444266 | 1444266 | 2021-06-22 | St. Landry | Louisiana | 22097 | 9159 | 261 |
1441021 | 1441021 | 2021-06-21 | St. Landry | Louisiana | 22097 | 9155 | 261 |
1437774 | 1437774 | 2021-06-20 | St. Landry | Louisiana | 22097 | 9151 | 261 |
1434527 | 1434527 | 2021-06-19 | St. Landry | Louisiana | 22097 | 9151 | 261 |
1431281 | 1431281 | 2021-06-18 | St. Landry | Louisiana | 22097 | 9151 | 261 |
1428036 | 1428036 | 2021-06-17 | St. Landry | Louisiana | 22097 | 9141 | 261 |
1424791 | 1424791 | 2021-06-16 | St. Landry | Louisiana | 22097 | 9133 | 261 |
1421543 | 1421543 | 2021-06-15 | St. Landry | Louisiana | 22097 | 9128 | 261 |
1418298 | 1418298 | 2021-06-14 | St. Landry | Louisiana | 22097 | 9118 | 261 |
1415052 | 1415052 | 2021-06-13 | St. Landry | Louisiana | 22097 | 9108 | 261 |
1411807 | 1411807 | 2021-06-12 | St. Landry | Louisiana | 22097 | 9108 | 261 |
1408562 | 1408562 | 2021-06-11 | St. Landry | Louisiana | 22097 | 9108 | 261 |
1405316 | 1405316 | 2021-06-10 | St. Landry | Louisiana | 22097 | 9108 | 261 |
1402071 | 1402071 | 2021-06-09 | St. Landry | Louisiana | 22097 | 9095 | 260 |
1398826 | 1398826 | 2021-06-08 | St. Landry | Louisiana | 22097 | 9081 | 260 |
1395579 | 1395579 | 2021-06-07 | St. Landry | Louisiana | 22097 | 9071 | 260 |
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);