ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,612 rows where county = "Fayette" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1813812 | 1813812 | 2021-10-14 | Fayette | Georgia | 13113 | 12980 | 220 |
1813993 | 1813993 | 2021-10-14 | Fayette | Illinois | 17051 | 4281 | 66 |
1814091 | 1814091 | 2021-10-14 | Fayette | Indiana | 18041 | 4151 | 89 |
1814195 | 1814195 | 2021-10-14 | Fayette | Iowa | 19065 | 2540 | 48 |
1814401 | 1814401 | 2021-10-14 | Fayette | Kentucky | 21067 | 50776 | 381 |
1815450 | 1815450 | 2021-10-14 | Fayette | Ohio | 39047 | 4182 | 60 |
1815655 | 1815655 | 2021-10-14 | Fayette | Pennsylvania | 42051 | 16818 | 377 |
1815917 | 1815917 | 2021-10-14 | Fayette | Tennessee | 47047 | 7215 | 100 |
1816064 | 1816064 | 2021-10-14 | Fayette | Texas | 48149 | 3575 | 89 |
1816473 | 1816473 | 2021-10-14 | Fayette | West Virginia | 54019 | 5869 | 113 |
1810145 | 1810145 | 2021-10-13 | Fayette | Alabama | 1057 | 2881 | 79 |
1810563 | 1810563 | 2021-10-13 | Fayette | Georgia | 13113 | 12965 | 219 |
1810744 | 1810744 | 2021-10-13 | Fayette | Illinois | 17051 | 4270 | 64 |
1810842 | 1810842 | 2021-10-13 | Fayette | Indiana | 18041 | 4144 | 89 |
1810946 | 1810946 | 2021-10-13 | Fayette | Iowa | 19065 | 2540 | 48 |
1811152 | 1811152 | 2021-10-13 | Fayette | Kentucky | 21067 | 50674 | 380 |
1812202 | 1812202 | 2021-10-13 | Fayette | Ohio | 39047 | 4168 | 60 |
1812407 | 1812407 | 2021-10-13 | Fayette | Pennsylvania | 42051 | 16744 | 371 |
1812669 | 1812669 | 2021-10-13 | Fayette | Tennessee | 47047 | 7208 | 100 |
1812816 | 1812816 | 2021-10-13 | Fayette | Texas | 48149 | 3574 | 89 |
1813225 | 1813225 | 2021-10-13 | Fayette | West Virginia | 54019 | 5834 | 112 |
1806896 | 1806896 | 2021-10-12 | Fayette | Alabama | 1057 | 2877 | 78 |
1807314 | 1807314 | 2021-10-12 | Fayette | Georgia | 13113 | 12952 | 218 |
1807495 | 1807495 | 2021-10-12 | Fayette | Illinois | 17051 | 4261 | 64 |
1807593 | 1807593 | 2021-10-12 | Fayette | Indiana | 18041 | 4135 | 89 |
1807697 | 1807697 | 2021-10-12 | Fayette | Iowa | 19065 | 2471 | 47 |
1807903 | 1807903 | 2021-10-12 | Fayette | Kentucky | 21067 | 50576 | 380 |
1808953 | 1808953 | 2021-10-12 | Fayette | Ohio | 39047 | 4145 | 60 |
1809158 | 1809158 | 2021-10-12 | Fayette | Pennsylvania | 42051 | 16612 | 368 |
1809420 | 1809420 | 2021-10-12 | Fayette | Tennessee | 47047 | 7196 | 100 |
1809567 | 1809567 | 2021-10-12 | Fayette | Texas | 48149 | 3574 | 89 |
1809976 | 1809976 | 2021-10-12 | Fayette | West Virginia | 54019 | 5802 | 112 |
1803645 | 1803645 | 2021-10-11 | Fayette | Alabama | 1057 | 2877 | 78 |
1804063 | 1804063 | 2021-10-11 | Fayette | Georgia | 13113 | 12901 | 217 |
1804244 | 1804244 | 2021-10-11 | Fayette | Illinois | 17051 | 4237 | 64 |
1804342 | 1804342 | 2021-10-11 | Fayette | Indiana | 18041 | 4132 | 89 |
1804446 | 1804446 | 2021-10-11 | Fayette | Iowa | 19065 | 2471 | 47 |
1804652 | 1804652 | 2021-10-11 | Fayette | Kentucky | 21067 | 50443 | 380 |
1805703 | 1805703 | 2021-10-11 | Fayette | Ohio | 39047 | 4135 | 58 |
1805908 | 1805908 | 2021-10-11 | Fayette | Pennsylvania | 42051 | 16569 | 365 |
1806170 | 1806170 | 2021-10-11 | Fayette | Tennessee | 47047 | 7182 | 100 |
1806317 | 1806317 | 2021-10-11 | Fayette | Texas | 48149 | 3570 | 89 |
1806727 | 1806727 | 2021-10-11 | Fayette | West Virginia | 54019 | 5779 | 111 |
1800396 | 1800396 | 2021-10-10 | Fayette | Alabama | 1057 | 2873 | 78 |
1800814 | 1800814 | 2021-10-10 | Fayette | Georgia | 13113 | 12901 | 217 |
1800995 | 1800995 | 2021-10-10 | Fayette | Illinois | 17051 | 4237 | 64 |
1801093 | 1801093 | 2021-10-10 | Fayette | Indiana | 18041 | 4111 | 89 |
1801197 | 1801197 | 2021-10-10 | Fayette | Iowa | 19065 | 2471 | 47 |
1801403 | 1801403 | 2021-10-10 | Fayette | Kentucky | 21067 | 50209 | 375 |
1802453 | 1802453 | 2021-10-10 | Fayette | Ohio | 39047 | 4121 | 58 |
1802658 | 1802658 | 2021-10-10 | Fayette | Pennsylvania | 42051 | 16534 | 365 |
1802920 | 1802920 | 2021-10-10 | Fayette | Tennessee | 47047 | 7157 | 100 |
1803067 | 1803067 | 2021-10-10 | Fayette | Texas | 48149 | 3570 | 89 |
1803476 | 1803476 | 2021-10-10 | Fayette | West Virginia | 54019 | 5764 | 110 |
1797147 | 1797147 | 2021-10-09 | Fayette | Alabama | 1057 | 2862 | 78 |
1797565 | 1797565 | 2021-10-09 | Fayette | Georgia | 13113 | 12901 | 217 |
1797746 | 1797746 | 2021-10-09 | Fayette | Illinois | 17051 | 4237 | 64 |
1797844 | 1797844 | 2021-10-09 | Fayette | Indiana | 18041 | 4111 | 89 |
1797948 | 1797948 | 2021-10-09 | Fayette | Iowa | 19065 | 2471 | 47 |
1798154 | 1798154 | 2021-10-09 | Fayette | Kentucky | 21067 | 50209 | 375 |
1799204 | 1799204 | 2021-10-09 | Fayette | Ohio | 39047 | 4098 | 58 |
1799409 | 1799409 | 2021-10-09 | Fayette | Pennsylvania | 42051 | 16481 | 365 |
1799671 | 1799671 | 2021-10-09 | Fayette | Tennessee | 47047 | 7157 | 100 |
1799818 | 1799818 | 2021-10-09 | Fayette | Texas | 48149 | 3570 | 89 |
1800227 | 1800227 | 2021-10-09 | Fayette | West Virginia | 54019 | 5741 | 110 |
1793898 | 1793898 | 2021-10-08 | Fayette | Alabama | 1057 | 2853 | 76 |
1794316 | 1794316 | 2021-10-08 | Fayette | Georgia | 13113 | 12901 | 217 |
1794497 | 1794497 | 2021-10-08 | Fayette | Illinois | 17051 | 4237 | 64 |
1794595 | 1794595 | 2021-10-08 | Fayette | Indiana | 18041 | 4111 | 89 |
1794699 | 1794699 | 2021-10-08 | Fayette | Iowa | 19065 | 2471 | 47 |
1794905 | 1794905 | 2021-10-08 | Fayette | Kentucky | 21067 | 50209 | 375 |
1795955 | 1795955 | 2021-10-08 | Fayette | Ohio | 39047 | 4089 | 58 |
1796160 | 1796160 | 2021-10-08 | Fayette | Pennsylvania | 42051 | 16384 | 365 |
1796422 | 1796422 | 2021-10-08 | Fayette | Tennessee | 47047 | 7157 | 100 |
1796569 | 1796569 | 2021-10-08 | Fayette | Texas | 48149 | 3568 | 89 |
1796978 | 1796978 | 2021-10-08 | Fayette | West Virginia | 54019 | 5709 | 110 |
1790649 | 1790649 | 2021-10-07 | Fayette | Alabama | 1057 | 2851 | 75 |
1791068 | 1791068 | 2021-10-07 | Fayette | Georgia | 13113 | 12871 | 217 |
1791249 | 1791249 | 2021-10-07 | Fayette | Illinois | 17051 | 4231 | 62 |
1791347 | 1791347 | 2021-10-07 | Fayette | Indiana | 18041 | 4093 | 89 |
1791451 | 1791451 | 2021-10-07 | Fayette | Iowa | 19065 | 2471 | 47 |
1791657 | 1791657 | 2021-10-07 | Fayette | Kentucky | 21067 | 50130 | 368 |
1792706 | 1792706 | 2021-10-07 | Fayette | Ohio | 39047 | 4069 | 56 |
1792911 | 1792911 | 2021-10-07 | Fayette | Pennsylvania | 42051 | 16253 | 365 |
1793173 | 1793173 | 2021-10-07 | Fayette | Tennessee | 47047 | 7141 | 99 |
1793320 | 1793320 | 2021-10-07 | Fayette | Texas | 48149 | 3568 | 89 |
1793729 | 1793729 | 2021-10-07 | Fayette | West Virginia | 54019 | 5672 | 109 |
1787401 | 1787401 | 2021-10-06 | Fayette | Alabama | 1057 | 2845 | 74 |
1787819 | 1787819 | 2021-10-06 | Fayette | Georgia | 13113 | 12833 | 214 |
1788000 | 1788000 | 2021-10-06 | Fayette | Illinois | 17051 | 4207 | 62 |
1788098 | 1788098 | 2021-10-06 | Fayette | Indiana | 18041 | 4084 | 89 |
1788202 | 1788202 | 2021-10-06 | Fayette | Iowa | 19065 | 2471 | 47 |
1788408 | 1788408 | 2021-10-06 | Fayette | Kentucky | 21067 | 50018 | 368 |
1789457 | 1789457 | 2021-10-06 | Fayette | Ohio | 39047 | 4041 | 56 |
1789662 | 1789662 | 2021-10-06 | Fayette | Pennsylvania | 42051 | 16140 | 364 |
1789924 | 1789924 | 2021-10-06 | Fayette | Tennessee | 47047 | 7128 | 97 |
1790071 | 1790071 | 2021-10-06 | Fayette | Texas | 48149 | 3568 | 88 |
1790480 | 1790480 | 2021-10-06 | Fayette | West Virginia | 54019 | 5633 | 109 |
1784152 | 1784152 | 2021-10-05 | Fayette | Alabama | 1057 | 2842 | 74 |
1784570 | 1784570 | 2021-10-05 | Fayette | Georgia | 13113 | 12828 | 213 |
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);