ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
6,253 rows where county = "Harrison" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 8
- Kentucky 593
- Iowa 588
- Mississippi 584
- Indiana 580
- West Virginia 577
- Texas 574
- Missouri 570
- Ohio 555
county 1
- Harrison · 4,621 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1836843 | 1836843 | 2021-10-21 | Harrison | Indiana | 18061 | 6480 | 94 |
1836947 | 1836947 | 2021-10-21 | Harrison | Iowa | 19085 | 2179 | 77 |
1837158 | 1837158 | 2021-10-21 | Harrison | Kentucky | 21097 | 3272 | 36 |
1837547 | 1837547 | 2021-10-21 | Harrison | Mississippi | 28047 | 34312 | 538 |
1837646 | 1837646 | 2021-10-21 | Harrison | Missouri | 29081 | 1106 | 17 |
1838203 | 1838203 | 2021-10-21 | Harrison | Ohio | 39067 | 1801 | 43 |
1838834 | 1838834 | 2021-10-21 | Harrison | Texas | 48203 | 9103 | 175 |
1839223 | 1839223 | 2021-10-21 | Harrison | West Virginia | 54033 | 10895 | 138 |
1833594 | 1833594 | 2021-10-20 | Harrison | Indiana | 18061 | 6471 | 94 |
1833698 | 1833698 | 2021-10-20 | Harrison | Iowa | 19085 | 2179 | 77 |
1833909 | 1833909 | 2021-10-20 | Harrison | Kentucky | 21097 | 3264 | 36 |
1834298 | 1834298 | 2021-10-20 | Harrison | Mississippi | 28047 | 34281 | 537 |
1834397 | 1834397 | 2021-10-20 | Harrison | Missouri | 29081 | 1104 | 17 |
1834954 | 1834954 | 2021-10-20 | Harrison | Ohio | 39067 | 1794 | 43 |
1835585 | 1835585 | 2021-10-20 | Harrison | Texas | 48203 | 9097 | 174 |
1835974 | 1835974 | 2021-10-20 | Harrison | West Virginia | 54033 | 10841 | 138 |
1830345 | 1830345 | 2021-10-19 | Harrison | Indiana | 18061 | 6463 | 94 |
1830449 | 1830449 | 2021-10-19 | Harrison | Iowa | 19085 | 2153 | 77 |
1830660 | 1830660 | 2021-10-19 | Harrison | Kentucky | 21097 | 3241 | 36 |
1831049 | 1831049 | 2021-10-19 | Harrison | Mississippi | 28047 | 34258 | 537 |
1831148 | 1831148 | 2021-10-19 | Harrison | Missouri | 29081 | 1104 | 17 |
1831705 | 1831705 | 2021-10-19 | Harrison | Ohio | 39067 | 1787 | 43 |
1832336 | 1832336 | 2021-10-19 | Harrison | Texas | 48203 | 9091 | 173 |
1832725 | 1832725 | 2021-10-19 | Harrison | West Virginia | 54033 | 10787 | 137 |
1827096 | 1827096 | 2021-10-18 | Harrison | Indiana | 18061 | 6449 | 94 |
1827200 | 1827200 | 2021-10-18 | Harrison | Iowa | 19085 | 2153 | 77 |
1827411 | 1827411 | 2021-10-18 | Harrison | Kentucky | 21097 | 3220 | 36 |
1827800 | 1827800 | 2021-10-18 | Harrison | Mississippi | 28047 | 34150 | 535 |
1827899 | 1827899 | 2021-10-18 | Harrison | Missouri | 29081 | 1102 | 17 |
1828456 | 1828456 | 2021-10-18 | Harrison | Ohio | 39067 | 1782 | 42 |
1829087 | 1829087 | 2021-10-18 | Harrison | Texas | 48203 | 9073 | 173 |
1829476 | 1829476 | 2021-10-18 | Harrison | West Virginia | 54033 | 10765 | 137 |
1823847 | 1823847 | 2021-10-17 | Harrison | Indiana | 18061 | 6420 | 94 |
1823951 | 1823951 | 2021-10-17 | Harrison | Iowa | 19085 | 2153 | 77 |
1824162 | 1824162 | 2021-10-17 | Harrison | Kentucky | 21097 | 3206 | 35 |
1824551 | 1824551 | 2021-10-17 | Harrison | Mississippi | 28047 | 34102 | 530 |
1824650 | 1824650 | 2021-10-17 | Harrison | Missouri | 29081 | 1102 | 17 |
1825207 | 1825207 | 2021-10-17 | Harrison | Ohio | 39067 | 1782 | 42 |
1825838 | 1825838 | 2021-10-17 | Harrison | Texas | 48203 | 9073 | 173 |
1826227 | 1826227 | 2021-10-17 | Harrison | West Virginia | 54033 | 10728 | 136 |
1820598 | 1820598 | 2021-10-16 | Harrison | Indiana | 18061 | 6420 | 94 |
1820702 | 1820702 | 2021-10-16 | Harrison | Iowa | 19085 | 2153 | 77 |
1820913 | 1820913 | 2021-10-16 | Harrison | Kentucky | 21097 | 3206 | 35 |
1821302 | 1821302 | 2021-10-16 | Harrison | Mississippi | 28047 | 34102 | 530 |
1821401 | 1821401 | 2021-10-16 | Harrison | Missouri | 29081 | 1102 | 17 |
1821958 | 1821958 | 2021-10-16 | Harrison | Ohio | 39067 | 1778 | 42 |
1822589 | 1822589 | 2021-10-16 | Harrison | Texas | 48203 | 9073 | 173 |
1822978 | 1822978 | 2021-10-16 | Harrison | West Virginia | 54033 | 10668 | 136 |
1817349 | 1817349 | 2021-10-15 | Harrison | Indiana | 18061 | 6420 | 94 |
1817453 | 1817453 | 2021-10-15 | Harrison | Iowa | 19085 | 2153 | 77 |
1817664 | 1817664 | 2021-10-15 | Harrison | Kentucky | 21097 | 3206 | 35 |
1818053 | 1818053 | 2021-10-15 | Harrison | Mississippi | 28047 | 34102 | 530 |
1818152 | 1818152 | 2021-10-15 | Harrison | Missouri | 29081 | 1100 | 17 |
1818709 | 1818709 | 2021-10-15 | Harrison | Ohio | 39067 | 1770 | 42 |
1819340 | 1819340 | 2021-10-15 | Harrison | Texas | 48203 | 9064 | 171 |
1819729 | 1819729 | 2021-10-15 | Harrison | West Virginia | 54033 | 10612 | 136 |
1814101 | 1814101 | 2021-10-14 | Harrison | Indiana | 18061 | 6401 | 94 |
1814205 | 1814205 | 2021-10-14 | Harrison | Iowa | 19085 | 2153 | 77 |
1814416 | 1814416 | 2021-10-14 | Harrison | Kentucky | 21097 | 3192 | 33 |
1814804 | 1814804 | 2021-10-14 | Harrison | Mississippi | 28047 | 34085 | 530 |
1814903 | 1814903 | 2021-10-14 | Harrison | Missouri | 29081 | 1100 | 17 |
1815460 | 1815460 | 2021-10-14 | Harrison | Ohio | 39067 | 1759 | 42 |
1816091 | 1816091 | 2021-10-14 | Harrison | Texas | 48203 | 9054 | 170 |
1816480 | 1816480 | 2021-10-14 | Harrison | West Virginia | 54033 | 10528 | 135 |
1810852 | 1810852 | 2021-10-13 | Harrison | Indiana | 18061 | 6389 | 94 |
1810956 | 1810956 | 2021-10-13 | Harrison | Iowa | 19085 | 2153 | 77 |
1811167 | 1811167 | 2021-10-13 | Harrison | Kentucky | 21097 | 3165 | 33 |
1811556 | 1811556 | 2021-10-13 | Harrison | Mississippi | 28047 | 34022 | 530 |
1811655 | 1811655 | 2021-10-13 | Harrison | Missouri | 29081 | 1100 | 17 |
1812212 | 1812212 | 2021-10-13 | Harrison | Ohio | 39067 | 1751 | 42 |
1812843 | 1812843 | 2021-10-13 | Harrison | Texas | 48203 | 9043 | 168 |
1813232 | 1813232 | 2021-10-13 | Harrison | West Virginia | 54033 | 10438 | 130 |
1807603 | 1807603 | 2021-10-12 | Harrison | Indiana | 18061 | 6375 | 94 |
1807707 | 1807707 | 2021-10-12 | Harrison | Iowa | 19085 | 2131 | 77 |
1807918 | 1807918 | 2021-10-12 | Harrison | Kentucky | 21097 | 3133 | 33 |
1808307 | 1808307 | 2021-10-12 | Harrison | Mississippi | 28047 | 33979 | 529 |
1808406 | 1808406 | 2021-10-12 | Harrison | Missouri | 29081 | 1100 | 17 |
1808963 | 1808963 | 2021-10-12 | Harrison | Ohio | 39067 | 1746 | 42 |
1809594 | 1809594 | 2021-10-12 | Harrison | Texas | 48203 | 9028 | 167 |
1809983 | 1809983 | 2021-10-12 | Harrison | West Virginia | 54033 | 10348 | 130 |
1804352 | 1804352 | 2021-10-11 | Harrison | Indiana | 18061 | 6366 | 94 |
1804456 | 1804456 | 2021-10-11 | Harrison | Iowa | 19085 | 2131 | 77 |
1804667 | 1804667 | 2021-10-11 | Harrison | Kentucky | 21097 | 3117 | 30 |
1805056 | 1805056 | 2021-10-11 | Harrison | Mississippi | 28047 | 33919 | 525 |
1805155 | 1805155 | 2021-10-11 | Harrison | Missouri | 29081 | 1100 | 17 |
1805713 | 1805713 | 2021-10-11 | Harrison | Ohio | 39067 | 1739 | 41 |
1806344 | 1806344 | 2021-10-11 | Harrison | Texas | 48203 | 9003 | 167 |
1806734 | 1806734 | 2021-10-11 | Harrison | West Virginia | 54033 | 10307 | 130 |
1801103 | 1801103 | 2021-10-10 | Harrison | Indiana | 18061 | 6317 | 93 |
1801207 | 1801207 | 2021-10-10 | Harrison | Iowa | 19085 | 2131 | 77 |
1801418 | 1801418 | 2021-10-10 | Harrison | Kentucky | 21097 | 3097 | 30 |
1801807 | 1801807 | 2021-10-10 | Harrison | Mississippi | 28047 | 33835 | 522 |
1801906 | 1801906 | 2021-10-10 | Harrison | Missouri | 29081 | 1100 | 17 |
1802463 | 1802463 | 2021-10-10 | Harrison | Ohio | 39067 | 1733 | 41 |
1803094 | 1803094 | 2021-10-10 | Harrison | Texas | 48203 | 9003 | 167 |
1803483 | 1803483 | 2021-10-10 | Harrison | West Virginia | 54033 | 10266 | 127 |
1797854 | 1797854 | 2021-10-09 | Harrison | Indiana | 18061 | 6317 | 93 |
1797958 | 1797958 | 2021-10-09 | Harrison | Iowa | 19085 | 2131 | 77 |
1798169 | 1798169 | 2021-10-09 | Harrison | Kentucky | 21097 | 3097 | 30 |
1798558 | 1798558 | 2021-10-09 | Harrison | Mississippi | 28047 | 33835 | 522 |
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);