ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 42077 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922737 | 922737 | 2021-01-12 | Lehigh | Pennsylvania | 42077 | 24010 | 564 |
919492 | 919492 | 2021-01-11 | Lehigh | Pennsylvania | 42077 | 23815 | 556 |
916247 | 916247 | 2021-01-10 | Lehigh | Pennsylvania | 42077 | 23595 | 556 |
913002 | 913002 | 2021-01-09 | Lehigh | Pennsylvania | 42077 | 23311 | 553 |
909757 | 909757 | 2021-01-08 | Lehigh | Pennsylvania | 42077 | 22784 | 545 |
906512 | 906512 | 2021-01-07 | Lehigh | Pennsylvania | 42077 | 22433 | 536 |
903266 | 903266 | 2021-01-06 | Lehigh | Pennsylvania | 42077 | 22015 | 528 |
900021 | 900021 | 2021-01-05 | Lehigh | Pennsylvania | 42077 | 21720 | 518 |
896776 | 896776 | 2021-01-04 | Lehigh | Pennsylvania | 42077 | 21370 | 513 |
893530 | 893530 | 2021-01-03 | Lehigh | Pennsylvania | 42077 | 21231 | 513 |
890284 | 890284 | 2021-01-02 | Lehigh | Pennsylvania | 42077 | 21107 | 511 |
887037 | 887037 | 2021-01-01 | Lehigh | Pennsylvania | 42077 | 20674 | 511 |
883792 | 883792 | 2020-12-31 | Lehigh | Pennsylvania | 42077 | 20348 | 503 |
880547 | 880547 | 2020-12-30 | Lehigh | Pennsylvania | 42077 | 20031 | 498 |
877302 | 877302 | 2020-12-29 | Lehigh | Pennsylvania | 42077 | 19701 | 489 |
874057 | 874057 | 2020-12-28 | Lehigh | Pennsylvania | 42077 | 19449 | 481 |
870812 | 870812 | 2020-12-27 | Lehigh | Pennsylvania | 42077 | 19280 | 479 |
867567 | 867567 | 2020-12-26 | Lehigh | Pennsylvania | 42077 | 19071 | 473 |
864322 | 864322 | 2020-12-25 | Lehigh | Pennsylvania | 42077 | 18843 | 473 |
861077 | 861077 | 2020-12-24 | Lehigh | Pennsylvania | 42077 | 18571 | 468 |
857832 | 857832 | 2020-12-23 | Lehigh | Pennsylvania | 42077 | 18177 | 460 |
854587 | 854587 | 2020-12-22 | Lehigh | Pennsylvania | 42077 | 17883 | 454 |
851342 | 851342 | 2020-12-21 | Lehigh | Pennsylvania | 42077 | 17668 | 444 |
848097 | 848097 | 2020-12-20 | Lehigh | Pennsylvania | 42077 | 17286 | 444 |
844852 | 844852 | 2020-12-19 | Lehigh | Pennsylvania | 42077 | 17000 | 443 |
841606 | 841606 | 2020-12-18 | Lehigh | Pennsylvania | 42077 | 16758 | 440 |
838361 | 838361 | 2020-12-17 | Lehigh | Pennsylvania | 42077 | 16525 | 435 |
835115 | 835115 | 2020-12-16 | Lehigh | Pennsylvania | 42077 | 16105 | 434 |
831869 | 831869 | 2020-12-15 | Lehigh | Pennsylvania | 42077 | 15789 | 429 |
828622 | 828622 | 2020-12-14 | Lehigh | Pennsylvania | 42077 | 15583 | 424 |
825376 | 825376 | 2020-12-13 | Lehigh | Pennsylvania | 42077 | 15288 | 424 |
822129 | 822129 | 2020-12-12 | Lehigh | Pennsylvania | 42077 | 14948 | 423 |
818883 | 818883 | 2020-12-11 | Lehigh | Pennsylvania | 42077 | 14678 | 422 |
815637 | 815637 | 2020-12-10 | Lehigh | Pennsylvania | 42077 | 14384 | 416 |
812391 | 812391 | 2020-12-09 | Lehigh | Pennsylvania | 42077 | 14013 | 409 |
809147 | 809147 | 2020-12-08 | Lehigh | Pennsylvania | 42077 | 13760 | 409 |
805902 | 805902 | 2020-12-07 | Lehigh | Pennsylvania | 42077 | 13455 | 401 |
802657 | 802657 | 2020-12-06 | Lehigh | Pennsylvania | 42077 | 13200 | 400 |
799412 | 799412 | 2020-12-05 | Lehigh | Pennsylvania | 42077 | 12930 | 399 |
796167 | 796167 | 2020-12-04 | Lehigh | Pennsylvania | 42077 | 12554 | 395 |
792922 | 792922 | 2020-12-03 | Lehigh | Pennsylvania | 42077 | 12070 | 392 |
789677 | 789677 | 2020-12-02 | Lehigh | Pennsylvania | 42077 | 11868 | 387 |
786432 | 786432 | 2020-12-01 | Lehigh | Pennsylvania | 42077 | 11579 | 385 |
783188 | 783188 | 2020-11-30 | Lehigh | Pennsylvania | 42077 | 11512 | 382 |
779943 | 779943 | 2020-11-29 | Lehigh | Pennsylvania | 42077 | 11412 | 382 |
776697 | 776697 | 2020-11-28 | Lehigh | Pennsylvania | 42077 | 11279 | 382 |
773452 | 773452 | 2020-11-27 | Lehigh | Pennsylvania | 42077 | 10981 | 382 |
770207 | 770207 | 2020-11-26 | Lehigh | Pennsylvania | 42077 | 10666 | 382 |
766961 | 766961 | 2020-11-25 | Lehigh | Pennsylvania | 42077 | 10403 | 381 |
763716 | 763716 | 2020-11-24 | Lehigh | Pennsylvania | 42077 | 10222 | 380 |
760471 | 760471 | 2020-11-23 | Lehigh | Pennsylvania | 42077 | 10059 | 379 |
757226 | 757226 | 2020-11-22 | Lehigh | Pennsylvania | 42077 | 9912 | 379 |
753979 | 753979 | 2020-11-21 | Lehigh | Pennsylvania | 42077 | 9694 | 379 |
750733 | 750733 | 2020-11-20 | Lehigh | Pennsylvania | 42077 | 9453 | 376 |
747487 | 747487 | 2020-11-19 | Lehigh | Pennsylvania | 42077 | 9183 | 376 |
744241 | 744241 | 2020-11-18 | Lehigh | Pennsylvania | 42077 | 8970 | 374 |
740994 | 740994 | 2020-11-17 | Lehigh | Pennsylvania | 42077 | 8831 | 374 |
737748 | 737748 | 2020-11-16 | Lehigh | Pennsylvania | 42077 | 8725 | 374 |
734504 | 734504 | 2020-11-15 | Lehigh | Pennsylvania | 42077 | 8637 | 374 |
731258 | 731258 | 2020-11-14 | Lehigh | Pennsylvania | 42077 | 8466 | 374 |
728014 | 728014 | 2020-11-13 | Lehigh | Pennsylvania | 42077 | 8332 | 372 |
724770 | 724770 | 2020-11-12 | Lehigh | Pennsylvania | 42077 | 8167 | 372 |
721527 | 721527 | 2020-11-11 | Lehigh | Pennsylvania | 42077 | 7965 | 372 |
718284 | 718284 | 2020-11-10 | Lehigh | Pennsylvania | 42077 | 7775 | 372 |
715041 | 715041 | 2020-11-09 | Lehigh | Pennsylvania | 42077 | 7657 | 372 |
711797 | 711797 | 2020-11-08 | Lehigh | Pennsylvania | 42077 | 7544 | 372 |
708553 | 708553 | 2020-11-07 | Lehigh | Pennsylvania | 42077 | 7439 | 372 |
705310 | 705310 | 2020-11-06 | Lehigh | Pennsylvania | 42077 | 7290 | 371 |
702067 | 702067 | 2020-11-05 | Lehigh | Pennsylvania | 42077 | 7180 | 370 |
698823 | 698823 | 2020-11-04 | Lehigh | Pennsylvania | 42077 | 7087 | 369 |
695580 | 695580 | 2020-11-03 | Lehigh | Pennsylvania | 42077 | 7027 | 366 |
692338 | 692338 | 2020-11-02 | Lehigh | Pennsylvania | 42077 | 6944 | 366 |
689094 | 689094 | 2020-11-01 | Lehigh | Pennsylvania | 42077 | 6863 | 366 |
685849 | 685849 | 2020-10-31 | Lehigh | Pennsylvania | 42077 | 6811 | 366 |
682606 | 682606 | 2020-10-30 | Lehigh | Pennsylvania | 42077 | 6698 | 366 |
679363 | 679363 | 2020-10-29 | Lehigh | Pennsylvania | 42077 | 6643 | 365 |
676120 | 676120 | 2020-10-28 | Lehigh | Pennsylvania | 42077 | 6593 | 365 |
672877 | 672877 | 2020-10-27 | Lehigh | Pennsylvania | 42077 | 6541 | 365 |
669635 | 669635 | 2020-10-26 | Lehigh | Pennsylvania | 42077 | 6496 | 365 |
666391 | 666391 | 2020-10-25 | Lehigh | Pennsylvania | 42077 | 6411 | 365 |
663146 | 663146 | 2020-10-24 | Lehigh | Pennsylvania | 42077 | 6376 | 365 |
659902 | 659902 | 2020-10-23 | Lehigh | Pennsylvania | 42077 | 6318 | 364 |
656658 | 656658 | 2020-10-22 | Lehigh | Pennsylvania | 42077 | 6262 | 363 |
653413 | 653413 | 2020-10-21 | Lehigh | Pennsylvania | 42077 | 6201 | 363 |
650168 | 650168 | 2020-10-20 | Lehigh | Pennsylvania | 42077 | 6166 | 363 |
646924 | 646924 | 2020-10-19 | Lehigh | Pennsylvania | 42077 | 6149 | 362 |
643678 | 643678 | 2020-10-18 | Lehigh | Pennsylvania | 42077 | 6129 | 362 |
640430 | 640430 | 2020-10-17 | Lehigh | Pennsylvania | 42077 | 6109 | 361 |
637184 | 637184 | 2020-10-16 | Lehigh | Pennsylvania | 42077 | 6078 | 361 |
633938 | 633938 | 2020-10-15 | Lehigh | Pennsylvania | 42077 | 6053 | 361 |
630693 | 630693 | 2020-10-14 | Lehigh | Pennsylvania | 42077 | 6023 | 361 |
627449 | 627449 | 2020-10-13 | Lehigh | Pennsylvania | 42077 | 5999 | 359 |
624207 | 624207 | 2020-10-12 | Lehigh | Pennsylvania | 42077 | 5981 | 359 |
620964 | 620964 | 2020-10-11 | Lehigh | Pennsylvania | 42077 | 5976 | 359 |
617721 | 617721 | 2020-10-10 | Lehigh | Pennsylvania | 42077 | 5941 | 358 |
614479 | 614479 | 2020-10-09 | Lehigh | Pennsylvania | 42077 | 5901 | 357 |
611238 | 611238 | 2020-10-08 | Lehigh | Pennsylvania | 42077 | 5875 | 357 |
607996 | 607996 | 2020-10-07 | Lehigh | Pennsylvania | 42077 | 5850 | 357 |
604753 | 604753 | 2020-10-06 | Lehigh | Pennsylvania | 42077 | 5805 | 356 |
601511 | 601511 | 2020-10-05 | Lehigh | Pennsylvania | 42077 | 5781 | 355 |
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);