ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where cases = 66 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
698837 | 698837 | 2020-11-04 | Potter | Pennsylvania | 42105 | 66 | 1 |
695594 | 695594 | 2020-11-03 | Potter | Pennsylvania | 42105 | 66 | 1 |
679386 | 679386 | 2020-10-29 | Warren | Pennsylvania | 42123 | 66 | 1 |
676143 | 676143 | 2020-10-28 | Warren | Pennsylvania | 42123 | 66 | 1 |
614482 | 614482 | 2020-10-09 | McKean | Pennsylvania | 42083 | 66 | 2 |
611241 | 611241 | 2020-10-08 | McKean | Pennsylvania | 42083 | 66 | 2 |
565875 | 565875 | 2020-09-24 | Tioga | Pennsylvania | 42117 | 66 | 3 |
539937 | 539937 | 2020-09-16 | Elk | Pennsylvania | 42047 | 66 | 2 |
536700 | 536700 | 2020-09-15 | Elk | Pennsylvania | 42047 | 66 | 2 |
533464 | 533464 | 2020-09-14 | Elk | Pennsylvania | 42047 | 66 | 2 |
530229 | 530229 | 2020-09-13 | Elk | Pennsylvania | 42047 | 66 | 2 |
526992 | 526992 | 2020-09-12 | Elk | Pennsylvania | 42047 | 66 | 2 |
484992 | 484992 | 2020-08-30 | Wyoming | Pennsylvania | 42131 | 66 | 8 |
481757 | 481757 | 2020-08-29 | Wyoming | Pennsylvania | 42131 | 66 | 8 |
478523 | 478523 | 2020-08-28 | Wyoming | Pennsylvania | 42131 | 66 | 8 |
336873 | 336873 | 2020-07-15 | Clarion | Pennsylvania | 42031 | 66 | 2 |
333679 | 333679 | 2020-07-14 | Clarion | Pennsylvania | 42031 | 66 | 2 |
311441 | 311441 | 2020-07-07 | Mifflin | Pennsylvania | 42087 | 66 | 1 |
305081 | 305081 | 2020-07-05 | Crawford | Pennsylvania | 42039 | 66 | 0 |
292474 | 292474 | 2020-07-01 | Snyder | Pennsylvania | 42109 | 66 | 2 |
289322 | 289322 | 2020-06-30 | Snyder | Pennsylvania | 42109 | 66 | 2 |
264134 | 264134 | 2020-06-22 | Bedford | Pennsylvania | 42009 | 66 | 2 |
261006 | 261006 | 2020-06-21 | Bedford | Pennsylvania | 42009 | 66 | 2 |
261018 | 261018 | 2020-06-21 | Clearfield | Pennsylvania | 42033 | 66 | 0 |
257891 | 257891 | 2020-06-20 | Clearfield | Pennsylvania | 42033 | 66 | 0 |
242296 | 242296 | 2020-06-15 | Armstrong | Pennsylvania | 42005 | 66 | 5 |
239187 | 239187 | 2020-06-14 | Armstrong | Pennsylvania | 42005 | 66 | 5 |
236079 | 236079 | 2020-06-13 | Armstrong | Pennsylvania | 42005 | 66 | 5 |
232974 | 232974 | 2020-06-12 | Armstrong | Pennsylvania | 42005 | 66 | 5 |
114581 | 114581 | 2020-05-04 | Mercer | Pennsylvania | 42085 | 66 | 1 |
111699 | 111699 | 2020-05-03 | Mercer | Pennsylvania | 42085 | 66 | 1 |
108825 | 108825 | 2020-05-02 | Mercer | Pennsylvania | 42085 | 66 | 1 |
105958 | 105958 | 2020-05-01 | Mercer | Pennsylvania | 42085 | 66 | 1 |
103095 | 103095 | 2020-04-30 | Mercer | Pennsylvania | 42085 | 66 | 1 |
100242 | 100242 | 2020-04-29 | Mercer | Pennsylvania | 42085 | 66 | 1 |
97393 | 97393 | 2020-04-28 | Mercer | Pennsylvania | 42085 | 66 | 1 |
74937 | 74937 | 2020-04-20 | Susquehanna | Pennsylvania | 42115 | 66 | 4 |
72130 | 72130 | 2020-04-19 | Fayette | Pennsylvania | 42051 | 66 | 3 |
69363 | 69363 | 2020-04-18 | Fayette | Pennsylvania | 42051 | 66 | 3 |
69371 | 69371 | 2020-04-18 | Juniata | Pennsylvania | 42067 | 66 | 0 |
66605 | 66605 | 2020-04-17 | Fayette | Pennsylvania | 42051 | 66 | 3 |
55717 | 55717 | 2020-04-13 | Franklin | Pennsylvania | 42055 | 66 | 0 |
50394 | 50394 | 2020-04-11 | Washington | Pennsylvania | 42125 | 66 | 0 |
47737 | 47737 | 2020-04-10 | Washington | Pennsylvania | 42125 | 66 | 0 |
25545 | 25545 | 2020-04-01 | York | Pennsylvania | 42133 | 66 | 0 |
23348 | 23348 | 2020-03-31 | York | Pennsylvania | 42133 | 66 | 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);