Green Cards explorer (jobsintech)
Data
public records explorer
SHOW HN2015
How HN took it
5 positive, 40 neutral or asking, 1 mixed, 11 critical, out of 57 comments about the project. Thread score -0.09.
Execution: 0 for, 8 againstDesign: 2 for, 1 againstIdea: 0 for, 1 againstPrivacy: 0 for, 1 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Great, interesting tool with useful data visualisation
From 3 comments
Awesome! Nit-pick: Any chance you could right-align the columns with numbers, and add thousand delimiters?
slater on HNThis is a really great tool. Kudos to negrit.
maximedev on HNExcellent 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…
rvdm on HN
Objections
Data covers only PERM labor certifications, not all green card categories
From 3 comments
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…
thrwy10 on HNSince it has salary data it must be based on PERMs, which only cover a subset of employment green cards.
klipt on HNAre 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…
bradleyjg on HN
Success rate shows NaN for zero denominators
From 3 comments
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…
slipjack on HNGetting an 'NaN' for the Success Rate in the table at the bottom of that page. May be something for OP to look into.
vinay427 on HNOh man Palau has NaN% software engineers accepted :(
ighost on HN
Salary feature exposes individuals' salaries and privacy concerns
From 2 comments
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…
chrissnell on HNNeat tool, though it's a little disconcerting to be able to easily find my application - not your fault, though, the data was already there!
jlees on HN
Requests
Filter or breakdown by visa category such as EB1, EB2
From 1 comment
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.
anorark on HN
Add percent of population column per country
From 2 comments
Thanks for the work to present that data in a nice and explorable way! It would be awesome to have another column next to "% of Greencards" that says "% of population". One of…
rb2k_ on HNyes, 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…
rb2k_ on HN
Allow running SQL select queries on the data
From 1 comment
Any way for us to run `select` queries ourselves?
netheril96 on HN
Questions
Why do the numbers differ across countries like India and China or Mexico
From 2 comments
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.
npalli on HNEven 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,…
npalli on HN
Why are Soviet Union and Czechoslovakia listed for later years
From 2 comments
Also, the Soviet Union was dissolved in 1991, how come there were 4 USSR nationals between 2001 and 2015 applying for permanent residency?
DrJokepu on HNYeah, Czechoslovakia is also on the list, even though they split in 1993.
gambiting on HN