Data source: Big Local News · About: big-local-datasette

926 rows sorted by pop2018_tot

View and edit SQL

Link rowid CBSA_Code CBSA_Title MSAtype pop2018_tot ▼ pop2018_0to4 pop2018_5to9 pop2018_10to14 pop2018_15to19 pop2018_20to24 pop2018_25to29 pop2018_30to34 pop2018_35to39 pop2018_40to44 pop2018_45to49 pop2018_50to54 pop2018_55to59 pop2018_60to64 pop2018_65to69 pop2018_70to74 pop2018_75to79 pop2018_80to84 pop2018_85plus
862 46780 Van Wert, OH Micropolitan Statistical Area 28281 1784 1712 1911 1781 1617 1734 1499 1748 1605 1711 1783 2026 2004 1660 1314 969 670 753
21 10980 Alpena, MI Micropolitan Statistical Area 28360 1348 1409 1513 1564 1379 1586 1403 1604 1470 1628 1923 2400 2486 2044 1617 1236 853 897
533 32700 McPherson, KS Micropolitan Statistical Area 28537 1601 1801 1935 1948 1745 1680 1658 1759 1542 1473 1604 2120 2011 1666 1275 945 684 1090
299 22820 Fort Morgan, CO Micropolitan Statistical Area 28558 2113 2150 1989 1887 1814 1969 2007 1789 1564 1629 1644 1815 1766 1334 1036 767 577 708
886 47920 Washington Court House, OH Micropolitan Statistical Area 28666 1704 1886 2000 1720 1591 1797 1652 1706 1700 1960 1859 2078 1922 1699 1292 998 614 488
363 25700 Hays, KS Micropolitan Statistical Area 28710 1708 1795 1714 2158 3733 2070 1785 1692 1454 1401 1417 1627 1740 1436 997 712 579 692
257 21180 Elkins, WV Micropolitan Statistical Area 28823 1455 1487 1528 1612 1702 1884 1662 1678 1586 1835 1935 2116 2036 1965 1655 1228 732 727
550 33420 Mineral Wells, TX Micropolitan Statistical Area 28875 1771 1897 1914 1803 1736 1818 1635 1509 1508 1686 1770 2102 2087 1766 1598 1067 630 578
134 15780 Camden, AR Micropolitan Statistical Area 28883 1565 1755 1917 1658 1513 1676 1598 1582 1510 1754 1845 2260 2303 1998 1435 1021 717 776
483 30660 Lincoln, IL Micropolitan Statistical Area 28925 1529 1469 1591 1888 2080 2026 1964 2021 1766 1717 1738 1977 1874 1611 1188 940 714 832
894 48220 Weatherford, OK Micropolitan Statistical Area 29036 2075 2084 1911 2387 3620 1941 1775 1870 1368 1440 1344 1710 1493 1179 1033 709 498 599
496 31220 Ludington, MI Micropolitan Statistical Area 29100 1499 1613 1749 1599 1402 1635 1480 1601 1453 1599 1821 2282 2513 2297 1669 1274 822 792
432 28380 Kennett, MO Micropolitan Statistical Area 29423 2000 2166 2119 1911 1600 1745 1527 1639 1683 1742 1818 2025 1940 1657 1376 1057 711 707
398 27020 Iron Mountain, MI-WI Micropolitan Statistical Area 29704 1556 1535 1636 1589 1469 1488 1573 1660 1446 1658 2132 2543 2688 2067 1669 1166 818 1011
417 27700 Jesup, GA Micropolitan Statistical Area 29808 1928 1975 2119 1875 1674 2053 1948 1969 1845 1984 1945 1965 1806 1553 1312 862 528 467
443 28860 Kirksville, MO Micropolitan Statistical Area 29938 1642 1503 1656 3162 5250 1749 1403 1399 1218 1467 1525 1699 1600 1374 1163 893 580 655
500 31380 Macomb, IL Micropolitan Statistical Area 29955 1329 1409 1465 2834 4666 1888 1633 1544 1359 1467 1458 1783 1836 1664 1263 894 608 855
379 26260 Hope, AR Micropolitan Statistical Area 30067 2049 2169 2112 1860 1604 1813 1562 1668 1696 1722 1929 2175 2085 1680 1405 1111 711 716
736 41260 St. Marys, PA Micropolitan Statistical Area 30169 1522 1582 1664 1669 1581 1449 1510 1530 1512 2078 2349 2590 2493 2027 1530 1242 895 946
780 43260 Sheridan, WY Micropolitan Statistical Area 30233 1661 1783 1923 1845 1636 1716 1779 1831 1759 1755 1699 2097 2402 2244 1601 1119 630 753
855 46460 Union City, TN Micropolitan Statistical Area 30267 1712 1821 1834 1857 1661 1865 1596 1766 1767 2006 1918 2113 2172 1889 1650 1184 766 690
12 10660 Albert Lea, MN Micropolitan Statistical Area 30444 1725 1845 1945 1751 1492 1671 1674 1809 1595 1602 1902 2440 2251 1867 1629 1196 985 1065
149 16420 Central City, KY Micropolitan Statistical Area 30774 1729 1641 1837 1958 1949 1967 1768 1871 1929 1970 2016 2179 2075 1802 1592 1129 724 638
821 45000 Susanville, CA Micropolitan Statistical Area 30802 1533 1454 1439 1515 2364 2999 2706 2361 2134 2062 1882 1850 1836 1633 1257 740 467 570
110 14720 Breckenridge, CO Micropolitan Statistical Area 31007 1404 1363 1449 1234 1722 3378 2919 2456 2206 2326 2050 2108 2157 1833 1245 714 262 181
541 33060 Miami, OK Micropolitan Statistical Area 31175 2002 2193 2151 2315 2045 2049 1667 1768 1686 1811 1810 1989 1969 1693 1536 1081 724 686
874 47340 Wabash, IN Micropolitan Statistical Area 31280 1661 1692 1892 2315 2099 1747 1567 1723 1702 1887 1954 2291 2224 1858 1561 1146 902 1059
169 17380 Cleveland, MS Micropolitan Statistical Area 31333 2074 2232 2109 2265 2345 2340 2036 1917 1586 1781 1821 1991 1885 1758 1339 876 476 502
361 25580 Hastings, NE Micropolitan Statistical Area 31511 2085 2035 2069 2378 2351 1947 1773 1725 1702 1658 1800 2164 2088 1845 1363 1003 665 860
441 28780 Kingsville, TX Micropolitan Statistical Area 31571 2133 2085 2085 2984 4746 2491 1951 1847 1423 1545 1399 1361 1423 1161 1126 759 535 517
416 27660 Jennings, LA Micropolitan Statistical Area 31582 2194 2212 2346 2083 1855 2056 1931 1970 1739 1835 1940 2251 2011 1608 1247 974 701 629
83 13620 Berlin, NH Micropolitan Statistical Area 31589 1256 1312 1557 1560 1648 1815 1674 1687 1729 2102 2333 2639 2783 2524 1828 1294 856 992
228 19860 Dickinson, ND Micropolitan Statistical Area 31916 2748 2393 2194 1803 1814 2831 2602 2371 1625 1598 1714 2032 1781 1295 961 679 602 873
132 15700 Cambridge, MD Micropolitan Statistical Area 31998 1748 1832 1983 1732 1595 2083 1817 1637 1644 1862 2175 2520 2459 2132 1833 1287 800 859
463 29780 Las Vegas, NM Micropolitan Statistical Area 32097 1499 1576 1594 2284 2030 1963 1699 1707 1551 1896 1964 2546 2500 2422 1917 1370 861 718
422 27940 Juneau, AK Micropolitan Statistical Area 32113 1843 1888 1893 1964 2000 2374 2478 2375 2051 2144 2153 2427 2225 1776 1205 638 351 328
176 17700 Coffeyville, KS Micropolitan Statistical Area 32120 1982 2176 2238 2290 1738 1771 1861 1835 1612 1779 1894 2298 2257 1913 1553 1216 786 921
503 31500 Madison, IN Micropolitan Statistical Area 32208 1841 1718 1803 2149 2329 2010 1778 1955 1888 2058 2182 2438 2263 1945 1525 1082 603 641
304 23140 Frankfort, IN Micropolitan Statistical Area 32250 2270 2228 2459 2237 1798 2028 1941 1899 1852 1967 1932 2233 2027 1686 1237 917 689 850
647 37540 Paris, TN Micropolitan Statistical Area 32358 1683 1744 2030 1822 1600 1785 1619 1759 1737 1975 2203 2483 2392 2319 2070 1449 925 763
402 27160 Jackson, OH Micropolitan Statistical Area 32384 2080 2110 2189 2005 1739 2112 1965 1980 1939 2085 2122 2188 2268 1942 1476 969 640 575
76 13300 Beeville, TX Micropolitan Statistical Area 32587 1895 1868 1956 2124 2704 2919 2769 2688 2256 2180 1889 1771 1556 1264 1059 716 530 443
572 34350 Mount Gay-Shamrock, WV Micropolitan Statistical Area 32607 1760 1889 1830 1823 1693 1966 1684 1956 2235 2228 2095 2169 2678 2487 1706 1060 766 582
829 45380 Taylorville, IL Micropolitan Statistical Area 32661 1656 1780 2004 1811 1885 2030 1951 2013 1870 2097 2246 2466 2341 1925 1518 1217 866 985
828 45340 Taos, NM Micropolitan Statistical Area 32835 1448 1517 1753 1718 1524 1638 1662 1852 1787 1912 2119 2485 2732 3004 2344 1528 942 870
215 19420 Dayton, TN Micropolitan Statistical Area 33044 1954 1944 2255 2219 2098 2030 1842 1885 1845 2175 2237 2215 2196 2003 1662 1187 684 613
883 47780 Washington, IN Micropolitan Statistical Area 33147 2693 2715 2729 2357 1972 2233 1953 1974 1768 1765 1858 2104 1946 1643 1252 925 630 630
844 45980 Troy, AL Micropolitan Statistical Area 33338 1788 1792 1725 2929 5640 2494 1584 1752 1560 1718 1651 1870 1848 1502 1375 904 641 565
185 18100 Columbus, NE Micropolitan Statistical Area 33363 2444 2424 2423 2210 1956 2005 2018 2070 1832 1752 1945 2309 2248 1766 1300 993 764 904
654 37800 Pella, IA Micropolitan Statistical Area 33407 1954 2140 2383 2566 2375 1774 1819 2004 1896 1947 2102 2375 2115 1850 1412 1088 810 797
523 32280 Martin, TN Micropolitan Statistical Area 33415 1699 1819 1795 2569 3891 2119 1635 1727 1690 1972 2046 2167 2058 1954 1573 1114 779 808
475 30280 Lewisburg, TN Micropolitan Statistical Area 33683 2078 2117 2261 2203 1768 2282 2070 2139 2111 2337 2344 2357 2186 1873 1488 959 555 555
508 31680 Malvern, AR Micropolitan Statistical Area 33701 1716 1844 2063 2018 1962 2355 2027 2069 2110 2210 2243 2397 2318 2075 1697 1185 727 685
667 38380 Plainview, TX Micropolitan Statistical Area 33830 2258 2677 2674 2670 2723 2450 2281 2178 1817 1919 1924 1931 1783 1377 1097 875 598 598
230 19980 Dodge City, KS Micropolitan Statistical Area 33888 3011 2929 2752 2578 2426 2538 2143 2177 1950 1958 1962 1996 1676 1212 870 588 486 636
888 47980 Watertown, SD Micropolitan Statistical Area 34126 2310 2380 2587 2139 1946 2157 1986 2121 1903 1928 2034 2410 2323 1811 1351 995 794 951
115 15020 Brookhaven, MS Micropolitan Statistical Area 34205 2079 2232 2388 2142 1907 2245 1900 2264 2103 2294 2134 2353 2283 1956 1481 1078 687 679
249 20820 Effingham, IL Micropolitan Statistical Area 34208 2277 2279 2257 2008 1942 2361 2126 2080 1805 1861 2228 2619 2322 1875 1407 1161 763 837
113 14820 Brevard, NC Micropolitan Statistical Area 34215 1406 1425 1556 1744 1790 1651 1610 1621 1741 1832 1977 2521 2896 2881 2740 2137 1356 1331
229 19940 Dixon, IL Micropolitan Statistical Area 34223 1707 1895 1994 1833 1851 2213 2116 2167 2003 2193 2366 2667 2510 2094 1680 1135 858 941
771 42900 Seneca Falls, NY Micropolitan Statistical Area 34300 1768 1846 1962 1937 2279 2434 2208 2012 1797 2084 2187 2637 2558 2149 1737 1124 761 820
30 11420 Angola, IN Micropolitan Statistical Area 34586 1976 1842 2012 2393 2405 1912 1745 1727 1765 2181 2410 2583 2652 2394 1863 1236 802 688
404 27220 Jackson, WY-ID Micropolitan Statistical Area 34721 1860 2108 2057 1663 1617 2611 2799 2997 2717 2644 2174 2203 2256 1966 1378 787 443 441
466 29900 Laurinburg, NC Micropolitan Statistical Area 34810 2210 2171 2271 2158 2417 2441 1894 2010 1929 2263 2082 2320 2275 2109 1707 1107 708 738
25 11140 Americus, GA Micropolitan Statistical Area 34969 2066 2207 2397 2711 3266 2225 1848 1935 1848 2137 2248 2206 1999 1914 1635 1041 667 619
128 15580 Butte-Silver Bow, MT Micropolitan Statistical Area 34993 2017 1975 1955 2034 3140 2350 1953 2072 1792 1873 2092 2519 2554 2208 1569 1258 785 847
112 14780 Brenham, TX Micropolitan Statistical Area 35108 2038 2183 2128 2793 2104 1789 1904 1854 1839 1886 2020 2438 2520 2197 1823 1413 933 1246
633 36900 Ottumwa, IA Micropolitan Statistical Area 35205 2284 2159 2206 2155 2213 2443 2126 2163 1986 2069 2092 2480 2492 2007 1500 1136 808 886
910 49060 Winfield, KS Micropolitan Statistical Area 35218 2154 2367 2368 2609 2331 2120 2143 2080 1958 2009 2046 2389 2224 1898 1650 1114 811 947
117 15100 Brookings, SD Micropolitan Statistical Area 35232 2237 1936 1948 3889 6228 2687 2130 1982 1582 1537 1514 1654 1713 1429 973 700 515 578
100 14300 Bonham, TX Micropolitan Statistical Area 35286 1874 2066 2301 2097 2116 2376 2125 2242 2109 2297 2299 2521 2331 2030 1721 1217 853 711
904 48780 Williston, ND Micropolitan Statistical Area 35350 3405 2886 2570 2013 2284 3534 3205 2539 1985 1882 1835 2042 1782 1166 749 529 414 530
864 46860 Vernal, UT Micropolitan Statistical Area 35438 3031 3353 3504 2736 1878 2438 2518 2862 2308 1795 1580 1831 1749 1330 982 666 451 426
657 37940 Peru, IN Micropolitan Statistical Area 35567 1844 1953 2291 2190 2147 2447 2238 2296 2349 2371 2383 2515 2254 2043 1651 1167 665 763
82 13540 Bennington, VT Micropolitan Statistical Area 35631 1670 1800 2013 2288 2237 1777 1709 1805 1706 2128 2501 2937 2898 2552 2042 1465 958 1145
219 19540 Decatur, IN Micropolitan Statistical Area 35636 3327 3153 2943 2614 2126 2261 1885 1940 1879 1882 1974 2061 2067 1635 1342 929 714 904
470 30060 Lebanon, MO Micropolitan Statistical Area 35713 2482 2326 2561 2212 1940 2138 2039 2167 1959 2263 2348 2584 2321 1955 1673 1229 821 695
674 38700 Pontiac, IL Micropolitan Statistical Area 35761 1934 2082 2224 2193 2142 2299 2203 2137 2032 2090 2331 2691 2535 2111 1536 1229 841 1151
599 35460 Newport, TN Micropolitan Statistical Area 35774 1889 1969 2130 1930 1854 2088 1857 1893 2025 2457 2583 2783 2780 2479 2132 1418 874 633
266 21540 Escanaba, MI Micropolitan Statistical Area 35857 1782 1967 1998 2067 1697 1816 1685 1960 1838 2074 2332 2873 3103 2877 2039 1454 1085 1210
392 26780 Hutchinson, MN Micropolitan Statistical Area 35873 2105 2224 2387 2275 2019 2134 2177 2172 1988 2316 2383 2683 2294 1947 1620 1262 891 996
262 21380 Emporia, KS Micropolitan Statistical Area 36035 2145 2194 2282 2801 4623 2416 2002 1983 1728 1792 1870 2209 2254 1824 1350 974 681 907
868 47080 Vidalia, GA Micropolitan Statistical Area 36080 2397 2439 2631 2544 2377 2317 2224 2163 2063 2224 2217 2325 2185 1923 1584 1121 735 611
386 26540 Huntington, IN Micropolitan Statistical Area 36240 2066 2134 2246 2430 2476 2252 2147 2119 2109 2196 2377 2797 2661 1960 1517 1121 797 835
296 22700 Fort Dodge, IA Micropolitan Statistical Area 36277 2162 2119 2209 2718 2838 2405 1964 2127 1835 1967 2062 2639 2578 2097 1555 1137 931 934
605 35820 North Platte, NE Micropolitan Statistical Area 36426 2174 2305 2619 2279 1850 2102 2070 2387 2185 2148 2027 2559 2628 2282 1669 1203 904 1035
85 13700 Big Spring, TX Micropolitan Statistical Area 36459 2262 2155 2117 2359 2432 2915 2961 2364 2380 2721 2838 2332 1930 1602 1048 806 625 612
437 28620 Kill Devil Hills, NC Micropolitan Statistical Area 36501 1647 1845 2184 1857 1606 1773 1929 2212 2142 2422 2574 3076 3415 2917 2196 1257 768 681
70 13060 Bay City, TX Micropolitan Statistical Area 36552 2623 2587 2614 2359 2161 2383 2228 2262 1894 1969 2184 2615 2452 2122 1542 1091 762 704
135 15820 Campbellsville, KY Micropolitan Statistical Area 36598 2233 2191 2186 2618 2530 2270 2038 2109 1886 2097 2421 2649 2491 2141 1751 1321 918 748
199 18740 Coshocton, OH Micropolitan Statistical Area 36629 2363 2381 2434 2251 1924 2184 1988 2196 1895 2248 2387 2600 2647 2247 1750 1315 963 856
48 12120 Atmore, AL Micropolitan Statistical Area 36748 2187 2339 2284 2143 2076 2681 2291 2315 2259 2436 2340 2523 2278 2041 1745 1309 818 683
308 23340 Fremont, NE Micropolitan Statistical Area 36791 2515 2453 2489 2455 2368 2053 2031 2269 1982 2058 2198 2540 2303 2027 1628 1278 905 1239
634 36940 Owatonna, MN Micropolitan Statistical Area 36803 2293 2584 2740 2379 1972 2051 2302 2345 2041 2215 2395 2658 2337 2006 1472 1142 852 1019
817 44860 Sulphur Springs, TX Micropolitan Statistical Area 36810 2383 2442 2613 2469 2158 2248 2235 2058 2056 2281 2275 2531 2341 2109 1716 1284 852 759
869 47180 Vincennes, IN Micropolitan Statistical Area 36895 2207 2193 2197 2964 3061 2159 2131 2186 1839 2074 2204 2624 2474 2056 1634 1210 841 841
192 18420 Corinth, MS Micropolitan Statistical Area 36925 2113 2260 2498 2358 2177 2426 2149 2266 2206 2472 2374 2522 2291 2045 1917 1322 834 695
245 20660 Easton, MD Micropolitan Statistical Area 36968 1714 1858 1964 1817 1577 1886 1768 1826 1618 2054 2397 2761 2924 2866 2761 2242 1399 1536
225 19760 DeRidder, LA Micropolitan Statistical Area 37253 2517 2535 2544 2439 2271 2634 2446 2368 2336 2338 2262 2466 2226 1983 1543 1062 709 574
527 32460 Mayfield, KY Micropolitan Statistical Area 37317 2516 2526 2409 2290 2060 2388 2097 2236 2146 2260 2457 2600 2431 2156 1773 1349 809 814

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [pop2018_cbsa] (
   [CBSA_Code] INTEGER,
   [CBSA_Title] TEXT,
   [MSAtype] TEXT,
   [pop2018_tot] INTEGER,
   [pop2018_0to4] INTEGER,
   [pop2018_5to9] INTEGER,
   [pop2018_10to14] INTEGER,
   [pop2018_15to19] INTEGER,
   [pop2018_20to24] INTEGER,
   [pop2018_25to29] INTEGER,
   [pop2018_30to34] INTEGER,
   [pop2018_35to39] INTEGER,
   [pop2018_40to44] INTEGER,
   [pop2018_45to49] INTEGER,
   [pop2018_50to54] INTEGER,
   [pop2018_55to59] INTEGER,
   [pop2018_60to64] INTEGER,
   [pop2018_65to69] INTEGER,
   [pop2018_70to74] INTEGER,
   [pop2018_75to79] INTEGER,
   [pop2018_80to84] INTEGER,
   [pop2018_85plus] INTEGER
);