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-20 and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
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 |
---|---|---|---|---|---|---|---|
450481 | 450481 | 2020-08-20 | Arkansas | Arkansas | 5001 | 256 | 2 |
450482 | 450482 | 2020-08-20 | Ashley | Arkansas | 5003 | 369 | 7 |
450483 | 450483 | 2020-08-20 | Baxter | Arkansas | 5005 | 96 | 0 |
450484 | 450484 | 2020-08-20 | Benton | Arkansas | 5007 | 5000 | 43 |
450485 | 450485 | 2020-08-20 | Boone | Arkansas | 5009 | 242 | 2 |
450486 | 450486 | 2020-08-20 | Bradley | Arkansas | 5011 | 233 | 4 |
450487 | 450487 | 2020-08-20 | Calhoun | Arkansas | 5013 | 22 | 0 |
450488 | 450488 | 2020-08-20 | Carroll | Arkansas | 5015 | 409 | 7 |
450489 | 450489 | 2020-08-20 | Chicot | Arkansas | 5017 | 932 | 9 |
450490 | 450490 | 2020-08-20 | Clark | Arkansas | 5019 | 196 | 2 |
450491 | 450491 | 2020-08-20 | Clay | Arkansas | 5021 | 154 | 5 |
450492 | 450492 | 2020-08-20 | Cleburne | Arkansas | 5023 | 237 | 5 |
450493 | 450493 | 2020-08-20 | Cleveland | Arkansas | 5025 | 124 | 2 |
450494 | 450494 | 2020-08-20 | Columbia | Arkansas | 5027 | 255 | 12 |
450495 | 450495 | 2020-08-20 | Conway | Arkansas | 5029 | 178 | 3 |
450496 | 450496 | 2020-08-20 | Craighead | Arkansas | 5031 | 1598 | 13 |
450497 | 450497 | 2020-08-20 | Crawford | Arkansas | 5033 | 790 | 6 |
450498 | 450498 | 2020-08-20 | Crittenden | Arkansas | 5035 | 1530 | 26 |
450499 | 450499 | 2020-08-20 | Cross | Arkansas | 5037 | 236 | 4 |
450500 | 450500 | 2020-08-20 | Dallas | Arkansas | 5039 | 70 | 2 |
450501 | 450501 | 2020-08-20 | Desha | Arkansas | 5041 | 213 | 4 |
450502 | 450502 | 2020-08-20 | Drew | Arkansas | 5043 | 286 | 3 |
450503 | 450503 | 2020-08-20 | Faulkner | Arkansas | 5045 | 1438 | 7 |
450504 | 450504 | 2020-08-20 | Franklin | Arkansas | 5047 | 147 | 2 |
450505 | 450505 | 2020-08-20 | Fulton | Arkansas | 5049 | 52 | 0 |
450506 | 450506 | 2020-08-20 | Garland | Arkansas | 5051 | 1256 | 21 |
450507 | 450507 | 2020-08-20 | Grant | Arkansas | 5053 | 159 | 0 |
450508 | 450508 | 2020-08-20 | Greene | Arkansas | 5055 | 563 | 3 |
450509 | 450509 | 2020-08-20 | Hempstead | Arkansas | 5057 | 284 | 3 |
450510 | 450510 | 2020-08-20 | Hot Spring | Arkansas | 5059 | 1659 | 14 |
450511 | 450511 | 2020-08-20 | Howard | Arkansas | 5061 | 383 | 3 |
450512 | 450512 | 2020-08-20 | Independence | Arkansas | 5063 | 651 | 3 |
450513 | 450513 | 2020-08-20 | Izard | Arkansas | 5065 | 69 | 0 |
450514 | 450514 | 2020-08-20 | Jackson | Arkansas | 5067 | 155 | 1 |
450515 | 450515 | 2020-08-20 | Jefferson | Arkansas | 5069 | 1831 | 41 |
450516 | 450516 | 2020-08-20 | Johnson | Arkansas | 5071 | 724 | 3 |
450517 | 450517 | 2020-08-20 | Lafayette | Arkansas | 5073 | 64 | 2 |
450518 | 450518 | 2020-08-20 | Lawrence | Arkansas | 5075 | 238 | 9 |
450519 | 450519 | 2020-08-20 | Lee | Arkansas | 5077 | 986 | 8 |
450520 | 450520 | 2020-08-20 | Lincoln | Arkansas | 5079 | 1360 | 12 |
450521 | 450521 | 2020-08-20 | Little River | Arkansas | 5081 | 248 | 6 |
450522 | 450522 | 2020-08-20 | Logan | Arkansas | 5083 | 343 | 1 |
450523 | 450523 | 2020-08-20 | Lonoke | Arkansas | 5085 | 611 | 2 |
450524 | 450524 | 2020-08-20 | Madison | Arkansas | 5087 | 286 | 2 |
450525 | 450525 | 2020-08-20 | Marion | Arkansas | 5089 | 38 | 0 |
450526 | 450526 | 2020-08-20 | Miller | Arkansas | 5091 | 541 | 5 |
450527 | 450527 | 2020-08-20 | Mississippi | Arkansas | 5093 | 1216 | 16 |
450528 | 450528 | 2020-08-20 | Monroe | Arkansas | 5095 | 84 | 0 |
450529 | 450529 | 2020-08-20 | Montgomery | Arkansas | 5097 | 56 | 2 |
450530 | 450530 | 2020-08-20 | Nevada | Arkansas | 5099 | 150 | 9 |
450531 | 450531 | 2020-08-20 | Newton | Arkansas | 5101 | 107 | 12 |
450532 | 450532 | 2020-08-20 | Ouachita | Arkansas | 5103 | 124 | 3 |
450533 | 450533 | 2020-08-20 | Perry | Arkansas | 5105 | 56 | 0 |
450534 | 450534 | 2020-08-20 | Phillips | Arkansas | 5107 | 366 | 9 |
450535 | 450535 | 2020-08-20 | Pike | Arkansas | 5109 | 151 | 1 |
450536 | 450536 | 2020-08-20 | Poinsett | Arkansas | 5111 | 367 | 4 |
450537 | 450537 | 2020-08-20 | Polk | Arkansas | 5113 | 191 | 2 |
450538 | 450538 | 2020-08-20 | Pope | Arkansas | 5115 | 1520 | 14 |
450539 | 450539 | 2020-08-20 | Prairie | Arkansas | 5117 | 112 | 0 |
450540 | 450540 | 2020-08-20 | Pulaski | Arkansas | 5119 | 6341 | 91 |
450541 | 450541 | 2020-08-20 | Randolph | Arkansas | 5121 | 285 | 11 |
450542 | 450542 | 2020-08-20 | Saline | Arkansas | 5125 | 1334 | 10 |
450543 | 450543 | 2020-08-20 | Scott | Arkansas | 5127 | 84 | 0 |
450544 | 450544 | 2020-08-20 | Searcy | Arkansas | 5129 | 39 | 0 |
450545 | 450545 | 2020-08-20 | Sebastian | Arkansas | 5131 | 2583 | 27 |
450546 | 450546 | 2020-08-20 | Sevier | Arkansas | 5133 | 1086 | 11 |
450547 | 450547 | 2020-08-20 | Sharp | Arkansas | 5135 | 130 | 5 |
450548 | 450548 | 2020-08-20 | St. Francis | Arkansas | 5123 | 1252 | 3 |
450549 | 450549 | 2020-08-20 | Stone | Arkansas | 5137 | 113 | 1 |
450550 | 450550 | 2020-08-20 | Union | Arkansas | 5139 | 597 | 21 |
450551 | 450551 | 2020-08-20 | Unknown | Arkansas | 774 | 0 | |
450552 | 450552 | 2020-08-20 | Van Buren | Arkansas | 5141 | 70 | 2 |
450553 | 450553 | 2020-08-20 | Washington | Arkansas | 5143 | 6517 | 53 |
450554 | 450554 | 2020-08-20 | White | Arkansas | 5145 | 422 | 5 |
450555 | 450555 | 2020-08-20 | Woodruff | Arkansas | 5147 | 26 | 0 |
450556 | 450556 | 2020-08-20 | Yell | Arkansas | 5149 | 1100 | 20 |
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);