ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where deaths = 364 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501847 | 2501847 | 2022-05-13 | Adams | Pennsylvania | 42001 | 25114 | 364 |
2498589 | 2498589 | 2022-05-12 | Adams | Pennsylvania | 42001 | 25114 | 364 |
2495331 | 2495331 | 2022-05-11 | Adams | Pennsylvania | 42001 | 25114 | 364 |
2153739 | 2153739 | 2022-01-26 | Somerset | Pennsylvania | 42111 | 17327 | 364 |
1987905 | 1987905 | 2021-12-06 | Lebanon | Pennsylvania | 42075 | 23568 | 364 |
1945653 | 1945653 | 2021-11-23 | Mercer | Pennsylvania | 42085 | 15402 | 364 |
1789662 | 1789662 | 2021-10-06 | Fayette | Pennsylvania | 42051 | 16140 | 364 |
1536304 | 1536304 | 2021-07-20 | Northumberland | Pennsylvania | 42097 | 9734 | 364 |
1533056 | 1533056 | 2021-07-19 | Northumberland | Pennsylvania | 42097 | 9733 | 364 |
1529809 | 1529809 | 2021-07-18 | Northumberland | Pennsylvania | 42097 | 9732 | 364 |
1526562 | 1526562 | 2021-07-17 | Northumberland | Pennsylvania | 42097 | 9731 | 364 |
1523315 | 1523315 | 2021-07-16 | Northumberland | Pennsylvania | 42097 | 9732 | 364 |
1520067 | 1520067 | 2021-07-15 | Northumberland | Pennsylvania | 42097 | 9729 | 364 |
1049328 | 1049328 | 2021-02-20 | Schuylkill | Pennsylvania | 42107 | 11852 | 364 |
1036317 | 1036317 | 2021-02-16 | Erie | Pennsylvania | 42049 | 16650 | 364 |
1033072 | 1033072 | 2021-02-15 | Erie | Pennsylvania | 42049 | 16596 | 364 |
1029826 | 1029826 | 2021-02-14 | Erie | Pennsylvania | 42049 | 16542 | 364 |
1026579 | 1026579 | 2021-02-13 | Erie | Pennsylvania | 42049 | 16466 | 364 |
987618 | 987618 | 2021-02-01 | Cambria | Pennsylvania | 42021 | 10808 | 364 |
984371 | 984371 | 2021-01-31 | Cambria | Pennsylvania | 42021 | 10789 | 364 |
981124 | 981124 | 2021-01-30 | Cambria | Pennsylvania | 42021 | 10761 | 364 |
828623 | 828623 | 2020-12-14 | Luzerne | Pennsylvania | 42079 | 13259 | 364 |
659902 | 659902 | 2020-10-23 | Lehigh | Pennsylvania | 42077 | 6318 | 364 |
552879 | 552879 | 2020-09-20 | Chester | Pennsylvania | 42029 | 6567 | 364 |
549640 | 549640 | 2020-09-19 | Chester | Pennsylvania | 42029 | 6526 | 364 |
546401 | 546401 | 2020-09-18 | Chester | Pennsylvania | 42029 | 6510 | 364 |
384965 | 384965 | 2020-07-30 | Berks | Pennsylvania | 42011 | 5125 | 364 |
381747 | 381747 | 2020-07-29 | Berks | Pennsylvania | 42011 | 5100 | 364 |
378530 | 378530 | 2020-07-28 | Berks | Pennsylvania | 42011 | 5080 | 364 |
138309 | 138309 | 2020-05-12 | Bucks | Pennsylvania | 42017 | 4116 | 364 |
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);