ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 5109 and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386103 | 386103 | 2020-07-31 | Pike | Arkansas | 5109 | 77 | 1 |
382885 | 382885 | 2020-07-30 | Pike | Arkansas | 5109 | 69 | 1 |
379668 | 379668 | 2020-07-29 | Pike | Arkansas | 5109 | 65 | 1 |
376452 | 376452 | 2020-07-28 | Pike | Arkansas | 5109 | 60 | 1 |
373238 | 373238 | 2020-07-27 | Pike | Arkansas | 5109 | 58 | 1 |
370026 | 370026 | 2020-07-26 | Pike | Arkansas | 5109 | 57 | 0 |
366816 | 366816 | 2020-07-25 | Pike | Arkansas | 5109 | 55 | 0 |
363609 | 363609 | 2020-07-24 | Pike | Arkansas | 5109 | 49 | 0 |
360402 | 360402 | 2020-07-23 | Pike | Arkansas | 5109 | 49 | 0 |
357197 | 357197 | 2020-07-22 | Pike | Arkansas | 5109 | 43 | 0 |
353994 | 353994 | 2020-07-21 | Pike | Arkansas | 5109 | 39 | 0 |
350792 | 350792 | 2020-07-20 | Pike | Arkansas | 5109 | 35 | 0 |
347591 | 347591 | 2020-07-19 | Pike | Arkansas | 5109 | 32 | 0 |
344391 | 344391 | 2020-07-18 | Pike | Arkansas | 5109 | 30 | 0 |
341192 | 341192 | 2020-07-17 | Pike | Arkansas | 5109 | 27 | 0 |
337996 | 337996 | 2020-07-16 | Pike | Arkansas | 5109 | 27 | 0 |
334801 | 334801 | 2020-07-15 | Pike | Arkansas | 5109 | 23 | 0 |
331608 | 331608 | 2020-07-14 | Pike | Arkansas | 5109 | 20 | 0 |
328422 | 328422 | 2020-07-13 | Pike | Arkansas | 5109 | 20 | 0 |
325236 | 325236 | 2020-07-12 | Pike | Arkansas | 5109 | 19 | 0 |
322055 | 322055 | 2020-07-11 | Pike | Arkansas | 5109 | 23 | 0 |
318876 | 318876 | 2020-07-10 | Pike | Arkansas | 5109 | 20 | 0 |
315703 | 315703 | 2020-07-09 | Pike | Arkansas | 5109 | 19 | 0 |
312528 | 312528 | 2020-07-08 | Pike | Arkansas | 5109 | 12 | 0 |
309358 | 309358 | 2020-07-07 | Pike | Arkansas | 5109 | 11 | 0 |
306190 | 306190 | 2020-07-06 | Pike | Arkansas | 5109 | 10 | 0 |
303026 | 303026 | 2020-07-05 | Pike | Arkansas | 5109 | 10 | 0 |
299862 | 299862 | 2020-07-04 | Pike | Arkansas | 5109 | 10 | 0 |
296700 | 296700 | 2020-07-03 | Pike | Arkansas | 5109 | 9 | 0 |
293544 | 293544 | 2020-07-02 | Pike | Arkansas | 5109 | 9 | 0 |
290390 | 290390 | 2020-07-01 | Pike | Arkansas | 5109 | 7 | 0 |
287239 | 287239 | 2020-06-30 | Pike | Arkansas | 5109 | 8 | 0 |
284093 | 284093 | 2020-06-29 | Pike | Arkansas | 5109 | 8 | 0 |
280947 | 280947 | 2020-06-28 | Pike | Arkansas | 5109 | 8 | 0 |
277800 | 277800 | 2020-06-27 | Pike | Arkansas | 5109 | 8 | 0 |
274652 | 274652 | 2020-06-26 | Pike | Arkansas | 5109 | 8 | 0 |
271512 | 271512 | 2020-06-25 | Pike | Arkansas | 5109 | 8 | 0 |
268377 | 268377 | 2020-06-24 | Pike | Arkansas | 5109 | 7 | 0 |
265247 | 265247 | 2020-06-23 | Pike | Arkansas | 5109 | 7 | 0 |
262119 | 262119 | 2020-06-22 | Pike | Arkansas | 5109 | 7 | 0 |
258992 | 258992 | 2020-06-21 | Pike | Arkansas | 5109 | 7 | 0 |
255865 | 255865 | 2020-06-20 | Pike | Arkansas | 5109 | 7 | 0 |
252746 | 252746 | 2020-06-19 | Pike | Arkansas | 5109 | 7 | 0 |
249631 | 249631 | 2020-06-18 | Pike | Arkansas | 5109 | 7 | 0 |
246519 | 246519 | 2020-06-17 | Pike | Arkansas | 5109 | 7 | 0 |
243406 | 243406 | 2020-06-16 | Pike | Arkansas | 5109 | 7 | 0 |
240295 | 240295 | 2020-06-15 | Pike | Arkansas | 5109 | 7 | 0 |
237187 | 237187 | 2020-06-14 | Pike | Arkansas | 5109 | 7 | 0 |
234080 | 234080 | 2020-06-13 | Pike | Arkansas | 5109 | 7 | 0 |
230974 | 230974 | 2020-06-12 | Pike | Arkansas | 5109 | 6 | 0 |
227871 | 227871 | 2020-06-11 | Pike | Arkansas | 5109 | 6 | 0 |
224769 | 224769 | 2020-06-10 | Pike | Arkansas | 5109 | 6 | 0 |
221674 | 221674 | 2020-06-09 | Pike | Arkansas | 5109 | 6 | 0 |
218579 | 218579 | 2020-06-08 | Pike | Arkansas | 5109 | 6 | 0 |
215488 | 215488 | 2020-06-07 | Pike | Arkansas | 5109 | 6 | 0 |
212401 | 212401 | 2020-06-06 | Pike | Arkansas | 5109 | 6 | 0 |
209316 | 209316 | 2020-06-05 | Pike | Arkansas | 5109 | 6 | 0 |
206235 | 206235 | 2020-06-04 | Pike | Arkansas | 5109 | 5 | 0 |
203155 | 203155 | 2020-06-03 | Pike | Arkansas | 5109 | 5 | 0 |
200079 | 200079 | 2020-06-02 | Pike | Arkansas | 5109 | 5 | 0 |
197006 | 197006 | 2020-06-01 | Pike | Arkansas | 5109 | 5 | 0 |
193936 | 193936 | 2020-05-31 | Pike | Arkansas | 5109 | 5 | 0 |
190869 | 190869 | 2020-05-30 | Pike | Arkansas | 5109 | 5 | 0 |
187804 | 187804 | 2020-05-29 | Pike | Arkansas | 5109 | 5 | 0 |
184748 | 184748 | 2020-05-28 | Pike | Arkansas | 5109 | 5 | 0 |
181694 | 181694 | 2020-05-27 | Pike | Arkansas | 5109 | 5 | 0 |
178650 | 178650 | 2020-05-26 | Pike | Arkansas | 5109 | 5 | 0 |
175606 | 175606 | 2020-05-25 | Pike | Arkansas | 5109 | 4 | 0 |
172562 | 172562 | 2020-05-24 | Pike | Arkansas | 5109 | 4 | 0 |
169521 | 169521 | 2020-05-23 | Pike | Arkansas | 5109 | 4 | 0 |
166485 | 166485 | 2020-05-22 | Pike | Arkansas | 5109 | 4 | 0 |
163453 | 163453 | 2020-05-21 | Pike | Arkansas | 5109 | 4 | 0 |
160425 | 160425 | 2020-05-20 | Pike | Arkansas | 5109 | 3 | 0 |
157399 | 157399 | 2020-05-19 | Pike | Arkansas | 5109 | 3 | 0 |
154383 | 154383 | 2020-05-18 | Pike | Arkansas | 5109 | 3 | 0 |
151371 | 151371 | 2020-05-17 | Pike | Arkansas | 5109 | 3 | 0 |
148362 | 148362 | 2020-05-16 | Pike | Arkansas | 5109 | 3 | 0 |
145358 | 145358 | 2020-05-15 | Pike | Arkansas | 5109 | 3 | 0 |
142359 | 142359 | 2020-05-14 | Pike | Arkansas | 5109 | 3 | 0 |
139363 | 139363 | 2020-05-13 | Pike | Arkansas | 5109 | 3 | 0 |
136372 | 136372 | 2020-05-12 | Pike | Arkansas | 5109 | 3 | 0 |
133382 | 133382 | 2020-05-11 | Pike | Arkansas | 5109 | 3 | 0 |
130392 | 130392 | 2020-05-10 | Pike | Arkansas | 5109 | 3 | 0 |
127402 | 127402 | 2020-05-09 | Pike | Arkansas | 5109 | 3 | 0 |
124417 | 124417 | 2020-05-08 | Pike | Arkansas | 5109 | 3 | 0 |
121437 | 121437 | 2020-05-07 | Pike | Arkansas | 5109 | 3 | 0 |
118470 | 118470 | 2020-05-06 | Pike | Arkansas | 5109 | 3 | 0 |
115511 | 115511 | 2020-05-05 | Pike | Arkansas | 5109 | 3 | 0 |
112628 | 112628 | 2020-05-04 | Pike | Arkansas | 5109 | 3 | 0 |
109753 | 109753 | 2020-05-03 | Pike | Arkansas | 5109 | 3 | 0 |
106884 | 106884 | 2020-05-02 | Pike | Arkansas | 5109 | 3 | 0 |
104019 | 104019 | 2020-05-01 | Pike | Arkansas | 5109 | 3 | 0 |
101164 | 101164 | 2020-04-30 | Pike | Arkansas | 5109 | 3 | 0 |
98314 | 98314 | 2020-04-29 | Pike | Arkansas | 5109 | 3 | 0 |
95469 | 95469 | 2020-04-28 | Pike | Arkansas | 5109 | 3 | 0 |
92638 | 92638 | 2020-04-27 | Pike | Arkansas | 5109 | 3 | 0 |
89820 | 89820 | 2020-04-26 | Pike | Arkansas | 5109 | 3 | 0 |
87003 | 87003 | 2020-04-25 | Pike | Arkansas | 5109 | 3 | 0 |
84195 | 84195 | 2020-04-24 | Pike | Arkansas | 5109 | 3 | 0 |
81395 | 81395 | 2020-04-23 | Pike | Arkansas | 5109 | 3 | 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);