10 ms·
Hello everyone. I quickly built this little tool based on public records provided by the government. The amount of information they provide is incredible. Ther
by negrit 11y ago
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.
- ma2rten 11y agoThanks this is way better than existing sites. I did notice that searching for Google gives you 5 different entities that are all Google.
- negrit 11y agoYes 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.
- djb_hackernews 11y agoA 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.
- aceperry 11y agoExcellent ideas. Hope to see these things soon.
- deleted 11y ago[deleted]
- Serow225 11y agoFor 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!! :)
- negrit 11y agoI'm currently coding both feature. :)
- joshz 11y agoCheck 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.
- nraynaud 11y agohttp://data.jobsintech.io/search?utf8=%E2%9C%93&employer=dassault&commit=Search%21 http://data.jobsintech.io/search?utf8=%E2%9C%93&employer=das... good luck with the cleanup
- seanp2k2 11y agoAny plans to open-source this on Github and accept pull requests?
- lmz 11y agoI thought clicking "Jobs" would lead me to something grouped by job title...
- lukasm 11y agoCan I find the highest salaries?
- iagooar 11y agoTake a look at Airbnb, Data Scientist. This person has been doing >$1.000.000 a year...
- philsnow 11y agowhat does "status: withdrawn" mean ?
- refurb 11y agoIt means the petition was withdrawn. My guess is that that person left the company.
- negrit 11y agoI 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.
- refurb 11y agoActually 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.
- sjg007 11y agoThey probably misfiled the LCA at 1m and re filed at 100k.
- lukasm 11y agoI've seen that. It's either mistake or he sold the shares.
- pkaye 11y agoGreat 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.
- myth_buster 11y agoThanks 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 http://data.jobsintech.io/companies/***/2015
- Eridrus 11y agoTheir data hadn't been updated in a while, but http://www.salar.ly/ http://www.salar.ly/ has that functionality
- visadoor 11y agoTry http://visadoor.com http://visadoor.com You can also search Green Card PERMs.
- negrit 11y agoYes, This is definitively something I'm going to provide.
- myth_buster 11y agoExcellent.
- wodzu 11y agoMay I ask which public records did you use? Thanks, this looks awesome!
- pshin45 11y agoVery 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-weekend/5961 http://www.up.co/communities/usa/san-francisco/startup-weeke... (Use promo code "hn" for 70% off)
- negrit 11y agoDefinitively. I'm going to provide an API pretty soon. Too bad it wont be ready for this week end.
- hlake 11y agoGreat work. Impressive little tool.
- smrtinsert 11y agoThis is a great tool. I hope it helps every H1-B fight for the skills they are worth.
- bradleyjg 11y agoNeat project. My brother, who is an immigration lawyer and presumably somewhere on the list, asks for a way to search by attorney.
- motti_s 11y agoTry this: http://data.jobsintech.io/lawyers/<last http://data.jobsintech.io/lawyers/<last name>-<first name>-<city>-<state> Example: http://data.jobsintech.io/lawyers/maranci-daniel-boston-ma http://data.jobsintech.io/lawyers/maranci-daniel-boston-ma
- micro_cam 11y agoInstead 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.
- paxtonab 11y agocan you add functionality to search by job title other than as a filter? great tool though!
- negrit 11y agoYes, work in progress!