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-09-30 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 |
---|---|---|---|---|---|---|---|
1767987 | 1767987 | 2021-09-30 | Arkansas | Arkansas | 5001 | 3385 | 56 |
1767988 | 1767988 | 2021-09-30 | Ashley | Arkansas | 5003 | 3096 | 42 |
1767989 | 1767989 | 2021-09-30 | Baxter | Arkansas | 5005 | 5685 | 170 |
1767990 | 1767990 | 2021-09-30 | Benton | Arkansas | 5007 | 40730 | 575 |
1767991 | 1767991 | 2021-09-30 | Boone | Arkansas | 5009 | 6021 | 114 |
1767992 | 1767992 | 2021-09-30 | Bradley | Arkansas | 5011 | 1921 | 37 |
1767993 | 1767993 | 2021-09-30 | Calhoun | Arkansas | 5013 | 580 | 7 |
1767994 | 1767994 | 2021-09-30 | Carroll | Arkansas | 5015 | 4196 | 67 |
1767995 | 1767995 | 2021-09-30 | Chicot | Arkansas | 5017 | 1988 | 44 |
1767996 | 1767996 | 2021-09-30 | Clark | Arkansas | 5019 | 3118 | 51 |
1767997 | 1767997 | 2021-09-30 | Clay | Arkansas | 5021 | 2600 | 58 |
1767998 | 1767998 | 2021-09-30 | Cleburne | Arkansas | 5023 | 3543 | 88 |
1767999 | 1767999 | 2021-09-30 | Cleveland | Arkansas | 5025 | 1352 | 32 |
1768000 | 1768000 | 2021-09-30 | Columbia | Arkansas | 5027 | 3290 | 66 |
1768001 | 1768001 | 2021-09-30 | Conway | Arkansas | 5029 | 3078 | 42 |
1768002 | 1768002 | 2021-09-30 | Craighead | Arkansas | 5031 | 20795 | 233 |
1768003 | 1768003 | 2021-09-30 | Crawford | Arkansas | 5033 | 10332 | 165 |
1768004 | 1768004 | 2021-09-30 | Crittenden | Arkansas | 5035 | 8516 | 122 |
1768005 | 1768005 | 2021-09-30 | Cross | Arkansas | 5037 | 2828 | 59 |
1768006 | 1768006 | 2021-09-30 | Dallas | Arkansas | 5039 | 1120 | 18 |
1768007 | 1768007 | 2021-09-30 | Desha | Arkansas | 5041 | 1828 | 29 |
1768008 | 1768008 | 2021-09-30 | Drew | Arkansas | 5043 | 2782 | 54 |
1768009 | 1768009 | 2021-09-30 | Faulkner | Arkansas | 5045 | 18985 | 214 |
1768010 | 1768010 | 2021-09-30 | Franklin | Arkansas | 5047 | 2653 | 52 |
1768011 | 1768011 | 2021-09-30 | Fulton | Arkansas | 5049 | 1649 | 55 |
1768012 | 1768012 | 2021-09-30 | Garland | Arkansas | 5051 | 15607 | 369 |
1768013 | 1768013 | 2021-09-30 | Grant | Arkansas | 5053 | 2823 | 47 |
1768014 | 1768014 | 2021-09-30 | Greene | Arkansas | 5055 | 9640 | 113 |
1768015 | 1768015 | 2021-09-30 | Hempstead | Arkansas | 5057 | 2838 | 25 |
1768016 | 1768016 | 2021-09-30 | Hot Spring | Arkansas | 5059 | 7367 | 105 |
1768017 | 1768017 | 2021-09-30 | Howard | Arkansas | 5061 | 2330 | 30 |
1768018 | 1768018 | 2021-09-30 | Independence | Arkansas | 5063 | 5990 | 152 |
1768019 | 1768019 | 2021-09-30 | Izard | Arkansas | 5065 | 2375 | 55 |
1768020 | 1768020 | 2021-09-30 | Jackson | Arkansas | 5067 | 4024 | 42 |
1768021 | 1768021 | 2021-09-30 | Jefferson | Arkansas | 5069 | 12193 | 224 |
1768022 | 1768022 | 2021-09-30 | Johnson | Arkansas | 5071 | 4429 | 56 |
1768023 | 1768023 | 2021-09-30 | Lafayette | Arkansas | 5073 | 814 | 12 |
1768024 | 1768024 | 2021-09-30 | Lawrence | Arkansas | 5075 | 3135 | 52 |
1768025 | 1768025 | 2021-09-30 | Lee | Arkansas | 5077 | 2037 | 45 |
1768026 | 1768026 | 2021-09-30 | Lincoln | Arkansas | 5079 | 3616 | 55 |
1768027 | 1768027 | 2021-09-30 | Little River | Arkansas | 5081 | 1945 | 45 |
1768028 | 1768028 | 2021-09-30 | Logan | Arkansas | 5083 | 3448 | 34 |
1768029 | 1768029 | 2021-09-30 | Lonoke | Arkansas | 5085 | 11626 | 171 |
1768030 | 1768030 | 2021-09-30 | Madison | Arkansas | 5087 | 2409 | 35 |
1768031 | 1768031 | 2021-09-30 | Marion | Arkansas | 5089 | 2075 | 55 |
1768032 | 1768032 | 2021-09-30 | Miller | Arkansas | 5091 | 6190 | 44 |
1768033 | 1768033 | 2021-09-30 | Mississippi | Arkansas | 5093 | 7951 | 129 |
1768034 | 1768034 | 2021-09-30 | Monroe | Arkansas | 5095 | 1170 | 21 |
1768035 | 1768035 | 2021-09-30 | Montgomery | Arkansas | 5097 | 1103 | 40 |
1768036 | 1768036 | 2021-09-30 | Nevada | Arkansas | 5099 | 1301 | 30 |
1768037 | 1768037 | 2021-09-30 | Newton | Arkansas | 5101 | 1149 | 34 |
1768038 | 1768038 | 2021-09-30 | Ouachita | Arkansas | 5103 | 3352 | 75 |
1768039 | 1768039 | 2021-09-30 | Perry | Arkansas | 5105 | 1448 | 20 |
1768040 | 1768040 | 2021-09-30 | Phillips | Arkansas | 5107 | 3108 | 69 |
1768041 | 1768041 | 2021-09-30 | Pike | Arkansas | 5109 | 1643 | 35 |
1768042 | 1768042 | 2021-09-30 | Poinsett | Arkansas | 5111 | 4734 | 96 |
1768043 | 1768043 | 2021-09-30 | Polk | Arkansas | 5113 | 2862 | 98 |
1768044 | 1768044 | 2021-09-30 | Pope | Arkansas | 5115 | 11611 | 149 |
1768045 | 1768045 | 2021-09-30 | Prairie | Arkansas | 5117 | 1270 | 28 |
1768046 | 1768046 | 2021-09-30 | Pulaski | Arkansas | 5119 | 57351 | 876 |
1768047 | 1768047 | 2021-09-30 | Randolph | Arkansas | 5121 | 3150 | 51 |
1768048 | 1768048 | 2021-09-30 | Saline | Arkansas | 5125 | 18058 | 235 |
1768049 | 1768049 | 2021-09-30 | Scott | Arkansas | 5127 | 1655 | 25 |
1768050 | 1768050 | 2021-09-30 | Searcy | Arkansas | 5129 | 1230 | 24 |
1768051 | 1768051 | 2021-09-30 | Sebastian | Arkansas | 5131 | 21564 | 345 |
1768052 | 1768052 | 2021-09-30 | Sevier | Arkansas | 5133 | 3686 | 34 |
1768053 | 1768053 | 2021-09-30 | Sharp | Arkansas | 5135 | 2698 | 62 |
1768054 | 1768054 | 2021-09-30 | St. Francis | Arkansas | 5123 | 4658 | 59 |
1768055 | 1768055 | 2021-09-30 | Stone | Arkansas | 5137 | 1611 | 40 |
1768056 | 1768056 | 2021-09-30 | Union | Arkansas | 5139 | 5495 | 128 |
1768057 | 1768057 | 2021-09-30 | Unknown | Arkansas | 5506 | 0 | |
1768058 | 1768058 | 2021-09-30 | Van Buren | Arkansas | 5141 | 2101 | 37 |
1768059 | 1768059 | 2021-09-30 | Washington | Arkansas | 5143 | 43298 | 455 |
1768060 | 1768060 | 2021-09-30 | White | Arkansas | 5145 | 12754 | 181 |
1768061 | 1768061 | 2021-09-30 | Woodruff | Arkansas | 5147 | 1062 | 23 |
1768062 | 1768062 | 2021-09-30 | Yell | Arkansas | 5149 | 4516 | 76 |
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);