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_80to84

✎ 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
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          
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          
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          
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          
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          
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          
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          
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
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          
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          
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          
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          
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          
2614 2614 8047 Gilpin County, Colorado 6121 229 218 321 276 209 286 360 369 510 495 533 654 626 506 277 143 64 45 19740 Outlying Gilpin County Denver-Aurora, CO Colorado
269 269 8113 San Miguel County, Colorado 8191 326 391 469 368 380 636 662 586 616 681 639 607 629 558 358 159 65 61          
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          
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          
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          
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          
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          
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          
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          
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
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          
223 223 2290 Yukon-Koyukuk Census Area, Alaska 5327 371 478 393 366 277 376 344 349 287 229 312 354 381 345 197 131 69 68          
751 751 48243 Jeff Davis County, Texas 2252 35 27 29 109 78 101 112 94 112 150 137 213 270 257 225 145 69 89          
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          
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          
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          
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          
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          
967 967 2180 Nome Census Area, Alaska 10008 1009 1054 910 787 699 847 722 640 527 485 510 570 474 326 219 115 71 43          
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          
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          
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          
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
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
2833 2833 13007 Baker County, Georgia 3092 164 145 177 169 177 182 158 151 156 196 207 265 249 244 168 115 72 97 10500 Outlying Baker County   Georgia
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          
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          
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          
2215 2215 48229 Hudspeth County, Texas 4795 287 297 275 262 363 486 464 369 349 235 198 241 232 225 207 145 73 87 21340 Outlying Hudspeth County El Paso-Las Cruces, TX-NM Texas
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
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          
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          
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          
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          
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          
861 861 46105 Perkins County, South Dakota 2922 175 172 152 168 151 123 122 154 152 141 180 246 251 208 178 122 75 152          
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          
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
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          
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
181 181 48435 Sutton County, Texas 3758 240 242 245 273 186 226 214 190 200 268 240 270 274 213 188 111 77 101          
434 434 38039 Griggs County, North Dakota 2232 115 141 124 114 100 82 92 115 94 111 115 167 188 194 173 112 77 118          
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          
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          
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          
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          
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          
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          
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
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          
759 759 46121 Todd County, South Dakota 10283 1334 1235 1134 947 685 764 650 559 486 421 456 427 424 290 185 114 80 92          
9 9 48327 Menard County, Texas 2139 91 107 120 103 87 103 81 97 87 106 113 183 182 170 181 139 81 108          
328 328 2198 Prince of Wales-Hyder Census Area, Alaska 6422 389 418 420 395 302 362 413 373 346 362 502 521 523 479 315 165 82 55          
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          
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          
846 846 20207 Woodson County, Kansas 3183 168 181 194 196 133 160 168 211 138 147 195 263 256 263 178 124 83 125          
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          
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          
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          
1868 1868 48317 Martin County, Texas 5753 508 521 487 432 323 377 438 359 295 359 332 355 319 194 185 108 85 76 33260 Outlying Martin County Midland-Odessa, TX Texas
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          
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          
306 306 8025 Crowley County, Colorado 5858 147 206 222 194 483 657 563 535 496 511 383 361 297 258 213 144 87 101          
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          
754 754 48111 Dallam County, Texas 7200 697 565 631 563 427 525 510 443 360 488 433 408 326 299 204 143 88 90          
3051 3051 16063 Lincoln County, Idaho 5360 367 432 467 443 308 309 296 382 361 301 321 304 311 262 210 107 88 91 25200 Outlying Lincoln County   Idaho
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          
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          
151 151 38081 Sargent County, North Dakota 3870 221 228 224 199 204 248 194 215 208 218 258 302 279 287 218 157 90 120          
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          
1195 1195 46102 Oglala Lakota County, South Dakota 14309 1462 1563 1508 1262 1114 1168 1019 846 681 715 714 669 543 415 268 194 90 78          
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          
2900 2900 26083 Keweenaw County, Michigan 2113 89 68 94 96 65 83 62 85 89 104 104 183 214 244 221 158 90 64 26340 Outlying Keweenaw County   Michigan
721 721 20105 Lincoln County, Kansas 3023 162 204 194 190 125 130 108 185 139 158 187 229 273 224 175 96 91 153          
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          
815 815 38037 Grant County, North Dakota 2374 148 158 121 96 94 103 113 106 105 119 129 192 180 210 170 132 91 107          
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          
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          
591 591 8091 Ouray County, Colorado 4833 142 210 226 232 161 178 214 251 292 299 310 441 563 524 368 242 92 88          
791 791 20007 Barber County, Kansas 4472 273 303 280 243 194 236 255 258 182 219 238 371 393 321 285 183 92 146          
893 893 13239 Quitman County, Georgia 2279 118 96 107 130 80 93 109 80 97 120 148 156 234 212 198 135 92 74          
1247 1247 51091 Highland County, Virginia 2210 100 67 65 85 66 108 83 72 98 103 110 230 263 242 218 136 92 72          
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          
521 521 2240 Southeast Fairbanks Census Area, Alaska 6918 515 498 447 418 325 527 485 443 416 435 433 491 480 405 272 182 93 53          
532 532 2261 Valdez-Cordova Census Area, Alaska 9164 622 576 576 567 462 574 656 619 502 536 637 806 775 549 365 183 93 66          
164 164 46025 Clark County, South Dakota 3739 392 259 219 167 210 228 205 190 162 161 197 276 282 269 172 141 94 115          

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