tacobell fan Posted April 1, 2019 Report Share Posted April 1, 2019 5 minutes ago, ekunadam_enkanna said: https://www.uscis.gov/tools/reports-studies/h-1b-employer-data-hub-files Not the raw data, but there is a high level approval data released by them couple weeks ago where it shows 99% approval rating for Silicon Valley companies versus WITCH. Quote Link to comment Share on other sites More sharing options...
tacobell fan Posted April 1, 2019 Report Share Posted April 1, 2019 https://www.uscis.gov/sites/default/files/USCIS/Resources/Reports and Studies/Immigration Forms Data/BAHA/h-1B-quarterly-requests-for-evidence-2015-2019-Q1-top-30-employers.pdf this is the link I was talking about. Quote Link to comment Share on other sites More sharing options...
LazyRohit Posted April 1, 2019 Report Share Posted April 1, 2019 CI, CD ante enti all ready done or pending? Quote Link to comment Share on other sites More sharing options...
tacobell fan Posted April 1, 2019 Report Share Posted April 1, 2019 Just now, LazyRohit said: CI, CD ante enti all ready done or pending? Continuous Integration and Continuous Deployment ani @Spartan brief'd Quote Link to comment Share on other sites More sharing options...
LazyRohit Posted April 1, 2019 Report Share Posted April 1, 2019 Just now, tacobell fan said: Continuous Integration and Continuous Deployment ani @Spartan brief'd ori eshaloooo ani CBN tweeted Quote Link to comment Share on other sites More sharing options...
snoww Posted April 1, 2019 Report Share Posted April 1, 2019 22 minutes ago, LazyRohit said: CI, CD ante enti all ready done or pending? Renewals/transfers Approved/Denied stats CA - H-1B petitions with anything other than “New employment” or “New concurrent employment” selected on Part 2, Question 2 of the Form I-129, whose first decision is an approval. This includes, for example, continuing employment, change of employer, and amended petitions. CD - H-1B petitions with anything other than “New employment” or “New concurrent employment” selected on Part 2, Question 2 of the Form I-129 whose first decision is a denial. This includes, for example, continuing employment, change of employer, and amended petitions. 1 Quote Link to comment Share on other sites More sharing options...
LastManStanding Posted April 1, 2019 Report Share Posted April 1, 2019 Morning nunchi whatsapp lo vastune undi e site..ivale open chesaru anta kadha..appude ela popular aindi! Crazy! Quote Link to comment Share on other sites More sharing options...
ekunadam_enkanna Posted April 1, 2019 Author Report Share Posted April 1, 2019 BTW, you can load these csv files and import them into tables. Use sqlite3, then apply analytical functions. 1 1 Quote Link to comment Share on other sites More sharing options...
LastManStanding Posted April 1, 2019 Report Share Posted April 1, 2019 Just now, ekunadam_enkanna said: BTW, you can load these csv files and import them into tables. Use sqlite3, then apply analytical functions. Quote Link to comment Share on other sites More sharing options...
tacobell fan Posted April 1, 2019 Report Share Posted April 1, 2019 1 minute ago, ekunadam_enkanna said: BTW, you can load these csv files and import them into tables. Use sqlite3, then apply analytical functions. emi chesukuntam bro ee data analyse chesi? Quote Link to comment Share on other sites More sharing options...
snoww Posted April 1, 2019 Report Share Posted April 1, 2019 3 minutes ago, tacobell fan said: emi chesukuntam bro ee data analyse chesi? koolies ki baaga helpful , in finding next mesthri if they want to jump Quote Link to comment Share on other sites More sharing options...
ekunadam_enkanna Posted April 1, 2019 Author Report Share Posted April 1, 2019 Quote $ sqlite3 hokati.db SQLite version 3.11.0 2016-02-15 17:29:24 Enter ".help" for usage hints. sqlite> .mode csv sqlite> .headers on sqlite> create table h2019(year integer, employer text, ia integer, id integer, ca integer, cd integer, naics integer, taxid integer, state text, city text, zip integer); sqlite> .import h1b_datahubexport-2019.csv h2019 sqlite> select count(employer) from h2019; count(employer) 22502 Quote Link to comment Share on other sites More sharing options...
snoww Posted April 1, 2019 Report Share Posted April 1, 2019 2 minutes ago, ekunadam_enkanna said: Any column available in data for H1B dependent employer ? That will mostly give Desi Mesthris count Quote Link to comment Share on other sites More sharing options...
ekunadam_enkanna Posted April 1, 2019 Author Report Share Posted April 1, 2019 1 minute ago, snoww said: Any column available in data for H1B dependent employer ? That will mostly give Desi Mesthris count Ah, that field comes from LCA forms. If we can find LCA csv files with that field, join tables:) Quote Link to comment Share on other sites More sharing options...
ekunadam_enkanna Posted April 1, 2019 Author Report Share Posted April 1, 2019 Another query. Find all employers, whose denials --both initial and continuous > 100 Quote sqlite> select employer, id, cd from h2019 where id+cd > 100; employer,id,cd "DELOITTE CONSULTING LLP",564,165 "DELOITTE CONSULTING LLP",150,497 "DELOITTE & TOUCHE LLP",54,78 "COGNIZANT TECH SOLNS US CORP",217,996 "CAPGEMINI AMERICA INC",138,266 "TECH MAHINDRA AMERICAS INC",440,78 "LARSEN AND TOUBRO INFOTECH LTD",83,55 "ERNST & YOUNG US LLP",65,106 "PRICEWATERHOUSECOOPERS ADVISORY SE",33,93 "IBM INDIA PRIVATE LIMITED",5,145 "INFOSYS LTD",49,423 "ACCENTURE LLP",96,138 "HCL AMERICA INC",23,169 "WIPRO LIMITED",437,189 "TATA CONSULTANCY SVCS LTD",700,832 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.