ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "West Baton Rouge" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947779 | 1947779 | 2021-11-24 | West Baton Rouge | Louisiana | 22121 | 4436 | 78 |
1944528 | 1944528 | 2021-11-23 | West Baton Rouge | Louisiana | 22121 | 4433 | 78 |
1941278 | 1941278 | 2021-11-22 | West Baton Rouge | Louisiana | 22121 | 4427 | 77 |
1938028 | 1938028 | 2021-11-21 | West Baton Rouge | Louisiana | 22121 | 4426 | 77 |
1934778 | 1934778 | 2021-11-20 | West Baton Rouge | Louisiana | 22121 | 4426 | 77 |
1931527 | 1931527 | 2021-11-19 | West Baton Rouge | Louisiana | 22121 | 4426 | 77 |
1928276 | 1928276 | 2021-11-18 | West Baton Rouge | Louisiana | 22121 | 4419 | 77 |
1925026 | 1925026 | 2021-11-17 | West Baton Rouge | Louisiana | 22121 | 4418 | 77 |
1921777 | 1921777 | 2021-11-16 | West Baton Rouge | Louisiana | 22121 | 4414 | 77 |
1918527 | 1918527 | 2021-11-15 | West Baton Rouge | Louisiana | 22121 | 4411 | 77 |
1915277 | 1915277 | 2021-11-14 | West Baton Rouge | Louisiana | 22121 | 4409 | 77 |
1912027 | 1912027 | 2021-11-13 | West Baton Rouge | Louisiana | 22121 | 4409 | 77 |
1908778 | 1908778 | 2021-11-12 | West Baton Rouge | Louisiana | 22121 | 4409 | 77 |
1905529 | 1905529 | 2021-11-11 | West Baton Rouge | Louisiana | 22121 | 4407 | 77 |
1902279 | 1902279 | 2021-11-10 | West Baton Rouge | Louisiana | 22121 | 4407 | 77 |
1899029 | 1899029 | 2021-11-09 | West Baton Rouge | Louisiana | 22121 | 4403 | 77 |
1895779 | 1895779 | 2021-11-08 | West Baton Rouge | Louisiana | 22121 | 4400 | 76 |
1892529 | 1892529 | 2021-11-07 | West Baton Rouge | Louisiana | 22121 | 4394 | 75 |
1889279 | 1889279 | 2021-11-06 | West Baton Rouge | Louisiana | 22121 | 4394 | 75 |
1886029 | 1886029 | 2021-11-05 | West Baton Rouge | Louisiana | 22121 | 4394 | 75 |
1882780 | 1882780 | 2021-11-04 | West Baton Rouge | Louisiana | 22121 | 4394 | 75 |
1879531 | 1879531 | 2021-11-03 | West Baton Rouge | Louisiana | 22121 | 4390 | 75 |
1876282 | 1876282 | 2021-11-02 | West Baton Rouge | Louisiana | 22121 | 4390 | 75 |
1873033 | 1873033 | 2021-11-01 | West Baton Rouge | Louisiana | 22121 | 4390 | 75 |
1869784 | 1869784 | 2021-10-31 | West Baton Rouge | Louisiana | 22121 | 4386 | 75 |
1866535 | 1866535 | 2021-10-30 | West Baton Rouge | Louisiana | 22121 | 4386 | 75 |
1863286 | 1863286 | 2021-10-29 | West Baton Rouge | Louisiana | 22121 | 4386 | 75 |
1860037 | 1860037 | 2021-10-28 | West Baton Rouge | Louisiana | 22121 | 4385 | 75 |
1856788 | 1856788 | 2021-10-27 | West Baton Rouge | Louisiana | 22121 | 4383 | 75 |
1853539 | 1853539 | 2021-10-26 | West Baton Rouge | Louisiana | 22121 | 4379 | 75 |
1850290 | 1850290 | 2021-10-25 | West Baton Rouge | Louisiana | 22121 | 4376 | 75 |
1847040 | 1847040 | 2021-10-24 | West Baton Rouge | Louisiana | 22121 | 4374 | 74 |
1843790 | 1843790 | 2021-10-23 | West Baton Rouge | Louisiana | 22121 | 4374 | 74 |
1840540 | 1840540 | 2021-10-22 | West Baton Rouge | Louisiana | 22121 | 4374 | 74 |
1837291 | 1837291 | 2021-10-21 | West Baton Rouge | Louisiana | 22121 | 4366 | 74 |
1834042 | 1834042 | 2021-10-20 | West Baton Rouge | Louisiana | 22121 | 4365 | 73 |
1830793 | 1830793 | 2021-10-19 | West Baton Rouge | Louisiana | 22121 | 4365 | 73 |
1827544 | 1827544 | 2021-10-18 | West Baton Rouge | Louisiana | 22121 | 4358 | 73 |
1824295 | 1824295 | 2021-10-17 | West Baton Rouge | Louisiana | 22121 | 4356 | 72 |
1821046 | 1821046 | 2021-10-16 | West Baton Rouge | Louisiana | 22121 | 4356 | 72 |
1817797 | 1817797 | 2021-10-15 | West Baton Rouge | Louisiana | 22121 | 4356 | 72 |
1814549 | 1814549 | 2021-10-14 | West Baton Rouge | Louisiana | 22121 | 4356 | 72 |
1811300 | 1811300 | 2021-10-13 | West Baton Rouge | Louisiana | 22121 | 4355 | 72 |
1808051 | 1808051 | 2021-10-12 | West Baton Rouge | Louisiana | 22121 | 4351 | 71 |
1804800 | 1804800 | 2021-10-11 | West Baton Rouge | Louisiana | 22121 | 4346 | 71 |
1801551 | 1801551 | 2021-10-10 | West Baton Rouge | Louisiana | 22121 | 4340 | 71 |
1798302 | 1798302 | 2021-10-09 | West Baton Rouge | Louisiana | 22121 | 4340 | 71 |
1795053 | 1795053 | 2021-10-08 | West Baton Rouge | Louisiana | 22121 | 4340 | 71 |
1791805 | 1791805 | 2021-10-07 | West Baton Rouge | Louisiana | 22121 | 4339 | 71 |
1788556 | 1788556 | 2021-10-06 | West Baton Rouge | Louisiana | 22121 | 4337 | 71 |
1785307 | 1785307 | 2021-10-05 | West Baton Rouge | Louisiana | 22121 | 4334 | 71 |
1782058 | 1782058 | 2021-10-04 | West Baton Rouge | Louisiana | 22121 | 4327 | 71 |
1778808 | 1778808 | 2021-10-03 | West Baton Rouge | Louisiana | 22121 | 4321 | 71 |
1775558 | 1775558 | 2021-10-02 | West Baton Rouge | Louisiana | 22121 | 4321 | 71 |
1772308 | 1772308 | 2021-10-01 | West Baton Rouge | Louisiana | 22121 | 4321 | 71 |
1769059 | 1769059 | 2021-09-30 | West Baton Rouge | Louisiana | 22121 | 4317 | 71 |
1765810 | 1765810 | 2021-09-29 | West Baton Rouge | Louisiana | 22121 | 4315 | 71 |
1762561 | 1762561 | 2021-09-28 | West Baton Rouge | Louisiana | 22121 | 4313 | 71 |
1759313 | 1759313 | 2021-09-27 | West Baton Rouge | Louisiana | 22121 | 4311 | 71 |
1756065 | 1756065 | 2021-09-26 | West Baton Rouge | Louisiana | 22121 | 4303 | 71 |
1752817 | 1752817 | 2021-09-25 | West Baton Rouge | Louisiana | 22121 | 4303 | 71 |
1749568 | 1749568 | 2021-09-24 | West Baton Rouge | Louisiana | 22121 | 4303 | 71 |
1746318 | 1746318 | 2021-09-23 | West Baton Rouge | Louisiana | 22121 | 4299 | 71 |
1743069 | 1743069 | 2021-09-22 | West Baton Rouge | Louisiana | 22121 | 4295 | 71 |
1739820 | 1739820 | 2021-09-21 | West Baton Rouge | Louisiana | 22121 | 4283 | 71 |
1736571 | 1736571 | 2021-09-20 | West Baton Rouge | Louisiana | 22121 | 4281 | 71 |
1733321 | 1733321 | 2021-09-19 | West Baton Rouge | Louisiana | 22121 | 4271 | 71 |
1730071 | 1730071 | 2021-09-18 | West Baton Rouge | Louisiana | 22121 | 4271 | 71 |
1726821 | 1726821 | 2021-09-17 | West Baton Rouge | Louisiana | 22121 | 4271 | 71 |
1723572 | 1723572 | 2021-09-16 | West Baton Rouge | Louisiana | 22121 | 4260 | 71 |
1720323 | 1720323 | 2021-09-15 | West Baton Rouge | Louisiana | 22121 | 4254 | 71 |
1717075 | 1717075 | 2021-09-14 | West Baton Rouge | Louisiana | 22121 | 4252 | 71 |
1713828 | 1713828 | 2021-09-13 | West Baton Rouge | Louisiana | 22121 | 4243 | 71 |
1710582 | 1710582 | 2021-09-12 | West Baton Rouge | Louisiana | 22121 | 4237 | 71 |
1707335 | 1707335 | 2021-09-11 | West Baton Rouge | Louisiana | 22121 | 4237 | 71 |
1704087 | 1704087 | 2021-09-10 | West Baton Rouge | Louisiana | 22121 | 4237 | 71 |
1700837 | 1700837 | 2021-09-09 | West Baton Rouge | Louisiana | 22121 | 4233 | 71 |
1697588 | 1697588 | 2021-09-08 | West Baton Rouge | Louisiana | 22121 | 4209 | 71 |
1694340 | 1694340 | 2021-09-07 | West Baton Rouge | Louisiana | 22121 | 4198 | 69 |
1691091 | 1691091 | 2021-09-06 | West Baton Rouge | Louisiana | 22121 | 4187 | 69 |
1687841 | 1687841 | 2021-09-05 | West Baton Rouge | Louisiana | 22121 | 4187 | 69 |
1684591 | 1684591 | 2021-09-04 | West Baton Rouge | Louisiana | 22121 | 4187 | 69 |
1681340 | 1681340 | 2021-09-03 | West Baton Rouge | Louisiana | 22121 | 4187 | 69 |
1678092 | 1678092 | 2021-09-02 | West Baton Rouge | Louisiana | 22121 | 4178 | 69 |
1674845 | 1674845 | 2021-09-01 | West Baton Rouge | Louisiana | 22121 | 4171 | 69 |
1671596 | 1671596 | 2021-08-31 | West Baton Rouge | Louisiana | 22121 | 4130 | 68 |
1668349 | 1668349 | 2021-08-30 | West Baton Rouge | Louisiana | 22121 | 4130 | 68 |
1665102 | 1665102 | 2021-08-29 | West Baton Rouge | Louisiana | 22121 | 4130 | 68 |
1661854 | 1661854 | 2021-08-28 | West Baton Rouge | Louisiana | 22121 | 4130 | 68 |
1658606 | 1658606 | 2021-08-27 | West Baton Rouge | Louisiana | 22121 | 4130 | 68 |
1655358 | 1655358 | 2021-08-26 | West Baton Rouge | Louisiana | 22121 | 4125 | 68 |
1652111 | 1652111 | 2021-08-25 | West Baton Rouge | Louisiana | 22121 | 4115 | 68 |
1648862 | 1648862 | 2021-08-24 | West Baton Rouge | Louisiana | 22121 | 4082 | 67 |
1645614 | 1645614 | 2021-08-23 | West Baton Rouge | Louisiana | 22121 | 4069 | 67 |
1642365 | 1642365 | 2021-08-22 | West Baton Rouge | Louisiana | 22121 | 4008 | 67 |
1639115 | 1639115 | 2021-08-21 | West Baton Rouge | Louisiana | 22121 | 4008 | 67 |
1635865 | 1635865 | 2021-08-20 | West Baton Rouge | Louisiana | 22121 | 4008 | 67 |
1632615 | 1632615 | 2021-08-19 | West Baton Rouge | Louisiana | 22121 | 3986 | 67 |
1629368 | 1629368 | 2021-08-18 | West Baton Rouge | Louisiana | 22121 | 3961 | 67 |
1626121 | 1626121 | 2021-08-17 | West Baton Rouge | Louisiana | 22121 | 3907 | 67 |
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);