ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Adams" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922699 | 922699 | 2021-01-12 | Adams | Pennsylvania | 42001 | 5434 | 115 |
919454 | 919454 | 2021-01-11 | Adams | Pennsylvania | 42001 | 5401 | 114 |
916209 | 916209 | 2021-01-10 | Adams | Pennsylvania | 42001 | 5341 | 112 |
912964 | 912964 | 2021-01-09 | Adams | Pennsylvania | 42001 | 5230 | 111 |
909719 | 909719 | 2021-01-08 | Adams | Pennsylvania | 42001 | 5145 | 108 |
906474 | 906474 | 2021-01-07 | Adams | Pennsylvania | 42001 | 5059 | 108 |
903228 | 903228 | 2021-01-06 | Adams | Pennsylvania | 42001 | 4973 | 101 |
899983 | 899983 | 2021-01-05 | Adams | Pennsylvania | 42001 | 4865 | 95 |
896738 | 896738 | 2021-01-04 | Adams | Pennsylvania | 42001 | 4786 | 92 |
893492 | 893492 | 2021-01-03 | Adams | Pennsylvania | 42001 | 4768 | 91 |
890246 | 890246 | 2021-01-02 | Adams | Pennsylvania | 42001 | 4701 | 90 |
886999 | 886999 | 2021-01-01 | Adams | Pennsylvania | 42001 | 4649 | 90 |
883754 | 883754 | 2020-12-31 | Adams | Pennsylvania | 42001 | 4557 | 88 |
880509 | 880509 | 2020-12-30 | Adams | Pennsylvania | 42001 | 4477 | 81 |
877264 | 877264 | 2020-12-29 | Adams | Pennsylvania | 42001 | 4325 | 77 |
874019 | 874019 | 2020-12-28 | Adams | Pennsylvania | 42001 | 4262 | 74 |
870774 | 870774 | 2020-12-27 | Adams | Pennsylvania | 42001 | 4221 | 74 |
867529 | 867529 | 2020-12-26 | Adams | Pennsylvania | 42001 | 4154 | 71 |
864284 | 864284 | 2020-12-25 | Adams | Pennsylvania | 42001 | 4040 | 71 |
861039 | 861039 | 2020-12-24 | Adams | Pennsylvania | 42001 | 3988 | 71 |
857794 | 857794 | 2020-12-23 | Adams | Pennsylvania | 42001 | 3889 | 68 |
854549 | 854549 | 2020-12-22 | Adams | Pennsylvania | 42001 | 3744 | 66 |
851304 | 851304 | 2020-12-21 | Adams | Pennsylvania | 42001 | 3697 | 64 |
848059 | 848059 | 2020-12-20 | Adams | Pennsylvania | 42001 | 3630 | 64 |
844814 | 844814 | 2020-12-19 | Adams | Pennsylvania | 42001 | 3569 | 64 |
841568 | 841568 | 2020-12-18 | Adams | Pennsylvania | 42001 | 3406 | 61 |
838323 | 838323 | 2020-12-17 | Adams | Pennsylvania | 42001 | 3280 | 61 |
835077 | 835077 | 2020-12-16 | Adams | Pennsylvania | 42001 | 3196 | 57 |
831831 | 831831 | 2020-12-15 | Adams | Pennsylvania | 42001 | 3132 | 56 |
828584 | 828584 | 2020-12-14 | Adams | Pennsylvania | 42001 | 3095 | 54 |
825338 | 825338 | 2020-12-13 | Adams | Pennsylvania | 42001 | 3017 | 54 |
822091 | 822091 | 2020-12-12 | Adams | Pennsylvania | 42001 | 2868 | 53 |
818845 | 818845 | 2020-12-11 | Adams | Pennsylvania | 42001 | 2792 | 53 |
815599 | 815599 | 2020-12-10 | Adams | Pennsylvania | 42001 | 2726 | 53 |
812353 | 812353 | 2020-12-09 | Adams | Pennsylvania | 42001 | 2633 | 52 |
809109 | 809109 | 2020-12-08 | Adams | Pennsylvania | 42001 | 2570 | 52 |
805864 | 805864 | 2020-12-07 | Adams | Pennsylvania | 42001 | 2512 | 52 |
802619 | 802619 | 2020-12-06 | Adams | Pennsylvania | 42001 | 2488 | 51 |
799374 | 799374 | 2020-12-05 | Adams | Pennsylvania | 42001 | 2424 | 50 |
796129 | 796129 | 2020-12-04 | Adams | Pennsylvania | 42001 | 2292 | 49 |
792884 | 792884 | 2020-12-03 | Adams | Pennsylvania | 42001 | 2227 | 49 |
789639 | 789639 | 2020-12-02 | Adams | Pennsylvania | 42001 | 2096 | 48 |
786394 | 786394 | 2020-12-01 | Adams | Pennsylvania | 42001 | 2047 | 47 |
783150 | 783150 | 2020-11-30 | Adams | Pennsylvania | 42001 | 2028 | 47 |
779905 | 779905 | 2020-11-29 | Adams | Pennsylvania | 42001 | 2003 | 47 |
776659 | 776659 | 2020-11-28 | Adams | Pennsylvania | 42001 | 1973 | 47 |
773414 | 773414 | 2020-11-27 | Adams | Pennsylvania | 42001 | 1908 | 46 |
770169 | 770169 | 2020-11-26 | Adams | Pennsylvania | 42001 | 1877 | 46 |
766923 | 766923 | 2020-11-25 | Adams | Pennsylvania | 42001 | 1834 | 45 |
763678 | 763678 | 2020-11-24 | Adams | Pennsylvania | 42001 | 1808 | 45 |
760433 | 760433 | 2020-11-23 | Adams | Pennsylvania | 42001 | 1774 | 45 |
757188 | 757188 | 2020-11-22 | Adams | Pennsylvania | 42001 | 1763 | 45 |
753941 | 753941 | 2020-11-21 | Adams | Pennsylvania | 42001 | 1666 | 45 |
750695 | 750695 | 2020-11-20 | Adams | Pennsylvania | 42001 | 1636 | 45 |
747449 | 747449 | 2020-11-19 | Adams | Pennsylvania | 42001 | 1611 | 42 |
744203 | 744203 | 2020-11-18 | Adams | Pennsylvania | 42001 | 1587 | 40 |
740956 | 740956 | 2020-11-17 | Adams | Pennsylvania | 42001 | 1552 | 39 |
737710 | 737710 | 2020-11-16 | Adams | Pennsylvania | 42001 | 1517 | 39 |
734466 | 734466 | 2020-11-15 | Adams | Pennsylvania | 42001 | 1493 | 39 |
731220 | 731220 | 2020-11-14 | Adams | Pennsylvania | 42001 | 1481 | 39 |
727976 | 727976 | 2020-11-13 | Adams | Pennsylvania | 42001 | 1468 | 37 |
724732 | 724732 | 2020-11-12 | Adams | Pennsylvania | 42001 | 1431 | 36 |
721489 | 721489 | 2020-11-11 | Adams | Pennsylvania | 42001 | 1408 | 34 |
718246 | 718246 | 2020-11-10 | Adams | Pennsylvania | 42001 | 1382 | 34 |
715003 | 715003 | 2020-11-09 | Adams | Pennsylvania | 42001 | 1358 | 34 |
711759 | 711759 | 2020-11-08 | Adams | Pennsylvania | 42001 | 1341 | 34 |
708515 | 708515 | 2020-11-07 | Adams | Pennsylvania | 42001 | 1318 | 34 |
705272 | 705272 | 2020-11-06 | Adams | Pennsylvania | 42001 | 1288 | 34 |
702029 | 702029 | 2020-11-05 | Adams | Pennsylvania | 42001 | 1252 | 33 |
698785 | 698785 | 2020-11-04 | Adams | Pennsylvania | 42001 | 1235 | 32 |
695542 | 695542 | 2020-11-03 | Adams | Pennsylvania | 42001 | 1229 | 31 |
692300 | 692300 | 2020-11-02 | Adams | Pennsylvania | 42001 | 1195 | 31 |
689056 | 689056 | 2020-11-01 | Adams | Pennsylvania | 42001 | 1184 | 31 |
685811 | 685811 | 2020-10-31 | Adams | Pennsylvania | 42001 | 1179 | 31 |
682568 | 682568 | 2020-10-30 | Adams | Pennsylvania | 42001 | 1158 | 29 |
679325 | 679325 | 2020-10-29 | Adams | Pennsylvania | 42001 | 1144 | 28 |
676082 | 676082 | 2020-10-28 | Adams | Pennsylvania | 42001 | 1133 | 27 |
672839 | 672839 | 2020-10-27 | Adams | Pennsylvania | 42001 | 1118 | 27 |
669597 | 669597 | 2020-10-26 | Adams | Pennsylvania | 42001 | 1100 | 27 |
666353 | 666353 | 2020-10-25 | Adams | Pennsylvania | 42001 | 1084 | 27 |
663108 | 663108 | 2020-10-24 | Adams | Pennsylvania | 42001 | 1070 | 27 |
659864 | 659864 | 2020-10-23 | Adams | Pennsylvania | 42001 | 1062 | 27 |
656620 | 656620 | 2020-10-22 | Adams | Pennsylvania | 42001 | 1044 | 27 |
653375 | 653375 | 2020-10-21 | Adams | Pennsylvania | 42001 | 1035 | 27 |
650130 | 650130 | 2020-10-20 | Adams | Pennsylvania | 42001 | 1030 | 27 |
646886 | 646886 | 2020-10-19 | Adams | Pennsylvania | 42001 | 1017 | 27 |
643640 | 643640 | 2020-10-18 | Adams | Pennsylvania | 42001 | 996 | 27 |
640392 | 640392 | 2020-10-17 | Adams | Pennsylvania | 42001 | 985 | 27 |
637146 | 637146 | 2020-10-16 | Adams | Pennsylvania | 42001 | 971 | 27 |
633900 | 633900 | 2020-10-15 | Adams | Pennsylvania | 42001 | 962 | 27 |
630655 | 630655 | 2020-10-14 | Adams | Pennsylvania | 42001 | 957 | 27 |
627411 | 627411 | 2020-10-13 | Adams | Pennsylvania | 42001 | 945 | 26 |
624169 | 624169 | 2020-10-12 | Adams | Pennsylvania | 42001 | 939 | 26 |
620926 | 620926 | 2020-10-11 | Adams | Pennsylvania | 42001 | 935 | 26 |
617683 | 617683 | 2020-10-10 | Adams | Pennsylvania | 42001 | 929 | 26 |
614441 | 614441 | 2020-10-09 | Adams | Pennsylvania | 42001 | 916 | 26 |
611200 | 611200 | 2020-10-08 | Adams | Pennsylvania | 42001 | 910 | 26 |
607958 | 607958 | 2020-10-07 | Adams | Pennsylvania | 42001 | 897 | 26 |
604715 | 604715 | 2020-10-06 | Adams | Pennsylvania | 42001 | 891 | 26 |
601473 | 601473 | 2020-10-05 | Adams | Pennsylvania | 42001 | 885 | 26 |
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);