ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 5069 and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382865 | 382865 | 2020-07-30 | Jefferson | Arkansas | 5069 | 1270 | 37 |
379648 | 379648 | 2020-07-29 | Jefferson | Arkansas | 5069 | 1239 | 37 |
376432 | 376432 | 2020-07-28 | Jefferson | Arkansas | 5069 | 1222 | 36 |
373218 | 373218 | 2020-07-27 | Jefferson | Arkansas | 5069 | 1204 | 36 |
370006 | 370006 | 2020-07-26 | Jefferson | Arkansas | 5069 | 1171 | 34 |
366796 | 366796 | 2020-07-25 | Jefferson | Arkansas | 5069 | 1146 | 34 |
363589 | 363589 | 2020-07-24 | Jefferson | Arkansas | 5069 | 1133 | 33 |
360382 | 360382 | 2020-07-23 | Jefferson | Arkansas | 5069 | 1094 | 32 |
357177 | 357177 | 2020-07-22 | Jefferson | Arkansas | 5069 | 1069 | 32 |
353974 | 353974 | 2020-07-21 | Jefferson | Arkansas | 5069 | 1063 | 32 |
350772 | 350772 | 2020-07-20 | Jefferson | Arkansas | 5069 | 1029 | 30 |
347571 | 347571 | 2020-07-19 | Jefferson | Arkansas | 5069 | 1023 | 30 |
344371 | 344371 | 2020-07-18 | Jefferson | Arkansas | 5069 | 969 | 30 |
341172 | 341172 | 2020-07-17 | Jefferson | Arkansas | 5069 | 950 | 30 |
337976 | 337976 | 2020-07-16 | Jefferson | Arkansas | 5069 | 937 | 29 |
334781 | 334781 | 2020-07-15 | Jefferson | Arkansas | 5069 | 917 | 29 |
331588 | 331588 | 2020-07-14 | Jefferson | Arkansas | 5069 | 900 | 29 |
328402 | 328402 | 2020-07-13 | Jefferson | Arkansas | 5069 | 884 | 29 |
325216 | 325216 | 2020-07-12 | Jefferson | Arkansas | 5069 | 861 | 29 |
322035 | 322035 | 2020-07-11 | Jefferson | Arkansas | 5069 | 850 | 29 |
318856 | 318856 | 2020-07-10 | Jefferson | Arkansas | 5069 | 831 | 28 |
315683 | 315683 | 2020-07-09 | Jefferson | Arkansas | 5069 | 808 | 28 |
312508 | 312508 | 2020-07-08 | Jefferson | Arkansas | 5069 | 784 | 28 |
309338 | 309338 | 2020-07-07 | Jefferson | Arkansas | 5069 | 774 | 28 |
306170 | 306170 | 2020-07-06 | Jefferson | Arkansas | 5069 | 761 | 28 |
303006 | 303006 | 2020-07-05 | Jefferson | Arkansas | 5069 | 752 | 28 |
299842 | 299842 | 2020-07-04 | Jefferson | Arkansas | 5069 | 737 | 28 |
296680 | 296680 | 2020-07-03 | Jefferson | Arkansas | 5069 | 726 | 28 |
293524 | 293524 | 2020-07-02 | Jefferson | Arkansas | 5069 | 720 | 28 |
290370 | 290370 | 2020-07-01 | Jefferson | Arkansas | 5069 | 706 | 28 |
287219 | 287219 | 2020-06-30 | Jefferson | Arkansas | 5069 | 700 | 28 |
284073 | 284073 | 2020-06-29 | Jefferson | Arkansas | 5069 | 693 | 28 |
280927 | 280927 | 2020-06-28 | Jefferson | Arkansas | 5069 | 683 | 28 |
277780 | 277780 | 2020-06-27 | Jefferson | Arkansas | 5069 | 680 | 28 |
274632 | 274632 | 2020-06-26 | Jefferson | Arkansas | 5069 | 676 | 28 |
271492 | 271492 | 2020-06-25 | Jefferson | Arkansas | 5069 | 663 | 28 |
268357 | 268357 | 2020-06-24 | Jefferson | Arkansas | 5069 | 661 | 28 |
265227 | 265227 | 2020-06-23 | Jefferson | Arkansas | 5069 | 657 | 28 |
262099 | 262099 | 2020-06-22 | Jefferson | Arkansas | 5069 | 657 | 28 |
258972 | 258972 | 2020-06-21 | Jefferson | Arkansas | 5069 | 650 | 28 |
255845 | 255845 | 2020-06-20 | Jefferson | Arkansas | 5069 | 644 | 28 |
252726 | 252726 | 2020-06-19 | Jefferson | Arkansas | 5069 | 640 | 28 |
249611 | 249611 | 2020-06-18 | Jefferson | Arkansas | 5069 | 637 | 28 |
246499 | 246499 | 2020-06-17 | Jefferson | Arkansas | 5069 | 634 | 28 |
243386 | 243386 | 2020-06-16 | Jefferson | Arkansas | 5069 | 633 | 28 |
240275 | 240275 | 2020-06-15 | Jefferson | Arkansas | 5069 | 633 | 28 |
237167 | 237167 | 2020-06-14 | Jefferson | Arkansas | 5069 | 630 | 28 |
234060 | 234060 | 2020-06-13 | Jefferson | Arkansas | 5069 | 628 | 28 |
230954 | 230954 | 2020-06-12 | Jefferson | Arkansas | 5069 | 625 | 28 |
227851 | 227851 | 2020-06-11 | Jefferson | Arkansas | 5069 | 578 | 28 |
224749 | 224749 | 2020-06-10 | Jefferson | Arkansas | 5069 | 573 | 28 |
221654 | 221654 | 2020-06-09 | Jefferson | Arkansas | 5069 | 559 | 28 |
218559 | 218559 | 2020-06-08 | Jefferson | Arkansas | 5069 | 554 | 26 |
215468 | 215468 | 2020-06-07 | Jefferson | Arkansas | 5069 | 548 | 26 |
212381 | 212381 | 2020-06-06 | Jefferson | Arkansas | 5069 | 547 | 26 |
209296 | 209296 | 2020-06-05 | Jefferson | Arkansas | 5069 | 545 | 25 |
206215 | 206215 | 2020-06-04 | Jefferson | Arkansas | 5069 | 536 | 25 |
203135 | 203135 | 2020-06-03 | Jefferson | Arkansas | 5069 | 532 | 25 |
200059 | 200059 | 2020-06-02 | Jefferson | Arkansas | 5069 | 529 | 25 |
196986 | 196986 | 2020-06-01 | Jefferson | Arkansas | 5069 | 523 | 25 |
193916 | 193916 | 2020-05-31 | Jefferson | Arkansas | 5069 | 521 | 25 |
190849 | 190849 | 2020-05-30 | Jefferson | Arkansas | 5069 | 517 | 25 |
187784 | 187784 | 2020-05-29 | Jefferson | Arkansas | 5069 | 516 | 25 |
184728 | 184728 | 2020-05-28 | Jefferson | Arkansas | 5069 | 515 | 24 |
181674 | 181674 | 2020-05-27 | Jefferson | Arkansas | 5069 | 510 | 23 |
178630 | 178630 | 2020-05-26 | Jefferson | Arkansas | 5069 | 510 | 23 |
175586 | 175586 | 2020-05-25 | Jefferson | Arkansas | 5069 | 504 | 23 |
172542 | 172542 | 2020-05-24 | Jefferson | Arkansas | 5069 | 504 | 23 |
169501 | 169501 | 2020-05-23 | Jefferson | Arkansas | 5069 | 504 | 23 |
166465 | 166465 | 2020-05-22 | Jefferson | Arkansas | 5069 | 501 | 23 |
163433 | 163433 | 2020-05-21 | Jefferson | Arkansas | 5069 | 500 | 22 |
160405 | 160405 | 2020-05-20 | Jefferson | Arkansas | 5069 | 499 | 21 |
157379 | 157379 | 2020-05-19 | Jefferson | Arkansas | 5069 | 497 | 20 |
154363 | 154363 | 2020-05-18 | Jefferson | Arkansas | 5069 | 491 | 19 |
151351 | 151351 | 2020-05-17 | Jefferson | Arkansas | 5069 | 491 | 19 |
148342 | 148342 | 2020-05-16 | Jefferson | Arkansas | 5069 | 362 | 19 |
145339 | 145339 | 2020-05-15 | Jefferson | Arkansas | 5069 | 310 | 19 |
142340 | 142340 | 2020-05-14 | Jefferson | Arkansas | 5069 | 300 | 19 |
139344 | 139344 | 2020-05-13 | Jefferson | Arkansas | 5069 | 280 | 19 |
136353 | 136353 | 2020-05-12 | Jefferson | Arkansas | 5069 | 273 | 19 |
133363 | 133363 | 2020-05-11 | Jefferson | Arkansas | 5069 | 238 | 19 |
130373 | 130373 | 2020-05-10 | Jefferson | Arkansas | 5069 | 234 | 19 |
127383 | 127383 | 2020-05-09 | Jefferson | Arkansas | 5069 | 226 | 19 |
124398 | 124398 | 2020-05-08 | Jefferson | Arkansas | 5069 | 226 | 19 |
121418 | 121418 | 2020-05-07 | Jefferson | Arkansas | 5069 | 222 | 19 |
118451 | 118451 | 2020-05-06 | Jefferson | Arkansas | 5069 | 217 | 19 |
115492 | 115492 | 2020-05-05 | Jefferson | Arkansas | 5069 | 199 | 19 |
112609 | 112609 | 2020-05-04 | Jefferson | Arkansas | 5069 | 195 | 18 |
109734 | 109734 | 2020-05-03 | Jefferson | Arkansas | 5069 | 184 | 17 |
106865 | 106865 | 2020-05-02 | Jefferson | Arkansas | 5069 | 178 | 16 |
104000 | 104000 | 2020-05-01 | Jefferson | Arkansas | 5069 | 176 | 15 |
101145 | 101145 | 2020-04-30 | Jefferson | Arkansas | 5069 | 169 | 14 |
98295 | 98295 | 2020-04-29 | Jefferson | Arkansas | 5069 | 168 | 14 |
95450 | 95450 | 2020-04-28 | Jefferson | Arkansas | 5069 | 162 | 13 |
92620 | 92620 | 2020-04-27 | Jefferson | Arkansas | 5069 | 160 | 9 |
89802 | 89802 | 2020-04-26 | Jefferson | Arkansas | 5069 | 153 | 9 |
86985 | 86985 | 2020-04-25 | Jefferson | Arkansas | 5069 | 149 | 7 |
84177 | 84177 | 2020-04-24 | Jefferson | Arkansas | 5069 | 145 | 7 |
81377 | 81377 | 2020-04-23 | Jefferson | Arkansas | 5069 | 142 | 7 |
78583 | 78583 | 2020-04-22 | Jefferson | Arkansas | 5069 | 136 | 7 |
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);