Winning Strategies for Long Term Investors (Advertisement)

IRS tax return data by zip codes


By Patrick   Follow   Fri, 4 May 2012, 2:14pm   8,255 views   48 comments
Watch (1)   Share   Quote   Permalink   Like   Dislike  

I've created a page to display IRS tax return data by zip code, broken down by adjusted gross income (AGI) class. Here's an example:

http://patrick.net/housing/irs_data.php?zip=94025

It's pretty interesting. It would be even more interesting to correlate it with house prices.

How else can I improve the presentation, or navigation?

« First     « Previous     Viewing Comments 9-48 of 48     Last »     See most liked comments

  1. E-man


    Follow
    Befriend (31)
    34 threads
    2,612 comments
    San Jose, CA
    Premium

    9   6:53am Sat 5 May 2012   Share   Quote   Permalink   Like (1)   Dislike (1)  

    Mick Russom says

    Not really. Its not about intelligence or experience. Its about connections, rainmaking and first picks.

    Dont think that one's capability enables success. It doesn't. Your lack of capability can destroy your chances, but most of the folks making mega bank or are famous are mostly lucky schmucks, right place, right time, right connections, right parents.

    Mick,

    Living in the fortress increases your kids' chance to be ....... right............. As you've mentioned above.

    Why don't you bust your ass to become the right parents and give your kids a chance to meet the right connections and become one of those lucky schmucks instead of whining on the Internet?

  2. E-man


    Follow
    Befriend (31)
    34 threads
    2,612 comments
    San Jose, CA
    Premium

    10   7:02am Sat 5 May 2012   Share   Quote   Permalink   Like   Dislike  

    Patrick,

    Looks like the top tier's total tax liability over AGI is around 22% while the 2nd top tier's tax liability is 14%.

    Interesting that the top tier's passive income (interest & dividend) is over $82k per year. I can live pretty comfortable in the south bay based on that passive income.

    The unemployment compensation is very low, less than 2%, across the board. Does this mean 98% of the people are working???

  3. Patrick


    Follow
    Befriend (54)
    5,240 threads
    6,175 comments
    46 male
    Menlo Park, CA
    Premium

    11   9:26am Sat 5 May 2012   Share   Quote   Permalink   Like (1)   Dislike  

    Good idea, I will add in total tax liability divided by AGI.

    I think the low unemployment comp just means that most people who filed returns didn't get much unemployment money.

    Now that I look a little more closely, even though capital gains goes up hugely in the top tier, those people still get most of their money on average from wages and salaries.

    There is huge wealth in unrealized stock gains that doesn't show up in that chart at all. For example, Sergei Brin lives in Menlo Park, and I bet almost all his Google worth is still in stock that he never sold and so doesn't have to report.

  4. xenogear3


    Follow
    Befriend
    10 threads
    419 comments

    12   10:48am Sat 5 May 2012   Share   Quote   Permalink   Like   Dislike  

    Low income and welfare don't have to file.
    I bet they are not included.

    I have no problem with VC.
    If someone pays $100 billion for Facebook or $1500 for gold, that is his own problem.

  5. Mick Russom


    Follow
    Befriend (2)
    7 threads
    542 comments
    Belmont, CA

    13   1:07pm Sat 5 May 2012   Share   Quote   Permalink   Like   Dislike  

    E-man says

    Why don't you bust your ass to become the right parents and give your kids a chance to meet the right connections and become one of those lucky schmucks instead of whining on the Internet?

    Wont work. The SillyCON valley has changed sufficiently to the point with even two good jobs and some modest connections busting your ass is a crap-shoot with terrible odds. And while busting my ass I cant spend time with the kids.

    Its times to leave this idiot rat race. Best of luck chasing pie in the sky.

  6. Dan8267


    Follow
    Befriend (17)
    785 threads
    7,970 comments
    Boca Raton, FL
    Premium

    14   1:42pm Sat 5 May 2012   Share   Quote   Permalink   Like   Dislike  

    It would be interesting, possibly useful, to see the tax returns graphed on Google Earth. Color the zip codes from brown (dirt-poor) to green (rich, the color of money) based on how rich they are.

  7. bubblesitter


    Follow
    Befriend (5)
    10 threads
    2,329 comments

    15   4:18pm Sat 5 May 2012   Share   Quote   Permalink   Like   Dislike  

    Dan8267 says

    It would be interesting, possibly useful, to see the tax returns graphed on Google Earth. Color the zip codes from brown (dirt-poor) to green (rich, the color of money) based on how rich they are.

    BA(sorry,fortress!) will be lush green.

  8. Patrick


    Follow
    Befriend (54)
    5,240 threads
    6,175 comments
    46 male
    Menlo Park, CA
    Premium

    16   4:54pm Sat 5 May 2012   Share   Quote   Permalink   Like   Dislike  

    Good idea. How could I also illustrate a huge inequality of income in a zip code? Menlo Park is like that. There is a very poor part on the east side of highway 101, and it gets richer and richer as you move west on the other side.

    Also, how do you shade a whole zip code? I tried to do that once but couldn't find all the boundary data. Maybe Google maps now has zip code boundaries as a feature?

    Ah, yes, searching for just 94025 in Google maps does outline the zip code.

  9. Dan8267


    Follow
    Befriend (17)
    785 threads
    7,970 comments
    Boca Raton, FL
    Premium

    17   6:47pm Sat 5 May 2012   Share   Quote   Permalink   Like   Dislike  

    Patrick says

    How could I also illustrate a huge inequality of income in a zip code?

    Option 1
    Use hue to indicate the median income and brightness or saturation to indicate the standard deviation.

    Option 2
    Use 9 digit zip codes instead of 5 digit ones. The greater resolution will allow for showing huge income gaps in small areas.

    Option 3
    Use a linear gradient that goes from the min value to the median value to the max value. This would show how the wealth is spread, but the maps would look a bit confusing.

    Option 4
    Break into the IRS database and get all the individual returns. Then paint each house by it's income. You'll also need to adjust for income hiding by doubling the reported income of registered Republicans.

  10. Patrick


    Follow
    Befriend (54)
    5,240 threads
    6,175 comments
    46 male
    Menlo Park, CA
    Premium

    18   1:58pm Sun 6 May 2012   Share   Quote   Permalink   Like   Dislike  

    Patrick says

    Good idea, I will add in total tax liability divided by AGI.

    OK, done. Last row is total tax liability divided by AGI. And the first row is the % of returns in each income class.

  11. unclemat


    Follow
    Befriend
    1 threads
    30 comments

    19   2:59pm Sun 6 May 2012   Share   Quote   Permalink   Like   Dislike  

    This is great! Very interesting and indeed gives some insight into particular locale's buying power and real estate prices.

    One request: please add median values. The averages in the highest bracket are really skewed up by super earners and you'll always find a few in posh towns.

    Thanks!

  12. thomas.wong1986


    Follow
    Befriend
    16 threads
    4,426 comments

    20   3:58pm Sun 6 May 2012   Share   Quote   Permalink   Like   Dislike  

    Mick Russom says

    but most of the folks making mega bank or are famous are mostly lucky schmucks, right place, right time, right connections, right parents.

    being at the right place right time has very little to do with living in Los altos, MP or the rest. If buying into LA would give you a bigger chance, than it would follow many from decades pasts would be gods today... clearly not the case if you been here for some time.

  13. Patrick


    Follow
    Befriend (54)
    5,240 threads
    6,175 comments
    46 male
    Menlo Park, CA
    Premium

    21   4:10pm Sun 6 May 2012   Share   Quote   Permalink   Like   Dislike  

    unclemat says

    One request: please add median values. The averages in the highest bracket are really skewed up by super earners and you'll always find a few in posh towns.

    I would love to, but the IRS doesn't publish enough data to do that, at least not in the data set I got from them. They lump people together in groups to protect the privacy of billionaires.

    So all I have is the total income reported and the number of tax returns it was reported for. Can't get a median out of that, only an average.

    Hmmm, I wonder what Warren Buffett's zip code is. Here it is:

    http://patrick.net/housing/irs_data.php?zip=68102

    Average income not all that huge.

  14. housingcasino4865


    Follow
    Befriend
    1 threads
    55 comments

    22   6:09am Tue 8 May 2012   Share   Quote   Permalink   Like   Dislike  

    I can't believe this! Everyone is paying between 5%-14% while the top tier is paying only 23%!!!! Those rat bastards!

    I can only imagine how many loopholes they exploited to get it down to that number: 23% !!! 'Believe that?? A mere 23% while everyone else is paying 5%-14% !!!! Raise their taxes!!! Make 'em pay their fair share!!! Come on... everyone else does!

    EAT THE RICH!

  15. freak80


    Follow
    Befriend (4)
    52 threads
    4,416 comments
    Corning, NY
    Premium

    23   7:24am Tue 8 May 2012   Share   Quote   Permalink   Like   Dislike  

    Mick Russom says

    Its times to leave this idiot rat race.

    That's a good idea. Ever read the book of Ecclesiastes in the Bible? Stop "chasing the wind."

  16. freak80


    Follow
    Befriend (4)
    52 threads
    4,416 comments
    Corning, NY
    Premium

    24   7:30am Tue 8 May 2012   Share   Quote   Permalink   Like   Dislike  

    Patrick says

    Hmmm, I wonder what Warren Buffett's zip code is. Here it is:
    http://patrick.net/housing/irs_data.php?zip=68102
    Average income not all that huge.

    Does Buffett live in the city of Omaha itself or in the suburbs?

  17. xenogear3


    Follow
    Befriend
    10 threads
    419 comments

    25   7:38am Tue 8 May 2012   Share   Quote   Permalink   Like   Dislike  

    housingcasino4865 says

    I can only imagine how many loopholes they exploited to get it down to that number: 23% !!! 'Believe that?? A mere 23% while everyone else is paying 5%-14% !!!!

    The poor people also pay the 7% Social Security Tax.

    The chart only shows >$200k. It includes some poor people who make less than $1 million.
    If you look at >$10 million, the tax rate is only 15%.

  18. ArtimusMaxtor


    Follow
    Befriend (3)
    803 comments

    26   9:36am Tue 8 May 2012   Share   Quote   Permalink   Like   Dislike  

    You might not think this video has any relevance in your life. Somewhere you just know there is a crazy tax.i. So that being the case I have wonder if this has to do with the concept of the Treasure of Serria madre in some way being thrust upon the common man in some kind of twisted scheme. What I am saying is that the people that run this monetary system just may be on that kind of adventure. Everyone else along for the ride. I'm not saying they are crazy you just might want to consider it.

    Aritmus M-16 if it ain't yours don't touch it.

    Actually thats Steve the Wonder steering with his knees.

  19. hanera


    Follow
    Befriend (3)
    124 comments

    27   10:55am Tue 8 May 2012   Share   Quote   Permalink   Like   Dislike  

    Patrick says

    There is huge wealth in unrealized stock gains that doesn't show up in that chart at all. For example, Sergei Brin lives in Menlo Park, and I bet almost all his Google worth is still in stock that he never sold and so doesn't have to report.

    He sold a billion dollar worth per year.

  20. Patrick


    Follow
    Befriend (54)
    5,240 threads
    6,175 comments
    46 male
    Menlo Park, CA
    Premium

    28   11:04am Tue 8 May 2012   Share   Quote   Permalink   Like   Dislike  

    Yes, it looks like you're right:

    http://biz.yahoo.com/t/27/6414.html

  21. hanera


    Follow
    Befriend (3)
    124 comments

    29   11:09am Tue 8 May 2012   Share   Quote   Permalink   Like   Dislike  

    Founders and employees of new web companies know what happen to those guys of the dot com era. So they sell regularly. Some monies probably went into RE.

  22. samsmom


    Follow
    Befriend
    13 threads
    57 comments

    30   1:31pm Tue 8 May 2012   Share   Quote   Permalink   Like   Dislike  

    How are all these people only paying 24% taxes over 200k? My husband is a "salaried partner" who works 80 hours per week, and finally got a raise last year after 5 years of building a business to 12 employees including 7 lawyers. All of his raise went to taxes. Not only does the govt take about 44% per paycheck, they asked for another 26k on April 15 which was the money we saved to put toward a downpayment on a house. ALL GONE!! I think we now pay over 50% of our income to taxes. Why even bother working hard??

    We have an appt with a new CPA on thursday to see if we can get our tax structure reworked so we can keep more of our money and finally buy a house!!

  23. freak80


    Follow
    Befriend (4)
    52 threads
    4,416 comments
    Corning, NY
    Premium

    31   1:37pm Tue 8 May 2012   Share   Quote   Permalink   Like   Dislike  

    samsmom says

    ALL GONE!! I think we now pay over 50% of our income to taxes. Why even bother working hard??
    We have an appt with a new CPA on thursday to see if we can get our tax structure reworked so we can keep more of our money and finally buy a house!!

    The solution is to raise the capital gains taxes on ultra high net worth individuals. And to quit getting into endless wars that we can't win.

    Eventually we'll need to introduce euthanasia since we won't be able to afford care of all the baby boomers.

  24. samsmom


    Follow
    Befriend
    13 threads
    57 comments

    32   1:57pm Tue 8 May 2012   Share   Quote   Permalink   Like   Dislike  

    Raising capital gains taxes wont help us. Our taxes will still remain the same or go up too. Once the bush tax credits expire, our taxes will go up another 3%. God only knows what the state will continue to take going forward.

    I keep reviewing over and over again how the effective tax rate for over 200k is only 24% in ANY ZIPCODE not just Menlo Park!! It's every single zipcode I plug in regardless of home prices or neighborhood status.

    What are we doing wrong? We don't have any income as capital gains because my husband works at a law firm. No stock options or real estate type investments either.

  25. Patrick


    Follow
    Befriend (54)
    5,240 threads
    6,175 comments
    46 male
    Menlo Park, CA
    Premium

    33   2:04pm Tue 8 May 2012   Share   Quote   Permalink   Like (1)   Dislike  

    samsmom says

    What are we doing wrong? We don't have any income as capital gains because my husband works at a law firm.

    What you are doing wrong is actually working for a living!

    America punishes hard work and rewards merely living off the work of other people.

    That's what the ultra-low capital gains tax is all about.

  26. hanera


    Follow
    Befriend (3)
    124 comments

    34   2:09pm Tue 8 May 2012   Share   Quote   Permalink   Like   Dislike  

    Long term solution is to cut down government expenditure and subsidy. Increase taxes is short-term and toxic. Can businesses increase prices whenever they like? No, they have to cut costs, improve efficiencies and think out of the box.

  27. freak80


    Follow
    Befriend (4)
    52 threads
    4,416 comments
    Corning, NY
    Premium

    35   3:59pm Tue 8 May 2012   Share   Quote   Permalink   Like   Dislike  

    Patrick says

    America punishes hard work and rewards merely living off the work of other people.

    That's what America is all about! How dare you question those All-American values. Slavery, genocide, and exploitation...that's what made America the Greatest Country in the World (tm)!

  28. housingcasino4865


    Follow
    Befriend
    1 threads
    55 comments

    36   1:53am Wed 9 May 2012   Share   Quote   Permalink   Like   Dislike  

    xenogear3 says

    housingcasino4865 says

    I can only imagine how many loopholes they exploited to get it down to that number: 23% !!! 'Believe that?? A mere 23% while everyone else is paying 5%-14% !!!!

    The poor people also pay the 7% Social Security Tax.

    The chart only shows >$200k. It includes some poor people who make less than $1 million.

    If you look at >$10 million, the tax rate is only 15%.

    Someone who makes $200K a year and has over a million in assets is a "millionaire". Isn't that who you want to raise taxes on? If it's 10-millonaires and over then why don't you socialists say it from the start? Most millionaires that I know are paying far more than 23% in taxes.

  29. housingcasino4865


    Follow
    Befriend
    1 threads
    55 comments

    37   1:57am Wed 9 May 2012   Share   Quote   Permalink   Like   Dislike  

    samsmom says

    How are all these people only paying 24% taxes over 200k? My husband is a "salaried partner" who works 80 hours per week, and finally got a raise last year after 5 years of building a business to 12 employees including 7 lawyers. All of his raise went to taxes. Not only does the govt take about 44% per paycheck, they asked for another 26k on April 15 which was the money we saved to put toward a downpayment on a house. ALL GONE!! I think we now pay over 50% of our income to taxes. Why even bother working hard??

    We have an appt with a new CPA on thursday to see if we can get our tax structure reworked so we can keep more of our money and finally buy a house!!

    The reason it's showing 23% is probably because of deductions like real estate depreciation for investment properties. Sadly, it's only a temporary tax reduction because when you sell, all that depreciation is "recaptured". So their real tax rates are higher.

  30. xenogear3


    Follow
    Befriend
    10 threads
    419 comments

    38   3:02am Wed 9 May 2012   Share   Quote   Permalink   Like   Dislike  

    You cannot tell the actual percentage in taxes by looking at 1040.

    "Look Around the Poker Table; If You Can’t See the Sucker, You’re It !"

  31. housingcasino4865


    Follow
    Befriend
    1 threads
    55 comments

    39   3:49am Wed 9 May 2012   Share   Quote   Permalink   Like   Dislike  

    wthrfrk80 says

    samsmom says

    ALL GONE!! I think we now pay over 50% of our income to taxes. Why even bother working hard??

    We have an appt with a new CPA on thursday to see if we can get our tax structure reworked so we can keep more of our money and finally buy a house!!

    The solution is to raise the capital gains taxes on ultra high net worth individuals. And to quit getting into endless wars that we can't win.

    Eventually we'll need to introduce euthanasia since we won't be able to afford care of all the baby boomers.

    Here we go with the capital gains tax. Do any of you realize that much, and in some cases all of the capital gains are inflation?

    You buy shares for $100,000

    18.5 years later you sell at $200,000

    With the historical annual rate of inflation of 3.5%, over those 18.5 years your purchasing power is reduced by 50%.

    Net gain in real terms = $0.00

    In nominal terms = $100,000

    Now you pay a tax of $15,000!?

    With this type of investment you lose 7.5% of your purchasing power. Better than losing 50%, but still, you lose.

    And people want to raise capital gains taxes!???

    Do you not realize this is a game the government plays: wealth confiscation through inflation?

  32. freak80


    Follow
    Befriend (4)
    52 threads
    4,416 comments
    Corning, NY
    Premium

    40   6:48am Wed 9 May 2012   Share   Quote   Permalink   Like   Dislike  

    housingcasino4865 says

    Do you not realize this is a game the government plays: wealth confiscation through inflation?

    Oh I'm fully aware of that, yes. Inflation is a nefarious, hidden tax.

    Let's say I buy gold or stock or whatever...and it's nominal value increases...but not faster than inflation. In other words, its REAL value stays the same. But the gummint considers it a "capital gain." Hah! So they get to tax it.

    God Bless America.

  33. chemechie


    Follow
    Befriend
    99 comments
    Wheeling, WV

    41   7:42am Wed 9 May 2012   Share   Quote   Permalink   Like   Dislike  

    Could you add a line showing the average number of dependents (per tax return)? It would be interesting to see how it varies with income - I've seen articles claim it goes up with income, and other articles claim it goes down with income.
    Also, can you think of a way to compare zip codes? I'd like to see how my zip compares with others.

  34. GUAB


    Follow
    Befriend
    82 comments
    Scottsdale, AZ

    42   8:01am Wed 9 May 2012   Share   Quote   Permalink   Like   Dislike  

    Patrick says

    Yes, is that insane or what? Of course that's an average, so one billion-dollar payout skews it quite a bit. That's the problem with living near all those venture capitalists.

    Actually, that's not normally taxed as ordinary income -- not sure it would show up on that stat.

  35. GUAB


    Follow
    Befriend
    82 comments
    Scottsdale, AZ

    43   8:02am Wed 9 May 2012   Share   Quote   Permalink   Like   Dislike  

    wthrfrk80 says

    The solution is to raise the capital gains taxes on ultra high net worth individuals. And to quit getting into endless wars that we can't win.

    No. Sorry. Not a solution. At all.

  36. GUAB


    Follow
    Befriend
    82 comments
    Scottsdale, AZ

    44   8:08am Wed 9 May 2012   Share   Quote   Permalink   Like   Dislike  

    People need to stop looking at the overall percentage of high income earners in only one manner. Right now all people see is HEY HOW DID HE PAY ONLY 15% OVERALL TAXES! OMG OMG OMG OMG?

    Well, there's lots of reasons. The tax code is incredibly complex and unless you understand his individual situation, you have no right to judge. There could have been passive deductions that came from a sale of an asset, non-ordinary income, capital gains income, etc.

    The overall percentage is almost a useless figure.

  37. Patrick


    Follow
    Befriend (54)
    5,240 threads
    6,175 comments
    46 male
    Menlo Park, CA
    Premium

    45   4:44pm Wed 9 May 2012   Share   Quote   Permalink   Like   Dislike  

    GUAB says

    Patrick says

    Yes, is that insane or what? Of course that's an average, so one billion-dollar payout skews it quite a bit. That's the problem with living near all those venture capitalists.

    Actually, that's not normally taxed as ordinary income -- not sure it would show up on that stat.

    It's taxed as capital gains, so it shows up on your 1040, even if the rate on it is only 15%.

    Of course at the very high end, people like Steve Jobs, Mark Zuckerberg, and Larry Ellison don't even pay the 15%. They just borrow against their stock, and never sell. Then when they die, like Steve did, their heirs inherit the stock COMPLETELY TAX FREE.

    That's because the cost basis resets on their death. So their heirs technically have no gain.

    This is an excellent example of how our tax code has been thoroughly corrupted by the very rich.

  38. Patrick


    Follow
    Befriend (54)
    5,240 threads
    6,175 comments
    46 male
    Menlo Park, CA
    Premium

    46   4:57pm Wed 9 May 2012   Share   Quote   Permalink   Like   Dislike  

    chemechie says

    Could you add a line showing the average number of dependents (per tax return)? It would be interesting to see how it varies with income - I've seen articles claim it goes up with income, and other articles claim it goes down with income.

    Also, can you think of a way to compare zip codes? I'd like to see how my zip compares with others.

    Average number of dependents per return is line number 6.

    Not sure how I would compare two zip codes. Just do a difference of all the fields?

    I could probably add in national percentiles for things pretty easily.

  39. klarek


    Follow
    Befriend (7)
    1 threads
    1,217 comments

    47   4:37pm Sat 12 May 2012   Share   Quote   Permalink   Like   Dislike  

    GUAB says

    Right now all people see is HEY HOW DID HE PAY ONLY 15% OVERALL TAXES! OMG OMG OMG OMG?

    Well, there's lots of reasons. The tax code is incredibly complex....

    That is exactly the problem, and "complex" is an understatement. This is a game and a complete clusterf*ck. Efficient tax systems are supposed to minimize the number of factors, such as using a person's income, their consumption of market goods, or passage/participation (bridges, markets, tolls, etc). Our political climate seek to maximize the number of factors of the tax code. They tack on every single loophole imaginable: Deductions, credits, exemptions, deferred write-offs.... these all are insidious financial caveats, subsidies, corporate/lobbyist financial game-rigging, and social engineering.

    It is an enormous wast of money and resources. The cost of non-discretionary expenditures exceeded $1t in 2011, more than any other discretionary spending we, even more than defense spending. It's nearly double (in real dollars) what it cost 30 years ago. That's just for individual filers, corporation taxation loopholes are another horrible beast which needs to be slayed. Our govt revenue authority is giving back one dollar for every two dollars it takes in. It sort of defies the whole purpose of having a tax collection department, doesn't it? Treasury Dept acts is like a Blackjack dealer than a revenue management agency.

    I can't think of any good reason not to get rid of every single provision in the tax code and lower the tax rates. None. We could lower taxes below the rate for capital gains. Effective rates = actual rates, no more b.s. about the rich dodging the system, etc. Plus, a lot of that loophole outflow money goes to wealthy foreigners and unpatriotic Americans who cheat the system, live abroad or have an army of lawyers/accounts covering them, and are not accountable. We could close an enormous gap in our deficit just by cutting off that outflow, and it wouldn't impact legit investments or the economy. And as for the hundreds of thousands of govt/attorney/accountant jobs serving this system, they can apply their math skills in many better places and industries; no reason to preserve the status quo for their convenience IMO.

  40. bubblesitter


    Follow
    Befriend (5)
    10 threads
    2,329 comments

    48   5:27pm Sat 12 May 2012   Share   Quote   Permalink   Like   Dislike  

    Welcome back klarek.

« First     « Previous comments    

Premium member Patrick is moderator of this thread.

Email

Username

Watch comments by email
Home   Tips and Tricks   Questions or suggestions? Mail p@patrick.net  

Page took 219 milliseconds to create.