ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 42045 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-06 1
- 2020-03-07 1
- 2020-03-08 1
- 2020-03-09 1
- 2020-03-10 1
- 2020-03-11 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- …
state 1
- Pennsylvania · 699 ✖
fips 1
- 42045 · 699 ✖
county 1
- Delaware 699
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176485 | 2176485 | 2022-02-02 | Delaware | Pennsylvania | 42045 | 106549 | 1729 |
2173231 | 2173231 | 2022-02-01 | Delaware | Pennsylvania | 42045 | 106289 | 1723 |
2169979 | 2169979 | 2022-01-31 | Delaware | Pennsylvania | 42045 | 106126 | 1711 |
2166725 | 2166725 | 2022-01-30 | Delaware | Pennsylvania | 42045 | 106039 | 1710 |
2163470 | 2163470 | 2022-01-29 | Delaware | Pennsylvania | 42045 | 105820 | 1710 |
2160215 | 2160215 | 2022-01-28 | Delaware | Pennsylvania | 42045 | 105558 | 1701 |
2156959 | 2156959 | 2022-01-27 | Delaware | Pennsylvania | 42045 | 105135 | 1698 |
2153706 | 2153706 | 2022-01-26 | Delaware | Pennsylvania | 42045 | 104675 | 1689 |
2150454 | 2150454 | 2022-01-25 | Delaware | Pennsylvania | 42045 | 104297 | 1678 |
2147202 | 2147202 | 2022-01-24 | Delaware | Pennsylvania | 42045 | 103940 | 1671 |
2143948 | 2143948 | 2022-01-23 | Delaware | Pennsylvania | 42045 | 103646 | 1668 |
2140693 | 2140693 | 2022-01-22 | Delaware | Pennsylvania | 42045 | 103272 | 1666 |
2137437 | 2137437 | 2022-01-21 | Delaware | Pennsylvania | 42045 | 102747 | 1663 |
2134183 | 2134183 | 2022-01-20 | Delaware | Pennsylvania | 42045 | 102339 | 1649 |
2130931 | 2130931 | 2022-01-19 | Delaware | Pennsylvania | 42045 | 101525 | 1636 |
2127677 | 2127677 | 2022-01-18 | Delaware | Pennsylvania | 42045 | 100923 | 1633 |
2124425 | 2124425 | 2022-01-17 | Delaware | Pennsylvania | 42045 | 100388 | 1631 |
2121173 | 2121173 | 2022-01-16 | Delaware | Pennsylvania | 42045 | 100000 | 1631 |
2117921 | 2117921 | 2022-01-15 | Delaware | Pennsylvania | 42045 | 98803 | 1631 |
2114670 | 2114670 | 2022-01-14 | Delaware | Pennsylvania | 42045 | 97865 | 1621 |
2111418 | 2111418 | 2022-01-13 | Delaware | Pennsylvania | 42045 | 96870 | 1618 |
2108166 | 2108166 | 2022-01-12 | Delaware | Pennsylvania | 42045 | 95870 | 1612 |
2104915 | 2104915 | 2022-01-11 | Delaware | Pennsylvania | 42045 | 94598 | 1608 |
2101664 | 2101664 | 2022-01-10 | Delaware | Pennsylvania | 42045 | 93468 | 1604 |
2098413 | 2098413 | 2022-01-09 | Delaware | Pennsylvania | 42045 | 92202 | 1604 |
2095161 | 2095161 | 2022-01-08 | Delaware | Pennsylvania | 42045 | 90745 | 1604 |
2091909 | 2091909 | 2022-01-07 | Delaware | Pennsylvania | 42045 | 89555 | 1601 |
2088657 | 2088657 | 2022-01-06 | Delaware | Pennsylvania | 42045 | 87730 | 1597 |
2085406 | 2085406 | 2022-01-05 | Delaware | Pennsylvania | 42045 | 86243 | 1594 |
2082154 | 2082154 | 2022-01-04 | Delaware | Pennsylvania | 42045 | 84648 | 1588 |
2078902 | 2078902 | 2022-01-03 | Delaware | Pennsylvania | 42045 | 83381 | 1584 |
2075651 | 2075651 | 2022-01-02 | Delaware | Pennsylvania | 42045 | 82044 | 1582 |
2072400 | 2072400 | 2022-01-01 | Delaware | Pennsylvania | 42045 | 80991 | 1582 |
2069149 | 2069149 | 2021-12-31 | Delaware | Pennsylvania | 42045 | 79520 | 1582 |
2065898 | 2065898 | 2021-12-30 | Delaware | Pennsylvania | 42045 | 77947 | 1582 |
2062648 | 2062648 | 2021-12-29 | Delaware | Pennsylvania | 42045 | 76786 | 1576 |
2059398 | 2059398 | 2021-12-28 | Delaware | Pennsylvania | 42045 | 75511 | 1568 |
2056149 | 2056149 | 2021-12-27 | Delaware | Pennsylvania | 42045 | 74693 | 1563 |
2052900 | 2052900 | 2021-12-26 | Delaware | Pennsylvania | 42045 | 74344 | 1563 |
2049650 | 2049650 | 2021-12-25 | Delaware | Pennsylvania | 42045 | 73722 | 1563 |
2046400 | 2046400 | 2021-12-24 | Delaware | Pennsylvania | 42045 | 73142 | 1563 |
2043150 | 2043150 | 2021-12-23 | Delaware | Pennsylvania | 42045 | 72308 | 1562 |
2039901 | 2039901 | 2021-12-22 | Delaware | Pennsylvania | 42045 | 71845 | 1560 |
2036651 | 2036651 | 2021-12-21 | Delaware | Pennsylvania | 42045 | 71444 | 1560 |
2033401 | 2033401 | 2021-12-20 | Delaware | Pennsylvania | 42045 | 71061 | 1556 |
2030151 | 2030151 | 2021-12-19 | Delaware | Pennsylvania | 42045 | 70858 | 1556 |
2026900 | 2026900 | 2021-12-18 | Delaware | Pennsylvania | 42045 | 70552 | 1555 |
2023649 | 2023649 | 2021-12-17 | Delaware | Pennsylvania | 42045 | 70201 | 1549 |
2020398 | 2020398 | 2021-12-16 | Delaware | Pennsylvania | 42045 | 69868 | 1544 |
2017147 | 2017147 | 2021-12-15 | Delaware | Pennsylvania | 42045 | 69551 | 1543 |
2013897 | 2013897 | 2021-12-14 | Delaware | Pennsylvania | 42045 | 69378 | 1541 |
2010646 | 2010646 | 2021-12-13 | Delaware | Pennsylvania | 42045 | 69145 | 1538 |
2007395 | 2007395 | 2021-12-12 | Delaware | Pennsylvania | 42045 | 68979 | 1538 |
2004144 | 2004144 | 2021-12-11 | Delaware | Pennsylvania | 42045 | 68673 | 1538 |
2000893 | 2000893 | 2021-12-10 | Delaware | Pennsylvania | 42045 | 68413 | 1536 |
1997643 | 1997643 | 2021-12-09 | Delaware | Pennsylvania | 42045 | 68028 | 1536 |
1994392 | 1994392 | 2021-12-08 | Delaware | Pennsylvania | 42045 | 67754 | 1534 |
1991141 | 1991141 | 2021-12-07 | Delaware | Pennsylvania | 42045 | 67576 | 1534 |
1987890 | 1987890 | 2021-12-06 | Delaware | Pennsylvania | 42045 | 67302 | 1533 |
1984640 | 1984640 | 2021-12-05 | Delaware | Pennsylvania | 42045 | 67219 | 1533 |
1981390 | 1981390 | 2021-12-04 | Delaware | Pennsylvania | 42045 | 67112 | 1531 |
1978140 | 1978140 | 2021-12-03 | Delaware | Pennsylvania | 42045 | 66950 | 1530 |
1974890 | 1974890 | 2021-12-02 | Delaware | Pennsylvania | 42045 | 66601 | 1530 |
1971641 | 1971641 | 2021-12-01 | Delaware | Pennsylvania | 42045 | 66368 | 1527 |
1968391 | 1968391 | 2021-11-30 | Delaware | Pennsylvania | 42045 | 66167 | 1527 |
1965140 | 1965140 | 2021-11-29 | Delaware | Pennsylvania | 42045 | 66035 | 1527 |
1961888 | 1961888 | 2021-11-28 | Delaware | Pennsylvania | 42045 | 65944 | 1527 |
1958637 | 1958637 | 2021-11-27 | Delaware | Pennsylvania | 42045 | 65854 | 1527 |
1955386 | 1955386 | 2021-11-26 | Delaware | Pennsylvania | 42045 | 65748 | 1527 |
1952135 | 1952135 | 2021-11-25 | Delaware | Pennsylvania | 42045 | 65592 | 1527 |
1948884 | 1948884 | 2021-11-24 | Delaware | Pennsylvania | 42045 | 65455 | 1525 |
1945633 | 1945633 | 2021-11-23 | Delaware | Pennsylvania | 42045 | 65302 | 1523 |
1942382 | 1942382 | 2021-11-22 | Delaware | Pennsylvania | 42045 | 65145 | 1522 |
1939132 | 1939132 | 2021-11-21 | Delaware | Pennsylvania | 42045 | 65041 | 1522 |
1935882 | 1935882 | 2021-11-20 | Delaware | Pennsylvania | 42045 | 64919 | 1522 |
1932632 | 1932632 | 2021-11-19 | Delaware | Pennsylvania | 42045 | 64791 | 1522 |
1929381 | 1929381 | 2021-11-18 | Delaware | Pennsylvania | 42045 | 64640 | 1520 |
1926131 | 1926131 | 2021-11-17 | Delaware | Pennsylvania | 42045 | 64481 | 1518 |
1922881 | 1922881 | 2021-11-16 | Delaware | Pennsylvania | 42045 | 64385 | 1515 |
1919632 | 1919632 | 2021-11-15 | Delaware | Pennsylvania | 42045 | 64267 | 1515 |
1916382 | 1916382 | 2021-11-14 | Delaware | Pennsylvania | 42045 | 64214 | 1515 |
1913132 | 1913132 | 2021-11-13 | Delaware | Pennsylvania | 42045 | 64082 | 1515 |
1909882 | 1909882 | 2021-11-12 | Delaware | Pennsylvania | 42045 | 63441 | 1515 |
1906633 | 1906633 | 2021-11-11 | Delaware | Pennsylvania | 42045 | 63351 | 1515 |
1903384 | 1903384 | 2021-11-10 | Delaware | Pennsylvania | 42045 | 63226 | 1513 |
1900134 | 1900134 | 2021-11-09 | Delaware | Pennsylvania | 42045 | 63125 | 1511 |
1896884 | 1896884 | 2021-11-08 | Delaware | Pennsylvania | 42045 | 63026 | 1510 |
1893634 | 1893634 | 2021-11-07 | Delaware | Pennsylvania | 42045 | 62967 | 1510 |
1890384 | 1890384 | 2021-11-06 | Delaware | Pennsylvania | 42045 | 62896 | 1510 |
1887134 | 1887134 | 2021-11-05 | Delaware | Pennsylvania | 42045 | 62809 | 1509 |
1883884 | 1883884 | 2021-11-04 | Delaware | Pennsylvania | 42045 | 62715 | 1509 |
1880635 | 1880635 | 2021-11-03 | Delaware | Pennsylvania | 42045 | 62601 | 1507 |
1877386 | 1877386 | 2021-11-02 | Delaware | Pennsylvania | 42045 | 62533 | 1504 |
1874137 | 1874137 | 2021-11-01 | Delaware | Pennsylvania | 42045 | 62391 | 1504 |
1870888 | 1870888 | 2021-10-31 | Delaware | Pennsylvania | 42045 | 62391 | 1504 |
1867639 | 1867639 | 2021-10-30 | Delaware | Pennsylvania | 42045 | 62298 | 1504 |
1864390 | 1864390 | 2021-10-29 | Delaware | Pennsylvania | 42045 | 62205 | 1504 |
1861141 | 1861141 | 2021-10-28 | Delaware | Pennsylvania | 42045 | 62107 | 1501 |
1857892 | 1857892 | 2021-10-27 | Delaware | Pennsylvania | 42045 | 62010 | 1499 |
1854643 | 1854643 | 2021-10-26 | Delaware | Pennsylvania | 42045 | 61932 | 1496 |
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);