ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52,441 rows where state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) 799 ✖
- 2020-04-07 67
- 2020-04-08 67
- 2020-04-09 67
- 2020-04-10 67
- 2020-04-11 67
- 2020-04-12 67
- 2020-04-13 67
- 2020-04-14 67
- 2020-04-15 67
- 2020-04-16 67
- 2020-04-17 67
- 2020-04-18 67
- 2020-04-19 67
- 2020-04-20 67
- 2020-04-21 67
- 2020-04-22 67
- 2020-04-23 67
- 2020-04-24 67
- 2020-04-25 67
- 2020-04-26 67
- 2020-04-27 67
- 2020-04-28 67
- 2020-04-29 67
- 2020-04-30 67
- 2020-05-01 67
- 2020-05-02 67
- 2020-05-03 67
- 2020-05-04 67
- 2020-05-05 67
- 2020-05-06 67
- 2020-05-07 67
- 2020-05-08 67
- 2020-05-09 67
- 2020-05-10 67
- 2020-05-11 67
- 2020-05-12 67
- 2020-05-13 67
- 2020-05-14 67
- 2020-05-15 67
- 2020-05-16 67
- 2020-05-17 67
- 2020-05-18 67
- 2020-05-19 67
- 2020-05-20 67
- 2020-05-21 67
- 2020-05-22 67
- 2020-05-23 67
- 2020-05-24 67
- 2020-05-25 67
- 2020-05-26 67
- 2020-05-27 67
- 2020-05-28 67
- 2020-05-29 67
- 2020-05-30 67
- 2020-05-31 67
- 2020-06-01 67
- 2020-06-02 67
- 2020-06-03 67
- 2020-06-04 67
- 2020-06-05 67
- 2020-06-06 67
- 2020-06-07 67
- 2020-06-08 67
- 2020-06-09 67
- 2020-06-10 67
- 2020-06-11 67
- 2020-06-12 67
- 2020-06-13 67
- 2020-06-14 67
- 2020-06-15 67
- 2020-06-16 67
- 2020-06-17 67
- 2020-06-18 67
- 2020-06-19 67
- 2020-06-20 67
- 2020-06-21 67
- 2020-06-22 67
- 2020-06-23 67
- 2020-06-24 67
- 2020-06-25 67
- 2020-06-26 67
- 2020-06-27 67
- 2020-06-28 67
- 2020-06-29 67
- 2020-06-30 67
- 2020-07-01 67
- 2020-07-02 67
- 2020-07-03 67
- 2020-07-04 67
- 2020-07-05 67
- 2020-07-06 67
- 2020-07-07 67
- 2020-07-08 67
- 2020-07-09 67
- 2020-07-10 67
- 2020-07-11 67
- 2020-07-12 67
- 2020-07-13 67
- 2020-07-14 67
- 2020-07-15 67
- 2020-07-16 67
- 2020-07-17 67
- 2020-07-18 67
- 2020-07-19 67
- 2020-07-20 67
- 2020-07-21 67
- 2020-07-22 67
- 2020-07-23 67
- 2020-07-24 67
- 2020-07-25 67
- 2020-07-26 67
- 2020-07-27 67
- 2020-07-28 67
- 2020-07-29 67
- 2020-07-30 67
- 2020-07-31 67
- 2020-08-01 67
- 2020-08-02 67
- 2020-08-03 67
- 2020-08-04 67
- 2020-08-05 67
- 2020-08-06 67
- 2020-08-07 67
- 2020-08-08 67
- 2020-08-09 67
- 2020-08-10 67
- 2020-08-11 67
- 2020-08-12 67
- 2020-08-13 67
- 2020-08-14 67
- 2020-08-15 67
- 2020-08-16 67
- 2020-08-17 67
- 2020-08-18 67
- 2020-08-19 67
- 2020-08-20 67
- 2020-08-21 67
- 2020-08-22 67
- 2020-08-23 67
- 2020-08-24 67
- 2020-08-25 67
- 2020-08-26 67
- 2020-08-27 67
- 2020-08-28 67
- 2020-08-29 67
- 2020-08-30 67
- 2020-08-31 67
- 2020-09-01 67
- 2020-09-02 67
- 2020-09-03 67
- 2020-09-04 67
- 2020-09-05 67
- 2020-09-06 67
- 2020-09-07 67
- 2020-09-08 67
- 2020-09-09 67
- 2020-09-10 67
- 2020-09-11 67
- 2020-09-12 67
- 2020-09-13 67
- 2020-09-14 67
- 2020-09-15 67
- 2020-09-16 67
- 2020-09-17 67
- 2020-09-18 67
- 2020-09-19 67
- 2020-09-20 67
- 2020-09-21 67
- 2020-09-22 67
- 2020-09-23 67
- 2020-09-24 67
- 2020-09-25 67
- 2020-09-26 67
- 2020-09-27 67
- 2020-09-28 67
- 2020-09-29 67
- 2020-09-30 67
- 2020-10-01 67
- 2020-10-02 67
- 2020-10-03 67
- 2020-10-04 67
- 2020-10-05 67
- 2020-10-06 67
- 2020-10-07 67
- 2020-10-08 67
- 2020-10-09 67
- 2020-10-10 67
- 2020-10-11 67
- 2020-10-12 67
- 2020-10-13 67
- 2020-10-14 67
- 2020-10-15 67
- 2020-10-16 67
- 2020-10-17 67
- 2020-10-18 67
- 2020-10-19 67
- 2020-10-20 67
- 2020-10-21 67
- 2020-10-22 67
- 2020-10-23 67
- 2020-10-24 67
- 2020-10-25 67
- 2020-10-26 67
- 2020-10-27 67
- 2020-10-28 67
- 2020-10-29 67
- 2020-10-30 67
- 2020-10-31 67
- 2020-11-01 67
- 2020-11-02 67
- 2020-11-03 67
- 2020-11-04 67
- 2020-11-05 67
- 2020-11-06 67
- 2020-11-07 67
- 2020-11-08 67
- 2020-11-09 67
- 2020-11-10 67
- 2020-11-11 67
- 2020-11-12 67
- 2020-11-13 67
- 2020-11-14 67
- 2020-11-15 67
- 2020-11-16 67
- 2020-11-17 67
- 2020-11-18 67
- 2020-11-19 67
- 2020-11-20 67
- 2020-11-21 67
- 2020-11-22 67
- 2020-11-23 67
- 2020-11-24 67
- 2020-11-25 67
- 2020-11-26 67
- 2020-11-27 67
- 2020-11-28 67
- 2020-11-29 67
- 2020-11-30 67
- 2020-12-01 67
- 2020-12-02 67
- 2020-12-03 67
- 2020-12-04 67
- 2020-12-05 67
- 2020-12-06 67
- 2020-12-07 67
- 2020-12-08 67
- 2020-12-09 67
- 2020-12-10 67
- 2020-12-11 67
- 2020-12-12 67
- 2020-12-13 67
- 2020-12-14 67
- 2020-12-15 67
- 2020-12-16 67
- 2020-12-17 67
- 2020-12-18 67
- 2020-12-19 67
- 2020-12-20 67
- 2020-12-21 67
- 2020-12-22 67
- 2020-12-23 67
- 2020-12-24 67
- 2020-12-25 67
- 2020-12-26 67
- 2020-12-27 67
- 2020-12-28 67
- 2020-12-29 67
- 2020-12-30 67
- 2020-12-31 67
- 2021-01-01 67
- 2021-01-02 67
- 2021-01-03 67
- 2021-01-04 67
- 2021-01-05 67
- 2021-01-06 67
- 2021-01-07 67
- 2021-01-08 67
- 2021-01-09 67
- 2021-01-10 67
- 2021-01-11 67
- 2021-01-12 67
- 2021-01-13 67
- 2021-01-14 67
- 2021-01-15 67
- 2021-01-16 67
- 2021-01-17 67
- 2021-01-18 67
- 2021-01-19 67
- 2021-01-20 67
- 2021-01-21 67
- 2021-01-22 67
- 2021-01-23 67
- 2021-01-24 67
- 2021-01-25 67
- 2021-01-26 67
- 2021-01-27 67
- 2021-01-28 67
- 2021-01-29 67
- 2021-01-30 67
- 2021-01-31 67
- 2021-02-01 67
- 2021-02-02 67
- 2021-02-03 67
- 2021-02-04 67
- 2021-02-05 67
- 2021-02-06 67
- 2021-02-07 67
- 2021-02-08 67
- 2021-02-09 67
- 2021-02-10 67
- 2021-02-11 67
- 2021-02-12 67
- 2021-02-13 67
- 2021-02-14 67
- 2021-02-15 67
- 2021-02-16 67
- 2021-02-17 67
- 2021-02-18 67
- 2021-02-19 67
- 2021-02-20 67
- 2021-02-21 67
- 2021-02-22 67
- 2021-02-23 67
- 2021-02-24 67
- 2021-02-25 67
- 2021-02-26 67
- 2021-02-27 67
- 2021-02-28 67
- 2021-03-01 67
- 2021-03-02 67
- 2021-03-03 67
- 2021-03-04 67
- 2021-03-05 67
- 2021-03-06 67
- 2021-03-07 67
- 2021-03-08 67
- 2021-03-09 67
- 2021-03-10 67
- 2021-03-11 67
- 2021-03-12 67
- 2021-03-13 67
- 2021-03-14 67
- 2021-03-15 67
- 2021-03-16 67
- 2021-03-17 67
- 2021-03-18 67
- 2021-03-19 67
- 2021-03-20 67
- 2021-03-21 67
- 2021-03-22 67
- 2021-03-23 67
- 2021-03-24 67
- 2021-03-25 67
- 2021-03-26 67
- 2021-03-27 67
- 2021-03-28 67
- 2021-03-29 67
- 2021-03-30 67
- 2021-03-31 67
- 2021-04-01 67
- 2021-04-02 67
- 2021-04-03 67
- 2021-04-04 67
- 2021-04-05 67
- 2021-04-06 67
- 2021-04-07 67
- 2021-04-08 67
- 2021-04-09 67
- 2021-04-10 67
- 2021-04-11 67
- 2021-04-12 67
- 2021-04-13 67
- 2021-04-14 67
- 2021-04-15 67
- 2021-04-16 67
- 2021-04-17 67
- 2021-04-18 67
- 2021-04-19 67
- 2021-04-20 67
- 2021-04-21 67
- 2021-04-22 67
- 2021-04-23 67
- 2021-04-24 67
- 2021-04-25 67
- 2021-04-26 67
- 2021-04-27 67
- 2021-04-28 67
- 2021-04-29 67
- 2021-04-30 67
- 2021-05-01 67
- 2021-05-02 67
- 2021-05-03 67
- 2021-05-04 67
- 2021-05-05 67
- 2021-05-06 67
- 2021-05-07 67
- 2021-05-08 67
- 2021-05-09 67
- 2021-05-10 67
- 2021-05-11 67
- 2021-05-12 67
- 2021-05-13 67
- 2021-05-14 67
- 2021-05-15 67
- 2021-05-16 67
- 2021-05-17 67
- 2021-05-18 67
- 2021-05-19 67
- 2021-05-20 67
- 2021-05-21 67
- 2021-05-22 67
- 2021-05-23 67
- 2021-05-24 67
- 2021-05-25 67
- 2021-05-26 67
- 2021-05-27 67
- 2021-05-28 67
- 2021-05-29 67
- 2021-05-30 67
- 2021-05-31 67
- 2021-06-01 67
- 2021-06-02 67
- 2021-06-03 67
- 2021-06-04 67
- 2021-06-05 67
- 2021-06-06 67
- 2021-06-07 67
- 2021-06-08 67
- 2021-06-09 67
- 2021-06-10 67
- 2021-06-11 67
- 2021-06-12 67
- 2021-06-13 67
- 2021-06-14 67
- 2021-06-15 67
- 2021-06-16 67
- 2021-06-17 67
- 2021-06-18 67
- 2021-06-19 67
- 2021-06-20 67
- 2021-06-21 67
- 2021-06-22 67
- 2021-06-23 67
- 2021-06-24 67
- 2021-06-25 67
- 2021-06-26 67
- 2021-06-27 67
- 2021-06-28 67
- 2021-06-29 67
- 2021-06-30 67
- 2021-07-01 67
- 2021-07-02 67
- 2021-07-03 67
- 2021-07-04 67
- 2021-07-05 67
- 2021-07-06 67
- 2021-07-07 67
- 2021-07-08 67
- 2021-07-09 67
- 2021-07-10 67
- 2021-07-11 67
- 2021-07-12 67
- 2021-07-13 67
- 2021-07-14 67
- 2021-07-15 67
- 2021-07-16 67
- 2021-07-17 67
- 2021-07-18 67
- 2021-07-19 67
- 2021-07-20 67
- 2021-07-21 67
- 2021-07-22 67
- 2021-07-23 67
- 2021-07-24 67
- 2021-07-25 67
- 2021-07-26 67
- 2021-07-27 67
- 2021-07-28 67
- 2021-07-29 67
- 2021-07-30 67
- 2021-07-31 67
- 2021-08-01 67
- 2021-08-02 67
- 2021-08-03 67
- 2021-08-04 67
- 2021-08-05 67
- 2021-08-06 67
- 2021-08-07 67
- 2021-08-08 67
- 2021-08-09 67
- 2021-08-10 67
- 2021-08-11 67
- 2021-08-12 67
- 2021-08-13 67
- 2021-08-14 67
- 2021-08-15 67
- 2021-08-16 67
- 2021-08-17 67
- 2021-08-18 67
- 2021-08-19 67
- 2021-08-20 67
- 2021-08-21 67
- 2021-08-22 67
- 2021-08-23 67
- 2021-08-24 67
- 2021-08-25 67
- 2021-08-26 67
- 2021-08-27 67
- 2021-08-28 67
- 2021-08-29 67
- 2021-08-30 67
- 2021-08-31 67
- 2021-09-01 67
- 2021-09-02 67
- 2021-09-03 67
- 2021-09-04 67
- 2021-09-05 67
- 2021-09-06 67
- 2021-09-07 67
- 2021-09-08 67
- 2021-09-09 67
- 2021-09-10 67
- 2021-09-11 67
- 2021-09-12 67
- 2021-09-13 67
- 2021-09-14 67
- 2021-09-15 67
- 2021-09-16 67
- 2021-09-17 67
- 2021-09-18 67
- 2021-09-19 67
- 2021-09-20 67
- 2021-09-21 67
- 2021-09-22 67
- 2021-09-23 67
- 2021-09-24 67
- 2021-09-25 67
- 2021-09-26 67
- 2021-09-27 67
- 2021-09-28 67
- 2021-09-29 67
- 2021-09-30 67
- 2021-10-01 67
- 2021-10-02 67
- 2021-10-03 67
- 2021-10-04 67
- 2021-10-05 67
- 2021-10-06 67
- 2021-10-07 67
- 2021-10-08 67
- 2021-10-09 67
- 2021-10-10 67
- 2021-10-11 67
- 2021-10-12 67
- 2021-10-13 67
- 2021-10-14 67
- 2021-10-15 67
- 2021-10-16 67
- 2021-10-17 67
- 2021-10-18 67
- 2021-10-19 67
- 2021-10-20 67
- 2021-10-21 67
- 2021-10-22 67
- 2021-10-23 67
- 2021-10-24 67
- 2021-10-25 67
- 2021-10-26 67
- 2021-10-27 67
- 2021-10-28 67
- 2021-10-29 67
- 2021-10-30 67
- 2021-10-31 67
- 2021-11-01 67
- 2021-11-02 67
- 2021-11-03 67
- 2021-11-04 67
- 2021-11-05 67
- 2021-11-06 67
- 2021-11-07 67
- 2021-11-08 67
- 2021-11-09 67
- 2021-11-10 67
- 2021-11-11 67
- 2021-11-12 67
- 2021-11-13 67
- 2021-11-14 67
- 2021-11-15 67
- 2021-11-16 67
- 2021-11-17 67
- 2021-11-18 67
- 2021-11-19 67
- 2021-11-20 67
- 2021-11-21 67
- 2021-11-22 67
- 2021-11-23 67
- 2021-11-24 67
- 2021-11-25 67
- 2021-11-26 67
- 2021-11-27 67
- 2021-11-28 67
- 2021-11-29 67
- 2021-11-30 67
- 2021-12-01 67
- 2021-12-02 67
- 2021-12-03 67
- 2021-12-04 67
- 2021-12-05 67
- 2021-12-06 67
- 2021-12-07 67
- 2021-12-08 67
- 2021-12-09 67
- 2021-12-10 67
- 2021-12-11 67
- 2021-12-12 67
- 2021-12-13 67
- 2021-12-14 67
- 2021-12-15 67
- 2021-12-16 67
- 2021-12-17 67
- 2021-12-18 67
- 2021-12-19 67
- 2021-12-20 67
- 2021-12-21 67
- 2021-12-22 67
- 2021-12-23 67
- 2021-12-24 67
- 2021-12-25 67
- 2021-12-26 67
- 2021-12-27 67
- 2021-12-28 67
- 2021-12-29 67
- 2021-12-30 67
- 2021-12-31 67
- 2022-01-01 67
- 2022-01-02 67
- 2022-01-03 67
- 2022-01-04 67
- 2022-01-05 67
- 2022-01-06 67
- 2022-01-07 67
- 2022-01-08 67
- 2022-01-09 67
- 2022-01-10 67
- 2022-01-11 67
- 2022-01-12 67
- 2022-01-13 67
- 2022-01-14 67
- 2022-01-15 67
- 2022-01-16 67
- 2022-01-17 67
- 2022-01-18 67
- 2022-01-19 67
- 2022-01-20 67
- 2022-01-21 67
- 2022-01-22 67
- 2022-01-23 67
- 2022-01-24 67
- 2022-01-25 67
- 2022-01-26 67
- 2022-01-27 67
- 2022-01-28 67
- 2022-01-29 67
- 2022-01-30 67
- 2022-01-31 67
- 2022-02-01 67
- 2022-02-02 67
- 2022-02-03 67
- 2022-02-04 67
- 2022-02-05 67
- 2022-02-06 67
- 2022-02-07 67
- 2022-02-08 67
- 2022-02-09 67
- 2022-02-10 67
- 2022-02-11 67
- 2022-02-12 67
- 2022-02-13 67
- 2022-02-14 67
- 2022-02-15 67
- 2022-02-16 67
- 2022-02-17 67
- 2022-02-18 67
- 2022-02-19 67
- 2022-02-20 67
- 2022-02-21 67
- 2022-02-22 67
- 2022-02-23 67
- 2022-02-24 67
- 2022-02-25 67
- 2022-02-26 67
- 2022-02-27 67
- 2022-02-28 67
- 2022-03-01 67
- 2022-03-02 67
- 2022-03-03 67
- 2022-03-04 67
- 2022-03-05 67
- 2022-03-06 67
- 2022-03-07 67
- 2022-03-08 67
- 2022-03-09 67
- 2022-03-10 67
- 2022-03-11 67
- 2022-03-12 67
- 2022-03-13 67
- 2022-03-14 67
- 2022-03-15 67
- 2022-03-16 67
- 2022-03-17 67
- 2022-03-18 67
- 2022-03-19 67
- 2022-03-20 67
- 2022-03-21 67
- 2022-03-22 67
- 2022-03-23 67
- 2022-03-24 67
- 2022-03-25 67
- 2022-03-26 67
- 2022-03-27 67
- 2022-03-28 67
- 2022-03-29 67
- 2022-03-30 67
- 2022-03-31 67
- 2022-04-01 67
- 2022-04-02 67
- 2022-04-03 67
- 2022-04-04 67
- 2022-04-05 67
- 2022-04-06 67
- 2022-04-07 67
- 2022-04-08 67
- 2022-04-09 67
- 2022-04-10 67
- 2022-04-11 67
- 2022-04-12 67
- 2022-04-13 67
- 2022-04-14 67
- 2022-04-15 67
- 2022-04-16 67
- 2022-04-17 67
- 2022-04-18 67
- 2022-04-19 67
- 2022-04-20 67
- 2022-04-21 67
- 2022-04-22 67
- 2022-04-23 67
- 2022-04-24 67
- 2022-04-25 67
- 2022-04-26 67
- 2022-04-27 67
- 2022-04-28 67
- 2022-04-29 67
- 2022-04-30 67
- 2022-05-01 67
- 2022-05-02 67
- 2022-05-03 67
- 2022-05-04 67
- 2022-05-05 67
- 2022-05-06 67
- 2022-05-07 67
- 2022-05-08 67
- 2022-05-09 67
- 2022-05-10 67
- 2022-05-11 67
- 2022-05-12 67
- 2022-05-13 67
- 2020-04-05 65
- 2020-04-06 65
- 2020-04-04 64
- 2020-04-03 63
- 2020-03-31 61
- 2020-04-02 61
- 2020-04-01 60
- 2020-03-30 59
- 2020-03-29 58
- 2020-03-28 56
- 2020-03-27 49
- 2020-03-26 48
- 2020-03-25 44
- 2020-03-24 40
- 2020-03-23 34
- 2020-03-22 33
- 2020-03-21 28
- 2020-03-20 26
- 2020-03-19 22
- 2020-03-18 19
- 2020-03-17 15
- 2020-03-15 14
- 2020-03-16 14
- 2020-03-14 12
- 2020-03-13 11
- 2020-03-12 8
- 2020-03-11 6
- 2020-03-10 5
- 2020-03-09 4
- 2020-03-07 3
- 2020-03-08 3
- 2020-03-06 2
fips 68
- 42045 799
- 42127 799
- 42091 798
- 42089 796
- 42101 795
- 42017 794
- 42095 793
- 42103 793
- 42029 792
- 42041 792
- 42125 792
- 42003 791
- 42077 790
- 42079 790
- 42007 788
- 42001 787
- 42011 787
- 42069 787
- 42133 787
- 42071 786
- 42075 786
- 42129 786
- 42027 785
- 42049 785
- 42055 785
- 42105 785
- 42019 784
- 42093 784
- 42037 783
- 42043 783
- 42051 783
- 42085 783
- 42107 783
- 42021 782
- 42005 781
- 42015 781
- 42025 781
- 42033 781
- 42067 781
- 42111 781
- 42059 780
- 42073 780
- 42081 780
- 42123 780
- 42013 779
- 42039 779
- 42063 779
- 42115 779
- 42097 778
- 42023 777
- 42031 777
- 42061 777
- 42083 777
- 42099 777
- 42109 777
- 42117 777
- 42087 776
- 42121 776
- 42119 775
- 42009 774
- 42053 772
- 42035 771
- 42113 770
- 42131 770
- 42057 769
- 42047 767
- 42065 767
- - 2
county 68
- Delaware 799
- Wayne 799
- Montgomery 798
- Monroe 796
- Philadelphia 795
- Bucks 794
- Northampton 793
- Pike 793
- Chester 792
- Cumberland 792
- Washington 792
- Allegheny 791
- Lehigh 790
- Luzerne 790
- Beaver 788
- Adams 787
- Berks 787
- Lackawanna 787
- York 787
- Lancaster 786
- Lebanon 786
- Westmoreland 786
- Centre 785
- Erie 785
- Franklin 785
- Potter 785
- Butler 784
- Montour 784
- Columbia 783
- Dauphin 783
- Fayette 783
- Mercer 783
- Schuylkill 783
- Cambria 782
- Armstrong 781
- Bradford 781
- Carbon 781
- Clearfield 781
- Juniata 781
- Somerset 781
- Greene 780
- Lawrence 780
- Lycoming 780
- Warren 780
- Blair 779
- Crawford 779
- Indiana 779
- Susquehanna 779
- Northumberland 778
- Cameron 777
- Clarion 777
- Huntingdon 777
- McKean 777
- Perry 777
- Snyder 777
- Tioga 777
- Mifflin 776
- Venango 776
- Union 775
- Bedford 774
- Forest 772
- Clinton 771
- Sullivan 770
- Wyoming 770
- Fulton 769
- Elk 767
- Jefferson 767
- Unknown 2
state 1
- Pennsylvania · 52,441 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501847 | 2501847 | 2022-05-13 | Adams | Pennsylvania | 42001 | 25114 | 364 |
2501848 | 2501848 | 2022-05-13 | Allegheny | Pennsylvania | 42003 | 271427 | 3323 |
2501849 | 2501849 | 2022-05-13 | Armstrong | Pennsylvania | 42005 | 15397 | 343 |
2501850 | 2501850 | 2022-05-13 | Beaver | Pennsylvania | 42007 | 40744 | 745 |
2501851 | 2501851 | 2022-05-13 | Bedford | Pennsylvania | 42009 | 11044 | 275 |
2501852 | 2501852 | 2022-05-13 | Berks | Pennsylvania | 42011 | 103652 | 1595 |
2501853 | 2501853 | 2022-05-13 | Blair | Pennsylvania | 42013 | 29924 | 616 |
2501854 | 2501854 | 2022-05-13 | Bradford | Pennsylvania | 42015 | 16219 | 207 |
2501855 | 2501855 | 2022-05-13 | Bucks | Pennsylvania | 42017 | 126504 | 1905 |
2501856 | 2501856 | 2022-05-13 | Butler | Pennsylvania | 42019 | 45173 | 743 |
2501857 | 2501857 | 2022-05-13 | Cambria | Pennsylvania | 42021 | 34936 | 732 |
2501858 | 2501858 | 2022-05-13 | Cameron | Pennsylvania | 42023 | 822 | 21 |
2501859 | 2501859 | 2022-05-13 | Carbon | Pennsylvania | 42025 | 16188 | 294 |
2501860 | 2501860 | 2022-05-13 | Centre | Pennsylvania | 42027 | 36016 | 351 |
2501861 | 2501861 | 2022-05-13 | Chester | Pennsylvania | 42029 | 94968 | 1164 |
2501862 | 2501862 | 2022-05-13 | Clarion | Pennsylvania | 42031 | 8323 | 202 |
2501863 | 2501863 | 2022-05-13 | Clearfield | Pennsylvania | 42033 | 19533 | 348 |
2501864 | 2501864 | 2022-05-13 | Clinton | Pennsylvania | 42035 | 9157 | 127 |
2501865 | 2501865 | 2022-05-13 | Columbia | Pennsylvania | 42037 | 15476 | 246 |
2501866 | 2501866 | 2022-05-13 | Crawford | Pennsylvania | 42039 | 20080 | 320 |
2501867 | 2501867 | 2022-05-13 | Cumberland | Pennsylvania | 42041 | 51754 | 892 |
2501868 | 2501868 | 2022-05-13 | Dauphin | Pennsylvania | 42043 | 59830 | 964 |
2501869 | 2501869 | 2022-05-13 | Delaware | Pennsylvania | 42045 | 113339 | 1875 |
2501870 | 2501870 | 2022-05-13 | Elk | Pennsylvania | 42047 | 7193 | 101 |
2501871 | 2501871 | 2022-05-13 | Erie | Pennsylvania | 42049 | 58218 | 760 |
2501872 | 2501872 | 2022-05-13 | Fayette | Pennsylvania | 42051 | 31332 | 674 |
2501873 | 2501873 | 2022-05-13 | Forest | Pennsylvania | 42053 | 2250 | 35 |
2501874 | 2501874 | 2022-05-13 | Franklin | Pennsylvania | 42055 | 40694 | 695 |
2501875 | 2501875 | 2022-05-13 | Fulton | Pennsylvania | 42057 | 4153 | 65 |
2501876 | 2501876 | 2022-05-13 | Greene | Pennsylvania | 42059 | 8513 | 104 |
2501877 | 2501877 | 2022-05-13 | Huntingdon | Pennsylvania | 42061 | 11594 | 249 |
2501878 | 2501878 | 2022-05-13 | Indiana | Pennsylvania | 42063 | 17690 | 356 |
2501879 | 2501879 | 2022-05-13 | Jefferson | Pennsylvania | 42065 | 9121 | 235 |
2501880 | 2501880 | 2022-05-13 | Juniata | Pennsylvania | 42067 | 4797 | 176 |
2501881 | 2501881 | 2022-05-13 | Lackawanna | Pennsylvania | 42069 | 45137 | 776 |
2501882 | 2501882 | 2022-05-13 | Lancaster | Pennsylvania | 42071 | 122794 | 1890 |
2501883 | 2501883 | 2022-05-13 | Lawrence | Pennsylvania | 42073 | 19109 | 418 |
2501884 | 2501884 | 2022-05-13 | Lebanon | Pennsylvania | 42075 | 37011 | 518 |
2501885 | 2501885 | 2022-05-13 | Lehigh | Pennsylvania | 42077 | 91539 | 1246 |
2501886 | 2501886 | 2022-05-13 | Luzerne | Pennsylvania | 42079 | 75379 | 1366 |
2501887 | 2501887 | 2022-05-13 | Lycoming | Pennsylvania | 42081 | 28894 | 522 |
2501888 | 2501888 | 2022-05-13 | McKean | Pennsylvania | 42083 | 8298 | 141 |
2501889 | 2501889 | 2022-05-13 | Mercer | Pennsylvania | 42085 | 23612 | 498 |
2501890 | 2501890 | 2022-05-13 | Mifflin | Pennsylvania | 42087 | 12348 | 276 |
2501891 | 2501891 | 2022-05-13 | Monroe | Pennsylvania | 42089 | 37881 | 524 |
2501892 | 2501892 | 2022-05-13 | Montgomery | Pennsylvania | 42091 | 158154 | 2329 |
2501893 | 2501893 | 2022-05-13 | Montour | Pennsylvania | 42093 | 4637 | 93 |
2501894 | 2501894 | 2022-05-13 | Northampton | Pennsylvania | 42095 | 81732 | 1097 |
2501895 | 2501895 | 2022-05-13 | Northumberland | Pennsylvania | 42097 | 23172 | 534 |
2501896 | 2501896 | 2022-05-13 | Perry | Pennsylvania | 42099 | 8873 | 185 |
2501897 | 2501897 | 2022-05-13 | Philadelphia | Pennsylvania | 42101 | 317808 | 5110 |
2501898 | 2501898 | 2022-05-13 | Pike | Pennsylvania | 42103 | 10557 | 98 |
2501899 | 2501899 | 2022-05-13 | Potter | Pennsylvania | 42105 | 3256 | 92 |
2501900 | 2501900 | 2022-05-13 | Schuylkill | Pennsylvania | 42107 | 34853 | 675 |
2501901 | 2501901 | 2022-05-13 | Snyder | Pennsylvania | 42109 | 8149 | 158 |
2501902 | 2501902 | 2022-05-13 | Somerset | Pennsylvania | 42111 | 18829 | 408 |
2501903 | 2501903 | 2022-05-13 | Sullivan | Pennsylvania | 42113 | 1092 | 36 |
2501904 | 2501904 | 2022-05-13 | Susquehanna | Pennsylvania | 42115 | 8188 | 110 |
2501905 | 2501905 | 2022-05-13 | Tioga | Pennsylvania | 42117 | 8270 | 193 |
2501906 | 2501906 | 2022-05-13 | Union | Pennsylvania | 42119 | 11842 | 154 |
2501907 | 2501907 | 2022-05-13 | Venango | Pennsylvania | 42121 | 11406 | 241 |
2501908 | 2501908 | 2022-05-13 | Warren | Pennsylvania | 42123 | 7506 | 212 |
2501909 | 2501909 | 2022-05-13 | Washington | Pennsylvania | 42125 | 51747 | 654 |
2501910 | 2501910 | 2022-05-13 | Wayne | Pennsylvania | 42127 | 10460 | 172 |
2501911 | 2501911 | 2022-05-13 | Westmoreland | Pennsylvania | 42129 | 81006 | 1378 |
2501912 | 2501912 | 2022-05-13 | Wyoming | Pennsylvania | 42131 | 5257 | 106 |
2501913 | 2501913 | 2022-05-13 | York | Pennsylvania | 42133 | 120372 | 1502 |
2498589 | 2498589 | 2022-05-12 | Adams | Pennsylvania | 42001 | 25114 | 364 |
2498590 | 2498590 | 2022-05-12 | Allegheny | Pennsylvania | 42003 | 271427 | 3323 |
2498591 | 2498591 | 2022-05-12 | Armstrong | Pennsylvania | 42005 | 15397 | 343 |
2498592 | 2498592 | 2022-05-12 | Beaver | Pennsylvania | 42007 | 40744 | 745 |
2498593 | 2498593 | 2022-05-12 | Bedford | Pennsylvania | 42009 | 11044 | 275 |
2498594 | 2498594 | 2022-05-12 | Berks | Pennsylvania | 42011 | 103652 | 1595 |
2498595 | 2498595 | 2022-05-12 | Blair | Pennsylvania | 42013 | 29924 | 616 |
2498596 | 2498596 | 2022-05-12 | Bradford | Pennsylvania | 42015 | 16219 | 207 |
2498597 | 2498597 | 2022-05-12 | Bucks | Pennsylvania | 42017 | 126504 | 1905 |
2498598 | 2498598 | 2022-05-12 | Butler | Pennsylvania | 42019 | 45173 | 743 |
2498599 | 2498599 | 2022-05-12 | Cambria | Pennsylvania | 42021 | 34936 | 732 |
2498600 | 2498600 | 2022-05-12 | Cameron | Pennsylvania | 42023 | 822 | 21 |
2498601 | 2498601 | 2022-05-12 | Carbon | Pennsylvania | 42025 | 16188 | 294 |
2498602 | 2498602 | 2022-05-12 | Centre | Pennsylvania | 42027 | 36016 | 351 |
2498603 | 2498603 | 2022-05-12 | Chester | Pennsylvania | 42029 | 94968 | 1164 |
2498604 | 2498604 | 2022-05-12 | Clarion | Pennsylvania | 42031 | 8323 | 202 |
2498605 | 2498605 | 2022-05-12 | Clearfield | Pennsylvania | 42033 | 19533 | 348 |
2498606 | 2498606 | 2022-05-12 | Clinton | Pennsylvania | 42035 | 9157 | 127 |
2498607 | 2498607 | 2022-05-12 | Columbia | Pennsylvania | 42037 | 15476 | 246 |
2498608 | 2498608 | 2022-05-12 | Crawford | Pennsylvania | 42039 | 20080 | 320 |
2498609 | 2498609 | 2022-05-12 | Cumberland | Pennsylvania | 42041 | 51754 | 892 |
2498610 | 2498610 | 2022-05-12 | Dauphin | Pennsylvania | 42043 | 59830 | 964 |
2498611 | 2498611 | 2022-05-12 | Delaware | Pennsylvania | 42045 | 113339 | 1875 |
2498612 | 2498612 | 2022-05-12 | Elk | Pennsylvania | 42047 | 7193 | 101 |
2498613 | 2498613 | 2022-05-12 | Erie | Pennsylvania | 42049 | 58218 | 760 |
2498614 | 2498614 | 2022-05-12 | Fayette | Pennsylvania | 42051 | 31332 | 674 |
2498615 | 2498615 | 2022-05-12 | Forest | Pennsylvania | 42053 | 2250 | 35 |
2498616 | 2498616 | 2022-05-12 | Franklin | Pennsylvania | 42055 | 40694 | 695 |
2498617 | 2498617 | 2022-05-12 | Fulton | Pennsylvania | 42057 | 4153 | 65 |
2498618 | 2498618 | 2022-05-12 | Greene | Pennsylvania | 42059 | 8513 | 104 |
2498619 | 2498619 | 2022-05-12 | Huntingdon | Pennsylvania | 42061 | 11594 | 249 |
2498620 | 2498620 | 2022-05-12 | Indiana | Pennsylvania | 42063 | 17690 | 356 |
2498621 | 2498621 | 2022-05-12 | Jefferson | Pennsylvania | 42065 | 9121 | 235 |
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);