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

926 rows sorted by MSAtype

View and edit SQL

Suggested facets: MSAtype

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
3 10180 Abilene, TX Metropolitan Statistical Area 171451 11808 11254 11139 12304 16515 13313 11849 11154 9071 8856 8853 10141 9449 7624 6456 4776 3401 3488
6 10420 Akron, OH Metropolitan Statistical Area 704845 37714 38786 41098 46631 52006 48597 42520 41668 38737 44466 46858 51550 50188 41063 31217 20996 14642 16108
8 10500 Albany, GA Metropolitan Statistical Area 149917 9368 10006 10101 12182 11220 10459 8978 9226 8374 8995 8855 9519 9276 8106 6036 4036 2623 2557
9 10540 Albany-Lebanon, OR Metropolitan Statistical Area 127335 7811 7817 8151 7586 7267 8925 8315 7897 7302 7642 7434 8747 8770 7916 6234 4331 2653 2537
10 10580 Albany-Schenectady-Troy, NY Metropolitan Statistical Area 883169 45718 47555 48356 59038 68809 58372 56897 54907 49860 55731 60487 64089 59131 50596 38927 26118 17273 21305
14 10740 Albuquerque, NM Metropolitan Statistical Area 915927 50853 56272 59358 58595 57909 65742 64619 62333 54320 55450 55438 62232 59101 52527 40576 26663 16729 17210
16 10780 Alexandria, LA Metropolitan Statistical Area 153044 10231 10048 10557 9914 9353 10618 10241 10111 8927 8986 9606 10276 9381 7948 6398 4602 3007 2840
19 10900 Allentown-Bethlehem-Easton, PA-NJ Metropolitan Statistical Area 842913 44542 47499 52513 55860 53716 53099 51463 51071 48688 54165 58894 61733 57353 46944 37853 26789 18184 22547
22 11020 Altoona, PA Metropolitan Statistical Area 122492 6464 6903 7309 7461 6295 8050 6962 7072 6953 7616 8017 8827 9118 7930 6112 4517 3220 3666
24 11100 Amarillo, TX Metropolitan Statistical Area 265947 18633 19116 19138 18122 17756 19802 19412 18866 16034 15586 14869 15978 15232 12494 9276 6587 4663 4383
26 11180 Ames, IA Metropolitan Statistical Area 124451 5856 5989 6090 13447 22765 9361 6755 7008 5970 5595 5869 6486 6594 5631 3821 2786 2047 2381
28 11260 Anchorage, AK Metropolitan Statistical Area 399148 28625 27930 27610 25210 28160 33913 32032 28934 23759 24249 23918 26083 23578 17868 12058 7260 4092 3869
31 11460 Ann Arbor, MI Metropolitan Statistical Area 370963 18094 18672 19811 33361 48595 30111 23560 22478 19922 21455 21436 21547 20544 17861 13305 8842 5356 6013
32 11500 Anniston-Oxford, AL Metropolitan Statistical Area 114277 6580 6561 7146 7491 7286 8177 6882 6983 6663 7064 7239 8086 7872 6769 5307 3672 2388 2111
33 11540 Appleton, WI Metropolitan Statistical Area 237524 14410 15415 16275 15536 14043 15027 15689 16326 14604 15090 17050 17814 15085 11946 8730 6175 4114 4195
37 11700 Asheville, NC Metropolitan Statistical Area 459585 22526 23140 24358 24597 23833 29208 28713 28774 27758 29617 29430 32057 33564 32311 26946 18523 11906 12324
45 12020 Athens-Clarke County, GA Metropolitan Statistical Area 211306 11419 11916 12086 18141 28349 16649 13486 13257 11816 12196 11309 11663 11235 9542 7381 4984 2959 2918
46 12060 Atlanta-Sandy Springs-Alpharetta, GA Metropolitan Statistical Area 5949951 374055 395049 426016 414121 382416 438078 412127 419257 404294 436161 408956 385722 324110 261079 198776 125533 74446 69755
47 12100 Atlantic City-Hammonton, NJ Metropolitan Statistical Area 265429 14367 15688 16247 16771 17168 16641 15278 14877 14645 17307 18953 20604 19272 15106 12276 8684 5638 5907
51 12220 Auburn-Opelika, AL Metropolitan Statistical Area 163941 9629 9551 10043 13355 21876 12706 10547 10381 9361 10004 9324 9428 8255 6850 5310 3409 2111 1801
52 12260 Augusta-Richmond County, GA-SC Metropolitan Statistical Area 604167 37590 38478 39756 39573 38894 45184 41296 39050 34427 36488 37679 40722 38721 32917 25603 17233 10632 9924
55 12420 Austin-Round Rock-Georgetown, TX Metropolitan Statistical Area 2168316 137877 138726 141017 141426 149085 187321 190605 179655 158713 150154 127244 122348 107877 87583 63297 38160 23651 23577
57 12540 Bakersfield, CA Metropolitan Statistical Area 896764 69785 74172 73637 66394 65720 73491 66219 60946 53421 51266 49175 50348 43843 33832 25532 17762 10840 10381
58 12580 Baltimore-Columbia-Towson, MD Metropolitan Statistical Area 2802789 167429 169431 172743 173813 173586 204541 202663 189781 165388 177330 192317 200711 178212 142892 110875 75790 48719 56568
59 12620 Bangor, ME Metropolitan Statistical Area 151096 7135 7284 8025 10031 10354 10499 9448 8893 8276 9474 10506 11850 11117 9478 6986 4771 3383 3586
62 12700 Barnstable Town, MA Metropolitan Statistical Area 213413 7852 8426 9599 10302 10880 9918 9170 9639 8951 11443 14367 18134 19433 19676 17400 11906 7677 8640
67 12940 Baton Rouge, LA Metropolitan Statistical Area 853610 55677 55184 55814 57204 69328 63655 58536 59218 49826 51516 51891 54406 50557 42092 31935 21079 13120 12572
68 12980 Battle Creek, MI Metropolitan Statistical Area 134487 8362 8336 8723 8943 8517 8764 7757 8236 7458 8387 8427 9555 9035 7874 5822 4252 2909 3130
69 13020 Bay City, MI Metropolitan Statistical Area 103923 5245 5603 6303 6023 5846 6847 5900 6082 5774 6302 6923 8004 7876 6811 5249 3826 2518 2791
72 13140 Beaumont-Port Arthur, TX Metropolitan Statistical Area 395780 27178 26675 26636 25343 25293 28532 27115 26548 23541 24044 23944 26506 24622 19494 14880 10486 7347 7596
74 13220 Beckley, WV Metropolitan Statistical Area 117272 6267 7086 6970 6395 6147 7207 6661 7201 7532 7590 7095 7817 8935 8206 6322 4110 2894 2837
78 13380 Bellingham, WA Metropolitan Statistical Area 225685 12067 12429 12142 14908 23520 16991 14047 14368 12458 12959 12625 13743 14270 13567 10658 6659 4051 4223
80 13460 Bend, OR Metropolitan Statistical Area 191996 9834 10582 11541 10369 9523 12239 12769 13144 12119 12872 11468 12942 14186 13713 10724 6610 3723 3638
87 13740 Billings, MT Metropolitan Statistical Area 180385 10838 11617 12203 10634 10208 12076 11928 11958 10489 10565 10640 12680 12510 10645 8129 5470 3664 4131
88 13780 Binghamton, NY Metropolitan Statistical Area 240219 12543 12787 13380 17595 21638 13919 13018 13274 11891 13119 15249 18339 17071 13787 11078 8130 6212 7189
89 13820 Birmingham-Hoover, AL Metropolitan Statistical Area 1088090 67107 69016 71183 68237 65757 77275 72471 72166 67637 71252 68768 73563 69637 59363 44324 30077 19933 20324
90 13900 Bismarck, ND Metropolitan Statistical Area 128320 8914 8295 8156 7586 7765 9447 9353 9083 7479 7165 7280 8636 8210 6789 4876 3334 2565 3387
92 13980 Blacksburg-Christiansburg, VA Metropolitan Statistical Area 168234 7388 7364 7598 16708 25794 12450 9885 8478 8480 9748 9582 9546 9571 8232 6708 4730 3009 2963
93 14010 Bloomington, IL Metropolitan Statistical Area 172828 10095 10135 10514 14796 21759 11703 10753 10968 9718 9854 9746 10481 9446 7763 5576 3844 2623 3054
94 14020 Bloomington, IN Metropolitan Statistical Area 167762 7556 7423 7563 16508 28559 13176 10122 9556 8389 8371 8612 9276 9383 7825 5924 4102 2573 2844
95 14100 Bloomsburg-Berwick, PA Metropolitan Statistical Area 83696 4019 4123 4475 6206 7652 4882 4636 4542 4296 4932 5316 6012 5987 5070 4125 2875 2143 2405
99 14260 Boise City, ID Metropolitan Statistical Area 730426 46082 50154 55215 51854 44627 51118 50023 51528 47140 46672 43131 44623 41841 36809 28901 18672 11116 10920
103 14460 Boston-Cambridge-Newton, MA-NH Metropolitan Statistical Area 4875390 257769 260414 272270 318214 348925 379679 360902 320557 287966 315827 337061 343627 306525 248178 191972 129798 89240 106466
104 14500 Boulder, CO Metropolitan Statistical Area 326078 14494 16890 19016 26658 33488 24846 20906 20506 20161 21575 19994 21142 19916 16753 12086 7500 4909 5238
105 14540 Bowling Green, KY Metropolitan Statistical Area 177432 11095 11171 11204 13808 17655 12765 10618 11215 10366 10606 10419 10941 10002 8456 6801 4691 2809 2810
111 14740 Bremerton-Silverdale-Port Orchard, WA Metropolitan Statistical Area 269805 15688 15155 15312 14636 20401 21067 18681 17458 14617 15284 16183 18801 18428 16565 13439 8312 4786 4992
114 14860 Bridgeport-Stamford-Norwalk, CT Metropolitan Statistical Area 943823 51672 56713 64049 65906 59743 52874 55047 58183 58887 66466 72070 71103 61192 45485 36410 26273 18084 23666
119 15180 Brownsville-Harlingen, TX Metropolitan Statistical Area 423908 34371 35426 35980 36570 31189 28319 24326 25283 26243 25209 22288 21424 19865 17620 14679 10322 7479 7315
121 15260 Brunswick, GA Metropolitan Statistical Area 118456 6471 6947 7314 7243 6683 7341 6712 6705 6555 7530 7783 8566 8391 7852 6769 4441 2739 2414
123 15380 Buffalo-Cheektowaga, NY Metropolitan Statistical Area 1130152 61109 62181 63679 70515 72634 81951 76334 67016 59027 68201 76285 84661 81398 65349 49638 35472 24956 29746
126 15500 Burlington, NC Metropolitan Statistical Area 166436 9632 10150 10645 12950 10920 10734 9991 9542 9564 11047 11344 11436 10354 8538 7273 5160 3476 3680
127 15540 Burlington-South Burlington, VT Metropolitan Statistical Area 221083 10899 11145 11916 16974 21705 15874 14421 13769 12289 13452 14141 15856 14569 11590 8666 5784 3661 4372
131 15680 California-Lexington Park, MD Metropolitan Statistical Area 112664 7162 7554 7857 7743 7297 7964 7923 7381 6627 7361 8378 8231 6456 4894 3844 2675 1692 1625
137 15940 Canton-Massillon, OH Metropolitan Statistical Area 398655 22294 22834 24728 25131 23983 24791 22372 23219 21725 25064 26210 29167 29124 24860 19254 13850 9544 10505
138 15980 Cape Coral-Fort Myers, FL Metropolitan Statistical Area 754610 34544 36201 38518 38127 36961 42278 40395 39649 37722 42829 45388 51742 54362 58873 58402 44700 27869 26050
139 16020 Cape Girardeau, MO-IL Metropolitan Statistical Area 96982 5536 5771 5995 6837 8827 6335 5663 5713 5150 5518 5763 6502 6263 5547 4072 3036 2192 2262
140 16060 Carbondale-Marion, IL Metropolitan Statistical Area 136931 7693 7500 7498 9105 13615 9594 8497 8326 7581 7885 7790 8903 8538 7649 6314 4484 2947 3012
143 16180 Carson City, NV Metropolitan Statistical Area 55414 3150 2999 3240 3027 3203 3755 3537 3173 3003 3360 3638 3979 4089 3523 3055 2097 1330 1256
144 16220 Casper, WY Metropolitan Statistical Area 79115 5236 5307 5470 4788 4375 5831 5740 5737 4741 4492 4376 5427 5415 4274 3046 1896 1362 1602
146 16300 Cedar Rapids, IA Metropolitan Statistical Area 272295 16964 17208 17971 17547 17074 18207 17623 18314 16563 16805 17598 18751 16928 14279 11001 7714 5662 6086
152 16540 Chambersburg-Waynesboro, PA Metropolitan Statistical Area 154835 9328 9294 9785 9529 8198 9591 9064 9046 8871 10184 10418 10739 10363 8976 7789 5551 3903 4206
153 16580 Champaign-Urbana, IL Metropolitan Statistical Area 226379 12488 11787 11528 21966 34957 17214 14688 13442 11389 11324 10809 12467 12216 10300 7210 4933 3550 4111
154 16620 Charleston, WV Metropolitan Statistical Area 260342 13849 14629 15465 14679 13943 16062 14268 15634 15932 16628 16885 19149 19897 17963 13356 9369 6573 6061
156 16700 Charleston-North Charleston, SC Metropolitan Statistical Area 787643 48052 47766 48453 47466 48758 62832 60921 56624 47269 49321 49561 52495 48460 42048 33278 20735 12068 11536
157 16740 Charlotte-Concord-Gastonia, NC-SC Metropolitan Statistical Area 2594090 160921 168059 178987 171245 156563 188249 178906 180683 174790 190558 176615 168546 145877 120605 95361 62495 38583 37047
158 16820 Charlottesville, VA Metropolitan Statistical Area 218233 11631 11459 11642 15389 18261 15742 15035 13858 12131 12706 13322 14119 14207 12824 10002 6859 4394 4652
159 16860 Chattanooga, TN-GA Metropolitan Statistical Area 560793 31802 32387 33994 33788 33709 40024 36380 35240 33615 36708 36293 38401 37695 32433 26157 18180 11766 12221
160 16940 Cheyenne, WY Metropolitan Statistical Area 98976 6239 6495 6586 5904 6578 7603 7096 6681 5511 5746 5782 6672 6219 5388 4111 2716 1741 1908
161 16980 Chicago-Naperville-Elgin, IL-IN-WI Metropolitan Statistical Area 9498716 571828 588381 621589 619048 618793 696323 670955 657678 605467 626568 621090 639282 577461 460497 344872 239562 159413 179909
162 17020 Chico, CA Metropolitan Statistical Area 231256 12803 12732 12963 15667 25027 16833 13394 13601 11685 11971 12243 14305 15040 14348 10990 7162 4914 5578
164 17140 Cincinnati, OH-KY-IN Metropolitan Statistical Area 2212945 137507 142550 148470 149679 144021 153052 144776 143584 129522 140058 145054 154384 143476 114634 84271 58093 38961 40853
167 17300 Clarksville, TN-KY Metropolitan Statistical Area 305825 25381 22564 20812 19600 28857 30076 24088 20654 17071 16621 15865 16024 14399 11245 9036 6115 4000 3417
170 17420 Cleveland, TN Metropolitan Statistical Area 123625 6986 7045 7671 8298 8059 8257 7195 7308 7756 8462 8455 8541 7773 6765 5880 4213 2665 2296
171 17460 Cleveland-Elyria, OH Metropolitan Statistical Area 2057009 114566 116722 124055 127114 125677 139338 127313 124110 114255 128658 136715 151730 146929 122084 92460 66459 45699 53125
175 17660 Coeur d'Alene, ID Metropolitan Statistical Area 161505 9664 10169 10628 9803 8670 10628 10165 10009 9448 9668 9892 11022 11069 10378 8251 5635 3279 3127
178 17780 College Station-Bryan, TX Metropolitan Statistical Area 262431 16187 15142 14893 23614 45899 22774 17749 16200 13117 12712 12175 12346 11770 9293 7106 4772 3287 3395
179 17820 Colorado Springs, CO Metropolitan Statistical Area 738939 49154 48746 49302 49801 58963 61663 55446 50380 42972 43632 43264 47197 41851 34438 26003 15972 10318 9837
180 17860 Columbia, MO Metropolitan Statistical Area 207745 12062 11812 11859 16405 27938 17060 13916 13270 11168 11064 10708 12070 11247 9585 6641 4487 2986 3467
181 17900 Columbia, SC Metropolitan Statistical Area 832666 47822 50653 53385 59293 68706 61859 54182 53683 49537 52349 52223 54509 50758 42869 33245 21590 13249 12754
182 17980 Columbus, GA-AL Metropolitan Statistical Area 317922 21239 21465 20669 20334 22833 26522 23070 20802 18375 18843 19334 20210 18786 15184 11954 8027 5123 5152
183 18020 Columbus, IN Metropolitan Statistical Area 82753 5448 5489 5534 4931 4976 6495 5496 5247 5014 5310 5097 5260 4969 4340 3423 2530 1568 1626
186 18140 Columbus, OH Metropolitan Statistical Area 2106541 139787 137780 136863 137718 136992 171476 160855 149106 133007 137837 131115 133975 120529 96997 71728 48353 31332 31091
195 18580 Corpus Christi, TX Metropolitan Statistical Area 429158 29335 29169 29964 30376 29962 31229 29645 29391 25735 25507 24579 26776 25254 20373 16429 10648 7314 7472
198 18700 Corvallis, OR Metropolitan Statistical Area 92101 3799 3976 4416 8415 15408 7072 5076 4935 4414 4610 4380 5102 5553 5303 3876 2454 1536 1776
203 18880 Crestview-Fort Walton Beach-Destin, FL Metropolitan Statistical Area 278644 17705 17131 16368 14689 17184 21670 20234 18352 15517 15543 17358 20401 18626 15821 12788 8541 5762 4954
207 19060 Cumberland, MD-WV Metropolitan Statistical Area 97915 4614 4903 4959 6648 7479 6463 5817 5688 5352 6200 6395 6698 6458 5922 5322 3914 2635 2448
208 19100 Dallas-Fort Worth-Arlington, TX Metropolitan Statistical Area 7470158 518273 533012 560459 523971 487757 563243 552132 546577 508386 516332 474566 462353 384752 294993 222999 144382 89374 86597
209 19140 Dalton, GA Metropolitan Statistical Area 143983 9387 9860 10998 10227 9269 10059 8943 9107 8870 9887 9770 9177 7878 6560 5489 3933 2449 2120
210 19180 Danville, IL Metropolitan Statistical Area 76806 4949 5013 5149 4663 4301 4761 4434 4490 4312 4435 4713 5431 5299 4627 3644 2814 1838 1933
213 19300 Daphne-Fairhope-Foley, AL Metropolitan Statistical Area 218022 11955 12802 13981 12932 11108 12471 12057 13156 12877 14461 14242 15744 15665 14267 12471 8465 5064 4304
214 19340 Davenport-Moline-Rock Island, IA-IL Metropolitan Statistical Area 381451 23524 24178 24980 23911 22085 23989 23505 24979 22303 22931 23457 26544 25890 22095 17171 12290 8236 9383
216 19430 Dayton-Kettering, OH Metropolitan Statistical Area 806548 48424 48418 49187 52784 54410 56609 51204 49450 43095 48433 50603 56060 53686 45615 36121 25550 17770 19129
217 19460 Decatur, AL Metropolitan Statistical Area 152046 8934 9364 9970 9326 8572 9713 8802 9143 9004 10146 10918 11052 10148 8639 7108 5198 3261 2748
218 19500 Decatur, IL Metropolitan Statistical Area 104712 6425 6415 6463 6586 6449 6601 5867 6089 5909 5888 6222 7292 7546 6533 5011 3733 2517 3166
222 19660 Deltona-Daytona Beach-Ormond Beach, FL Metropolitan Statistical Area 659605 30298 31583 33289 35584 36154 39196 35283 34358 33476 38315 42421 50031 51456 50554 44404 31802 20725 20676
224 19740 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area 2932415 176166 180678 190572 176691 169714 245938 248439 230417 200767 200048 180685 185582 166754 136816 99888 62325 39253 41682
226 19780 Des Moines-West Des Moines, IA Metropolitan Statistical Area 692556 48448 48528 48928 44221 42064 50793 50637 51414 43835 44361 42318 43780 38484 32281 23465 15822 10669 12508
227 19820 Detroit-Warren-Dearborn, MI Metropolitan Statistical Area 4326442 253260 257247 271758 268620 264288 314341 268390 262447 254042 291745 301362 315342 293978 236470 179234 122818 78950 92150
231 20020 Dothan, AL Metropolitan Statistical Area 148245 8687 9013 9648 9231 8007 9478 8996 9173 8783 9599 9707 10086 9947 8901 7478 5028 3445 3038
233 20100 Dover, DE Metropolitan Statistical Area 178550 11170 11264 11516 12105 12492 12835 11499 10898 9841 10345 11305 11933 10864 9479 8345 5877 3631 3151

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