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)
state 1
- Pennsylvania · 894 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
49664 | 49664 | 2022-08-16 | Pennsylvania | 42 | 3141175 | 46422 |
49608 | 49608 | 2022-08-15 | Pennsylvania | 42 | 3134837 | 46422 |
49552 | 49552 | 2022-08-14 | Pennsylvania | 42 | 3131000 | 46398 |
49496 | 49496 | 2022-08-13 | Pennsylvania | 42 | 3131000 | 46398 |
49440 | 49440 | 2022-08-12 | Pennsylvania | 42 | 3131000 | 46398 |
49384 | 49384 | 2022-08-11 | Pennsylvania | 42 | 3125967 | 46374 |
49328 | 49328 | 2022-08-10 | Pennsylvania | 42 | 3125967 | 46374 |
49272 | 49272 | 2022-08-09 | Pennsylvania | 42 | 3119129 | 46315 |
49216 | 49216 | 2022-08-08 | Pennsylvania | 42 | 3112328 | 46298 |
49160 | 49160 | 2022-08-07 | Pennsylvania | 42 | 3108489 | 46279 |
49104 | 49104 | 2022-08-06 | Pennsylvania | 42 | 3108489 | 46279 |
49048 | 49048 | 2022-08-05 | Pennsylvania | 42 | 3108489 | 46279 |
48992 | 48992 | 2022-08-04 | Pennsylvania | 42 | 3105341 | 46261 |
48936 | 48936 | 2022-08-03 | Pennsylvania | 42 | 3105341 | 46261 |
48880 | 48880 | 2022-08-02 | Pennsylvania | 42 | 3090149 | 46205 |
48824 | 48824 | 2022-08-01 | Pennsylvania | 42 | 3090149 | 46205 |
48768 | 48768 | 2022-07-31 | Pennsylvania | 42 | 3083595 | 46185 |
48712 | 48712 | 2022-07-30 | Pennsylvania | 42 | 3083595 | 46185 |
48656 | 48656 | 2022-07-29 | Pennsylvania | 42 | 3083595 | 46185 |
48600 | 48600 | 2022-07-28 | Pennsylvania | 42 | 3080593 | 46164 |
48544 | 48544 | 2022-07-27 | Pennsylvania | 42 | 3080593 | 46164 |
48488 | 48488 | 2022-07-26 | Pennsylvania | 42 | 3072445 | 46118 |
48432 | 48432 | 2022-07-25 | Pennsylvania | 42 | 3065454 | 46087 |
48376 | 48376 | 2022-07-24 | Pennsylvania | 42 | 3061287 | 46062 |
48320 | 48320 | 2022-07-23 | Pennsylvania | 42 | 3061287 | 46062 |
48264 | 48264 | 2022-07-22 | Pennsylvania | 42 | 3061287 | 46062 |
48208 | 48208 | 2022-07-21 | Pennsylvania | 42 | 3058316 | 46047 |
48152 | 48152 | 2022-07-20 | Pennsylvania | 42 | 3058316 | 46047 |
48096 | 48096 | 2022-07-19 | Pennsylvania | 42 | 3051356 | 45996 |
48040 | 48040 | 2022-07-18 | Pennsylvania | 42 | 3044919 | 45963 |
47984 | 47984 | 2022-07-17 | Pennsylvania | 42 | 3040853 | 45963 |
47928 | 47928 | 2022-07-16 | Pennsylvania | 42 | 3040853 | 45963 |
47872 | 47872 | 2022-07-15 | Pennsylvania | 42 | 3040853 | 45963 |
47816 | 47816 | 2022-07-14 | Pennsylvania | 42 | 3038076 | 45949 |
47760 | 47760 | 2022-07-13 | Pennsylvania | 42 | 3038076 | 45949 |
47704 | 47704 | 2022-07-12 | Pennsylvania | 42 | 3031550 | 45888 |
47648 | 47648 | 2022-07-11 | Pennsylvania | 42 | 3025035 | 45863 |
47592 | 47592 | 2022-07-10 | Pennsylvania | 42 | 3021110 | 45838 |
47536 | 47536 | 2022-07-09 | Pennsylvania | 42 | 3021110 | 45838 |
47480 | 47480 | 2022-07-08 | Pennsylvania | 42 | 3021110 | 45838 |
47424 | 47424 | 2022-07-07 | Pennsylvania | 42 | 3018129 | 45821 |
47368 | 47368 | 2022-07-06 | Pennsylvania | 42 | 3018129 | 45821 |
47312 | 47312 | 2022-07-05 | Pennsylvania | 42 | 3009121 | 45777 |
47256 | 47256 | 2022-07-04 | Pennsylvania | 42 | 3006257 | 45766 |
47200 | 47200 | 2022-07-03 | Pennsylvania | 42 | 3006257 | 45766 |
47144 | 47144 | 2022-07-02 | Pennsylvania | 42 | 3006257 | 45766 |
47088 | 47088 | 2022-07-01 | Pennsylvania | 42 | 3006257 | 45766 |
47032 | 47032 | 2022-06-30 | Pennsylvania | 42 | 3006257 | 45766 |
46976 | 46976 | 2022-06-29 | Pennsylvania | 42 | 3001048 | 45715 |
46920 | 46920 | 2022-06-28 | Pennsylvania | 42 | 2993089 | 45715 |
46864 | 46864 | 2022-06-27 | Pennsylvania | 42 | 2993089 | 45693 |
46808 | 46808 | 2022-06-26 | Pennsylvania | 42 | 2993089 | 45693 |
46752 | 46752 | 2022-06-25 | Pennsylvania | 42 | 2993089 | 45693 |
46696 | 46696 | 2022-06-24 | Pennsylvania | 42 | 2989896 | 45678 |
46640 | 46640 | 2022-06-23 | Pennsylvania | 42 | 2987357 | 45657 |
46584 | 46584 | 2022-06-22 | Pennsylvania | 42 | 2987357 | 45657 |
46528 | 46528 | 2022-06-21 | Pennsylvania | 42 | 2977739 | 45580 |
46472 | 46472 | 2022-06-20 | Pennsylvania | 42 | 2975031 | 45580 |
46416 | 46416 | 2022-06-19 | Pennsylvania | 42 | 2975031 | 45580 |
46360 | 46360 | 2022-06-18 | Pennsylvania | 42 | 2975031 | 45580 |
46304 | 46304 | 2022-06-17 | Pennsylvania | 42 | 2975031 | 45580 |
46248 | 46248 | 2022-06-16 | Pennsylvania | 42 | 2975031 | 45580 |
46192 | 46192 | 2022-06-15 | Pennsylvania | 42 | 2975031 | 45580 |
46136 | 46136 | 2022-06-14 | Pennsylvania | 42 | 2967190 | 45506 |
46080 | 46080 | 2022-06-13 | Pennsylvania | 42 | 2960677 | 45465 |
46024 | 46024 | 2022-06-12 | Pennsylvania | 42 | 2960677 | 45465 |
45968 | 45968 | 2022-06-11 | Pennsylvania | 42 | 2960677 | 45465 |
45912 | 45912 | 2022-06-10 | Pennsylvania | 42 | 2957244 | 45434 |
45856 | 45856 | 2022-06-09 | Pennsylvania | 42 | 2954750 | 45413 |
45800 | 45800 | 2022-06-08 | Pennsylvania | 42 | 2954750 | 45413 |
45744 | 45744 | 2022-06-07 | Pennsylvania | 42 | 2947243 | 45336 |
45688 | 45688 | 2022-06-06 | Pennsylvania | 42 | 2941231 | 45308 |
45632 | 45632 | 2022-06-05 | Pennsylvania | 42 | 2941231 | 45308 |
45576 | 45576 | 2022-06-04 | Pennsylvania | 42 | 2941231 | 45308 |
45520 | 45520 | 2022-06-03 | Pennsylvania | 42 | 2936121 | 45283 |
45464 | 45464 | 2022-06-02 | Pennsylvania | 42 | 2932186 | 45254 |
45408 | 45408 | 2022-06-01 | Pennsylvania | 42 | 2932186 | 45254 |
45352 | 45352 | 2022-05-31 | Pennsylvania | 42 | 2925652 | 45184 |
45296 | 45296 | 2022-05-30 | Pennsylvania | 42 | 2913240 | 45169 |
45240 | 45240 | 2022-05-29 | Pennsylvania | 42 | 2913240 | 45169 |
45184 | 45184 | 2022-05-28 | Pennsylvania | 42 | 2913240 | 45169 |
45128 | 45128 | 2022-05-27 | Pennsylvania | 42 | 2913240 | 45169 |
45072 | 45072 | 2022-05-26 | Pennsylvania | 42 | 2907324 | 45147 |
45016 | 45016 | 2022-05-25 | Pennsylvania | 42 | 2907324 | 45147 |
44960 | 44960 | 2022-05-24 | Pennsylvania | 42 | 2899047 | 45098 |
44904 | 44904 | 2022-05-23 | Pennsylvania | 42 | 2887716 | 44923 |
44848 | 44848 | 2022-05-22 | Pennsylvania | 42 | 2887716 | 44923 |
44792 | 44792 | 2022-05-21 | Pennsylvania | 42 | 2887716 | 44923 |
44736 | 44736 | 2022-05-20 | Pennsylvania | 42 | 2882374 | 44923 |
44680 | 44680 | 2022-05-19 | Pennsylvania | 42 | 2877660 | 44898 |
44624 | 44624 | 2022-05-18 | Pennsylvania | 42 | 2877660 | 44898 |
44568 | 44568 | 2022-05-17 | Pennsylvania | 42 | 2868494 | 44856 |
44512 | 44512 | 2022-05-16 | Pennsylvania | 42 | 2852056 | 44814 |
44456 | 44456 | 2022-05-15 | Pennsylvania | 42 | 2850343 | 44814 |
44400 | 44400 | 2022-05-14 | Pennsylvania | 42 | 2850343 | 44814 |
44344 | 44344 | 2022-05-13 | Pennsylvania | 42 | 2850343 | 44814 |
44288 | 44288 | 2022-05-12 | Pennsylvania | 42 | 2850343 | 44814 |
44232 | 44232 | 2022-05-11 | Pennsylvania | 42 | 2849865 | 44814 |
44176 | 44176 | 2022-05-10 | Pennsylvania | 42 | 2829776 | 44733 |
44120 | 44120 | 2022-05-09 | Pennsylvania | 42 | 2829776 | 44733 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );