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 |
---|---|---|---|---|---|---|---|
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 |
1850276 | 1850276 | 2021-10-25 | St. John the Baptist | Louisiana | 22095 | 6293 | 170 |
1847026 | 1847026 | 2021-10-24 | St. John the Baptist | Louisiana | 22095 | 6288 | 170 |
1843776 | 1843776 | 2021-10-23 | St. John the Baptist | Louisiana | 22095 | 6288 | 170 |
1840526 | 1840526 | 2021-10-22 | St. John the Baptist | Louisiana | 22095 | 6288 | 170 |
1837277 | 1837277 | 2021-10-21 | St. John the Baptist | Louisiana | 22095 | 6285 | 170 |
1834028 | 1834028 | 2021-10-20 | St. John the Baptist | Louisiana | 22095 | 6279 | 170 |
1830779 | 1830779 | 2021-10-19 | St. John the Baptist | Louisiana | 22095 | 6279 | 170 |
1827530 | 1827530 | 2021-10-18 | St. John the Baptist | Louisiana | 22095 | 6278 | 168 |
1824281 | 1824281 | 2021-10-17 | St. John the Baptist | Louisiana | 22095 | 6270 | 168 |
1821032 | 1821032 | 2021-10-16 | St. John the Baptist | Louisiana | 22095 | 6270 | 168 |
1817783 | 1817783 | 2021-10-15 | St. John the Baptist | Louisiana | 22095 | 6270 | 168 |
1814535 | 1814535 | 2021-10-14 | St. John the Baptist | Louisiana | 22095 | 6266 | 167 |
1811286 | 1811286 | 2021-10-13 | St. John the Baptist | Louisiana | 22095 | 6259 | 165 |
1808037 | 1808037 | 2021-10-12 | St. John the Baptist | Louisiana | 22095 | 6252 | 165 |
1804786 | 1804786 | 2021-10-11 | St. John the Baptist | Louisiana | 22095 | 6248 | 163 |
1801537 | 1801537 | 2021-10-10 | St. John the Baptist | Louisiana | 22095 | 6235 | 163 |
1798288 | 1798288 | 2021-10-09 | St. John the Baptist | Louisiana | 22095 | 6235 | 163 |
1795039 | 1795039 | 2021-10-08 | St. John the Baptist | Louisiana | 22095 | 6235 | 163 |
1791791 | 1791791 | 2021-10-07 | St. John the Baptist | Louisiana | 22095 | 6232 | 163 |
1788542 | 1788542 | 2021-10-06 | St. John the Baptist | Louisiana | 22095 | 6226 | 163 |
1785293 | 1785293 | 2021-10-05 | St. John the Baptist | Louisiana | 22095 | 6222 | 163 |
1782044 | 1782044 | 2021-10-04 | St. John the Baptist | Louisiana | 22095 | 6217 | 163 |
1778794 | 1778794 | 2021-10-03 | St. John the Baptist | Louisiana | 22095 | 6204 | 162 |
1775544 | 1775544 | 2021-10-02 | St. John the Baptist | Louisiana | 22095 | 6204 | 162 |
1772294 | 1772294 | 2021-10-01 | St. John the Baptist | Louisiana | 22095 | 6204 | 162 |
1769045 | 1769045 | 2021-09-30 | St. John the Baptist | Louisiana | 22095 | 6199 | 162 |
1765796 | 1765796 | 2021-09-29 | St. John the Baptist | Louisiana | 22095 | 6194 | 160 |
1762547 | 1762547 | 2021-09-28 | St. John the Baptist | Louisiana | 22095 | 6191 | 160 |
1759299 | 1759299 | 2021-09-27 | St. John the Baptist | Louisiana | 22095 | 6185 | 158 |
1756051 | 1756051 | 2021-09-26 | St. John the Baptist | Louisiana | 22095 | 6163 | 158 |
1752803 | 1752803 | 2021-09-25 | St. John the Baptist | Louisiana | 22095 | 6163 | 158 |
1749554 | 1749554 | 2021-09-24 | St. John the Baptist | Louisiana | 22095 | 6163 | 158 |
1746304 | 1746304 | 2021-09-23 | St. John the Baptist | Louisiana | 22095 | 6155 | 158 |
1743055 | 1743055 | 2021-09-22 | St. John the Baptist | Louisiana | 22095 | 6145 | 158 |
1739806 | 1739806 | 2021-09-21 | St. John the Baptist | Louisiana | 22095 | 6138 | 157 |
1736557 | 1736557 | 2021-09-20 | St. John the Baptist | Louisiana | 22095 | 6127 | 156 |
1733307 | 1733307 | 2021-09-19 | St. John the Baptist | Louisiana | 22095 | 6104 | 156 |
1730057 | 1730057 | 2021-09-18 | St. John the Baptist | Louisiana | 22095 | 6104 | 156 |
1726807 | 1726807 | 2021-09-17 | St. John the Baptist | Louisiana | 22095 | 6104 | 156 |
1723558 | 1723558 | 2021-09-16 | St. John the Baptist | Louisiana | 22095 | 6092 | 156 |
1720309 | 1720309 | 2021-09-15 | St. John the Baptist | Louisiana | 22095 | 6078 | 156 |
1717061 | 1717061 | 2021-09-14 | St. John the Baptist | Louisiana | 22095 | 6059 | 156 |
1713815 | 1713815 | 2021-09-13 | St. John the Baptist | Louisiana | 22095 | 6041 | 156 |
1710568 | 1710568 | 2021-09-12 | St. John the Baptist | Louisiana | 22095 | 6018 | 156 |
1707321 | 1707321 | 2021-09-11 | St. John the Baptist | Louisiana | 22095 | 6018 | 156 |
1704073 | 1704073 | 2021-09-10 | St. John the Baptist | Louisiana | 22095 | 6018 | 156 |
1700823 | 1700823 | 2021-09-09 | St. John the Baptist | Louisiana | 22095 | 6002 | 155 |
1697574 | 1697574 | 2021-09-08 | St. John the Baptist | Louisiana | 22095 | 5980 | 155 |
1694326 | 1694326 | 2021-09-07 | St. John the Baptist | Louisiana | 22095 | 5973 | 153 |
1691077 | 1691077 | 2021-09-06 | St. John the Baptist | Louisiana | 22095 | 5945 | 153 |
1687827 | 1687827 | 2021-09-05 | St. John the Baptist | Louisiana | 22095 | 5945 | 153 |
1684577 | 1684577 | 2021-09-04 | St. John the Baptist | Louisiana | 22095 | 5945 | 153 |
1681326 | 1681326 | 2021-09-03 | St. John the Baptist | Louisiana | 22095 | 5945 | 153 |
1678078 | 1678078 | 2021-09-02 | St. John the Baptist | Louisiana | 22095 | 5937 | 153 |
1674831 | 1674831 | 2021-09-01 | St. John the Baptist | Louisiana | 22095 | 5933 | 153 |
1671582 | 1671582 | 2021-08-31 | St. John the Baptist | Louisiana | 22095 | 5816 | 153 |
1668335 | 1668335 | 2021-08-30 | St. John the Baptist | Louisiana | 22095 | 5816 | 153 |
1665088 | 1665088 | 2021-08-29 | St. John the Baptist | Louisiana | 22095 | 5816 | 153 |
1661840 | 1661840 | 2021-08-28 | St. John the Baptist | Louisiana | 22095 | 5816 | 153 |
1658592 | 1658592 | 2021-08-27 | St. John the Baptist | Louisiana | 22095 | 5816 | 153 |
1655344 | 1655344 | 2021-08-26 | St. John the Baptist | Louisiana | 22095 | 5780 | 153 |
1652097 | 1652097 | 2021-08-25 | St. John the Baptist | Louisiana | 22095 | 5723 | 151 |
1648848 | 1648848 | 2021-08-24 | St. John the Baptist | Louisiana | 22095 | 5669 | 150 |
1645600 | 1645600 | 2021-08-23 | St. John the Baptist | Louisiana | 22095 | 5619 | 149 |
1642351 | 1642351 | 2021-08-22 | St. John the Baptist | Louisiana | 22095 | 5497 | 149 |
1639101 | 1639101 | 2021-08-21 | St. John the Baptist | Louisiana | 22095 | 5497 | 149 |
1635851 | 1635851 | 2021-08-20 | St. John the Baptist | Louisiana | 22095 | 5497 | 149 |
1632601 | 1632601 | 2021-08-19 | St. John the Baptist | Louisiana | 22095 | 5452 | 149 |
1629354 | 1629354 | 2021-08-18 | St. John the Baptist | Louisiana | 22095 | 5395 | 149 |
1626107 | 1626107 | 2021-08-17 | St. John the Baptist | Louisiana | 22095 | 5348 | 149 |
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);