Can somebody explain to me why Americans need to have green card to work in the US? According the the data, there are 1659 applicants with a success rate of 68%.
Ah, I should have made it more clear. It's the decision date, note the application date. So probably those applicants applied when the USSR was still a thing.
Maybe it refers to US nationals as opposed to US citizens. For example, the people of American Samoa and Guam are US nationals but not US citizens, at least not automatically. But I don't know what all the differences between the two categories are.
Hello everyone. I quickly built this little tool based on public records provided by the government.
I did the same a couple weeks ago with H-1Bs and I just added over 1.1million green cards records.
The data provided is not perfect so i'm still working on cleaning it but it should give you an idea of what is going on.
Great tool! There seems to be a bug though when I drill down to year plus country of citizenship and then try to filter by job description and state or city. The job description search term ends up in the state input field.
kinda weird that all the timeseries charts have time going backwards. going lower to higher is certainly the standard way to do it. for eg: http://data.jobsintech.io/companies/google-inc
This looks great!
Can the green card data be shown by categories? Like how many green cards applications were filed in each category like EB1, EB2, etc.
so just dump the data in and process via sql. What about pre-processing ie: different data sources (pdf, cvs), incomplete or overlapping data? I imagine some code had to be written to do this?
All my datasource where csv and mdb files. So, I directly imported them to PostgreSQL. Very little code was written to clean the data. 99% of the cleaning was done with SQL queries.
The code is mostly used to display the data. Cleaning the data with SQL queries is much faster than writing code.
yes, and that's why I'd love to have another column to figure out if there are any countries that have statistically significant higher/lower Greencards per capita :)
It's probably not a super useful metric, but it would be interesting to see
Is there some filter on this data? Green Card for a certain type of job? India has 280K greencards and Mexico only 40K greencards in 16 years? That doesn't seem right.
I assume this is only employment green cards. Most Mexican Americans probably come in on family based green cards, or just got citizenship by birth in the US.
Even China has only 45K greencards. They seem to follow the same pattern as India for immigration, so what category are they coming in. Last I checked both countries (India, China) have similar number of immigrants in the US.
I don't know, but the EB2 and EB3 backlogs for India are longer than for China so there must be some difference.
Assuming those numbers are from PERM applications though, they don't correspond one-to-one to immigrants. For example Indians have a multi year wait to get a green card after their PERM is approved, and anytime they change employers while waiting they will likely apply for a new PERM, so by the time they get their green card one Indian could have gone through many PERM approvals (which this website will probably count separately).
So reading into India's stats, there was dip in 2013 followed by a rise to maximum GC applications by indians ever? Is there a way to tell how many of those were upgrades? that would be interesting because then you can tell how many might just be repetitions.
The dates in this dataset are "decision" date, not the application date.
In that year, there was a fast forward movement in backlog of India's GC application... Green cards have a per country cap-- at the end of fiscal year, USCIS can use the "unused" GC quota of other countries for the backlogged countries. This is why you see that "priority date" for India stays at a fixed place (e.g., 2005 for EB2 India) for most of the year, and then suddenly moves forward at the end of fiscal year.
Just as an FYI, citizenship is not the same as country of chargeability (usually country of birth), which is what the USCIS looks at for placing you in EB-ROW/India/China/Mexico/Philippines. So you could have an Indian passport but if you are born in, let's say, Saudi Arabia, you are placed in EB-ROW.
Thats correct. Also, if your spouse is born in a different country than you, you could charge your application to that country. For example, if your spouse if born in Kenya but you are born in India you can charge your GC app to Kenya which is ROW ( Rest of World).
If you ever get the chance I would consider redoing the graphs using https://dc-js.github.io/dc.js/ Being able to interact with data by clicking on graphs can make a massive difference to the way you can interrogate data. Kudos though.
Excellent way of drawing attention to the subject! Kudos.
Might be interesting to explore the option of adding a beautiful data vis on the home page to capture the user's attention from the get-go. Looking at the sub pages you're obviously skilled enough at creating fascinating visualizations.
What is this?
This website indexes all available LCAs from 2001 to 2015.
Where does the information come from?
LCAs are public records and provided by the "Office of Foreign Labor Certification".
IMHO, this is misleading. LCAs don't have a 1-1 corelation to 'Green Cards'. This data is based on the PERM process which is just 1 stage in the green card process. LCAs aren't green card applications, but a labour market test based on which green cards are applied for.
Are these across all LPR categories—i.e. employment based, family based, DV, asylum, etc.? The numbers make me inclined to think not, but I can't find any explanation on the website of what it covers.
Search fields don't appear to work properly (Safari on OS X) - if you key in a full search (title, city, state) and hit 'refine' it puts the title in all three fields while showing you everything, not just search results. Interesting site though - I want to find me :)
The 'salary' feature is pretty telling. I just looked up a former coworker by searching for the company and narrowing down by the hire year. I knew what country he was from so I was able to see his (starting) salary.
But I work for a private company, and I would bet the majority of HN readers do too. Imagine if your starting salary was known to your coworkers on the day you started, but not vice versa.
As mentioned in one of the other comments, you're getting NaN% for some success rates. I'm guessing it's because you're using the number of certified as the denominator, which will return NaN if it's 0.
Also, maybe this is a dumb question, but is this all green cards? For example, your site says there were 261 green card recipients from Nigeria, which seems quite low.
> Also, maybe this is a dumb question, but is this all green cards? For example, your site says there were 261 green card recipients from Nigeria, which seems quite low.
I wondered the same thing. Fiji is listed with 2 recipients (last I checked Fiji's annual quota was 600).
88 comments
[ 4.7 ms ] story [ 178 ms ] threadReference: https://www.youtube.com/watch?v=CesHr99ezWE
The data provided is not perfect so i'm still working on cleaning it but it should give you an idea of what is going on.
If you have any questions, feel free to ask.
Also, filter by company would be great!
Fixing it ASAP
What tools did you use/craft to clean the source data?
The code is mostly used to display the data. Cleaning the data with SQL queries is much faster than writing code.
It would be awesome to have another column next to "% of Greencards" that says "% of population".
One of the reasons India has by far the most green cards is that they also are up there when it comes to total population.
It's probably not a super useful metric, but it would be interesting to see
Assuming those numbers are from PERM applications though, they don't correspond one-to-one to immigrants. For example Indians have a multi year wait to get a green card after their PERM is approved, and anytime they change employers while waiting they will likely apply for a new PERM, so by the time they get their green card one Indian could have gone through many PERM approvals (which this website will probably count separately).
>Soviet Union 4 | 0.0 | 2 | 0 | 0 | 2 | 100.0%
[0] - http://data.jobsintech.io/green-cards/india/2012
In that year, there was a fast forward movement in backlog of India's GC application... Green cards have a per country cap-- at the end of fiscal year, USCIS can use the "unused" GC quota of other countries for the backlogged countries. This is why you see that "priority date" for India stays at a fixed place (e.g., 2005 for EB2 India) for most of the year, and then suddenly moves forward at the end of fiscal year.
http://en.m.wikipedia.org/wiki/Prevailing_wage
Might be interesting to explore the option of adding a beautiful data vis on the home page to capture the user's attention from the get-go. Looking at the sub pages you're obviously skilled enough at creating fascinating visualizations.
IMHO, this is misleading. LCAs don't have a 1-1 corelation to 'Green Cards'. This data is based on the PERM process which is just 1 stage in the green card process. LCAs aren't green card applications, but a labour market test based on which green cards are applied for.
https://en.wikipedia.org/wiki/Labor_certification#Difference...
I can't now reproduce the earlier behavior I saw where a job title ended up in all 3 search fields.
Nit-pick: Any chance you could right-align the columns with numbers, and add thousand delimiters?
http://data.jobsintech.io/green-cards/india?utf8=%E2%9C%93&r...
Don't think that would ever happen though, it would be labeled as a shocking breach of privacy.
But I work for a private company, and I would bet the majority of HN readers do too. Imagine if your starting salary was known to your coworkers on the day you started, but not vice versa.
Also, maybe this is a dumb question, but is this all green cards? For example, your site says there were 261 green card recipients from Nigeria, which seems quite low.
(Goes without saying - really cool!)
I wondered the same thing. Fiji is listed with 2 recipients (last I checked Fiji's annual quota was 600).