ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
7,741 rows where county = "Perry" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 10
- Mississippi 584
- Tennessee 581
- Missouri 579
- Pennsylvania 575
- Arkansas 573
- Ohio 572
- Kentucky 567
- Alabama 562
- Indiana 561
- Illinois 560
fips 10
county 1
- Perry · 5,714 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1844732 | 1844732 | 2021-10-23 | Perry | Ohio | 39127 | 5183 | 63 |
1844921 | 1844921 | 2021-10-23 | Perry | Pennsylvania | 42099 | 5219 | 119 |
1845203 | 1845203 | 2021-10-23 | Perry | Tennessee | 47135 | 1602 | 34 |
1839409 | 1839409 | 2021-10-22 | Perry | Alabama | 1105 | 1383 | 40 |
1839520 | 1839520 | 2021-10-22 | Perry | Arkansas | 5105 | 1510 | 21 |
1840031 | 1840031 | 2021-10-22 | Perry | Illinois | 17145 | 4339 | 84 |
1840123 | 1840123 | 2021-10-22 | Perry | Indiana | 18123 | 2666 | 55 |
1840455 | 1840455 | 2021-10-22 | Perry | Kentucky | 21193 | 6076 | 87 |
1840828 | 1840828 | 2021-10-22 | Perry | Mississippi | 28111 | 2055 | 56 |
1840935 | 1840935 | 2021-10-22 | Perry | Missouri | 29157 | 3099 | 33 |
1841482 | 1841482 | 2021-10-22 | Perry | Ohio | 39127 | 5173 | 63 |
1841671 | 1841671 | 2021-10-22 | Perry | Pennsylvania | 42099 | 5206 | 119 |
1841953 | 1841953 | 2021-10-22 | Perry | Tennessee | 47135 | 1602 | 34 |
1836160 | 1836160 | 2021-10-21 | Perry | Alabama | 1105 | 1383 | 40 |
1836271 | 1836271 | 2021-10-21 | Perry | Arkansas | 5105 | 1510 | 21 |
1836782 | 1836782 | 2021-10-21 | Perry | Illinois | 17145 | 4337 | 84 |
1836874 | 1836874 | 2021-10-21 | Perry | Indiana | 18123 | 2665 | 55 |
1837206 | 1837206 | 2021-10-21 | Perry | Kentucky | 21193 | 6041 | 87 |
1837579 | 1837579 | 2021-10-21 | Perry | Mississippi | 28111 | 2053 | 56 |
1837686 | 1837686 | 2021-10-21 | Perry | Missouri | 29157 | 3092 | 33 |
1838233 | 1838233 | 2021-10-21 | Perry | Ohio | 39127 | 5165 | 63 |
1838422 | 1838422 | 2021-10-21 | Perry | Pennsylvania | 42099 | 5190 | 119 |
1838704 | 1838704 | 2021-10-21 | Perry | Tennessee | 47135 | 1600 | 34 |
1832911 | 1832911 | 2021-10-20 | Perry | Alabama | 1105 | 1384 | 40 |
1833022 | 1833022 | 2021-10-20 | Perry | Arkansas | 5105 | 1508 | 21 |
1833533 | 1833533 | 2021-10-20 | Perry | Illinois | 17145 | 4332 | 84 |
1833625 | 1833625 | 2021-10-20 | Perry | Indiana | 18123 | 2660 | 55 |
1833957 | 1833957 | 2021-10-20 | Perry | Kentucky | 21193 | 6020 | 87 |
1834330 | 1834330 | 2021-10-20 | Perry | Mississippi | 28111 | 2052 | 56 |
1834437 | 1834437 | 2021-10-20 | Perry | Missouri | 29157 | 3082 | 33 |
1834984 | 1834984 | 2021-10-20 | Perry | Ohio | 39127 | 5155 | 63 |
1835173 | 1835173 | 2021-10-20 | Perry | Pennsylvania | 42099 | 5167 | 117 |
1835455 | 1835455 | 2021-10-20 | Perry | Tennessee | 47135 | 1599 | 34 |
1829662 | 1829662 | 2021-10-19 | Perry | Alabama | 1105 | 1382 | 40 |
1829773 | 1829773 | 2021-10-19 | Perry | Arkansas | 5105 | 1504 | 21 |
1830284 | 1830284 | 2021-10-19 | Perry | Illinois | 17145 | 4329 | 84 |
1830376 | 1830376 | 2021-10-19 | Perry | Indiana | 18123 | 2659 | 55 |
1830708 | 1830708 | 2021-10-19 | Perry | Kentucky | 21193 | 6009 | 87 |
1831081 | 1831081 | 2021-10-19 | Perry | Mississippi | 28111 | 2052 | 55 |
1831188 | 1831188 | 2021-10-19 | Perry | Missouri | 29157 | 3071 | 33 |
1831735 | 1831735 | 2021-10-19 | Perry | Ohio | 39127 | 5135 | 63 |
1831924 | 1831924 | 2021-10-19 | Perry | Pennsylvania | 42099 | 5156 | 116 |
1832206 | 1832206 | 2021-10-19 | Perry | Tennessee | 47135 | 1595 | 34 |
1826413 | 1826413 | 2021-10-18 | Perry | Alabama | 1105 | 1380 | 40 |
1826524 | 1826524 | 2021-10-18 | Perry | Arkansas | 5105 | 1502 | 21 |
1827035 | 1827035 | 2021-10-18 | Perry | Illinois | 17145 | 4323 | 84 |
1827127 | 1827127 | 2021-10-18 | Perry | Indiana | 18123 | 2659 | 55 |
1827459 | 1827459 | 2021-10-18 | Perry | Kentucky | 21193 | 5993 | 87 |
1827832 | 1827832 | 2021-10-18 | Perry | Mississippi | 28111 | 2048 | 55 |
1827939 | 1827939 | 2021-10-18 | Perry | Missouri | 29157 | 3063 | 33 |
1828486 | 1828486 | 2021-10-18 | Perry | Ohio | 39127 | 5125 | 61 |
1828675 | 1828675 | 2021-10-18 | Perry | Pennsylvania | 42099 | 5130 | 116 |
1828957 | 1828957 | 2021-10-18 | Perry | Tennessee | 47135 | 1594 | 34 |
1823164 | 1823164 | 2021-10-17 | Perry | Alabama | 1105 | 1380 | 40 |
1823275 | 1823275 | 2021-10-17 | Perry | Arkansas | 5105 | 1501 | 21 |
1823786 | 1823786 | 2021-10-17 | Perry | Illinois | 17145 | 4303 | 84 |
1823878 | 1823878 | 2021-10-17 | Perry | Indiana | 18123 | 2656 | 55 |
1824210 | 1824210 | 2021-10-17 | Perry | Kentucky | 21193 | 5962 | 87 |
1824583 | 1824583 | 2021-10-17 | Perry | Mississippi | 28111 | 2047 | 55 |
1824690 | 1824690 | 2021-10-17 | Perry | Missouri | 29157 | 3062 | 33 |
1825237 | 1825237 | 2021-10-17 | Perry | Ohio | 39127 | 5121 | 61 |
1825426 | 1825426 | 2021-10-17 | Perry | Pennsylvania | 42099 | 5118 | 116 |
1825708 | 1825708 | 2021-10-17 | Perry | Tennessee | 47135 | 1585 | 34 |
1819915 | 1819915 | 2021-10-16 | Perry | Alabama | 1105 | 1380 | 40 |
1820026 | 1820026 | 2021-10-16 | Perry | Arkansas | 5105 | 1501 | 21 |
1820537 | 1820537 | 2021-10-16 | Perry | Illinois | 17145 | 4303 | 84 |
1820629 | 1820629 | 2021-10-16 | Perry | Indiana | 18123 | 2656 | 55 |
1820961 | 1820961 | 2021-10-16 | Perry | Kentucky | 21193 | 5962 | 87 |
1821334 | 1821334 | 2021-10-16 | Perry | Mississippi | 28111 | 2047 | 55 |
1821441 | 1821441 | 2021-10-16 | Perry | Missouri | 29157 | 3059 | 33 |
1821988 | 1821988 | 2021-10-16 | Perry | Ohio | 39127 | 5117 | 61 |
1822177 | 1822177 | 2021-10-16 | Perry | Pennsylvania | 42099 | 5109 | 116 |
1822459 | 1822459 | 2021-10-16 | Perry | Tennessee | 47135 | 1585 | 34 |
1816666 | 1816666 | 2021-10-15 | Perry | Alabama | 1105 | 1380 | 40 |
1816777 | 1816777 | 2021-10-15 | Perry | Arkansas | 5105 | 1501 | 21 |
1817288 | 1817288 | 2021-10-15 | Perry | Illinois | 17145 | 4303 | 84 |
1817380 | 1817380 | 2021-10-15 | Perry | Indiana | 18123 | 2656 | 55 |
1817712 | 1817712 | 2021-10-15 | Perry | Kentucky | 21193 | 5962 | 87 |
1818085 | 1818085 | 2021-10-15 | Perry | Mississippi | 28111 | 2047 | 55 |
1818192 | 1818192 | 2021-10-15 | Perry | Missouri | 29157 | 3052 | 33 |
1818739 | 1818739 | 2021-10-15 | Perry | Ohio | 39127 | 5106 | 61 |
1818928 | 1818928 | 2021-10-15 | Perry | Pennsylvania | 42099 | 5096 | 116 |
1819210 | 1819210 | 2021-10-15 | Perry | Tennessee | 47135 | 1585 | 34 |
1813418 | 1813418 | 2021-10-14 | Perry | Alabama | 1105 | 1379 | 40 |
1813529 | 1813529 | 2021-10-14 | Perry | Arkansas | 5105 | 1499 | 21 |
1814040 | 1814040 | 2021-10-14 | Perry | Illinois | 17145 | 4302 | 83 |
1814132 | 1814132 | 2021-10-14 | Perry | Indiana | 18123 | 2647 | 55 |
1814464 | 1814464 | 2021-10-14 | Perry | Kentucky | 21193 | 5943 | 87 |
1814836 | 1814836 | 2021-10-14 | Perry | Mississippi | 28111 | 2045 | 55 |
1814943 | 1814943 | 2021-10-14 | Perry | Missouri | 29157 | 3044 | 33 |
1815490 | 1815490 | 2021-10-14 | Perry | Ohio | 39127 | 5097 | 59 |
1815679 | 1815679 | 2021-10-14 | Perry | Pennsylvania | 42099 | 5068 | 115 |
1815961 | 1815961 | 2021-10-14 | Perry | Tennessee | 47135 | 1585 | 34 |
1810169 | 1810169 | 2021-10-13 | Perry | Alabama | 1105 | 1380 | 39 |
1810280 | 1810280 | 2021-10-13 | Perry | Arkansas | 5105 | 1495 | 21 |
1810791 | 1810791 | 2021-10-13 | Perry | Illinois | 17145 | 4286 | 83 |
1810883 | 1810883 | 2021-10-13 | Perry | Indiana | 18123 | 2641 | 55 |
1811215 | 1811215 | 2021-10-13 | Perry | Kentucky | 21193 | 5932 | 87 |
1811588 | 1811588 | 2021-10-13 | Perry | Mississippi | 28111 | 2043 | 54 |
1811695 | 1811695 | 2021-10-13 | Perry | Missouri | 29157 | 3036 | 33 |
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);