Internal Revenue Service


The Internal Revenue Service (IRS) is a US government agency responsible for administering tax laws and collecting taxes. The IRS publishes aggregated individual income tax statistics and population data based on annual returns.

Example topics covered:

  • Taxable income

  • Total tax credits

  • Total charitable contributions

  • Population migration based on year-to-year address changes

  • Number of returns filed

  • Number of personal exemptions claimed

Key Attributes

Geographic Coverage

United States

Entity Level

Individual Income: Zip Code, State Migration: State

Time Granularity


Release Frequency



Individual Income: December 31, 2011 Migration: December 31, 2012

As with all Public Domain datasets, Cybersyn aims to release data on Snowflake Marketplace as soon as the underlying source releases new data. We check periodically for changes to the underlying source and, upon detecting a change, propagate the data to Snowflake Marketplace immediately. See our release process for more details.


IRS data illustrates underlying economic conditions at a zip code and state level as well as measuring population and aggregate income changes between counties and states. It also allows for specific measurement of county-to-county population flow.

All Cybersyn products follow the EAV (entity, attributes, value) model with a unified schema. Entities are tangible objects (e.g. geography, company) that Cybersyn provides data on. All timeseries' dates and values that refer to the entity are included in a timeseries table. Descriptors of the timeseries are included in an attributes table. Data is joinable across all Cybersyn products that have a GEO_ID. Refer to Cybersyn Concepts for more details.

Tables & Sources

Cybersyn Products

Tables above are available in the following Cybersyn data products:

Examples & Sample Queries

Track house prices and gross income inflow in a specific city

Compare Phoenix house prices vs gross income inflow

WITH county_map AS (
    FROM cybersyn.geography_relationships
    WHERE geo_name = 'Phoenix-Mesa-Scottsdale, AZ Metro Area'
    AND related_level = 'County'
), gross_income_data AS (
        geo_name AS msa,
        SUM(value) AS gross_income_inflow
    FROM cybersyn.irs_origin_destination_migration_timeseries AS ts
    JOIN county_map ON (county_map.related_geo_id = ts.to_geo_id)
    WHERE ts.variable_name = 'Adjusted Gross Income'
    GROUP BY geo_id, msa, date
), home_price_data AS (
    SELECT LAST_DAY(date, 'year') AS end_date, AVG(value) AS home_price_index
    FROM cybersyn.fhfa_house_price_timeseries AS ts
    JOIN cybersyn.fhfa_house_price_attributes AS att
        ON (ts.variable = att.variable)
    WHERE geo_id IN (SELECT geo_id FROM county_map)
      AND att.index_type = 'purchase-only'
      AND att.seasonally_adjusted = TRUE
    GROUP BY end_date
FROM gross_income_data AS gid
JOIN home_price_data AS hpi ON ( = hpi.end_date)
ORDER BY date;

Find zip codes with top adjusted gross income per capita

Show the top 5 zip codes by gross income that have a population of at least 10k people

	geo.geo_name AS zip_code,
	ROUND(agi.value / NULLIF(pop.value, 0), 0) AS per_capita_income
FROM cybersyn.irs_individual_income_timeseries agi -- Adjusted gross income values
JOIN  cybersyn.irs_individual_income_timeseries pop -- Population (number of individuals) values
	ON (pop.geo_id = agi.geo_id
	    AND =
	    AND pop.value IS NOT NULL
	    AND = '2020-12-31'
	    AND pop.variable_name = 'Number of individuals, AGI bin: Total')
JOIN cybersyn.geography_index geo
    ON (agi.geo_id = geo.geo_id
        AND geo.level = 'CensusZipCodeTabulationArea')
WHERE agi.variable_name = 'Adjusted gross income (AGI), AGI bin: Total'
  AND agi.value IS NOT NULL
  AND pop.value > 10000
ORDER BY per_capita_income DESC


The data in this product is sourced from Internal Revenue Service (IRS).

Cybersyn is not endorsed by or affiliated with any of these providers. Contact for questions.

Last updated

Copyright © 2024 Cybersyn