ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where deaths = 12, fips = 42019 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
245415 | 245415 | 2020-06-16 | Butler | Pennsylvania | 42019 | 260 | 12 |
242303 | 242303 | 2020-06-15 | Butler | Pennsylvania | 42019 | 257 | 12 |
239194 | 239194 | 2020-06-14 | Butler | Pennsylvania | 42019 | 257 | 12 |
236086 | 236086 | 2020-06-13 | Butler | Pennsylvania | 42019 | 257 | 12 |
232981 | 232981 | 2020-06-12 | Butler | Pennsylvania | 42019 | 256 | 12 |
229876 | 229876 | 2020-06-11 | Butler | Pennsylvania | 42019 | 255 | 12 |
226772 | 226772 | 2020-06-10 | Butler | Pennsylvania | 42019 | 250 | 12 |
223672 | 223672 | 2020-06-09 | Butler | Pennsylvania | 42019 | 249 | 12 |
220577 | 220577 | 2020-06-08 | Butler | Pennsylvania | 42019 | 247 | 12 |
217485 | 217485 | 2020-06-07 | Butler | Pennsylvania | 42019 | 247 | 12 |
214395 | 214395 | 2020-06-06 | Butler | Pennsylvania | 42019 | 244 | 12 |
211309 | 211309 | 2020-06-05 | Butler | Pennsylvania | 42019 | 239 | 12 |
208227 | 208227 | 2020-06-04 | Butler | Pennsylvania | 42019 | 240 | 12 |
205146 | 205146 | 2020-06-03 | Butler | Pennsylvania | 42019 | 235 | 12 |
202069 | 202069 | 2020-06-02 | Butler | Pennsylvania | 42019 | 232 | 12 |
198994 | 198994 | 2020-06-01 | Butler | Pennsylvania | 42019 | 230 | 12 |
195921 | 195921 | 2020-05-31 | Butler | Pennsylvania | 42019 | 230 | 12 |
192852 | 192852 | 2020-05-30 | Butler | Pennsylvania | 42019 | 229 | 12 |
189787 | 189787 | 2020-05-29 | Butler | Pennsylvania | 42019 | 227 | 12 |
186726 | 186726 | 2020-05-28 | Butler | Pennsylvania | 42019 | 226 | 12 |
183669 | 183669 | 2020-05-27 | Butler | Pennsylvania | 42019 | 222 | 12 |
180619 | 180619 | 2020-05-26 | Butler | Pennsylvania | 42019 | 220 | 12 |
177576 | 177576 | 2020-05-25 | Butler | Pennsylvania | 42019 | 220 | 12 |
174532 | 174532 | 2020-05-24 | Butler | Pennsylvania | 42019 | 219 | 12 |
171490 | 171490 | 2020-05-23 | Butler | Pennsylvania | 42019 | 216 | 12 |
168451 | 168451 | 2020-05-22 | Butler | Pennsylvania | 42019 | 209 | 12 |
165415 | 165415 | 2020-05-21 | Butler | Pennsylvania | 42019 | 209 | 12 |
162386 | 162386 | 2020-05-20 | Butler | Pennsylvania | 42019 | 208 | 12 |
159359 | 159359 | 2020-05-19 | Butler | Pennsylvania | 42019 | 206 | 12 |
156338 | 156338 | 2020-05-18 | Butler | Pennsylvania | 42019 | 203 | 12 |
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);