home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

52,441 rows where state = "Pennsylvania" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips >30

  • 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
  • …

county >30

  • 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
  • …

state 1

  • Pennsylvania · 52,441 ✖
Link rowid date ▲ county state fips cases deaths
2501847 2501847 2022-05-13 Adams Pennsylvania 42001 25114 364
2501848 2501848 2022-05-13 Allegheny Pennsylvania 42003 271427 3323
2501849 2501849 2022-05-13 Armstrong Pennsylvania 42005 15397 343
2501850 2501850 2022-05-13 Beaver Pennsylvania 42007 40744 745
2501851 2501851 2022-05-13 Bedford Pennsylvania 42009 11044 275
2501852 2501852 2022-05-13 Berks Pennsylvania 42011 103652 1595
2501853 2501853 2022-05-13 Blair Pennsylvania 42013 29924 616
2501854 2501854 2022-05-13 Bradford Pennsylvania 42015 16219 207
2501855 2501855 2022-05-13 Bucks Pennsylvania 42017 126504 1905
2501856 2501856 2022-05-13 Butler Pennsylvania 42019 45173 743
2501857 2501857 2022-05-13 Cambria Pennsylvania 42021 34936 732
2501858 2501858 2022-05-13 Cameron Pennsylvania 42023 822 21
2501859 2501859 2022-05-13 Carbon Pennsylvania 42025 16188 294
2501860 2501860 2022-05-13 Centre Pennsylvania 42027 36016 351
2501861 2501861 2022-05-13 Chester Pennsylvania 42029 94968 1164
2501862 2501862 2022-05-13 Clarion Pennsylvania 42031 8323 202
2501863 2501863 2022-05-13 Clearfield Pennsylvania 42033 19533 348
2501864 2501864 2022-05-13 Clinton Pennsylvania 42035 9157 127
2501865 2501865 2022-05-13 Columbia Pennsylvania 42037 15476 246
2501866 2501866 2022-05-13 Crawford Pennsylvania 42039 20080 320
2501867 2501867 2022-05-13 Cumberland Pennsylvania 42041 51754 892
2501868 2501868 2022-05-13 Dauphin Pennsylvania 42043 59830 964
2501869 2501869 2022-05-13 Delaware Pennsylvania 42045 113339 1875
2501870 2501870 2022-05-13 Elk Pennsylvania 42047 7193 101
2501871 2501871 2022-05-13 Erie Pennsylvania 42049 58218 760
2501872 2501872 2022-05-13 Fayette Pennsylvania 42051 31332 674
2501873 2501873 2022-05-13 Forest Pennsylvania 42053 2250 35
2501874 2501874 2022-05-13 Franklin Pennsylvania 42055 40694 695
2501875 2501875 2022-05-13 Fulton Pennsylvania 42057 4153 65
2501876 2501876 2022-05-13 Greene Pennsylvania 42059 8513 104
2501877 2501877 2022-05-13 Huntingdon Pennsylvania 42061 11594 249
2501878 2501878 2022-05-13 Indiana Pennsylvania 42063 17690 356
2501879 2501879 2022-05-13 Jefferson Pennsylvania 42065 9121 235
2501880 2501880 2022-05-13 Juniata Pennsylvania 42067 4797 176
2501881 2501881 2022-05-13 Lackawanna Pennsylvania 42069 45137 776
2501882 2501882 2022-05-13 Lancaster Pennsylvania 42071 122794 1890
2501883 2501883 2022-05-13 Lawrence Pennsylvania 42073 19109 418
2501884 2501884 2022-05-13 Lebanon Pennsylvania 42075 37011 518
2501885 2501885 2022-05-13 Lehigh Pennsylvania 42077 91539 1246
2501886 2501886 2022-05-13 Luzerne Pennsylvania 42079 75379 1366
2501887 2501887 2022-05-13 Lycoming Pennsylvania 42081 28894 522
2501888 2501888 2022-05-13 McKean Pennsylvania 42083 8298 141
2501889 2501889 2022-05-13 Mercer Pennsylvania 42085 23612 498
2501890 2501890 2022-05-13 Mifflin Pennsylvania 42087 12348 276
2501891 2501891 2022-05-13 Monroe Pennsylvania 42089 37881 524
2501892 2501892 2022-05-13 Montgomery Pennsylvania 42091 158154 2329
2501893 2501893 2022-05-13 Montour Pennsylvania 42093 4637 93
2501894 2501894 2022-05-13 Northampton Pennsylvania 42095 81732 1097
2501895 2501895 2022-05-13 Northumberland Pennsylvania 42097 23172 534
2501896 2501896 2022-05-13 Perry Pennsylvania 42099 8873 185
2501897 2501897 2022-05-13 Philadelphia Pennsylvania 42101 317808 5110
2501898 2501898 2022-05-13 Pike Pennsylvania 42103 10557 98
2501899 2501899 2022-05-13 Potter Pennsylvania 42105 3256 92
2501900 2501900 2022-05-13 Schuylkill Pennsylvania 42107 34853 675
2501901 2501901 2022-05-13 Snyder Pennsylvania 42109 8149 158
2501902 2501902 2022-05-13 Somerset Pennsylvania 42111 18829 408
2501903 2501903 2022-05-13 Sullivan Pennsylvania 42113 1092 36
2501904 2501904 2022-05-13 Susquehanna Pennsylvania 42115 8188 110
2501905 2501905 2022-05-13 Tioga Pennsylvania 42117 8270 193
2501906 2501906 2022-05-13 Union Pennsylvania 42119 11842 154
2501907 2501907 2022-05-13 Venango Pennsylvania 42121 11406 241
2501908 2501908 2022-05-13 Warren Pennsylvania 42123 7506 212
2501909 2501909 2022-05-13 Washington Pennsylvania 42125 51747 654
2501910 2501910 2022-05-13 Wayne Pennsylvania 42127 10460 172
2501911 2501911 2022-05-13 Westmoreland Pennsylvania 42129 81006 1378
2501912 2501912 2022-05-13 Wyoming Pennsylvania 42131 5257 106
2501913 2501913 2022-05-13 York Pennsylvania 42133 120372 1502
2498589 2498589 2022-05-12 Adams Pennsylvania 42001 25114 364
2498590 2498590 2022-05-12 Allegheny Pennsylvania 42003 271427 3323
2498591 2498591 2022-05-12 Armstrong Pennsylvania 42005 15397 343
2498592 2498592 2022-05-12 Beaver Pennsylvania 42007 40744 745
2498593 2498593 2022-05-12 Bedford Pennsylvania 42009 11044 275
2498594 2498594 2022-05-12 Berks Pennsylvania 42011 103652 1595
2498595 2498595 2022-05-12 Blair Pennsylvania 42013 29924 616
2498596 2498596 2022-05-12 Bradford Pennsylvania 42015 16219 207
2498597 2498597 2022-05-12 Bucks Pennsylvania 42017 126504 1905
2498598 2498598 2022-05-12 Butler Pennsylvania 42019 45173 743
2498599 2498599 2022-05-12 Cambria Pennsylvania 42021 34936 732
2498600 2498600 2022-05-12 Cameron Pennsylvania 42023 822 21
2498601 2498601 2022-05-12 Carbon Pennsylvania 42025 16188 294
2498602 2498602 2022-05-12 Centre Pennsylvania 42027 36016 351
2498603 2498603 2022-05-12 Chester Pennsylvania 42029 94968 1164
2498604 2498604 2022-05-12 Clarion Pennsylvania 42031 8323 202
2498605 2498605 2022-05-12 Clearfield Pennsylvania 42033 19533 348
2498606 2498606 2022-05-12 Clinton Pennsylvania 42035 9157 127
2498607 2498607 2022-05-12 Columbia Pennsylvania 42037 15476 246
2498608 2498608 2022-05-12 Crawford Pennsylvania 42039 20080 320
2498609 2498609 2022-05-12 Cumberland Pennsylvania 42041 51754 892
2498610 2498610 2022-05-12 Dauphin Pennsylvania 42043 59830 964
2498611 2498611 2022-05-12 Delaware Pennsylvania 42045 113339 1875
2498612 2498612 2022-05-12 Elk Pennsylvania 42047 7193 101
2498613 2498613 2022-05-12 Erie Pennsylvania 42049 58218 760
2498614 2498614 2022-05-12 Fayette Pennsylvania 42051 31332 674
2498615 2498615 2022-05-12 Forest Pennsylvania 42053 2250 35
2498616 2498616 2022-05-12 Franklin Pennsylvania 42055 40694 695
2498617 2498617 2022-05-12 Fulton Pennsylvania 42057 4153 65
2498618 2498618 2022-05-12 Greene Pennsylvania 42059 8513 104
2498619 2498619 2022-05-12 Huntingdon Pennsylvania 42061 11594 249
2498620 2498620 2022-05-12 Indiana Pennsylvania 42063 17690 356
2498621 2498621 2022-05-12 Jefferson Pennsylvania 42065 9121 235

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 434.044ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette