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 statecountyfips

✎ 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
2090 2090 1001 Autauga County, Alabama 55601 3364 3423 3882 3755 3173 3705 3461 3628 3616 3966 3811 3927 3237 2589 2311 1739 1143 871 33860 Central Autauga County   Alabama
2043 2043 1003 Baldwin County, Alabama 218022 11955 12802 13981 12932 11108 12471 12057 13156 12877 14461 14242 15744 15665 14267 12471 8465 5064 4304 19300 Central Baldwin County Mobile-Daphne-Fairhope, AL Alabama
718 718 1005 Barbour County, Alabama 24881 1284 1448 1509 1451 1472 1796 1670 1531 1450 1624 1603 1675 1536 1540 1337 907 576 472          
3015 3015 1007 Bibb County, Alabama 22400 1285 1171 1326 1270 1303 1726 1601 1512 1440 1598 1581 1534 1363 1182 992 731 422 363 13820 Outlying Bibb County Birmingham-Hoover-Talladega, AL Alabama
1818 1818 1009 Blount County, Alabama 57840 3460 3635 3902 3668 3178 3564 3370 3514 3553 3921 3897 3947 3683 3282 2961 1970 1303 1032 13820 Outlying Blount County Birmingham-Hoover-Talladega, AL Alabama
530 530 1011 Bullock County, Alabama 10138 600 598 601 529 626 769 757 689 620 654 604 752 678 541 407 296 233 184          
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          
2578 2578 1015 Calhoun County, Alabama 114277 6580 6561 7146 7491 7286 8177 6882 6983 6663 7064 7239 8086 7872 6769 5307 3672 2388 2111 11500 Central Calhoun County   Alabama
1603 1603 1017 Chambers County, Alabama 33615 1929 1940 1926 1886 2007 2373 1858 1876 1899 2179 2230 2531 2419 2073 1767 1205 768 749 46740 Central Chambers County Columbus-Auburn-Opelika, GA-AL Alabama
3 3 1019 Cherokee County, Alabama 26032 1206 1348 1482 1499 1304 1548 1206 1298 1471 1733 1857 2016 2084 1862 1683 1152 747 536          
3076 3076 1021 Chilton County, Alabama 44153 2730 2922 2971 2847 2549 3017 2554 2679 2776 2879 2934 2998 2886 2473 1988 1346 835 769 13820 Outlying Chilton County Birmingham-Hoover-Talladega, AL Alabama
585 585 1023 Choctaw County, Alabama 12841 673 651 740 749 694 708 596 693 689 789 894 1053 959 865 803 568 364 353          
838 838 1025 Clarke County, Alabama 23920 1386 1318 1471 1574 1433 1478 1150 1407 1381 1490 1630 1789 1660 1336 1261 959 605 592          
2 2 1027 Clay County, Alabama 13275 687 733 769 795 780 763 683 772 734 870 979 1012 947 852 673 541 373 312          
732 732 1029 Cleburne County, Alabama 14987 894 935 987 918 744 943 807 858 894 1036 1040 1073 943 908 784 574 310 339          
3082 3082 1031 Coffee County, Alabama 51909 3211 3394 3498 3330 2985 3327 3270 3316 3344 3552 3373 3289 3219 2739 2439 1524 1129 970 21460 Central Coffee County Dothan-Enterprise-Ozark, AL Alabama
1478 1478 1033 Colbert County, Alabama 54762 3108 3140 3199 3119 3113 3698 3239 3185 3136 3530 3636 3872 3873 3417 2718 2129 1364 1286 22520 Central Colbert County   Alabama
1045 1045 1035 Conecuh County, Alabama 12277 652 715 726 708 687 723 634 626 639 696 792 962 955 771 782 526 358 325          
1887 1887 1037 Coosa County, Alabama 10715 488 440 519 504 557 608 492 536 598 781 783 967 961 785 662 475 289 270 45180 Outlying Coosa County Birmingham-Hoover-Talladega, AL Alabama
1285 1285 1039 Covington County, Alabama 36986 2203 2235 2293 2104 1862 2325 2017 2077 1952 2226 2403 2738 2761 2276 2050 1458 1027 979          
875 875 1041 Crenshaw County, Alabama 13824 798 884 914 850 757 892 749 808 777 871 896 1017 982 846 759 422 299 303          
2172 2172 1043 Cullman County, Alabama 83442 5162 5114 5220 5036 4599 5790 4980 4946 5077 5258 5442 5792 5580 4872 4205 3016 1903 1450 18980 Central Cullman County Birmingham-Hoover-Talladega, AL Alabama
2422 2422 1045 Dale County, Alabama 48956 3268 3118 2984 2934 3189 3824 3373 2939 2734 2954 2949 3273 3147 2603 2175 1577 1017 898 37120 Central Dale County Dothan-Enterprise-Ozark, AL Alabama
2205 2205 1047 Dallas County, Alabama 38310 2335 2432 2703 2642 2369 2384 2099 2199 2047 2107 2415 2844 2813 2299 1839 1220 862 701 42820 Central Dallas County   Alabama
1 1 1049 DeKalb County, Alabama 71385 4237 4692 5213 4796 4058 4542 3963 4256 4505 4839 4642 4755 4565 4030 3345 2279 1461 1207          
2982 2982 1051 Elmore County, Alabama 81887 4713 4922 5264 5095 5054 6089 5478 5529 5302 5701 5571 5631 5138 4113 3432 2326 1365 1164 33860 Central Elmore County   Alabama
332 332 1053 Escambia County, Alabama 36748 2187 2339 2284 2143 2076 2681 2291 2315 2259 2436 2340 2523 2278 2041 1745 1309 818 683          
3054 3054 1055 Etowah County, Alabama 102501 5902 5934 6122 6321 6120 6708 5711 6141 6146 7161 6713 7013 7022 6424 5207 3605 2268 1983 23460 Central Etowah County   Alabama
205 205 1057 Fayette County, Alabama 16433 921 957 1002 941 951 1015 871 906 906 1088 1039 1196 1168 1090 897 698 447 340          
1016 1016 1059 Franklin County, Alabama 31363 2084 2098 2187 2028 1827 2094 1793 1861 2017 2124 2031 2010 1913 1641 1364 1025 701 565          
2389 2389 1061 Geneva County, Alabama 26314 1422 1559 1701 1635 1322 1537 1437 1516 1511 1738 1820 1807 1968 1675 1421 993 674 578 20020 Outlying Geneva County Dothan-Enterprise-Ozark, AL Alabama
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          
4 4 1065 Hale County, Alabama 14726 979 909 956 910 933 951 783 840 795 806 916 1106 1013 923 715 486 355 350 46220 Outlying Hale County   Alabama
3124 3124 1067 Henry County, Alabama 17209 915 926 1060 990 851 961 891 1023 1028 1129 1135 1112 1278 1290 1072 662 463 423 20020 Outlying Henry County Dothan-Enterprise-Ozark, AL Alabama
2500 2500 1069 Houston County, Alabama 104722 6350 6528 6887 6606 5834 6980 6668 6634 6244 6732 6752 7167 6701 5936 4985 3373 2308 2037 20020 Central Houston County Dothan-Enterprise-Ozark, AL Alabama
2008 2008 1071 Jackson County, Alabama 51736 2776 2856 3151 3107 2745 3219 2645 2991 3208 3518 3442 3763 3942 3266 2814 2044 1292 957 42460 Central Jackson County Chattanooga-Cleveland-Dalton, TN-GA-AL Alabama
2995 2995 1073 Jefferson County, Alabama 659300 41882 41984 41913 40910 41674 50181 45744 43846 39621 40600 39767 44002 42629 35993 25592 17412 12107 13443 13820 Central Jefferson County Birmingham-Hoover-Talladega, AL Alabama
1004 1004 1075 Lamar County, Alabama 13844 743 755 916 829 707 756 740 731 835 928 884 1019 1003 848 800 598 426 326          
2322 2322 1077 Lauderdale County, Alabama 92387 4734 4836 5325 6016 7668 5905 5102 5112 4815 5738 5919 6260 6394 5746 4849 3561 2312 2095 22520 Central Lauderdale County   Alabama
2643 2643 1079 Lawrence County, Alabama 32957 1810 1957 2106 1912 1780 2136 1829 1817 1882 2263 2442 2572 2300 1961 1705 1225 702 558 19460 Outlying Lawrence County Huntsville-Decatur-Albertville, AL Alabama
1581 1581 1081 Lee County, Alabama 163941 9629 9551 10043 13355 21876 12706 10547 10381 9361 10004 9324 9428 8255 6850 5310 3409 2111 1801 12220 Central Lee County Columbus-Auburn-Opelika, GA-AL Alabama
1794 1794 1083 Limestone County, Alabama 96174 5393 5968 6388 6007 5183 6187 6352 6652 6428 6969 7112 7031 5896 4845 3977 2693 1702 1391 26620 Outlying Limestone County Huntsville-Decatur-Albertville, AL Alabama
1855 1855 1085 Lowndes County, Alabama 9974 614 662 606 558 575 711 533 561 503 580 690 769 732 579 490 376 220 215 33860 Outlying Lowndes County   Alabama
551 551 1087 Macon County, Alabama 18439 855 839 838 1669 2195 1242 837 834 823 958 1100 1255 1238 1303 969 646 413 425          
2530 2530 1089 Madison County, Alabama 366519 21403 21675 22960 23962 24647 26312 24897 23465 21173 23274 26096 28379 23151 17730 14047 10104 7021 6223 26620 Central Madison County Huntsville-Decatur-Albertville, AL Alabama
17 17 1091 Marengo County, Alabama 19066 1209 1155 1228 1152 1106 1226 1070 1005 1078 1182 1239 1332 1347 1128 950 693 456 510          
399 399 1093 Marion County, Alabama 29763 1597 1635 1790 1792 1580 1796 1596 1677 1666 2042 2083 2192 1996 1838 1647 1260 875 701          
1765 1765 1095 Marshall County, Alabama 96109 6769 6433 6853 6072 5490 6270 5701 5714 5528 6222 6103 6515 6064 5087 4343 3282 1984 1679 10700 Central Marshall County Huntsville-Decatur-Albertville, AL Alabama
1601 1601 1097 Mobile County, Alabama 413757 26937 26470 26929 26632 26777 30611 27297 25747 23781 24821 25702 28165 26847 22367 17711 11974 7751 7238 33660 Central Mobile County Mobile-Daphne-Fairhope, AL Alabama
378 378 1099 Monroe County, Alabama 21067 1105 1193 1390 1386 1240 1254 1010 1131 1178 1328 1447 1572 1558 1331 1056 837 484 567          
3009 3009 1101 Montgomery County, Alabama 225763 15223 14511 14478 14843 15908 17384 15399 14904 13179 13806 13491 14565 13899 11719 8473 5868 4101 4012 33860 Central Montgomery County   Alabama
2706 2706 1103 Morgan County, Alabama 119089 7124 7407 7864 7414 6792 7577 6973 7326 7122 7883 8476 8480 7848 6678 5403 3973 2559 2190 19460 Central Morgan County Huntsville-Decatur-Albertville, AL Alabama
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          
2299 2299 1107 Pickens County, Alabama 19938 1056 1051 1061 1200 1215 1387 1306 1218 1058 1313 1411 1512 1357 1211 929 742 481 430 46220 Outlying Pickens County   Alabama
1925 1925 1109 Pike County, Alabama 33338 1788 1792 1725 2929 5640 2494 1584 1752 1560 1718 1651 1870 1848 1502 1375 904 641 565 45980 Central Pike County   Alabama
1240 1240 1111 Randolph County, Alabama 22725 1314 1316 1372 1492 1308 1347 1105 1212 1234 1438 1604 1675 1683 1443 1215 894 582 491          
2740 2740 1113 Russell County, Alabama 57781 3972 4017 3768 3496 3504 4759 4029 3773 3450 3582 3756 3874 3521 2811 2188 1468 920 893 17980 Central Russell County Columbus-Auburn-Opelika, GA-AL Alabama
2129 2129 1115 St. Clair County, Alabama 88690 5289 5596 5889 5107 4520 5914 5912 5740 5561 6287 5967 6397 5773 4937 4007 2805 1688 1301 13820 Outlying St. Clair County Birmingham-Hoover-Talladega, AL Alabama
2174 2174 1117 Shelby County, Alabama 215707 12461 13708 15182 14435 12533 12873 13290 14875 14686 15967 14622 14685 13303 11496 8784 5813 3578 3416 13820 Central Shelby County Birmingham-Hoover-Talladega, AL Alabama
439 439 1119 Sumter County, Alabama 12691 728 615 662 1057 1821 842 527 517 536 660 660 880 900 770 492 388 276 360          
1949 1949 1121 Talladega County, Alabama 79828 4281 4506 4972 5046 4750 5517 4744 4854 4622 5508 5366 5638 5654 4771 3893 2674 1675 1357 45180 Central Talladega County Birmingham-Hoover-Talladega, AL Alabama
820 820 1123 Tallapoosa County, Alabama 40497 2235 2338 2395 2232 2241 2568 2056 2063 2074 2568 2817 2976 3203 2845 2366 1673 1033 814          
1658 1658 1125 Tuscaloosa County, Alabama 208911 12541 12229 11798 17404 24032 17392 13406 13264 11791 12104 11296 11966 11945 9930 6975 4671 3014 3153 46220 Central Tuscaloosa County   Alabama
2998 2998 1127 Walker County, Alabama 63711 3832 3945 3913 3751 3614 4126 3418 3606 3719 4239 4238 4549 4450 3942 3348 2364 1590 1067 13820 Outlying Walker County Birmingham-Hoover-Talladega, AL Alabama
863 863 1129 Washington County, Alabama 16378 873 928 1086 1106 956 1003 818 933 892 1119 1129 1229 1176 1004 844 574 383 325          
246 246 1131 Wilcox County, Alabama 10627 679 635 707 803 684 633 526 597 557 632 647 692 769 657 565 322 273 249          
440 440 1133 Winston County, Alabama 23660 1289 1234 1408 1394 1273 1276 1197 1292 1330 1623 1713 1832 1698 1522 1415 1002 609 553          
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          
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          
1696 1696 2020 Anchorage Municipality, Alaska 291538 20944 19897 19192 17997 21962 26281 24242 21222 17038 17686 17357 18641 16746 12491 8669 5116 3050 3007 11260 Central Anchorage Municipality   Alaska
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          
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          
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          
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          
2162 2162 2090 Fairbanks North Star Borough, Alaska 98971 7506 6888 6125 5947 10451 10079 8408 6993 5392 5043 5092 5571 5272 4264 2850 1584 810 696 21820 Central Fairbanks North Star Borough   Alaska
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          
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          
1791 1791 2110 Juneau City and Borough, Alaska 32113 1843 1888 1893 1964 2000 2374 2478 2375 2051 2144 2153 2427 2225 1776 1205 638 351 328 27940 Central Juneau City and Borough   Alaska
499 499 2122 Kenai Peninsula Borough, Alaska 58533 3552 3733 3712 3450 3156 3775 3615 3670 3251 3469 3654 4532 4776 4137 2744 1722 895 690          
1361 1361 2130 Ketchikan Gateway Borough, Alaska 13918 819 876 845 864 791 996 944 984 787 855 873 1085 1037 814 588 366 186 208 28540 Central Ketchikan Gateway Borough   Alaska
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          
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          
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          
2394 2394 2170 Matanuska-Susitna Borough, Alaska 107610 7681 8033 8418 7213 6198 7632 7790 7712 6721 6563 6561 7442 6832 5377 3389 2144 1042 862 11260 Outlying Matanuska-Susitna Borough   Alaska
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
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          
1048 1048 4001 Apache County, Arizona 71818 4799 5457 5890 5489 4695 4998 4392 3964 3762 3833 4296 4825 4432 3645 2827 2060 1299 1155          
1963 1963 4003 Cochise County, Arizona 126770 7409 7485 7819 8261 7627 8270 7534 7562 6334 6339 7047 8175 8582 8605 7547 5639 3566 2969 43420 Central Cochise County   Arizona
2080 2080 4005 Coconino County, Arizona 142854 7882 8177 8470 13964 19620 11401 8885 8393 7380 7167 7268 8269 8123 6714 4680 3090 1737 1634 22380 Central Coconino County   Arizona
2310 2310 4007 Gila County, Arizona 53889 3034 3083 2957 2754 2440 2757 2563 2535 2130 2542 3071 3908 4609 4677 4284 3081 1874 1590 37740 Central Gila County   Arizona

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