{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["by county","state totals"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"by county","index":0,"n_rows":173,"n_cols":13,"rows_kept":173,"cut":false,"hidden":false,"merged":[[3,0,5,0],[3,2,4,2],[3,1,5,1],[3,5,3,6],[3,7,3,8],[0,0,0,12],[157,0,157,12],[158,0,158,12],[159,0,159,12],[160,0,160,12],[162,0,162,12],[161,0,161,12],[155,0,155,12],[3,3,3,4],[172,0,172,12],[1,0,1,12],[2,0,2,12],[3,9,3,12],[163,0,163,12],[164,0,164,12],[165,0,165,12],[156,0,156,12],[169,0,169,12],[170,0,170,12],[171,0,171,12],[166,0,166,12],[167,0,167,12],[168,0,168,12]]}
["MASSACHUSETTS"]
["Individual Income Tax Returns: \nSelected Income and Tax Items by State, \nCounty, and Size of Adjusted Gross Income, \nTax Year 2015                                                                                                                                                                                                                                                                                                                                                                                                           "]
["[Money amounts are in thousands of dollars]"]
["County \nFIPS \ncode [1]","Size of adjusted gross income by county","Number of returns"," Charitable Contributions",null,"Child tax credit",null,"Earned income credit [7]",null,"Number of volunteer prepared returns [2]"]
[null,null,null,"Number of returns","Amount","Number of returns","Amount","Number of returns","Amount","Total","Number of volunteer income tax assistance (VITA) prepared returns","Number of tax counseling for the elderly (TCE) prepared returns","Number of volunteer prepared \nreturns with\nEarned Income Credit"]
[null,null,-1,-72,-73,-92,-93,-106,-107,-8,-9,-10,-11]
[0,"MASSACHUSETTS",3396580,1035770,5505893,407200,484029,421540,870972,71900,38970,32960,13750]
[0,"Under $1",38030,0,0,50,17,3980,3341,350,210,150,0]
[0,"$1 under $10,000",482150,12780,11774,100,36,122210,119935,23430,12020,11420,5950]
[0,"$10,000 under $25,000",582350,37320,53329,27480,9194,173240,510400,23370,13380,10000,5250]
[0,"$25,000 under $50,000",736030,101750,176578,122520,115480,121380,236984,17760,10870,6890,2550]
[0,"$50,000 under $75,000",473620,145380,265485,88940,128887,730,312,4840,1940,2900,0]
[0,"$75,000 under $100,000",311440,144160,287268,72250,112000,0,0,1460,440,1020,0]
[0,"$100,000 under $200,000",531960,377460,918089,95860,118415,0,0,670,110,560,0]
[0,"$200,000 or more",241000,216920,3793370,0,0,0,0,20,0,20,0]
[]
[1,"Barnstable County",125300,42070,144263,11740,14523,12960,22752,2980,520,2450,210]
[1,"Under $1",2210,0,0,0,0,210,170,30,0,30,0]
[1,"$1 under $10,000",18150,880,851,0,0,4160,3457,960,160,800,110]
[1,"$10,000 under $25,000",22360,2570,3627,670,229,5160,12548,870,170,700,70]
[1,"$25,000 under $50,000",26920,5510,9401,3460,3239,3410,6567,660,130,530,30]
[1,"$50,000 under $75,000",18040,7190,13649,2900,4198,20,10,320,60,250,0]
[1,"$75,000 under $100,000",12150,6370,14356,2260,3662,0,0,90,0,90,0]
[1,"$100,000 under $200,000",18940,13610,40393,2450,3195,0,0,50,0,50,0]
[1,"$200,000 or more",6530,5940,61986,0,0,0,0,0,0,0,0]
[]
[3,"Berkshire County",65040,15350,60908,7730,9205,9720,18971,2170,1100,1070,390]
[3,"Under $1",880,0,0,0,0,100,77,0,0,0,0]
[3,"$1 under $10,000",10230,290,276,0,0,2970,2770,720,330,390,180]
[3,"$10,000 under $25,000",13610,850,1135,600,216,4000,10856,750,380,370,150]
[3,"$25,000 under $50,000",15820,2090,3185,2540,2375,2650,5268,520,330,190,60]
[3,"$50,000 under $75,000",8950,2640,4786,1810,2642,0,0,130,60,70,0]
[3,"$75,000 under $100,000",5840,2360,4776,1470,2248,0,0,50,0,50,0]
[3,"$100,000 under $200,000",7460,5060,14559,1310,1724,0,0,0,0,0,0]
[3,"$200,000 or more",2250,2060,32191,0,0,0,0,0,0,0,0]
[]
[5,"Bristol County",271590,71260,164855,39050,46493,40260,85813,6050,2800,3260,950]
[5,"Under $1",2590,0,0,0,0,270,256,0,0,0,0]
[5,"$1 under $10,000",40870,760,700,0,0,11530,12157,2070,870,1200,390]
[5,"$10,000 under $25,000",53380,2490,3271,3040,1039,17120,51315,2080,1050,1040,400]
[5,"$25,000 under $50,000",62370,7510,11175,11330,10713,11270,22056,1390,730,660,160]
[5,"$50,000 under $75,000",38360,11670,17628,8560,12428,70,29,360,110,250,0]
[5,"$75,000 under $100,000",25430,11920,19804,7150,11136,0,0,110,40,70,0]
[5,"$100,000 under $200,000",38910,28140,58264,8970,11177,0,0,40,0,40,0]
[5,"$200,000 or more",9680,8770,54013,0,0,0,0,0,0,0,0]
[]
[7,"Dukes County",11100,3380,14921,1100,1304,1320,1961,140,0,140,0]
[7,"Under $1",250,0,0,0,0,30,32,0,0,0,0]
[7,"$1 under $10,000",2000,90,78,0,0,480,281,40,0,40,0]
[7,"$10,000 under $25,000",2090,210,294,50,17,500,1052,30,0,30,0]
[7,"$25,000 under $50,000",2320,460,840,350,318,310,596,40,0,40,0]
[7,"$50,000 under $75,000",1490,580,1325,280,395,0,0,30,0,30,0]
[7,"$75,000 under $100,000",980,530,1520,210,327,0,0,0,0,0,0]
[7,"$100,000 under $200,000",1360,940,3187,210,247,0,0,0,0,0,0]
[7,"$200,000 or more",610,570,7677,0,0,0,0,0,0,0,0]
[]
[9,"Essex County",395070,123560,434427,51000,59244,55650,122494,6850,2600,4240,1010]
[9,"Under $1",4290,0,0,30,7,400,406,30,0,30,0]
[9,"$1 under $10,000",59190,1660,1407,0,0,14630,15050,2240,800,1440,410]
[9,"$10,000 under $25,000",72030,4660,6129,4170,1389,23840,74136,2160,900,1260,380]
[9,"$25,000 under $50,000",85420,12260,18680,16610,15487,16680,32860,1630,730,900,220]
[9,"$50,000 under $75,000",51660,17500,29700,10560,15449,100,42,520,120,390,0]
[9,"$75,000 under $100,000",34020,17140,31822,8380,13060,0,0,180,50,130,0]
[9,"$100,000 under $200,000",61270,45520,104305,11250,13852,0,0,90,0,90,0]
[9,"$200,000 or more",27190,24820,242384,0,0,0,0,0,0,0,0]
[]
[11,"Franklin County",35740,8220,21562,4590,5706,5060,9075,570,380,200,190]
[11,"Under $1",490,0,0,0,0,60,31,0,0,0,0]
[11,"$1 under $10,000",5190,180,115,0,0,1660,1377,220,150,80,100]
[11,"$10,000 under $25,000",7050,430,560,280,96,1960,5017,200,140,60,60]
[11,"$25,000 under $50,000",9010,1240,1658,1370,1304,1380,2650,130,90,40,30]
[11,"$50,000 under $75,000",5400,1520,2570,1150,1693,0,0,20,0,20,0]
[11,"$75,000 under $100,000",3530,1390,2679,960,1517,0,0,0,0,0,0]
[11,"$100,000 under $200,000",4190,2670,6181,830,1096,0,0,0,0,0,0]
[11,"$200,000 or more",880,790,7799,0,0,0,0,0,0,0,0]
[]
[13,"Hampden County",219070,50160,135140,32170,37019,44460,105306,6100,3600,2500,1580]
[13,"Under $1",2010,0,0,0,0,190,185,20,20,0,0]
[13,"$1 under $10,000",34930,730,738,0,0,12380,15148,2310,1390,920,780]
[13,"$10,000 under $25,000",48520,2280,3602,3040,997,19180,63974,2150,1380,770,590]
[13,"$25,000 under $50,000",54250,7030,12377,11850,11044,12620,25960,1240,700,530,210]
[13,"$50,000 under $75,000",30730,9570,17455,7030,10330,90,39,270,80,190,0]
[13,"$75,000 under $100,000",18480,8340,16884,4920,7787,0,0,80,30,60,0]
[13,"$100,000 under $200,000",24550,17150,41113,5330,6861,0,0,30,0,30,0]
[13,"$200,000 or more",5600,5060,42971,0,0,0,0,0,0,0,0]
[]
[15,"Hampshire County",72540,21160,62752,8450,10444,7400,12555,1770,780,990,270]
[15,"Under $1",920,0,0,0,0,90,60,0,0,0,0]
[15,"$1 under $10,000",10310,300,266,0,0,2530,1923,580,230,360,110]
[15,"$10,000 under $25,000",12570,850,1166,400,139,2820,6851,600,290,300,110]
[15,"$25,000 under $50,000",15980,2250,3184,1990,1868,1960,3721,440,220,220,50]
[15,"$50,000 under $75,000",10650,3410,5426,2010,2887,0,0,110,40,70,0]
[15,"$75,000 under $100,000",7360,3380,6671,1790,2746,0,0,40,0,40,0]
[15,"$100,000 under $200,000",11560,8080,20440,2260,2804,0,0,0,0,0,0]
[15,"$200,000 or more",3190,2890,25599,0,0,0,0,0,0,0,0]
[]
[17,"Middlesex County",798880,274650,1840947,82300,98551,68640,127990,15400,7570,7850,2330]
[17,"Under $1",9410,0,0,0,0,1010,789,100,70,40,0]
[17,"$1 under $10,000",104310,3090,2801,70,28,20950,17605,4670,2070,2610,960]
[17,"$10,000 under $25,000",113280,8760,12043,3960,1316,26860,71706,4670,2380,2290,890]
[17,"$25,000 under $50,000",157200,21420,37172,21020,19833,19680,37829,3930,2260,1660,480]
[17,"$50,000 under $75,000",109510,31660,59102,17670,25344,140,61,1300,550,760,0]
[17,"$75,000 under $100,000",74800,33060,67580,15670,23736,0,0,440,160,280,0]
[17,"$100,000 under $200,000",145770,101160,254813,23910,28294,0,0,270,80,190,0]
[17,"$200,000 or more",84600,75500,1407436,0,0,0,0,20,0,20,0]
[]
[19,"Nantucket County",7550,1970,12353,890,1060,690,1128,0,0,0,0]
[19,"Under $1",150,0,0,0,0,0,0,0,0,0,0]
[19,"$1 under $10,000",960,30,37,0,0,200,131,0,0,0,0]
[19,"$10,000 under $25,000",1330,90,144,40,12,300,689,0,0,0,0]
[19,"$25,000 under $50,000",1710,220,464,270,268,190,308,0,0,0,0]
[19,"$50,000 under $75,000",1140,270,684,240,326,0,0,0,0,0,0]
[19,"$75,000 under $100,000",600,220,636,170,237,0,0,0,0,0,0]
[19,"$100,000 under $200,000",1030,600,1989,170,217,0,0,0,0,0,0]
[19,"$200,000 or more",630,540,8399,0,0,0,0,0,0,0,0]
[]
[21,"Norfolk County",353590,135390,933303,35830,44004,28200,51499,5110,1990,3100,630]
[21,"Under $1",4210,0,0,20,10,420,406,50,20,30,0]
[21,"$1 under $10,000",48710,1490,1248,0,0,8850,7295,1610,560,1040,260]
[21,"$10,000 under $25,000",47750,4050,5789,1320,429,10990,28541,1620,640,970,240]
[21,"$25,000 under $50,000",64150,10350,18019,7670,7230,7880,15230,1220,590,630,130]
[21,"$50,000 under $75,000",47590,15950,29661,7580,10715,60,27,420,140,280,0]
[21,"$75,000 under $100,000",33680,16890,34811,7370,11204,0,0,130,40,90,0]
[21,"$100,000 under $200,000",66760,49270,122045,11870,14416,0,0,60,0,60,0]
[21,"$200,000 or more",40740,37390,721730,0,0,0,0,0,0,0,0]
[]
[23,"Plymouth County",259730,91820,305741,34170,42478,29470,59941,3870,1430,2450,440]
[23,"Under $1",2610,0,0,0,0,230,251,0,0,0,0]
[23,"$1 under $10,000",38630,1170,1054,0,0,8180,8222,1250,380,870,170]
[23,"$10,000 under $25,000",42980,3360,4396,1980,687,12050,34525,1180,470,710,160]
[23,"$25,000 under $50,000",52400,9270,14204,8930,8439,8950,16917,960,460,510,110]
[23,"$50,000 under $75,000",35550,13440,22425,7450,10920,60,26,320,90,230,0]
[23,"$75,000 under $100,000",25020,13660,24630,6490,10440,0,0,120,30,90,0]
[23,"$100,000 under $200,000",45490,35210,76989,9320,11992,0,0,40,0,40,0]
[23,"$200,000 or more",17050,15710,162043,0,0,0,0,0,0,0,0]
[]
[25,"Suffolk County",383100,79260,1028591,41140,44259,64160,137989,14040,13280,760,4680]
[25,"Under $1",4260,0,0,0,0,560,295,100,100,0,0]
[25,"$1 under $10,000",49610,800,889,30,8,18580,18871,4350,4130,220,1980]
[25,"$10,000 under $25,000",75320,2640,5000,4360,1405,27150,84381,4720,4510,210,1780]
[25,"$25,000 under $50,000",99970,9290,21911,18660,17748,17800,34411,4070,3880,190,920]
[25,"$50,000 under $75,000",58710,12080,27542,8880,12676,70,31,630,540,90,0]
[25,"$75,000 under $100,000",32150,11360,27260,4880,7095,0,0,120,90,30,0]
[25,"$100,000 under $200,000",41570,24730,70686,4330,5327,0,0,50,30,20,0]
[25,"$200,000 or more",21510,18360,875303,0,0,0,0,0,0,0,0]
[]
[27,"Worcester County",398370,117550,346130,57040,69739,53580,113498,6880,2930,3950,1100]
[27,"Under $1",3770,0,0,0,0,420,383,20,0,20,0]
[27,"$1 under $10,000",59070,1330,1314,0,0,15120,15648,2410,960,1450,500]
[27,"$10,000 under $25,000",70100,4090,6173,3580,1223,21330,64809,2350,1070,1280,440]
[27,"$25,000 under $50,000",88500,12850,24308,16460,15614,16600,32611,1540,750,800,160]
[27,"$50,000 under $75,000",55860,17890,33532,12810,18884,110,47,430,150,270,0]
[27,"$75,000 under $100,000",37410,17540,33839,10550,16805,0,0,90,0,90,0]
[27,"$100,000 under $200,000",63120,45310,103125,13640,17213,0,0,40,0,40,0]
[27,"$200,000 or more",20540,18540,143839,0,0,0,0,0,0,0,0]
["** - Not shown to avoid disclosure of information \nabout specific taxpayers.  However, the data are \ncombined with data in an adjacent size class, \nas appropriate, and included in the appropriate totals."]
["[1] The County Federal Information Processing System (FIPS) \nCodes used for these statistics were derived from the \nU.S. Census Bureau.  A complete list of codes can be obtained from"]
["https://www.census.gov/geo/reference/codes/cou.html"]
["[2] The \"Number of volunteer prepared returns\" shows counts of \nreturns prepared by IRS-certified volunteers to taxpayers with \nlimited income, persons with disabilities, limited English speaking \ntaxpayers, current and former members of the military, and \ntaxpayers who are 60 years of age and older."]
["[3] Includes primary taxpayers 60 years of age or older."]
["[4] Less deficit."]
["[5] \"Qualified dividends\" are ordinary dividends received \nin tax years beginning after 2002 that meet certain \nconditions and receive preferential tax rates. \nThe maximum qualified dividends tax rate is 15%."]
["[6] Includes the Alaskan permanent fund, reported by \nresidents of Alaska on Forms 1040A and 1040EZ's.  \nThis fund only applies to statistics in the totals, and the \nstate of Alaska."]
["[7] \"Earned income credit\" includes both the refundable \nand non-refundable portions.  The non-refundable portion \ncould reduce income tax and certain related taxes to zero. \nThe earned income credit amounts in excess of total tax \nliability, or amounts when there was no tax liability at all, \nwere refundable.  See footnote 8 below for explanation \nof the refundable portion of the earned income credit."]
["[8] The refundable portion of the \"earned income credit\" \nequals \"total income tax\" minus the \"earned income credit.\"  \nIf the result is negative, this amount is considered the \nrefundable portion.  No other refundable credits were \ntaken into account for this calculation."]
["[9]  \"Income tax\" reflects the amount reported on \nForm 1040 line 56.  It also includes data from \nForm 1040A and 1040EZ filers.  "]
["[10] \"Total tax liability\" differs from \"Income tax,\" in that\n\"Total tax liability\" includes the taxes from recapture of \ncertain prior-year credits, tax applicable to individual \nretirement arrangements (IRA's), social security taxes \non self-employment income and on certain tip income, \nadvanced earned income payments, household\nemployment taxes, and certain \"other taxes\" listed \nin the Form 1040 instructions."]
["[11] Reflects payments to or withholdings made to \n\"Total tax liability\".  This is the amount the tax filer \nowes when the income tax return is filed."]
["[12]  The amount of overpayments the tax filer requested to \nhave refunded. "]
["NOTE: This table presents aggregates of all returns filed and\nprocessed through the Individual Master File (IMF) system \nduring Calendar Year 2016, including any returns filed for \ntax years preceding 2015."]
["This table is based on tax returns as initially processed by IRS\nand does not reflect amended returns or errors that were\ncorrected after initial processing. In general, during administrative \nor Master File processing, taxpayer reporting discrepancies are \ncorrected only to the extent necessary. The statistics in the county \ndata should, therefore, be used with the knowledge that some of the \ndata have not been perfected or edited for statistical purposes \nand that State totals in this table may not be altogether \ncomparable to other State totals published by the IRS, \nStatistics of Income Division. "]
["Detail may not add to totals because of rounding."]
["SOURCE: IRS, Statistics of Income Division, \nIndividual Master File System, August 2017."]

{"sheet":"state totals","index":1,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,5,0],[3,1,5,1],[3,2,4,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,11]]}
["MASSACHUSETTS"]
["Individual Income Tax Returns: \nSelected Income and Tax Items by State, \nCounty, and Size of Adjusted Gross Income, \nTax Year 2015                                                                                                                                                                                                                                                                                                                                                                                                           "]
["[Money amounts are in thousands of dollars]"]
["County \nFIPS \ncode [1]","Size of adjusted gross income by county","Number of returns"," Charitable \nContributions",null,"Child tax credit",null,"Earned income \ncredit [7]",null,"Number of volunteer prepared returns [2]"]
[null,null,null,"Number of returns","Amount","Number of returns","Amount","Number of returns","Amount","Number of volunteer income tax assistance (VITA) prepared returns","Number of tax counseling for the elderly (TCE) prepared returns","Number of volunteer prepared \nreturns with\nEarned Income Credit"]
[null,null,-1,-72,-73,-92,-93,-106,-107,-9,-10,-11]
[0,"MASSACHUSETTS",3396580,1035770,5505893,407200,484029,421540,870972,38970,32960,13750]
[0,"Under $1",38030,0,0,50,17,3980,3341,210,150,0]
[0,"$1 under $10,000",482150,12780,11774,100,36,122210,119935,12020,11420,5950]
[0,"$10,000 under $25,000",582350,37320,53329,27480,9194,173240,510400,13380,10000,5250]
[0,"$25,000 under $50,000",736030,101750,176578,122520,115480,121380,236984,10870,6890,2550]
[0,"$50,000 under $75,000",473620,145380,265485,88940,128887,730,312,1940,2900,0]
[0,"$75,000 under $100,000",311440,144160,287268,72250,112000,0,0,440,1020,0]
[0,"$100,000 under $200,000",531960,377460,918089,95860,118415,0,0,110,560,0]
[0,"$200,000 or more",241000,216920,3793370,0,0,0,0,0,20,0]