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

26,200 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 · 26,200 ✖
Link rowid date ▲ county state fips cases deaths
1095809 1095809 2021-03-07 Arkansas Arkansas 5001 2005 33
1095810 1095810 2021-03-07 Ashley Arkansas 5003 1849 29
1095811 1095811 2021-03-07 Baxter Arkansas 5005 2911 95
1095812 1095812 2021-03-07 Benton Arkansas 5007 27508 382
1095813 1095813 2021-03-07 Boone Arkansas 5009 3672 75
1095814 1095814 2021-03-07 Bradley Arkansas 5011 1325 30
1095815 1095815 2021-03-07 Calhoun Arkansas 5013 401 2
1095816 1095816 2021-03-07 Carroll Arkansas 5015 2728 42
1095817 1095817 2021-03-07 Chicot Arkansas 5017 1592 38
1095818 1095818 2021-03-07 Clark Arkansas 5019 2057 38
1095819 1095819 2021-03-07 Clay Arkansas 5021 1701 48
1095820 1095820 2021-03-07 Cleburne Arkansas 5023 1895 66
1095821 1095821 2021-03-07 Cleveland Arkansas 5025 928 24
1095822 1095822 2021-03-07 Columbia Arkansas 5027 2282 53
1095823 1095823 2021-03-07 Conway Arkansas 5029 2159 30
1095824 1095824 2021-03-07 Craighead Arkansas 5031 12918 169
1095825 1095825 2021-03-07 Crawford Arkansas 5033 6845 103
1095826 1095826 2021-03-07 Crittenden Arkansas 5035 5791 91
1095827 1095827 2021-03-07 Cross Arkansas 5037 1901 47
1095828 1095828 2021-03-07 Dallas Arkansas 5039 744 12
1095829 1095829 2021-03-07 Desha Arkansas 5041 1341 23
1095830 1095830 2021-03-07 Drew Arkansas 5043 1955 36
1095831 1095831 2021-03-07 Faulkner Arkansas 5045 11872 150
1095832 1095832 2021-03-07 Franklin Arkansas 5047 1643 38
1095833 1095833 2021-03-07 Fulton Arkansas 5049 1083 46
1095834 1095834 2021-03-07 Garland Arkansas 5051 9818 233
1095835 1095835 2021-03-07 Grant Arkansas 5053 1596 32
1095836 1095836 2021-03-07 Greene Arkansas 5055 5924 72
1095837 1095837 2021-03-07 Hempstead Arkansas 5057 1936 19
1095838 1095838 2021-03-07 Hot Spring Arkansas 5059 4903 66
1095839 1095839 2021-03-07 Howard Arkansas 5061 1605 23
1095840 1095840 2021-03-07 Independence Arkansas 5063 3679 118
1095841 1095841 2021-03-07 Izard Arkansas 5065 1641 41
1095842 1095842 2021-03-07 Jackson Arkansas 5067 3182 36
1095843 1095843 2021-03-07 Jefferson Arkansas 5069 8643 161
1095844 1095844 2021-03-07 Johnson Arkansas 5071 2800 31
1095845 1095845 2021-03-07 Lafayette Arkansas 5073 538 8
1095846 1095846 2021-03-07 Lawrence Arkansas 5075 2055 41
1095847 1095847 2021-03-07 Lee Arkansas 5077 1646 34
1095848 1095848 2021-03-07 Lincoln Arkansas 5079 3158 44
1095849 1095849 2021-03-07 Little River Arkansas 5081 1187 39
1095850 1095850 2021-03-07 Logan Arkansas 5083 2187 19
1095851 1095851 2021-03-07 Lonoke Arkansas 5085 6905 108
1095852 1095852 2021-03-07 Madison Arkansas 5087 1411 21
1095853 1095853 2021-03-07 Marion Arkansas 5089 981 29
1095854 1095854 2021-03-07 Miller Arkansas 5091 4077 32
1095855 1095855 2021-03-07 Mississippi Arkansas 5093 5688 105
1095856 1095856 2021-03-07 Monroe Arkansas 5095 837 16
1095857 1095857 2021-03-07 Montgomery Arkansas 5097 739 30
1095858 1095858 2021-03-07 Nevada Arkansas 5099 797 23
1095859 1095859 2021-03-07 Newton Arkansas 5101 696 26
1095860 1095860 2021-03-07 Ouachita Arkansas 5103 2239 52
1095861 1095861 2021-03-07 Perry Arkansas 5105 801 9
1095862 1095862 2021-03-07 Phillips Arkansas 5107 1717 35
1095863 1095863 2021-03-07 Pike Arkansas 5109 981 22
1095864 1095864 2021-03-07 Poinsett Arkansas 5111 3086 75
1095865 1095865 2021-03-07 Polk Arkansas 5113 1913 66
1095866 1095866 2021-03-07 Pope Arkansas 5115 7776 99
1095867 1095867 2021-03-07 Prairie Arkansas 5117 880 21
1095868 1095868 2021-03-07 Pulaski Arkansas 5119 37642 573
1095869 1095869 2021-03-07 Randolph Arkansas 5121 2018 45
1095870 1095870 2021-03-07 Saline Arkansas 5125 11512 158
1095871 1095871 2021-03-07 Scott Arkansas 5127 921 14
1095872 1095872 2021-03-07 Searcy Arkansas 5129 665 15
1095873 1095873 2021-03-07 Sebastian Arkansas 5131 14728 260
1095874 1095874 2021-03-07 Sevier Arkansas 5133 2731 25
1095875 1095875 2021-03-07 Sharp Arkansas 5135 1529 45
1095876 1095876 2021-03-07 St. Francis Arkansas 5123 3456 36
1095877 1095877 2021-03-07 Stone Arkansas 5137 971 29
1095878 1095878 2021-03-07 Union Arkansas 5139 3777 101
1095879 1095879 2021-03-07 Unknown Arkansas   3284 0
1095880 1095880 2021-03-07 Van Buren Arkansas 5141 1215 21
1095881 1095881 2021-03-07 Washington Arkansas 5143 29603 329
1095882 1095882 2021-03-07 White Arkansas 5145 7626 108
1095883 1095883 2021-03-07 Woodruff Arkansas 5147 626 11
1095884 1095884 2021-03-07 Yell Arkansas 5149 3386 63
1092563 1092563 2021-03-06 Arkansas Arkansas 5001 2005 33
1092564 1092564 2021-03-06 Ashley Arkansas 5003 1847 29
1092565 1092565 2021-03-06 Baxter Arkansas 5005 2909 94
1092566 1092566 2021-03-06 Benton Arkansas 5007 27477 382
1092567 1092567 2021-03-06 Boone Arkansas 5009 3670 75
1092568 1092568 2021-03-06 Bradley Arkansas 5011 1324 30
1092569 1092569 2021-03-06 Calhoun Arkansas 5013 401 2
1092570 1092570 2021-03-06 Carroll Arkansas 5015 2728 42
1092571 1092571 2021-03-06 Chicot Arkansas 5017 1592 38
1092572 1092572 2021-03-06 Clark Arkansas 5019 2057 38
1092573 1092573 2021-03-06 Clay Arkansas 5021 1700 48
1092574 1092574 2021-03-06 Cleburne Arkansas 5023 1894 64
1092575 1092575 2021-03-06 Cleveland Arkansas 5025 928 24
1092576 1092576 2021-03-06 Columbia Arkansas 5027 2281 53
1092577 1092577 2021-03-06 Conway Arkansas 5029 2159 30
1092578 1092578 2021-03-06 Craighead Arkansas 5031 12910 169
1092579 1092579 2021-03-06 Crawford Arkansas 5033 6838 103
1092580 1092580 2021-03-06 Crittenden Arkansas 5035 5787 91
1092581 1092581 2021-03-06 Cross Arkansas 5037 1901 47
1092582 1092582 2021-03-06 Dallas Arkansas 5039 744 12
1092583 1092583 2021-03-06 Desha Arkansas 5041 1339 22
1092584 1092584 2021-03-06 Drew Arkansas 5043 1955 35
1092585 1092585 2021-03-06 Faulkner Arkansas 5045 11863 150
1092586 1092586 2021-03-06 Franklin Arkansas 5047 1640 37

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