ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Allegheny" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176464 | 2176464 | 2022-02-02 | Allegheny | Pennsylvania | 42003 | 252496 | 3019 |
2173210 | 2173210 | 2022-02-01 | Allegheny | Pennsylvania | 42003 | 251815 | 3004 |
2169958 | 2169958 | 2022-01-31 | Allegheny | Pennsylvania | 42003 | 251318 | 2979 |
2166704 | 2166704 | 2022-01-30 | Allegheny | Pennsylvania | 42003 | 250741 | 2976 |
2163449 | 2163449 | 2022-01-29 | Allegheny | Pennsylvania | 42003 | 250058 | 2975 |
2160194 | 2160194 | 2022-01-28 | Allegheny | Pennsylvania | 42003 | 246575 | 2965 |
2156938 | 2156938 | 2022-01-27 | Allegheny | Pennsylvania | 42003 | 245213 | 2954 |
2153685 | 2153685 | 2022-01-26 | Allegheny | Pennsylvania | 42003 | 243543 | 2933 |
2150433 | 2150433 | 2022-01-25 | Allegheny | Pennsylvania | 42003 | 242555 | 2921 |
2147181 | 2147181 | 2022-01-24 | Allegheny | Pennsylvania | 42003 | 241621 | 2905 |
2143927 | 2143927 | 2022-01-23 | Allegheny | Pennsylvania | 42003 | 240260 | 2904 |
2140672 | 2140672 | 2022-01-22 | Allegheny | Pennsylvania | 42003 | 239215 | 2901 |
2137416 | 2137416 | 2022-01-21 | Allegheny | Pennsylvania | 42003 | 237334 | 2885 |
2134162 | 2134162 | 2022-01-20 | Allegheny | Pennsylvania | 42003 | 235185 | 2864 |
2130910 | 2130910 | 2022-01-19 | Allegheny | Pennsylvania | 42003 | 233419 | 2848 |
2127656 | 2127656 | 2022-01-18 | Allegheny | Pennsylvania | 42003 | 231810 | 2843 |
2124404 | 2124404 | 2022-01-17 | Allegheny | Pennsylvania | 42003 | 230108 | 2842 |
2121152 | 2121152 | 2022-01-16 | Allegheny | Pennsylvania | 42003 | 228362 | 2842 |
2117900 | 2117900 | 2022-01-15 | Allegheny | Pennsylvania | 42003 | 224385 | 2842 |
2114649 | 2114649 | 2022-01-14 | Allegheny | Pennsylvania | 42003 | 221273 | 2831 |
2111397 | 2111397 | 2022-01-13 | Allegheny | Pennsylvania | 42003 | 218117 | 2815 |
2108145 | 2108145 | 2022-01-12 | Allegheny | Pennsylvania | 42003 | 214887 | 2809 |
2104894 | 2104894 | 2022-01-11 | Allegheny | Pennsylvania | 42003 | 210625 | 2799 |
2101643 | 2101643 | 2022-01-10 | Allegheny | Pennsylvania | 42003 | 208603 | 2787 |
2098392 | 2098392 | 2022-01-09 | Allegheny | Pennsylvania | 42003 | 205696 | 2786 |
2095140 | 2095140 | 2022-01-08 | Allegheny | Pennsylvania | 42003 | 202490 | 2784 |
2091888 | 2091888 | 2022-01-07 | Allegheny | Pennsylvania | 42003 | 198751 | 2777 |
2088636 | 2088636 | 2022-01-06 | Allegheny | Pennsylvania | 42003 | 194789 | 2767 |
2085385 | 2085385 | 2022-01-05 | Allegheny | Pennsylvania | 42003 | 190152 | 2750 |
2082133 | 2082133 | 2022-01-04 | Allegheny | Pennsylvania | 42003 | 186760 | 2739 |
2078881 | 2078881 | 2022-01-03 | Allegheny | Pennsylvania | 42003 | 184573 | 2727 |
2075630 | 2075630 | 2022-01-02 | Allegheny | Pennsylvania | 42003 | 181874 | 2725 |
2072379 | 2072379 | 2022-01-01 | Allegheny | Pennsylvania | 42003 | 179776 | 2725 |
2069128 | 2069128 | 2021-12-31 | Allegheny | Pennsylvania | 42003 | 176336 | 2725 |
2065877 | 2065877 | 2021-12-30 | Allegheny | Pennsylvania | 42003 | 174116 | 2724 |
2062627 | 2062627 | 2021-12-29 | Allegheny | Pennsylvania | 42003 | 172136 | 2715 |
2059377 | 2059377 | 2021-12-28 | Allegheny | Pennsylvania | 42003 | 170435 | 2698 |
2056128 | 2056128 | 2021-12-27 | Allegheny | Pennsylvania | 42003 | 169781 | 2691 |
2052879 | 2052879 | 2021-12-26 | Allegheny | Pennsylvania | 42003 | 169372 | 2691 |
2049629 | 2049629 | 2021-12-25 | Allegheny | Pennsylvania | 42003 | 168486 | 2691 |
2046379 | 2046379 | 2021-12-24 | Allegheny | Pennsylvania | 42003 | 167244 | 2691 |
2043129 | 2043129 | 2021-12-23 | Allegheny | Pennsylvania | 42003 | 165659 | 2688 |
2039880 | 2039880 | 2021-12-22 | Allegheny | Pennsylvania | 42003 | 164715 | 2674 |
2036630 | 2036630 | 2021-12-21 | Allegheny | Pennsylvania | 42003 | 164271 | 2665 |
2033380 | 2033380 | 2021-12-20 | Allegheny | Pennsylvania | 42003 | 163457 | 2648 |
2030130 | 2030130 | 2021-12-19 | Allegheny | Pennsylvania | 42003 | 163022 | 2646 |
2026879 | 2026879 | 2021-12-18 | Allegheny | Pennsylvania | 42003 | 162514 | 2643 |
2023628 | 2023628 | 2021-12-17 | Allegheny | Pennsylvania | 42003 | 161862 | 2629 |
2020377 | 2020377 | 2021-12-16 | Allegheny | Pennsylvania | 42003 | 161085 | 2620 |
2017126 | 2017126 | 2021-12-15 | Allegheny | Pennsylvania | 42003 | 160659 | 2612 |
2013876 | 2013876 | 2021-12-14 | Allegheny | Pennsylvania | 42003 | 160084 | 2583 |
2010625 | 2010625 | 2021-12-13 | Allegheny | Pennsylvania | 42003 | 159390 | 2574 |
2007374 | 2007374 | 2021-12-12 | Allegheny | Pennsylvania | 42003 | 159011 | 2574 |
2004123 | 2004123 | 2021-12-11 | Allegheny | Pennsylvania | 42003 | 158347 | 2570 |
2000872 | 2000872 | 2021-12-10 | Allegheny | Pennsylvania | 42003 | 157410 | 2560 |
1997622 | 1997622 | 2021-12-09 | Allegheny | Pennsylvania | 42003 | 156669 | 2545 |
1994371 | 1994371 | 2021-12-08 | Allegheny | Pennsylvania | 42003 | 155979 | 2542 |
1991120 | 1991120 | 2021-12-07 | Allegheny | Pennsylvania | 42003 | 155212 | 2532 |
1987869 | 1987869 | 2021-12-06 | Allegheny | Pennsylvania | 42003 | 154363 | 2526 |
1984619 | 1984619 | 2021-12-05 | Allegheny | Pennsylvania | 42003 | 154011 | 2522 |
1981369 | 1981369 | 2021-12-04 | Allegheny | Pennsylvania | 42003 | 153516 | 2518 |
1978119 | 1978119 | 2021-12-03 | Allegheny | Pennsylvania | 42003 | 152840 | 2512 |
1974869 | 1974869 | 2021-12-02 | Allegheny | Pennsylvania | 42003 | 151539 | 2502 |
1971620 | 1971620 | 2021-12-01 | Allegheny | Pennsylvania | 42003 | 150886 | 2495 |
1968370 | 1968370 | 2021-11-30 | Allegheny | Pennsylvania | 42003 | 150179 | 2490 |
1965119 | 1965119 | 2021-11-29 | Allegheny | Pennsylvania | 42003 | 149645 | 2483 |
1961867 | 1961867 | 2021-11-28 | Allegheny | Pennsylvania | 42003 | 148898 | 2481 |
1958616 | 1958616 | 2021-11-27 | Allegheny | Pennsylvania | 42003 | 148492 | 2476 |
1955365 | 1955365 | 2021-11-26 | Allegheny | Pennsylvania | 42003 | 148118 | 2476 |
1952114 | 1952114 | 2021-11-25 | Allegheny | Pennsylvania | 42003 | 147267 | 2476 |
1948863 | 1948863 | 2021-11-24 | Allegheny | Pennsylvania | 42003 | 146794 | 2468 |
1945612 | 1945612 | 2021-11-23 | Allegheny | Pennsylvania | 42003 | 145902 | 2462 |
1942361 | 1942361 | 2021-11-22 | Allegheny | Pennsylvania | 42003 | 145422 | 2458 |
1939111 | 1939111 | 2021-11-21 | Allegheny | Pennsylvania | 42003 | 144615 | 2458 |
1935861 | 1935861 | 2021-11-20 | Allegheny | Pennsylvania | 42003 | 144076 | 2457 |
1932611 | 1932611 | 2021-11-19 | Allegheny | Pennsylvania | 42003 | 143372 | 2451 |
1929360 | 1929360 | 2021-11-18 | Allegheny | Pennsylvania | 42003 | 142527 | 2446 |
1926110 | 1926110 | 2021-11-17 | Allegheny | Pennsylvania | 42003 | 141833 | 2439 |
1922860 | 1922860 | 2021-11-16 | Allegheny | Pennsylvania | 42003 | 141336 | 2431 |
1919611 | 1919611 | 2021-11-15 | Allegheny | Pennsylvania | 42003 | 140678 | 2424 |
1916361 | 1916361 | 2021-11-14 | Allegheny | Pennsylvania | 42003 | 140263 | 2423 |
1913111 | 1913111 | 2021-11-13 | Allegheny | Pennsylvania | 42003 | 139730 | 2420 |
1909861 | 1909861 | 2021-11-12 | Allegheny | Pennsylvania | 42003 | 137807 | 2414 |
1906612 | 1906612 | 2021-11-11 | Allegheny | Pennsylvania | 42003 | 137203 | 2412 |
1903363 | 1903363 | 2021-11-10 | Allegheny | Pennsylvania | 42003 | 136799 | 2402 |
1900113 | 1900113 | 2021-11-09 | Allegheny | Pennsylvania | 42003 | 136200 | 2388 |
1896863 | 1896863 | 2021-11-08 | Allegheny | Pennsylvania | 42003 | 135939 | 2378 |
1893613 | 1893613 | 2021-11-07 | Allegheny | Pennsylvania | 42003 | 135549 | 2376 |
1890363 | 1890363 | 2021-11-06 | Allegheny | Pennsylvania | 42003 | 135115 | 2376 |
1887113 | 1887113 | 2021-11-05 | Allegheny | Pennsylvania | 42003 | 134695 | 2372 |
1883863 | 1883863 | 2021-11-04 | Allegheny | Pennsylvania | 42003 | 134146 | 2369 |
1880614 | 1880614 | 2021-11-03 | Allegheny | Pennsylvania | 42003 | 133681 | 2358 |
1877365 | 1877365 | 2021-11-02 | Allegheny | Pennsylvania | 42003 | 133256 | 2350 |
1874116 | 1874116 | 2021-11-01 | Allegheny | Pennsylvania | 42003 | 132673 | 2343 |
1870867 | 1870867 | 2021-10-31 | Allegheny | Pennsylvania | 42003 | 132673 | 2343 |
1867618 | 1867618 | 2021-10-30 | Allegheny | Pennsylvania | 42003 | 132348 | 2338 |
1864369 | 1864369 | 2021-10-29 | Allegheny | Pennsylvania | 42003 | 131892 | 2334 |
1861120 | 1861120 | 2021-10-28 | Allegheny | Pennsylvania | 42003 | 131420 | 2332 |
1857871 | 1857871 | 2021-10-27 | Allegheny | Pennsylvania | 42003 | 131032 | 2321 |
1854622 | 1854622 | 2021-10-26 | Allegheny | Pennsylvania | 42003 | 130624 | 2306 |
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);