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-04 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 |
---|---|---|---|---|---|---|---|
894587 | 894587 | 2021-01-04 | Arkansas | Arkansas | 5001 | 1340 | 32 |
894588 | 894588 | 2021-01-04 | Ashley | Arkansas | 5003 | 1312 | 21 |
894589 | 894589 | 2021-01-04 | Baxter | Arkansas | 5005 | 2205 | 72 |
894590 | 894590 | 2021-01-04 | Benton | Arkansas | 5007 | 18907 | 275 |
894591 | 894591 | 2021-01-04 | Boone | Arkansas | 5009 | 2663 | 69 |
894592 | 894592 | 2021-01-04 | Bradley | Arkansas | 5011 | 977 | 16 |
894593 | 894593 | 2021-01-04 | Calhoun | Arkansas | 5013 | 244 | 1 |
894594 | 894594 | 2021-01-04 | Carroll | Arkansas | 5015 | 2133 | 30 |
894595 | 894595 | 2021-01-04 | Chicot | Arkansas | 5017 | 1433 | 32 |
894596 | 894596 | 2021-01-04 | Clark | Arkansas | 5019 | 1419 | 24 |
894597 | 894597 | 2021-01-04 | Clay | Arkansas | 5021 | 1350 | 32 |
894598 | 894598 | 2021-01-04 | Cleburne | Arkansas | 5023 | 1332 | 38 |
894599 | 894599 | 2021-01-04 | Cleveland | Arkansas | 5025 | 583 | 20 |
894600 | 894600 | 2021-01-04 | Columbia | Arkansas | 5027 | 1599 | 44 |
894601 | 894601 | 2021-01-04 | Conway | Arkansas | 5029 | 1434 | 17 |
894602 | 894602 | 2021-01-04 | Craighead | Arkansas | 5031 | 10350 | 142 |
894603 | 894603 | 2021-01-04 | Crawford | Arkansas | 5033 | 4681 | 62 |
894604 | 894604 | 2021-01-04 | Crittenden | Arkansas | 5035 | 4434 | 76 |
894605 | 894605 | 2021-01-04 | Cross | Arkansas | 5037 | 1474 | 37 |
894606 | 894606 | 2021-01-04 | Dallas | Arkansas | 5039 | 496 | 11 |
894607 | 894607 | 2021-01-04 | Desha | Arkansas | 5041 | 979 | 11 |
894608 | 894608 | 2021-01-04 | Drew | Arkansas | 5043 | 1510 | 20 |
894609 | 894609 | 2021-01-04 | Faulkner | Arkansas | 5045 | 8076 | 94 |
894610 | 894610 | 2021-01-04 | Franklin | Arkansas | 5047 | 1137 | 25 |
894611 | 894611 | 2021-01-04 | Fulton | Arkansas | 5049 | 914 | 36 |
894612 | 894612 | 2021-01-04 | Garland | Arkansas | 5051 | 6004 | 157 |
894613 | 894613 | 2021-01-04 | Grant | Arkansas | 5053 | 1124 | 12 |
894614 | 894614 | 2021-01-04 | Greene | Arkansas | 5055 | 4543 | 53 |
894615 | 894615 | 2021-01-04 | Hempstead | Arkansas | 5057 | 1276 | 11 |
894616 | 894616 | 2021-01-04 | Hot Spring | Arkansas | 5059 | 3719 | 57 |
894617 | 894617 | 2021-01-04 | Howard | Arkansas | 5061 | 1129 | 18 |
894618 | 894618 | 2021-01-04 | Independence | Arkansas | 5063 | 2861 | 94 |
894619 | 894619 | 2021-01-04 | Izard | Arkansas | 5065 | 1354 | 15 |
894620 | 894620 | 2021-01-04 | Jackson | Arkansas | 5067 | 2840 | 22 |
894621 | 894621 | 2021-01-04 | Jefferson | Arkansas | 5069 | 6865 | 131 |
894622 | 894622 | 2021-01-04 | Johnson | Arkansas | 5071 | 1938 | 20 |
894623 | 894623 | 2021-01-04 | Lafayette | Arkansas | 5073 | 351 | 4 |
894624 | 894624 | 2021-01-04 | Lawrence | Arkansas | 5075 | 1626 | 36 |
894625 | 894625 | 2021-01-04 | Lee | Arkansas | 5077 | 1464 | 26 |
894626 | 894626 | 2021-01-04 | Lincoln | Arkansas | 5079 | 2848 | 26 |
894627 | 894627 | 2021-01-04 | Little River | Arkansas | 5081 | 843 | 39 |
894628 | 894628 | 2021-01-04 | Logan | Arkansas | 5083 | 1507 | 11 |
894629 | 894629 | 2021-01-04 | Lonoke | Arkansas | 5085 | 4371 | 84 |
894630 | 894630 | 2021-01-04 | Madison | Arkansas | 5087 | 1062 | 13 |
894631 | 894631 | 2021-01-04 | Marion | Arkansas | 5089 | 671 | 24 |
894632 | 894632 | 2021-01-04 | Miller | Arkansas | 5091 | 2822 | 25 |
894633 | 894633 | 2021-01-04 | Mississippi | Arkansas | 5093 | 4482 | 97 |
894634 | 894634 | 2021-01-04 | Monroe | Arkansas | 5095 | 511 | 9 |
894635 | 894635 | 2021-01-04 | Montgomery | Arkansas | 5097 | 517 | 18 |
894636 | 894636 | 2021-01-04 | Nevada | Arkansas | 5099 | 611 | 20 |
894637 | 894637 | 2021-01-04 | Newton | Arkansas | 5101 | 564 | 24 |
894638 | 894638 | 2021-01-04 | Ouachita | Arkansas | 5103 | 1438 | 31 |
894639 | 894639 | 2021-01-04 | Perry | Arkansas | 5105 | 473 | 5 |
894640 | 894640 | 2021-01-04 | Phillips | Arkansas | 5107 | 1296 | 25 |
894641 | 894641 | 2021-01-04 | Pike | Arkansas | 5109 | 714 | 11 |
894642 | 894642 | 2021-01-04 | Poinsett | Arkansas | 5111 | 2461 | 63 |
894643 | 894643 | 2021-01-04 | Polk | Arkansas | 5113 | 1306 | 46 |
894644 | 894644 | 2021-01-04 | Pope | Arkansas | 5115 | 5755 | 61 |
894645 | 894645 | 2021-01-04 | Prairie | Arkansas | 5117 | 566 | 17 |
894646 | 894646 | 2021-01-04 | Pulaski | Arkansas | 5119 | 25953 | 399 |
894647 | 894647 | 2021-01-04 | Randolph | Arkansas | 5121 | 1495 | 43 |
894648 | 894648 | 2021-01-04 | Saline | Arkansas | 5125 | 7934 | 108 |
894649 | 894649 | 2021-01-04 | Scott | Arkansas | 5127 | 623 | 11 |
894650 | 894650 | 2021-01-04 | Searcy | Arkansas | 5129 | 515 | 13 |
894651 | 894651 | 2021-01-04 | Sebastian | Arkansas | 5131 | 10046 | 158 |
894652 | 894652 | 2021-01-04 | Sevier | Arkansas | 5133 | 2108 | 20 |
894653 | 894653 | 2021-01-04 | Sharp | Arkansas | 5135 | 1184 | 33 |
894654 | 894654 | 2021-01-04 | St. Francis | Arkansas | 5123 | 2825 | 20 |
894655 | 894655 | 2021-01-04 | Stone | Arkansas | 5137 | 781 | 27 |
894656 | 894656 | 2021-01-04 | Union | Arkansas | 5139 | 2577 | 73 |
894657 | 894657 | 2021-01-04 | Unknown | Arkansas | 2761 | 0 | |
894658 | 894658 | 2021-01-04 | Van Buren | Arkansas | 5141 | 788 | 8 |
894659 | 894659 | 2021-01-04 | Washington | Arkansas | 5143 | 22333 | 226 |
894660 | 894660 | 2021-01-04 | White | Arkansas | 5145 | 5065 | 72 |
894661 | 894661 | 2021-01-04 | Woodruff | Arkansas | 5147 | 395 | 2 |
894662 | 894662 | 2021-01-04 | Yell | Arkansas | 5149 | 2504 | 45 |
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);