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)

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
629 629 29227 Worth County, Missouri 2040 108 119 107 125 97 106 106 96 93 95 136 170 177 132 109 93 79 92          
88 88 13265 Taliaferro County, Georgia 1608 66 91 73 65 81 89 84 80 95 84 123 130 124 130 110 70 44 69          
583 583 46071 Jackson County, South Dakota 3307 354 303 301 264 229 189 192 151 150 155 196 203 178 138 110 72 63 59          
320 320 38047 Logan County, North Dakota 1903 127 116 124 107 101 81 82 79 89 98 106 157 142 117 111 99 80 87          
212 212 48045 Briscoe County, Texas 1516 65 85 90 82 76 69 92 82 96 84 97 111 90 102 112 74 62 47          
417 417 38091 Steele County, North Dakota 1903 136 109 105 96 103 107 84 90 86 101 106 162 159 150 112 87 63 47          
792 792 20109 Logan County, Kansas 2844 210 188 176 165 152 185 145 167 162 108 149 228 217 177 112 102 91 110          
1067 1067 30075 Powder River County, Montana 1716 76 66 90 92 86 94 65 85 80 78 113 161 164 157 112 71 56 70          
1030 1030 31069 Garden County, Nebraska 1897 88 112 114 90 83 81 113 81 70 101 107 169 158 140 113 114 90 73          
111 111 38013 Burke County, North Dakota 2100 175 135 134 122 88 129 107 131 102 99 109 163 170 153 114 69 42 58          
950 950 48421 Sherman County, Texas 3079 210 241 278 216 180 185 167 174 161 198 230 189 191 136 114 86 55 68          
973 973 38095 Towner County, North Dakota 2192 122 138 123 111 105 71 106 103 82 111 168 191 211 159 114 95 91 91          
2846 2846 38065 Oliver County, North Dakota 1952 128 141 146 114 63 82 111 107 93 92 131 143 168 168 114 62 36 53 13900 Outlying Oliver County   North Dakota
720 720 2070 Dillingham Census Area, Alaska 5000 498 482 379 363 359 431 347 289 231 230 294 335 292 199 115 80 41 35          
2347 2347 13101 Echols County, Georgia 4000 251 327 308 259 239 270 319 244 291 253 257 243 218 188 115 79 79 60 46660 Outlying Echols County   Georgia
630 630 48295 Lipscomb County, Texas 3355 199 237 273 232 176 175 231 248 161 160 191 244 220 203 116 112 83 94          
173 173 46073 Jerauld County, South Dakota 2043 131 138 137 100 73 83 116 129 107 91 100 138 150 174 118 88 68 102          
237 237 21201 Robertson County, Kentucky 2135 108 120 138 116 115 117 105 95 130 132 165 178 156 121 118 100 55 66          
493 493 20033 Comanche County, Kansas 1748 85 141 114 114 72 79 82 92 83 100 91 126 122 131 118 85 53 60          
1077 1077 56027 Niobrara County, Wyoming 2388 133 116 98 119 134 153 163 159 135 154 117 141 226 179 118 93 98 52          
2113 2113 31073 Gosper County, Nebraska 1996 117 113 119 134 86 79 111 117 81 115 114 171 162 132 118 71 76 80 30420 Outlying Gosper County   Nebraska
841 841 2013 Aleutians East Borough, Alaska 3515 83 85 70 88 289 309 255 296 448 377 399 288 204 107 119 47 23 28          
961 961 48109 Culberson County, Texas 2204 155 115 138 138 143 141 115 118 93 123 149 151 152 145 120 74 65 69          
1279 1279 38041 Hettinger County, North Dakota 2514 179 171 179 131 104 164 142 131 123 124 139 182 181 145 121 93 102 103          
1327 1327 2105 Hoonah-Angoon Census Area, Alaska 2151 102 115 119 95 87 100 112 119 106 152 168 202 191 202 121 90 46 24          
158 158 31077 Greeley County, Nebraska 2356 150 148 165 126 116 99 134 113 133 82 141 183 162 161 122 108 97 116          
1051 1051 20097 Kiowa County, Kansas 2516 169 157 156 194 196 123 123 105 128 121 135 177 180 179 122 73 78 100          
1389 1389 48011 Armstrong County, Texas 1892 108 142 121 102 77 89 87 113 111 112 82 146 149 135 122 84 68 44 11100 Outlying Armstrong County Amarillo-Borger, TX Texas
266 266 48461 Upton County, Texas 3671 297 319 285 267 180 240 268 231 230 199 185 198 256 148 123 102 71 72          
1290 1290 40025 Cimarron County, Oklahoma 2153 139 164 142 137 94 98 116 108 101 122 117 135 132 170 123 121 75 59          
458 458 40057 Harmon County, Oklahoma 2664 168 179 210 172 135 141 152 162 135 151 186 175 173 160 126 86 73 80          
1116 1116 38025 Dunn County, North Dakota 4332 326 296 267 222 219 327 304 264 223 209 266 366 353 249 126 110 118 87          
1091 1091 46059 Hand County, South Dakota 3262 191 205 227 147 162 169 147 167 159 132 215 255 260 228 128 140 133 197          
1267 1267 46031 Corson County, South Dakota 4165 429 419 450 355 219 278 231 216 215 168 233 250 231 153 128 91 55 44          
1945 1945 46061 Hanson County, South Dakota 3376 256 290 302 275 159 172 143 217 204 185 225 202 225 258 128 77 28 30 33580 Outlying Hanson County   South Dakota
1040 1040 20179 Sheridan County, Kansas 2533 171 165 191 159 122 116 120 142 123 117 130 197 196 169 129 89 74 123          
1722 1722 13053 Chattahoochee County, Georgia 10684 898 711 500 818 2334 1680 1006 649 471 312 343 225 221 147 129 106 75 59 17980 Central Chattahoochee County Columbus-Auburn-Opelika, GA-AL Georgia
856 856 30045 Judith Basin County, Montana 1952 88 104 108 103 71 81 77 102 96 95 133 196 169 165 130 116 60 58          
1176 1176 30107 Wheatland County, Montana 2236 140 157 151 200 118 92 97 90 116 134 90 129 188 171 130 101 53 79          
7 7 35011 De Baca County, New Mexico 1781 86 130 109 115 75 68 86 107 68 82 90 144 124 156 131 80 57 73          
46 46 31015 Boyd County, Nebraska 1955 88 107 100 114 105 73 77 85 84 89 107 176 152 177 131 110 69 111          
225 225 48103 Crane County, Texas 4794 382 404 398 362 316 325 299 311 294 272 281 318 260 177 131 101 83 80          
438 438 31071 Garfield County, Nebraska 1987 95 79 111 122 119 77 92 77 105 84 106 163 186 144 132 93 100 102          
901 901 20135 Ness County, Kansas 2840 165 167 178 167 135 114 137 144 120 134 139 268 237 209 132 136 111 147          
1047 1047 48125 Dickens County, Texas 2249 116 106 122 145 124 162 147 133 158 122 97 148 156 136 132 119 70 56          
391 391 38043 Kidder County, North Dakota 2450 149 144 139 128 95 108 143 140 111 131 139 183 240 179 133 113 92 83          
687 687 41021 Gilliam County, Oregon 1894 86 121 100 96 85 62 84 118 81 92 102 149 191 155 133 85 65 89          
943 943 20081 Haskell County, Kansas 3997 280 318 326 299 271 236 237 226 228 236 214 272 263 226 134 101 63 67          
872 872 2158 Kusilvak Census Area, Alaska 8303 1088 1026 815 729 641 733 585 420 325 339 390 410 306 208 135 62 44 47          
600 600 48087 Collingsworth County, Texas 2962 179 253 220 211 179 159 169 180 145 157 170 196 185 173 137 99 76 74          
58 58 8115 Sedgwick County, Colorado 2303 120 130 132 123 101 112 129 127 118 112 107 169 219 167 138 108 85 106          
522 522 20065 Graham County, Kansas 2492 101 154 152 116 100 120 119 137 128 102 135 220 224 162 138 144 126 114          
488 488 38001 Adams County, North Dakota 2294 117 128 117 117 82 98 149 120 110 106 130 185 196 173 139 103 101 123          
1178 1178 46089 McPherson County, South Dakota 2407 157 175 166 137 95 99 104 124 111 110 124 160 169 165 139 110 122 140          
1194 1194 13125 Glascock County, Georgia 2995 142 178 194 214 168 180 149 163 200 229 213 217 210 160 139 101 54 84          
462 462 46041 Dewey County, South Dakota 5904 770 634 535 463 365 377 358 359 259 271 326 349 279 192 140 97 77 53          
110 110 40059 Harper County, Oklahoma 3797 256 280 319 247 175 187 218 242 226 182 239 293 247 213 141 115 115 102          
309 309 38011 Bowman County, North Dakota 3076 192 227 215 171 155 156 167 191 158 154 140 215 276 190 142 117 93 117          
960 960 46107 Potter County, South Dakota 2207 122 121 154 121 96 103 87 111 87 100 122 184 161 187 144 98 97 112          
1033 1033 20047 Edwards County, Kansas 2849 171 188 189 178 143 130 131 160 149 154 185 222 243 192 144 102 99 69          
2901 2901 20093 Kearny County, Kansas 3943 315 341 334 249 241 260 285 234 208 186 233 250 195 185 144 94 101 88 23780 Outlying Kearny County   Kansas
557 557 20063 Gove County, Kansas 2612 167 187 175 148 120 115 138 143 139 107 134 196 208 166 145 98 94 132          
840 840 46003 Aurora County, South Dakota 2801 179 182 196 206 144 133 181 169 128 159 149 182 216 161 145 87 95 89          
331 331 2275 Wrangell City and Borough, Alaska 2503 116 154 147 132 133 129 127 121 99 149 150 236 262 211 146 78 72 41          
1245 1245 31063 Frontier County, Nebraska 2608 130 134 150 210 161 130 131 125 122 147 134 179 232 181 147 112 86 97          
1293 1293 31125 Nance County, Nebraska 3532 195 222 226 215 160 198 169 199 187 176 224 311 295 254 147 98 116 140          
566 566 46085 Lyman County, South Dakota 3821 350 311 298 261 219 221 213 208 201 170 197 285 282 189 148 125 84 59          
248 248 31087 Hitchcock County, Nebraska 2806 152 164 214 160 119 115 125 202 128 154 129 222 211 228 149 128 94 112          
301 301 48211 Hemphill County, Texas 3825 258 295 384 361 169 183 223 249 278 225 203 243 201 186 149 93 58 67          
455 455 38023 Divide County, North Dakota 2283 143 136 162 101 80 107 123 124 97 89 159 202 183 157 149 87 78 106          
807 807 53023 Garfield County, Washington 2247 160 115 124 115 100 80 114 119 143 117 122 160 207 187 149 75 75 85          
1314 1314 31135 Perkins County, Nebraska 2929 198 198 215 188 131 112 176 176 171 128 141 205 203 223 149 99 90 126          
1242 1242 8033 Dolores County, Colorado 2074 73 133 129 112 84 87 81 120 115 126 134 165 195 163 150 96 61 50          
1248 1248 30091 Sheridan County, Montana 3424 178 212 205 159 163 158 179 270 179 163 202 259 323 257 151 131 114 121          
100 100 48413 Schleicher County, Texas 2895 150 189 252 238 136 157 190 194 144 174 161 179 164 201 152 110 55 49          
105 105 2188 Northwest Arctic Borough, Alaska 7671 780 857 697 601 542 721 530 449 344 377 454 425 333 181 152 90 72 66          
469 469 38051 McIntosh County, North Dakota 2585 121 145 142 110 126 101 124 116 92 104 162 225 224 162 152 139 145 195          
329 329 2195 Petersburg Borough, Alaska 3221 193 209 159 176 179 185 201 191 182 207 210 253 261 264 153 102 47 49          
605 605 13307 Webster County, Georgia 2611 121 117 157 172 151 134 110 115 129 180 222 184 202 186 154 111 73 93          
2490 2490 46117 Stanley County, South Dakota 3022 187 198 228 178 123 174 156 186 188 169 199 198 221 203 155 124 73 62 38180 Central Stanley County   South Dakota
43 43 20039 Decatur County, Kansas 2871 163 168 138 144 118 141 165 123 121 112 188 213 269 219 156 133 109 191          
89 89 30059 Meagher County, Montana 1866 98 112 96 84 71 78 81 88 89 99 90 135 172 202 157 89 54 71          
126 126 20195 Trego County, Kansas 2793 135 134 137 150 118 134 148 154 118 165 158 245 257 237 157 122 97 127          
375 375 48137 Edwards County, Texas 1928 125 135 114 99 77 97 75 98 80 96 103 128 140 181 159 106 59 56          
1224 1224 29129 Mercer County, Missouri 3641 234 220 250 246 192 183 165 189 162 219 205 278 295 244 159 150 104 146          
1859 1859 16023 Butte County, Idaho 2611 143 178 192 167 132 112 114 139 133 133 128 196 232 189 159 121 72 71 26820 Outlying Butte County Idaho Falls-Rexburg-Blackfoot, ID Idaho
60 60 46043 Douglas County, South Dakota 2935 223 196 197 195 122 138 148 132 120 124 175 218 240 189 161 113 96 148          
839 839 20017 Chase County, Kansas 2629 135 151 149 150 158 153 128 127 137 140 157 205 178 192 161 131 78 99          
1158 1158 20119 Meade County, Kansas 4146 275 306 311 291 268 234 201 205 196 267 242 285 266 227 162 140 114 156          
73 73 31017 Brown County, Nebraska 2973 131 181 189 195 144 125 133 125 165 165 167 237 240 230 163 148 110 125          
2597 2597 51720 Norton city, Virginia 3968 201 246 203 238 252 315 293 244 236 229 241 256 274 237 163 142 104 94 13720 Central Norton city   Virginia
304 304 48417 Shackelford County, Texas 3253 172 203 231 237 143 178 186 146 188 181 179 280 264 190 164 124 109 78          
878 878 20153 Rawlins County, Kansas 2508 157 160 139 116 100 133 122 140 103 110 142 187 199 188 164 134 101 113          
910 910 20141 Osborne County, Kansas 3475 192 197 203 183 172 185 200 189 162 145 211 277 291 220 164 168 143 173          
395 395 20023 Cheyenne County, Kansas 2660 180 151 140 154 134 127 120 157 133 115 133 176 223 185 165 120 87 160          
3092 3092 55078 Menominee County, Wisconsin 4658 465 434 429 392 263 287 255 222 190 233 260 320 293 213 165 112 62 63 43020 Outlying Menominee County Green Bay-Shawano, WI Wisconsin
257 257 20165 Rush County, Kansas 3093 167 170 192 184 147 138 146 150 168 170 189 239 265 223 167 115 116 147          
1094 1094 20049 Elk County, Kansas 2508 146 159 160 115 91 102 87 119 102 124 145 202 227 200 167 150 120 92          
572 572 2100 Haines Borough, Alaska 2474 89 111 129 141 110 97 146 150 147 145 179 229 255 223 168 68 38 49          
1022 1022 48105 Crockett County, Texas 3499 235 248 248 209 188 192 193 235 203 217 228 225 258 188 168 127 74 63          

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
);