ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

43,072 rows where state = "Arkansas" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Arkansas · 43,072 ✖
Link rowid date ▲ county state fips cases deaths
1816725 1816725 2021-10-15 Arkansas Arkansas 5001 3444 59
1816726 1816726 2021-10-15 Ashley Arkansas 5003 3147 48
1816727 1816727 2021-10-15 Baxter Arkansas 5005 5762 175
1816728 1816728 2021-10-15 Benton Arkansas 5007 41546 591
1816729 1816729 2021-10-15 Boone Arkansas 5009 6153 126
1816730 1816730 2021-10-15 Bradley Arkansas 5011 1942 41
1816731 1816731 2021-10-15 Calhoun Arkansas 5013 590 7
1816732 1816732 2021-10-15 Carroll Arkansas 5015 4251 73
1816733 1816733 2021-10-15 Chicot Arkansas 5017 2006 44
1816734 1816734 2021-10-15 Clark Arkansas 5019 3180 54
1816735 1816735 2021-10-15 Clay Arkansas 5021 2679 66
1816736 1816736 2021-10-15 Cleburne Arkansas 5023 3657 89
1816737 1816737 2021-10-15 Cleveland Arkansas 5025 1397 32
1816738 1816738 2021-10-15 Columbia Arkansas 5027 3356 72
1816739 1816739 2021-10-15 Conway Arkansas 5029 3119 43
1816740 1816740 2021-10-15 Craighead Arkansas 5031 21295 241
1816741 1816741 2021-10-15 Crawford Arkansas 5033 10584 171
1816742 1816742 2021-10-15 Crittenden Arkansas 5035 8702 166
1816743 1816743 2021-10-15 Cross Arkansas 5037 2920 64
1816744 1816744 2021-10-15 Dallas Arkansas 5039 1128 19
1816745 1816745 2021-10-15 Desha Arkansas 5041 1884 32
1816746 1816746 2021-10-15 Drew Arkansas 5043 2856 54
1816747 1816747 2021-10-15 Faulkner Arkansas 5045 19335 219
1816748 1816748 2021-10-15 Franklin Arkansas 5047 2702 51
1816749 1816749 2021-10-15 Fulton Arkansas 5049 1673 62
1816750 1816750 2021-10-15 Garland Arkansas 5051 15841 382
1816751 1816751 2021-10-15 Grant Arkansas 5053 2861 47
1816752 1816752 2021-10-15 Greene Arkansas 5055 9954 121
1816753 1816753 2021-10-15 Hempstead Arkansas 5057 2896 38
1816754 1816754 2021-10-15 Hot Spring Arkansas 5059 7525 105
1816755 1816755 2021-10-15 Howard Arkansas 5061 2392 35
1816756 1816756 2021-10-15 Independence Arkansas 5063 6232 156
1816757 1816757 2021-10-15 Izard Arkansas 5065 2489 54
1816758 1816758 2021-10-15 Jackson Arkansas 5067 4140 42
1816759 1816759 2021-10-15 Jefferson Arkansas 5069 12276 227
1816760 1816760 2021-10-15 Johnson Arkansas 5071 4552 55
1816761 1816761 2021-10-15 Lafayette Arkansas 5073 839 26
1816762 1816762 2021-10-15 Lawrence Arkansas 5075 3229 56
1816763 1816763 2021-10-15 Lee Arkansas 5077 2072 48
1816764 1816764 2021-10-15 Lincoln Arkansas 5079 3637 57
1816765 1816765 2021-10-15 Little River Arkansas 5081 1996 71
1816766 1816766 2021-10-15 Logan Arkansas 5083 3583 42
1816767 1816767 2021-10-15 Lonoke Arkansas 5085 11814 174
1816768 1816768 2021-10-15 Madison Arkansas 5087 2455 37
1816769 1816769 2021-10-15 Marion Arkansas 5089 2114 57
1816770 1816770 2021-10-15 Miller Arkansas 5091 6376 116
1816771 1816771 2021-10-15 Mississippi Arkansas 5093 8222 137
1816772 1816772 2021-10-15 Monroe Arkansas 5095 1186 24
1816773 1816773 2021-10-15 Montgomery Arkansas 5097 1108 44
1816774 1816774 2021-10-15 Nevada Arkansas 5099 1342 38
1816775 1816775 2021-10-15 Newton Arkansas 5101 1165 36
1816776 1816776 2021-10-15 Ouachita Arkansas 5103 3380 83
1816777 1816777 2021-10-15 Perry Arkansas 5105 1501 21
1816778 1816778 2021-10-15 Phillips Arkansas 5107 3171 76
1816779 1816779 2021-10-15 Pike Arkansas 5109 1686 35
1816780 1816780 2021-10-15 Poinsett Arkansas 5111 4866 98
1816781 1816781 2021-10-15 Polk Arkansas 5113 2961 108
1816782 1816782 2021-10-15 Pope Arkansas 5115 11839 153
1816783 1816783 2021-10-15 Prairie Arkansas 5117 1274 29
1816784 1816784 2021-10-15 Pulaski Arkansas 5119 58220 896
1816785 1816785 2021-10-15 Randolph Arkansas 5121 3272 55
1816786 1816786 2021-10-15 Saline Arkansas 5125 18366 241
1816787 1816787 2021-10-15 Scott Arkansas 5127 1704 29
1816788 1816788 2021-10-15 Searcy Arkansas 5129 1237 24
1816789 1816789 2021-10-15 Sebastian Arkansas 5131 22063 365
1816790 1816790 2021-10-15 Sevier Arkansas 5133 3805 50
1816791 1816791 2021-10-15 Sharp Arkansas 5135 2808 66
1816792 1816792 2021-10-15 St. Francis Arkansas 5123 4771 66
1816793 1816793 2021-10-15 Stone Arkansas 5137 1690 41
1816794 1816794 2021-10-15 Union Arkansas 5139 5668 135
1816795 1816795 2021-10-15 Unknown Arkansas   5109 0
1816796 1816796 2021-10-15 Van Buren Arkansas 5141 2166 39
1816797 1816797 2021-10-15 Washington Arkansas 5143 44127 468
1816798 1816798 2021-10-15 White Arkansas 5145 13037 189
1816799 1816799 2021-10-15 Woodruff Arkansas 5147 1079 24
1816800 1816800 2021-10-15 Yell Arkansas 5149 4607 77
1813477 1813477 2021-10-14 Arkansas Arkansas 5001 3441 59
1813478 1813478 2021-10-14 Ashley Arkansas 5003 3145 48
1813479 1813479 2021-10-14 Baxter Arkansas 5005 5758 174
1813480 1813480 2021-10-14 Benton Arkansas 5007 41490 590
1813481 1813481 2021-10-14 Boone Arkansas 5009 6147 126
1813482 1813482 2021-10-14 Bradley Arkansas 5011 1943 41
1813483 1813483 2021-10-14 Calhoun Arkansas 5013 590 7
1813484 1813484 2021-10-14 Carroll Arkansas 5015 4245 73
1813485 1813485 2021-10-14 Chicot Arkansas 5017 2006 44
1813486 1813486 2021-10-14 Clark Arkansas 5019 3174 54
1813487 1813487 2021-10-14 Clay Arkansas 5021 2678 66
1813488 1813488 2021-10-14 Cleburne Arkansas 5023 3649 89
1813489 1813489 2021-10-14 Cleveland Arkansas 5025 1388 32
1813490 1813490 2021-10-14 Columbia Arkansas 5027 3352 72
1813491 1813491 2021-10-14 Conway Arkansas 5029 3117 43
1813492 1813492 2021-10-14 Craighead Arkansas 5031 21265 241
1813493 1813493 2021-10-14 Crawford Arkansas 5033 10577 171
1813494 1813494 2021-10-14 Crittenden Arkansas 5035 8692 166
1813495 1813495 2021-10-14 Cross Arkansas 5037 2911 64
1813496 1813496 2021-10-14 Dallas Arkansas 5039 1128 19
1813497 1813497 2021-10-14 Desha Arkansas 5041 1882 32
1813498 1813498 2021-10-14 Drew Arkansas 5043 2854 54
1813499 1813499 2021-10-14 Faulkner Arkansas 5045 19319 219
1813500 1813500 2021-10-14 Franklin Arkansas 5047 2698 51

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);