ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Lawrence" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922735 | 922735 | 2021-01-12 | Lawrence | Pennsylvania | 42073 | 4871 | 140 |
919490 | 919490 | 2021-01-11 | Lawrence | Pennsylvania | 42073 | 4826 | 140 |
916245 | 916245 | 2021-01-10 | Lawrence | Pennsylvania | 42073 | 4790 | 139 |
913000 | 913000 | 2021-01-09 | Lawrence | Pennsylvania | 42073 | 4734 | 139 |
909755 | 909755 | 2021-01-08 | Lawrence | Pennsylvania | 42073 | 4663 | 136 |
906510 | 906510 | 2021-01-07 | Lawrence | Pennsylvania | 42073 | 4579 | 135 |
903264 | 903264 | 2021-01-06 | Lawrence | Pennsylvania | 42073 | 4526 | 134 |
900019 | 900019 | 2021-01-05 | Lawrence | Pennsylvania | 42073 | 4471 | 131 |
896774 | 896774 | 2021-01-04 | Lawrence | Pennsylvania | 42073 | 4431 | 130 |
893528 | 893528 | 2021-01-03 | Lawrence | Pennsylvania | 42073 | 4390 | 129 |
890282 | 890282 | 2021-01-02 | Lawrence | Pennsylvania | 42073 | 4361 | 129 |
887035 | 887035 | 2021-01-01 | Lawrence | Pennsylvania | 42073 | 4286 | 129 |
883790 | 883790 | 2020-12-31 | Lawrence | Pennsylvania | 42073 | 4245 | 126 |
880545 | 880545 | 2020-12-30 | Lawrence | Pennsylvania | 42073 | 4209 | 126 |
877300 | 877300 | 2020-12-29 | Lawrence | Pennsylvania | 42073 | 4162 | 121 |
874055 | 874055 | 2020-12-28 | Lawrence | Pennsylvania | 42073 | 4081 | 121 |
870810 | 870810 | 2020-12-27 | Lawrence | Pennsylvania | 42073 | 4062 | 121 |
867565 | 867565 | 2020-12-26 | Lawrence | Pennsylvania | 42073 | 4051 | 120 |
864320 | 864320 | 2020-12-25 | Lawrence | Pennsylvania | 42073 | 4021 | 120 |
861075 | 861075 | 2020-12-24 | Lawrence | Pennsylvania | 42073 | 3942 | 120 |
857830 | 857830 | 2020-12-23 | Lawrence | Pennsylvania | 42073 | 3862 | 115 |
854585 | 854585 | 2020-12-22 | Lawrence | Pennsylvania | 42073 | 3795 | 112 |
851340 | 851340 | 2020-12-21 | Lawrence | Pennsylvania | 42073 | 3741 | 107 |
848095 | 848095 | 2020-12-20 | Lawrence | Pennsylvania | 42073 | 3697 | 107 |
844850 | 844850 | 2020-12-19 | Lawrence | Pennsylvania | 42073 | 3655 | 106 |
841604 | 841604 | 2020-12-18 | Lawrence | Pennsylvania | 42073 | 3536 | 102 |
838359 | 838359 | 2020-12-17 | Lawrence | Pennsylvania | 42073 | 3429 | 98 |
835113 | 835113 | 2020-12-16 | Lawrence | Pennsylvania | 42073 | 3387 | 95 |
831867 | 831867 | 2020-12-15 | Lawrence | Pennsylvania | 42073 | 3294 | 93 |
828620 | 828620 | 2020-12-14 | Lawrence | Pennsylvania | 42073 | 3242 | 92 |
825374 | 825374 | 2020-12-13 | Lawrence | Pennsylvania | 42073 | 3201 | 89 |
822127 | 822127 | 2020-12-12 | Lawrence | Pennsylvania | 42073 | 3138 | 88 |
818881 | 818881 | 2020-12-11 | Lawrence | Pennsylvania | 42073 | 3036 | 87 |
815635 | 815635 | 2020-12-10 | Lawrence | Pennsylvania | 42073 | 2931 | 87 |
812389 | 812389 | 2020-12-09 | Lawrence | Pennsylvania | 42073 | 2862 | 86 |
809145 | 809145 | 2020-12-08 | Lawrence | Pennsylvania | 42073 | 2772 | 81 |
805900 | 805900 | 2020-12-07 | Lawrence | Pennsylvania | 42073 | 2703 | 79 |
802655 | 802655 | 2020-12-06 | Lawrence | Pennsylvania | 42073 | 2653 | 78 |
799410 | 799410 | 2020-12-05 | Lawrence | Pennsylvania | 42073 | 2597 | 77 |
796165 | 796165 | 2020-12-04 | Lawrence | Pennsylvania | 42073 | 2503 | 75 |
792920 | 792920 | 2020-12-03 | Lawrence | Pennsylvania | 42073 | 2441 | 71 |
789675 | 789675 | 2020-12-02 | Lawrence | Pennsylvania | 42073 | 2330 | 70 |
786430 | 786430 | 2020-12-01 | Lawrence | Pennsylvania | 42073 | 2292 | 69 |
783186 | 783186 | 2020-11-30 | Lawrence | Pennsylvania | 42073 | 2206 | 68 |
779941 | 779941 | 2020-11-29 | Lawrence | Pennsylvania | 42073 | 2195 | 66 |
776695 | 776695 | 2020-11-28 | Lawrence | Pennsylvania | 42073 | 2153 | 66 |
773450 | 773450 | 2020-11-27 | Lawrence | Pennsylvania | 42073 | 2080 | 66 |
770205 | 770205 | 2020-11-26 | Lawrence | Pennsylvania | 42073 | 2048 | 66 |
766959 | 766959 | 2020-11-25 | Lawrence | Pennsylvania | 42073 | 1986 | 66 |
763714 | 763714 | 2020-11-24 | Lawrence | Pennsylvania | 42073 | 1929 | 64 |
760469 | 760469 | 2020-11-23 | Lawrence | Pennsylvania | 42073 | 1872 | 64 |
757224 | 757224 | 2020-11-22 | Lawrence | Pennsylvania | 42073 | 1846 | 64 |
753977 | 753977 | 2020-11-21 | Lawrence | Pennsylvania | 42073 | 1818 | 64 |
750731 | 750731 | 2020-11-20 | Lawrence | Pennsylvania | 42073 | 1776 | 61 |
747485 | 747485 | 2020-11-19 | Lawrence | Pennsylvania | 42073 | 1725 | 59 |
744239 | 744239 | 2020-11-18 | Lawrence | Pennsylvania | 42073 | 1686 | 58 |
740992 | 740992 | 2020-11-17 | Lawrence | Pennsylvania | 42073 | 1645 | 56 |
737746 | 737746 | 2020-11-16 | Lawrence | Pennsylvania | 42073 | 1595 | 54 |
734502 | 734502 | 2020-11-15 | Lawrence | Pennsylvania | 42073 | 1554 | 53 |
731256 | 731256 | 2020-11-14 | Lawrence | Pennsylvania | 42073 | 1525 | 48 |
728012 | 728012 | 2020-11-13 | Lawrence | Pennsylvania | 42073 | 1480 | 48 |
724768 | 724768 | 2020-11-12 | Lawrence | Pennsylvania | 42073 | 1450 | 47 |
721525 | 721525 | 2020-11-11 | Lawrence | Pennsylvania | 42073 | 1388 | 46 |
718282 | 718282 | 2020-11-10 | Lawrence | Pennsylvania | 42073 | 1343 | 44 |
715039 | 715039 | 2020-11-09 | Lawrence | Pennsylvania | 42073 | 1296 | 42 |
711795 | 711795 | 2020-11-08 | Lawrence | Pennsylvania | 42073 | 1269 | 42 |
708551 | 708551 | 2020-11-07 | Lawrence | Pennsylvania | 42073 | 1239 | 42 |
705308 | 705308 | 2020-11-06 | Lawrence | Pennsylvania | 42073 | 1175 | 40 |
702065 | 702065 | 2020-11-05 | Lawrence | Pennsylvania | 42073 | 1132 | 40 |
698821 | 698821 | 2020-11-04 | Lawrence | Pennsylvania | 42073 | 1093 | 38 |
695578 | 695578 | 2020-11-03 | Lawrence | Pennsylvania | 42073 | 1024 | 36 |
692336 | 692336 | 2020-11-02 | Lawrence | Pennsylvania | 42073 | 1003 | 35 |
689092 | 689092 | 2020-11-01 | Lawrence | Pennsylvania | 42073 | 957 | 35 |
685847 | 685847 | 2020-10-31 | Lawrence | Pennsylvania | 42073 | 947 | 35 |
682604 | 682604 | 2020-10-30 | Lawrence | Pennsylvania | 42073 | 914 | 34 |
679361 | 679361 | 2020-10-29 | Lawrence | Pennsylvania | 42073 | 903 | 34 |
676118 | 676118 | 2020-10-28 | Lawrence | Pennsylvania | 42073 | 879 | 34 |
672875 | 672875 | 2020-10-27 | Lawrence | Pennsylvania | 42073 | 865 | 34 |
669633 | 669633 | 2020-10-26 | Lawrence | Pennsylvania | 42073 | 849 | 34 |
666389 | 666389 | 2020-10-25 | Lawrence | Pennsylvania | 42073 | 840 | 34 |
663144 | 663144 | 2020-10-24 | Lawrence | Pennsylvania | 42073 | 820 | 34 |
659900 | 659900 | 2020-10-23 | Lawrence | Pennsylvania | 42073 | 800 | 31 |
656656 | 656656 | 2020-10-22 | Lawrence | Pennsylvania | 42073 | 777 | 29 |
653411 | 653411 | 2020-10-21 | Lawrence | Pennsylvania | 42073 | 753 | 27 |
650166 | 650166 | 2020-10-20 | Lawrence | Pennsylvania | 42073 | 741 | 26 |
646922 | 646922 | 2020-10-19 | Lawrence | Pennsylvania | 42073 | 723 | 25 |
643676 | 643676 | 2020-10-18 | Lawrence | Pennsylvania | 42073 | 708 | 25 |
640428 | 640428 | 2020-10-17 | Lawrence | Pennsylvania | 42073 | 703 | 24 |
637182 | 637182 | 2020-10-16 | Lawrence | Pennsylvania | 42073 | 685 | 24 |
633936 | 633936 | 2020-10-15 | Lawrence | Pennsylvania | 42073 | 681 | 24 |
630691 | 630691 | 2020-10-14 | Lawrence | Pennsylvania | 42073 | 653 | 24 |
627447 | 627447 | 2020-10-13 | Lawrence | Pennsylvania | 42073 | 643 | 23 |
624205 | 624205 | 2020-10-12 | Lawrence | Pennsylvania | 42073 | 628 | 23 |
620962 | 620962 | 2020-10-11 | Lawrence | Pennsylvania | 42073 | 622 | 23 |
617719 | 617719 | 2020-10-10 | Lawrence | Pennsylvania | 42073 | 608 | 23 |
614477 | 614477 | 2020-10-09 | Lawrence | Pennsylvania | 42073 | 602 | 23 |
611236 | 611236 | 2020-10-08 | Lawrence | Pennsylvania | 42073 | 593 | 23 |
607994 | 607994 | 2020-10-07 | Lawrence | Pennsylvania | 42073 | 568 | 23 |
604751 | 604751 | 2020-10-06 | Lawrence | Pennsylvania | 42073 | 564 | 22 |
601509 | 601509 | 2020-10-05 | Lawrence | Pennsylvania | 42073 | 562 | 22 |
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);