ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,867 rows where county = "Anderson" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 5
- South Carolina 580
- Tennessee 575
- Kentucky 573
- Texas 563
- Kansas 524
county 1
- Anderson · 2,815 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1819034 | 1819034 | 2021-10-15 | Anderson | South Carolina | 45007 | 35853 | 713 |
1819143 | 1819143 | 2021-10-15 | Anderson | Tennessee | 47001 | 12734 | 212 |
1819239 | 1819239 | 2021-10-15 | Anderson | Texas | 48001 | 7952 | 192 |
1814264 | 1814264 | 2021-10-14 | Anderson | Kansas | 20003 | 1087 | 21 |
1814370 | 1814370 | 2021-10-14 | Anderson | Kentucky | 21005 | 3246 | 40 |
1815785 | 1815785 | 2021-10-14 | Anderson | South Carolina | 45007 | 35787 | 705 |
1815894 | 1815894 | 2021-10-14 | Anderson | Tennessee | 47001 | 12716 | 211 |
1815990 | 1815990 | 2021-10-14 | Anderson | Texas | 48001 | 7904 | 191 |
1811015 | 1811015 | 2021-10-13 | Anderson | Kansas | 20003 | 1087 | 21 |
1811121 | 1811121 | 2021-10-13 | Anderson | Kentucky | 21005 | 3214 | 40 |
1812537 | 1812537 | 2021-10-13 | Anderson | South Carolina | 45007 | 35718 | 704 |
1812646 | 1812646 | 2021-10-13 | Anderson | Tennessee | 47001 | 12684 | 211 |
1812742 | 1812742 | 2021-10-13 | Anderson | Texas | 48001 | 7905 | 191 |
1807766 | 1807766 | 2021-10-12 | Anderson | Kansas | 20003 | 1081 | 21 |
1807872 | 1807872 | 2021-10-12 | Anderson | Kentucky | 21005 | 3168 | 40 |
1809288 | 1809288 | 2021-10-12 | Anderson | South Carolina | 45007 | 35691 | 699 |
1809397 | 1809397 | 2021-10-12 | Anderson | Tennessee | 47001 | 12648 | 209 |
1809493 | 1809493 | 2021-10-12 | Anderson | Texas | 48001 | 7910 | 190 |
1804515 | 1804515 | 2021-10-11 | Anderson | Kansas | 20003 | 1081 | 21 |
1804621 | 1804621 | 2021-10-11 | Anderson | Kentucky | 21005 | 3146 | 40 |
1806038 | 1806038 | 2021-10-11 | Anderson | South Carolina | 45007 | 35655 | 697 |
1806147 | 1806147 | 2021-10-11 | Anderson | Tennessee | 47001 | 12608 | 209 |
1806243 | 1806243 | 2021-10-11 | Anderson | Texas | 48001 | 7884 | 189 |
1801266 | 1801266 | 2021-10-10 | Anderson | Kansas | 20003 | 1081 | 21 |
1801372 | 1801372 | 2021-10-10 | Anderson | Kentucky | 21005 | 3123 | 39 |
1802788 | 1802788 | 2021-10-10 | Anderson | South Carolina | 45007 | 35414 | 692 |
1802897 | 1802897 | 2021-10-10 | Anderson | Tennessee | 47001 | 12548 | 208 |
1802993 | 1802993 | 2021-10-10 | Anderson | Texas | 48001 | 7884 | 189 |
1798017 | 1798017 | 2021-10-09 | Anderson | Kansas | 20003 | 1081 | 21 |
1798123 | 1798123 | 2021-10-09 | Anderson | Kentucky | 21005 | 3123 | 39 |
1799539 | 1799539 | 2021-10-09 | Anderson | South Carolina | 45007 | 35414 | 692 |
1799648 | 1799648 | 2021-10-09 | Anderson | Tennessee | 47001 | 12548 | 208 |
1799744 | 1799744 | 2021-10-09 | Anderson | Texas | 48001 | 7884 | 188 |
1794768 | 1794768 | 2021-10-08 | Anderson | Kansas | 20003 | 1081 | 21 |
1794874 | 1794874 | 2021-10-08 | Anderson | Kentucky | 21005 | 3123 | 39 |
1796290 | 1796290 | 2021-10-08 | Anderson | South Carolina | 45007 | 35414 | 692 |
1796399 | 1796399 | 2021-10-08 | Anderson | Tennessee | 47001 | 12548 | 208 |
1796495 | 1796495 | 2021-10-08 | Anderson | Texas | 48001 | 7884 | 188 |
1791520 | 1791520 | 2021-10-07 | Anderson | Kansas | 20003 | 1077 | 21 |
1791626 | 1791626 | 2021-10-07 | Anderson | Kentucky | 21005 | 3107 | 39 |
1793041 | 1793041 | 2021-10-07 | Anderson | South Carolina | 45007 | 35313 | 685 |
1793150 | 1793150 | 2021-10-07 | Anderson | Tennessee | 47001 | 12483 | 208 |
1793246 | 1793246 | 2021-10-07 | Anderson | Texas | 48001 | 7847 | 185 |
1788271 | 1788271 | 2021-10-06 | Anderson | Kansas | 20003 | 1077 | 21 |
1788377 | 1788377 | 2021-10-06 | Anderson | Kentucky | 21005 | 3088 | 39 |
1789792 | 1789792 | 2021-10-06 | Anderson | South Carolina | 45007 | 35226 | 683 |
1789901 | 1789901 | 2021-10-06 | Anderson | Tennessee | 47001 | 12456 | 207 |
1789997 | 1789997 | 2021-10-06 | Anderson | Texas | 48001 | 7850 | 185 |
1785022 | 1785022 | 2021-10-05 | Anderson | Kansas | 20003 | 1075 | 21 |
1785128 | 1785128 | 2021-10-05 | Anderson | Kentucky | 21005 | 3069 | 39 |
1786544 | 1786544 | 2021-10-05 | Anderson | South Carolina | 45007 | 35168 | 680 |
1786653 | 1786653 | 2021-10-05 | Anderson | Tennessee | 47001 | 12430 | 205 |
1786749 | 1786749 | 2021-10-05 | Anderson | Texas | 48001 | 7846 | 184 |
1781773 | 1781773 | 2021-10-04 | Anderson | Kansas | 20003 | 1075 | 21 |
1781879 | 1781879 | 2021-10-04 | Anderson | Kentucky | 21005 | 3030 | 39 |
1783295 | 1783295 | 2021-10-04 | Anderson | South Carolina | 45007 | 35094 | 678 |
1783404 | 1783404 | 2021-10-04 | Anderson | Tennessee | 47001 | 12411 | 204 |
1783500 | 1783500 | 2021-10-04 | Anderson | Texas | 48001 | 7805 | 181 |
1778523 | 1778523 | 2021-10-03 | Anderson | Kansas | 20003 | 1068 | 21 |
1778629 | 1778629 | 2021-10-03 | Anderson | Kentucky | 21005 | 2978 | 36 |
1780046 | 1780046 | 2021-10-03 | Anderson | South Carolina | 45007 | 34723 | 671 |
1780155 | 1780155 | 2021-10-03 | Anderson | Tennessee | 47001 | 12333 | 199 |
1780251 | 1780251 | 2021-10-03 | Anderson | Texas | 48001 | 7805 | 180 |
1775273 | 1775273 | 2021-10-02 | Anderson | Kansas | 20003 | 1068 | 21 |
1775379 | 1775379 | 2021-10-02 | Anderson | Kentucky | 21005 | 2978 | 36 |
1776796 | 1776796 | 2021-10-02 | Anderson | South Carolina | 45007 | 34723 | 671 |
1776905 | 1776905 | 2021-10-02 | Anderson | Tennessee | 47001 | 12333 | 199 |
1777001 | 1777001 | 2021-10-02 | Anderson | Texas | 48001 | 7805 | 178 |
1772023 | 1772023 | 2021-10-01 | Anderson | Kansas | 20003 | 1068 | 21 |
1772129 | 1772129 | 2021-10-01 | Anderson | Kentucky | 21005 | 2978 | 36 |
1773546 | 1773546 | 2021-10-01 | Anderson | South Carolina | 45007 | 34723 | 671 |
1773655 | 1773655 | 2021-10-01 | Anderson | Tennessee | 47001 | 12333 | 199 |
1773751 | 1773751 | 2021-10-01 | Anderson | Texas | 48001 | 7805 | 178 |
1768774 | 1768774 | 2021-09-30 | Anderson | Kansas | 20003 | 1062 | 21 |
1768880 | 1768880 | 2021-09-30 | Anderson | Kentucky | 21005 | 2943 | 36 |
1770296 | 1770296 | 2021-09-30 | Anderson | South Carolina | 45007 | 34550 | 664 |
1770405 | 1770405 | 2021-09-30 | Anderson | Tennessee | 47001 | 12273 | 199 |
1770501 | 1770501 | 2021-09-30 | Anderson | Texas | 48001 | 7731 | 177 |
1765525 | 1765525 | 2021-09-29 | Anderson | Kansas | 20003 | 1062 | 21 |
1765631 | 1765631 | 2021-09-29 | Anderson | Kentucky | 21005 | 2908 | 36 |
1767047 | 1767047 | 2021-09-29 | Anderson | South Carolina | 45007 | 34429 | 658 |
1767156 | 1767156 | 2021-09-29 | Anderson | Tennessee | 47001 | 12236 | 198 |
1767252 | 1767252 | 2021-09-29 | Anderson | Texas | 48001 | 7729 | 174 |
1762276 | 1762276 | 2021-09-28 | Anderson | Kansas | 20003 | 1051 | 21 |
1762382 | 1762382 | 2021-09-28 | Anderson | Kentucky | 21005 | 2899 | 36 |
1763798 | 1763798 | 2021-09-28 | Anderson | South Carolina | 45007 | 34362 | 648 |
1763907 | 1763907 | 2021-09-28 | Anderson | Tennessee | 47001 | 12190 | 198 |
1764003 | 1764003 | 2021-09-28 | Anderson | Texas | 48001 | 7728 | 171 |
1759028 | 1759028 | 2021-09-27 | Anderson | Kansas | 20003 | 1051 | 21 |
1759134 | 1759134 | 2021-09-27 | Anderson | Kentucky | 21005 | 2853 | 36 |
1760549 | 1760549 | 2021-09-27 | Anderson | South Carolina | 45007 | 34273 | 644 |
1760658 | 1760658 | 2021-09-27 | Anderson | Tennessee | 47001 | 12132 | 197 |
1760754 | 1760754 | 2021-09-27 | Anderson | Texas | 48001 | 7707 | 169 |
1755780 | 1755780 | 2021-09-26 | Anderson | Kansas | 20003 | 1051 | 21 |
1755886 | 1755886 | 2021-09-26 | Anderson | Kentucky | 21005 | 2827 | 35 |
1757301 | 1757301 | 2021-09-26 | Anderson | South Carolina | 45007 | 33812 | 637 |
1757410 | 1757410 | 2021-09-26 | Anderson | Tennessee | 47001 | 12065 | 194 |
1757506 | 1757506 | 2021-09-26 | Anderson | Texas | 48001 | 7707 | 169 |
1752532 | 1752532 | 2021-09-25 | Anderson | Kansas | 20003 | 1051 | 21 |
1752638 | 1752638 | 2021-09-25 | Anderson | Kentucky | 21005 | 2827 | 35 |
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);