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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
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);