ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Somerset" and fips = 42111 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths
date (date) 781 ✖
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- 2020-04-26 1
- 2020-04-27 1
- 2020-04-28 1
- 2020-04-29 1
- 2020-04-30 1
- 2020-05-01 1
- 2020-05-02 1
- 2020-05-03 1
- 2020-05-04 1
- 2020-05-05 1
- 2020-05-06 1
- 2020-05-07 1
- 2020-05-08 1
- 2020-05-09 1
- 2020-05-10 1
- 2020-05-11 1
- 2020-05-12 1
- 2020-05-13 1
- 2020-05-14 1
- 2020-05-15 1
- 2020-05-16 1
- 2020-05-17 1
- 2020-05-18 1
- 2020-05-19 1
- 2020-05-20 1
- 2020-05-21 1
- 2020-05-22 1
- 2020-05-23 1
- 2020-05-24 1
- 2020-05-25 1
- 2020-05-26 1
- 2020-05-27 1
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- 2020-06-12 1
- 2020-06-13 1
- 2020-06-14 1
- 2020-06-15 1
- 2020-06-16 1
- 2020-06-17 1
- 2020-06-18 1
- 2020-06-19 1
- 2020-06-20 1
- 2020-06-21 1
- 2020-06-22 1
- 2020-06-23 1
- 2020-06-24 1
- 2020-06-25 1
- 2020-06-26 1
- 2020-06-27 1
- 2020-06-28 1
- 2020-06-29 1
- 2020-06-30 1
- 2020-07-01 1
- 2020-07-02 1
- 2020-07-03 1
- 2020-07-04 1
- 2020-07-05 1
- 2020-07-06 1
- 2020-07-07 1
- 2020-07-08 1
- 2020-07-09 1
- 2020-07-10 1
- 2020-07-11 1
- 2020-07-12 1
- 2020-07-13 1
- 2020-07-14 1
- 2020-07-15 1
- 2020-07-16 1
- 2020-07-17 1
- 2020-07-18 1
- 2020-07-19 1
- 2020-07-20 1
- 2020-07-21 1
- 2020-07-22 1
- 2020-07-23 1
- 2020-07-24 1
- 2020-07-25 1
- 2020-07-26 1
- 2020-07-27 1
- 2020-07-28 1
- 2020-07-29 1
- 2020-07-30 1
- 2020-07-31 1
- 2020-08-01 1
- 2020-08-02 1
- 2020-08-03 1
- 2020-08-04 1
- 2020-08-05 1
- 2020-08-06 1
- 2020-08-07 1
- 2020-08-08 1
- 2020-08-09 1
- 2020-08-10 1
- 2020-08-11 1
- 2020-08-12 1
- 2020-08-13 1
- 2020-08-14 1
- 2020-08-15 1
- 2020-08-16 1
- 2020-08-17 1
- 2020-08-18 1
- 2020-08-19 1
- 2020-08-20 1
- 2020-08-21 1
- 2020-08-22 1
- 2020-08-23 1
- 2020-08-24 1
- 2020-08-25 1
- 2020-08-26 1
- 2020-08-27 1
- 2020-08-28 1
- 2020-08-29 1
- 2020-08-30 1
- 2020-08-31 1
- 2020-09-01 1
- 2020-09-02 1
- 2020-09-03 1
- 2020-09-04 1
- 2020-09-05 1
- 2020-09-06 1
- 2020-09-07 1
- 2020-09-08 1
- 2020-09-09 1
- 2020-09-10 1
- 2020-09-11 1
- 2020-09-12 1
- 2020-09-13 1
- 2020-09-14 1
- 2020-09-15 1
- 2020-09-16 1
- 2020-09-17 1
- 2020-09-18 1
- 2020-09-19 1
- 2020-09-20 1
- 2020-09-21 1
- 2020-09-22 1
- 2020-09-23 1
- 2020-09-24 1
- 2020-09-25 1
- 2020-09-26 1
- 2020-09-27 1
- 2020-09-28 1
- 2020-09-29 1
- 2020-09-30 1
- 2020-10-01 1
- 2020-10-02 1
- 2020-10-03 1
- 2020-10-04 1
- 2020-10-05 1
- 2020-10-06 1
- 2020-10-07 1
- 2020-10-08 1
- 2020-10-09 1
- 2020-10-10 1
- 2020-10-11 1
- 2020-10-12 1
- 2020-10-13 1
- 2020-10-14 1
- 2020-10-15 1
- 2020-10-16 1
- 2020-10-17 1
- 2020-10-18 1
- 2020-10-19 1
- 2020-10-20 1
- 2020-10-21 1
- 2020-10-22 1
- 2020-10-23 1
- 2020-10-24 1
- 2020-10-25 1
- 2020-10-26 1
- 2020-10-27 1
- 2020-10-28 1
- 2020-10-29 1
- 2020-10-30 1
- 2020-10-31 1
- 2020-11-01 1
- 2020-11-02 1
- 2020-11-03 1
- 2020-11-04 1
- 2020-11-05 1
- 2020-11-06 1
- 2020-11-07 1
- 2020-11-08 1
- 2020-11-09 1
- 2020-11-10 1
- 2020-11-11 1
- 2020-11-12 1
- 2020-11-13 1
- 2020-11-14 1
- 2020-11-15 1
- 2020-11-16 1
- 2020-11-17 1
- 2020-11-18 1
- 2020-11-19 1
- 2020-11-20 1
- 2020-11-21 1
- 2020-11-22 1
- 2020-11-23 1
- 2020-11-24 1
- 2020-11-25 1
- 2020-11-26 1
- 2020-11-27 1
- 2020-11-28 1
- 2020-11-29 1
- 2020-11-30 1
- 2020-12-01 1
- 2020-12-02 1
- 2020-12-03 1
- 2020-12-04 1
- 2020-12-05 1
- 2020-12-06 1
- 2020-12-07 1
- 2020-12-08 1
- 2020-12-09 1
- 2020-12-10 1
- 2020-12-11 1
- 2020-12-12 1
- 2020-12-13 1
- 2020-12-14 1
- 2020-12-15 1
- 2020-12-16 1
- 2020-12-17 1
- 2020-12-18 1
- 2020-12-19 1
- 2020-12-20 1
- 2020-12-21 1
- 2020-12-22 1
- 2020-12-23 1
- 2020-12-24 1
- 2020-12-25 1
- 2020-12-26 1
- 2020-12-27 1
- 2020-12-28 1
- 2020-12-29 1
- 2020-12-30 1
- 2020-12-31 1
- 2021-01-01 1
- 2021-01-02 1
- 2021-01-03 1
- 2021-01-04 1
- 2021-01-05 1
- 2021-01-06 1
- 2021-01-07 1
- 2021-01-08 1
- 2021-01-09 1
- 2021-01-10 1
- 2021-01-11 1
- 2021-01-12 1
- 2021-01-13 1
- 2021-01-14 1
- 2021-01-15 1
- 2021-01-16 1
- 2021-01-17 1
- 2021-01-18 1
- 2021-01-19 1
- 2021-01-20 1
- 2021-01-21 1
- 2021-01-22 1
- 2021-01-23 1
- 2021-01-24 1
- 2021-01-25 1
- 2021-01-26 1
- 2021-01-27 1
- 2021-01-28 1
- 2021-01-29 1
- 2021-01-30 1
- 2021-01-31 1
- 2021-02-01 1
- 2021-02-02 1
- 2021-02-03 1
- 2021-02-04 1
- 2021-02-05 1
- 2021-02-06 1
- 2021-02-07 1
- 2021-02-08 1
- 2021-02-09 1
- 2021-02-10 1
- 2021-02-11 1
- 2021-02-12 1
- 2021-02-13 1
- 2021-02-14 1
- 2021-02-15 1
- 2021-02-16 1
- 2021-02-17 1
- 2021-02-18 1
- 2021-02-19 1
- 2021-02-20 1
- 2021-02-21 1
- 2021-02-22 1
- 2021-02-23 1
- 2021-02-24 1
- 2021-02-25 1
- 2021-02-26 1
- 2021-02-27 1
- 2021-02-28 1
- 2021-03-01 1
- 2021-03-02 1
- 2021-03-03 1
- 2021-03-04 1
- 2021-03-05 1
- 2021-03-06 1
- 2021-03-07 1
- 2021-03-08 1
- 2021-03-09 1
- 2021-03-10 1
- 2021-03-11 1
- 2021-03-12 1
- 2021-03-13 1
- 2021-03-14 1
- 2021-03-15 1
- 2021-03-16 1
- 2021-03-17 1
- 2021-03-18 1
- 2021-03-19 1
- 2021-03-20 1
- 2021-03-21 1
- 2021-03-22 1
- 2021-03-23 1
- 2021-03-24 1
- 2021-03-25 1
- 2021-03-26 1
- 2021-03-27 1
- 2021-03-28 1
- 2021-03-29 1
- 2021-03-30 1
- 2021-03-31 1
- 2021-04-01 1
- 2021-04-02 1
- 2021-04-03 1
- 2021-04-04 1
- 2021-04-05 1
- 2021-04-06 1
- 2021-04-07 1
- 2021-04-08 1
- 2021-04-09 1
- 2021-04-10 1
- 2021-04-11 1
- 2021-04-12 1
- 2021-04-13 1
- 2021-04-14 1
- 2021-04-15 1
- 2021-04-16 1
- 2021-04-17 1
- 2021-04-18 1
- 2021-04-19 1
- 2021-04-20 1
- 2021-04-21 1
- 2021-04-22 1
- 2021-04-23 1
- 2021-04-24 1
- 2021-04-25 1
- 2021-04-26 1
- 2021-04-27 1
- 2021-04-28 1
- 2021-04-29 1
- 2021-04-30 1
- 2021-05-01 1
- 2021-05-02 1
- 2021-05-03 1
- 2021-05-04 1
- 2021-05-05 1
- 2021-05-06 1
- 2021-05-07 1
- 2021-05-08 1
- 2021-05-09 1
- 2021-05-10 1
- 2021-05-11 1
- 2021-05-12 1
- 2021-05-13 1
- 2021-05-14 1
- 2021-05-15 1
- 2021-05-16 1
- 2021-05-17 1
- 2021-05-18 1
- 2021-05-19 1
- 2021-05-20 1
- 2021-05-21 1
- 2021-05-22 1
- 2021-05-23 1
- 2021-05-24 1
- 2021-05-25 1
- 2021-05-26 1
- 2021-05-27 1
- 2021-05-28 1
- 2021-05-29 1
- 2021-05-30 1
- 2021-05-31 1
- 2021-06-01 1
- 2021-06-02 1
- 2021-06-03 1
- 2021-06-04 1
- 2021-06-05 1
- 2021-06-06 1
- 2021-06-07 1
- 2021-06-08 1
- 2021-06-09 1
- 2021-06-10 1
- 2021-06-11 1
- 2021-06-12 1
- 2021-06-13 1
- 2021-06-14 1
- 2021-06-15 1
- 2021-06-16 1
- 2021-06-17 1
- 2021-06-18 1
- 2021-06-19 1
- 2021-06-20 1
- 2021-06-21 1
- 2021-06-22 1
- 2021-06-23 1
- 2021-06-24 1
- 2021-06-25 1
- 2021-06-26 1
- 2021-06-27 1
- 2021-06-28 1
- 2021-06-29 1
- 2021-06-30 1
- 2021-07-01 1
- 2021-07-02 1
- 2021-07-03 1
- 2021-07-04 1
- 2021-07-05 1
- 2021-07-06 1
- 2021-07-07 1
- 2021-07-08 1
- 2021-07-09 1
- 2021-07-10 1
- 2021-07-11 1
- 2021-07-12 1
- 2021-07-13 1
- 2021-07-14 1
- 2021-07-15 1
- 2021-07-16 1
- 2021-07-17 1
- 2021-07-18 1
- 2021-07-19 1
- 2021-07-20 1
- 2021-07-21 1
- 2021-07-22 1
- 2021-07-23 1
- 2021-07-24 1
- 2021-07-25 1
- 2021-07-26 1
- 2021-07-27 1
- 2021-07-28 1
- 2021-07-29 1
- 2021-07-30 1
- 2021-07-31 1
- 2021-08-01 1
- 2021-08-02 1
- 2021-08-03 1
- 2021-08-04 1
- 2021-08-05 1
- 2021-08-06 1
- 2021-08-07 1
- 2021-08-08 1
- 2021-08-09 1
- 2021-08-10 1
- 2021-08-11 1
- 2021-08-12 1
- 2021-08-13 1
- 2021-08-14 1
- 2021-08-15 1
- 2021-08-16 1
- 2021-08-17 1
- 2021-08-18 1
- 2021-08-19 1
- 2021-08-20 1
- 2021-08-21 1
- 2021-08-22 1
- 2021-08-23 1
- 2021-08-24 1
- 2021-08-25 1
- 2021-08-26 1
- 2021-08-27 1
- 2021-08-28 1
- 2021-08-29 1
- 2021-08-30 1
- 2021-08-31 1
- 2021-09-01 1
- 2021-09-02 1
- 2021-09-03 1
- 2021-09-04 1
- 2021-09-05 1
- 2021-09-06 1
- 2021-09-07 1
- 2021-09-08 1
- 2021-09-09 1
- 2021-09-10 1
- 2021-09-11 1
- 2021-09-12 1
- 2021-09-13 1
- 2021-09-14 1
- 2021-09-15 1
- 2021-09-16 1
- 2021-09-17 1
- 2021-09-18 1
- 2021-09-19 1
- 2021-09-20 1
- 2021-09-21 1
- 2021-09-22 1
- 2021-09-23 1
- 2021-09-24 1
- 2021-09-25 1
- 2021-09-26 1
- 2021-09-27 1
- 2021-09-28 1
- 2021-09-29 1
- 2021-09-30 1
- 2021-10-01 1
- 2021-10-02 1
- 2021-10-03 1
- 2021-10-04 1
- 2021-10-05 1
- 2021-10-06 1
- 2021-10-07 1
- 2021-10-08 1
- 2021-10-09 1
- 2021-10-10 1
- 2021-10-11 1
- 2021-10-12 1
- 2021-10-13 1
- 2021-10-14 1
- 2021-10-15 1
- 2021-10-16 1
- 2021-10-17 1
- 2021-10-18 1
- 2021-10-19 1
- 2021-10-20 1
- 2021-10-21 1
- 2021-10-22 1
- 2021-10-23 1
- 2021-10-24 1
- 2021-10-25 1
- 2021-10-26 1
- 2021-10-27 1
- 2021-10-28 1
- 2021-10-29 1
- 2021-10-30 1
- 2021-10-31 1
- 2021-11-01 1
- 2021-11-02 1
- 2021-11-03 1
- 2021-11-04 1
- 2021-11-05 1
- 2021-11-06 1
- 2021-11-07 1
- 2021-11-08 1
- 2021-11-09 1
- 2021-11-10 1
- 2021-11-11 1
- 2021-11-12 1
- 2021-11-13 1
- 2021-11-14 1
- 2021-11-15 1
- 2021-11-16 1
- 2021-11-17 1
- 2021-11-18 1
- 2021-11-19 1
- 2021-11-20 1
- 2021-11-21 1
- 2021-11-22 1
- 2021-11-23 1
- 2021-11-24 1
- 2021-11-25 1
- 2021-11-26 1
- 2021-11-27 1
- 2021-11-28 1
- 2021-11-29 1
- 2021-11-30 1
- 2021-12-01 1
- 2021-12-02 1
- 2021-12-03 1
- 2021-12-04 1
- 2021-12-05 1
- 2021-12-06 1
- 2021-12-07 1
- 2021-12-08 1
- 2021-12-09 1
- 2021-12-10 1
- 2021-12-11 1
- 2021-12-12 1
- 2021-12-13 1
- 2021-12-14 1
- 2021-12-15 1
- 2021-12-16 1
- 2021-12-17 1
- 2021-12-18 1
- 2021-12-19 1
- 2021-12-20 1
- 2021-12-21 1
- 2021-12-22 1
- 2021-12-23 1
- 2021-12-24 1
- 2021-12-25 1
- 2021-12-26 1
- 2021-12-27 1
- 2021-12-28 1
- 2021-12-29 1
- 2021-12-30 1
- 2021-12-31 1
- 2022-01-01 1
- 2022-01-02 1
- 2022-01-03 1
- 2022-01-04 1
- 2022-01-05 1
- 2022-01-06 1
- 2022-01-07 1
- 2022-01-08 1
- 2022-01-09 1
- 2022-01-10 1
- 2022-01-11 1
- 2022-01-12 1
- 2022-01-13 1
- 2022-01-14 1
- 2022-01-15 1
- 2022-01-16 1
- 2022-01-17 1
- 2022-01-18 1
- 2022-01-19 1
- 2022-01-20 1
- 2022-01-21 1
- 2022-01-22 1
- 2022-01-23 1
- 2022-01-24 1
- 2022-01-25 1
- 2022-01-26 1
- 2022-01-27 1
- 2022-01-28 1
- 2022-01-29 1
- 2022-01-30 1
- 2022-01-31 1
- 2022-02-01 1
- 2022-02-02 1
- 2022-02-03 1
- 2022-02-04 1
- 2022-02-05 1
- 2022-02-06 1
- 2022-02-07 1
- 2022-02-08 1
- 2022-02-09 1
- 2022-02-10 1
- 2022-02-11 1
- 2022-02-12 1
- 2022-02-13 1
- 2022-02-14 1
- 2022-02-15 1
- 2022-02-16 1
- 2022-02-17 1
- 2022-02-18 1
- 2022-02-19 1
- 2022-02-20 1
- 2022-02-21 1
- 2022-02-22 1
- 2022-02-23 1
- 2022-02-24 1
- 2022-02-25 1
- 2022-02-26 1
- 2022-02-27 1
- 2022-02-28 1
- 2022-03-01 1
- 2022-03-02 1
- 2022-03-03 1
- 2022-03-04 1
- 2022-03-05 1
- 2022-03-06 1
- 2022-03-07 1
- 2022-03-08 1
- 2022-03-09 1
- 2022-03-10 1
- 2022-03-11 1
- 2022-03-12 1
- 2022-03-13 1
- 2022-03-14 1
- 2022-03-15 1
- 2022-03-16 1
- 2022-03-17 1
- 2022-03-18 1
- 2022-03-19 1
- 2022-03-20 1
- 2022-03-21 1
- 2022-03-22 1
- 2022-03-23 1
- 2022-03-24 1
- 2022-03-25 1
- 2022-03-26 1
- 2022-03-27 1
- 2022-03-28 1
- 2022-03-29 1
- 2022-03-30 1
- 2022-03-31 1
- 2022-04-01 1
- 2022-04-02 1
- 2022-04-03 1
- 2022-04-04 1
- 2022-04-05 1
- 2022-04-06 1
- 2022-04-07 1
- 2022-04-08 1
- 2022-04-09 1
- 2022-04-10 1
- 2022-04-11 1
- 2022-04-12 1
- 2022-04-13 1
- 2022-04-14 1
- 2022-04-15 1
- 2022-04-16 1
- 2022-04-17 1
- 2022-04-18 1
- 2022-04-19 1
- 2022-04-20 1
- 2022-04-21 1
- 2022-04-22 1
- 2022-04-23 1
- 2022-04-24 1
- 2022-04-25 1
- 2022-04-26 1
- 2022-04-27 1
- 2022-04-28 1
- 2022-04-29 1
- 2022-04-30 1
- 2022-05-01 1
- 2022-05-02 1
- 2022-05-03 1
- 2022-05-04 1
- 2022-05-05 1
- 2022-05-06 1
- 2022-05-07 1
- 2022-05-08 1
- 2022-05-09 1
- 2022-05-10 1
- 2022-05-11 1
- 2022-05-12 1
- 2022-05-13 1
state 1
- Pennsylvania 781
fips 1
- 42111 · 781 ✖
county 1
- Somerset · 781 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501902 | 2501902 | 2022-05-13 | Somerset | Pennsylvania | 42111 | 18829 | 408 |
2498644 | 2498644 | 2022-05-12 | Somerset | Pennsylvania | 42111 | 18829 | 408 |
2495386 | 2495386 | 2022-05-11 | Somerset | Pennsylvania | 42111 | 18829 | 408 |
2492128 | 2492128 | 2022-05-10 | Somerset | Pennsylvania | 42111 | 18793 | 408 |
2488870 | 2488870 | 2022-05-09 | Somerset | Pennsylvania | 42111 | 18793 | 408 |
2485613 | 2485613 | 2022-05-08 | Somerset | Pennsylvania | 42111 | 18793 | 408 |
2482355 | 2482355 | 2022-05-07 | Somerset | Pennsylvania | 42111 | 18793 | 408 |
2479097 | 2479097 | 2022-05-06 | Somerset | Pennsylvania | 42111 | 18793 | 408 |
2475839 | 2475839 | 2022-05-05 | Somerset | Pennsylvania | 42111 | 18793 | 408 |
2472582 | 2472582 | 2022-05-04 | Somerset | Pennsylvania | 42111 | 18793 | 408 |
2469326 | 2469326 | 2022-05-03 | Somerset | Pennsylvania | 42111 | 18788 | 408 |
2466070 | 2466070 | 2022-05-02 | Somerset | Pennsylvania | 42111 | 18786 | 407 |
2462815 | 2462815 | 2022-05-01 | Somerset | Pennsylvania | 42111 | 18782 | 407 |
2459559 | 2459559 | 2022-04-30 | Somerset | Pennsylvania | 42111 | 18775 | 407 |
2456303 | 2456303 | 2022-04-29 | Somerset | Pennsylvania | 42111 | 18771 | 407 |
2453047 | 2453047 | 2022-04-28 | Somerset | Pennsylvania | 42111 | 18764 | 407 |
2449791 | 2449791 | 2022-04-27 | Somerset | Pennsylvania | 42111 | 18761 | 406 |
2446534 | 2446534 | 2022-04-26 | Somerset | Pennsylvania | 42111 | 18759 | 406 |
2443279 | 2443279 | 2022-04-25 | Somerset | Pennsylvania | 42111 | 18755 | 406 |
2440023 | 2440023 | 2022-04-24 | Somerset | Pennsylvania | 42111 | 18754 | 406 |
2436767 | 2436767 | 2022-04-23 | Somerset | Pennsylvania | 42111 | 18753 | 406 |
2433511 | 2433511 | 2022-04-22 | Somerset | Pennsylvania | 42111 | 18750 | 406 |
2430255 | 2430255 | 2022-04-21 | Somerset | Pennsylvania | 42111 | 18743 | 405 |
2426999 | 2426999 | 2022-04-20 | Somerset | Pennsylvania | 42111 | 18735 | 405 |
2423743 | 2423743 | 2022-04-19 | Somerset | Pennsylvania | 42111 | 18729 | 405 |
2420487 | 2420487 | 2022-04-18 | Somerset | Pennsylvania | 42111 | 18723 | 405 |
2417231 | 2417231 | 2022-04-17 | Somerset | Pennsylvania | 42111 | 18722 | 405 |
2413975 | 2413975 | 2022-04-16 | Somerset | Pennsylvania | 42111 | 18721 | 405 |
2410719 | 2410719 | 2022-04-15 | Somerset | Pennsylvania | 42111 | 18716 | 405 |
2407463 | 2407463 | 2022-04-14 | Somerset | Pennsylvania | 42111 | 18715 | 405 |
2404207 | 2404207 | 2022-04-13 | Somerset | Pennsylvania | 42111 | 18714 | 405 |
2400952 | 2400952 | 2022-04-12 | Somerset | Pennsylvania | 42111 | 18712 | 405 |
2397697 | 2397697 | 2022-04-11 | Somerset | Pennsylvania | 42111 | 18711 | 404 |
2394442 | 2394442 | 2022-04-10 | Somerset | Pennsylvania | 42111 | 18710 | 404 |
2391186 | 2391186 | 2022-04-09 | Somerset | Pennsylvania | 42111 | 18707 | 404 |
2387930 | 2387930 | 2022-04-08 | Somerset | Pennsylvania | 42111 | 18703 | 404 |
2384675 | 2384675 | 2022-04-07 | Somerset | Pennsylvania | 42111 | 18700 | 404 |
2381420 | 2381420 | 2022-04-06 | Somerset | Pennsylvania | 42111 | 18698 | 404 |
2378165 | 2378165 | 2022-04-05 | Somerset | Pennsylvania | 42111 | 18698 | 403 |
2374911 | 2374911 | 2022-04-04 | Somerset | Pennsylvania | 42111 | 18692 | 402 |
2371659 | 2371659 | 2022-04-03 | Somerset | Pennsylvania | 42111 | 18690 | 402 |
2368406 | 2368406 | 2022-04-02 | Somerset | Pennsylvania | 42111 | 18690 | 402 |
2365153 | 2365153 | 2022-04-01 | Somerset | Pennsylvania | 42111 | 18686 | 401 |
2361900 | 2361900 | 2022-03-31 | Somerset | Pennsylvania | 42111 | 18684 | 401 |
2358646 | 2358646 | 2022-03-30 | Somerset | Pennsylvania | 42111 | 18681 | 401 |
2355392 | 2355392 | 2022-03-29 | Somerset | Pennsylvania | 42111 | 18675 | 401 |
2352139 | 2352139 | 2022-03-28 | Somerset | Pennsylvania | 42111 | 18668 | 400 |
2348887 | 2348887 | 2022-03-27 | Somerset | Pennsylvania | 42111 | 18667 | 400 |
2345634 | 2345634 | 2022-03-26 | Somerset | Pennsylvania | 42111 | 18662 | 400 |
2342381 | 2342381 | 2022-03-25 | Somerset | Pennsylvania | 42111 | 18661 | 399 |
2339128 | 2339128 | 2022-03-24 | Somerset | Pennsylvania | 42111 | 18660 | 399 |
2335874 | 2335874 | 2022-03-23 | Somerset | Pennsylvania | 42111 | 18659 | 399 |
2332620 | 2332620 | 2022-03-22 | Somerset | Pennsylvania | 42111 | 18659 | 399 |
2329367 | 2329367 | 2022-03-21 | Somerset | Pennsylvania | 42111 | 18658 | 398 |
2326115 | 2326115 | 2022-03-20 | Somerset | Pennsylvania | 42111 | 18657 | 398 |
2322862 | 2322862 | 2022-03-19 | Somerset | Pennsylvania | 42111 | 18657 | 398 |
2319608 | 2319608 | 2022-03-18 | Somerset | Pennsylvania | 42111 | 18655 | 398 |
2316354 | 2316354 | 2022-03-17 | Somerset | Pennsylvania | 42111 | 18654 | 398 |
2313101 | 2313101 | 2022-03-16 | Somerset | Pennsylvania | 42111 | 18650 | 398 |
2309848 | 2309848 | 2022-03-15 | Somerset | Pennsylvania | 42111 | 18645 | 397 |
2306595 | 2306595 | 2022-03-14 | Somerset | Pennsylvania | 42111 | 18640 | 396 |
2303344 | 2303344 | 2022-03-13 | Somerset | Pennsylvania | 42111 | 18640 | 396 |
2300092 | 2300092 | 2022-03-12 | Somerset | Pennsylvania | 42111 | 18638 | 396 |
2296840 | 2296840 | 2022-03-11 | Somerset | Pennsylvania | 42111 | 18634 | 396 |
2293588 | 2293588 | 2022-03-10 | Somerset | Pennsylvania | 42111 | 18629 | 396 |
2290336 | 2290336 | 2022-03-09 | Somerset | Pennsylvania | 42111 | 18629 | 396 |
2287084 | 2287084 | 2022-03-08 | Somerset | Pennsylvania | 42111 | 18625 | 396 |
2283832 | 2283832 | 2022-03-07 | Somerset | Pennsylvania | 42111 | 18621 | 396 |
2280580 | 2280580 | 2022-03-06 | Somerset | Pennsylvania | 42111 | 18618 | 396 |
2277327 | 2277327 | 2022-03-05 | Somerset | Pennsylvania | 42111 | 18615 | 396 |
2274074 | 2274074 | 2022-03-04 | Somerset | Pennsylvania | 42111 | 18616 | 396 |
2270821 | 2270821 | 2022-03-03 | Somerset | Pennsylvania | 42111 | 18609 | 396 |
2267569 | 2267569 | 2022-03-02 | Somerset | Pennsylvania | 42111 | 18600 | 396 |
2264316 | 2264316 | 2022-03-01 | Somerset | Pennsylvania | 42111 | 18588 | 396 |
2261066 | 2261066 | 2022-02-28 | Somerset | Pennsylvania | 42111 | 18587 | 394 |
2257815 | 2257815 | 2022-02-27 | Somerset | Pennsylvania | 42111 | 18579 | 394 |
2254564 | 2254564 | 2022-02-26 | Somerset | Pennsylvania | 42111 | 18570 | 394 |
2251313 | 2251313 | 2022-02-25 | Somerset | Pennsylvania | 42111 | 18541 | 394 |
2248062 | 2248062 | 2022-02-24 | Somerset | Pennsylvania | 42111 | 18528 | 394 |
2244811 | 2244811 | 2022-02-23 | Somerset | Pennsylvania | 42111 | 18517 | 394 |
2241560 | 2241560 | 2022-02-22 | Somerset | Pennsylvania | 42111 | 18500 | 391 |
2238309 | 2238309 | 2022-02-21 | Somerset | Pennsylvania | 42111 | 18474 | 391 |
2235058 | 2235058 | 2022-02-20 | Somerset | Pennsylvania | 42111 | 18474 | 391 |
2231807 | 2231807 | 2022-02-19 | Somerset | Pennsylvania | 42111 | 18468 | 391 |
2228556 | 2228556 | 2022-02-18 | Somerset | Pennsylvania | 42111 | 18439 | 391 |
2225305 | 2225305 | 2022-02-17 | Somerset | Pennsylvania | 42111 | 18412 | 390 |
2222054 | 2222054 | 2022-02-16 | Somerset | Pennsylvania | 42111 | 18398 | 389 |
2218803 | 2218803 | 2022-02-15 | Somerset | Pennsylvania | 42111 | 18379 | 387 |
2215552 | 2215552 | 2022-02-14 | Somerset | Pennsylvania | 42111 | 18352 | 387 |
2212301 | 2212301 | 2022-02-13 | Somerset | Pennsylvania | 42111 | 18335 | 387 |
2209048 | 2209048 | 2022-02-12 | Somerset | Pennsylvania | 42111 | 18325 | 387 |
2205795 | 2205795 | 2022-02-11 | Somerset | Pennsylvania | 42111 | 18299 | 386 |
2202542 | 2202542 | 2022-02-10 | Somerset | Pennsylvania | 42111 | 18273 | 385 |
2199288 | 2199288 | 2022-02-09 | Somerset | Pennsylvania | 42111 | 18208 | 385 |
2196034 | 2196034 | 2022-02-08 | Somerset | Pennsylvania | 42111 | 18169 | 385 |
2192780 | 2192780 | 2022-02-07 | Somerset | Pennsylvania | 42111 | 18208 | 381 |
2189526 | 2189526 | 2022-02-06 | Somerset | Pennsylvania | 42111 | 18140 | 381 |
2186273 | 2186273 | 2022-02-05 | Somerset | Pennsylvania | 42111 | 18109 | 380 |
2183021 | 2183021 | 2022-02-04 | Somerset | Pennsylvania | 42111 | 18013 | 379 |
2179769 | 2179769 | 2022-02-03 | Somerset | Pennsylvania | 42111 | 17951 | 378 |
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);