ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 5035 and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382848 | 382848 | 2020-07-30 | Crittenden | Arkansas | 5035 | 1135 | 17 |
379631 | 379631 | 2020-07-29 | Crittenden | Arkansas | 5035 | 1127 | 17 |
376415 | 376415 | 2020-07-28 | Crittenden | Arkansas | 5035 | 1113 | 17 |
373201 | 373201 | 2020-07-27 | Crittenden | Arkansas | 5035 | 1100 | 16 |
369989 | 369989 | 2020-07-26 | Crittenden | Arkansas | 5035 | 1090 | 16 |
366779 | 366779 | 2020-07-25 | Crittenden | Arkansas | 5035 | 1072 | 16 |
363572 | 363572 | 2020-07-24 | Crittenden | Arkansas | 5035 | 1058 | 16 |
360365 | 360365 | 2020-07-23 | Crittenden | Arkansas | 5035 | 1044 | 15 |
357160 | 357160 | 2020-07-22 | Crittenden | Arkansas | 5035 | 994 | 15 |
353957 | 353957 | 2020-07-21 | Crittenden | Arkansas | 5035 | 972 | 15 |
350755 | 350755 | 2020-07-20 | Crittenden | Arkansas | 5035 | 957 | 15 |
347554 | 347554 | 2020-07-19 | Crittenden | Arkansas | 5035 | 944 | 14 |
344354 | 344354 | 2020-07-18 | Crittenden | Arkansas | 5035 | 929 | 14 |
341155 | 341155 | 2020-07-17 | Crittenden | Arkansas | 5035 | 916 | 14 |
337959 | 337959 | 2020-07-16 | Crittenden | Arkansas | 5035 | 906 | 14 |
334764 | 334764 | 2020-07-15 | Crittenden | Arkansas | 5035 | 893 | 14 |
331571 | 331571 | 2020-07-14 | Crittenden | Arkansas | 5035 | 879 | 14 |
328385 | 328385 | 2020-07-13 | Crittenden | Arkansas | 5035 | 865 | 14 |
325199 | 325199 | 2020-07-12 | Crittenden | Arkansas | 5035 | 841 | 14 |
322018 | 322018 | 2020-07-11 | Crittenden | Arkansas | 5035 | 833 | 14 |
318839 | 318839 | 2020-07-10 | Crittenden | Arkansas | 5035 | 817 | 13 |
315666 | 315666 | 2020-07-09 | Crittenden | Arkansas | 5035 | 815 | 13 |
312491 | 312491 | 2020-07-08 | Crittenden | Arkansas | 5035 | 799 | 13 |
309321 | 309321 | 2020-07-07 | Crittenden | Arkansas | 5035 | 786 | 13 |
306153 | 306153 | 2020-07-06 | Crittenden | Arkansas | 5035 | 783 | 13 |
302989 | 302989 | 2020-07-05 | Crittenden | Arkansas | 5035 | 766 | 13 |
299825 | 299825 | 2020-07-04 | Crittenden | Arkansas | 5035 | 766 | 13 |
296663 | 296663 | 2020-07-03 | Crittenden | Arkansas | 5035 | 765 | 13 |
293507 | 293507 | 2020-07-02 | Crittenden | Arkansas | 5035 | 759 | 13 |
290353 | 290353 | 2020-07-01 | Crittenden | Arkansas | 5035 | 749 | 13 |
287202 | 287202 | 2020-06-30 | Crittenden | Arkansas | 5035 | 746 | 12 |
284056 | 284056 | 2020-06-29 | Crittenden | Arkansas | 5035 | 737 | 11 |
280910 | 280910 | 2020-06-28 | Crittenden | Arkansas | 5035 | 731 | 11 |
277763 | 277763 | 2020-06-27 | Crittenden | Arkansas | 5035 | 696 | 11 |
274615 | 274615 | 2020-06-26 | Crittenden | Arkansas | 5035 | 687 | 11 |
271475 | 271475 | 2020-06-25 | Crittenden | Arkansas | 5035 | 660 | 10 |
268340 | 268340 | 2020-06-24 | Crittenden | Arkansas | 5035 | 621 | 10 |
265210 | 265210 | 2020-06-23 | Crittenden | Arkansas | 5035 | 604 | 10 |
262082 | 262082 | 2020-06-22 | Crittenden | Arkansas | 5035 | 600 | 10 |
258955 | 258955 | 2020-06-21 | Crittenden | Arkansas | 5035 | 588 | 10 |
255828 | 255828 | 2020-06-20 | Crittenden | Arkansas | 5035 | 577 | 10 |
252709 | 252709 | 2020-06-19 | Crittenden | Arkansas | 5035 | 573 | 10 |
249594 | 249594 | 2020-06-18 | Crittenden | Arkansas | 5035 | 562 | 10 |
246482 | 246482 | 2020-06-17 | Crittenden | Arkansas | 5035 | 554 | 10 |
243369 | 243369 | 2020-06-16 | Crittenden | Arkansas | 5035 | 545 | 10 |
240258 | 240258 | 2020-06-15 | Crittenden | Arkansas | 5035 | 537 | 9 |
237150 | 237150 | 2020-06-14 | Crittenden | Arkansas | 5035 | 522 | 9 |
234043 | 234043 | 2020-06-13 | Crittenden | Arkansas | 5035 | 517 | 9 |
230937 | 230937 | 2020-06-12 | Crittenden | Arkansas | 5035 | 508 | 9 |
227834 | 227834 | 2020-06-11 | Crittenden | Arkansas | 5035 | 500 | 9 |
224732 | 224732 | 2020-06-10 | Crittenden | Arkansas | 5035 | 489 | 9 |
221637 | 221637 | 2020-06-09 | Crittenden | Arkansas | 5035 | 473 | 9 |
218542 | 218542 | 2020-06-08 | Crittenden | Arkansas | 5035 | 465 | 9 |
215451 | 215451 | 2020-06-07 | Crittenden | Arkansas | 5035 | 463 | 9 |
212364 | 212364 | 2020-06-06 | Crittenden | Arkansas | 5035 | 452 | 9 |
209279 | 209279 | 2020-06-05 | Crittenden | Arkansas | 5035 | 436 | 9 |
206198 | 206198 | 2020-06-04 | Crittenden | Arkansas | 5035 | 426 | 9 |
203118 | 203118 | 2020-06-03 | Crittenden | Arkansas | 5035 | 413 | 9 |
200042 | 200042 | 2020-06-02 | Crittenden | Arkansas | 5035 | 395 | 9 |
196969 | 196969 | 2020-06-01 | Crittenden | Arkansas | 5035 | 386 | 9 |
193899 | 193899 | 2020-05-31 | Crittenden | Arkansas | 5035 | 380 | 9 |
190832 | 190832 | 2020-05-30 | Crittenden | Arkansas | 5035 | 367 | 9 |
187767 | 187767 | 2020-05-29 | Crittenden | Arkansas | 5035 | 341 | 9 |
184711 | 184711 | 2020-05-28 | Crittenden | Arkansas | 5035 | 318 | 9 |
181657 | 181657 | 2020-05-27 | Crittenden | Arkansas | 5035 | 301 | 9 |
178613 | 178613 | 2020-05-26 | Crittenden | Arkansas | 5035 | 297 | 9 |
175569 | 175569 | 2020-05-25 | Crittenden | Arkansas | 5035 | 293 | 9 |
172525 | 172525 | 2020-05-24 | Crittenden | Arkansas | 5035 | 285 | 9 |
169484 | 169484 | 2020-05-23 | Crittenden | Arkansas | 5035 | 280 | 9 |
166448 | 166448 | 2020-05-22 | Crittenden | Arkansas | 5035 | 276 | 8 |
163416 | 163416 | 2020-05-21 | Crittenden | Arkansas | 5035 | 267 | 8 |
160388 | 160388 | 2020-05-20 | Crittenden | Arkansas | 5035 | 250 | 8 |
157362 | 157362 | 2020-05-19 | Crittenden | Arkansas | 5035 | 241 | 7 |
154346 | 154346 | 2020-05-18 | Crittenden | Arkansas | 5035 | 237 | 7 |
151334 | 151334 | 2020-05-17 | Crittenden | Arkansas | 5035 | 234 | 7 |
148325 | 148325 | 2020-05-16 | Crittenden | Arkansas | 5035 | 230 | 7 |
145322 | 145322 | 2020-05-15 | Crittenden | Arkansas | 5035 | 229 | 7 |
142323 | 142323 | 2020-05-14 | Crittenden | Arkansas | 5035 | 219 | 7 |
139327 | 139327 | 2020-05-13 | Crittenden | Arkansas | 5035 | 216 | 7 |
136336 | 136336 | 2020-05-12 | Crittenden | Arkansas | 5035 | 212 | 7 |
133346 | 133346 | 2020-05-11 | Crittenden | Arkansas | 5035 | 210 | 7 |
130356 | 130356 | 2020-05-10 | Crittenden | Arkansas | 5035 | 210 | 7 |
127366 | 127366 | 2020-05-09 | Crittenden | Arkansas | 5035 | 205 | 7 |
124381 | 124381 | 2020-05-08 | Crittenden | Arkansas | 5035 | 205 | 7 |
121401 | 121401 | 2020-05-07 | Crittenden | Arkansas | 5035 | 203 | 7 |
118434 | 118434 | 2020-05-06 | Crittenden | Arkansas | 5035 | 202 | 7 |
115475 | 115475 | 2020-05-05 | Crittenden | Arkansas | 5035 | 197 | 7 |
112592 | 112592 | 2020-05-04 | Crittenden | Arkansas | 5035 | 196 | 7 |
109717 | 109717 | 2020-05-03 | Crittenden | Arkansas | 5035 | 197 | 5 |
106848 | 106848 | 2020-05-02 | Crittenden | Arkansas | 5035 | 193 | 5 |
103983 | 103983 | 2020-05-01 | Crittenden | Arkansas | 5035 | 188 | 5 |
101128 | 101128 | 2020-04-30 | Crittenden | Arkansas | 5035 | 187 | 5 |
98278 | 98278 | 2020-04-29 | Crittenden | Arkansas | 5035 | 181 | 5 |
95433 | 95433 | 2020-04-28 | Crittenden | Arkansas | 5035 | 177 | 5 |
92603 | 92603 | 2020-04-27 | Crittenden | Arkansas | 5035 | 174 | 5 |
89785 | 89785 | 2020-04-26 | Crittenden | Arkansas | 5035 | 171 | 5 |
86968 | 86968 | 2020-04-25 | Crittenden | Arkansas | 5035 | 169 | 5 |
84160 | 84160 | 2020-04-24 | Crittenden | Arkansas | 5035 | 167 | 5 |
81360 | 81360 | 2020-04-23 | Crittenden | Arkansas | 5035 | 156 | 5 |
78567 | 78567 | 2020-04-22 | Crittenden | Arkansas | 5035 | 147 | 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);