ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Montour" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1279853 | 1279853 | 2021-05-02 | Montour | Pennsylvania | 42093 | 1964 | 63 |
1276606 | 1276606 | 2021-05-01 | Montour | Pennsylvania | 42093 | 1963 | 63 |
1273359 | 1273359 | 2021-04-30 | Montour | Pennsylvania | 42093 | 1959 | 63 |
1270112 | 1270112 | 2021-04-29 | Montour | Pennsylvania | 42093 | 1957 | 63 |
1266865 | 1266865 | 2021-04-28 | Montour | Pennsylvania | 42093 | 1950 | 63 |
1263618 | 1263618 | 2021-04-27 | Montour | Pennsylvania | 42093 | 1945 | 63 |
1260371 | 1260371 | 2021-04-26 | Montour | Pennsylvania | 42093 | 1942 | 63 |
1257124 | 1257124 | 2021-04-25 | Montour | Pennsylvania | 42093 | 1941 | 63 |
1253877 | 1253877 | 2021-04-24 | Montour | Pennsylvania | 42093 | 1940 | 63 |
1250630 | 1250630 | 2021-04-23 | Montour | Pennsylvania | 42093 | 1934 | 63 |
1247383 | 1247383 | 2021-04-22 | Montour | Pennsylvania | 42093 | 1923 | 63 |
1244136 | 1244136 | 2021-04-21 | Montour | Pennsylvania | 42093 | 1921 | 62 |
1240889 | 1240889 | 2021-04-20 | Montour | Pennsylvania | 42093 | 1914 | 62 |
1237642 | 1237642 | 2021-04-19 | Montour | Pennsylvania | 42093 | 1911 | 62 |
1234395 | 1234395 | 2021-04-18 | Montour | Pennsylvania | 42093 | 1911 | 62 |
1231147 | 1231147 | 2021-04-17 | Montour | Pennsylvania | 42093 | 1906 | 62 |
1227899 | 1227899 | 2021-04-16 | Montour | Pennsylvania | 42093 | 1904 | 61 |
1224651 | 1224651 | 2021-04-15 | Montour | Pennsylvania | 42093 | 1900 | 61 |
1221404 | 1221404 | 2021-04-14 | Montour | Pennsylvania | 42093 | 1895 | 60 |
1218156 | 1218156 | 2021-04-13 | Montour | Pennsylvania | 42093 | 1889 | 60 |
1214908 | 1214908 | 2021-04-12 | Montour | Pennsylvania | 42093 | 1888 | 60 |
1211661 | 1211661 | 2021-04-11 | Montour | Pennsylvania | 42093 | 1886 | 60 |
1208412 | 1208412 | 2021-04-10 | Montour | Pennsylvania | 42093 | 1883 | 60 |
1205164 | 1205164 | 2021-04-09 | Montour | Pennsylvania | 42093 | 1881 | 60 |
1201916 | 1201916 | 2021-04-08 | Montour | Pennsylvania | 42093 | 1871 | 60 |
1198667 | 1198667 | 2021-04-07 | Montour | Pennsylvania | 42093 | 1868 | 60 |
1195418 | 1195418 | 2021-04-06 | Montour | Pennsylvania | 42093 | 1863 | 60 |
1192170 | 1192170 | 2021-04-05 | Montour | Pennsylvania | 42093 | 1858 | 60 |
1188921 | 1188921 | 2021-04-04 | Montour | Pennsylvania | 42093 | 1854 | 60 |
1185674 | 1185674 | 2021-04-03 | Montour | Pennsylvania | 42093 | 1852 | 60 |
1182427 | 1182427 | 2021-04-02 | Montour | Pennsylvania | 42093 | 1844 | 60 |
1179180 | 1179180 | 2021-04-01 | Montour | Pennsylvania | 42093 | 1840 | 60 |
1175933 | 1175933 | 2021-03-31 | Montour | Pennsylvania | 42093 | 1837 | 60 |
1172686 | 1172686 | 2021-03-30 | Montour | Pennsylvania | 42093 | 1833 | 60 |
1169439 | 1169439 | 2021-03-29 | Montour | Pennsylvania | 42093 | 1828 | 60 |
1166191 | 1166191 | 2021-03-28 | Montour | Pennsylvania | 42093 | 1821 | 60 |
1162943 | 1162943 | 2021-03-27 | Montour | Pennsylvania | 42093 | 1817 | 60 |
1159694 | 1159694 | 2021-03-26 | Montour | Pennsylvania | 42093 | 1812 | 60 |
1156447 | 1156447 | 2021-03-25 | Montour | Pennsylvania | 42093 | 1808 | 60 |
1153200 | 1153200 | 2021-03-24 | Montour | Pennsylvania | 42093 | 1804 | 60 |
1149953 | 1149953 | 2021-03-23 | Montour | Pennsylvania | 42093 | 1802 | 60 |
1146706 | 1146706 | 2021-03-22 | Montour | Pennsylvania | 42093 | 1801 | 60 |
1143459 | 1143459 | 2021-03-21 | Montour | Pennsylvania | 42093 | 1801 | 60 |
1140212 | 1140212 | 2021-03-20 | Montour | Pennsylvania | 42093 | 1801 | 60 |
1136966 | 1136966 | 2021-03-19 | Montour | Pennsylvania | 42093 | 1794 | 60 |
1133720 | 1133720 | 2021-03-18 | Montour | Pennsylvania | 42093 | 1789 | 60 |
1130472 | 1130472 | 2021-03-17 | Montour | Pennsylvania | 42093 | 1781 | 60 |
1127225 | 1127225 | 2021-03-16 | Montour | Pennsylvania | 42093 | 1778 | 60 |
1123979 | 1123979 | 2021-03-15 | Montour | Pennsylvania | 42093 | 1778 | 60 |
1120733 | 1120733 | 2021-03-14 | Montour | Pennsylvania | 42093 | 1773 | 60 |
1117486 | 1117486 | 2021-03-13 | Montour | Pennsylvania | 42093 | 1767 | 60 |
1114239 | 1114239 | 2021-03-12 | Montour | Pennsylvania | 42093 | 1764 | 60 |
1110993 | 1110993 | 2021-03-11 | Montour | Pennsylvania | 42093 | 1761 | 60 |
1107747 | 1107747 | 2021-03-10 | Montour | Pennsylvania | 42093 | 1760 | 60 |
1104501 | 1104501 | 2021-03-09 | Montour | Pennsylvania | 42093 | 1760 | 60 |
1101255 | 1101255 | 2021-03-08 | Montour | Pennsylvania | 42093 | 1779 | 60 |
1098009 | 1098009 | 2021-03-07 | Montour | Pennsylvania | 42093 | 1777 | 60 |
1094761 | 1094761 | 2021-03-06 | Montour | Pennsylvania | 42093 | 1789 | 60 |
1091515 | 1091515 | 2021-03-05 | Montour | Pennsylvania | 42093 | 1790 | 60 |
1088269 | 1088269 | 2021-03-04 | Montour | Pennsylvania | 42093 | 1785 | 60 |
1085024 | 1085024 | 2021-03-03 | Montour | Pennsylvania | 42093 | 1783 | 60 |
1081778 | 1081778 | 2021-03-02 | Montour | Pennsylvania | 42093 | 1782 | 60 |
1078532 | 1078532 | 2021-03-01 | Montour | Pennsylvania | 42093 | 1779 | 60 |
1075287 | 1075287 | 2021-02-28 | Montour | Pennsylvania | 42093 | 1776 | 60 |
1072041 | 1072041 | 2021-02-27 | Montour | Pennsylvania | 42093 | 1767 | 60 |
1068795 | 1068795 | 2021-02-26 | Montour | Pennsylvania | 42093 | 1758 | 60 |
1065550 | 1065550 | 2021-02-25 | Montour | Pennsylvania | 42093 | 1754 | 60 |
1062305 | 1062305 | 2021-02-24 | Montour | Pennsylvania | 42093 | 1756 | 58 |
1059060 | 1059060 | 2021-02-23 | Montour | Pennsylvania | 42093 | 1755 | 58 |
1055814 | 1055814 | 2021-02-22 | Montour | Pennsylvania | 42093 | 1751 | 58 |
1052568 | 1052568 | 2021-02-21 | Montour | Pennsylvania | 42093 | 1752 | 58 |
1049321 | 1049321 | 2021-02-20 | Montour | Pennsylvania | 42093 | 1748 | 58 |
1046074 | 1046074 | 2021-02-19 | Montour | Pennsylvania | 42093 | 1742 | 57 |
1042829 | 1042829 | 2021-02-18 | Montour | Pennsylvania | 42093 | 1735 | 56 |
1039584 | 1039584 | 2021-02-17 | Montour | Pennsylvania | 42093 | 1731 | 56 |
1036339 | 1036339 | 2021-02-16 | Montour | Pennsylvania | 42093 | 1731 | 56 |
1033094 | 1033094 | 2021-02-15 | Montour | Pennsylvania | 42093 | 1725 | 56 |
1029848 | 1029848 | 2021-02-14 | Montour | Pennsylvania | 42093 | 1703 | 56 |
1026601 | 1026601 | 2021-02-13 | Montour | Pennsylvania | 42093 | 1699 | 56 |
1023356 | 1023356 | 2021-02-12 | Montour | Pennsylvania | 42093 | 1698 | 56 |
1020111 | 1020111 | 2021-02-11 | Montour | Pennsylvania | 42093 | 1689 | 55 |
1016866 | 1016866 | 2021-02-10 | Montour | Pennsylvania | 42093 | 1686 | 55 |
1013621 | 1013621 | 2021-02-09 | Montour | Pennsylvania | 42093 | 1683 | 55 |
1010376 | 1010376 | 2021-02-08 | Montour | Pennsylvania | 42093 | 1680 | 55 |
1007130 | 1007130 | 2021-02-07 | Montour | Pennsylvania | 42093 | 1675 | 54 |
1003884 | 1003884 | 2021-02-06 | Montour | Pennsylvania | 42093 | 1667 | 54 |
1000638 | 1000638 | 2021-02-05 | Montour | Pennsylvania | 42093 | 1662 | 53 |
997392 | 997392 | 2021-02-04 | Montour | Pennsylvania | 42093 | 1644 | 53 |
994146 | 994146 | 2021-02-03 | Montour | Pennsylvania | 42093 | 1641 | 52 |
990900 | 990900 | 2021-02-02 | Montour | Pennsylvania | 42093 | 1623 | 52 |
987654 | 987654 | 2021-02-01 | Montour | Pennsylvania | 42093 | 1627 | 52 |
984407 | 984407 | 2021-01-31 | Montour | Pennsylvania | 42093 | 1649 | 51 |
981160 | 981160 | 2021-01-30 | Montour | Pennsylvania | 42093 | 1593 | 50 |
977914 | 977914 | 2021-01-29 | Montour | Pennsylvania | 42093 | 1568 | 50 |
974669 | 974669 | 2021-01-28 | Montour | Pennsylvania | 42093 | 1567 | 48 |
971424 | 971424 | 2021-01-27 | Montour | Pennsylvania | 42093 | 1556 | 48 |
968179 | 968179 | 2021-01-26 | Montour | Pennsylvania | 42093 | 1524 | 45 |
964935 | 964935 | 2021-01-25 | Montour | Pennsylvania | 42093 | 1545 | 45 |
961690 | 961690 | 2021-01-24 | Montour | Pennsylvania | 42093 | 1527 | 45 |
958445 | 958445 | 2021-01-23 | Montour | Pennsylvania | 42093 | 1511 | 45 |
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);