ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52,441 rows where state = "Pennsylvania" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 68
- 42045 799
- 42127 799
- 42091 798
- 42089 796
- 42101 795
- 42017 794
- 42095 793
- 42103 793
- 42029 792
- 42041 792
- 42125 792
- 42003 791
- 42077 790
- 42079 790
- 42007 788
- 42001 787
- 42011 787
- 42069 787
- 42133 787
- 42071 786
- 42075 786
- 42129 786
- 42027 785
- 42049 785
- 42055 785
- 42105 785
- 42019 784
- 42093 784
- 42037 783
- 42043 783
- 42051 783
- 42085 783
- 42107 783
- 42021 782
- 42005 781
- 42015 781
- 42025 781
- 42033 781
- 42067 781
- 42111 781
- 42059 780
- 42073 780
- 42081 780
- 42123 780
- 42013 779
- 42039 779
- 42063 779
- 42115 779
- 42097 778
- 42023 777
- 42031 777
- 42061 777
- 42083 777
- 42099 777
- 42109 777
- 42117 777
- 42087 776
- 42121 776
- 42119 775
- 42009 774
- 42053 772
- 42035 771
- 42113 770
- 42131 770
- 42057 769
- 42047 767
- 42065 767
- - 2
county 68
- Delaware 799
- Wayne 799
- Montgomery 798
- Monroe 796
- Philadelphia 795
- Bucks 794
- Northampton 793
- Pike 793
- Chester 792
- Cumberland 792
- Washington 792
- Allegheny 791
- Lehigh 790
- Luzerne 790
- Beaver 788
- Adams 787
- Berks 787
- Lackawanna 787
- York 787
- Lancaster 786
- Lebanon 786
- Westmoreland 786
- Centre 785
- Erie 785
- Franklin 785
- Potter 785
- Butler 784
- Montour 784
- Columbia 783
- Dauphin 783
- Fayette 783
- Mercer 783
- Schuylkill 783
- Cambria 782
- Armstrong 781
- Bradford 781
- Carbon 781
- Clearfield 781
- Juniata 781
- Somerset 781
- Greene 780
- Lawrence 780
- Lycoming 780
- Warren 780
- Blair 779
- Crawford 779
- Indiana 779
- Susquehanna 779
- Northumberland 778
- Cameron 777
- Clarion 777
- Huntingdon 777
- McKean 777
- Perry 777
- Snyder 777
- Tioga 777
- Mifflin 776
- Venango 776
- Union 775
- Bedford 774
- Forest 772
- Clinton 771
- Sullivan 770
- Wyoming 770
- Fulton 769
- Elk 767
- Jefferson 767
- Unknown 2
state 1
- Pennsylvania · 52,441 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635 | 635 | 2020-03-06 | Delaware | Pennsylvania | 42045 | 1 | 0 |
636 | 636 | 2020-03-06 | Wayne | Pennsylvania | 42127 | 1 | 0 |
726 | 726 | 2020-03-07 | Delaware | Pennsylvania | 42045 | 1 | 0 |
727 | 727 | 2020-03-07 | Montgomery | Pennsylvania | 42091 | 2 | 0 |
728 | 728 | 2020-03-07 | Wayne | Pennsylvania | 42127 | 1 | 0 |
835 | 835 | 2020-03-08 | Delaware | Pennsylvania | 42045 | 1 | 0 |
836 | 836 | 2020-03-08 | Montgomery | Pennsylvania | 42091 | 4 | 0 |
837 | 837 | 2020-03-08 | Wayne | Pennsylvania | 42127 | 1 | 0 |
963 | 963 | 2020-03-09 | Delaware | Pennsylvania | 42045 | 1 | 0 |
964 | 964 | 2020-03-09 | Monroe | Pennsylvania | 42089 | 1 | 0 |
965 | 965 | 2020-03-09 | Montgomery | Pennsylvania | 42091 | 7 | 0 |
966 | 966 | 2020-03-09 | Wayne | Pennsylvania | 42127 | 1 | 0 |
1115 | 1115 | 2020-03-10 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1116 | 1116 | 2020-03-10 | Monroe | Pennsylvania | 42089 | 1 | 0 |
1117 | 1117 | 2020-03-10 | Montgomery | Pennsylvania | 42091 | 8 | 0 |
1118 | 1118 | 2020-03-10 | Philadelphia | Pennsylvania | 42101 | 1 | 0 |
1119 | 1119 | 2020-03-10 | Wayne | Pennsylvania | 42127 | 1 | 0 |
1308 | 1308 | 2020-03-11 | Bucks | Pennsylvania | 42017 | 2 | 0 |
1309 | 1309 | 2020-03-11 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1310 | 1310 | 2020-03-11 | Monroe | Pennsylvania | 42089 | 2 | 0 |
1311 | 1311 | 2020-03-11 | Montgomery | Pennsylvania | 42091 | 9 | 0 |
1312 | 1312 | 2020-03-11 | Philadelphia | Pennsylvania | 42101 | 1 | 0 |
1313 | 1313 | 2020-03-11 | Wayne | Pennsylvania | 42127 | 1 | 0 |
1552 | 1552 | 2020-03-12 | Bucks | Pennsylvania | 42017 | 2 | 0 |
1553 | 1553 | 2020-03-12 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1554 | 1554 | 2020-03-12 | Monroe | Pennsylvania | 42089 | 2 | 0 |
1555 | 1555 | 2020-03-12 | Montgomery | Pennsylvania | 42091 | 13 | 0 |
1556 | 1556 | 2020-03-12 | Northampton | Pennsylvania | 42095 | 1 | 0 |
1557 | 1557 | 2020-03-12 | Philadelphia | Pennsylvania | 42101 | 1 | 0 |
1558 | 1558 | 2020-03-12 | Pike | Pennsylvania | 42103 | 1 | 0 |
1559 | 1559 | 2020-03-12 | Wayne | Pennsylvania | 42127 | 1 | 0 |
1848 | 1848 | 2020-03-13 | Bucks | Pennsylvania | 42017 | 3 | 0 |
1849 | 1849 | 2020-03-13 | Chester | Pennsylvania | 42029 | 1 | 0 |
1850 | 1850 | 2020-03-13 | Cumberland | Pennsylvania | 42041 | 3 | 0 |
1851 | 1851 | 2020-03-13 | Delaware | Pennsylvania | 42045 | 6 | 0 |
1852 | 1852 | 2020-03-13 | Monroe | Pennsylvania | 42089 | 3 | 0 |
1853 | 1853 | 2020-03-13 | Montgomery | Pennsylvania | 42091 | 18 | 0 |
1854 | 1854 | 2020-03-13 | Northampton | Pennsylvania | 42095 | 1 | 0 |
1855 | 1855 | 2020-03-13 | Philadelphia | Pennsylvania | 42101 | 3 | 0 |
1856 | 1856 | 2020-03-13 | Pike | Pennsylvania | 42103 | 1 | 0 |
1857 | 1857 | 2020-03-13 | Washington | Pennsylvania | 42125 | 1 | 0 |
1858 | 1858 | 2020-03-13 | Wayne | Pennsylvania | 42127 | 1 | 0 |
2209 | 2209 | 2020-03-14 | Allegheny | Pennsylvania | 42003 | 1 | 0 |
2210 | 2210 | 2020-03-14 | Bucks | Pennsylvania | 42017 | 4 | 0 |
2211 | 2211 | 2020-03-14 | Chester | Pennsylvania | 42029 | 2 | 0 |
2212 | 2212 | 2020-03-14 | Cumberland | Pennsylvania | 42041 | 3 | 0 |
2213 | 2213 | 2020-03-14 | Delaware | Pennsylvania | 42045 | 6 | 0 |
2214 | 2214 | 2020-03-14 | Monroe | Pennsylvania | 42089 | 3 | 0 |
2215 | 2215 | 2020-03-14 | Montgomery | Pennsylvania | 42091 | 20 | 0 |
2216 | 2216 | 2020-03-14 | Northampton | Pennsylvania | 42095 | 1 | 0 |
2217 | 2217 | 2020-03-14 | Philadelphia | Pennsylvania | 42101 | 4 | 0 |
2218 | 2218 | 2020-03-14 | Pike | Pennsylvania | 42103 | 1 | 0 |
2219 | 2219 | 2020-03-14 | Washington | Pennsylvania | 42125 | 1 | 0 |
2220 | 2220 | 2020-03-14 | Wayne | Pennsylvania | 42127 | 1 | 0 |
2629 | 2629 | 2020-03-15 | Allegheny | Pennsylvania | 42003 | 3 | 0 |
2630 | 2630 | 2020-03-15 | Bucks | Pennsylvania | 42017 | 4 | 0 |
2631 | 2631 | 2020-03-15 | Chester | Pennsylvania | 42029 | 4 | 0 |
2632 | 2632 | 2020-03-15 | Cumberland | Pennsylvania | 42041 | 5 | 0 |
2633 | 2633 | 2020-03-15 | Delaware | Pennsylvania | 42045 | 7 | 0 |
2634 | 2634 | 2020-03-15 | Lehigh | Pennsylvania | 42077 | 1 | 0 |
2635 | 2635 | 2020-03-15 | Luzerne | Pennsylvania | 42079 | 1 | 0 |
2636 | 2636 | 2020-03-15 | Monroe | Pennsylvania | 42089 | 7 | 0 |
2637 | 2637 | 2020-03-15 | Montgomery | Pennsylvania | 42091 | 24 | 0 |
2638 | 2638 | 2020-03-15 | Northampton | Pennsylvania | 42095 | 1 | 0 |
2639 | 2639 | 2020-03-15 | Philadelphia | Pennsylvania | 42101 | 8 | 0 |
2640 | 2640 | 2020-03-15 | Pike | Pennsylvania | 42103 | 1 | 0 |
2641 | 2641 | 2020-03-15 | Washington | Pennsylvania | 42125 | 1 | 0 |
2642 | 2642 | 2020-03-15 | Wayne | Pennsylvania | 42127 | 1 | 0 |
3094 | 3094 | 2020-03-16 | Allegheny | Pennsylvania | 42003 | 5 | 0 |
3095 | 3095 | 2020-03-16 | Bucks | Pennsylvania | 42017 | 7 | 0 |
3096 | 3096 | 2020-03-16 | Chester | Pennsylvania | 42029 | 4 | 0 |
3097 | 3097 | 2020-03-16 | Cumberland | Pennsylvania | 42041 | 5 | 0 |
3098 | 3098 | 2020-03-16 | Delaware | Pennsylvania | 42045 | 7 | 0 |
3099 | 3099 | 2020-03-16 | Lehigh | Pennsylvania | 42077 | 1 | 0 |
3100 | 3100 | 2020-03-16 | Luzerne | Pennsylvania | 42079 | 1 | 0 |
3101 | 3101 | 2020-03-16 | Monroe | Pennsylvania | 42089 | 9 | 0 |
3102 | 3102 | 2020-03-16 | Montgomery | Pennsylvania | 42091 | 30 | 0 |
3103 | 3103 | 2020-03-16 | Northampton | Pennsylvania | 42095 | 1 | 0 |
3104 | 3104 | 2020-03-16 | Philadelphia | Pennsylvania | 42101 | 8 | 0 |
3105 | 3105 | 2020-03-16 | Pike | Pennsylvania | 42103 | 1 | 0 |
3106 | 3106 | 2020-03-16 | Washington | Pennsylvania | 42125 | 1 | 0 |
3107 | 3107 | 2020-03-16 | Wayne | Pennsylvania | 42127 | 1 | 0 |
3623 | 3623 | 2020-03-17 | Allegheny | Pennsylvania | 42003 | 10 | 0 |
3624 | 3624 | 2020-03-17 | Beaver | Pennsylvania | 42007 | 1 | 0 |
3625 | 3625 | 2020-03-17 | Bucks | Pennsylvania | 42017 | 9 | 0 |
3626 | 3626 | 2020-03-17 | Chester | Pennsylvania | 42029 | 4 | 0 |
3627 | 3627 | 2020-03-17 | Cumberland | Pennsylvania | 42041 | 10 | 0 |
3628 | 3628 | 2020-03-17 | Delaware | Pennsylvania | 42045 | 9 | 0 |
3629 | 3629 | 2020-03-17 | Lehigh | Pennsylvania | 42077 | 1 | 0 |
3630 | 3630 | 2020-03-17 | Luzerne | Pennsylvania | 42079 | 1 | 0 |
3631 | 3631 | 2020-03-17 | Monroe | Pennsylvania | 42089 | 9 | 0 |
3632 | 3632 | 2020-03-17 | Montgomery | Pennsylvania | 42091 | 32 | 0 |
3633 | 3633 | 2020-03-17 | Northampton | Pennsylvania | 42095 | 1 | 0 |
3634 | 3634 | 2020-03-17 | Philadelphia | Pennsylvania | 42101 | 10 | 0 |
3635 | 3635 | 2020-03-17 | Pike | Pennsylvania | 42103 | 1 | 0 |
3636 | 3636 | 2020-03-17 | Washington | Pennsylvania | 42125 | 2 | 0 |
3637 | 3637 | 2020-03-17 | Wayne | Pennsylvania | 42127 | 1 | 0 |
4238 | 4238 | 2020-03-18 | Adams | Pennsylvania | 42001 | 1 | 0 |
4239 | 4239 | 2020-03-18 | Allegheny | Pennsylvania | 42003 | 12 | 0 |
4240 | 4240 | 2020-03-18 | Beaver | Pennsylvania | 42007 | 2 | 0 |
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);