gistfile1.txt

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