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

✎ 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
101 101 21001 Adair County, Kentucky 19215 1059 977 1129 1521 1467 1236 1009 1027 1028 1180 1328 1406 1277 1185 915 666 433 372          
102 102 21097 Harrison County, Kentucky 18778 1164 1065 1244 1176 1060 1194 958 1035 1104 1262 1377 1458 1383 1101 817 623 397 360          
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          
104 104 42059 Greene County, Pennsylvania 36506 1906 1946 2022 2275 2360 2388 2109 2085 2274 2512 2411 2622 2700 2399 1752 1152 750 843          
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          
106 106 1105 Perry County, Alabama 9140 500 532 551 900 830 516 441 456 457 503 497 549 634 497 443 361 238 235          
107 107 20151 Pratt County, Kansas 9378 653 649 642 677 597 511 518 547 471 444 445 636 693 575 385 342 239 354          
108 108 13075 Cook County, Georgia 17162 1095 1154 1309 1146 1081 1046 1045 1059 1022 1128 1127 1109 1002 946 724 540 363 266          
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          
110 110 40059 Harper County, Oklahoma 3797 256 280 319 247 175 187 218 242 226 182 239 293 247 213 141 115 115 102          
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          
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          
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          
114 114 49013 Duchesne County, Utah 19964 1819 1943 1893 1582 1029 1231 1363 1495 1271 978 892 1046 1014 774 610 447 303 274          
115 115 40003 Alfalfa County, Oklahoma 5754 304 350 296 290 238 289 317 461 428 425 428 395 404 338 247 207 168 169          
116 116 48119 Delta County, Texas 5349 366 334 340 328 250 316 266 330 277 317 352 339 420 345 292 254 128 95          
117 117 21193 Perry County, Kentucky 26092 1754 1658 1625 1412 1295 1668 1577 1627 1691 1696 1911 1857 1892 1616 1156 750 510 397          
118 118 46039 Deuel County, South Dakota 4337 278 279 305 262 194 228 228 246 216 224 272 336 320 293 232 151 130 143          
119 119 48507 Zavala County, Texas 11983 919 1055 963 968 1002 916 708 649 689 650 594 591 567 584 422 281 201 224          
120 120 26151 Sanilac County, Michigan 41182 2215 2378 2606 2486 2191 2175 2042 2200 2163 2447 2802 3282 3376 2904 2152 1662 1149 952          
121 121 1063 Greene County, Alabama 8233 475 518 515 483 465 531 421 445 384 414 481 617 647 640 432 318 206 241          
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          
123 123 19109 Kossuth County, Iowa 14908 849 870 973 874 758 741 763 813 676 736 885 1243 1189 974 746 621 568 629          
124 124 27001 Aitkin County, Minnesota 15902 594 737 858 704 595 612 609 707 612 767 953 1361 1542 1580 1398 1096 642 535          
125 125 38071 Ramsey County, North Dakota 11481 810 778 710 703 666 699 654 620 571 586 703 863 836 689 526 404 287 376          
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          
127 127 48133 Eastland County, Texas 18322 1112 983 1127 1402 1142 993 904 1045 917 951 1060 1358 1325 1137 1060 769 532 505          
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          
129 129 48123 DeWitt County, Texas 20187 1275 1257 1235 1182 956 1162 1249 1318 1249 1225 1284 1442 1330 1197 979 713 562 572          
130 130 29125 Maries County, Missouri 8769 389 480 562 528 477 454 443 498 484 546 630 736 659 588 453 383 230 229          
131 131 5001 Arkansas County, Arkansas 17769 1179 1163 1079 1016 975 1113 923 1009 1075 1067 1140 1278 1268 1120 884 598 443 439          
132 132 29109 Lawrence County, Missouri 38359 2555 2592 2799 2631 2079 2159 2100 2336 2132 2399 2377 2745 2437 2033 1756 1302 926 1001          
133 133 39163 Vinton County, Ohio 13139 737 730 853 833 693 825 677 769 839 888 892 1082 983 804 615 419 293 207          
134 134 16037 Custer County, Idaho 4280 205 182 215 213 145 184 199 210 221 232 231 388 412 449 336 234 112 112          
135 135 19089 Howard County, Iowa 9187 594 621 698 549 449 478 470 528 491 461 589 690 651 548 455 335 247 333          
136 136 1013 Butler County, Alabama 19680 1119 1232 1288 1173 1090 1196 1083 1254 1136 1182 1131 1360 1441 1242 958 702 508 585          
137 137 51097 King and Queen County, Virginia 7042 304 329 391 339 377 431 374 349 338 449 547 593 609 529 422 305 160 196          
138 138 5015 Carroll County, Arkansas 28223 1654 1613 1759 1673 1487 1534 1452 1488 1487 1623 1741 1985 2183 2190 1807 1206 705 636          
139 139 31151 Saline County, Nebraska 14350 962 1050 1047 1195 1188 760 850 854 826 920 821 920 802 652 520 367 273 343          
140 140 21119 Knott County, Kentucky 15126 841 842 845 1035 1031 885 725 825 900 979 1131 1158 1135 977 760 483 316 258          
141 141 27063 Jackson County, Minnesota 9911 546 568 642 582 467 513 525 600 554 545 562 822 768 637 470 382 317 411          
142 142 6009 Calaveras County, California 45602 1955 2023 2220 2313 2021 2125 2252 2282 1997 2497 2969 3887 4508 4122 3497 2333 1468 1133          
143 143 47097 Lauderdale County, Tennessee 25825 1494 1531 1724 1679 1713 1859 1614 1781 1562 1646 1772 1761 1612 1348 1119 774 463 373          
144 144 41001 Baker County, Oregon 16006 837 895 882 786 716 800 917 906 744 871 921 1206 1298 1349 1050 842 495 491          
145 145 36097 Schuyler County, New York 17912 906 948 966 975 858 1064 962 989 984 1161 1304 1485 1488 1301 981 657 439 444          
146 146 21127 Lawrence County, Kentucky 15571 974 1050 1055 925 776 969 825 970 965 1042 1047 1144 1130 947 730 492 297 233          
147 147 21175 Morgan County, Kentucky 13345 654 643 690 683 808 1057 956 932 935 1015 868 925 944 825 541 373 274 222          
148 148 2220 Sitka City and Borough, Alaska 8647 437 515 590 507 510 618 636 589 584 531 508 624 637 501 339 209 163 149          
149 149 47061 Grundy County, Tennessee 13346 753 741 845 804 731 807 671 799 785 879 886 932 917 817 837 537 355 250          
150 150 27057 Hubbard County, Minnesota 21332 1143 1305 1348 1114 860 941 967 1207 1052 1120 1344 1815 1773 1799 1394 966 635 549          
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          
152 152 29179 Reynolds County, Missouri 6254 269 331 374 373 295 310 295 372 327 399 434 522 504 406 381 265 212 185          
153 153 39125 Paulding County, Ohio 18760 1082 1130 1391 1208 1016 1033 1055 1106 1062 1161 1257 1435 1339 1166 872 646 397 404          
154 154 21055 Crittenden County, Kentucky 8915 471 532 622 524 461 493 432 551 516 534 608 668 651 576 487 396 200 193          
155 155 19147 Palo Alto County, Iowa 8929 556 536 602 579 529 515 457 512 442 465 493 640 645 548 428 306 286 390          
156 156 19159 Ringgold County, Iowa 4968 303 298 348 325 222 211 271 261 243 236 300 349 382 326 276 214 154 249          
157 157 18171 Warren County, Indiana 8263 442 532 543 503 377 456 442 464 457 557 581 645 593 510 409 338 216 198          
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          
159 159 31095 Jefferson County, Nebraska 7097 398 422 460 416 315 333 368 381 363 392 410 548 593 509 386 289 238 276          
160 160 51119 Middlesex County, Virginia 10769 506 427 504 503 454 505 458 482 407 585 679 942 964 920 954 690 387 402          
161 161 42065 Jefferson County, Pennsylvania 43641 2389 2607 2574 2549 2245 2590 2420 2427 2315 2681 2917 3320 3410 2835 2168 1698 1220 1276          
162 162 47027 Clay County, Tennessee 7717 370 452 479 386 349 418 357 384 399 513 588 546 599 555 480 418 234 190          
163 163 21177 Muhlenberg County, Kentucky 30774 1729 1641 1837 1958 1949 1967 1768 1871 1929 1970 2016 2179 2075 1802 1592 1129 724 638          
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          
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          
166 166 48289 Leon County, Texas 17270 1055 1079 1084 1028 807 846 811 907 920 894 988 1281 1344 1248 1128 884 519 447          
167 167 27121 Pope County, Minnesota 11097 614 662 672 547 486 573 661 643 548 570 632 862 917 844 651 446 343 426          
168 168 17033 Crawford County, Illinois 18807 1007 1047 1054 1014 1032 1333 1279 1214 1151 1206 1230 1389 1294 1098 858 652 470 479          
169 169 19025 Calhoun County, Iowa 9699 556 615 574 523 525 561 552 561 515 473 553 690 776 629 500 366 335 395          
170 170 47041 DeKalb County, Tennessee 20138 1137 1166 1288 1150 1090 1240 1195 1204 1223 1384 1438 1522 1402 1224 1047 660 423 345          
171 171 42031 Clarion County, Pennsylvania 38779 2009 1961 2014 2984 3461 2463 2041 2012 1868 2336 2505 2731 2791 2428 1768 1424 1019 964          
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          
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          
174 174 51057 Essex County, Virginia 10919 516 564 571 589 553 675 610 541 525 687 793 897 868 830 673 468 286 273          
175 175 45089 Williamsburg County, South Carolina 30606 1558 1665 1916 1878 1719 2021 1640 1683 1714 1908 1927 2133 2403 2205 1700 1150 694 692          
176 176 36031 Essex County, New York 37300 1455 1653 1755 1901 1887 2201 2238 2132 2045 2337 2690 3121 3142 2843 2186 1603 1007 1104          
177 177 40063 Hughes County, Oklahoma 13335 808 792 794 788 865 959 874 902 779 798 806 849 812 746 671 462 309 321          
178 178 51027 Buchanan County, Virginia 21221 841 1026 1108 1051 1060 1221 1176 1229 1258 1499 1591 1707 1745 1490 1278 927 626 388          
179 179 51005 Alleghany County, Virginia 14910 634 757 826 854 790 796 664 731 726 1015 1099 1144 1192 1041 1020 752 435 434          
180 180 8099 Prowers County, Colorado 12164 869 878 868 969 797 676 669 733 660 632 630 834 806 700 532 375 246 290          
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          
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          
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          
184 184 13251 Screven County, Georgia 13938 833 819 738 809 813 1009 802 759 786 847 961 1070 1070 931 669 477 291 254          
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          
186 186 39069 Henry County, Ohio 27086 1547 1755 1829 1755 1477 1604 1484 1623 1616 1655 1720 1970 1996 1586 1178 895 693 703          
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          
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          
189 189 8003 Alamosa County, Colorado 16683 1088 1208 1074 1716 1827 1262 1065 972 836 745 815 941 863 779 597 385 276 234          
190 190 18137 Ripley County, Indiana 28523 1686 1789 1983 1972 1730 1656 1482 1703 1648 1869 1946 2069 1905 1587 1330 900 611 657          
191 191 38057 Mercer County, North Dakota 8267 518 558 519 451 368 428 490 497 428 404 529 762 723 501 382 272 202 235          
192 192 13147 Hart County, Georgia 26099 1395 1456 1668 1478 1416 1597 1387 1413 1398 1683 1804 1851 1914 1662 1558 1113 723 583          
193 193 22049 Jackson Parish, Louisiana 15902 873 991 1012 909 911 1067 1064 948 927 948 988 1140 958 954 778 623 423 388          
194 194 51133 Northumberland County, Virginia 12147 413 515 497 513 474 524 428 498 441 477 769 1019 1123 1229 1256 944 527 500          
195 195 55047 Green Lake County, Wisconsin 18918 1096 1137 1211 1224 940 866 909 1029 958 1045 1241 1530 1531 1344 1081 768 505 503          
196 196 30073 Pondera County, Montana 5972 434 385 395 371 316 358 362 304 282 312 343 450 441 373 285 193 137 231          
197 197 32021 Mineral County, Nevada 4514 252 260 244 210 211 266 283 260 191 214 252 368 389 320 290 222 159 123          
198 198 38021 Dickey County, North Dakota 4903 323 307 363 360 318 240 242 268 244 254 277 336 369 258 229 195 132 188          
199 199 38003 Barnes County, North Dakota 10542 555 554 615 720 694 570 531 600 519 573 624 812 774 726 538 435 293 409          
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          

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