ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,322 rows where county = "Lee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 12
- Florida 572
- Georgia 567
- Alabama 563
- South Carolina 561
- Mississippi 558
- North Carolina 557
- Virginia 557
- Arkansas 546
- Texas 546
- Illinois 543
- Iowa 543
- Kentucky 489
fips 12
county 1
- Lee · 6,602 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1766585 | 1766585 | 2021-09-29 | Lee | North Carolina | 37105 | 8950 | 99 |
1767074 | 1767074 | 2021-09-29 | Lee | South Carolina | 45061 | 2421 | 68 |
1767395 | 1767395 | 2021-09-29 | Lee | Texas | 48287 | 2814 | 47 |
1767622 | 1767622 | 2021-09-29 | Lee | Virginia | 51105 | 3409 | 52 |
1761418 | 1761418 | 2021-09-28 | Lee | Alabama | 1081 | 22751 | 220 |
1761527 | 1761527 | 2021-09-28 | Lee | Arkansas | 5077 | 2033 | 45 |
1761735 | 1761735 | 2021-09-28 | Lee | Florida | 12071 | 121291 | 1613 |
1761856 | 1761856 | 2021-09-28 | Lee | Georgia | 13177 | 4539 | 74 |
1762031 | 1762031 | 2021-09-28 | Lee | Illinois | 17103 | 4622 | 99 |
1762230 | 1762230 | 2021-09-28 | Lee | Iowa | 19111 | 5301 | 84 |
1762444 | 1762444 | 2021-09-28 | Lee | Kentucky | 21129 | 1673 | 29 |
1762834 | 1762834 | 2021-09-28 | Lee | Mississippi | 28081 | 15016 | 221 |
1763336 | 1763336 | 2021-09-28 | Lee | North Carolina | 37105 | 8905 | 98 |
1763825 | 1763825 | 2021-09-28 | Lee | South Carolina | 45061 | 2415 | 68 |
1764146 | 1764146 | 2021-09-28 | Lee | Texas | 48287 | 2808 | 47 |
1764373 | 1764373 | 2021-09-28 | Lee | Virginia | 51105 | 3386 | 52 |
1758170 | 1758170 | 2021-09-27 | Lee | Alabama | 1081 | 22712 | 220 |
1758279 | 1758279 | 2021-09-27 | Lee | Arkansas | 5077 | 2032 | 45 |
1758487 | 1758487 | 2021-09-27 | Lee | Florida | 12071 | 121291 | 1613 |
1758608 | 1758608 | 2021-09-27 | Lee | Georgia | 13177 | 4534 | 74 |
1758783 | 1758783 | 2021-09-27 | Lee | Illinois | 17103 | 4615 | 99 |
1758982 | 1758982 | 2021-09-27 | Lee | Iowa | 19111 | 5301 | 84 |
1759196 | 1759196 | 2021-09-27 | Lee | Kentucky | 21129 | 1672 | 29 |
1759585 | 1759585 | 2021-09-27 | Lee | Mississippi | 28081 | 14963 | 221 |
1760087 | 1760087 | 2021-09-27 | Lee | North Carolina | 37105 | 8867 | 97 |
1760576 | 1760576 | 2021-09-27 | Lee | South Carolina | 45061 | 2408 | 68 |
1760897 | 1760897 | 2021-09-27 | Lee | Texas | 48287 | 2804 | 47 |
1761124 | 1761124 | 2021-09-27 | Lee | Virginia | 51105 | 3367 | 52 |
1754922 | 1754922 | 2021-09-26 | Lee | Alabama | 1081 | 22680 | 220 |
1755031 | 1755031 | 2021-09-26 | Lee | Arkansas | 5077 | 2032 | 45 |
1755239 | 1755239 | 2021-09-26 | Lee | Florida | 12071 | 121291 | 1613 |
1755360 | 1755360 | 2021-09-26 | Lee | Georgia | 13177 | 4505 | 74 |
1755535 | 1755535 | 2021-09-26 | Lee | Illinois | 17103 | 4606 | 97 |
1755734 | 1755734 | 2021-09-26 | Lee | Iowa | 19111 | 5301 | 84 |
1755948 | 1755948 | 2021-09-26 | Lee | Kentucky | 21129 | 1659 | 29 |
1756337 | 1756337 | 2021-09-26 | Lee | Mississippi | 28081 | 14909 | 220 |
1756839 | 1756839 | 2021-09-26 | Lee | North Carolina | 37105 | 8785 | 97 |
1757328 | 1757328 | 2021-09-26 | Lee | South Carolina | 45061 | 2391 | 68 |
1757649 | 1757649 | 2021-09-26 | Lee | Texas | 48287 | 2792 | 47 |
1757876 | 1757876 | 2021-09-26 | Lee | Virginia | 51105 | 3293 | 52 |
1751674 | 1751674 | 2021-09-25 | Lee | Alabama | 1081 | 22590 | 220 |
1751783 | 1751783 | 2021-09-25 | Lee | Arkansas | 5077 | 2030 | 44 |
1751991 | 1751991 | 2021-09-25 | Lee | Florida | 12071 | 121291 | 1613 |
1752112 | 1752112 | 2021-09-25 | Lee | Georgia | 13177 | 4505 | 74 |
1752287 | 1752287 | 2021-09-25 | Lee | Illinois | 17103 | 4606 | 97 |
1752486 | 1752486 | 2021-09-25 | Lee | Iowa | 19111 | 5301 | 84 |
1752700 | 1752700 | 2021-09-25 | Lee | Kentucky | 21129 | 1659 | 29 |
1753089 | 1753089 | 2021-09-25 | Lee | Mississippi | 28081 | 14909 | 220 |
1753591 | 1753591 | 2021-09-25 | Lee | North Carolina | 37105 | 8785 | 97 |
1754080 | 1754080 | 2021-09-25 | Lee | South Carolina | 45061 | 2391 | 68 |
1754401 | 1754401 | 2021-09-25 | Lee | Texas | 48287 | 2792 | 47 |
1754628 | 1754628 | 2021-09-25 | Lee | Virginia | 51105 | 3293 | 52 |
1748425 | 1748425 | 2021-09-24 | Lee | Alabama | 1081 | 22407 | 219 |
1748534 | 1748534 | 2021-09-24 | Lee | Arkansas | 5077 | 2027 | 44 |
1748742 | 1748742 | 2021-09-24 | Lee | Florida | 12071 | 121291 | 1539 |
1748863 | 1748863 | 2021-09-24 | Lee | Georgia | 13177 | 4505 | 74 |
1749038 | 1749038 | 2021-09-24 | Lee | Illinois | 17103 | 4606 | 97 |
1749237 | 1749237 | 2021-09-24 | Lee | Iowa | 19111 | 5301 | 84 |
1749451 | 1749451 | 2021-09-24 | Lee | Kentucky | 21129 | 1659 | 29 |
1749841 | 1749841 | 2021-09-24 | Lee | Mississippi | 28081 | 14909 | 220 |
1750343 | 1750343 | 2021-09-24 | Lee | North Carolina | 37105 | 8785 | 97 |
1750832 | 1750832 | 2021-09-24 | Lee | South Carolina | 45061 | 2391 | 68 |
1751153 | 1751153 | 2021-09-24 | Lee | Texas | 48287 | 2771 | 47 |
1751380 | 1751380 | 2021-09-24 | Lee | Virginia | 51105 | 3293 | 52 |
1745175 | 1745175 | 2021-09-23 | Lee | Alabama | 1081 | 22337 | 218 |
1745284 | 1745284 | 2021-09-23 | Lee | Arkansas | 5077 | 2027 | 44 |
1745492 | 1745492 | 2021-09-23 | Lee | Florida | 12071 | 119066 | 1539 |
1745613 | 1745613 | 2021-09-23 | Lee | Georgia | 13177 | 4490 | 74 |
1745788 | 1745788 | 2021-09-23 | Lee | Illinois | 17103 | 4595 | 97 |
1745987 | 1745987 | 2021-09-23 | Lee | Iowa | 19111 | 5301 | 84 |
1746201 | 1746201 | 2021-09-23 | Lee | Kentucky | 21129 | 1654 | 29 |
1746591 | 1746591 | 2021-09-23 | Lee | Mississippi | 28081 | 14867 | 220 |
1747093 | 1747093 | 2021-09-23 | Lee | North Carolina | 37105 | 8741 | 97 |
1747583 | 1747583 | 2021-09-23 | Lee | South Carolina | 45061 | 2381 | 68 |
1747904 | 1747904 | 2021-09-23 | Lee | Texas | 48287 | 2771 | 47 |
1748131 | 1748131 | 2021-09-23 | Lee | Virginia | 51105 | 3273 | 51 |
1741926 | 1741926 | 2021-09-22 | Lee | Alabama | 1081 | 22231 | 216 |
1742035 | 1742035 | 2021-09-22 | Lee | Arkansas | 5077 | 2020 | 44 |
1742243 | 1742243 | 2021-09-22 | Lee | Florida | 12071 | 119066 | 1539 |
1742364 | 1742364 | 2021-09-22 | Lee | Georgia | 13177 | 4477 | 74 |
1742539 | 1742539 | 2021-09-22 | Lee | Illinois | 17103 | 4581 | 95 |
1742738 | 1742738 | 2021-09-22 | Lee | Iowa | 19111 | 5301 | 84 |
1742952 | 1742952 | 2021-09-22 | Lee | Kentucky | 21129 | 1648 | 29 |
1743342 | 1743342 | 2021-09-22 | Lee | Mississippi | 28081 | 14803 | 219 |
1743844 | 1743844 | 2021-09-22 | Lee | North Carolina | 37105 | 8694 | 97 |
1744333 | 1744333 | 2021-09-22 | Lee | South Carolina | 45061 | 2373 | 68 |
1744654 | 1744654 | 2021-09-22 | Lee | Texas | 48287 | 2769 | 45 |
1744881 | 1744881 | 2021-09-22 | Lee | Virginia | 51105 | 3233 | 51 |
1738677 | 1738677 | 2021-09-21 | Lee | Alabama | 1081 | 22147 | 210 |
1738786 | 1738786 | 2021-09-21 | Lee | Arkansas | 5077 | 2005 | 43 |
1738994 | 1738994 | 2021-09-21 | Lee | Florida | 12071 | 119066 | 1539 |
1739115 | 1739115 | 2021-09-21 | Lee | Georgia | 13177 | 4460 | 74 |
1739290 | 1739290 | 2021-09-21 | Lee | Illinois | 17103 | 4570 | 95 |
1739489 | 1739489 | 2021-09-21 | Lee | Iowa | 19111 | 5121 | 78 |
1739703 | 1739703 | 2021-09-21 | Lee | Kentucky | 21129 | 1646 | 29 |
1740093 | 1740093 | 2021-09-21 | Lee | Mississippi | 28081 | 14732 | 219 |
1740595 | 1740595 | 2021-09-21 | Lee | North Carolina | 37105 | 8658 | 97 |
1741084 | 1741084 | 2021-09-21 | Lee | South Carolina | 45061 | 2370 | 68 |
1741405 | 1741405 | 2021-09-21 | Lee | Texas | 48287 | 2755 | 45 |
1741632 | 1741632 | 2021-09-21 | Lee | Virginia | 51105 | 3194 | 51 |
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);