ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
7,769 rows where county = "Pike" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) 793 ✖
- 2020-04-12 10
- 2020-04-13 10
- 2020-04-14 10
- 2020-04-15 10
- 2020-04-16 10
- 2020-04-17 10
- 2020-04-18 10
- 2020-04-19 10
- 2020-04-20 10
- 2020-04-21 10
- 2020-04-22 10
- 2020-04-23 10
- 2020-04-24 10
- 2020-04-25 10
- 2020-04-26 10
- 2020-04-27 10
- 2020-04-28 10
- 2020-04-29 10
- 2020-04-30 10
- 2020-05-01 10
- 2020-05-02 10
- 2020-05-03 10
- 2020-05-04 10
- 2020-05-05 10
- 2020-05-06 10
- 2020-05-07 10
- 2020-05-08 10
- 2020-05-09 10
- 2020-05-10 10
- 2020-05-11 10
- 2020-05-12 10
- 2020-05-13 10
- 2020-05-14 10
- 2020-05-15 10
- 2020-05-16 10
- 2020-05-17 10
- 2020-05-18 10
- 2020-05-19 10
- 2020-05-20 10
- 2020-05-21 10
- 2020-05-22 10
- 2020-05-23 10
- 2020-05-24 10
- 2020-05-25 10
- 2020-05-26 10
- 2020-05-27 10
- 2020-05-28 10
- 2020-05-29 10
- 2020-05-30 10
- 2020-05-31 10
- 2020-06-01 10
- 2020-06-02 10
- 2020-06-03 10
- 2020-06-04 10
- 2020-06-05 10
- 2020-06-06 10
- 2020-06-07 10
- 2020-06-08 10
- 2020-06-09 10
- 2020-06-10 10
- 2020-06-11 10
- 2020-06-12 10
- 2020-06-13 10
- 2020-06-14 10
- 2020-06-15 10
- 2020-06-16 10
- 2020-06-17 10
- 2020-06-18 10
- 2020-06-19 10
- 2020-06-20 10
- 2020-06-21 10
- 2020-06-22 10
- 2020-06-23 10
- 2020-06-24 10
- 2020-06-25 10
- 2020-06-26 10
- 2020-06-27 10
- 2020-06-28 10
- 2020-06-29 10
- 2020-06-30 10
- 2020-07-01 10
- 2020-07-02 10
- 2020-07-03 10
- 2020-07-04 10
- 2020-07-05 10
- 2020-07-06 10
- 2020-07-07 10
- 2020-07-08 10
- 2020-07-09 10
- 2020-07-10 10
- 2020-07-11 10
- 2020-07-12 10
- 2020-07-13 10
- 2020-07-14 10
- 2020-07-15 10
- 2020-07-16 10
- 2020-07-17 10
- 2020-07-18 10
- 2020-07-19 10
- 2020-07-20 10
- 2020-07-21 10
- 2020-07-22 10
- 2020-07-23 10
- 2020-07-24 10
- 2020-07-25 10
- 2020-07-26 10
- 2020-07-27 10
- 2020-07-28 10
- 2020-07-29 10
- 2020-07-30 10
- 2020-07-31 10
- 2020-08-01 10
- 2020-08-02 10
- 2020-08-03 10
- 2020-08-04 10
- 2020-08-05 10
- 2020-08-06 10
- 2020-08-07 10
- 2020-08-08 10
- 2020-08-09 10
- 2020-08-10 10
- 2020-08-11 10
- 2020-08-12 10
- 2020-08-13 10
- 2020-08-14 10
- 2020-08-15 10
- 2020-08-16 10
- 2020-08-17 10
- 2020-08-18 10
- 2020-08-19 10
- 2020-08-20 10
- 2020-08-21 10
- 2020-08-22 10
- 2020-08-23 10
- 2020-08-24 10
- 2020-08-25 10
- 2020-08-26 10
- 2020-08-27 10
- 2020-08-28 10
- 2020-08-29 10
- 2020-08-30 10
- 2020-08-31 10
- 2020-09-01 10
- 2020-09-02 10
- 2020-09-03 10
- 2020-09-04 10
- 2020-09-05 10
- 2020-09-06 10
- 2020-09-07 10
- 2020-09-08 10
- 2020-09-09 10
- 2020-09-10 10
- 2020-09-11 10
- 2020-09-12 10
- 2020-09-13 10
- 2020-09-14 10
- 2020-09-15 10
- 2020-09-16 10
- 2020-09-17 10
- 2020-09-18 10
- 2020-09-19 10
- 2020-09-20 10
- 2020-09-21 10
- 2020-09-22 10
- 2020-09-23 10
- 2020-09-24 10
- 2020-09-25 10
- 2020-09-26 10
- 2020-09-27 10
- 2020-09-28 10
- 2020-09-29 10
- 2020-09-30 10
- 2020-10-01 10
- 2020-10-02 10
- 2020-10-03 10
- 2020-10-04 10
- 2020-10-05 10
- 2020-10-06 10
- 2020-10-07 10
- 2020-10-08 10
- 2020-10-09 10
- 2020-10-10 10
- 2020-10-11 10
- 2020-10-12 10
- 2020-10-13 10
- 2020-10-14 10
- 2020-10-15 10
- 2020-10-16 10
- 2020-10-17 10
- 2020-10-18 10
- 2020-10-19 10
- 2020-10-20 10
- 2020-10-21 10
- 2020-10-22 10
- 2020-10-23 10
- 2020-10-24 10
- 2020-10-25 10
- 2020-10-26 10
- 2020-10-27 10
- 2020-10-28 10
- 2020-10-29 10
- 2020-10-30 10
- 2020-10-31 10
- 2020-11-01 10
- 2020-11-02 10
- 2020-11-03 10
- 2020-11-04 10
- 2020-11-05 10
- 2020-11-06 10
- 2020-11-07 10
- 2020-11-08 10
- 2020-11-09 10
- 2020-11-10 10
- 2020-11-11 10
- 2020-11-12 10
- 2020-11-13 10
- 2020-11-14 10
- 2020-11-15 10
- 2020-11-16 10
- 2020-11-17 10
- 2020-11-18 10
- 2020-11-19 10
- 2020-11-20 10
- 2020-11-21 10
- 2020-11-22 10
- 2020-11-23 10
- 2020-11-24 10
- 2020-11-25 10
- 2020-11-26 10
- 2020-11-27 10
- 2020-11-28 10
- 2020-11-29 10
- 2020-11-30 10
- 2020-12-01 10
- 2020-12-02 10
- 2020-12-03 10
- 2020-12-04 10
- 2020-12-05 10
- 2020-12-06 10
- 2020-12-07 10
- 2020-12-08 10
- 2020-12-09 10
- 2020-12-10 10
- 2020-12-11 10
- 2020-12-12 10
- 2020-12-13 10
- 2020-12-14 10
- 2020-12-15 10
- 2020-12-16 10
- 2020-12-17 10
- 2020-12-18 10
- 2020-12-19 10
- 2020-12-20 10
- 2020-12-21 10
- 2020-12-22 10
- 2020-12-23 10
- 2020-12-24 10
- 2020-12-25 10
- 2020-12-26 10
- 2020-12-27 10
- 2020-12-28 10
- 2020-12-29 10
- 2020-12-30 10
- 2020-12-31 10
- 2021-01-01 10
- 2021-01-02 10
- 2021-01-03 10
- 2021-01-04 10
- 2021-01-05 10
- 2021-01-06 10
- 2021-01-07 10
- 2021-01-08 10
- 2021-01-09 10
- 2021-01-10 10
- 2021-01-11 10
- 2021-01-12 10
- 2021-01-13 10
- 2021-01-14 10
- 2021-01-15 10
- 2021-01-16 10
- 2021-01-17 10
- 2021-01-18 10
- 2021-01-19 10
- 2021-01-20 10
- 2021-01-21 10
- 2021-01-22 10
- 2021-01-23 10
- 2021-01-24 10
- 2021-01-25 10
- 2021-01-26 10
- 2021-01-27 10
- 2021-01-28 10
- 2021-01-29 10
- 2021-01-30 10
- 2021-01-31 10
- 2021-02-01 10
- 2021-02-02 10
- 2021-02-03 10
- 2021-02-04 10
- 2021-02-05 10
- 2021-02-06 10
- 2021-02-07 10
- 2021-02-08 10
- 2021-02-09 10
- 2021-02-10 10
- 2021-02-11 10
- 2021-02-12 10
- 2021-02-13 10
- 2021-02-14 10
- 2021-02-15 10
- 2021-02-16 10
- 2021-02-17 10
- 2021-02-18 10
- 2021-02-19 10
- 2021-02-20 10
- 2021-02-21 10
- 2021-02-22 10
- 2021-02-23 10
- 2021-02-24 10
- 2021-02-25 10
- 2021-02-26 10
- 2021-02-27 10
- 2021-02-28 10
- 2021-03-01 10
- 2021-03-02 10
- 2021-03-03 10
- 2021-03-04 10
- 2021-03-05 10
- 2021-03-06 10
- 2021-03-07 10
- 2021-03-08 10
- 2021-03-09 10
- 2021-03-10 10
- 2021-03-11 10
- 2021-03-12 10
- 2021-03-13 10
- 2021-03-14 10
- 2021-03-15 10
- 2021-03-16 10
- 2021-03-17 10
- 2021-03-18 10
- 2021-03-19 10
- 2021-03-20 10
- 2021-03-21 10
- 2021-03-22 10
- 2021-03-23 10
- 2021-03-24 10
- 2021-03-25 10
- 2021-03-26 10
- 2021-03-27 10
- 2021-03-28 10
- 2021-03-29 10
- 2021-03-30 10
- 2021-03-31 10
- 2021-04-01 10
- 2021-04-02 10
- 2021-04-03 10
- 2021-04-04 10
- 2021-04-05 10
- 2021-04-06 10
- 2021-04-07 10
- 2021-04-08 10
- 2021-04-09 10
- 2021-04-10 10
- 2021-04-11 10
- 2021-04-12 10
- 2021-04-13 10
- 2021-04-14 10
- 2021-04-15 10
- 2021-04-16 10
- 2021-04-17 10
- 2021-04-18 10
- 2021-04-19 10
- 2021-04-20 10
- 2021-04-21 10
- 2021-04-22 10
- 2021-04-23 10
- 2021-04-24 10
- 2021-04-25 10
- 2021-04-26 10
- 2021-04-27 10
- 2021-04-28 10
- 2021-04-29 10
- 2021-04-30 10
- 2021-05-01 10
- 2021-05-02 10
- 2021-05-03 10
- 2021-05-04 10
- 2021-05-05 10
- 2021-05-06 10
- 2021-05-07 10
- 2021-05-08 10
- 2021-05-09 10
- 2021-05-10 10
- 2021-05-11 10
- 2021-05-12 10
- 2021-05-13 10
- 2021-05-14 10
- 2021-05-15 10
- 2021-05-16 10
- 2021-05-17 10
- 2021-05-18 10
- 2021-05-19 10
- 2021-05-20 10
- 2021-05-21 10
- 2021-05-22 10
- 2021-05-23 10
- 2021-05-24 10
- 2021-05-25 10
- 2021-05-26 10
- 2021-05-27 10
- 2021-05-28 10
- 2021-05-29 10
- 2021-05-30 10
- 2021-05-31 10
- 2021-06-01 10
- 2021-06-02 10
- 2021-06-03 10
- 2021-06-04 10
- 2021-06-05 10
- 2021-06-06 10
- 2021-06-07 10
- 2021-06-08 10
- 2021-06-09 10
- 2021-06-10 10
- 2021-06-11 10
- 2021-06-12 10
- 2021-06-13 10
- 2021-06-14 10
- 2021-06-15 10
- 2021-06-16 10
- 2021-06-17 10
- 2021-06-18 10
- 2021-06-19 10
- 2021-06-20 10
- 2021-06-21 10
- 2021-06-22 10
- 2021-06-23 10
- 2021-06-24 10
- 2021-06-25 10
- 2021-06-26 10
- 2021-06-27 10
- 2021-06-28 10
- 2021-06-29 10
- 2021-06-30 10
- 2021-07-01 10
- 2021-07-02 10
- 2021-07-03 10
- 2021-07-04 10
- 2021-07-05 10
- 2021-07-06 10
- 2021-07-07 10
- 2021-07-08 10
- 2021-07-09 10
- 2021-07-10 10
- 2021-07-11 10
- 2021-07-12 10
- 2021-07-13 10
- 2021-07-14 10
- 2021-07-15 10
- 2021-07-16 10
- 2021-07-17 10
- 2021-07-18 10
- 2021-07-19 10
- 2021-07-20 10
- 2021-07-21 10
- 2021-07-22 10
- 2021-07-23 10
- 2021-07-24 10
- 2021-07-25 10
- 2021-07-26 10
- 2021-07-27 10
- 2021-07-28 10
- 2021-07-29 10
- 2021-07-30 10
- 2021-07-31 10
- 2021-08-01 10
- 2021-08-02 10
- 2021-08-03 10
- 2021-08-04 10
- 2021-08-05 10
- 2021-08-06 10
- 2021-08-07 10
- 2021-08-08 10
- 2021-08-09 10
- 2021-08-10 10
- 2021-08-11 10
- 2021-08-12 10
- 2021-08-13 10
- 2021-08-14 10
- 2021-08-15 10
- 2021-08-16 10
- 2021-08-17 10
- 2021-08-18 10
- 2021-08-19 10
- 2021-08-20 10
- 2021-08-21 10
- 2021-08-22 10
- 2021-08-23 10
- 2021-08-24 10
- 2021-08-25 10
- 2021-08-26 10
- 2021-08-27 10
- 2021-08-28 10
- 2021-08-29 10
- 2021-08-30 10
- 2021-08-31 10
- 2021-09-01 10
- 2021-09-02 10
- 2021-09-03 10
- 2021-09-04 10
- 2021-09-05 10
- 2021-09-06 10
- 2021-09-07 10
- 2021-09-08 10
- 2021-09-09 10
- 2021-09-10 10
- 2021-09-11 10
- 2021-09-12 10
- 2021-09-13 10
- 2021-09-14 10
- 2021-09-15 10
- 2021-09-16 10
- 2021-09-17 10
- 2021-09-18 10
- 2021-09-19 10
- 2021-09-20 10
- 2021-09-21 10
- 2021-09-22 10
- 2021-09-23 10
- 2021-09-24 10
- 2021-09-25 10
- 2021-09-26 10
- 2021-09-27 10
- 2021-09-28 10
- 2021-09-29 10
- 2021-09-30 10
- 2021-10-01 10
- 2021-10-02 10
- 2021-10-03 10
- 2021-10-04 10
- 2021-10-05 10
- 2021-10-06 10
- 2021-10-07 10
- 2021-10-08 10
- 2021-10-09 10
- 2021-10-10 10
- 2021-10-11 10
- 2021-10-12 10
- 2021-10-13 10
- 2021-10-14 10
- 2021-10-15 10
- 2021-10-16 10
- 2021-10-17 10
- 2021-10-18 10
- 2021-10-19 10
- 2021-10-20 10
- 2021-10-21 10
- 2021-10-22 10
- 2021-10-23 10
- 2021-10-24 10
- 2021-10-25 10
- 2021-10-26 10
- 2021-10-27 10
- 2021-10-28 10
- 2021-10-29 10
- 2021-10-30 10
- 2021-10-31 10
- 2021-11-01 10
- 2021-11-02 10
- 2021-11-03 10
- 2021-11-04 10
- 2021-11-05 10
- 2021-11-06 10
- 2021-11-07 10
- 2021-11-08 10
- 2021-11-09 10
- 2021-11-10 10
- 2021-11-11 10
- 2021-11-12 10
- 2021-11-13 10
- 2021-11-14 10
- 2021-11-15 10
- 2021-11-16 10
- 2021-11-17 10
- 2021-11-18 10
- 2021-11-19 10
- 2021-11-20 10
- 2021-11-21 10
- 2021-11-22 10
- 2021-11-23 10
- 2021-11-24 10
- 2021-11-25 10
- 2021-11-26 10
- 2021-11-27 10
- 2021-11-28 10
- 2021-11-29 10
- 2021-11-30 10
- 2021-12-01 10
- 2021-12-02 10
- 2021-12-03 10
- 2021-12-04 10
- 2021-12-05 10
- 2021-12-06 10
- 2021-12-07 10
- 2021-12-08 10
- 2021-12-09 10
- 2021-12-10 10
- 2021-12-11 10
- 2021-12-12 10
- 2021-12-13 10
- 2021-12-14 10
- 2021-12-15 10
- 2021-12-16 10
- 2021-12-17 10
- 2021-12-18 10
- 2021-12-19 10
- 2021-12-20 10
- 2021-12-21 10
- 2021-12-22 10
- 2021-12-23 10
- 2021-12-24 10
- 2021-12-25 10
- 2021-12-26 10
- 2021-12-27 10
- 2021-12-28 10
- 2021-12-29 10
- 2021-12-30 10
- 2021-12-31 10
- 2022-01-01 10
- 2022-01-02 10
- 2022-01-03 10
- 2022-01-04 10
- 2022-01-05 10
- 2022-01-06 10
- 2022-01-07 10
- 2022-01-08 10
- 2022-01-09 10
- 2022-01-10 10
- 2022-01-11 10
- 2022-01-12 10
- 2022-01-13 10
- 2022-01-14 10
- 2022-01-15 10
- 2022-01-16 10
- 2022-01-17 10
- 2022-01-18 10
- 2022-01-19 10
- 2022-01-20 10
- 2022-01-21 10
- 2022-01-22 10
- 2022-01-23 10
- 2022-01-24 10
- 2022-01-25 10
- 2022-01-26 10
- 2022-01-27 10
- 2022-01-28 10
- 2022-01-29 10
- 2022-01-30 10
- 2022-01-31 10
- 2022-02-01 10
- 2022-02-02 10
- 2022-02-03 10
- 2022-02-04 10
- 2022-02-05 10
- 2022-02-06 10
- 2022-02-07 10
- 2022-02-08 10
- 2022-02-09 10
- 2022-02-10 10
- 2022-02-11 10
- 2022-02-12 10
- 2022-02-13 10
- 2022-02-14 10
- 2022-02-15 10
- 2022-02-16 10
- 2022-02-17 10
- 2022-02-18 10
- 2022-02-19 10
- 2022-02-20 10
- 2022-02-21 10
- 2022-02-22 10
- 2022-02-23 10
- 2022-02-24 10
- 2022-02-25 10
- 2022-02-26 10
- 2022-02-27 10
- 2022-02-28 10
- 2022-03-01 10
- 2022-03-02 10
- 2022-03-03 10
- 2022-03-04 10
- 2022-03-05 10
- 2022-03-06 10
- 2022-03-07 10
- 2022-03-08 10
- 2022-03-09 10
- 2022-03-10 10
- 2022-03-11 10
- 2022-03-12 10
- 2022-03-13 10
- 2022-03-14 10
- 2022-03-15 10
- 2022-03-16 10
- 2022-03-17 10
- 2022-03-18 10
- 2022-03-19 10
- 2022-03-20 10
- 2022-03-21 10
- 2022-03-22 10
- 2022-03-23 10
- 2022-03-24 10
- 2022-03-25 10
- 2022-03-26 10
- 2022-03-27 10
- 2022-03-28 10
- 2022-03-29 10
- 2022-03-30 10
- 2022-03-31 10
- 2022-04-01 10
- 2022-04-02 10
- 2022-04-03 10
- 2022-04-04 10
- 2022-04-05 10
- 2022-04-06 10
- 2022-04-07 10
- 2022-04-08 10
- 2022-04-09 10
- 2022-04-10 10
- 2022-04-11 10
- 2022-04-12 10
- 2022-04-13 10
- 2022-04-14 10
- 2022-04-15 10
- 2022-04-16 10
- 2022-04-17 10
- 2022-04-18 10
- 2022-04-19 10
- 2022-04-20 10
- 2022-04-21 10
- 2022-04-22 10
- 2022-04-23 10
- 2022-04-24 10
- 2022-04-25 10
- 2022-04-26 10
- 2022-04-27 10
- 2022-04-28 10
- 2022-04-29 10
- 2022-04-30 10
- 2022-05-01 10
- 2022-05-02 10
- 2022-05-03 10
- 2022-05-04 10
- 2022-05-05 10
- 2022-05-06 10
- 2022-05-07 10
- 2022-05-08 10
- 2022-05-09 10
- 2022-05-10 10
- 2022-05-11 10
- 2022-05-12 10
- 2022-05-13 10
- 2020-04-05 9
- 2020-04-06 9
- 2020-04-07 9
- 2020-04-08 9
- 2020-04-09 9
- 2020-04-10 9
- 2020-04-11 9
- 2020-04-04 8
- 2020-03-30 7
- 2020-03-31 7
- 2020-04-01 7
- 2020-04-02 7
- 2020-04-03 7
- 2020-03-28 6
- 2020-03-29 6
- 2020-03-25 4
- 2020-03-26 4
- 2020-03-27 4
- 2020-03-24 3
- 2020-03-20 2
- 2020-03-21 2
- 2020-03-22 2
- 2020-03-23 2
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
state 10
- Pennsylvania 793
- Mississippi 785
- Arkansas 781
- Alabama 780
- Georgia 777
- Ohio 777
- Missouri 775
- Illinois 770
- Kentucky 769
- Indiana 762
fips 10
county 1
- Pike · 7,769 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1558 | 1558 | 2020-03-12 | Pike | Pennsylvania | 42103 | 1 | 0 |
1856 | 1856 | 2020-03-13 | Pike | Pennsylvania | 42103 | 1 | 0 |
2218 | 2218 | 2020-03-14 | Pike | Pennsylvania | 42103 | 1 | 0 |
2640 | 2640 | 2020-03-15 | Pike | Pennsylvania | 42103 | 1 | 0 |
3105 | 3105 | 2020-03-16 | Pike | Pennsylvania | 42103 | 1 | 0 |
3635 | 3635 | 2020-03-17 | Pike | Pennsylvania | 42103 | 1 | 0 |
4253 | 4253 | 2020-03-18 | Pike | Pennsylvania | 42103 | 2 | 0 |
4994 | 4994 | 2020-03-19 | Pike | Pennsylvania | 42103 | 3 | 0 |
5625 | 5625 | 2020-03-20 | Pike | Mississippi | 28113 | 1 | 0 |
5866 | 5866 | 2020-03-20 | Pike | Pennsylvania | 42103 | 3 | 0 |
6608 | 6608 | 2020-03-21 | Pike | Mississippi | 28113 | 2 | 0 |
6870 | 6870 | 2020-03-21 | Pike | Pennsylvania | 42103 | 3 | 0 |
7693 | 7693 | 2020-03-22 | Pike | Mississippi | 28113 | 3 | 0 |
7989 | 7989 | 2020-03-22 | Pike | Pennsylvania | 42103 | 3 | 0 |
8875 | 8875 | 2020-03-23 | Pike | Mississippi | 28113 | 4 | 0 |
9200 | 9200 | 2020-03-23 | Pike | Pennsylvania | 42103 | 3 | 0 |
9547 | 9547 | 2020-03-24 | Pike | Arkansas | 5109 | 1 | 0 |
10173 | 10173 | 2020-03-24 | Pike | Mississippi | 28113 | 7 | 0 |
10524 | 10524 | 2020-03-24 | Pike | Pennsylvania | 42103 | 4 | 0 |
10867 | 10867 | 2020-03-25 | Pike | Alabama | 1109 | 1 | 0 |
10918 | 10918 | 2020-03-25 | Pike | Arkansas | 5109 | 2 | 0 |
11593 | 11593 | 2020-03-25 | Pike | Mississippi | 28113 | 10 | 0 |
11989 | 11989 | 2020-03-25 | Pike | Pennsylvania | 42103 | 9 | 0 |
12406 | 12406 | 2020-03-26 | Pike | Alabama | 1109 | 2 | 0 |
12462 | 12462 | 2020-03-26 | Pike | Arkansas | 5109 | 2 | 0 |
13186 | 13186 | 2020-03-26 | Pike | Mississippi | 28113 | 12 | 0 |
13610 | 13610 | 2020-03-26 | Pike | Pennsylvania | 42103 | 15 | 0 |
14067 | 14067 | 2020-03-27 | Pike | Alabama | 1109 | 4 | 0 |
14126 | 14126 | 2020-03-27 | Pike | Arkansas | 5109 | 2 | 0 |
14905 | 14905 | 2020-03-27 | Pike | Mississippi | 28113 | 12 | 0 |
15357 | 15357 | 2020-03-27 | Pike | Pennsylvania | 42103 | 23 | 0 |
15846 | 15846 | 2020-03-28 | Pike | Alabama | 1109 | 4 | 0 |
15907 | 15907 | 2020-03-28 | Pike | Arkansas | 5109 | 3 | 0 |
16161 | 16161 | 2020-03-28 | Pike | Georgia | 13231 | 1 | 0 |
16729 | 16729 | 2020-03-28 | Pike | Mississippi | 28113 | 12 | 0 |
17084 | 17084 | 2020-03-28 | Pike | Ohio | 39131 | 1 | 0 |
17209 | 17209 | 2020-03-28 | Pike | Pennsylvania | 42103 | 27 | 1 |
17730 | 17730 | 2020-03-29 | Pike | Alabama | 1109 | 4 | 0 |
17796 | 17796 | 2020-03-29 | Pike | Arkansas | 5109 | 3 | 0 |
18058 | 18058 | 2020-03-29 | Pike | Georgia | 13231 | 2 | 0 |
18651 | 18651 | 2020-03-29 | Pike | Mississippi | 28113 | 14 | 0 |
19018 | 19018 | 2020-03-29 | Pike | Ohio | 39131 | 1 | 0 |
19148 | 19148 | 2020-03-29 | Pike | Pennsylvania | 42103 | 33 | 1 |
19702 | 19702 | 2020-03-30 | Pike | Alabama | 1109 | 4 | 0 |
19771 | 19771 | 2020-03-30 | Pike | Arkansas | 5109 | 2 | 0 |
20051 | 20051 | 2020-03-30 | Pike | Georgia | 13231 | 2 | 0 |
20675 | 20675 | 2020-03-30 | Pike | Mississippi | 28113 | 16 | 0 |
20742 | 20742 | 2020-03-30 | Pike | Missouri | 29163 | 1 | 0 |
21063 | 21063 | 2020-03-30 | Pike | Ohio | 39131 | 1 | 0 |
21198 | 21198 | 2020-03-30 | Pike | Pennsylvania | 42103 | 39 | 1 |
21774 | 21774 | 2020-03-31 | Pike | Alabama | 1109 | 4 | 0 |
21844 | 21844 | 2020-03-31 | Pike | Arkansas | 5109 | 2 | 0 |
22133 | 22133 | 2020-03-31 | Pike | Georgia | 13231 | 2 | 0 |
22792 | 22792 | 2020-03-31 | Pike | Mississippi | 28113 | 17 | 0 |
22861 | 22861 | 2020-03-31 | Pike | Missouri | 29163 | 1 | 0 |
23196 | 23196 | 2020-03-31 | Pike | Ohio | 39131 | 1 | 0 |
23334 | 23334 | 2020-03-31 | Pike | Pennsylvania | 42103 | 48 | 1 |
23930 | 23930 | 2020-04-01 | Pike | Alabama | 1109 | 7 | 0 |
24002 | 24002 | 2020-04-01 | Pike | Arkansas | 5109 | 2 | 0 |
24297 | 24297 | 2020-04-01 | Pike | Georgia | 13231 | 2 | 0 |
24976 | 24976 | 2020-04-01 | Pike | Mississippi | 28113 | 20 | 0 |
25049 | 25049 | 2020-04-01 | Pike | Missouri | 29163 | 1 | 0 |
25392 | 25392 | 2020-04-01 | Pike | Ohio | 39131 | 1 | 0 |
25532 | 25532 | 2020-04-01 | Pike | Pennsylvania | 42103 | 57 | 1 |
26152 | 26152 | 2020-04-02 | Pike | Alabama | 1109 | 7 | 0 |
26229 | 26229 | 2020-04-02 | Pike | Arkansas | 5109 | 2 | 0 |
26528 | 26528 | 2020-04-02 | Pike | Georgia | 13231 | 2 | 0 |
27230 | 27230 | 2020-04-02 | Pike | Mississippi | 28113 | 21 | 0 |
27306 | 27306 | 2020-04-02 | Pike | Missouri | 29163 | 1 | 0 |
27660 | 27660 | 2020-04-02 | Pike | Ohio | 39131 | 1 | 0 |
27805 | 27805 | 2020-04-02 | Pike | Pennsylvania | 42103 | 68 | 1 |
28449 | 28449 | 2020-04-03 | Pike | Alabama | 1109 | 10 | 0 |
28527 | 28527 | 2020-04-03 | Pike | Arkansas | 5109 | 2 | 0 |
28833 | 28833 | 2020-04-03 | Pike | Georgia | 13231 | 4 | 0 |
29549 | 29549 | 2020-04-03 | Pike | Mississippi | 28113 | 21 | 0 |
29627 | 29627 | 2020-04-03 | Pike | Missouri | 29163 | 2 | 0 |
29989 | 29989 | 2020-04-03 | Pike | Ohio | 39131 | 1 | 0 |
30139 | 30139 | 2020-04-03 | Pike | Pennsylvania | 42103 | 83 | 1 |
30806 | 30806 | 2020-04-04 | Pike | Alabama | 1109 | 10 | 0 |
30885 | 30885 | 2020-04-04 | Pike | Arkansas | 5109 | 2 | 0 |
31193 | 31193 | 2020-04-04 | Pike | Georgia | 13231 | 5 | 0 |
31328 | 31328 | 2020-04-04 | Pike | Illinois | 17149 | 1 | 0 |
31929 | 31929 | 2020-04-04 | Pike | Mississippi | 28113 | 23 | 0 |
32008 | 32008 | 2020-04-04 | Pike | Missouri | 29163 | 2 | 0 |
32378 | 32378 | 2020-04-04 | Pike | Ohio | 39131 | 1 | 0 |
32529 | 32529 | 2020-04-04 | Pike | Pennsylvania | 42103 | 97 | 1 |
33210 | 33210 | 2020-04-05 | Pike | Alabama | 1109 | 14 | 0 |
33290 | 33290 | 2020-04-05 | Pike | Arkansas | 5109 | 2 | 0 |
33600 | 33600 | 2020-04-05 | Pike | Georgia | 13231 | 5 | 0 |
33738 | 33738 | 2020-04-05 | Pike | Illinois | 17149 | 1 | 0 |
34038 | 34038 | 2020-04-05 | Pike | Kentucky | 21195 | 1 | 0 |
34356 | 34356 | 2020-04-05 | Pike | Mississippi | 28113 | 26 | 0 |
34436 | 34436 | 2020-04-05 | Pike | Missouri | 29163 | 2 | 0 |
34812 | 34812 | 2020-04-05 | Pike | Ohio | 39131 | 1 | 0 |
34965 | 34965 | 2020-04-05 | Pike | Pennsylvania | 42103 | 114 | 1 |
35649 | 35649 | 2020-04-06 | Pike | Alabama | 1109 | 14 | 0 |
35734 | 35734 | 2020-04-06 | Pike | Arkansas | 5109 | 2 | 0 |
36050 | 36050 | 2020-04-06 | Pike | Georgia | 13231 | 9 | 0 |
36190 | 36190 | 2020-04-06 | Pike | Illinois | 17149 | 1 | 0 |
36496 | 36496 | 2020-04-06 | Pike | Kentucky | 21195 | 1 | 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);