News for hackers. Stuff that matters.
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by negrit on Friday May 22, 2015 @09:48AM (#9588209)
Hello everyone. I quickly built this little tool based on public records provided by the government.

The amount of information they provide is incredible. There are no explicit names, but for small startup or exec position it is easy to guess who is who.

As far as I know this is the biggest LCA database so far.

Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by myth_buster on Friday May 22, 2015 @11:53AM (#9589035)
Thanks for this! I'm currently looking at opportunities and this would help immensely during negotiations.

Would it be possible to search for role + location instead of company first? Essentially the refine functionality you provide on company's yearly page [0] to be at the root. You can perhaps make state or city mandatory so that it doesn't hit your backend hard.

[0]: http://data.jobsintech.io/companies/***/2015

Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by visadoor on Friday May 22, 2015 @12:08PM (#9589167)
Try http://visadoor.com

You can also search Green Card PERMs.

Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by negrit on Friday May 22, 2015 @12:42PM (#9589434)
Yes, This is definitively something I'm going to provide.
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by myth_buster on Friday May 22, 2015 @02:46PM (#9590194)
Excellent.
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by Eridrus on Friday May 22, 2015 @12:00PM (#9589105)
Their data hadn't been updated in a while, but http://www.salar.ly/ has that functionality
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by pkaye on Friday May 22, 2015 @10:16AM (#9588394)
Great implementation. I've seen the raw data before but never had the web development skills to execute on this idea. Can you also add a query where once you select a company and year, it groups by title and gives average salary.
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by negrit on Friday May 22, 2015 @10:30AM (#9588496)
For a company and a given year, you can search by title.
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by berkay on Friday May 22, 2015 @10:49AM (#9588613)
It would be useful to search across companies for a job title
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by lmz on Friday May 22, 2015 @10:09AM (#9588343)
I thought clicking "Jobs" would lead me to something grouped by job title...
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by lukasm on Friday May 22, 2015 @10:11AM (#9588357)
Can I find the highest salaries?
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by iagooar on Friday May 22, 2015 @02:48PM (#9590207)
Take a look at Airbnb, Data Scientist. This person has been doing >$1.000.000 a year...
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by lukasm on Friday May 22, 2015 @04:58PM (#9590879)
I've seen that. It's either mistake or he sold the shares.
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by philsnow on Friday May 22, 2015 @02:58PM (#9590278)
what does "status: withdrawn" mean ?
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by refurb on Friday May 22, 2015 @07:43PM (#9591412)
It means the petition was withdrawn. My guess is that that person left the company.
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by negrit on Friday May 22, 2015 @08:30PM (#9591538)
I actually think it means they decide to no make go further with the LCA. Like they decided to finally not hire the employee or the employee decided to not work for this company anymore.
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by refurb on Saturday May 23, 2015 @02:32AM (#9592174)
Actually that makes more sense. It is possible to be working on another visa while a company files the LCA for you (TN, L, visas, etc), but it's probably less likely than a new H1-B hire.
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by sjg007 on Saturday May 23, 2015 @06:33PM (#9594638)
They probably misfiled the LCA at 1m and re filed at 100k.
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by ajays on Friday May 22, 2015 @05:41PM (#9591014)
Netflix? Senior Software Engineer, $375K.
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by joering2 on Saturday May 23, 2015 @12:14AM (#9591980)
Serious question.

What kind of skills of knowledge or experience do you have to have so that you take more than quarter million of dollars??? Incredible!!

Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by owenfi on Monday June 01, 2015 @03:08AM (#9637099)
They ran the million dollar challenge[1] to increase viewership, thus decreasing churn.

If you could (make a case that you) consistently decrease churn then you'd pay for yourself at that rate.

1: http://www.wired.com/2012/04/netflix-prize-costs/

Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by lgieron on Saturday May 23, 2015 @06:52AM (#9592563)
For a company like Netflix, my guess is, you need to be a world-class expert at some area of scalable backends and/or big data. For example, you need to be a core contributor (in terms of concepts, architecture etc. - not just coding) to projects like Kafka, Cassandra, Spark etc.
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by pshin45 on Friday May 22, 2015 @01:56PM (#9589899)
Very impressive. I'm organizing an Immigration-themed "Startup Weekend" event[1] happening next week (in SF), and I think I'll be sharing this with participants there as an example of what can be done.

[1] http://www.up.co/communities/usa/san-francisco/startup-weeke... (Use promo code "hn" for 70% off)

Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by negrit on Friday May 22, 2015 @08:29PM (#9591533)
Definitively. I'm going to provide an API pretty soon. Too bad it wont be ready for this week end.
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by bradleyjg on Friday May 22, 2015 @03:03PM (#9590303)
Neat project. My brother, who is an immigration lawyer and presumably somewhere on the list, asks for a way to search by attorney.
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by motti_s on Friday May 22, 2015 @03:11PM (#9590348)
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by micro_cam on Friday May 22, 2015 @04:44PM (#9590824)
Instead of plotting a count per exact salary could you plot count per binned salary? Ie instead of plotting 1 at 105k and 1 at 107k plot 2 at 100-110k.

As it is the plots aren't particularly useful for comparing the distribution of salaries between companies etc.

Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by ma2rten on Friday May 22, 2015 @09:58AM (#9588274)
Thanks this is way better than existing sites.

I did notice that searching for Google gives you 5 different entities that are all Google.

Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by negrit on Friday May 22, 2015 @10:01AM (#9588296)
Yes I am still cleaning the data. It's all unbelievable the amount of crap you can find in the public records. I have a lot of duplicates unfortunately.

Down the road, I'm planning on providing a couple of cool charts/map about trends and evolutions.

Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by djb_hackernews on Friday May 22, 2015 @10:18AM (#9588401)
A few things I'd be interested in:

- ratio of LCAs to total permanent full time employees. This will show which companies are really leaning on the H1-B visa (I'd estimate my "household name" software company is at about 50%)

- Source of prevailing wage. Interestingly employers don't have to use the BOL published data and can self report. I'd be interested to see how many self report.

- The average delta between prevailing wage and salary per employer/job title.

- A way to search by geographic region.

Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by aceperry on Friday May 22, 2015 @02:38PM (#9590150)
Excellent ideas. Hope to see these things soon.
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by joshz on Friday May 22, 2015 @11:10AM (#9588759)
Check out Open Refine. Has a feature that clusters similar strings and unifies. I remember last time I looked at this data set... 4 letter acronyms spelled 12 different ways, it's unbelievably messy.
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by Serow225 on Friday May 22, 2015 @11:03AM (#9588719)
For search result of a company name, can you sort the results descending by # of LCA? this would put the most likely true result of top, I think.

I also noticed that the sort buttons (for salary) behave backwards of what I'd intuitively expect?

Would it be possible to auto-merge likely duplicate company names?

Great job, keep it up!! :)

Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by negrit on Friday May 22, 2015 @12:44PM (#9589452)
I'm currently coding both feature. :)
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by nraynaud on Friday May 22, 2015 @12:53PM (#9589523)
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by seanp2k2 on Friday May 22, 2015 @07:26PM (#9591362)
Any plans to open-source this on Github and accept pull requests?
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by hlake on Friday May 22, 2015 @02:40PM (#9590160)
Great work. Impressive little tool.
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by smrtinsert on Friday May 22, 2015 @03:00PM (#9590286)
This is a great tool. I hope it helps every H1-B fight for the skills they are worth.
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by wodzu on Friday May 22, 2015 @12:31PM (#9589344)
May I ask which public records did you use? Thanks, this looks awesome!
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by paxtonab on Friday May 22, 2015 @06:19PM (#9591163)
can you add functionality to search by job title other than as a filter? great tool though!
Re:Show HN: Visa Explorer – Salaries, lawyers, companies of ... by negrit on Friday May 22, 2015 @08:31PM (#9591541)
Yes, work in progress!