ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 22051 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811264 | 1811264 | 2021-10-13 | Jefferson | Louisiana | 22051 | 69014 | 1147 |
1808015 | 1808015 | 2021-10-12 | Jefferson | Louisiana | 22051 | 68976 | 1144 |
1804764 | 1804764 | 2021-10-11 | Jefferson | Louisiana | 22051 | 68939 | 1143 |
1801515 | 1801515 | 2021-10-10 | Jefferson | Louisiana | 22051 | 68849 | 1142 |
1798266 | 1798266 | 2021-10-09 | Jefferson | Louisiana | 22051 | 68849 | 1142 |
1795017 | 1795017 | 2021-10-08 | Jefferson | Louisiana | 22051 | 68849 | 1142 |
1791769 | 1791769 | 2021-10-07 | Jefferson | Louisiana | 22051 | 68806 | 1139 |
1788520 | 1788520 | 2021-10-06 | Jefferson | Louisiana | 22051 | 68772 | 1137 |
1785271 | 1785271 | 2021-10-05 | Jefferson | Louisiana | 22051 | 68718 | 1135 |
1782022 | 1782022 | 2021-10-04 | Jefferson | Louisiana | 22051 | 68664 | 1134 |
1778772 | 1778772 | 2021-10-03 | Jefferson | Louisiana | 22051 | 68523 | 1130 |
1775522 | 1775522 | 2021-10-02 | Jefferson | Louisiana | 22051 | 68523 | 1130 |
1772272 | 1772272 | 2021-10-01 | Jefferson | Louisiana | 22051 | 68523 | 1130 |
1769023 | 1769023 | 2021-09-30 | Jefferson | Louisiana | 22051 | 68449 | 1126 |
1765774 | 1765774 | 2021-09-29 | Jefferson | Louisiana | 22051 | 68382 | 1124 |
1762525 | 1762525 | 2021-09-28 | Jefferson | Louisiana | 22051 | 68333 | 1118 |
1759277 | 1759277 | 2021-09-27 | Jefferson | Louisiana | 22051 | 68273 | 1115 |
1756029 | 1756029 | 2021-09-26 | Jefferson | Louisiana | 22051 | 68099 | 1107 |
1752781 | 1752781 | 2021-09-25 | Jefferson | Louisiana | 22051 | 68099 | 1107 |
1749532 | 1749532 | 2021-09-24 | Jefferson | Louisiana | 22051 | 68099 | 1107 |
1746282 | 1746282 | 2021-09-23 | Jefferson | Louisiana | 22051 | 68040 | 1103 |
1743033 | 1743033 | 2021-09-22 | Jefferson | Louisiana | 22051 | 67956 | 1102 |
1739784 | 1739784 | 2021-09-21 | Jefferson | Louisiana | 22051 | 67871 | 1094 |
1736535 | 1736535 | 2021-09-20 | Jefferson | Louisiana | 22051 | 67774 | 1091 |
1733285 | 1733285 | 2021-09-19 | Jefferson | Louisiana | 22051 | 67536 | 1088 |
1730035 | 1730035 | 2021-09-18 | Jefferson | Louisiana | 22051 | 67536 | 1088 |
1726785 | 1726785 | 2021-09-17 | Jefferson | Louisiana | 22051 | 67536 | 1088 |
1723536 | 1723536 | 2021-09-16 | Jefferson | Louisiana | 22051 | 67419 | 1087 |
1720287 | 1720287 | 2021-09-15 | Jefferson | Louisiana | 22051 | 67305 | 1084 |
1717039 | 1717039 | 2021-09-14 | Jefferson | Louisiana | 22051 | 67169 | 1080 |
1713793 | 1713793 | 2021-09-13 | Jefferson | Louisiana | 22051 | 67050 | 1069 |
1710546 | 1710546 | 2021-09-12 | Jefferson | Louisiana | 22051 | 66764 | 1067 |
1707299 | 1707299 | 2021-09-11 | Jefferson | Louisiana | 22051 | 66764 | 1067 |
1704051 | 1704051 | 2021-09-10 | Jefferson | Louisiana | 22051 | 66764 | 1067 |
1700801 | 1700801 | 2021-09-09 | Jefferson | Louisiana | 22051 | 66672 | 1060 |
1697552 | 1697552 | 2021-09-08 | Jefferson | Louisiana | 22051 | 66518 | 1050 |
1694304 | 1694304 | 2021-09-07 | Jefferson | Louisiana | 22051 | 66454 | 1044 |
1691055 | 1691055 | 2021-09-06 | Jefferson | Louisiana | 22051 | 66247 | 1042 |
1687805 | 1687805 | 2021-09-05 | Jefferson | Louisiana | 22051 | 66247 | 1042 |
1684555 | 1684555 | 2021-09-04 | Jefferson | Louisiana | 22051 | 66247 | 1042 |
1681304 | 1681304 | 2021-09-03 | Jefferson | Louisiana | 22051 | 66247 | 1042 |
1678056 | 1678056 | 2021-09-02 | Jefferson | Louisiana | 22051 | 66184 | 1041 |
1674809 | 1674809 | 2021-09-01 | Jefferson | Louisiana | 22051 | 66158 | 1034 |
1671560 | 1671560 | 2021-08-31 | Jefferson | Louisiana | 22051 | 65340 | 1018 |
1668313 | 1668313 | 2021-08-30 | Jefferson | Louisiana | 22051 | 65340 | 1018 |
1665066 | 1665066 | 2021-08-29 | Jefferson | Louisiana | 22051 | 65340 | 1018 |
1661818 | 1661818 | 2021-08-28 | Jefferson | Louisiana | 22051 | 65340 | 1018 |
1658570 | 1658570 | 2021-08-27 | Jefferson | Louisiana | 22051 | 65340 | 1018 |
1655322 | 1655322 | 2021-08-26 | Jefferson | Louisiana | 22051 | 64996 | 1013 |
1652075 | 1652075 | 2021-08-25 | Jefferson | Louisiana | 22051 | 64561 | 1011 |
1648826 | 1648826 | 2021-08-24 | Jefferson | Louisiana | 22051 | 64111 | 1007 |
1645578 | 1645578 | 2021-08-23 | Jefferson | Louisiana | 22051 | 63783 | 996 |
1642329 | 1642329 | 2021-08-22 | Jefferson | Louisiana | 22051 | 62791 | 993 |
1639079 | 1639079 | 2021-08-21 | Jefferson | Louisiana | 22051 | 62791 | 993 |
1635829 | 1635829 | 2021-08-20 | Jefferson | Louisiana | 22051 | 62791 | 993 |
1632579 | 1632579 | 2021-08-19 | Jefferson | Louisiana | 22051 | 62338 | 989 |
1629332 | 1629332 | 2021-08-18 | Jefferson | Louisiana | 22051 | 61889 | 986 |
1626085 | 1626085 | 2021-08-17 | Jefferson | Louisiana | 22051 | 61475 | 980 |
1622838 | 1622838 | 2021-08-16 | Jefferson | Louisiana | 22051 | 61075 | 966 |
1619591 | 1619591 | 2021-08-15 | Jefferson | Louisiana | 22051 | 59777 | 963 |
1616343 | 1616343 | 2021-08-14 | Jefferson | Louisiana | 22051 | 59777 | 963 |
1613094 | 1613094 | 2021-08-13 | Jefferson | Louisiana | 22051 | 59777 | 963 |
1609846 | 1609846 | 2021-08-12 | Jefferson | Louisiana | 22051 | 59130 | 959 |
1606597 | 1606597 | 2021-08-11 | Jefferson | Louisiana | 22051 | 58690 | 957 |
1603348 | 1603348 | 2021-08-10 | Jefferson | Louisiana | 22051 | 58156 | 953 |
1600099 | 1600099 | 2021-08-09 | Jefferson | Louisiana | 22051 | 57721 | 949 |
1596851 | 1596851 | 2021-08-08 | Jefferson | Louisiana | 22051 | 56220 | 947 |
1593602 | 1593602 | 2021-08-07 | Jefferson | Louisiana | 22051 | 56220 | 947 |
1590353 | 1590353 | 2021-08-06 | Jefferson | Louisiana | 22051 | 56220 | 947 |
1587104 | 1587104 | 2021-08-05 | Jefferson | Louisiana | 22051 | 55670 | 945 |
1583854 | 1583854 | 2021-08-04 | Jefferson | Louisiana | 22051 | 55109 | 945 |
1580604 | 1580604 | 2021-08-03 | Jefferson | Louisiana | 22051 | 54658 | 944 |
1577355 | 1577355 | 2021-08-02 | Jefferson | Louisiana | 22051 | 54313 | 939 |
1574107 | 1574107 | 2021-08-01 | Jefferson | Louisiana | 22051 | 52912 | 932 |
1570859 | 1570859 | 2021-07-31 | Jefferson | Louisiana | 22051 | 52912 | 932 |
1567611 | 1567611 | 2021-07-30 | Jefferson | Louisiana | 22051 | 52912 | 932 |
1564363 | 1564363 | 2021-07-29 | Jefferson | Louisiana | 22051 | 52348 | 925 |
1561115 | 1561115 | 2021-07-28 | Jefferson | Louisiana | 22051 | 51904 | 924 |
1557868 | 1557868 | 2021-07-27 | Jefferson | Louisiana | 22051 | 51515 | 920 |
1554621 | 1554621 | 2021-07-26 | Jefferson | Louisiana | 22051 | 51000 | 919 |
1551374 | 1551374 | 2021-07-25 | Jefferson | Louisiana | 22051 | 50084 | 918 |
1548127 | 1548127 | 2021-07-24 | Jefferson | Louisiana | 22051 | 50084 | 918 |
1544880 | 1544880 | 2021-07-23 | Jefferson | Louisiana | 22051 | 50084 | 918 |
1541632 | 1541632 | 2021-07-22 | Jefferson | Louisiana | 22051 | 49727 | 917 |
1538385 | 1538385 | 2021-07-21 | Jefferson | Louisiana | 22051 | 49455 | 917 |
1535137 | 1535137 | 2021-07-20 | Jefferson | Louisiana | 22051 | 49083 | 917 |
1531890 | 1531890 | 2021-07-19 | Jefferson | Louisiana | 22051 | 48976 | 914 |
1528643 | 1528643 | 2021-07-18 | Jefferson | Louisiana | 22051 | 48570 | 914 |
1525396 | 1525396 | 2021-07-17 | Jefferson | Louisiana | 22051 | 48570 | 914 |
1522148 | 1522148 | 2021-07-16 | Jefferson | Louisiana | 22051 | 48570 | 914 |
1518900 | 1518900 | 2021-07-15 | Jefferson | Louisiana | 22051 | 48442 | 914 |
1515653 | 1515653 | 2021-07-14 | Jefferson | Louisiana | 22051 | 48335 | 913 |
1512407 | 1512407 | 2021-07-13 | Jefferson | Louisiana | 22051 | 48212 | 913 |
1509160 | 1509160 | 2021-07-12 | Jefferson | Louisiana | 22051 | 48142 | 912 |
1505914 | 1505914 | 2021-07-11 | Jefferson | Louisiana | 22051 | 47995 | 912 |
1502668 | 1502668 | 2021-07-10 | Jefferson | Louisiana | 22051 | 47995 | 912 |
1499422 | 1499422 | 2021-07-09 | Jefferson | Louisiana | 22051 | 47995 | 912 |
1496175 | 1496175 | 2021-07-08 | Jefferson | Louisiana | 22051 | 47940 | 911 |
1492929 | 1492929 | 2021-07-07 | Jefferson | Louisiana | 22051 | 47877 | 911 |
1489682 | 1489682 | 2021-07-06 | Jefferson | Louisiana | 22051 | 47816 | 911 |
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);