ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 42003 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388178 | 388178 | 2020-07-31 | Allegheny | Pennsylvania | 42003 | 8094 | 239 |
384961 | 384961 | 2020-07-30 | Allegheny | Pennsylvania | 42003 | 7850 | 235 |
381743 | 381743 | 2020-07-29 | Allegheny | Pennsylvania | 42003 | 7718 | 234 |
378526 | 378526 | 2020-07-28 | Allegheny | Pennsylvania | 42003 | 7593 | 229 |
375310 | 375310 | 2020-07-27 | Allegheny | Pennsylvania | 42003 | 7474 | 222 |
372097 | 372097 | 2020-07-26 | Allegheny | Pennsylvania | 42003 | 7294 | 222 |
368885 | 368885 | 2020-07-25 | Allegheny | Pennsylvania | 42003 | 7161 | 222 |
365676 | 365676 | 2020-07-24 | Allegheny | Pennsylvania | 42003 | 7015 | 221 |
362470 | 362470 | 2020-07-23 | Allegheny | Pennsylvania | 42003 | 6817 | 219 |
359264 | 359264 | 2020-07-22 | Allegheny | Pennsylvania | 42003 | 6670 | 217 |
356060 | 356060 | 2020-07-21 | Allegheny | Pennsylvania | 42003 | 6574 | 211 |
352857 | 352857 | 2020-07-20 | Allegheny | Pennsylvania | 42003 | 6435 | 208 |
349654 | 349654 | 2020-07-19 | Allegheny | Pennsylvania | 42003 | 6263 | 208 |
346454 | 346454 | 2020-07-18 | Allegheny | Pennsylvania | 42003 | 6125 | 207 |
343254 | 343254 | 2020-07-17 | Allegheny | Pennsylvania | 42003 | 5990 | 206 |
340056 | 340056 | 2020-07-16 | Allegheny | Pennsylvania | 42003 | 5750 | 205 |
336859 | 336859 | 2020-07-15 | Allegheny | Pennsylvania | 42003 | 5610 | 204 |
333665 | 333665 | 2020-07-14 | Allegheny | Pennsylvania | 42003 | 5364 | 199 |
330473 | 330473 | 2020-07-13 | Allegheny | Pennsylvania | 42003 | 5033 | 198 |
327287 | 327287 | 2020-07-12 | Allegheny | Pennsylvania | 42003 | 4962 | 198 |
324102 | 324102 | 2020-07-11 | Allegheny | Pennsylvania | 42003 | 4762 | 198 |
320922 | 320922 | 2020-07-10 | Allegheny | Pennsylvania | 42003 | 4547 | 197 |
317744 | 317744 | 2020-07-09 | Allegheny | Pennsylvania | 42003 | 4367 | 196 |
314571 | 314571 | 2020-07-08 | Allegheny | Pennsylvania | 42003 | 4209 | 196 |
311399 | 311399 | 2020-07-07 | Allegheny | Pennsylvania | 42003 | 3979 | 194 |
308230 | 308230 | 2020-07-06 | Allegheny | Pennsylvania | 42003 | 3775 | 190 |
305063 | 305063 | 2020-07-05 | Allegheny | Pennsylvania | 42003 | 3557 | 190 |
301900 | 301900 | 2020-07-04 | Allegheny | Pennsylvania | 42003 | 3430 | 190 |
298736 | 298736 | 2020-07-03 | Allegheny | Pennsylvania | 42003 | 3280 | 190 |
295577 | 295577 | 2020-07-02 | Allegheny | Pennsylvania | 42003 | 3103 | 188 |
292421 | 292421 | 2020-07-01 | Allegheny | Pennsylvania | 42003 | 2870 | 187 |
289269 | 289269 | 2020-06-30 | Allegheny | Pennsylvania | 42003 | 2760 | 186 |
286118 | 286118 | 2020-06-29 | Allegheny | Pennsylvania | 42003 | 2651 | 186 |
282973 | 282973 | 2020-06-28 | Allegheny | Pennsylvania | 42003 | 2568 | 186 |
279827 | 279827 | 2020-06-27 | Allegheny | Pennsylvania | 42003 | 2472 | 186 |
276679 | 276679 | 2020-06-26 | Allegheny | Pennsylvania | 42003 | 2382 | 183 |
273532 | 273532 | 2020-06-25 | Allegheny | Pennsylvania | 42003 | 2321 | 182 |
270393 | 270393 | 2020-06-24 | Allegheny | Pennsylvania | 42003 | 2284 | 180 |
267259 | 267259 | 2020-06-23 | Allegheny | Pennsylvania | 42003 | 2239 | 179 |
264131 | 264131 | 2020-06-22 | Allegheny | Pennsylvania | 42003 | 2220 | 179 |
261003 | 261003 | 2020-06-21 | Allegheny | Pennsylvania | 42003 | 2175 | 179 |
257876 | 257876 | 2020-06-20 | Allegheny | Pennsylvania | 42003 | 2159 | 179 |
254750 | 254750 | 2020-06-19 | Allegheny | Pennsylvania | 42003 | 2139 | 178 |
251635 | 251635 | 2020-06-18 | Allegheny | Pennsylvania | 42003 | 2122 | 177 |
248520 | 248520 | 2020-06-17 | Allegheny | Pennsylvania | 42003 | 2113 | 177 |
245407 | 245407 | 2020-06-16 | Allegheny | Pennsylvania | 42003 | 2113 | 177 |
242295 | 242295 | 2020-06-15 | Allegheny | Pennsylvania | 42003 | 2086 | 174 |
239186 | 239186 | 2020-06-14 | Allegheny | Pennsylvania | 42003 | 2079 | 172 |
236078 | 236078 | 2020-06-13 | Allegheny | Pennsylvania | 42003 | 2076 | 172 |
232973 | 232973 | 2020-06-12 | Allegheny | Pennsylvania | 42003 | 2065 | 171 |
229868 | 229868 | 2020-06-11 | Allegheny | Pennsylvania | 42003 | 2055 | 171 |
226764 | 226764 | 2020-06-10 | Allegheny | Pennsylvania | 42003 | 2034 | 170 |
223664 | 223664 | 2020-06-09 | Allegheny | Pennsylvania | 42003 | 2027 | 169 |
220569 | 220569 | 2020-06-08 | Allegheny | Pennsylvania | 42003 | 2008 | 169 |
217477 | 217477 | 2020-06-07 | Allegheny | Pennsylvania | 42003 | 2003 | 168 |
214387 | 214387 | 2020-06-06 | Allegheny | Pennsylvania | 42003 | 1989 | 168 |
211301 | 211301 | 2020-06-05 | Allegheny | Pennsylvania | 42003 | 1973 | 168 |
208219 | 208219 | 2020-06-04 | Allegheny | Pennsylvania | 42003 | 1965 | 166 |
205138 | 205138 | 2020-06-03 | Allegheny | Pennsylvania | 42003 | 1952 | 166 |
202061 | 202061 | 2020-06-02 | Allegheny | Pennsylvania | 42003 | 1928 | 165 |
198986 | 198986 | 2020-06-01 | Allegheny | Pennsylvania | 42003 | 1919 | 164 |
195913 | 195913 | 2020-05-31 | Allegheny | Pennsylvania | 42003 | 1911 | 163 |
192844 | 192844 | 2020-05-30 | Allegheny | Pennsylvania | 42003 | 1897 | 163 |
189779 | 189779 | 2020-05-29 | Allegheny | Pennsylvania | 42003 | 1870 | 162 |
186718 | 186718 | 2020-05-28 | Allegheny | Pennsylvania | 42003 | 1851 | 161 |
183661 | 183661 | 2020-05-27 | Allegheny | Pennsylvania | 42003 | 1828 | 160 |
180611 | 180611 | 2020-05-26 | Allegheny | Pennsylvania | 42003 | 1816 | 160 |
177568 | 177568 | 2020-05-25 | Allegheny | Pennsylvania | 42003 | 1805 | 160 |
174524 | 174524 | 2020-05-24 | Allegheny | Pennsylvania | 42003 | 1777 | 159 |
171482 | 171482 | 2020-05-23 | Allegheny | Pennsylvania | 42003 | 1753 | 158 |
168443 | 168443 | 2020-05-22 | Allegheny | Pennsylvania | 42003 | 1739 | 154 |
165407 | 165407 | 2020-05-21 | Allegheny | Pennsylvania | 42003 | 1718 | 148 |
162378 | 162378 | 2020-05-20 | Allegheny | Pennsylvania | 42003 | 1687 | 147 |
159351 | 159351 | 2020-05-19 | Allegheny | Pennsylvania | 42003 | 1658 | 145 |
156330 | 156330 | 2020-05-18 | Allegheny | Pennsylvania | 42003 | 1641 | 143 |
153313 | 153313 | 2020-05-17 | Allegheny | Pennsylvania | 42003 | 1603 | 143 |
150302 | 150302 | 2020-05-16 | Allegheny | Pennsylvania | 42003 | 1595 | 143 |
147295 | 147295 | 2020-05-15 | Allegheny | Pennsylvania | 42003 | 1582 | 141 |
144294 | 144294 | 2020-05-14 | Allegheny | Pennsylvania | 42003 | 1551 | 139 |
141298 | 141298 | 2020-05-13 | Allegheny | Pennsylvania | 42003 | 1545 | 139 |
138302 | 138302 | 2020-05-12 | Allegheny | Pennsylvania | 42003 | 1526 | 127 |
135312 | 135312 | 2020-05-11 | Allegheny | Pennsylvania | 42003 | 1511 | 123 |
132321 | 132321 | 2020-05-10 | Allegheny | Pennsylvania | 42003 | 1503 | 122 |
129332 | 129332 | 2020-05-09 | Allegheny | Pennsylvania | 42003 | 1486 | 120 |
126343 | 126343 | 2020-05-08 | Allegheny | Pennsylvania | 42003 | 1455 | 119 |
123360 | 123360 | 2020-05-07 | Allegheny | Pennsylvania | 42003 | 1439 | 117 |
120383 | 120383 | 2020-05-06 | Allegheny | Pennsylvania | 42003 | 1394 | 111 |
117421 | 117421 | 2020-05-05 | Allegheny | Pennsylvania | 42003 | 1375 | 109 |
114540 | 114540 | 2020-05-04 | Allegheny | Pennsylvania | 42003 | 1365 | 102 |
111658 | 111658 | 2020-05-03 | Allegheny | Pennsylvania | 42003 | 1345 | 102 |
108784 | 108784 | 2020-05-02 | Allegheny | Pennsylvania | 42003 | 1333 | 102 |
105917 | 105917 | 2020-05-01 | Allegheny | Pennsylvania | 42003 | 1319 | 99 |
103054 | 103054 | 2020-04-30 | Allegheny | Pennsylvania | 42003 | 1289 | 94 |
100201 | 100201 | 2020-04-29 | Allegheny | Pennsylvania | 42003 | 1273 | 86 |
97352 | 97352 | 2020-04-28 | Allegheny | Pennsylvania | 42003 | 1235 | 87 |
94513 | 94513 | 2020-04-27 | Allegheny | Pennsylvania | 42003 | 1224 | 79 |
91686 | 91686 | 2020-04-26 | Allegheny | Pennsylvania | 42003 | 1211 | 73 |
88870 | 88870 | 2020-04-25 | Allegheny | Pennsylvania | 42003 | 1198 | 73 |
86056 | 86056 | 2020-04-24 | Allegheny | Pennsylvania | 42003 | 1177 | 71 |
83252 | 83252 | 2020-04-23 | Allegheny | Pennsylvania | 42003 | 1149 | 69 |
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);