ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where deaths = 244 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
- Huntingdon 14
- Centre 8
- Columbia 7
- Mercer 4
- Fayette 2
- Armstrong 1
- Lackawanna 1
- Monroe 1
- Northampton 1
- Somerset 1
- Washington 1
state 1
- Pennsylvania · 41 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2433474 | 2433474 | 2022-04-22 | Columbia | Pennsylvania | 42037 | 15184 | 244 |
2430218 | 2430218 | 2022-04-21 | Columbia | Pennsylvania | 42037 | 15165 | 244 |
2426962 | 2426962 | 2022-04-20 | Columbia | Pennsylvania | 42037 | 15158 | 244 |
2423706 | 2423706 | 2022-04-19 | Columbia | Pennsylvania | 42037 | 15144 | 244 |
2423718 | 2423718 | 2022-04-19 | Huntingdon | Pennsylvania | 42061 | 11516 | 244 |
2420450 | 2420450 | 2022-04-18 | Columbia | Pennsylvania | 42037 | 15137 | 244 |
2420462 | 2420462 | 2022-04-18 | Huntingdon | Pennsylvania | 42061 | 11513 | 244 |
2417194 | 2417194 | 2022-04-17 | Columbia | Pennsylvania | 42037 | 15133 | 244 |
2417206 | 2417206 | 2022-04-17 | Huntingdon | Pennsylvania | 42061 | 11513 | 244 |
2413938 | 2413938 | 2022-04-16 | Columbia | Pennsylvania | 42037 | 15127 | 244 |
2413950 | 2413950 | 2022-04-16 | Huntingdon | Pennsylvania | 42061 | 11511 | 244 |
2410694 | 2410694 | 2022-04-15 | Huntingdon | Pennsylvania | 42061 | 11509 | 244 |
2407438 | 2407438 | 2022-04-14 | Huntingdon | Pennsylvania | 42061 | 11508 | 244 |
2404182 | 2404182 | 2022-04-13 | Huntingdon | Pennsylvania | 42061 | 11507 | 244 |
2400927 | 2400927 | 2022-04-12 | Huntingdon | Pennsylvania | 42061 | 11507 | 244 |
2397672 | 2397672 | 2022-04-11 | Huntingdon | Pennsylvania | 42061 | 11504 | 244 |
2394417 | 2394417 | 2022-04-10 | Huntingdon | Pennsylvania | 42061 | 11504 | 244 |
2391161 | 2391161 | 2022-04-09 | Huntingdon | Pennsylvania | 42061 | 11504 | 244 |
2387905 | 2387905 | 2022-04-08 | Huntingdon | Pennsylvania | 42061 | 11496 | 244 |
2384650 | 2384650 | 2022-04-07 | Huntingdon | Pennsylvania | 42061 | 11496 | 244 |
2381395 | 2381395 | 2022-04-06 | Huntingdon | Pennsylvania | 42061 | 11492 | 244 |
2000873 | 2000873 | 2021-12-10 | Armstrong | Pennsylvania | 42005 | 11025 | 244 |
1877377 | 1877377 | 2021-11-02 | Centre | Pennsylvania | 42027 | 20758 | 244 |
1874128 | 1874128 | 2021-11-01 | Centre | Pennsylvania | 42027 | 20698 | 244 |
1870879 | 1870879 | 2021-10-31 | Centre | Pennsylvania | 42027 | 20698 | 244 |
1867630 | 1867630 | 2021-10-30 | Centre | Pennsylvania | 42027 | 20659 | 244 |
1864381 | 1864381 | 2021-10-29 | Centre | Pennsylvania | 42027 | 20613 | 244 |
1861132 | 1861132 | 2021-10-28 | Centre | Pennsylvania | 42027 | 20567 | 244 |
1857883 | 1857883 | 2021-10-27 | Centre | Pennsylvania | 42027 | 20521 | 244 |
1854634 | 1854634 | 2021-10-26 | Centre | Pennsylvania | 42027 | 20474 | 244 |
1835179 | 1835179 | 2021-10-20 | Somerset | Pennsylvania | 42111 | 10292 | 244 |
1133716 | 1133716 | 2021-03-18 | Mercer | Pennsylvania | 42085 | 8382 | 244 |
1130468 | 1130468 | 2021-03-17 | Mercer | Pennsylvania | 42085 | 8365 | 244 |
1127221 | 1127221 | 2021-03-16 | Mercer | Pennsylvania | 42085 | 8354 | 244 |
1123975 | 1123975 | 2021-03-15 | Mercer | Pennsylvania | 42085 | 8336 | 244 |
1023372 | 1023372 | 2021-02-12 | Washington | Pennsylvania | 42125 | 13198 | 244 |
1016845 | 1016845 | 2021-02-10 | Fayette | Pennsylvania | 42051 | 10022 | 244 |
1013600 | 1013600 | 2021-02-09 | Fayette | Pennsylvania | 42051 | 9993 | 244 |
977912 | 977912 | 2021-01-29 | Monroe | Pennsylvania | 42089 | 8469 | 244 |
818879 | 818879 | 2020-12-11 | Lackawanna | Pennsylvania | 42069 | 6358 | 244 |
245453 | 245453 | 2020-06-16 | Northampton | Pennsylvania | 42095 | 3250 | 244 |
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);