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 2020-08-25 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 |
---|---|---|---|---|---|---|---|
466622 | 466622 | 2020-08-25 | Arkansas | Arkansas | 5001 | 266 | 2 |
466623 | 466623 | 2020-08-25 | Ashley | Arkansas | 5003 | 380 | 7 |
466624 | 466624 | 2020-08-25 | Baxter | Arkansas | 5005 | 116 | 0 |
466625 | 466625 | 2020-08-25 | Benton | Arkansas | 5007 | 5113 | 45 |
466626 | 466626 | 2020-08-25 | Boone | Arkansas | 5009 | 274 | 1 |
466627 | 466627 | 2020-08-25 | Bradley | Arkansas | 5011 | 267 | 5 |
466628 | 466628 | 2020-08-25 | Calhoun | Arkansas | 5013 | 23 | 0 |
466629 | 466629 | 2020-08-25 | Carroll | Arkansas | 5015 | 437 | 7 |
466630 | 466630 | 2020-08-25 | Chicot | Arkansas | 5017 | 939 | 10 |
466631 | 466631 | 2020-08-25 | Clark | Arkansas | 5019 | 215 | 3 |
466632 | 466632 | 2020-08-25 | Clay | Arkansas | 5021 | 165 | 5 |
466633 | 466633 | 2020-08-25 | Cleburne | Arkansas | 5023 | 247 | 6 |
466634 | 466634 | 2020-08-25 | Cleveland | Arkansas | 5025 | 130 | 2 |
466635 | 466635 | 2020-08-25 | Columbia | Arkansas | 5027 | 284 | 13 |
466636 | 466636 | 2020-08-25 | Conway | Arkansas | 5029 | 193 | 3 |
466637 | 466637 | 2020-08-25 | Craighead | Arkansas | 5031 | 1701 | 14 |
466638 | 466638 | 2020-08-25 | Crawford | Arkansas | 5033 | 851 | 6 |
466639 | 466639 | 2020-08-25 | Crittenden | Arkansas | 5035 | 1595 | 28 |
466640 | 466640 | 2020-08-25 | Cross | Arkansas | 5037 | 244 | 4 |
466641 | 466641 | 2020-08-25 | Dallas | Arkansas | 5039 | 103 | 2 |
466642 | 466642 | 2020-08-25 | Desha | Arkansas | 5041 | 224 | 5 |
466643 | 466643 | 2020-08-25 | Drew | Arkansas | 5043 | 294 | 4 |
466644 | 466644 | 2020-08-25 | Faulkner | Arkansas | 5045 | 1579 | 7 |
466645 | 466645 | 2020-08-25 | Franklin | Arkansas | 5047 | 153 | 2 |
466646 | 466646 | 2020-08-25 | Fulton | Arkansas | 5049 | 61 | 0 |
466647 | 466647 | 2020-08-25 | Garland | Arkansas | 5051 | 1320 | 27 |
466648 | 466648 | 2020-08-25 | Grant | Arkansas | 5053 | 169 | 0 |
466649 | 466649 | 2020-08-25 | Greene | Arkansas | 5055 | 587 | 4 |
466650 | 466650 | 2020-08-25 | Hempstead | Arkansas | 5057 | 312 | 3 |
466651 | 466651 | 2020-08-25 | Hot Spring | Arkansas | 5059 | 1684 | 18 |
466652 | 466652 | 2020-08-25 | Howard | Arkansas | 5061 | 398 | 5 |
466653 | 466653 | 2020-08-25 | Independence | Arkansas | 5063 | 705 | 4 |
466654 | 466654 | 2020-08-25 | Izard | Arkansas | 5065 | 80 | 0 |
466655 | 466655 | 2020-08-25 | Jackson | Arkansas | 5067 | 175 | 1 |
466656 | 466656 | 2020-08-25 | Jefferson | Arkansas | 5069 | 1924 | 47 |
466657 | 466657 | 2020-08-25 | Johnson | Arkansas | 5071 | 742 | 3 |
466658 | 466658 | 2020-08-25 | Lafayette | Arkansas | 5073 | 65 | 2 |
466659 | 466659 | 2020-08-25 | Lawrence | Arkansas | 5075 | 245 | 10 |
466660 | 466660 | 2020-08-25 | Lee | Arkansas | 5077 | 993 | 10 |
466661 | 466661 | 2020-08-25 | Lincoln | Arkansas | 5079 | 1384 | 13 |
466662 | 466662 | 2020-08-25 | Little River | Arkansas | 5081 | 265 | 13 |
466663 | 466663 | 2020-08-25 | Logan | Arkansas | 5083 | 351 | 1 |
466664 | 466664 | 2020-08-25 | Lonoke | Arkansas | 5085 | 661 | 2 |
466665 | 466665 | 2020-08-25 | Madison | Arkansas | 5087 | 287 | 2 |
466666 | 466666 | 2020-08-25 | Marion | Arkansas | 5089 | 41 | 0 |
466667 | 466667 | 2020-08-25 | Miller | Arkansas | 5091 | 578 | 5 |
466668 | 466668 | 2020-08-25 | Mississippi | Arkansas | 5093 | 1277 | 18 |
466669 | 466669 | 2020-08-25 | Monroe | Arkansas | 5095 | 90 | 0 |
466670 | 466670 | 2020-08-25 | Montgomery | Arkansas | 5097 | 61 | 3 |
466671 | 466671 | 2020-08-25 | Nevada | Arkansas | 5099 | 158 | 11 |
466672 | 466672 | 2020-08-25 | Newton | Arkansas | 5101 | 109 | 15 |
466673 | 466673 | 2020-08-25 | Ouachita | Arkansas | 5103 | 133 | 4 |
466674 | 466674 | 2020-08-25 | Perry | Arkansas | 5105 | 58 | 0 |
466675 | 466675 | 2020-08-25 | Phillips | Arkansas | 5107 | 379 | 9 |
466676 | 466676 | 2020-08-25 | Pike | Arkansas | 5109 | 161 | 1 |
466677 | 466677 | 2020-08-25 | Poinsett | Arkansas | 5111 | 432 | 4 |
466678 | 466678 | 2020-08-25 | Polk | Arkansas | 5113 | 208 | 2 |
466679 | 466679 | 2020-08-25 | Pope | Arkansas | 5115 | 1605 | 14 |
466680 | 466680 | 2020-08-25 | Prairie | Arkansas | 5117 | 114 | 0 |
466681 | 466681 | 2020-08-25 | Pulaski | Arkansas | 5119 | 6675 | 98 |
466682 | 466682 | 2020-08-25 | Randolph | Arkansas | 5121 | 291 | 12 |
466683 | 466683 | 2020-08-25 | Saline | Arkansas | 5125 | 1409 | 10 |
466684 | 466684 | 2020-08-25 | Scott | Arkansas | 5127 | 84 | 0 |
466685 | 466685 | 2020-08-25 | Searcy | Arkansas | 5129 | 66 | 0 |
466686 | 466686 | 2020-08-25 | Sebastian | Arkansas | 5131 | 2722 | 30 |
466687 | 466687 | 2020-08-25 | Sevier | Arkansas | 5133 | 1134 | 12 |
466688 | 466688 | 2020-08-25 | Sharp | Arkansas | 5135 | 137 | 5 |
466689 | 466689 | 2020-08-25 | St. Francis | Arkansas | 5123 | 1280 | 3 |
466690 | 466690 | 2020-08-25 | Stone | Arkansas | 5137 | 159 | 1 |
466691 | 466691 | 2020-08-25 | Union | Arkansas | 5139 | 650 | 21 |
466692 | 466692 | 2020-08-25 | Unknown | Arkansas | 820 | 0 | |
466693 | 466693 | 2020-08-25 | Van Buren | Arkansas | 5141 | 99 | 2 |
466694 | 466694 | 2020-08-25 | Washington | Arkansas | 5143 | 6631 | 55 |
466695 | 466695 | 2020-08-25 | White | Arkansas | 5145 | 472 | 9 |
466696 | 466696 | 2020-08-25 | Woodruff | Arkansas | 5147 | 27 | 0 |
466697 | 466697 | 2020-08-25 | Yell | Arkansas | 5149 | 1113 | 21 |
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);