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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
5625 | 5625 | 2020-03-20 | Pike | Mississippi | 28113 | 1 | 0 |
9547 | 9547 | 2020-03-24 | Pike | Arkansas | 5109 | 1 | 0 |
10867 | 10867 | 2020-03-25 | Pike | Alabama | 1109 | 1 | 0 |
16161 | 16161 | 2020-03-28 | Pike | Georgia | 13231 | 1 | 0 |
17084 | 17084 | 2020-03-28 | Pike | Ohio | 39131 | 1 | 0 |
19018 | 19018 | 2020-03-29 | Pike | Ohio | 39131 | 1 | 0 |
20742 | 20742 | 2020-03-30 | Pike | Missouri | 29163 | 1 | 0 |
21063 | 21063 | 2020-03-30 | Pike | Ohio | 39131 | 1 | 0 |
22861 | 22861 | 2020-03-31 | Pike | Missouri | 29163 | 1 | 0 |
23196 | 23196 | 2020-03-31 | Pike | Ohio | 39131 | 1 | 0 |
25049 | 25049 | 2020-04-01 | Pike | Missouri | 29163 | 1 | 0 |
25392 | 25392 | 2020-04-01 | Pike | Ohio | 39131 | 1 | 0 |
27306 | 27306 | 2020-04-02 | Pike | Missouri | 29163 | 1 | 0 |
27660 | 27660 | 2020-04-02 | Pike | Ohio | 39131 | 1 | 0 |
29989 | 29989 | 2020-04-03 | Pike | Ohio | 39131 | 1 | 0 |
31328 | 31328 | 2020-04-04 | Pike | Illinois | 17149 | 1 | 0 |
32378 | 32378 | 2020-04-04 | Pike | Ohio | 39131 | 1 | 0 |
33738 | 33738 | 2020-04-05 | Pike | Illinois | 17149 | 1 | 0 |
34038 | 34038 | 2020-04-05 | Pike | Kentucky | 21195 | 1 | 0 |
34812 | 34812 | 2020-04-05 | Pike | Ohio | 39131 | 1 | 0 |
36190 | 36190 | 2020-04-06 | Pike | Illinois | 17149 | 1 | 0 |
36496 | 36496 | 2020-04-06 | Pike | Kentucky | 21195 | 1 | 0 |
37283 | 37283 | 2020-04-06 | Pike | Ohio | 39131 | 1 | 0 |
38686 | 38686 | 2020-04-07 | Pike | Illinois | 17149 | 1 | 0 |
39003 | 39003 | 2020-04-07 | Pike | Kentucky | 21195 | 1 | 0 |
39801 | 39801 | 2020-04-07 | Pike | Ohio | 39131 | 1 | 0 |
41231 | 41231 | 2020-04-08 | Pike | Illinois | 17149 | 1 | 0 |
41553 | 41553 | 2020-04-08 | Pike | Kentucky | 21195 | 1 | 0 |
42361 | 42361 | 2020-04-08 | Pike | Ohio | 39131 | 1 | 0 |
43805 | 43805 | 2020-04-09 | Pike | Illinois | 17149 | 1 | 0 |
44129 | 44129 | 2020-04-09 | Pike | Kentucky | 21195 | 1 | 0 |
44947 | 44947 | 2020-04-09 | Pike | Ohio | 39131 | 1 | 0 |
46409 | 46409 | 2020-04-10 | Pike | Illinois | 17149 | 1 | 0 |
46737 | 46737 | 2020-04-10 | Pike | Kentucky | 21195 | 1 | 0 |
47562 | 47562 | 2020-04-10 | Pike | Ohio | 39131 | 1 | 0 |
49042 | 49042 | 2020-04-11 | Pike | Illinois | 17149 | 1 | 0 |
50218 | 50218 | 2020-04-11 | Pike | Ohio | 39131 | 1 | 0 |
51704 | 51704 | 2020-04-12 | Pike | Illinois | 17149 | 1 | 0 |
51789 | 51789 | 2020-04-12 | Pike | Indiana | 18125 | 1 | 0 |
52891 | 52891 | 2020-04-12 | Pike | Ohio | 39131 | 1 | 0 |
54385 | 54385 | 2020-04-13 | Pike | Illinois | 17149 | 1 | 0 |
54470 | 54470 | 2020-04-13 | Pike | Indiana | 18125 | 1 | 0 |
55575 | 55575 | 2020-04-13 | Pike | Ohio | 39131 | 1 | 0 |
57078 | 57078 | 2020-04-14 | Pike | Illinois | 17149 | 1 | 0 |
58276 | 58276 | 2020-04-14 | Pike | Ohio | 39131 | 1 | 0 |
59785 | 59785 | 2020-04-15 | Pike | Illinois | 17149 | 1 | 0 |
59871 | 59871 | 2020-04-15 | Pike | Indiana | 18125 | 1 | 0 |
60991 | 60991 | 2020-04-15 | Pike | Ohio | 39131 | 1 | 0 |
62506 | 62506 | 2020-04-16 | Pike | Illinois | 17149 | 1 | 0 |
62592 | 62592 | 2020-04-16 | Pike | Indiana | 18125 | 1 | 0 |
63717 | 63717 | 2020-04-16 | Pike | Ohio | 39131 | 1 | 0 |
65239 | 65239 | 2020-04-17 | Pike | Illinois | 17149 | 1 | 0 |
65326 | 65326 | 2020-04-17 | Pike | Indiana | 18125 | 1 | 0 |
66460 | 66460 | 2020-04-17 | Pike | Ohio | 39131 | 1 | 0 |
67988 | 67988 | 2020-04-18 | Pike | Illinois | 17149 | 1 | 0 |
68075 | 68075 | 2020-04-18 | Pike | Indiana | 18125 | 1 | 0 |
69217 | 69217 | 2020-04-18 | Pike | Ohio | 39131 | 1 | 0 |
70750 | 70750 | 2020-04-19 | Pike | Illinois | 17149 | 1 | 0 |
70837 | 70837 | 2020-04-19 | Pike | Indiana | 18125 | 1 | 0 |
71984 | 71984 | 2020-04-19 | Pike | Ohio | 39131 | 1 | 0 |
73520 | 73520 | 2020-04-20 | Pike | Illinois | 17149 | 1 | 0 |
73608 | 73608 | 2020-04-20 | Pike | Indiana | 18125 | 1 | 0 |
76297 | 76297 | 2020-04-21 | Pike | Illinois | 17149 | 1 | 0 |
76385 | 76385 | 2020-04-21 | Pike | Indiana | 18125 | 1 | 0 |
79081 | 79081 | 2020-04-22 | Pike | Illinois | 17149 | 1 | 0 |
79169 | 79169 | 2020-04-22 | Pike | Indiana | 18125 | 1 | 0 |
81874 | 81874 | 2020-04-23 | Pike | Illinois | 17149 | 1 | 0 |
81962 | 81962 | 2020-04-23 | Pike | Indiana | 18125 | 1 | 0 |
84674 | 84674 | 2020-04-24 | Pike | Illinois | 17149 | 1 | 0 |
84762 | 84762 | 2020-04-24 | Pike | Indiana | 18125 | 1 | 0 |
87484 | 87484 | 2020-04-25 | Pike | Illinois | 17149 | 1 | 0 |
87572 | 87572 | 2020-04-25 | Pike | Indiana | 18125 | 1 | 0 |
90300 | 90300 | 2020-04-26 | Pike | Illinois | 17149 | 1 | 0 |
90388 | 90388 | 2020-04-26 | Pike | Indiana | 18125 | 1 | 0 |
93119 | 93119 | 2020-04-27 | Pike | Illinois | 17149 | 1 | 0 |
93207 | 93207 | 2020-04-27 | Pike | Indiana | 18125 | 1 | 0 |
95951 | 95951 | 2020-04-28 | Pike | Illinois | 17149 | 1 | 0 |
96039 | 96039 | 2020-04-28 | Pike | Indiana | 18125 | 1 | 0 |
98795 | 98795 | 2020-04-29 | Pike | Illinois | 17149 | 1 | 0 |
98883 | 98883 | 2020-04-29 | Pike | Indiana | 18125 | 1 | 0 |
101646 | 101646 | 2020-04-30 | Pike | Illinois | 17149 | 1 | 0 |
101734 | 101734 | 2020-04-30 | Pike | Indiana | 18125 | 1 | 0 |
104502 | 104502 | 2020-05-01 | Pike | Illinois | 17149 | 1 | 0 |
107367 | 107367 | 2020-05-02 | Pike | Illinois | 17149 | 1 | 0 |
110237 | 110237 | 2020-05-03 | Pike | Illinois | 17149 | 1 | 0 |
113112 | 113112 | 2020-05-04 | Pike | Illinois | 17149 | 1 | 0 |
115995 | 115995 | 2020-05-05 | Pike | Illinois | 17149 | 1 | 0 |
118955 | 118955 | 2020-05-06 | Pike | Illinois | 17149 | 1 | 0 |
121925 | 121925 | 2020-05-07 | Pike | Illinois | 17149 | 1 | 0 |
124904 | 124904 | 2020-05-08 | Pike | Illinois | 17149 | 1 | 0 |
127891 | 127891 | 2020-05-09 | Pike | Illinois | 17149 | 1 | 0 |
130882 | 130882 | 2020-05-10 | Pike | Illinois | 17149 | 1 | 0 |
133873 | 133873 | 2020-05-11 | Pike | Illinois | 17149 | 1 | 0 |
136862 | 136862 | 2020-05-12 | Pike | Illinois | 17149 | 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);