ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Wayne" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055831 | 1055831 | 2021-02-22 | Wayne | Pennsylvania | 42127 | 2967 | 65 |
1052585 | 1052585 | 2021-02-21 | Wayne | Pennsylvania | 42127 | 2965 | 65 |
1049338 | 1049338 | 2021-02-20 | Wayne | Pennsylvania | 42127 | 2954 | 65 |
1046091 | 1046091 | 2021-02-19 | Wayne | Pennsylvania | 42127 | 2948 | 64 |
1042846 | 1042846 | 2021-02-18 | Wayne | Pennsylvania | 42127 | 2925 | 64 |
1039601 | 1039601 | 2021-02-17 | Wayne | Pennsylvania | 42127 | 2914 | 63 |
1036356 | 1036356 | 2021-02-16 | Wayne | Pennsylvania | 42127 | 2902 | 63 |
1033111 | 1033111 | 2021-02-15 | Wayne | Pennsylvania | 42127 | 2892 | 63 |
1029865 | 1029865 | 2021-02-14 | Wayne | Pennsylvania | 42127 | 2892 | 63 |
1026618 | 1026618 | 2021-02-13 | Wayne | Pennsylvania | 42127 | 2873 | 63 |
1023373 | 1023373 | 2021-02-12 | Wayne | Pennsylvania | 42127 | 2864 | 60 |
1020128 | 1020128 | 2021-02-11 | Wayne | Pennsylvania | 42127 | 2848 | 58 |
1016883 | 1016883 | 2021-02-10 | Wayne | Pennsylvania | 42127 | 2837 | 58 |
1013638 | 1013638 | 2021-02-09 | Wayne | Pennsylvania | 42127 | 2825 | 56 |
1010393 | 1010393 | 2021-02-08 | Wayne | Pennsylvania | 42127 | 2818 | 55 |
1007147 | 1007147 | 2021-02-07 | Wayne | Pennsylvania | 42127 | 2810 | 55 |
1003901 | 1003901 | 2021-02-06 | Wayne | Pennsylvania | 42127 | 2787 | 55 |
1000655 | 1000655 | 2021-02-05 | Wayne | Pennsylvania | 42127 | 2764 | 53 |
997409 | 997409 | 2021-02-04 | Wayne | Pennsylvania | 42127 | 2750 | 50 |
994163 | 994163 | 2021-02-03 | Wayne | Pennsylvania | 42127 | 2746 | 48 |
990917 | 990917 | 2021-02-02 | Wayne | Pennsylvania | 42127 | 2740 | 48 |
987671 | 987671 | 2021-02-01 | Wayne | Pennsylvania | 42127 | 2714 | 47 |
984424 | 984424 | 2021-01-31 | Wayne | Pennsylvania | 42127 | 2676 | 47 |
981177 | 981177 | 2021-01-30 | Wayne | Pennsylvania | 42127 | 2662 | 46 |
977931 | 977931 | 2021-01-29 | Wayne | Pennsylvania | 42127 | 2640 | 46 |
974686 | 974686 | 2021-01-28 | Wayne | Pennsylvania | 42127 | 2616 | 44 |
971441 | 971441 | 2021-01-27 | Wayne | Pennsylvania | 42127 | 2600 | 42 |
968196 | 968196 | 2021-01-26 | Wayne | Pennsylvania | 42127 | 2578 | 40 |
964952 | 964952 | 2021-01-25 | Wayne | Pennsylvania | 42127 | 2567 | 39 |
961707 | 961707 | 2021-01-24 | Wayne | Pennsylvania | 42127 | 2552 | 39 |
958462 | 958462 | 2021-01-23 | Wayne | Pennsylvania | 42127 | 2539 | 39 |
955216 | 955216 | 2021-01-22 | Wayne | Pennsylvania | 42127 | 2525 | 39 |
951971 | 951971 | 2021-01-21 | Wayne | Pennsylvania | 42127 | 2503 | 39 |
948726 | 948726 | 2021-01-20 | Wayne | Pennsylvania | 42127 | 2486 | 39 |
945480 | 945480 | 2021-01-19 | Wayne | Pennsylvania | 42127 | 2467 | 36 |
942233 | 942233 | 2021-01-18 | Wayne | Pennsylvania | 42127 | 2446 | 36 |
938988 | 938988 | 2021-01-17 | Wayne | Pennsylvania | 42127 | 2432 | 35 |
935743 | 935743 | 2021-01-16 | Wayne | Pennsylvania | 42127 | 2414 | 35 |
932498 | 932498 | 2021-01-15 | Wayne | Pennsylvania | 42127 | 2370 | 34 |
929253 | 929253 | 2021-01-14 | Wayne | Pennsylvania | 42127 | 2349 | 33 |
926008 | 926008 | 2021-01-13 | Wayne | Pennsylvania | 42127 | 2308 | 30 |
922762 | 922762 | 2021-01-12 | Wayne | Pennsylvania | 42127 | 2281 | 28 |
919517 | 919517 | 2021-01-11 | Wayne | Pennsylvania | 42127 | 2257 | 27 |
916272 | 916272 | 2021-01-10 | Wayne | Pennsylvania | 42127 | 2232 | 25 |
913027 | 913027 | 2021-01-09 | Wayne | Pennsylvania | 42127 | 2197 | 24 |
909782 | 909782 | 2021-01-08 | Wayne | Pennsylvania | 42127 | 2167 | 22 |
906537 | 906537 | 2021-01-07 | Wayne | Pennsylvania | 42127 | 2111 | 21 |
903291 | 903291 | 2021-01-06 | Wayne | Pennsylvania | 42127 | 2046 | 19 |
900046 | 900046 | 2021-01-05 | Wayne | Pennsylvania | 42127 | 2029 | 19 |
896801 | 896801 | 2021-01-04 | Wayne | Pennsylvania | 42127 | 1971 | 18 |
893555 | 893555 | 2021-01-03 | Wayne | Pennsylvania | 42127 | 1968 | 18 |
890309 | 890309 | 2021-01-02 | Wayne | Pennsylvania | 42127 | 1951 | 18 |
887062 | 887062 | 2021-01-01 | Wayne | Pennsylvania | 42127 | 1867 | 18 |
883817 | 883817 | 2020-12-31 | Wayne | Pennsylvania | 42127 | 1829 | 18 |
880572 | 880572 | 2020-12-30 | Wayne | Pennsylvania | 42127 | 1796 | 18 |
877327 | 877327 | 2020-12-29 | Wayne | Pennsylvania | 42127 | 1720 | 18 |
874082 | 874082 | 2020-12-28 | Wayne | Pennsylvania | 42127 | 1698 | 17 |
870837 | 870837 | 2020-12-27 | Wayne | Pennsylvania | 42127 | 1689 | 17 |
867592 | 867592 | 2020-12-26 | Wayne | Pennsylvania | 42127 | 1665 | 17 |
864347 | 864347 | 2020-12-25 | Wayne | Pennsylvania | 42127 | 1587 | 17 |
861102 | 861102 | 2020-12-24 | Wayne | Pennsylvania | 42127 | 1504 | 16 |
857857 | 857857 | 2020-12-23 | Wayne | Pennsylvania | 42127 | 1443 | 15 |
854612 | 854612 | 2020-12-22 | Wayne | Pennsylvania | 42127 | 1367 | 15 |
851367 | 851367 | 2020-12-21 | Wayne | Pennsylvania | 42127 | 1358 | 15 |
848122 | 848122 | 2020-12-20 | Wayne | Pennsylvania | 42127 | 1288 | 15 |
844877 | 844877 | 2020-12-19 | Wayne | Pennsylvania | 42127 | 1274 | 15 |
841631 | 841631 | 2020-12-18 | Wayne | Pennsylvania | 42127 | 1241 | 15 |
838386 | 838386 | 2020-12-17 | Wayne | Pennsylvania | 42127 | 1209 | 15 |
835140 | 835140 | 2020-12-16 | Wayne | Pennsylvania | 42127 | 1175 | 15 |
831894 | 831894 | 2020-12-15 | Wayne | Pennsylvania | 42127 | 1092 | 15 |
828647 | 828647 | 2020-12-14 | Wayne | Pennsylvania | 42127 | 1073 | 14 |
825401 | 825401 | 2020-12-13 | Wayne | Pennsylvania | 42127 | 971 | 14 |
822154 | 822154 | 2020-12-12 | Wayne | Pennsylvania | 42127 | 893 | 14 |
818908 | 818908 | 2020-12-11 | Wayne | Pennsylvania | 42127 | 854 | 13 |
815662 | 815662 | 2020-12-10 | Wayne | Pennsylvania | 42127 | 772 | 13 |
812416 | 812416 | 2020-12-09 | Wayne | Pennsylvania | 42127 | 746 | 13 |
809172 | 809172 | 2020-12-08 | Wayne | Pennsylvania | 42127 | 721 | 13 |
805927 | 805927 | 2020-12-07 | Wayne | Pennsylvania | 42127 | 711 | 12 |
802682 | 802682 | 2020-12-06 | Wayne | Pennsylvania | 42127 | 705 | 12 |
799437 | 799437 | 2020-12-05 | Wayne | Pennsylvania | 42127 | 668 | 12 |
796192 | 796192 | 2020-12-04 | Wayne | Pennsylvania | 42127 | 640 | 12 |
792947 | 792947 | 2020-12-03 | Wayne | Pennsylvania | 42127 | 605 | 12 |
789702 | 789702 | 2020-12-02 | Wayne | Pennsylvania | 42127 | 585 | 12 |
786457 | 786457 | 2020-12-01 | Wayne | Pennsylvania | 42127 | 569 | 12 |
783213 | 783213 | 2020-11-30 | Wayne | Pennsylvania | 42127 | 538 | 12 |
779968 | 779968 | 2020-11-29 | Wayne | Pennsylvania | 42127 | 527 | 12 |
776722 | 776722 | 2020-11-28 | Wayne | Pennsylvania | 42127 | 481 | 12 |
773477 | 773477 | 2020-11-27 | Wayne | Pennsylvania | 42127 | 465 | 12 |
770232 | 770232 | 2020-11-26 | Wayne | Pennsylvania | 42127 | 449 | 12 |
766986 | 766986 | 2020-11-25 | Wayne | Pennsylvania | 42127 | 432 | 12 |
763741 | 763741 | 2020-11-24 | Wayne | Pennsylvania | 42127 | 417 | 12 |
760496 | 760496 | 2020-11-23 | Wayne | Pennsylvania | 42127 | 409 | 12 |
757251 | 757251 | 2020-11-22 | Wayne | Pennsylvania | 42127 | 404 | 12 |
754004 | 754004 | 2020-11-21 | Wayne | Pennsylvania | 42127 | 391 | 12 |
750758 | 750758 | 2020-11-20 | Wayne | Pennsylvania | 42127 | 383 | 12 |
747512 | 747512 | 2020-11-19 | Wayne | Pennsylvania | 42127 | 370 | 12 |
744266 | 744266 | 2020-11-18 | Wayne | Pennsylvania | 42127 | 360 | 12 |
741019 | 741019 | 2020-11-17 | Wayne | Pennsylvania | 42127 | 357 | 12 |
737773 | 737773 | 2020-11-16 | Wayne | Pennsylvania | 42127 | 351 | 12 |
734529 | 734529 | 2020-11-15 | Wayne | Pennsylvania | 42127 | 348 | 12 |
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);