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)

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
492 492 13003 Atkinson County, Georgia 8297 598 604 605 574 549 581 513 495 531 554 517 540 469 403 305 241 130 88          
3111 3111 34001 Atlantic County, New Jersey 265429 14367 15688 16247 16771 17168 16641 15278 14877 14645 17307 18953 20604 19272 15106 12276 8684 5638 5907 12100 Central Atlantic County Philadelphia-Reading-Camden, PA-NJ-DE-MD New Jersey
365 365 40005 Atoka County, Oklahoma 13838 832 884 881 803 752 952 877 849 780 830 814 923 915 828 743 538 357 280          
655 655 28007 Attala County, Mississippi 18365 1164 1298 1411 1178 1051 1099 976 1025 1010 1114 1136 1154 1228 1047 888 655 474 457          
2484 2484 29007 Audrain County, Missouri 25473 1610 1488 1576 1661 1530 1688 1611 1663 1555 1555 1541 1752 1691 1466 1119 835 577 555 33020 Central Audrain County Columbia-Moberly-Mexico, MO Missouri
786 786 19009 Audubon County, Iowa 5506 333 298 310 288 280 279 249 277 259 281 347 499 444 363 295 249 188 267          
2648 2648 39011 Auglaize County, Ohio 45804 2926 3032 3164 2936 2595 2709 2522 2675 2532 2767 2994 3329 3197 2700 1994 1421 1105 1206 47540 Central Auglaize County Lima-Van Wert-Celina, OH Ohio
2308 2308 51015 Augusta County, Virginia 75457 3455 3820 4383 4272 4086 4563 4243 4420 4235 5114 5438 5946 5605 4907 4176 3088 1933 1773 44420 Central Augusta County Harrisonburg-Staunton-Waynesboro, VA Virginia
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          
2798 2798 48015 Austin County, Texas 29989 1768 2041 2065 1989 1660 1748 1647 1662 1677 1749 1917 2104 2263 1836 1529 1114 601 619 26420 Outlying Austin County Houston-The Woodlands, TX Texas
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
418 418 37011 Avery County, North Carolina 17505 653 702 772 994 1151 1135 1050 1078 1134 1284 1177 1262 1222 1230 1033 741 455 432          
628 628 22009 Avoyelles Parish, Louisiana 40462 2691 2657 2629 2500 2366 2906 2635 2643 2374 2367 2606 2705 2533 2201 1712 1186 921 830          
1189 1189 8009 Baca County, Colorado 3585 196 238 239 193 188 186 184 192 171 170 195 263 284 236 204 150 128 168          
1174 1174 13005 Bacon County, Georgia 11185 732 784 843 734 700 723 661 677 777 713 682 637 728 636 464 311 228 155          
953 953 48017 Bailey County, Texas 7027 577 574 669 602 439 384 422 397 451 340 370 400 377 313 232 190 158 132          
2576 2576 12003 Baker County, Florida 28355 1778 1845 1931 1831 1655 2247 2020 1892 1770 1971 1877 1880 1643 1379 1040 738 486 372 27260 Outlying Baker County Jacksonville-St. Marys-Palatka, FL-GA Florida
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
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          
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
3079 3079 13009 Baldwin County, Georgia 44823 2125 2320 2544 4238 5416 2917 2383 2490 2265 2465 2725 2947 2811 2423 1924 1269 826 735 33300 Central Baldwin County   Georgia
2492 2492 21007 Ballard County, Kentucky 7979 396 482 503 512 404 431 433 446 478 546 516 552 610 522 428 303 216 201 37140 Outlying Ballard County Paducah-Mayfield, KY-IL Kentucky
1690 1690 24005 Baltimore County, Maryland 828431 48780 49363 50734 52490 50138 57159 56872 53524 47684 51056 54483 58482 55356 45050 34359 23611 16723 22567 12580 Central Baltimore County Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Maryland
1433 1433 24510 Baltimore city, Maryland 602495 37992 34379 32589 34709 40785 60669 54814 42670 32944 33248 36781 40008 36520 29680 20556 14128 9361 10662 12580 Central Baltimore city Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Maryland
292 292 45009 Bamberg County, South Carolina 14275 654 749 776 1198 1137 803 661 651 736 801 942 996 1074 1025 772 536 345 419          
1457 1457 48019 Bandera County, Texas 22824 949 1043 1138 1066 1001 957 1045 1087 1055 1308 1584 2196 2238 2098 1733 1156 627 543 41700 Outlying Bandera County   Texas
694 694 13011 Banks County, Georgia 18988 1119 1068 1232 1274 1056 1163 1087 1153 1216 1315 1392 1322 1270 1082 1001 647 349 242          
1492 1492 31007 Banner County, Nebraska 730 49 51 43 39 38 41 29 50 24 25 41 60 66 63 51 25 18 17 42420 Outlying Banner County   Nebraska
2667 2667 16005 Bannock County, Idaho 87138 6205 6245 6497 6668 6248 6748 6165 6038 5049 4577 4248 4956 5094 4340 3280 2094 1370 1316 38540 Central Bannock County   Idaho
216 216 26013 Baraga County, Michigan 8320 328 405 451 457 492 514 477 503 462 542 579 626 644 620 444 360 203 213          
791 791 20007 Barber County, Kansas 4472 273 303 280 243 194 236 255 258 182 219 238 371 393 321 285 183 92 146          
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          
481 481 54001 Barbour County, West Virginia 16535 824 878 984 1187 1282 943 869 885 953 1022 1026 1218 1131 1067 855 654 392 365          
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          
1556 1556 25001 Barnstable County, Massachusetts 213413 7852 8426 9599 10302 10880 9918 9170 9639 8951 11443 14367 18134 19433 19676 17400 11906 7677 8640 12700 Central Barnstable County Boston-Worcester-Providence, MA-RI-NH-CT Massachusetts
1270 1270 45011 Barnwell County, South Carolina 21112 1278 1416 1470 1370 1237 1378 1061 1178 1124 1266 1410 1546 1505 1283 1085 684 378 443          
2863 2863 21009 Barren County, Kentucky 44176 2905 2746 2986 2680 2455 2786 2547 2768 2619 2852 2948 3166 2900 2477 1961 1478 951 951 23980 Central Barren County Bowling Green-Glasgow, KY Kentucky
706 706 55005 Barron County, Wisconsin 45164 2462 2739 2857 2566 2264 2442 2393 2676 2328 2684 2809 3615 3421 3086 2573 1793 1213 1243          
1588 1588 13013 Barrow County, Georgia 80809 5433 5903 6188 5215 4695 5838 5981 6053 5318 5603 5190 4971 4363 3510 2847 1757 1001 943 12060 Outlying Barrow County Atlanta--Athens-Clarke County--Sandy Springs, GA Georgia
1711 1711 26015 Barry County, Michigan 61157 3380 3692 4010 3877 3357 3490 3440 3582 3420 3831 4269 4954 4601 3768 2984 2073 1262 1167 24340 Outlying Barry County Grand Rapids-Wyoming-Muskegon, MI Michigan
671 671 29009 Barry County, Missouri 35886 2173 2230 2358 2124 1952 2145 1833 1909 1888 2169 2312 2733 2672 2302 1945 1452 908 781          
1635 1635 18005 Bartholomew County, Indiana 82753 5448 5489 5534 4931 4976 6495 5496 5247 5014 5310 5097 5260 4969 4340 3423 2530 1568 1626 18020 Central Bartholomew County Indianapolis-Carmel-Muncie, IN Indiana
1939 1939 20009 Barton County, Kansas 26111 1633 1761 1761 1730 1544 1543 1549 1573 1261 1273 1495 1980 1990 1551 1105 853 658 851 24460 Central Barton County   Kansas
19 19 29011 Barton County, Missouri 11798 674 705 846 800 672 685 553 724 604 653 722 859 878 711 599 469 297 347          
1824 1824 13015 Bartow County, Georgia 106408 6886 6821 7421 6957 6459 7582 6903 6741 6606 7577 7636 7425 6478 5048 4289 2659 1543 1377 12060 Outlying Bartow County Atlanta--Athens-Clarke County--Sandy Springs, GA Georgia
2607 2607 48021 Bastrop County, Texas 86976 5922 5812 6498 6098 5075 5245 5315 5317 5203 5494 5657 6203 5926 4864 3666 2129 1374 1178 12420 Outlying Bastrop County   Texas
3120 3120 29013 Bates County, Missouri 16320 958 992 1151 1044 915 905 920 978 902 931 1044 1276 1140 965 711 639 469 380 28140 Outlying Bates County Kansas City-Overland Park-Kansas City, MO-KS Missouri
3093 3093 21011 Bath County, Kentucky 12383 828 846 914 806 707 738 605 733 763 835 866 853 809 703 533 363 255 226 34460 Outlying Bath County Lexington-Fayette--Richmond--Frankfort, KY Kentucky
616 616 51017 Bath County, Virginia 4292 189 182 165 187 204 236 212 195 208 272 340 367 348 328 344 241 127 147          
2254 2254 5005 Baxter County, Arkansas 41619 1921 1933 2229 1978 1748 2009 1905 2006 1825 2221 2440 3185 3359 3441 3318 2760 1742 1599 34260 Central Baxter County   Arkansas
2321 2321 12005 Bay County, Florida 185287 11333 11233 10920 9920 10927 13877 12840 11878 10503 11498 12294 13879 12507 10189 8218 5683 3785 3803 37460 Central Bay County   Florida
2604 2604 26017 Bay County, Michigan 103923 5245 5603 6303 6023 5846 6847 5900 6082 5774 6302 6923 8004 7876 6811 5249 3826 2518 2791 13020 Central Bay County Saginaw-Midland-Bay City, MI Michigan
419 419 55007 Bayfield County, Wisconsin 15042 677 666 750 764 613 587 651 694 708 823 1075 1295 1570 1448 1130 752 444 395          
829 829 48023 Baylor County, Texas 3582 212 242 234 205 161 201 177 211 183 192 220 234 257 229 183 182 119 140          
2171 2171 46005 Beadle County, South Dakota 18883 1659 1423 1285 1241 1035 1090 1204 1147 1008 985 1019 1362 1216 1010 689 528 430 552 26700 Central Beadle County   South Dakota
1191 1191 16007 Bear Lake County, Idaho 6050 405 472 442 444 282 298 344 338 334 305 308 399 431 394 336 213 155 150          
1606 1606 37013 Beaufort County, North Carolina 47079 2277 2574 2811 2809 2344 2509 2226 2454 2647 2901 3012 3526 3708 3639 3132 2120 1224 1166 47820 Central Beaufort County Greenville-Washington, NC North Carolina
1995 1995 45013 Beaufort County, South Carolina 188715 9662 9658 10015 10776 11967 11039 9775 9656 9188 9650 10085 12050 13752 15611 15012 10282 5693 4844 25940 Central Beaufort County   South Carolina
3089 3089 22011 Beauregard Parish, Louisiana 37253 2517 2535 2544 2439 2271 2634 2446 2368 2336 2338 2262 2466 2226 1983 1543 1062 709 574 19760 Central Beauregard Parish DeRidder-Fort Polk South, LA Louisiana
946 946 40007 Beaver County, Oklahoma 5319 310 375 427 410 233 289 269 316 270 326 331 374 340 300 269 186 144 150          
27 27 42007 Beaver County, Pennsylvania 164742 8362 8858 9205 8827 8785 9716 9526 9834 8764 9734 11276 13353 13090 11067 8423 6157 4611 5154 38300 Central Beaver County Pittsburgh-New Castle-Weirton, PA-OH-WV Pennsylvania
886 886 49001 Beaver County, Utah 6580 574 581 626 529 378 375 373 426 383 328 284 365 410 339 225 185 121 78          
1337 1337 30001 Beaverhead County, Montana 9404 437 422 433 746 971 545 461 483 480 444 501 653 758 623 541 421 248 237          
322 322 27005 Becker County, Minnesota 34371 2133 2330 2481 2165 1786 1758 1804 2030 1858 1745 2048 2485 2696 2378 1790 1224 848 812          
2362 2362 40009 Beckham County, Oklahoma 21709 1485 1537 1498 1263 1426 1744 1650 1546 1294 1259 1221 1365 1307 1057 708 508 421 420 21120 Central Beckham County   Oklahoma
349 349 42009 Bedford County, Pennsylvania 48176 2425 2463 2691 2773 2428 2679 2309 2498 2621 3234 3444 3864 3729 3174 2703 2197 1437 1507          
1558 1558 47003 Bedford County, Tennessee 49038 3284 3417 3628 3235 2929 3509 3025 3072 3037 3303 3174 3227 2801 2439 2059 1382 844 673 43180 Central Bedford County Nashville-Davidson--Murfreesboro, TN Tennessee
2050 2050 51019 Bedford County, Virginia 78747 3605 4333 4630 4622 4158 4215 3825 3983 4218 5462 5890 6595 6422 5468 4546 3201 1895 1679 31340 Central Bedford County   Virginia
2829 2829 48025 Bee County, Texas 32587 1895 1868 1956 2124 2704 2919 2769 2688 2256 2180 1889 1771 1556 1264 1059 716 530 443 13300 Central Bee County   Texas
3121 3121 33001 Belknap County, New Hampshire 61022 2707 3019 3421 3242 3059 3319 3204 3388 3265 3771 4421 5386 5315 4504 3645 2320 1383 1653 29060 Central Belknap County Boston-Worcester-Providence, MA-RI-NH-CT New Hampshire
2355 2355 21013 Bell County, Kentucky 26569 1565 1542 1571 1516 1574 1762 1523 1475 1561 1777 1811 1939 1848 1668 1344 968 565 560 33180 Central Bell County   Kentucky
1440 1440 48027 Bell County, Texas 355642 30043 27667 26126 24702 30052 31798 27481 25400 20889 19568 18490 18501 16340 13048 10224 6729 4248 4336 28660 Central Bell County   Texas
2725 2725 39013 Belmont County, Ohio 67505 3242 3579 3627 3544 3808 4463 4071 4052 3831 4289 4352 5220 5355 4639 3411 2312 1736 1974 48540 Central Belmont County   Ohio
1841 1841 27007 Beltrami County, Minnesota 46847 3318 3507 3198 3574 4447 3055 2797 2791 2259 2226 2405 2901 2821 2499 1811 1288 912 1038 13420 Central Beltrami County   Minnesota
2575 2575 13017 Ben Hill County, Georgia 16787 1074 1160 1230 1071 961 1022 1022 993 940 1029 1084 1094 1168 967 789 550 335 298 22340 Central Ben Hill County   Georgia
289 289 16009 Benewah County, Idaho 9226 526 601 597 529 412 462 436 468 473 494 622 702 831 698 579 413 225 158          
650 650 46007 Bennett County, South Dakota 3468 336 358 316 262 249 217 228 177 142 167 196 220 167 146 90 61 85 51          
2670 2670 50003 Bennington County, Vermont 35631 1670 1800 2013 2288 2237 1777 1709 1805 1706 2128 2501 2937 2898 2552 2042 1465 958 1145 13540 Central Bennington County   Vermont
277 277 38005 Benson County, North Dakota 6962 766 663 689 519 381 421 394 367 282 296 374 417 425 362 223 164 120 99          
607 607 8011 Bent County, Colorado 5882 191 259 268 249 428 553 453 434 432 442 362 381 375 324 263 197 125 146          
2715 2715 5007 Benton County, Arkansas 272608 19055 19875 20673 18363 15702 19642 20493 21042 17895 17964 16020 15605 13722 11626 9745 6651 4361 4174 22220 Central Benton County   Arkansas
1400 1400 18007 Benton County, Indiana 8653 555 542 660 584 450 509 442 514 531 512 587 635 589 472 376 325 164 206 29200 Outlying Benton County Lafayette-West Lafayette-Frankfort, IN Indiana
1798 1798 19011 Benton County, Iowa 25642 1554 1607 1759 1590 1309 1288 1361 1538 1499 1550 1912 2081 1827 1410 1154 869 601 733 16300 Outlying Benton County Cedar Rapids-Iowa City, IA Iowa
2320 2320 27009 Benton County, Minnesota 40545 2938 2834 2885 2430 2451 2915 3070 3122 2418 2421 2536 2661 2155 1806 1306 897 695 1005 41060 Central Benton County Minneapolis-St. Paul, MN-WI Minnesota
1526 1526 28009 Benton County, Mississippi 8271 490 442 525 517 455 532 472 463 481 528 605 643 571 455 409 321 186 176 32820 Outlying Benton County Memphis-Forrest City, TN-MS-AR Mississippi
1215 1215 29015 Benton County, Missouri 19278 847 877 970 950 697 834 745 823 789 1101 1229 1635 1842 1875 1603 1168 728 565          
1612 1612 41003 Benton County, Oregon 92101 3799 3976 4416 8415 15408 7072 5076 4935 4414 4610 4380 5102 5553 5303 3876 2454 1536 1776 18700 Central Benton County Portland-Vancouver-Salem, OR-WA Oregon
1132 1132 47005 Benton County, Tennessee 16184 815 948 913 879 776 832 780 866 879 1065 1168 1187 1251 1152 1098 718 457 400          
2429 2429 53005 Benton County, Washington 201877 14468 15378 15296 13661 12103 13742 13822 13793 11703 11454 11575 12597 12188 10393 7758 5262 3327 3357 28420 Central Benton County   Washington
2192 2192 26019 Benzie County, Michigan 17753 835 827 952 937 767 919 907 902 845 989 1146 1463 1625 1422 1254 860 576 527 45900 Outlying Benzie County   Michigan
2674 2674 34003 Bergen County, New Jersey 936692 49659 53507 58766 57900 54820 52263 56248 62033 61731 66649 69419 70156 62455 48504 39041 28256 20337 24948 35620 Central Bergen County New York-Newark, NY-NJ-CT-PA New Jersey
1646 1646 45015 Berkeley County, South Carolina 221091 14285 14775 15165 14350 14778 16697 15944 15449 13678 14189 14123 14356 12892 10695 8841 5479 3076 2319 16700 Central Berkeley County   South Carolina
2625 2625 54003 Berkeley County, West Virginia 117123 7180 7474 7893 7039 6460 8402 8122 8201 7343 8063 8279 8144 7348 6126 4916 3036 1701 1396 25180 Central Berkeley County Washington-Baltimore-Arlington, DC-MD-VA-WV-PA West Virginia
1890 1890 42011 Berks County, Pennsylvania 420152 24151 25642 27166 29488 27708 26950 25194 24753 23592 26626 29187 30290 27053 22520 18066 12392 8747 10627 39740 Central Berks County Philadelphia-Reading-Camden, PA-NJ-DE-MD Pennsylvania
1919 1919 25003 Berkshire County, Massachusetts 126348 5292 5603 6273 7752 8424 6846 6728 6852 6245 7483 8936 10347 10169 9178 7415 5090 3432 4283 38340 Central Berkshire County   Massachusetts
2869 2869 35001 Bernalillo County, New Mexico 678701 37745 41002 42732 42856 44474 51033 50021 47292 40416 40777 40872 45276 42989 37614 28918 19120 12363 13201 10740 Central Bernalillo County Albuquerque-Santa Fe-Las Vegas, NM New Mexico
293 293 13019 Berrien County, Georgia 19252 1227 1175 1415 1263 1041 1231 1197 1103 1096 1285 1310 1391 1226 1006 923 609 396 358          
1803 1803 26021 Berrien County, Michigan 154141 8807 9309 9657 9466 8852 9459 8690 8997 8440 9496 9956 11443 11167 9731 7551 5473 3659 3988 35660 Central Berrien County South Bend-Elkhart-Mishawaka, IN-MI Michigan
800 800 37015 Bertie County, North Carolina 19026 818 927 995 951 1120 1268 1155 958 1047 1101 1247 1489 1571 1384 1072 764 562 597          
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          

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