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 2020-08-01 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 |
---|---|---|---|---|---|---|---|
389266 | 389266 | 2020-08-01 | Arkansas | Arkansas | 5001 | 194 | 0 |
389267 | 389267 | 2020-08-01 | Ashley | Arkansas | 5003 | 238 | 4 |
389268 | 389268 | 2020-08-01 | Baxter | Arkansas | 5005 | 60 | 0 |
389269 | 389269 | 2020-08-01 | Benton | Arkansas | 5007 | 4495 | 39 |
389270 | 389270 | 2020-08-01 | Boone | Arkansas | 5009 | 162 | 1 |
389271 | 389271 | 2020-08-01 | Bradley | Arkansas | 5011 | 142 | 3 |
389272 | 389272 | 2020-08-01 | Calhoun | Arkansas | 5013 | 13 | 0 |
389273 | 389273 | 2020-08-01 | Carroll | Arkansas | 5015 | 337 | 6 |
389274 | 389274 | 2020-08-01 | Chicot | Arkansas | 5017 | 522 | 6 |
389275 | 389275 | 2020-08-01 | Clark | Arkansas | 5019 | 152 | 0 |
389276 | 389276 | 2020-08-01 | Clay | Arkansas | 5021 | 105 | 4 |
389277 | 389277 | 2020-08-01 | Cleburne | Arkansas | 5023 | 179 | 5 |
389278 | 389278 | 2020-08-01 | Cleveland | Arkansas | 5025 | 67 | 2 |
389279 | 389279 | 2020-08-01 | Columbia | Arkansas | 5027 | 186 | 6 |
389280 | 389280 | 2020-08-01 | Conway | Arkansas | 5029 | 134 | 3 |
389281 | 389281 | 2020-08-01 | Craighead | Arkansas | 5031 | 1104 | 11 |
389282 | 389282 | 2020-08-01 | Crawford | Arkansas | 5033 | 522 | 3 |
389283 | 389283 | 2020-08-01 | Crittenden | Arkansas | 5035 | 1191 | 18 |
389284 | 389284 | 2020-08-01 | Cross | Arkansas | 5037 | 162 | 1 |
389285 | 389285 | 2020-08-01 | Dallas | Arkansas | 5039 | 56 | 0 |
389286 | 389286 | 2020-08-01 | Desha | Arkansas | 5041 | 144 | 2 |
389287 | 389287 | 2020-08-01 | Drew | Arkansas | 5043 | 155 | 2 |
389288 | 389288 | 2020-08-01 | Faulkner | Arkansas | 5045 | 1190 | 5 |
389289 | 389289 | 2020-08-01 | Franklin | Arkansas | 5047 | 105 | 2 |
389290 | 389290 | 2020-08-01 | Fulton | Arkansas | 5049 | 27 | 0 |
389291 | 389291 | 2020-08-01 | Garland | Arkansas | 5051 | 837 | 7 |
389292 | 389292 | 2020-08-01 | Grant | Arkansas | 5053 | 124 | 0 |
389293 | 389293 | 2020-08-01 | Greene | Arkansas | 5055 | 359 | 1 |
389294 | 389294 | 2020-08-01 | Hempstead | Arkansas | 5057 | 207 | 2 |
389295 | 389295 | 2020-08-01 | Hot Spring | Arkansas | 5059 | 1451 | 8 |
389296 | 389296 | 2020-08-01 | Howard | Arkansas | 5061 | 294 | 2 |
389297 | 389297 | 2020-08-01 | Independence | Arkansas | 5063 | 345 | 0 |
389298 | 389298 | 2020-08-01 | Izard | Arkansas | 5065 | 44 | 1 |
389299 | 389299 | 2020-08-01 | Jackson | Arkansas | 5067 | 58 | 1 |
389300 | 389300 | 2020-08-01 | Jefferson | Arkansas | 5069 | 1315 | 38 |
389301 | 389301 | 2020-08-01 | Johnson | Arkansas | 5071 | 617 | 0 |
389302 | 389302 | 2020-08-01 | Lafayette | Arkansas | 5073 | 49 | 2 |
389303 | 389303 | 2020-08-01 | Lawrence | Arkansas | 5075 | 182 | 9 |
389304 | 389304 | 2020-08-01 | Lee | Arkansas | 5077 | 885 | 6 |
389305 | 389305 | 2020-08-01 | Lincoln | Arkansas | 5079 | 1168 | 11 |
389306 | 389306 | 2020-08-01 | Little River | Arkansas | 5081 | 152 | 1 |
389307 | 389307 | 2020-08-01 | Logan | Arkansas | 5083 | 141 | 0 |
389308 | 389308 | 2020-08-01 | Lonoke | Arkansas | 5085 | 416 | 2 |
389309 | 389309 | 2020-08-01 | Madison | Arkansas | 5087 | 254 | 1 |
389310 | 389310 | 2020-08-01 | Marion | Arkansas | 5089 | 23 | 0 |
389311 | 389311 | 2020-08-01 | Miller | Arkansas | 5091 | 457 | 4 |
389312 | 389312 | 2020-08-01 | Mississippi | Arkansas | 5093 | 752 | 10 |
389313 | 389313 | 2020-08-01 | Monroe | Arkansas | 5095 | 51 | 0 |
389314 | 389314 | 2020-08-01 | Montgomery | Arkansas | 5097 | 25 | 0 |
389315 | 389315 | 2020-08-01 | Nevada | Arkansas | 5099 | 129 | 9 |
389316 | 389316 | 2020-08-01 | Newton | Arkansas | 5101 | 93 | 3 |
389317 | 389317 | 2020-08-01 | Ouachita | Arkansas | 5103 | 76 | 1 |
389318 | 389318 | 2020-08-01 | Perry | Arkansas | 5105 | 49 | 0 |
389319 | 389319 | 2020-08-01 | Phillips | Arkansas | 5107 | 273 | 6 |
389320 | 389320 | 2020-08-01 | Pike | Arkansas | 5109 | 77 | 1 |
389321 | 389321 | 2020-08-01 | Poinsett | Arkansas | 5111 | 156 | 3 |
389322 | 389322 | 2020-08-01 | Polk | Arkansas | 5113 | 128 | 1 |
389323 | 389323 | 2020-08-01 | Pope | Arkansas | 5115 | 1174 | 9 |
389324 | 389324 | 2020-08-01 | Prairie | Arkansas | 5117 | 63 | 0 |
389325 | 389325 | 2020-08-01 | Pulaski | Arkansas | 5119 | 4803 | 77 |
389326 | 389326 | 2020-08-01 | Randolph | Arkansas | 5121 | 170 | 2 |
389327 | 389327 | 2020-08-01 | Saline | Arkansas | 5125 | 868 | 4 |
389328 | 389328 | 2020-08-01 | Scott | Arkansas | 5127 | 41 | 0 |
389329 | 389329 | 2020-08-01 | Searcy | Arkansas | 5129 | 25 | 0 |
389330 | 389330 | 2020-08-01 | Sebastian | Arkansas | 5131 | 1724 | 14 |
389331 | 389331 | 2020-08-01 | Sevier | Arkansas | 5133 | 933 | 10 |
389332 | 389332 | 2020-08-01 | Sharp | Arkansas | 5135 | 102 | 5 |
389333 | 389333 | 2020-08-01 | St. Francis | Arkansas | 5123 | 1117 | 3 |
389334 | 389334 | 2020-08-01 | Stone | Arkansas | 5137 | 52 | 1 |
389335 | 389335 | 2020-08-01 | Union | Arkansas | 5139 | 430 | 16 |
389336 | 389336 | 2020-08-01 | Unknown | Arkansas | 1555 | 0 | |
389337 | 389337 | 2020-08-01 | Van Buren | Arkansas | 5141 | 50 | 2 |
389338 | 389338 | 2020-08-01 | Washington | Arkansas | 5143 | 5952 | 46 |
389339 | 389339 | 2020-08-01 | White | Arkansas | 5145 | 254 | 2 |
389340 | 389340 | 2020-08-01 | Woodruff | Arkansas | 5147 | 19 | 0 |
389341 | 389341 | 2020-08-01 | Yell | Arkansas | 5149 | 1012 | 14 |
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);