ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-01-31" 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 |
---|---|---|---|---|---|---|---|
984361 | 984361 | 2021-01-31 | Adams | Pennsylvania | 42001 | 6564 | 142 |
984362 | 984362 | 2021-01-31 | Allegheny | Pennsylvania | 42003 | 69368 | 1520 |
984363 | 984363 | 2021-01-31 | Armstrong | Pennsylvania | 42005 | 4602 | 112 |
984364 | 984364 | 2021-01-31 | Beaver | Pennsylvania | 42007 | 10985 | 322 |
984365 | 984365 | 2021-01-31 | Bedford | Pennsylvania | 42009 | 3635 | 121 |
984366 | 984366 | 2021-01-31 | Berks | Pennsylvania | 42011 | 32577 | 802 |
984367 | 984367 | 2021-01-31 | Blair | Pennsylvania | 42013 | 9933 | 256 |
984368 | 984368 | 2021-01-31 | Bradford | Pennsylvania | 42015 | 3907 | 69 |
984369 | 984369 | 2021-01-31 | Bucks | Pennsylvania | 42017 | 40193 | 1037 |
984370 | 984370 | 2021-01-31 | Butler | Pennsylvania | 42019 | 12736 | 327 |
984371 | 984371 | 2021-01-31 | Cambria | Pennsylvania | 42021 | 10789 | 364 |
984372 | 984372 | 2021-01-31 | Cameron | Pennsylvania | 42023 | 243 | 7 |
984373 | 984373 | 2021-01-31 | Carbon | Pennsylvania | 42025 | 4387 | 124 |
984374 | 984374 | 2021-01-31 | Centre | Pennsylvania | 42027 | 11292 | 193 |
984375 | 984375 | 2021-01-31 | Chester | Pennsylvania | 42029 | 27405 | 660 |
984376 | 984376 | 2021-01-31 | Clarion | Pennsylvania | 42031 | 2487 | 74 |
984377 | 984377 | 2021-01-31 | Clearfield | Pennsylvania | 42033 | 5603 | 100 |
984378 | 984378 | 2021-01-31 | Clinton | Pennsylvania | 42035 | 2496 | 52 |
984379 | 984379 | 2021-01-31 | Columbia | Pennsylvania | 42037 | 4163 | 116 |
984380 | 984380 | 2021-01-31 | Crawford | Pennsylvania | 42039 | 5940 | 128 |
984381 | 984381 | 2021-01-31 | Cumberland | Pennsylvania | 42041 | 14474 | 437 |
984382 | 984382 | 2021-01-31 | Dauphin | Pennsylvania | 42043 | 18518 | 444 |
984383 | 984383 | 2021-01-31 | Delaware | Pennsylvania | 42045 | 37339 | 1190 |
984384 | 984384 | 2021-01-31 | Elk | Pennsylvania | 42047 | 2132 | 33 |
984385 | 984385 | 2021-01-31 | Erie | Pennsylvania | 42049 | 15533 | 341 |
984386 | 984386 | 2021-01-31 | Fayette | Pennsylvania | 42051 | 9677 | 230 |
984387 | 984387 | 2021-01-31 | Forest | Pennsylvania | 42053 | 1331 | 17 |
984388 | 984388 | 2021-01-31 | Franklin | Pennsylvania | 42055 | 11476 | 300 |
984389 | 984389 | 2021-01-31 | Fulton | Pennsylvania | 42057 | 1039 | 13 |
984390 | 984390 | 2021-01-31 | Greene | Pennsylvania | 42059 | 2413 | 30 |
984391 | 984391 | 2021-01-31 | Huntingdon | Pennsylvania | 42061 | 3873 | 115 |
984392 | 984392 | 2021-01-31 | Indiana | Pennsylvania | 42063 | 4771 | 150 |
984393 | 984393 | 2021-01-31 | Jefferson | Pennsylvania | 42065 | 2530 | 75 |
984394 | 984394 | 2021-01-31 | Juniata | Pennsylvania | 42067 | 1693 | 77 |
984395 | 984395 | 2021-01-31 | Lackawanna | Pennsylvania | 42069 | 12398 | 355 |
984396 | 984396 | 2021-01-31 | Lancaster | Pennsylvania | 42071 | 38485 | 921 |
984397 | 984397 | 2021-01-31 | Lawrence | Pennsylvania | 42073 | 5477 | 167 |
984398 | 984398 | 2021-01-31 | Lebanon | Pennsylvania | 42075 | 11774 | 223 |
984399 | 984399 | 2021-01-31 | Lehigh | Pennsylvania | 42077 | 28135 | 688 |
984400 | 984400 | 2021-01-31 | Luzerne | Pennsylvania | 42079 | 22882 | 631 |
984401 | 984401 | 2021-01-31 | Lycoming | Pennsylvania | 42081 | 8090 | 208 |
984402 | 984402 | 2021-01-31 | McKean | Pennsylvania | 42083 | 2736 | 58 |
984403 | 984403 | 2021-01-31 | Mercer | Pennsylvania | 42085 | 7498 | 223 |
984404 | 984404 | 2021-01-31 | Mifflin | Pennsylvania | 42087 | 4304 | 154 |
984405 | 984405 | 2021-01-31 | Monroe | Pennsylvania | 42089 | 8595 | 245 |
984406 | 984406 | 2021-01-31 | Montgomery | Pennsylvania | 42091 | 48612 | 1389 |
984407 | 984407 | 2021-01-31 | Montour | Pennsylvania | 42093 | 1649 | 51 |
984408 | 984408 | 2021-01-31 | Northampton | Pennsylvania | 42095 | 23443 | 569 |
984409 | 984409 | 2021-01-31 | Northumberland | Pennsylvania | 42097 | 6830 | 294 |
984410 | 984410 | 2021-01-31 | Perry | Pennsylvania | 42099 | 2561 | 74 |
984411 | 984411 | 2021-01-31 | Philadelphia | Pennsylvania | 42101 | 109231 | 2908 |
984412 | 984412 | 2021-01-31 | Pike | Pennsylvania | 42103 | 2133 | 44 |
984413 | 984413 | 2021-01-31 | Potter | Pennsylvania | 42105 | 828 | 19 |
984414 | 984414 | 2021-01-31 | Schuylkill | Pennsylvania | 42107 | 11209 | 335 |
984415 | 984415 | 2021-01-31 | Snyder | Pennsylvania | 42109 | 2560 | 68 |
984416 | 984416 | 2021-01-31 | Somerset | Pennsylvania | 42111 | 6328 | 176 |
984417 | 984417 | 2021-01-31 | Sullivan | Pennsylvania | 42113 | 281 | 11 |
984418 | 984418 | 2021-01-31 | Susquehanna | Pennsylvania | 42115 | 1520 | 49 |
984419 | 984419 | 2021-01-31 | Tioga | Pennsylvania | 42117 | 2269 | 90 |
984420 | 984420 | 2021-01-31 | Union | Pennsylvania | 42119 | 4056 | 74 |
984421 | 984421 | 2021-01-31 | Venango | Pennsylvania | 42121 | 3096 | 75 |
984422 | 984422 | 2021-01-31 | Warren | Pennsylvania | 42123 | 2021 | 91 |
984423 | 984423 | 2021-01-31 | Washington | Pennsylvania | 42125 | 12562 | 225 |
984424 | 984424 | 2021-01-31 | Wayne | Pennsylvania | 42127 | 2676 | 47 |
984425 | 984425 | 2021-01-31 | Westmoreland | Pennsylvania | 42129 | 24703 | 605 |
984426 | 984426 | 2021-01-31 | Wyoming | Pennsylvania | 42131 | 1056 | 36 |
984427 | 984427 | 2021-01-31 | York | Pennsylvania | 42133 | 32142 | 634 |
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);