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 date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, 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 |
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);