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 fips
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 |
---|---|---|---|---|---|---|---|
10867 | 10867 | 2020-03-25 | Pike | Alabama | 1109 | 1 | 0 |
12406 | 12406 | 2020-03-26 | Pike | Alabama | 1109 | 2 | 0 |
14067 | 14067 | 2020-03-27 | Pike | Alabama | 1109 | 4 | 0 |
15846 | 15846 | 2020-03-28 | Pike | Alabama | 1109 | 4 | 0 |
17730 | 17730 | 2020-03-29 | Pike | Alabama | 1109 | 4 | 0 |
19702 | 19702 | 2020-03-30 | Pike | Alabama | 1109 | 4 | 0 |
21774 | 21774 | 2020-03-31 | Pike | Alabama | 1109 | 4 | 0 |
23930 | 23930 | 2020-04-01 | Pike | Alabama | 1109 | 7 | 0 |
26152 | 26152 | 2020-04-02 | Pike | Alabama | 1109 | 7 | 0 |
28449 | 28449 | 2020-04-03 | Pike | Alabama | 1109 | 10 | 0 |
30806 | 30806 | 2020-04-04 | Pike | Alabama | 1109 | 10 | 0 |
33210 | 33210 | 2020-04-05 | Pike | Alabama | 1109 | 14 | 0 |
35649 | 35649 | 2020-04-06 | Pike | Alabama | 1109 | 14 | 0 |
38137 | 38137 | 2020-04-07 | Pike | Alabama | 1109 | 14 | 0 |
40679 | 40679 | 2020-04-08 | Pike | Alabama | 1109 | 16 | 0 |
43253 | 43253 | 2020-04-09 | Pike | Alabama | 1109 | 18 | 0 |
45851 | 45851 | 2020-04-10 | Pike | Alabama | 1109 | 18 | 0 |
48480 | 48480 | 2020-04-11 | Pike | Alabama | 1109 | 18 | 0 |
51142 | 51142 | 2020-04-12 | Pike | Alabama | 1109 | 20 | 0 |
53820 | 53820 | 2020-04-13 | Pike | Alabama | 1109 | 21 | 0 |
56512 | 56512 | 2020-04-14 | Pike | Alabama | 1109 | 22 | 0 |
59220 | 59220 | 2020-04-15 | Pike | Alabama | 1109 | 27 | 0 |
61938 | 61938 | 2020-04-16 | Pike | Alabama | 1109 | 28 | 0 |
64671 | 64671 | 2020-04-17 | Pike | Alabama | 1109 | 29 | 0 |
67419 | 67419 | 2020-04-18 | Pike | Alabama | 1109 | 34 | 0 |
70181 | 70181 | 2020-04-19 | Pike | Alabama | 1109 | 37 | 0 |
72950 | 72950 | 2020-04-20 | Pike | Alabama | 1109 | 41 | 0 |
75726 | 75726 | 2020-04-21 | Pike | Alabama | 1109 | 46 | 0 |
78509 | 78509 | 2020-04-22 | Pike | Alabama | 1109 | 53 | 0 |
81302 | 81302 | 2020-04-23 | Pike | Alabama | 1109 | 57 | 0 |
84103 | 84103 | 2020-04-24 | Pike | Alabama | 1109 | 58 | 0 |
86911 | 86911 | 2020-04-25 | Pike | Alabama | 1109 | 58 | 0 |
89727 | 89727 | 2020-04-26 | Pike | Alabama | 1109 | 62 | 0 |
92545 | 92545 | 2020-04-27 | Pike | Alabama | 1109 | 65 | 0 |
95375 | 95375 | 2020-04-28 | Pike | Alabama | 1109 | 65 | 0 |
98220 | 98220 | 2020-04-29 | Pike | Alabama | 1109 | 67 | 0 |
101070 | 101070 | 2020-04-30 | Pike | Alabama | 1109 | 66 | 0 |
103925 | 103925 | 2020-05-01 | Pike | Alabama | 1109 | 69 | 0 |
106790 | 106790 | 2020-05-02 | Pike | Alabama | 1109 | 73 | 0 |
109659 | 109659 | 2020-05-03 | Pike | Alabama | 1109 | 75 | 0 |
112534 | 112534 | 2020-05-04 | Pike | Alabama | 1109 | 79 | 0 |
115417 | 115417 | 2020-05-05 | Pike | Alabama | 1109 | 82 | 0 |
118376 | 118376 | 2020-05-06 | Pike | Alabama | 1109 | 84 | 0 |
121342 | 121342 | 2020-05-07 | Pike | Alabama | 1109 | 85 | 0 |
124322 | 124322 | 2020-05-08 | Pike | Alabama | 1109 | 87 | 0 |
127307 | 127307 | 2020-05-09 | Pike | Alabama | 1109 | 89 | 0 |
130297 | 130297 | 2020-05-10 | Pike | Alabama | 1109 | 93 | 0 |
133287 | 133287 | 2020-05-11 | Pike | Alabama | 1109 | 99 | 0 |
136277 | 136277 | 2020-05-12 | Pike | Alabama | 1109 | 100 | 0 |
139268 | 139268 | 2020-05-13 | Pike | Alabama | 1109 | 102 | 0 |
142264 | 142264 | 2020-05-14 | Pike | Alabama | 1109 | 103 | 0 |
145263 | 145263 | 2020-05-15 | Pike | Alabama | 1109 | 105 | 0 |
148266 | 148266 | 2020-05-16 | Pike | Alabama | 1109 | 106 | 0 |
151275 | 151275 | 2020-05-17 | Pike | Alabama | 1109 | 106 | 0 |
154287 | 154287 | 2020-05-18 | Pike | Alabama | 1109 | 107 | 0 |
157303 | 157303 | 2020-05-19 | Pike | Alabama | 1109 | 110 | 0 |
160327 | 160327 | 2020-05-20 | Pike | Alabama | 1109 | 121 | 0 |
163355 | 163355 | 2020-05-21 | Pike | Alabama | 1109 | 125 | 0 |
166387 | 166387 | 2020-05-22 | Pike | Alabama | 1109 | 127 | 0 |
169423 | 169423 | 2020-05-23 | Pike | Alabama | 1109 | 130 | 0 |
172464 | 172464 | 2020-05-24 | Pike | Alabama | 1109 | 136 | 0 |
175507 | 175507 | 2020-05-25 | Pike | Alabama | 1109 | 145 | 0 |
178552 | 178552 | 2020-05-26 | Pike | Alabama | 1109 | 160 | 0 |
181596 | 181596 | 2020-05-27 | Pike | Alabama | 1109 | 173 | 0 |
184648 | 184648 | 2020-05-28 | Pike | Alabama | 1109 | 179 | 0 |
187705 | 187705 | 2020-05-29 | Pike | Alabama | 1109 | 191 | 0 |
190769 | 190769 | 2020-05-30 | Pike | Alabama | 1109 | 198 | 0 |
193835 | 193835 | 2020-05-31 | Pike | Alabama | 1109 | 203 | 0 |
196905 | 196905 | 2020-06-01 | Pike | Alabama | 1109 | 207 | 0 |
199978 | 199978 | 2020-06-02 | Pike | Alabama | 1109 | 209 | 0 |
203054 | 203054 | 2020-06-03 | Pike | Alabama | 1109 | 209 | 0 |
206133 | 206133 | 2020-06-04 | Pike | Alabama | 1109 | 213 | 0 |
209215 | 209215 | 2020-06-05 | Pike | Alabama | 1109 | 224 | 1 |
212300 | 212300 | 2020-06-06 | Pike | Alabama | 1109 | 241 | 1 |
215387 | 215387 | 2020-06-07 | Pike | Alabama | 1109 | 245 | 1 |
218477 | 218477 | 2020-06-08 | Pike | Alabama | 1109 | 252 | 1 |
221569 | 221569 | 2020-06-09 | Pike | Alabama | 1109 | 261 | 1 |
224665 | 224665 | 2020-06-10 | Pike | Alabama | 1109 | 268 | 1 |
227766 | 227766 | 2020-06-11 | Pike | Alabama | 1109 | 285 | 1 |
230870 | 230870 | 2020-06-12 | Pike | Alabama | 1109 | 300 | 2 |
233975 | 233975 | 2020-06-13 | Pike | Alabama | 1109 | 309 | 2 |
237082 | 237082 | 2020-06-14 | Pike | Alabama | 1109 | 326 | 2 |
240190 | 240190 | 2020-06-15 | Pike | Alabama | 1109 | 336 | 2 |
243301 | 243301 | 2020-06-16 | Pike | Alabama | 1109 | 343 | 2 |
246414 | 246414 | 2020-06-17 | Pike | Alabama | 1109 | 345 | 2 |
249526 | 249526 | 2020-06-18 | Pike | Alabama | 1109 | 347 | 3 |
252641 | 252641 | 2020-06-19 | Pike | Alabama | 1109 | 356 | 3 |
255760 | 255760 | 2020-06-20 | Pike | Alabama | 1109 | 360 | 3 |
258887 | 258887 | 2020-06-21 | Pike | Alabama | 1109 | 360 | 3 |
262014 | 262014 | 2020-06-22 | Pike | Alabama | 1109 | 361 | 3 |
265143 | 265143 | 2020-06-23 | Pike | Alabama | 1109 | 370 | 4 |
268272 | 268272 | 2020-06-24 | Pike | Alabama | 1109 | 378 | 4 |
271406 | 271406 | 2020-06-25 | Pike | Alabama | 1109 | 383 | 4 |
274546 | 274546 | 2020-06-26 | Pike | Alabama | 1109 | 387 | 5 |
277694 | 277694 | 2020-06-27 | Pike | Alabama | 1109 | 394 | 5 |
280842 | 280842 | 2020-06-28 | Pike | Alabama | 1109 | 395 | 5 |
283988 | 283988 | 2020-06-29 | Pike | Alabama | 1109 | 401 | 5 |
287134 | 287134 | 2020-06-30 | Pike | Alabama | 1109 | 404 | 5 |
290284 | 290284 | 2020-07-01 | Pike | Alabama | 1109 | 407 | 5 |
293437 | 293437 | 2020-07-02 | Pike | Alabama | 1109 | 415 | 5 |
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);