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)
Suggested facets: cases, date (date)
deaths 556 ✖
- 2 11
- 2016 9
- 2025 8
- 0 7
- 397 7
- 3294 7
- 3319 7
- 2030 6
- 349 5
- 380 5
- 179 4
- 186 4
- 190 4
- 373 4
- 386 4
- 421 4
- 2008 4
- 2017 4
- 2210 4
- 2691 4
- 3280 4
- 3311 4
- 3316 4
- 1 3
- 102 3
- 143 3
- 160 3
- 168 3
- 177 3
- 198 3
- 222 3
- 306 3
- 330 3
- 362 3
- 405 3
- 434 3
- 447 3
- 458 3
- 482 3
- 575 3
- 1767 3
- 1964 3
- 2027 3
- 2038 3
- 2054 3
- 2065 3
- 2094 3
- 2139 3
- 2257 3
- 2303 3
- 2476 3
- 2725 3
- 2842 3
- 3156 3
- 3289 3
- 3302 3
- 3323 3
- 4 2
- 19 2
- 73 2
- 139 2
- 163 2
- 166 2
- 169 2
- 171 2
- 172 2
- 196 2
- 208 2
- 242 2
- 259 2
- 283 2
- 358 2
- 363 2
- 376 2
- 382 2
- 393 2
- 442 2
- 465 2
- 498 2
- 505 2
- 1591 2
- 1685 2
- 1715 2
- 1720 2
- 1755 2
- 1774 2
- 1780 2
- 1821 2
- 1860 2
- 1870 2
- 1879 2
- 1885 2
- 1901 2
- 1922 2
- 1979 2
- 1980 2
- 1989 2
- 1999 2
- 2009 2
- 2011 2
- 2013 2
- 2023 2
- 2024 2
- 2026 2
- 2028 2
- 2032 2
- 2066 2
- 2083 2
- 2119 2
- 2343 2
- 2376 2
- 2458 2
- 2574 2
- 3112 2
- 3143 2
- 3200 2
- 3222 2
- 3233 2
- 3263 2
- 3264 2
- 3268 2
- 3310 2
- 3312 2
- 3 1
- 6 1
- 10 1
- 12 1
- 18 1
- 21 1
- 24 1
- 26 1
- 38 1
- 43 1
- 47 1
- 50 1
- 55 1
- 67 1
- 69 1
- 71 1
- 74 1
- 79 1
- 86 1
- 87 1
- 94 1
- 99 1
- 109 1
- 111 1
- 117 1
- 119 1
- 120 1
- 122 1
- 123 1
- 127 1
- 141 1
- 145 1
- 147 1
- 148 1
- 154 1
- 158 1
- 159 1
- 161 1
- 162 1
- 164 1
- 165 1
- 170 1
- 174 1
- 178 1
- 180 1
- 182 1
- 183 1
- 187 1
- 188 1
- 194 1
- 197 1
- 199 1
- 204 1
- 205 1
- 206 1
- 207 1
- 211 1
- 217 1
- 219 1
- 221 1
- 229 1
- 234 1
- 235 1
- 239 1
- 240 1
- 243 1
- 248 1
- 251 1
- 257 1
- 258 1
- 260 1
- 273 1
- 278 1
- 288 1
- 290 1
- 291 1
- 297 1
- 298 1
- 304 1
- 309 1
- 317 1
- 318 1
- 325 1
- 334 1
- 343 1
- 344 1
- 361 1
- 366 1
- 370 1
- 390 1
- 403 1
- 406 1
- 416 1
- 417 1
- 422 1
- 426 1
- 428 1
- 435 1
- 437 1
- 446 1
- 448 1
- 453 1
- 456 1
- 459 1
- 462 1
- 468 1
- 486 1
- 504 1
- 510 1
- 518 1
- 536 1
- 551 1
- 570 1
- 588 1
- 619 1
- 635 1
- 658 1
- 681 1
- 691 1
- 696 1
- 717 1
- 741 1
- 767 1
- 791 1
- 815 1
- 823 1
- 830 1
- 845 1
- 867 1
- 888 1
- 899 1
- 906 1
- 916 1
- 925 1
- 952 1
- 977 1
- 1009 1
- 1036 1
- 1041 1
- 1047 1
- 1055 1
- 1070 1
- 1099 1
- 1118 1
- 1143 1
- 1173 1
- 1180 1
- 1192 1
- 1208 1
- 1253 1
- 1277 1
- 1302 1
- 1322 1
- 1334 1
- 1336 1
- 1338 1
- 1370 1
- 1394 1
- 1413 1
- 1422 1
- 1430 1
- 1435 1
- 1454 1
- 1471 1
- 1485 1
- 1500 1
- 1516 1
- 1520 1
- 1521 1
- 1536 1
- 1555 1
- 1568 1
- 1576 1
- 1586 1
- 1600 1
- 1608 1
- 1620 1
- 1630 1
- 1643 1
- 1644 1
- 1646 1
- 1647 1
- 1658 1
- 1666 1
- 1675 1
- 1689 1
- 1697 1
- 1704 1
- 1708 1
- 1730 1
- 1734 1
- 1738 1
- 1742 1
- 1748 1
- 1760 1
- 1762 1
- 1764 1
- 1769 1
- 1770 1
- 1777 1
- 1779 1
- 1783 1
- 1790 1
- 1793 1
- 1797 1
- 1800 1
- 1801 1
- 1802 1
- 1807 1
- 1814 1
- 1817 1
- 1820 1
- 1823 1
- 1824 1
- 1826 1
- 1832 1
- 1838 1
- 1840 1
- 1841 1
- 1842 1
- 1853 1
- 1866 1
- 1869 1
- 1878 1
- 1882 1
- 1883 1
- 1886 1
- 1891 1
- 1894 1
- 1897 1
- 1899 1
- 1909 1
- 1913 1
- 1915 1
- 1919 1
- 1923 1
- 1927 1
- 1931 1
- 1934 1
- 1938 1
- 1940 1
- 1944 1
- 1947 1
- 1949 1
- 1956 1
- 1957 1
- 1958 1
- 1965 1
- 1969 1
- 1971 1
- 1976 1
- 1984 1
- 1985 1
- 1986 1
- 1988 1
- 1990 1
- 1991 1
- 1994 1
- 1996 1
- 1997 1
- 2003 1
- 2004 1
- 2006 1
- 2010 1
- 2014 1
- 2015 1
- 2021 1
- 2029 1
- 2035 1
- 2037 1
- 2042 1
- 2047 1
- 2051 1
- 2052 1
- 2057 1
- 2060 1
- 2062 1
- 2063 1
- 2076 1
- 2081 1
- 2082 1
- 2084 1
- 2086 1
- 2089 1
- 2091 1
- 2101 1
- 2107 1
- 2113 1
- 2116 1
- 2118 1
- 2124 1
- 2129 1
- 2131 1
- 2134 1
- 2150 1
- 2160 1
- 2164 1
- 2165 1
- 2173 1
- 2175 1
- 2176 1
- 2185 1
- 2196 1
- 2202 1
- 2226 1
- 2242 1
- 2249 1
- 2263 1
- 2267 1
- 2281 1
- 2286 1
- 2298 1
- 2306 1
- 2321 1
- 2332 1
- 2334 1
- 2338 1
- 2350 1
- 2358 1
- 2369 1
- 2372 1
- 2378 1
- 2388 1
- 2402 1
- 2412 1
- 2414 1
- 2420 1
- 2423 1
- 2424 1
- 2431 1
- 2439 1
- 2446 1
- 2451 1
- 2457 1
- 2462 1
- 2468 1
- 2481 1
- 2483 1
- 2490 1
- 2495 1
- 2502 1
- 2512 1
- 2518 1
- 2522 1
- 2526 1
- 2532 1
- 2542 1
- 2545 1
- 2560 1
- 2570 1
- 2583 1
- 2612 1
- 2620 1
- 2629 1
- 2643 1
- 2646 1
- 2648 1
- 2665 1
- 2674 1
- 2688 1
- 2698 1
- 2715 1
- 2724 1
- 2727 1
- 2739 1
- 2750 1
- 2767 1
- 2777 1
- 2784 1
- 2786 1
- 2787 1
- 2799 1
- 2809 1
- 2815 1
- 2831 1
- 2843 1
- 2848 1
- 2864 1
- 2885 1
- 2901 1
- 2904 1
- 2905 1
- 2921 1
- 2933 1
- 2954 1
- 2965 1
- 2975 1
- 2976 1
- 2979 1
- 3004 1
- 3019 1
- 3031 1
- 3043 1
- 3057 1
- 3059 1
- 3063 1
- 3083 1
- 3091 1
- 3098 1
- 3105 1
- 3117 1
- 3126 1
- 3136 1
- 3140 1
- 3175 1
- 3186 1
- 3191 1
- 3198 1
- 3210 1
- 3217 1
- 3220 1
- 3242 1
- 3243 1
- 3244 1
- 3253 1
- 3258 1
- 3259 1
- 3260 1
- 3262 1
- 3272 1
- 3275 1
- 3278 1
- 3282 1
- 3285 1
- 3286 1
- 3288 1
- 3292 1
- 3295 1
- 3299 1
- 3301 1
- 3309 1
- 3314 1
- 3317 1
state 1
- Pennsylvania 791
fips 1
- 42003 791
county 1
- Allegheny · 791 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501848 | 2501848 | 2022-05-13 | Allegheny | Pennsylvania | 42003 | 271427 | 3323 |
2498590 | 2498590 | 2022-05-12 | Allegheny | Pennsylvania | 42003 | 271427 | 3323 |
2495332 | 2495332 | 2022-05-11 | Allegheny | Pennsylvania | 42003 | 271427 | 3323 |
2492074 | 2492074 | 2022-05-10 | Allegheny | Pennsylvania | 42003 | 268725 | 3319 |
2488816 | 2488816 | 2022-05-09 | Allegheny | Pennsylvania | 42003 | 268725 | 3319 |
2485559 | 2485559 | 2022-05-08 | Allegheny | Pennsylvania | 42003 | 268725 | 3319 |
2482301 | 2482301 | 2022-05-07 | Allegheny | Pennsylvania | 42003 | 268725 | 3319 |
2479043 | 2479043 | 2022-05-06 | Allegheny | Pennsylvania | 42003 | 268725 | 3319 |
2475785 | 2475785 | 2022-05-05 | Allegheny | Pennsylvania | 42003 | 268725 | 3319 |
2472528 | 2472528 | 2022-05-04 | Allegheny | Pennsylvania | 42003 | 268725 | 3319 |
2469272 | 2469272 | 2022-05-03 | Allegheny | Pennsylvania | 42003 | 268436 | 3317 |
2466016 | 2466016 | 2022-05-02 | Allegheny | Pennsylvania | 42003 | 268240 | 3316 |
2462761 | 2462761 | 2022-05-01 | Allegheny | Pennsylvania | 42003 | 268082 | 3316 |
2459505 | 2459505 | 2022-04-30 | Allegheny | Pennsylvania | 42003 | 267841 | 3316 |
2456249 | 2456249 | 2022-04-29 | Allegheny | Pennsylvania | 42003 | 267593 | 3316 |
2452993 | 2452993 | 2022-04-28 | Allegheny | Pennsylvania | 42003 | 267326 | 3314 |
2449737 | 2449737 | 2022-04-27 | Allegheny | Pennsylvania | 42003 | 267012 | 3312 |
2446480 | 2446480 | 2022-04-26 | Allegheny | Pennsylvania | 42003 | 266679 | 3312 |
2443225 | 2443225 | 2022-04-25 | Allegheny | Pennsylvania | 42003 | 266523 | 3311 |
2439969 | 2439969 | 2022-04-24 | Allegheny | Pennsylvania | 42003 | 266379 | 3311 |
2436713 | 2436713 | 2022-04-23 | Allegheny | Pennsylvania | 42003 | 266239 | 3311 |
2433457 | 2433457 | 2022-04-22 | Allegheny | Pennsylvania | 42003 | 265968 | 3311 |
2430201 | 2430201 | 2022-04-21 | Allegheny | Pennsylvania | 42003 | 265744 | 3310 |
2426945 | 2426945 | 2022-04-20 | Allegheny | Pennsylvania | 42003 | 265536 | 3310 |
2423689 | 2423689 | 2022-04-19 | Allegheny | Pennsylvania | 42003 | 265302 | 3309 |
2420433 | 2420433 | 2022-04-18 | Allegheny | Pennsylvania | 42003 | 265167 | 3302 |
2417177 | 2417177 | 2022-04-17 | Allegheny | Pennsylvania | 42003 | 265036 | 3302 |
2413921 | 2413921 | 2022-04-16 | Allegheny | Pennsylvania | 42003 | 264941 | 3302 |
2410665 | 2410665 | 2022-04-15 | Allegheny | Pennsylvania | 42003 | 264711 | 3301 |
2407409 | 2407409 | 2022-04-14 | Allegheny | Pennsylvania | 42003 | 264521 | 3299 |
2404153 | 2404153 | 2022-04-13 | Allegheny | Pennsylvania | 42003 | 264349 | 3294 |
2400898 | 2400898 | 2022-04-12 | Allegheny | Pennsylvania | 42003 | 264143 | 3295 |
2397643 | 2397643 | 2022-04-11 | Allegheny | Pennsylvania | 42003 | 264031 | 3294 |
2394388 | 2394388 | 2022-04-10 | Allegheny | Pennsylvania | 42003 | 263964 | 3294 |
2391132 | 2391132 | 2022-04-09 | Allegheny | Pennsylvania | 42003 | 263899 | 3294 |
2387876 | 2387876 | 2022-04-08 | Allegheny | Pennsylvania | 42003 | 263773 | 3294 |
2384621 | 2384621 | 2022-04-07 | Allegheny | Pennsylvania | 42003 | 263617 | 3294 |
2381366 | 2381366 | 2022-04-06 | Allegheny | Pennsylvania | 42003 | 263496 | 3294 |
2378111 | 2378111 | 2022-04-05 | Allegheny | Pennsylvania | 42003 | 263437 | 3292 |
2374857 | 2374857 | 2022-04-04 | Allegheny | Pennsylvania | 42003 | 263368 | 3289 |
2371605 | 2371605 | 2022-04-03 | Allegheny | Pennsylvania | 42003 | 263300 | 3289 |
2368352 | 2368352 | 2022-04-02 | Allegheny | Pennsylvania | 42003 | 263300 | 3289 |
2365099 | 2365099 | 2022-04-01 | Allegheny | Pennsylvania | 42003 | 263209 | 3288 |
2361846 | 2361846 | 2022-03-31 | Allegheny | Pennsylvania | 42003 | 263142 | 3286 |
2358592 | 2358592 | 2022-03-30 | Allegheny | Pennsylvania | 42003 | 263085 | 3285 |
2355338 | 2355338 | 2022-03-29 | Allegheny | Pennsylvania | 42003 | 263027 | 3282 |
2352085 | 2352085 | 2022-03-28 | Allegheny | Pennsylvania | 42003 | 262969 | 3280 |
2348833 | 2348833 | 2022-03-27 | Allegheny | Pennsylvania | 42003 | 262939 | 3280 |
2345580 | 2345580 | 2022-03-26 | Allegheny | Pennsylvania | 42003 | 262894 | 3280 |
2342327 | 2342327 | 2022-03-25 | Allegheny | Pennsylvania | 42003 | 262805 | 3280 |
2339074 | 2339074 | 2022-03-24 | Allegheny | Pennsylvania | 42003 | 262741 | 3278 |
2335820 | 2335820 | 2022-03-23 | Allegheny | Pennsylvania | 42003 | 262636 | 3275 |
2332566 | 2332566 | 2022-03-22 | Allegheny | Pennsylvania | 42003 | 262556 | 3272 |
2329313 | 2329313 | 2022-03-21 | Allegheny | Pennsylvania | 42003 | 262514 | 3268 |
2326061 | 2326061 | 2022-03-20 | Allegheny | Pennsylvania | 42003 | 262456 | 3268 |
2322808 | 2322808 | 2022-03-19 | Allegheny | Pennsylvania | 42003 | 262410 | 3264 |
2319554 | 2319554 | 2022-03-18 | Allegheny | Pennsylvania | 42003 | 262340 | 3264 |
2316300 | 2316300 | 2022-03-17 | Allegheny | Pennsylvania | 42003 | 262233 | 3263 |
2313047 | 2313047 | 2022-03-16 | Allegheny | Pennsylvania | 42003 | 262172 | 3263 |
2309794 | 2309794 | 2022-03-15 | Allegheny | Pennsylvania | 42003 | 262125 | 3262 |
2306541 | 2306541 | 2022-03-14 | Allegheny | Pennsylvania | 42003 | 262042 | 3260 |
2303290 | 2303290 | 2022-03-13 | Allegheny | Pennsylvania | 42003 | 262010 | 3259 |
2300038 | 2300038 | 2022-03-12 | Allegheny | Pennsylvania | 42003 | 261957 | 3258 |
2296786 | 2296786 | 2022-03-11 | Allegheny | Pennsylvania | 42003 | 261882 | 3253 |
2293534 | 2293534 | 2022-03-10 | Allegheny | Pennsylvania | 42003 | 261789 | 3244 |
2290282 | 2290282 | 2022-03-09 | Allegheny | Pennsylvania | 42003 | 261659 | 3243 |
2287030 | 2287030 | 2022-03-08 | Allegheny | Pennsylvania | 42003 | 261591 | 3242 |
2283778 | 2283778 | 2022-03-07 | Allegheny | Pennsylvania | 42003 | 261495 | 3233 |
2280526 | 2280526 | 2022-03-06 | Allegheny | Pennsylvania | 42003 | 261395 | 3233 |
2277273 | 2277273 | 2022-03-05 | Allegheny | Pennsylvania | 42003 | 261326 | 3222 |
2274020 | 2274020 | 2022-03-04 | Allegheny | Pennsylvania | 42003 | 261220 | 3222 |
2270767 | 2270767 | 2022-03-03 | Allegheny | Pennsylvania | 42003 | 261102 | 3220 |
2267515 | 2267515 | 2022-03-02 | Allegheny | Pennsylvania | 42003 | 260980 | 3217 |
2264262 | 2264262 | 2022-03-01 | Allegheny | Pennsylvania | 42003 | 260868 | 3210 |
2261012 | 2261012 | 2022-02-28 | Allegheny | Pennsylvania | 42003 | 260712 | 3200 |
2257761 | 2257761 | 2022-02-27 | Allegheny | Pennsylvania | 42003 | 260642 | 3200 |
2254510 | 2254510 | 2022-02-26 | Allegheny | Pennsylvania | 42003 | 260530 | 3198 |
2251259 | 2251259 | 2022-02-25 | Allegheny | Pennsylvania | 42003 | 260180 | 3191 |
2248008 | 2248008 | 2022-02-24 | Allegheny | Pennsylvania | 42003 | 260022 | 3186 |
2244757 | 2244757 | 2022-02-23 | Allegheny | Pennsylvania | 42003 | 259837 | 3175 |
2241506 | 2241506 | 2022-02-22 | Allegheny | Pennsylvania | 42003 | 259678 | 3156 |
2238255 | 2238255 | 2022-02-21 | Allegheny | Pennsylvania | 42003 | 259348 | 3156 |
2235004 | 2235004 | 2022-02-20 | Allegheny | Pennsylvania | 42003 | 259348 | 3156 |
2231753 | 2231753 | 2022-02-19 | Allegheny | Pennsylvania | 42003 | 259206 | 3143 |
2228502 | 2228502 | 2022-02-18 | Allegheny | Pennsylvania | 42003 | 258731 | 3143 |
2225251 | 2225251 | 2022-02-17 | Allegheny | Pennsylvania | 42003 | 258378 | 3140 |
2222000 | 2222000 | 2022-02-16 | Allegheny | Pennsylvania | 42003 | 258008 | 3136 |
2218749 | 2218749 | 2022-02-15 | Allegheny | Pennsylvania | 42003 | 257812 | 3126 |
2215498 | 2215498 | 2022-02-14 | Allegheny | Pennsylvania | 42003 | 257594 | 3117 |
2212247 | 2212247 | 2022-02-13 | Allegheny | Pennsylvania | 42003 | 257293 | 3112 |
2208994 | 2208994 | 2022-02-12 | Allegheny | Pennsylvania | 42003 | 257052 | 3112 |
2205741 | 2205741 | 2022-02-11 | Allegheny | Pennsylvania | 42003 | 256562 | 3105 |
2202488 | 2202488 | 2022-02-10 | Allegheny | Pennsylvania | 42003 | 256178 | 3098 |
2199234 | 2199234 | 2022-02-09 | Allegheny | Pennsylvania | 42003 | 255702 | 3091 |
2195980 | 2195980 | 2022-02-08 | Allegheny | Pennsylvania | 42003 | 255232 | 3083 |
2192726 | 2192726 | 2022-02-07 | Allegheny | Pennsylvania | 42003 | 255574 | 3063 |
2189472 | 2189472 | 2022-02-06 | Allegheny | Pennsylvania | 42003 | 254874 | 3059 |
2186219 | 2186219 | 2022-02-05 | Allegheny | Pennsylvania | 42003 | 254604 | 3057 |
2182967 | 2182967 | 2022-02-04 | Allegheny | Pennsylvania | 42003 | 253888 | 3043 |
2179715 | 2179715 | 2022-02-03 | Allegheny | Pennsylvania | 42003 | 253226 | 3031 |
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);