ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Lebanon" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055805 | 1055805 | 2021-02-22 | Lebanon | Pennsylvania | 42075 | 12651 | 256 |
1052559 | 1052559 | 2021-02-21 | Lebanon | Pennsylvania | 42075 | 12643 | 256 |
1049312 | 1049312 | 2021-02-20 | Lebanon | Pennsylvania | 42075 | 12623 | 256 |
1046065 | 1046065 | 2021-02-19 | Lebanon | Pennsylvania | 42075 | 12584 | 255 |
1042820 | 1042820 | 2021-02-18 | Lebanon | Pennsylvania | 42075 | 12562 | 255 |
1039575 | 1039575 | 2021-02-17 | Lebanon | Pennsylvania | 42075 | 12533 | 256 |
1036330 | 1036330 | 2021-02-16 | Lebanon | Pennsylvania | 42075 | 12493 | 252 |
1033085 | 1033085 | 2021-02-15 | Lebanon | Pennsylvania | 42075 | 12468 | 252 |
1029839 | 1029839 | 2021-02-14 | Lebanon | Pennsylvania | 42075 | 12446 | 252 |
1026592 | 1026592 | 2021-02-13 | Lebanon | Pennsylvania | 42075 | 12391 | 252 |
1023347 | 1023347 | 2021-02-12 | Lebanon | Pennsylvania | 42075 | 12342 | 247 |
1020102 | 1020102 | 2021-02-11 | Lebanon | Pennsylvania | 42075 | 12308 | 245 |
1016857 | 1016857 | 2021-02-10 | Lebanon | Pennsylvania | 42075 | 12266 | 243 |
1013612 | 1013612 | 2021-02-09 | Lebanon | Pennsylvania | 42075 | 12229 | 241 |
1010367 | 1010367 | 2021-02-08 | Lebanon | Pennsylvania | 42075 | 12160 | 239 |
1007121 | 1007121 | 2021-02-07 | Lebanon | Pennsylvania | 42075 | 12125 | 237 |
1003875 | 1003875 | 2021-02-06 | Lebanon | Pennsylvania | 42075 | 12046 | 235 |
1000629 | 1000629 | 2021-02-05 | Lebanon | Pennsylvania | 42075 | 11997 | 234 |
997383 | 997383 | 2021-02-04 | Lebanon | Pennsylvania | 42075 | 11940 | 230 |
994137 | 994137 | 2021-02-03 | Lebanon | Pennsylvania | 42075 | 11888 | 226 |
990891 | 990891 | 2021-02-02 | Lebanon | Pennsylvania | 42075 | 11861 | 225 |
987645 | 987645 | 2021-02-01 | Lebanon | Pennsylvania | 42075 | 11805 | 223 |
984398 | 984398 | 2021-01-31 | Lebanon | Pennsylvania | 42075 | 11774 | 223 |
981151 | 981151 | 2021-01-30 | Lebanon | Pennsylvania | 42075 | 11715 | 223 |
977905 | 977905 | 2021-01-29 | Lebanon | Pennsylvania | 42075 | 11650 | 223 |
974660 | 974660 | 2021-01-28 | Lebanon | Pennsylvania | 42075 | 11573 | 219 |
971415 | 971415 | 2021-01-27 | Lebanon | Pennsylvania | 42075 | 11511 | 217 |
968170 | 968170 | 2021-01-26 | Lebanon | Pennsylvania | 42075 | 11412 | 215 |
964926 | 964926 | 2021-01-25 | Lebanon | Pennsylvania | 42075 | 11354 | 212 |
961681 | 961681 | 2021-01-24 | Lebanon | Pennsylvania | 42075 | 11281 | 212 |
958436 | 958436 | 2021-01-23 | Lebanon | Pennsylvania | 42075 | 11249 | 210 |
955190 | 955190 | 2021-01-22 | Lebanon | Pennsylvania | 42075 | 11161 | 209 |
951945 | 951945 | 2021-01-21 | Lebanon | Pennsylvania | 42075 | 11065 | 208 |
948700 | 948700 | 2021-01-20 | Lebanon | Pennsylvania | 42075 | 10979 | 205 |
945454 | 945454 | 2021-01-19 | Lebanon | Pennsylvania | 42075 | 10873 | 196 |
942207 | 942207 | 2021-01-18 | Lebanon | Pennsylvania | 42075 | 10780 | 196 |
938962 | 938962 | 2021-01-17 | Lebanon | Pennsylvania | 42075 | 10737 | 193 |
935717 | 935717 | 2021-01-16 | Lebanon | Pennsylvania | 42075 | 10623 | 193 |
932472 | 932472 | 2021-01-15 | Lebanon | Pennsylvania | 42075 | 10509 | 191 |
929227 | 929227 | 2021-01-14 | Lebanon | Pennsylvania | 42075 | 10457 | 189 |
925982 | 925982 | 2021-01-13 | Lebanon | Pennsylvania | 42075 | 10355 | 186 |
922736 | 922736 | 2021-01-12 | Lebanon | Pennsylvania | 42075 | 10248 | 176 |
919491 | 919491 | 2021-01-11 | Lebanon | Pennsylvania | 42075 | 10150 | 173 |
916246 | 916246 | 2021-01-10 | Lebanon | Pennsylvania | 42075 | 10075 | 172 |
913001 | 913001 | 2021-01-09 | Lebanon | Pennsylvania | 42075 | 9971 | 172 |
909756 | 909756 | 2021-01-08 | Lebanon | Pennsylvania | 42075 | 9762 | 169 |
906511 | 906511 | 2021-01-07 | Lebanon | Pennsylvania | 42075 | 9629 | 166 |
903265 | 903265 | 2021-01-06 | Lebanon | Pennsylvania | 42075 | 9504 | 163 |
900020 | 900020 | 2021-01-05 | Lebanon | Pennsylvania | 42075 | 9357 | 160 |
896775 | 896775 | 2021-01-04 | Lebanon | Pennsylvania | 42075 | 9206 | 158 |
893529 | 893529 | 2021-01-03 | Lebanon | Pennsylvania | 42075 | 9167 | 158 |
890283 | 890283 | 2021-01-02 | Lebanon | Pennsylvania | 42075 | 9087 | 158 |
887036 | 887036 | 2021-01-01 | Lebanon | Pennsylvania | 42075 | 8956 | 158 |
883791 | 883791 | 2020-12-31 | Lebanon | Pennsylvania | 42075 | 8851 | 156 |
880546 | 880546 | 2020-12-30 | Lebanon | Pennsylvania | 42075 | 8716 | 152 |
877301 | 877301 | 2020-12-29 | Lebanon | Pennsylvania | 42075 | 8569 | 148 |
874056 | 874056 | 2020-12-28 | Lebanon | Pennsylvania | 42075 | 8447 | 147 |
870811 | 870811 | 2020-12-27 | Lebanon | Pennsylvania | 42075 | 8397 | 146 |
867566 | 867566 | 2020-12-26 | Lebanon | Pennsylvania | 42075 | 8285 | 148 |
864321 | 864321 | 2020-12-25 | Lebanon | Pennsylvania | 42075 | 8182 | 148 |
861076 | 861076 | 2020-12-24 | Lebanon | Pennsylvania | 42075 | 8111 | 145 |
857831 | 857831 | 2020-12-23 | Lebanon | Pennsylvania | 42075 | 8002 | 144 |
854586 | 854586 | 2020-12-22 | Lebanon | Pennsylvania | 42075 | 7867 | 142 |
851341 | 851341 | 2020-12-21 | Lebanon | Pennsylvania | 42075 | 7789 | 141 |
848096 | 848096 | 2020-12-20 | Lebanon | Pennsylvania | 42075 | 7693 | 141 |
844851 | 844851 | 2020-12-19 | Lebanon | Pennsylvania | 42075 | 7585 | 138 |
841605 | 841605 | 2020-12-18 | Lebanon | Pennsylvania | 42075 | 7469 | 138 |
838360 | 838360 | 2020-12-17 | Lebanon | Pennsylvania | 42075 | 7357 | 138 |
835114 | 835114 | 2020-12-16 | Lebanon | Pennsylvania | 42075 | 7252 | 137 |
831868 | 831868 | 2020-12-15 | Lebanon | Pennsylvania | 42075 | 7147 | 132 |
828621 | 828621 | 2020-12-14 | Lebanon | Pennsylvania | 42075 | 7044 | 132 |
825375 | 825375 | 2020-12-13 | Lebanon | Pennsylvania | 42075 | 6931 | 132 |
822128 | 822128 | 2020-12-12 | Lebanon | Pennsylvania | 42075 | 6736 | 129 |
818882 | 818882 | 2020-12-11 | Lebanon | Pennsylvania | 42075 | 6613 | 128 |
815636 | 815636 | 2020-12-10 | Lebanon | Pennsylvania | 42075 | 6514 | 128 |
812390 | 812390 | 2020-12-09 | Lebanon | Pennsylvania | 42075 | 6385 | 124 |
809146 | 809146 | 2020-12-08 | Lebanon | Pennsylvania | 42075 | 6290 | 123 |
805901 | 805901 | 2020-12-07 | Lebanon | Pennsylvania | 42075 | 6159 | 121 |
802656 | 802656 | 2020-12-06 | Lebanon | Pennsylvania | 42075 | 6106 | 120 |
799411 | 799411 | 2020-12-05 | Lebanon | Pennsylvania | 42075 | 6040 | 120 |
796166 | 796166 | 2020-12-04 | Lebanon | Pennsylvania | 42075 | 5891 | 119 |
792921 | 792921 | 2020-12-03 | Lebanon | Pennsylvania | 42075 | 5754 | 114 |
789676 | 789676 | 2020-12-02 | Lebanon | Pennsylvania | 42075 | 5550 | 113 |
786431 | 786431 | 2020-12-01 | Lebanon | Pennsylvania | 42075 | 5386 | 112 |
783187 | 783187 | 2020-11-30 | Lebanon | Pennsylvania | 42075 | 5336 | 108 |
779942 | 779942 | 2020-11-29 | Lebanon | Pennsylvania | 42075 | 5282 | 106 |
776696 | 776696 | 2020-11-28 | Lebanon | Pennsylvania | 42075 | 5204 | 106 |
773451 | 773451 | 2020-11-27 | Lebanon | Pennsylvania | 42075 | 5105 | 106 |
770206 | 770206 | 2020-11-26 | Lebanon | Pennsylvania | 42075 | 5036 | 106 |
766960 | 766960 | 2020-11-25 | Lebanon | Pennsylvania | 42075 | 4935 | 105 |
763715 | 763715 | 2020-11-24 | Lebanon | Pennsylvania | 42075 | 4860 | 104 |
760470 | 760470 | 2020-11-23 | Lebanon | Pennsylvania | 42075 | 4763 | 103 |
757225 | 757225 | 2020-11-22 | Lebanon | Pennsylvania | 42075 | 4712 | 101 |
753978 | 753978 | 2020-11-21 | Lebanon | Pennsylvania | 42075 | 4519 | 100 |
750732 | 750732 | 2020-11-20 | Lebanon | Pennsylvania | 42075 | 4444 | 95 |
747486 | 747486 | 2020-11-19 | Lebanon | Pennsylvania | 42075 | 4361 | 92 |
744240 | 744240 | 2020-11-18 | Lebanon | Pennsylvania | 42075 | 4279 | 89 |
740993 | 740993 | 2020-11-17 | Lebanon | Pennsylvania | 42075 | 4189 | 87 |
737747 | 737747 | 2020-11-16 | Lebanon | Pennsylvania | 42075 | 4110 | 85 |
734503 | 734503 | 2020-11-15 | Lebanon | Pennsylvania | 42075 | 4045 | 83 |
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);