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 |
---|---|---|---|---|---|---|---|
2110312 | 2110312 | 2022-01-13 | West Baton Rouge | Louisiana | 22121 | 5558 | 79 |
2107061 | 2107061 | 2022-01-12 | West Baton Rouge | Louisiana | 22121 | 5558 | 79 |
2103810 | 2103810 | 2022-01-11 | West Baton Rouge | Louisiana | 22121 | 5558 | 79 |
2100559 | 2100559 | 2022-01-10 | West Baton Rouge | Louisiana | 22121 | 5457 | 79 |
2097308 | 2097308 | 2022-01-09 | West Baton Rouge | Louisiana | 22121 | 5337 | 79 |
2094056 | 2094056 | 2022-01-08 | West Baton Rouge | Louisiana | 22121 | 5337 | 79 |
2090804 | 2090804 | 2022-01-07 | West Baton Rouge | Louisiana | 22121 | 5337 | 79 |
2087553 | 2087553 | 2022-01-06 | West Baton Rouge | Louisiana | 22121 | 5110 | 79 |
2084301 | 2084301 | 2022-01-05 | West Baton Rouge | Louisiana | 22121 | 5034 | 79 |
2081049 | 2081049 | 2022-01-04 | West Baton Rouge | Louisiana | 22121 | 4972 | 79 |
2077797 | 2077797 | 2022-01-03 | West Baton Rouge | Louisiana | 22121 | 4862 | 79 |
2074546 | 2074546 | 2022-01-02 | West Baton Rouge | Louisiana | 22121 | 4731 | 79 |
2071295 | 2071295 | 2022-01-01 | West Baton Rouge | Louisiana | 22121 | 4731 | 79 |
2068044 | 2068044 | 2021-12-31 | West Baton Rouge | Louisiana | 22121 | 4731 | 79 |
2064793 | 2064793 | 2021-12-30 | West Baton Rouge | Louisiana | 22121 | 4731 | 79 |
2061543 | 2061543 | 2021-12-29 | West Baton Rouge | Louisiana | 22121 | 4645 | 79 |
2058294 | 2058294 | 2021-12-28 | West Baton Rouge | Louisiana | 22121 | 4588 | 79 |
2055045 | 2055045 | 2021-12-27 | West Baton Rouge | Louisiana | 22121 | 4551 | 79 |
2051795 | 2051795 | 2021-12-26 | West Baton Rouge | Louisiana | 22121 | 4517 | 79 |
2048545 | 2048545 | 2021-12-25 | West Baton Rouge | Louisiana | 22121 | 4517 | 79 |
2045295 | 2045295 | 2021-12-24 | West Baton Rouge | Louisiana | 22121 | 4517 | 79 |
2042046 | 2042046 | 2021-12-23 | West Baton Rouge | Louisiana | 22121 | 4517 | 79 |
2038796 | 2038796 | 2021-12-22 | West Baton Rouge | Louisiana | 22121 | 4510 | 79 |
2035546 | 2035546 | 2021-12-21 | West Baton Rouge | Louisiana | 22121 | 4500 | 79 |
2032296 | 2032296 | 2021-12-20 | West Baton Rouge | Louisiana | 22121 | 4489 | 79 |
2029045 | 2029045 | 2021-12-19 | West Baton Rouge | Louisiana | 22121 | 4480 | 79 |
2025794 | 2025794 | 2021-12-18 | West Baton Rouge | Louisiana | 22121 | 4480 | 79 |
2022543 | 2022543 | 2021-12-17 | West Baton Rouge | Louisiana | 22121 | 4480 | 79 |
2019292 | 2019292 | 2021-12-16 | West Baton Rouge | Louisiana | 22121 | 4477 | 79 |
2016042 | 2016042 | 2021-12-15 | West Baton Rouge | Louisiana | 22121 | 4473 | 79 |
2012791 | 2012791 | 2021-12-14 | West Baton Rouge | Louisiana | 22121 | 4466 | 79 |
2009540 | 2009540 | 2021-12-13 | West Baton Rouge | Louisiana | 22121 | 4464 | 79 |
2006289 | 2006289 | 2021-12-12 | West Baton Rouge | Louisiana | 22121 | 4463 | 79 |
2003038 | 2003038 | 2021-12-11 | West Baton Rouge | Louisiana | 22121 | 4463 | 79 |
1999788 | 1999788 | 2021-12-10 | West Baton Rouge | Louisiana | 22121 | 4463 | 79 |
1996537 | 1996537 | 2021-12-09 | West Baton Rouge | Louisiana | 22121 | 4460 | 79 |
1993286 | 1993286 | 2021-12-08 | West Baton Rouge | Louisiana | 22121 | 4459 | 79 |
1990035 | 1990035 | 2021-12-07 | West Baton Rouge | Louisiana | 22121 | 4458 | 79 |
1986785 | 1986785 | 2021-12-06 | West Baton Rouge | Louisiana | 22121 | 4456 | 78 |
1983535 | 1983535 | 2021-12-05 | West Baton Rouge | Louisiana | 22121 | 4453 | 78 |
1980285 | 1980285 | 2021-12-04 | West Baton Rouge | Louisiana | 22121 | 4453 | 78 |
1977035 | 1977035 | 2021-12-03 | West Baton Rouge | Louisiana | 22121 | 4453 | 78 |
1973786 | 1973786 | 2021-12-02 | West Baton Rouge | Louisiana | 22121 | 4452 | 78 |
1970536 | 1970536 | 2021-12-01 | West Baton Rouge | Louisiana | 22121 | 4450 | 78 |
1967286 | 1967286 | 2021-11-30 | West Baton Rouge | Louisiana | 22121 | 4441 | 78 |
1964034 | 1964034 | 2021-11-29 | West Baton Rouge | Louisiana | 22121 | 4440 | 78 |
1960783 | 1960783 | 2021-11-28 | West Baton Rouge | Louisiana | 22121 | 4436 | 78 |
1957532 | 1957532 | 2021-11-27 | West Baton Rouge | Louisiana | 22121 | 4436 | 78 |
1954281 | 1954281 | 2021-11-26 | West Baton Rouge | Louisiana | 22121 | 4436 | 78 |
1951030 | 1951030 | 2021-11-25 | West Baton Rouge | Louisiana | 22121 | 4436 | 78 |
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 |
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);