Live data from Hacker News

Show HN: Visa Explorer – Salaries, lawyers, companies of all H-1B in the USA

data.jobsintech.io

91–100 of 257 posts

Re: Show HN: Visa Explorer – Salaries, lawyers, companies of all H-1B in the USA

#91
For all the H-1B is "cheap labor complains" the fact that this information is public is horrible. Its a very asymetric relationship with your colleagues. If this were really meant to be about transparent controls, it should be tied to the wages of the other employees.

Cant believe there isnt a single comment about privacy issues regarding this here.

EDIT: after scrolling a bit I did find some. Kudos to that conversation, though this has to be off-putting. The OP is also playing with people's information. He hasnt put his next to it, for example. Not that it would have been enough.

Re: Show HN: Visa Explorer – Salaries, lawyers, companies of all H-1B in the USA

#92
post #89

Thanks, this is a very good job so far. I do have one question, though. What is your reasoning for having the upward-facing arrow /\ serve as the descending sort and downward-facing \/ as ascending? It feels backwards to me and a bit counter intuitive.

I was thinking from the top salaries to the bottom.

I was confused by this as well, usually it's the other way around. I think regular reasoning is from largest (widest part of arrow) to smallest.

Thanks for the site though :)

Re: Show HN: Visa Explorer – Salaries, lawyers, companies of all H-1B in the USA

#93

Thanks, this is a very good job so far. I do have one question, though. What is your reasoning for having the upward-facing arrow /\ serve as the descending sort and downward-facing \/ as ascending? It feels backwards to me and a bit counter intuitive.

The asc/desc triangles bugs me too. Arrows would indicate order (⬆︎ = rising, lowest to highest). Triangles aren't arrows and should IMO be the reversed, like a pyramid (▲ = ascending, smallest on top). I just noticed HN uses triangles as arrows for upvotes, whereas Reddit has the arrows.

Re: Show HN: Visa Explorer – Salaries, lawyers, companies of all H-1B in the USA

#96
post #2

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.

May I ask which public records did you use? Thanks, this looks awesome!

Re: Show HN: Visa Explorer – Salaries, lawyers, companies of all H-1B in the USA

#97
post #14

What's being used on the front-end to display the tables and pages and the back-end to store all the info? Time required to create? Other fun details? (I ask because I have another dataset I want to work on recreating online in a searchable manner)

Front End: twitter bootstrap. Back End: RoR+postgreSQL I roughly spent a week on it. At first I was cleaning and moving some data around with RoR but it didn't seemed right to me. Then I started poking around with postgreSQL and once you get a hold of it, it's super powerful and does most of the job. Use indexes... on fairly large datasets it really makes a difference.

Thank you for doing this! Any tips on how I can learn and better at using twitter bootstrap? So far I've only figured out how to load the basic template.

Re: Show HN: Visa Explorer – Salaries, lawyers, companies of all H-1B in the USA

#98

Earlier quoted context omitted.

See my reply below. TLDR version: Netflix compensation is all salary. Google, etc, comp is salary + stock + bonus, and I suspect these applications list just salary, not total comp.

Isn't it the case that compensation at Netflix is variable and you could select how you want to distribute it over salary/stock/bonus?

Yes, that's true (for at least stock, I don't think they do bonuses). But the default is 95% salary / 5% stock, so to simplify, I said "just salary"

Re: Show HN: Visa Explorer – Salaries, lawyers, companies of all H-1B in the USA

#99
post #93

Thanks, this is a very good job so far. I do have one question, though. What is your reasoning for having the upward-facing arrow /\ serve as the descending sort and downward-facing \/ as ascending? It feels backwards to me and a bit counter intuitive.

The asc/desc triangles bugs me too. Arrows would indicate order (⬆︎ = rising, lowest to highest). Triangles aren't arrows and should IMO be the reversed, like a pyramid (▲ = ascending, smallest on top). I just noticed HN uses triangles as arrows for upvotes, whereas Reddit has the arrows.

Good to know I'm not alone in this reasoning. I've seen the flip-flopped behavior on other sites, and it is a pet peeve of mine.

Re: Show HN: Visa Explorer – Salaries, lawyers, companies of all H-1B in the USA

#100
post #2

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.

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

Yes, This is definitively something I'm going to provide.
Post reply on HN