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-02-27 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 |
---|---|---|---|---|---|---|---|
2255604 | 2255604 | 2022-02-27 | Arkansas | Arkansas | 5001 | 5631 | 75 |
2255605 | 2255605 | 2022-02-27 | Ashley | Arkansas | 5003 | 5060 | 59 |
2255606 | 2255606 | 2022-02-27 | Baxter | Arkansas | 5005 | 8517 | 231 |
2255607 | 2255607 | 2022-02-27 | Benton | Arkansas | 5007 | 65747 | 776 |
2255608 | 2255608 | 2022-02-27 | Boone | Arkansas | 5009 | 9287 | 161 |
2255609 | 2255609 | 2022-02-27 | Bradley | Arkansas | 5011 | 2974 | 45 |
2255610 | 2255610 | 2022-02-27 | Calhoun | Arkansas | 5013 | 932 | 9 |
2255611 | 2255611 | 2022-02-27 | Carroll | Arkansas | 5015 | 5988 | 94 |
2255612 | 2255612 | 2022-02-27 | Chicot | Arkansas | 5017 | 2742 | 54 |
2255613 | 2255613 | 2022-02-27 | Clark | Arkansas | 5019 | 5181 | 74 |
2255614 | 2255614 | 2022-02-27 | Clay | Arkansas | 5021 | 4059 | 88 |
2255615 | 2255615 | 2022-02-27 | Cleburne | Arkansas | 5023 | 6359 | 118 |
2255616 | 2255616 | 2022-02-27 | Cleveland | Arkansas | 5025 | 2240 | 35 |
2255617 | 2255617 | 2022-02-27 | Columbia | Arkansas | 5027 | 5270 | 85 |
2255618 | 2255618 | 2022-02-27 | Conway | Arkansas | 5029 | 5402 | 58 |
2255619 | 2255619 | 2022-02-27 | Craighead | Arkansas | 5031 | 36549 | 313 |
2255620 | 2255620 | 2022-02-27 | Crawford | Arkansas | 5033 | 15676 | 232 |
2255621 | 2255621 | 2022-02-27 | Crittenden | Arkansas | 5035 | 13756 | 209 |
2255622 | 2255622 | 2022-02-27 | Cross | Arkansas | 5037 | 4732 | 75 |
2255623 | 2255623 | 2022-02-27 | Dallas | Arkansas | 5039 | 1728 | 29 |
2255624 | 2255624 | 2022-02-27 | Desha | Arkansas | 5041 | 3001 | 38 |
2255625 | 2255625 | 2022-02-27 | Drew | Arkansas | 5043 | 4631 | 62 |
2255626 | 2255626 | 2022-02-27 | Faulkner | Arkansas | 5045 | 34672 | 298 |
2255627 | 2255627 | 2022-02-27 | Franklin | Arkansas | 5047 | 3748 | 68 |
2255628 | 2255628 | 2022-02-27 | Fulton | Arkansas | 5049 | 2638 | 83 |
2255629 | 2255629 | 2022-02-27 | Garland | Arkansas | 5051 | 22499 | 470 |
2255630 | 2255630 | 2022-02-27 | Grant | Arkansas | 5053 | 4359 | 58 |
2255631 | 2255631 | 2022-02-27 | Greene | Arkansas | 5055 | 15658 | 163 |
2255632 | 2255632 | 2022-02-27 | Hempstead | Arkansas | 5057 | 4466 | 57 |
2255633 | 2255633 | 2022-02-27 | Hot Spring | Arkansas | 5059 | 10966 | 122 |
2255634 | 2255634 | 2022-02-27 | Howard | Arkansas | 5061 | 3719 | 48 |
2255635 | 2255635 | 2022-02-27 | Independence | Arkansas | 5063 | 10513 | 195 |
2255636 | 2255636 | 2022-02-27 | Izard | Arkansas | 5065 | 3854 | 64 |
2255637 | 2255637 | 2022-02-27 | Jackson | Arkansas | 5067 | 5946 | 54 |
2255638 | 2255638 | 2022-02-27 | Jefferson | Arkansas | 5069 | 18485 | 261 |
2255639 | 2255639 | 2022-02-27 | Johnson | Arkansas | 5071 | 6606 | 69 |
2255640 | 2255640 | 2022-02-27 | Lafayette | Arkansas | 5073 | 1271 | 28 |
2255641 | 2255641 | 2022-02-27 | Lawrence | Arkansas | 5075 | 5091 | 69 |
2255642 | 2255642 | 2022-02-27 | Lee | Arkansas | 5077 | 2868 | 56 |
2255643 | 2255643 | 2022-02-27 | Lincoln | Arkansas | 5079 | 4895 | 63 |
2255644 | 2255644 | 2022-02-27 | Little River | Arkansas | 5081 | 3214 | 87 |
2255645 | 2255645 | 2022-02-27 | Logan | Arkansas | 5083 | 5026 | 69 |
2255646 | 2255646 | 2022-02-27 | Lonoke | Arkansas | 5085 | 19598 | 224 |
2255647 | 2255647 | 2022-02-27 | Madison | Arkansas | 5087 | 3851 | 58 |
2255648 | 2255648 | 2022-02-27 | Marion | Arkansas | 5089 | 3302 | 83 |
2255649 | 2255649 | 2022-02-27 | Miller | Arkansas | 5091 | 9329 | 159 |
2255650 | 2255650 | 2022-02-27 | Mississippi | Arkansas | 5093 | 13083 | 186 |
2255651 | 2255651 | 2022-02-27 | Monroe | Arkansas | 5095 | 1913 | 31 |
2255652 | 2255652 | 2022-02-27 | Montgomery | Arkansas | 5097 | 1486 | 54 |
2255653 | 2255653 | 2022-02-27 | Nevada | Arkansas | 5099 | 2147 | 44 |
2255654 | 2255654 | 2022-02-27 | Newton | Arkansas | 5101 | 1700 | 45 |
2255655 | 2255655 | 2022-02-27 | Ouachita | Arkansas | 5103 | 5380 | 95 |
2255656 | 2255656 | 2022-02-27 | Perry | Arkansas | 5105 | 2475 | 32 |
2255657 | 2255657 | 2022-02-27 | Phillips | Arkansas | 5107 | 4729 | 93 |
2255658 | 2255658 | 2022-02-27 | Pike | Arkansas | 5109 | 2522 | 40 |
2255659 | 2255659 | 2022-02-27 | Poinsett | Arkansas | 5111 | 7820 | 117 |
2255660 | 2255660 | 2022-02-27 | Polk | Arkansas | 5113 | 4063 | 134 |
2255661 | 2255661 | 2022-02-27 | Pope | Arkansas | 5115 | 18228 | 191 |
2255662 | 2255662 | 2022-02-27 | Prairie | Arkansas | 5117 | 1948 | 39 |
2255663 | 2255663 | 2022-02-27 | Pulaski | Arkansas | 5119 | 101692 | 1115 |
2255664 | 2255664 | 2022-02-27 | Randolph | Arkansas | 5121 | 4841 | 80 |
2255665 | 2255665 | 2022-02-27 | Saline | Arkansas | 5125 | 30397 | 306 |
2255666 | 2255666 | 2022-02-27 | Scott | Arkansas | 5127 | 2261 | 38 |
2255667 | 2255667 | 2022-02-27 | Searcy | Arkansas | 5129 | 2060 | 41 |
2255668 | 2255668 | 2022-02-27 | Sebastian | Arkansas | 5131 | 32381 | 485 |
2255669 | 2255669 | 2022-02-27 | Sevier | Arkansas | 5133 | 5760 | 68 |
2255670 | 2255670 | 2022-02-27 | Sharp | Arkansas | 5135 | 4572 | 98 |
2255671 | 2255671 | 2022-02-27 | St. Francis | Arkansas | 5123 | 7028 | 84 |
2255672 | 2255672 | 2022-02-27 | Stone | Arkansas | 5137 | 2872 | 60 |
2255673 | 2255673 | 2022-02-27 | Union | Arkansas | 5139 | 9068 | 161 |
2255674 | 2255674 | 2022-02-27 | Unknown | Arkansas | 26114 | 0 | |
2255675 | 2255675 | 2022-02-27 | Van Buren | Arkansas | 5141 | 3430 | 56 |
2255676 | 2255676 | 2022-02-27 | Washington | Arkansas | 5143 | 67317 | 584 |
2255677 | 2255677 | 2022-02-27 | White | Arkansas | 5145 | 21633 | 266 |
2255678 | 2255678 | 2022-02-27 | Woodruff | Arkansas | 5147 | 1706 | 26 |
2255679 | 2255679 | 2022-02-27 | Yell | Arkansas | 5149 | 6764 | 102 |
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);