ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
75 rows where "date" is on date 2020-05-28 and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 75
- 5001 1
- 5003 1
- 5005 1
- 5007 1
- 5009 1
- 5011 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 75
- Arkansas 1
- Ashley 1
- Baxter 1
- Benton 1
- Boone 1
- Bradley 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 · 75 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
184695 | 184695 | 2020-05-28 | Arkansas | Arkansas | 5001 | 3 | 0 |
184696 | 184696 | 2020-05-28 | Ashley | Arkansas | 5003 | 19 | 0 |
184697 | 184697 | 2020-05-28 | Baxter | Arkansas | 5005 | 9 | 0 |
184698 | 184698 | 2020-05-28 | Benton | Arkansas | 5007 | 428 | 0 |
184699 | 184699 | 2020-05-28 | Boone | Arkansas | 5009 | 6 | 0 |
184700 | 184700 | 2020-05-28 | Bradley | Arkansas | 5011 | 18 | 1 |
184701 | 184701 | 2020-05-28 | Carroll | Arkansas | 5015 | 24 | 0 |
184702 | 184702 | 2020-05-28 | Chicot | Arkansas | 5017 | 15 | 0 |
184703 | 184703 | 2020-05-28 | Clark | Arkansas | 5019 | 38 | 0 |
184704 | 184704 | 2020-05-28 | Clay | Arkansas | 5021 | 4 | 0 |
184705 | 184705 | 2020-05-28 | Cleburne | Arkansas | 5023 | 73 | 4 |
184706 | 184706 | 2020-05-28 | Cleveland | Arkansas | 5025 | 18 | 0 |
184707 | 184707 | 2020-05-28 | Columbia | Arkansas | 5027 | 20 | 2 |
184708 | 184708 | 2020-05-28 | Conway | Arkansas | 5029 | 14 | 1 |
184709 | 184709 | 2020-05-28 | Craighead | Arkansas | 5031 | 203 | 0 |
184710 | 184710 | 2020-05-28 | Crawford | Arkansas | 5033 | 17 | 0 |
184711 | 184711 | 2020-05-28 | Crittenden | Arkansas | 5035 | 318 | 9 |
184712 | 184712 | 2020-05-28 | Cross | Arkansas | 5037 | 48 | 0 |
184713 | 184713 | 2020-05-28 | Dallas | Arkansas | 5039 | 1 | 0 |
184714 | 184714 | 2020-05-28 | Desha | Arkansas | 5041 | 19 | 0 |
184715 | 184715 | 2020-05-28 | Drew | Arkansas | 5043 | 19 | 1 |
184716 | 184716 | 2020-05-28 | Faulkner | Arkansas | 5045 | 101 | 3 |
184717 | 184717 | 2020-05-28 | Franklin | Arkansas | 5047 | 4 | 0 |
184718 | 184718 | 2020-05-28 | Fulton | Arkansas | 5049 | 7 | 0 |
184719 | 184719 | 2020-05-28 | Garland | Arkansas | 5051 | 136 | 1 |
184720 | 184720 | 2020-05-28 | Grant | Arkansas | 5053 | 18 | 0 |
184721 | 184721 | 2020-05-28 | Greene | Arkansas | 5055 | 60 | 0 |
184722 | 184722 | 2020-05-28 | Hempstead | Arkansas | 5057 | 14 | 1 |
184723 | 184723 | 2020-05-28 | Hot Spring | Arkansas | 5059 | 31 | 0 |
184724 | 184724 | 2020-05-28 | Howard | Arkansas | 5061 | 18 | 0 |
184725 | 184725 | 2020-05-28 | Independence | Arkansas | 5063 | 29 | 0 |
184726 | 184726 | 2020-05-28 | Izard | Arkansas | 5065 | 16 | 0 |
184727 | 184727 | 2020-05-28 | Jackson | Arkansas | 5067 | 1 | 0 |
184728 | 184728 | 2020-05-28 | Jefferson | Arkansas | 5069 | 515 | 24 |
184729 | 184729 | 2020-05-28 | Johnson | Arkansas | 5071 | 40 | 0 |
184730 | 184730 | 2020-05-28 | Lafayette | Arkansas | 5073 | 9 | 1 |
184731 | 184731 | 2020-05-28 | Lawrence | Arkansas | 5075 | 82 | 5 |
184732 | 184732 | 2020-05-28 | Lee | Arkansas | 5077 | 18 | 1 |
184733 | 184733 | 2020-05-28 | Lincoln | Arkansas | 5079 | 975 | 9 |
184734 | 184734 | 2020-05-28 | Little River | Arkansas | 5081 | 6 | 0 |
184735 | 184735 | 2020-05-28 | Logan | Arkansas | 5083 | 4 | 0 |
184736 | 184736 | 2020-05-28 | Lonoke | Arkansas | 5085 | 46 | 0 |
184737 | 184737 | 2020-05-28 | Madison | Arkansas | 5087 | 6 | 0 |
184738 | 184738 | 2020-05-28 | Marion | Arkansas | 5089 | 1 | 0 |
184739 | 184739 | 2020-05-28 | Miller | Arkansas | 5091 | 42 | 1 |
184740 | 184740 | 2020-05-28 | Mississippi | Arkansas | 5093 | 73 | 2 |
184741 | 184741 | 2020-05-28 | Monroe | Arkansas | 5095 | 5 | 0 |
184742 | 184742 | 2020-05-28 | Montgomery | Arkansas | 5097 | 2 | 0 |
184743 | 184743 | 2020-05-28 | Nevada | Arkansas | 5099 | 5 | 0 |
184744 | 184744 | 2020-05-28 | Newton | Arkansas | 5101 | 3 | 0 |
184745 | 184745 | 2020-05-28 | Ouachita | Arkansas | 5103 | 10 | 0 |
184746 | 184746 | 2020-05-28 | Perry | Arkansas | 5105 | 14 | 0 |
184747 | 184747 | 2020-05-28 | Phillips | Arkansas | 5107 | 12 | 1 |
184748 | 184748 | 2020-05-28 | Pike | Arkansas | 5109 | 5 | 0 |
184749 | 184749 | 2020-05-28 | Poinsett | Arkansas | 5111 | 31 | 2 |
184750 | 184750 | 2020-05-28 | Polk | Arkansas | 5113 | 12 | 0 |
184751 | 184751 | 2020-05-28 | Pope | Arkansas | 5115 | 129 | 1 |
184752 | 184752 | 2020-05-28 | Prairie | Arkansas | 5117 | 2 | 0 |
184753 | 184753 | 2020-05-28 | Pulaski | Arkansas | 5119 | 830 | 31 |
184754 | 184754 | 2020-05-28 | Randolph | Arkansas | 5121 | 26 | 0 |
184755 | 184755 | 2020-05-28 | Saline | Arkansas | 5125 | 108 | 1 |
184756 | 184756 | 2020-05-28 | Scott | Arkansas | 5127 | 1 | 0 |
184757 | 184757 | 2020-05-28 | Searcy | Arkansas | 5129 | 7 | 0 |
184758 | 184758 | 2020-05-28 | Sebastian | Arkansas | 5131 | 24 | 0 |
184759 | 184759 | 2020-05-28 | Sevier | Arkansas | 5133 | 131 | 2 |
184760 | 184760 | 2020-05-28 | Sharp | Arkansas | 5135 | 45 | 2 |
184761 | 184761 | 2020-05-28 | St. Francis | Arkansas | 5123 | 660 | 1 |
184762 | 184762 | 2020-05-28 | Stone | Arkansas | 5137 | 8 | 0 |
184763 | 184763 | 2020-05-28 | Union | Arkansas | 5139 | 164 | 8 |
184764 | 184764 | 2020-05-28 | Unknown | Arkansas | 199 | 0 | |
184765 | 184765 | 2020-05-28 | Van Buren | Arkansas | 5141 | 28 | 2 |
184766 | 184766 | 2020-05-28 | Washington | Arkansas | 5143 | 352 | 6 |
184767 | 184767 | 2020-05-28 | White | Arkansas | 5145 | 43 | 1 |
184768 | 184768 | 2020-05-28 | Woodruff | Arkansas | 5147 | 2 | 0 |
184769 | 184769 | 2020-05-28 | Yell | Arkansas | 5149 | 114 | 1 |
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);