ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
250 rows where deaths = 12 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1919621 | 1919621 | 2021-11-15 | Cameron | Pennsylvania | 42023 | 553 | 12 |
1916371 | 1916371 | 2021-11-14 | Cameron | Pennsylvania | 42023 | 550 | 12 |
994156 | 994156 | 2021-02-03 | Sullivan | Pennsylvania | 42113 | 284 | 12 |
971406 | 971406 | 2021-01-27 | Fulton | Pennsylvania | 42057 | 1016 | 12 |
968161 | 968161 | 2021-01-26 | Fulton | Pennsylvania | 42057 | 1013 | 12 |
964915 | 964915 | 2021-01-25 | Forest | Pennsylvania | 42053 | 1248 | 12 |
964917 | 964917 | 2021-01-25 | Fulton | Pennsylvania | 42057 | 989 | 12 |
961670 | 961670 | 2021-01-24 | Forest | Pennsylvania | 42053 | 1247 | 12 |
961672 | 961672 | 2021-01-24 | Fulton | Pennsylvania | 42057 | 984 | 12 |
958425 | 958425 | 2021-01-23 | Forest | Pennsylvania | 42053 | 1246 | 12 |
958427 | 958427 | 2021-01-23 | Fulton | Pennsylvania | 42057 | 980 | 12 |
955181 | 955181 | 2021-01-22 | Fulton | Pennsylvania | 42057 | 973 | 12 |
951936 | 951936 | 2021-01-21 | Fulton | Pennsylvania | 42057 | 963 | 12 |
948691 | 948691 | 2021-01-20 | Fulton | Pennsylvania | 42057 | 954 | 12 |
945445 | 945445 | 2021-01-19 | Fulton | Pennsylvania | 42057 | 940 | 12 |
942198 | 942198 | 2021-01-18 | Fulton | Pennsylvania | 42057 | 931 | 12 |
938953 | 938953 | 2021-01-17 | Fulton | Pennsylvania | 42057 | 923 | 12 |
935708 | 935708 | 2021-01-16 | Fulton | Pennsylvania | 42057 | 917 | 12 |
932463 | 932463 | 2021-01-15 | Fulton | Pennsylvania | 42057 | 903 | 12 |
929218 | 929218 | 2021-01-14 | Fulton | Pennsylvania | 42057 | 893 | 12 |
925973 | 925973 | 2021-01-13 | Fulton | Pennsylvania | 42057 | 885 | 12 |
922727 | 922727 | 2021-01-12 | Fulton | Pennsylvania | 42057 | 878 | 12 |
867581 | 867581 | 2020-12-26 | Potter | Pennsylvania | 42105 | 540 | 12 |
864336 | 864336 | 2020-12-25 | Potter | Pennsylvania | 42105 | 517 | 12 |
861068 | 861068 | 2020-12-24 | Greene | Pennsylvania | 42059 | 1489 | 12 |
861091 | 861091 | 2020-12-24 | Potter | Pennsylvania | 42105 | 514 | 12 |
851345 | 851345 | 2020-12-21 | McKean | Pennsylvania | 42083 | 1349 | 12 |
848100 | 848100 | 2020-12-20 | McKean | Pennsylvania | 42083 | 1323 | 12 |
844855 | 844855 | 2020-12-19 | McKean | Pennsylvania | 42083 | 1296 | 12 |
828607 | 828607 | 2020-12-14 | Elk | Pennsylvania | 42047 | 861 | 12 |
825361 | 825361 | 2020-12-13 | Elk | Pennsylvania | 42047 | 855 | 12 |
812413 | 812413 | 2020-12-09 | Venango | Pennsylvania | 42121 | 1416 | 12 |
809169 | 809169 | 2020-12-08 | Venango | Pennsylvania | 42121 | 1315 | 12 |
805924 | 805924 | 2020-12-07 | Venango | Pennsylvania | 42121 | 1256 | 12 |
805927 | 805927 | 2020-12-07 | Wayne | Pennsylvania | 42127 | 711 | 12 |
802679 | 802679 | 2020-12-06 | Venango | Pennsylvania | 42121 | 1216 | 12 |
802682 | 802682 | 2020-12-06 | Wayne | Pennsylvania | 42127 | 705 | 12 |
799437 | 799437 | 2020-12-05 | Wayne | Pennsylvania | 42127 | 668 | 12 |
796146 | 796146 | 2020-12-04 | Clinton | Pennsylvania | 42035 | 850 | 12 |
796192 | 796192 | 2020-12-04 | Wayne | Pennsylvania | 42127 | 640 | 12 |
792947 | 792947 | 2020-12-03 | Wayne | Pennsylvania | 42127 | 605 | 12 |
789688 | 789688 | 2020-12-02 | Perry | Pennsylvania | 42099 | 711 | 12 |
789702 | 789702 | 2020-12-02 | Wayne | Pennsylvania | 42127 | 585 | 12 |
786457 | 786457 | 2020-12-01 | Wayne | Pennsylvania | 42127 | 569 | 12 |
783166 | 783166 | 2020-11-30 | Clearfield | Pennsylvania | 42033 | 1693 | 12 |
783213 | 783213 | 2020-11-30 | Wayne | Pennsylvania | 42127 | 538 | 12 |
779921 | 779921 | 2020-11-29 | Clearfield | Pennsylvania | 42033 | 1639 | 12 |
779938 | 779938 | 2020-11-29 | Juniata | Pennsylvania | 42067 | 732 | 12 |
779968 | 779968 | 2020-11-29 | Wayne | Pennsylvania | 42127 | 527 | 12 |
776692 | 776692 | 2020-11-28 | Juniata | Pennsylvania | 42067 | 724 | 12 |
776722 | 776722 | 2020-11-28 | Wayne | Pennsylvania | 42127 | 481 | 12 |
773447 | 773447 | 2020-11-27 | Juniata | Pennsylvania | 42067 | 704 | 12 |
773477 | 773477 | 2020-11-27 | Wayne | Pennsylvania | 42127 | 465 | 12 |
770202 | 770202 | 2020-11-26 | Juniata | Pennsylvania | 42067 | 687 | 12 |
770232 | 770232 | 2020-11-26 | Wayne | Pennsylvania | 42127 | 449 | 12 |
766956 | 766956 | 2020-11-25 | Juniata | Pennsylvania | 42067 | 652 | 12 |
766986 | 766986 | 2020-11-25 | Wayne | Pennsylvania | 42127 | 432 | 12 |
763711 | 763711 | 2020-11-24 | Juniata | Pennsylvania | 42067 | 632 | 12 |
763741 | 763741 | 2020-11-24 | Wayne | Pennsylvania | 42127 | 417 | 12 |
760452 | 760452 | 2020-11-23 | Crawford | Pennsylvania | 42039 | 1508 | 12 |
760466 | 760466 | 2020-11-23 | Juniata | Pennsylvania | 42067 | 621 | 12 |
760496 | 760496 | 2020-11-23 | Wayne | Pennsylvania | 42127 | 409 | 12 |
757207 | 757207 | 2020-11-22 | Crawford | Pennsylvania | 42039 | 1470 | 12 |
757221 | 757221 | 2020-11-22 | Juniata | Pennsylvania | 42067 | 595 | 12 |
757251 | 757251 | 2020-11-22 | Wayne | Pennsylvania | 42127 | 404 | 12 |
753974 | 753974 | 2020-11-21 | Juniata | Pennsylvania | 42067 | 569 | 12 |
754004 | 754004 | 2020-11-21 | Wayne | Pennsylvania | 42127 | 391 | 12 |
750699 | 750699 | 2020-11-20 | Bedford | Pennsylvania | 42009 | 1113 | 12 |
750758 | 750758 | 2020-11-20 | Wayne | Pennsylvania | 42127 | 383 | 12 |
747453 | 747453 | 2020-11-19 | Bedford | Pennsylvania | 42009 | 1069 | 12 |
747492 | 747492 | 2020-11-19 | Mifflin | Pennsylvania | 42087 | 1136 | 12 |
747512 | 747512 | 2020-11-19 | Wayne | Pennsylvania | 42127 | 370 | 12 |
744266 | 744266 | 2020-11-18 | Wayne | Pennsylvania | 42127 | 360 | 12 |
741019 | 741019 | 2020-11-17 | Wayne | Pennsylvania | 42127 | 357 | 12 |
737769 | 737769 | 2020-11-16 | Union | Pennsylvania | 42119 | 1016 | 12 |
737773 | 737773 | 2020-11-16 | Wayne | Pennsylvania | 42127 | 351 | 12 |
734525 | 734525 | 2020-11-15 | Union | Pennsylvania | 42119 | 1003 | 12 |
734529 | 734529 | 2020-11-15 | Wayne | Pennsylvania | 42127 | 348 | 12 |
731279 | 731279 | 2020-11-14 | Union | Pennsylvania | 42119 | 966 | 12 |
731283 | 731283 | 2020-11-14 | Wayne | Pennsylvania | 42127 | 340 | 12 |
728035 | 728035 | 2020-11-13 | Union | Pennsylvania | 42119 | 922 | 12 |
728039 | 728039 | 2020-11-13 | Wayne | Pennsylvania | 42127 | 341 | 12 |
724791 | 724791 | 2020-11-12 | Union | Pennsylvania | 42119 | 901 | 12 |
724795 | 724795 | 2020-11-12 | Wayne | Pennsylvania | 42127 | 333 | 12 |
721535 | 721535 | 2020-11-11 | Montour | Pennsylvania | 42093 | 352 | 12 |
721552 | 721552 | 2020-11-11 | Wayne | Pennsylvania | 42127 | 331 | 12 |
721554 | 721554 | 2020-11-11 | Wyoming | Pennsylvania | 42131 | 255 | 12 |
718292 | 718292 | 2020-11-10 | Montour | Pennsylvania | 42093 | 346 | 12 |
718309 | 718309 | 2020-11-10 | Wayne | Pennsylvania | 42127 | 326 | 12 |
718311 | 718311 | 2020-11-10 | Wyoming | Pennsylvania | 42131 | 247 | 12 |
715049 | 715049 | 2020-11-09 | Montour | Pennsylvania | 42093 | 342 | 12 |
715066 | 715066 | 2020-11-09 | Wayne | Pennsylvania | 42127 | 322 | 12 |
711805 | 711805 | 2020-11-08 | Montour | Pennsylvania | 42093 | 335 | 12 |
711822 | 711822 | 2020-11-08 | Wayne | Pennsylvania | 42127 | 318 | 12 |
708561 | 708561 | 2020-11-07 | Montour | Pennsylvania | 42093 | 333 | 12 |
708578 | 708578 | 2020-11-07 | Wayne | Pennsylvania | 42127 | 313 | 12 |
705282 | 705282 | 2020-11-06 | Cambria | Pennsylvania | 42021 | 1456 | 12 |
705335 | 705335 | 2020-11-06 | Wayne | Pennsylvania | 42127 | 308 | 12 |
702039 | 702039 | 2020-11-05 | Cambria | Pennsylvania | 42021 | 1410 | 12 |
702092 | 702092 | 2020-11-05 | Wayne | Pennsylvania | 42127 | 302 | 12 |
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);