ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Philadelphia" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055818 | 1055818 | 2021-02-22 | Philadelphia | Pennsylvania | 42101 | 116726 | 3089 |
1052572 | 1052572 | 2021-02-21 | Philadelphia | Pennsylvania | 42101 | 116242 | 3087 |
1049325 | 1049325 | 2021-02-20 | Philadelphia | Pennsylvania | 42101 | 116242 | 3085 |
1046078 | 1046078 | 2021-02-19 | Philadelphia | Pennsylvania | 42101 | 116242 | 3071 |
1042833 | 1042833 | 2021-02-18 | Philadelphia | Pennsylvania | 42101 | 115944 | 3065 |
1039588 | 1039588 | 2021-02-17 | Philadelphia | Pennsylvania | 42101 | 115560 | 3051 |
1036343 | 1036343 | 2021-02-16 | Philadelphia | Pennsylvania | 42101 | 115018 | 3029 |
1033098 | 1033098 | 2021-02-15 | Philadelphia | Pennsylvania | 42101 | 114308 | 3029 |
1029852 | 1029852 | 2021-02-14 | Philadelphia | Pennsylvania | 42101 | 114308 | 3028 |
1026605 | 1026605 | 2021-02-13 | Philadelphia | Pennsylvania | 42101 | 114308 | 3026 |
1023360 | 1023360 | 2021-02-12 | Philadelphia | Pennsylvania | 42101 | 114308 | 3010 |
1020115 | 1020115 | 2021-02-11 | Philadelphia | Pennsylvania | 42101 | 113878 | 3001 |
1016870 | 1016870 | 2021-02-10 | Philadelphia | Pennsylvania | 42101 | 113519 | 2988 |
1013625 | 1013625 | 2021-02-09 | Philadelphia | Pennsylvania | 42101 | 113224 | 2978 |
1010380 | 1010380 | 2021-02-08 | Philadelphia | Pennsylvania | 42101 | 112652 | 2963 |
1007134 | 1007134 | 2021-02-07 | Philadelphia | Pennsylvania | 42101 | 111750 | 2971 |
1003888 | 1003888 | 2021-02-06 | Philadelphia | Pennsylvania | 42101 | 111750 | 2964 |
1000642 | 1000642 | 2021-02-05 | Philadelphia | Pennsylvania | 42101 | 111750 | 2957 |
997396 | 997396 | 2021-02-04 | Philadelphia | Pennsylvania | 42101 | 111411 | 2949 |
994150 | 994150 | 2021-02-03 | Philadelphia | Pennsylvania | 42101 | 111098 | 2935 |
990904 | 990904 | 2021-02-02 | Philadelphia | Pennsylvania | 42101 | 110793 | 2920 |
987658 | 987658 | 2021-02-01 | Philadelphia | Pennsylvania | 42101 | 110272 | 2909 |
984411 | 984411 | 2021-01-31 | Philadelphia | Pennsylvania | 42101 | 109231 | 2908 |
981164 | 981164 | 2021-01-30 | Philadelphia | Pennsylvania | 42101 | 109231 | 2905 |
977918 | 977918 | 2021-01-29 | Philadelphia | Pennsylvania | 42101 | 109231 | 2892 |
974673 | 974673 | 2021-01-28 | Philadelphia | Pennsylvania | 42101 | 108760 | 2879 |
971428 | 971428 | 2021-01-27 | Philadelphia | Pennsylvania | 42101 | 108222 | 2856 |
968183 | 968183 | 2021-01-26 | Philadelphia | Pennsylvania | 42101 | 107863 | 2842 |
964939 | 964939 | 2021-01-25 | Philadelphia | Pennsylvania | 42101 | 107177 | 2826 |
961694 | 961694 | 2021-01-24 | Philadelphia | Pennsylvania | 42101 | 106132 | 2822 |
958449 | 958449 | 2021-01-23 | Philadelphia | Pennsylvania | 42101 | 106132 | 2817 |
955203 | 955203 | 2021-01-22 | Philadelphia | Pennsylvania | 42101 | 106132 | 2798 |
951958 | 951958 | 2021-01-21 | Philadelphia | Pennsylvania | 42101 | 105713 | 2779 |
948713 | 948713 | 2021-01-20 | Philadelphia | Pennsylvania | 42101 | 105177 | 2758 |
945467 | 945467 | 2021-01-19 | Philadelphia | Pennsylvania | 42101 | 104648 | 2732 |
942220 | 942220 | 2021-01-18 | Philadelphia | Pennsylvania | 42101 | 102837 | 2731 |
938975 | 938975 | 2021-01-17 | Philadelphia | Pennsylvania | 42101 | 102837 | 2727 |
935730 | 935730 | 2021-01-16 | Philadelphia | Pennsylvania | 42101 | 102837 | 2723 |
932485 | 932485 | 2021-01-15 | Philadelphia | Pennsylvania | 42101 | 102837 | 2722 |
929240 | 929240 | 2021-01-14 | Philadelphia | Pennsylvania | 42101 | 102168 | 2693 |
925995 | 925995 | 2021-01-13 | Philadelphia | Pennsylvania | 42101 | 101582 | 2671 |
922749 | 922749 | 2021-01-12 | Philadelphia | Pennsylvania | 42101 | 100910 | 2645 |
919504 | 919504 | 2021-01-11 | Philadelphia | Pennsylvania | 42101 | 100092 | 2621 |
916259 | 916259 | 2021-01-10 | Philadelphia | Pennsylvania | 42101 | 98541 | 2617 |
913014 | 913014 | 2021-01-09 | Philadelphia | Pennsylvania | 42101 | 98541 | 2607 |
909769 | 909769 | 2021-01-08 | Philadelphia | Pennsylvania | 42101 | 98541 | 2599 |
906524 | 906524 | 2021-01-07 | Philadelphia | Pennsylvania | 42101 | 97891 | 2576 |
903278 | 903278 | 2021-01-06 | Philadelphia | Pennsylvania | 42101 | 97099 | 2553 |
900033 | 900033 | 2021-01-05 | Philadelphia | Pennsylvania | 42101 | 96419 | 2524 |
896788 | 896788 | 2021-01-04 | Philadelphia | Pennsylvania | 42101 | 95503 | 2502 |
893542 | 893542 | 2021-01-03 | Philadelphia | Pennsylvania | 42101 | 93885 | 2498 |
890296 | 890296 | 2021-01-02 | Philadelphia | Pennsylvania | 42101 | 93885 | 2493 |
887049 | 887049 | 2021-01-01 | Philadelphia | Pennsylvania | 42101 | 93885 | 2493 |
883804 | 883804 | 2020-12-31 | Philadelphia | Pennsylvania | 42101 | 93885 | 2473 |
880559 | 880559 | 2020-12-30 | Philadelphia | Pennsylvania | 42101 | 92706 | 2440 |
877314 | 877314 | 2020-12-29 | Philadelphia | Pennsylvania | 42101 | 92354 | 2409 |
874069 | 874069 | 2020-12-28 | Philadelphia | Pennsylvania | 42101 | 91429 | 2390 |
870824 | 870824 | 2020-12-27 | Philadelphia | Pennsylvania | 42101 | 89887 | 2388 |
867579 | 867579 | 2020-12-26 | Philadelphia | Pennsylvania | 42101 | 89887 | 2378 |
864334 | 864334 | 2020-12-25 | Philadelphia | Pennsylvania | 42101 | 89887 | 2378 |
861089 | 861089 | 2020-12-24 | Philadelphia | Pennsylvania | 42101 | 89887 | 2369 |
857844 | 857844 | 2020-12-23 | Philadelphia | Pennsylvania | 42101 | 89164 | 2348 |
854599 | 854599 | 2020-12-22 | Philadelphia | Pennsylvania | 42101 | 88420 | 2327 |
851354 | 851354 | 2020-12-21 | Philadelphia | Pennsylvania | 42101 | 87395 | 2317 |
848109 | 848109 | 2020-12-20 | Philadelphia | Pennsylvania | 42101 | 85733 | 2310 |
844864 | 844864 | 2020-12-19 | Philadelphia | Pennsylvania | 42101 | 85733 | 2294 |
841618 | 841618 | 2020-12-18 | Philadelphia | Pennsylvania | 42101 | 85733 | 2283 |
838373 | 838373 | 2020-12-17 | Philadelphia | Pennsylvania | 42101 | 85033 | 2270 |
835127 | 835127 | 2020-12-16 | Philadelphia | Pennsylvania | 42101 | 84061 | 2254 |
831881 | 831881 | 2020-12-15 | Philadelphia | Pennsylvania | 42101 | 83113 | 2236 |
828634 | 828634 | 2020-12-14 | Philadelphia | Pennsylvania | 42101 | 81779 | 2207 |
825388 | 825388 | 2020-12-13 | Philadelphia | Pennsylvania | 42101 | 79646 | 2206 |
822141 | 822141 | 2020-12-12 | Philadelphia | Pennsylvania | 42101 | 79646 | 2197 |
818895 | 818895 | 2020-12-11 | Philadelphia | Pennsylvania | 42101 | 79646 | 2185 |
815649 | 815649 | 2020-12-10 | Philadelphia | Pennsylvania | 42101 | 78565 | 2166 |
812403 | 812403 | 2020-12-09 | Philadelphia | Pennsylvania | 42101 | 77601 | 2149 |
809159 | 809159 | 2020-12-08 | Philadelphia | Pennsylvania | 42101 | 76589 | 2127 |
805914 | 805914 | 2020-12-07 | Philadelphia | Pennsylvania | 42101 | 75073 | 2111 |
802669 | 802669 | 2020-12-06 | Philadelphia | Pennsylvania | 42101 | 72314 | 2109 |
799424 | 799424 | 2020-12-05 | Philadelphia | Pennsylvania | 42101 | 72314 | 2106 |
796179 | 796179 | 2020-12-04 | Philadelphia | Pennsylvania | 42101 | 72314 | 2099 |
792934 | 792934 | 2020-12-03 | Philadelphia | Pennsylvania | 42101 | 70476 | 2083 |
789689 | 789689 | 2020-12-02 | Philadelphia | Pennsylvania | 42101 | 69630 | 2065 |
786444 | 786444 | 2020-12-01 | Philadelphia | Pennsylvania | 42101 | 67943 | 2042 |
783200 | 783200 | 2020-11-30 | Philadelphia | Pennsylvania | 42101 | 67283 | 2026 |
779955 | 779955 | 2020-11-29 | Philadelphia | Pennsylvania | 42101 | 65484 | 2026 |
776709 | 776709 | 2020-11-28 | Philadelphia | Pennsylvania | 42101 | 65484 | 2015 |
773464 | 773464 | 2020-11-27 | Philadelphia | Pennsylvania | 42101 | 65484 | 2013 |
770219 | 770219 | 2020-11-26 | Philadelphia | Pennsylvania | 42101 | 63862 | 2012 |
766973 | 766973 | 2020-11-25 | Philadelphia | Pennsylvania | 42101 | 63862 | 1998 |
763728 | 763728 | 2020-11-24 | Philadelphia | Pennsylvania | 42101 | 62620 | 1989 |
760483 | 760483 | 2020-11-23 | Philadelphia | Pennsylvania | 42101 | 61498 | 1980 |
757238 | 757238 | 2020-11-22 | Philadelphia | Pennsylvania | 42101 | 59081 | 1979 |
753991 | 753991 | 2020-11-21 | Philadelphia | Pennsylvania | 42101 | 59081 | 1978 |
750745 | 750745 | 2020-11-20 | Philadelphia | Pennsylvania | 42101 | 59081 | 1968 |
747499 | 747499 | 2020-11-19 | Philadelphia | Pennsylvania | 42101 | 58012 | 1961 |
744253 | 744253 | 2020-11-18 | Philadelphia | Pennsylvania | 42101 | 57201 | 1951 |
741006 | 741006 | 2020-11-17 | Philadelphia | Pennsylvania | 42101 | 56372 | 1939 |
737760 | 737760 | 2020-11-16 | Philadelphia | Pennsylvania | 42101 | 55302 | 1935 |
734516 | 734516 | 2020-11-15 | Philadelphia | Pennsylvania | 42101 | 52723 | 1934 |
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);