ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
91 rows where cases = 27 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
786405 | 786405 | 2020-12-01 | Cameron | Pennsylvania | 42023 | 27 | 0 |
737736 | 737736 | 2020-11-16 | Forest | Pennsylvania | 42053 | 27 | 1 |
724788 | 724788 | 2020-11-12 | Sullivan | Pennsylvania | 42113 | 27 | 1 |
565869 | 565869 | 2020-09-24 | Potter | Pennsylvania | 42105 | 27 | 0 |
488221 | 488221 | 2020-08-31 | Warren | Pennsylvania | 42123 | 27 | 1 |
484988 | 484988 | 2020-08-30 | Warren | Pennsylvania | 42123 | 27 | 1 |
481753 | 481753 | 2020-08-29 | Warren | Pennsylvania | 42123 | 27 | 1 |
478519 | 478519 | 2020-08-28 | Warren | Pennsylvania | 42123 | 27 | 1 |
426834 | 426834 | 2020-08-12 | Fulton | Pennsylvania | 42057 | 27 | 2 |
423611 | 423611 | 2020-08-11 | Fulton | Pennsylvania | 42057 | 27 | 2 |
420388 | 420388 | 2020-08-10 | Fulton | Pennsylvania | 42057 | 27 | 2 |
417168 | 417168 | 2020-08-09 | Fulton | Pennsylvania | 42057 | 27 | 2 |
413947 | 413947 | 2020-08-08 | Fulton | Pennsylvania | 42057 | 27 | 2 |
320979 | 320979 | 2020-07-10 | Tioga | Pennsylvania | 42117 | 27 | 2 |
317801 | 317801 | 2020-07-09 | Tioga | Pennsylvania | 42117 | 27 | 2 |
314628 | 314628 | 2020-07-08 | Tioga | Pennsylvania | 42117 | 27 | 2 |
311456 | 311456 | 2020-07-07 | Tioga | Pennsylvania | 42117 | 27 | 2 |
308287 | 308287 | 2020-07-06 | Tioga | Pennsylvania | 42117 | 27 | 2 |
308289 | 308289 | 2020-07-06 | Venango | Pennsylvania | 42121 | 27 | 0 |
305120 | 305120 | 2020-07-05 | Tioga | Pennsylvania | 42117 | 27 | 2 |
305122 | 305122 | 2020-07-05 | Venango | Pennsylvania | 42121 | 27 | 0 |
220583 | 220583 | 2020-06-08 | Clarion | Pennsylvania | 42031 | 27 | 2 |
220597 | 220597 | 2020-06-08 | Greene | Pennsylvania | 42059 | 27 | 0 |
217491 | 217491 | 2020-06-07 | Clarion | Pennsylvania | 42031 | 27 | 2 |
217505 | 217505 | 2020-06-07 | Greene | Pennsylvania | 42059 | 27 | 0 |
214401 | 214401 | 2020-06-06 | Clarion | Pennsylvania | 42031 | 27 | 2 |
214415 | 214415 | 2020-06-06 | Greene | Pennsylvania | 42059 | 27 | 0 |
211315 | 211315 | 2020-06-05 | Clarion | Pennsylvania | 42031 | 27 | 2 |
211329 | 211329 | 2020-06-05 | Greene | Pennsylvania | 42059 | 27 | 0 |
208233 | 208233 | 2020-06-04 | Clarion | Pennsylvania | 42031 | 27 | 2 |
208247 | 208247 | 2020-06-04 | Greene | Pennsylvania | 42059 | 27 | 0 |
205152 | 205152 | 2020-06-03 | Clarion | Pennsylvania | 42031 | 27 | 2 |
205166 | 205166 | 2020-06-03 | Greene | Pennsylvania | 42059 | 27 | 0 |
202075 | 202075 | 2020-06-02 | Clarion | Pennsylvania | 42031 | 27 | 2 |
202089 | 202089 | 2020-06-02 | Greene | Pennsylvania | 42059 | 27 | 0 |
199000 | 199000 | 2020-06-01 | Clarion | Pennsylvania | 42031 | 27 | 2 |
199014 | 199014 | 2020-06-01 | Greene | Pennsylvania | 42059 | 27 | 0 |
195927 | 195927 | 2020-05-31 | Clarion | Pennsylvania | 42031 | 27 | 2 |
195941 | 195941 | 2020-05-31 | Greene | Pennsylvania | 42059 | 27 | 0 |
192858 | 192858 | 2020-05-30 | Clarion | Pennsylvania | 42031 | 27 | 2 |
192872 | 192872 | 2020-05-30 | Greene | Pennsylvania | 42059 | 27 | 0 |
189807 | 189807 | 2020-05-29 | Greene | Pennsylvania | 42059 | 27 | 0 |
186746 | 186746 | 2020-05-28 | Greene | Pennsylvania | 42059 | 27 | 0 |
183689 | 183689 | 2020-05-27 | Greene | Pennsylvania | 42059 | 27 | 0 |
180639 | 180639 | 2020-05-26 | Greene | Pennsylvania | 42059 | 27 | 0 |
177596 | 177596 | 2020-05-25 | Greene | Pennsylvania | 42059 | 27 | 0 |
174552 | 174552 | 2020-05-24 | Greene | Pennsylvania | 42059 | 27 | 0 |
171510 | 171510 | 2020-05-23 | Greene | Pennsylvania | 42059 | 27 | 0 |
168471 | 168471 | 2020-05-22 | Greene | Pennsylvania | 42059 | 27 | 0 |
165435 | 165435 | 2020-05-21 | Greene | Pennsylvania | 42059 | 27 | 0 |
162406 | 162406 | 2020-05-20 | Greene | Pennsylvania | 42059 | 27 | 0 |
159379 | 159379 | 2020-05-19 | Greene | Pennsylvania | 42059 | 27 | 0 |
156358 | 156358 | 2020-05-18 | Greene | Pennsylvania | 42059 | 27 | 0 |
153341 | 153341 | 2020-05-17 | Greene | Pennsylvania | 42059 | 27 | 1 |
150330 | 150330 | 2020-05-16 | Greene | Pennsylvania | 42059 | 27 | 1 |
147323 | 147323 | 2020-05-15 | Greene | Pennsylvania | 42059 | 27 | 1 |
144322 | 144322 | 2020-05-14 | Greene | Pennsylvania | 42059 | 27 | 1 |
141326 | 141326 | 2020-05-13 | Greene | Pennsylvania | 42059 | 27 | 1 |
138330 | 138330 | 2020-05-12 | Greene | Pennsylvania | 42059 | 27 | 1 |
135340 | 135340 | 2020-05-11 | Greene | Pennsylvania | 42059 | 27 | 1 |
132349 | 132349 | 2020-05-10 | Greene | Pennsylvania | 42059 | 27 | 1 |
129360 | 129360 | 2020-05-09 | Greene | Pennsylvania | 42059 | 27 | 1 |
126371 | 126371 | 2020-05-08 | Greene | Pennsylvania | 42059 | 27 | 1 |
123363 | 123363 | 2020-05-07 | Bedford | Pennsylvania | 42009 | 27 | 1 |
123388 | 123388 | 2020-05-07 | Greene | Pennsylvania | 42059 | 27 | 1 |
123424 | 123424 | 2020-05-07 | Wyoming | Pennsylvania | 42131 | 27 | 2 |
120386 | 120386 | 2020-05-06 | Bedford | Pennsylvania | 42009 | 27 | 1 |
120411 | 120411 | 2020-05-06 | Greene | Pennsylvania | 42059 | 27 | 1 |
120447 | 120447 | 2020-05-06 | Wyoming | Pennsylvania | 42131 | 27 | 2 |
117449 | 117449 | 2020-05-05 | Greene | Pennsylvania | 42059 | 27 | 1 |
117485 | 117485 | 2020-05-05 | Wyoming | Pennsylvania | 42131 | 27 | 2 |
114568 | 114568 | 2020-05-04 | Greene | Pennsylvania | 42059 | 27 | 1 |
114604 | 114604 | 2020-05-04 | Wyoming | Pennsylvania | 42131 | 27 | 2 |
111686 | 111686 | 2020-05-03 | Greene | Pennsylvania | 42059 | 27 | 1 |
108812 | 108812 | 2020-05-02 | Greene | Pennsylvania | 42059 | 27 | 0 |
97400 | 97400 | 2020-04-28 | Perry | Pennsylvania | 42099 | 27 | 1 |
91728 | 91728 | 2020-04-26 | Mifflin | Pennsylvania | 42087 | 27 | 0 |
72159 | 72159 | 2020-04-19 | Snyder | Pennsylvania | 42109 | 27 | 1 |
72164 | 72164 | 2020-04-19 | Union | Pennsylvania | 42119 | 27 | 0 |
69392 | 69392 | 2020-04-18 | Snyder | Pennsylvania | 42109 | 27 | 1 |
69397 | 69397 | 2020-04-18 | Union | Pennsylvania | 42119 | 27 | 0 |
53007 | 53007 | 2020-04-12 | Armstrong | Pennsylvania | 42005 | 27 | 1 |
42514 | 42514 | 2020-04-08 | Mercer | Pennsylvania | 42085 | 27 | 0 |
39958 | 39958 | 2020-04-07 | Montour | Pennsylvania | 42093 | 27 | 0 |
34940 | 34940 | 2020-04-05 | Fayette | Pennsylvania | 42051 | 27 | 1 |
32507 | 32507 | 2020-04-04 | Franklin | Pennsylvania | 42055 | 27 | 0 |
25499 | 25499 | 2020-04-01 | Centre | Pennsylvania | 42027 | 27 | 0 |
21184 | 21184 | 2020-03-30 | Lebanon | Pennsylvania | 42075 | 27 | 0 |
17209 | 17209 | 2020-03-28 | Pike | Pennsylvania | 42103 | 27 | 1 |
11981 | 11981 | 2020-03-25 | Luzerne | Pennsylvania | 42079 | 27 | 1 |
10516 | 10516 | 2020-03-24 | Lehigh | Pennsylvania | 42077 | 27 | 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);