ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where deaths = 518 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
state 1
- Pennsylvania · 41 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501884 | 2501884 | 2022-05-13 | Lebanon | Pennsylvania | 42075 | 37011 | 518 |
2498626 | 2498626 | 2022-05-12 | Lebanon | Pennsylvania | 42075 | 37011 | 518 |
2495368 | 2495368 | 2022-05-11 | Lebanon | Pennsylvania | 42075 | 37011 | 518 |
2492110 | 2492110 | 2022-05-10 | Lebanon | Pennsylvania | 42075 | 36833 | 518 |
2488852 | 2488852 | 2022-05-09 | Lebanon | Pennsylvania | 42075 | 36833 | 518 |
2485595 | 2485595 | 2022-05-08 | Lebanon | Pennsylvania | 42075 | 36833 | 518 |
2482337 | 2482337 | 2022-05-07 | Lebanon | Pennsylvania | 42075 | 36833 | 518 |
2479079 | 2479079 | 2022-05-06 | Lebanon | Pennsylvania | 42075 | 36833 | 518 |
2475821 | 2475821 | 2022-05-05 | Lebanon | Pennsylvania | 42075 | 36833 | 518 |
2472564 | 2472564 | 2022-05-04 | Lebanon | Pennsylvania | 42075 | 36833 | 518 |
2469308 | 2469308 | 2022-05-03 | Lebanon | Pennsylvania | 42075 | 36798 | 518 |
2466052 | 2466052 | 2022-05-02 | Lebanon | Pennsylvania | 42075 | 36783 | 518 |
2462797 | 2462797 | 2022-05-01 | Lebanon | Pennsylvania | 42075 | 36775 | 518 |
2459541 | 2459541 | 2022-04-30 | Lebanon | Pennsylvania | 42075 | 36764 | 518 |
2456285 | 2456285 | 2022-04-29 | Lebanon | Pennsylvania | 42075 | 36739 | 518 |
2453029 | 2453029 | 2022-04-28 | Lebanon | Pennsylvania | 42075 | 36726 | 518 |
2449773 | 2449773 | 2022-04-27 | Lebanon | Pennsylvania | 42075 | 36708 | 518 |
2446516 | 2446516 | 2022-04-26 | Lebanon | Pennsylvania | 42075 | 36693 | 518 |
2443261 | 2443261 | 2022-04-25 | Lebanon | Pennsylvania | 42075 | 36681 | 518 |
2440005 | 2440005 | 2022-04-24 | Lebanon | Pennsylvania | 42075 | 36675 | 518 |
2436749 | 2436749 | 2022-04-23 | Lebanon | Pennsylvania | 42075 | 36671 | 518 |
2433493 | 2433493 | 2022-04-22 | Lebanon | Pennsylvania | 42075 | 36654 | 518 |
2410708 | 2410708 | 2022-04-15 | Monroe | Pennsylvania | 42089 | 37088 | 518 |
2407452 | 2407452 | 2022-04-14 | Monroe | Pennsylvania | 42089 | 37067 | 518 |
2404196 | 2404196 | 2022-04-13 | Monroe | Pennsylvania | 42089 | 37044 | 518 |
2400941 | 2400941 | 2022-04-12 | Monroe | Pennsylvania | 42089 | 37024 | 518 |
2397686 | 2397686 | 2022-04-11 | Monroe | Pennsylvania | 42089 | 37012 | 518 |
2394431 | 2394431 | 2022-04-10 | Monroe | Pennsylvania | 42089 | 37006 | 518 |
2391175 | 2391175 | 2022-04-09 | Monroe | Pennsylvania | 42089 | 36994 | 518 |
2387919 | 2387919 | 2022-04-08 | Monroe | Pennsylvania | 42089 | 36988 | 518 |
2384664 | 2384664 | 2022-04-07 | Monroe | Pennsylvania | 42089 | 36976 | 518 |
2039904 | 2039904 | 2021-12-22 | Fayette | Pennsylvania | 42051 | 22327 | 518 |
1900121 | 1900121 | 2021-11-09 | Butler | Pennsylvania | 42019 | 26023 | 518 |
1877374 | 1877374 | 2021-11-02 | Cambria | Pennsylvania | 42021 | 19750 | 518 |
1315537 | 1315537 | 2021-05-13 | Cumberland | Pennsylvania | 42041 | 20097 | 518 |
1312291 | 1312291 | 2021-05-12 | Cumberland | Pennsylvania | 42041 | 20067 | 518 |
1172661 | 1172661 | 2021-03-30 | Dauphin | Pennsylvania | 42043 | 22273 | 518 |
900021 | 900021 | 2021-01-05 | Lehigh | Pennsylvania | 42077 | 21720 | 518 |
851309 | 851309 | 2020-12-21 | Berks | Pennsylvania | 42011 | 20546 | 518 |
786395 | 786395 | 2020-12-01 | Allegheny | Pennsylvania | 42003 | 29007 | 518 |
168464 | 168464 | 2020-05-22 | Delaware | Pennsylvania | 42045 | 6112 | 518 |
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);