ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Philadelphia" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388227 | 388227 | 2020-07-31 | Philadelphia | Pennsylvania | 42101 | 30354 | 1690 |
385010 | 385010 | 2020-07-30 | Philadelphia | Pennsylvania | 42101 | 30213 | 1691 |
381792 | 381792 | 2020-07-29 | Philadelphia | Pennsylvania | 42101 | 30077 | 1680 |
378575 | 378575 | 2020-07-28 | Philadelphia | Pennsylvania | 42101 | 29945 | 1678 |
375359 | 375359 | 2020-07-27 | Philadelphia | Pennsylvania | 42101 | 29803 | 1678 |
372146 | 372146 | 2020-07-26 | Philadelphia | Pennsylvania | 42101 | 29303 | 1676 |
368934 | 368934 | 2020-07-25 | Philadelphia | Pennsylvania | 42101 | 29303 | 1676 |
365725 | 365725 | 2020-07-24 | Philadelphia | Pennsylvania | 42101 | 29303 | 1676 |
362519 | 362519 | 2020-07-23 | Philadelphia | Pennsylvania | 42101 | 29102 | 1675 |
359313 | 359313 | 2020-07-22 | Philadelphia | Pennsylvania | 42101 | 28874 | 1673 |
356109 | 356109 | 2020-07-21 | Philadelphia | Pennsylvania | 42101 | 28742 | 1666 |
352906 | 352906 | 2020-07-20 | Philadelphia | Pennsylvania | 42101 | 28592 | 1665 |
349703 | 349703 | 2020-07-19 | Philadelphia | Pennsylvania | 42101 | 28196 | 1665 |
346503 | 346503 | 2020-07-18 | Philadelphia | Pennsylvania | 42101 | 28196 | 1665 |
343303 | 343303 | 2020-07-17 | Philadelphia | Pennsylvania | 42101 | 28159 | 1665 |
340105 | 340105 | 2020-07-16 | Philadelphia | Pennsylvania | 42101 | 28024 | 1664 |
336908 | 336908 | 2020-07-15 | Philadelphia | Pennsylvania | 42101 | 27867 | 1653 |
333714 | 333714 | 2020-07-14 | Philadelphia | Pennsylvania | 42101 | 27723 | 1646 |
330522 | 330522 | 2020-07-13 | Philadelphia | Pennsylvania | 42101 | 27575 | 1640 |
327336 | 327336 | 2020-07-12 | Philadelphia | Pennsylvania | 42101 | 27367 | 1637 |
324151 | 324151 | 2020-07-11 | Philadelphia | Pennsylvania | 42101 | 27367 | 1636 |
320971 | 320971 | 2020-07-10 | Philadelphia | Pennsylvania | 42101 | 27341 | 1635 |
317793 | 317793 | 2020-07-09 | Philadelphia | Pennsylvania | 42101 | 27228 | 1633 |
314620 | 314620 | 2020-07-08 | Philadelphia | Pennsylvania | 42101 | 26969 | 1628 |
311448 | 311448 | 2020-07-07 | Philadelphia | Pennsylvania | 42101 | 26901 | 1621 |
308279 | 308279 | 2020-07-06 | Philadelphia | Pennsylvania | 42101 | 26810 | 1619 |
305112 | 305112 | 2020-07-05 | Philadelphia | Pennsylvania | 42101 | 26565 | 1619 |
301949 | 301949 | 2020-07-04 | Philadelphia | Pennsylvania | 42101 | 26565 | 1619 |
298785 | 298785 | 2020-07-03 | Philadelphia | Pennsylvania | 42101 | 26536 | 1619 |
295626 | 295626 | 2020-07-02 | Philadelphia | Pennsylvania | 42101 | 26400 | 1615 |
292470 | 292470 | 2020-07-01 | Philadelphia | Pennsylvania | 42101 | 26257 | 1609 |
289318 | 289318 | 2020-06-30 | Philadelphia | Pennsylvania | 42101 | 26133 | 1606 |
286167 | 286167 | 2020-06-29 | Philadelphia | Pennsylvania | 42101 | 25991 | 1595 |
283022 | 283022 | 2020-06-28 | Philadelphia | Pennsylvania | 42101 | 25693 | 1592 |
279876 | 279876 | 2020-06-27 | Philadelphia | Pennsylvania | 42101 | 25693 | 1591 |
276728 | 276728 | 2020-06-26 | Philadelphia | Pennsylvania | 42101 | 25693 | 1587 |
273581 | 273581 | 2020-06-25 | Philadelphia | Pennsylvania | 42101 | 25443 | 1583 |
270442 | 270442 | 2020-06-24 | Philadelphia | Pennsylvania | 42101 | 25443 | 1576 |
267308 | 267308 | 2020-06-23 | Philadelphia | Pennsylvania | 42101 | 25335 | 1564 |
264180 | 264180 | 2020-06-22 | Philadelphia | Pennsylvania | 42101 | 25116 | 1553 |
261052 | 261052 | 2020-06-21 | Philadelphia | Pennsylvania | 42101 | 24841 | 1553 |
257925 | 257925 | 2020-06-20 | Philadelphia | Pennsylvania | 42101 | 24841 | 1552 |
254799 | 254799 | 2020-06-19 | Philadelphia | Pennsylvania | 42101 | 24841 | 1550 |
251684 | 251684 | 2020-06-18 | Philadelphia | Pennsylvania | 42101 | 24723 | 1540 |
248569 | 248569 | 2020-06-17 | Philadelphia | Pennsylvania | 42101 | 24655 | 1528 |
245456 | 245456 | 2020-06-16 | Philadelphia | Pennsylvania | 42101 | 24591 | 1518 |
242344 | 242344 | 2020-06-15 | Philadelphia | Pennsylvania | 42101 | 24475 | 1509 |
239235 | 239235 | 2020-06-14 | Philadelphia | Pennsylvania | 42101 | 24338 | 1505 |
236127 | 236127 | 2020-06-13 | Philadelphia | Pennsylvania | 42101 | 24338 | 1502 |
233022 | 233022 | 2020-06-12 | Philadelphia | Pennsylvania | 42101 | 24228 | 1487 |
229917 | 229917 | 2020-06-11 | Philadelphia | Pennsylvania | 42101 | 24107 | 1471 |
226813 | 226813 | 2020-06-10 | Philadelphia | Pennsylvania | 42101 | 23951 | 1454 |
223713 | 223713 | 2020-06-09 | Philadelphia | Pennsylvania | 42101 | 23822 | 1436 |
220618 | 220618 | 2020-06-08 | Philadelphia | Pennsylvania | 42101 | 23691 | 1421 |
217526 | 217526 | 2020-06-07 | Philadelphia | Pennsylvania | 42101 | 23529 | 1420 |
214436 | 214436 | 2020-06-06 | Philadelphia | Pennsylvania | 42101 | 23529 | 1414 |
211350 | 211350 | 2020-06-05 | Philadelphia | Pennsylvania | 42101 | 23407 | 1411 |
208268 | 208268 | 2020-06-04 | Philadelphia | Pennsylvania | 42101 | 23281 | 1394 |
205187 | 205187 | 2020-06-03 | Philadelphia | Pennsylvania | 42101 | 23160 | 1359 |
202110 | 202110 | 2020-06-02 | Philadelphia | Pennsylvania | 42101 | 23034 | 1346 |
199035 | 199035 | 2020-06-01 | Philadelphia | Pennsylvania | 42101 | 22881 | 1320 |
195962 | 195962 | 2020-05-31 | Philadelphia | Pennsylvania | 42101 | 22629 | 1316 |
192893 | 192893 | 2020-05-30 | Philadelphia | Pennsylvania | 42101 | 22629 | 1308 |
189828 | 189828 | 2020-05-29 | Philadelphia | Pennsylvania | 42101 | 22405 | 1300 |
186767 | 186767 | 2020-05-28 | Philadelphia | Pennsylvania | 42101 | 22150 | 1282 |
183710 | 183710 | 2020-05-27 | Philadelphia | Pennsylvania | 42101 | 21975 | 1262 |
180660 | 180660 | 2020-05-26 | Philadelphia | Pennsylvania | 42101 | 21738 | 1243 |
177617 | 177617 | 2020-05-25 | Philadelphia | Pennsylvania | 42101 | 21641 | 1235 |
174573 | 174573 | 2020-05-24 | Philadelphia | Pennsylvania | 42101 | 21234 | 1233 |
171531 | 171531 | 2020-05-23 | Philadelphia | Pennsylvania | 42101 | 21234 | 1233 |
168492 | 168492 | 2020-05-22 | Philadelphia | Pennsylvania | 42101 | 21009 | 1221 |
165456 | 165456 | 2020-05-21 | Philadelphia | Pennsylvania | 42101 | 20700 | 1178 |
162427 | 162427 | 2020-05-20 | Philadelphia | Pennsylvania | 42101 | 20359 | 1152 |
159400 | 159400 | 2020-05-19 | Philadelphia | Pennsylvania | 42101 | 20129 | 1109 |
156379 | 156379 | 2020-05-18 | Philadelphia | Pennsylvania | 42101 | 19950 | 1080 |
153362 | 153362 | 2020-05-17 | Philadelphia | Pennsylvania | 42101 | 19606 | 1031 |
150351 | 150351 | 2020-05-16 | Philadelphia | Pennsylvania | 42101 | 19606 | 1031 |
147344 | 147344 | 2020-05-15 | Philadelphia | Pennsylvania | 42101 | 19349 | 1021 |
144343 | 144343 | 2020-05-14 | Philadelphia | Pennsylvania | 42101 | 19093 | 1008 |
141347 | 141347 | 2020-05-13 | Philadelphia | Pennsylvania | 42101 | 18779 | 986 |
138351 | 138351 | 2020-05-12 | Philadelphia | Pennsylvania | 42101 | 18537 | 908 |
135361 | 135361 | 2020-05-11 | Philadelphia | Pennsylvania | 42101 | 18313 | 893 |
132370 | 132370 | 2020-05-10 | Philadelphia | Pennsylvania | 42101 | 18211 | 894 |
129381 | 129381 | 2020-05-09 | Philadelphia | Pennsylvania | 42101 | 17881 | 891 |
126392 | 126392 | 2020-05-08 | Philadelphia | Pennsylvania | 42101 | 17517 | 875 |
123409 | 123409 | 2020-05-07 | Philadelphia | Pennsylvania | 42101 | 17047 | 816 |
120432 | 120432 | 2020-05-06 | Philadelphia | Pennsylvania | 42101 | 16697 | 803 |
117470 | 117470 | 2020-05-05 | Philadelphia | Pennsylvania | 42101 | 16410 | 743 |
114589 | 114589 | 2020-05-04 | Philadelphia | Pennsylvania | 42101 | 16040 | 726 |
111707 | 111707 | 2020-05-03 | Philadelphia | Pennsylvania | 42101 | 15854 | 727 |
108833 | 108833 | 2020-05-02 | Philadelphia | Pennsylvania | 42101 | 15527 | 705 |
105966 | 105966 | 2020-05-01 | Philadelphia | Pennsylvania | 42101 | 15137 | 638 |
103103 | 103103 | 2020-04-30 | Philadelphia | Pennsylvania | 42101 | 14468 | 607 |
100250 | 100250 | 2020-04-29 | Philadelphia | Pennsylvania | 42101 | 13445 | 516 |
97401 | 97401 | 2020-04-28 | Philadelphia | Pennsylvania | 42101 | 13445 | 516 |
94562 | 94562 | 2020-04-27 | Philadelphia | Pennsylvania | 42101 | 12868 | 484 |
91735 | 91735 | 2020-04-26 | Philadelphia | Pennsylvania | 42101 | 12566 | 472 |
88919 | 88919 | 2020-04-25 | Philadelphia | Pennsylvania | 42101 | 12329 | 466 |
86105 | 86105 | 2020-04-24 | Philadelphia | Pennsylvania | 42101 | 11877 | 449 |
83301 | 83301 | 2020-04-23 | Philadelphia | Pennsylvania | 42101 | 11226 | 443 |
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);