ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,029 rows where state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- Pennsylvania · 1,029 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
57224 | 57224 | 2022-12-29 | Pennsylvania | 42 | 3416142 | 48972 |
57168 | 57168 | 2022-12-28 | Pennsylvania | 42 | 3416142 | 48972 |
57112 | 57112 | 2022-12-27 | Pennsylvania | 42 | 3403953 | 48881 |
57056 | 57056 | 2022-12-26 | Pennsylvania | 42 | 3403953 | 48881 |
57000 | 57000 | 2022-12-25 | Pennsylvania | 42 | 3403177 | 48881 |
56944 | 56944 | 2022-12-24 | Pennsylvania | 42 | 3403177 | 48881 |
56888 | 56888 | 2022-12-23 | Pennsylvania | 42 | 3403177 | 48881 |
56832 | 56832 | 2022-12-22 | Pennsylvania | 42 | 3403177 | 48881 |
56776 | 56776 | 2022-12-21 | Pennsylvania | 42 | 3403177 | 48881 |
56720 | 56720 | 2022-12-20 | Pennsylvania | 42 | 3389458 | 48746 |
56664 | 56664 | 2022-12-19 | Pennsylvania | 42 | 3389458 | 48746 |
56608 | 56608 | 2022-12-18 | Pennsylvania | 42 | 3388571 | 48746 |
56552 | 56552 | 2022-12-17 | Pennsylvania | 42 | 3388571 | 48746 |
56496 | 56496 | 2022-12-16 | Pennsylvania | 42 | 3388571 | 48746 |
56440 | 56440 | 2022-12-15 | Pennsylvania | 42 | 3388571 | 48746 |
56384 | 56384 | 2022-12-14 | Pennsylvania | 42 | 3388571 | 48746 |
56328 | 56328 | 2022-12-13 | Pennsylvania | 42 | 3375513 | 48613 |
56272 | 56272 | 2022-12-12 | Pennsylvania | 42 | 3375513 | 48613 |
56216 | 56216 | 2022-12-11 | Pennsylvania | 42 | 3374733 | 48613 |
56160 | 56160 | 2022-12-10 | Pennsylvania | 42 | 3374733 | 48613 |
56104 | 56104 | 2022-12-09 | Pennsylvania | 42 | 3374733 | 48613 |
56048 | 56048 | 2022-12-08 | Pennsylvania | 42 | 3374733 | 48613 |
55992 | 55992 | 2022-12-07 | Pennsylvania | 42 | 3374733 | 48606 |
55936 | 55936 | 2022-12-06 | Pennsylvania | 42 | 3361643 | 48467 |
55880 | 55880 | 2022-12-05 | Pennsylvania | 42 | 3361643 | 48467 |
55824 | 55824 | 2022-12-04 | Pennsylvania | 42 | 3360797 | 48467 |
55768 | 55768 | 2022-12-03 | Pennsylvania | 42 | 3360797 | 48467 |
55712 | 55712 | 2022-12-02 | Pennsylvania | 42 | 3360797 | 48467 |
55656 | 55656 | 2022-12-01 | Pennsylvania | 42 | 3360797 | 48467 |
55600 | 55600 | 2022-11-30 | Pennsylvania | 42 | 3360797 | 48467 |
55544 | 55544 | 2022-11-29 | Pennsylvania | 42 | 3350584 | 48355 |
55488 | 55488 | 2022-11-28 | Pennsylvania | 42 | 3350584 | 48355 |
55432 | 55432 | 2022-11-27 | Pennsylvania | 42 | 3350067 | 48355 |
55376 | 55376 | 2022-11-26 | Pennsylvania | 42 | 3350067 | 48355 |
55320 | 55320 | 2022-11-25 | Pennsylvania | 42 | 3350067 | 48355 |
55264 | 55264 | 2022-11-24 | Pennsylvania | 42 | 3350067 | 48355 |
55208 | 55208 | 2022-11-23 | Pennsylvania | 42 | 3350067 | 48355 |
55152 | 55152 | 2022-11-22 | Pennsylvania | 42 | 3340506 | 48212 |
55096 | 55096 | 2022-11-21 | Pennsylvania | 42 | 3340506 | 48212 |
55040 | 55040 | 2022-11-20 | Pennsylvania | 42 | 3340015 | 48212 |
54984 | 54984 | 2022-11-19 | Pennsylvania | 42 | 3340015 | 48212 |
54928 | 54928 | 2022-11-18 | Pennsylvania | 42 | 3340015 | 48212 |
54872 | 54872 | 2022-11-17 | Pennsylvania | 42 | 3340015 | 48212 |
54816 | 54816 | 2022-11-16 | Pennsylvania | 42 | 3340015 | 48212 |
54760 | 54760 | 2022-11-15 | Pennsylvania | 42 | 3330515 | 48081 |
54704 | 54704 | 2022-11-14 | Pennsylvania | 42 | 3330515 | 48081 |
54648 | 54648 | 2022-11-13 | Pennsylvania | 42 | 3330062 | 48081 |
54592 | 54592 | 2022-11-12 | Pennsylvania | 42 | 3330062 | 48081 |
54536 | 54536 | 2022-11-11 | Pennsylvania | 42 | 3330062 | 48081 |
54480 | 54480 | 2022-11-10 | Pennsylvania | 42 | 3330062 | 47994 |
54424 | 54424 | 2022-11-09 | Pennsylvania | 42 | 3330062 | 47994 |
54368 | 54368 | 2022-11-08 | Pennsylvania | 42 | 3318490 | 47840 |
54312 | 54312 | 2022-11-07 | Pennsylvania | 42 | 3318490 | 47840 |
54256 | 54256 | 2022-11-06 | Pennsylvania | 42 | 3317854 | 47840 |
54200 | 54200 | 2022-11-05 | Pennsylvania | 42 | 3317854 | 47840 |
54144 | 54144 | 2022-11-04 | Pennsylvania | 42 | 3317854 | 47840 |
54088 | 54088 | 2022-11-03 | Pennsylvania | 42 | 3317854 | 47840 |
54032 | 54032 | 2022-11-02 | Pennsylvania | 42 | 3317854 | 47840 |
53976 | 53976 | 2022-11-01 | Pennsylvania | 42 | 3305389 | 47705 |
53920 | 53920 | 2022-10-31 | Pennsylvania | 42 | 3305389 | 47705 |
53864 | 53864 | 2022-10-30 | Pennsylvania | 42 | 3304816 | 47705 |
53808 | 53808 | 2022-10-29 | Pennsylvania | 42 | 3304816 | 47705 |
53752 | 53752 | 2022-10-28 | Pennsylvania | 42 | 3304816 | 47705 |
53696 | 53696 | 2022-10-27 | Pennsylvania | 42 | 3304816 | 47705 |
53640 | 53640 | 2022-10-26 | Pennsylvania | 42 | 3304816 | 47705 |
53584 | 53584 | 2022-10-25 | Pennsylvania | 42 | 3293037 | 47582 |
53528 | 53528 | 2022-10-24 | Pennsylvania | 42 | 3293037 | 47582 |
53472 | 53472 | 2022-10-23 | Pennsylvania | 42 | 3291589 | 47582 |
53416 | 53416 | 2022-10-22 | Pennsylvania | 42 | 3291589 | 47582 |
53360 | 53360 | 2022-10-21 | Pennsylvania | 42 | 3291589 | 47582 |
53304 | 53304 | 2022-10-20 | Pennsylvania | 42 | 3291589 | 47582 |
53248 | 53248 | 2022-10-19 | Pennsylvania | 42 | 3291589 | 47582 |
53192 | 53192 | 2022-10-18 | Pennsylvania | 42 | 3280746 | 47442 |
53136 | 53136 | 2022-10-17 | Pennsylvania | 42 | 3280746 | 47442 |
53080 | 53080 | 2022-10-16 | Pennsylvania | 42 | 3280190 | 47442 |
53024 | 53024 | 2022-10-15 | Pennsylvania | 42 | 3280190 | 47442 |
52968 | 52968 | 2022-10-14 | Pennsylvania | 42 | 3280190 | 47442 |
52912 | 52912 | 2022-10-13 | Pennsylvania | 42 | 3280190 | 47442 |
52856 | 52856 | 2022-10-12 | Pennsylvania | 42 | 3280190 | 47442 |
52800 | 52800 | 2022-10-11 | Pennsylvania | 42 | 3267569 | 47323 |
52744 | 52744 | 2022-10-10 | Pennsylvania | 42 | 3267569 | 47323 |
52688 | 52688 | 2022-10-09 | Pennsylvania | 42 | 3266934 | 47323 |
52632 | 52632 | 2022-10-08 | Pennsylvania | 42 | 3266934 | 47323 |
52576 | 52576 | 2022-10-07 | Pennsylvania | 42 | 3266934 | 47323 |
52520 | 52520 | 2022-10-06 | Pennsylvania | 42 | 3266934 | 47323 |
52464 | 52464 | 2022-10-05 | Pennsylvania | 42 | 3266934 | 47323 |
52408 | 52408 | 2022-10-04 | Pennsylvania | 42 | 3254818 | 47213 |
52352 | 52352 | 2022-10-03 | Pennsylvania | 42 | 3254818 | 47213 |
52296 | 52296 | 2022-10-02 | Pennsylvania | 42 | 3254503 | 47213 |
52240 | 52240 | 2022-10-01 | Pennsylvania | 42 | 3254503 | 47213 |
52184 | 52184 | 2022-09-30 | Pennsylvania | 42 | 3254503 | 47213 |
52128 | 52128 | 2022-09-29 | Pennsylvania | 42 | 3254503 | 47213 |
52072 | 52072 | 2022-09-28 | Pennsylvania | 42 | 3254503 | 47213 |
52016 | 52016 | 2022-09-27 | Pennsylvania | 42 | 3240293 | 47098 |
51960 | 51960 | 2022-09-26 | Pennsylvania | 42 | 3240293 | 47098 |
51904 | 51904 | 2022-09-25 | Pennsylvania | 42 | 3239298 | 47098 |
51848 | 51848 | 2022-09-24 | Pennsylvania | 42 | 3239298 | 47098 |
51792 | 51792 | 2022-09-23 | Pennsylvania | 42 | 3239298 | 47098 |
51736 | 51736 | 2022-09-22 | Pennsylvania | 42 | 3239298 | 47098 |
51680 | 51680 | 2022-09-21 | Pennsylvania | 42 | 3239298 | 47098 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );