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 |
---|---|---|---|---|---|---|---|
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 |
731270 | 731270 | 2020-11-14 | Philadelphia | Pennsylvania | 42101 | 52723 | 1934 |
728026 | 728026 | 2020-11-13 | Philadelphia | Pennsylvania | 42101 | 52723 | 1928 |
724782 | 724782 | 2020-11-12 | Philadelphia | Pennsylvania | 42101 | 51513 | 1920 |
721539 | 721539 | 2020-11-11 | Philadelphia | Pennsylvania | 42101 | 50354 | 1914 |
718296 | 718296 | 2020-11-10 | Philadelphia | Pennsylvania | 42101 | 50354 | 1912 |
715053 | 715053 | 2020-11-09 | Philadelphia | Pennsylvania | 42101 | 49456 | 1909 |
711809 | 711809 | 2020-11-08 | Philadelphia | Pennsylvania | 42101 | 47675 | 1908 |
708565 | 708565 | 2020-11-07 | Philadelphia | Pennsylvania | 42101 | 47675 | 1907 |
705322 | 705322 | 2020-11-06 | Philadelphia | Pennsylvania | 42101 | 47675 | 1905 |
702079 | 702079 | 2020-11-05 | Philadelphia | Pennsylvania | 42101 | 46917 | 1902 |
698835 | 698835 | 2020-11-04 | Philadelphia | Pennsylvania | 42101 | 46489 | 1900 |
695592 | 695592 | 2020-11-03 | Philadelphia | Pennsylvania | 42101 | 46093 | 1897 |
692350 | 692350 | 2020-11-02 | Philadelphia | Pennsylvania | 42101 | 45451 | 1894 |
689106 | 689106 | 2020-11-01 | Philadelphia | Pennsylvania | 42101 | 44505 | 1894 |
685861 | 685861 | 2020-10-31 | Philadelphia | Pennsylvania | 42101 | 44505 | 1892 |
682618 | 682618 | 2020-10-30 | Philadelphia | Pennsylvania | 42101 | 44505 | 1890 |
679375 | 679375 | 2020-10-29 | Philadelphia | Pennsylvania | 42101 | 44139 | 1890 |
676132 | 676132 | 2020-10-28 | Philadelphia | Pennsylvania | 42101 | 43740 | 1882 |
672889 | 672889 | 2020-10-27 | Philadelphia | Pennsylvania | 42101 | 43365 | 1880 |
669647 | 669647 | 2020-10-26 | Philadelphia | Pennsylvania | 42101 | 43003 | 1876 |
666403 | 666403 | 2020-10-25 | Philadelphia | Pennsylvania | 42101 | 41972 | 1875 |
663158 | 663158 | 2020-10-24 | Philadelphia | Pennsylvania | 42101 | 41972 | 1874 |
659914 | 659914 | 2020-10-23 | Philadelphia | Pennsylvania | 42101 | 41972 | 1873 |
656670 | 656670 | 2020-10-22 | Philadelphia | Pennsylvania | 42101 | 41561 | 1871 |
653425 | 653425 | 2020-10-21 | Philadelphia | Pennsylvania | 42101 | 41323 | 1868 |
650180 | 650180 | 2020-10-20 | Philadelphia | Pennsylvania | 42101 | 41094 | 1867 |
646936 | 646936 | 2020-10-19 | Philadelphia | Pennsylvania | 42101 | 40803 | 1867 |
643690 | 643690 | 2020-10-18 | Philadelphia | Pennsylvania | 42101 | 40179 | 1868 |
640442 | 640442 | 2020-10-17 | Philadelphia | Pennsylvania | 42101 | 40179 | 1866 |
637196 | 637196 | 2020-10-16 | Philadelphia | Pennsylvania | 42101 | 40179 | 1865 |
633950 | 633950 | 2020-10-15 | Philadelphia | Pennsylvania | 42101 | 39870 | 1861 |
630705 | 630705 | 2020-10-14 | Philadelphia | Pennsylvania | 42101 | 39691 | 1857 |
627461 | 627461 | 2020-10-13 | Philadelphia | Pennsylvania | 42101 | 39413 | 1856 |
624219 | 624219 | 2020-10-12 | Philadelphia | Pennsylvania | 42101 | 38767 | 1855 |
620976 | 620976 | 2020-10-11 | Philadelphia | Pennsylvania | 42101 | 38767 | 1854 |
617733 | 617733 | 2020-10-10 | Philadelphia | Pennsylvania | 42101 | 38767 | 1854 |
614491 | 614491 | 2020-10-09 | Philadelphia | Pennsylvania | 42101 | 38767 | 1850 |
611250 | 611250 | 2020-10-08 | Philadelphia | Pennsylvania | 42101 | 38515 | 1849 |
608008 | 608008 | 2020-10-07 | Philadelphia | Pennsylvania | 42101 | 38264 | 1844 |
604765 | 604765 | 2020-10-06 | Philadelphia | Pennsylvania | 42101 | 38083 | 1841 |
601523 | 601523 | 2020-10-05 | Philadelphia | Pennsylvania | 42101 | 37807 | 1839 |
598280 | 598280 | 2020-10-04 | Philadelphia | Pennsylvania | 42101 | 37502 | 1838 |
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);