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 · 323 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
17930 | 17930 | 2021-01-22 | Pennsylvania | 42 | 799948 | 20322 |
17875 | 17875 | 2021-01-21 | Pennsylvania | 42 | 794632 | 20128 |
17820 | 17820 | 2021-01-20 | Pennsylvania | 42 | 789029 | 19868 |
17765 | 17765 | 2021-01-19 | Pennsylvania | 42 | 783355 | 19467 |
17710 | 17710 | 2021-01-18 | Pennsylvania | 42 | 776490 | 19390 |
17655 | 17655 | 2021-01-17 | Pennsylvania | 42 | 772747 | 19310 |
17600 | 17600 | 2021-01-16 | Pennsylvania | 42 | 767074 | 19188 |
17545 | 17545 | 2021-01-15 | Pennsylvania | 42 | 760552 | 18978 |
17490 | 17490 | 2021-01-14 | Pennsylvania | 42 | 754441 | 18752 |
17435 | 17435 | 2021-01-13 | Pennsylvania | 42 | 747245 | 18458 |
17380 | 17380 | 2021-01-12 | Pennsylvania | 42 | 739212 | 18091 |
17325 | 17325 | 2021-01-11 | Pennsylvania | 42 | 731967 | 17861 |
17270 | 17270 | 2021-01-10 | Pennsylvania | 42 | 725506 | 17780 |
17215 | 17215 | 2021-01-09 | Pennsylvania | 42 | 718642 | 17681 |
17160 | 17160 | 2021-01-08 | Pennsylvania | 42 | 709235 | 17427 |
17105 | 17105 | 2021-01-07 | Pennsylvania | 42 | 699018 | 17220 |
17050 | 17050 | 2021-01-06 | Pennsylvania | 42 | 689162 | 16960 |
16995 | 16995 | 2021-01-05 | Pennsylvania | 42 | 679760 | 16583 |
16940 | 16940 | 2021-01-04 | Pennsylvania | 42 | 670769 | 16394 |
16885 | 16885 | 2021-01-03 | Pennsylvania | 42 | 666207 | 16324 |
16830 | 16830 | 2021-01-02 | Pennsylvania | 42 | 661731 | 16270 |
16775 | 16775 | 2021-01-01 | Pennsylvania | 42 | 652952 | 16247 |
16720 | 16720 | 2020-12-31 | Pennsylvania | 42 | 646060 | 16020 |
16665 | 16665 | 2020-12-30 | Pennsylvania | 42 | 636710 | 15718 |
16610 | 16610 | 2020-12-29 | Pennsylvania | 42 | 628083 | 15389 |
16555 | 16555 | 2020-12-28 | Pennsylvania | 42 | 619425 | 15114 |
16500 | 16500 | 2020-12-27 | Pennsylvania | 42 | 614303 | 15040 |
16445 | 16445 | 2020-12-26 | Pennsylvania | 42 | 609682 | 14915 |
16390 | 16390 | 2020-12-25 | Pennsylvania | 42 | 602605 | 14892 |
16335 | 16335 | 2020-12-24 | Pennsylvania | 42 | 596122 | 14759 |
16280 | 16280 | 2020-12-23 | Pennsylvania | 42 | 586908 | 14470 |
16225 | 16225 | 2020-12-22 | Pennsylvania | 42 | 577183 | 14244 |
16170 | 16170 | 2020-12-21 | Pennsylvania | 42 | 569413 | 14021 |
16115 | 16115 | 2020-12-20 | Pennsylvania | 42 | 560002 | 13964 |
16060 | 16060 | 2020-12-19 | Pennsylvania | 42 | 553424 | 13869 |
16005 | 16005 | 2020-12-18 | Pennsylvania | 42 | 544417 | 13664 |
15950 | 15950 | 2020-12-17 | Pennsylvania | 42 | 535231 | 13442 |
15895 | 15895 | 2020-12-16 | Pennsylvania | 42 | 525199 | 13200 |
15840 | 15840 | 2020-12-15 | Pennsylvania | 42 | 515009 | 12930 |
15785 | 15785 | 2020-12-14 | Pennsylvania | 42 | 505422 | 12668 |
15730 | 15730 | 2020-12-13 | Pennsylvania | 42 | 495906 | 12613 |
15675 | 15675 | 2020-12-12 | Pennsylvania | 42 | 485901 | 12489 |
15620 | 15620 | 2020-12-11 | Pennsylvania | 42 | 475844 | 12298 |
15565 | 15565 | 2020-12-10 | Pennsylvania | 42 | 463175 | 12066 |
15510 | 15510 | 2020-12-09 | Pennsylvania | 42 | 451154 | 11839 |
15455 | 15455 | 2020-12-08 | Pennsylvania | 42 | 442528 | 11592 |
15400 | 15400 | 2020-12-07 | Pennsylvania | 42 | 432410 | 11431 |
15345 | 15345 | 2020-12-06 | Pennsylvania | 42 | 423828 | 11389 |
15290 | 15290 | 2020-12-05 | Pennsylvania | 42 | 416073 | 11331 |
15235 | 15235 | 2020-12-04 | Pennsylvania | 42 | 404699 | 11189 |
15180 | 15180 | 2020-12-03 | Pennsylvania | 42 | 392610 | 11008 |
15125 | 15125 | 2020-12-02 | Pennsylvania | 42 | 381342 | 10803 |
15070 | 15070 | 2020-12-01 | Pennsylvania | 42 | 372688 | 10614 |
15015 | 15015 | 2020-11-30 | Pennsylvania | 42 | 366971 | 10439 |
14960 | 14960 | 2020-11-29 | Pennsylvania | 42 | 361387 | 10406 |
14905 | 14905 | 2020-11-28 | Pennsylvania | 42 | 356243 | 10337 |
14850 | 14850 | 2020-11-27 | Pennsylvania | 42 | 349360 | 10295 |
14795 | 14795 | 2020-11-26 | Pennsylvania | 42 | 340998 | 10271 |
14740 | 14740 | 2020-11-25 | Pennsylvania | 42 | 333571 | 10162 |
14685 | 14685 | 2020-11-24 | Pennsylvania | 42 | 326615 | 10014 |
14630 | 14630 | 2020-11-23 | Pennsylvania | 42 | 320250 | 9932 |
14575 | 14575 | 2020-11-22 | Pennsylvania | 42 | 313788 | 9901 |
14520 | 14520 | 2020-11-21 | Pennsylvania | 42 | 307247 | 9862 |
14465 | 14465 | 2020-11-20 | Pennsylvania | 42 | 301373 | 9748 |
14410 | 14410 | 2020-11-19 | Pennsylvania | 42 | 294345 | 9643 |
14355 | 14355 | 2020-11-18 | Pennsylvania | 42 | 287464 | 9541 |
14300 | 14300 | 2020-11-17 | Pennsylvania | 42 | 280978 | 9433 |
14245 | 14245 | 2020-11-16 | Pennsylvania | 42 | 275257 | 9399 |
14190 | 14190 | 2020-11-15 | Pennsylvania | 42 | 269043 | 9385 |
14135 | 14135 | 2020-11-14 | Pennsylvania | 42 | 264396 | 9353 |
14080 | 14080 | 2020-11-13 | Pennsylvania | 42 | 260001 | 9306 |
14025 | 14025 | 2020-11-12 | Pennsylvania | 42 | 254167 | 9272 |
13970 | 13970 | 2020-11-11 | Pennsylvania | 42 | 248144 | 9217 |
13915 | 13915 | 2020-11-10 | Pennsylvania | 42 | 244046 | 9156 |
13860 | 13860 | 2020-11-09 | Pennsylvania | 42 | 239724 | 9098 |
13805 | 13805 | 2020-11-08 | Pennsylvania | 42 | 235162 | 9093 |
13750 | 13750 | 2020-11-07 | Pennsylvania | 42 | 232582 | 9089 |
13695 | 13695 | 2020-11-06 | Pennsylvania | 42 | 229346 | 9052 |
13640 | 13640 | 2020-11-05 | Pennsylvania | 42 | 225698 | 9009 |
13585 | 13585 | 2020-11-04 | Pennsylvania | 42 | 222883 | 8967 |
13530 | 13530 | 2020-11-03 | Pennsylvania | 42 | 220111 | 8926 |
13475 | 13475 | 2020-11-02 | Pennsylvania | 42 | 217243 | 8893 |
13420 | 13420 | 2020-11-01 | Pennsylvania | 42 | 214500 | 8888 |
13365 | 13365 | 2020-10-31 | Pennsylvania | 42 | 212816 | 8883 |
13310 | 13310 | 2020-10-30 | Pennsylvania | 42 | 210586 | 8860 |
13255 | 13255 | 2020-10-29 | Pennsylvania | 42 | 208087 | 8828 |
13200 | 13200 | 2020-10-28 | Pennsylvania | 42 | 205852 | 8789 |
13145 | 13145 | 2020-10-27 | Pennsylvania | 42 | 203520 | 8760 |
13090 | 13090 | 2020-10-26 | Pennsylvania | 42 | 201248 | 8737 |
13035 | 13035 | 2020-10-25 | Pennsylvania | 42 | 198756 | 8730 |
12980 | 12980 | 2020-10-24 | Pennsylvania | 42 | 197370 | 8721 |
12925 | 12925 | 2020-10-23 | Pennsylvania | 42 | 195659 | 8695 |
12870 | 12870 | 2020-10-22 | Pennsylvania | 42 | 193401 | 8660 |
12815 | 12815 | 2020-10-21 | Pennsylvania | 42 | 191347 | 8629 |
12760 | 12760 | 2020-10-20 | Pennsylvania | 42 | 189988 | 8591 |
12705 | 12705 | 2020-10-19 | Pennsylvania | 42 | 188442 | 8562 |
12650 | 12650 | 2020-10-18 | Pennsylvania | 42 | 186772 | 8555 |
12595 | 12595 | 2020-10-17 | Pennsylvania | 42 | 185670 | 8535 |
12540 | 12540 | 2020-10-16 | Pennsylvania | 42 | 184185 | 8524 |
12485 | 12485 | 2020-10-15 | Pennsylvania | 42 | 182502 | 8496 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );