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_25to29

✎ 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
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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
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          
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          
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          
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          
667 667 31133 Pawnee County, Nebraska 2632 168 155 149 145 115 115 113 126 108 125 141 213 204 200 178 119 100 158          
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          
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          
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          
386 386 38063 Nelson County, North Dakota 2869 148 153 160 140 127 118 135 139 135 128 169 270 275 214 186 135 109 128          
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
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          
16 16 35003 Catron County, New Mexico 3578 110 105 127 151 133 123 107 111 107 138 144 333 403 474 429 287 177 119          
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          
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          
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          
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          
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          
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          
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          
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
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          
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          
472 472 20089 Jewell County, Kansas 2841 156 148 158 130 125 129 134 112 124 126 154 215 274 241 196 158 115 146          
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          
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          
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          
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          
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          
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          
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          
635 635 31163 Sherman County, Nebraska 3038 162 169 196 175 135 137 122 133 139 161 194 231 261 230 193 138 130 132          
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          
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          
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          
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          
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          
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          
324 324 38029 Emmons County, North Dakota 3295 171 166 191 180 193 144 120 139 144 164 211 273 280 245 201 156 149 168          
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          
213 213 26131 Ontonagon County, Michigan 5795 154 177 257 236 190 145 169 210 221 319 414 572 634 678 533 405 290 191          
735 735 27155 Traverse County, Minnesota 3308 188 190 197 182 188 147 139 179 171 149 221 256 269 197 172 153 124 186          
620 620 30039 Granite County, Montana 3378 114 141 155 158 128 149 121 180 175 154 200 328 343 345 265 216 103 103          
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          
842 842 31061 Franklin County, Nebraska 3023 155 162 168 156 132 149 141 131 147 148 170 262 249 254 189 165 119 126          
565 565 27077 Lake of the Woods County, Minnesota 3758 186 186 225 168 172 151 176 202 184 200 265 333 399 328 206 167 107 103          
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          
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          
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          
103 103 30097 Sweet Grass County, Montana 3710 170 183 249 221 203 154 167 171 195 212 230 259 310 289 254 179 120 144          
1066 1066 31083 Harlan County, Nebraska 3401 184 207 202 204 139 155 128 169 157 189 200 283 293 262 222 154 122 131          
1225 1225 20019 Chautauqua County, Kansas 3309 165 186 202 181 142 155 181 181 145 168 182 259 277 227 221 196 116 125          
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          
2494 2494 32029 Storey County, Nevada 4029 98 116 176 152 136 156 169 172 187 252 267 422 458 438 412 223 99 96 39900 Outlying Storey County Reno-Carson City-Fernley, NV Nevada
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
722 722 20183 Smith County, Kansas 3603 206 190 206 196 164 163 129 197 172 160 196 317 310 289 203 154 143 208          
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          
1002 1002 40129 Roger Mills County, Oklahoma 3656 242 231 293 232 177 167 180 248 196 194 215 256 265 224 182 144 112 98          
562 562 17069 Hardin County, Illinois 3910 165 187 217 215 183 168 178 211 199 261 287 319 315 325 270 193 116 101          
826 826 48191 Hall County, Texas 3028 143 200 205 229 166 168 134 167 142 161 179 220 213 184 173 143 105 96          
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          
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          
431 431 38103 Wells County, North Dakota 3957 231 241 224 204 150 172 211 158 160 187 266 334 320 283 239 205 164 208          
621 621 38031 Foster County, North Dakota 3216 205 166 205 168 176 172 171 154 175 184 182 271 263 181 177 106 106 154          
1268 1268 46053 Gregory County, South Dakota 4212 277 249 296 260 202 172 175 216 224 215 218 308 328 304 251 180 140 197          
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
113 113 17151 Pope County, Illinois 4212 111 124 160 253 251 173 157 222 211 251 292 424 405 379 286 221 146 146          

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