ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-05-09" 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 |
---|---|---|---|---|---|---|---|
1302532 | 1302532 | 2021-05-09 | Adams | Pennsylvania | 42001 | 9309 | 177 |
1302533 | 1302533 | 2021-05-09 | Allegheny | Pennsylvania | 42003 | 99089 | 1922 |
1302534 | 1302534 | 2021-05-09 | Armstrong | Pennsylvania | 42005 | 5840 | 133 |
1302535 | 1302535 | 2021-05-09 | Beaver | Pennsylvania | 42007 | 14988 | 379 |
1302536 | 1302536 | 2021-05-09 | Bedford | Pennsylvania | 42009 | 4446 | 135 |
1302537 | 1302537 | 2021-05-09 | Berks | Pennsylvania | 42011 | 46671 | 1003 |
1302538 | 1302538 | 2021-05-09 | Blair | Pennsylvania | 42013 | 12899 | 329 |
1302539 | 1302539 | 2021-05-09 | Bradford | Pennsylvania | 42015 | 5799 | 89 |
1302540 | 1302540 | 2021-05-09 | Bucks | Pennsylvania | 42017 | 59478 | 1264 |
1302541 | 1302541 | 2021-05-09 | Butler | Pennsylvania | 42019 | 17052 | 410 |
1302542 | 1302542 | 2021-05-09 | Cambria | Pennsylvania | 42021 | 14074 | 421 |
1302543 | 1302543 | 2021-05-09 | Cameron | Pennsylvania | 42023 | 293 | 8 |
1302544 | 1302544 | 2021-05-09 | Carbon | Pennsylvania | 42025 | 6182 | 169 |
1302545 | 1302545 | 2021-05-09 | Centre | Pennsylvania | 42027 | 16578 | 220 |
1302546 | 1302546 | 2021-05-09 | Chester | Pennsylvania | 42029 | 39871 | 789 |
1302547 | 1302547 | 2021-05-09 | Clarion | Pennsylvania | 42031 | 3119 | 91 |
1302548 | 1302548 | 2021-05-09 | Clearfield | Pennsylvania | 42033 | 8360 | 142 |
1302549 | 1302549 | 2021-05-09 | Clinton | Pennsylvania | 42035 | 3596 | 62 |
1302550 | 1302550 | 2021-05-09 | Columbia | Pennsylvania | 42037 | 5648 | 133 |
1302551 | 1302551 | 2021-05-09 | Crawford | Pennsylvania | 42039 | 7152 | 149 |
1302552 | 1302552 | 2021-05-09 | Cumberland | Pennsylvania | 42041 | 20006 | 517 |
1302553 | 1302553 | 2021-05-09 | Dauphin | Pennsylvania | 42043 | 25266 | 543 |
1302554 | 1302554 | 2021-05-09 | Delaware | Pennsylvania | 42045 | 51240 | 1404 |
1302555 | 1302555 | 2021-05-09 | Elk | Pennsylvania | 42047 | 2826 | 39 |
1302556 | 1302556 | 2021-05-09 | Erie | Pennsylvania | 42049 | 20473 | 405 |
1302557 | 1302557 | 2021-05-09 | Fayette | Pennsylvania | 42051 | 12713 | 309 |
1302558 | 1302558 | 2021-05-09 | Forest | Pennsylvania | 42053 | 1422 | 21 |
1302559 | 1302559 | 2021-05-09 | Franklin | Pennsylvania | 42055 | 14888 | 363 |
1302560 | 1302560 | 2021-05-09 | Fulton | Pennsylvania | 42057 | 1305 | 15 |
1302561 | 1302561 | 2021-05-09 | Greene | Pennsylvania | 42059 | 3185 | 39 |
1302562 | 1302562 | 2021-05-09 | Huntingdon | Pennsylvania | 42061 | 5008 | 128 |
1302563 | 1302563 | 2021-05-09 | Indiana | Pennsylvania | 42063 | 6100 | 173 |
1302564 | 1302564 | 2021-05-09 | Jefferson | Pennsylvania | 42065 | 3248 | 97 |
1302565 | 1302565 | 2021-05-09 | Juniata | Pennsylvania | 42067 | 2086 | 84 |
1302566 | 1302566 | 2021-05-09 | Lackawanna | Pennsylvania | 42069 | 18034 | 461 |
1302567 | 1302567 | 2021-05-09 | Lancaster | Pennsylvania | 42071 | 54098 | 1123 |
1302568 | 1302568 | 2021-05-09 | Lawrence | Pennsylvania | 42073 | 7370 | 207 |
1302569 | 1302569 | 2021-05-09 | Lebanon | Pennsylvania | 42075 | 15711 | 283 |
1302570 | 1302570 | 2021-05-09 | Lehigh | Pennsylvania | 42077 | 38813 | 844 |
1302571 | 1302571 | 2021-05-09 | Luzerne | Pennsylvania | 42079 | 30942 | 798 |
1302572 | 1302572 | 2021-05-09 | Lycoming | Pennsylvania | 42081 | 11552 | 277 |
1302573 | 1302573 | 2021-05-09 | McKean | Pennsylvania | 42083 | 3613 | 68 |
1302574 | 1302574 | 2021-05-09 | Mercer | Pennsylvania | 42085 | 9310 | 255 |
1302575 | 1302575 | 2021-05-09 | Mifflin | Pennsylvania | 42087 | 5269 | 177 |
1302576 | 1302576 | 2021-05-09 | Monroe | Pennsylvania | 42089 | 14303 | 305 |
1302577 | 1302577 | 2021-05-09 | Montgomery | Pennsylvania | 42091 | 68963 | 1682 |
1302578 | 1302578 | 2021-05-09 | Montour | Pennsylvania | 42093 | 1981 | 63 |
1302579 | 1302579 | 2021-05-09 | Northampton | Pennsylvania | 42095 | 35039 | 702 |
1302580 | 1302580 | 2021-05-09 | Northumberland | Pennsylvania | 42097 | 9384 | 347 |
1302581 | 1302581 | 2021-05-09 | Perry | Pennsylvania | 42099 | 3715 | 100 |
1302582 | 1302582 | 2021-05-09 | Philadelphia | Pennsylvania | 42101 | 149172 | 3543 |
1302583 | 1302583 | 2021-05-09 | Pike | Pennsylvania | 42103 | 3861 | 54 |
1302584 | 1302584 | 2021-05-09 | Potter | Pennsylvania | 42105 | 1109 | 23 |
1302585 | 1302585 | 2021-05-09 | Schuylkill | Pennsylvania | 42107 | 14367 | 398 |
1302586 | 1302586 | 2021-05-09 | Snyder | Pennsylvania | 42109 | 3579 | 84 |
1302587 | 1302587 | 2021-05-09 | Somerset | Pennsylvania | 42111 | 7722 | 205 |
1302588 | 1302588 | 2021-05-09 | Sullivan | Pennsylvania | 42113 | 418 | 20 |
1302589 | 1302589 | 2021-05-09 | Susquehanna | Pennsylvania | 42115 | 2522 | 61 |
1302590 | 1302590 | 2021-05-09 | Tioga | Pennsylvania | 42117 | 2926 | 104 |
1302591 | 1302591 | 2021-05-09 | Union | Pennsylvania | 42119 | 6006 | 86 |
1302592 | 1302592 | 2021-05-09 | Venango | Pennsylvania | 42121 | 3853 | 93 |
1302593 | 1302593 | 2021-05-09 | Warren | Pennsylvania | 42123 | 2565 | 102 |
1302594 | 1302594 | 2021-05-09 | Washington | Pennsylvania | 42125 | 17241 | 294 |
1302595 | 1302595 | 2021-05-09 | Wayne | Pennsylvania | 42127 | 3978 | 80 |
1302596 | 1302596 | 2021-05-09 | Westmoreland | Pennsylvania | 42129 | 33329 | 748 |
1302597 | 1302597 | 2021-05-09 | Wyoming | Pennsylvania | 42131 | 1873 | 48 |
1302598 | 1302598 | 2021-05-09 | York | Pennsylvania | 42133 | 45139 | 792 |
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);