USCIS h1-b data hub

[tacobell fan]

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. 

[tacobell fan]

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. 

[LazyRohit]

CI, CD ante enti all ready done or pending?

[tacobell fan]

Just now, LazyRohit said:

CI, CD ante enti all ready done or pending?

Continuous Integration and Continuous Deployment ani @Spartan brief'd 

[LazyRohit]

Just now, tacobell fan said:

Continuous Integration and Continuous Deployment ani @Spartan brief'd 

ori eshaloooo ani CBN tweeted

[snoww]

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.

[LastManStanding]

Morning nunchi whatsapp lo vastune undi e site..ivale open chesaru anta kadha..appude ela popular aindi! Crazy!

[ekunadam_enkanna]

BTW, you can load these csv files and import them into tables. Use sqlite3, then apply analytical functions.

 

[LastManStanding]

Just now, ekunadam_enkanna said:

BTW, you can load these csv files and import them into tables. Use sqlite3, then apply analytical functions.

 

[tacobell fan]

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? 

[snoww]

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

[ekunadam_enkanna]

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

 

[snoww]

2 minutes ago, ekunadam_enkanna said:

 

Any column available in data for H1B dependent employer ? That will mostly give Desi Mesthris count 

[ekunadam_enkanna]

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:)

[ekunadam_enkanna]

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