ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Franklin" and fips = 42055 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922726 | 922726 | 2021-01-12 | Franklin | Pennsylvania | 42055 | 10180 | 261 |
919481 | 919481 | 2021-01-11 | Franklin | Pennsylvania | 42055 | 10035 | 261 |
916236 | 916236 | 2021-01-10 | Franklin | Pennsylvania | 42055 | 9952 | 261 |
912991 | 912991 | 2021-01-09 | Franklin | Pennsylvania | 42055 | 9855 | 259 |
909746 | 909746 | 2021-01-08 | Franklin | Pennsylvania | 42055 | 9723 | 254 |
906501 | 906501 | 2021-01-07 | Franklin | Pennsylvania | 42055 | 9515 | 253 |
903255 | 903255 | 2021-01-06 | Franklin | Pennsylvania | 42055 | 9404 | 250 |
900010 | 900010 | 2021-01-05 | Franklin | Pennsylvania | 42055 | 9189 | 240 |
896765 | 896765 | 2021-01-04 | Franklin | Pennsylvania | 42055 | 8963 | 238 |
893519 | 893519 | 2021-01-03 | Franklin | Pennsylvania | 42055 | 8924 | 236 |
890273 | 890273 | 2021-01-02 | Franklin | Pennsylvania | 42055 | 8854 | 234 |
887026 | 887026 | 2021-01-01 | Franklin | Pennsylvania | 42055 | 8766 | 231 |
883781 | 883781 | 2020-12-31 | Franklin | Pennsylvania | 42055 | 8699 | 225 |
880536 | 880536 | 2020-12-30 | Franklin | Pennsylvania | 42055 | 8570 | 220 |
877291 | 877291 | 2020-12-29 | Franklin | Pennsylvania | 42055 | 8391 | 215 |
874046 | 874046 | 2020-12-28 | Franklin | Pennsylvania | 42055 | 8294 | 211 |
870801 | 870801 | 2020-12-27 | Franklin | Pennsylvania | 42055 | 8256 | 210 |
867556 | 867556 | 2020-12-26 | Franklin | Pennsylvania | 42055 | 8201 | 209 |
864311 | 864311 | 2020-12-25 | Franklin | Pennsylvania | 42055 | 8074 | 209 |
861066 | 861066 | 2020-12-24 | Franklin | Pennsylvania | 42055 | 8001 | 205 |
857821 | 857821 | 2020-12-23 | Franklin | Pennsylvania | 42055 | 7893 | 198 |
854576 | 854576 | 2020-12-22 | Franklin | Pennsylvania | 42055 | 7776 | 193 |
851331 | 851331 | 2020-12-21 | Franklin | Pennsylvania | 42055 | 7649 | 189 |
848086 | 848086 | 2020-12-20 | Franklin | Pennsylvania | 42055 | 7547 | 187 |
844841 | 844841 | 2020-12-19 | Franklin | Pennsylvania | 42055 | 7471 | 183 |
841595 | 841595 | 2020-12-18 | Franklin | Pennsylvania | 42055 | 7293 | 180 |
838350 | 838350 | 2020-12-17 | Franklin | Pennsylvania | 42055 | 7152 | 176 |
835104 | 835104 | 2020-12-16 | Franklin | Pennsylvania | 42055 | 7063 | 169 |
831858 | 831858 | 2020-12-15 | Franklin | Pennsylvania | 42055 | 6961 | 163 |
828611 | 828611 | 2020-12-14 | Franklin | Pennsylvania | 42055 | 6767 | 162 |
825365 | 825365 | 2020-12-13 | Franklin | Pennsylvania | 42055 | 6682 | 160 |
822118 | 822118 | 2020-12-12 | Franklin | Pennsylvania | 42055 | 6419 | 160 |
818872 | 818872 | 2020-12-11 | Franklin | Pennsylvania | 42055 | 6229 | 158 |
815626 | 815626 | 2020-12-10 | Franklin | Pennsylvania | 42055 | 6042 | 152 |
812380 | 812380 | 2020-12-09 | Franklin | Pennsylvania | 42055 | 5899 | 149 |
809136 | 809136 | 2020-12-08 | Franklin | Pennsylvania | 42055 | 5753 | 141 |
805891 | 805891 | 2020-12-07 | Franklin | Pennsylvania | 42055 | 5568 | 135 |
802646 | 802646 | 2020-12-06 | Franklin | Pennsylvania | 42055 | 5496 | 134 |
799401 | 799401 | 2020-12-05 | Franklin | Pennsylvania | 42055 | 5423 | 133 |
796156 | 796156 | 2020-12-04 | Franklin | Pennsylvania | 42055 | 5232 | 128 |
792911 | 792911 | 2020-12-03 | Franklin | Pennsylvania | 42055 | 5043 | 125 |
789666 | 789666 | 2020-12-02 | Franklin | Pennsylvania | 42055 | 4801 | 122 |
786421 | 786421 | 2020-12-01 | Franklin | Pennsylvania | 42055 | 4662 | 116 |
783177 | 783177 | 2020-11-30 | Franklin | Pennsylvania | 42055 | 4476 | 110 |
779932 | 779932 | 2020-11-29 | Franklin | Pennsylvania | 42055 | 4408 | 110 |
776686 | 776686 | 2020-11-28 | Franklin | Pennsylvania | 42055 | 4320 | 106 |
773441 | 773441 | 2020-11-27 | Franklin | Pennsylvania | 42055 | 4262 | 104 |
770196 | 770196 | 2020-11-26 | Franklin | Pennsylvania | 42055 | 4210 | 104 |
766950 | 766950 | 2020-11-25 | Franklin | Pennsylvania | 42055 | 4097 | 101 |
763705 | 763705 | 2020-11-24 | Franklin | Pennsylvania | 42055 | 3937 | 99 |
760460 | 760460 | 2020-11-23 | Franklin | Pennsylvania | 42055 | 3855 | 95 |
757215 | 757215 | 2020-11-22 | Franklin | Pennsylvania | 42055 | 3829 | 94 |
753968 | 753968 | 2020-11-21 | Franklin | Pennsylvania | 42055 | 3667 | 93 |
750722 | 750722 | 2020-11-20 | Franklin | Pennsylvania | 42055 | 3582 | 91 |
747476 | 747476 | 2020-11-19 | Franklin | Pennsylvania | 42055 | 3508 | 87 |
744230 | 744230 | 2020-11-18 | Franklin | Pennsylvania | 42055 | 3425 | 84 |
740983 | 740983 | 2020-11-17 | Franklin | Pennsylvania | 42055 | 3258 | 76 |
737737 | 737737 | 2020-11-16 | Franklin | Pennsylvania | 42055 | 3156 | 76 |
734493 | 734493 | 2020-11-15 | Franklin | Pennsylvania | 42055 | 3086 | 75 |
731247 | 731247 | 2020-11-14 | Franklin | Pennsylvania | 42055 | 3060 | 72 |
728003 | 728003 | 2020-11-13 | Franklin | Pennsylvania | 42055 | 2996 | 72 |
724759 | 724759 | 2020-11-12 | Franklin | Pennsylvania | 42055 | 2892 | 68 |
721516 | 721516 | 2020-11-11 | Franklin | Pennsylvania | 42055 | 2792 | 67 |
718273 | 718273 | 2020-11-10 | Franklin | Pennsylvania | 42055 | 2758 | 66 |
715030 | 715030 | 2020-11-09 | Franklin | Pennsylvania | 42055 | 2681 | 64 |
711786 | 711786 | 2020-11-08 | Franklin | Pennsylvania | 42055 | 2640 | 64 |
708542 | 708542 | 2020-11-07 | Franklin | Pennsylvania | 42055 | 2599 | 64 |
705299 | 705299 | 2020-11-06 | Franklin | Pennsylvania | 42055 | 2546 | 62 |
702056 | 702056 | 2020-11-05 | Franklin | Pennsylvania | 42055 | 2500 | 59 |
698812 | 698812 | 2020-11-04 | Franklin | Pennsylvania | 42055 | 2467 | 58 |
695569 | 695569 | 2020-11-03 | Franklin | Pennsylvania | 42055 | 2419 | 57 |
692327 | 692327 | 2020-11-02 | Franklin | Pennsylvania | 42055 | 2346 | 55 |
689083 | 689083 | 2020-11-01 | Franklin | Pennsylvania | 42055 | 2329 | 55 |
685838 | 685838 | 2020-10-31 | Franklin | Pennsylvania | 42055 | 2306 | 55 |
682595 | 682595 | 2020-10-30 | Franklin | Pennsylvania | 42055 | 2269 | 55 |
679352 | 679352 | 2020-10-29 | Franklin | Pennsylvania | 42055 | 2219 | 55 |
676109 | 676109 | 2020-10-28 | Franklin | Pennsylvania | 42055 | 2190 | 54 |
672866 | 672866 | 2020-10-27 | Franklin | Pennsylvania | 42055 | 2168 | 54 |
669624 | 669624 | 2020-10-26 | Franklin | Pennsylvania | 42055 | 2115 | 54 |
666380 | 666380 | 2020-10-25 | Franklin | Pennsylvania | 42055 | 2112 | 54 |
663135 | 663135 | 2020-10-24 | Franklin | Pennsylvania | 42055 | 2099 | 54 |
659891 | 659891 | 2020-10-23 | Franklin | Pennsylvania | 42055 | 2081 | 54 |
656647 | 656647 | 2020-10-22 | Franklin | Pennsylvania | 42055 | 2047 | 54 |
653402 | 653402 | 2020-10-21 | Franklin | Pennsylvania | 42055 | 2031 | 54 |
650157 | 650157 | 2020-10-20 | Franklin | Pennsylvania | 42055 | 2020 | 53 |
646913 | 646913 | 2020-10-19 | Franklin | Pennsylvania | 42055 | 2003 | 53 |
643667 | 643667 | 2020-10-18 | Franklin | Pennsylvania | 42055 | 1986 | 53 |
640419 | 640419 | 2020-10-17 | Franklin | Pennsylvania | 42055 | 1982 | 53 |
637173 | 637173 | 2020-10-16 | Franklin | Pennsylvania | 42055 | 1975 | 53 |
633927 | 633927 | 2020-10-15 | Franklin | Pennsylvania | 42055 | 1957 | 53 |
630682 | 630682 | 2020-10-14 | Franklin | Pennsylvania | 42055 | 1936 | 53 |
627438 | 627438 | 2020-10-13 | Franklin | Pennsylvania | 42055 | 1931 | 53 |
624196 | 624196 | 2020-10-12 | Franklin | Pennsylvania | 42055 | 1900 | 53 |
620953 | 620953 | 2020-10-11 | Franklin | Pennsylvania | 42055 | 1892 | 53 |
617710 | 617710 | 2020-10-10 | Franklin | Pennsylvania | 42055 | 1889 | 53 |
614468 | 614468 | 2020-10-09 | Franklin | Pennsylvania | 42055 | 1875 | 52 |
611227 | 611227 | 2020-10-08 | Franklin | Pennsylvania | 42055 | 1869 | 52 |
607985 | 607985 | 2020-10-07 | Franklin | Pennsylvania | 42055 | 1855 | 52 |
604742 | 604742 | 2020-10-06 | Franklin | Pennsylvania | 42055 | 1847 | 52 |
601500 | 601500 | 2020-10-05 | Franklin | Pennsylvania | 42055 | 1835 | 52 |
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);