ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "St. John the Baptist" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175364 | 2175364 | 2022-02-02 | St. John the Baptist | Louisiana | 22095 | 10194 | 178 |
2172111 | 2172111 | 2022-02-01 | St. John the Baptist | Louisiana | 22095 | 10174 | 178 |
2168858 | 2168858 | 2022-01-31 | St. John the Baptist | Louisiana | 22095 | 10118 | 177 |
2165603 | 2165603 | 2022-01-30 | St. John the Baptist | Louisiana | 22095 | 10053 | 177 |
2162348 | 2162348 | 2022-01-29 | St. John the Baptist | Louisiana | 22095 | 10053 | 177 |
2159093 | 2159093 | 2022-01-28 | St. John the Baptist | Louisiana | 22095 | 10053 | 177 |
2155839 | 2155839 | 2022-01-27 | St. John the Baptist | Louisiana | 22095 | 10010 | 176 |
2152586 | 2152586 | 2022-01-26 | St. John the Baptist | Louisiana | 22095 | 9961 | 176 |
2149334 | 2149334 | 2022-01-25 | St. John the Baptist | Louisiana | 22095 | 9477 | 174 |
2146082 | 2146082 | 2022-01-24 | St. John the Baptist | Louisiana | 22095 | 9436 | 174 |
2142827 | 2142827 | 2022-01-23 | St. John the Baptist | Louisiana | 22095 | 9297 | 174 |
2139572 | 2139572 | 2022-01-22 | St. John the Baptist | Louisiana | 22095 | 9297 | 174 |
2136316 | 2136316 | 2022-01-21 | St. John the Baptist | Louisiana | 22095 | 9297 | 174 |
2133064 | 2133064 | 2022-01-20 | St. John the Baptist | Louisiana | 22095 | 9181 | 174 |
2129811 | 2129811 | 2022-01-19 | St. John the Baptist | Louisiana | 22095 | 9109 | 173 |
2126557 | 2126557 | 2022-01-18 | St. John the Baptist | Louisiana | 22095 | 9016 | 173 |
2123305 | 2123305 | 2022-01-17 | St. John the Baptist | Louisiana | 22095 | 8801 | 173 |
2120053 | 2120053 | 2022-01-16 | St. John the Baptist | Louisiana | 22095 | 8801 | 173 |
2116801 | 2116801 | 2022-01-15 | St. John the Baptist | Louisiana | 22095 | 8801 | 173 |
2113550 | 2113550 | 2022-01-14 | St. John the Baptist | Louisiana | 22095 | 8801 | 173 |
2110298 | 2110298 | 2022-01-13 | St. John the Baptist | Louisiana | 22095 | 8329 | 173 |
2107047 | 2107047 | 2022-01-12 | St. John the Baptist | Louisiana | 22095 | 8329 | 173 |
2103796 | 2103796 | 2022-01-11 | St. John the Baptist | Louisiana | 22095 | 8329 | 173 |
2100545 | 2100545 | 2022-01-10 | St. John the Baptist | Louisiana | 22095 | 8204 | 173 |
2097294 | 2097294 | 2022-01-09 | St. John the Baptist | Louisiana | 22095 | 7947 | 173 |
2094042 | 2094042 | 2022-01-08 | St. John the Baptist | Louisiana | 22095 | 7947 | 173 |
2090790 | 2090790 | 2022-01-07 | St. John the Baptist | Louisiana | 22095 | 7947 | 173 |
2087539 | 2087539 | 2022-01-06 | St. John the Baptist | Louisiana | 22095 | 7805 | 173 |
2084287 | 2084287 | 2022-01-05 | St. John the Baptist | Louisiana | 22095 | 7661 | 173 |
2081035 | 2081035 | 2022-01-04 | St. John the Baptist | Louisiana | 22095 | 7486 | 173 |
2077783 | 2077783 | 2022-01-03 | St. John the Baptist | Louisiana | 22095 | 7413 | 173 |
2074532 | 2074532 | 2022-01-02 | St. John the Baptist | Louisiana | 22095 | 7060 | 173 |
2071281 | 2071281 | 2022-01-01 | St. John the Baptist | Louisiana | 22095 | 7060 | 173 |
2068030 | 2068030 | 2021-12-31 | St. John the Baptist | Louisiana | 22095 | 7060 | 173 |
2064779 | 2064779 | 2021-12-30 | St. John the Baptist | Louisiana | 22095 | 7060 | 173 |
2061529 | 2061529 | 2021-12-29 | St. John the Baptist | Louisiana | 22095 | 6900 | 173 |
2058280 | 2058280 | 2021-12-28 | St. John the Baptist | Louisiana | 22095 | 6752 | 173 |
2055031 | 2055031 | 2021-12-27 | St. John the Baptist | Louisiana | 22095 | 6727 | 173 |
2051781 | 2051781 | 2021-12-26 | St. John the Baptist | Louisiana | 22095 | 6564 | 173 |
2048531 | 2048531 | 2021-12-25 | St. John the Baptist | Louisiana | 22095 | 6564 | 173 |
2045281 | 2045281 | 2021-12-24 | St. John the Baptist | Louisiana | 22095 | 6564 | 173 |
2042032 | 2042032 | 2021-12-23 | St. John the Baptist | Louisiana | 22095 | 6564 | 173 |
2038782 | 2038782 | 2021-12-22 | St. John the Baptist | Louisiana | 22095 | 6527 | 173 |
2035532 | 2035532 | 2021-12-21 | St. John the Baptist | Louisiana | 22095 | 6502 | 173 |
2032282 | 2032282 | 2021-12-20 | St. John the Baptist | Louisiana | 22095 | 6490 | 173 |
2029031 | 2029031 | 2021-12-19 | St. John the Baptist | Louisiana | 22095 | 6454 | 173 |
2025780 | 2025780 | 2021-12-18 | St. John the Baptist | Louisiana | 22095 | 6454 | 173 |
2022529 | 2022529 | 2021-12-17 | St. John the Baptist | Louisiana | 22095 | 6454 | 173 |
2019278 | 2019278 | 2021-12-16 | St. John the Baptist | Louisiana | 22095 | 6443 | 173 |
2016028 | 2016028 | 2021-12-15 | St. John the Baptist | Louisiana | 22095 | 6439 | 173 |
2012777 | 2012777 | 2021-12-14 | St. John the Baptist | Louisiana | 22095 | 6435 | 173 |
2009526 | 2009526 | 2021-12-13 | St. John the Baptist | Louisiana | 22095 | 6428 | 173 |
2006275 | 2006275 | 2021-12-12 | St. John the Baptist | Louisiana | 22095 | 6418 | 173 |
2003024 | 2003024 | 2021-12-11 | St. John the Baptist | Louisiana | 22095 | 6418 | 173 |
1999774 | 1999774 | 2021-12-10 | St. John the Baptist | Louisiana | 22095 | 6418 | 173 |
1996523 | 1996523 | 2021-12-09 | St. John the Baptist | Louisiana | 22095 | 6415 | 173 |
1993272 | 1993272 | 2021-12-08 | St. John the Baptist | Louisiana | 22095 | 6415 | 173 |
1990021 | 1990021 | 2021-12-07 | St. John the Baptist | Louisiana | 22095 | 6412 | 173 |
1986771 | 1986771 | 2021-12-06 | St. John the Baptist | Louisiana | 22095 | 6410 | 173 |
1983521 | 1983521 | 2021-12-05 | St. John the Baptist | Louisiana | 22095 | 6408 | 173 |
1980271 | 1980271 | 2021-12-04 | St. John the Baptist | Louisiana | 22095 | 6408 | 173 |
1977021 | 1977021 | 2021-12-03 | St. John the Baptist | Louisiana | 22095 | 6408 | 173 |
1973772 | 1973772 | 2021-12-02 | St. John the Baptist | Louisiana | 22095 | 6401 | 173 |
1970522 | 1970522 | 2021-12-01 | St. John the Baptist | Louisiana | 22095 | 6399 | 173 |
1967272 | 1967272 | 2021-11-30 | St. John the Baptist | Louisiana | 22095 | 6398 | 173 |
1964020 | 1964020 | 2021-11-29 | St. John the Baptist | Louisiana | 22095 | 6373 | 173 |
1960769 | 1960769 | 2021-11-28 | St. John the Baptist | Louisiana | 22095 | 6368 | 173 |
1957518 | 1957518 | 2021-11-27 | St. John the Baptist | Louisiana | 22095 | 6368 | 173 |
1954267 | 1954267 | 2021-11-26 | St. John the Baptist | Louisiana | 22095 | 6368 | 173 |
1951016 | 1951016 | 2021-11-25 | St. John the Baptist | Louisiana | 22095 | 6368 | 173 |
1947765 | 1947765 | 2021-11-24 | St. John the Baptist | Louisiana | 22095 | 6368 | 173 |
1944514 | 1944514 | 2021-11-23 | St. John the Baptist | Louisiana | 22095 | 6365 | 173 |
1941264 | 1941264 | 2021-11-22 | St. John the Baptist | Louisiana | 22095 | 6364 | 173 |
1938014 | 1938014 | 2021-11-21 | St. John the Baptist | Louisiana | 22095 | 6360 | 173 |
1934764 | 1934764 | 2021-11-20 | St. John the Baptist | Louisiana | 22095 | 6360 | 173 |
1931513 | 1931513 | 2021-11-19 | St. John the Baptist | Louisiana | 22095 | 6360 | 173 |
1928262 | 1928262 | 2021-11-18 | St. John the Baptist | Louisiana | 22095 | 6359 | 173 |
1925012 | 1925012 | 2021-11-17 | St. John the Baptist | Louisiana | 22095 | 6355 | 173 |
1921763 | 1921763 | 2021-11-16 | St. John the Baptist | Louisiana | 22095 | 6348 | 172 |
1918513 | 1918513 | 2021-11-15 | St. John the Baptist | Louisiana | 22095 | 6344 | 172 |
1915263 | 1915263 | 2021-11-14 | St. John the Baptist | Louisiana | 22095 | 6338 | 171 |
1912013 | 1912013 | 2021-11-13 | St. John the Baptist | Louisiana | 22095 | 6338 | 171 |
1908764 | 1908764 | 2021-11-12 | St. John the Baptist | Louisiana | 22095 | 6338 | 171 |
1905515 | 1905515 | 2021-11-11 | St. John the Baptist | Louisiana | 22095 | 6332 | 171 |
1902265 | 1902265 | 2021-11-10 | St. John the Baptist | Louisiana | 22095 | 6332 | 171 |
1899015 | 1899015 | 2021-11-09 | St. John the Baptist | Louisiana | 22095 | 6332 | 171 |
1895765 | 1895765 | 2021-11-08 | St. John the Baptist | Louisiana | 22095 | 6330 | 171 |
1892515 | 1892515 | 2021-11-07 | St. John the Baptist | Louisiana | 22095 | 6329 | 171 |
1889265 | 1889265 | 2021-11-06 | St. John the Baptist | Louisiana | 22095 | 6329 | 171 |
1886015 | 1886015 | 2021-11-05 | St. John the Baptist | Louisiana | 22095 | 6329 | 171 |
1882766 | 1882766 | 2021-11-04 | St. John the Baptist | Louisiana | 22095 | 6324 | 171 |
1879517 | 1879517 | 2021-11-03 | St. John the Baptist | Louisiana | 22095 | 6321 | 171 |
1876268 | 1876268 | 2021-11-02 | St. John the Baptist | Louisiana | 22095 | 6314 | 171 |
1873019 | 1873019 | 2021-11-01 | St. John the Baptist | Louisiana | 22095 | 6313 | 171 |
1869770 | 1869770 | 2021-10-31 | St. John the Baptist | Louisiana | 22095 | 6306 | 171 |
1866521 | 1866521 | 2021-10-30 | St. John the Baptist | Louisiana | 22095 | 6306 | 171 |
1863272 | 1863272 | 2021-10-29 | St. John the Baptist | Louisiana | 22095 | 6306 | 171 |
1860023 | 1860023 | 2021-10-28 | St. John the Baptist | Louisiana | 22095 | 6305 | 171 |
1856774 | 1856774 | 2021-10-27 | St. John the Baptist | Louisiana | 22095 | 6298 | 170 |
1853525 | 1853525 | 2021-10-26 | St. John the Baptist | Louisiana | 22095 | 6296 | 170 |
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);