ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where "date" is on date 2021-03-29 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1169393 | 1169393 | 2021-03-29 | Adams | Pennsylvania | 42001 | 8008 | 159 |
1169394 | 1169394 | 2021-03-29 | Allegheny | Pennsylvania | 42003 | 84850 | 1802 |
1169395 | 1169395 | 2021-03-29 | Armstrong | Pennsylvania | 42005 | 5132 | 120 |
1169396 | 1169396 | 2021-03-29 | Beaver | Pennsylvania | 42007 | 13105 | 357 |
1169397 | 1169397 | 2021-03-29 | Bedford | Pennsylvania | 42009 | 3942 | 130 |
1169398 | 1169398 | 2021-03-29 | Berks | Pennsylvania | 42011 | 39419 | 927 |
1169399 | 1169399 | 2021-03-29 | Blair | Pennsylvania | 42013 | 11092 | 312 |
1169400 | 1169400 | 2021-03-29 | Bradford | Pennsylvania | 42015 | 4768 | 83 |
1169401 | 1169401 | 2021-03-29 | Bucks | Pennsylvania | 42017 | 50345 | 1177 |
1169402 | 1169402 | 2021-03-29 | Butler | Pennsylvania | 42019 | 15108 | 384 |
1169403 | 1169403 | 2021-03-29 | Cambria | Pennsylvania | 42021 | 12219 | 403 |
1169404 | 1169404 | 2021-03-29 | Cameron | Pennsylvania | 42023 | 277 | 6 |
1169405 | 1169405 | 2021-03-29 | Carbon | Pennsylvania | 42025 | 5335 | 158 |
1169406 | 1169406 | 2021-03-29 | Centre | Pennsylvania | 42027 | 14439 | 213 |
1169407 | 1169407 | 2021-03-29 | Chester | Pennsylvania | 42029 | 33748 | 753 |
1169408 | 1169408 | 2021-03-29 | Clarion | Pennsylvania | 42031 | 2822 | 88 |
1169409 | 1169409 | 2021-03-29 | Clearfield | Pennsylvania | 42033 | 7105 | 128 |
1169410 | 1169410 | 2021-03-29 | Clinton | Pennsylvania | 42035 | 3064 | 58 |
1169411 | 1169411 | 2021-03-29 | Columbia | Pennsylvania | 42037 | 4912 | 127 |
1169412 | 1169412 | 2021-03-29 | Crawford | Pennsylvania | 42039 | 6661 | 143 |
1169413 | 1169413 | 2021-03-29 | Cumberland | Pennsylvania | 42041 | 17816 | 496 |
1169414 | 1169414 | 2021-03-29 | Dauphin | Pennsylvania | 42043 | 22158 | 517 |
1169415 | 1169415 | 2021-03-29 | Delaware | Pennsylvania | 42045 | 44363 | 1339 |
1169416 | 1169416 | 2021-03-29 | Elk | Pennsylvania | 42047 | 2514 | 37 |
1169417 | 1169417 | 2021-03-29 | Erie | Pennsylvania | 42049 | 18577 | 392 |
1169418 | 1169418 | 2021-03-29 | Fayette | Pennsylvania | 42051 | 11152 | 286 |
1169419 | 1169419 | 2021-03-29 | Forest | Pennsylvania | 42053 | 1393 | 21 |
1169420 | 1169420 | 2021-03-29 | Franklin | Pennsylvania | 42055 | 13371 | 338 |
1169421 | 1169421 | 2021-03-29 | Fulton | Pennsylvania | 42057 | 1183 | 15 |
1169422 | 1169422 | 2021-03-29 | Greene | Pennsylvania | 42059 | 2832 | 37 |
1169423 | 1169423 | 2021-03-29 | Huntingdon | Pennsylvania | 42061 | 4543 | 126 |
1169424 | 1169424 | 2021-03-29 | Indiana | Pennsylvania | 42063 | 5324 | 161 |
1169425 | 1169425 | 2021-03-29 | Jefferson | Pennsylvania | 42065 | 2964 | 91 |
1169426 | 1169426 | 2021-03-29 | Juniata | Pennsylvania | 42067 | 1898 | 81 |
1169427 | 1169427 | 2021-03-29 | Lackawanna | Pennsylvania | 42069 | 15365 | 433 |
1169428 | 1169428 | 2021-03-29 | Lancaster | Pennsylvania | 42071 | 47420 | 1077 |
1169429 | 1169429 | 2021-03-29 | Lawrence | Pennsylvania | 42073 | 6563 | 194 |
1169430 | 1169430 | 2021-03-29 | Lebanon | Pennsylvania | 42075 | 13725 | 264 |
1169431 | 1169431 | 2021-03-29 | Lehigh | Pennsylvania | 42077 | 33695 | 804 |
1169432 | 1169432 | 2021-03-29 | Luzerne | Pennsylvania | 42079 | 26869 | 762 |
1169433 | 1169433 | 2021-03-29 | Lycoming | Pennsylvania | 42081 | 10108 | 261 |
1169434 | 1169434 | 2021-03-29 | McKean | Pennsylvania | 42083 | 3160 | 65 |
1169435 | 1169435 | 2021-03-29 | Mercer | Pennsylvania | 42085 | 8504 | 248 |
1169436 | 1169436 | 2021-03-29 | Mifflin | Pennsylvania | 42087 | 4769 | 175 |
1169437 | 1169437 | 2021-03-29 | Monroe | Pennsylvania | 42089 | 11244 | 286 |
1169438 | 1169438 | 2021-03-29 | Montgomery | Pennsylvania | 42091 | 59243 | 1606 |
1169439 | 1169439 | 2021-03-29 | Montour | Pennsylvania | 42093 | 1828 | 60 |
1169440 | 1169440 | 2021-03-29 | Northampton | Pennsylvania | 42095 | 30082 | 676 |
1169441 | 1169441 | 2021-03-29 | Northumberland | Pennsylvania | 42097 | 8504 | 334 |
1169442 | 1169442 | 2021-03-29 | Perry | Pennsylvania | 42099 | 3175 | 88 |
1169443 | 1169443 | 2021-03-29 | Philadelphia | Pennsylvania | 42101 | 129077 | 3269 |
1169444 | 1169444 | 2021-03-29 | Pike | Pennsylvania | 42103 | 3088 | 51 |
1169445 | 1169445 | 2021-03-29 | Potter | Pennsylvania | 42105 | 976 | 22 |
1169446 | 1169446 | 2021-03-29 | Schuylkill | Pennsylvania | 42107 | 12752 | 381 |
1169447 | 1169447 | 2021-03-29 | Snyder | Pennsylvania | 42109 | 3272 | 82 |
1169448 | 1169448 | 2021-03-29 | Somerset | Pennsylvania | 42111 | 6950 | 188 |
1169449 | 1169449 | 2021-03-29 | Sullivan | Pennsylvania | 42113 | 340 | 20 |
1169450 | 1169450 | 2021-03-29 | Susquehanna | Pennsylvania | 42115 | 1943 | 53 |
1169451 | 1169451 | 2021-03-29 | Tioga | Pennsylvania | 42117 | 2603 | 97 |
1169452 | 1169452 | 2021-03-29 | Union | Pennsylvania | 42119 | 5409 | 85 |
1169453 | 1169453 | 2021-03-29 | Venango | Pennsylvania | 42121 | 3510 | 90 |
1169454 | 1169454 | 2021-03-29 | Warren | Pennsylvania | 42123 | 2268 | 99 |
1169455 | 1169455 | 2021-03-29 | Washington | Pennsylvania | 42125 | 14947 | 274 |
1169456 | 1169456 | 2021-03-29 | Wayne | Pennsylvania | 42127 | 3339 | 70 |
1169457 | 1169457 | 2021-03-29 | Westmoreland | Pennsylvania | 42129 | 28930 | 704 |
1169458 | 1169458 | 2021-03-29 | Wyoming | Pennsylvania | 42131 | 1376 | 44 |
1169459 | 1169459 | 2021-03-29 | York | Pennsylvania | 42133 | 39111 | 746 |
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);