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 |
---|---|---|---|---|---|---|---|
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 |
1486435 | 1486435 | 2021-07-05 | Jefferson | Louisiana | 22051 | 47666 | 911 |
1483189 | 1483189 | 2021-07-04 | Jefferson | Louisiana | 22051 | 47666 | 911 |
1479942 | 1479942 | 2021-07-03 | Jefferson | Louisiana | 22051 | 47666 | 911 |
1476696 | 1476696 | 2021-07-02 | Jefferson | Louisiana | 22051 | 47666 | 911 |
1473450 | 1473450 | 2021-07-01 | Jefferson | Louisiana | 22051 | 47640 | 911 |
1470204 | 1470204 | 2021-06-30 | Jefferson | Louisiana | 22051 | 47582 | 911 |
1466959 | 1466959 | 2021-06-29 | Jefferson | Louisiana | 22051 | 47551 | 910 |
1463714 | 1463714 | 2021-06-28 | Jefferson | Louisiana | 22051 | 47526 | 908 |
1460469 | 1460469 | 2021-06-27 | Jefferson | Louisiana | 22051 | 47459 | 908 |
1457224 | 1457224 | 2021-06-26 | Jefferson | Louisiana | 22051 | 47459 | 908 |
1453979 | 1453979 | 2021-06-25 | Jefferson | Louisiana | 22051 | 47459 | 908 |
1450733 | 1450733 | 2021-06-24 | Jefferson | Louisiana | 22051 | 47444 | 908 |
1447488 | 1447488 | 2021-06-23 | Jefferson | Louisiana | 22051 | 47423 | 908 |
1444243 | 1444243 | 2021-06-22 | Jefferson | Louisiana | 22051 | 47401 | 907 |
1440998 | 1440998 | 2021-06-21 | Jefferson | Louisiana | 22051 | 47380 | 906 |
1437751 | 1437751 | 2021-06-20 | Jefferson | Louisiana | 22051 | 47339 | 906 |
1434504 | 1434504 | 2021-06-19 | Jefferson | Louisiana | 22051 | 47339 | 906 |
1431258 | 1431258 | 2021-06-18 | Jefferson | Louisiana | 22051 | 47339 | 906 |
1428013 | 1428013 | 2021-06-17 | Jefferson | Louisiana | 22051 | 47316 | 905 |
1424768 | 1424768 | 2021-06-16 | Jefferson | Louisiana | 22051 | 47289 | 903 |
1421520 | 1421520 | 2021-06-15 | Jefferson | Louisiana | 22051 | 47257 | 902 |
1418275 | 1418275 | 2021-06-14 | Jefferson | Louisiana | 22051 | 47212 | 901 |
1415029 | 1415029 | 2021-06-13 | Jefferson | Louisiana | 22051 | 47175 | 901 |
1411784 | 1411784 | 2021-06-12 | Jefferson | Louisiana | 22051 | 47175 | 901 |
1408539 | 1408539 | 2021-06-11 | Jefferson | Louisiana | 22051 | 47175 | 901 |
1405293 | 1405293 | 2021-06-10 | Jefferson | Louisiana | 22051 | 47149 | 901 |
1402048 | 1402048 | 2021-06-09 | Jefferson | Louisiana | 22051 | 47108 | 901 |
1398803 | 1398803 | 2021-06-08 | Jefferson | Louisiana | 22051 | 47063 | 899 |
1395556 | 1395556 | 2021-06-07 | Jefferson | Louisiana | 22051 | 47023 | 899 |
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);