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 |
---|---|---|---|---|---|---|---|
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 |
731234 | 731234 | 2020-11-14 | Chester | Pennsylvania | 42029 | 9601 | 384 |
727990 | 727990 | 2020-11-13 | Chester | Pennsylvania | 42029 | 9440 | 384 |
724746 | 724746 | 2020-11-12 | Chester | Pennsylvania | 42029 | 9291 | 383 |
721503 | 721503 | 2020-11-11 | Chester | Pennsylvania | 42029 | 9169 | 383 |
718260 | 718260 | 2020-11-10 | Chester | Pennsylvania | 42029 | 9040 | 383 |
715017 | 715017 | 2020-11-09 | Chester | Pennsylvania | 42029 | 8928 | 383 |
711773 | 711773 | 2020-11-08 | Chester | Pennsylvania | 42029 | 8817 | 383 |
708529 | 708529 | 2020-11-07 | Chester | Pennsylvania | 42029 | 8758 | 383 |
705286 | 705286 | 2020-11-06 | Chester | Pennsylvania | 42029 | 8669 | 383 |
702043 | 702043 | 2020-11-05 | Chester | Pennsylvania | 42029 | 8581 | 381 |
698799 | 698799 | 2020-11-04 | Chester | Pennsylvania | 42029 | 8506 | 381 |
695556 | 695556 | 2020-11-03 | Chester | Pennsylvania | 42029 | 8398 | 381 |
692314 | 692314 | 2020-11-02 | Chester | Pennsylvania | 42029 | 8361 | 381 |
689070 | 689070 | 2020-11-01 | Chester | Pennsylvania | 42029 | 8282 | 381 |
685825 | 685825 | 2020-10-31 | Chester | Pennsylvania | 42029 | 8223 | 381 |
682582 | 682582 | 2020-10-30 | Chester | Pennsylvania | 42029 | 8198 | 381 |
679339 | 679339 | 2020-10-29 | Chester | Pennsylvania | 42029 | 8163 | 379 |
676096 | 676096 | 2020-10-28 | Chester | Pennsylvania | 42029 | 8093 | 379 |
672853 | 672853 | 2020-10-27 | Chester | Pennsylvania | 42029 | 8039 | 378 |
669611 | 669611 | 2020-10-26 | Chester | Pennsylvania | 42029 | 7986 | 378 |
666367 | 666367 | 2020-10-25 | Chester | Pennsylvania | 42029 | 7876 | 378 |
663122 | 663122 | 2020-10-24 | Chester | Pennsylvania | 42029 | 7833 | 378 |
659878 | 659878 | 2020-10-23 | Chester | Pennsylvania | 42029 | 7833 | 378 |
656634 | 656634 | 2020-10-22 | Chester | Pennsylvania | 42029 | 7775 | 376 |
653389 | 653389 | 2020-10-21 | Chester | Pennsylvania | 42029 | 7730 | 376 |
650144 | 650144 | 2020-10-20 | Chester | Pennsylvania | 42029 | 7701 | 374 |
646900 | 646900 | 2020-10-19 | Chester | Pennsylvania | 42029 | 7656 | 374 |
643654 | 643654 | 2020-10-18 | Chester | Pennsylvania | 42029 | 7593 | 374 |
640406 | 640406 | 2020-10-17 | Chester | Pennsylvania | 42029 | 7577 | 374 |
637160 | 637160 | 2020-10-16 | Chester | Pennsylvania | 42029 | 7575 | 374 |
633914 | 633914 | 2020-10-15 | Chester | Pennsylvania | 42029 | 7534 | 375 |
630669 | 630669 | 2020-10-14 | Chester | Pennsylvania | 42029 | 7491 | 375 |
627425 | 627425 | 2020-10-13 | Chester | Pennsylvania | 42029 | 7455 | 374 |
624183 | 624183 | 2020-10-12 | Chester | Pennsylvania | 42029 | 7401 | 374 |
620940 | 620940 | 2020-10-11 | Chester | Pennsylvania | 42029 | 7324 | 374 |
617697 | 617697 | 2020-10-10 | Chester | Pennsylvania | 42029 | 7292 | 374 |
614455 | 614455 | 2020-10-09 | Chester | Pennsylvania | 42029 | 7285 | 374 |
611214 | 611214 | 2020-10-08 | Chester | Pennsylvania | 42029 | 7243 | 371 |
607972 | 607972 | 2020-10-07 | Chester | Pennsylvania | 42029 | 7202 | 371 |
604729 | 604729 | 2020-10-06 | Chester | Pennsylvania | 42029 | 7155 | 370 |
601487 | 601487 | 2020-10-05 | Chester | Pennsylvania | 42029 | 7135 | 370 |
598244 | 598244 | 2020-10-04 | Chester | Pennsylvania | 42029 | 7075 | 369 |
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);