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_85plus

✎ 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
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          
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          
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          
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
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          
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
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          
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          
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
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
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          
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          
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          
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          
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
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
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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
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          
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          
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          
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          
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          
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          
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          
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          
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
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          
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          
886 886 49001 Beaver County, Utah 6580 574 581 626 529 378 375 373 426 383 328 284 365 410 339 225 185 121 78          
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          
50 50 48247 Jim Hogg County, Texas 5248 423 418 493 427 287 280 322 301 320 236 286 289 243 271 258 185 130 79          
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          
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          
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          
804 804 48095 Concho County, Texas 4276 117 111 182 160 249 372 352 404 446 368 265 258 236 235 198 142 101 80          
848 848 13065 Clinch County, Georgia 6648 438 487 474 440 412 443 409 393 391 417 448 396 423 360 320 199 118 80          
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
604 604 2050 Bethel Census Area, Alaska 18216 2043 1877 1640 1574 1319 1507 1318 1033 826 845 975 1036 821 596 352 238 135 81          
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          
361 361 13061 Clay County, Georgia 2887 149 157 177 160 116 163 144 171 140 129 166 190 251 237 226 133 96 82          
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
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          
690 690 48129 Donley County, Texas 3319 171 177 185 326 245 149 127 197 166 139 177 219 245 242 191 160 120 83          
1106 1106 32027 Pershing County, Nevada 6666 267 322 316 311 399 519 488 478 500 556 514 495 438 333 286 246 115 83          
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          
10 10 6091 Sierra County, California 2987 139 133 130 115 110 128 119 143 145 152 169 279 280 347 239 174 100 85          
447 447 48385 Real County, Texas 3478 153 158 175 157 157 157 141 165 153 202 218 267 350 321 278 191 150 85          
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          
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          
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          
402 402 48169 Garza County, Texas 6578 302 294 310 441 688 848 560 356 400 564 352 470 264 192 178 147 125 87          
696 696 32015 Lander County, Nevada 5575 430 421 418 331 267 366 397 356 291 325 392 376 323 274 236 180 105 87          
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          
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
492 492 13003 Atkinson County, Georgia 8297 598 604 605 574 549 581 513 495 531 554 517 540 469 403 305 241 130 88          
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          
2495 2495 13249 Schley County, Georgia 5236 267 329 450 397 264 276 264 279 335 458 380 355 285 259 259 195 96 88 11140 Outlying Schley County   Georgia
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
80 80 8027 Custer County, Colorado 4954 163 184 186 219 167 202 167 216 197 246 267 510 636 678 467 231 129 89          
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          
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          
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          
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          
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          
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          
788 788 8065 Lake County, Colorado 7824 416 420 484 432 543 691 628 587 514 510 470 522 490 503 252 170 102 90          
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          
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          
978 978 2150 Kodiak Island Borough, Alaska 13345 1042 961 900 840 911 1100 1066 987 833 702 815 921 888 514 404 241 129 91          
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
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          
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          
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          
342 342 21189 Owsley County, Kentucky 4472 299 248 280 259 226 261 282 244 254 287 316 318 321 311 195 179 99 93          
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          
1474 1474 21077 Gallatin County, Kentucky 8832 565 574 624 586 508 634 497 556 531 603 658 666 597 425 354 248 113 93 17140 Outlying Gallatin County Cincinnati-Wilmington-Maysville, OH-KY-IN Kentucky
2415 2415 54105 Wirt County, West Virginia 5830 290 361 388 309 261 287 318 317 352 368 409 490 500 381 328 230 148 93 37620 Outlying Wirt County Parkersburg-Marietta-Vienna, WV-OH West Virginia
259 259 21129 Lee County, Kentucky 7033 406 330 379 360 374 476 461 447 429 477 580 566 512 461 357 191 133 94          
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          
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          

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