ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where deaths = 195 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 |
---|---|---|---|---|---|---|---|
2296792 | 2296792 | 2022-03-11 | Bradford | Pennsylvania | 42015 | 14930 | 195 |
2293540 | 2293540 | 2022-03-10 | Bradford | Pennsylvania | 42015 | 14923 | 195 |
2290288 | 2290288 | 2022-03-09 | Bradford | Pennsylvania | 42015 | 14910 | 195 |
2287036 | 2287036 | 2022-03-08 | Bradford | Pennsylvania | 42015 | 14895 | 195 |
2170018 | 2170018 | 2022-01-31 | Warren | Pennsylvania | 42123 | 6838 | 195 |
2166764 | 2166764 | 2022-01-30 | Warren | Pennsylvania | 42123 | 6831 | 195 |
2163509 | 2163509 | 2022-01-29 | Warren | Pennsylvania | 42123 | 6816 | 195 |
2160254 | 2160254 | 2022-01-28 | Warren | Pennsylvania | 42123 | 6783 | 195 |
2156998 | 2156998 | 2022-01-27 | Warren | Pennsylvania | 42123 | 6743 | 195 |
2127687 | 2127687 | 2022-01-18 | Jefferson | Pennsylvania | 42065 | 7669 | 195 |
2124435 | 2124435 | 2022-01-17 | Jefferson | Pennsylvania | 42065 | 7624 | 195 |
2121183 | 2121183 | 2022-01-16 | Jefferson | Pennsylvania | 42065 | 7598 | 195 |
2117931 | 2117931 | 2022-01-15 | Jefferson | Pennsylvania | 42065 | 7520 | 195 |
2036659 | 2036659 | 2021-12-21 | Huntingdon | Pennsylvania | 42061 | 8230 | 195 |
1978122 | 1978122 | 2021-12-03 | Bedford | Pennsylvania | 42009 | 7886 | 195 |
1854664 | 1854664 | 2021-10-26 | Mifflin | Pennsylvania | 42087 | 7183 | 195 |
1815642 | 1815642 | 2021-10-14 | Carbon | Pennsylvania | 42025 | 8448 | 195 |
1250639 | 1250639 | 2021-04-23 | Somerset | Pennsylvania | 42111 | 7388 | 195 |
1247392 | 1247392 | 2021-04-22 | Somerset | Pennsylvania | 42111 | 7366 | 195 |
1244145 | 1244145 | 2021-04-21 | Somerset | Pennsylvania | 42111 | 7334 | 195 |
1240898 | 1240898 | 2021-04-20 | Somerset | Pennsylvania | 42111 | 7316 | 195 |
1195408 | 1195408 | 2021-04-06 | Lawrence | Pennsylvania | 42073 | 6759 | 195 |
1192160 | 1192160 | 2021-04-05 | Lawrence | Pennsylvania | 42073 | 6731 | 195 |
1188911 | 1188911 | 2021-04-04 | Lawrence | Pennsylvania | 42073 | 6725 | 195 |
1185664 | 1185664 | 2021-04-03 | Lawrence | Pennsylvania | 42073 | 6708 | 195 |
1182417 | 1182417 | 2021-04-02 | Lawrence | Pennsylvania | 42073 | 6664 | 195 |
994113 | 994113 | 2021-02-03 | Centre | Pennsylvania | 42027 | 11512 | 195 |
877308 | 877308 | 2020-12-29 | Monroe | Pennsylvania | 42089 | 5900 | 195 |
874043 | 874043 | 2020-12-28 | Erie | Pennsylvania | 42049 | 11251 | 195 |
676103 | 676103 | 2020-10-28 | Dauphin | Pennsylvania | 42043 | 4818 | 195 |
672860 | 672860 | 2020-10-27 | Dauphin | Pennsylvania | 42043 | 4745 | 195 |
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);