Immigrant share in U.S. nears record high but remains below that of many other countries

Good recap of comparative statistics:

Nearly 14% of the U.S. population was born in another country, numbering more than 44 million people in 2017, according to a Pew Research Center analysis of the U.S. Census Bureau’s American Community Survey.

Immigrant share of U.S. population approaches historic highThis was the highest share of foreign-born people in the United States since 1910, when immigrants accounted for 14.7% of the American population. The record share was 14.8% in 1890, when 9.2 million immigrants lived in the United States.

The foreign-born population in the U.S. grew substantially during the late 1800s, when immigration from Europe and elsewhere brought millions of new residents to the nation’s shores. In the 1920s, the U.S. adopted a series of more restrictive immigration laws, eventually leading to the establishment of a national-origin quota system in 1924 and a subsequent decline in the foreign-born share of the nation’s population. That immigration system was not changed until 1965, when the Immigration and Nationality Act created the same overarching immigration laws that the U.S. still uses today. Since 1965, at least 59 million immigrants have come to the United States.

Immigrant share in U.S. is lower than in many other countriesEven though the U.S. has more immigrants than any other country, the foreign-born share of its population is far from the highest in the world. In 2017, 25 countries and territories had higher shares of foreign-born people than the U.S., according to United Nations data.

In 2017, large majorities of populations in some Persian Gulf nations, such as the United Arab Emirates (88%) and Kuwait (76%), were born in other countries. (Most foreign-born persons living in Persian Gulf nations are labor migrants and live in the region temporarily.)

Foreign-born people also accounted for a substantial share of the population in Australia (29%), New Zealand (23%) and Canada (21%), as well as in several European countries, such as Switzerland (30%), Austria (19%) and Sweden (18%).

Explore detailed tables on the number and share of immigrants and emigrants by country.

The share of foreign-born people has changed over time in many nations, just as it has in the U.S. Several European countries, as well as other immigrant destinations (Canada and Australia, for example), have seen steady increases in recent decades. But some nations have seen their immigrant shares drop. In several Central and Eastern European countries – such as Latvia and Estonia – more people are leaving than entering, and remaining immigrants are getting older and dying, all leading to a decreasing share of foreign-born people.

In several immigrant destination countries, larger shares of publics want fewer or no immigrants to move to their country, according to a Pew Research Center survey conducted in the spring of 2018. However, support for taking in high-skilled immigrants and refugees fleeing war remains high in some destination countries.

Worldwide, most people do not move across international borders. In all, only 3.4% of the world’s population lives in a country they were not born in, according to data from the UN. This share has ticked up over time, but marginally so: In 1990, 2.9% of the world’s population did not live in their country of birth.

Source: Immigrant share in U.S. nears record high but remains below that of many other countries

One year later, Citizenship Act improvements lead to more new citizens – The numbers

Almost one year after the changes to residency requirements (from 4 to 3 years) and fewer applicants having to be tested for language and knowledge (from 14-64 to 18-54), the number of applications has increased.

As noted before, the residency requirement change is a one time impact, with this year being a “double year” with 3 and 4 year cohorts combined. The reduced testing requirements, primarily the 55-64 year olds, has both a one-time impact (those who put off getting citizenship) as well as ongoing.

The new “normal” will be known with the 2019 numbers:

This year, Citizenship Week (October 8 to 14, 2018) will be celebrated with 72 special citizenship ceremonies across the country. Citizenship Week also marks the 1 year anniversary of Bill C 6, which brought in important changes to the Citizenship Act, helping qualified applicants get citizenship faster.

The changes from Bill C 6 came into effect on October 11, 2017, and provided those wanting to become Canadian citizens with greater flexibility to meet the requirements. In particular, the changes reduced the time permanent residents must be physically present in Canada before applying for citizenship from 4 out of 6 years to 3 out of 5 years.

By the end of October 2018, an estimated 152,000 people will have obtained Canadian citizenship since the changes came into effect, an increase of 40%, compared to the 108,000 people who obtained citizenship in the same period the year before.

Bill C 6 has allowed more permanent residents to apply for citizenship. In the 9 month period from October 2017 to June 2018, Immigration, Refugees and Citizenship Canada (IRCC) received 242,680 applications, more than double the 102,261 applications that were received in the same period the year before. Despite the increase in applications, processing times for routine citizenship applications remain under 12 months.

Source: Taking Canadian Citizenship to New Heights This Citizenship Week

Nine things everyone should know how to do with a spreadsheet | Macworld

As I am starting to use spreadsheets to analyze demographic and related data, my basic knowledge of spreadsheets is being challenged. Another primer from Macworld (but applies to Excel and Google’s Sheets as well).

As I have been only using sum and average functions, these examples of other functions caught my eye:

=MAXRANGE and =MINRANGE: Return the largest and smallest values in a range. Related to these two, I also often use =RANKCELL,RANGE, which returns the rank of a given cell within the specified range.

=NOW: Inserts the current date and time, which is then updated each time the spreadsheet recalculates. In both Excel and Sheets, you need to add a set of parentheses: =NOW.

=TRIMCELL: If you work with text that you copy and paste from other sources, there’s a good chance you’ll find extra spaces at the beginning or end of some lines of text. The TRIM function removes all those leading and trailing spaces but leaves the spaces between words.

Nine things everyone should know how to do with a spreadsheet | Macworld.