ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Philadelphia" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 578 ✖
- 154800 7
- 155134 7
- 152956 5
- 38767 4
- 89887 4
- 93885 4
- 102837 4
- 114308 4
- 117642 4
- 130974 4
- 149172 4
- 150796 4
- 151949 4
- 153521 4
- 153888 4
- 154185 4
- 154473 4
- 154993 4
- 155859 4
- 156688 4
- 1 3
- 24841 3
- 25693 3
- 29303 3
- 30354 3
- 31120 3
- 34445 3
- 35583 3
- 36187 3
- 37502 3
- 40179 3
- 41972 3
- 44505 3
- 47675 3
- 52723 3
- 59081 3
- 65484 3
- 72314 3
- 79646 3
- 85733 3
- 98541 3
- 106132 3
- 109231 3
- 111750 3
- 116242 3
- 119874 3
- 121881 3
- 124489 3
- 127770 3
- 135632 3
- 140229 3
- 144048 3
- 147125 3
- 148031 3
- 149953 3
- 151454 3
- 152530 3
- 153724 3
- 154094 3
- 154286 3
- 154545 3
- 155608 3
- 156240 3
- 158129 3
- 159822 3
- 162279 3
- 304285 3
- 305124 3
- 306006 3
- 308108 3
- 315614 3
- 8 2
- 13445 2
- 19606 2
- 21234 2
- 22629 2
- 23529 2
- 24338 2
- 25443 2
- 26565 2
- 27367 2
- 28196 2
- 32186 2
- 32936 2
- 33607 2
- 34742 2
- 35094 2
- 50354 2
- 63862 2
- 153308 2
- 157274 2
- 165476 2
- 166713 2
- 171356 2
- 173451 2
- 175486 2
- 177651 2
- 179451 2
- 182323 2
- 187219 2
- 189142 2
- 190199 2
- 191061 2
- 193836 2
- 203281 2
- 208609 2
- 228936 2
- 256404 2
- 298723 2
- 302595 2
- 307048 2
- 307610 2
- 307693 2
- 309301 2
- 310563 2
- 312583 2
- 313767 2
- 316363 2
- 317808 2
- 3 1
- 4 1
- 10 1
- 17 1
- 33 1
- 42 1
- 69 1
- 91 1
- 128 1
- 177 1
- 257 1
- 402 1
- 530 1
- 709 1
- 865 1
- 1072 1
- 1315 1
- 1478 1
- 1852 1
- 2284 1
- 2610 1
- 3135 1
- 3611 1
- 4012 1
- 4456 1
- 5029 1
- 5521 1
- 6022 1
- 6352 1
- 6810 1
- 7130 1
- 7441 1
- 8045 1
- 8563 1
- 9014 1
- 9214 1
- 9553 1
- 10028 1
- 10643 1
- 11226 1
- 11877 1
- 12329 1
- 12566 1
- 12868 1
- 14468 1
- 15137 1
- 15527 1
- 15854 1
- 16040 1
- 16410 1
- 16697 1
- 17047 1
- 17517 1
- 17881 1
- 18211 1
- 18313 1
- 18537 1
- 18779 1
- 19093 1
- 19349 1
- 19950 1
- 20129 1
- 20359 1
- 20700 1
- 21009 1
- 21641 1
- 21738 1
- 21975 1
- 22150 1
- 22405 1
- 22881 1
- 23034 1
- 23160 1
- 23281 1
- 23407 1
- 23691 1
- 23822 1
- 23951 1
- 24107 1
- 24228 1
- 24475 1
- 24591 1
- 24655 1
- 24723 1
- 25116 1
- 25335 1
- 25991 1
- 26133 1
- 26257 1
- 26400 1
- 26536 1
- 26810 1
- 26901 1
- 26969 1
- 27228 1
- 27341 1
- 27575 1
- 27723 1
- 27867 1
- 28024 1
- 28159 1
- 28592 1
- 28742 1
- 28874 1
- 29102 1
- 29803 1
- 29945 1
- 30077 1
- 30213 1
- 30665 1
- 30771 1
- 30877 1
- 30986 1
- 31448 1
- 31584 1
- 31725 1
- 31910 1
- 32057 1
- 32348 1
- 32432 1
- 32569 1
- 32674 1
- 32791 1
- 33054 1
- 33139 1
- 33255 1
- 33343 1
- 33495 1
- 33778 1
- 33909 1
- 34144 1
- 34311 1
- 34699 1
- 34887 1
- 34986 1
- 35257 1
- 35344 1
- 35441 1
- 35529 1
- 35825 1
- 35901 1
- 36004 1
- 36112 1
- 36452 1
- 37067 1
- 37226 1
- 37361 1
- 37807 1
- 38083 1
- 38264 1
- 38515 1
- 39413 1
- 39691 1
- 39870 1
- 40803 1
- 41094 1
- 41323 1
- 41561 1
- 43003 1
- 43365 1
- 43740 1
- 44139 1
- 45451 1
- 46093 1
- 46489 1
- 46917 1
- 49456 1
- 51513 1
- 55302 1
- 56372 1
- 57201 1
- 58012 1
- 61498 1
- 62620 1
- 67283 1
- 67943 1
- 69630 1
- 70476 1
- 75073 1
- 76589 1
- 77601 1
- 78565 1
- 81779 1
- 83113 1
- 84061 1
- 85033 1
- 87395 1
- 88420 1
- 89164 1
- 91429 1
- 92354 1
- 92706 1
- 95503 1
- 96419 1
- 97099 1
- 97891 1
- 100092 1
- 100910 1
- 101582 1
- 102168 1
- 104648 1
- 105177 1
- 105713 1
- 107177 1
- 107863 1
- 108222 1
- 108760 1
- 110272 1
- 110793 1
- 111098 1
- 111411 1
- 112652 1
- 113224 1
- 113519 1
- 113878 1
- 115018 1
- 115560 1
- 115944 1
- 116726 1
- 117022 1
- 117318 1
- 118594 1
- 118906 1
- 119245 1
- 119562 1
- 120539 1
- 120966 1
- 121242 1
- 121583 1
- 122598 1
- 122971 1
- 123531 1
- 123959 1
- 125428 1
- 126122 1
- 126609 1
- 127137 1
- 129077 1
- 129790 1
- 130405 1
- 132575 1
- 133485 1
- 134356 1
- 134945 1
- 137201 1
- 137331 1
- 138643 1
- 139486 1
- 141551 1
- 142297 1
- 142980 1
- 143574 1
- 145181 1
- 145789 1
- 146255 1
- 146762 1
- 157749 1
- 157951 1
- 158648 1
- 158877 1
- 159070 1
- 159434 1
- 160366 1
- 160676 1
- 161040 1
- 161863 1
- 163018 1
- 163322 1
- 164044 1
- 164447 1
- 164729 1
- 165127 1
- 165761 1
- 165992 1
- 167348 1
- 167598 1
- 167757 1
- 167965 1
- 168121 1
- 168223 1
- 168549 1
- 168902 1
- 169211 1
- 169382 1
- 169565 1
- 169984 1
- 170332 1
- 170703 1
- 171029 1
- 171729 1
- 172132 1
- 172505 1
- 172892 1
- 173214 1
- 173871 1
- 174141 1
- 174478 1
- 174860 1
- 175217 1
- 175804 1
- 176202 1
- 176497 1
- 176753 1
- 177237 1
- 177453 1
- 177989 1
- 178440 1
- 178723 1
- 179117 1
- 179899 1
- 180089 1
- 180356 1
- 180602 1
- 180910 1
- 181075 1
- 181187 1
- 181389 1
- 181586 1
- 181782 1
- 182022 1
- 182196 1
- 182708 1
- 182856 1
- 183119 1
- 183308 1
- 183605 1
- 183784 1
- 183863 1
- 184083 1
- 185978 1
- 186154 1
- 186491 1
- 186842 1
- 187044 1
- 187752 1
- 188101 1
- 188416 1
- 188736 1
- 188996 1
- 189812 1
- 190694 1
- 191401 1
- 191846 1
- 192262 1
- 192726 1
- 193338 1
- 194343 1
- 195633 1
- 195644 1
- 197431 1
- 197981 1
- 198751 1
- 199077 1
- 199369 1
- 200129 1
- 200668 1
- 201709 1
- 202708 1
- 204818 1
- 205662 1
- 207061 1
- 208610 1
- 214540 1
- 217278 1
- 220803 1
- 224017 1
- 225031 1
- 235342 1
- 239880 1
- 243701 1
- 249183 1
- 250195 1
- 261739 1
- 267300 1
- 271062 1
- 274256 1
- 276641 1
- 277656 1
- 277659 1
- 280648 1
- 283652 1
- 285140 1
- 286526 1
- 287817 1
- 288836 1
- 290207 1
- 290754 1
- 291747 1
- 292767 1
- 293487 1
- 294277 1
- 295307 1
- 295837 1
- 296109 1
- 296373 1
- 296868 1
- 297384 1
- 298012 1
- 298694 1
- 298975 1
- 299711 1
- 299963 1
- 300509 1
- 300817 1
- 301219 1
- 301283 1
- 301381 1
- 301765 1
- 301945 1
- 302227 1
- 302482 1
- 302632 1
- 304001 1
- 304068 1
- 304568 1
- 304700 1
- 304750 1
- 304910 1
- 305303 1
- 305734 1
- 305790 1
- 305927 1
- 306134 1
- 306251 1
- 306606 1
- 306682 1
- 306860 1
- 306978 1
- 307142 1
- 307160 1
- 307297 1
- 307412 1
- 307531 1
- 307948 1
- 308325 1
- 308488 1
- 308578 1
- 308812 1
- 309120 1
- 309304 1
- 309642 1
- 309812 1
- 310220 1
- 310562 1
- 310971 1
- 311502 1
- 311553 1
- 311825 1
- 311951 1
- 312345 1
- 312757 1
- 312875 1
- 313299 1
- 313471 1
- 314091 1
- 314253 1
- 314469 1
- 315226 1
- 317330 1
state 1
- Pennsylvania 795
fips 1
- 42101 795
county 1
- Philadelphia · 795 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1118 | 1118 | 2020-03-10 | Philadelphia | Pennsylvania | 42101 | 1 | 0 |
1312 | 1312 | 2020-03-11 | Philadelphia | Pennsylvania | 42101 | 1 | 0 |
1557 | 1557 | 2020-03-12 | Philadelphia | Pennsylvania | 42101 | 1 | 0 |
1855 | 1855 | 2020-03-13 | Philadelphia | Pennsylvania | 42101 | 3 | 0 |
2217 | 2217 | 2020-03-14 | Philadelphia | Pennsylvania | 42101 | 4 | 0 |
2639 | 2639 | 2020-03-15 | Philadelphia | Pennsylvania | 42101 | 8 | 0 |
3104 | 3104 | 2020-03-16 | Philadelphia | Pennsylvania | 42101 | 8 | 0 |
3634 | 3634 | 2020-03-17 | Philadelphia | Pennsylvania | 42101 | 10 | 0 |
4252 | 4252 | 2020-03-18 | Philadelphia | Pennsylvania | 42101 | 17 | 0 |
4993 | 4993 | 2020-03-19 | Philadelphia | Pennsylvania | 42101 | 33 | 0 |
5865 | 5865 | 2020-03-20 | Philadelphia | Pennsylvania | 42101 | 42 | 0 |
6869 | 6869 | 2020-03-21 | Philadelphia | Pennsylvania | 42101 | 69 | 0 |
7988 | 7988 | 2020-03-22 | Philadelphia | Pennsylvania | 42101 | 91 | 0 |
9199 | 9199 | 2020-03-23 | Philadelphia | Pennsylvania | 42101 | 128 | 0 |
10523 | 10523 | 2020-03-24 | Philadelphia | Pennsylvania | 42101 | 177 | 0 |
11988 | 11988 | 2020-03-25 | Philadelphia | Pennsylvania | 42101 | 257 | 1 |
13609 | 13609 | 2020-03-26 | Philadelphia | Pennsylvania | 42101 | 402 | 1 |
15356 | 15356 | 2020-03-27 | Philadelphia | Pennsylvania | 42101 | 530 | 2 |
17208 | 17208 | 2020-03-28 | Philadelphia | Pennsylvania | 42101 | 709 | 5 |
19147 | 19147 | 2020-03-29 | Philadelphia | Pennsylvania | 42101 | 865 | 5 |
21197 | 21197 | 2020-03-30 | Philadelphia | Pennsylvania | 42101 | 1072 | 7 |
23333 | 23333 | 2020-03-31 | Philadelphia | Pennsylvania | 42101 | 1315 | 14 |
25531 | 25531 | 2020-04-01 | Philadelphia | Pennsylvania | 42101 | 1478 | 14 |
27804 | 27804 | 2020-04-02 | Philadelphia | Pennsylvania | 42101 | 1852 | 14 |
30138 | 30138 | 2020-04-03 | Philadelphia | Pennsylvania | 42101 | 2284 | 14 |
32528 | 32528 | 2020-04-04 | Philadelphia | Pennsylvania | 42101 | 2610 | 24 |
34964 | 34964 | 2020-04-05 | Philadelphia | Pennsylvania | 42101 | 3135 | 28 |
37439 | 37439 | 2020-04-06 | Philadelphia | Pennsylvania | 42101 | 3611 | 28 |
39962 | 39962 | 2020-04-07 | Philadelphia | Pennsylvania | 42101 | 4012 | 58 |
42522 | 42522 | 2020-04-08 | Philadelphia | Pennsylvania | 42101 | 4456 | 86 |
45108 | 45108 | 2020-04-09 | Philadelphia | Pennsylvania | 42101 | 5029 | 86 |
47725 | 47725 | 2020-04-10 | Philadelphia | Pennsylvania | 42101 | 5521 | 110 |
50382 | 50382 | 2020-04-11 | Philadelphia | Pennsylvania | 42101 | 6022 | 130 |
53055 | 53055 | 2020-04-12 | Philadelphia | Pennsylvania | 42101 | 6352 | 128 |
55740 | 55740 | 2020-04-13 | Philadelphia | Pennsylvania | 42101 | 6810 | 127 |
58443 | 58443 | 2020-04-14 | Philadelphia | Pennsylvania | 42101 | 7130 | 206 |
61158 | 61158 | 2020-04-15 | Philadelphia | Pennsylvania | 42101 | 7441 | 222 |
63884 | 63884 | 2020-04-16 | Philadelphia | Pennsylvania | 42101 | 8045 | 264 |
66630 | 66630 | 2020-04-17 | Philadelphia | Pennsylvania | 42101 | 8563 | 298 |
69388 | 69388 | 2020-04-18 | Philadelphia | Pennsylvania | 42101 | 9014 | 342 |
72155 | 72155 | 2020-04-19 | Philadelphia | Pennsylvania | 42101 | 9214 | 365 |
74930 | 74930 | 2020-04-20 | Philadelphia | Pennsylvania | 42101 | 9553 | 370 |
77712 | 77712 | 2020-04-21 | Philadelphia | Pennsylvania | 42101 | 10028 | 394 |
80502 | 80502 | 2020-04-22 | Philadelphia | Pennsylvania | 42101 | 10643 | 419 |
83301 | 83301 | 2020-04-23 | Philadelphia | Pennsylvania | 42101 | 11226 | 443 |
86105 | 86105 | 2020-04-24 | Philadelphia | Pennsylvania | 42101 | 11877 | 449 |
88919 | 88919 | 2020-04-25 | Philadelphia | Pennsylvania | 42101 | 12329 | 466 |
91735 | 91735 | 2020-04-26 | Philadelphia | Pennsylvania | 42101 | 12566 | 472 |
94562 | 94562 | 2020-04-27 | Philadelphia | Pennsylvania | 42101 | 12868 | 484 |
97401 | 97401 | 2020-04-28 | Philadelphia | Pennsylvania | 42101 | 13445 | 516 |
100250 | 100250 | 2020-04-29 | Philadelphia | Pennsylvania | 42101 | 13445 | 516 |
103103 | 103103 | 2020-04-30 | Philadelphia | Pennsylvania | 42101 | 14468 | 607 |
105966 | 105966 | 2020-05-01 | Philadelphia | Pennsylvania | 42101 | 15137 | 638 |
108833 | 108833 | 2020-05-02 | Philadelphia | Pennsylvania | 42101 | 15527 | 705 |
111707 | 111707 | 2020-05-03 | Philadelphia | Pennsylvania | 42101 | 15854 | 727 |
114589 | 114589 | 2020-05-04 | Philadelphia | Pennsylvania | 42101 | 16040 | 726 |
117470 | 117470 | 2020-05-05 | Philadelphia | Pennsylvania | 42101 | 16410 | 743 |
120432 | 120432 | 2020-05-06 | Philadelphia | Pennsylvania | 42101 | 16697 | 803 |
123409 | 123409 | 2020-05-07 | Philadelphia | Pennsylvania | 42101 | 17047 | 816 |
126392 | 126392 | 2020-05-08 | Philadelphia | Pennsylvania | 42101 | 17517 | 875 |
129381 | 129381 | 2020-05-09 | Philadelphia | Pennsylvania | 42101 | 17881 | 891 |
132370 | 132370 | 2020-05-10 | Philadelphia | Pennsylvania | 42101 | 18211 | 894 |
135361 | 135361 | 2020-05-11 | Philadelphia | Pennsylvania | 42101 | 18313 | 893 |
138351 | 138351 | 2020-05-12 | Philadelphia | Pennsylvania | 42101 | 18537 | 908 |
141347 | 141347 | 2020-05-13 | Philadelphia | Pennsylvania | 42101 | 18779 | 986 |
144343 | 144343 | 2020-05-14 | Philadelphia | Pennsylvania | 42101 | 19093 | 1008 |
147344 | 147344 | 2020-05-15 | Philadelphia | Pennsylvania | 42101 | 19349 | 1021 |
150351 | 150351 | 2020-05-16 | Philadelphia | Pennsylvania | 42101 | 19606 | 1031 |
153362 | 153362 | 2020-05-17 | Philadelphia | Pennsylvania | 42101 | 19606 | 1031 |
156379 | 156379 | 2020-05-18 | Philadelphia | Pennsylvania | 42101 | 19950 | 1080 |
159400 | 159400 | 2020-05-19 | Philadelphia | Pennsylvania | 42101 | 20129 | 1109 |
162427 | 162427 | 2020-05-20 | Philadelphia | Pennsylvania | 42101 | 20359 | 1152 |
165456 | 165456 | 2020-05-21 | Philadelphia | Pennsylvania | 42101 | 20700 | 1178 |
168492 | 168492 | 2020-05-22 | Philadelphia | Pennsylvania | 42101 | 21009 | 1221 |
171531 | 171531 | 2020-05-23 | Philadelphia | Pennsylvania | 42101 | 21234 | 1233 |
174573 | 174573 | 2020-05-24 | Philadelphia | Pennsylvania | 42101 | 21234 | 1233 |
177617 | 177617 | 2020-05-25 | Philadelphia | Pennsylvania | 42101 | 21641 | 1235 |
180660 | 180660 | 2020-05-26 | Philadelphia | Pennsylvania | 42101 | 21738 | 1243 |
183710 | 183710 | 2020-05-27 | Philadelphia | Pennsylvania | 42101 | 21975 | 1262 |
186767 | 186767 | 2020-05-28 | Philadelphia | Pennsylvania | 42101 | 22150 | 1282 |
189828 | 189828 | 2020-05-29 | Philadelphia | Pennsylvania | 42101 | 22405 | 1300 |
192893 | 192893 | 2020-05-30 | Philadelphia | Pennsylvania | 42101 | 22629 | 1308 |
195962 | 195962 | 2020-05-31 | Philadelphia | Pennsylvania | 42101 | 22629 | 1316 |
199035 | 199035 | 2020-06-01 | Philadelphia | Pennsylvania | 42101 | 22881 | 1320 |
202110 | 202110 | 2020-06-02 | Philadelphia | Pennsylvania | 42101 | 23034 | 1346 |
205187 | 205187 | 2020-06-03 | Philadelphia | Pennsylvania | 42101 | 23160 | 1359 |
208268 | 208268 | 2020-06-04 | Philadelphia | Pennsylvania | 42101 | 23281 | 1394 |
211350 | 211350 | 2020-06-05 | Philadelphia | Pennsylvania | 42101 | 23407 | 1411 |
214436 | 214436 | 2020-06-06 | Philadelphia | Pennsylvania | 42101 | 23529 | 1414 |
217526 | 217526 | 2020-06-07 | Philadelphia | Pennsylvania | 42101 | 23529 | 1420 |
220618 | 220618 | 2020-06-08 | Philadelphia | Pennsylvania | 42101 | 23691 | 1421 |
223713 | 223713 | 2020-06-09 | Philadelphia | Pennsylvania | 42101 | 23822 | 1436 |
226813 | 226813 | 2020-06-10 | Philadelphia | Pennsylvania | 42101 | 23951 | 1454 |
229917 | 229917 | 2020-06-11 | Philadelphia | Pennsylvania | 42101 | 24107 | 1471 |
233022 | 233022 | 2020-06-12 | Philadelphia | Pennsylvania | 42101 | 24228 | 1487 |
236127 | 236127 | 2020-06-13 | Philadelphia | Pennsylvania | 42101 | 24338 | 1502 |
239235 | 239235 | 2020-06-14 | Philadelphia | Pennsylvania | 42101 | 24338 | 1505 |
242344 | 242344 | 2020-06-15 | Philadelphia | Pennsylvania | 42101 | 24475 | 1509 |
245456 | 245456 | 2020-06-16 | Philadelphia | Pennsylvania | 42101 | 24591 | 1518 |
248569 | 248569 | 2020-06-17 | Philadelphia | Pennsylvania | 42101 | 24655 | 1528 |
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);