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-01-18 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 |
---|---|---|---|---|---|---|---|
940019 | 940019 | 2021-01-18 | Arkansas | Arkansas | 5001 | 1566 | 35 |
940020 | 940020 | 2021-01-18 | Ashley | Arkansas | 5003 | 1490 | 24 |
940021 | 940021 | 2021-01-18 | Baxter | Arkansas | 5005 | 2472 | 85 |
940022 | 940022 | 2021-01-18 | Benton | Arkansas | 5007 | 23121 | 311 |
940023 | 940023 | 2021-01-18 | Boone | Arkansas | 5009 | 3014 | 72 |
940024 | 940024 | 2021-01-18 | Bradley | Arkansas | 5011 | 1166 | 24 |
940025 | 940025 | 2021-01-18 | Calhoun | Arkansas | 5013 | 293 | 2 |
940026 | 940026 | 2021-01-18 | Carroll | Arkansas | 5015 | 2408 | 34 |
940027 | 940027 | 2021-01-18 | Chicot | Arkansas | 5017 | 1505 | 35 |
940028 | 940028 | 2021-01-18 | Clark | Arkansas | 5019 | 1655 | 30 |
940029 | 940029 | 2021-01-18 | Clay | Arkansas | 5021 | 1479 | 39 |
940030 | 940030 | 2021-01-18 | Cleburne | Arkansas | 5023 | 1614 | 45 |
940031 | 940031 | 2021-01-18 | Cleveland | Arkansas | 5025 | 688 | 23 |
940032 | 940032 | 2021-01-18 | Columbia | Arkansas | 5027 | 1798 | 47 |
940033 | 940033 | 2021-01-18 | Conway | Arkansas | 5029 | 1789 | 21 |
940034 | 940034 | 2021-01-18 | Craighead | Arkansas | 5031 | 11567 | 154 |
940035 | 940035 | 2021-01-18 | Crawford | Arkansas | 5033 | 5610 | 75 |
940036 | 940036 | 2021-01-18 | Crittenden | Arkansas | 5035 | 5078 | 79 |
940037 | 940037 | 2021-01-18 | Cross | Arkansas | 5037 | 1709 | 41 |
940038 | 940038 | 2021-01-18 | Dallas | Arkansas | 5039 | 612 | 12 |
940039 | 940039 | 2021-01-18 | Desha | Arkansas | 5041 | 1091 | 14 |
940040 | 940040 | 2021-01-18 | Drew | Arkansas | 5043 | 1718 | 26 |
940041 | 940041 | 2021-01-18 | Faulkner | Arkansas | 5045 | 9642 | 120 |
940042 | 940042 | 2021-01-18 | Franklin | Arkansas | 5047 | 1348 | 28 |
940043 | 940043 | 2021-01-18 | Fulton | Arkansas | 5049 | 999 | 38 |
940044 | 940044 | 2021-01-18 | Garland | Arkansas | 5051 | 7552 | 187 |
940045 | 940045 | 2021-01-18 | Grant | Arkansas | 5053 | 1275 | 25 |
940046 | 940046 | 2021-01-18 | Greene | Arkansas | 5055 | 5124 | 60 |
940047 | 940047 | 2021-01-18 | Hempstead | Arkansas | 5057 | 1464 | 11 |
940048 | 940048 | 2021-01-18 | Hot Spring | Arkansas | 5059 | 4115 | 61 |
940049 | 940049 | 2021-01-18 | Howard | Arkansas | 5061 | 1248 | 20 |
940050 | 940050 | 2021-01-18 | Independence | Arkansas | 5063 | 3263 | 106 |
940051 | 940051 | 2021-01-18 | Izard | Arkansas | 5065 | 1476 | 28 |
940052 | 940052 | 2021-01-18 | Jackson | Arkansas | 5067 | 3005 | 29 |
940053 | 940053 | 2021-01-18 | Jefferson | Arkansas | 5069 | 7493 | 139 |
940054 | 940054 | 2021-01-18 | Johnson | Arkansas | 5071 | 2294 | 26 |
940055 | 940055 | 2021-01-18 | Lafayette | Arkansas | 5073 | 395 | 7 |
940056 | 940056 | 2021-01-18 | Lawrence | Arkansas | 5075 | 1811 | 40 |
940057 | 940057 | 2021-01-18 | Lee | Arkansas | 5077 | 1563 | 29 |
940058 | 940058 | 2021-01-18 | Lincoln | Arkansas | 5079 | 2958 | 29 |
940059 | 940059 | 2021-01-18 | Little River | Arkansas | 5081 | 956 | 39 |
940060 | 940060 | 2021-01-18 | Logan | Arkansas | 5083 | 1788 | 13 |
940061 | 940061 | 2021-01-18 | Lonoke | Arkansas | 5085 | 5295 | 96 |
940062 | 940062 | 2021-01-18 | Madison | Arkansas | 5087 | 1213 | 15 |
940063 | 940063 | 2021-01-18 | Marion | Arkansas | 5089 | 794 | 27 |
940064 | 940064 | 2021-01-18 | Miller | Arkansas | 5091 | 3138 | 26 |
940065 | 940065 | 2021-01-18 | Mississippi | Arkansas | 5093 | 4900 | 101 |
940066 | 940066 | 2021-01-18 | Monroe | Arkansas | 5095 | 616 | 11 |
940067 | 940067 | 2021-01-18 | Montgomery | Arkansas | 5097 | 621 | 22 |
940068 | 940068 | 2021-01-18 | Nevada | Arkansas | 5099 | 649 | 22 |
940069 | 940069 | 2021-01-18 | Newton | Arkansas | 5101 | 610 | 26 |
940070 | 940070 | 2021-01-18 | Ouachita | Arkansas | 5103 | 1756 | 39 |
940071 | 940071 | 2021-01-18 | Perry | Arkansas | 5105 | 617 | 6 |
940072 | 940072 | 2021-01-18 | Phillips | Arkansas | 5107 | 1488 | 29 |
940073 | 940073 | 2021-01-18 | Pike | Arkansas | 5109 | 841 | 15 |
940074 | 940074 | 2021-01-18 | Poinsett | Arkansas | 5111 | 2746 | 70 |
940075 | 940075 | 2021-01-18 | Polk | Arkansas | 5113 | 1547 | 51 |
940076 | 940076 | 2021-01-18 | Pope | Arkansas | 5115 | 6642 | 74 |
940077 | 940077 | 2021-01-18 | Prairie | Arkansas | 5117 | 674 | 17 |
940078 | 940078 | 2021-01-18 | Pulaski | Arkansas | 5119 | 30453 | 452 |
940079 | 940079 | 2021-01-18 | Randolph | Arkansas | 5121 | 1736 | 44 |
940080 | 940080 | 2021-01-18 | Saline | Arkansas | 5125 | 9467 | 129 |
940081 | 940081 | 2021-01-18 | Scott | Arkansas | 5127 | 786 | 14 |
940082 | 940082 | 2021-01-18 | Searcy | Arkansas | 5129 | 574 | 14 |
940083 | 940083 | 2021-01-18 | Sebastian | Arkansas | 5131 | 12365 | 184 |
940084 | 940084 | 2021-01-18 | Sevier | Arkansas | 5133 | 2263 | 23 |
940085 | 940085 | 2021-01-18 | Sharp | Arkansas | 5135 | 1380 | 38 |
940086 | 940086 | 2021-01-18 | St. Francis | Arkansas | 5123 | 3171 | 28 |
940087 | 940087 | 2021-01-18 | Stone | Arkansas | 5137 | 874 | 27 |
940088 | 940088 | 2021-01-18 | Union | Arkansas | 5139 | 2997 | 83 |
940089 | 940089 | 2021-01-18 | Unknown | Arkansas | 2781 | 0 | |
940090 | 940090 | 2021-01-18 | Van Buren | Arkansas | 5141 | 978 | 10 |
940091 | 940091 | 2021-01-18 | Washington | Arkansas | 5143 | 25796 | 250 |
940092 | 940092 | 2021-01-18 | White | Arkansas | 5145 | 5937 | 76 |
940093 | 940093 | 2021-01-18 | Woodruff | Arkansas | 5147 | 492 | 5 |
940094 | 940094 | 2021-01-18 | Yell | Arkansas | 5149 | 2854 | 56 |
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);