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-04-23 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 |
---|---|---|---|---|---|---|---|
1248431 | 1248431 | 2021-04-23 | Arkansas | Arkansas | 5001 | 2089 | 36 |
1248432 | 1248432 | 2021-04-23 | Ashley | Arkansas | 5003 | 1956 | 34 |
1248433 | 1248433 | 2021-04-23 | Baxter | Arkansas | 5005 | 3135 | 103 |
1248434 | 1248434 | 2021-04-23 | Benton | Arkansas | 5007 | 28621 | 412 |
1248435 | 1248435 | 2021-04-23 | Boone | Arkansas | 5009 | 3782 | 80 |
1248436 | 1248436 | 2021-04-23 | Bradley | Arkansas | 5011 | 1365 | 32 |
1248437 | 1248437 | 2021-04-23 | Calhoun | Arkansas | 5013 | 410 | 3 |
1248438 | 1248438 | 2021-04-23 | Carroll | Arkansas | 5015 | 2782 | 45 |
1248439 | 1248439 | 2021-04-23 | Chicot | Arkansas | 5017 | 1612 | 40 |
1248440 | 1248440 | 2021-04-23 | Clark | Arkansas | 5019 | 2098 | 40 |
1248441 | 1248441 | 2021-04-23 | Clay | Arkansas | 5021 | 1743 | 50 |
1248442 | 1248442 | 2021-04-23 | Cleburne | Arkansas | 5023 | 1967 | 73 |
1248443 | 1248443 | 2021-04-23 | Cleveland | Arkansas | 5025 | 949 | 25 |
1248444 | 1248444 | 2021-04-23 | Columbia | Arkansas | 5027 | 2338 | 56 |
1248445 | 1248445 | 2021-04-23 | Conway | Arkansas | 5029 | 2209 | 32 |
1248446 | 1248446 | 2021-04-23 | Craighead | Arkansas | 5031 | 13268 | 178 |
1248447 | 1248447 | 2021-04-23 | Crawford | Arkansas | 5033 | 7041 | 119 |
1248448 | 1248448 | 2021-04-23 | Crittenden | Arkansas | 5035 | 5982 | 96 |
1248449 | 1248449 | 2021-04-23 | Cross | Arkansas | 5037 | 1939 | 49 |
1248450 | 1248450 | 2021-04-23 | Dallas | Arkansas | 5039 | 757 | 15 |
1248451 | 1248451 | 2021-04-23 | Desha | Arkansas | 5041 | 1361 | 24 |
1248452 | 1248452 | 2021-04-23 | Drew | Arkansas | 5043 | 1992 | 42 |
1248453 | 1248453 | 2021-04-23 | Faulkner | Arkansas | 5045 | 12387 | 160 |
1248454 | 1248454 | 2021-04-23 | Franklin | Arkansas | 5047 | 1687 | 39 |
1248455 | 1248455 | 2021-04-23 | Fulton | Arkansas | 5049 | 1119 | 47 |
1248456 | 1248456 | 2021-04-23 | Garland | Arkansas | 5051 | 10094 | 259 |
1248457 | 1248457 | 2021-04-23 | Grant | Arkansas | 5053 | 1641 | 32 |
1248458 | 1248458 | 2021-04-23 | Greene | Arkansas | 5055 | 6076 | 75 |
1248459 | 1248459 | 2021-04-23 | Hempstead | Arkansas | 5057 | 1991 | 20 |
1248460 | 1248460 | 2021-04-23 | Hot Spring | Arkansas | 5059 | 5061 | 71 |
1248461 | 1248461 | 2021-04-23 | Howard | Arkansas | 5061 | 1648 | 25 |
1248462 | 1248462 | 2021-04-23 | Independence | Arkansas | 5063 | 3744 | 122 |
1248463 | 1248463 | 2021-04-23 | Izard | Arkansas | 5065 | 1675 | 41 |
1248464 | 1248464 | 2021-04-23 | Jackson | Arkansas | 5067 | 3214 | 38 |
1248465 | 1248465 | 2021-04-23 | Jefferson | Arkansas | 5069 | 8838 | 166 |
1248466 | 1248466 | 2021-04-23 | Johnson | Arkansas | 5071 | 2899 | 37 |
1248467 | 1248467 | 2021-04-23 | Lafayette | Arkansas | 5073 | 546 | 9 |
1248468 | 1248468 | 2021-04-23 | Lawrence | Arkansas | 5075 | 2091 | 43 |
1248469 | 1248469 | 2021-04-23 | Lee | Arkansas | 5077 | 1667 | 34 |
1248470 | 1248470 | 2021-04-23 | Lincoln | Arkansas | 5079 | 3200 | 48 |
1248471 | 1248471 | 2021-04-23 | Little River | Arkansas | 5081 | 1235 | 42 |
1248472 | 1248472 | 2021-04-23 | Logan | Arkansas | 5083 | 2221 | 22 |
1248473 | 1248473 | 2021-04-23 | Lonoke | Arkansas | 5085 | 7226 | 119 |
1248474 | 1248474 | 2021-04-23 | Madison | Arkansas | 5087 | 1448 | 22 |
1248475 | 1248475 | 2021-04-23 | Marion | Arkansas | 5089 | 1049 | 30 |
1248476 | 1248476 | 2021-04-23 | Miller | Arkansas | 5091 | 4259 | 36 |
1248477 | 1248477 | 2021-04-23 | Mississippi | Arkansas | 5093 | 5802 | 107 |
1248478 | 1248478 | 2021-04-23 | Monroe | Arkansas | 5095 | 866 | 17 |
1248479 | 1248479 | 2021-04-23 | Montgomery | Arkansas | 5097 | 754 | 33 |
1248480 | 1248480 | 2021-04-23 | Nevada | Arkansas | 5099 | 820 | 24 |
1248481 | 1248481 | 2021-04-23 | Newton | Arkansas | 5101 | 712 | 26 |
1248482 | 1248482 | 2021-04-23 | Ouachita | Arkansas | 5103 | 2305 | 61 |
1248483 | 1248483 | 2021-04-23 | Perry | Arkansas | 5105 | 835 | 10 |
1248484 | 1248484 | 2021-04-23 | Phillips | Arkansas | 5107 | 1790 | 38 |
1248485 | 1248485 | 2021-04-23 | Pike | Arkansas | 5109 | 1006 | 22 |
1248486 | 1248486 | 2021-04-23 | Poinsett | Arkansas | 5111 | 3154 | 77 |
1248487 | 1248487 | 2021-04-23 | Polk | Arkansas | 5113 | 1977 | 71 |
1248488 | 1248488 | 2021-04-23 | Pope | Arkansas | 5115 | 7971 | 106 |
1248489 | 1248489 | 2021-04-23 | Prairie | Arkansas | 5117 | 889 | 21 |
1248490 | 1248490 | 2021-04-23 | Pulaski | Arkansas | 5119 | 38837 | 647 |
1248491 | 1248491 | 2021-04-23 | Randolph | Arkansas | 5121 | 2092 | 47 |
1248492 | 1248492 | 2021-04-23 | Saline | Arkansas | 5125 | 11820 | 166 |
1248493 | 1248493 | 2021-04-23 | Scott | Arkansas | 5127 | 931 | 14 |
1248494 | 1248494 | 2021-04-23 | Searcy | Arkansas | 5129 | 678 | 17 |
1248495 | 1248495 | 2021-04-23 | Sebastian | Arkansas | 5131 | 15155 | 274 |
1248496 | 1248496 | 2021-04-23 | Sevier | Arkansas | 5133 | 2786 | 24 |
1248497 | 1248497 | 2021-04-23 | Sharp | Arkansas | 5135 | 1583 | 45 |
1248498 | 1248498 | 2021-04-23 | St. Francis | Arkansas | 5123 | 3566 | 42 |
1248499 | 1248499 | 2021-04-23 | Stone | Arkansas | 5137 | 986 | 30 |
1248500 | 1248500 | 2021-04-23 | Union | Arkansas | 5139 | 3996 | 112 |
1248501 | 1248501 | 2021-04-23 | Unknown | Arkansas | 2816 | 0 | |
1248502 | 1248502 | 2021-04-23 | Van Buren | Arkansas | 5141 | 1292 | 23 |
1248503 | 1248503 | 2021-04-23 | Washington | Arkansas | 5143 | 30641 | 345 |
1248504 | 1248504 | 2021-04-23 | White | Arkansas | 5145 | 7920 | 118 |
1248505 | 1248505 | 2021-04-23 | Woodruff | Arkansas | 5147 | 645 | 13 |
1248506 | 1248506 | 2021-04-23 | Yell | Arkansas | 5149 | 3421 | 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);