ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where cases = 106 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
822147 | 822147 | 2020-12-12 | Sullivan | Pennsylvania | 42113 | 106 | 2 |
796155 | 796155 | 2020-12-04 | Forest | Pennsylvania | 42053 | 106 | 1 |
546419 | 546419 | 2020-09-18 | Jefferson | Pennsylvania | 42065 | 106 | 2 |
433303 | 433303 | 2020-08-14 | Montour | Pennsylvania | 42093 | 106 | 3 |
430077 | 430077 | 2020-08-13 | Montour | Pennsylvania | 42093 | 106 | 3 |
420414 | 420414 | 2020-08-10 | Snyder | Pennsylvania | 42109 | 106 | 2 |
394653 | 394653 | 2020-08-02 | Mifflin | Pennsylvania | 42087 | 106 | 1 |
372145 | 372145 | 2020-07-26 | Perry | Pennsylvania | 42099 | 106 | 5 |
372151 | 372151 | 2020-07-26 | Somerset | Pennsylvania | 42111 | 106 | 2 |
368933 | 368933 | 2020-07-25 | Perry | Pennsylvania | 42099 | 106 | 5 |
368939 | 368939 | 2020-07-25 | Somerset | Pennsylvania | 42111 | 106 | 2 |
365730 | 365730 | 2020-07-24 | Somerset | Pennsylvania | 42111 | 106 | 2 |
356063 | 356063 | 2020-07-21 | Bedford | Pennsylvania | 42009 | 106 | 4 |
276703 | 276703 | 2020-06-26 | Fayette | Pennsylvania | 42051 | 106 | 4 |
186759 | 186759 | 2020-05-28 | Mercer | Pennsylvania | 42085 | 106 | 4 |
183702 | 183702 | 2020-05-27 | Mercer | Pennsylvania | 42085 | 106 | 4 |
117433 | 117433 | 2020-05-05 | Centre | Pennsylvania | 42027 | 106 | 2 |
69365 | 69365 | 2020-04-18 | Franklin | Pennsylvania | 42055 | 106 | 0 |
53023 | 53023 | 2020-04-12 | Columbia | Pennsylvania | 42037 | 106 | 3 |
34951 | 34951 | 2020-04-05 | Lebanon | Pennsylvania | 42075 | 106 | 0 |
17202 | 17202 | 2020-03-28 | Monroe | Pennsylvania | 42089 | 106 | 2 |
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);