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)

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
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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
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          
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
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          
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          
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
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
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          
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
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          
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          
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          
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          
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          
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
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          
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          
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          
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
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          
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          
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          
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          
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
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          
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
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
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          
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          
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
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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
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          
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          
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          
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          
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
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
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          
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          
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          
1013 1013 49055 Wayne County, Utah 2690 163 172 191 198 148 108 168 144 131 143 146 187 205 226 170 98 46 46          
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          
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          
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          
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          
908 908 2185 North Slope Borough, Alaska 9872 788 780 693 556 557 825 820 689 570 677 881 822 541 310 171 86 58 48          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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
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
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          

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