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-02-24 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 |
---|---|---|---|---|---|---|---|
1060108 | 1060108 | 2021-02-24 | Arkansas | Arkansas | 5001 | 1963 | 38 |
1060109 | 1060109 | 2021-02-24 | Ashley | Arkansas | 5003 | 1764 | 33 |
1060110 | 1060110 | 2021-02-24 | Baxter | Arkansas | 5005 | 2804 | 95 |
1060111 | 1060111 | 2021-02-24 | Benton | Arkansas | 5007 | 26975 | 385 |
1060112 | 1060112 | 2021-02-24 | Boone | Arkansas | 5009 | 3612 | 78 |
1060113 | 1060113 | 2021-02-24 | Bradley | Arkansas | 5011 | 1320 | 31 |
1060114 | 1060114 | 2021-02-24 | Calhoun | Arkansas | 5013 | 390 | 3 |
1060115 | 1060115 | 2021-02-24 | Carroll | Arkansas | 5015 | 2711 | 41 |
1060116 | 1060116 | 2021-02-24 | Chicot | Arkansas | 5017 | 1585 | 40 |
1060117 | 1060117 | 2021-02-24 | Clark | Arkansas | 5019 | 2014 | 37 |
1060118 | 1060118 | 2021-02-24 | Clay | Arkansas | 5021 | 1673 | 46 |
1060119 | 1060119 | 2021-02-24 | Cleburne | Arkansas | 5023 | 1871 | 67 |
1060120 | 1060120 | 2021-02-24 | Cleveland | Arkansas | 5025 | 914 | 23 |
1060121 | 1060121 | 2021-02-24 | Columbia | Arkansas | 5027 | 2124 | 54 |
1060122 | 1060122 | 2021-02-24 | Conway | Arkansas | 5029 | 2138 | 31 |
1060123 | 1060123 | 2021-02-24 | Craighead | Arkansas | 5031 | 12714 | 177 |
1060124 | 1060124 | 2021-02-24 | Crawford | Arkansas | 5033 | 6718 | 105 |
1060125 | 1060125 | 2021-02-24 | Crittenden | Arkansas | 5035 | 5648 | 94 |
1060126 | 1060126 | 2021-02-24 | Cross | Arkansas | 5037 | 1896 | 48 |
1060127 | 1060127 | 2021-02-24 | Dallas | Arkansas | 5039 | 716 | 12 |
1060128 | 1060128 | 2021-02-24 | Desha | Arkansas | 5041 | 1316 | 21 |
1060129 | 1060129 | 2021-02-24 | Drew | Arkansas | 5043 | 1948 | 35 |
1060130 | 1060130 | 2021-02-24 | Faulkner | Arkansas | 5045 | 11647 | 154 |
1060131 | 1060131 | 2021-02-24 | Franklin | Arkansas | 5047 | 1622 | 34 |
1060132 | 1060132 | 2021-02-24 | Fulton | Arkansas | 5049 | 1063 | 45 |
1060133 | 1060133 | 2021-02-24 | Garland | Arkansas | 5051 | 9572 | 231 |
1060134 | 1060134 | 2021-02-24 | Grant | Arkansas | 5053 | 1550 | 32 |
1060135 | 1060135 | 2021-02-24 | Greene | Arkansas | 5055 | 5784 | 74 |
1060136 | 1060136 | 2021-02-24 | Hempstead | Arkansas | 5057 | 1812 | 18 |
1060137 | 1060137 | 2021-02-24 | Hot Spring | Arkansas | 5059 | 4741 | 68 |
1060138 | 1060138 | 2021-02-24 | Howard | Arkansas | 5061 | 1523 | 24 |
1060139 | 1060139 | 2021-02-24 | Independence | Arkansas | 5063 | 3650 | 120 |
1060140 | 1060140 | 2021-02-24 | Izard | Arkansas | 5065 | 1650 | 39 |
1060141 | 1060141 | 2021-02-24 | Jackson | Arkansas | 5067 | 3134 | 33 |
1060142 | 1060142 | 2021-02-24 | Jefferson | Arkansas | 5069 | 8568 | 165 |
1060143 | 1060143 | 2021-02-24 | Johnson | Arkansas | 5071 | 2715 | 31 |
1060144 | 1060144 | 2021-02-24 | Lafayette | Arkansas | 5073 | 501 | 7 |
1060145 | 1060145 | 2021-02-24 | Lawrence | Arkansas | 5075 | 2001 | 41 |
1060146 | 1060146 | 2021-02-24 | Lee | Arkansas | 5077 | 1635 | 35 |
1060147 | 1060147 | 2021-02-24 | Lincoln | Arkansas | 5079 | 3135 | 43 |
1060148 | 1060148 | 2021-02-24 | Little River | Arkansas | 5081 | 1122 | 40 |
1060149 | 1060149 | 2021-02-24 | Logan | Arkansas | 5083 | 2165 | 18 |
1060150 | 1060150 | 2021-02-24 | Lonoke | Arkansas | 5085 | 6732 | 109 |
1060151 | 1060151 | 2021-02-24 | Madison | Arkansas | 5087 | 1399 | 22 |
1060152 | 1060152 | 2021-02-24 | Marion | Arkansas | 5089 | 933 | 30 |
1060153 | 1060153 | 2021-02-24 | Miller | Arkansas | 5091 | 3768 | 34 |
1060154 | 1060154 | 2021-02-24 | Mississippi | Arkansas | 5093 | 5536 | 112 |
1060155 | 1060155 | 2021-02-24 | Monroe | Arkansas | 5095 | 823 | 17 |
1060156 | 1060156 | 2021-02-24 | Montgomery | Arkansas | 5097 | 723 | 29 |
1060157 | 1060157 | 2021-02-24 | Nevada | Arkansas | 5099 | 772 | 24 |
1060158 | 1060158 | 2021-02-24 | Newton | Arkansas | 5101 | 689 | 26 |
1060159 | 1060159 | 2021-02-24 | Ouachita | Arkansas | 5103 | 2144 | 50 |
1060160 | 1060160 | 2021-02-24 | Perry | Arkansas | 5105 | 800 | 9 |
1060161 | 1060161 | 2021-02-24 | Phillips | Arkansas | 5107 | 1683 | 34 |
1060162 | 1060162 | 2021-02-24 | Pike | Arkansas | 5109 | 961 | 22 |
1060163 | 1060163 | 2021-02-24 | Poinsett | Arkansas | 5111 | 3059 | 75 |
1060164 | 1060164 | 2021-02-24 | Polk | Arkansas | 5113 | 1868 | 63 |
1060165 | 1060165 | 2021-02-24 | Pope | Arkansas | 5115 | 7673 | 101 |
1060166 | 1060166 | 2021-02-24 | Prairie | Arkansas | 5117 | 863 | 24 |
1060167 | 1060167 | 2021-02-24 | Pulaski | Arkansas | 5119 | 36920 | 578 |
1060168 | 1060168 | 2021-02-24 | Randolph | Arkansas | 5121 | 1933 | 49 |
1060169 | 1060169 | 2021-02-24 | Saline | Arkansas | 5125 | 11339 | 163 |
1060170 | 1060170 | 2021-02-24 | Scott | Arkansas | 5127 | 925 | 14 |
1060171 | 1060171 | 2021-02-24 | Searcy | Arkansas | 5129 | 650 | 15 |
1060172 | 1060172 | 2021-02-24 | Sebastian | Arkansas | 5131 | 14479 | 258 |
1060173 | 1060173 | 2021-02-24 | Sevier | Arkansas | 5133 | 2603 | 29 |
1060174 | 1060174 | 2021-02-24 | Sharp | Arkansas | 5135 | 1518 | 51 |
1060175 | 1060175 | 2021-02-24 | St. Francis | Arkansas | 5123 | 3423 | 37 |
1060176 | 1060176 | 2021-02-24 | Stone | Arkansas | 5137 | 952 | 30 |
1060177 | 1060177 | 2021-02-24 | Union | Arkansas | 5139 | 3647 | 102 |
1060178 | 1060178 | 2021-02-24 | Unknown | Arkansas | 2750 | 0 | |
1060179 | 1060179 | 2021-02-24 | Van Buren | Arkansas | 5141 | 1161 | 18 |
1060180 | 1060180 | 2021-02-24 | Washington | Arkansas | 5143 | 29210 | 330 |
1060181 | 1060181 | 2021-02-24 | White | Arkansas | 5145 | 7111 | 108 |
1060182 | 1060182 | 2021-02-24 | Woodruff | Arkansas | 5147 | 615 | 11 |
1060183 | 1060183 | 2021-02-24 | Yell | Arkansas | 5149 | 3330 | 67 |
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);