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-01-16 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 |
---|---|---|---|---|---|---|---|
933529 | 933529 | 2021-01-16 | Arkansas | Arkansas | 5001 | 1549 | 35 |
933530 | 933530 | 2021-01-16 | Ashley | Arkansas | 5003 | 1480 | 24 |
933531 | 933531 | 2021-01-16 | Baxter | Arkansas | 5005 | 2464 | 85 |
933532 | 933532 | 2021-01-16 | Benton | Arkansas | 5007 | 22931 | 306 |
933533 | 933533 | 2021-01-16 | Boone | Arkansas | 5009 | 2996 | 72 |
933534 | 933534 | 2021-01-16 | Bradley | Arkansas | 5011 | 1154 | 24 |
933535 | 933535 | 2021-01-16 | Calhoun | Arkansas | 5013 | 289 | 2 |
933536 | 933536 | 2021-01-16 | Carroll | Arkansas | 5015 | 2400 | 34 |
933537 | 933537 | 2021-01-16 | Chicot | Arkansas | 5017 | 1502 | 35 |
933538 | 933538 | 2021-01-16 | Clark | Arkansas | 5019 | 1643 | 30 |
933539 | 933539 | 2021-01-16 | Clay | Arkansas | 5021 | 1476 | 39 |
933540 | 933540 | 2021-01-16 | Cleburne | Arkansas | 5023 | 1601 | 45 |
933541 | 933541 | 2021-01-16 | Cleveland | Arkansas | 5025 | 681 | 23 |
933542 | 933542 | 2021-01-16 | Columbia | Arkansas | 5027 | 1787 | 46 |
933543 | 933543 | 2021-01-16 | Conway | Arkansas | 5029 | 1767 | 21 |
933544 | 933544 | 2021-01-16 | Craighead | Arkansas | 5031 | 11501 | 150 |
933545 | 933545 | 2021-01-16 | Crawford | Arkansas | 5033 | 5543 | 74 |
933546 | 933546 | 2021-01-16 | Crittenden | Arkansas | 5035 | 5029 | 79 |
933547 | 933547 | 2021-01-16 | Cross | Arkansas | 5037 | 1696 | 39 |
933548 | 933548 | 2021-01-16 | Dallas | Arkansas | 5039 | 609 | 12 |
933549 | 933549 | 2021-01-16 | Desha | Arkansas | 5041 | 1086 | 14 |
933550 | 933550 | 2021-01-16 | Drew | Arkansas | 5043 | 1700 | 26 |
933551 | 933551 | 2021-01-16 | Faulkner | Arkansas | 5045 | 9557 | 118 |
933552 | 933552 | 2021-01-16 | Franklin | Arkansas | 5047 | 1330 | 28 |
933553 | 933553 | 2021-01-16 | Fulton | Arkansas | 5049 | 996 | 38 |
933554 | 933554 | 2021-01-16 | Garland | Arkansas | 5051 | 7472 | 184 |
933555 | 933555 | 2021-01-16 | Grant | Arkansas | 5053 | 1266 | 23 |
933556 | 933556 | 2021-01-16 | Greene | Arkansas | 5055 | 5090 | 59 |
933557 | 933557 | 2021-01-16 | Hempstead | Arkansas | 5057 | 1454 | 11 |
933558 | 933558 | 2021-01-16 | Hot Spring | Arkansas | 5059 | 4081 | 61 |
933559 | 933559 | 2021-01-16 | Howard | Arkansas | 5061 | 1245 | 19 |
933560 | 933560 | 2021-01-16 | Independence | Arkansas | 5063 | 3250 | 106 |
933561 | 933561 | 2021-01-16 | Izard | Arkansas | 5065 | 1474 | 26 |
933562 | 933562 | 2021-01-16 | Jackson | Arkansas | 5067 | 2982 | 28 |
933563 | 933563 | 2021-01-16 | Jefferson | Arkansas | 5069 | 7428 | 139 |
933564 | 933564 | 2021-01-16 | Johnson | Arkansas | 5071 | 2282 | 26 |
933565 | 933565 | 2021-01-16 | Lafayette | Arkansas | 5073 | 392 | 6 |
933566 | 933566 | 2021-01-16 | Lawrence | Arkansas | 5075 | 1801 | 40 |
933567 | 933567 | 2021-01-16 | Lee | Arkansas | 5077 | 1550 | 29 |
933568 | 933568 | 2021-01-16 | Lincoln | Arkansas | 5079 | 2949 | 29 |
933569 | 933569 | 2021-01-16 | Little River | Arkansas | 5081 | 951 | 39 |
933570 | 933570 | 2021-01-16 | Logan | Arkansas | 5083 | 1784 | 13 |
933571 | 933571 | 2021-01-16 | Lonoke | Arkansas | 5085 | 5239 | 96 |
933572 | 933572 | 2021-01-16 | Madison | Arkansas | 5087 | 1198 | 15 |
933573 | 933573 | 2021-01-16 | Marion | Arkansas | 5089 | 792 | 26 |
933574 | 933574 | 2021-01-16 | Miller | Arkansas | 5091 | 3130 | 26 |
933575 | 933575 | 2021-01-16 | Mississippi | Arkansas | 5093 | 4877 | 101 |
933576 | 933576 | 2021-01-16 | Monroe | Arkansas | 5095 | 599 | 11 |
933577 | 933577 | 2021-01-16 | Montgomery | Arkansas | 5097 | 619 | 22 |
933578 | 933578 | 2021-01-16 | Nevada | Arkansas | 5099 | 645 | 22 |
933579 | 933579 | 2021-01-16 | Newton | Arkansas | 5101 | 606 | 26 |
933580 | 933580 | 2021-01-16 | Ouachita | Arkansas | 5103 | 1729 | 38 |
933581 | 933581 | 2021-01-16 | Perry | Arkansas | 5105 | 609 | 6 |
933582 | 933582 | 2021-01-16 | Phillips | Arkansas | 5107 | 1480 | 29 |
933583 | 933583 | 2021-01-16 | Pike | Arkansas | 5109 | 834 | 15 |
933584 | 933584 | 2021-01-16 | Poinsett | Arkansas | 5111 | 2726 | 69 |
933585 | 933585 | 2021-01-16 | Polk | Arkansas | 5113 | 1534 | 51 |
933586 | 933586 | 2021-01-16 | Pope | Arkansas | 5115 | 6614 | 71 |
933587 | 933587 | 2021-01-16 | Prairie | Arkansas | 5117 | 660 | 17 |
933588 | 933588 | 2021-01-16 | Pulaski | Arkansas | 5119 | 30116 | 450 |
933589 | 933589 | 2021-01-16 | Randolph | Arkansas | 5121 | 1726 | 44 |
933590 | 933590 | 2021-01-16 | Saline | Arkansas | 5125 | 9409 | 126 |
933591 | 933591 | 2021-01-16 | Scott | Arkansas | 5127 | 779 | 14 |
933592 | 933592 | 2021-01-16 | Searcy | Arkansas | 5129 | 570 | 14 |
933593 | 933593 | 2021-01-16 | Sebastian | Arkansas | 5131 | 12259 | 179 |
933594 | 933594 | 2021-01-16 | Sevier | Arkansas | 5133 | 2259 | 23 |
933595 | 933595 | 2021-01-16 | Sharp | Arkansas | 5135 | 1375 | 38 |
933596 | 933596 | 2021-01-16 | St. Francis | Arkansas | 5123 | 3132 | 27 |
933597 | 933597 | 2021-01-16 | Stone | Arkansas | 5137 | 868 | 27 |
933598 | 933598 | 2021-01-16 | Union | Arkansas | 5139 | 2969 | 81 |
933599 | 933599 | 2021-01-16 | Unknown | Arkansas | 2824 | 0 | |
933600 | 933600 | 2021-01-16 | Van Buren | Arkansas | 5141 | 964 | 10 |
933601 | 933601 | 2021-01-16 | Washington | Arkansas | 5143 | 25591 | 245 |
933602 | 933602 | 2021-01-16 | White | Arkansas | 5145 | 5902 | 76 |
933603 | 933603 | 2021-01-16 | Woodruff | Arkansas | 5147 | 484 | 5 |
933604 | 933604 | 2021-01-16 | Yell | Arkansas | 5149 | 2842 | 56 |
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);