ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Chester" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055782 | 1055782 | 2021-02-22 | Chester | Pennsylvania | 42029 | 30004 | 714 |
1052536 | 1052536 | 2021-02-21 | Chester | Pennsylvania | 42029 | 29912 | 713 |
1049289 | 1049289 | 2021-02-20 | Chester | Pennsylvania | 42029 | 29843 | 713 |
1046042 | 1046042 | 2021-02-19 | Chester | Pennsylvania | 42029 | 29781 | 711 |
1042797 | 1042797 | 2021-02-18 | Chester | Pennsylvania | 42029 | 29693 | 711 |
1039552 | 1039552 | 2021-02-17 | Chester | Pennsylvania | 42029 | 29560 | 707 |
1036307 | 1036307 | 2021-02-16 | Chester | Pennsylvania | 42029 | 29416 | 698 |
1033062 | 1033062 | 2021-02-15 | Chester | Pennsylvania | 42029 | 29325 | 698 |
1029816 | 1029816 | 2021-02-14 | Chester | Pennsylvania | 42029 | 29212 | 697 |
1026569 | 1026569 | 2021-02-13 | Chester | Pennsylvania | 42029 | 29112 | 697 |
1023324 | 1023324 | 2021-02-12 | Chester | Pennsylvania | 42029 | 28958 | 695 |
1020079 | 1020079 | 2021-02-11 | Chester | Pennsylvania | 42029 | 28871 | 693 |
1016834 | 1016834 | 2021-02-10 | Chester | Pennsylvania | 42029 | 28723 | 689 |
1013589 | 1013589 | 2021-02-09 | Chester | Pennsylvania | 42029 | 28624 | 684 |
1010344 | 1010344 | 2021-02-08 | Chester | Pennsylvania | 42029 | 28502 | 681 |
1007098 | 1007098 | 2021-02-07 | Chester | Pennsylvania | 42029 | 28399 | 679 |
1003852 | 1003852 | 2021-02-06 | Chester | Pennsylvania | 42029 | 28201 | 678 |
1000606 | 1000606 | 2021-02-05 | Chester | Pennsylvania | 42029 | 28042 | 673 |
997360 | 997360 | 2021-02-04 | Chester | Pennsylvania | 42029 | 27915 | 670 |
994114 | 994114 | 2021-02-03 | Chester | Pennsylvania | 42029 | 27775 | 664 |
990868 | 990868 | 2021-02-02 | Chester | Pennsylvania | 42029 | 27695 | 663 |
987622 | 987622 | 2021-02-01 | Chester | Pennsylvania | 42029 | 27519 | 660 |
984375 | 984375 | 2021-01-31 | Chester | Pennsylvania | 42029 | 27405 | 660 |
981128 | 981128 | 2021-01-30 | Chester | Pennsylvania | 42029 | 27251 | 659 |
977882 | 977882 | 2021-01-29 | Chester | Pennsylvania | 42029 | 27079 | 657 |
974637 | 974637 | 2021-01-28 | Chester | Pennsylvania | 42029 | 26744 | 656 |
971392 | 971392 | 2021-01-27 | Chester | Pennsylvania | 42029 | 26580 | 653 |
968147 | 968147 | 2021-01-26 | Chester | Pennsylvania | 42029 | 26380 | 647 |
964903 | 964903 | 2021-01-25 | Chester | Pennsylvania | 42029 | 26249 | 644 |
961658 | 961658 | 2021-01-24 | Chester | Pennsylvania | 42029 | 26110 | 643 |
958413 | 958413 | 2021-01-23 | Chester | Pennsylvania | 42029 | 25948 | 643 |
955167 | 955167 | 2021-01-22 | Chester | Pennsylvania | 42029 | 25771 | 643 |
951922 | 951922 | 2021-01-21 | Chester | Pennsylvania | 42029 | 25579 | 639 |
948677 | 948677 | 2021-01-20 | Chester | Pennsylvania | 42029 | 25381 | 632 |
945431 | 945431 | 2021-01-19 | Chester | Pennsylvania | 42029 | 25167 | 624 |
942184 | 942184 | 2021-01-18 | Chester | Pennsylvania | 42029 | 24984 | 623 |
938939 | 938939 | 2021-01-17 | Chester | Pennsylvania | 42029 | 24822 | 622 |
935694 | 935694 | 2021-01-16 | Chester | Pennsylvania | 42029 | 24645 | 616 |
932449 | 932449 | 2021-01-15 | Chester | Pennsylvania | 42029 | 24369 | 609 |
929204 | 929204 | 2021-01-14 | Chester | Pennsylvania | 42029 | 24140 | 605 |
925959 | 925959 | 2021-01-13 | Chester | Pennsylvania | 42029 | 23914 | 596 |
922713 | 922713 | 2021-01-12 | Chester | Pennsylvania | 42029 | 23631 | 587 |
919468 | 919468 | 2021-01-11 | Chester | Pennsylvania | 42029 | 23366 | 579 |
916223 | 916223 | 2021-01-10 | Chester | Pennsylvania | 42029 | 23197 | 577 |
912978 | 912978 | 2021-01-09 | Chester | Pennsylvania | 42029 | 22921 | 575 |
909733 | 909733 | 2021-01-08 | Chester | Pennsylvania | 42029 | 22570 | 568 |
906488 | 906488 | 2021-01-07 | Chester | Pennsylvania | 42029 | 22280 | 555 |
903242 | 903242 | 2021-01-06 | Chester | Pennsylvania | 42029 | 21796 | 544 |
899997 | 899997 | 2021-01-05 | Chester | Pennsylvania | 42029 | 21529 | 531 |
896752 | 896752 | 2021-01-04 | Chester | Pennsylvania | 42029 | 21137 | 522 |
893506 | 893506 | 2021-01-03 | Chester | Pennsylvania | 42029 | 21081 | 521 |
890260 | 890260 | 2021-01-02 | Chester | Pennsylvania | 42029 | 20938 | 521 |
887013 | 887013 | 2021-01-01 | Chester | Pennsylvania | 42029 | 20648 | 520 |
883768 | 883768 | 2020-12-31 | Chester | Pennsylvania | 42029 | 20457 | 512 |
880523 | 880523 | 2020-12-30 | Chester | Pennsylvania | 42029 | 20185 | 507 |
877278 | 877278 | 2020-12-29 | Chester | Pennsylvania | 42029 | 19845 | 499 |
874033 | 874033 | 2020-12-28 | Chester | Pennsylvania | 42029 | 19627 | 491 |
870788 | 870788 | 2020-12-27 | Chester | Pennsylvania | 42029 | 19425 | 490 |
867543 | 867543 | 2020-12-26 | Chester | Pennsylvania | 42029 | 19309 | 485 |
864298 | 864298 | 2020-12-25 | Chester | Pennsylvania | 42029 | 19059 | 483 |
861053 | 861053 | 2020-12-24 | Chester | Pennsylvania | 42029 | 18838 | 483 |
857808 | 857808 | 2020-12-23 | Chester | Pennsylvania | 42029 | 18562 | 466 |
854563 | 854563 | 2020-12-22 | Chester | Pennsylvania | 42029 | 18281 | 463 |
851318 | 851318 | 2020-12-21 | Chester | Pennsylvania | 42029 | 17999 | 462 |
848073 | 848073 | 2020-12-20 | Chester | Pennsylvania | 42029 | 17798 | 459 |
844828 | 844828 | 2020-12-19 | Chester | Pennsylvania | 42029 | 17581 | 459 |
841582 | 841582 | 2020-12-18 | Chester | Pennsylvania | 42029 | 17353 | 459 |
838337 | 838337 | 2020-12-17 | Chester | Pennsylvania | 42029 | 16929 | 452 |
835091 | 835091 | 2020-12-16 | Chester | Pennsylvania | 42029 | 16696 | 444 |
831845 | 831845 | 2020-12-15 | Chester | Pennsylvania | 42029 | 16414 | 442 |
828598 | 828598 | 2020-12-14 | Chester | Pennsylvania | 42029 | 16105 | 441 |
825352 | 825352 | 2020-12-13 | Chester | Pennsylvania | 42029 | 15850 | 440 |
822105 | 822105 | 2020-12-12 | Chester | Pennsylvania | 42029 | 15614 | 440 |
818859 | 818859 | 2020-12-11 | Chester | Pennsylvania | 42029 | 15264 | 440 |
815613 | 815613 | 2020-12-10 | Chester | Pennsylvania | 42029 | 15015 | 430 |
812367 | 812367 | 2020-12-09 | Chester | Pennsylvania | 42029 | 14691 | 430 |
809123 | 809123 | 2020-12-08 | Chester | Pennsylvania | 42029 | 14470 | 420 |
805878 | 805878 | 2020-12-07 | Chester | Pennsylvania | 42029 | 14178 | 418 |
802633 | 802633 | 2020-12-06 | Chester | Pennsylvania | 42029 | 13976 | 416 |
799388 | 799388 | 2020-12-05 | Chester | Pennsylvania | 42029 | 13686 | 416 |
796143 | 796143 | 2020-12-04 | Chester | Pennsylvania | 42029 | 13426 | 416 |
792898 | 792898 | 2020-12-03 | Chester | Pennsylvania | 42029 | 13017 | 413 |
789653 | 789653 | 2020-12-02 | Chester | Pennsylvania | 42029 | 12654 | 406 |
786408 | 786408 | 2020-12-01 | Chester | Pennsylvania | 42029 | 12421 | 402 |
783164 | 783164 | 2020-11-30 | Chester | Pennsylvania | 42029 | 12246 | 399 |
779919 | 779919 | 2020-11-29 | Chester | Pennsylvania | 42029 | 12154 | 398 |
776673 | 776673 | 2020-11-28 | Chester | Pennsylvania | 42029 | 12009 | 398 |
773428 | 773428 | 2020-11-27 | Chester | Pennsylvania | 42029 | 11833 | 398 |
770183 | 770183 | 2020-11-26 | Chester | Pennsylvania | 42029 | 11619 | 398 |
766937 | 766937 | 2020-11-25 | Chester | Pennsylvania | 42029 | 11369 | 398 |
763692 | 763692 | 2020-11-24 | Chester | Pennsylvania | 42029 | 11222 | 392 |
760447 | 760447 | 2020-11-23 | Chester | Pennsylvania | 42029 | 11080 | 392 |
757202 | 757202 | 2020-11-22 | Chester | Pennsylvania | 42029 | 10935 | 389 |
753955 | 753955 | 2020-11-21 | Chester | Pennsylvania | 42029 | 10764 | 389 |
750709 | 750709 | 2020-11-20 | Chester | Pennsylvania | 42029 | 10574 | 389 |
747463 | 747463 | 2020-11-19 | Chester | Pennsylvania | 42029 | 10402 | 388 |
744217 | 744217 | 2020-11-18 | Chester | Pennsylvania | 42029 | 10180 | 388 |
740970 | 740970 | 2020-11-17 | Chester | Pennsylvania | 42029 | 10020 | 386 |
737724 | 737724 | 2020-11-16 | Chester | Pennsylvania | 42029 | 9895 | 384 |
734480 | 734480 | 2020-11-15 | Chester | Pennsylvania | 42029 | 9774 | 384 |
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);