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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 10
- Pennsylvania 777
- Missouri 767
- Ohio 767
- Alabama 766
- Arkansas 766
- Georgia 766
- Illinois 766
- Kentucky 766
- Mississippi 766
- Indiana 762
fips 10
county 1
- Pike · 7,669 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
39416 | 39416 | 2020-04-07 | Pike | Missouri | 29163 | 2 | 0 |
39801 | 39801 | 2020-04-07 | Pike | Ohio | 39131 | 1 | 0 |
40679 | 40679 | 2020-04-08 | Pike | Alabama | 1109 | 16 | 0 |
40767 | 40767 | 2020-04-08 | Pike | Arkansas | 5109 | 2 | 0 |
41087 | 41087 | 2020-04-08 | Pike | Georgia | 13231 | 11 | 0 |
41231 | 41231 | 2020-04-08 | Pike | Illinois | 17149 | 1 | 0 |
41553 | 41553 | 2020-04-08 | Pike | Kentucky | 21195 | 1 | 0 |
41970 | 41970 | 2020-04-08 | Pike | Missouri | 29163 | 4 | 0 |
42361 | 42361 | 2020-04-08 | Pike | Ohio | 39131 | 1 | 0 |
43253 | 43253 | 2020-04-09 | Pike | Alabama | 1109 | 18 | 0 |
43339 | 43339 | 2020-04-09 | Pike | Arkansas | 5109 | 2 | 0 |
43661 | 43661 | 2020-04-09 | Pike | Georgia | 13231 | 12 | 0 |
43805 | 43805 | 2020-04-09 | Pike | Illinois | 17149 | 1 | 0 |
44129 | 44129 | 2020-04-09 | Pike | Kentucky | 21195 | 1 | 0 |
44547 | 44547 | 2020-04-09 | Pike | Missouri | 29163 | 5 | 0 |
44947 | 44947 | 2020-04-09 | Pike | Ohio | 39131 | 1 | 0 |
45851 | 45851 | 2020-04-10 | Pike | Alabama | 1109 | 18 | 0 |
45939 | 45939 | 2020-04-10 | Pike | Arkansas | 5109 | 2 | 0 |
46263 | 46263 | 2020-04-10 | Pike | Georgia | 13231 | 15 | 0 |
46409 | 46409 | 2020-04-10 | Pike | Illinois | 17149 | 1 | 0 |
46737 | 46737 | 2020-04-10 | Pike | Kentucky | 21195 | 1 | 0 |
47156 | 47156 | 2020-04-10 | Pike | Missouri | 29163 | 5 | 0 |
47562 | 47562 | 2020-04-10 | Pike | Ohio | 39131 | 1 | 0 |
48480 | 48480 | 2020-04-11 | Pike | Alabama | 1109 | 18 | 0 |
48569 | 48569 | 2020-04-11 | Pike | Arkansas | 5109 | 2 | 0 |
48894 | 48894 | 2020-04-11 | Pike | Georgia | 13231 | 16 | 0 |
49042 | 49042 | 2020-04-11 | Pike | Illinois | 17149 | 1 | 0 |
49377 | 49377 | 2020-04-11 | Pike | Kentucky | 21195 | 4 | 0 |
49804 | 49804 | 2020-04-11 | Pike | Missouri | 29163 | 6 | 0 |
50218 | 50218 | 2020-04-11 | Pike | Ohio | 39131 | 1 | 0 |
51142 | 51142 | 2020-04-12 | Pike | Alabama | 1109 | 20 | 0 |
51231 | 51231 | 2020-04-12 | Pike | Arkansas | 5109 | 2 | 0 |
51556 | 51556 | 2020-04-12 | Pike | Georgia | 13231 | 16 | 0 |
51704 | 51704 | 2020-04-12 | Pike | Illinois | 17149 | 1 | 0 |
51789 | 51789 | 2020-04-12 | Pike | Indiana | 18125 | 1 | 0 |
52477 | 52477 | 2020-04-12 | Pike | Missouri | 29163 | 6 | 0 |
52891 | 52891 | 2020-04-12 | Pike | Ohio | 39131 | 1 | 0 |
53820 | 53820 | 2020-04-13 | Pike | Alabama | 1109 | 21 | 0 |
53910 | 53910 | 2020-04-13 | Pike | Arkansas | 5109 | 2 | 0 |
54236 | 54236 | 2020-04-13 | Pike | Georgia | 13231 | 19 | 0 |
54385 | 54385 | 2020-04-13 | Pike | Illinois | 17149 | 1 | 0 |
54470 | 54470 | 2020-04-13 | Pike | Indiana | 18125 | 1 | 0 |
55159 | 55159 | 2020-04-13 | Pike | Missouri | 29163 | 6 | 0 |
55575 | 55575 | 2020-04-13 | Pike | Ohio | 39131 | 1 | 0 |
56512 | 56512 | 2020-04-14 | Pike | Alabama | 1109 | 22 | 0 |
56602 | 56602 | 2020-04-14 | Pike | Arkansas | 5109 | 2 | 0 |
56928 | 56928 | 2020-04-14 | Pike | Georgia | 13231 | 22 | 0 |
57078 | 57078 | 2020-04-14 | Pike | Illinois | 17149 | 1 | 0 |
57163 | 57163 | 2020-04-14 | Pike | Indiana | 18125 | 2 | 0 |
57857 | 57857 | 2020-04-14 | Pike | Missouri | 29163 | 6 | 0 |
58276 | 58276 | 2020-04-14 | Pike | Ohio | 39131 | 1 | 0 |
59220 | 59220 | 2020-04-15 | Pike | Alabama | 1109 | 27 | 0 |
59310 | 59310 | 2020-04-15 | Pike | Arkansas | 5109 | 2 | 0 |
59785 | 59785 | 2020-04-15 | Pike | Illinois | 17149 | 1 | 0 |
59871 | 59871 | 2020-04-15 | Pike | Indiana | 18125 | 1 | 0 |
60571 | 60571 | 2020-04-15 | Pike | Missouri | 29163 | 6 | 0 |
60991 | 60991 | 2020-04-15 | Pike | Ohio | 39131 | 1 | 0 |
61938 | 61938 | 2020-04-16 | Pike | Alabama | 1109 | 28 | 0 |
62029 | 62029 | 2020-04-16 | Pike | Arkansas | 5109 | 2 | 0 |
62506 | 62506 | 2020-04-16 | Pike | Illinois | 17149 | 1 | 0 |
62592 | 62592 | 2020-04-16 | Pike | Indiana | 18125 | 1 | 0 |
63293 | 63293 | 2020-04-16 | Pike | Missouri | 29163 | 6 | 0 |
63717 | 63717 | 2020-04-16 | Pike | Ohio | 39131 | 1 | 0 |
64671 | 64671 | 2020-04-17 | Pike | Alabama | 1109 | 29 | 0 |
64762 | 64762 | 2020-04-17 | Pike | Arkansas | 5109 | 2 | 0 |
65239 | 65239 | 2020-04-17 | Pike | Illinois | 17149 | 1 | 0 |
65326 | 65326 | 2020-04-17 | Pike | Indiana | 18125 | 1 | 0 |
66033 | 66033 | 2020-04-17 | Pike | Missouri | 29163 | 6 | 0 |
66460 | 66460 | 2020-04-17 | Pike | Ohio | 39131 | 1 | 0 |
67419 | 67419 | 2020-04-18 | Pike | Alabama | 1109 | 34 | 0 |
67510 | 67510 | 2020-04-18 | Pike | Arkansas | 5109 | 2 | 0 |
67988 | 67988 | 2020-04-18 | Pike | Illinois | 17149 | 1 | 0 |
68075 | 68075 | 2020-04-18 | Pike | Indiana | 18125 | 1 | 0 |
68787 | 68787 | 2020-04-18 | Pike | Missouri | 29163 | 6 | 0 |
69217 | 69217 | 2020-04-18 | Pike | Ohio | 39131 | 1 | 0 |
70181 | 70181 | 2020-04-19 | Pike | Alabama | 1109 | 37 | 0 |
70272 | 70272 | 2020-04-19 | Pike | Arkansas | 5109 | 2 | 0 |
70750 | 70750 | 2020-04-19 | Pike | Illinois | 17149 | 1 | 0 |
70837 | 70837 | 2020-04-19 | Pike | Indiana | 18125 | 1 | 0 |
71554 | 71554 | 2020-04-19 | Pike | Missouri | 29163 | 6 | 0 |
71984 | 71984 | 2020-04-19 | Pike | Ohio | 39131 | 1 | 0 |
72950 | 72950 | 2020-04-20 | Pike | Alabama | 1109 | 41 | 0 |
73041 | 73041 | 2020-04-20 | Pike | Arkansas | 5109 | 2 | 0 |
73520 | 73520 | 2020-04-20 | Pike | Illinois | 17149 | 1 | 0 |
73608 | 73608 | 2020-04-20 | Pike | Indiana | 18125 | 1 | 0 |
74327 | 74327 | 2020-04-20 | Pike | Missouri | 29163 | 6 | 0 |
74759 | 74759 | 2020-04-20 | Pike | Ohio | 39131 | 2 | 0 |
75726 | 75726 | 2020-04-21 | Pike | Alabama | 1109 | 46 | 0 |
75817 | 75817 | 2020-04-21 | Pike | Arkansas | 5109 | 2 | 0 |
76297 | 76297 | 2020-04-21 | Pike | Illinois | 17149 | 1 | 0 |
76385 | 76385 | 2020-04-21 | Pike | Indiana | 18125 | 1 | 0 |
77108 | 77108 | 2020-04-21 | Pike | Missouri | 29163 | 6 | 0 |
77540 | 77540 | 2020-04-21 | Pike | Ohio | 39131 | 2 | 0 |
78509 | 78509 | 2020-04-22 | Pike | Alabama | 1109 | 53 | 0 |
78601 | 78601 | 2020-04-22 | Pike | Arkansas | 5109 | 3 | 0 |
79081 | 79081 | 2020-04-22 | Pike | Illinois | 17149 | 1 | 0 |
79169 | 79169 | 2020-04-22 | Pike | Indiana | 18125 | 1 | 0 |
79895 | 79895 | 2020-04-22 | Pike | Missouri | 29163 | 6 | 0 |
80330 | 80330 | 2020-04-22 | Pike | Ohio | 39131 | 2 | 0 |
81302 | 81302 | 2020-04-23 | Pike | Alabama | 1109 | 57 | 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);