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 rowid
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 |
---|---|---|---|---|---|---|---|
635 | 635 | 2020-03-06 | Delaware | Pennsylvania | 42045 | 1 | 0 |
636 | 636 | 2020-03-06 | Wayne | Pennsylvania | 42127 | 1 | 0 |
726 | 726 | 2020-03-07 | Delaware | Pennsylvania | 42045 | 1 | 0 |
727 | 727 | 2020-03-07 | Montgomery | Pennsylvania | 42091 | 2 | 0 |
728 | 728 | 2020-03-07 | Wayne | Pennsylvania | 42127 | 1 | 0 |
835 | 835 | 2020-03-08 | Delaware | Pennsylvania | 42045 | 1 | 0 |
836 | 836 | 2020-03-08 | Montgomery | Pennsylvania | 42091 | 4 | 0 |
837 | 837 | 2020-03-08 | Wayne | Pennsylvania | 42127 | 1 | 0 |
963 | 963 | 2020-03-09 | Delaware | Pennsylvania | 42045 | 1 | 0 |
964 | 964 | 2020-03-09 | Monroe | Pennsylvania | 42089 | 1 | 0 |
965 | 965 | 2020-03-09 | Montgomery | Pennsylvania | 42091 | 7 | 0 |
966 | 966 | 2020-03-09 | Wayne | Pennsylvania | 42127 | 1 | 0 |
1115 | 1115 | 2020-03-10 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1116 | 1116 | 2020-03-10 | Monroe | Pennsylvania | 42089 | 1 | 0 |
1117 | 1117 | 2020-03-10 | Montgomery | Pennsylvania | 42091 | 8 | 0 |
1118 | 1118 | 2020-03-10 | Philadelphia | Pennsylvania | 42101 | 1 | 0 |
1119 | 1119 | 2020-03-10 | Wayne | Pennsylvania | 42127 | 1 | 0 |
1308 | 1308 | 2020-03-11 | Bucks | Pennsylvania | 42017 | 2 | 0 |
1309 | 1309 | 2020-03-11 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1310 | 1310 | 2020-03-11 | Monroe | Pennsylvania | 42089 | 2 | 0 |
1311 | 1311 | 2020-03-11 | Montgomery | Pennsylvania | 42091 | 9 | 0 |
1312 | 1312 | 2020-03-11 | Philadelphia | Pennsylvania | 42101 | 1 | 0 |
1313 | 1313 | 2020-03-11 | Wayne | Pennsylvania | 42127 | 1 | 0 |
1552 | 1552 | 2020-03-12 | Bucks | Pennsylvania | 42017 | 2 | 0 |
1553 | 1553 | 2020-03-12 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1554 | 1554 | 2020-03-12 | Monroe | Pennsylvania | 42089 | 2 | 0 |
1555 | 1555 | 2020-03-12 | Montgomery | Pennsylvania | 42091 | 13 | 0 |
1556 | 1556 | 2020-03-12 | Northampton | Pennsylvania | 42095 | 1 | 0 |
1557 | 1557 | 2020-03-12 | Philadelphia | Pennsylvania | 42101 | 1 | 0 |
1558 | 1558 | 2020-03-12 | Pike | Pennsylvania | 42103 | 1 | 0 |
1559 | 1559 | 2020-03-12 | Wayne | Pennsylvania | 42127 | 1 | 0 |
1848 | 1848 | 2020-03-13 | Bucks | Pennsylvania | 42017 | 3 | 0 |
1849 | 1849 | 2020-03-13 | Chester | Pennsylvania | 42029 | 1 | 0 |
1850 | 1850 | 2020-03-13 | Cumberland | Pennsylvania | 42041 | 3 | 0 |
1851 | 1851 | 2020-03-13 | Delaware | Pennsylvania | 42045 | 6 | 0 |
1852 | 1852 | 2020-03-13 | Monroe | Pennsylvania | 42089 | 3 | 0 |
1853 | 1853 | 2020-03-13 | Montgomery | Pennsylvania | 42091 | 18 | 0 |
1854 | 1854 | 2020-03-13 | Northampton | Pennsylvania | 42095 | 1 | 0 |
1855 | 1855 | 2020-03-13 | Philadelphia | Pennsylvania | 42101 | 3 | 0 |
1856 | 1856 | 2020-03-13 | Pike | Pennsylvania | 42103 | 1 | 0 |
1857 | 1857 | 2020-03-13 | Washington | Pennsylvania | 42125 | 1 | 0 |
1858 | 1858 | 2020-03-13 | Wayne | Pennsylvania | 42127 | 1 | 0 |
2209 | 2209 | 2020-03-14 | Allegheny | Pennsylvania | 42003 | 1 | 0 |
2210 | 2210 | 2020-03-14 | Bucks | Pennsylvania | 42017 | 4 | 0 |
2211 | 2211 | 2020-03-14 | Chester | Pennsylvania | 42029 | 2 | 0 |
2212 | 2212 | 2020-03-14 | Cumberland | Pennsylvania | 42041 | 3 | 0 |
2213 | 2213 | 2020-03-14 | Delaware | Pennsylvania | 42045 | 6 | 0 |
2214 | 2214 | 2020-03-14 | Monroe | Pennsylvania | 42089 | 3 | 0 |
2215 | 2215 | 2020-03-14 | Montgomery | Pennsylvania | 42091 | 20 | 0 |
2216 | 2216 | 2020-03-14 | Northampton | Pennsylvania | 42095 | 1 | 0 |
2217 | 2217 | 2020-03-14 | Philadelphia | Pennsylvania | 42101 | 4 | 0 |
2218 | 2218 | 2020-03-14 | Pike | Pennsylvania | 42103 | 1 | 0 |
2219 | 2219 | 2020-03-14 | Washington | Pennsylvania | 42125 | 1 | 0 |
2220 | 2220 | 2020-03-14 | Wayne | Pennsylvania | 42127 | 1 | 0 |
2629 | 2629 | 2020-03-15 | Allegheny | Pennsylvania | 42003 | 3 | 0 |
2630 | 2630 | 2020-03-15 | Bucks | Pennsylvania | 42017 | 4 | 0 |
2631 | 2631 | 2020-03-15 | Chester | Pennsylvania | 42029 | 4 | 0 |
2632 | 2632 | 2020-03-15 | Cumberland | Pennsylvania | 42041 | 5 | 0 |
2633 | 2633 | 2020-03-15 | Delaware | Pennsylvania | 42045 | 7 | 0 |
2634 | 2634 | 2020-03-15 | Lehigh | Pennsylvania | 42077 | 1 | 0 |
2635 | 2635 | 2020-03-15 | Luzerne | Pennsylvania | 42079 | 1 | 0 |
2636 | 2636 | 2020-03-15 | Monroe | Pennsylvania | 42089 | 7 | 0 |
2637 | 2637 | 2020-03-15 | Montgomery | Pennsylvania | 42091 | 24 | 0 |
2638 | 2638 | 2020-03-15 | Northampton | Pennsylvania | 42095 | 1 | 0 |
2639 | 2639 | 2020-03-15 | Philadelphia | Pennsylvania | 42101 | 8 | 0 |
2640 | 2640 | 2020-03-15 | Pike | Pennsylvania | 42103 | 1 | 0 |
2641 | 2641 | 2020-03-15 | Washington | Pennsylvania | 42125 | 1 | 0 |
2642 | 2642 | 2020-03-15 | Wayne | Pennsylvania | 42127 | 1 | 0 |
3094 | 3094 | 2020-03-16 | Allegheny | Pennsylvania | 42003 | 5 | 0 |
3095 | 3095 | 2020-03-16 | Bucks | Pennsylvania | 42017 | 7 | 0 |
3096 | 3096 | 2020-03-16 | Chester | Pennsylvania | 42029 | 4 | 0 |
3097 | 3097 | 2020-03-16 | Cumberland | Pennsylvania | 42041 | 5 | 0 |
3098 | 3098 | 2020-03-16 | Delaware | Pennsylvania | 42045 | 7 | 0 |
3099 | 3099 | 2020-03-16 | Lehigh | Pennsylvania | 42077 | 1 | 0 |
3100 | 3100 | 2020-03-16 | Luzerne | Pennsylvania | 42079 | 1 | 0 |
3101 | 3101 | 2020-03-16 | Monroe | Pennsylvania | 42089 | 9 | 0 |
3102 | 3102 | 2020-03-16 | Montgomery | Pennsylvania | 42091 | 30 | 0 |
3103 | 3103 | 2020-03-16 | Northampton | Pennsylvania | 42095 | 1 | 0 |
3104 | 3104 | 2020-03-16 | Philadelphia | Pennsylvania | 42101 | 8 | 0 |
3105 | 3105 | 2020-03-16 | Pike | Pennsylvania | 42103 | 1 | 0 |
3106 | 3106 | 2020-03-16 | Washington | Pennsylvania | 42125 | 1 | 0 |
3107 | 3107 | 2020-03-16 | Wayne | Pennsylvania | 42127 | 1 | 0 |
3623 | 3623 | 2020-03-17 | Allegheny | Pennsylvania | 42003 | 10 | 0 |
3624 | 3624 | 2020-03-17 | Beaver | Pennsylvania | 42007 | 1 | 0 |
3625 | 3625 | 2020-03-17 | Bucks | Pennsylvania | 42017 | 9 | 0 |
3626 | 3626 | 2020-03-17 | Chester | Pennsylvania | 42029 | 4 | 0 |
3627 | 3627 | 2020-03-17 | Cumberland | Pennsylvania | 42041 | 10 | 0 |
3628 | 3628 | 2020-03-17 | Delaware | Pennsylvania | 42045 | 9 | 0 |
3629 | 3629 | 2020-03-17 | Lehigh | Pennsylvania | 42077 | 1 | 0 |
3630 | 3630 | 2020-03-17 | Luzerne | Pennsylvania | 42079 | 1 | 0 |
3631 | 3631 | 2020-03-17 | Monroe | Pennsylvania | 42089 | 9 | 0 |
3632 | 3632 | 2020-03-17 | Montgomery | Pennsylvania | 42091 | 32 | 0 |
3633 | 3633 | 2020-03-17 | Northampton | Pennsylvania | 42095 | 1 | 0 |
3634 | 3634 | 2020-03-17 | Philadelphia | Pennsylvania | 42101 | 10 | 0 |
3635 | 3635 | 2020-03-17 | Pike | Pennsylvania | 42103 | 1 | 0 |
3636 | 3636 | 2020-03-17 | Washington | Pennsylvania | 42125 | 2 | 0 |
3637 | 3637 | 2020-03-17 | Wayne | Pennsylvania | 42127 | 1 | 0 |
4238 | 4238 | 2020-03-18 | Adams | Pennsylvania | 42001 | 1 | 0 |
4239 | 4239 | 2020-03-18 | Allegheny | Pennsylvania | 42003 | 12 | 0 |
4240 | 4240 | 2020-03-18 | Beaver | Pennsylvania | 42007 | 2 | 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);