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_0to4

✎ 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
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          
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          
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          
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          
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          
221 221 36041 Hamilton County, New York 4434 116 151 182 190 192 182 155 204 181 248 325 420 502 497 363 244 127 155          
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          
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          
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          
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          
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          
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          
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
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          
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          
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          
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          
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          
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          
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          
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          
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          
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
188 188 51580 Covington city, Virginia 5460 130 325 323 323 333 351 349 302 299 341 395 436 393 315 346 231 134 134          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
6 6 53069 Wahkiakum County, Washington 4426 137 230 229 265 174 183 169 181 193 227 285 323 406 443 418 267 164 132          
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          
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          
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          
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          
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          
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          
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          
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          
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
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          
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          
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          
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          
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          
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          
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          
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          
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          
23 23 42053 Forest County, Pennsylvania 7279 152 147 182 445 659 728 563 459 381 468 452 499 499 463 481 340 219 142          
182 182 51595 Emporia city, Virginia 5121 152 334 367 349 276 375 301 294 276 311 337 352 361 246 246 193 144 207          
200 200 48271 Kinney County, Texas 3767 152 194 229 221 260 240 225 235 249 211 212 183 252 216 223 194 156 115          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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
503 503 51530 Buena Vista city, Virginia 6237 165 346 358 552 611 467 330 327 330 331 410 385 406 354 327 238 158 142          
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          
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          
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          
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          
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          
2331 2331 55037 Florence County, Wisconsin 4321 167 174 187 165 166 178 201 210 194 234 367 461 492 377 302 196 132 118 27020 Outlying Florence County   Wisconsin
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          
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          
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          
37 37 31181 Webster County, Nebraska 3533 169 242 230 200 188 203 147 189 172 201 212 292 278 229 180 149 125 127          
430 430 16003 Adams County, Idaho 4250 169 227 226 195 132 183 176 186 198 213 221 382 521 456 315 227 123 100          
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          
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          
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          
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          
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          
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          
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          
284 284 8023 Costilla County, Colorado 3828 173 194 215 213 181 185 184 183 158 179 248 282 388 320 299 195 130 101          
707 707 55051 Iron County, Wisconsin 5676 173 233 289 252 210 198 203 262 279 330 391 521 583 527 469 284 205 267          
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          
479 479 42113 Sullivan County, Pennsylvania 6071 175 165 154 322 335 294 286 316 290 346 437 584 649 522 438 324 229 205          
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          
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          

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