ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
76 rows where "date" is on date 2021-06-09 and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 76
- 5001 1
- 5003 1
- 5005 1
- 5007 1
- 5009 1
- 5011 1
- 5013 1
- 5015 1
- 5017 1
- 5019 1
- 5021 1
- 5023 1
- 5025 1
- 5027 1
- 5029 1
- 5031 1
- 5033 1
- 5035 1
- 5037 1
- 5039 1
- 5041 1
- 5043 1
- 5045 1
- 5047 1
- 5049 1
- 5051 1
- 5053 1
- 5055 1
- 5057 1
- 5059 1
- 5061 1
- 5063 1
- 5065 1
- 5067 1
- 5069 1
- 5071 1
- 5073 1
- 5075 1
- 5077 1
- 5079 1
- 5081 1
- 5083 1
- 5085 1
- 5087 1
- 5089 1
- 5091 1
- 5093 1
- 5095 1
- 5097 1
- 5099 1
- 5101 1
- 5103 1
- 5105 1
- 5107 1
- 5109 1
- 5111 1
- 5113 1
- 5115 1
- 5117 1
- 5119 1
- 5121 1
- 5123 1
- 5125 1
- 5127 1
- 5129 1
- 5131 1
- 5133 1
- 5135 1
- 5137 1
- 5139 1
- 5141 1
- 5143 1
- 5145 1
- 5147 1
- 5149 1
- - 1
county 76
- Arkansas 1
- Ashley 1
- Baxter 1
- Benton 1
- Boone 1
- Bradley 1
- Calhoun 1
- Carroll 1
- Chicot 1
- Clark 1
- Clay 1
- Cleburne 1
- Cleveland 1
- Columbia 1
- Conway 1
- Craighead 1
- Crawford 1
- Crittenden 1
- Cross 1
- Dallas 1
- Desha 1
- Drew 1
- Faulkner 1
- Franklin 1
- Fulton 1
- Garland 1
- Grant 1
- Greene 1
- Hempstead 1
- Hot Spring 1
- Howard 1
- Independence 1
- Izard 1
- Jackson 1
- Jefferson 1
- Johnson 1
- Lafayette 1
- Lawrence 1
- Lee 1
- Lincoln 1
- Little River 1
- Logan 1
- Lonoke 1
- Madison 1
- Marion 1
- Miller 1
- Mississippi 1
- Monroe 1
- Montgomery 1
- Nevada 1
- Newton 1
- Ouachita 1
- Perry 1
- Phillips 1
- Pike 1
- Poinsett 1
- Polk 1
- Pope 1
- Prairie 1
- Pulaski 1
- Randolph 1
- Saline 1
- Scott 1
- Searcy 1
- Sebastian 1
- Sevier 1
- Sharp 1
- St. Francis 1
- Stone 1
- Union 1
- Unknown 1
- Van Buren 1
- Washington 1
- White 1
- Woodruff 1
- Yell 1
state 1
- Arkansas · 76 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1401013 | 1401013 | 2021-06-09 | Arkansas | Arkansas | 5001 | 2145 | 37 |
1401014 | 1401014 | 2021-06-09 | Ashley | Arkansas | 5003 | 2046 | 35 |
1401015 | 1401015 | 2021-06-09 | Baxter | Arkansas | 5005 | 3214 | 104 |
1401016 | 1401016 | 2021-06-09 | Benton | Arkansas | 5007 | 29501 | 420 |
1401017 | 1401017 | 2021-06-09 | Boone | Arkansas | 5009 | 3904 | 80 |
1401018 | 1401018 | 2021-06-09 | Bradley | Arkansas | 5011 | 1439 | 32 |
1401019 | 1401019 | 2021-06-09 | Calhoun | Arkansas | 5013 | 415 | 3 |
1401020 | 1401020 | 2021-06-09 | Carroll | Arkansas | 5015 | 2826 | 46 |
1401021 | 1401021 | 2021-06-09 | Chicot | Arkansas | 5017 | 1623 | 41 |
1401022 | 1401022 | 2021-06-09 | Clark | Arkansas | 5019 | 2132 | 41 |
1401023 | 1401023 | 2021-06-09 | Clay | Arkansas | 5021 | 1794 | 52 |
1401024 | 1401024 | 2021-06-09 | Cleburne | Arkansas | 5023 | 2032 | 74 |
1401025 | 1401025 | 2021-06-09 | Cleveland | Arkansas | 5025 | 970 | 25 |
1401026 | 1401026 | 2021-06-09 | Columbia | Arkansas | 5027 | 2371 | 56 |
1401027 | 1401027 | 2021-06-09 | Conway | Arkansas | 5029 | 2250 | 33 |
1401028 | 1401028 | 2021-06-09 | Craighead | Arkansas | 5031 | 13657 | 183 |
1401029 | 1401029 | 2021-06-09 | Crawford | Arkansas | 5033 | 7153 | 119 |
1401030 | 1401030 | 2021-06-09 | Crittenden | Arkansas | 5035 | 6159 | 97 |
1401031 | 1401031 | 2021-06-09 | Cross | Arkansas | 5037 | 1968 | 50 |
1401032 | 1401032 | 2021-06-09 | Dallas | Arkansas | 5039 | 765 | 15 |
1401033 | 1401033 | 2021-06-09 | Desha | Arkansas | 5041 | 1371 | 23 |
1401034 | 1401034 | 2021-06-09 | Drew | Arkansas | 5043 | 2027 | 45 |
1401035 | 1401035 | 2021-06-09 | Faulkner | Arkansas | 5045 | 12869 | 164 |
1401036 | 1401036 | 2021-06-09 | Franklin | Arkansas | 5047 | 1708 | 40 |
1401037 | 1401037 | 2021-06-09 | Fulton | Arkansas | 5049 | 1153 | 47 |
1401038 | 1401038 | 2021-06-09 | Garland | Arkansas | 5051 | 10367 | 263 |
1401039 | 1401039 | 2021-06-09 | Grant | Arkansas | 5053 | 1714 | 33 |
1401040 | 1401040 | 2021-06-09 | Greene | Arkansas | 5055 | 6192 | 77 |
1401041 | 1401041 | 2021-06-09 | Hempstead | Arkansas | 5057 | 2018 | 20 |
1401042 | 1401042 | 2021-06-09 | Hot Spring | Arkansas | 5059 | 5215 | 74 |
1401043 | 1401043 | 2021-06-09 | Howard | Arkansas | 5061 | 1668 | 25 |
1401044 | 1401044 | 2021-06-09 | Independence | Arkansas | 5063 | 3828 | 124 |
1401045 | 1401045 | 2021-06-09 | Izard | Arkansas | 5065 | 1692 | 42 |
1401046 | 1401046 | 2021-06-09 | Jackson | Arkansas | 5067 | 3232 | 38 |
1401047 | 1401047 | 2021-06-09 | Jefferson | Arkansas | 5069 | 9023 | 170 |
1401048 | 1401048 | 2021-06-09 | Johnson | Arkansas | 5071 | 2947 | 38 |
1401049 | 1401049 | 2021-06-09 | Lafayette | Arkansas | 5073 | 555 | 9 |
1401050 | 1401050 | 2021-06-09 | Lawrence | Arkansas | 5075 | 2137 | 43 |
1401051 | 1401051 | 2021-06-09 | Lee | Arkansas | 5077 | 1700 | 37 |
1401052 | 1401052 | 2021-06-09 | Lincoln | Arkansas | 5079 | 3216 | 48 |
1401053 | 1401053 | 2021-06-09 | Little River | Arkansas | 5081 | 1255 | 42 |
1401054 | 1401054 | 2021-06-09 | Logan | Arkansas | 5083 | 2260 | 25 |
1401055 | 1401055 | 2021-06-09 | Lonoke | Arkansas | 5085 | 7537 | 123 |
1401056 | 1401056 | 2021-06-09 | Madison | Arkansas | 5087 | 1466 | 23 |
1401057 | 1401057 | 2021-06-09 | Marion | Arkansas | 5089 | 1073 | 30 |
1401058 | 1401058 | 2021-06-09 | Miller | Arkansas | 5091 | 4419 | 38 |
1401059 | 1401059 | 2021-06-09 | Mississippi | Arkansas | 5093 | 5907 | 110 |
1401060 | 1401060 | 2021-06-09 | Monroe | Arkansas | 5095 | 873 | 17 |
1401061 | 1401061 | 2021-06-09 | Montgomery | Arkansas | 5097 | 759 | 33 |
1401062 | 1401062 | 2021-06-09 | Nevada | Arkansas | 5099 | 833 | 24 |
1401063 | 1401063 | 2021-06-09 | Newton | Arkansas | 5101 | 734 | 26 |
1401064 | 1401064 | 2021-06-09 | Ouachita | Arkansas | 5103 | 2370 | 63 |
1401065 | 1401065 | 2021-06-09 | Perry | Arkansas | 5105 | 848 | 10 |
1401066 | 1401066 | 2021-06-09 | Phillips | Arkansas | 5107 | 1858 | 43 |
1401067 | 1401067 | 2021-06-09 | Pike | Arkansas | 5109 | 1018 | 22 |
1401068 | 1401068 | 2021-06-09 | Poinsett | Arkansas | 5111 | 3187 | 77 |
1401069 | 1401069 | 2021-06-09 | Polk | Arkansas | 5113 | 2013 | 74 |
1401070 | 1401070 | 2021-06-09 | Pope | Arkansas | 5115 | 8102 | 110 |
1401071 | 1401071 | 2021-06-09 | Prairie | Arkansas | 5117 | 911 | 21 |
1401072 | 1401072 | 2021-06-09 | Pulaski | Arkansas | 5119 | 40063 | 669 |
1401073 | 1401073 | 2021-06-09 | Randolph | Arkansas | 5121 | 2191 | 47 |
1401074 | 1401074 | 2021-06-09 | Saline | Arkansas | 5125 | 12239 | 173 |
1401075 | 1401075 | 2021-06-09 | Scott | Arkansas | 5127 | 946 | 14 |
1401076 | 1401076 | 2021-06-09 | Searcy | Arkansas | 5129 | 722 | 18 |
1401077 | 1401077 | 2021-06-09 | Sebastian | Arkansas | 5131 | 15382 | 283 |
1401078 | 1401078 | 2021-06-09 | Sevier | Arkansas | 5133 | 2811 | 24 |
1401079 | 1401079 | 2021-06-09 | Sharp | Arkansas | 5135 | 1620 | 47 |
1401080 | 1401080 | 2021-06-09 | St. Francis | Arkansas | 5123 | 3618 | 44 |
1401081 | 1401081 | 2021-06-09 | Stone | Arkansas | 5137 | 997 | 30 |
1401082 | 1401082 | 2021-06-09 | Union | Arkansas | 5139 | 4072 | 115 |
1401083 | 1401083 | 2021-06-09 | Unknown | Arkansas | 2923 | 0 | |
1401084 | 1401084 | 2021-06-09 | Van Buren | Arkansas | 5141 | 1361 | 24 |
1401085 | 1401085 | 2021-06-09 | Washington | Arkansas | 5143 | 31283 | 352 |
1401086 | 1401086 | 2021-06-09 | White | Arkansas | 5145 | 8180 | 121 |
1401087 | 1401087 | 2021-06-09 | Woodruff | Arkansas | 5147 | 651 | 14 |
1401088 | 1401088 | 2021-06-09 | Yell | Arkansas | 5149 | 3449 | 65 |
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);