List of the data tables as part of the Immigration System Statistics Home Office release. Summary and detailed data tables covering the immigration system, including out-of-country and in-country visas, asylum, detention, and returns.
If you have any feedback, please email MigrationStatsEnquiries@homeoffice.gov.uk.
The Microsoft Excel .xlsx files may not be suitable for users of assistive technology.
If you use assistive technology (such as a screen reader) and need a version of these documents in a more accessible format, please email MigrationStatsEnquiries@homeoffice.gov.uk
Please tell us what format you need. It will help us if you say what assistive technology you use.
Immigration system statistics, year ending March 2025
Immigration system statistics quarterly release
Immigration system statistics user guide
Publishing detailed data tables in migration statistics
Policy and legislative changes affecting migration to the UK: timeline
Immigration statistics data archives
https://assets.publishing.service.gov.uk/media/68258d71aa3556876875ec80/passenger-arrivals-summary-mar-2025-tables.xlsx">Passenger arrivals summary tables, year ending March 2025 (MS Excel Spreadsheet, 66.5 KB)
‘Passengers refused entry at the border summary tables’ and ‘Passengers refused entry at the border detailed datasets’ have been discontinued. The latest published versions of these tables are from February 2025 and are available in the ‘Passenger refusals – release discontinued’ section. A similar data series, ‘Refused entry at port and subsequently departed’, is available within the Returns detailed and summary tables.
https://assets.publishing.service.gov.uk/media/681e406753add7d476d8187f/electronic-travel-authorisation-datasets-mar-2025.xlsx">Electronic travel authorisation detailed datasets, year ending March 2025 (MS Excel Spreadsheet, 56.7 KB)
ETA_D01: Applications for electronic travel authorisations, by nationality
ETA_D02: Outcomes of applications for electronic travel authorisations, by nationality
https://assets.publishing.service.gov.uk/media/68247953b296b83ad5262ed7/visas-summary-mar-2025-tables.xlsx">Entry clearance visas summary tables, year ending March 2025 (MS Excel Spreadsheet, 113 KB)
https://assets.publishing.service.gov.uk/media/682c4241010c5c28d1c7e820/entry-clearance-visa-outcomes-datasets-mar-2025.xlsx">Entry clearance visa applications and outcomes detailed datasets, year ending March 2025 (MS Excel Spreadsheet, 29.1 MB)
Vis_D01: Entry clearance visa applications, by nationality and visa type
Vis_D02: Outcomes of entry clearance visa applications, by nationality, visa type, and outcome
Additional dat
VITAL SIGNS INDICATOR Migration (EQ4)
FULL MEASURE NAME Migration flows
LAST UPDATED December 2018
DESCRIPTION Migration refers to the movement of people from one location to another, typically crossing a county or regional boundary. Migration captures both voluntary relocation – for example, moving to another region for a better job or lower home prices – and involuntary relocation as a result of displacement. The dataset includes metropolitan area, regional, and county tables.
DATA SOURCE American Community Survey County-to-County Migration Flows 2012-2015 5-year rolling average http://www.census.gov/topics/population/migration/data/tables.All.html
CONTACT INFORMATION vitalsigns.info@bayareametro.gov
METHODOLOGY NOTES (across all datasets for this indicator) Data for migration comes from the American Community Survey; county-to-county flow datasets experience a longer lag time than other standard datasets available in FactFinder. 5-year rolling average data was used for migration for all geographies, as the Census Bureau does not release 1-year annual data. Data is not available at any geography below the county level; note that flows that are relatively small on the county level are often within the margin of error. The metropolitan area comparison was performed for the nine-county San Francisco Bay Area, in addition to the primary MSAs for the nine other major metropolitan areas, by aggregating county data based on current metropolitan area boundaries. Data prior to 2011 is not available on Vital Signs due to inconsistent Census formats and a lack of net migration statistics for prior years. Only counties with a non-negligible flow are shown in the data; all other pairs can be assumed to have zero migration.
Given that the vast majority of migration out of the region was to other counties in California, California counties were bundled into the following regions for simplicity: Bay Area: Alameda, Contra Costa, Marin, Napa, San Francisco, San Mateo, Santa Clara, Solano, Sonoma Central Coast: Monterey, San Benito, San Luis Obispo, Santa Barbara, Santa Cruz Central Valley: Fresno, Kern, Kings, Madera, Merced, Tulare Los Angeles + Inland Empire: Imperial, Los Angeles, Orange, Riverside, San Bernardino, Ventura Sacramento: El Dorado, Placer, Sacramento, Sutter, Yolo, Yuba San Diego: San Diego San Joaquin Valley: San Joaquin, Stanislaus Rural: all other counties (23)
One key limitation of the American Community Survey migration data is that it is not able to track emigration (movement of current U.S. residents to other countries). This is despite the fact that it is able to quantify immigration (movement of foreign residents to the U.S.), generally by continent of origin. Thus the Vital Signs analysis focuses primarily on net domestic migration, while still specifically citing in-migration flows from countries abroad based on data availability.
VITAL SIGNS INDICATOR Migration (EQ4)
FULL MEASURE NAME Migration flows
LAST UPDATED December 2018
DESCRIPTION Migration refers to the movement of people from one location to another, typically crossing a county or regional boundary. Migration captures both voluntary relocation – for example, moving to another region for a better job or lower home prices – and involuntary relocation as a result of displacement. The dataset includes metropolitan area, regional, and county tables.
DATA SOURCE American Community Survey County-to-County Migration Flows 2012-2015 5-year rolling average http://www.census.gov/topics/population/migration/data/tables.All.html
CONTACT INFORMATION vitalsigns.info@bayareametro.gov
METHODOLOGY NOTES (across all datasets for this indicator) Data for migration comes from the American Community Survey; county-to-county flow datasets experience a longer lag time than other standard datasets available in FactFinder. 5-year rolling average data was used for migration for all geographies, as the Census Bureau does not release 1-year annual data. Data is not available at any geography below the county level; note that flows that are relatively small on the county level are often within the margin of error. The metropolitan area comparison was performed for the nine-county San Francisco Bay Area, in addition to the primary MSAs for the nine other major metropolitan areas, by aggregating county data based on current metropolitan area boundaries. Data prior to 2011 is not available on Vital Signs due to inconsistent Census formats and a lack of net migration statistics for prior years. Only counties with a non-negligible flow are shown in the data; all other pairs can be assumed to have zero migration.
Given that the vast majority of migration out of the region was to other counties in California, California counties were bundled into the following regions for simplicity: Bay Area: Alameda, Contra Costa, Marin, Napa, San Francisco, San Mateo, Santa Clara, Solano, Sonoma Central Coast: Monterey, San Benito, San Luis Obispo, Santa Barbara, Santa Cruz Central Valley: Fresno, Kern, Kings, Madera, Merced, Tulare Los Angeles + Inland Empire: Imperial, Los Angeles, Orange, Riverside, San Bernardino, Ventura Sacramento: El Dorado, Placer, Sacramento, Sutter, Yolo, Yuba San Diego: San Diego San Joaquin Valley: San Joaquin, Stanislaus Rural: all other counties (23)
One key limitation of the American Community Survey migration data is that it is not able to track emigration (movement of current U.S. residents to other countries). This is despite the fact that it is able to quantify immigration (movement of foreign residents to the U.S.), generally by continent of origin. Thus the Vital Signs analysis focuses primarily on net domestic migration, while still specifically citing in-migration flows from countries abroad based on data availability.
Immigration system statistics quarterly release.
The Microsoft Excel .xlsx files may not be suitable for users of assistive technology.
If you use assistive technology (such as a screen reader) and need a version of these documents in a more accessible format, please email migrationstatistics@homeoffice.gov.uk
Please tell us what format you need. It will help us if you say what assistive technology you use.
https://assets.publishing.service.gov.uk/media/6825e438a60aeba5ab34e046/regional-and-local-authority-dataset-mar-2025.xlsx">Regional and local authority data on immigration groups, year ending March 2025 (MS Excel Spreadsheet, 279 KB)
Reg_01: Immigration groups, by Region and Devolved Administration
Reg_02: Immigration groups, by Local Authority
Please note that the totals across all pathways and per capita percentages for City of London and Isles of Scilly do not include Homes for Ukraine arrivals due to suppression, in line with published Homes for Ukraine figures.
https://assets.publishing.service.gov.uk/media/67bc89984ad141d90835347b/regional-and-local-authority-dataset-dec-2024.ods">Regional and local authority data on immigration groups, year ending December 2024 (ODS, 263 KB)
https://assets.publishing.service.gov.uk/media/675c7e1a98302e574b91539f/regional-and-local-authority-dataset-sep-24.ods">Regional and local authority data on immigration groups, year ending September 2024 (ODS, 262 KB)
https://assets.publishing.service.gov.uk/media/66bf74a8dcb0757928e5bd4c/regional-and-local-authority-dataset-jun-24.ods">Regional and local authority data on immigration groups, year ending June 2024 (ODS, 263 KB)
https://assets.publishing.service.gov.uk/media/66c31766b75776507ecdf3a1/regional-and-local-authority-dataset-mar-24-third-edition.ods">Regional and local authority data on immigration groups, year ending March 2024 (third edition) (ODS, 91.4 KB)
https://assets.publishing.service.gov.uk/media/65ddd9ebf1cab3001afc4795/regional-and-local-authority-dataset-dec-2023.ods">Regional and local authority data on immigration groups, year ending December 2023 (ODS, 91.6 KB)
https://assets.publishing.service.gov.uk/media/65ddda05cf7eb10011f57fbd/regional-and-local-authority-dataset-sep-2023.ods">Regional and local authority data on immigration groups, year ending September 2023 (ODS, 91.7 KB)
https://assets.publishing.service.gov.uk/media/655b39ce544aea000dfb301b/regional-and-local-authority-dataset-jun-2023.ods">Regional and local authority data on immigration groups, year ending June 2023 (ODS
This annual study provides migration pattern data for the United States by State or by county and are available for inflows (the number of new residents who moved to a State or county and where they migrated from) and outflows (the number of residents who left a State or county and where they moved to). The data include the number of returns filed, number of personal exemptions claimed, total adjusted gross income, and aggregate migration flows at the State level, by the size of adjusted gross income (AGI) and by age of the primary taxpayer. Data are collected and based on year-to-year address changes reported on U.S. Individual Income Tax Returns (Form 1040) filed with the IRS. SOI collects these data as part of its Individual Income Tax Return (Form 1040) Statistics program, Data by Geographic Areas, U.S. Population Migration Data.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Immigrants Admitted: Philippines data was reported at 53,287.000 Person in 2016. This records a decrease from the previous number of 56,478.000 Person for 2015. Immigrants Admitted: Philippines data is updated yearly, averaging 54,446.000 Person from Sep 1986 (Median) to 2016, with 31 observations. The data reached an all-time high of 74,606.000 Person in 2006 and a record low of 30,943.000 Person in 1999. Immigrants Admitted: Philippines data remains active status in CEIC and is reported by US Department of Homeland Security. The data is categorized under Global Database’s USA – Table US.G086: Immigration.
https://dataful.in/terms-and-conditionshttps://dataful.in/terms-and-conditions
The dataset consists of the number Removals by Country of Citizenship by the United State's Immigration and Customs Enforcement (ICE) in each fiscal year. An ICE removal is defined as the compulsory and confirmed movement of an inadmissible or deportable noncitizen out of the United States.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Analysis of ‘Missing Migrants Dataset’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/jmataya/missingmigrants on 14 February 2022.
--- Dataset description provided by original source is as follows ---
This data is sourced from the International Organization for Migration. The data is part of a specific project called the Missing Migrants Project which tracks deaths of migrants, including refugees , who have gone missing along mixed migration routes worldwide. The research behind this project began with the October 2013 tragedies, when at least 368 individuals died in two shipwrecks near the Italian island of Lampedusa. Since then, Missing Migrants Project has developed into an important hub and advocacy source of information that media, researchers, and the general public access for the latest information.
Missing Migrants Project data are compiled from a variety of sources. Sources vary depending on the region and broadly include data from national authorities, such as Coast Guards and Medical Examiners; media reports; NGOs; and interviews with survivors of shipwrecks. In the Mediterranean region, data are relayed from relevant national authorities to IOM field missions, who then share it with the Missing Migrants Project team. Data are also obtained by IOM and other organizations that receive survivors at landing points in Italy and Greece. In other cases, media reports are used. IOM and UNHCR also regularly coordinate on such data to ensure consistency. Data on the U.S./Mexico border are compiled based on data from U.S. county medical examiners and sheriff’s offices, as well as media reports for deaths occurring on the Mexico side of the border. Estimates within Mexico and Central America are based primarily on media and year-end government reports. Data on the Bay of Bengal are drawn from reports by UNHCR and NGOs. In the Horn of Africa, data are obtained from media and NGOs. Data for other regions is drawn from a combination of sources, including media and grassroots organizations. In all regions, Missing Migrants Projectdata represents minimum estimates and are potentially lower than in actuality.
Updated data and visuals can be found here: https://missingmigrants.iom.int/
IOM defines a migrant as any person who is moving or has moved across an international border or within a State away from his/her habitual place of residence, regardless of
(1) the person’s legal status;
(2) whether the movement is voluntary or involuntary;
(3) what the causes for the movement are; or
(4) what the length of the stay is.[1]
Missing Migrants Project counts migrants who have died or gone missing at the external borders of states, or in the process of migration towards an international destination. The count excludes deaths that occur in immigration detention facilities, during deportation, or after forced return to a migrant’s homeland, as well as deaths more loosely connected with migrants’ irregular status, such as those resulting from labour exploitation. Migrants who die or go missing after they are established in a new home are also not included in the data, so deaths in refugee camps or housing are excluded. This approach is chosen because deaths that occur at physical borders and while en route represent a more clearly definable category, and inform what migration routes are most dangerous. Data and knowledge of the risks and vulnerabilities faced by migrants in destination countries, including death, should not be neglected, rather tracked as a distinct category.
Data on fatalities during the migration process are challenging to collect for a number of reasons, most stemming from the irregular nature of migratory journeys on which deaths tend to occur. For one, deaths often occur in remote areas on routes chosen with the explicit aim of evading detection. Countless bodies are never found, and rarely do these deaths come to the attention of authorities or the media. Furthermore, when deaths occur at sea, frequently not all bodies are recovered - sometimes with hundreds missing from one shipwreck - and the precise number of missing is often unknown. In 2015, over 50 per cent of deaths recorded by the Missing Migrants Project refer to migrants who are presumed dead and whose bodies have not been found, mainly at sea.
Data are also challenging to collect as reporting on deaths is poor, and the data that does exist are highly scattered. Few official sources are collecting data systematically. Many counts of death rely on media as a source. Coverage can be spotty and incomplete. In addition, the involvement of criminal actors in incidents means there may be fear among survivors to report deaths and some deaths may be actively covered-up. The irregular immigration status of many migrants, and at times their families as well, also impedes reporting of missing persons or deaths.
The varying quality and comprehensiveness of data by region in attempting to estimate deaths globally may exaggerate the share of deaths that occur in some regions, while under-representing the share occurring in others.
The available data can give an indication of changing conditions and trends related to migration routes and the people travelling on them, which can be relevant for policy making and protection plans. Data can be useful to determine the relative risks of irregular migration routes. For example, Missing Migrants Project data show that despite the increase in migrant flows through the eastern Mediterranean in 2015, the central Mediterranean remained the more deadly route. In 2015, nearly two people died out of every 100 travellers (1.85%) crossing the Central route, as opposed to one out of every 1,000 that crossed from Turkey to Greece (0.095%). From the data, we can also get a sense of whether groups like women and children face additional vulnerabilities on migration routes.
However, it is important to note that because of the challenges in data collection for the missing and dead, basic demographic information on the deceased is rarely known. Often migrants in mixed migration flows do not carry appropriate identification. When bodies are found it may not be possible to identify them or to determine basic demographic information. In the data compiled by Missing Migrants Project, sex of the deceased is unknown in over 80% of cases. Region of origin has been determined for the majority of the deceased. Even this information is at times extrapolated based on available information – for instance if all survivors of a shipwreck are of one origin it was assumed those missing also came from the same region.
The Missing Migrants Project dataset includes coordinates for where incidents of death took place, which indicates where the risks to migrants may be highest. However, it should be noted that all coordinates are estimates.
By counting lives lost during migration, even if the result is only an informed estimate, we at least acknowledge the fact of these deaths. What before was vague and ill-defined is now a quantified tragedy that must be addressed. Politically, the availability of official data is important. The lack of political commitment at national and international levels to record and account for migrant deaths reflects and contributes to a lack of concern more broadly for the safety and well-being of migrants, including asylum-seekers. Further, it drives public apathy, ignorance, and the dehumanization of these groups.
Data are crucial to better understand the profiles of those who are most at risk and to tailor policies to better assist migrants and prevent loss of life. Ultimately, improved data should contribute to efforts to better understand the causes, both direct and indirect, of fatalities and their potential links to broader migration control policies and practices.
Counting and recording the dead can also be an initial step to encourage improved systems of identification of those who die. Identifying the dead is a moral imperative that respects and acknowledges those who have died. This process can also provide a some sense of closure for families who may otherwise be left without ever knowing the fate of missing loved ones.
As mentioned above, the challenge remains to count the numbers of dead and also identify those counted. Globally, the majority of those who die during migration remain unidentified. Even in cases in which a body is found identification rates are low. Families may search for years or a lifetime to find conclusive news of their loved one. In the meantime, they may face psychological, practical, financial, and legal problems.
Ultimately Missing Migrants Project would like to see that every unidentified body, for which it is possible to recover, is adequately “managed”, analysed and tracked to ensure proper documentation, traceability and dignity. Common forensic protocols and standards should be agreed upon, and used within and between States. Furthermore, data relating to the dead and missing should be held in searchable and open databases at local, national and international levels to facilitate identification.
For more in-depth analysis and discussion of the numbers of missing and dead migrants around the world, and the challenges involved in identification and tracing, read our two reports on the issue, Fatal Journeys: Tracking Lives Lost during Migration (2014) and Fatal Journeys Volume 2, Identification and Tracing of Dead and Missing Migrants
The data set records
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This dataset provides a global gridded (5 arc-min resolution) detailed annual net-migration dataset for 2000-2019. We also provide global annual birth and death rate datasets – that were used to estimate the net-migration – for same years. The dataset is presented in details, with some further analyses, in the following publication. Please cite this paper when using data.
Niva et al. 2023. World's human migration patterns in 2000-2019 unveiled by high-resolution data. Nature Human Behaviour 7: 2023–2037. Doi: https://doi.org/10.1038/s41562-023-01689-4
You can explore the data in our online net-migration explorer: https://wdrg.aalto.fi/global-net-migration-explorer/
Short introduction to the data
For the dataset, we collected, gap-filled, and harmonised:
a comprehensive national level birth and death rate datasets for altogether 216 countries or sovereign states; and
sub-national data for births (data covering 163 countries, divided altogether into 2555 admin units) and deaths (123 countries, 2067 admin units).
These birth and death rates were downscaled with selected socio-economic indicators to 5 arc-min grid for each year 2000-2019. These allowed us to calculate the 'natural' population change and when this was compared with the reported changes in population, we were able to estimate the annual net-migration. See more about the methods and calculations at Niva et al (2023).
We recommend using the data either over multiple years (we provide 3, 5 and 20 year net-migration sums at gridded level) or then aggregated over larger area (we provide adm0, adm1 and adm2 level geospatial polygon files). This is due to some noise in the gridded annual data.
Due to copy-right issues we are not able to release all the original data collected, but those can be requested from the authors.
List of datasets
Birth and death rates:
raster_birth_rate_2000_2019.tif: Gridded birth rate for 2000-2019 (5 arc-min; multiband tif)
raster_death_rate_2000_2019.tif: Gridded death rate for 2000-2019 (5 arc-min; multiband tif)
tabulated_adm1adm0_birth_rate.csv: Tabulated sub-national birth rate for 2000-2019 at the division to which data was collected (subnational data when available, otherwise national)
tabulated_ adm1adm0_death_rate.csv: Tabulated sub-national death rate for 2000-2019 at the division to which data was collected (subnational data when available, otherwise national)
Net-migration:
raster_netMgr_2000_2019_annual.tif: Gridded annual net-migration 2000-2019 (5 arc-min; multiband tif)
raster_netMgr_2000_2019_3yrSum.tif: Gridded 3-yr sum net-migration 2000-2019 (5 arc-min; multiband tif)
raster_netMgr_2000_2019_5yrSum.tif: Gridded 5-yr sum net-migration 2000-2019 (5 arc-min; multiband tif)
raster_netMgr_2000_2019_20yrSum.tif: Gridded 20-yr sum net-migration 2000-2019 (5 arc-min)
polyg_adm0_dataNetMgr.gpkg: National (adm 0 level) net-migration geospatial file (gpkg)
polyg_adm1_dataNetMgr.gpkg: Provincial (adm 1 level) net-migration geospatial file (gpkg) (if not adm 1 level division, adm 0 used)
polyg_adm2_dataNetMgr.gpkg: Communal (adm 2 level) net-migration geospatial file (gpkg) (if not adm 2 level division, adm 1 used; and if not adm 1 level division either, adm 0 used)
Files to run online net migration explorer
masterData.rds and admGeoms.rds are related to our online ‘Net-migration explorer’ tool (https://wdrg.aalto.fi/global-net-migration-explorer/). The source code of this application is available in https://github.com/vvirkki/net-migration-explorer. Running the application locally requires these two .rds files from this repository.
Metadata
Grids:
Resolution: 5 arc-min (0.083333333 degrees)
Spatial extent: Lon: -180, 180; -90, 90 (xmin, xmax, ymin, ymax)
Coordinate ref system: EPSG:4326 - WGS 84
Format: Multiband geotiff; each band for each year over 2000-2019
Units:
Birth and death rates: births/deaths per 1000 people per year
Net-migration: persons per 1000 people per time period (year, 3yr, 5yr, 20yr, depending on the dataset)
Geospatial polygon (gpkg) files:
Spatial extent: -180, 180; -90, 83.67 (xmin, xmax, ymin, ymax)
Temporal extent: annual over 2000-2019
Coordinate ref system: EPSG:4326 - WGS 84
Format: gkpk
Units:
Net-migration: persons per 1000 people per year
Open Government Licence - Canada 2.0https://open.canada.ca/en/open-government-licence-canada
License information was derived automatically
People who have been granted permanent resident status in Canada. Please note that in these datasets, the figures have been suppressed or rounded to prevent the identification of individuals when the datasets are compiled and compared with other publicly available statistics. Values between 0 and 5 are shown as “--“ and all other values are rounded to the nearest multiple of 5. This may result to the sum of the figures not equating to the totals indicated.
https://creativecommons.org/publicdomain/zero/1.0/https://creativecommons.org/publicdomain/zero/1.0/
The United States Census Bureau’s International Dataset provides estimates of country populations since 1950 and projections through 2050.
The U.S. Census Bureau provides estimates and projections for countries and areas that are recognized by the U.S. Department of State that have a population of at least 5,000. Specifically, the data set includes midyear population figures broken down by age and gender assignment at birth. Additionally, they provide time-series data for attributes including fertility rates, birth rates, death rates, and migration rates.
Fork this kernel to get started.
https://bigquery.cloud.google.com/dataset/bigquery-public-data:census_bureau_international
https://cloud.google.com/bigquery/public-data/international-census
Dataset Source: www.census.gov
This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source -http://www.data.gov/privacy-policy#data_policy - and is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset.
Banner Photo by Steve Richey from Unsplash.
What countries have the longest life expectancy?
Which countries have the largest proportion of their population under 25?
Which countries are seeing the largest net migration?
Open Government Licence - Canada 2.0https://open.canada.ca/en/open-government-licence-canada
License information was derived automatically
This table contains 25 series, with data for years 1955 - 2013 (not all combinations necessarily have data for all years). This table contains data described by the following dimensions (Not all combinations are available): Geography (1 items: Canada ...) Last permanent residence (25 items: Total immigrants; France; Great Britain; Total Europe ...).
The United States Census Bureau’s international dataset provides estimates of country populations since 1950 and projections through 2050. Specifically, the dataset includes midyear population figures broken down by age and gender assignment at birth. Additionally, time-series data is provided for attributes including fertility rates, birth rates, death rates, and migration rates.
You can use the BigQuery Python client library to query tables in this dataset in Kernels. Note that methods available in Kernels are limited to querying data. Tables are at bigquery-public-data.census_bureau_international.
What countries have the longest life expectancy? In this query, 2016 census information is retrieved by joining the mortality_life_expectancy and country_names_area tables for countries larger than 25,000 km2. Without the size constraint, Monaco is the top result with an average life expectancy of over 89 years!
SELECT
age.country_name,
age.life_expectancy,
size.country_area
FROM (
SELECT
country_name,
life_expectancy
FROM
bigquery-public-data.census_bureau_international.mortality_life_expectancy
WHERE
year = 2016) age
INNER JOIN (
SELECT
country_name,
country_area
FROM
bigquery-public-data.census_bureau_international.country_names_area
where country_area > 25000) size
ON
age.country_name = size.country_name
ORDER BY
2 DESC
/* Limit removed for Data Studio Visualization */
LIMIT
10
Which countries have the largest proportion of their population under 25? Over 40% of the world’s population is under 25 and greater than 50% of the world’s population is under 30! This query retrieves the countries with the largest proportion of young people by joining the age-specific population table with the midyear (total) population table.
SELECT
age.country_name,
SUM(age.population) AS under_25,
pop.midyear_population AS total,
ROUND((SUM(age.population) / pop.midyear_population) * 100,2) AS pct_under_25
FROM (
SELECT
country_name,
population,
country_code
FROM
bigquery-public-data.census_bureau_international.midyear_population_agespecific
WHERE
year =2017
AND age < 25) age
INNER JOIN (
SELECT
midyear_population,
country_code
FROM
bigquery-public-data.census_bureau_international.midyear_population
WHERE
year = 2017) pop
ON
age.country_code = pop.country_code
GROUP BY
1,
3
ORDER BY
4 DESC /* Remove limit for visualization*/
LIMIT
10
The International Census dataset contains growth information in the form of birth rates, death rates, and migration rates. Net migration is the net number of migrants per 1,000 population, an important component of total population and one that often drives the work of the United Nations Refugee Agency. This query joins the growth rate table with the area table to retrieve 2017 data for countries greater than 500 km2.
SELECT
growth.country_name,
growth.net_migration,
CAST(area.country_area AS INT64) AS country_area
FROM (
SELECT
country_name,
net_migration,
country_code
FROM
bigquery-public-data.census_bureau_international.birth_death_growth_rates
WHERE
year = 2017) growth
INNER JOIN (
SELECT
country_area,
country_code
FROM
bigquery-public-data.census_bureau_international.country_names_area
Historic (none)
United States Census Bureau
Terms of use: This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source - http://www.data.gov/privacy-policy#data_policy - and is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset.
See the GCP Marketplace listing for more details and sample queries: https://console.cloud.google.com/marketplace/details/united-states-census-bureau/international-census-data
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This is a data record of the input and output data associated with the following publication:
Jiang, L., B.C. O'Neill, H. Zoraghein, and S. Dahlke. 2020. Population scenarios for U.S. states consistent with Shared Socioeconomic Pathways. Environmental Research Letters, https://doi.org/10.1088/1748-9326/aba5b1.
The accompanying code can be found here:
Zoraghein, H., R. Nawrotzki, L. Jiang, and S. Dahlke (2020). IMMM-SFA/statepop: v0.1.0 (Version v0.1.0). Zenodo. http://doi.org/10.5281/zenodo.3956703
The following detail the contents:
https://creativecommons.org/publicdomain/zero/1.0/https://creativecommons.org/publicdomain/zero/1.0/
A permanent labor certification issued by the Department of Labor (DOL) allows an employer to hire a foreign worker to work permanently in the United States. In most instances, before the U.S. employer can submit an immigration petition to the Department of Homeland Security's U.S. Citizenship and Immigration Services (USCIS), the employer must obtain a certified labor certification application from the DOL's Employment and Training Administration (ETA). The DOL must certify to the USCIS that there are not sufficient U.S. workers able, willing, qualified and available to accept the job opportunity in the area of intended employment and that employment of the foreign worker will not adversely affect the wages and working conditions of similarly employed U.S. workers.
Data covers 2012-2017 and includes information on employer, position, wage offered, job posting history, employee education and past visa history, associated lawyers, and final decision.
This data was collected and distributed by the US Department of Labor.
Archaeologists and researchers in allied fields have long sought to understand human colonization of North America. When, how, and from where did people migrate, and what were the consequences of their arrival for the established fauna and landscape are enduring questions. Here, we present evidence from excavated surfaces of in situ human footprints from White Sands National Park (New Mexico, USA), where multiple human footprints are stratigraphically constrained and bracketed by seed layers that yield calibrated 14C ages between ~23 and 21 ka. These findings confirm the presence of humans in North America during the Last Glacial Maximum, adding evidence to the antiquity of human colonization of the Americas and providing a temporal range extension for the coexistence of early inhabitants and Pleistocene megafauna.
The dataset, provided both in comma-separated values (.csv) and the more informative Stata (.dta) format, contains place/year demographic data on more than 300 rural Alaska communities annually for 1990 to 2022 -- about 10,000 place/years. For each of the available place/years, the data include population estimates from the Alaska Department of Labor and Workforce Development or (in Census years) from the US Census. For a subset consisting of 104 northern or western Alaska (Arctic/subarctic) towns and villages, the dataset also contains yearly estimates of natural increase (births minus deaths) and net migration (population minus last year's population plus natural increase). Natural increase was calculated from birth and death counts provided confidentially to researchers by the Alaska Health Analytics and Vital Records Section (HAVRS). By agreement with HAVRS, the community-level birth and death counts are not available for publication. Population, natural increase, and net migration estimates reflect mid-year values, or change over the past fiscal rather than calendar year. For example, the natural increase value for a community in 2020 is based on births and deaths of residents from July 1, 2019 to June 31, 2020. We emphasize that all values here are best estimates, based on records of the Alaska government organizations. The dataset contains 19 variables: placename Place name (string) placenum Place name (numeric) placefips Place FIPS code year Year borough Borough name boroughfips Borough FIPS code latitude Latitude (decimal, - denotes S) longitude Longitude (decimal, - denotes W) town Village {0:pop2020<2,000} or town {1:pop2020>2,000} village104 104 selected Arctic/rural communities {0,1} arctic43 43 Arctic communities {0,1}, Hamilton et al. 2016 north37 37 Northern Alaska communities {0,1), Hamilton et al. 2016 pop Population (2022 data) cpopP Change in population, percent natinc Natural increase: births-deaths natincP Natural increase, percent netmig Net migration estimate netmigP Net migration, percent nipop Population without migration Three of these variables flag particular subsets of communities. The first two subsets (43 or 37 places) were analyzed in earlier publications, so the flags might be useful for replications or comparisons. The third subset (104 places) is a newer, expanded group of Arctic/subarctic towns and villages for which natural increase and net migration estimates are now available. The flag variables are: If arctic43 = 1 Subset consisting of 43 Arctic towns and villages, previously studied in three published articles: 1. Hamilton, L.C. & A.M. Mitiguy. 2009. “Visualizing population dynamics of Alaska’s Arctic communities.” Arctic 62(4):393–398. https://doi.org/10.14430/arctic170 2. Hamilton, L.C., D.M. White, R.B. Lammers & G. Myerchin. 2012. “Population, climate and electricity use in the Arctic: Integrated analysis of Alaska community data.” Population and Environment 33(4):269–283. https://doi.org/10.1007/s11111-011-0145-1 3. Hamilton, L.C., K. Saito, P.A. Loring, R.B. Lammers & H.P. Huntington. 2016. “Climigration? Population and climate change in Arctic Alaska.” Population and Environment 38(2):115–133. https://doi.org/10.1007/s11111-016-0259-6 If north37 = 1 Subset consisting of 37 northern Alaska towns and villages, previously analyzed for comparison with Nunavut and Greenland in a paper on demographics of the Inuit Arctic: 4. Hamilton, L.C., J. Wirsing & K. Saito. 2018. “Demographic variation and change in the Inuit Arctic.” Environmental Research Letters 13:11507. https://doi.org/10.1088/1748-9326/aae7ef If village104 = 1 Expanded group consisting of 104 communities, including all those in the arctic43 and north37 subsets. This group includes most rural Arctic/subarctic communities that had reasonably complete, continuous data, and 2018 populations of at least 100 people. These data were developed by updating older work and drawing in 61 additional towns or villages, as part of the NSF-supported Arctic Village Dynamics project (OPP-1822424).
These data are part of NACJD's Fast Track Release and are distributed as they were received from the data depositor. The files have been zipped by NACJD for release, but not checked or processed except for the removal of direct identifiers. Users should refer to the accompanying readme file for a brief description of the files available with this collection and consult the investigator(s) if further information is needed. The main aim of this research is to study the criminal mobility of ethnic-based organized crime groups. The project examines whether organized crime groups are able to move abroad easily and to reproduce their territorial control in a foreign country, or whether these groups, and/or individual members, start a life of crime only after their arrival in the new territories, potentially as a result of social exclusion, economic strain, culture conflict and labeling. More specifically, the aim is to examine the criminal mobility of ethnic Albanian organized crime groups involved in a range of criminal markets and operating in and around New York City, area and to study the relevance of the importation/alien conspiracy model versus the deprivation model of organized crime in relation to Albanian organized crime. There are several analytical dimensions in this study: (1) reasons for going abroad; (2) the nature of the presence abroad; (3) level of support from ethnic constituencies in the new territories; (4) importance of cultural codes; (5) organizational structure; (6) selection of criminal activities; (7) economic incentives and political infiltration. This study utilizes a mixed-methods approach with a sequential exploratory design, in which qualitative data and documents are collected and analyzed first, followed by quantitative data. Demographic variables in this collection include age, gender, birth place, immigration status, nationality, ethnicity, education, religion, and employment status. Two main data sources were employed: (1) court documents, including indictments and court transcripts related to select organized crime cases (84 court documents on 29 groups, 254 offenders); (2) in-depth, face-to-face interviews with 9 ethnic Albanian offenders currently serving prison sentences in U.S. Federal Prisons for organized crime related activities, and with 79 adult ethnic Albanian immigrants in New York, including common people, undocumented migrants, offenders, and people with good knowledge of Albanian organized crime modus operandi. Sampling for these data were conducted in five phases, the first of which involved researchers examining court documents and identifying members of 29 major ethnic Albanian organized crime groups operating in the New York area between 1975 and 2013 who were or had served sentences in the U.S. Federal Prisons for organized crime related activities. In phase two researchers conducted eight in-depth interviews with law enforcement experts working in New York or New Jersey. Phase three involved interviews with members of the Albanian diaspora and filed observations from an ethnographic study. Researchers utilized snowball and respondent driven (RDS) recruitment methods to create the sample for the diaspora dataset. The self-reported criteria for recruitment to participate in the diaspora interviews were: (1) age 18 or over; (2) of ethnic Albanian origin (foreign-born or 1st/2nd generation); and (3) living in NYC area for at least 1 year. They also visited neighborhoods identified as high concentrations of ethnic Albanian individuals and conducted an ethnographic study to locate the target population. In phase four, data for the cultural advisors able to help with the project data was collected. In the fifth and final phase, researchers gathered data for the second wave of the diaspora data, and conducted interviews with offenders with ethnic Albanian immigrants with knowledge of the organized crime situation in New York City area. Researchers also approached about twenty organized crime figures currently serving a prison sentence, and were able to conduct 9 in-depth interviews.
U.S. Government Workshttps://www.usa.gov/government-works
License information was derived automatically
Maryland Total (International and Domestic) Migration from 2001 to 2022. Source from the Population Division, U.S. Census Bureau.
Attribution-NonCommercial 4.0 (CC BY-NC 4.0)https://creativecommons.org/licenses/by-nc/4.0/
License information was derived automatically
The Most Wanted Fugitives published by the U.S. Immigration and Customs Enforcement (ICE).
List of the data tables as part of the Immigration System Statistics Home Office release. Summary and detailed data tables covering the immigration system, including out-of-country and in-country visas, asylum, detention, and returns.
If you have any feedback, please email MigrationStatsEnquiries@homeoffice.gov.uk.
The Microsoft Excel .xlsx files may not be suitable for users of assistive technology.
If you use assistive technology (such as a screen reader) and need a version of these documents in a more accessible format, please email MigrationStatsEnquiries@homeoffice.gov.uk
Please tell us what format you need. It will help us if you say what assistive technology you use.
Immigration system statistics, year ending March 2025
Immigration system statistics quarterly release
Immigration system statistics user guide
Publishing detailed data tables in migration statistics
Policy and legislative changes affecting migration to the UK: timeline
Immigration statistics data archives
https://assets.publishing.service.gov.uk/media/68258d71aa3556876875ec80/passenger-arrivals-summary-mar-2025-tables.xlsx">Passenger arrivals summary tables, year ending March 2025 (MS Excel Spreadsheet, 66.5 KB)
‘Passengers refused entry at the border summary tables’ and ‘Passengers refused entry at the border detailed datasets’ have been discontinued. The latest published versions of these tables are from February 2025 and are available in the ‘Passenger refusals – release discontinued’ section. A similar data series, ‘Refused entry at port and subsequently departed’, is available within the Returns detailed and summary tables.
https://assets.publishing.service.gov.uk/media/681e406753add7d476d8187f/electronic-travel-authorisation-datasets-mar-2025.xlsx">Electronic travel authorisation detailed datasets, year ending March 2025 (MS Excel Spreadsheet, 56.7 KB)
ETA_D01: Applications for electronic travel authorisations, by nationality
ETA_D02: Outcomes of applications for electronic travel authorisations, by nationality
https://assets.publishing.service.gov.uk/media/68247953b296b83ad5262ed7/visas-summary-mar-2025-tables.xlsx">Entry clearance visas summary tables, year ending March 2025 (MS Excel Spreadsheet, 113 KB)
https://assets.publishing.service.gov.uk/media/682c4241010c5c28d1c7e820/entry-clearance-visa-outcomes-datasets-mar-2025.xlsx">Entry clearance visa applications and outcomes detailed datasets, year ending March 2025 (MS Excel Spreadsheet, 29.1 MB)
Vis_D01: Entry clearance visa applications, by nationality and visa type
Vis_D02: Outcomes of entry clearance visa applications, by nationality, visa type, and outcome
Additional dat