ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Lawrence", fips = 5075 and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1813514 | 1813514 | 2021-10-14 | Lawrence | Arkansas | 5075 | 3225 | 55 |
1810265 | 1810265 | 2021-10-13 | Lawrence | Arkansas | 5075 | 3220 | 55 |
1807016 | 1807016 | 2021-10-12 | Lawrence | Arkansas | 5075 | 3215 | 55 |
1803765 | 1803765 | 2021-10-11 | Lawrence | Arkansas | 5075 | 3213 | 55 |
1800516 | 1800516 | 2021-10-10 | Lawrence | Arkansas | 5075 | 3210 | 55 |
1797267 | 1797267 | 2021-10-09 | Lawrence | Arkansas | 5075 | 3207 | 55 |
1794018 | 1794018 | 2021-10-08 | Lawrence | Arkansas | 5075 | 3196 | 55 |
1790770 | 1790770 | 2021-10-07 | Lawrence | Arkansas | 5075 | 3192 | 55 |
1787521 | 1787521 | 2021-10-06 | Lawrence | Arkansas | 5075 | 3181 | 54 |
1784272 | 1784272 | 2021-10-05 | Lawrence | Arkansas | 5075 | 3173 | 53 |
1781023 | 1781023 | 2021-10-04 | Lawrence | Arkansas | 5075 | 3160 | 53 |
1777773 | 1777773 | 2021-10-03 | Lawrence | Arkansas | 5075 | 3160 | 53 |
1774523 | 1774523 | 2021-10-02 | Lawrence | Arkansas | 5075 | 3154 | 53 |
1771273 | 1771273 | 2021-10-01 | Lawrence | Arkansas | 5075 | 3145 | 53 |
1768024 | 1768024 | 2021-09-30 | Lawrence | Arkansas | 5075 | 3135 | 52 |
1764775 | 1764775 | 2021-09-29 | Lawrence | Arkansas | 5075 | 3128 | 52 |
1761526 | 1761526 | 2021-09-28 | Lawrence | Arkansas | 5075 | 3117 | 50 |
1758278 | 1758278 | 2021-09-27 | Lawrence | Arkansas | 5075 | 3115 | 50 |
1755030 | 1755030 | 2021-09-26 | Lawrence | Arkansas | 5075 | 3107 | 50 |
1751782 | 1751782 | 2021-09-25 | Lawrence | Arkansas | 5075 | 3106 | 50 |
1748533 | 1748533 | 2021-09-24 | Lawrence | Arkansas | 5075 | 3104 | 50 |
1745283 | 1745283 | 2021-09-23 | Lawrence | Arkansas | 5075 | 3095 | 50 |
1742034 | 1742034 | 2021-09-22 | Lawrence | Arkansas | 5075 | 3077 | 50 |
1738785 | 1738785 | 2021-09-21 | Lawrence | Arkansas | 5075 | 3066 | 50 |
1735536 | 1735536 | 2021-09-20 | Lawrence | Arkansas | 5075 | 3046 | 50 |
1732286 | 1732286 | 2021-09-19 | Lawrence | Arkansas | 5075 | 3044 | 49 |
1729036 | 1729036 | 2021-09-18 | Lawrence | Arkansas | 5075 | 3031 | 49 |
1725786 | 1725786 | 2021-09-17 | Lawrence | Arkansas | 5075 | 3022 | 49 |
1722537 | 1722537 | 2021-09-16 | Lawrence | Arkansas | 5075 | 3006 | 49 |
1719288 | 1719288 | 2021-09-15 | Lawrence | Arkansas | 5075 | 2995 | 48 |
1716040 | 1716040 | 2021-09-14 | Lawrence | Arkansas | 5075 | 2982 | 47 |
1712794 | 1712794 | 2021-09-13 | Lawrence | Arkansas | 5075 | 2968 | 47 |
1709547 | 1709547 | 2021-09-12 | Lawrence | Arkansas | 5075 | 2957 | 47 |
1706300 | 1706300 | 2021-09-11 | Lawrence | Arkansas | 5075 | 2945 | 47 |
1703052 | 1703052 | 2021-09-10 | Lawrence | Arkansas | 5075 | 2911 | 47 |
1699802 | 1699802 | 2021-09-09 | Lawrence | Arkansas | 5075 | 2876 | 47 |
1696553 | 1696553 | 2021-09-08 | Lawrence | Arkansas | 5075 | 2853 | 47 |
1693305 | 1693305 | 2021-09-07 | Lawrence | Arkansas | 5075 | 2838 | 47 |
1690056 | 1690056 | 2021-09-06 | Lawrence | Arkansas | 5075 | 2836 | 47 |
1686806 | 1686806 | 2021-09-05 | Lawrence | Arkansas | 5075 | 2826 | 46 |
1683556 | 1683556 | 2021-09-04 | Lawrence | Arkansas | 5075 | 2807 | 46 |
1680305 | 1680305 | 2021-09-03 | Lawrence | Arkansas | 5075 | 2774 | 46 |
1677057 | 1677057 | 2021-09-02 | Lawrence | Arkansas | 5075 | 2746 | 46 |
1673810 | 1673810 | 2021-09-01 | Lawrence | Arkansas | 5075 | 2717 | 46 |
1670562 | 1670562 | 2021-08-31 | Lawrence | Arkansas | 5075 | 2699 | 45 |
1667315 | 1667315 | 2021-08-30 | Lawrence | Arkansas | 5075 | 2669 | 45 |
1664068 | 1664068 | 2021-08-29 | Lawrence | Arkansas | 5075 | 2661 | 45 |
1660820 | 1660820 | 2021-08-28 | Lawrence | Arkansas | 5075 | 2650 | 44 |
1657572 | 1657572 | 2021-08-27 | Lawrence | Arkansas | 5075 | 2639 | 44 |
1654324 | 1654324 | 2021-08-26 | Lawrence | Arkansas | 5075 | 2614 | 44 |
1651077 | 1651077 | 2021-08-25 | Lawrence | Arkansas | 5075 | 2602 | 44 |
1647828 | 1647828 | 2021-08-24 | Lawrence | Arkansas | 5075 | 2577 | 43 |
1644580 | 1644580 | 2021-08-23 | Lawrence | Arkansas | 5075 | 2559 | 43 |
1641330 | 1641330 | 2021-08-22 | Lawrence | Arkansas | 5075 | 2548 | 43 |
1638080 | 1638080 | 2021-08-21 | Lawrence | Arkansas | 5075 | 2540 | 43 |
1634830 | 1634830 | 2021-08-20 | Lawrence | Arkansas | 5075 | 2527 | 43 |
1631581 | 1631581 | 2021-08-19 | Lawrence | Arkansas | 5075 | 2516 | 43 |
1628334 | 1628334 | 2021-08-18 | Lawrence | Arkansas | 5075 | 2494 | 43 |
1625087 | 1625087 | 2021-08-17 | Lawrence | Arkansas | 5075 | 2471 | 43 |
1621840 | 1621840 | 2021-08-16 | Lawrence | Arkansas | 5075 | 2452 | 43 |
1618593 | 1618593 | 2021-08-15 | Lawrence | Arkansas | 5075 | 2447 | 43 |
1615345 | 1615345 | 2021-08-14 | Lawrence | Arkansas | 5075 | 2445 | 43 |
1612096 | 1612096 | 2021-08-13 | Lawrence | Arkansas | 5075 | 2432 | 43 |
1608848 | 1608848 | 2021-08-12 | Lawrence | Arkansas | 5075 | 2418 | 43 |
1605599 | 1605599 | 2021-08-11 | Lawrence | Arkansas | 5075 | 2407 | 43 |
1602350 | 1602350 | 2021-08-10 | Lawrence | Arkansas | 5075 | 2394 | 43 |
1599101 | 1599101 | 2021-08-09 | Lawrence | Arkansas | 5075 | 2375 | 43 |
1595852 | 1595852 | 2021-08-08 | Lawrence | Arkansas | 5075 | 2368 | 43 |
1592603 | 1592603 | 2021-08-07 | Lawrence | Arkansas | 5075 | 2362 | 43 |
1589354 | 1589354 | 2021-08-06 | Lawrence | Arkansas | 5075 | 2353 | 43 |
1586105 | 1586105 | 2021-08-05 | Lawrence | Arkansas | 5075 | 2340 | 43 |
1582855 | 1582855 | 2021-08-04 | Lawrence | Arkansas | 5075 | 2330 | 43 |
1579605 | 1579605 | 2021-08-03 | Lawrence | Arkansas | 5075 | 2315 | 43 |
1576357 | 1576357 | 2021-08-02 | Lawrence | Arkansas | 5075 | 2304 | 43 |
1573109 | 1573109 | 2021-08-01 | Lawrence | Arkansas | 5075 | 2303 | 43 |
1569861 | 1569861 | 2021-07-31 | Lawrence | Arkansas | 5075 | 2300 | 43 |
1566613 | 1566613 | 2021-07-30 | Lawrence | Arkansas | 5075 | 2295 | 43 |
1563365 | 1563365 | 2021-07-29 | Lawrence | Arkansas | 5075 | 2284 | 43 |
1560117 | 1560117 | 2021-07-28 | Lawrence | Arkansas | 5075 | 2279 | 43 |
1556870 | 1556870 | 2021-07-27 | Lawrence | Arkansas | 5075 | 2279 | 43 |
1553623 | 1553623 | 2021-07-26 | Lawrence | Arkansas | 5075 | 2268 | 43 |
1550376 | 1550376 | 2021-07-25 | Lawrence | Arkansas | 5075 | 2267 | 43 |
1547129 | 1547129 | 2021-07-24 | Lawrence | Arkansas | 5075 | 2265 | 43 |
1543882 | 1543882 | 2021-07-23 | Lawrence | Arkansas | 5075 | 2262 | 43 |
1540634 | 1540634 | 2021-07-22 | Lawrence | Arkansas | 5075 | 2259 | 43 |
1537387 | 1537387 | 2021-07-21 | Lawrence | Arkansas | 5075 | 2250 | 43 |
1534139 | 1534139 | 2021-07-20 | Lawrence | Arkansas | 5075 | 2249 | 43 |
1530892 | 1530892 | 2021-07-19 | Lawrence | Arkansas | 5075 | 2236 | 43 |
1527645 | 1527645 | 2021-07-18 | Lawrence | Arkansas | 5075 | 2228 | 43 |
1524398 | 1524398 | 2021-07-17 | Lawrence | Arkansas | 5075 | 2228 | 43 |
1521150 | 1521150 | 2021-07-16 | Lawrence | Arkansas | 5075 | 2228 | 43 |
1517902 | 1517902 | 2021-07-15 | Lawrence | Arkansas | 5075 | 2223 | 43 |
1514655 | 1514655 | 2021-07-14 | Lawrence | Arkansas | 5075 | 2217 | 43 |
1511409 | 1511409 | 2021-07-13 | Lawrence | Arkansas | 5075 | 2207 | 43 |
1508162 | 1508162 | 2021-07-12 | Lawrence | Arkansas | 5075 | 2198 | 43 |
1504916 | 1504916 | 2021-07-11 | Lawrence | Arkansas | 5075 | 2196 | 43 |
1501670 | 1501670 | 2021-07-10 | Lawrence | Arkansas | 5075 | 2196 | 43 |
1498424 | 1498424 | 2021-07-09 | Lawrence | Arkansas | 5075 | 2196 | 43 |
1495177 | 1495177 | 2021-07-08 | Lawrence | Arkansas | 5075 | 2188 | 43 |
1491930 | 1491930 | 2021-07-07 | Lawrence | Arkansas | 5075 | 2179 | 43 |
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);