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 descending

✎ 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
215 215 46137 Ziebach County, South Dakota 2742 159 182 263 288 213 163 133 215 190 175 146 232 120 87 63 47 32 34          
119 119 48507 Zavala County, Texas 11983 919 1055 963 968 1002 916 708 649 689 650 594 591 567 584 422 281 201 224          
3125 3125 48505 Zapata County, Texas 14190 1291 1380 1321 1131 1028 936 836 809 889 751 728 654 593 561 463 390 229 200 49820 Central Zapata County   Texas
940 940 8125 Yuma County, Colorado 10020 745 788 752 629 527 595 622 606 519 586 568 611 621 533 477 338 226 277          
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
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          
2152 2152 6115 Yuba County, California 78041 6187 6242 5894 5091 5510 6254 6024 5403 4388 4070 4187 4584 4252 3580 2628 1706 1086 955 49700 Central Yuba County Sacramento-Roseville, CA California
819 819 48503 Young County, Texas 18045 1097 1258 1251 1141 903 1020 1068 1028 973 1003 1085 1278 1269 1154 884 671 489 473          
2968 2968 51199 York County, Virginia 67846 3791 4480 4823 4721 4240 3872 4004 4716 4153 4214 4591 5078 4206 3330 2981 2118 1310 1218 47260 Central York County Virginia Beach-Norfolk, VA-NC Virginia
3062 3062 45091 York County, South Carolina 274118 16680 18884 19482 18468 15638 16847 17393 19179 18701 20328 18612 18274 16396 13708 10757 7135 4068 3568 16740 Outlying York County Charlotte-Concord, NC-SC South Carolina
2169 2169 42133 York County, Pennsylvania 448273 25487 27153 28936 27930 25659 28221 27577 27881 26077 30209 31297 32973 30657 25116 20046 13835 9306 9913 49620 Central York County Harrisburg-York-Lebanon, PA Pennsylvania
984 984 31185 York County, Nebraska 13772 902 888 938 894 862 842 807 789 700 701 750 961 938 831 652 471 394 452          
2237 2237 23031 York County, Maine 206229 9701 10289 11443 11603 10923 12502 12492 12073 11291 13324 14944 17140 16271 14156 10851 7191 4764 5271 38860 Central York County Portland-Lewiston-South Portland, ME Maine
2148 2148 6113 Yolo County, California 220408 12414 12852 13174 21335 30835 16479 13600 13905 12121 11799 11621 11811 10927 9021 6965 4711 3150 3688 40900 Outlying Yolo County Sacramento-Roseville, CA California
1081 1081 48501 Yoakum County, Texas 8591 764 785 830 693 562 519 561 548 495 421 445 502 449 319 256 197 128 117          
2893 2893 30111 Yellowstone County, Montana 160137 10023 10571 10944 9424 9381 11285 11001 10830 9303 9389 9340 10933 10596 8894 6804 4624 3148 3647 13740 Central Yellowstone County   Montana
742 742 27173 Yellow Medicine County, Minnesota 9795 611 630 695 594 541 512 562 555 483 521 594 745 771 558 403 355 268 397          
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
2207 2207 28163 Yazoo County, Mississippi 28248 1569 1722 1903 1588 1779 2519 2541 2560 1881 1653 1629 1604 1538 1176 942 662 468 514 27140 Outlying Yazoo County Jackson-Vicksburg-Brookhaven, MS Mississippi
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
2477 2477 36123 Yates County, New York 24841 1490 1564 1434 1763 1898 1421 1261 1224 1105 1306 1423 1850 1930 1722 1345 903 597 605 40380 Outlying Yates County Rochester-Batavia-Seneca Falls, NY New York
1996 1996 46135 Yankton County, South Dakota 22869 1380 1291 1390 1338 1473 1417 1456 1404 1285 1383 1458 1652 1631 1358 953 739 534 727 49460 Central Yankton County   South Dakota
929 929 37199 Yancey County, North Carolina 17903 822 823 1007 958 858 1018 880 912 971 1158 1226 1316 1347 1429 1196 866 635 481          
2841 2841 41071 Yamhill County, Oregon 107002 6121 6394 6939 7755 7395 6815 6751 7079 6725 6561 6376 6804 6950 6040 4760 3141 2067 2329 38900 Outlying Yamhill County Portland-Vancouver-Salem, OR-WA Oregon
451 451 28161 Yalobusha County, Mississippi 12392 759 729 829 711 646 840 627 687 690 814 772 861 953 817 663 444 316 234          
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          
2074 2074 53077 Yakima County, Washington 251446 20306 21085 21129 19005 16882 17994 15807 15489 14291 14171 13542 14221 13000 11277 8756 6092 3991 4408 49420 Central Yakima County   Washington
2633 2633 37197 Yadkin County, North Carolina 37543 1952 2159 2257 2241 2102 2170 1910 1983 2084 2713 2897 2932 2577 2302 1953 1497 933 881 49180 Outlying Yadkin County Greensboro--Winston-Salem--High Point, NC North Carolina
545 545 51197 Wythe County, Virginia 28754 1407 1525 1674 1628 1338 1624 1565 1605 1708 2063 2152 2105 2147 1984 1569 1200 777 683          
659 659 54109 Wyoming County, West Virginia 20786 992 1161 1261 1219 1059 1159 1013 1103 1446 1383 1349 1463 1767 1698 1135 710 478 390          
2051 2051 42131 Wyoming County, Pennsylvania 27046 1270 1359 1612 1651 1601 1524 1479 1455 1438 1805 1822 2169 2133 1847 1571 1115 597 598 42540 Outlying Wyoming County   Pennsylvania
998 998 36121 Wyoming County, New York 40085 1978 2088 2123 2142 2193 2861 2798 2598 2354 2779 3015 3065 2903 2511 1875 1255 781 766          
2062 2062 20209 Wyandotte County, Kansas 165324 13195 13071 12854 10722 10318 12908 12036 11593 9910 9666 9250 10188 9332 7221 4959 3380 2212 2509 28140 Central Wyandotte County Kansas City-Overland Park-Kansas City, MO-KS Kansas
1325 1325 39175 Wyandot County, Ohio 21935 1238 1337 1494 1345 1194 1188 1242 1386 1293 1369 1462 1563 1551 1298 1012 790 560 613          
822 822 29229 Wright County, Missouri 18378 1349 1181 1337 1230 923 1017 941 1046 921 1044 1154 1324 1281 1081 929 713 444 463          
1684 1684 27171 Wright County, Minnesota 136349 9406 10579 11504 9630 7081 7354 8664 9953 9412 9452 9431 9327 7341 5733 4500 3139 1909 1934 33460 Central Wright County Minneapolis-St. Paul, MN-WI Minnesota
613 613 19197 Wright County, Iowa 12690 812 787 901 822 606 656 614 697 676 640 696 915 984 831 619 481 405 548          
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          
629 629 29227 Worth County, Missouri 2040 108 119 107 125 97 106 106 96 93 95 136 170 177 132 109 93 79 92          
1551 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
2229 2229 13321 Worth County, Georgia 20299 1181 1254 1311 1221 1134 1309 1186 1097 1077 1290 1393 1556 1418 1246 1063 763 428 372 10500 Outlying Worth County   Georgia
1640 1640 25027 Worcester County, Massachusetts 830839 44667 47353 50552 56392 56477 54139 54236 51291 49041 56916 61455 62871 55471 43034 32491 21807 14782 17864 49340 Central Worcester County Boston-Worcester-Providence, MA-RI-NH-CT Massachusetts
1411 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
2801 2801 40153 Woodward County, Oklahoma 20222 1329 1432 1362 1299 1228 1454 1354 1481 1282 1179 1131 1309 1204 954 771 665 457 331 49260 Central Woodward County   Oklahoma
846 846 20207 Woodson County, Kansas 3183 168 181 194 196 133 160 168 211 138 147 195 263 256 263 178 124 83 125          
423 423 40151 Woods County, Oklahoma 8897 557 514 469 699 1040 724 596 518 401 389 457 527 484 440 338 264 221 259          
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          
2904 2904 21239 Woodford County, Kentucky 26533 1534 1595 1672 1697 1500 1368 1358 1593 1629 1738 1803 2138 1920 1783 1342 835 564 464 30460 Outlying Woodford County Lexington-Fayette--Richmond--Frankfort, KY Kentucky
2297 2297 17203 Woodford County, Illinois 38463 2209 2598 2740 2697 2207 2027 2038 2495 2249 2268 2503 2789 2683 2237 1553 1178 852 1140 37900 Central Woodford County Peoria-Canton, IL Illinois
2656 2656 19193 Woodbury County, Iowa 102539 7352 7314 7668 7494 6924 6792 6456 6607 5854 6087 5959 6462 6099 5243 3764 2663 1819 1982 43580 Central Woodbury County Sioux City-Vermillion, IA-SD-NE Iowa
2722 2722 55141 Wood County, Wisconsin 73055 4139 4362 4548 4144 3789 4043 4112 4216 3856 4324 4995 5983 5522 4590 3585 2665 1995 2187 49220 Central Wood County Wausau-Stevens Point-Wisconsin Rapids, WI Wisconsin
1913 1913 54107 Wood County, West Virginia 84203 4756 4756 5055 4742 4467 5075 4560 5085 4920 5508 5709 6254 6107 5384 4435 3316 2164 1910 37620 Central Wood County Parkersburg-Marietta-Vienna, WV-OH West Virginia
744 744 48499 Wood County, Texas 45129 2202 2341 2537 2685 2557 2248 2074 2171 2038 2438 2699 3330 3667 3642 3361 2465 1472 1202          
2942 2942 39173 Wood County, Ohio 130696 7065 7224 7745 11113 16073 8586 7354 7492 7019 7557 7339 8092 8039 6790 5001 3322 2351 2534 45780 Central Wood County Toledo-Port Clinton, OH Ohio
209 209 21237 Wolfe County, Kentucky 7177 442 416 485 439 351 394 376 441 449 419 510 571 496 467 376 250 166 129          
2726 2726 51195 Wise County, Virginia 38012 1980 2058 2124 2310 2489 2758 2377 2320 2352 2592 2436 2591 2694 2454 1768 1239 798 672 13720 Central Wise County   Virginia
2185 2185 48497 Wise County, Texas 68305 4291 4646 4969 4650 3713 4180 4237 4448 4059 4571 4695 5158 4498 3327 2854 1964 1169 876 19100 Outlying Wise County Dallas-Fort Worth, TX-OK Texas
2415 2415 54105 Wirt County, West Virginia 5830 290 361 388 309 261 287 318 317 352 368 409 490 500 381 328 230 148 93 37620 Outlying Wirt County Parkersburg-Marietta-Vienna, WV-OH West Virginia
832 832 28159 Winston County, Mississippi 18165 964 1072 1346 1150 954 1126 1043 1058 1062 1110 1089 1259 1304 1149 915 633 479 452          
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          
1829 1829 27169 Winona County, Minnesota 50825 2452 2414 2677 4625 7245 3089 2610 2746 2426 2545 2776 3277 3312 2844 2097 1430 1071 1189 49100 Central Winona County   Minnesota
697 697 19191 Winneshiek County, Iowa 20029 911 937 1176 1752 2042 859 904 1029 962 1028 1228 1493 1564 1252 928 730 558 676          
2766 2766 55139 Winnebago County, Wisconsin 171020 9464 9639 9923 11378 14775 11823 10867 10803 9782 10381 11153 12093 10917 9023 6726 4765 3549 3959 36780 Central Winnebago County Appleton-Oshkosh-Neenah, WI Wisconsin
1324 1324 19189 Winnebago County, Iowa 10518 582 669 659 722 710 526 573 554 531 595 577 754 803 682 474 386 300 421          
2309 2309 17201 Winnebago County, Illinois 284081 18087 18092 18784 18112 16961 18628 17144 17219 16062 17999 18314 20080 18780 15938 12637 8802 5949 6493 40420 Central Winnebago County Rockford-Freeport-Rochelle, IL Illinois
641 641 22127 Winn Parish, Louisiana 14134 855 779 813 803 806 1041 925 866 876 915 977 942 910 816 691 480 318 321          
582 582 48495 Winkler County, Texas 7720 584 665 639 618 509 522 511 495 492 453 454 455 374 291 274 153 127 104          
2867 2867 50027 Windsor County, Vermont 55286 2461 2694 2989 2853 2597 2920 3165 3214 2897 3262 3842 4631 4876 4242 3435 2270 1500 1438 17200 Central Windsor County   Vermont
1332 1332 50025 Windham County, Vermont 42756 1889 2059 2287 2405 2371 2314 2314 2410 2194 2459 2885 3687 3725 3503 2524 1594 994 1142          
2137 2137 9015 Windham County, Connecticut 117027 5736 6265 6799 8115 7700 7449 7542 7321 6728 7715 8491 9346 8402 6491 4995 3279 2192 2461 49340 Central Windham County Boston-Worcester-Providence, MA-RI-NH-CT Connecticut
2261 2261 51840 Winchester city, Virginia 28108 1873 1756 1750 2066 1978 2113 1801 1835 1598 1678 1736 1761 1697 1456 1144 734 562 570 49020 Central Winchester city Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Virginia
2680 2680 48493 Wilson County, Texas 50224 3016 3204 3502 3623 2850 2804 2916 3211 2925 3549 3525 3767 3299 2807 2073 1369 860 924 41700 Outlying Wilson County   Texas
2531 2531 47189 Wilson County, Tennessee 140625 8454 9158 9746 9115 7194 8238 8635 9844 9487 10209 9704 10030 8746 7634 6129 4020 2399 1883 34980 Central Wilson County Nashville-Davidson--Murfreesboro, TN Tennessee
2210 2210 37195 Wilson County, North Carolina 81455 4794 5149 5418 5385 4866 5186 4611 4665 4635 5201 5310 5773 5581 4849 3887 2635 1797 1713 48980 Central Wilson County Rocky Mount-Wilson-Roanoke Rapids, NC North Carolina
919 919 20205 Wilson County, Kansas 8665 544 590 584 557 404 458 464 513 421 504 475 602 695 581 474 342 206 251          
2271 2271 48491 Williamson County, Texas 566719 36855 40769 42726 38522 31363 36043 42897 47667 44804 42180 34555 32027 27323 23617 19239 12238 7344 6550 12420 Central Williamson County   Texas
2366 2366 47187 Williamson County, Tennessee 231729 13834 17088 20078 17992 11941 9778 11802 16177 17310 18671 16892 15847 13839 10740 8191 5011 3197 3341 34980 Central Williamson County Nashville-Davidson--Murfreesboro, TN Tennessee
2035 2035 17199 Williamson County, Illinois 67056 3970 4024 4193 3679 3389 4433 4376 4561 4100 4298 4175 4711 4434 3843 3439 2452 1571 1408 16060 Central Williamson County   Illinois
2612 2612 51830 Williamsburg city, Virginia 14896 492 479 435 2404 3176 961 798 620 483 512 602 740 762 723 617 463 349 280 47260 Outlying Williamsburg city Virginia Beach-Norfolk, VA-NC Virginia
175 175 45089 Williamsburg County, South Carolina 30606 1558 1665 1916 1878 1719 2021 1640 1683 1714 1908 1927 2133 2403 2205 1700 1150 694 692          
1188 1188 39171 Williams County, Ohio 36804 2177 2190 2477 2367 2049 2185 2109 2208 2101 2184 2331 2798 2700 2125 1673 1326 861 943          
2141 2141 38105 Williams County, North Dakota 35350 3405 2886 2570 2013 2284 3534 3205 2539 1985 1882 1835 2042 1782 1166 749 529 414 530 48780 Central Williams County   North Dakota
2041 2041 48489 Willacy County, Texas 21515 1381 1386 1465 1582 2069 1933 1533 1520 1320 1158 1097 1045 1011 923 756 581 350 405 39700 Central Willacy County Brownsville-Harlingen-Raymondville, TX Texas
2544 2544 17197 Will County, Illinois 692310 40589 45577 52705 52051 44514 41568 40688 46426 47132 52620 50810 47770 39454 30930 23800 16105 9762 9809 16980 Central Will County Chicago-Naperville, IL-IN-WI Illinois
1038 1038 28157 Wilkinson County, Mississippi 8792 465 516 563 485 544 725 650 575 473 474 555 622 632 536 331 280 162 204          
280 280 13319 Wilkinson County, Georgia 9036 506 575 612 563 490 495 495 543 434 523 629 698 722 523 428 365 243 192          
2288 2288 27167 Wilkin County, Minnesota 6254 382 377 401 396 328 287 338 388 339 372 408 550 488 344 270 224 185 177 47420 Outlying Wilkin County Fargo-Wahpeton, ND-MN Minnesota
1790 1790 37193 Wilkes County, North Carolina 68557 3461 3641 4179 4221 3668 3900 3513 3606 3966 4621 4804 5140 5060 4531 3959 2747 1879 1661 35900 Central Wilkes County   North Carolina
1186 1186 13317 Wilkes County, Georgia 9876 511 598 628 573 507 552 492 496 485 578 676 731 767 609 611 451 306 305          
770 770 13315 Wilcox County, Georgia 8812 482 451 473 448 592 664 654 619 601 607 579 529 522 463 410 309 205 204          
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          
2930 2930 48487 Wilbarger County, Texas 12820 752 753 782 883 815 851 896 766 716 770 715 914 852 691 613 427 308 316 46900 Central Wilbarger County   Texas
2311 2311 24045 Wicomico County, Maryland 103195 6255 6176 6362 9221 10033 6812 5614 5920 5364 5785 6155 6602 6498 5285 4333 2979 1813 1988 41540 Central Wicomico County   Maryland
2005 2005 48485 Wichita County, Texas 132064 8374 8574 8068 10256 11857 10516 9446 8369 6903 7025 7151 8325 7764 6085 4589 3428 2629 2705 48660 Central Wichita County   Texas
1199 1199 20203 Wichita County, Kansas 2105 117 186 144 165 109 108 95 107 122 130 101 138 157 130 91 69 59 77          
553 553 30109 Wibaux County, Montana 1034 64 65 55 62 50 40 48 69 49 45 71 81 84 85 51 43 39 33          
2955 2955 53075 Whitman County, Washington 49791 2116 2095 2002 6166 12192 4511 2826 2432 2097 1929 1855 2253 2136 1704 1302 922 569 684 39420 Central Whitman County Pullman-Moscow, WA-ID Washington
2270 2270 21235 Whitley County, Kentucky 36242 2824 2502 2387 2670 2797 2383 1980 2049 1991 2138 2293 2212 2237 1888 1479 1148 696 568 30940 Central Whitley County   Kentucky
2975 2975 18183 Whitley County, Indiana 34074 2074 2097 2305 2105 1864 2036 1986 1988 2058 2158 2158 2631 2490 2092 1546 1003 688 795 23060 Outlying Whitley County Fort Wayne-Huntington-Auburn, IN Indiana
2952 2952 13313 Whitfield County, Georgia 104062 6798 7296 8025 7515 6863 7327 6619 6666 6425 7056 6866 6413 5573 4624 3775 2788 1792 1641 19140 Central Whitfield County Chattanooga-Cleveland-Dalton, TN-GA-AL Georgia

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