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 state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state 1
- Pennsylvania · 1,029 ✖
Link | rowid | date | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|
343 | 343 | 2020-03-06 | Pennsylvania | 42 | 2 | 0 |
374 | 374 | 2020-03-07 | Pennsylvania | 42 | 4 | 0 |
409 | 409 | 2020-03-08 | Pennsylvania | 42 | 6 | 0 |
446 | 446 | 2020-03-09 | Pennsylvania | 42 | 10 | 0 |
484 | 484 | 2020-03-10 | Pennsylvania | 42 | 12 | 0 |
528 | 528 | 2020-03-11 | Pennsylvania | 42 | 16 | 0 |
575 | 575 | 2020-03-12 | Pennsylvania | 42 | 22 | 0 |
625 | 625 | 2020-03-13 | Pennsylvania | 42 | 41 | 0 |
676 | 676 | 2020-03-14 | Pennsylvania | 42 | 47 | 0 |
729 | 729 | 2020-03-15 | Pennsylvania | 42 | 68 | 0 |
782 | 782 | 2020-03-16 | Pennsylvania | 42 | 81 | 0 |
835 | 835 | 2020-03-17 | Pennsylvania | 42 | 101 | 0 |
889 | 889 | 2020-03-18 | Pennsylvania | 42 | 139 | 1 |
943 | 943 | 2020-03-19 | Pennsylvania | 42 | 187 | 1 |
997 | 997 | 2020-03-20 | Pennsylvania | 42 | 269 | 1 |
1051 | 1051 | 2020-03-21 | Pennsylvania | 42 | 388 | 2 |
1105 | 1105 | 2020-03-22 | Pennsylvania | 42 | 504 | 3 |
1159 | 1159 | 2020-03-23 | Pennsylvania | 42 | 644 | 6 |
1213 | 1213 | 2020-03-24 | Pennsylvania | 42 | 851 | 8 |
1267 | 1267 | 2020-03-25 | Pennsylvania | 42 | 1151 | 12 |
1321 | 1321 | 2020-03-26 | Pennsylvania | 42 | 1690 | 16 |
1375 | 1375 | 2020-03-27 | Pennsylvania | 42 | 2217 | 23 |
1430 | 1430 | 2020-03-28 | Pennsylvania | 42 | 2815 | 35 |
1485 | 1485 | 2020-03-29 | Pennsylvania | 42 | 3441 | 40 |
1540 | 1540 | 2020-03-30 | Pennsylvania | 42 | 4156 | 48 |
1595 | 1595 | 2020-03-31 | Pennsylvania | 42 | 4997 | 72 |
1650 | 1650 | 2020-04-01 | Pennsylvania | 42 | 5805 | 78 |
1705 | 1705 | 2020-04-02 | Pennsylvania | 42 | 7021 | 91 |
1760 | 1760 | 2020-04-03 | Pennsylvania | 42 | 8420 | 102 |
1815 | 1815 | 2020-04-04 | Pennsylvania | 42 | 10110 | 140 |
1870 | 1870 | 2020-04-05 | Pennsylvania | 42 | 11590 | 159 |
1925 | 1925 | 2020-04-06 | Pennsylvania | 42 | 13075 | 170 |
1980 | 1980 | 2020-04-07 | Pennsylvania | 42 | 14582 | 241 |
2035 | 2035 | 2020-04-08 | Pennsylvania | 42 | 16414 | 313 |
2090 | 2090 | 2020-04-09 | Pennsylvania | 42 | 18379 | 344 |
2145 | 2145 | 2020-04-10 | Pennsylvania | 42 | 20128 | 435 |
2200 | 2200 | 2020-04-11 | Pennsylvania | 42 | 21774 | 515 |
2255 | 2255 | 2020-04-12 | Pennsylvania | 42 | 22955 | 525 |
2310 | 2310 | 2020-04-13 | Pennsylvania | 42 | 24295 | 563 |
2365 | 2365 | 2020-04-14 | Pennsylvania | 42 | 25591 | 746 |
2420 | 2420 | 2020-04-15 | Pennsylvania | 42 | 26804 | 833 |
2475 | 2475 | 2020-04-16 | Pennsylvania | 42 | 28314 | 940 |
2530 | 2530 | 2020-04-17 | Pennsylvania | 42 | 30121 | 1027 |
2585 | 2585 | 2020-04-18 | Pennsylvania | 42 | 31742 | 1150 |
2640 | 2640 | 2020-04-19 | Pennsylvania | 42 | 32992 | 1285 |
2695 | 2695 | 2020-04-20 | Pennsylvania | 42 | 34005 | 1366 |
2750 | 2750 | 2020-04-21 | Pennsylvania | 42 | 35384 | 1620 |
2805 | 2805 | 2020-04-22 | Pennsylvania | 42 | 36763 | 1720 |
2860 | 2860 | 2020-04-23 | Pennsylvania | 42 | 38334 | 1723 |
2915 | 2915 | 2020-04-24 | Pennsylvania | 42 | 40298 | 1786 |
2970 | 2970 | 2020-04-25 | Pennsylvania | 42 | 41626 | 1842 |
3025 | 3025 | 2020-04-26 | Pennsylvania | 42 | 42709 | 1871 |
3080 | 3080 | 2020-04-27 | Pennsylvania | 42 | 43728 | 1946 |
3135 | 3135 | 2020-04-28 | Pennsylvania | 42 | 45323 | 2092 |
3190 | 3190 | 2020-04-29 | Pennsylvania | 42 | 46191 | 2392 |
3245 | 3245 | 2020-04-30 | Pennsylvania | 42 | 48224 | 2580 |
3300 | 3300 | 2020-05-01 | Pennsylvania | 42 | 49764 | 2671 |
3355 | 3355 | 2020-05-02 | Pennsylvania | 42 | 51071 | 2794 |
3410 | 3410 | 2020-05-03 | Pennsylvania | 42 | 52079 | 2843 |
3465 | 3465 | 2020-05-04 | Pennsylvania | 42 | 52992 | 2880 |
3520 | 3520 | 2020-05-05 | Pennsylvania | 42 | 53967 | 3206 |
3575 | 3575 | 2020-05-06 | Pennsylvania | 42 | 54989 | 3360 |
3630 | 3630 | 2020-05-07 | Pennsylvania | 42 | 56149 | 3599 |
3685 | 3685 | 2020-05-08 | Pennsylvania | 42 | 57501 | 3724 |
3740 | 3740 | 2020-05-09 | Pennsylvania | 42 | 58661 | 3793 |
3795 | 3795 | 2020-05-10 | Pennsylvania | 42 | 60037 | 3819 |
3850 | 3850 | 2020-05-11 | Pennsylvania | 42 | 60557 | 3846 |
3905 | 3905 | 2020-05-12 | Pennsylvania | 42 | 61407 | 3924 |
3960 | 3960 | 2020-05-13 | Pennsylvania | 42 | 62194 | 4104 |
4015 | 4015 | 2020-05-14 | Pennsylvania | 42 | 63158 | 4298 |
4070 | 4070 | 2020-05-15 | Pennsylvania | 42 | 64178 | 4432 |
4125 | 4125 | 2020-05-16 | Pennsylvania | 42 | 65228 | 4490 |
4180 | 4180 | 2020-05-17 | Pennsylvania | 42 | 65745 | 4504 |
4235 | 4235 | 2020-05-18 | Pennsylvania | 42 | 66676 | 4560 |
4290 | 4290 | 2020-05-19 | Pennsylvania | 42 | 67404 | 4675 |
4345 | 4345 | 2020-05-20 | Pennsylvania | 42 | 68151 | 4794 |
4400 | 4400 | 2020-05-21 | Pennsylvania | 42 | 69252 | 4887 |
4455 | 4455 | 2020-05-22 | Pennsylvania | 42 | 70305 | 5032 |
4510 | 4510 | 2020-05-23 | Pennsylvania | 42 | 71102 | 5121 |
4565 | 4565 | 2020-05-24 | Pennsylvania | 42 | 71656 | 5145 |
4620 | 4620 | 2020-05-25 | Pennsylvania | 42 | 72356 | 5159 |
4675 | 4675 | 2020-05-26 | Pennsylvania | 42 | 72873 | 5175 |
4730 | 4730 | 2020-05-27 | Pennsylvania | 42 | 73646 | 5290 |
4785 | 4785 | 2020-05-28 | Pennsylvania | 42 | 74312 | 5397 |
4840 | 4840 | 2020-05-29 | Pennsylvania | 42 | 75073 | 5467 |
4895 | 4895 | 2020-05-30 | Pennsylvania | 42 | 75789 | 5537 |
4950 | 4950 | 2020-05-31 | Pennsylvania | 42 | 76218 | 5555 |
5005 | 5005 | 2020-06-01 | Pennsylvania | 42 | 76734 | 5574 |
5060 | 5060 | 2020-06-02 | Pennsylvania | 42 | 77315 | 5670 |
5115 | 5115 | 2020-06-03 | Pennsylvania | 42 | 77871 | 5742 |
5170 | 5170 | 2020-06-04 | Pennsylvania | 42 | 78428 | 5862 |
5225 | 5225 | 2020-06-05 | Pennsylvania | 42 | 78908 | 5952 |
5280 | 5280 | 2020-06-06 | Pennsylvania | 42 | 79507 | 5986 |
5335 | 5335 | 2020-06-07 | Pennsylvania | 42 | 80001 | 5997 |
5390 | 5390 | 2020-06-08 | Pennsylvania | 42 | 80432 | 6007 |
5445 | 5445 | 2020-06-09 | Pennsylvania | 42 | 80964 | 6070 |
5500 | 5500 | 2020-06-10 | Pennsylvania | 42 | 81410 | 6143 |
5555 | 5555 | 2020-06-11 | Pennsylvania | 42 | 81944 | 6187 |
5610 | 5610 | 2020-06-12 | Pennsylvania | 42 | 82578 | 6229 |
5665 | 5665 | 2020-06-13 | Pennsylvania | 42 | 82988 | 6264 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );