ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where deaths = 8, fips = 42127 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 |
---|---|---|---|---|---|---|---|
407542 | 407542 | 2020-08-06 | Wayne | Pennsylvania | 42127 | 157 | 8 |
404323 | 404323 | 2020-08-05 | Wayne | Pennsylvania | 42127 | 157 | 8 |
401105 | 401105 | 2020-08-04 | Wayne | Pennsylvania | 42127 | 157 | 8 |
397890 | 397890 | 2020-08-03 | Wayne | Pennsylvania | 42127 | 158 | 8 |
394673 | 394673 | 2020-08-02 | Wayne | Pennsylvania | 42127 | 158 | 8 |
391457 | 391457 | 2020-08-01 | Wayne | Pennsylvania | 42127 | 158 | 8 |
388240 | 388240 | 2020-07-31 | Wayne | Pennsylvania | 42127 | 158 | 8 |
385023 | 385023 | 2020-07-30 | Wayne | Pennsylvania | 42127 | 157 | 8 |
381805 | 381805 | 2020-07-29 | Wayne | Pennsylvania | 42127 | 156 | 8 |
378588 | 378588 | 2020-07-28 | Wayne | Pennsylvania | 42127 | 154 | 8 |
375372 | 375372 | 2020-07-27 | Wayne | Pennsylvania | 42127 | 154 | 8 |
372159 | 372159 | 2020-07-26 | Wayne | Pennsylvania | 42127 | 153 | 8 |
368947 | 368947 | 2020-07-25 | Wayne | Pennsylvania | 42127 | 152 | 8 |
365738 | 365738 | 2020-07-24 | Wayne | Pennsylvania | 42127 | 151 | 8 |
362532 | 362532 | 2020-07-23 | Wayne | Pennsylvania | 42127 | 151 | 8 |
359326 | 359326 | 2020-07-22 | Wayne | Pennsylvania | 42127 | 148 | 8 |
356122 | 356122 | 2020-07-21 | Wayne | Pennsylvania | 42127 | 149 | 8 |
352919 | 352919 | 2020-07-20 | Wayne | Pennsylvania | 42127 | 149 | 8 |
349716 | 349716 | 2020-07-19 | Wayne | Pennsylvania | 42127 | 148 | 8 |
346516 | 346516 | 2020-07-18 | Wayne | Pennsylvania | 42127 | 148 | 8 |
343316 | 343316 | 2020-07-17 | Wayne | Pennsylvania | 42127 | 148 | 8 |
340118 | 340118 | 2020-07-16 | Wayne | Pennsylvania | 42127 | 144 | 8 |
336921 | 336921 | 2020-07-15 | Wayne | Pennsylvania | 42127 | 143 | 8 |
333727 | 333727 | 2020-07-14 | Wayne | Pennsylvania | 42127 | 141 | 8 |
330535 | 330535 | 2020-07-13 | Wayne | Pennsylvania | 42127 | 141 | 8 |
327349 | 327349 | 2020-07-12 | Wayne | Pennsylvania | 42127 | 141 | 8 |
324164 | 324164 | 2020-07-11 | Wayne | Pennsylvania | 42127 | 141 | 8 |
320984 | 320984 | 2020-07-10 | Wayne | Pennsylvania | 42127 | 141 | 8 |
317806 | 317806 | 2020-07-09 | Wayne | Pennsylvania | 42127 | 141 | 8 |
314633 | 314633 | 2020-07-08 | Wayne | Pennsylvania | 42127 | 141 | 8 |
208281 | 208281 | 2020-06-04 | Wayne | Pennsylvania | 42127 | 121 | 8 |
205200 | 205200 | 2020-06-03 | Wayne | Pennsylvania | 42127 | 120 | 8 |
202123 | 202123 | 2020-06-02 | Wayne | Pennsylvania | 42127 | 120 | 8 |
199048 | 199048 | 2020-06-01 | Wayne | Pennsylvania | 42127 | 120 | 8 |
195975 | 195975 | 2020-05-31 | Wayne | Pennsylvania | 42127 | 119 | 8 |
192906 | 192906 | 2020-05-30 | Wayne | Pennsylvania | 42127 | 119 | 8 |
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);