ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-05-05" 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 |
---|---|---|---|---|---|---|---|
1289546 | 1289546 | 2021-05-05 | Adams | Pennsylvania | 42001 | 9229 | 174 |
1289547 | 1289547 | 2021-05-05 | Allegheny | Pennsylvania | 42003 | 98355 | 1913 |
1289548 | 1289548 | 2021-05-05 | Armstrong | Pennsylvania | 42005 | 5799 | 133 |
1289549 | 1289549 | 2021-05-05 | Beaver | Pennsylvania | 42007 | 14865 | 378 |
1289550 | 1289550 | 2021-05-05 | Bedford | Pennsylvania | 42009 | 4396 | 135 |
1289551 | 1289551 | 2021-05-05 | Berks | Pennsylvania | 42011 | 46236 | 1000 |
1289552 | 1289552 | 2021-05-05 | Blair | Pennsylvania | 42013 | 12743 | 326 |
1289553 | 1289553 | 2021-05-05 | Bradford | Pennsylvania | 42015 | 5710 | 88 |
1289554 | 1289554 | 2021-05-05 | Bucks | Pennsylvania | 42017 | 59050 | 1257 |
1289555 | 1289555 | 2021-05-05 | Butler | Pennsylvania | 42019 | 16929 | 409 |
1289556 | 1289556 | 2021-05-05 | Cambria | Pennsylvania | 42021 | 13921 | 420 |
1289557 | 1289557 | 2021-05-05 | Cameron | Pennsylvania | 42023 | 293 | 8 |
1289558 | 1289558 | 2021-05-05 | Carbon | Pennsylvania | 42025 | 6135 | 169 |
1289559 | 1289559 | 2021-05-05 | Centre | Pennsylvania | 42027 | 16472 | 220 |
1289560 | 1289560 | 2021-05-05 | Chester | Pennsylvania | 42029 | 39578 | 780 |
1289561 | 1289561 | 2021-05-05 | Clarion | Pennsylvania | 42031 | 3091 | 91 |
1289562 | 1289562 | 2021-05-05 | Clearfield | Pennsylvania | 42033 | 8280 | 141 |
1289563 | 1289563 | 2021-05-05 | Clinton | Pennsylvania | 42035 | 3577 | 62 |
1289564 | 1289564 | 2021-05-05 | Columbia | Pennsylvania | 42037 | 5578 | 133 |
1289565 | 1289565 | 2021-05-05 | Crawford | Pennsylvania | 42039 | 7097 | 148 |
1289566 | 1289566 | 2021-05-05 | Cumberland | Pennsylvania | 42041 | 19861 | 513 |
1289567 | 1289567 | 2021-05-05 | Dauphin | Pennsylvania | 42043 | 25050 | 540 |
1289568 | 1289568 | 2021-05-05 | Delaware | Pennsylvania | 42045 | 50908 | 1398 |
1289569 | 1289569 | 2021-05-05 | Elk | Pennsylvania | 42047 | 2818 | 38 |
1289570 | 1289570 | 2021-05-05 | Erie | Pennsylvania | 42049 | 20295 | 405 |
1289571 | 1289571 | 2021-05-05 | Fayette | Pennsylvania | 42051 | 12596 | 308 |
1289572 | 1289572 | 2021-05-05 | Forest | Pennsylvania | 42053 | 1416 | 21 |
1289573 | 1289573 | 2021-05-05 | Franklin | Pennsylvania | 42055 | 14822 | 362 |
1289574 | 1289574 | 2021-05-05 | Fulton | Pennsylvania | 42057 | 1296 | 15 |
1289575 | 1289575 | 2021-05-05 | Greene | Pennsylvania | 42059 | 3170 | 39 |
1289576 | 1289576 | 2021-05-05 | Huntingdon | Pennsylvania | 42061 | 4954 | 129 |
1289577 | 1289577 | 2021-05-05 | Indiana | Pennsylvania | 42063 | 6015 | 171 |
1289578 | 1289578 | 2021-05-05 | Jefferson | Pennsylvania | 42065 | 3226 | 96 |
1289579 | 1289579 | 2021-05-05 | Juniata | Pennsylvania | 42067 | 2077 | 84 |
1289580 | 1289580 | 2021-05-05 | Lackawanna | Pennsylvania | 42069 | 17880 | 460 |
1289581 | 1289581 | 2021-05-05 | Lancaster | Pennsylvania | 42071 | 53703 | 1117 |
1289582 | 1289582 | 2021-05-05 | Lawrence | Pennsylvania | 42073 | 7304 | 205 |
1289583 | 1289583 | 2021-05-05 | Lebanon | Pennsylvania | 42075 | 15577 | 282 |
1289584 | 1289584 | 2021-05-05 | Lehigh | Pennsylvania | 42077 | 38546 | 841 |
1289585 | 1289585 | 2021-05-05 | Luzerne | Pennsylvania | 42079 | 30687 | 795 |
1289586 | 1289586 | 2021-05-05 | Lycoming | Pennsylvania | 42081 | 11438 | 277 |
1289587 | 1289587 | 2021-05-05 | McKean | Pennsylvania | 42083 | 3555 | 68 |
1289588 | 1289588 | 2021-05-05 | Mercer | Pennsylvania | 42085 | 9233 | 254 |
1289589 | 1289589 | 2021-05-05 | Mifflin | Pennsylvania | 42087 | 5220 | 176 |
1289590 | 1289590 | 2021-05-05 | Monroe | Pennsylvania | 42089 | 14136 | 302 |
1289591 | 1289591 | 2021-05-05 | Montgomery | Pennsylvania | 42091 | 68508 | 1672 |
1289592 | 1289592 | 2021-05-05 | Montour | Pennsylvania | 42093 | 1970 | 63 |
1289593 | 1289593 | 2021-05-05 | Northampton | Pennsylvania | 42095 | 34822 | 699 |
1289594 | 1289594 | 2021-05-05 | Northumberland | Pennsylvania | 42097 | 9313 | 347 |
1289595 | 1289595 | 2021-05-05 | Perry | Pennsylvania | 42099 | 3682 | 100 |
1289596 | 1289596 | 2021-05-05 | Philadelphia | Pennsylvania | 42101 | 148031 | 3510 |
1289597 | 1289597 | 2021-05-05 | Pike | Pennsylvania | 42103 | 3805 | 54 |
1289598 | 1289598 | 2021-05-05 | Potter | Pennsylvania | 42105 | 1098 | 23 |
1289599 | 1289599 | 2021-05-05 | Schuylkill | Pennsylvania | 42107 | 14253 | 395 |
1289600 | 1289600 | 2021-05-05 | Snyder | Pennsylvania | 42109 | 3552 | 84 |
1289601 | 1289601 | 2021-05-05 | Somerset | Pennsylvania | 42111 | 7649 | 202 |
1289602 | 1289602 | 2021-05-05 | Sullivan | Pennsylvania | 42113 | 411 | 20 |
1289603 | 1289603 | 2021-05-05 | Susquehanna | Pennsylvania | 42115 | 2493 | 60 |
1289604 | 1289604 | 2021-05-05 | Tioga | Pennsylvania | 42117 | 2897 | 104 |
1289605 | 1289605 | 2021-05-05 | Union | Pennsylvania | 42119 | 5965 | 86 |
1289606 | 1289606 | 2021-05-05 | Venango | Pennsylvania | 42121 | 3807 | 93 |
1289607 | 1289607 | 2021-05-05 | Warren | Pennsylvania | 42123 | 2552 | 101 |
1289608 | 1289608 | 2021-05-05 | Washington | Pennsylvania | 42125 | 17089 | 293 |
1289609 | 1289609 | 2021-05-05 | Wayne | Pennsylvania | 42127 | 3937 | 79 |
1289610 | 1289610 | 2021-05-05 | Westmoreland | Pennsylvania | 42129 | 33058 | 746 |
1289611 | 1289611 | 2021-05-05 | Wyoming | Pennsylvania | 42131 | 1854 | 48 |
1289612 | 1289612 | 2021-05-05 | York | Pennsylvania | 42133 | 44732 | 786 |
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);