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 deaths
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 ▼ |
---|---|---|---|---|---|---|---|
2209 | 2209 | 2020-03-14 | Allegheny | Pennsylvania | 42003 | 1 | 0 |
2629 | 2629 | 2020-03-15 | Allegheny | Pennsylvania | 42003 | 3 | 0 |
3094 | 3094 | 2020-03-16 | Allegheny | Pennsylvania | 42003 | 5 | 0 |
3623 | 3623 | 2020-03-17 | Allegheny | Pennsylvania | 42003 | 10 | 0 |
4239 | 4239 | 2020-03-18 | Allegheny | Pennsylvania | 42003 | 12 | 0 |
4978 | 4978 | 2020-03-19 | Allegheny | Pennsylvania | 42003 | 18 | 0 |
5847 | 5847 | 2020-03-20 | Allegheny | Pennsylvania | 42003 | 28 | 0 |
6849 | 6849 | 2020-03-21 | Allegheny | Pennsylvania | 42003 | 31 | 1 |
7964 | 7964 | 2020-03-22 | Allegheny | Pennsylvania | 42003 | 40 | 1 |
9174 | 9174 | 2020-03-23 | Allegheny | Pennsylvania | 42003 | 48 | 1 |
10493 | 10493 | 2020-03-24 | Allegheny | Pennsylvania | 42003 | 58 | 2 |
11955 | 11955 | 2020-03-25 | Allegheny | Pennsylvania | 42003 | 88 | 2 |
13573 | 13573 | 2020-03-26 | Allegheny | Pennsylvania | 42003 | 133 | 2 |
15319 | 15319 | 2020-03-27 | Allegheny | Pennsylvania | 42003 | 158 | 2 |
17166 | 17166 | 2020-03-28 | Allegheny | Pennsylvania | 42003 | 219 | 2 |
19104 | 19104 | 2020-03-29 | Allegheny | Pennsylvania | 42003 | 265 | 2 |
21154 | 21154 | 2020-03-30 | Allegheny | Pennsylvania | 42003 | 290 | 2 |
23289 | 23289 | 2020-03-31 | Allegheny | Pennsylvania | 42003 | 325 | 2 |
25487 | 25487 | 2020-04-01 | Allegheny | Pennsylvania | 42003 | 356 | 2 |
27759 | 27759 | 2020-04-02 | Allegheny | Pennsylvania | 42003 | 419 | 2 |
30092 | 30092 | 2020-04-03 | Allegheny | Pennsylvania | 42003 | 476 | 2 |
32482 | 32482 | 2020-04-04 | Allegheny | Pennsylvania | 42003 | 552 | 3 |
34917 | 34917 | 2020-04-05 | Allegheny | Pennsylvania | 42003 | 605 | 4 |
37392 | 37392 | 2020-04-06 | Allegheny | Pennsylvania | 42003 | 642 | 4 |
39913 | 39913 | 2020-04-07 | Allegheny | Pennsylvania | 42003 | 689 | 6 |
42473 | 42473 | 2020-04-08 | Allegheny | Pennsylvania | 42003 | 720 | 10 |
45059 | 45059 | 2020-04-09 | Allegheny | Pennsylvania | 42003 | 759 | 12 |
47676 | 47676 | 2020-04-10 | Allegheny | Pennsylvania | 42003 | 788 | 18 |
50333 | 50333 | 2020-04-11 | Allegheny | Pennsylvania | 42003 | 836 | 19 |
53006 | 53006 | 2020-04-12 | Allegheny | Pennsylvania | 42003 | 857 | 19 |
55691 | 55691 | 2020-04-13 | Allegheny | Pennsylvania | 42003 | 876 | 21 |
58394 | 58394 | 2020-04-14 | Allegheny | Pennsylvania | 42003 | 893 | 24 |
61109 | 61109 | 2020-04-15 | Allegheny | Pennsylvania | 42003 | 904 | 26 |
63835 | 63835 | 2020-04-16 | Allegheny | Pennsylvania | 42003 | 925 | 38 |
66581 | 66581 | 2020-04-17 | Allegheny | Pennsylvania | 42003 | 947 | 43 |
69339 | 69339 | 2020-04-18 | Allegheny | Pennsylvania | 42003 | 1009 | 47 |
72106 | 72106 | 2020-04-19 | Allegheny | Pennsylvania | 42003 | 1035 | 50 |
74881 | 74881 | 2020-04-20 | Allegheny | Pennsylvania | 42003 | 1042 | 55 |
77663 | 77663 | 2020-04-21 | Allegheny | Pennsylvania | 42003 | 1059 | 67 |
83252 | 83252 | 2020-04-23 | Allegheny | Pennsylvania | 42003 | 1149 | 69 |
86056 | 86056 | 2020-04-24 | Allegheny | Pennsylvania | 42003 | 1177 | 71 |
88870 | 88870 | 2020-04-25 | Allegheny | Pennsylvania | 42003 | 1198 | 73 |
91686 | 91686 | 2020-04-26 | Allegheny | Pennsylvania | 42003 | 1211 | 73 |
80453 | 80453 | 2020-04-22 | Allegheny | Pennsylvania | 42003 | 1088 | 74 |
94513 | 94513 | 2020-04-27 | Allegheny | Pennsylvania | 42003 | 1224 | 79 |
100201 | 100201 | 2020-04-29 | Allegheny | Pennsylvania | 42003 | 1273 | 86 |
97352 | 97352 | 2020-04-28 | Allegheny | Pennsylvania | 42003 | 1235 | 87 |
103054 | 103054 | 2020-04-30 | Allegheny | Pennsylvania | 42003 | 1289 | 94 |
105917 | 105917 | 2020-05-01 | Allegheny | Pennsylvania | 42003 | 1319 | 99 |
108784 | 108784 | 2020-05-02 | Allegheny | Pennsylvania | 42003 | 1333 | 102 |
111658 | 111658 | 2020-05-03 | Allegheny | Pennsylvania | 42003 | 1345 | 102 |
114540 | 114540 | 2020-05-04 | Allegheny | Pennsylvania | 42003 | 1365 | 102 |
117421 | 117421 | 2020-05-05 | Allegheny | Pennsylvania | 42003 | 1375 | 109 |
120383 | 120383 | 2020-05-06 | Allegheny | Pennsylvania | 42003 | 1394 | 111 |
123360 | 123360 | 2020-05-07 | Allegheny | Pennsylvania | 42003 | 1439 | 117 |
126343 | 126343 | 2020-05-08 | Allegheny | Pennsylvania | 42003 | 1455 | 119 |
129332 | 129332 | 2020-05-09 | Allegheny | Pennsylvania | 42003 | 1486 | 120 |
132321 | 132321 | 2020-05-10 | Allegheny | Pennsylvania | 42003 | 1503 | 122 |
135312 | 135312 | 2020-05-11 | Allegheny | Pennsylvania | 42003 | 1511 | 123 |
138302 | 138302 | 2020-05-12 | Allegheny | Pennsylvania | 42003 | 1526 | 127 |
141298 | 141298 | 2020-05-13 | Allegheny | Pennsylvania | 42003 | 1545 | 139 |
144294 | 144294 | 2020-05-14 | Allegheny | Pennsylvania | 42003 | 1551 | 139 |
147295 | 147295 | 2020-05-15 | Allegheny | Pennsylvania | 42003 | 1582 | 141 |
150302 | 150302 | 2020-05-16 | Allegheny | Pennsylvania | 42003 | 1595 | 143 |
153313 | 153313 | 2020-05-17 | Allegheny | Pennsylvania | 42003 | 1603 | 143 |
156330 | 156330 | 2020-05-18 | Allegheny | Pennsylvania | 42003 | 1641 | 143 |
159351 | 159351 | 2020-05-19 | Allegheny | Pennsylvania | 42003 | 1658 | 145 |
162378 | 162378 | 2020-05-20 | Allegheny | Pennsylvania | 42003 | 1687 | 147 |
165407 | 165407 | 2020-05-21 | Allegheny | Pennsylvania | 42003 | 1718 | 148 |
168443 | 168443 | 2020-05-22 | Allegheny | Pennsylvania | 42003 | 1739 | 154 |
171482 | 171482 | 2020-05-23 | Allegheny | Pennsylvania | 42003 | 1753 | 158 |
174524 | 174524 | 2020-05-24 | Allegheny | Pennsylvania | 42003 | 1777 | 159 |
177568 | 177568 | 2020-05-25 | Allegheny | Pennsylvania | 42003 | 1805 | 160 |
180611 | 180611 | 2020-05-26 | Allegheny | Pennsylvania | 42003 | 1816 | 160 |
183661 | 183661 | 2020-05-27 | Allegheny | Pennsylvania | 42003 | 1828 | 160 |
186718 | 186718 | 2020-05-28 | Allegheny | Pennsylvania | 42003 | 1851 | 161 |
189779 | 189779 | 2020-05-29 | Allegheny | Pennsylvania | 42003 | 1870 | 162 |
192844 | 192844 | 2020-05-30 | Allegheny | Pennsylvania | 42003 | 1897 | 163 |
195913 | 195913 | 2020-05-31 | Allegheny | Pennsylvania | 42003 | 1911 | 163 |
198986 | 198986 | 2020-06-01 | Allegheny | Pennsylvania | 42003 | 1919 | 164 |
202061 | 202061 | 2020-06-02 | Allegheny | Pennsylvania | 42003 | 1928 | 165 |
205138 | 205138 | 2020-06-03 | Allegheny | Pennsylvania | 42003 | 1952 | 166 |
208219 | 208219 | 2020-06-04 | Allegheny | Pennsylvania | 42003 | 1965 | 166 |
211301 | 211301 | 2020-06-05 | Allegheny | Pennsylvania | 42003 | 1973 | 168 |
214387 | 214387 | 2020-06-06 | Allegheny | Pennsylvania | 42003 | 1989 | 168 |
217477 | 217477 | 2020-06-07 | Allegheny | Pennsylvania | 42003 | 2003 | 168 |
220569 | 220569 | 2020-06-08 | Allegheny | Pennsylvania | 42003 | 2008 | 169 |
223664 | 223664 | 2020-06-09 | Allegheny | Pennsylvania | 42003 | 2027 | 169 |
226764 | 226764 | 2020-06-10 | Allegheny | Pennsylvania | 42003 | 2034 | 170 |
229868 | 229868 | 2020-06-11 | Allegheny | Pennsylvania | 42003 | 2055 | 171 |
232973 | 232973 | 2020-06-12 | Allegheny | Pennsylvania | 42003 | 2065 | 171 |
236078 | 236078 | 2020-06-13 | Allegheny | Pennsylvania | 42003 | 2076 | 172 |
239186 | 239186 | 2020-06-14 | Allegheny | Pennsylvania | 42003 | 2079 | 172 |
242295 | 242295 | 2020-06-15 | Allegheny | Pennsylvania | 42003 | 2086 | 174 |
245407 | 245407 | 2020-06-16 | Allegheny | Pennsylvania | 42003 | 2113 | 177 |
248520 | 248520 | 2020-06-17 | Allegheny | Pennsylvania | 42003 | 2113 | 177 |
251635 | 251635 | 2020-06-18 | Allegheny | Pennsylvania | 42003 | 2122 | 177 |
254750 | 254750 | 2020-06-19 | Allegheny | Pennsylvania | 42003 | 2139 | 178 |
257876 | 257876 | 2020-06-20 | Allegheny | Pennsylvania | 42003 | 2159 | 179 |
261003 | 261003 | 2020-06-21 | Allegheny | Pennsylvania | 42003 | 2175 | 179 |
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);