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-02-05 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 |
---|---|---|---|---|---|---|---|
998440 | 998440 | 2021-02-05 | Arkansas | Arkansas | 5001 | 1855 | 36 |
998441 | 998441 | 2021-02-05 | Ashley | Arkansas | 5003 | 1683 | 29 |
998442 | 998442 | 2021-02-05 | Baxter | Arkansas | 5005 | 2718 | 95 |
998443 | 998443 | 2021-02-05 | Benton | Arkansas | 5007 | 25781 | 366 |
998444 | 998444 | 2021-02-05 | Boone | Arkansas | 5009 | 3448 | 75 |
998445 | 998445 | 2021-02-05 | Bradley | Arkansas | 5011 | 1277 | 29 |
998446 | 998446 | 2021-02-05 | Calhoun | Arkansas | 5013 | 365 | 3 |
998447 | 998447 | 2021-02-05 | Carroll | Arkansas | 5015 | 2647 | 39 |
998448 | 998448 | 2021-02-05 | Chicot | Arkansas | 5017 | 1571 | 38 |
998449 | 998449 | 2021-02-05 | Clark | Arkansas | 5019 | 1912 | 35 |
998450 | 998450 | 2021-02-05 | Clay | Arkansas | 5021 | 1633 | 42 |
998451 | 998451 | 2021-02-05 | Cleburne | Arkansas | 5023 | 1811 | 63 |
998452 | 998452 | 2021-02-05 | Cleveland | Arkansas | 5025 | 865 | 23 |
998453 | 998453 | 2021-02-05 | Columbia | Arkansas | 5027 | 2012 | 52 |
998454 | 998454 | 2021-02-05 | Conway | Arkansas | 5029 | 2052 | 28 |
998455 | 998455 | 2021-02-05 | Craighead | Arkansas | 5031 | 12401 | 172 |
998456 | 998456 | 2021-02-05 | Crawford | Arkansas | 5033 | 6450 | 95 |
998457 | 998457 | 2021-02-05 | Crittenden | Arkansas | 5035 | 5499 | 88 |
998458 | 998458 | 2021-02-05 | Cross | Arkansas | 5037 | 1851 | 46 |
998459 | 998459 | 2021-02-05 | Dallas | Arkansas | 5039 | 690 | 12 |
998460 | 998460 | 2021-02-05 | Desha | Arkansas | 5041 | 1253 | 17 |
998461 | 998461 | 2021-02-05 | Drew | Arkansas | 5043 | 1899 | 32 |
998462 | 998462 | 2021-02-05 | Faulkner | Arkansas | 5045 | 11126 | 140 |
998463 | 998463 | 2021-02-05 | Franklin | Arkansas | 5047 | 1531 | 32 |
998464 | 998464 | 2021-02-05 | Fulton | Arkansas | 5049 | 1045 | 43 |
998465 | 998465 | 2021-02-05 | Garland | Arkansas | 5051 | 8905 | 214 |
998466 | 998466 | 2021-02-05 | Grant | Arkansas | 5053 | 1478 | 29 |
998467 | 998467 | 2021-02-05 | Greene | Arkansas | 5055 | 5641 | 69 |
998468 | 998468 | 2021-02-05 | Hempstead | Arkansas | 5057 | 1712 | 15 |
998469 | 998469 | 2021-02-05 | Hot Spring | Arkansas | 5059 | 4558 | 67 |
998470 | 998470 | 2021-02-05 | Howard | Arkansas | 5061 | 1438 | 24 |
998471 | 998471 | 2021-02-05 | Independence | Arkansas | 5063 | 3545 | 117 |
998472 | 998472 | 2021-02-05 | Izard | Arkansas | 5065 | 1599 | 36 |
998473 | 998473 | 2021-02-05 | Jackson | Arkansas | 5067 | 3110 | 32 |
998474 | 998474 | 2021-02-05 | Jefferson | Arkansas | 5069 | 8255 | 153 |
998475 | 998475 | 2021-02-05 | Johnson | Arkansas | 5071 | 2558 | 29 |
998476 | 998476 | 2021-02-05 | Lafayette | Arkansas | 5073 | 472 | 7 |
998477 | 998477 | 2021-02-05 | Lawrence | Arkansas | 5075 | 1948 | 41 |
998478 | 998478 | 2021-02-05 | Lee | Arkansas | 5077 | 1610 | 34 |
998479 | 998479 | 2021-02-05 | Lincoln | Arkansas | 5079 | 3079 | 42 |
998480 | 998480 | 2021-02-05 | Little River | Arkansas | 5081 | 1077 | 40 |
998481 | 998481 | 2021-02-05 | Logan | Arkansas | 5083 | 2047 | 17 |
998482 | 998482 | 2021-02-05 | Lonoke | Arkansas | 5085 | 6220 | 106 |
998483 | 998483 | 2021-02-05 | Madison | Arkansas | 5087 | 1367 | 19 |
998484 | 998484 | 2021-02-05 | Marion | Arkansas | 5089 | 897 | 27 |
998485 | 998485 | 2021-02-05 | Miller | Arkansas | 5091 | 3537 | 29 |
998486 | 998486 | 2021-02-05 | Mississippi | Arkansas | 5093 | 5375 | 110 |
998487 | 998487 | 2021-02-05 | Monroe | Arkansas | 5095 | 765 | 16 |
998488 | 998488 | 2021-02-05 | Montgomery | Arkansas | 5097 | 678 | 27 |
998489 | 998489 | 2021-02-05 | Nevada | Arkansas | 5099 | 737 | 24 |
998490 | 998490 | 2021-02-05 | Newton | Arkansas | 5101 | 664 | 26 |
998491 | 998491 | 2021-02-05 | Ouachita | Arkansas | 5103 | 2049 | 47 |
998492 | 998492 | 2021-02-05 | Perry | Arkansas | 5105 | 717 | 7 |
998493 | 998493 | 2021-02-05 | Phillips | Arkansas | 5107 | 1637 | 31 |
998494 | 998494 | 2021-02-05 | Pike | Arkansas | 5109 | 903 | 20 |
998495 | 998495 | 2021-02-05 | Poinsett | Arkansas | 5111 | 2993 | 74 |
998496 | 998496 | 2021-02-05 | Polk | Arkansas | 5113 | 1751 | 56 |
998497 | 998497 | 2021-02-05 | Pope | Arkansas | 5115 | 7330 | 90 |
998498 | 998498 | 2021-02-05 | Prairie | Arkansas | 5117 | 825 | 21 |
998499 | 998499 | 2021-02-05 | Pulaski | Arkansas | 5119 | 35193 | 531 |
998500 | 998500 | 2021-02-05 | Randolph | Arkansas | 5121 | 1893 | 47 |
998501 | 998501 | 2021-02-05 | Saline | Arkansas | 5125 | 10788 | 153 |
998502 | 998502 | 2021-02-05 | Scott | Arkansas | 5127 | 898 | 14 |
998503 | 998503 | 2021-02-05 | Searcy | Arkansas | 5129 | 630 | 14 |
998504 | 998504 | 2021-02-05 | Sebastian | Arkansas | 5131 | 13886 | 238 |
998505 | 998505 | 2021-02-05 | Sevier | Arkansas | 5133 | 2447 | 25 |
998506 | 998506 | 2021-02-05 | Sharp | Arkansas | 5135 | 1478 | 47 |
998507 | 998507 | 2021-02-05 | St. Francis | Arkansas | 5123 | 3355 | 35 |
998508 | 998508 | 2021-02-05 | Stone | Arkansas | 5137 | 935 | 29 |
998509 | 998509 | 2021-02-05 | Union | Arkansas | 5139 | 3482 | 94 |
998510 | 998510 | 2021-02-05 | Unknown | Arkansas | 2925 | 0 | |
998511 | 998511 | 2021-02-05 | Van Buren | Arkansas | 5141 | 1155 | 14 |
998512 | 998512 | 2021-02-05 | Washington | Arkansas | 5143 | 28247 | 314 |
998513 | 998513 | 2021-02-05 | White | Arkansas | 5145 | 6797 | 96 |
998514 | 998514 | 2021-02-05 | Woodruff | Arkansas | 5147 | 590 | 8 |
998515 | 998515 | 2021-02-05 | Yell | Arkansas | 5149 | 3172 | 65 |
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);