ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where cases = 38 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 24
county 24
- Somerset 7
- Elk 4
- Fulton 4
- Snyder 4
- Tioga 4
- Union 4
- Armstrong 3
- Blair 3
- Bradford 3
- Wyoming 3
- Bedford 2
- Juniata 2
- Mifflin 2
- Adams 1
- Clearfield 1
- Crawford 1
- Cumberland 1
- Huntingdon 1
- Lehigh 1
- Mercer 1
- Potter 1
- Schuylkill 1
- Venango 1
- Washington 1
state 1
- Pennsylvania · 56 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637198 | 637198 | 2020-10-16 | Potter | Pennsylvania | 42105 | 38 | 1 |
520525 | 520525 | 2020-09-10 | Fulton | Pennsylvania | 42057 | 38 | 2 |
517289 | 517289 | 2020-09-09 | Fulton | Pennsylvania | 42057 | 38 | 2 |
514054 | 514054 | 2020-09-08 | Fulton | Pennsylvania | 42057 | 38 | 2 |
510821 | 510821 | 2020-09-07 | Fulton | Pennsylvania | 42057 | 38 | 2 |
423641 | 423641 | 2020-08-11 | Tioga | Pennsylvania | 42117 | 38 | 3 |
420418 | 420418 | 2020-08-10 | Tioga | Pennsylvania | 42117 | 38 | 3 |
417198 | 417198 | 2020-08-09 | Tioga | Pennsylvania | 42117 | 38 | 3 |
413977 | 413977 | 2020-08-08 | Tioga | Pennsylvania | 42117 | 38 | 3 |
365698 | 365698 | 2020-07-24 | Elk | Pennsylvania | 42047 | 38 | 2 |
362492 | 362492 | 2020-07-23 | Elk | Pennsylvania | 42047 | 38 | 2 |
359286 | 359286 | 2020-07-22 | Elk | Pennsylvania | 42047 | 38 | 2 |
356082 | 356082 | 2020-07-21 | Elk | Pennsylvania | 42047 | 38 | 2 |
330532 | 330532 | 2020-07-13 | Venango | Pennsylvania | 42121 | 38 | 0 |
295641 | 295641 | 2020-07-02 | Wyoming | Pennsylvania | 42131 | 38 | 7 |
292485 | 292485 | 2020-07-01 | Wyoming | Pennsylvania | 42131 | 38 | 7 |
289333 | 289333 | 2020-06-30 | Wyoming | Pennsylvania | 42131 | 38 | 7 |
254768 | 254768 | 2020-06-19 | Crawford | Pennsylvania | 42039 | 38 | 0 |
211355 | 211355 | 2020-06-05 | Somerset | Pennsylvania | 42111 | 38 | 1 |
208273 | 208273 | 2020-06-04 | Somerset | Pennsylvania | 42111 | 38 | 1 |
205192 | 205192 | 2020-06-03 | Somerset | Pennsylvania | 42111 | 38 | 1 |
202115 | 202115 | 2020-06-02 | Somerset | Pennsylvania | 42111 | 38 | 1 |
199040 | 199040 | 2020-06-01 | Somerset | Pennsylvania | 42111 | 38 | 1 |
195967 | 195967 | 2020-05-31 | Somerset | Pennsylvania | 42111 | 38 | 1 |
192898 | 192898 | 2020-05-30 | Somerset | Pennsylvania | 42111 | 38 | 1 |
189794 | 189794 | 2020-05-29 | Clearfield | Pennsylvania | 42033 | 38 | 0 |
186721 | 186721 | 2020-05-28 | Bedford | Pennsylvania | 42009 | 38 | 2 |
183664 | 183664 | 2020-05-27 | Bedford | Pennsylvania | 42009 | 38 | 2 |
180664 | 180664 | 2020-05-26 | Snyder | Pennsylvania | 42109 | 38 | 1 |
177621 | 177621 | 2020-05-25 | Snyder | Pennsylvania | 42109 | 38 | 1 |
174577 | 174577 | 2020-05-24 | Snyder | Pennsylvania | 42109 | 38 | 1 |
171535 | 171535 | 2020-05-23 | Snyder | Pennsylvania | 42109 | 38 | 1 |
159356 | 159356 | 2020-05-19 | Blair | Pennsylvania | 42013 | 38 | 1 |
156335 | 156335 | 2020-05-18 | Blair | Pennsylvania | 42013 | 38 | 1 |
153318 | 153318 | 2020-05-17 | Blair | Pennsylvania | 42013 | 38 | 0 |
135318 | 135318 | 2020-05-11 | Bradford | Pennsylvania | 42015 | 38 | 5 |
132327 | 132327 | 2020-05-10 | Bradford | Pennsylvania | 42015 | 38 | 5 |
129338 | 129338 | 2020-05-09 | Bradford | Pennsylvania | 42015 | 38 | 5 |
117479 | 117479 | 2020-05-05 | Union | Pennsylvania | 42119 | 38 | 1 |
114598 | 114598 | 2020-05-04 | Union | Pennsylvania | 42119 | 38 | 0 |
111716 | 111716 | 2020-05-03 | Union | Pennsylvania | 42119 | 38 | 0 |
108826 | 108826 | 2020-05-02 | Mifflin | Pennsylvania | 42087 | 38 | 0 |
108842 | 108842 | 2020-05-02 | Union | Pennsylvania | 42119 | 38 | 0 |
103083 | 103083 | 2020-04-30 | Huntingdon | Pennsylvania | 42061 | 38 | 0 |
103096 | 103096 | 2020-04-30 | Mifflin | Pennsylvania | 42087 | 38 | 0 |
77664 | 77664 | 2020-04-21 | Armstrong | Pennsylvania | 42005 | 38 | 2 |
74882 | 74882 | 2020-04-20 | Armstrong | Pennsylvania | 42005 | 38 | 2 |
72107 | 72107 | 2020-04-19 | Armstrong | Pennsylvania | 42005 | 38 | 2 |
53038 | 53038 | 2020-04-12 | Juniata | Pennsylvania | 42067 | 38 | 0 |
50365 | 50365 | 2020-04-11 | Juniata | Pennsylvania | 42067 | 38 | 0 |
50374 | 50374 | 2020-04-11 | Mercer | Pennsylvania | 42085 | 38 | 0 |
45058 | 45058 | 2020-04-09 | Adams | Pennsylvania | 42001 | 38 | 1 |
27815 | 27815 | 2020-04-02 | Washington | Pennsylvania | 42125 | 38 | 0 |
25505 | 25505 | 2020-04-01 | Cumberland | Pennsylvania | 42041 | 38 | 1 |
23336 | 23336 | 2020-03-31 | Schuylkill | Pennsylvania | 42107 | 38 | 0 |
11980 | 11980 | 2020-03-25 | Lehigh | Pennsylvania | 42077 | 38 | 0 |
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);