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 |
---|---|---|---|---|---|---|---|
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 |
1622860 | 1622860 | 2021-08-16 | St. John the Baptist | Louisiana | 22095 | 5319 | 148 |
1619613 | 1619613 | 2021-08-15 | St. John the Baptist | Louisiana | 22095 | 5170 | 148 |
1616365 | 1616365 | 2021-08-14 | St. John the Baptist | Louisiana | 22095 | 5170 | 148 |
1613116 | 1613116 | 2021-08-13 | St. John the Baptist | Louisiana | 22095 | 5170 | 148 |
1609868 | 1609868 | 2021-08-12 | St. John the Baptist | Louisiana | 22095 | 5126 | 147 |
1606619 | 1606619 | 2021-08-11 | St. John the Baptist | Louisiana | 22095 | 5076 | 147 |
1603370 | 1603370 | 2021-08-10 | St. John the Baptist | Louisiana | 22095 | 5039 | 147 |
1600121 | 1600121 | 2021-08-09 | St. John the Baptist | Louisiana | 22095 | 4981 | 147 |
1596873 | 1596873 | 2021-08-08 | St. John the Baptist | Louisiana | 22095 | 4855 | 147 |
1593624 | 1593624 | 2021-08-07 | St. John the Baptist | Louisiana | 22095 | 4855 | 147 |
1590375 | 1590375 | 2021-08-06 | St. John the Baptist | Louisiana | 22095 | 4855 | 147 |
1587126 | 1587126 | 2021-08-05 | St. John the Baptist | Louisiana | 22095 | 4792 | 147 |
1583876 | 1583876 | 2021-08-04 | St. John the Baptist | Louisiana | 22095 | 4734 | 142 |
1580626 | 1580626 | 2021-08-03 | St. John the Baptist | Louisiana | 22095 | 4678 | 142 |
1577377 | 1577377 | 2021-08-02 | St. John the Baptist | Louisiana | 22095 | 4639 | 142 |
1574129 | 1574129 | 2021-08-01 | St. John the Baptist | Louisiana | 22095 | 4524 | 142 |
1570881 | 1570881 | 2021-07-31 | St. John the Baptist | Louisiana | 22095 | 4524 | 142 |
1567633 | 1567633 | 2021-07-30 | St. John the Baptist | Louisiana | 22095 | 4524 | 142 |
1564385 | 1564385 | 2021-07-29 | St. John the Baptist | Louisiana | 22095 | 4454 | 142 |
1561137 | 1561137 | 2021-07-28 | St. John the Baptist | Louisiana | 22095 | 4404 | 141 |
1557890 | 1557890 | 2021-07-27 | St. John the Baptist | Louisiana | 22095 | 4349 | 141 |
1554643 | 1554643 | 2021-07-26 | St. John the Baptist | Louisiana | 22095 | 4306 | 141 |
1551396 | 1551396 | 2021-07-25 | St. John the Baptist | Louisiana | 22095 | 4205 | 141 |
1548149 | 1548149 | 2021-07-24 | St. John the Baptist | Louisiana | 22095 | 4205 | 141 |
1544902 | 1544902 | 2021-07-23 | St. John the Baptist | Louisiana | 22095 | 4205 | 141 |
1541654 | 1541654 | 2021-07-22 | St. John the Baptist | Louisiana | 22095 | 4162 | 141 |
1538407 | 1538407 | 2021-07-21 | St. John the Baptist | Louisiana | 22095 | 4126 | 141 |
1535159 | 1535159 | 2021-07-20 | St. John the Baptist | Louisiana | 22095 | 4075 | 141 |
1531912 | 1531912 | 2021-07-19 | St. John the Baptist | Louisiana | 22095 | 4053 | 141 |
1528665 | 1528665 | 2021-07-18 | St. John the Baptist | Louisiana | 22095 | 3995 | 141 |
1525418 | 1525418 | 2021-07-17 | St. John the Baptist | Louisiana | 22095 | 3995 | 141 |
1522170 | 1522170 | 2021-07-16 | St. John the Baptist | Louisiana | 22095 | 3995 | 141 |
1518922 | 1518922 | 2021-07-15 | St. John the Baptist | Louisiana | 22095 | 3977 | 141 |
1515675 | 1515675 | 2021-07-14 | St. John the Baptist | Louisiana | 22095 | 3965 | 141 |
1512429 | 1512429 | 2021-07-13 | St. John the Baptist | Louisiana | 22095 | 3954 | 141 |
1509182 | 1509182 | 2021-07-12 | St. John the Baptist | Louisiana | 22095 | 3949 | 141 |
1505936 | 1505936 | 2021-07-11 | St. John the Baptist | Louisiana | 22095 | 3931 | 141 |
1502690 | 1502690 | 2021-07-10 | St. John the Baptist | Louisiana | 22095 | 3931 | 141 |
1499444 | 1499444 | 2021-07-09 | St. John the Baptist | Louisiana | 22095 | 3931 | 141 |
1496197 | 1496197 | 2021-07-08 | St. John the Baptist | Louisiana | 22095 | 3926 | 141 |
1492951 | 1492951 | 2021-07-07 | St. John the Baptist | Louisiana | 22095 | 3916 | 141 |
1489704 | 1489704 | 2021-07-06 | St. John the Baptist | Louisiana | 22095 | 3907 | 141 |
1486457 | 1486457 | 2021-07-05 | St. John the Baptist | Louisiana | 22095 | 3898 | 141 |
1483211 | 1483211 | 2021-07-04 | St. John the Baptist | Louisiana | 22095 | 3898 | 141 |
1479964 | 1479964 | 2021-07-03 | St. John the Baptist | Louisiana | 22095 | 3898 | 141 |
1476718 | 1476718 | 2021-07-02 | St. John the Baptist | Louisiana | 22095 | 3898 | 141 |
1473472 | 1473472 | 2021-07-01 | St. John the Baptist | Louisiana | 22095 | 3889 | 141 |
1470226 | 1470226 | 2021-06-30 | St. John the Baptist | Louisiana | 22095 | 3882 | 141 |
1466981 | 1466981 | 2021-06-29 | St. John the Baptist | Louisiana | 22095 | 3880 | 141 |
1463736 | 1463736 | 2021-06-28 | St. John the Baptist | Louisiana | 22095 | 3881 | 141 |
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);