ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Delaware" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055790 | 1055790 | 2021-02-22 | Delaware | Pennsylvania | 42045 | 40132 | 1261 |
1052544 | 1052544 | 2021-02-21 | Delaware | Pennsylvania | 42045 | 40052 | 1261 |
1049297 | 1049297 | 2021-02-20 | Delaware | Pennsylvania | 42045 | 39983 | 1261 |
1046050 | 1046050 | 2021-02-19 | Delaware | Pennsylvania | 42045 | 39905 | 1261 |
1042805 | 1042805 | 2021-02-18 | Delaware | Pennsylvania | 42045 | 39778 | 1250 |
1039560 | 1039560 | 2021-02-17 | Delaware | Pennsylvania | 42045 | 39642 | 1250 |
1036315 | 1036315 | 2021-02-16 | Delaware | Pennsylvania | 42045 | 39479 | 1238 |
1033070 | 1033070 | 2021-02-15 | Delaware | Pennsylvania | 42045 | 39393 | 1236 |
1029824 | 1029824 | 2021-02-14 | Delaware | Pennsylvania | 42045 | 39312 | 1236 |
1026577 | 1026577 | 2021-02-13 | Delaware | Pennsylvania | 42045 | 39222 | 1236 |
1023332 | 1023332 | 2021-02-12 | Delaware | Pennsylvania | 42045 | 39041 | 1236 |
1020087 | 1020087 | 2021-02-11 | Delaware | Pennsylvania | 42045 | 38901 | 1232 |
1016842 | 1016842 | 2021-02-10 | Delaware | Pennsylvania | 42045 | 38751 | 1230 |
1013597 | 1013597 | 2021-02-09 | Delaware | Pennsylvania | 42045 | 38616 | 1213 |
1010352 | 1010352 | 2021-02-08 | Delaware | Pennsylvania | 42045 | 38461 | 1199 |
1007106 | 1007106 | 2021-02-07 | Delaware | Pennsylvania | 42045 | 38324 | 1199 |
1003860 | 1003860 | 2021-02-06 | Delaware | Pennsylvania | 42045 | 38137 | 1199 |
1000614 | 1000614 | 2021-02-05 | Delaware | Pennsylvania | 42045 | 37983 | 1199 |
997368 | 997368 | 2021-02-04 | Delaware | Pennsylvania | 42045 | 37868 | 1199 |
994122 | 994122 | 2021-02-03 | Delaware | Pennsylvania | 42045 | 37727 | 1200 |
990876 | 990876 | 2021-02-02 | Delaware | Pennsylvania | 42045 | 37617 | 1192 |
987630 | 987630 | 2021-02-01 | Delaware | Pennsylvania | 42045 | 37443 | 1190 |
984383 | 984383 | 2021-01-31 | Delaware | Pennsylvania | 42045 | 37339 | 1190 |
981136 | 981136 | 2021-01-30 | Delaware | Pennsylvania | 42045 | 37190 | 1190 |
977890 | 977890 | 2021-01-29 | Delaware | Pennsylvania | 42045 | 37027 | 1190 |
974645 | 974645 | 2021-01-28 | Delaware | Pennsylvania | 42045 | 36636 | 1170 |
971400 | 971400 | 2021-01-27 | Delaware | Pennsylvania | 42045 | 36447 | 1116 |
968155 | 968155 | 2021-01-26 | Delaware | Pennsylvania | 42045 | 36252 | 1110 |
964911 | 964911 | 2021-01-25 | Delaware | Pennsylvania | 42045 | 36048 | 1104 |
961666 | 961666 | 2021-01-24 | Delaware | Pennsylvania | 42045 | 35855 | 1103 |
958421 | 958421 | 2021-01-23 | Delaware | Pennsylvania | 42045 | 35642 | 1103 |
955175 | 955175 | 2021-01-22 | Delaware | Pennsylvania | 42045 | 35351 | 1097 |
951930 | 951930 | 2021-01-21 | Delaware | Pennsylvania | 42045 | 35169 | 1090 |
948685 | 948685 | 2021-01-20 | Delaware | Pennsylvania | 42045 | 34955 | 1080 |
945439 | 945439 | 2021-01-19 | Delaware | Pennsylvania | 42045 | 34717 | 1062 |
942192 | 942192 | 2021-01-18 | Delaware | Pennsylvania | 42045 | 34536 | 1059 |
938947 | 938947 | 2021-01-17 | Delaware | Pennsylvania | 42045 | 34398 | 1057 |
935702 | 935702 | 2021-01-16 | Delaware | Pennsylvania | 42045 | 34188 | 1053 |
932457 | 932457 | 2021-01-15 | Delaware | Pennsylvania | 42045 | 33933 | 1053 |
929212 | 929212 | 2021-01-14 | Delaware | Pennsylvania | 42045 | 33696 | 1049 |
925967 | 925967 | 2021-01-13 | Delaware | Pennsylvania | 42045 | 33407 | 1049 |
922721 | 922721 | 2021-01-12 | Delaware | Pennsylvania | 42045 | 33132 | 1024 |
919476 | 919476 | 2021-01-11 | Delaware | Pennsylvania | 42045 | 32836 | 1024 |
916231 | 916231 | 2021-01-10 | Delaware | Pennsylvania | 42045 | 32640 | 1023 |
912986 | 912986 | 2021-01-09 | Delaware | Pennsylvania | 42045 | 32337 | 1023 |
909741 | 909741 | 2021-01-08 | Delaware | Pennsylvania | 42045 | 32008 | 1023 |
906496 | 906496 | 2021-01-07 | Delaware | Pennsylvania | 42045 | 31675 | 1022 |
903250 | 903250 | 2021-01-06 | Delaware | Pennsylvania | 42045 | 31063 | 1016 |
900005 | 900005 | 2021-01-05 | Delaware | Pennsylvania | 42045 | 30786 | 1000 |
896760 | 896760 | 2021-01-04 | Delaware | Pennsylvania | 42045 | 30443 | 999 |
893514 | 893514 | 2021-01-03 | Delaware | Pennsylvania | 42045 | 30337 | 993 |
890268 | 890268 | 2021-01-02 | Delaware | Pennsylvania | 42045 | 30182 | 993 |
887021 | 887021 | 2021-01-01 | Delaware | Pennsylvania | 42045 | 29944 | 993 |
883776 | 883776 | 2020-12-31 | Delaware | Pennsylvania | 42045 | 29745 | 993 |
880531 | 880531 | 2020-12-30 | Delaware | Pennsylvania | 42045 | 29371 | 990 |
877286 | 877286 | 2020-12-29 | Delaware | Pennsylvania | 42045 | 28738 | 973 |
874041 | 874041 | 2020-12-28 | Delaware | Pennsylvania | 42045 | 28406 | 956 |
870796 | 870796 | 2020-12-27 | Delaware | Pennsylvania | 42045 | 28182 | 954 |
867551 | 867551 | 2020-12-26 | Delaware | Pennsylvania | 42045 | 27991 | 954 |
864306 | 864306 | 2020-12-25 | Delaware | Pennsylvania | 42045 | 27736 | 954 |
861061 | 861061 | 2020-12-24 | Delaware | Pennsylvania | 42045 | 27515 | 954 |
857816 | 857816 | 2020-12-23 | Delaware | Pennsylvania | 42045 | 27168 | 933 |
854571 | 854571 | 2020-12-22 | Delaware | Pennsylvania | 42045 | 26905 | 929 |
851326 | 851326 | 2020-12-21 | Delaware | Pennsylvania | 42045 | 26639 | 928 |
848081 | 848081 | 2020-12-20 | Delaware | Pennsylvania | 42045 | 26299 | 925 |
844836 | 844836 | 2020-12-19 | Delaware | Pennsylvania | 42045 | 26061 | 925 |
841590 | 841590 | 2020-12-18 | Delaware | Pennsylvania | 42045 | 25757 | 925 |
838345 | 838345 | 2020-12-17 | Delaware | Pennsylvania | 42045 | 25450 | 915 |
835099 | 835099 | 2020-12-16 | Delaware | Pennsylvania | 42045 | 25218 | 897 |
831853 | 831853 | 2020-12-15 | Delaware | Pennsylvania | 42045 | 24917 | 896 |
828606 | 828606 | 2020-12-14 | Delaware | Pennsylvania | 42045 | 24627 | 895 |
825360 | 825360 | 2020-12-13 | Delaware | Pennsylvania | 42045 | 24420 | 895 |
822113 | 822113 | 2020-12-12 | Delaware | Pennsylvania | 42045 | 24126 | 895 |
818867 | 818867 | 2020-12-11 | Delaware | Pennsylvania | 42045 | 23810 | 895 |
815621 | 815621 | 2020-12-10 | Delaware | Pennsylvania | 42045 | 23408 | 888 |
812375 | 812375 | 2020-12-09 | Delaware | Pennsylvania | 42045 | 23010 | 888 |
809131 | 809131 | 2020-12-08 | Delaware | Pennsylvania | 42045 | 22761 | 873 |
805886 | 805886 | 2020-12-07 | Delaware | Pennsylvania | 42045 | 22470 | 874 |
802641 | 802641 | 2020-12-06 | Delaware | Pennsylvania | 42045 | 22258 | 873 |
799396 | 799396 | 2020-12-05 | Delaware | Pennsylvania | 42045 | 21953 | 873 |
796151 | 796151 | 2020-12-04 | Delaware | Pennsylvania | 42045 | 21560 | 873 |
792906 | 792906 | 2020-12-03 | Delaware | Pennsylvania | 42045 | 21211 | 867 |
789661 | 789661 | 2020-12-02 | Delaware | Pennsylvania | 42045 | 20762 | 852 |
786416 | 786416 | 2020-12-01 | Delaware | Pennsylvania | 42045 | 20364 | 852 |
783172 | 783172 | 2020-11-30 | Delaware | Pennsylvania | 42045 | 20166 | 850 |
779927 | 779927 | 2020-11-29 | Delaware | Pennsylvania | 42045 | 20057 | 850 |
776681 | 776681 | 2020-11-28 | Delaware | Pennsylvania | 42045 | 19877 | 850 |
773436 | 773436 | 2020-11-27 | Delaware | Pennsylvania | 42045 | 19649 | 850 |
770191 | 770191 | 2020-11-26 | Delaware | Pennsylvania | 42045 | 19401 | 849 |
766945 | 766945 | 2020-11-25 | Delaware | Pennsylvania | 42045 | 19019 | 849 |
763700 | 763700 | 2020-11-24 | Delaware | Pennsylvania | 42045 | 18829 | 844 |
760455 | 760455 | 2020-11-23 | Delaware | Pennsylvania | 42045 | 18604 | 842 |
757210 | 757210 | 2020-11-22 | Delaware | Pennsylvania | 42045 | 18404 | 838 |
753963 | 753963 | 2020-11-21 | Delaware | Pennsylvania | 42045 | 18172 | 838 |
750717 | 750717 | 2020-11-20 | Delaware | Pennsylvania | 42045 | 17899 | 838 |
747471 | 747471 | 2020-11-19 | Delaware | Pennsylvania | 42045 | 17625 | 836 |
744225 | 744225 | 2020-11-18 | Delaware | Pennsylvania | 42045 | 17294 | 836 |
740978 | 740978 | 2020-11-17 | Delaware | Pennsylvania | 42045 | 16963 | 833 |
737732 | 737732 | 2020-11-16 | Delaware | Pennsylvania | 42045 | 16736 | 831 |
734488 | 734488 | 2020-11-15 | Delaware | Pennsylvania | 42045 | 16595 | 831 |
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);