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

✎ 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
201 201 17135 Montgomery County, Illinois 28601 1451 1598 1676 1564 1624 1856 1689 1886 1623 1780 1920 2111 2059 1748 1273 1039 763 941          
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          
203 203 17055 Franklin County, Illinois 38701 2345 2297 2408 2326 2029 2296 2107 2253 2283 2452 2570 2735 2668 2383 2051 1561 986 951          
204 204 30033 Garfield County, Montana 1268 74 85 78 64 68 59 57 103 64 69 66 78 108 99 70 64 40 22          
205 205 1057 Fayette County, Alabama 16433 921 957 1002 941 951 1015 871 906 906 1088 1039 1196 1168 1090 897 698 447 340          
206 206 21087 Green County, Kentucky 11049 609 621 672 631 570 606 518 665 631 708 843 896 799 733 580 434 285 248          
207 207 18047 Franklin County, Indiana 22736 1344 1322 1563 1532 1254 1204 1181 1314 1345 1507 1625 1721 1637 1449 1011 759 494 474          
208 208 26071 Iron County, Michigan 11117 483 510 516 521 441 442 431 520 513 544 680 985 1129 1076 805 572 389 560          
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          
210 210 48149 Fayette County, Texas 25349 1270 1390 1559 1395 1291 1240 1185 1390 1268 1340 1515 2015 2060 1919 1579 1216 823 894          
211 211 23029 Washington County, Maine 31490 1499 1585 1793 1758 1607 1533 1492 1624 1635 1871 2052 2595 2759 2496 2067 1434 885 805          
212 212 48045 Briscoe County, Texas 1516 65 85 90 82 76 69 92 82 96 84 97 111 90 102 112 74 62 47          
213 213 26131 Ontonagon County, Michigan 5795 154 177 257 236 190 145 169 210 221 319 414 572 634 678 533 405 290 191          
214 214 27133 Rock County, Minnesota 9414 574 651 751 648 468 485 485 528 575 537 520 665 660 528 426 324 256 333          
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          
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          
217 217 40015 Caddo County, Oklahoma 28977 1993 2072 1956 1956 1693 2032 1854 1834 1565 1737 1729 1922 1753 1460 1255 940 641 585          
218 218 48383 Reagan County, Texas 3741 291 325 312 259 264 225 248 278 268 209 220 211 211 143 99 70 62 46          
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          
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          
221 221 36041 Hamilton County, New York 4434 116 151 182 190 192 182 155 204 181 248 325 420 502 497 363 244 127 155          
222 222 48083 Coleman County, Texas 8397 436 481 521 512 375 393 383 421 450 474 492 692 671 626 576 361 300 233          
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          
224 224 48357 Ochiltree County, Texas 9947 858 833 958 781 635 631 637 595 652 567 557 595 540 367 293 219 116 113          
225 225 48103 Crane County, Texas 4794 382 404 398 362 316 325 299 311 294 272 281 318 260 177 131 101 83 80          
226 226 56003 Big Horn County, Wyoming 11881 746 812 916 797 597 576 662 678 636 638 690 785 853 795 641 485 292 282          
227 227 29081 Harrison County, Missouri 8414 537 538 627 517 376 436 451 463 415 437 502 592 633 520 427 361 253 329          
228 228 29067 Douglas County, Missouri 13373 756 810 868 711 584 636 687 708 651 727 820 1040 1121 1016 823 634 412 369          
229 229 38009 Bottineau County, North Dakota 6411 348 385 400 402 348 343 311 349 297 308 369 499 523 516 376 258 170 209          
230 230 56017 Hot Springs County, Wyoming 4555 232 267 303 245 178 200 247 244 219 238 248 348 392 341 301 220 183 149          
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          
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          
233 233 42023 Cameron County, Pennsylvania 4492 211 219 198 228 205 214 185 212 204 258 317 395 423 370 315 220 132 186          
234 234 27161 Waseca County, Minnesota 18691 1054 1177 1333 1207 1039 1104 1166 1267 1133 1142 1143 1259 1267 1128 803 561 389 519          
235 235 46015 Brule County, South Dakota 5229 346 382 409 355 263 257 259 310 264 278 328 387 399 339 174 171 130 178          
236 236 17023 Clark County, Illinois 15596 919 995 997 967 804 857 865 952 855 973 1039 1187 1089 956 750 605 345 441          
237 237 21201 Robertson County, Kentucky 2135 108 120 138 116 115 117 105 95 130 132 165 178 156 121 118 100 55 66          
238 238 47095 Lake County, Tennessee 7411 289 291 261 353 628 763 617 532 547 522 516 466 460 374 286 208 159 139          
239 239 48333 Mills County, Texas 4921 223 235 367 295 223 213 189 231 233 270 319 358 359 415 339 288 159 205          
240 240 16049 Idaho County, Idaho 16513 776 943 936 933 763 690 735 843 768 834 918 1293 1475 1479 1243 861 523 500          
241 241 20115 Marion County, Kansas 11950 610 735 729 833 803 556 572 630 541 600 733 907 918 767 641 497 366 512          
242 242 27033 Cottonwood County, Minnesota 11277 773 735 770 698 632 520 555 610 576 593 667 786 790 703 586 455 374 454          
243 243 13291 Union County, Georgia 24001 894 950 1237 1133 1041 1020 946 1028 1031 1217 1457 1956 2168 2441 2215 1540 926 801          
244 244 48403 Sabine County, Texas 10589 524 498 597 552 459 479 464 466 422 526 622 881 865 914 887 670 406 357          
245 245 39131 Pike County, Ohio 28067 1727 1732 1916 1857 1555 1728 1441 1658 1730 1838 1923 2047 1906 1587 1265 906 614 637          
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          
247 247 28097 Montgomery County, Mississippi 10023 598 628 655 568 530 667 492 547 487 547 672 752 711 632 593 422 243 279          
248 248 31087 Hitchcock County, Nebraska 2806 152 164 214 160 119 115 125 202 128 154 129 222 211 228 149 128 94 112          
249 249 31131 Otoe County, Nebraska 15985 1053 1039 1102 987 854 818 903 927 892 933 1010 1191 1166 879 710 550 391 580          
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          
251 251 16077 Power County, Idaho 7768 656 699 687 595 464 483 455 397 405 345 420 487 476 417 290 236 127 129          
252 252 56043 Washakie County, Wyoming 7885 406 452 560 553 352 363 416 487 440 460 518 567 601 517 420 321 210 242          
253 253 55123 Vernon County, Wisconsin 30785 2132 2229 2275 2072 1448 1393 1512 1685 1581 1688 1972 2397 2390 1999 1450 1034 691 837          
254 254 29093 Iron County, Missouri 10177 529 553 645 605 497 538 512 608 610 628 678 812 785 694 537 404 286 256          
255 255 48225 Houston County, Texas 23169 1214 1281 1365 1164 1108 1398 1311 1515 1457 1513 1554 1591 1599 1478 1290 946 736 649          
256 256 39111 Monroe County, Ohio 13790 696 791 790 784 652 718 727 742 720 885 945 1048 1049 1026 805 630 417 365          
257 257 20165 Rush County, Kansas 3093 167 170 192 184 147 138 146 150 168 170 189 239 265 223 167 115 116 147          
258 258 20187 Stanton County, Kansas 1987 138 151 139 162 109 97 111 119 124 117 109 123 138 95 83 56 55 61          
259 259 21129 Lee County, Kentucky 7033 406 330 379 360 374 476 461 447 429 477 580 566 512 461 357 191 133 94          
260 260 27071 Koochiching County, Minnesota 12440 550 598 671 745 522 613 579 624 617 697 855 1005 1185 1060 747 548 435 389          
261 261 40097 Mayes County, Oklahoma 41107 2442 2636 2810 2692 2358 2613 2292 2504 2412 2510 2575 2848 2839 2402 2066 1498 907 703          
262 262 27165 Watonwan County, Minnesota 10980 767 750 712 712 686 573 567 643 592 545 646 781 815 601 442 412 311 425          
263 263 22053 Jefferson Davis Parish, Louisiana 31582 2194 2212 2346 2083 1855 2056 1931 1970 1739 1835 1940 2251 2011 1608 1247 974 701 629          
264 264 40029 Coal County, Oklahoma 5520 384 331 394 335 305 361 258 274 341 290 324 393 409 330 301 203 140 147          
265 265 30011 Carter County, Montana 1238 91 76 54 50 54 67 80 63 46 40 73 107 118 98 64 59 46 52          
266 266 48461 Upton County, Texas 3671 297 319 285 267 180 240 268 231 230 199 185 198 256 148 123 102 71 72          
267 267 18051 Gibson County, Indiana 33452 2099 2192 2258 2038 1913 2074 1923 2088 1893 2135 2209 2457 2297 1872 1423 1053 709 819          
268 268 31105 Kimball County, Nebraska 3618 218 213 211 222 168 180 178 190 173 191 217 294 280 225 209 188 124 137          
269 269 8113 San Miguel County, Colorado 8191 326 391 469 368 380 636 662 586 616 681 639 607 629 558 358 159 65 61          
270 270 28019 Choctaw County, Mississippi 8278 469 486 555 471 427 489 470 447 452 506 545 618 558 530 456 342 254 203          
271 271 29079 Grundy County, Missouri 9914 725 643 640 631 543 641 586 497 454 504 574 682 654 581 476 444 294 345          
272 272 26085 Lake County, Michigan 11881 524 523 565 485 480 496 481 536 543 710 771 1094 1272 1207 882 608 420 284          
273 273 17059 Gallatin County, Illinois 5058 262 282 322 280 225 277 263 300 296 339 321 378 335 343 322 249 165 99          
274 274 47075 Haywood County, Tennessee 17335 961 1035 1153 1090 980 1029 957 1031 1003 987 1201 1281 1328 1178 791 549 368 413          
275 275 28139 Tippah County, Mississippi 21995 1402 1441 1611 1489 1446 1444 1181 1355 1295 1403 1479 1502 1310 1182 1013 676 428 338          
276 276 54035 Jackson County, West Virginia 28706 1536 1645 1824 1653 1519 1603 1495 1674 1646 1924 1990 2203 2138 1796 1432 1083 865 680          
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          
278 278 29163 Pike County, Missouri 18504 1135 1148 1107 1013 1163 1363 1220 1193 1093 1192 1194 1273 1198 965 819 639 393 396          
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          
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          
281 281 19039 Clarke County, Iowa 9423 665 681 715 577 476 518 552 565 522 515 565 679 650 561 401 295 214 272          
282 282 19065 Fayette County, Iowa 19660 1076 1110 1217 1283 1250 1155 1027 1021 934 1009 1291 1549 1511 1245 947 776 594 665          
283 283 12043 Glades County, Florida 13724 427 570 676 649 663 920 866 874 820 877 835 868 935 927 1021 868 547 381          
284 284 8023 Costilla County, Colorado 3828 173 194 215 213 181 185 184 183 158 179 248 282 388 320 299 195 130 101          
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          
286 286 6043 Mariposa County, California 17471 750 786 787 763 824 993 876 891 777 876 1095 1499 1672 1550 1289 922 577 544          
287 287 29089 Howard County, Missouri 10137 602 613 633 791 808 538 573 595 471 536 590 723 711 642 438 353 255 265          
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          
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          
290 290 31127 Nemaha County, Nebraska 6958 411 430 423 559 524 389 419 442 307 316 387 469 485 457 323 229 181 207          
291 291 25019 Nantucket County, Massachusetts 11327 728 663 670 510 596 737 869 871 830 877 800 785 711 604 407 262 188 219          
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          
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          
294 294 26143 Roscommon County, Michigan 23884 854 954 1071 998 881 970 950 948 934 1241 1509 2103 2698 2501 2125 1501 957 689          
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          
296 296 19037 Chickasaw County, Iowa 11964 720 766 832 737 644 598 551 700 615 645 788 937 946 753 582 442 344 364          
297 297 19081 Hancock County, Iowa 10712 606 579 714 661 551 538 555 605 602 567 614 869 844 742 537 387 340 401          
298 298 42057 Fulton County, Pennsylvania 14523 753 764 861 843 773 778 740 770 874 998 1090 1078 1071 918 856 650 402 304          
299 299 48237 Jack County, Texas 8843 484 555 544 583 601 649 585 545 516 555 606 602 504 472 410 284 206 142          
300 300 40055 Greer County, Oklahoma 5821 283 346 305 349 357 466 459 414 391 366 385 365 299 271 239 195 155 176          

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