USA Income Tax Data By ZIP Code, 2014

Distribution of income for 6 earning brackets

@kaggle.wpncrh_zip_code_income_tax_data_2014

Table List

1 table(24.38 MB)

N 14zpallagi

@kaggle.wpncrh_zip_code_income_tax_data_2014.n_14zpallagi

24.38 MB
166670 rows
127 columns
Only the first 100 columns are shown

statefips STATEFIPS	state STATE	zipcode Zipcode	agi_stub Agi Stub	n1 N1	mars1 Mars1	mars2 MARS2	mars4 MARS4	prep PREP	n2 N2	numdep NUMDEP	total_vita TOTAL VITA	vita VITA	tce TCE	a00100 A00100	n02650 N02650	a02650 A02650	n00200 N00200	a00200 A00200	n00300 N00300	a00300 A00300	n00600 N00600	a00600 A00600	n00650 N00650	a00650 A00650	n00700 N00700	a00700 A00700	n00900 N00900	a00900 A00900	n01000 N01000	a01000 A01000	n01400 N01400	a01400 A01400	n01700 N01700	a01700 A01700	schf SCHF	n02300 N02300	a02300 A02300	n02500 N02500	a02500 A02500	n26270 N26270	a26270 A26270	n02900 N02900	a02900 A02900	n03220 N03220	a03220 A03220	n03300 N03300	a03300 A03300	n03270 N03270	a03270 A03270	n03150 N03150	a03150 A03150	n03210 N03210	a03210 A03210	n03230 N03230	a03230 A03230	n03240 N03240	a03240 A03240	n04470 N04470	a04470 A04470	a00101 A00101	n18425 N18425	a18425 A18425	n18450 N18450	a18450 A18450	n18500 N18500	a18500 A18500	n18300 N18300	a18300 A18300	n19300 N19300	a19300 A19300	n19700 N19700	a19700 A19700	n04800 N04800	a04800 A04800	n05800 N05800	a05800 A05800	n09600 N09600	a09600 A09600	n05780 N05780	a05780 A05780	n07100 N07100	a07100 A07100	n07300 N07300	a07300 A07300	n07180 N07180	a07180 A07180	n07230 N07230	a07230 A07230	n07240 N07240	a07240 A07240	n07220 N07220	a07220 A07220	n07260 N07260	a07260 A07260	n09400 N09400	a09400 A09400	n85770 N85770	a85770 A85770	n85775 N85775
1	AL		1	850050	481840	115070	240450	479900	1401930	548630	24840	16660	8180	11004990	850050	11187657	682860	8746419	95140	64688	43950	72642	38880	46689	13400	5825	145420	810441	35870	38739	37300	223749	107590	1047421	8170	33740	97553	36220	64407	8600	7880	151350	182667	2760	613	50	119	8530	30882	2440	5935	19660	17306	5640	16681	40	4	50060	697858	784033	21090	20029	22230	17571	25080	21675	48360	72527	23280	124980	37870	102592	328640	1830923	327060	194554			7910	2898	106200	36418	2470	66	8490	2768	32980	16979	32000	5460	31350	9543	2240	604	116380	153768	24900	84425	25060
1	AL		2	491370	200750	150290	125560	281350	1016010	375670	10850	7080	3780	17658446	491370	17836190	425830	14494884	92610	69421	41040	96100	36250	64683	51450	27881	62500	250528	31950	75029	34210	317668	101020	1791833	8600	18180	52682	88200	560917	10430	52953	94650	177744	11500	2756	160	739	6810	32249	6180	20701	37140	39070	2050	5249	70	45	106170	1595160	4041356	77320	129793	23420	28761	69770	56079	104850	240950	64890	349299	88100	331671	470700	8618302	468560	1043771			6830	4778	215720	192756	5920	265	28430	16078	45700	47932	67530	12516	122540	108415	10560	4749	37790	80221	10870	34145	11810
1	AL		3	259540	75820	142970	34070	156720	589190	186770	3170	1680	1490	15963943	259540	16117661	223910	12316371	82760	69005	39530	123290	35530	85619	62280	40993	39640	253529	31650	108577	28200	360311	72620	1757156	7680	8900	27490	60570	882812	10610	97042	68600	153718	8950	2229	160	1192	4810	27104	4850	19580	27650	29802	2070	4611	100	115	100170	1713071	6212309	81280	206019	15880	23310	80080	72769	99890	329474	73950	442924	85970	386048	258400	10205184	257860	1404518	110	76	2010	3392	114100	168113	8040	515	18010	9554	24340	31082	17950	2792	76950	116151	8970	3975	26800	65138	1720	5212	2660
1	AL		4	164840	26730	125410	10390	99750	423300	133020	1260	700	560	14294375	164840	14422811	143710	10817987	69880	62269	35700	126688	32500	90127	57000	43748	28060	232026	28920	139040	22560	378333	52890	1584142	6130	5060	16508	40540	793454	9960	116234	49710	128436	8540	2312	240	1949	3530	21584	3760	17523	19190	21700	640	1216	140	206	82040	1587508	7161929	70090	242031	9930	17481	72620	76413	81940	361954	67010	458211	73330	390545	164610	10045399	164300	1452758	270	322	650	1555	76400	129131	7960	693	15460	8450	17800	23168			54560	90111	6020	2195	19600	54016	200	426	750
1	AL		5	203650	18990	177070	5860	122670	565930	185150	1260	900	360	27387096	203650	27664725	181410	20155298	113360	141176	69620	368076	64740	274484	107690	111331	38850	571411	59170	547842	32290	825820	69810	2690393	8720	4820	17488	45910	1038902	24330	644799	71940	277629	12650	3343	1250	18046	7320	56851	5530	29992	22020	23255	4460	9213	640	2413	145150	3395412	20015351	132030	706154	11030	25051	135670	196303	145060	982577	123290	998836	134550	910154	203500	21014718	203230	3631329	2270	5243	390	1369	92860	126604	19520	5371	20550	11284	22740	31720			46520	63034	7940	2660	28990	113649			450
1	AL		6	51270	4160	45860	910	39250	148020	50820	80	80		22652783	51270	23073614	44660	11051815	40610	264670	32640	791136	31530	620013	29090	96411	13720	855431	31500	2331256	9340	444369	14820	833058	2630	520	1842	11220	292923	22620	4633716	22380	420831	1080	267	2770	86011	8520	92498	1140	10827					1660	61679	47840	2499208	21437993	45930	761404	1440	4867	45630	168515	47820	962132	36310	456194	45490	920293	51240	19692443	51230	5274998	15590	77387	50	171	21020	54852	15290	25542	3230	1747							1410	459	14770	124954			50
1	AL	35004	1	1510	970	230	270	740	2130	660	50	50		19419	1510	19780	1170	14552	200	134	80	141	80	95	50	16	210	1641	60	37	120	731	210	1970		60	160	90	152			250	361					40	168	20	85	40	33	20	62			140	1933	2280	50	35	80	62	80	57	140	172	80	422	120	288	670	4003	670	425					190	65					60	34	70	11	50	15			180	262	60	221	60
1	AL	35004	2	1280	590	370	270	630	2450	800				47683	1280	48168	1140	40323	210	188	100	181	90	120	210	113	160	957	70	127	80	809	230	3801		40	110	200	1416	40	109	270	485	40	10							120	136					330	4377	13273	270	490	50	54	260	150	330	749	270	1529	270	669	1240	25244	1240	3127			40	28	520	499			100	51	110	121	170	32	320	288	30	8	100	195	40	134	40
1	AL	35004	3	920	280	510	110	470	2070	650				56761	920	57275	840	47954	250	121	110	365	100	290	290	172	120	1183	90	191	70	942	170	3449		30	103	150	2254	30	297	280	514	30	8			30	180	20	50	140	157	30	58			410	6258	25156	360	953	40	58	350	227	410	1325	340	2049	340	1217	910	36673	910	5079					430	667	50	2	100	52	80	99	80	12	310	474	30	14	90	197
1	AL	35004	4	630	100	490	50	300	1650	530				54677	630	55041	600	47176	210	123	100	171	90	123	290	204	80	337	80	189	80	1380	140	2951		40	132	100	1927	20	275	210	364	30	8					30	116	120	135					340	5986	29897	310	1135	30	57	310	200	340	1493	310	2018	310	1365	630	38665	630	5605	20	54			310	545			100	61	70	86			250	391	40	9	50	99


CREATE TABLE n_14zpallagi (
  "statefips" BIGINT,
  "state" VARCHAR,
  "zipcode" BIGINT,
  "agi_stub" BIGINT,
  "n1" DOUBLE,
  "mars1" DOUBLE,
  "mars2" DOUBLE,
  "mars4" DOUBLE,
  "prep" DOUBLE,
  "n2" DOUBLE,
  "numdep" DOUBLE,
  "total_vita" DOUBLE,
  "vita" DOUBLE,
  "tce" DOUBLE,
  "a00100" DOUBLE,
  "n02650" DOUBLE,
  "a02650" DOUBLE,
  "n00200" DOUBLE,
  "a00200" DOUBLE,
  "n00300" DOUBLE,
  "a00300" DOUBLE,
  "n00600" DOUBLE,
  "a00600" DOUBLE,
  "n00650" DOUBLE,
  "a00650" DOUBLE,
  "n00700" DOUBLE,
  "a00700" DOUBLE,
  "n00900" DOUBLE,
  "a00900" DOUBLE,
  "n01000" DOUBLE,
  "a01000" DOUBLE,
  "n01400" DOUBLE,
  "a01400" DOUBLE,
  "n01700" DOUBLE,
  "a01700" DOUBLE,
  "schf" DOUBLE,
  "n02300" DOUBLE,
  "a02300" DOUBLE,
  "n02500" DOUBLE,
  "a02500" DOUBLE,
  "n26270" DOUBLE,
  "a26270" DOUBLE,
  "n02900" DOUBLE,
  "a02900" DOUBLE,
  "n03220" DOUBLE,
  "a03220" DOUBLE,
  "n03300" DOUBLE,
  "a03300" DOUBLE,
  "n03270" DOUBLE,
  "a03270" DOUBLE,
  "n03150" DOUBLE,
  "a03150" DOUBLE,
  "n03210" DOUBLE,
  "a03210" DOUBLE,
  "n03230" DOUBLE,
  "a03230" DOUBLE,
  "n03240" DOUBLE,
  "a03240" DOUBLE,
  "n04470" DOUBLE,
  "a04470" DOUBLE,
  "a00101" DOUBLE,
  "n18425" DOUBLE,
  "a18425" DOUBLE,
  "n18450" DOUBLE,
  "a18450" DOUBLE,
  "n18500" DOUBLE,
  "a18500" DOUBLE,
  "n18300" DOUBLE,
  "a18300" DOUBLE,
  "n19300" DOUBLE,
  "a19300" DOUBLE,
  "n19700" DOUBLE,
  "a19700" DOUBLE,
  "n04800" DOUBLE,
  "a04800" DOUBLE,
  "n05800" DOUBLE,
  "a05800" DOUBLE,
  "n09600" DOUBLE,
  "a09600" DOUBLE,
  "n05780" DOUBLE,
  "a05780" DOUBLE,
  "n07100" DOUBLE,
  "a07100" DOUBLE,
  "n07300" DOUBLE,
  "a07300" DOUBLE,
  "n07180" DOUBLE,
  "a07180" DOUBLE,
  "n07230" DOUBLE,
  "a07230" DOUBLE,
  "n07240" DOUBLE,
  "a07240" DOUBLE,
  "n07220" DOUBLE,
  "a07220" DOUBLE,
  "n07260" DOUBLE,
  "a07260" DOUBLE,
  "n09400" DOUBLE,
  "a09400" DOUBLE,
  "n85770" DOUBLE,
  "a85770" DOUBLE,
  "n85775" DOUBLE
);