ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where deaths = 203 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 20
county 20
- Clarion 18
- Warren 5
- Columbia 4
- Huntingdon 4
- Centre 2
- Fayette 2
- Lackawanna 2
- Somerset 2
- York 2
- Beaver 1
- Bradford 1
- Butler 1
- Carbon 1
- Crawford 1
- Dauphin 1
- Lawrence 1
- Luzerne 1
- Mercer 1
- Northampton 1
- Schuylkill 1
state 1
- Pennsylvania · 52 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2430207 | 2430207 | 2022-04-21 | Bradford | Pennsylvania | 42015 | 15451 | 203 |
2397657 | 2397657 | 2022-04-11 | Clarion | Pennsylvania | 42031 | 8230 | 203 |
2394402 | 2394402 | 2022-04-10 | Clarion | Pennsylvania | 42031 | 8229 | 203 |
2391146 | 2391146 | 2022-04-09 | Clarion | Pennsylvania | 42031 | 8229 | 203 |
2387890 | 2387890 | 2022-04-08 | Clarion | Pennsylvania | 42031 | 8229 | 203 |
2384635 | 2384635 | 2022-04-07 | Clarion | Pennsylvania | 42031 | 8227 | 203 |
2381380 | 2381380 | 2022-04-06 | Clarion | Pennsylvania | 42031 | 8226 | 203 |
2378125 | 2378125 | 2022-04-05 | Clarion | Pennsylvania | 42031 | 8224 | 203 |
2374871 | 2374871 | 2022-04-04 | Clarion | Pennsylvania | 42031 | 8223 | 203 |
2371619 | 2371619 | 2022-04-03 | Clarion | Pennsylvania | 42031 | 8222 | 203 |
2368366 | 2368366 | 2022-04-02 | Clarion | Pennsylvania | 42031 | 8222 | 203 |
2365113 | 2365113 | 2022-04-01 | Clarion | Pennsylvania | 42031 | 8220 | 203 |
2361860 | 2361860 | 2022-03-31 | Clarion | Pennsylvania | 42031 | 8220 | 203 |
2358606 | 2358606 | 2022-03-30 | Clarion | Pennsylvania | 42031 | 8219 | 203 |
2355352 | 2355352 | 2022-03-29 | Clarion | Pennsylvania | 42031 | 8216 | 203 |
2352099 | 2352099 | 2022-03-28 | Clarion | Pennsylvania | 42031 | 8216 | 203 |
2348847 | 2348847 | 2022-03-27 | Clarion | Pennsylvania | 42031 | 8216 | 203 |
2345594 | 2345594 | 2022-03-26 | Clarion | Pennsylvania | 42031 | 8214 | 203 |
2342341 | 2342341 | 2022-03-25 | Clarion | Pennsylvania | 42031 | 8213 | 203 |
2215558 | 2215558 | 2022-02-14 | Warren | Pennsylvania | 42123 | 7111 | 203 |
2212307 | 2212307 | 2022-02-13 | Warren | Pennsylvania | 42123 | 7110 | 203 |
2209054 | 2209054 | 2022-02-12 | Warren | Pennsylvania | 42123 | 7104 | 203 |
2205801 | 2205801 | 2022-02-11 | Warren | Pennsylvania | 42123 | 7090 | 203 |
2202548 | 2202548 | 2022-02-10 | Warren | Pennsylvania | 42123 | 7073 | 203 |
2127673 | 2127673 | 2022-01-18 | Columbia | Pennsylvania | 42037 | 12798 | 203 |
2124421 | 2124421 | 2022-01-17 | Columbia | Pennsylvania | 42037 | 12725 | 203 |
2121169 | 2121169 | 2022-01-16 | Columbia | Pennsylvania | 42037 | 12665 | 203 |
2117917 | 2117917 | 2022-01-15 | Columbia | Pennsylvania | 42037 | 12458 | 203 |
2078910 | 2078910 | 2022-01-03 | Huntingdon | Pennsylvania | 42061 | 8579 | 203 |
2075659 | 2075659 | 2022-01-02 | Huntingdon | Pennsylvania | 42061 | 8547 | 203 |
2072408 | 2072408 | 2022-01-01 | Huntingdon | Pennsylvania | 42061 | 8519 | 203 |
2069157 | 2069157 | 2021-12-31 | Huntingdon | Pennsylvania | 42061 | 8475 | 203 |
1922878 | 1922878 | 2021-11-16 | Crawford | Pennsylvania | 42039 | 12128 | 203 |
1887124 | 1887124 | 2021-11-05 | Carbon | Pennsylvania | 42025 | 9084 | 203 |
1296093 | 1296093 | 2021-05-07 | Somerset | Pennsylvania | 42111 | 7689 | 203 |
1292847 | 1292847 | 2021-05-06 | Somerset | Pennsylvania | 42111 | 7671 | 203 |
1263608 | 1263608 | 2021-04-27 | Lawrence | Pennsylvania | 42073 | 7212 | 203 |
1023323 | 1023323 | 2021-02-12 | Centre | Pennsylvania | 42027 | 12114 | 203 |
1020078 | 1020078 | 2021-02-11 | Centre | Pennsylvania | 42027 | 12074 | 203 |
955178 | 955178 | 2021-01-22 | Fayette | Pennsylvania | 42051 | 9271 | 203 |
951933 | 951933 | 2021-01-21 | Fayette | Pennsylvania | 42051 | 9225 | 203 |
948705 | 948705 | 2021-01-20 | Mercer | Pennsylvania | 42085 | 7090 | 203 |
893501 | 893501 | 2021-01-03 | Butler | Pennsylvania | 42019 | 9746 | 203 |
835080 | 835080 | 2020-12-16 | Beaver | Pennsylvania | 42007 | 6593 | 203 |
818898 | 818898 | 2020-12-11 | Schuylkill | Pennsylvania | 42107 | 5349 | 203 |
737731 | 737731 | 2020-11-16 | Dauphin | Pennsylvania | 42043 | 6146 | 203 |
682607 | 682607 | 2020-10-30 | Luzerne | Pennsylvania | 42079 | 5467 | 203 |
676148 | 676148 | 2020-10-28 | York | Pennsylvania | 42133 | 6484 | 203 |
672905 | 672905 | 2020-10-27 | York | Pennsylvania | 42133 | 6405 | 203 |
292454 | 292454 | 2020-07-01 | Lackawanna | Pennsylvania | 42069 | 1707 | 203 |
289302 | 289302 | 2020-06-30 | Lackawanna | Pennsylvania | 42069 | 1703 | 203 |
183707 | 183707 | 2020-05-27 | Northampton | Pennsylvania | 42095 | 2958 | 203 |
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);