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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
277763 | 277763 | 2020-06-27 | Crittenden | Arkansas | 5035 | 696 | 11 |
280910 | 280910 | 2020-06-28 | Crittenden | Arkansas | 5035 | 731 | 11 |
284056 | 284056 | 2020-06-29 | Crittenden | Arkansas | 5035 | 737 | 11 |
287202 | 287202 | 2020-06-30 | Crittenden | Arkansas | 5035 | 746 | 12 |
290353 | 290353 | 2020-07-01 | Crittenden | Arkansas | 5035 | 749 | 13 |
293507 | 293507 | 2020-07-02 | Crittenden | Arkansas | 5035 | 759 | 13 |
296663 | 296663 | 2020-07-03 | Crittenden | Arkansas | 5035 | 765 | 13 |
299825 | 299825 | 2020-07-04 | Crittenden | Arkansas | 5035 | 766 | 13 |
302989 | 302989 | 2020-07-05 | Crittenden | Arkansas | 5035 | 766 | 13 |
306153 | 306153 | 2020-07-06 | Crittenden | Arkansas | 5035 | 783 | 13 |
309321 | 309321 | 2020-07-07 | Crittenden | Arkansas | 5035 | 786 | 13 |
312491 | 312491 | 2020-07-08 | Crittenden | Arkansas | 5035 | 799 | 13 |
315666 | 315666 | 2020-07-09 | Crittenden | Arkansas | 5035 | 815 | 13 |
318839 | 318839 | 2020-07-10 | Crittenden | Arkansas | 5035 | 817 | 13 |
322018 | 322018 | 2020-07-11 | Crittenden | Arkansas | 5035 | 833 | 14 |
325199 | 325199 | 2020-07-12 | Crittenden | Arkansas | 5035 | 841 | 14 |
328385 | 328385 | 2020-07-13 | Crittenden | Arkansas | 5035 | 865 | 14 |
331571 | 331571 | 2020-07-14 | Crittenden | Arkansas | 5035 | 879 | 14 |
334764 | 334764 | 2020-07-15 | Crittenden | Arkansas | 5035 | 893 | 14 |
337959 | 337959 | 2020-07-16 | Crittenden | Arkansas | 5035 | 906 | 14 |
341155 | 341155 | 2020-07-17 | Crittenden | Arkansas | 5035 | 916 | 14 |
344354 | 344354 | 2020-07-18 | Crittenden | Arkansas | 5035 | 929 | 14 |
347554 | 347554 | 2020-07-19 | Crittenden | Arkansas | 5035 | 944 | 14 |
350755 | 350755 | 2020-07-20 | Crittenden | Arkansas | 5035 | 957 | 15 |
353957 | 353957 | 2020-07-21 | Crittenden | Arkansas | 5035 | 972 | 15 |
357160 | 357160 | 2020-07-22 | Crittenden | Arkansas | 5035 | 994 | 15 |
360365 | 360365 | 2020-07-23 | Crittenden | Arkansas | 5035 | 1044 | 15 |
363572 | 363572 | 2020-07-24 | Crittenden | Arkansas | 5035 | 1058 | 16 |
366779 | 366779 | 2020-07-25 | Crittenden | Arkansas | 5035 | 1072 | 16 |
369989 | 369989 | 2020-07-26 | Crittenden | Arkansas | 5035 | 1090 | 16 |
373201 | 373201 | 2020-07-27 | Crittenden | Arkansas | 5035 | 1100 | 16 |
376415 | 376415 | 2020-07-28 | Crittenden | Arkansas | 5035 | 1113 | 17 |
379631 | 379631 | 2020-07-29 | Crittenden | Arkansas | 5035 | 1127 | 17 |
382848 | 382848 | 2020-07-30 | Crittenden | Arkansas | 5035 | 1135 | 17 |
386066 | 386066 | 2020-07-31 | Crittenden | Arkansas | 5035 | 1172 | 17 |
389283 | 389283 | 2020-08-01 | Crittenden | Arkansas | 5035 | 1191 | 18 |
392500 | 392500 | 2020-08-02 | Crittenden | Arkansas | 5035 | 1213 | 20 |
395716 | 395716 | 2020-08-03 | Crittenden | Arkansas | 5035 | 1242 | 20 |
398932 | 398932 | 2020-08-04 | Crittenden | Arkansas | 5035 | 1269 | 20 |
402148 | 402148 | 2020-08-05 | Crittenden | Arkansas | 5035 | 1291 | 20 |
405366 | 405366 | 2020-08-06 | Crittenden | Arkansas | 5035 | 1315 | 20 |
408586 | 408586 | 2020-08-07 | Crittenden | Arkansas | 5035 | 1327 | 20 |
411805 | 411805 | 2020-08-08 | Crittenden | Arkansas | 5035 | 1351 | 21 |
415025 | 415025 | 2020-08-09 | Crittenden | Arkansas | 5035 | 1356 | 23 |
418246 | 418246 | 2020-08-10 | Crittenden | Arkansas | 5035 | 1369 | 23 |
421467 | 421467 | 2020-08-11 | Crittenden | Arkansas | 5035 | 1381 | 23 |
424688 | 424688 | 2020-08-12 | Crittenden | Arkansas | 5035 | 1402 | 24 |
427912 | 427912 | 2020-08-13 | Crittenden | Arkansas | 5035 | 1442 | 24 |
431140 | 431140 | 2020-08-14 | Crittenden | Arkansas | 5035 | 1455 | 24 |
434365 | 434365 | 2020-08-15 | Crittenden | Arkansas | 5035 | 1460 | 24 |
437591 | 437591 | 2020-08-16 | Crittenden | Arkansas | 5035 | 1482 | 24 |
440817 | 440817 | 2020-08-17 | Crittenden | Arkansas | 5035 | 1493 | 24 |
444043 | 444043 | 2020-08-18 | Crittenden | Arkansas | 5035 | 1503 | 26 |
447270 | 447270 | 2020-08-19 | Crittenden | Arkansas | 5035 | 1515 | 26 |
450498 | 450498 | 2020-08-20 | Crittenden | Arkansas | 5035 | 1530 | 26 |
453726 | 453726 | 2020-08-21 | Crittenden | Arkansas | 5035 | 1554 | 27 |
456954 | 456954 | 2020-08-22 | Crittenden | Arkansas | 5035 | 1563 | 27 |
460181 | 460181 | 2020-08-23 | Crittenden | Arkansas | 5035 | 1573 | 28 |
463410 | 463410 | 2020-08-24 | Crittenden | Arkansas | 5035 | 1582 | 28 |
466639 | 466639 | 2020-08-25 | Crittenden | Arkansas | 5035 | 1595 | 28 |
469868 | 469868 | 2020-08-26 | Crittenden | Arkansas | 5035 | 1602 | 29 |
473100 | 473100 | 2020-08-27 | Crittenden | Arkansas | 5035 | 1619 | 30 |
476333 | 476333 | 2020-08-28 | Crittenden | Arkansas | 5035 | 1624 | 30 |
479566 | 479566 | 2020-08-29 | Crittenden | Arkansas | 5035 | 1635 | 33 |
482800 | 482800 | 2020-08-30 | Crittenden | Arkansas | 5035 | 1641 | 34 |
486035 | 486035 | 2020-08-31 | Crittenden | Arkansas | 5035 | 1643 | 34 |
489268 | 489268 | 2020-09-01 | Crittenden | Arkansas | 5035 | 1648 | 34 |
492501 | 492501 | 2020-09-02 | Crittenden | Arkansas | 5035 | 1659 | 35 |
495735 | 495735 | 2020-09-03 | Crittenden | Arkansas | 5035 | 1685 | 35 |
498968 | 498968 | 2020-09-04 | Crittenden | Arkansas | 5035 | 1693 | 35 |
502202 | 502202 | 2020-09-05 | Crittenden | Arkansas | 5035 | 1703 | 35 |
505436 | 505436 | 2020-09-06 | Crittenden | Arkansas | 5035 | 1713 | 35 |
508668 | 508668 | 2020-09-07 | Crittenden | Arkansas | 5035 | 1738 | 35 |
511901 | 511901 | 2020-09-08 | Crittenden | Arkansas | 5035 | 1748 | 36 |
515134 | 515134 | 2020-09-09 | Crittenden | Arkansas | 5035 | 1757 | 36 |
518369 | 518369 | 2020-09-10 | Crittenden | Arkansas | 5035 | 1767 | 36 |
521606 | 521606 | 2020-09-11 | Crittenden | Arkansas | 5035 | 1785 | 36 |
524842 | 524842 | 2020-09-12 | Crittenden | Arkansas | 5035 | 1799 | 36 |
528078 | 528078 | 2020-09-13 | Crittenden | Arkansas | 5035 | 1801 | 36 |
531315 | 531315 | 2020-09-14 | Crittenden | Arkansas | 5035 | 1802 | 37 |
534550 | 534550 | 2020-09-15 | Crittenden | Arkansas | 5035 | 1816 | 45 |
537786 | 537786 | 2020-09-16 | Crittenden | Arkansas | 5035 | 1833 | 45 |
541023 | 541023 | 2020-09-17 | Crittenden | Arkansas | 5035 | 1848 | 45 |
544259 | 544259 | 2020-09-18 | Crittenden | Arkansas | 5035 | 1856 | 45 |
547497 | 547497 | 2020-09-19 | Crittenden | Arkansas | 5035 | 1868 | 45 |
550736 | 550736 | 2020-09-20 | Crittenden | Arkansas | 5035 | 1871 | 45 |
553975 | 553975 | 2020-09-21 | Crittenden | Arkansas | 5035 | 1887 | 45 |
557212 | 557212 | 2020-09-22 | Crittenden | Arkansas | 5035 | 1895 | 45 |
560448 | 560448 | 2020-09-23 | Crittenden | Arkansas | 5035 | 1903 | 45 |
563687 | 563687 | 2020-09-24 | Crittenden | Arkansas | 5035 | 1917 | 46 |
566927 | 566927 | 2020-09-25 | Crittenden | Arkansas | 5035 | 1923 | 46 |
570169 | 570169 | 2020-09-26 | Crittenden | Arkansas | 5035 | 1944 | 46 |
573411 | 573411 | 2020-09-27 | Crittenden | Arkansas | 5035 | 1945 | 46 |
576654 | 576654 | 2020-09-28 | Crittenden | Arkansas | 5035 | 1948 | 46 |
579895 | 579895 | 2020-09-29 | Crittenden | Arkansas | 5035 | 1959 | 46 |
583134 | 583134 | 2020-09-30 | Crittenden | Arkansas | 5035 | 1970 | 46 |
586374 | 586374 | 2020-10-01 | Crittenden | Arkansas | 5035 | 1983 | 46 |
589615 | 589615 | 2020-10-02 | Crittenden | Arkansas | 5035 | 1997 | 46 |
592855 | 592855 | 2020-10-03 | Crittenden | Arkansas | 5035 | 2005 | 46 |
596097 | 596097 | 2020-10-04 | Crittenden | Arkansas | 5035 | 2007 | 48 |
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);