2018_county_census

Table actions
Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

3,142 rows sorted by est2018_70to74

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: centraloutlyingcounty

Link rowid statecountyfips geo_display est2018_all est2018_0to4 est2018_5to9 est2018_10to14 est2018_15to19 est2018_20to24 est2018_25to29 est2018_30to34 est2018_35to39 est2018_40to44 est2018_45to49 est2018_50to54 est2018_55to59 est2018_60to64 est2018_65to69 est2018_70to74 ▼ est2018_75to79 est2018_80to84 est2018_85plus cbsacode centraloutlyingcounty countyequivalent csatitle statename
2511 2511 15005 Kalawao County, Hawaii 88 0 0 0 0 0 0 7 4 3 6 10 8 13 11 2 4 6 14 27980 Outlying Kalawao County   Hawaii
1031 1031 48301 Loving County, Texas 152 11 17 11 17 10 14 13 13 2 2 7 7 13 7 5 3 0 0          
1104 1104 48269 King County, Texas 277 13 24 26 11 11 17 14 23 7 19 22 17 24 14 9 8 13 5          
576 576 31005 Arthur County, Nebraska 465 24 37 35 35 30 22 29 22 32 22 23 23 29 34 20 21 20 7          
794 794 31009 Blaine County, Nebraska 476 26 29 25 22 27 36 16 21 15 24 33 45 36 43 21 28 15 14          
1202 1202 30069 Petroleum County, Montana 513 19 31 25 30 29 15 26 21 22 29 40 44 54 31 23 39 19 16          
2843 2843 48261 Kenedy County, Texas 442 17 37 39 49 23 18 32 27 17 30 28 24 32 11 27 11 7 13 28780 Outlying Kenedy County Corpus Christi-Kingsville-Alice, TX Texas
688 688 2060 Bristol Bay Borough, Alaska 877 56 55 33 43 56 67 71 48 48 55 53 98 67 54 29 19 20 5          
2107 2107 31117 McPherson County, Nebraska 492 16 14 34 43 26 14 15 21 27 34 39 46 44 34 31 20 16 18 35820 Outlying McPherson County   Nebraska
1039 1039 2282 Yakutat City and Borough, Alaska 604 33 32 23 29 32 45 35 35 35 41 61 39 46 42 33 17 13 13          
122 122 16033 Clark County, Idaho 852 47 50 61 78 56 40 57 52 55 49 47 48 61 48 35 24 25 19          
728 728 31075 Grant County, Nebraska 660 56 47 37 33 22 30 42 40 37 19 35 64 49 53 35 34 21 6          
1098 1098 48033 Borden County, Texas 648 33 35 38 35 29 20 27 34 33 65 48 47 44 42 35 25 31 27          
2268 2268 31113 Logan County, Nebraska 749 48 43 68 49 26 27 30 50 51 36 35 59 58 59 36 35 17 22 35820 Outlying Logan County   Nebraska
1326 1326 2230 Skagway Municipality, Alaska 1148 61 56 43 31 39 100 115 130 94 81 79 68 84 71 37 32 18 9          
78 78 31171 Thomas County, Nebraska 720 43 50 48 42 26 33 44 28 39 43 39 36 62 71 41 33 21 21          
1089 1089 31091 Hooker County, Nebraska 682 42 35 50 40 23 33 25 34 39 30 26 35 62 56 41 38 22 51          
187 187 48311 McMullen County, Texas 749 33 36 47 38 40 56 39 35 32 51 58 44 60 40 43 36 32 29          
568 568 48431 Sterling County, Texas 1311 109 96 101 96 71 65 86 90 89 78 69 80 92 48 44 30 30 37          
128 128 28055 Issaquena County, Mississippi 1308 36 42 31 94 120 153 62 103 63 78 98 107 103 58 46 43 38 33          
658 658 2164 Lake and Peninsula Borough, Alaska 1587 161 113 115 100 89 137 97 110 97 92 99 124 91 66 46 22 15 13          
834 834 31183 Wheeler County, Nebraska 805 47 48 43 33 42 32 38 33 41 37 47 67 89 57 46 37 36 32          
1254 1254 31115 Loup County, Nebraska 618 30 31 31 36 33 23 30 26 23 26 30 58 76 51 46 35 21 12          
517 517 2068 Denali Borough, Alaska 2059 114 105 109 81 105 170 153 150 141 189 174 182 141 136 47 34 20 8          
2197 2197 48173 Glasscock County, Texas 1388 90 104 101 104 88 83 84 97 88 95 77 88 78 73 47 40 32 19 13700 Outlying Glasscock County   Texas
2425 2425 30037 Golden Valley County, Montana 826 43 46 52 56 31 36 32 52 37 35 51 66 65 87 47 38 26 26 13740 Outlying Golden Valley County   Montana
573 573 38007 Billings County, North Dakota 919 69 45 46 37 35 51 71 69 47 46 63 66 68 65 48 28 32 33          
183 183 20071 Greeley County, Kansas 1227 72 106 96 73 45 58 86 86 58 37 70 97 89 70 49 40 36 59          
436 436 38087 Slope County, North Dakota 763 43 48 40 41 33 36 33 45 31 33 47 78 80 53 49 17 28 28          
637 637 46063 Harding County, South Dakota 1249 82 78 66 87 60 76 76 71 63 75 76 109 108 82 49 33 24 34          
925 925 46017 Buffalo County, South Dakota 2036 248 214 219 175 133 158 120 122 120 93 88 79 107 50 50 29 18 13          
1028 1028 48263 Kent County, Texas 726 37 42 49 41 25 21 38 44 23 42 49 52 66 40 50 43 34 30          
553 553 30109 Wibaux County, Montana 1034 64 65 55 62 50 40 48 69 49 45 71 81 84 85 51 43 39 33          
570 570 46075 Jones County, South Dakota 928 57 63 59 40 37 40 52 43 33 61 54 89 84 68 51 34 30 33          
1492 1492 31007 Banner County, Nebraska 730 49 51 43 39 38 41 29 50 24 25 41 60 66 63 51 25 18 17 42420 Outlying Banner County   Nebraska
580 580 31085 Hayes County, Nebraska 916 68 62 46 39 55 45 40 45 35 24 39 80 86 69 55 38 43 47          
1131 1131 30103 Treasure County, Montana 679 55 41 25 29 26 28 38 38 22 17 40 54 72 53 55 33 30 23          
993 993 46069 Hyde County, South Dakota 1282 78 60 84 68 52 82 58 66 69 44 84 83 130 81 57 60 63 63          
1231 1231 48393 Roberts County, Texas 903 58 52 75 58 29 48 50 75 45 47 47 70 60 59 57 33 25 15          
99 99 8111 San Juan County, Colorado 762 28 25 31 21 27 54 44 53 57 49 51 62 82 57 61 30 18 12          
112 112 31103 Keya Paha County, Nebraska 810 33 45 53 36 34 33 22 44 37 29 42 76 75 55 63 41 52 40          
215 215 46137 Ziebach County, South Dakota 2742 159 182 263 288 213 163 133 215 190 175 146 232 120 87 63 47 32 34          
444 444 35021 Harding County, New Mexico 655 25 27 20 22 20 24 30 33 23 20 38 53 73 68 63 29 32 55          
2225 2225 31165 Sioux County, Nebraska 1187 45 54 70 74 65 39 45 61 60 50 65 110 110 109 63 57 48 62 42420 Outlying Sioux County   Nebraska
265 265 30011 Carter County, Montana 1238 91 76 54 50 54 67 80 63 46 40 73 107 118 98 64 59 46 52          
1167 1167 8061 Kiowa County, Colorado 1383 109 78 72 75 86 71 64 68 70 64 66 131 105 100 65 55 48 56          
515 515 8079 Mineral County, Colorado 776 33 36 18 34 21 34 52 33 37 41 43 77 75 94 67 40 19 22          
877 877 48443 Terrell County, Texas 823 42 58 42 40 41 30 42 43 52 45 46 42 56 73 67 41 22 41          
204 204 30033 Garfield County, Montana 1268 74 85 78 64 68 59 57 103 64 69 66 78 108 99 70 64 40 22          
542 542 31149 Rock County, Nebraska 1360 81 65 90 56 62 48 76 74 68 55 45 122 155 133 71 53 43 63          
1006 1006 8057 Jackson County, Colorado 1399 69 62 67 61 55 85 79 76 97 81 99 117 140 111 71 61 35 33          
51 51 8017 Cheyenne County, Colorado 1876 131 155 124 113 81 89 106 118 90 91 113 147 133 142 73 65 39 66          
446 446 48155 Foard County, Texas 1200 45 77 70 75 63 50 59 57 47 69 97 97 78 79 73 68 49 47          
795 795 49009 Daggett County, Utah 980 48 59 66 66 38 29 44 52 50 60 56 87 74 86 74 38 18 35          
1157 1157 20083 Hodgeman County, Kansas 1818 117 96 121 112 87 78 98 91 77 92 109 159 145 119 76 87 86 68          
1679 1679 46119 Sully County, South Dakota 1392 78 83 84 71 53 65 74 75 72 63 90 112 124 124 76 55 40 53 38180 Outlying Sully County   South Dakota
3055 3055 16025 Camas County, Idaho 1127 55 77 93 57 37 35 49 76 78 67 61 88 101 91 76 43 14 29 25200 Outlying Camas County   Idaho
1076 1076 38033 Golden Valley County, North Dakota 1769 107 87 105 121 75 81 79 115 109 81 100 123 154 152 77 62 55 86          
529 529 6003 Alpine County, California 1101 44 36 69 70 60 55 54 36 47 63 70 114 103 115 78 36 28 23          
1417 1417 38085 Sioux County, North Dakota 4358 447 423 433 414 287 303 275 257 234 222 277 262 171 123 81 71 43 35 13900 Outlying Sioux County   North Dakota
926 926 46095 Mellette County, South Dakota 2042 210 139 200 140 134 144 99 81 95 91 122 137 134 109 82 49 40 36          
258 258 20187 Stanton County, Kansas 1987 138 151 139 162 109 97 111 119 124 117 109 123 138 95 83 56 55 61          
812 812 48101 Cottle County, Texas 1389 75 84 89 97 56 60 75 84 68 63 79 115 106 96 83 75 42 42          
93 93 20199 Wallace County, Kansas 1503 119 94 97 107 74 71 81 74 62 59 87 117 111 99 84 48 47 72          
471 471 48345 Motley County, Texas 1234 58 56 84 76 59 55 65 48 50 77 52 96 84 123 84 75 46 46          
636 636 46021 Campbell County, South Dakota 1377 59 63 53 71 62 47 61 61 55 54 104 154 143 87 85 73 77 68          
942 942 20025 Clark County, Kansas 2005 107 142 155 125 118 112 100 125 109 97 111 130 134 108 85 91 65 91          
77 77 20075 Hamilton County, Kansas 2607 198 244 200 178 142 181 177 164 140 151 147 176 144 125 87 77 44 32          
2157 2157 32011 Eureka County, Nevada 2003 100 145 169 102 82 89 122 114 127 145 142 192 148 115 87 63 31 30 21220 Outlying Eureka County   Nevada
2341 2341 48235 Irion County, Texas 1522 84 94 95 93 74 92 95 67 80 95 86 124 116 95 87 76 28 41 41660 Outlying Irion County   Texas
681 681 8053 Hinsdale County, Colorado 811 32 36 34 47 39 32 42 29 45 32 54 60 83 72 88 43 21 22          
172 172 46097 Miner County, South Dakota 2213 132 132 166 142 115 107 105 98 109 94 150 197 202 138 89 84 63 90          
1135 1135 32009 Esmeralda County, Nevada 826 27 38 42 27 23 35 44 46 41 45 32 71 51 84 89 54 35 42          
650 650 46007 Bennett County, South Dakota 3468 336 358 316 262 249 217 228 177 142 167 196 220 167 146 90 61 85 51          
1199 1199 20203 Wichita County, Kansas 2105 117 186 144 165 109 108 95 107 122 130 101 138 157 130 91 69 59 77          
1650 1650 48359 Oldham County, Texas 2131 98 83 179 211 109 118 123 182 116 152 133 163 145 104 91 55 37 32 11100 Outlying Oldham County Amarillo-Borger, TX Texas
109 109 20101 Lane County, Kansas 1560 89 102 98 87 73 75 88 59 76 99 98 117 132 98 94 53 66 56          
185 185 48433 Stonewall County, Texas 1362 79 72 90 89 52 75 43 85 55 75 88 96 102 93 94 62 46 66          
359 359 30051 Liberty County, Montana 2430 147 138 151 129 131 158 143 150 124 119 151 175 214 133 94 100 66 107          
968 968 30055 McCone County, Montana 1675 94 88 104 83 92 75 91 74 85 75 84 146 146 140 94 84 69 51          
366 366 38083 Sheridan County, North Dakota 1349 76 66 61 71 50 49 65 54 39 73 88 107 113 96 95 87 70 89          
165 165 31057 Dundy County, Nebraska 1770 86 99 93 97 115 64 87 92 93 116 86 147 148 139 97 71 58 82          
977 977 2016 Aleutians West Census Area, Alaska 5723 180 184 167 209 419 575 482 486 550 562 586 514 415 230 97 32 14 21          
1284 1284 30019 Daniels County, Montana 1747 90 117 100 90 65 87 100 94 83 81 89 125 163 132 98 68 71 94          
218 218 48383 Reagan County, Texas 3741 291 325 312 259 264 225 248 278 268 209 220 211 211 143 99 70 62 46          
903 903 48447 Throckmorton County, Texas 1515 73 82 93 82 62 67 61 87 67 75 108 121 112 116 99 86 69 55          
1301 1301 30079 Prairie County, Montana 1087 49 55 50 49 43 41 49 46 59 63 50 78 109 110 100 50 32 54          
1256 1256 46111 Sanborn County, South Dakota 2429 186 167 174 128 116 117 167 152 135 117 111 199 183 181 101 68 56 71          
524 524 20129 Morton County, Kansas 2667 136 193 192 191 131 97 131 163 160 162 167 204 199 154 102 99 74 112          
959 959 30025 Fallon County, Montana 2920 217 219 231 182 119 183 177 174 161 164 163 194 242 161 102 93 65 73          
1138 1138 46049 Faulk County, South Dakota 2330 193 156 150 124 113 123 113 121 105 104 126 175 183 148 102 88 89 117          
1232 1232 31049 Deuel County, Nebraska 1825 97 100 132 94 67 77 91 100 95 99 123 168 153 126 104 87 62 50          
1264 1264 38027 Eddy County, North Dakota 2313 163 132 154 145 97 114 123 109 122 98 143 183 198 168 104 82 74 104          
428 428 46055 Haakon County, South Dakota 1918 115 126 137 114 88 86 89 118 85 85 73 158 176 125 105 94 73 71          
689 689 49031 Piute County, Utah 1445 47 75 133 109 62 58 50 68 83 68 70 90 115 135 105 86 45 46          
923 923 41055 Sherman County, Oregon 1708 91 77 86 93 56 78 97 93 99 98 102 147 138 128 105 85 69 66          
669 669 48079 Cochran County, Texas 2836 205 206 225 217 143 196 191 165 132 154 174 197 168 131 107 84 89 52          
2820 2820 38075 Renville County, North Dakota 2374 144 148 143 149 108 128 126 135 114 140 164 208 185 145 107 76 72 82 33500 Outlying Renville County   North Dakota
14 14 49033 Rich County, Utah 2464 188 210 206 182 145 126 139 145 133 123 118 141 165 152 108 84 36 63          
409 409 41069 Wheeler County, Oregon 1366 67 50 54 64 43 54 60 56 55 65 81 100 142 135 108 113 60 59          

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [2018_county_census] (
   [statecountyfips] INTEGER,
   [geo_display] TEXT,
   [est2018_all] INTEGER,
   [est2018_0to4] INTEGER,
   [est2018_5to9] INTEGER,
   [est2018_10to14] INTEGER,
   [est2018_15to19] INTEGER,
   [est2018_20to24] INTEGER,
   [est2018_25to29] INTEGER,
   [est2018_30to34] INTEGER,
   [est2018_35to39] INTEGER,
   [est2018_40to44] INTEGER,
   [est2018_45to49] INTEGER,
   [est2018_50to54] INTEGER,
   [est2018_55to59] INTEGER,
   [est2018_60to64] INTEGER,
   [est2018_65to69] INTEGER,
   [est2018_70to74] INTEGER,
   [est2018_75to79] INTEGER,
   [est2018_80to84] INTEGER,
   [est2018_85plus] INTEGER,
   [cbsacode] TEXT,
   [centraloutlyingcounty] TEXT,
   [countyequivalent] TEXT,
   [csatitle] TEXT,
   [statename] TEXT
);