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-11-12 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 |
---|---|---|---|---|---|---|---|
722583 | 722583 | 2020-11-12 | Arkansas | Arkansas | 5001 | 807 | 20 |
722584 | 722584 | 2020-11-12 | Ashley | Arkansas | 5003 | 643 | 13 |
722585 | 722585 | 2020-11-12 | Baxter | Arkansas | 5005 | 1016 | 16 |
722586 | 722586 | 2020-11-12 | Benton | Arkansas | 5007 | 9977 | 133 |
722587 | 722587 | 2020-11-12 | Boone | Arkansas | 5009 | 1308 | 40 |
722588 | 722588 | 2020-11-12 | Bradley | Arkansas | 5011 | 390 | 8 |
722589 | 722589 | 2020-11-12 | Calhoun | Arkansas | 5013 | 95 | 0 |
722590 | 722590 | 2020-11-12 | Carroll | Arkansas | 5015 | 1141 | 20 |
722591 | 722591 | 2020-11-12 | Chicot | Arkansas | 5017 | 1073 | 24 |
722592 | 722592 | 2020-11-12 | Clark | Arkansas | 5019 | 648 | 6 |
722593 | 722593 | 2020-11-12 | Clay | Arkansas | 5021 | 609 | 17 |
722594 | 722594 | 2020-11-12 | Cleburne | Arkansas | 5023 | 570 | 18 |
722595 | 722595 | 2020-11-12 | Cleveland | Arkansas | 5025 | 286 | 13 |
722596 | 722596 | 2020-11-12 | Columbia | Arkansas | 5027 | 839 | 22 |
722597 | 722597 | 2020-11-12 | Conway | Arkansas | 5029 | 453 | 5 |
722598 | 722598 | 2020-11-12 | Craighead | Arkansas | 5031 | 5766 | 59 |
722599 | 722599 | 2020-11-12 | Crawford | Arkansas | 5033 | 2519 | 33 |
722600 | 722600 | 2020-11-12 | Crittenden | Arkansas | 5035 | 2815 | 53 |
722601 | 722601 | 2020-11-12 | Cross | Arkansas | 5037 | 653 | 24 |
722602 | 722602 | 2020-11-12 | Dallas | Arkansas | 5039 | 211 | 6 |
722603 | 722603 | 2020-11-12 | Desha | Arkansas | 5041 | 469 | 8 |
722604 | 722604 | 2020-11-12 | Drew | Arkansas | 5043 | 488 | 7 |
722605 | 722605 | 2020-11-12 | Faulkner | Arkansas | 5045 | 3942 | 44 |
722606 | 722606 | 2020-11-12 | Franklin | Arkansas | 5047 | 644 | 4 |
722607 | 722607 | 2020-11-12 | Fulton | Arkansas | 5049 | 415 | 12 |
722608 | 722608 | 2020-11-12 | Garland | Arkansas | 5051 | 3053 | 82 |
722609 | 722609 | 2020-11-12 | Grant | Arkansas | 5053 | 434 | 4 |
722610 | 722610 | 2020-11-12 | Greene | Arkansas | 5055 | 2067 | 24 |
722611 | 722611 | 2020-11-12 | Hempstead | Arkansas | 5057 | 699 | 5 |
722612 | 722612 | 2020-11-12 | Hot Spring | Arkansas | 5059 | 2522 | 39 |
722613 | 722613 | 2020-11-12 | Howard | Arkansas | 5061 | 702 | 15 |
722614 | 722614 | 2020-11-12 | Independence | Arkansas | 5063 | 1795 | 68 |
722615 | 722615 | 2020-11-12 | Izard | Arkansas | 5065 | 862 | 4 |
722616 | 722616 | 2020-11-12 | Jackson | Arkansas | 5067 | 1136 | 6 |
722617 | 722617 | 2020-11-12 | Jefferson | Arkansas | 5069 | 4679 | 103 |
722618 | 722618 | 2020-11-12 | Johnson | Arkansas | 5071 | 1112 | 11 |
722619 | 722619 | 2020-11-12 | Lafayette | Arkansas | 5073 | 227 | 3 |
722620 | 722620 | 2020-11-12 | Lawrence | Arkansas | 5075 | 986 | 25 |
722621 | 722621 | 2020-11-12 | Lee | Arkansas | 5077 | 1129 | 18 |
722622 | 722622 | 2020-11-12 | Lincoln | Arkansas | 5079 | 2363 | 18 |
722623 | 722623 | 2020-11-12 | Little River | Arkansas | 5081 | 536 | 39 |
722624 | 722624 | 2020-11-12 | Logan | Arkansas | 5083 | 696 | 5 |
722625 | 722625 | 2020-11-12 | Lonoke | Arkansas | 5085 | 2180 | 36 |
722626 | 722626 | 2020-11-12 | Madison | Arkansas | 5087 | 507 | 6 |
722627 | 722627 | 2020-11-12 | Marion | Arkansas | 5089 | 246 | 2 |
722628 | 722628 | 2020-11-12 | Miller | Arkansas | 5091 | 1850 | 22 |
722629 | 722629 | 2020-11-12 | Mississippi | Arkansas | 5093 | 2732 | 73 |
722630 | 722630 | 2020-11-12 | Monroe | Arkansas | 5095 | 260 | 4 |
722631 | 722631 | 2020-11-12 | Montgomery | Arkansas | 5097 | 208 | 9 |
722632 | 722632 | 2020-11-12 | Nevada | Arkansas | 5099 | 378 | 14 |
722633 | 722633 | 2020-11-12 | Newton | Arkansas | 5101 | 360 | 21 |
722634 | 722634 | 2020-11-12 | Ouachita | Arkansas | 5103 | 465 | 9 |
722635 | 722635 | 2020-11-12 | Perry | Arkansas | 5105 | 192 | 3 |
722636 | 722636 | 2020-11-12 | Phillips | Arkansas | 5107 | 825 | 16 |
722637 | 722637 | 2020-11-12 | Pike | Arkansas | 5109 | 307 | 1 |
722638 | 722638 | 2020-11-12 | Poinsett | Arkansas | 5111 | 1414 | 32 |
722639 | 722639 | 2020-11-12 | Polk | Arkansas | 5113 | 507 | 5 |
722640 | 722640 | 2020-11-12 | Pope | Arkansas | 5115 | 3074 | 39 |
722641 | 722641 | 2020-11-12 | Prairie | Arkansas | 5117 | 308 | 5 |
722642 | 722642 | 2020-11-12 | Pulaski | Arkansas | 5119 | 13855 | 234 |
722643 | 722643 | 2020-11-12 | Randolph | Arkansas | 5121 | 799 | 27 |
722644 | 722644 | 2020-11-12 | Saline | Arkansas | 5125 | 3648 | 44 |
722645 | 722645 | 2020-11-12 | Scott | Arkansas | 5127 | 287 | 2 |
722646 | 722646 | 2020-11-12 | Searcy | Arkansas | 5129 | 241 | 1 |
722647 | 722647 | 2020-11-12 | Sebastian | Arkansas | 5131 | 5887 | 110 |
722648 | 722648 | 2020-11-12 | Sevier | Arkansas | 5133 | 1545 | 16 |
722649 | 722649 | 2020-11-12 | Sharp | Arkansas | 5135 | 482 | 13 |
722650 | 722650 | 2020-11-12 | St. Francis | Arkansas | 5123 | 1884 | 11 |
722651 | 722651 | 2020-11-12 | Stone | Arkansas | 5137 | 423 | 22 |
722652 | 722652 | 2020-11-12 | Union | Arkansas | 5139 | 1302 | 54 |
722653 | 722653 | 2020-11-12 | Unknown | Arkansas | 2013 | 0 | |
722654 | 722654 | 2020-11-12 | Van Buren | Arkansas | 5141 | 258 | 3 |
722655 | 722655 | 2020-11-12 | Washington | Arkansas | 5143 | 13049 | 162 |
722656 | 722656 | 2020-11-12 | White | Arkansas | 5145 | 2122 | 41 |
722657 | 722657 | 2020-11-12 | Woodruff | Arkansas | 5147 | 160 | 0 |
722658 | 722658 | 2020-11-12 | Yell | Arkansas | 5149 | 1463 | 33 |
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);