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-09-05 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 |
---|---|---|---|---|---|---|---|
502185 | 502185 | 2020-09-05 | Arkansas | Arkansas | 5001 | 294 | 3 |
502186 | 502186 | 2020-09-05 | Ashley | Arkansas | 5003 | 389 | 7 |
502187 | 502187 | 2020-09-05 | Baxter | Arkansas | 5005 | 147 | 1 |
502188 | 502188 | 2020-09-05 | Benton | Arkansas | 5007 | 5599 | 59 |
502189 | 502189 | 2020-09-05 | Boone | Arkansas | 5009 | 393 | 4 |
502190 | 502190 | 2020-09-05 | Bradley | Arkansas | 5011 | 303 | 6 |
502191 | 502191 | 2020-09-05 | Calhoun | Arkansas | 5013 | 23 | 0 |
502192 | 502192 | 2020-09-05 | Carroll | Arkansas | 5015 | 486 | 8 |
502193 | 502193 | 2020-09-05 | Chicot | Arkansas | 5017 | 969 | 11 |
502194 | 502194 | 2020-09-05 | Clark | Arkansas | 5019 | 255 | 4 |
502195 | 502195 | 2020-09-05 | Clay | Arkansas | 5021 | 203 | 5 |
502196 | 502196 | 2020-09-05 | Cleburne | Arkansas | 5023 | 264 | 7 |
502197 | 502197 | 2020-09-05 | Cleveland | Arkansas | 5025 | 141 | 6 |
502198 | 502198 | 2020-09-05 | Columbia | Arkansas | 5027 | 315 | 15 |
502199 | 502199 | 2020-09-05 | Conway | Arkansas | 5029 | 216 | 3 |
502200 | 502200 | 2020-09-05 | Craighead | Arkansas | 5031 | 2022 | 16 |
502201 | 502201 | 2020-09-05 | Crawford | Arkansas | 5033 | 971 | 9 |
502202 | 502202 | 2020-09-05 | Crittenden | Arkansas | 5035 | 1703 | 35 |
502203 | 502203 | 2020-09-05 | Cross | Arkansas | 5037 | 303 | 5 |
502204 | 502204 | 2020-09-05 | Dallas | Arkansas | 5039 | 135 | 2 |
502205 | 502205 | 2020-09-05 | Desha | Arkansas | 5041 | 252 | 5 |
502206 | 502206 | 2020-09-05 | Drew | Arkansas | 5043 | 309 | 5 |
502207 | 502207 | 2020-09-05 | Faulkner | Arkansas | 5045 | 1770 | 9 |
502208 | 502208 | 2020-09-05 | Franklin | Arkansas | 5047 | 182 | 2 |
502209 | 502209 | 2020-09-05 | Fulton | Arkansas | 5049 | 84 | 1 |
502210 | 502210 | 2020-09-05 | Garland | Arkansas | 5051 | 1501 | 31 |
502211 | 502211 | 2020-09-05 | Grant | Arkansas | 5053 | 202 | 1 |
502212 | 502212 | 2020-09-05 | Greene | Arkansas | 5055 | 660 | 5 |
502213 | 502213 | 2020-09-05 | Hempstead | Arkansas | 5057 | 335 | 3 |
502214 | 502214 | 2020-09-05 | Hot Spring | Arkansas | 5059 | 1741 | 21 |
502215 | 502215 | 2020-09-05 | Howard | Arkansas | 5061 | 435 | 5 |
502216 | 502216 | 2020-09-05 | Independence | Arkansas | 5063 | 806 | 8 |
502217 | 502217 | 2020-09-05 | Izard | Arkansas | 5065 | 109 | 0 |
502218 | 502218 | 2020-09-05 | Jackson | Arkansas | 5067 | 194 | 1 |
502219 | 502219 | 2020-09-05 | Jefferson | Arkansas | 5069 | 2241 | 51 |
502220 | 502220 | 2020-09-05 | Johnson | Arkansas | 5071 | 777 | 4 |
502221 | 502221 | 2020-09-05 | Lafayette | Arkansas | 5073 | 74 | 2 |
502222 | 502222 | 2020-09-05 | Lawrence | Arkansas | 5075 | 263 | 11 |
502223 | 502223 | 2020-09-05 | Lee | Arkansas | 5077 | 1010 | 11 |
502224 | 502224 | 2020-09-05 | Lincoln | Arkansas | 5079 | 1754 | 13 |
502225 | 502225 | 2020-09-05 | Little River | Arkansas | 5081 | 300 | 15 |
502226 | 502226 | 2020-09-05 | Logan | Arkansas | 5083 | 367 | 1 |
502227 | 502227 | 2020-09-05 | Lonoke | Arkansas | 5085 | 767 | 5 |
502228 | 502228 | 2020-09-05 | Madison | Arkansas | 5087 | 308 | 2 |
502229 | 502229 | 2020-09-05 | Marion | Arkansas | 5089 | 51 | 0 |
502230 | 502230 | 2020-09-05 | Miller | Arkansas | 5091 | 646 | 10 |
502231 | 502231 | 2020-09-05 | Mississippi | Arkansas | 5093 | 1405 | 32 |
502232 | 502232 | 2020-09-05 | Monroe | Arkansas | 5095 | 100 | 0 |
502233 | 502233 | 2020-09-05 | Montgomery | Arkansas | 5097 | 118 | 4 |
502234 | 502234 | 2020-09-05 | Nevada | Arkansas | 5099 | 165 | 12 |
502235 | 502235 | 2020-09-05 | Newton | Arkansas | 5101 | 138 | 15 |
502236 | 502236 | 2020-09-05 | Ouachita | Arkansas | 5103 | 175 | 5 |
502237 | 502237 | 2020-09-05 | Perry | Arkansas | 5105 | 63 | 0 |
502238 | 502238 | 2020-09-05 | Phillips | Arkansas | 5107 | 414 | 10 |
502239 | 502239 | 2020-09-05 | Pike | Arkansas | 5109 | 183 | 1 |
502240 | 502240 | 2020-09-05 | Poinsett | Arkansas | 5111 | 511 | 6 |
502241 | 502241 | 2020-09-05 | Polk | Arkansas | 5113 | 234 | 4 |
502242 | 502242 | 2020-09-05 | Pope | Arkansas | 5115 | 1832 | 20 |
502243 | 502243 | 2020-09-05 | Prairie | Arkansas | 5117 | 121 | 1 |
502244 | 502244 | 2020-09-05 | Pulaski | Arkansas | 5119 | 7441 | 113 |
502245 | 502245 | 2020-09-05 | Randolph | Arkansas | 5121 | 319 | 17 |
502246 | 502246 | 2020-09-05 | Saline | Arkansas | 5125 | 1676 | 14 |
502247 | 502247 | 2020-09-05 | Scott | Arkansas | 5127 | 89 | 0 |
502248 | 502248 | 2020-09-05 | Searcy | Arkansas | 5129 | 114 | 0 |
502249 | 502249 | 2020-09-05 | Sebastian | Arkansas | 5131 | 2983 | 35 |
502250 | 502250 | 2020-09-05 | Sevier | Arkansas | 5133 | 1167 | 14 |
502251 | 502251 | 2020-09-05 | Sharp | Arkansas | 5135 | 154 | 5 |
502252 | 502252 | 2020-09-05 | St. Francis | Arkansas | 5123 | 1364 | 4 |
502253 | 502253 | 2020-09-05 | Stone | Arkansas | 5137 | 231 | 4 |
502254 | 502254 | 2020-09-05 | Union | Arkansas | 5139 | 724 | 21 |
502255 | 502255 | 2020-09-05 | Unknown | Arkansas | 1750 | 0 | |
502256 | 502256 | 2020-09-05 | Van Buren | Arkansas | 5141 | 140 | 2 |
502257 | 502257 | 2020-09-05 | Washington | Arkansas | 5143 | 7577 | 78 |
502258 | 502258 | 2020-09-05 | White | Arkansas | 5145 | 564 | 12 |
502259 | 502259 | 2020-09-05 | Woodruff | Arkansas | 5147 | 28 | 0 |
502260 | 502260 | 2020-09-05 | Yell | Arkansas | 5149 | 1177 | 25 |
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);