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 |
---|---|---|---|---|---|---|---|
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 |
75799 | 75799 | 2020-04-21 | Jefferson | Arkansas | 5069 | 135 | 7 |
73023 | 73023 | 2020-04-20 | Jefferson | Arkansas | 5069 | 126 | 7 |
70254 | 70254 | 2020-04-19 | Jefferson | Arkansas | 5069 | 118 | 6 |
67492 | 67492 | 2020-04-18 | Jefferson | Arkansas | 5069 | 118 | 6 |
64744 | 64744 | 2020-04-17 | Jefferson | Arkansas | 5069 | 113 | 6 |
62011 | 62011 | 2020-04-16 | Jefferson | Arkansas | 5069 | 109 | 6 |
59292 | 59292 | 2020-04-15 | Jefferson | Arkansas | 5069 | 107 | 6 |
56584 | 56584 | 2020-04-14 | Jefferson | Arkansas | 5069 | 105 | 5 |
53892 | 53892 | 2020-04-13 | Jefferson | Arkansas | 5069 | 103 | 4 |
51213 | 51213 | 2020-04-12 | Jefferson | Arkansas | 5069 | 95 | 3 |
48551 | 48551 | 2020-04-11 | Jefferson | Arkansas | 5069 | 91 | 2 |
45921 | 45921 | 2020-04-10 | Jefferson | Arkansas | 5069 | 90 | 2 |
43322 | 43322 | 2020-04-09 | Jefferson | Arkansas | 5069 | 91 | 1 |
40750 | 40750 | 2020-04-08 | Jefferson | Arkansas | 5069 | 85 | 1 |
38207 | 38207 | 2020-04-07 | Jefferson | Arkansas | 5069 | 78 | 1 |
35718 | 35718 | 2020-04-06 | Jefferson | Arkansas | 5069 | 68 | 1 |
33275 | 33275 | 2020-04-05 | Jefferson | Arkansas | 5069 | 62 | 0 |
30871 | 30871 | 2020-04-04 | Jefferson | Arkansas | 5069 | 53 | 0 |
28513 | 28513 | 2020-04-03 | Jefferson | Arkansas | 5069 | 53 | 0 |
26216 | 26216 | 2020-04-02 | Jefferson | Arkansas | 5069 | 49 | 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);