ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Vernon" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717072 | 1717072 | 2021-09-14 | Vernon | Louisiana | 22115 | 5589 | 142 |
1713825 | 1713825 | 2021-09-13 | Vernon | Louisiana | 22115 | 5531 | 140 |
1710579 | 1710579 | 2021-09-12 | Vernon | Louisiana | 22115 | 5442 | 139 |
1707332 | 1707332 | 2021-09-11 | Vernon | Louisiana | 22115 | 5442 | 139 |
1704084 | 1704084 | 2021-09-10 | Vernon | Louisiana | 22115 | 5442 | 139 |
1700834 | 1700834 | 2021-09-09 | Vernon | Louisiana | 22115 | 5415 | 137 |
1697585 | 1697585 | 2021-09-08 | Vernon | Louisiana | 22115 | 5246 | 137 |
1694337 | 1694337 | 2021-09-07 | Vernon | Louisiana | 22115 | 5123 | 134 |
1691088 | 1691088 | 2021-09-06 | Vernon | Louisiana | 22115 | 5070 | 134 |
1687838 | 1687838 | 2021-09-05 | Vernon | Louisiana | 22115 | 5070 | 134 |
1684588 | 1684588 | 2021-09-04 | Vernon | Louisiana | 22115 | 5070 | 134 |
1681337 | 1681337 | 2021-09-03 | Vernon | Louisiana | 22115 | 5070 | 134 |
1678089 | 1678089 | 2021-09-02 | Vernon | Louisiana | 22115 | 4976 | 134 |
1674842 | 1674842 | 2021-09-01 | Vernon | Louisiana | 22115 | 4946 | 131 |
1671593 | 1671593 | 2021-08-31 | Vernon | Louisiana | 22115 | 4775 | 129 |
1668346 | 1668346 | 2021-08-30 | Vernon | Louisiana | 22115 | 4775 | 129 |
1665099 | 1665099 | 2021-08-29 | Vernon | Louisiana | 22115 | 4775 | 129 |
1661851 | 1661851 | 2021-08-28 | Vernon | Louisiana | 22115 | 4775 | 129 |
1658603 | 1658603 | 2021-08-27 | Vernon | Louisiana | 22115 | 4775 | 129 |
1655355 | 1655355 | 2021-08-26 | Vernon | Louisiana | 22115 | 4744 | 129 |
1652108 | 1652108 | 2021-08-25 | Vernon | Louisiana | 22115 | 4683 | 129 |
1648859 | 1648859 | 2021-08-24 | Vernon | Louisiana | 22115 | 4620 | 129 |
1645611 | 1645611 | 2021-08-23 | Vernon | Louisiana | 22115 | 4599 | 127 |
1642362 | 1642362 | 2021-08-22 | Vernon | Louisiana | 22115 | 4509 | 125 |
1639112 | 1639112 | 2021-08-21 | Vernon | Louisiana | 22115 | 4509 | 125 |
1635862 | 1635862 | 2021-08-20 | Vernon | Louisiana | 22115 | 4509 | 125 |
1632612 | 1632612 | 2021-08-19 | Vernon | Louisiana | 22115 | 4473 | 125 |
1629365 | 1629365 | 2021-08-18 | Vernon | Louisiana | 22115 | 4418 | 124 |
1626118 | 1626118 | 2021-08-17 | Vernon | Louisiana | 22115 | 4351 | 123 |
1622871 | 1622871 | 2021-08-16 | Vernon | Louisiana | 22115 | 4324 | 122 |
1619624 | 1619624 | 2021-08-15 | Vernon | Louisiana | 22115 | 4179 | 121 |
1616376 | 1616376 | 2021-08-14 | Vernon | Louisiana | 22115 | 4179 | 121 |
1613127 | 1613127 | 2021-08-13 | Vernon | Louisiana | 22115 | 4179 | 121 |
1609879 | 1609879 | 2021-08-12 | Vernon | Louisiana | 22115 | 4146 | 121 |
1606630 | 1606630 | 2021-08-11 | Vernon | Louisiana | 22115 | 4106 | 118 |
1603381 | 1603381 | 2021-08-10 | Vernon | Louisiana | 22115 | 4075 | 116 |
1600132 | 1600132 | 2021-08-09 | Vernon | Louisiana | 22115 | 4006 | 115 |
1596884 | 1596884 | 2021-08-08 | Vernon | Louisiana | 22115 | 3900 | 114 |
1593635 | 1593635 | 2021-08-07 | Vernon | Louisiana | 22115 | 3900 | 114 |
1590386 | 1590386 | 2021-08-06 | Vernon | Louisiana | 22115 | 3900 | 114 |
1587137 | 1587137 | 2021-08-05 | Vernon | Louisiana | 22115 | 3862 | 112 |
1583887 | 1583887 | 2021-08-04 | Vernon | Louisiana | 22115 | 3817 | 112 |
1580637 | 1580637 | 2021-08-03 | Vernon | Louisiana | 22115 | 3780 | 111 |
1577388 | 1577388 | 2021-08-02 | Vernon | Louisiana | 22115 | 3730 | 109 |
1574140 | 1574140 | 2021-08-01 | Vernon | Louisiana | 22115 | 3650 | 108 |
1570892 | 1570892 | 2021-07-31 | Vernon | Louisiana | 22115 | 3650 | 108 |
1567644 | 1567644 | 2021-07-30 | Vernon | Louisiana | 22115 | 3650 | 108 |
1564396 | 1564396 | 2021-07-29 | Vernon | Louisiana | 22115 | 3609 | 108 |
1561148 | 1561148 | 2021-07-28 | Vernon | Louisiana | 22115 | 3562 | 108 |
1557901 | 1557901 | 2021-07-27 | Vernon | Louisiana | 22115 | 3524 | 108 |
1554654 | 1554654 | 2021-07-26 | Vernon | Louisiana | 22115 | 3467 | 108 |
1551407 | 1551407 | 2021-07-25 | Vernon | Louisiana | 22115 | 3430 | 108 |
1548160 | 1548160 | 2021-07-24 | Vernon | Louisiana | 22115 | 3430 | 108 |
1544913 | 1544913 | 2021-07-23 | Vernon | Louisiana | 22115 | 3430 | 108 |
1541665 | 1541665 | 2021-07-22 | Vernon | Louisiana | 22115 | 3405 | 108 |
1538418 | 1538418 | 2021-07-21 | Vernon | Louisiana | 22115 | 3380 | 107 |
1535170 | 1535170 | 2021-07-20 | Vernon | Louisiana | 22115 | 3361 | 107 |
1531923 | 1531923 | 2021-07-19 | Vernon | Louisiana | 22115 | 3351 | 107 |
1528676 | 1528676 | 2021-07-18 | Vernon | Louisiana | 22115 | 3323 | 107 |
1525429 | 1525429 | 2021-07-17 | Vernon | Louisiana | 22115 | 3323 | 107 |
1522181 | 1522181 | 2021-07-16 | Vernon | Louisiana | 22115 | 3323 | 107 |
1518933 | 1518933 | 2021-07-15 | Vernon | Louisiana | 22115 | 3305 | 107 |
1515686 | 1515686 | 2021-07-14 | Vernon | Louisiana | 22115 | 3291 | 107 |
1512440 | 1512440 | 2021-07-13 | Vernon | Louisiana | 22115 | 3276 | 106 |
1509193 | 1509193 | 2021-07-12 | Vernon | Louisiana | 22115 | 3273 | 106 |
1505947 | 1505947 | 2021-07-11 | Vernon | Louisiana | 22115 | 3264 | 106 |
1502701 | 1502701 | 2021-07-10 | Vernon | Louisiana | 22115 | 3264 | 106 |
1499455 | 1499455 | 2021-07-09 | Vernon | Louisiana | 22115 | 3264 | 106 |
1496208 | 1496208 | 2021-07-08 | Vernon | Louisiana | 22115 | 3248 | 106 |
1492962 | 1492962 | 2021-07-07 | Vernon | Louisiana | 22115 | 3245 | 106 |
1489715 | 1489715 | 2021-07-06 | Vernon | Louisiana | 22115 | 3241 | 106 |
1486468 | 1486468 | 2021-07-05 | Vernon | Louisiana | 22115 | 3232 | 106 |
1483222 | 1483222 | 2021-07-04 | Vernon | Louisiana | 22115 | 3232 | 106 |
1479975 | 1479975 | 2021-07-03 | Vernon | Louisiana | 22115 | 3232 | 106 |
1476729 | 1476729 | 2021-07-02 | Vernon | Louisiana | 22115 | 3232 | 106 |
1473483 | 1473483 | 2021-07-01 | Vernon | Louisiana | 22115 | 3222 | 105 |
1470237 | 1470237 | 2021-06-30 | Vernon | Louisiana | 22115 | 3220 | 105 |
1466992 | 1466992 | 2021-06-29 | Vernon | Louisiana | 22115 | 3214 | 105 |
1463747 | 1463747 | 2021-06-28 | Vernon | Louisiana | 22115 | 3204 | 105 |
1460502 | 1460502 | 2021-06-27 | Vernon | Louisiana | 22115 | 3199 | 105 |
1457257 | 1457257 | 2021-06-26 | Vernon | Louisiana | 22115 | 3199 | 105 |
1454012 | 1454012 | 2021-06-25 | Vernon | Louisiana | 22115 | 3199 | 105 |
1450766 | 1450766 | 2021-06-24 | Vernon | Louisiana | 22115 | 3199 | 105 |
1447521 | 1447521 | 2021-06-23 | Vernon | Louisiana | 22115 | 3196 | 105 |
1444276 | 1444276 | 2021-06-22 | Vernon | Louisiana | 22115 | 3192 | 105 |
1441031 | 1441031 | 2021-06-21 | Vernon | Louisiana | 22115 | 3193 | 105 |
1437784 | 1437784 | 2021-06-20 | Vernon | Louisiana | 22115 | 3192 | 105 |
1434537 | 1434537 | 2021-06-19 | Vernon | Louisiana | 22115 | 3192 | 105 |
1431291 | 1431291 | 2021-06-18 | Vernon | Louisiana | 22115 | 3192 | 105 |
1428046 | 1428046 | 2021-06-17 | Vernon | Louisiana | 22115 | 3191 | 105 |
1424801 | 1424801 | 2021-06-16 | Vernon | Louisiana | 22115 | 3190 | 105 |
1421553 | 1421553 | 2021-06-15 | Vernon | Louisiana | 22115 | 3189 | 104 |
1418308 | 1418308 | 2021-06-14 | Vernon | Louisiana | 22115 | 3187 | 104 |
1415062 | 1415062 | 2021-06-13 | Vernon | Louisiana | 22115 | 3186 | 104 |
1411817 | 1411817 | 2021-06-12 | Vernon | Louisiana | 22115 | 3186 | 104 |
1408572 | 1408572 | 2021-06-11 | Vernon | Louisiana | 22115 | 3186 | 104 |
1405326 | 1405326 | 2021-06-10 | Vernon | Louisiana | 22115 | 3186 | 104 |
1402081 | 1402081 | 2021-06-09 | Vernon | Louisiana | 22115 | 3182 | 104 |
1398836 | 1398836 | 2021-06-08 | Vernon | Louisiana | 22115 | 3178 | 104 |
1395589 | 1395589 | 2021-06-07 | Vernon | Louisiana | 22115 | 3176 | 104 |
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);