ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 42017 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
919462 | 919462 | 2021-01-11 | Bucks | Pennsylvania | 42017 | 34438 | 942 |
916217 | 916217 | 2021-01-10 | Bucks | Pennsylvania | 42017 | 34178 | 940 |
912972 | 912972 | 2021-01-09 | Bucks | Pennsylvania | 42017 | 33843 | 940 |
909727 | 909727 | 2021-01-08 | Bucks | Pennsylvania | 42017 | 33463 | 932 |
906482 | 906482 | 2021-01-07 | Bucks | Pennsylvania | 42017 | 32988 | 928 |
903236 | 903236 | 2021-01-06 | Bucks | Pennsylvania | 42017 | 32484 | 919 |
899991 | 899991 | 2021-01-05 | Bucks | Pennsylvania | 42017 | 32070 | 913 |
896746 | 896746 | 2021-01-04 | Bucks | Pennsylvania | 42017 | 31562 | 909 |
893500 | 893500 | 2021-01-03 | Bucks | Pennsylvania | 42017 | 31468 | 909 |
890254 | 890254 | 2021-01-02 | Bucks | Pennsylvania | 42017 | 31224 | 908 |
887007 | 887007 | 2021-01-01 | Bucks | Pennsylvania | 42017 | 30891 | 908 |
883762 | 883762 | 2020-12-31 | Bucks | Pennsylvania | 42017 | 30537 | 904 |
880517 | 880517 | 2020-12-30 | Bucks | Pennsylvania | 42017 | 30101 | 898 |
877272 | 877272 | 2020-12-29 | Bucks | Pennsylvania | 42017 | 29692 | 889 |
874027 | 874027 | 2020-12-28 | Bucks | Pennsylvania | 42017 | 29244 | 876 |
870782 | 870782 | 2020-12-27 | Bucks | Pennsylvania | 42017 | 29033 | 870 |
867537 | 867537 | 2020-12-26 | Bucks | Pennsylvania | 42017 | 28831 | 864 |
864292 | 864292 | 2020-12-25 | Bucks | Pennsylvania | 42017 | 28538 | 862 |
861047 | 861047 | 2020-12-24 | Bucks | Pennsylvania | 42017 | 28193 | 862 |
857802 | 857802 | 2020-12-23 | Bucks | Pennsylvania | 42017 | 27796 | 854 |
854557 | 854557 | 2020-12-22 | Bucks | Pennsylvania | 42017 | 27411 | 846 |
851312 | 851312 | 2020-12-21 | Bucks | Pennsylvania | 42017 | 27009 | 838 |
848067 | 848067 | 2020-12-20 | Bucks | Pennsylvania | 42017 | 26706 | 836 |
844822 | 844822 | 2020-12-19 | Bucks | Pennsylvania | 42017 | 26387 | 833 |
841576 | 841576 | 2020-12-18 | Bucks | Pennsylvania | 42017 | 26036 | 825 |
838331 | 838331 | 2020-12-17 | Bucks | Pennsylvania | 42017 | 25496 | 820 |
835085 | 835085 | 2020-12-16 | Bucks | Pennsylvania | 42017 | 25183 | 811 |
831839 | 831839 | 2020-12-15 | Bucks | Pennsylvania | 42017 | 24813 | 794 |
828592 | 828592 | 2020-12-14 | Bucks | Pennsylvania | 42017 | 24462 | 782 |
825346 | 825346 | 2020-12-13 | Bucks | Pennsylvania | 42017 | 24067 | 777 |
822099 | 822099 | 2020-12-12 | Bucks | Pennsylvania | 42017 | 23638 | 772 |
818853 | 818853 | 2020-12-11 | Bucks | Pennsylvania | 42017 | 23071 | 766 |
815607 | 815607 | 2020-12-10 | Bucks | Pennsylvania | 42017 | 22509 | 753 |
812361 | 812361 | 2020-12-09 | Bucks | Pennsylvania | 42017 | 21923 | 742 |
809117 | 809117 | 2020-12-08 | Bucks | Pennsylvania | 42017 | 21586 | 727 |
805872 | 805872 | 2020-12-07 | Bucks | Pennsylvania | 42017 | 21146 | 719 |
802627 | 802627 | 2020-12-06 | Bucks | Pennsylvania | 42017 | 20619 | 719 |
799382 | 799382 | 2020-12-05 | Bucks | Pennsylvania | 42017 | 20128 | 718 |
796137 | 796137 | 2020-12-04 | Bucks | Pennsylvania | 42017 | 19654 | 716 |
792892 | 792892 | 2020-12-03 | Bucks | Pennsylvania | 42017 | 18925 | 711 |
789647 | 789647 | 2020-12-02 | Bucks | Pennsylvania | 42017 | 18296 | 704 |
786402 | 786402 | 2020-12-01 | Bucks | Pennsylvania | 42017 | 17936 | 693 |
783158 | 783158 | 2020-11-30 | Bucks | Pennsylvania | 42017 | 17733 | 679 |
779913 | 779913 | 2020-11-29 | Bucks | Pennsylvania | 42017 | 17410 | 678 |
776667 | 776667 | 2020-11-28 | Bucks | Pennsylvania | 42017 | 17146 | 674 |
773422 | 773422 | 2020-11-27 | Bucks | Pennsylvania | 42017 | 16709 | 672 |
770177 | 770177 | 2020-11-26 | Bucks | Pennsylvania | 42017 | 16297 | 672 |
766931 | 766931 | 2020-11-25 | Bucks | Pennsylvania | 42017 | 15901 | 668 |
763686 | 763686 | 2020-11-24 | Bucks | Pennsylvania | 42017 | 15647 | 660 |
760441 | 760441 | 2020-11-23 | Bucks | Pennsylvania | 42017 | 15405 | 658 |
757196 | 757196 | 2020-11-22 | Bucks | Pennsylvania | 42017 | 15126 | 657 |
753949 | 753949 | 2020-11-21 | Bucks | Pennsylvania | 42017 | 14794 | 656 |
750703 | 750703 | 2020-11-20 | Bucks | Pennsylvania | 42017 | 14465 | 650 |
747457 | 747457 | 2020-11-19 | Bucks | Pennsylvania | 42017 | 14076 | 646 |
744211 | 744211 | 2020-11-18 | Bucks | Pennsylvania | 42017 | 13686 | 641 |
740964 | 740964 | 2020-11-17 | Bucks | Pennsylvania | 42017 | 13518 | 636 |
737718 | 737718 | 2020-11-16 | Bucks | Pennsylvania | 42017 | 13285 | 636 |
734474 | 734474 | 2020-11-15 | Bucks | Pennsylvania | 42017 | 13050 | 636 |
731228 | 731228 | 2020-11-14 | Bucks | Pennsylvania | 42017 | 12748 | 636 |
727984 | 727984 | 2020-11-13 | Bucks | Pennsylvania | 42017 | 12519 | 636 |
724740 | 724740 | 2020-11-12 | Bucks | Pennsylvania | 42017 | 12229 | 636 |
721497 | 721497 | 2020-11-11 | Bucks | Pennsylvania | 42017 | 11921 | 635 |
718254 | 718254 | 2020-11-10 | Bucks | Pennsylvania | 42017 | 11676 | 632 |
715011 | 715011 | 2020-11-09 | Bucks | Pennsylvania | 42017 | 11519 | 629 |
711767 | 711767 | 2020-11-08 | Bucks | Pennsylvania | 42017 | 11340 | 628 |
708523 | 708523 | 2020-11-07 | Bucks | Pennsylvania | 42017 | 11193 | 628 |
705280 | 705280 | 2020-11-06 | Bucks | Pennsylvania | 42017 | 11051 | 628 |
702037 | 702037 | 2020-11-05 | Bucks | Pennsylvania | 42017 | 10895 | 627 |
698793 | 698793 | 2020-11-04 | Bucks | Pennsylvania | 42017 | 10770 | 627 |
695550 | 695550 | 2020-11-03 | Bucks | Pennsylvania | 42017 | 10679 | 627 |
692308 | 692308 | 2020-11-02 | Bucks | Pennsylvania | 42017 | 10585 | 626 |
689064 | 689064 | 2020-11-01 | Bucks | Pennsylvania | 42017 | 10513 | 626 |
685819 | 685819 | 2020-10-31 | Bucks | Pennsylvania | 42017 | 10445 | 626 |
682576 | 682576 | 2020-10-30 | Bucks | Pennsylvania | 42017 | 10337 | 626 |
679333 | 679333 | 2020-10-29 | Bucks | Pennsylvania | 42017 | 10254 | 626 |
676090 | 676090 | 2020-10-28 | Bucks | Pennsylvania | 42017 | 10171 | 626 |
672847 | 672847 | 2020-10-27 | Bucks | Pennsylvania | 42017 | 10112 | 626 |
669605 | 669605 | 2020-10-26 | Bucks | Pennsylvania | 42017 | 10053 | 626 |
666361 | 666361 | 2020-10-25 | Bucks | Pennsylvania | 42017 | 10008 | 625 |
663116 | 663116 | 2020-10-24 | Bucks | Pennsylvania | 42017 | 9942 | 625 |
659872 | 659872 | 2020-10-23 | Bucks | Pennsylvania | 42017 | 9848 | 624 |
656628 | 656628 | 2020-10-22 | Bucks | Pennsylvania | 42017 | 9764 | 623 |
653383 | 653383 | 2020-10-21 | Bucks | Pennsylvania | 42017 | 9709 | 623 |
650138 | 650138 | 2020-10-20 | Bucks | Pennsylvania | 42017 | 9671 | 623 |
646894 | 646894 | 2020-10-19 | Bucks | Pennsylvania | 42017 | 9637 | 623 |
643648 | 643648 | 2020-10-18 | Bucks | Pennsylvania | 42017 | 9599 | 623 |
640400 | 640400 | 2020-10-17 | Bucks | Pennsylvania | 42017 | 9561 | 622 |
637154 | 637154 | 2020-10-16 | Bucks | Pennsylvania | 42017 | 9527 | 622 |
633908 | 633908 | 2020-10-15 | Bucks | Pennsylvania | 42017 | 9485 | 622 |
630663 | 630663 | 2020-10-14 | Bucks | Pennsylvania | 42017 | 9423 | 622 |
627419 | 627419 | 2020-10-13 | Bucks | Pennsylvania | 42017 | 9392 | 622 |
624177 | 624177 | 2020-10-12 | Bucks | Pennsylvania | 42017 | 9366 | 621 |
620934 | 620934 | 2020-10-11 | Bucks | Pennsylvania | 42017 | 9320 | 620 |
617691 | 617691 | 2020-10-10 | Bucks | Pennsylvania | 42017 | 9283 | 621 |
614449 | 614449 | 2020-10-09 | Bucks | Pennsylvania | 42017 | 9248 | 621 |
611208 | 611208 | 2020-10-08 | Bucks | Pennsylvania | 42017 | 9172 | 621 |
607966 | 607966 | 2020-10-07 | Bucks | Pennsylvania | 42017 | 9136 | 619 |
604723 | 604723 | 2020-10-06 | Bucks | Pennsylvania | 42017 | 9086 | 618 |
601481 | 601481 | 2020-10-05 | Bucks | Pennsylvania | 42017 | 9066 | 617 |
598238 | 598238 | 2020-10-04 | Bucks | Pennsylvania | 42017 | 9037 | 617 |
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);