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

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
1 1049 DeKalb County, Alabama 71385 4237 4692 5213 4796 4058 4542 3963 4256 4505 4839 4642 4755 4565 4030 3345 2279 1461 1207          
2 1027 Clay County, Alabama 13275 687 733 769 795 780 763 683 772 734 870 979 1012 947 852 673 541 373 312          
3 1019 Cherokee County, Alabama 26032 1206 1348 1482 1499 1304 1548 1206 1298 1471 1733 1857 2016 2084 1862 1683 1152 747 536          
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
5 31039 Cuming County, Nebraska 8940 596 551 654 611 503 428 451 478 453 434 565 625 626 500 434 344 297 390          
6 53069 Wahkiakum County, Washington 4426 137 230 229 265 174 183 169 181 193 227 285 323 406 443 418 267 164 132          
7 35011 De Baca County, New Mexico 1781 86 130 109 115 75 68 86 107 68 82 90 144 124 156 131 80 57 73          
8 31129 Nuckolls County, Nebraska 4195 214 206 251 249 203 192 193 235 188 205 228 333 361 304 285 195 157 196          
9 48327 Menard County, Texas 2139 91 107 120 103 87 103 81 97 87 106 113 183 182 170 181 139 81 108          
10 6091 Sierra County, California 2987 139 133 130 115 110 128 119 143 145 152 169 279 280 347 239 174 100 85          
11 21053 Clinton County, Kentucky 10206 612 622 636 626 526 647 537 595 570 660 712 756 717 626 526 415 256 167          
12 29083 Henry County, Missouri 21792 1294 1365 1309 1283 1074 1211 1222 1244 1096 1272 1403 1673 1608 1420 1267 912 577 562          
13 8109 Saguache County, Colorado 6843 398 358 457 404 269 286 297 372 391 328 461 558 692 651 461 245 115 100          
14 49033 Rich County, Utah 2464 188 210 206 182 145 126 139 145 133 123 118 141 165 152 108 84 36 63          
15 40001 Adair County, Oklahoma 22082 1637 1557 1677 1522 1311 1446 1220 1309 1317 1376 1422 1518 1258 1149 937 683 407 336          
16 35003 Catron County, New Mexico 3578 110 105 127 151 133 123 107 111 107 138 144 333 403 474 429 287 177 119          
17 1091 Marengo County, Alabama 19066 1209 1155 1228 1152 1106 1226 1070 1005 1078 1182 1239 1332 1347 1128 950 693 456 510          
18 56023 Lincoln County, Wyoming 19434 1312 1422 1549 1269 893 840 1061 1266 1263 1149 1078 1366 1590 1243 946 573 338 276          
19 29011 Barton County, Missouri 11798 674 705 846 800 672 685 553 724 604 653 722 859 878 711 599 469 297 347          
20 54075 Pocahontas County, West Virginia 8414 411 421 394 376 384 483 442 443 464 480 582 704 708 670 551 412 268 221          
21 31101 Keith County, Nebraska 8021 447 415 475 395 361 371 409 391 386 426 480 701 622 660 550 402 301 229          
22 31137 Phelps County, Nebraska 8996 534 621 600 584 494 487 509 507 462 517 562 689 566 500 426 335 277 326          
23 42053 Forest County, Pennsylvania 7279 152 147 182 445 659 728 563 459 381 468 452 499 499 463 481 340 219 142          
24 31109 Lancaster County, Nebraska 317272 20112 20394 20374 23538 35462 23479 20609 21364 18344 17439 16355 18105 17558 15634 11014 7136 4837 5518 30700 Central Lancaster County Lincoln-Beatrice, NE Nebraska
25 46099 Minnehaha County, South Dakota 192876 14858 14005 12978 11879 12259 15281 15392 14005 11408 11014 11105 12302 11161 9433 6080 3632 2690 3394 43620 Central Minnehaha County   South Dakota
26 39063 Hancock County, Ohio 75930 4542 4631 4733 5066 4740 5439 4952 4591 4245 4621 4806 5438 5014 4137 3292 2311 1656 1716 22300 Central Hancock County Findlay-Tiffin, OH Ohio
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
28 28017 Chickasaw County, Mississippi 17171 1134 1201 1206 1095 1116 1217 1017 1020 949 984 1086 1114 1074 936 730 529 414 349          
29 41063 Wallowa County, Oregon 7081 341 363 392 331 210 293 404 393 337 316 393 577 665 690 518 367 242 249          
30 26035 Clare County, Michigan 30757 1653 1639 1758 1628 1503 1701 1519 1529 1595 1721 2029 2492 2649 2464 1937 1391 844 705          
31 20157 Republic County, Kansas 4664 256 272 267 252 212 208 203 254 193 210 269 368 406 357 263 222 187 265          
32 5137 Stone County, Arkansas 12457 596 640 730 655 545 626 545 605 669 592 773 1013 1052 957 918 718 426 397          
33 20073 Greenwood County, Kansas 6055 337 335 402 358 281 221 279 303 319 327 379 511 494 456 384 285 160 224          
34 48177 Gonzales County, Texas 20826 1525 1504 1620 1545 1188 1312 1214 1212 1120 1195 1201 1410 1297 1020 872 701 480 410          
35 51167 Russell County, Virginia 26748 1273 1394 1468 1427 1311 1542 1352 1559 1602 1797 1866 2196 2188 1886 1500 1077 748 562          
36 48147 Fannin County, Texas 35286 1874 2066 2301 2097 2116 2376 2125 2242 2109 2297 2299 2521 2331 2030 1721 1217 853 711          
37 31181 Webster County, Nebraska 3533 169 242 230 200 188 203 147 189 172 201 212 292 278 229 180 149 125 127          
38 46067 Hutchinson County, South Dakota 7380 683 460 468 408 397 337 361 364 371 429 374 520 511 462 327 277 257 374          
39 17025 Clay County, Illinois 13253 798 851 874 772 679 839 692 776 721 799 835 988 936 845 677 465 341 365          
40 29103 Knox County, Missouri 3947 231 247 265 271 208 193 186 195 189 231 246 315 299 231 219 194 101 126          
41 29117 Livingston County, Missouri 15146 852 856 956 778 870 1073 1025 1025 1024 939 926 989 918 791 705 540 353 526          
42 42117 Tioga County, Pennsylvania 40763 2149 2227 2275 2598 2387 2306 2233 2233 1990 2463 2702 3147 3070 2693 2289 1785 1126 1090          
43 20039 Decatur County, Kansas 2871 163 168 138 144 118 141 165 123 121 112 188 213 269 219 156 133 109 191          
44 18123 Perry County, Indiana 19102 1032 1082 1218 1048 1121 1319 1184 1237 1121 1177 1214 1411 1348 1222 874 581 424 489          
45 28145 Union County, Mississippi 28606 1907 1948 2105 1834 1633 1900 1712 1811 1845 1842 1825 1793 1666 1501 1259 861 581 583          
46 31015 Boyd County, Nebraska 1955 88 107 100 114 105 73 77 85 84 89 107 176 152 177 131 110 69 111          
47 38099 Walsh County, North Dakota 10667 721 659 636 636 529 625 521 584 535 592 677 856 834 650 509 418 305 380          
48 39115 Morgan County, Ohio 14604 748 802 932 892 747 795 767 847 784 929 967 1174 1101 1013 719 573 451 363          
49 46101 Moody County, South Dakota 6579 504 466 461 433 360 313 321 409 355 338 404 532 449 398 283 229 151 173          
50 48247 Jim Hogg County, Texas 5248 423 418 493 427 287 280 322 301 320 236 286 289 243 271 258 185 130 79          
51 8017 Cheyenne County, Colorado 1876 131 155 124 113 81 89 106 118 90 91 113 147 133 142 73 65 39 66          
52 5113 Polk County, Arkansas 20049 1196 1220 1330 1269 999 1096 948 1040 1067 1197 1199 1453 1424 1418 1219 937 557 480          
53 13193 Macon County, Georgia 13143 666 679 666 774 892 1081 938 830 758 786 902 957 944 804 627 423 226 190          
54 21231 Wayne County, Kentucky 20468 1118 1177 1175 1144 1069 1256 1112 1175 1166 1383 1378 1483 1526 1387 1148 839 540 392          
55 47185 White County, Tennessee 27107 1605 1584 1721 1574 1378 1722 1546 1526 1578 1726 1909 1826 1918 1777 1407 1038 616 656          
56 51181 Surry County, Virginia 6474 265 280 322 335 321 351 362 289 286 386 532 668 609 476 407 270 165 150          
57 48391 Refugio County, Texas 7032 451 417 462 449 349 414 351 418 323 399 441 500 468 420 468 292 228 182          
58 8115 Sedgwick County, Colorado 2303 120 130 132 123 101 112 129 127 118 112 107 169 219 167 138 108 85 106          
59 30065 Musselshell County, Montana 4651 201 233 258 267 168 217 208 218 201 300 274 410 461 475 290 220 127 123          
60 46043 Douglas County, South Dakota 2935 223 196 197 195 122 138 148 132 120 124 175 218 240 189 161 113 96 148          
61 17185 Wabash County, Illinois 11549 729 721 716 679 570 761 656 681 612 637 648 866 886 767 543 412 290 375          
62 19053 Decatur County, Iowa 7890 508 444 487 709 933 389 353 387 353 381 358 492 512 458 376 277 207 266          
63 48127 Dimmit County, Texas 10308 775 868 876 766 637 638 626 613 603 525 544 575 533 525 441 296 204 263          
64 27073 Lac qui Parle County, Minnesota 6658 320 373 400 371 316 257 283 374 295 336 379 554 566 508 376 314 246 390          
65 13049 Charlton County, Georgia 12968 664 724 722 674 938 1121 980 868 813 886 857 904 745 610 565 415 254 228          
66 20147 Phillips County, Kansas 5317 304 331 348 346 248 263 256 304 244 281 296 419 406 415 302 203 156 195          
67 31089 Holt County, Nebraska 10178 717 748 727 567 509 481 504 556 475 477 575 850 795 666 490 405 282 354          
68 22021 Caldwell Parish, Louisiana 9960 621 596 667 618 551 684 622 599 624 669 603 673 664 561 474 330 219 185          
69 36003 Allegany County, New York 46430 2432 2569 2645 4418 4147 2284 2445 2385 2293 2524 2778 3328 3367 2922 2243 1523 1071 1056          
70 19031 Cedar County, Iowa 18627 979 1095 1241 1169 903 984 993 1178 1147 1123 1256 1522 1367 1163 838 607 470 592          
71 18117 Orange County, Indiana 19489 1155 1178 1263 1275 1078 1092 1039 1101 1104 1163 1314 1485 1434 1218 1029 692 450 419          
72 30015 Chouteau County, Montana 5745 291 323 459 395 285 327 343 331 323 296 286 448 467 411 283 181 149 147          
73 31017 Brown County, Nebraska 2973 131 181 189 195 144 125 133 125 165 165 167 237 240 230 163 148 110 125          
74 19027 Carroll County, Iowa 20154 1327 1406 1415 1204 1104 1044 1102 1114 1079 1067 1269 1489 1439 1221 827 703 594 750          
75 22107 Tensas Parish, Louisiana 4462 261 297 288 269 228 200 205 215 213 213 266 367 351 369 282 196 112 130          
76 47123 Monroe County, Tennessee 46357 2525 2537 2934 2764 2499 2827 2476 2490 2546 3028 3209 3353 3351 3248 2762 1915 1025 868          
77 20075 Hamilton County, Kansas 2607 198 244 200 178 142 181 177 164 140 151 147 176 144 125 87 77 44 32          
78 31171 Thomas County, Nebraska 720 43 50 48 42 26 33 44 28 39 43 39 36 62 71 41 33 21 21          
79 17009 Brown County, Illinois 6556 289 291 297 288 552 681 600 543 466 451 434 403 348 281 218 174 109 131          
80 8027 Custer County, Colorado 4954 163 184 186 219 167 202 167 216 197 246 267 510 636 678 467 231 129 89          
81 29123 Madison County, Missouri 12188 730 802 818 724 609 781 675 682 694 787 804 874 878 700 577 470 294 289          
82 42127 Wayne County, Pennsylvania 51276 2182 2235 2391 2637 2628 2849 2874 2884 2751 3370 3639 4273 4176 4040 3333 2272 1449 1293          
83 40095 Marshall County, Oklahoma 16806 995 1072 1140 1050 921 890 812 930 964 965 1026 1190 1201 1028 975 748 494 405          
84 54103 Wetzel County, West Virginia 15270 814 785 911 825 857 872 708 819 807 1034 1009 1204 1105 1019 885 712 491 413          
85 55053 Jackson County, Wisconsin 20478 1205 1190 1260 1207 1102 1311 1192 1263 1108 1276 1411 1586 1482 1279 993 691 493 429          
86 19151 Pocahontas County, Iowa 6740 392 419 457 406 318 331 336 349 329 310 414 560 567 450 342 296 219 245          
87 13119 Franklin County, Georgia 23023 1361 1379 1373 1598 1535 1500 1351 1208 1261 1396 1509 1614 1562 1359 1199 810 540 468          
88 13265 Taliaferro County, Georgia 1608 66 91 73 65 81 89 84 80 95 84 123 130 124 130 110 70 44 69          
89 30059 Meagher County, Montana 1866 98 112 96 84 71 78 81 88 89 99 90 135 172 202 157 89 54 71          
90 30087 Rosebud County, Montana 9063 761 713 731 651 516 553 517 454 453 513 509 627 634 521 388 217 166 139          
91 35059 Union County, New Mexico 4118 193 223 226 198 230 324 289 298 248 260 206 272 289 238 223 149 128 124          
92 26153 Schoolcraft County, Michigan 8068 323 389 410 395 373 335 304 358 395 504 518 784 818 716 533 386 268 259          
93 20199 Wallace County, Kansas 1503 119 94 97 107 74 71 81 74 62 59 87 117 111 99 84 48 47 72          
94 26003 Alger County, Michigan 9097 333 354 394 449 483 505 513 537 487 492 608 767 840 803 595 422 273 242          
95 5049 Fulton County, Arkansas 12269 601 656 787 722 585 559 546 610 583 735 782 920 962 964 816 654 410 377          
96 26123 Newaygo County, Michigan 48892 2854 2889 3303 2990 2572 3000 2675 2697 2567 2850 3344 4038 3756 3155 2352 1750 1128 972          
97 27153 Todd County, Minnesota 24582 1663 1656 1580 1440 1306 1192 1193 1362 1201 1312 1530 1918 1935 1634 1311 1011 628 710          
98 5083 Logan County, Arkansas 21737 1310 1177 1326 1397 1178 1303 1162 1186 1240 1437 1596 1643 1467 1352 1105 855 541 462          
99 8111 San Juan County, Colorado 762 28 25 31 21 27 54 44 53 57 49 51 62 82 57 61 30 18 12          
100 48413 Schleicher County, Texas 2895 150 189 252 238 136 157 190 194 144 174 161 179 164 201 152 110 55 49          

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