ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 22055 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947746 | 1947746 | 2021-11-24 | Lafayette | Louisiana | 22055 | 39507 | 407 |
1944495 | 1944495 | 2021-11-23 | Lafayette | Louisiana | 22055 | 39497 | 406 |
1941245 | 1941245 | 2021-11-22 | Lafayette | Louisiana | 22055 | 39442 | 406 |
1937995 | 1937995 | 2021-11-21 | Lafayette | Louisiana | 22055 | 39415 | 406 |
1934745 | 1934745 | 2021-11-20 | Lafayette | Louisiana | 22055 | 39415 | 406 |
1931494 | 1931494 | 2021-11-19 | Lafayette | Louisiana | 22055 | 39415 | 406 |
1928243 | 1928243 | 2021-11-18 | Lafayette | Louisiana | 22055 | 39399 | 406 |
1924993 | 1924993 | 2021-11-17 | Lafayette | Louisiana | 22055 | 39377 | 406 |
1921744 | 1921744 | 2021-11-16 | Lafayette | Louisiana | 22055 | 39350 | 405 |
1918494 | 1918494 | 2021-11-15 | Lafayette | Louisiana | 22055 | 39322 | 405 |
1915244 | 1915244 | 2021-11-14 | Lafayette | Louisiana | 22055 | 39269 | 404 |
1911994 | 1911994 | 2021-11-13 | Lafayette | Louisiana | 22055 | 39269 | 404 |
1908745 | 1908745 | 2021-11-12 | Lafayette | Louisiana | 22055 | 39269 | 404 |
1905496 | 1905496 | 2021-11-11 | Lafayette | Louisiana | 22055 | 39246 | 404 |
1902246 | 1902246 | 2021-11-10 | Lafayette | Louisiana | 22055 | 39246 | 404 |
1898996 | 1898996 | 2021-11-09 | Lafayette | Louisiana | 22055 | 39225 | 404 |
1895746 | 1895746 | 2021-11-08 | Lafayette | Louisiana | 22055 | 39193 | 404 |
1892496 | 1892496 | 2021-11-07 | Lafayette | Louisiana | 22055 | 39163 | 404 |
1889246 | 1889246 | 2021-11-06 | Lafayette | Louisiana | 22055 | 39163 | 404 |
1885996 | 1885996 | 2021-11-05 | Lafayette | Louisiana | 22055 | 39163 | 404 |
1882747 | 1882747 | 2021-11-04 | Lafayette | Louisiana | 22055 | 39156 | 403 |
1879498 | 1879498 | 2021-11-03 | Lafayette | Louisiana | 22055 | 39109 | 403 |
1876249 | 1876249 | 2021-11-02 | Lafayette | Louisiana | 22055 | 39089 | 403 |
1873000 | 1873000 | 2021-11-01 | Lafayette | Louisiana | 22055 | 39080 | 403 |
1869751 | 1869751 | 2021-10-31 | Lafayette | Louisiana | 22055 | 38883 | 403 |
1866502 | 1866502 | 2021-10-30 | Lafayette | Louisiana | 22055 | 38883 | 403 |
1863253 | 1863253 | 2021-10-29 | Lafayette | Louisiana | 22055 | 38883 | 403 |
1860004 | 1860004 | 2021-10-28 | Lafayette | Louisiana | 22055 | 38875 | 403 |
1856755 | 1856755 | 2021-10-27 | Lafayette | Louisiana | 22055 | 38848 | 401 |
1853506 | 1853506 | 2021-10-26 | Lafayette | Louisiana | 22055 | 38746 | 401 |
1850257 | 1850257 | 2021-10-25 | Lafayette | Louisiana | 22055 | 38723 | 401 |
1847007 | 1847007 | 2021-10-24 | Lafayette | Louisiana | 22055 | 38681 | 401 |
1843757 | 1843757 | 2021-10-23 | Lafayette | Louisiana | 22055 | 38681 | 401 |
1840507 | 1840507 | 2021-10-22 | Lafayette | Louisiana | 22055 | 38681 | 401 |
1837258 | 1837258 | 2021-10-21 | Lafayette | Louisiana | 22055 | 38623 | 400 |
1834009 | 1834009 | 2021-10-20 | Lafayette | Louisiana | 22055 | 38538 | 400 |
1830760 | 1830760 | 2021-10-19 | Lafayette | Louisiana | 22055 | 38522 | 399 |
1827511 | 1827511 | 2021-10-18 | Lafayette | Louisiana | 22055 | 38453 | 399 |
1824262 | 1824262 | 2021-10-17 | Lafayette | Louisiana | 22055 | 38387 | 399 |
1821013 | 1821013 | 2021-10-16 | Lafayette | Louisiana | 22055 | 38387 | 399 |
1817764 | 1817764 | 2021-10-15 | Lafayette | Louisiana | 22055 | 38387 | 399 |
1814516 | 1814516 | 2021-10-14 | Lafayette | Louisiana | 22055 | 38362 | 398 |
1811267 | 1811267 | 2021-10-13 | Lafayette | Louisiana | 22055 | 38326 | 397 |
1808018 | 1808018 | 2021-10-12 | Lafayette | Louisiana | 22055 | 38307 | 397 |
1804767 | 1804767 | 2021-10-11 | Lafayette | Louisiana | 22055 | 38225 | 396 |
1801518 | 1801518 | 2021-10-10 | Lafayette | Louisiana | 22055 | 38169 | 395 |
1798269 | 1798269 | 2021-10-09 | Lafayette | Louisiana | 22055 | 38169 | 395 |
1795020 | 1795020 | 2021-10-08 | Lafayette | Louisiana | 22055 | 38169 | 395 |
1791772 | 1791772 | 2021-10-07 | Lafayette | Louisiana | 22055 | 38140 | 393 |
1788523 | 1788523 | 2021-10-06 | Lafayette | Louisiana | 22055 | 38059 | 391 |
1785274 | 1785274 | 2021-10-05 | Lafayette | Louisiana | 22055 | 38030 | 391 |
1782025 | 1782025 | 2021-10-04 | Lafayette | Louisiana | 22055 | 37969 | 388 |
1778775 | 1778775 | 2021-10-03 | Lafayette | Louisiana | 22055 | 37904 | 387 |
1775525 | 1775525 | 2021-10-02 | Lafayette | Louisiana | 22055 | 37904 | 387 |
1772275 | 1772275 | 2021-10-01 | Lafayette | Louisiana | 22055 | 37904 | 387 |
1769026 | 1769026 | 2021-09-30 | Lafayette | Louisiana | 22055 | 37829 | 387 |
1765777 | 1765777 | 2021-09-29 | Lafayette | Louisiana | 22055 | 37809 | 387 |
1762528 | 1762528 | 2021-09-28 | Lafayette | Louisiana | 22055 | 37779 | 387 |
1759280 | 1759280 | 2021-09-27 | Lafayette | Louisiana | 22055 | 37738 | 386 |
1756032 | 1756032 | 2021-09-26 | Lafayette | Louisiana | 22055 | 37619 | 385 |
1752784 | 1752784 | 2021-09-25 | Lafayette | Louisiana | 22055 | 37619 | 385 |
1749535 | 1749535 | 2021-09-24 | Lafayette | Louisiana | 22055 | 37619 | 385 |
1746285 | 1746285 | 2021-09-23 | Lafayette | Louisiana | 22055 | 37566 | 385 |
1743036 | 1743036 | 2021-09-22 | Lafayette | Louisiana | 22055 | 37522 | 384 |
1739787 | 1739787 | 2021-09-21 | Lafayette | Louisiana | 22055 | 37440 | 385 |
1736538 | 1736538 | 2021-09-20 | Lafayette | Louisiana | 22055 | 37391 | 378 |
1733288 | 1733288 | 2021-09-19 | Lafayette | Louisiana | 22055 | 37245 | 378 |
1730038 | 1730038 | 2021-09-18 | Lafayette | Louisiana | 22055 | 37245 | 378 |
1726788 | 1726788 | 2021-09-17 | Lafayette | Louisiana | 22055 | 37245 | 378 |
1723539 | 1723539 | 2021-09-16 | Lafayette | Louisiana | 22055 | 37101 | 378 |
1720290 | 1720290 | 2021-09-15 | Lafayette | Louisiana | 22055 | 37065 | 378 |
1717042 | 1717042 | 2021-09-14 | Lafayette | Louisiana | 22055 | 36957 | 376 |
1713796 | 1713796 | 2021-09-13 | Lafayette | Louisiana | 22055 | 36838 | 374 |
1710549 | 1710549 | 2021-09-12 | Lafayette | Louisiana | 22055 | 36583 | 371 |
1707302 | 1707302 | 2021-09-11 | Lafayette | Louisiana | 22055 | 36583 | 371 |
1704054 | 1704054 | 2021-09-10 | Lafayette | Louisiana | 22055 | 36583 | 371 |
1700804 | 1700804 | 2021-09-09 | Lafayette | Louisiana | 22055 | 36501 | 372 |
1697555 | 1697555 | 2021-09-08 | Lafayette | Louisiana | 22055 | 36162 | 368 |
1694307 | 1694307 | 2021-09-07 | Lafayette | Louisiana | 22055 | 36023 | 363 |
1691058 | 1691058 | 2021-09-06 | Lafayette | Louisiana | 22055 | 35669 | 363 |
1687808 | 1687808 | 2021-09-05 | Lafayette | Louisiana | 22055 | 35669 | 363 |
1684558 | 1684558 | 2021-09-04 | Lafayette | Louisiana | 22055 | 35669 | 363 |
1681307 | 1681307 | 2021-09-03 | Lafayette | Louisiana | 22055 | 35669 | 363 |
1678059 | 1678059 | 2021-09-02 | Lafayette | Louisiana | 22055 | 35530 | 362 |
1674812 | 1674812 | 2021-09-01 | Lafayette | Louisiana | 22055 | 35407 | 360 |
1671563 | 1671563 | 2021-08-31 | Lafayette | Louisiana | 22055 | 34858 | 352 |
1668316 | 1668316 | 2021-08-30 | Lafayette | Louisiana | 22055 | 34858 | 352 |
1665069 | 1665069 | 2021-08-29 | Lafayette | Louisiana | 22055 | 34858 | 352 |
1661821 | 1661821 | 2021-08-28 | Lafayette | Louisiana | 22055 | 34858 | 352 |
1658573 | 1658573 | 2021-08-27 | Lafayette | Louisiana | 22055 | 34858 | 352 |
1655325 | 1655325 | 2021-08-26 | Lafayette | Louisiana | 22055 | 34745 | 351 |
1652078 | 1652078 | 2021-08-25 | Lafayette | Louisiana | 22055 | 34529 | 349 |
1648829 | 1648829 | 2021-08-24 | Lafayette | Louisiana | 22055 | 34255 | 347 |
1645581 | 1645581 | 2021-08-23 | Lafayette | Louisiana | 22055 | 34100 | 340 |
1642332 | 1642332 | 2021-08-22 | Lafayette | Louisiana | 22055 | 33608 | 340 |
1639082 | 1639082 | 2021-08-21 | Lafayette | Louisiana | 22055 | 33608 | 340 |
1635832 | 1635832 | 2021-08-20 | Lafayette | Louisiana | 22055 | 33608 | 340 |
1632582 | 1632582 | 2021-08-19 | Lafayette | Louisiana | 22055 | 33405 | 335 |
1629335 | 1629335 | 2021-08-18 | Lafayette | Louisiana | 22055 | 33104 | 332 |
1626088 | 1626088 | 2021-08-17 | Lafayette | Louisiana | 22055 | 32763 | 330 |
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);