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 2022-05-06 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 |
---|---|---|---|---|---|---|---|
2476881 | 2476881 | 2022-05-06 | Arkansas | Arkansas | 5001 | 5690 | 79 |
2476882 | 2476882 | 2022-05-06 | Ashley | Arkansas | 5003 | 5114 | 66 |
2476883 | 2476883 | 2022-05-06 | Baxter | Arkansas | 5005 | 8826 | 247 |
2476884 | 2476884 | 2022-05-06 | Benton | Arkansas | 5007 | 66941 | 847 |
2476885 | 2476885 | 2022-05-06 | Boone | Arkansas | 5009 | 9454 | 180 |
2476886 | 2476886 | 2022-05-06 | Bradley | Arkansas | 5011 | 2995 | 49 |
2476887 | 2476887 | 2022-05-06 | Calhoun | Arkansas | 5013 | 965 | 10 |
2476888 | 2476888 | 2022-05-06 | Carroll | Arkansas | 5015 | 6127 | 102 |
2476889 | 2476889 | 2022-05-06 | Chicot | Arkansas | 5017 | 2777 | 60 |
2476890 | 2476890 | 2022-05-06 | Clark | Arkansas | 5019 | 5349 | 79 |
2476891 | 2476891 | 2022-05-06 | Clay | Arkansas | 5021 | 4149 | 93 |
2476892 | 2476892 | 2022-05-06 | Cleburne | Arkansas | 5023 | 6461 | 128 |
2476893 | 2476893 | 2022-05-06 | Cleveland | Arkansas | 5025 | 2264 | 36 |
2476894 | 2476894 | 2022-05-06 | Columbia | Arkansas | 5027 | 5428 | 95 |
2476895 | 2476895 | 2022-05-06 | Conway | Arkansas | 5029 | 5484 | 65 |
2476896 | 2476896 | 2022-05-06 | Craighead | Arkansas | 5031 | 37702 | 329 |
2476897 | 2476897 | 2022-05-06 | Crawford | Arkansas | 5033 | 15858 | 249 |
2476898 | 2476898 | 2022-05-06 | Crittenden | Arkansas | 5035 | 14289 | 226 |
2476899 | 2476899 | 2022-05-06 | Cross | Arkansas | 5037 | 4833 | 83 |
2476900 | 2476900 | 2022-05-06 | Dallas | Arkansas | 5039 | 1745 | 31 |
2476901 | 2476901 | 2022-05-06 | Desha | Arkansas | 5041 | 3030 | 41 |
2476902 | 2476902 | 2022-05-06 | Drew | Arkansas | 5043 | 4685 | 70 |
2476903 | 2476903 | 2022-05-06 | Faulkner | Arkansas | 5045 | 35173 | 315 |
2476904 | 2476904 | 2022-05-06 | Franklin | Arkansas | 5047 | 3815 | 73 |
2476905 | 2476905 | 2022-05-06 | Fulton | Arkansas | 5049 | 2692 | 90 |
2476906 | 2476906 | 2022-05-06 | Garland | Arkansas | 5051 | 23337 | 510 |
2476907 | 2476907 | 2022-05-06 | Grant | Arkansas | 5053 | 4464 | 61 |
2476908 | 2476908 | 2022-05-06 | Greene | Arkansas | 5055 | 16065 | 173 |
2476909 | 2476909 | 2022-05-06 | Hempstead | Arkansas | 5057 | 4566 | 68 |
2476910 | 2476910 | 2022-05-06 | Hot Spring | Arkansas | 5059 | 11215 | 135 |
2476911 | 2476911 | 2022-05-06 | Howard | Arkansas | 5061 | 3761 | 50 |
2476912 | 2476912 | 2022-05-06 | Independence | Arkansas | 5063 | 10627 | 212 |
2476913 | 2476913 | 2022-05-06 | Izard | Arkansas | 5065 | 3902 | 70 |
2476914 | 2476914 | 2022-05-06 | Jackson | Arkansas | 5067 | 6129 | 63 |
2476915 | 2476915 | 2022-05-06 | Jefferson | Arkansas | 5069 | 18601 | 277 |
2476916 | 2476916 | 2022-05-06 | Johnson | Arkansas | 5071 | 6819 | 87 |
2476917 | 2476917 | 2022-05-06 | Lafayette | Arkansas | 5073 | 1298 | 31 |
2476918 | 2476918 | 2022-05-06 | Lawrence | Arkansas | 5075 | 5314 | 78 |
2476919 | 2476919 | 2022-05-06 | Lee | Arkansas | 5077 | 2912 | 59 |
2476920 | 2476920 | 2022-05-06 | Lincoln | Arkansas | 5079 | 4918 | 68 |
2476921 | 2476921 | 2022-05-06 | Little River | Arkansas | 5081 | 3280 | 104 |
2476922 | 2476922 | 2022-05-06 | Logan | Arkansas | 5083 | 5126 | 80 |
2476923 | 2476923 | 2022-05-06 | Lonoke | Arkansas | 5085 | 19926 | 243 |
2476924 | 2476924 | 2022-05-06 | Madison | Arkansas | 5087 | 3966 | 61 |
2476925 | 2476925 | 2022-05-06 | Marion | Arkansas | 5089 | 3401 | 88 |
2476926 | 2476926 | 2022-05-06 | Miller | Arkansas | 5091 | 9591 | 181 |
2476927 | 2476927 | 2022-05-06 | Mississippi | Arkansas | 5093 | 13595 | 209 |
2476928 | 2476928 | 2022-05-06 | Monroe | Arkansas | 5095 | 1933 | 35 |
2476929 | 2476929 | 2022-05-06 | Montgomery | Arkansas | 5097 | 1524 | 57 |
2476930 | 2476930 | 2022-05-06 | Nevada | Arkansas | 5099 | 2185 | 46 |
2476931 | 2476931 | 2022-05-06 | Newton | Arkansas | 5101 | 1718 | 47 |
2476932 | 2476932 | 2022-05-06 | Ouachita | Arkansas | 5103 | 5477 | 104 |
2476933 | 2476933 | 2022-05-06 | Perry | Arkansas | 5105 | 2520 | 37 |
2476934 | 2476934 | 2022-05-06 | Phillips | Arkansas | 5107 | 4824 | 99 |
2476935 | 2476935 | 2022-05-06 | Pike | Arkansas | 5109 | 2617 | 44 |
2476936 | 2476936 | 2022-05-06 | Poinsett | Arkansas | 5111 | 8047 | 127 |
2476937 | 2476937 | 2022-05-06 | Polk | Arkansas | 5113 | 4147 | 149 |
2476938 | 2476938 | 2022-05-06 | Pope | Arkansas | 5115 | 18445 | 209 |
2476939 | 2476939 | 2022-05-06 | Prairie | Arkansas | 5117 | 1963 | 43 |
2476940 | 2476940 | 2022-05-06 | Pulaski | Arkansas | 5119 | 103641 | 1181 |
2476941 | 2476941 | 2022-05-06 | Randolph | Arkansas | 5121 | 5205 | 89 |
2476942 | 2476942 | 2022-05-06 | Saline | Arkansas | 5125 | 30964 | 338 |
2476943 | 2476943 | 2022-05-06 | Scott | Arkansas | 5127 | 2295 | 43 |
2476944 | 2476944 | 2022-05-06 | Searcy | Arkansas | 5129 | 2123 | 48 |
2476945 | 2476945 | 2022-05-06 | Sebastian | Arkansas | 5131 | 32788 | 526 |
2476946 | 2476946 | 2022-05-06 | Sevier | Arkansas | 5133 | 5940 | 75 |
2476947 | 2476947 | 2022-05-06 | Sharp | Arkansas | 5135 | 4638 | 105 |
2476948 | 2476948 | 2022-05-06 | St. Francis | Arkansas | 5123 | 7164 | 96 |
2476949 | 2476949 | 2022-05-06 | Stone | Arkansas | 5137 | 2916 | 68 |
2476950 | 2476950 | 2022-05-06 | Union | Arkansas | 5139 | 9261 | 176 |
2476951 | 2476951 | 2022-05-06 | Unknown | Arkansas | 26983 | 0 | |
2476952 | 2476952 | 2022-05-06 | Van Buren | Arkansas | 5141 | 3483 | 62 |
2476953 | 2476953 | 2022-05-06 | Washington | Arkansas | 5143 | 68643 | 620 |
2476954 | 2476954 | 2022-05-06 | White | Arkansas | 5145 | 22138 | 292 |
2476955 | 2476955 | 2022-05-06 | Woodruff | Arkansas | 5147 | 1730 | 31 |
2476956 | 2476956 | 2022-05-06 | Yell | Arkansas | 5149 | 6858 | 106 |
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);