Migration Trends
v4.0
*** To see what's new in the Migration Trends feed, please refer to the Migration Trends v4.0 - Permanent vs. Seasonal
Use the Placer.ai Migration Trends Data-Feed to analyze people's migration over time for any region in the US. Analyze the net-migration, migration source, and destination, easily aggregated by ZCTA, DMA, CBSA, County, city/town, or State.
Placer’s migration data helps understand population trends and changes across the US. To ascertain a migration, we utilize our extensive roster of panelists and follow home region changes. A migration is defined as when a panelist is assigned a new home region for at least FIVE months. Please note that this differs from the census definition, but will allow a near real-time understanding of the trends in the market. For example, this will identify a student panelist moving to a new location for a semester.
Important
Please note - migration is defined when a panelist is assigned a new home region for at least FIVE consecutive months. To accurately determine migration, the calculation for a given month takes into account data for those elapsed months. Therefore at any given time a report will reflect parts of the data (in particular - the detailed origins/destinations moves in the AB files) with a latency of 5 months, while others (net migration & population changes) with a latency of 2 months, or up to the month prior to the last full calendar month. e.g. A report delivered in June will reflect net migration & population changes up to the end of April, and origins/destination moves up to the end of January.
Panelist moves lasting 2 to 5 months will be considered as "Seasonal Visitors", and moves of 5 months or more will be considered as affecting "Permanent residents" population.
Files Delivery
Once enabled, files will be uploaded to your cloud bucket (AWS/GCS) or delivered via email (see Delivery Details) once a month.
- Files will be located under this path:
/export/analytics/migration-trends/monthly/- upload date, example: 2020-01-11
- Each delivery includes a folder for each of the following region types: CBSA, DMA, county, citytown, state, ZCTA. In
each folder: migration[region_type]ab.csv, migration[region_type]net.csv,
migration[region_type]_metadata.csv - Delivery is done until the 15th of each month, each delivery includes full data history going back to 2018.
- Each file is GZip compressed
Data Retention and Usage
Placer's algorithms and data constantly improve, therefore we include all the history in every monthly export. We strongly suggest not to intermix data provided in old exports with new ones, to avoid data anomalies.
Zipcodes are actually ZCTAs
ZIP Code Tabulation Areas (ZCTAs) are generalized areal representations of United States Postal Service (USPS) ZIP Code service areas used by the US Census and are considered a common practice when analyzing Zip code population. For more information see this.
A Note about MS Excel
In order to display the data correctly, it's recommended to import the file to Excel, rather than opening it. Opening the file with Excel will work too, but some values may be displayed differently than expected (e.g ZCTAs that start with a zero such as '01003' may appear as 1003)
Schema Overview - migration_[region_type]_net.csv
Each row provides monthly net migration results per region type per month.
Important!
The permanent_residents_population for each month shows the sum of permanent_residents_population for the previous month as well as domestic migration, natural growth and international migration.
For example: The permanent_residents_population for November 2020, will be the permanent_residents_population for Oct 2020 + domestic migration throughout Oct 2020 + natural growth throughout Oct 2020 + international migration throughout Oct 2020.
The permanent_residents_population for January 2018 is used as a baseline.
The total_migration field shows the domestic migration between the named month and the next one. For example:
- The total_migration for November 2020, will include the number of people who migrated between November and December.
- The report for December 2020 will be released in January 2021 and will include the adjusted population up to December 2020. However, the 'total_migration' field will have values until November 2020, representing the migration between November and December.
The latest permanent_residents_population reflects the population counted up to the end of the previous calendar month.
Column | Description | Type | Example |
---|---|---|---|
[region_code] | The numeric code of the region. region_code can be one of: cbsa_code, dma_code, county_code, state_code, zipcode | string | '78705' |
month | Net-Migration month | YYYY-MM | 2019-01-01 |
permanent_residents_population | This metric calculation takes into consideration the previous month's population, net migration of people moving for over 5 months, natural growth, and international migration. | integer | 34598 |
migration_percent | A percentage of the adjusted region population who migrated within the US on the relevant month. Number could be positive or negative. | float | 0.71 |
population_growth_percent | A percentage of the adjusted region population which shows the population's natural growth (Births/Deaths) in the relevant month. Number could be positive or negative. | float | 4.32 |
international_migration_percent | A percentage of the adjusted region population which migrated internationally in the relevant month. Number could be positive or negative. | float | 0.66 |
total_pop_change | The total change in adjusted region population during that month. Number could be positive or negative. | integer | 10498 |
total_migration | The estimated net number of people who migrated domestically to the region during that month. Number could be positive or negative. | integer | 690 |
seasonal_visitors | The count of people currently residing in a region for periods longer than 2 months but only up to 5 months | integer | 1536 |
Schema Overview - migration_[region_type]_ab.csv
Important
Since a migration is defined when a panelist is assigned a new home region for at least 5 months, the _ab files include information no more recent than four months before the last full month. For example: if the feed is generated and delivered in May, it will include Migration data until December.
Each row provides monthly domestic migration results for a pair of source/destination region types and month.
Column | Description | Type | Example |
---|---|---|---|
month | Migration month | YYYY-MM | 2019-01 |
[region_code]_a | region code A region_code can be one of: cbsa_code, dma_code, county_code, state_code, zipcode | string | '90210' |
[region_code]_b | region code B region_code can be one of: cbsa_code, dma_code, county_code, state_code, zipcode | string | '90065' |
[region_code]_a_permanent_residents_population | The permanent residents population counted in region A. region_code can be one of: cbsa_code, dma_code, county_code, state_code, zipcode | integer | 21000 |
percentage_migrated_a_to_b | The percentage of population migrated from 'Region A' to 'Region B' on the relevant month | float | 0.47 |
percentage_migrated_b_to_a | The percentage of population migrated from 'Region B' to 'Region A' during the relevant month | float | 4.25 |
a_to_b | The number of people that migrated from 'Region A' to 'Region B' during the relevant month | integer | 1567 |
b_to_a | The number of people that migrated from 'Region B' to 'Region A' during the relevant month | integer | 345 |
Schema Overview - migration_[region_type]_metadata.csv
Each row includes metadata for a region.
Note the 'seasonal_magnitude' warning to improve analysis quality.
Column | Description | Type | Example |
---|---|---|---|
[region_code] | region_code can be one of: cbsa_code, dma_code, county_code, state_code, zipcode | string | '90210' |
[region_name] | region_name can be one state_name, cbsa_name, dma_name, county_name, zipcode_name | string | ‘Los Angeles’ |
baseline_population | Derived from the ACS 2018 1 year population average. Used as the baseline for the 'adjusted population estimates'. | integer | 19500 |
lat | Region’s center latitude | double | 34.100835 |
lng | Region’s center longitude | double | -118.41417 |
insufficient_data | regions with very low population, will have insufficient_data=true | boolean | False |
seasonal_magnitude | Ranges from 0.0 to 1.0 and used to measure the seasonality bias of the region (e.g. due to a University or a summer vacation destination). | double | 0.017317 |
Schema Sample File
Please find HERE migration trends feed's files with limited data for schema evaluation.
Updated 7 months ago