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 geo_display

✎ 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
2591 2591 45001 Abbeville County, South Carolina 24541 1151 1335 1515 1656 1550 1478 1180 1270 1274 1566 1639 1747 1837 1713 1437 956 646 591 24940 Outlying Abbeville County Greenville-Spartanburg-Anderson, SC South Carolina
3036 3036 22001 Acadia Parish, Louisiana 62190 4373 4410 4619 4115 3663 4443 3838 3977 3454 3577 3984 4272 3974 3132 2376 1692 1150 1141 29180 Outlying Acadia Parish Lafayette-Opelousas-Morgan City, LA Louisiana
806 806 51001 Accomack County, Virginia 32412 1810 1886 1857 1709 1411 1867 1750 1731 1591 1791 2101 2449 2821 2421 2030 1425 876 886          
2294 2294 16001 Ada County, Idaho 469966 27274 30425 34003 32409 28173 33646 33633 34897 31340 31244 28515 29299 27316 23749 18278 11517 7059 7189 14260 Central Ada County Boise City-Mountain Home-Ontario, ID-OR Idaho
285 285 19001 Adair County, Iowa 7063 384 422 438 407 337 381 406 404 346 367 439 593 536 470 335 265 218 315          
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          
2430 2430 29001 Adair County, Missouri 25339 1276 1207 1349 2869 4974 1455 1167 1190 971 1215 1238 1374 1299 1124 943 704 458 526 28860 Central Adair County   Missouri
15 15 40001 Adair County, Oklahoma 22082 1637 1557 1677 1522 1311 1446 1220 1309 1317 1376 1422 1518 1258 1149 937 683 407 336          
2021 2021 8001 Adams County, Colorado 511868 36180 37711 39279 35091 31852 41126 42569 40637 34887 33417 30002 30061 25469 19515 13908 8873 5829 5462 19740 Central Adams County Denver-Aurora, CO Colorado
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          
1755 1755 17001 Adams County, Illinois 65691 4145 4034 4135 3931 3662 3991 3986 3962 3490 3689 4120 4766 4490 3842 3020 2335 1742 2351 39500 Central Adams County Quincy-Hannibal, IL-MO Illinois
3032 3032 18001 Adams County, Indiana 35636 3327 3153 2943 2614 2126 2261 1885 1940 1879 1882 1974 2061 2067 1635 1342 929 714 904 19540 Central Adams County Fort Wayne-Huntington-Auburn, IN Indiana
1056 1056 19003 Adams County, Iowa 3645 212 215 222 195 152 203 195 200 169 192 219 344 286 246 201 171 108 115          
2891 2891 28001 Adams County, Mississippi 31192 1821 1619 1763 1660 1745 2136 2001 2137 1998 1745 1914 2414 2365 2010 1389 1024 712 739 35020 Central Adams County   Mississippi
1598 1598 31001 Adams County, Nebraska 31511 2085 2035 2069 2378 2351 1947 1773 1725 1702 1658 1800 2164 2088 1845 1363 1003 665 860 25580 Central Adams County   Nebraska
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          
279 279 39001 Adams County, Ohio 27724 1651 1777 1974 1821 1426 1630 1434 1521 1713 1886 1841 2075 2004 1652 1259 958 615 487          
2687 2687 42001 Adams County, Pennsylvania 102811 5121 5544 6139 6707 6596 5697 5506 5449 5363 6669 7570 7829 7667 6705 5353 3755 2460 2681 23900 Central Adams County Harrisburg-York-Lebanon, PA Pennsylvania
2847 2847 53001 Adams County, Washington 19759 1907 2136 1932 1616 1363 1247 1231 1135 1069 1029 959 974 976 755 581 371 236 242 36830 Central Adams County Moses Lake-Othello, WA Washington
653 653 55001 Adams County, Wisconsin 20348 693 768 924 871 805 952 1006 971 986 1099 1414 1893 2043 1942 1579 1200 683 519          
1220 1220 50001 Addison County, Vermont 36973 1572 1677 1823 2902 3347 1837 1933 2007 1944 2278 2561 2835 2900 2584 1970 1198 798 807          
1877 1877 45003 Aiken County, South Carolina 169401 9800 9956 10672 10285 9313 10962 10554 10196 9271 10191 11039 12197 12064 10607 8981 6158 3653 3502 12260 Central Aiken County   South Carolina
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          
2817 2817 12001 Alachua County, Florida 269956 14113 13902 13045 21562 42197 24072 18174 16084 13386 13232 13099 14630 14624 12921 9826 6451 4039 4599 23540 Central Alachua County Gainesville-Lake City, FL Florida
1365 1365 37001 Alamance County, North Carolina 166436 9632 10150 10645 12950 10920 10734 9991 9542 9564 11047 11344 11436 10354 8538 7273 5160 3476 3680 15500 Central Alamance County Greensboro--Winston-Salem--High Point, NC North Carolina
2516 2516 6001 Alameda County, California 1666753 96716 95425 95370 93570 99446 137553 141644 134126 117048 115151 107012 107380 95802 78175 58232 37876 25807 30420 41860 Central Alameda County San Jose-San Francisco-Oakland, CA California
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          
1673 1673 36001 Albany County, New York 307117 15326 15450 15482 22663 32432 21150 19583 18904 16359 17789 19468 20806 19632 17005 12764 8637 5900 7767 10580 Central Albany County Albany-Schenectady, NY New York
2652 2652 56001 Albany County, Wyoming 38601 1843 1761 1715 3216 8491 3794 2374 2178 1825 1580 1523 1797 1974 1736 1115 763 466 450 29660 Central Albany County   Wyoming
2452 2452 51003 Albemarle County, Virginia 108718 5712 5934 6078 9387 7438 7019 7050 6596 6041 6328 6536 7157 7194 6499 4955 3548 2380 2866 16820 Central Albemarle County   Virginia
231 231 26001 Alcona County, Michigan 10362 314 356 378 392 378 390 326 404 386 515 710 925 1175 1068 957 857 470 361          
1593 1593 28003 Alcorn County, Mississippi 36925 2113 2260 2498 2358 2177 2426 2149 2266 2206 2472 2374 2522 2291 2045 1917 1322 834 695 18420 Central Alcorn County   Mississippi
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          
2657 2657 17003 Alexander County, Illinois 6060 391 397 383 333 241 332 292 308 311 329 435 494 486 440 304 266 150 168 16020 Outlying Alexander County Cape Girardeau-Sikeston, MO-IL Illinois
1808 1808 37003 Alexander County, North Carolina 37353 1826 1996 2329 2068 2067 2412 1957 2235 2258 2653 2751 2731 2581 2334 2036 1474 910 735 25860 Outlying Alexander County Hickory-Lenoir, NC North Carolina
1487 1487 51510 Alexandria city, Virginia 160530 11469 7870 6362 5728 7604 15668 18889 16789 12689 11299 10088 9491 8119 6484 4973 2907 1819 2282 47900 Central Alexandria city Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Virginia
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          
94 94 26003 Alger County, Michigan 9097 333 354 394 449 483 505 513 537 487 492 608 767 840 803 595 422 273 242          
1302 1302 19005 Allamakee County, Iowa 13832 958 879 904 778 689 710 683 738 652 707 865 1050 1076 997 751 557 425 413          
2874 2874 26005 Allegan County, Michigan 117327 7283 7896 8315 7577 6490 7055 6923 7152 6763 7452 7979 8837 8191 6866 4947 3505 2092 2004 26090 Central Allegan County Grand Rapids-Wyoming-Muskegon, MI Michigan
1450 1450 24001 Allegany County, Maryland 70975 3208 3410 3465 4869 6028 4775 4404 4208 3907 4395 4510 4770 4626 4092 3687 2758 1932 1931 19060 Central Allegany County   Maryland
69 69 36003 Allegany County, New York 46430 2432 2569 2645 4418 4147 2284 2445 2385 2293 2524 2778 3328 3367 2922 2243 1523 1071 1056          
295 295 37005 Alleghany County, North Carolina 11161 518 493 574 534 527 564 480 542 569 699 755 910 973 925 813 548 386 351          
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          
2809 2809 42003 Allegheny County, Pennsylvania 1218452 63965 62136 62783 70765 75217 94658 92982 78363 65203 70659 75787 87021 88536 73823 53520 39079 27942 36013 38300 Central Allegheny County Pittsburgh-New Castle-Weirton, PA-OH-WV Pennsylvania
1415 1415 18003 Allen County, Indiana 375351 26135 26597 27232 25806 24399 27523 24583 24289 22021 23290 22321 23865 22572 18553 13910 9214 6033 7008 23060 Central Allen County Fort Wayne-Huntington-Auburn, IN Indiana
333 333 20001 Allen County, Kansas 12444 701 739 841 919 712 688 681 731 676 723 715 878 863 811 577 484 330 375          
1364 1364 21003 Allen County, Kentucky 21122 1253 1385 1365 1338 1096 1482 1207 1194 1254 1459 1472 1497 1395 1235 1022 708 442 318 14540 Outlying Allen County Bowling Green-Glasgow, KY Kentucky
1390 1390 39003 Allen County, Ohio 102663 6323 6420 6797 7206 6905 6944 5702 6173 5813 5901 6338 7085 6939 5927 4339 3109 2178 2564 30620 Central Allen County Lima-Van Wert-Celina, OH Ohio
992 992 22003 Allen Parish, Louisiana 25605 1518 1574 1601 1492 1569 2054 1980 1848 1700 1718 1630 1639 1438 1235 973 709 490 437          
985 985 45005 Allendale County, South Carolina 8903 416 455 482 515 576 691 573 516 475 623 618 562 611 615 529 277 182 187          
1408 1408 26007 Alpena County, Michigan 28360 1348 1409 1513 1564 1379 1586 1403 1604 1470 1628 1923 2400 2486 2044 1617 1236 853 897 10980 Central Alpena County   Michigan
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          
1117 1117 6005 Amador County, California 39383 1615 1587 1688 1672 1595 2165 2131 2365 2266 2488 2697 3140 3341 3492 2997 1871 1187 1086          
2527 2527 51007 Amelia County, Virginia 13013 647 740 788 752 668 754 728 702 681 816 953 1155 1053 798 691 508 290 289 40060 Outlying Amelia County   Virginia
1542 1542 51009 Amherst County, Virginia 31666 1641 1732 1798 1827 1837 1851 1733 1664 1652 2110 2305 2530 2285 2093 1696 1331 783 798 31340 Central Amherst County   Virginia
2349 2349 28005 Amite County, Mississippi 12326 671 695 725 685 608 661 602 617 607 677 771 1037 1074 922 710 564 355 345 32620 Outlying Amite County   Mississippi
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
1175 1175 20003 Anderson County, Kansas 7878 517 559 576 518 384 398 377 464 408 405 466 591 539 445 395 345 242 249          
2835 2835 21005 Anderson County, Kentucky 22663 1384 1442 1616 1407 1189 1435 1284 1380 1510 1692 1665 1699 1388 1232 926 630 408 376 23180 Outlying Anderson County Lexington-Fayette--Richmond--Frankfort, KY Kentucky
1958 1958 45007 Anderson County, South Carolina 200482 11892 12650 13318 12870 11617 12834 11721 11971 11783 13332 13353 14028 12928 11464 9769 6764 4406 3782 24860 Outlying Anderson County Greenville-Spartanburg-Anderson, SC South Carolina
2939 2939 47001 Anderson County, Tennessee 76482 4013 4418 4773 4381 4128 4943 4334 4421 4440 4993 5175 5632 5475 4869 3914 2613 1805 2155 28940 Central Anderson County Knoxville-Morristown-Sevierville, TN Tennessee
3094 3094 48001 Anderson County, Texas 58057 3016 3009 3140 3091 3410 4493 4836 4679 4599 4440 3896 3576 3281 2776 2246 1701 982 886 37300 Central Anderson County   Texas
1831 1831 29003 Andrew County, Missouri 17607 1001 1144 1190 1083 893 1038 975 1117 1051 1105 1156 1293 1308 1039 806 617 374 417 41140 Outlying Andrew County Kansas City-Overland Park-Kansas City, MO-KS Missouri
1874 1874 48003 Andrews County, Texas 18128 1569 1571 1533 1363 1148 1378 1301 1351 1069 1043 1010 1034 880 610 472 316 243 237 11380 Central Andrews County   Texas
1424 1424 23001 Androscoggin County, Maine 107679 6274 6749 6536 6495 6272 6609 6766 6724 5997 6953 7687 7972 7554 6213 4937 3223 2286 2432 30340 Central Androscoggin County Portland-Lewiston-South Portland, ME Maine
1499 1499 48005 Angelina County, Texas 87092 5951 6113 6508 5884 5380 5822 5352 5311 4987 5402 5375 5601 5188 4403 3659 2609 1818 1729 31260 Central Angelina County   Texas
1916 1916 24003 Anne Arundel County, Maryland 576031 35416 36164 35691 34142 36788 39898 41989 40843 35623 37749 40573 41285 35320 27612 22718 15491 9116 9613 12580 Central Anne Arundel County Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Maryland
2245 2245 27003 Anoka County, Minnesota 353813 22201 23033 24376 22278 19918 22328 24415 24985 22039 23771 25178 27350 22229 17387 13025 8757 5443 5100 33460 Central Anoka County Minneapolis-St. Paul, MN-WI Minnesota
571 571 37007 Anson County, North Carolina 24877 1276 1313 1388 1425 1585 1938 1626 1508 1510 1559 1727 1671 1757 1524 1190 839 529 512          
574 574 31003 Antelope County, Nebraska 6336 440 416 417 371 319 287 321 337 305 287 346 517 480 427 340 273 226 227          
288 288 26009 Antrim County, Michigan 23365 1076 1041 1305 1232 1079 1104 1065 1063 1038 1251 1589 1965 2215 2019 1664 1214 770 675          
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          
500 500 19007 Appanoose County, Iowa 12437 709 773 813 720 612 648 611 702 628 699 793 903 1003 824 717 515 346 421          
810 810 13001 Appling County, Georgia 18507 1255 1279 1302 1159 1105 1160 1037 1108 1098 1134 1178 1255 1248 1038 858 587 379 327          
2734 2734 51011 Appomattox County, Virginia 15841 924 934 927 912 830 969 940 948 840 1007 1012 1170 1148 981 890 679 387 343 31340 Outlying Appomattox County   Virginia
1736 1736 48007 Aransas County, Texas 23792 1141 1116 1196 1161 1109 1108 1075 1141 1068 1318 1424 1929 1957 2018 1925 1544 860 702 18580 Outlying Aransas County Corpus Christi-Kingsville-Alice, TX Texas
3010 3010 8005 Arapahoe County, Colorado 651215 40524 42191 44306 40285 38857 51593 51156 49261 44124 44501 40082 41378 37892 30905 22384 13862 8602 9312 19740 Central Arapahoe County Denver-Aurora, CO Colorado
2493 2493 48009 Archer County, Texas 8786 461 485 613 544 450 441 487 488 491 541 608 715 704 532 424 344 247 211 48660 Outlying Archer County   Texas
619 619 8007 Archuleta County, Colorado 13765 642 683 742 649 551 605 677 778 712 758 873 1184 1326 1422 1048 575 282 258          
909 909 26011 Arenac County, Michigan 15041 721 704 808 757 696 791 692 791 720 848 970 1366 1430 1280 948 699 439 381          
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          
2195 2195 51013 Arlington County, Virginia 237521 14285 12023 10976 9027 16215 30020 27129 22185 17356 15989 13734 12552 10821 8785 6616 4180 2546 3082 47900 Central Arlington County Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Virginia
3110 3110 42005 Armstrong County, Pennsylvania 65263 3180 3510 3667 3365 3276 3598 3399 3605 3651 4272 4583 5411 5408 4543 3464 2579 1807 1945 38300 Outlying Armstrong County Pittsburgh-New Castle-Weirton, PA-OH-WV Pennsylvania
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
1258 1258 23003 Aroostook County, Maine 67111 3234 3245 3468 3793 3524 3335 3200 3414 3569 4131 4818 5450 5734 5116 4074 2846 2051 2109          
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          
3033 3033 22005 Ascension Parish, Louisiana 124672 8851 9249 9642 8564 7074 8394 8985 9397 8200 8647 8312 7831 6792 5327 3946 2739 1448 1274 12940 Central Ascension Parish   Louisiana
1241 1241 37009 Ashe County, North Carolina 27109 1106 1359 1442 1370 1211 1373 1298 1473 1532 1720 1860 2153 2245 2203 1868 1306 854 736          
2055 2055 39005 Ashland County, Ohio 53745 3108 3290 3490 4102 3975 3058 2907 2985 2826 3174 3345 3632 3797 3155 2441 1914 1238 1308 11740 Central Ashland County Mansfield-Ashland-Bucyrus, OH Ohio
323 323 55003 Ashland County, Wisconsin 15600 880 906 1021 1083 1011 796 832 932 821 822 974 1244 1223 1078 753 506 348 370          
712 712 5003 Ashley County, Arkansas 20046 1226 1295 1251 1242 1078 1241 1007 1096 1137 1326 1298 1467 1301 1262 1105 808 531 375          
2082 2082 39007 Ashtabula County, Ohio 97493 5562 5843 6281 5892 5337 5965 5352 5523 5380 6360 6778 7265 7366 6068 4658 3406 2180 2277 11780 Central Ashtabula County Cleveland-Akron-Canton, OH Ohio
2368 2368 53003 Asotin County, Washington 22610 1165 1259 1344 1236 1031 1333 1284 1303 1236 1256 1337 1690 1864 1575 1316 1033 695 653 30300 Central Asotin County   Washington
701 701 22007 Assumption Parish, Louisiana 22300 1249 1259 1420 1351 1309 1525 1297 1355 1260 1407 1577 1696 1575 1336 1029 752 429 474          
2664 2664 48013 Atascosa County, Texas 50310 3671 3841 3904 3654 3159 3230 3255 3334 2980 3093 2905 3124 2775 2388 1950 1355 863 829 41700 Outlying Atascosa County   Texas
1873 1873 20005 Atchison County, Kansas 16193 969 982 1171 1471 1414 836 869 929 803 887 983 1040 1060 804 673 527 387 388 11860 Central Atchison County Kansas City-Overland Park-Kansas City, MO-KS Kansas
202 202 29005 Atchison County, Missouri 5171 251 299 291 277 222 295 234 278 280 317 351 373 388 341 368 268 140 198          
2561 2561 39009 Athens County, Ohio 65818 2545 2548 2708 8430 11915 4531 3735 3610 3095 3331 3360 3685 3654 3166 2194 1471 952 888 11900 Central Athens County   Ohio

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