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)

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
2359 2359 4009 Graham County, Arizona 38072 2730 2840 3015 2948 2735 2977 2618 2564 2341 2117 1925 1976 1976 1652 1366 970 697 625 40940 Central Graham County   Arizona
356 356 4011 Greenlee County, Arizona 9483 756 712 721 644 594 718 687 702 572 537 529 528 535 409 294 206 148 191          
976 976 4012 La Paz County, Arizona 21098 1002 932 1057 900 855 1059 903 898 796 813 959 1284 1353 1682 2170 2054 1375 1006          
1816 1816 4013 Maricopa County, Arizona 4410824 279620 289272 304795 295805 291532 335816 307998 298360 275928 284479 267970 268633 241331 210766 177344 123762 78789 78624 38060 Central Maricopa County   Arizona
2593 2593 4015 Mohave County, Arizona 209550 9161 9562 10764 9893 9356 11163 10175 9788 9092 10609 12210 16084 18167 18476 17513 13225 8242 6070 29420 Central Mohave County Las Vegas-Henderson, NV-AZ Arizona
1624 1624 4017 Navajo County, Arizona 110445 7673 8253 8737 7623 6344 7125 6247 6167 5685 5824 6202 7239 7316 6709 5398 3787 2309 1807 43320 Central Navajo County   Arizona
1846 1846 4019 Pima County, Arizona 1039073 58491 59449 61965 68872 90267 72913 60111 61967 56528 57185 56656 64018 65396 62486 54013 38553 24765 25438 46060 Central Pima County Tucson-Nogales, AZ Arizona
1568 1568 4021 Pinal County, Arizona 447138 25250 28421 30354 26891 25002 29377 29347 30507 27795 26164 23816 25694 27391 28189 26681 18555 10151 7553 38060 Central Pinal County   Arizona
2780 2780 4023 Santa Cruz County, Arizona 46511 3211 3407 3652 3569 2995 2761 2447 2526 2534 2594 2682 2845 2867 2610 2305 1603 962 941 35700 Central Santa Cruz County Tucson-Nogales, AZ Arizona
2594 2594 4025 Yavapai County, Arizona 231993 9689 9968 11316 11367 10435 10934 10165 10402 9990 11298 13205 17964 21982 23388 20154 13995 8316 7425 39140 Central Yavapai County   Arizona
1546 1546 4027 Yuma County, Arizona 212128 15229 14708 14909 14814 17679 15711 13793 12552 10677 10664 10789 10643 10132 9721 9857 8914 6089 5247 49740 Central Yuma County   Arizona
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          
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          
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
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
2316 2316 5009 Boone County, Arkansas 37480 2387 2317 2484 2138 1989 2374 2022 2191 2071 2307 2368 2684 2405 2279 2069 1493 970 932 25460 Central Boone County   Arkansas
1170 1170 5011 Bradley County, Arkansas 10897 662 756 762 654 543 677 641 657 648 664 696 733 737 620 512 399 257 279          
2158 2158 5013 Calhoun County, Arkansas 5277 237 284 296 296 291 333 291 273 288 341 373 440 397 376 289 194 156 122 15780 Outlying Calhoun County   Arkansas
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          
1163 1163 5017 Chicot County, Arkansas 10438 599 663 698 599 637 608 550 577 525 641 612 804 803 656 471 408 269 318          
1442 1442 5019 Clark County, Arkansas 22061 1161 1131 1225 2215 3203 1334 1104 1045 1076 1165 1162 1294 1259 1106 943 705 475 458 11660 Central Clark County   Arkansas
643 643 5021 Clay County, Arkansas 14847 924 848 911 850 814 936 754 850 802 908 1005 1079 987 877 859 629 453 361          
429 429 5023 Cleburne County, Arkansas 24965 1095 1328 1435 1322 1108 1224 1198 1343 1312 1368 1648 1965 1932 1784 1784 1383 883 853          
2745 2745 5025 Cleveland County, Arkansas 8018 412 439 577 506 407 436 424 459 461 523 519 626 546 530 453 305 222 173 38220 Outlying Cleveland County Little Rock-North Little Rock, AR Arkansas
1934 1934 5027 Columbia County, Arkansas 23537 1360 1348 1362 2268 2621 1439 1206 1263 1108 1252 1319 1476 1414 1219 1005 735 572 570 31620 Central Columbia County   Arkansas
904 904 5029 Conway County, Arkansas 20891 1222 1345 1279 1275 1034 1322 1181 1222 1185 1248 1427 1556 1500 1204 1061 764 539 527          
1904 1904 5031 Craighead County, Arkansas 108558 7597 7553 7498 7943 7941 8893 7846 7299 6590 6387 6080 6193 5708 4875 3776 2743 1791 1845 27860 Central Craighead County Jonesboro-Paragould, AR Arkansas
2212 2212 5033 Crawford County, Arkansas 63406 3970 4228 4578 4182 3544 4094 3912 3821 3905 4087 4124 4353 4061 3364 2773 2059 1267 1084 22900 Central Crawford County   Arkansas
2797 2797 5035 Crittenden County, Arkansas 48342 3686 3531 3633 3478 3062 3392 3022 2944 2771 2893 3014 3234 2844 2296 1763 1278 753 748 32820 Central Crittenden County Memphis-Forrest City, TN-MS-AR Arkansas
563 563 5037 Cross County, Arkansas 16676 1047 1058 1145 1045 945 1008 901 1003 1029 1040 1045 1201 1079 932 867 604 360 367          
1005 1005 5039 Dallas County, Arkansas 7182 376 409 468 422 363 410 361 412 335 418 425 544 574 497 432 302 188 246          
713 713 5041 Desha County, Arkansas 11512 772 831 842 755 614 644 642 654 601 607 689 819 854 716 545 414 267 246          
1238 1238 5043 Drew County, Arkansas 18328 1096 1045 1117 1409 1788 1272 974 1041 979 1003 1078 1202 1117 964 756 615 466 406          
2241 2241 5045 Faulkner County, Arkansas 124806 7621 7911 8366 9078 14476 9541 8473 8127 7384 7516 7074 7264 6393 5277 4207 2769 1728 1601 30780 Outlying Faulkner County Little Rock-North Little Rock, AR Arkansas
610 610 5047 Franklin County, Arkansas 17810 993 1103 1223 1183 1011 1071 949 1084 1037 1090 1136 1299 1188 1047 850 648 460 438          
95 95 5049 Fulton County, Arkansas 12269 601 656 787 722 585 559 546 610 583 735 782 920 962 964 816 654 410 377          
1647 1647 5051 Garland County, Arkansas 99154 5336 5470 5619 5592 5056 5955 5359 5585 5291 5834 6093 7044 7288 7174 6140 4577 2916 2825 26300 Central Garland County Hot Springs-Malvern, AR Arkansas
2712 2712 5053 Grant County, Arkansas 18188 980 1119 1218 1161 967 1134 1062 1161 1145 1213 1236 1354 1163 1001 896 642 368 368 30780 Outlying Grant County Little Rock-North Little Rock, AR Arkansas
2486 2486 5055 Greene County, Arkansas 45325 2968 3080 3158 2932 2694 3170 2856 2915 2872 3081 2930 2891 2536 2318 1905 1380 876 763 37500 Central Greene County Jonesboro-Paragould, AR Arkansas
1339 1339 5057 Hempstead County, Arkansas 21741 1565 1631 1567 1361 1229 1293 1122 1229 1249 1195 1372 1554 1469 1158 973 787 500 487          
1929 1929 5059 Hot Spring County, Arkansas 33701 1716 1844 2063 2018 1962 2355 2027 2069 2110 2210 2243 2397 2318 2075 1697 1185 727 685 31680 Central Hot Spring County Hot Springs-Malvern, AR Arkansas
939 939 5061 Howard County, Arkansas 13341 939 971 994 866 734 795 761 807 708 781 873 901 817 702 627 442 326 297          
1453 1453 5063 Independence County, Arkansas 37678 2422 2540 2638 2519 2294 2246 2232 2296 2273 2331 2350 2475 2459 2010 1686 1219 869 819 12900 Central Independence County   Arkansas
336 336 5065 Izard County, Arkansas 13593 585 662 779 663 683 724 698 741 704 870 924 1041 1013 982 881 706 492 445          
625 625 5067 Jackson County, Arkansas 16811 981 882 957 867 1003 1302 1143 1123 1067 1059 1104 1164 1108 967 818 581 348 337          
1670 1670 5069 Jefferson County, Arkansas 68114 4158 4022 4248 4778 4775 4715 4132 4092 3735 4001 4274 4716 4691 3941 3091 2025 1373 1347 38220 Central Jefferson County Little Rock-North Little Rock, AR Arkansas
220 220 5071 Johnson County, Arkansas 26742 1813 1832 1849 1941 1696 1670 1641 1676 1492 1556 1713 1814 1649 1368 1180 829 508 515          
1082 1082 5073 Lafayette County, Arkansas 6682 341 307 354 358 368 412 285 331 371 371 490 533 555 426 432 337 211 200          
1263 1263 5075 Lawrence County, Arkansas 16434 960 970 1050 1114 1058 1060 857 930 906 973 1094 1130 1090 879 869 617 458 419          
888 888 5077 Lee County, Arkansas 8985 447 441 447 474 544 728 650 564 563 630 573 597 563 515 464 325 209 251          
1671 1671 5079 Lincoln County, Arkansas 13383 537 609 678 738 1035 1183 1119 1045 914 940 957 863 716 613 526 371 290 249 38220 Outlying Lincoln County Little Rock-North Little Rock, AR Arkansas
2280 2280 5081 Little River County, Arkansas 12326 734 741 792 730 652 725 672 677 739 764 812 849 850 810 718 507 302 252 45500 Outlying Little River County   Arkansas
98 98 5083 Logan County, Arkansas 21737 1310 1177 1326 1397 1178 1303 1162 1186 1240 1437 1596 1643 1467 1352 1105 855 541 462          
1454 1454 5085 Lonoke County, Arkansas 73657 4988 5227 5502 4980 4276 5124 5242 5232 4891 4854 4647 4730 4156 3260 2620 1844 1130 954 30780 Central Lonoke County Little Rock-North Little Rock, AR Arkansas
2735 2735 5087 Madison County, Arkansas 16481 1112 1000 1098 1050 863 977 943 911 923 1016 1080 1216 1149 1061 790 609 376 307 22220 Outlying Madison County   Arkansas
1165 1165 5089 Marion County, Arkansas 16722 837 850 928 745 671 758 750 744 732 880 1071 1393 1595 1573 1345 912 520 418          
1466 1466 5091 Miller County, Arkansas 43592 2878 2896 2794 2684 2569 3063 2691 2848 2636 2730 2776 2948 2715 2335 1918 1391 905 815 45500 Central Miller County   Arkansas
2065 2065 5093 Mississippi County, Arkansas 41239 2969 2829 3092 2889 2655 2880 2538 2507 2392 2337 2649 2798 2604 2062 1557 1051 767 663 14180 Central Mississippi County   Arkansas
516 516 5095 Monroe County, Arkansas 6900 451 399 401 346 339 417 317 343 323 380 471 559 553 511 372 291 226 201          
723 723 5097 Montgomery County, Arkansas 8924 420 414 485 503 420 430 348 383 418 520 706 749 717 686 640 490 314 281          
949 949 5099 Nevada County, Arkansas 8326 484 538 545 499 375 520 440 439 447 527 557 621 616 522 432 324 211 229          
2126 2126 5101 Newton County, Arkansas 7805 381 367 460 448 350 400 368 411 392 404 516 585 654 657 582 401 238 191 25460 Outlying Newton County   Arkansas
1969 1969 5103 Ouachita County, Arkansas 23606 1328 1471 1621 1362 1222 1343 1307 1309 1222 1413 1472 1820 1906 1622 1146 827 561 654 15780 Central Ouachita County   Arkansas
1865 1865 5105 Perry County, Arkansas 10352 620 609 672 627 564 522 570 571 594 706 726 756 724 665 560 366 261 239 30780 Outlying Perry County Little Rock-North Little Rock, AR Arkansas
2150 2150 5107 Phillips County, Arkansas 18029 1386 1220 1265 1218 1106 1076 874 949 879 950 1048 1329 1303 1156 856 614 410 390 25760 Central Phillips County   Arkansas
1216 1216 5109 Pike County, Arkansas 10673 553 648 675 652 596 576 579 563 653 760 734 752 756 706 525 424 315 206          
3073 3073 5111 Poinsett County, Arkansas 23974 1622 1572 1612 1477 1386 1683 1372 1345 1345 1561 1577 1655 1471 1328 1153 880 522 413 27860 Outlying Poinsett County Jonesboro-Paragould, AR Arkansas
52 52 5113 Polk County, Arkansas 20049 1196 1220 1330 1269 999 1096 948 1040 1067 1197 1199 1453 1424 1418 1219 937 557 480          
2924 2924 5115 Pope County, Arkansas 64000 4056 3944 4179 5067 5499 4644 3985 3707 3427 3730 3895 4123 3663 3081 2689 1891 1244 1176 40780 Central Pope County   Arkansas
1169 1169 5117 Prairie County, Arkansas 8074 430 444 454 433 433 406 445 391 391 513 600 592 622 512 479 394 283 252          
2666 2666 5119 Pulaski County, Arkansas 392680 25974 25536 25029 23054 25388 30212 27786 26718 23508 24132 23240 26048 24980 21261 15562 10226 6629 7397 30780 Central Pulaski County Little Rock-North Little Rock, AR Arkansas
325 325 5121 Randolph County, Arkansas 17948 1139 1196 1178 1117 927 1189 1063 1044 1031 1003 1148 1198 1136 1067 885 661 438 528          
2346 2346 5123 St. Francis County, Arkansas 25439 1583 1438 1474 1412 1505 1910 1873 1957 1716 1588 1579 1633 1649 1410 1095 715 434 468 22620 Central St. Francis County Memphis-Forrest City, TN-MS-AR Arkansas
2899 2899 5125 Saline County, Arkansas 121421 7084 7699 8397 7546 6271 7689 7796 8550 7889 7910 7810 7806 7410 6705 5923 4294 2577 2065 30780 Central Saline County Little Rock-North Little Rock, AR Arkansas
350 350 5127 Scott County, Arkansas 10319 581 661 723 636 518 635 542 544 537 612 725 798 655 645 560 468 258 221          
232 232 5129 Searcy County, Arkansas 7958 418 448 464 461 357 375 401 385 414 467 534 613 633 587 538 366 255 242          
3022 3022 5131 Sebastian County, Arkansas 127753 8387 8249 8662 8309 8307 9085 8231 7933 7515 7940 8285 8445 7901 6672 5248 3732 2377 2475 22900 Central Sebastian County   Arkansas
250 250 5133 Sevier County, Arkansas 17139 1353 1373 1376 1223 1101 1165 991 999 947 1150 1022 1007 939 794 629 457 330 283          
753 753 5135 Sharp County, Arkansas 17366 938 917 1038 1026 829 879 743 860 886 1042 1073 1254 1351 1289 1215 885 623 518          
32 32 5137 Stone County, Arkansas 12457 596 640 730 655 545 626 545 605 669 592 773 1013 1052 957 918 718 426 397          
3007 3007 5139 Union County, Arkansas 39126 2568 2603 2693 2409 2174 2376 2234 2435 2181 2446 2415 2833 2742 2296 1773 1263 851 834 20980 Central Union County   Arkansas
219 219 5141 Van Buren County, Arkansas 16603 802 875 1029 950 715 731 778 868 835 1007 1067 1259 1362 1214 1140 856 561 554          
2075 2075 5143 Washington County, Arkansas 236961 16141 16172 16224 18783 24995 19138 16690 16864 14439 13356 12523 12646 11181 9334 7210 4986 3132 3147 22220 Central Washington County   Arkansas
2541 2541 5145 White County, Arkansas 78727 4656 5029 5278 5987 6213 5071 4648 4724 4397 5015 4945 5284 4548 3985 3466 2445 1596 1440 42620 Central White County Little Rock-North Little Rock, AR Arkansas
855 855 5147 Woodruff County, Arkansas 6490 381 400 382 379 355 345 316 323 356 413 403 495 440 496 380 269 157 200          
2038 2038 5149 Yell County, Arkansas 21535 1386 1439 1582 1390 1221 1280 1182 1228 1305 1381 1380 1580 1352 1181 927 738 499 484 40780 Outlying Yell County   Arkansas
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
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          
2606 2606 6007 Butte County, California 231256 12803 12732 12963 15667 25027 16833 13394 13601 11685 11971 12243 14305 15040 14348 10990 7162 4914 5578 17020 Central Butte County   California
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          
679 679 6011 Colusa County, California 21627 1543 1618 1732 1598 1409 1463 1418 1390 1222 1255 1285 1286 1245 1026 780 607 354 396          
1974 1974 6013 Contra Costa County, California 1150215 64973 70774 77366 73055 66640 73055 73953 78936 76498 80738 80749 80276 71759 59161 47276 31351 20413 23242 41860 Outlying Contra Costa County San Jose-San Francisco-Oakland, CA California
2337 2337 6015 Del Norte County, California 27828 1560 1659 1688 1479 1584 1925 2008 2056 1634 1603 1641 1940 2033 1754 1276 893 546 549 18860 Central Del Norte County   California
2121 2121 6017 El Dorado County, California 190678 8704 10164 11802 11103 9554 9649 9799 10898 10515 12189 13360 16346 16206 14190 10754 6926 4191 4328 40900 Central El Dorado County Sacramento-Roseville, CA California
2345 2345 6019 Fresno County, California 994400 77299 80577 79551 71727 70764 80417 72036 67102 58541 55843 54618 54997 48815 40669 30698 20902 14028 15816 23420 Central Fresno County Fresno-Madera, CA California
1296 1296 6021 Glenn County, California 28047 1995 2099 2156 1922 1806 1874 1747 1729 1521 1531 1617 1852 1745 1424 1108 836 540 545          
2243 2243 6023 Humboldt County, California 136373 7251 7209 7394 8904 12667 9823 8311 9464 8373 7417 7069 8788 9323 9062 6364 3844 2377 2733 21700 Central Humboldt County   California
2790 2790 6025 Imperial County, California 181827 14889 14623 13986 13563 13089 14215 12697 12001 10202 10128 9995 9798 9061 7332 5780 4222 2996 3250 20940 Central Imperial County   California
406 406 6027 Inyo County, California 17987 1011 1083 1019 928 828 893 1063 1110 915 965 994 1461 1507 1316 1002 731 536 625          

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