ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Warren" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055829 | 1055829 | 2021-02-22 | Warren | Pennsylvania | 42123 | 2135 | 96 |
1052583 | 1052583 | 2021-02-21 | Warren | Pennsylvania | 42123 | 2132 | 96 |
1049336 | 1049336 | 2021-02-20 | Warren | Pennsylvania | 42123 | 2132 | 96 |
1046089 | 1046089 | 2021-02-19 | Warren | Pennsylvania | 42123 | 2122 | 96 |
1042844 | 1042844 | 2021-02-18 | Warren | Pennsylvania | 42123 | 2114 | 96 |
1039599 | 1039599 | 2021-02-17 | Warren | Pennsylvania | 42123 | 2112 | 95 |
1036354 | 1036354 | 2021-02-16 | Warren | Pennsylvania | 42123 | 2110 | 95 |
1033109 | 1033109 | 2021-02-15 | Warren | Pennsylvania | 42123 | 2107 | 95 |
1029863 | 1029863 | 2021-02-14 | Warren | Pennsylvania | 42123 | 2105 | 95 |
1026616 | 1026616 | 2021-02-13 | Warren | Pennsylvania | 42123 | 2103 | 95 |
1023371 | 1023371 | 2021-02-12 | Warren | Pennsylvania | 42123 | 2091 | 95 |
1020126 | 1020126 | 2021-02-11 | Warren | Pennsylvania | 42123 | 2089 | 95 |
1016881 | 1016881 | 2021-02-10 | Warren | Pennsylvania | 42123 | 2086 | 95 |
1013636 | 1013636 | 2021-02-09 | Warren | Pennsylvania | 42123 | 2075 | 95 |
1010391 | 1010391 | 2021-02-08 | Warren | Pennsylvania | 42123 | 2072 | 95 |
1007145 | 1007145 | 2021-02-07 | Warren | Pennsylvania | 42123 | 2069 | 95 |
1003899 | 1003899 | 2021-02-06 | Warren | Pennsylvania | 42123 | 2054 | 95 |
1000653 | 1000653 | 2021-02-05 | Warren | Pennsylvania | 42123 | 2048 | 95 |
997407 | 997407 | 2021-02-04 | Warren | Pennsylvania | 42123 | 2045 | 95 |
994161 | 994161 | 2021-02-03 | Warren | Pennsylvania | 42123 | 2040 | 92 |
990915 | 990915 | 2021-02-02 | Warren | Pennsylvania | 42123 | 2035 | 92 |
987669 | 987669 | 2021-02-01 | Warren | Pennsylvania | 42123 | 2027 | 92 |
984422 | 984422 | 2021-01-31 | Warren | Pennsylvania | 42123 | 2021 | 91 |
981175 | 981175 | 2021-01-30 | Warren | Pennsylvania | 42123 | 2019 | 90 |
977929 | 977929 | 2021-01-29 | Warren | Pennsylvania | 42123 | 1981 | 88 |
974684 | 974684 | 2021-01-28 | Warren | Pennsylvania | 42123 | 1976 | 88 |
971439 | 971439 | 2021-01-27 | Warren | Pennsylvania | 42123 | 1970 | 85 |
968194 | 968194 | 2021-01-26 | Warren | Pennsylvania | 42123 | 1959 | 82 |
964950 | 964950 | 2021-01-25 | Warren | Pennsylvania | 42123 | 1952 | 81 |
961705 | 961705 | 2021-01-24 | Warren | Pennsylvania | 42123 | 1942 | 81 |
958460 | 958460 | 2021-01-23 | Warren | Pennsylvania | 42123 | 1933 | 81 |
955214 | 955214 | 2021-01-22 | Warren | Pennsylvania | 42123 | 1921 | 80 |
951969 | 951969 | 2021-01-21 | Warren | Pennsylvania | 42123 | 1906 | 78 |
948724 | 948724 | 2021-01-20 | Warren | Pennsylvania | 42123 | 1889 | 75 |
945478 | 945478 | 2021-01-19 | Warren | Pennsylvania | 42123 | 1872 | 73 |
942231 | 942231 | 2021-01-18 | Warren | Pennsylvania | 42123 | 1869 | 73 |
938986 | 938986 | 2021-01-17 | Warren | Pennsylvania | 42123 | 1849 | 70 |
935741 | 935741 | 2021-01-16 | Warren | Pennsylvania | 42123 | 1845 | 69 |
932496 | 932496 | 2021-01-15 | Warren | Pennsylvania | 42123 | 1839 | 68 |
929251 | 929251 | 2021-01-14 | Warren | Pennsylvania | 42123 | 1828 | 65 |
926006 | 926006 | 2021-01-13 | Warren | Pennsylvania | 42123 | 1813 | 63 |
922760 | 922760 | 2021-01-12 | Warren | Pennsylvania | 42123 | 1787 | 56 |
919515 | 919515 | 2021-01-11 | Warren | Pennsylvania | 42123 | 1773 | 53 |
916270 | 916270 | 2021-01-10 | Warren | Pennsylvania | 42123 | 1755 | 53 |
913025 | 913025 | 2021-01-09 | Warren | Pennsylvania | 42123 | 1751 | 52 |
909780 | 909780 | 2021-01-08 | Warren | Pennsylvania | 42123 | 1707 | 51 |
906535 | 906535 | 2021-01-07 | Warren | Pennsylvania | 42123 | 1677 | 46 |
903289 | 903289 | 2021-01-06 | Warren | Pennsylvania | 42123 | 1661 | 45 |
900044 | 900044 | 2021-01-05 | Warren | Pennsylvania | 42123 | 1636 | 40 |
896799 | 896799 | 2021-01-04 | Warren | Pennsylvania | 42123 | 1586 | 37 |
893553 | 893553 | 2021-01-03 | Warren | Pennsylvania | 42123 | 1577 | 36 |
890307 | 890307 | 2021-01-02 | Warren | Pennsylvania | 42123 | 1560 | 36 |
887060 | 887060 | 2021-01-01 | Warren | Pennsylvania | 42123 | 1531 | 36 |
883815 | 883815 | 2020-12-31 | Warren | Pennsylvania | 42123 | 1474 | 28 |
880570 | 880570 | 2020-12-30 | Warren | Pennsylvania | 42123 | 1460 | 26 |
877325 | 877325 | 2020-12-29 | Warren | Pennsylvania | 42123 | 1425 | 25 |
874080 | 874080 | 2020-12-28 | Warren | Pennsylvania | 42123 | 1372 | 25 |
870835 | 870835 | 2020-12-27 | Warren | Pennsylvania | 42123 | 1347 | 24 |
867590 | 867590 | 2020-12-26 | Warren | Pennsylvania | 42123 | 1325 | 23 |
864345 | 864345 | 2020-12-25 | Warren | Pennsylvania | 42123 | 1293 | 23 |
861100 | 861100 | 2020-12-24 | Warren | Pennsylvania | 42123 | 1268 | 23 |
857855 | 857855 | 2020-12-23 | Warren | Pennsylvania | 42123 | 1249 | 21 |
854610 | 854610 | 2020-12-22 | Warren | Pennsylvania | 42123 | 1223 | 19 |
851365 | 851365 | 2020-12-21 | Warren | Pennsylvania | 42123 | 1147 | 15 |
848120 | 848120 | 2020-12-20 | Warren | Pennsylvania | 42123 | 1037 | 15 |
844875 | 844875 | 2020-12-19 | Warren | Pennsylvania | 42123 | 1032 | 15 |
841629 | 841629 | 2020-12-18 | Warren | Pennsylvania | 42123 | 968 | 10 |
838384 | 838384 | 2020-12-17 | Warren | Pennsylvania | 42123 | 956 | 7 |
835138 | 835138 | 2020-12-16 | Warren | Pennsylvania | 42123 | 888 | 6 |
831892 | 831892 | 2020-12-15 | Warren | Pennsylvania | 42123 | 852 | 5 |
828645 | 828645 | 2020-12-14 | Warren | Pennsylvania | 42123 | 824 | 5 |
825399 | 825399 | 2020-12-13 | Warren | Pennsylvania | 42123 | 781 | 5 |
822152 | 822152 | 2020-12-12 | Warren | Pennsylvania | 42123 | 755 | 5 |
818906 | 818906 | 2020-12-11 | Warren | Pennsylvania | 42123 | 718 | 3 |
815660 | 815660 | 2020-12-10 | Warren | Pennsylvania | 42123 | 685 | 2 |
812414 | 812414 | 2020-12-09 | Warren | Pennsylvania | 42123 | 630 | 2 |
809170 | 809170 | 2020-12-08 | Warren | Pennsylvania | 42123 | 568 | 2 |
805925 | 805925 | 2020-12-07 | Warren | Pennsylvania | 42123 | 498 | 2 |
802680 | 802680 | 2020-12-06 | Warren | Pennsylvania | 42123 | 440 | 1 |
799435 | 799435 | 2020-12-05 | Warren | Pennsylvania | 42123 | 412 | 1 |
796190 | 796190 | 2020-12-04 | Warren | Pennsylvania | 42123 | 382 | 1 |
792945 | 792945 | 2020-12-03 | Warren | Pennsylvania | 42123 | 369 | 1 |
789700 | 789700 | 2020-12-02 | Warren | Pennsylvania | 42123 | 333 | 1 |
786455 | 786455 | 2020-12-01 | Warren | Pennsylvania | 42123 | 303 | 1 |
783211 | 783211 | 2020-11-30 | Warren | Pennsylvania | 42123 | 267 | 1 |
779966 | 779966 | 2020-11-29 | Warren | Pennsylvania | 42123 | 257 | 1 |
776720 | 776720 | 2020-11-28 | Warren | Pennsylvania | 42123 | 250 | 1 |
773475 | 773475 | 2020-11-27 | Warren | Pennsylvania | 42123 | 231 | 1 |
770230 | 770230 | 2020-11-26 | Warren | Pennsylvania | 42123 | 219 | 1 |
766984 | 766984 | 2020-11-25 | Warren | Pennsylvania | 42123 | 194 | 1 |
763739 | 763739 | 2020-11-24 | Warren | Pennsylvania | 42123 | 172 | 1 |
760494 | 760494 | 2020-11-23 | Warren | Pennsylvania | 42123 | 165 | 1 |
757249 | 757249 | 2020-11-22 | Warren | Pennsylvania | 42123 | 163 | 1 |
754002 | 754002 | 2020-11-21 | Warren | Pennsylvania | 42123 | 154 | 1 |
750756 | 750756 | 2020-11-20 | Warren | Pennsylvania | 42123 | 154 | 1 |
747510 | 747510 | 2020-11-19 | Warren | Pennsylvania | 42123 | 132 | 1 |
744264 | 744264 | 2020-11-18 | Warren | Pennsylvania | 42123 | 124 | 1 |
741017 | 741017 | 2020-11-17 | Warren | Pennsylvania | 42123 | 118 | 1 |
737771 | 737771 | 2020-11-16 | Warren | Pennsylvania | 42123 | 111 | 1 |
734527 | 734527 | 2020-11-15 | Warren | Pennsylvania | 42123 | 111 | 1 |
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);