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

926 rows sorted by MSAtype

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
472 30140 Lebanon, PA Metropolitan Statistical Area 141314 8274 9118 9187 9011 8547 8355 8226 8499 8026 8589 9002 9714 9369 8249 6688 5010 3394 4056
476 30300 Lewiston, ID-WA Metropolitan Statistical Area 63018 3552 3626 3752 3667 3537 4235 3782 3671 3469 3599 3768 4401 4626 4061 3223 2522 1719 1808
477 30340 Lewiston-Auburn, ME Metropolitan Statistical Area 107679 6274 6749 6536 6495 6272 6609 6766 6724 5997 6953 7687 7972 7554 6213 4937 3223 2286 2432
480 30460 Lexington-Fayette, KY Metropolitan Statistical Area 516697 31640 31378 31836 34948 45902 39497 34350 34632 32408 32592 31277 32721 30185 25126 18965 12729 8074 8437
482 30620 Lima, OH Metropolitan Statistical Area 102663 6323 6420 6797 7206 6905 6944 5702 6173 5813 5901 6338 7085 6939 5927 4339 3109 2178 2564
484 30700 Lincoln, NE Metropolitan Statistical Area 334590 21115 21582 21570 25082 36901 24325 21605 22425 19235 18392 17376 19276 18651 16521 11740 7605 5241 5948
485 30780 Little Rock-North Little Rock-Conway, AR Metropolitan Statistical Area 741104 47267 48101 49184 46446 51942 54222 50929 50359 45411 46331 44733 47958 44826 38169 29768 20141 12693 12624
487 30860 Logan, UT-ID Metropolitan Statistical Area 140794 11813 11933 12107 13025 19377 11219 7876 8799 7889 6241 5377 5814 5372 4600 3427 2545 1776 1604
490 30980 Longview, TX Metropolitan Statistical Area 286143 18622 19802 20492 19029 18023 19080 17993 18231 16636 17243 16816 19112 18168 15038 12035 8384 5755 5684
491 31020 Longview, WA Metropolitan Statistical Area 108987 6749 6886 7004 6692 5878 7112 6317 6614 6290 6635 6693 7699 7792 6787 5580 3804 2219 2236
493 31080 Los Angeles-Long Beach-Anaheim, CA Metropolitan Statistical Area 13291486 791041 792859 810361 833824 911060 1099733 1000882 928444 865095 911211 883918 861881 754833 595466 455204 318726 222307 254641
494 31140 Louisville/Jefferson County, KY-IN Metropolitan Statistical Area 1264908 76947 77768 80531 77986 76064 91713 83758 84268 77109 82448 82422 89354 82686 69255 51745 34747 22514 23593
495 31180 Lubbock, TX Metropolitan Statistical Area 319068 21448 21062 21491 26364 38350 25507 21123 20704 17107 16151 15917 17191 16382 12975 10000 7139 5191 4966
499 31340 Lynchburg, VA Metropolitan Statistical Area 263353 13914 14152 14500 19163 24333 17962 14491 13628 12989 15665 16808 18384 17828 15272 12873 9281 5987 6123
501 31420 Macon-Bibb County, GA Metropolitan Statistical Area 229737 14308 15080 15254 15538 15332 15974 13827 13891 12724 14240 14609 15726 15029 12714 9941 6866 4469 4215
502 31460 Madera, CA Metropolitan Statistical Area 157672 11922 12162 12264 11120 10743 11563 10462 10456 9403 9288 8830 8944 8464 7524 5776 3966 2407 2378
504 31540 Madison, WI Metropolitan Statistical Area 660422 36910 37821 38834 42481 61815 51574 47422 46625 39626 39483 40168 42340 39271 34003 24441 15530 10180 11898
509 31700 Manchester-Nashua, NH Metropolitan Statistical Area 415247 21458 22833 24561 25253 26227 29134 27860 26172 24510 28556 31351 33486 28498 21747 16956 10853 7314 8478
510 31740 Manhattan, KS Metropolitan Statistical Area 130574 9905 8395 7186 10758 23764 12881 9920 8384 5946 4985 4662 5336 5162 4398 3287 2198 1497 1910
512 31860 Mankato, MN Metropolitan Statistical Area 101647 5683 5848 5888 8487 13699 7076 6490 6455 5289 4996 5257 5815 5738 4862 3503 2522 1813 2226
513 31900 Mansfield, OH Metropolitan Statistical Area 121099 6839 7249 7555 7225 7330 8061 7237 7178 7095 7262 7629 8408 8466 7206 5761 4278 3062 3258
530 32580 McAllen-Edinburg-Mission, TX Metropolitan Statistical Area 865939 77329 79561 77819 75972 66007 62433 54118 54903 54575 51492 43557 38596 33552 29324 24462 17600 12486 12153
535 32780 Medford, OR Metropolitan Statistical Area 219564 12186 12889 12736 12155 11883 14326 13472 13588 12237 12543 12599 14761 15953 15803 12805 8565 5349 5714
536 32820 Memphis, TN-MS-AR Metropolitan Statistical Area 1342349 90233 92728 93380 90036 88386 101263 89547 87900 80973 86670 84552 87966 81523 66152 48707 31971 20046 20316
538 32900 Merced, CA Metropolitan Statistical Area 274765 21174 22566 23193 23859 20649 21277 19012 17798 15933 15740 15025 14770 12924 10122 7987 5387 3625 3724
542 33100 Miami-Fort Lauderdale-Pompano Beach, FL Metropolitan Statistical Area 6198782 348137 340377 352663 350999 359272 420550 415034 407252 403191 430267 439393 430004 373952 320921 272737 209846 150545 173642
543 33140 Michigan City-La Porte, IN Metropolitan Statistical Area 110007 6547 6494 6550 6306 6681 7817 6774 7015 6329 7129 7286 7798 7589 6646 5176 3502 2122 2246
545 33220 Midland, MI Metropolitan Statistical Area 83209 4486 4725 5123 5400 4850 5231 5119 5059 4752 5074 6042 6331 5741 4803 3543 2739 2009 2182
546 33260 Midland, TX Metropolitan Statistical Area 178331 15764 14763 13238 11429 11322 16064 15925 13467 10491 9551 8878 9979 9013 6170 4243 2940 2379 2715
548 33340 Milwaukee-Waukesha, WI Metropolitan Statistical Area 1576113 97544 100080 103303 103020 98463 112558 107600 105669 92528 95637 101603 110005 101902 82475 59288 40315 28922 35201
551 33460 Minneapolis-St. Paul-Bloomington, MN-WI Metropolitan Statistical Area 3614162 234375 236327 242211 227221 219774 260853 268047 261741 222129 229327 236177 252022 218713 174701 125403 85094 55986 64061
553 33540 Missoula, MT Metropolitan Statistical Area 118791 6109 6126 6420 7555 12721 10059 8528 8401 6924 6468 6428 7149 7397 6629 4976 3165 1886 1850
556 33660 Mobile, AL Metropolitan Statistical Area 430135 27810 27398 28015 27738 27733 31614 28115 26680 24673 25940 26831 29394 28023 23371 18555 12548 8134 7563
557 33700 Modesto, CA Metropolitan Statistical Area 549815 39758 41581 42621 39385 36896 41085 38591 36614 33193 33115 32368 33128 29161 23831 18614 12471 8608 8795
558 33740 Monroe, LA Metropolitan Statistical Area 202203 13716 13639 13702 13687 13106 14855 12929 12733 11649 11976 12027 13176 12808 10621 8133 5696 3887 3863
559 33780 Monroe, MI Metropolitan Statistical Area 150439 7985 8693 9356 9393 8585 9313 8315 8703 8765 9887 10876 11971 11335 9265 6718 4875 3114 3290
560 33860 Montgomery, AL Metropolitan Statistical Area 373225 23914 23518 24230 24251 24710 27889 24871 24622 22600 24053 23563 24892 23006 19000 14706 10309 6829 6262
564 34060 Morgantown, WV Metropolitan Statistical Area 140259 7013 6763 6374 10229 18060 12359 10355 9316 7846 7809 7862 8138 7909 7300 5044 3403 2170 2309
565 34100 Morristown, TN Metropolitan Statistical Area 141726 7549 8190 8901 8852 8120 8763 7542 8050 8355 9901 10146 10343 9532 8523 7618 5398 3298 2645
578 34580 Mount Vernon-Anacortes, WA Metropolitan Statistical Area 128206 7780 7784 7814 7292 7163 8318 7855 7987 7127 7216 7286 8826 9167 8761 7115 4732 2955 3028
579 34620 Muncie, IN Metropolitan Statistical Area 114772 5680 5735 5822 10270 16022 7371 5802 5861 5644 6436 6665 7038 6754 5882 5023 3618 2494 2655
582 34740 Muskegon, MI Metropolitan Statistical Area 173588 10560 11142 11372 10862 10430 11952 10736 10898 9988 10385 10988 12575 12176 10093 7568 4997 3352 3514
584 34820 Myrtle Beach-Conway-North Myrtle Beach, SC-NC Metropolitan Statistical Area 480891 21238 22899 24149 24166 22518 27443 25006 25924 25080 27931 30241 36380 42415 46025 37256 21709 11565 8946
586 34900 Napa, CA Metropolitan Statistical Area 139417 7049 7801 8569 8764 8444 8651 8468 8958 8675 9159 9274 9707 9233 8379 6716 4711 3197 3662
587 34940 Naples-Marco Island, FL Metropolitan Statistical Area 378488 16634 17433 19039 18589 17907 18139 17791 18442 18275 20699 22860 24758 25987 28833 31014 26501 18338 17249
588 34980 Nashville-Davidson--Murfreesboro--Franklin, TN Metropolitan Statistical Area 1905898 121284 120612 125347 121270 127136 152652 141848 137128 123247 127889 121663 123054 110280 88699 66589 43399 27419 26382
591 35100 New Bern, NC Metropolitan Statistical Area 125219 7358 7079 7220 7194 10900 8946 7360 7110 6181 6501 6799 8372 8642 7949 6891 4706 3020 2991
595 35300 New Haven-Milford, CT Metropolitan Statistical Area 857620 44160 46082 50768 58409 59257 58453 56564 52347 48260 54875 59909 62657 56993 46011 37144 25740 17388 22603
596 35380 New Orleans-Metairie, LA Metropolitan Statistical Area 1270399 79507 76640 80015 73986 73583 93393 95132 88729 75561 76507 82349 88847 84955 70218 52147 34159 21806 22865
601 35620 New York-Newark-Jersey City, NY-NJ-PA Metropolitan Statistical Area 19303808 1168063 1135920 1138822 1137556 1212190 1466205 1398035 1307789 1212589 1268319 1318072 1323027 1178589 949958 746592 532779 370789 438514
602 35660 Niles, MI Metropolitan Statistical Area 154141 8807 9309 9657 9466 8852 9459 8690 8997 8440 9496 9956 11443 11167 9731 7551 5473 3659 3988
606 35840 North Port-Sarasota-Bradenton, FL Metropolitan Statistical Area 821573 33510 35920 39343 38022 35753 40029 37492 38535 37940 45238 50158 60107 64844 69083 68329 52693 35753 38824
610 35980 Norwich-New London, CT Metropolitan Statistical Area 266784 13233 13846 15056 16686 19639 18062 16932 15492 14179 16376 19059 20608 19005 15379 12450 8653 5614 6515
612 36100 Ocala, FL Metropolitan Statistical Area 359977 17802 18497 19162 18023 17376 20564 18645 18372 17020 19734 21194 23725 25685 27853 28220 22305 14151 11649
613 36140 Ocean City, NJ Metropolitan Statistical Area 92560 4294 4528 4517 4683 5094 5102 4555 4496 4037 4955 6140 7580 7993 7688 6408 4557 2990 2943
614 36220 Odessa, TX Metropolitan Statistical Area 162124 14541 14157 12939 11905 11701 14345 13044 11517 9587 8664 8248 8411 7305 5417 3939 2690 1940 1774
615 36260 Ogden-Clearfield, UT Metropolitan Statistical Area 675067 54841 58479 59866 51760 44979 49409 47217 51405 45273 37393 33033 35676 32031 25110 18871 12754 8891 8079
619 36420 Oklahoma City, OK Metropolitan Statistical Area 1396445 94699 97243 97067 93051 100654 105839 101161 99172 84115 82754 78618 87676 80580 65645 50138 33832 22062 22139
621 36500 Olympia-Lacey-Tumwater, WA Metropolitan Statistical Area 286419 16690 17363 17049 16425 17035 20958 20664 20686 17947 17817 17073 18600 18598 17480 13287 8294 5151 5302
622 36540 Omaha-Council Bluffs, NE-IA Metropolitan Statistical Area 942198 67718 67272 66844 62834 58717 67327 68646 67844 57358 56834 56184 60845 54210 44958 32382 21611 14605 16009
627 36740 Orlando-Kissimmee-Sanford, FL Metropolitan Statistical Area 2572962 149456 154601 161824 161825 174940 205326 188700 183765 170490 171520 165401 161093 142954 122018 101224 68641 44727 44457
628 36780 Oshkosh-Neenah, WI Metropolitan Statistical Area 171020 9464 9639 9923 11378 14775 11823 10867 10803 9782 10381 11153 12093 10917 9023 6726 4765 3549 3959
635 36980 Owensboro, KY Metropolitan Statistical Area 119114 7958 8056 8270 7582 6766 7904 7095 7236 6830 7317 7541 8255 7890 6372 5349 3591 2520 2582
637 37100 Oxnard-Thousand Oaks-Ventura, CA Metropolitan Statistical Area 850967 49784 53892 56724 56319 57063 59641 54671 54473 51403 55609 56766 59144 53091 42601 33666 23039 15483 17598
643 37340 Palm Bay-Melbourne-Titusville, FL Metropolitan Statistical Area 596849 27825 29480 31999 31780 30980 35253 32892 32127 29794 34825 40729 50094 47726 40994 35234 27375 19135 18607
645 37460 Panama City, FL Metropolitan Statistical Area 185287 11333 11233 10920 9920 10927 13877 12840 11878 10503 11498 12294 13879 12507 10189 8218 5683 3785 3803
649 37620 Parkersburg-Vienna, WV Metropolitan Statistical Area 90033 5046 5117 5443 5051 4728 5362 4878 5402 5272 5876 6118 6744 6607 5765 4763 3546 2312 2003
655 37860 Pensacola-Ferry Pass-Brent, FL Metropolitan Statistical Area 494883 29147 28883 29858 32002 35154 37808 33673 30516 27206 29924 31122 35546 32251 27064 21780 14765 9590 8594
656 37900 Peoria, IL Metropolitan Statistical Area 403217 24798 25497 26217 25150 23133 25667 25007 26024 23972 24641 24976 27488 26937 23142 18045 12872 9032 10619
658 37980 Philadelphia-Camden-Wilmington, PA-NJ-DE-MD Metropolitan Statistical Area 6096372 352559 365340 374539 386365 386839 448266 427509 396970 355627 386884 412287 432673 396326 314089 241369 167325 114617 136788
659 38060 Phoenix-Mesa-Chandler, AZ Metropolitan Statistical Area 4857962 304870 317693 335149 322696 316534 365193 337345 328867 303723 310643 291786 294327 268722 238955 204025 142317 88940 86177
662 38220 Pine Bluff, AR Metropolitan Statistical Area 89515 5107 5070 5503 6022 6217 6334 5675 5596 5110 5464 5750 6205 5953 5084 4070 2701 1885 1769
665 38300 Pittsburgh, PA Metropolitan Statistical Area 2324743 117907 119977 124128 134172 136104 157299 153938 141803 126056 142117 154793 174889 176220 148445 110762 80422 56881 68830
666 38340 Pittsfield, MA Metropolitan Statistical Area 126348 5292 5603 6273 7752 8424 6846 6728 6852 6245 7483 8936 10347 10169 9178 7415 5090 3432 4283
671 38540 Pocatello, ID Metropolitan Statistical Area 94906 6861 6944 7184 7263 6712 7231 6620 6435 5454 4922 4668 5443 5570 4757 3570 2330 1497 1445
678 38860 Portland-South Portland, ME Metropolitan Statistical Area 535420 25764 26809 29356 30740 30352 34568 34681 32983 30519 35171 37886 42194 40122 34653 26960 17775 11838 13049
679 38900 Portland-Vancouver-Hillsboro, OR-WA Metropolitan Statistical Area 2478810 141260 147589 151924 144223 144612 190198 191946 192179 173393 170874 154751 156801 149211 130876 98222 61490 37212 42049
681 38940 Port St. Lucie, FL Metropolitan Statistical Area 482040 22812 24099 26617 25450 23702 26739 25068 25347 25005 28345 31276 35052 35335 34106 32461 25656 17107 17863
684 39100 Poughkeepsie-Newburgh-Middletown, NY Metropolitan Statistical Area 675669 38586 41099 44186 49884 50074 41381 38618 39900 39029 44931 49506 50334 42967 33981 26693 18233 12468 13799
685 39150 Prescott Valley-Prescott, AZ Metropolitan Statistical Area 231993 9689 9968 11316 11367 10435 10934 10165 10402 9990 11298 13205 17964 21982 23388 20154 13995 8316 7425
688 39300 Providence-Warwick, RI-MA Metropolitan Statistical Area 1621337 83789 86608 92801 106990 113377 113496 105863 100306 92285 104604 115060 118925 109515 87952 69277 46853 32087 41549
689 39340 Provo-Orem, UT Metropolitan Statistical Area 633768 59887 58785 59248 59917 79528 52581 38174 42593 37622 29537 23842 22602 20005 16321 12883 8932 6018 5293
690 39380 Pueblo, CO Metropolitan Statistical Area 167529 9748 10250 10948 11262 10265 11279 10750 10401 9345 9931 9818 11210 11334 10155 7869 5275 3661 4028
692 39460 Punta Gorda, FL Metropolitan Statistical Area 184998 5536 5793 6513 6715 6910 7595 6748 6721 6824 8643 10769 14547 17290 19931 19646 15236 9979 9602
694 39540 Racine, WI Metropolitan Statistical Area 196584 12010 12539 12852 12512 11982 11802 11789 12371 11233 12419 13972 14973 13670 10832 8110 5623 3741 4154
695 39580 Raleigh-Cary, NC Metropolitan Statistical Area 1362540 84428 90019 96614 93815 83929 96921 97078 100076 99257 102955 93294 86572 72355 58053 45030 27681 17409 17054
696 39660 Rapid City, SD Metropolitan Statistical Area 140023 8731 9021 9298 8252 9110 9850 9361 9037 7548 7392 7955 9787 10278 8890 6148 3902 2514 2949
698 39740 Reading, PA Metropolitan Statistical Area 420152 24151 25642 27166 29488 27708 26950 25194 24753 23592 26626 29187 30290 27053 22520 18066 12392 8747 10627
700 39820 Redding, CA Metropolitan Statistical Area 180040 10597 10609 10762 10412 9876 11797 11365 10922 9144 9846 10772 13143 13242 12087 9929 6888 4365 4284
702 39900 Reno, NV Metropolitan Statistical Area 469764 27803 27855 28898 27420 30620 36826 34169 30661 26974 29086 29687 31520 30816 27072 21963 13631 7797 6966
705 40060 Richmond, VA Metropolitan Statistical Area 1282442 74395 75652 78701 80839 80375 96195 90585 85708 76827 83796 86372 90070 82931 68348 52651 34365 21180 23452
708 40140 Riverside-San Bernardino-Ontario, CA Metropolitan Statistical Area 4622361 314070 327499 343049 333682 331740 354097 320525 310843 284758 288631 281850 280075 247059 197618 156714 108283 71799 70069
710 40220 Roanoke, VA Metropolitan Statistical Area 314172 16897 17574 18569 18443 17829 19917 18581 18038 17356 20581 21552 22917 22438 20457 16598 11240 7315 7870
713 40340 Rochester, MN Metropolitan Statistical Area 219802 14674 14765 15467 13017 12101 14412 15173 15212 12922 12658 13385 15441 14107 11254 8677 6474 4620 5443
714 40380 Rochester, NY Metropolitan Statistical Area 1071082 57172 60627 62890 71903 73513 73659 69197 63537 56098 65572 72725 79741 73748 61432 48231 32908 22082 26047
715 40420 Rockford, IL Metropolitan Statistical Area 337658 21104 21482 22976 22302 20371 21530 19963 20418 19363 21909 22167 23796 21974 18591 14893 10472 6935 7412
719 40580 Rocky Mount, NC Metropolitan Statistical Area 146021 8110 8916 9414 9399 8820 9369 7891 8153 8152 9128 9717 10787 10486 9333 7373 4775 3164 3034
721 40660 Rome, GA Metropolitan Statistical Area 97927 5967 6148 6628 7235 6485 6721 5951 6049 5692 6164 6175 6304 6018 5192 4149 3098 2038 1913
728 40900 Sacramento-Roseville-Folsom, CA Metropolitan Statistical Area 2345210 141047 148208 155076 151864 157058 171490 163772 160911 142971 147808 145967 154781 141826 120002 93341 62159 41327 45602
730 40980 Saginaw, MI Metropolitan Statistical Area 190800 10920 10937 11519 12825 12498 13128 10696 10604 10157 11402 12373 13626 13332 11813 9046 6509 4437 4978

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