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-08-11 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 |
---|---|---|---|---|---|---|---|
1605562 | 1605562 | 2021-08-11 | Arkansas | Arkansas | 5001 | 2745 | 46 |
1605563 | 1605563 | 2021-08-11 | Ashley | Arkansas | 5003 | 2314 | 37 |
1605564 | 1605564 | 2021-08-11 | Baxter | Arkansas | 5005 | 4920 | 130 |
1605565 | 1605565 | 2021-08-11 | Benton | Arkansas | 5007 | 34453 | 457 |
1605566 | 1605566 | 2021-08-11 | Boone | Arkansas | 5009 | 5134 | 86 |
1605567 | 1605567 | 2021-08-11 | Bradley | Arkansas | 5011 | 1662 | 34 |
1605568 | 1605568 | 2021-08-11 | Calhoun | Arkansas | 5013 | 506 | 4 |
1605569 | 1605569 | 2021-08-11 | Carroll | Arkansas | 5015 | 3470 | 52 |
1605570 | 1605570 | 2021-08-11 | Chicot | Arkansas | 5017 | 1718 | 42 |
1605571 | 1605571 | 2021-08-11 | Clark | Arkansas | 5019 | 2580 | 40 |
1605572 | 1605572 | 2021-08-11 | Clay | Arkansas | 5021 | 2027 | 52 |
1605573 | 1605573 | 2021-08-11 | Cleburne | Arkansas | 5023 | 2775 | 75 |
1605574 | 1605574 | 2021-08-11 | Cleveland | Arkansas | 5025 | 1187 | 28 |
1605575 | 1605575 | 2021-08-11 | Columbia | Arkansas | 5027 | 2704 | 60 |
1605576 | 1605576 | 2021-08-11 | Conway | Arkansas | 5029 | 2552 | 37 |
1605577 | 1605577 | 2021-08-11 | Craighead | Arkansas | 5031 | 16335 | 197 |
1605578 | 1605578 | 2021-08-11 | Crawford | Arkansas | 5033 | 8144 | 130 |
1605579 | 1605579 | 2021-08-11 | Crittenden | Arkansas | 5035 | 6840 | 102 |
1605580 | 1605580 | 2021-08-11 | Cross | Arkansas | 5037 | 2299 | 53 |
1605581 | 1605581 | 2021-08-11 | Dallas | Arkansas | 5039 | 989 | 17 |
1605582 | 1605582 | 2021-08-11 | Desha | Arkansas | 5041 | 1555 | 23 |
1605583 | 1605583 | 2021-08-11 | Drew | Arkansas | 5043 | 2382 | 49 |
1605584 | 1605584 | 2021-08-11 | Faulkner | Arkansas | 5045 | 16091 | 179 |
1605585 | 1605585 | 2021-08-11 | Franklin | Arkansas | 5047 | 2003 | 41 |
1605586 | 1605586 | 2021-08-11 | Fulton | Arkansas | 5049 | 1412 | 50 |
1605587 | 1605587 | 2021-08-11 | Garland | Arkansas | 5051 | 13074 | 281 |
1605588 | 1605588 | 2021-08-11 | Grant | Arkansas | 5053 | 2318 | 39 |
1605589 | 1605589 | 2021-08-11 | Greene | Arkansas | 5055 | 7315 | 83 |
1605590 | 1605590 | 2021-08-11 | Hempstead | Arkansas | 5057 | 2317 | 20 |
1605591 | 1605591 | 2021-08-11 | Hot Spring | Arkansas | 5059 | 6385 | 89 |
1605592 | 1605592 | 2021-08-11 | Howard | Arkansas | 5061 | 1883 | 25 |
1605593 | 1605593 | 2021-08-11 | Independence | Arkansas | 5063 | 4822 | 131 |
1605594 | 1605594 | 2021-08-11 | Izard | Arkansas | 5065 | 2053 | 47 |
1605595 | 1605595 | 2021-08-11 | Jackson | Arkansas | 5067 | 3518 | 38 |
1605596 | 1605596 | 2021-08-11 | Jefferson | Arkansas | 5069 | 10847 | 192 |
1605597 | 1605597 | 2021-08-11 | Johnson | Arkansas | 5071 | 3445 | 40 |
1605598 | 1605598 | 2021-08-11 | Lafayette | Arkansas | 5073 | 655 | 10 |
1605599 | 1605599 | 2021-08-11 | Lawrence | Arkansas | 5075 | 2407 | 43 |
1605600 | 1605600 | 2021-08-11 | Lee | Arkansas | 5077 | 1840 | 39 |
1605601 | 1605601 | 2021-08-11 | Lincoln | Arkansas | 5079 | 3465 | 49 |
1605602 | 1605602 | 2021-08-11 | Little River | Arkansas | 5081 | 1448 | 43 |
1605603 | 1605603 | 2021-08-11 | Logan | Arkansas | 5083 | 2651 | 26 |
1605604 | 1605604 | 2021-08-11 | Lonoke | Arkansas | 5085 | 9597 | 141 |
1605605 | 1605605 | 2021-08-11 | Madison | Arkansas | 5087 | 1836 | 32 |
1605606 | 1605606 | 2021-08-11 | Marion | Arkansas | 5089 | 1662 | 38 |
1605607 | 1605607 | 2021-08-11 | Miller | Arkansas | 5091 | 4972 | 37 |
1605608 | 1605608 | 2021-08-11 | Mississippi | Arkansas | 5093 | 6344 | 113 |
1605609 | 1605609 | 2021-08-11 | Monroe | Arkansas | 5095 | 1007 | 19 |
1605610 | 1605610 | 2021-08-11 | Montgomery | Arkansas | 5097 | 869 | 33 |
1605611 | 1605611 | 2021-08-11 | Nevada | Arkansas | 5099 | 1001 | 26 |
1605612 | 1605612 | 2021-08-11 | Newton | Arkansas | 5101 | 971 | 27 |
1605613 | 1605613 | 2021-08-11 | Ouachita | Arkansas | 5103 | 2870 | 66 |
1605614 | 1605614 | 2021-08-11 | Perry | Arkansas | 5105 | 1183 | 13 |
1605615 | 1605615 | 2021-08-11 | Phillips | Arkansas | 5107 | 2334 | 50 |
1605616 | 1605616 | 2021-08-11 | Pike | Arkansas | 5109 | 1229 | 24 |
1605617 | 1605617 | 2021-08-11 | Poinsett | Arkansas | 5111 | 3731 | 87 |
1605618 | 1605618 | 2021-08-11 | Polk | Arkansas | 5113 | 2260 | 76 |
1605619 | 1605619 | 2021-08-11 | Pope | Arkansas | 5115 | 9349 | 117 |
1605620 | 1605620 | 2021-08-11 | Prairie | Arkansas | 5117 | 1060 | 25 |
1605621 | 1605621 | 2021-08-11 | Pulaski | Arkansas | 5119 | 50031 | 746 |
1605622 | 1605622 | 2021-08-11 | Randolph | Arkansas | 5121 | 2417 | 49 |
1605623 | 1605623 | 2021-08-11 | Saline | Arkansas | 5125 | 15499 | 189 |
1605624 | 1605624 | 2021-08-11 | Scott | Arkansas | 5127 | 1119 | 18 |
1605625 | 1605625 | 2021-08-11 | Searcy | Arkansas | 5129 | 1040 | 19 |
1605626 | 1605626 | 2021-08-11 | Sebastian | Arkansas | 5131 | 17563 | 293 |
1605627 | 1605627 | 2021-08-11 | Sevier | Arkansas | 5133 | 3062 | 25 |
1605628 | 1605628 | 2021-08-11 | Sharp | Arkansas | 5135 | 2084 | 53 |
1605629 | 1605629 | 2021-08-11 | St. Francis | Arkansas | 5123 | 4008 | 46 |
1605630 | 1605630 | 2021-08-11 | Stone | Arkansas | 5137 | 1336 | 33 |
1605631 | 1605631 | 2021-08-11 | Union | Arkansas | 5139 | 4516 | 116 |
1605632 | 1605632 | 2021-08-11 | Unknown | Arkansas | 3750 | 0 | |
1605633 | 1605633 | 2021-08-11 | Van Buren | Arkansas | 5141 | 1709 | 29 |
1605634 | 1605634 | 2021-08-11 | Washington | Arkansas | 5143 | 36088 | 383 |
1605635 | 1605635 | 2021-08-11 | White | Arkansas | 5145 | 10550 | 145 |
1605636 | 1605636 | 2021-08-11 | Woodruff | Arkansas | 5147 | 800 | 16 |
1605637 | 1605637 | 2021-08-11 | Yell | Arkansas | 5149 | 3745 | 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);