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 2022-01-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 |
---|---|---|---|---|---|---|---|
2096236 | 2096236 | 2022-01-09 | Arkansas | Arkansas | 5001 | 4030 | 65 |
2096237 | 2096237 | 2022-01-09 | Ashley | Arkansas | 5003 | 3584 | 56 |
2096238 | 2096238 | 2022-01-09 | Baxter | Arkansas | 5005 | 6933 | 206 |
2096239 | 2096239 | 2022-01-09 | Benton | Arkansas | 5007 | 49528 | 700 |
2096240 | 2096240 | 2022-01-09 | Boone | Arkansas | 5009 | 7295 | 142 |
2096241 | 2096241 | 2022-01-09 | Bradley | Arkansas | 5011 | 2160 | 43 |
2096242 | 2096242 | 2022-01-09 | Calhoun | Arkansas | 5013 | 675 | 9 |
2096243 | 2096243 | 2022-01-09 | Carroll | Arkansas | 5015 | 4777 | 81 |
2096244 | 2096244 | 2022-01-09 | Chicot | Arkansas | 5017 | 2261 | 49 |
2096245 | 2096245 | 2022-01-09 | Clark | Arkansas | 5019 | 3992 | 66 |
2096246 | 2096246 | 2022-01-09 | Clay | Arkansas | 5021 | 3077 | 77 |
2096247 | 2096247 | 2022-01-09 | Cleburne | Arkansas | 5023 | 4573 | 104 |
2096248 | 2096248 | 2022-01-09 | Cleveland | Arkansas | 5025 | 1627 | 33 |
2096249 | 2096249 | 2022-01-09 | Columbia | Arkansas | 5027 | 3937 | 77 |
2096250 | 2096250 | 2022-01-09 | Conway | Arkansas | 5029 | 3796 | 50 |
2096251 | 2096251 | 2022-01-09 | Craighead | Arkansas | 5031 | 28234 | 263 |
2096252 | 2096252 | 2022-01-09 | Crawford | Arkansas | 5033 | 12003 | 200 |
2096253 | 2096253 | 2022-01-09 | Crittenden | Arkansas | 5035 | 11056 | 194 |
2096254 | 2096254 | 2022-01-09 | Cross | Arkansas | 5037 | 3451 | 72 |
2096255 | 2096255 | 2022-01-09 | Dallas | Arkansas | 5039 | 1290 | 21 |
2096256 | 2096256 | 2022-01-09 | Desha | Arkansas | 5041 | 2191 | 36 |
2096257 | 2096257 | 2022-01-09 | Drew | Arkansas | 5043 | 3299 | 58 |
2096258 | 2096258 | 2022-01-09 | Faulkner | Arkansas | 5045 | 24720 | 249 |
2096259 | 2096259 | 2022-01-09 | Franklin | Arkansas | 5047 | 3020 | 61 |
2096260 | 2096260 | 2022-01-09 | Fulton | Arkansas | 5049 | 2129 | 79 |
2096261 | 2096261 | 2022-01-09 | Garland | Arkansas | 5051 | 17631 | 433 |
2096262 | 2096262 | 2022-01-09 | Grant | Arkansas | 5053 | 3249 | 52 |
2096263 | 2096263 | 2022-01-09 | Greene | Arkansas | 5055 | 11964 | 137 |
2096264 | 2096264 | 2022-01-09 | Hempstead | Arkansas | 5057 | 3466 | 50 |
2096265 | 2096265 | 2022-01-09 | Hot Spring | Arkansas | 5059 | 8544 | 113 |
2096266 | 2096266 | 2022-01-09 | Howard | Arkansas | 5061 | 2913 | 39 |
2096267 | 2096267 | 2022-01-09 | Independence | Arkansas | 5063 | 7778 | 177 |
2096268 | 2096268 | 2022-01-09 | Izard | Arkansas | 5065 | 3079 | 58 |
2096269 | 2096269 | 2022-01-09 | Jackson | Arkansas | 5067 | 4937 | 49 |
2096270 | 2096270 | 2022-01-09 | Jefferson | Arkansas | 5069 | 14204 | 238 |
2096271 | 2096271 | 2022-01-09 | Johnson | Arkansas | 5071 | 5029 | 64 |
2096272 | 2096272 | 2022-01-09 | Lafayette | Arkansas | 5073 | 991 | 28 |
2096273 | 2096273 | 2022-01-09 | Lawrence | Arkansas | 5075 | 3864 | 64 |
2096274 | 2096274 | 2022-01-09 | Lee | Arkansas | 5077 | 2427 | 55 |
2096275 | 2096275 | 2022-01-09 | Lincoln | Arkansas | 5079 | 4051 | 59 |
2096276 | 2096276 | 2022-01-09 | Little River | Arkansas | 5081 | 2376 | 85 |
2096277 | 2096277 | 2022-01-09 | Logan | Arkansas | 5083 | 3965 | 57 |
2096278 | 2096278 | 2022-01-09 | Lonoke | Arkansas | 5085 | 14617 | 184 |
2096279 | 2096279 | 2022-01-09 | Madison | Arkansas | 5087 | 3014 | 46 |
2096280 | 2096280 | 2022-01-09 | Marion | Arkansas | 5089 | 2639 | 75 |
2096281 | 2096281 | 2022-01-09 | Miller | Arkansas | 5091 | 7251 | 157 |
2096282 | 2096282 | 2022-01-09 | Mississippi | Arkansas | 5093 | 10189 | 161 |
2096283 | 2096283 | 2022-01-09 | Monroe | Arkansas | 5095 | 1379 | 26 |
2096284 | 2096284 | 2022-01-09 | Montgomery | Arkansas | 5097 | 1224 | 53 |
2096285 | 2096285 | 2022-01-09 | Nevada | Arkansas | 5099 | 1627 | 43 |
2096286 | 2096286 | 2022-01-09 | Newton | Arkansas | 5101 | 1400 | 44 |
2096287 | 2096287 | 2022-01-09 | Ouachita | Arkansas | 5103 | 4097 | 91 |
2096288 | 2096288 | 2022-01-09 | Perry | Arkansas | 5105 | 1780 | 26 |
2096289 | 2096289 | 2022-01-09 | Phillips | Arkansas | 5107 | 3779 | 84 |
2096290 | 2096290 | 2022-01-09 | Pike | Arkansas | 5109 | 1961 | 39 |
2096291 | 2096291 | 2022-01-09 | Poinsett | Arkansas | 5111 | 6147 | 107 |
2096292 | 2096292 | 2022-01-09 | Polk | Arkansas | 5113 | 3209 | 129 |
2096293 | 2096293 | 2022-01-09 | Pope | Arkansas | 5115 | 13626 | 168 |
2096294 | 2096294 | 2022-01-09 | Prairie | Arkansas | 5117 | 1442 | 32 |
2096295 | 2096295 | 2022-01-09 | Pulaski | Arkansas | 5119 | 75794 | 976 |
2096296 | 2096296 | 2022-01-09 | Randolph | Arkansas | 5121 | 3917 | 68 |
2096297 | 2096297 | 2022-01-09 | Saline | Arkansas | 5125 | 22551 | 264 |
2096298 | 2096298 | 2022-01-09 | Scott | Arkansas | 5127 | 1871 | 34 |
2096299 | 2096299 | 2022-01-09 | Searcy | Arkansas | 5129 | 1508 | 33 |
2096300 | 2096300 | 2022-01-09 | Sebastian | Arkansas | 5131 | 25584 | 413 |
2096301 | 2096301 | 2022-01-09 | Sevier | Arkansas | 5133 | 4446 | 63 |
2096302 | 2096302 | 2022-01-09 | Sharp | Arkansas | 5135 | 3524 | 80 |
2096303 | 2096303 | 2022-01-09 | St. Francis | Arkansas | 5123 | 5655 | 74 |
2096304 | 2096304 | 2022-01-09 | Stone | Arkansas | 5137 | 2156 | 49 |
2096305 | 2096305 | 2022-01-09 | Union | Arkansas | 5139 | 7151 | 153 |
2096306 | 2096306 | 2022-01-09 | Unknown | Arkansas | 9461 | 0 | |
2096307 | 2096307 | 2022-01-09 | Van Buren | Arkansas | 5141 | 2626 | 45 |
2096308 | 2096308 | 2022-01-09 | Washington | Arkansas | 5143 | 51123 | 521 |
2096309 | 2096309 | 2022-01-09 | White | Arkansas | 5145 | 15761 | 213 |
2096310 | 2096310 | 2022-01-09 | Woodruff | Arkansas | 5147 | 1256 | 24 |
2096311 | 2096311 | 2022-01-09 | Yell | Arkansas | 5149 | 5143 | 90 |
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);