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-09-07 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 |
---|---|---|---|---|---|---|---|
1693268 | 1693268 | 2021-09-07 | Arkansas | Arkansas | 5001 | 3191 | 54 |
1693269 | 1693269 | 2021-09-07 | Ashley | Arkansas | 5003 | 2828 | 39 |
1693270 | 1693270 | 2021-09-07 | Baxter | Arkansas | 5005 | 5464 | 155 |
1693271 | 1693271 | 2021-09-07 | Benton | Arkansas | 5007 | 38482 | 529 |
1693272 | 1693272 | 2021-09-07 | Boone | Arkansas | 5009 | 5711 | 103 |
1693273 | 1693273 | 2021-09-07 | Bradley | Arkansas | 5011 | 1832 | 36 |
1693274 | 1693274 | 2021-09-07 | Calhoun | Arkansas | 5013 | 543 | 7 |
1693275 | 1693275 | 2021-09-07 | Carroll | Arkansas | 5015 | 3988 | 61 |
1693276 | 1693276 | 2021-09-07 | Chicot | Arkansas | 5017 | 1876 | 42 |
1693277 | 1693277 | 2021-09-07 | Clark | Arkansas | 5019 | 2918 | 47 |
1693278 | 1693278 | 2021-09-07 | Clay | Arkansas | 5021 | 2360 | 52 |
1693279 | 1693279 | 2021-09-07 | Cleburne | Arkansas | 5023 | 3256 | 83 |
1693280 | 1693280 | 2021-09-07 | Cleveland | Arkansas | 5025 | 1289 | 29 |
1693281 | 1693281 | 2021-09-07 | Columbia | Arkansas | 5027 | 3089 | 61 |
1693282 | 1693282 | 2021-09-07 | Conway | Arkansas | 5029 | 2867 | 41 |
1693283 | 1693283 | 2021-09-07 | Craighead | Arkansas | 5031 | 19167 | 212 |
1693284 | 1693284 | 2021-09-07 | Crawford | Arkansas | 5033 | 9384 | 146 |
1693285 | 1693285 | 2021-09-07 | Crittenden | Arkansas | 5035 | 7827 | 112 |
1693286 | 1693286 | 2021-09-07 | Cross | Arkansas | 5037 | 2597 | 58 |
1693287 | 1693287 | 2021-09-07 | Dallas | Arkansas | 5039 | 1075 | 18 |
1693288 | 1693288 | 2021-09-07 | Desha | Arkansas | 5041 | 1720 | 26 |
1693289 | 1693289 | 2021-09-07 | Drew | Arkansas | 5043 | 2596 | 53 |
1693290 | 1693290 | 2021-09-07 | Faulkner | Arkansas | 5045 | 18023 | 195 |
1693291 | 1693291 | 2021-09-07 | Franklin | Arkansas | 5047 | 2437 | 46 |
1693292 | 1693292 | 2021-09-07 | Fulton | Arkansas | 5049 | 1538 | 52 |
1693293 | 1693293 | 2021-09-07 | Garland | Arkansas | 5051 | 14847 | 343 |
1693294 | 1693294 | 2021-09-07 | Grant | Arkansas | 5053 | 2672 | 45 |
1693295 | 1693295 | 2021-09-07 | Greene | Arkansas | 5055 | 8756 | 97 |
1693296 | 1693296 | 2021-09-07 | Hempstead | Arkansas | 5057 | 2647 | 22 |
1693297 | 1693297 | 2021-09-07 | Hot Spring | Arkansas | 5059 | 7084 | 102 |
1693298 | 1693298 | 2021-09-07 | Howard | Arkansas | 5061 | 2182 | 28 |
1693299 | 1693299 | 2021-09-07 | Independence | Arkansas | 5063 | 5409 | 145 |
1693300 | 1693300 | 2021-09-07 | Izard | Arkansas | 5065 | 2233 | 53 |
1693301 | 1693301 | 2021-09-07 | Jackson | Arkansas | 5067 | 3826 | 41 |
1693302 | 1693302 | 2021-09-07 | Jefferson | Arkansas | 5069 | 11837 | 208 |
1693303 | 1693303 | 2021-09-07 | Johnson | Arkansas | 5071 | 4077 | 51 |
1693304 | 1693304 | 2021-09-07 | Lafayette | Arkansas | 5073 | 755 | 11 |
1693305 | 1693305 | 2021-09-07 | Lawrence | Arkansas | 5075 | 2838 | 47 |
1693306 | 1693306 | 2021-09-07 | Lee | Arkansas | 5077 | 1953 | 40 |
1693307 | 1693307 | 2021-09-07 | Lincoln | Arkansas | 5079 | 3577 | 55 |
1693308 | 1693308 | 2021-09-07 | Little River | Arkansas | 5081 | 1747 | 44 |
1693309 | 1693309 | 2021-09-07 | Logan | Arkansas | 5083 | 3175 | 33 |
1693310 | 1693310 | 2021-09-07 | Lonoke | Arkansas | 5085 | 10942 | 161 |
1693311 | 1693311 | 2021-09-07 | Madison | Arkansas | 5087 | 2219 | 33 |
1693312 | 1693312 | 2021-09-07 | Marion | Arkansas | 5089 | 1940 | 52 |
1693313 | 1693313 | 2021-09-07 | Miller | Arkansas | 5091 | 5606 | 39 |
1693314 | 1693314 | 2021-09-07 | Mississippi | Arkansas | 5093 | 7239 | 118 |
1693315 | 1693315 | 2021-09-07 | Monroe | Arkansas | 5095 | 1103 | 21 |
1693316 | 1693316 | 2021-09-07 | Montgomery | Arkansas | 5097 | 1035 | 34 |
1693317 | 1693317 | 2021-09-07 | Nevada | Arkansas | 5099 | 1133 | 29 |
1693318 | 1693318 | 2021-09-07 | Newton | Arkansas | 5101 | 1101 | 29 |
1693319 | 1693319 | 2021-09-07 | Ouachita | Arkansas | 5103 | 3195 | 68 |
1693320 | 1693320 | 2021-09-07 | Perry | Arkansas | 5105 | 1364 | 15 |
1693321 | 1693321 | 2021-09-07 | Phillips | Arkansas | 5107 | 2861 | 60 |
1693322 | 1693322 | 2021-09-07 | Pike | Arkansas | 5109 | 1497 | 32 |
1693323 | 1693323 | 2021-09-07 | Poinsett | Arkansas | 5111 | 4366 | 92 |
1693324 | 1693324 | 2021-09-07 | Polk | Arkansas | 5113 | 2638 | 90 |
1693325 | 1693325 | 2021-09-07 | Pope | Arkansas | 5115 | 10939 | 137 |
1693326 | 1693326 | 2021-09-07 | Prairie | Arkansas | 5117 | 1217 | 27 |
1693327 | 1693327 | 2021-09-07 | Pulaski | Arkansas | 5119 | 54989 | 819 |
1693328 | 1693328 | 2021-09-07 | Randolph | Arkansas | 5121 | 2799 | 50 |
1693329 | 1693329 | 2021-09-07 | Saline | Arkansas | 5125 | 17157 | 216 |
1693330 | 1693330 | 2021-09-07 | Scott | Arkansas | 5127 | 1356 | 19 |
1693331 | 1693331 | 2021-09-07 | Searcy | Arkansas | 5129 | 1163 | 20 |
1693332 | 1693332 | 2021-09-07 | Sebastian | Arkansas | 5131 | 20109 | 312 |
1693333 | 1693333 | 2021-09-07 | Sevier | Arkansas | 5133 | 3429 | 31 |
1693334 | 1693334 | 2021-09-07 | Sharp | Arkansas | 5135 | 2386 | 58 |
1693335 | 1693335 | 2021-09-07 | St. Francis | Arkansas | 5123 | 4367 | 53 |
1693336 | 1693336 | 2021-09-07 | Stone | Arkansas | 5137 | 1486 | 38 |
1693337 | 1693337 | 2021-09-07 | Union | Arkansas | 5139 | 5040 | 120 |
1693338 | 1693338 | 2021-09-07 | Unknown | Arkansas | 4906 | 0 | |
1693339 | 1693339 | 2021-09-07 | Van Buren | Arkansas | 5141 | 1886 | 35 |
1693340 | 1693340 | 2021-09-07 | Washington | Arkansas | 5143 | 40951 | 419 |
1693341 | 1693341 | 2021-09-07 | White | Arkansas | 5145 | 12023 | 167 |
1693342 | 1693342 | 2021-09-07 | Woodruff | Arkansas | 5147 | 960 | 19 |
1693343 | 1693343 | 2021-09-07 | Yell | Arkansas | 5149 | 4240 | 73 |
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);