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-07-15 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 |
---|---|---|---|---|---|---|---|
1517865 | 1517865 | 2021-07-15 | Arkansas | Arkansas | 5001 | 2336 | 40 |
1517866 | 1517866 | 2021-07-15 | Ashley | Arkansas | 5003 | 2088 | 37 |
1517867 | 1517867 | 2021-07-15 | Baxter | Arkansas | 5005 | 3897 | 111 |
1517868 | 1517868 | 2021-07-15 | Benton | Arkansas | 5007 | 30673 | 429 |
1517869 | 1517869 | 2021-07-15 | Boone | Arkansas | 5009 | 4350 | 80 |
1517870 | 1517870 | 2021-07-15 | Bradley | Arkansas | 5011 | 1518 | 33 |
1517871 | 1517871 | 2021-07-15 | Calhoun | Arkansas | 5013 | 437 | 3 |
1517872 | 1517872 | 2021-07-15 | Carroll | Arkansas | 5015 | 3027 | 47 |
1517873 | 1517873 | 2021-07-15 | Chicot | Arkansas | 5017 | 1634 | 41 |
1517874 | 1517874 | 2021-07-15 | Clark | Arkansas | 5019 | 2311 | 40 |
1517875 | 1517875 | 2021-07-15 | Clay | Arkansas | 5021 | 1831 | 52 |
1517876 | 1517876 | 2021-07-15 | Cleburne | Arkansas | 5023 | 2187 | 74 |
1517877 | 1517877 | 2021-07-15 | Cleveland | Arkansas | 5025 | 1031 | 26 |
1517878 | 1517878 | 2021-07-15 | Columbia | Arkansas | 5027 | 2470 | 58 |
1517879 | 1517879 | 2021-07-15 | Conway | Arkansas | 5029 | 2316 | 36 |
1517880 | 1517880 | 2021-07-15 | Craighead | Arkansas | 5031 | 14181 | 187 |
1517881 | 1517881 | 2021-07-15 | Crawford | Arkansas | 5033 | 7390 | 121 |
1517882 | 1517882 | 2021-07-15 | Crittenden | Arkansas | 5035 | 6248 | 97 |
1517883 | 1517883 | 2021-07-15 | Cross | Arkansas | 5037 | 2022 | 52 |
1517884 | 1517884 | 2021-07-15 | Dallas | Arkansas | 5039 | 862 | 16 |
1517885 | 1517885 | 2021-07-15 | Desha | Arkansas | 5041 | 1416 | 23 |
1517886 | 1517886 | 2021-07-15 | Drew | Arkansas | 5043 | 2133 | 46 |
1517887 | 1517887 | 2021-07-15 | Faulkner | Arkansas | 5045 | 13798 | 168 |
1517888 | 1517888 | 2021-07-15 | Franklin | Arkansas | 5047 | 1748 | 41 |
1517889 | 1517889 | 2021-07-15 | Fulton | Arkansas | 5049 | 1222 | 47 |
1517890 | 1517890 | 2021-07-15 | Garland | Arkansas | 5051 | 11043 | 266 |
1517891 | 1517891 | 2021-07-15 | Grant | Arkansas | 5053 | 1880 | 38 |
1517892 | 1517892 | 2021-07-15 | Greene | Arkansas | 5055 | 6421 | 80 |
1517893 | 1517893 | 2021-07-15 | Hempstead | Arkansas | 5057 | 2123 | 20 |
1517894 | 1517894 | 2021-07-15 | Hot Spring | Arkansas | 5059 | 5565 | 78 |
1517895 | 1517895 | 2021-07-15 | Howard | Arkansas | 5061 | 1705 | 25 |
1517896 | 1517896 | 2021-07-15 | Independence | Arkansas | 5063 | 4158 | 126 |
1517897 | 1517897 | 2021-07-15 | Izard | Arkansas | 5065 | 1808 | 43 |
1517898 | 1517898 | 2021-07-15 | Jackson | Arkansas | 5067 | 3297 | 38 |
1517899 | 1517899 | 2021-07-15 | Jefferson | Arkansas | 5069 | 9593 | 173 |
1517900 | 1517900 | 2021-07-15 | Johnson | Arkansas | 5071 | 3034 | 38 |
1517901 | 1517901 | 2021-07-15 | Lafayette | Arkansas | 5073 | 570 | 9 |
1517902 | 1517902 | 2021-07-15 | Lawrence | Arkansas | 5075 | 2223 | 43 |
1517903 | 1517903 | 2021-07-15 | Lee | Arkansas | 5077 | 1733 | 39 |
1517904 | 1517904 | 2021-07-15 | Lincoln | Arkansas | 5079 | 3281 | 48 |
1517905 | 1517905 | 2021-07-15 | Little River | Arkansas | 5081 | 1292 | 43 |
1517906 | 1517906 | 2021-07-15 | Logan | Arkansas | 5083 | 2339 | 25 |
1517907 | 1517907 | 2021-07-15 | Lonoke | Arkansas | 5085 | 8139 | 131 |
1517908 | 1517908 | 2021-07-15 | Madison | Arkansas | 5087 | 1579 | 23 |
1517909 | 1517909 | 2021-07-15 | Marion | Arkansas | 5089 | 1283 | 31 |
1517910 | 1517910 | 2021-07-15 | Miller | Arkansas | 5091 | 4519 | 37 |
1517911 | 1517911 | 2021-07-15 | Mississippi | Arkansas | 5093 | 5969 | 110 |
1517912 | 1517912 | 2021-07-15 | Monroe | Arkansas | 5095 | 921 | 18 |
1517913 | 1517913 | 2021-07-15 | Montgomery | Arkansas | 5097 | 774 | 33 |
1517914 | 1517914 | 2021-07-15 | Nevada | Arkansas | 5099 | 909 | 25 |
1517915 | 1517915 | 2021-07-15 | Newton | Arkansas | 5101 | 826 | 26 |
1517916 | 1517916 | 2021-07-15 | Ouachita | Arkansas | 5103 | 2533 | 63 |
1517917 | 1517917 | 2021-07-15 | Perry | Arkansas | 5105 | 961 | 11 |
1517918 | 1517918 | 2021-07-15 | Phillips | Arkansas | 5107 | 1909 | 45 |
1517919 | 1517919 | 2021-07-15 | Pike | Arkansas | 5109 | 1069 | 23 |
1517920 | 1517920 | 2021-07-15 | Poinsett | Arkansas | 5111 | 3305 | 79 |
1517921 | 1517921 | 2021-07-15 | Polk | Arkansas | 5113 | 2064 | 74 |
1517922 | 1517922 | 2021-07-15 | Pope | Arkansas | 5115 | 8337 | 112 |
1517923 | 1517923 | 2021-07-15 | Prairie | Arkansas | 5117 | 941 | 22 |
1517924 | 1517924 | 2021-07-15 | Pulaski | Arkansas | 5119 | 43266 | 685 |
1517925 | 1517925 | 2021-07-15 | Randolph | Arkansas | 5121 | 2262 | 48 |
1517926 | 1517926 | 2021-07-15 | Saline | Arkansas | 5125 | 13276 | 175 |
1517927 | 1517927 | 2021-07-15 | Scott | Arkansas | 5127 | 1035 | 14 |
1517928 | 1517928 | 2021-07-15 | Searcy | Arkansas | 5129 | 861 | 18 |
1517929 | 1517929 | 2021-07-15 | Sebastian | Arkansas | 5131 | 15876 | 287 |
1517930 | 1517930 | 2021-07-15 | Sevier | Arkansas | 5133 | 2867 | 24 |
1517931 | 1517931 | 2021-07-15 | Sharp | Arkansas | 5135 | 1726 | 48 |
1517932 | 1517932 | 2021-07-15 | St. Francis | Arkansas | 5123 | 3714 | 45 |
1517933 | 1517933 | 2021-07-15 | Stone | Arkansas | 5137 | 1140 | 31 |
1517934 | 1517934 | 2021-07-15 | Union | Arkansas | 5139 | 4173 | 116 |
1517935 | 1517935 | 2021-07-15 | Unknown | Arkansas | 3059 | 0 | |
1517936 | 1517936 | 2021-07-15 | Van Buren | Arkansas | 5141 | 1480 | 24 |
1517937 | 1517937 | 2021-07-15 | Washington | Arkansas | 5143 | 32284 | 360 |
1517938 | 1517938 | 2021-07-15 | White | Arkansas | 5145 | 8833 | 126 |
1517939 | 1517939 | 2021-07-15 | Woodruff | Arkansas | 5147 | 660 | 14 |
1517940 | 1517940 | 2021-07-15 | Yell | Arkansas | 5149 | 3497 | 66 |
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);