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 centraloutlyingcounty descending

View and edit SQL

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
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
1345 28061 Jasper County, Mississippi 16428 986 1037 1085 905 990 1094 807 936 910 950 1060 1156 1160 1078 832 664 440 338 29860 Outlying Jasper County   Mississippi
1350 48077 Clay County, Texas 10456 485 556 652 619 493 505 472 598 587 622 699 911 882 760 609 434 294 278 48660 Outlying Clay County   Texas
1351 51095 James City County, Virginia 76397 3779 4135 4546 4419 3713 3892 3870 4273 4051 4589 5012 5470 5347 5506 5174 3852 2442 2327 47260 Outlying James City County Virginia Beach-Norfolk, VA-NC Virginia
1353 22111 Union Parish, Louisiana 22330 1314 1301 1406 1338 1196 1356 1239 1289 1158 1296 1433 1673 1741 1455 1198 849 555 533 33740 Outlying Union Parish Monroe-Ruston-Bastrop, LA Louisiana
1354 40135 Sequoyah County, Oklahoma 41179 2581 2396 2734 2689 2418 2559 2282 2349 2453 2656 2754 2959 2547 2456 2066 1526 984 770 22900 Outlying Sequoyah County   Oklahoma
1359 18073 Jasper County, Indiana 33370 1918 2066 2338 2433 2180 1919 1711 1999 2057 2056 2104 2496 2221 1904 1540 1091 723 614 16980 Outlying Jasper County Chicago-Naperville, IL-IN-WI Indiana
1360 13025 Brantley County, Georgia 18897 1146 1213 1293 1216 1110 1200 1113 1056 1138 1354 1356 1365 1197 1097 849 533 388 273 15260 Outlying Brantley County   Georgia
1362 12129 Wakulla County, Florida 32461 1803 1821 2088 1914 1583 2179 2276 2283 2155 2452 2317 2316 2188 1797 1494 906 487 402 45220 Outlying Wakulla County Tallahassee-Bainbridge, FL-GA Florida
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
1367 16051 Jefferson County, Idaho 29439 2535 2820 3024 2469 1644 1717 1810 2142 1880 1477 1433 1632 1471 1207 861 599 376 342 26820 Outlying Jefferson County Idaho Falls-Rexburg-Blackfoot, ID Idaho
1371 17067 Hancock County, Illinois 17844 974 998 1123 976 856 947 967 988 964 964 1174 1365 1414 1224 1012 768 538 592 22800 Outlying Hancock County   Illinois
1373 50011 Franklin County, Vermont 49421 2892 3054 3128 2902 2741 3176 3107 3198 2978 3350 3528 3871 3571 2804 2091 1349 848 833 15540 Outlying Franklin County   Vermont
1381 27095 Mille Lacs County, Minnesota 26139 1690 1762 1781 1615 1323 1452 1554 1640 1438 1555 1737 2042 1763 1494 1128 944 589 632 33460 Outlying Mille Lacs County Minneapolis-St. Paul, MN-WI Minnesota
1386 47115 Marion County, Tennessee 28575 1618 1571 1745 1679 1522 1761 1545 1592 1682 1915 1964 2123 2121 1899 1574 1080 633 551 16860 Outlying Marion County Chattanooga-Cleveland-Dalton, TN-GA-AL Tennessee
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
1391 13189 McDuffie County, Georgia 21531 1407 1554 1561 1453 1180 1381 1247 1165 1121 1326 1416 1484 1459 1217 1065 712 456 327 12260 Outlying McDuffie County   Georgia
1393 13171 Lamar County, Georgia 19000 1095 1069 1083 1782 1476 1320 1074 1051 1011 1138 1218 1236 1224 1085 841 591 378 328 12060 Outlying Lamar County Atlanta--Athens-Clarke County--Sandy Springs, GA Georgia
1396 20043 Doniphan County, Kansas 7682 405 472 470 660 475 433 411 469 407 432 470 536 540 477 365 245 193 222 41140 Outlying Doniphan County Kansas City-Overland Park-Kansas City, MO-KS Kansas
1398 12053 Hernando County, Florida 190865 8695 9413 10457 10000 9110 10434 9684 9810 9547 11351 12104 13658 14190 14263 13859 10828 7017 6445 45300 Outlying Hernando County   Florida
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
1401 26089 Leelanau County, Michigan 21764 865 956 984 1063 994 937 943 1022 960 1054 1236 1818 2201 2232 1674 1211 783 831 45900 Outlying Leelanau County   Michigan
1403 13273 Terrell County, Georgia 8611 507 554 591 526 493 612 478 489 403 444 573 622 611 534 445 318 232 179 10500 Outlying Terrell County   Georgia
1406 18115 Ohio County, Indiana 5844 267 299 331 317 260 312 325 308 310 378 418 563 465 408 337 268 160 118 17140 Outlying Ohio County Cincinnati-Wilmington-Maysville, OH-KY-IN Indiana
1410 47129 Morgan County, Tennessee 21579 1032 1054 1264 1224 1410 1499 1291 1371 1413 1588 1618 1478 1501 1302 1019 711 438 366 28940 Outlying Morgan County Knoxville-Morristown-Sevierville, TN Tennessee
1411 24047 Worcester County, Maryland 51823 2176 2469 2623 2545 2544 2769 2598 2419 2400 2974 3529 4170 4186 4229 3879 2756 1938 1619 41540 Outlying Worcester County   Maryland
1413 21209 Scott County, Kentucky 56031 3672 3952 4131 3862 3626 4043 3643 4097 3914 4045 3698 3543 3058 2557 1757 1162 655 616 30460 Outlying Scott County Lexington-Fayette--Richmond--Frankfort, KY Kentucky
1417 38085 Sioux County, North Dakota 4358 447 423 433 414 287 303 275 257 234 222 277 262 171 123 81 71 43 35 13900 Outlying Sioux County   North Dakota
1418 27045 Fillmore County, Minnesota 21058 1398 1446 1541 1226 1002 1015 1115 1307 1103 1146 1283 1512 1555 1313 1004 739 578 775 40340 Outlying Fillmore County Rochester-Austin, MN Minnesota
1419 45023 Chester County, South Carolina 32251 1826 2027 2136 1940 1765 2166 1726 1810 1710 2118 2295 2347 2330 2006 1587 1128 654 680 16740 Outlying Chester County Charlotte-Concord, NC-SC South Carolina
1421 55093 Pierce County, Wisconsin 42555 2060 2418 2743 3777 4655 2334 2297 2525 2279 2600 2778 3058 2817 2245 1573 1068 664 664 33460 Outlying Pierce County Minneapolis-St. Paul, MN-WI Wisconsin
1430 13227 Pickens County, Georgia 31980 1619 1686 1904 1900 1587 1912 1678 1717 1808 2057 2218 2460 2430 2408 2005 1321 711 559 12060 Outlying Pickens County Atlanta--Athens-Clarke County--Sandy Springs, GA Georgia
1431 47013 Campbell County, Tennessee 39583 2185 2081 2416 2232 2140 2560 2026 2195 2385 2775 2857 2729 2790 2551 2178 1647 1031 805 28940 Outlying Campbell County Knoxville-Morristown-Sevierville, TN Tennessee
1432 37069 Franklin County, North Carolina 67560 3768 3942 4396 4378 3837 4126 3790 4039 4148 4900 4879 5221 4784 3928 3011 1939 1308 1166 39580 Outlying Franklin County Raleigh-Durham-Chapel Hill, NC North Carolina
1436 18111 Newton County, Indiana 14011 749 803 873 842 697 844 769 830 831 868 941 1164 1072 887 634 573 323 311 16980 Outlying Newton County Chicago-Naperville, IL-IN-WI Indiana
1441 28069 Kemper County, Mississippi 10027 445 495 554 947 840 701 498 524 536 605 574 640 643 584 502 335 290 314 32940 Outlying Kemper County   Mississippi
1443 21061 Edmonson County, Kentucky 12274 584 616 628 758 747 774 684 739 741 797 787 981 892 817 677 514 262 276 14540 Outlying Edmonson County Bowling Green-Glasgow, KY Kentucky
1444 17005 Bond County, Illinois 16630 791 858 982 949 908 1148 1175 1120 1081 991 1092 1298 1151 1023 709 565 355 434 41180 Outlying Bond County St. Louis-St. Charles-Farmington, MO-IL Illinois
1452 16045 Gem County, Idaho 17634 1052 1081 1157 1127 827 956 877 984 920 948 1165 1315 1362 1217 1030 760 462 394 14260 Outlying Gem County Boise City-Mountain Home-Ontario, ID-OR Idaho
1456 36075 Oswego County, New York 117898 6410 6774 7147 8707 8333 7673 6898 6691 6101 7434 8781 9446 8238 6644 4904 3464 2085 2168 45060 Outlying Oswego County Syracuse-Auburn, NY New York
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
1460 17083 Jersey County, Illinois 21847 1090 1194 1326 1436 1422 1190 1181 1253 1173 1377 1509 1777 1659 1326 1000 808 576 550 41180 Outlying Jersey County St. Louis-St. Charles-Farmington, MO-IL Illinois
1464 41049 Morrow County, Oregon 11372 841 858 898 863 676 620 588 681 633 649 646 728 810 680 472 322 235 172 25840 Outlying Morrow County   Oregon
1465 37109 Lincoln County, North Carolina 83770 4326 4722 5318 4998 4329 4866 4552 4703 5412 6522 6513 6646 6061 4935 4211 2750 1601 1305 16740 Outlying Lincoln County Charlotte-Concord, NC-SC North Carolina
1468 16041 Franklin County, Idaho 13726 1017 1174 1354 1239 809 748 692 875 907 714 689 812 753 610 484 365 245 239 30860 Outlying Franklin County   Idaho
1469 13045 Carroll County, Georgia 118121 7583 7507 8000 9464 10430 8674 7353 7404 6970 7647 7228 7258 6523 5444 4323 3011 1841 1461 12060 Outlying Carroll County Atlanta--Athens-Clarke County--Sandy Springs, GA Georgia
1474 21077 Gallatin County, Kentucky 8832 565 574 624 586 508 634 497 556 531 603 658 666 597 425 354 248 113 93 17140 Outlying Gallatin County Cincinnati-Wilmington-Maysville, OH-KY-IN Kentucky
1475 23023 Sagadahoc County, Maine 35634 1780 1839 1991 1830 1589 1966 2123 2085 1960 2340 2458 2954 2838 2526 2182 1434 924 815 38860 Outlying Sagadahoc County Portland-Lewiston-South Portland, ME Maine
1479 21017 Bourbon County, Kentucky 20184 1226 1271 1336 1211 1152 1283 1013 1097 1225 1384 1346 1487 1338 1167 950 743 478 477 30460 Outlying Bourbon County Lexington-Fayette--Richmond--Frankfort, KY Kentucky
1480 47149 Rutherford County, Tennessee 324890 21353 21775 23298 23593 29763 25815 22342 24007 21894 22162 19994 18861 16067 12393 8995 5757 3620 3201 34980 Outlying Rutherford County Nashville-Davidson--Murfreesboro, TN Tennessee
1481 17147 Piatt County, Illinois 16396 961 999 1035 1032 843 826 967 1001 967 987 1026 1346 1232 974 810 576 427 387 16580 Outlying Piatt County   Illinois
1483 19085 Harrison County, Iowa 14134 874 857 942 906 686 741 766 769 790 888 884 1196 1050 848 648 535 319 435 36540 Outlying Harrison County Omaha-Council Bluffs-Fremont, NE-IA Iowa
1485 47159 Smith County, Tennessee 19942 1230 1159 1311 1241 1160 1279 1137 1243 1130 1302 1473 1546 1346 1147 959 630 358 291 34980 Outlying Smith County Nashville-Davidson--Murfreesboro, TN Tennessee
1490 47169 Trousdale County, Tennessee 11012 545 530 562 756 765 1154 1207 923 511 770 694 578 591 483 390 275 146 132 34980 Outlying Trousdale County Nashville-Davidson--Murfreesboro, TN Tennessee
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
1493 19121 Madison County, Iowa 16249 926 1109 1286 1084 770 778 870 1056 1028 1189 1135 1170 1088 916 654 502 325 363 19780 Outlying Madison County Des Moines-Ames-West Des Moines, IA Iowa
1500 45081 Saluda County, South Carolina 20544 1241 1227 1272 1145 1115 1341 1172 1193 1148 1327 1343 1535 1425 1212 1045 821 496 486 17900 Outlying Saluda County Columbia-Orangeburg-Newberry, SC South Carolina
1504 37115 Madison County, North Carolina 21763 1030 1017 1098 1503 1415 1230 1173 1208 1261 1348 1443 1528 1649 1630 1295 837 559 539 11700 Outlying Madison County Asheville-Brevard, NC North Carolina
1505 16053 Jerome County, Idaho 24015 1996 2110 2192 1684 1416 1591 1614 1619 1338 1312 1279 1439 1308 1051 794 609 359 304 46300 Outlying Jerome County   Idaho
1508 13181 Lincoln County, Georgia 7915 440 379 433 425 397 473 431 367 399 439 512 675 660 627 501 373 198 186 12260 Outlying Lincoln County   Georgia
1512 27039 Dodge County, Minnesota 20822 1300 1450 1647 1441 1192 1155 1290 1413 1357 1384 1381 1444 1304 1006 733 549 362 414 40340 Outlying Dodge County Rochester-Austin, MN Minnesota
1514 26159 Van Buren County, Michigan 75448 4479 4789 5156 4813 4188 4172 4143 4554 4226 4731 5002 5786 5742 4868 3453 2416 1433 1497 28020 Outlying Van Buren County Kalamazoo-Battle Creek-Portage, MI Michigan
1515 17131 Mercer County, Illinois 15601 800 873 1007 974 776 803 808 907 899 945 1082 1228 1119 1031 817 660 389 483 19340 Outlying Mercer County Davenport-Moline, IA-IL Illinois
1519 18179 Wells County, Indiana 28206 1839 1973 1986 1754 1574 1655 1553 1719 1523 1660 1764 2063 1979 1636 1221 918 615 774 23060 Outlying Wells County Fort Wayne-Huntington-Auburn, IN Indiana
1520 51063 Floyd County, Virginia 15795 764 834 952 880 723 752 775 861 934 1060 1109 1267 1280 1191 910 706 426 371 13980 Outlying Floyd County   Virginia
1521 48107 Crosby County, Texas 5779 385 423 463 419 318 342 319 361 306 294 324 376 368 315 252 233 143 138 31180 Outlying Crosby County Lubbock-Levelland, TX Texas
1523 37145 Person County, North Carolina 39507 2128 2222 2364 2377 2127 2372 2076 2115 2257 2756 2760 3113 3115 2544 2043 1394 919 825 20500 Outlying Person County Raleigh-Durham-Chapel Hill, NC North Carolina
1525 54005 Boone County, West Virginia 21951 1117 1279 1380 1357 1079 1217 1012 1222 1591 1559 1455 1543 1737 1634 1184 712 491 382 16620 Outlying Boone County Charleston-Huntington-Ashland, WV-OH-KY West Virginia
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
1527 37151 Randolph County, North Carolina 143351 8084 8666 9477 9302 8163 8897 7984 8031 8474 10252 10435 10571 9575 8166 6972 4658 2976 2668 24660 Outlying Randolph County Greensboro--Winston-Salem--High Point, NC North Carolina
1531 12041 Gilchrist County, Florida 18256 1037 1007 995 1323 1486 941 953 986 881 1084 1191 1315 1316 1122 935 747 454 483 23540 Outlying Gilchrist County Gainesville-Lake City, FL Florida
1536 8097 Pitkin County, Colorado 17950 700 697 793 801 861 1333 1366 1222 1132 1399 1357 1356 1451 1305 1017 614 289 257 24060 Outlying Pitkin County Edwards-Glenwood Springs, CO Colorado
1541 51157 Rappahannock County, Virginia 7252 246 341 361 386 338 361 335 309 360 424 530 620 660 597 577 378 229 200 47900 Outlying Rappahannock County Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Virginia
1544 8093 Park County, Colorado 18556 667 752 869 801 638 851 886 1161 1072 1271 1508 2113 2174 1740 1111 549 221 172 19740 Outlying Park County Denver-Aurora, CO Colorado
1551 19195 Worth County, Iowa 7453 402 451 445 417 401 432 379 453 401 453 503 587 598 480 365 245 216 225 32380 Outlying Worth County   Iowa
1553 18143 Scott County, Indiana 23878 1411 1472 1562 1462 1366 1555 1369 1416 1514 1715 1642 1833 1586 1300 1091 764 474 346 31140 Outlying Scott County Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Indiana
1555 40081 Lincoln County, Oklahoma 34920 2057 2278 2484 2286 1822 2089 1891 2070 1925 2146 2319 2625 2528 1998 1678 1230 805 689 36420 Outlying Lincoln County Oklahoma City-Shawnee, OK Oklahoma
1561 13145 Harris County, Georgia 34475 1635 1998 2256 2282 1840 1789 1798 1946 2094 2534 2610 2684 2533 2337 1854 1117 594 574 17980 Outlying Harris County Columbus-Auburn-Opelika, GA-AL Georgia
1563 29145 Newton County, Missouri 58266 3563 3761 4001 3915 3323 3559 3317 3431 3211 3641 3851 4179 3961 3241 2801 2049 1329 1133 27900 Outlying Newton County Joplin-Miami, MO-OK Missouri
1564 18129 Posey County, Indiana 25540 1391 1628 1630 1497 1397 1399 1441 1545 1448 1582 1735 2024 2024 1662 1174 838 549 576 21780 Outlying Posey County   Indiana
1565 17035 Cumberland County, Illinois 10808 653 652 689 609 539 617 621 645 623 654 700 841 848 673 496 368 271 309 16660 Outlying Cumberland County   Illinois
1566 50017 Orange County, Vermont 28999 1366 1467 1501 1709 1610 1441 1618 1741 1551 1801 2052 2507 2486 2249 1615 1046 637 602 17200 Outlying Orange County   Vermont
1569 39051 Fulton County, Ohio 42276 2537 2688 2915 2798 2517 2423 2292 2549 2394 2684 2759 3130 3079 2552 1787 1300 865 1007 45780 Outlying Fulton County Toledo-Port Clinton, OH Ohio
1577 18161 Union County, Indiana 7037 374 357 432 421 407 451 346 412 391 475 534 585 489 458 357 251 145 152 17140 Outlying Union County Cincinnati-Wilmington-Maysville, OH-KY-IN Indiana
1578 29119 McDonald County, Missouri 23078 1711 1543 1665 1609 1316 1386 1319 1428 1364 1485 1592 1664 1469 1159 948 689 419 312 22220 Outlying McDonald County   Missouri
1582 48367 Parker County, Texas 138371 8698 9447 10151 9353 7434 7749 8504 9154 8360 9364 9606 10241 9008 7313 5760 3842 2340 2047 19100 Outlying Parker County Dallas-Fort Worth, TX-OK Texas
1583 27143 Sibley County, Minnesota 15028 844 988 1091 957 799 806 825 942 834 892 1000 1255 1039 825 627 490 380 434 33460 Outlying Sibley County Minneapolis-St. Paul, MN-WI Minnesota
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
1589 13183 Long County, Georgia 18998 1407 1446 1430 1311 1179 1482 1646 1452 1302 1261 1113 1129 1009 733 466 263 162 207 25980 Outlying Long County Savannah-Hinesville-Statesboro, GA Georgia
1595 22043 Grant Parish, Louisiana 22482 1329 1292 1356 1221 1310 1881 1946 1783 1470 1409 1364 1451 1250 1122 954 624 403 317 10780 Outlying Grant Parish   Louisiana
1602 46087 McCook County, South Dakota 5546 409 445 436 347 286 278 263 338 313 314 314 380 370 318 223 210 140 162 43620 Outlying McCook County   South Dakota
1604 37131 Northampton County, North Carolina 19676 905 883 1059 921 1016 1188 883 951 937 1125 1283 1630 1805 1544 1355 934 597 660 40260 Outlying Northampton County Rocky Mount-Wilson-Roanoke Rapids, NC North Carolina
1608 37159 Rowan County, North Carolina 141262 8134 8226 9311 9132 8650 9407 8192 8284 8156 9541 9655 10372 9372 8012 6492 4606 2844 2876 16740 Outlying Rowan County Charlotte-Concord, NC-SC North Carolina
1611 28015 Carroll County, Mississippi 9911 428 475 593 532 520 548 501 591 525 618 649 808 775 725 637 470 272 244 24900 Outlying Carroll County   Mississippi
1615 42099 Perry County, Pennsylvania 46139 2629 2756 2735 2665 2342 2854 2657 2784 2585 3120 3469 3523 3489 3083 2210 1476 924 838 25420 Outlying Perry County Harrisburg-York-Lebanon, PA Pennsylvania
1617 40131 Rogers County, Oklahoma 91984 5355 5808 6321 6325 5667 5928 5556 5801 5370 6074 6108 6666 5924 4867 3947 2789 1903 1575 46140 Outlying Rogers County Tulsa-Muskogee-Bartlesville, OK Oklahoma
1623 51045 Craig County, Virginia 5064 195 227 282 290 250 274 236 242 272 353 415 426 417 375 341 205 131 133 40220 Outlying Craig County   Virginia
1629 13079 Crawford County, Georgia 12318 599 678 777 707 643 756 715 664 668 812 929 1117 937 801 687 424 248 156 31420 Outlying Crawford County Macon-Warner Robins, GA Georgia
1631 36027 Dutchess County, New York 293718 13331 14594 16135 21009 21428 18299 16713 17127 16749 19624 22407 23843 20826 16192 12954 9005 6335 7147 35620 Outlying Dutchess County New York-Newark, NY-NJ-CT-PA New York
1633 47081 Hickman County, Tennessee 25063 1389 1375 1509 1481 1456 1699 1589 1593 1541 1712 1825 1880 1613 1473 1170 831 517 410 34980 Outlying Hickman County Nashville-Davidson--Murfreesboro, TN Tennessee

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