Skip to content

Instantly share code, notes, and snippets.

/gist:469915
Created Jul 9, 2010

Embed
What would you like to do?
select NID, Neighborhood, zip_code, postal_name, zippercent, state from neighborhoods_zip where postal_name='seattle' and state='wa'
----------------------------------------------------------------------------------
10533 Adams 98107 SEATTLE 100.00 WA
10534 Alki 98116 SEATTLE 99.60 WA
10535 Arbor Heights 98146 SEATTLE 76.30 WA
10535 Arbor Heights 98126 SEATTLE 13.10 WA
10535 Arbor Heights 98136 SEATTLE 10.60 WA
10536 Atlantic 98144 SEATTLE 96.00 WA
10537 Belltown 98141 SEATTLE 100.00 WA
10537 Belltown 98121 SEATTLE 76.50 WA
10537 Belltown 98101 SEATTLE 21.30 WA
10538 Bitter Lake 98133 SEATTLE 100.00 WA
10539 Briarcliff 98199 SEATTLE 100.00 WA
10540 Brighton 98118 SEATTLE 100.00 WA
10541 Broadview 98177 SEATTLE 85.20 WA
10541 Broadview 98133 SEATTLE 14.80 WA
10542 Broadway 98102 SEATTLE 65.10 WA
10542 Broadway 98122 SEATTLE 24.00 WA
10542 Broadway 98112 SEATTLE 9.50 WA
10543 Bryant 98105 SEATTLE 55.00 WA
10543 Bryant 98115 SEATTLE 45.00 WA
10544 Cedar Heights 98125 SEATTLE 100.00 WA
10545 Central Business District 98138 SEATTLE 100.00 WA
10545 Central Business District 98111 SEATTLE 100.00 WA
10545 Central Business District 98114 SEATTLE 100.00 WA
10545 Central Business District 98124 SEATTLE 100.00 WA
10545 Central Business District 98127 SEATTLE 100.00 WA
10545 Central Business District 98129 SEATTLE 100.00 WA
10545 Central Business District 98145 SEATTLE 100.00 WA
10545 Central Business District 98170 SEATTLE 100.00 WA
10545 Central Business District 98184 SEATTLE 100.00 WA
10545 Central Business District 98185 SEATTLE 100.00 WA
10545 Central Business District 98190 SEATTLE 100.00 WA
10545 Central Business District 98191 SEATTLE 100.00 WA
10545 Central Business District 98181 SEATTLE 100.00 WA
10545 Central Business District 98101 SEATTLE 48.60 WA
10545 Central Business District 98104 SEATTLE 30.70 WA
10545 Central Business District 98122 SEATTLE 18.20 WA
10546 Columbia City 98118 SEATTLE 71.40 WA
10546 Columbia City 98108 SEATTLE 20.60 WA
10546 Columbia City 98144 SEATTLE 8.00 WA
10547 Crown Hill 98117 SEATTLE 78.90 WA
10547 Crown Hill 98177 SEATTLE 21.10 WA
10548 Dunlap 98118 SEATTLE 100.00 WA
10549 East Queen Anne 98109 SEATTLE 100.00 WA
10550 Eastlake 98102 SEATTLE 100.00 WA
10551 Fairmount Park 98126 SEATTLE 61.80 WA
10551 Fairmount Park 98136 SEATTLE 35.60 WA
10552 Fauntleroy 98136 SEATTLE 72.50 WA
10552 Fauntleroy 98146 SEATTLE 16.10 WA
10552 Fauntleroy 98126 SEATTLE 11.40 WA
10553 Fremont 98103 SEATTLE 73.20 WA
10553 Fremont 98107 SEATTLE 26.80 WA
10554 Gatewood 98136 SEATTLE 62.30 WA
10554 Gatewood 98126 SEATTLE 37.70 WA
10555 Genesee 98116 SEATTLE 74.40 WA
10555 Genesee 98126 SEATTLE 25.60 WA
10556 Georgetown 98108 SEATTLE 93.50 WA
10557 Green Lakes 98113 SEATTLE 100.00 WA
10557 Green Lakes 98115 SEATTLE 59.00 WA
10557 Green Lakes 98103 SEATTLE 41.00 WA
10558 Greenwood 98103 SEATTLE 52.10 WA
10558 Greenwood 98117 SEATTLE 31.10 WA
10558 Greenwood 98133 SEATTLE 9.10 WA
10558 Greenwood 98177 SEATTLE 7.60 WA
10559 Haller Lake 98133 SEATTLE 83.30 WA
10559 Haller Lake 98125 SEATTLE 16.70 WA
10560 Harbor Island 98134 SEATTLE 99.50 WA
10561 Harrison/ Denny Blaine 98112 SEATTLE 96.70 WA
10562 High Point 98126 SEATTLE 52.60 WA
10562 High Point 98106 SEATTLE 47.40 WA
10563 Highland Park 98106 SEATTLE 91.00 WA
10563 Highland Park 98108 SEATTLE 5.20 WA
10564 Holly Park 98118 SEATTLE 68.50 WA
10564 Holly Park 98108 SEATTLE 31.50 WA
10565 Industrial District East 98134 SEATTLE 81.90 WA
10565 Industrial District East 98108 SEATTLE 17.20 WA
10566 Industrial District West 98106 SEATTLE 60.30 WA
10566 Industrial District West 98126 SEATTLE 39.70 WA
10567 Interbay 98119 SEATTLE 53.00 WA
10567 Interbay 98199 SEATTLE 45.70 WA
10568 International District 98104 SEATTLE 76.70 WA
10568 International District 98144 SEATTLE 21.50 WA
10569 Laurelhurst 98105 SEATTLE 100.00 WA
10570 Lawton Park 98139 SEATTLE 100.00 WA
10570 Lawton Park 98199 SEATTLE 100.00 WA
10571 Leschi 98144 SEATTLE 55.90 WA
10571 Leschi 98122 SEATTLE 44.10 WA
10572 Lower Queen Anne 98109 SEATTLE 54.80 WA
10572 Lower Queen Anne 98119 SEATTLE 44.10 WA
10573 Loyal Heights 98117 SEATTLE 100.00 WA
10574 Madison Park 98112 SEATTLE 100.00 WA
10575 Madrona 98122 SEATTLE 99.20 WA
10576 Mann 98122 SEATTLE 87.30 WA
10576 Mann 98112 SEATTLE 12.60 WA
10577 Maple Leaf 98115 SEATTLE 67.10 WA
10577 Maple Leaf 98125 SEATTLE 32.90 WA
10578 Matthews Beach 98125 SEATTLE 68.70 WA
10578 Matthews Beach 98115 SEATTLE 31.30 WA
10579 Meadowbrook 98125 SEATTLE 75.00 WA
10579 Meadowbrook 98115 SEATTLE 25.00 WA
10580 Mid-Beacon Hill 98108 SEATTLE 89.70 WA
10580 Mid-Beacon Hill 98118 SEATTLE 10.20 WA
10581 Minor 98122 SEATTLE 100.00 WA
10582 Montlake 98112 SEATTLE 79.10 WA
10582 Montlake 98102 SEATTLE 20.90 WA
10583 Mt. Baker 98144 SEATTLE 82.50 WA
10583 Mt. Baker 98118 SEATTLE 17.50 WA
10584 North Admiral 98116 SEATTLE 72.30 WA
10584 North Admiral 98126 SEATTLE 27.70 WA
10585 North Beach/ Blue Ridge 98117 SEATTLE 65.10 WA
10585 North Beach/ Blue Ridge 98177 SEATTLE 34.90 WA
10586 North Beacon Hill 98144 SEATTLE 67.20 WA
10586 North Beacon Hill 98108 SEATTLE 26.40 WA
10586 North Beacon Hill 98134 SEATTLE 6.40 WA
10587 North College Park 98103 SEATTLE 67.80 WA
10587 North College Park 98133 SEATTLE 31.20 WA
10588 North Delridge 98106 SEATTLE 51.50 WA
10588 North Delridge 98126 SEATTLE 48.50 WA
10589 North Queen Anne 98119 SEATTLE 82.70 WA
10589 North Queen Anne 98109 SEATTLE 17.30 WA
10590 Olympic Hills 98125 SEATTLE 100.00 WA
10591 Phinney Ridge 98103 SEATTLE 71.40 WA
10591 Phinney Ridge 98117 SEATTLE 17.60 WA
10591 Phinney Ridge 98107 SEATTLE 10.90 WA
10592 Pike Place Market 98101 SEATTLE 81.30 WA
10592 Pike Place Market 98121 SEATTLE 18.70 WA
10593 Pinehurst 98125 SEATTLE 99.90 WA
10594 Pioneer Square 98171 SEATTLE 100.00 WA
10594 Pioneer Square 98194 SEATTLE 100.00 WA
10594 Pioneer Square 98104 SEATTLE 90.10 WA
10594 Pioneer Square 98134 SEATTLE 8.90 WA
10595 Portage Bay 98102 SEATTLE 100.00 WA
10596 Rainier Beach 98178 SEATTLE 51.80 WA
10596 Rainier Beach 98118 SEATTLE 48.20 WA
10597 Rainier View 98178 SEATTLE 99.70 WA
10598 Ravenna 98115 SEATTLE 69.70 WA
10598 Ravenna 98105 SEATTLE 30.30 WA
10599 Riverview 98106 SEATTLE 100.00 WA
10600 Roosevelt 98115 SEATTLE 99.60 WA
10601 Roxhill 98126 SEATTLE 99.90 WA
10602 Sand Point 98115 SEATTLE 99.90 WA
10603 Seaview 98136 SEATTLE 92.60 WA
10603 Seaview 98116 SEATTLE 7.40 WA
10604 Seward Park 98118 SEATTLE 100.00 WA
10605 South Beacon Hill 98118 SEATTLE 68.50 WA
10605 South Beacon Hill 98108 SEATTLE 31.40 WA
10606 South Delridge 98106 SEATTLE 97.50 WA
10607 South Park 98108 SEATTLE 93.40 WA
10607 South Park 98106 SEATTLE 6.60 WA
10608 South-Lake Union 98109 SEATTLE 83.90 WA
10608 South-Lake Union 98102 SEATTLE 16.10 WA
10609 Southeast Magnolia 98199 SEATTLE 100.00 WA
10610 Stevens 98112 SEATTLE 93.40 WA
10610 Stevens 98122 SEATTLE 6.60 WA
10611 Sunset Hill 98117 SEATTLE 74.60 WA
10611 Sunset Hill 98107 SEATTLE 25.40 WA
10612 University District 98195 SEATTLE 100.00 WA
10612 University District 98105 SEATTLE 76.80 WA
10612 University District 98195 SEATTLE 22.60 WA
10613 Victory Heights 98175 SEATTLE 100.00 WA
10613 Victory Heights 98165 SEATTLE 100.00 WA
10613 Victory Heights 98125 SEATTLE 99.00 WA
10614 View Ridge 98115 SEATTLE 100.00 WA
10615 Wallingford 98103 SEATTLE 75.60 WA
10615 Wallingford 98105 SEATTLE 24.40 WA
10616 Wedgewood 98115 SEATTLE 100.00 WA
10617 West Queen Anne 98119 SEATTLE 100.00 WA
10618 West Woodland 98107 SEATTLE 100.00 WA
10619 Westlake 98109 SEATTLE 100.00 WA
10620 Whittier Heights 98117 SEATTLE 99.90 WA
10621 Windermere 98105 SEATTLE 61.80 WA
10621 Windermere 98115 SEATTLE 38.20 WA
10622 Yesler Terrace 98104 SEATTLE 67.60 WA
10622 Yesler Terrace 98122 SEATTLE 32.40 WA
12753 Magnolia - Queen Anne 98139 SEATTLE 100.00 WA
12753 Magnolia - Queen Anne 98199 SEATTLE 52.30 WA
12753 Magnolia - Queen Anne 98119 SEATTLE 30.40 WA
12753 Magnolia - Queen Anne 98109 SEATTLE 17.00 WA
12754 Delridge 98106 SEATTLE 68.40 WA
12754 Delridge 98126 SEATTLE 29.80 WA
12755 West Seattle 98116 SEATTLE 37.70 WA
12755 West Seattle 98136 SEATTLE 30.00 WA
12755 West Seattle 98126 SEATTLE 20.30 WA
12755 West Seattle 98146 SEATTLE 11.90 WA
12756 Ballard 98117 SEATTLE 57.20 WA
12756 Ballard 98107 SEATTLE 33.30 WA
12756 Ballard 98177 SEATTLE 9.50 WA
12757 Northwest Seattle 98113 SEATTLE 100.00 WA
12757 Northwest Seattle 98133 SEATTLE 32.90 WA
12757 Northwest Seattle 98103 SEATTLE 29.30 WA
12757 Northwest Seattle 98177 SEATTLE 17.30 WA
12757 Northwest Seattle 98115 SEATTLE 8.80 WA
12757 Northwest Seattle 98117 SEATTLE 7.30 WA
12758 Lake Union 98103 SEATTLE 54.40 WA
12758 Lake Union 98109 SEATTLE 15.20 WA
12758 Lake Union 98102 SEATTLE 11.90 WA
12758 Lake Union 98105 SEATTLE 10.90 WA
12758 Lake Union 98107 SEATTLE 7.50 WA
12759 Downtown 98181 SEATTLE 100.00 WA
12759 Downtown 98138 SEATTLE 100.00 WA
12759 Downtown 98111 SEATTLE 100.00 WA
12759 Downtown 98114 SEATTLE 100.00 WA
12759 Downtown 98124 SEATTLE 100.00 WA
12759 Downtown 98127 SEATTLE 100.00 WA
12759 Downtown 98129 SEATTLE 100.00 WA
12759 Downtown 98141 SEATTLE 100.00 WA
12759 Downtown 98145 SEATTLE 100.00 WA
12759 Downtown 98170 SEATTLE 100.00 WA
12759 Downtown 98171 SEATTLE 100.00 WA
12759 Downtown 98184 SEATTLE 100.00 WA
12759 Downtown 98185 SEATTLE 100.00 WA
12759 Downtown 98190 SEATTLE 100.00 WA
12759 Downtown 98191 SEATTLE 100.00 WA
12759 Downtown 98194 SEATTLE 100.00 WA
12759 Downtown 98104 SEATTLE 41.60 WA
12759 Downtown 98101 SEATTLE 24.20 WA
12759 Downtown 98121 SEATTLE 19.90 WA
12759 Downtown 98122 SEATTLE 8.70 WA
12760 Greater Duwamish 98108 SEATTLE 50.20 WA
12760 Greater Duwamish 98134 SEATTLE 27.40 WA
12760 Greater Duwamish 98118 SEATTLE 11.90 WA
12760 Greater Duwamish 98144 SEATTLE 9.70 WA
12761 Central Seattle 98122 SEATTLE 54.70 WA
12761 Central Seattle 98144 SEATTLE 32.80 WA
12761 Central Seattle 98112 SEATTLE 12.50 WA
12762 North Seattle 98175 SEATTLE 100.00 WA
12762 North Seattle 98165 SEATTLE 100.00 WA
12762 North Seattle 98125 SEATTLE 79.30 WA
12762 North Seattle 98115 SEATTLE 20.70 WA
12763 Northeast Seattle 98195 SEATTLE 100.00 WA
12763 Northeast Seattle 98115 SEATTLE 52.00 WA
12763 Northeast Seattle 98105 SEATTLE 34.30 WA
12763 Northeast Seattle 98112 SEATTLE 6.20 WA
12764 Capitol Hill 98112 SEATTLE 65.90 WA
12764 Capitol Hill 98102 SEATTLE 23.00 WA
12764 Capitol Hill 98122 SEATTLE 10.50 WA
12765 Ranier Valley 98118 SEATTLE 65.30 WA
12765 Ranier Valley 98178 SEATTLE 17.30 WA
12765 Ranier Valley 98144 SEATTLE 13.60 WA
14742 Washington Park 98112 SEATTLE 100.00 WA
14743 Junction 98116 SEATTLE 96.10 WA
14744 Judkins Park 98144 SEATTLE 100.00 WA
14745 Highline 98168 SEATTLE 47.40 WA
14745 Highline 98146 SEATTLE 38.70 WA
14745 Highline 98108 SEATTLE 8.20 WA
14745 Highline 98106 SEATTLE 5.00 WA
15053 Shorewood on the Sound 98146 SEATTLE 97.10 WA
15054 Salmon Creek 98146 SEATTLE 98.80 WA
21157 Lake Forest Park 98155 SEATTLE 97.20 WA
21158 Riverton-Boulevard Park 98168 SEATTLE 82.30 WA
21158 Riverton-Boulevard Park 98108 SEATTLE 17.70 WA
21160 Shoreline 98160 SEATTLE 100.00 WA
21160 Shoreline 98155 SEATTLE 34.00 WA
21160 Shoreline 98133 SEATTLE 33.80 WA
21160 Shoreline 98177 SEATTLE 32.20 WA
21332 Bryn Mawr-Skyway 98178 SEATTLE 93.80 WA
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.