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-22 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 |
---|---|---|---|---|---|---|---|
953002 | 953002 | 2021-01-22 | Arkansas | Arkansas | 5001 | 1664 | 35 |
953003 | 953003 | 2021-01-22 | Ashley | Arkansas | 5003 | 1565 | 27 |
953004 | 953004 | 2021-01-22 | Baxter | Arkansas | 5005 | 2533 | 88 |
953005 | 953005 | 2021-01-22 | Benton | Arkansas | 5007 | 23882 | 319 |
953006 | 953006 | 2021-01-22 | Boone | Arkansas | 5009 | 3129 | 74 |
953007 | 953007 | 2021-01-22 | Bradley | Arkansas | 5011 | 1194 | 27 |
953008 | 953008 | 2021-01-22 | Calhoun | Arkansas | 5013 | 307 | 2 |
953009 | 953009 | 2021-01-22 | Carroll | Arkansas | 5015 | 2460 | 36 |
953010 | 953010 | 2021-01-22 | Chicot | Arkansas | 5017 | 1528 | 37 |
953011 | 953011 | 2021-01-22 | Clark | Arkansas | 5019 | 1725 | 31 |
953012 | 953012 | 2021-01-22 | Clay | Arkansas | 5021 | 1525 | 40 |
953013 | 953013 | 2021-01-22 | Cleburne | Arkansas | 5023 | 1670 | 50 |
953014 | 953014 | 2021-01-22 | Cleveland | Arkansas | 5025 | 723 | 23 |
953015 | 953015 | 2021-01-22 | Columbia | Arkansas | 5027 | 1843 | 48 |
953016 | 953016 | 2021-01-22 | Conway | Arkansas | 5029 | 1871 | 23 |
953017 | 953017 | 2021-01-22 | Craighead | Arkansas | 5031 | 11814 | 157 |
953018 | 953018 | 2021-01-22 | Crawford | Arkansas | 5033 | 5862 | 82 |
953019 | 953019 | 2021-01-22 | Crittenden | Arkansas | 5035 | 5193 | 79 |
953020 | 953020 | 2021-01-22 | Cross | Arkansas | 5037 | 1762 | 41 |
953021 | 953021 | 2021-01-22 | Dallas | Arkansas | 5039 | 643 | 12 |
953022 | 953022 | 2021-01-22 | Desha | Arkansas | 5041 | 1118 | 16 |
953023 | 953023 | 2021-01-22 | Drew | Arkansas | 5043 | 1761 | 28 |
953024 | 953024 | 2021-01-22 | Faulkner | Arkansas | 5045 | 10033 | 123 |
953025 | 953025 | 2021-01-22 | Franklin | Arkansas | 5047 | 1408 | 31 |
953026 | 953026 | 2021-01-22 | Fulton | Arkansas | 5049 | 1013 | 41 |
953027 | 953027 | 2021-01-22 | Garland | Arkansas | 5051 | 7829 | 193 |
953028 | 953028 | 2021-01-22 | Grant | Arkansas | 5053 | 1319 | 27 |
953029 | 953029 | 2021-01-22 | Greene | Arkansas | 5055 | 5255 | 61 |
953030 | 953030 | 2021-01-22 | Hempstead | Arkansas | 5057 | 1541 | 13 |
953031 | 953031 | 2021-01-22 | Hot Spring | Arkansas | 5059 | 4211 | 62 |
953032 | 953032 | 2021-01-22 | Howard | Arkansas | 5061 | 1286 | 20 |
953033 | 953033 | 2021-01-22 | Independence | Arkansas | 5063 | 3335 | 109 |
953034 | 953034 | 2021-01-22 | Izard | Arkansas | 5065 | 1510 | 31 |
953035 | 953035 | 2021-01-22 | Jackson | Arkansas | 5067 | 3021 | 30 |
953036 | 953036 | 2021-01-22 | Jefferson | Arkansas | 5069 | 7681 | 143 |
953037 | 953037 | 2021-01-22 | Johnson | Arkansas | 5071 | 2363 | 26 |
953038 | 953038 | 2021-01-22 | Lafayette | Arkansas | 5073 | 419 | 7 |
953039 | 953039 | 2021-01-22 | Lawrence | Arkansas | 5075 | 1860 | 40 |
953040 | 953040 | 2021-01-22 | Lee | Arkansas | 5077 | 1581 | 30 |
953041 | 953041 | 2021-01-22 | Lincoln | Arkansas | 5079 | 2980 | 34 |
953042 | 953042 | 2021-01-22 | Little River | Arkansas | 5081 | 984 | 39 |
953043 | 953043 | 2021-01-22 | Logan | Arkansas | 5083 | 1869 | 13 |
953044 | 953044 | 2021-01-22 | Lonoke | Arkansas | 5085 | 5544 | 98 |
953045 | 953045 | 2021-01-22 | Madison | Arkansas | 5087 | 1254 | 16 |
953046 | 953046 | 2021-01-22 | Marion | Arkansas | 5089 | 821 | 27 |
953047 | 953047 | 2021-01-22 | Miller | Arkansas | 5091 | 3230 | 28 |
953048 | 953048 | 2021-01-22 | Mississippi | Arkansas | 5093 | 5014 | 103 |
953049 | 953049 | 2021-01-22 | Monroe | Arkansas | 5095 | 653 | 14 |
953050 | 953050 | 2021-01-22 | Montgomery | Arkansas | 5097 | 631 | 24 |
953051 | 953051 | 2021-01-22 | Nevada | Arkansas | 5099 | 675 | 22 |
953052 | 953052 | 2021-01-22 | Newton | Arkansas | 5101 | 629 | 26 |
953053 | 953053 | 2021-01-22 | Ouachita | Arkansas | 5103 | 1825 | 42 |
953054 | 953054 | 2021-01-22 | Perry | Arkansas | 5105 | 633 | 6 |
953055 | 953055 | 2021-01-22 | Phillips | Arkansas | 5107 | 1521 | 30 |
953056 | 953056 | 2021-01-22 | Pike | Arkansas | 5109 | 860 | 17 |
953057 | 953057 | 2021-01-22 | Poinsett | Arkansas | 5111 | 2827 | 70 |
953058 | 953058 | 2021-01-22 | Polk | Arkansas | 5113 | 1583 | 53 |
953059 | 953059 | 2021-01-22 | Pope | Arkansas | 5115 | 6891 | 80 |
953060 | 953060 | 2021-01-22 | Prairie | Arkansas | 5117 | 712 | 19 |
953061 | 953061 | 2021-01-22 | Pulaski | Arkansas | 5119 | 31628 | 476 |
953062 | 953062 | 2021-01-22 | Randolph | Arkansas | 5121 | 1780 | 46 |
953063 | 953063 | 2021-01-22 | Saline | Arkansas | 5125 | 9774 | 138 |
953064 | 953064 | 2021-01-22 | Scott | Arkansas | 5127 | 821 | 14 |
953065 | 953065 | 2021-01-22 | Searcy | Arkansas | 5129 | 590 | 14 |
953066 | 953066 | 2021-01-22 | Sebastian | Arkansas | 5131 | 12882 | 202 |
953067 | 953067 | 2021-01-22 | Sevier | Arkansas | 5133 | 2299 | 24 |
953068 | 953068 | 2021-01-22 | Sharp | Arkansas | 5135 | 1404 | 40 |
953069 | 953069 | 2021-01-22 | St. Francis | Arkansas | 5123 | 3227 | 29 |
953070 | 953070 | 2021-01-22 | Stone | Arkansas | 5137 | 888 | 27 |
953071 | 953071 | 2021-01-22 | Union | Arkansas | 5139 | 3113 | 89 |
953072 | 953072 | 2021-01-22 | Unknown | Arkansas | 3187 | 0 | |
953073 | 953073 | 2021-01-22 | Van Buren | Arkansas | 5141 | 1029 | 12 |
953074 | 953074 | 2021-01-22 | Washington | Arkansas | 5143 | 26552 | 270 |
953075 | 953075 | 2021-01-22 | White | Arkansas | 5145 | 6172 | 82 |
953076 | 953076 | 2021-01-22 | Woodruff | Arkansas | 5147 | 520 | 5 |
953077 | 953077 | 2021-01-22 | Yell | Arkansas | 5149 | 2943 | 58 |
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);