Jump to content

USCIS h1-b data hub

ekunadam_enkanna

By ekunadam_enkanna
in Discussions

 Share

Recommended Posts

snoww LEGEND

snoww

Posted
Posted
4 minutes ago, ekunadam_enkanna said:

Another query. Find all employers, whose denials --both initial and continuous > 100

 

"COGNIZANT TECH SOLNS US CORP",217,996

"TATA CONSULTANCY SVCS LTD",700,832

kummesayee bl@st

Link to comment
Share on other sites
  • Replies 60
  • Created
  • Last Reply

Top Posters In This Topic

  • snoww

    20

  • ekunadam_enkanna

    16

  • tacobell fan

    10

  • kittaya

    3

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

ekunadam_enkanna
ekunadam_enkanna

https://www.uscis.gov/h-1b-data-hub Better than myvisajobs/h1bdata.info, as the latter sites just give you info on LCAs.  

ekunadam_enkanna
ekunadam_enkanna

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

Sanathnagar_Satthi
Sanathnagar_Satthi

Great info uncle

ekunadam_enkanna Hero

ekunadam_enkanna

Posted
  • Author
Posted
5 minutes ago, snoww said:

How many approvals ? 

Quote

sqlite> select employer, ia, ca, (ca + ia) as total from h2019 order by total desc limit 50;
TECH MAHINDRA AMERICAS INC|475|540|1015
WIPRO LIMITED|270|652|922
INFOSYS LTD|38|828|866
MICROSOFT CORPORATION|364|485|849
GOOGLE LLC|512|240|752
LARSEN AND TOUBRO INFOTECH LTD|317|417|734
AMAZON.COM SERVICES INC|606|124|730
ERNST & YOUNG US LLP|83|627|710
CAPGEMINI AMERICA INC|135|484|619
ACCENTURE LLP|100|466|566
DELOITTE CONSULTING LLP|298|164|462
FACEBOOK INC|351|97|448
MPHASIS CORPORATION|222|218|440
APPLE INC|194|234|428
HCL AMERICA INC|31|381|412
IBM INDIA PRIVATE LIMITED|15|356|371
L&T TECH SVCS LTD|51|290|341
INTEL CORPORATION|213|115|328
CISCO SYSTEMS INC|119|201|320
JPMORGAN CHASE & CO|95|211|306
MINDTREE LIMITED|58|219|277
ORACLE AMERICA INC|99|176|275
VIRTUSA CORPORATION|80|187|267
HEXAWARE TECHNOLOGIES INC|116|142|258
IBM CORPORATION|159|82|241
QUALCOMM TECHNOLOGIES INC|201|26|227
RANDSTAD TECHNOLOGIES LLC|10|216|226
DELOITTE & TOUCHE LLP|59|149|208
KFORCE INC|68|136|204
PRICEWATERHOUSECOOPERS LLP|133|62|195
CGI TECHNOLOGIES AND SOLUTIONS INC|65|126|191
WAL-MART ASSOCIATES INC|31|153|184
SALESFORCE COM INC|45|131|176
SYNECHRON INC|34|134|168
SYNTEL INC|23|144|167
NTT DATA INC|69|97|166
COGNIZANT TECH SOLNS US CORP|158|1,717|159
PRICEWATERHOUSECOOPERS ADVISORY SE|61|98|159
COMPUNNEL SOFTWARE GROUP INC|18|132|150
BANK OF AMERICA NA|62|84|146
EPAM SYSTEMS INC|78|67|145
TESLA INC|114|26|140
UST GLOBAL INC|9|129|138
EBAY INC|76|62|138
SAP AMERICA INC|88|49|137
UBER TECHNOLOGIES INC|85|46|131
DELOITTE CONSULTING LLP|125|1,072|126
GOLDMAN SACHS & CO LLC|66|59|125
MCKINSEY & COMPANY INC US|82|36|118
PAYPAL INC|60|58|118

 

Link to comment
Share on other sites
ekunadam_enkanna Hero

ekunadam_enkanna

Posted
  • Author
Posted
1 hour ago, snoww said:

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

In some ghetto way, I found a semblance of an answer.

Scraped h1b dependent employers from myvisajobs.com. 4863 h1b dependent employers from 2015-2017 data from myvisajobs.

Quote

dep table = h1b depedent employers

sqlite> select count(dep.employer) from h2019, dep where h2019.employer=dep.employer;
count(dep.employer)
222

sqlite> select count(distinct dep.employer) from dep, h2018 where h2018.employer=dep.employer;
"count(distinct dep.employer)"
246

select count(distinct dep.employer) from dep, h2017 where h2017.employer=dep.employer;
"count(distinct dep.employer)"
245

That's not an accurate answer, since USCIS data is cleaner than myvisajobs' employers names.

Link to comment
Share on other sites
ekunadam_enkanna Hero

ekunadam_enkanna

Posted
  • Author
Posted

  


sqlite> select employer, ia, ca, (ca + ia) as total, city, state from h2019 order by total desc limit 100;
 EMPLOYER                  IA          CA          IA+CA       CITY        ST
-----------------------------------------------------------------------------
TATA CONSULTANCY SVCS LTD  1177        1881        3058        ROCKVILLE   MD
COGNIZANT TECH SOLNS US C  158         1717        1875        COLLEGE ST  TX
DELOITTE CONSULTING LLP    125         1072        1197        PHILADELPH  PA
TECH MAHINDRA AMERICAS IN  475         540         1015        SOUTH PLAI  NJ
WIPRO LIMITED              270         652         922         EAST BRUNS  NJ
INFOSYS LTD                38          828         866         PLANO       TX
MICROSOFT CORPORATION      364         485         849         REDMOND     WA
GOOGLE LLC                 512         240         752         MOUNTAIN V  CA
LARSEN AND TOUBRO INFOTEC  317         417         734         EDISON      NJ
AMAZON.COM SERVICES INC    606         124         730         SEATTLE     WA
ERNST & YOUNG US LLP       83          627         710         SECAUCUS    NJ
CAPGEMINI AMERICA INC      135         484         619         CHICAGO     IL
ACCENTURE LLP              100         466         566         CHICAGO     IL
DELOITTE CONSULTING LLP    298         164         462         BOSTON      MA
FACEBOOK INC               351         97          448         MENLO PARK  CA
MPHASIS CORPORATION        222         218         440         NEW YORK    NY
APPLE INC                  194         234         428         CUPERTINO   CA
HCL AMERICA INC            31          381         412         SUNNYVALE   CA
IBM INDIA PRIVATE LIMITED  15          356         371         DURHAM      NC
L&T TECH SVCS LTD          51          290         341         EDISON      NJ
INTEL CORPORATION          213         115         328         CHANDLER    AZ
CISCO SYSTEMS INC          119         201         320         SAN JOSE    CA
JPMORGAN CHASE & CO        95          211         306         CHICAGO     IL
MINDTREE LIMITED           58          219         277         WARREN      NJ
ORACLE AMERICA INC         99          176         275         REDWOOD CI  CA
VIRTUSA CORPORATION        80          187         267         SOUTHBOROU  MA
HEXAWARE TECHNOLOGIES INC  116         142         258         ISELIN      NJ
IBM CORPORATION            159         82          241         DURHAM      NC
QUALCOMM TECHNOLOGIES INC  201         26          227         SAN DIEGO   CA
RANDSTAD TECHNOLOGIES LLC  10          216         226         WOBURN      MA
DELOITTE & TOUCHE LLP      59          149         208         BOSTON      MA
KFORCE INC                 68          136         204         TAMPA       FL
PRICEWATERHOUSECOOPERS LL  133         62          195         TAMPA       FL
CGI TECHNOLOGIES AND SOLU  65          126         191         FAIRFAX     VA
WAL-MART ASSOCIATES INC    31          153         184         BENTONVILL  AR
SALESFORCE COM INC         45          131         176         SAN FRANCI  CA
SYNECHRON INC              34          134         168         NEW YORK    NY
SYNTEL INC                 23          144         167         TROY        MI
NTT DATA INC               69          97          166         CHARLESTOW  MA
PRICEWATERHOUSECOOPERS AD  61          98          159         TAMPA       FL
COMPUNNEL SOFTWARE GROUP   18          132         150         PLAINSBORO  NJ
BANK OF AMERICA NA         62          84          146         CHARLOTTE   NC
EPAM SYSTEMS INC           78          67          145         NEWTOWN     PA
TESLA INC                  114         26          140         PALO ALTO   CA
UST GLOBAL INC             9           129         138         ALISO VIEJ  CA
EBAY INC                   76          62          138         SAN JOSE    CA
SAP AMERICA INC            88          49          137         NEWTOWN SQ  PA
UBER TECHNOLOGIES INC      85          46          131         SAN FRANCI  CA
GOLDMAN SACHS & CO LLC     66          59          125         JERSEY CIT  NJ
MCKINSEY & COMPANY INC US  82          36          118         NEW YORK    NY
PAYPAL INC                 60          58          118         SAN JOSE    CA
POLARIS CONSULTING & SERV  12          105         117         PISCATAWAY  NJ
MORGAN STANLEY SERVICES G  34          83          117         NEW YORK    NY
CERNER CORPORATION         93          19          112         NORTH KANS  MO
COMCAST CABLE COMMUNICATI  20          91          111         PHILADELPH  PA
CUMMINS INC                17          90          107         NASHVILLE   TN
AMERICAN EXPRESS TRAVEL R  9           96          105         NEW YORK    NY
KPMG LLP                   33          66          99          DALLAS      TX
VMWARE INC                 52          46          98          PALO ALTO   CA
CITIUSTECH INC             56          39          95          PRINCETON   NJ
BLOOMBERG LP               28          64          92          NEW YORK    NY
CITIBANK NA                41          50          91          NEW YORK    NY
BIRLASOFT INC              46          45          91          EDISON      NJ
NATSOFT CORPORATION        45          45          90          SOMERSET    NJ
OATH HOLDINGS INC          74          15          89          SUNNYVALE   CA
NVIDIA CORPORATION         50          39          89          SANTA CLAR  CA
MARLABS INC                35          52          87          PISCATAWAY  NJ
KPIT INFOSYSTEMS INC       42          44          86          EDISON      NJ
COMPUTER SCIENCES CORPORA  71          15          86          MC LEAN     VA
AKAMAI TECHNOLOGIES INC    58          26          84          CAMBRIDGE   MA
EXLSERVICE.COM LLC         49          34          83          NEW YORK    NY
LINKEDIN CORPORATION       52          30          82          SUNNYVALE   CA
NIIT TECHNOLOGIES LIMITED  22          59          81          ATLANTA     GA
AMAZON WEB SERVICES INC    30          47          77          SEATTLE     WA
HITACHI CONSULTING CORPOR  54          22          76          DALLAS      TX
JOHNS HOPKINS UNIVERSITY   35          38          73          BALTIMORE   MD
FUJITSU AMERICA INC        42          30          72          PITTSBURGH  PA
NTT DATA SERVICES LLC      44          27          71          CHARLESTOW  MA
UNIV OF MICHIGAN           45          26          71          ANN ARBOR   MI
NTT DATA INC               5           65          70          BOSTON      MA
MASTECH DIGITAL TECHNOLOG  7           63          70          CORAOPOLIS  PA
THE LELAND STANFORD JR UN  30          40          70          STANFORD    CA
SERVICENOW INC             47          22          69          SANTA CLAR  CA
HEWLETT PACKARD ENTERPRIS  28          41          69          AUSTIN      TX
T MOBILE USA INC           23          46          69          BELLEVUE    WA
STATE STREET BANK & TRUST  6           61          67          BOSTON      MA
ANTHEM INC                 14          53          67          WILMINGTON  DE
POPULUS GROUP LLC          25          42          67          TROY        MI
HEADSTRONG SERVICES LLC    16          51          67          SHORT HILL  NJ
COLLABERA INC              15          49          64          BASKING RI  NJ
CAPITAL ONE SERVICES LLC   19          44          63          HENRICO     VA
GENERAL MOTORS COMPANY     25          37          62          DETROIT     MI
OPTUM SERVICES INC         9           53          62          RICHARDSON  TX
I5 TECH INC                35          27          62          EDISON      NJ
CAPITAL ONE SERVICES LLC   4           58          62          RICHMOND    VA
AMERICAN AIRLINES INC      28          33          61          FORT WORTH  TX
BARCLAYS SERVICES CORP     21          40          61          NEW YORK    NY
QUEST GLOBAL SERVICES-NA   43          18          61          EAST HARTF  CT
CYIENT INC                 32          29          61          EAST HARTF  CT
SAPIENT CORPORATION        10          49          59          BOSTON      MA
Link to comment
Share on other sites
snoww LEGEND

snoww

Posted
Posted
44 minutes ago, ekunadam_enkanna said:

  



sqlite> select employer, ia, ca, (ca + ia) as total, city, state from h2019 order by total desc limit 100;
 EMPLOYER                  IA          CA          IA+CA       CITY        ST
-----------------------------------------------------------------------------
TATA CONSULTANCY SVCS LTD  1177        1881        3058        ROCKVILLE   MD
COGNIZANT TECH SOLNS US C  158         1717        1875        COLLEGE ST  TX
DELOITTE CONSULTING LLP    125         1072        1197        PHILADELPH  PA
TECH MAHINDRA AMERICAS IN  475         540         1015        SOUTH PLAI  NJ
WIPRO LIMITED              270         652         922         EAST BRUNS  NJ
INFOSYS LTD                38          828         866         PLANO       TX
MICROSOFT CORPORATION      364         485         849         REDMOND     WA
GOOGLE LLC                 512         240         752         MOUNTAIN V  CA
LARSEN AND TOUBRO INFOTEC  317         417         734         EDISON      NJ
AMAZON.COM SERVICES INC    606         124         730         SEATTLE     WA
ERNST & YOUNG US LLP       83          627         710         SECAUCUS    NJ
CAPGEMINI AMERICA INC      135         484         619         CHICAGO     IL
ACCENTURE LLP              100         466         566         CHICAGO     IL
DELOITTE CONSULTING LLP    298         164         462         BOSTON      MA
FACEBOOK INC               351         97          448         MENLO PARK  CA
MPHASIS CORPORATION        222         218         440         NEW YORK    NY
APPLE INC                  194         234         428         CUPERTINO   CA
HCL AMERICA INC            31          381         412         SUNNYVALE   CA
IBM INDIA PRIVATE LIMITED  15          356         371         DURHAM      NC
L&T TECH SVCS LTD          51          290         341         EDISON      NJ
INTEL CORPORATION          213         115         328         CHANDLER    AZ
CISCO SYSTEMS INC          119         201         320         SAN JOSE    CA
JPMORGAN CHASE & CO        95          211         306         CHICAGO     IL
MINDTREE LIMITED           58          219         277         WARREN      NJ
ORACLE AMERICA INC         99          176         275         REDWOOD CI  CA
VIRTUSA CORPORATION        80          187         267         SOUTHBOROU  MA
HEXAWARE TECHNOLOGIES INC  116         142         258         ISELIN      NJ
IBM CORPORATION            159         82          241         DURHAM      NC
QUALCOMM TECHNOLOGIES INC  201         26          227         SAN DIEGO   CA
RANDSTAD TECHNOLOGIES LLC  10          216         226         WOBURN      MA
DELOITTE & TOUCHE LLP      59          149         208         BOSTON      MA
KFORCE INC                 68          136         204         TAMPA       FL
PRICEWATERHOUSECOOPERS LL  133         62          195         TAMPA       FL
CGI TECHNOLOGIES AND SOLU  65          126         191         FAIRFAX     VA
WAL-MART ASSOCIATES INC    31          153         184         BENTONVILL  AR
SALESFORCE COM INC         45          131         176         SAN FRANCI  CA
SYNECHRON INC              34          134         168         NEW YORK    NY
SYNTEL INC                 23          144         167         TROY        MI
NTT DATA INC               69          97          166         CHARLESTOW  MA
PRICEWATERHOUSECOOPERS AD  61          98          159         TAMPA       FL
COMPUNNEL SOFTWARE GROUP   18          132         150         PLAINSBORO  NJ
BANK OF AMERICA NA         62          84          146         CHARLOTTE   NC
EPAM SYSTEMS INC           78          67          145         NEWTOWN     PA
TESLA INC                  114         26          140         PALO ALTO   CA
UST GLOBAL INC             9           129         138         ALISO VIEJ  CA
EBAY INC                   76          62          138         SAN JOSE    CA
SAP AMERICA INC            88          49          137         NEWTOWN SQ  PA
UBER TECHNOLOGIES INC      85          46          131         SAN FRANCI  CA
GOLDMAN SACHS & CO LLC     66          59          125         JERSEY CIT  NJ
MCKINSEY & COMPANY INC US  82          36          118         NEW YORK    NY
PAYPAL INC                 60          58          118         SAN JOSE    CA
POLARIS CONSULTING & SERV  12          105         117         PISCATAWAY  NJ
MORGAN STANLEY SERVICES G  34          83          117         NEW YORK    NY
CERNER CORPORATION         93          19          112         NORTH KANS  MO
COMCAST CABLE COMMUNICATI  20          91          111         PHILADELPH  PA
CUMMINS INC                17          90          107         NASHVILLE   TN
AMERICAN EXPRESS TRAVEL R  9           96          105         NEW YORK    NY
KPMG LLP                   33          66          99          DALLAS      TX
VMWARE INC                 52          46          98          PALO ALTO   CA
CITIUSTECH INC             56          39          95          PRINCETON   NJ
BLOOMBERG LP               28          64          92          NEW YORK    NY
CITIBANK NA                41          50          91          NEW YORK    NY
BIRLASOFT INC              46          45          91          EDISON      NJ
NATSOFT CORPORATION        45          45          90          SOMERSET    NJ
OATH HOLDINGS INC          74          15          89          SUNNYVALE   CA
NVIDIA CORPORATION         50          39          89          SANTA CLAR  CA
MARLABS INC                35          52          87          PISCATAWAY  NJ
KPIT INFOSYSTEMS INC       42          44          86          EDISON      NJ
COMPUTER SCIENCES CORPORA  71          15          86          MC LEAN     VA
AKAMAI TECHNOLOGIES INC    58          26          84          CAMBRIDGE   MA
EXLSERVICE.COM LLC         49          34          83          NEW YORK    NY
LINKEDIN CORPORATION       52          30          82          SUNNYVALE   CA
NIIT TECHNOLOGIES LIMITED  22          59          81          ATLANTA     GA
AMAZON WEB SERVICES INC    30          47          77          SEATTLE     WA
HITACHI CONSULTING CORPOR  54          22          76          DALLAS      TX
JOHNS HOPKINS UNIVERSITY   35          38          73          BALTIMORE   MD
FUJITSU AMERICA INC        42          30          72          PITTSBURGH  PA
NTT DATA SERVICES LLC      44          27          71          CHARLESTOW  MA
UNIV OF MICHIGAN           45          26          71          ANN ARBOR   MI
NTT DATA INC               5           65          70          BOSTON      MA
MASTECH DIGITAL TECHNOLOG  7           63          70          CORAOPOLIS  PA
THE LELAND STANFORD JR UN  30          40          70          STANFORD    CA
SERVICENOW INC             47          22          69          SANTA CLAR  CA
HEWLETT PACKARD ENTERPRIS  28          41          69          AUSTIN      TX
T MOBILE USA INC           23          46          69          BELLEVUE    WA
STATE STREET BANK & TRUST  6           61          67          BOSTON      MA
ANTHEM INC                 14          53          67          WILMINGTON  DE
POPULUS GROUP LLC          25          42          67          TROY        MI
HEADSTRONG SERVICES LLC    16          51          67          SHORT HILL  NJ
COLLABERA INC              15          49          64          BASKING RI  NJ
CAPITAL ONE SERVICES LLC   19          44          63          HENRICO     VA
GENERAL MOTORS COMPANY     25          37          62          DETROIT     MI
OPTUM SERVICES INC         9           53          62          RICHARDSON  TX
I5 TECH INC                35          27          62          EDISON      NJ
CAPITAL ONE SERVICES LLC   4           58          62          RICHMOND    VA
AMERICAN AIRLINES INC      28          33          61          FORT WORTH  TX
BARCLAYS SERVICES CORP     21          40          61          NEW YORK    NY
QUEST GLOBAL SERVICES-NA   43          18          61          EAST HARTF  CT
CYIENT INC                 32          29          61          EAST HARTF  CT
SAPIENT CORPORATION        10          49          59          BOSTON      MA

Approvals column pakkana denials column kooda pettu bro. 

I heard WITCH companies are getting almost 33% denials. Want to see if it is truth. And compare it to American companies. 

Link to comment
Share on other sites
ekunadam_enkanna Hero

ekunadam_enkanna

Posted
  • Author
Posted 
$ cat run.sql
.mode column
.headers on
select employer, ia, ca, (ca + ia) as totalApprovals, id, cd, (cd+id) as totalDenials, city, state from h2019 order by totalApprovals desc limit 100;

$ sqlite3 blah.db < run.sql
employer                   ia          ca          totalApprovals  id          cd          totalDenials  city        state
-------------------------  ----------  ----------  --------------  ----------  ----------  ------------  ----------  ----------
TATA CONSULTANCY SVCS LTD  1177        1881        3058            700         832         1532          ROCKVILLE   MD
COGNIZANT TECH SOLNS US C  158         1717        1875            217         996         1213          COLLEGE ST  TX
DELOITTE CONSULTING LLP    125         1072        1197            150         497         647           PHILADELPH  PA
TECH MAHINDRA AMERICAS IN  475         540         1015            440         78          518           SOUTH PLAI  NJ
WIPRO LIMITED              270         652         922             437         189         626           EAST BRUNS  NJ
INFOSYS LTD                38          828         866             49          423         472           PLANO       TX
MICROSOFT CORPORATION      364         485         849             54          15          69            REDMOND     WA
GOOGLE LLC                 512         240         752             16          10          26            MOUNTAIN V  CA
LARSEN AND TOUBRO INFOTEC  317         417         734             83          55          138           EDISON      NJ
AMAZON.COM SERVICES INC    606         124         730             27          27          54            SEATTLE     WA
ERNST & YOUNG US LLP       83          627         710             65          106         171           SECAUCUS    NJ
CAPGEMINI AMERICA INC      135         484         619             138         266         404           CHICAGO     IL
ACCENTURE LLP              100         466         566             96          138         234           CHICAGO     IL
DELOITTE CONSULTING LLP    298         164         462             564         165         729           BOSTON      MA
FACEBOOK INC               351         97          448             11          4           15            MENLO PARK  CA
MPHASIS CORPORATION        222         218         440             60          25          85            NEW YORK    NY
APPLE INC                  194         234         428             6           5           11            CUPERTINO   CA
HCL AMERICA INC            31          381         412             23          169         192           SUNNYVALE   CA
IBM INDIA PRIVATE LIMITED  15          356         371             5           145         150           DURHAM      NC
L&T TECH SVCS LTD          51          290         341             11          32          43            EDISON      NJ
INTEL CORPORATION          213         115         328             19          9           28            CHANDLER    AZ
CISCO SYSTEMS INC          119         201         320             11          4           15            SAN JOSE    CA
JPMORGAN CHASE & CO        95          211         306             16          10          26            CHICAGO     IL
MINDTREE LIMITED           58          219         277             3           27          30            WARREN      NJ
ORACLE AMERICA INC         99          176         275             9           6           15            REDWOOD CI  CA
VIRTUSA CORPORATION        80          187         267             18          18          36            SOUTHBOROU  MA
HEXAWARE TECHNOLOGIES INC  116         142         258             10          12          22            ISELIN      NJ
IBM CORPORATION            159         82          241             23          34          57            DURHAM      NC
QUALCOMM TECHNOLOGIES INC  201         26          227             12          7           19            SAN DIEGO   CA
RANDSTAD TECHNOLOGIES LLC  10          216         226             2           13          15            WOBURN      MA
DELOITTE & TOUCHE LLP      59          149         208             54          78          132           BOSTON      MA
KFORCE INC                 68          136         204             32          52          84            TAMPA       FL
PRICEWATERHOUSECOOPERS LL  133         62          195             36          23          59            TAMPA       FL
CGI TECHNOLOGIES AND SOLU  65          126         191             7           12          19            FAIRFAX     VA
WAL-MART ASSOCIATES INC    31          153         184             8           18          26            BENTONVILL  AR
SALESFORCE COM INC         45          131         176             1           3           4             SAN FRANCI  CA
SYNECHRON INC              34          134         168             8           10          18            NEW YORK    NY
SYNTEL INC                 23          144         167             16          84          100           TROY        MI
NTT DATA INC               69          97          166             11          7           18            CHARLESTOW  MA
PRICEWATERHOUSECOOPERS AD  61          98          159             33          93          126           TAMPA       FL
COMPUNNEL SOFTWARE GROUP   18          132         150             8           19          27            PLAINSBORO  NJ
BANK OF AMERICA NA         62          84          146             4           4           8             CHARLOTTE   NC
EPAM SYSTEMS INC           78          67          145             34          7           41            NEWTOWN     PA
TESLA INC                  114         26          140             16          6           22            PALO ALTO   CA
UST GLOBAL INC             9           129         138             4           15          19            ALISO VIEJ  CA
EBAY INC                   76          62          138             4           0           4             SAN JOSE    CA
SAP AMERICA INC            88          49          137             12          6           18            NEWTOWN SQ  PA
UBER TECHNOLOGIES INC      85          46          131             4           1           5             SAN FRANCI  CA
GOLDMAN SACHS & CO LLC     66          59          125             40          5           45            JERSEY CIT  NJ
MCKINSEY & COMPANY INC US  82          36          118             34          9           43            NEW YORK    NY
PAYPAL INC                 60          58          118             3           3           6             SAN JOSE    CA
POLARIS CONSULTING & SERV  12          105         117             51          12          63            PISCATAWAY  NJ
MORGAN STANLEY SERVICES G  34          83          117             5           1           6             NEW YORK    NY
CERNER CORPORATION         93          19          112             6           0           6             NORTH KANS  MO
COMCAST CABLE COMMUNICATI  20          91          111             1           4           5             PHILADELPH  PA
CUMMINS INC                17          90          107             4           5           9             NASHVILLE   TN
AMERICAN EXPRESS TRAVEL R  9           96          105             1           2           3             NEW YORK    NY
KPMG LLP                   33          66          99              2           19          21            DALLAS      TX
VMWARE INC                 52          46          98              7           4           11            PALO ALTO   CA
CITIUSTECH INC             56          39          95              40          12          52            PRINCETON   NJ
BLOOMBERG LP               28          64          92              11          7           18            NEW YORK    NY
CITIBANK NA                41          50          91              21          1           22            NEW YORK    NY
BIRLASOFT INC              46          45          91              38          6           44            EDISON      NJ
NATSOFT CORPORATION        45          45          90              5           5           10            SOMERSET    NJ
OATH HOLDINGS INC          74          15          89              6           6           12            SUNNYVALE   CA
NVIDIA CORPORATION         50          39          89              2           2           4             SANTA CLAR  CA
MARLABS INC                35          52          87              23          3           26            PISCATAWAY  NJ
KPIT INFOSYSTEMS INC       42          44          86              7           9           16            EDISON      NJ
COMPUTER SCIENCES CORPORA  71          15          86              6           1           7             MC LEAN     VA
AKAMAI TECHNOLOGIES INC    58          26          84              0           1           1             CAMBRIDGE   MA
EXLSERVICE.COM LLC         49          34          83              42          4           46            NEW YORK    NY
LINKEDIN CORPORATION       52          30          82              0           3           3             SUNNYVALE   CA
NIIT TECHNOLOGIES LIMITED  22          59          81              3           11          14            ATLANTA     GA
AMAZON WEB SERVICES INC    30          47          77              5           11          16            SEATTLE     WA
HITACHI CONSULTING CORPOR  54          22          76              0           5           5             DALLAS      TX
JOHNS HOPKINS UNIVERSITY   35          38          73              0           2           2             BALTIMORE   MD
FUJITSU AMERICA INC        42          30          72              3           5           8             PITTSBURGH  PA
NTT DATA SERVICES LLC      44          27          71              24          2           26            CHARLESTOW  MA
UNIV OF MICHIGAN           45          26          71              0           1           1             ANN ARBOR   MI
NTT DATA INC               5           65          70              1           1           2             BOSTON      MA
MASTECH DIGITAL TECHNOLOG  7           63          70              2           21          23            CORAOPOLIS  PA
THE LELAND STANFORD JR UN  30          40          70              0           0           0             STANFORD    CA
SERVICENOW INC             47          22          69              2           0           2             SANTA CLAR  CA
HEWLETT PACKARD ENTERPRIS  28          41          69              4           1           5             AUSTIN      TX
T MOBILE USA INC           23          46          69              2           3           5             BELLEVUE    WA
STATE STREET BANK & TRUST  6           61          67              3           2           5             BOSTON      MA
ANTHEM INC                 14          53          67              1           0           1             WILMINGTON  DE
POPULUS GROUP LLC          25          42          67              58          33          91            TROY        MI
HEADSTRONG SERVICES LLC    16          51          67              18          6           24            SHORT HILL  NJ
COLLABERA INC              15          49          64              13          11          24            BASKING RI  NJ
CAPITAL ONE SERVICES LLC   19          44          63              2           3           5             HENRICO     VA
GENERAL MOTORS COMPANY     25          37          62              2           0           2             DETROIT     MI
OPTUM SERVICES INC         9           53          62              1           1           2             RICHARDSON  TX
I5 TECH INC                35          27          62              14          5           19            EDISON      NJ
CAPITAL ONE SERVICES LLC   4           58          62              0           0           0             RICHMOND    VA
AMERICAN AIRLINES INC      28          33          61              2           1           3             FORT WORTH  TX
BARCLAYS SERVICES CORP     21          40          61              0           3           3             NEW YORK    NY
QUEST GLOBAL SERVICES-NA   43          18          61              26          1           27            EAST HARTF  CT
CYIENT INC                 32          29          61              3           1           4             EAST HARTF  CT
SAPIENT CORPORATION        10          49          59              4           16          20            BOSTON      MA

 

  • Upvote 1
Link to comment
Share on other sites
snoww LEGEND

snoww

Posted
Posted 
TATA CONSULTANCY SVCS LTD  1177        1881        3058            700         832         1532          ROCKVILLE   MD
COGNIZANT TECH SOLNS US C  158         1717        1875            217         996         1213          COLLEGE ST  TX
DELOITTE CONSULTING LLP    125         1072        1197            150         497         647           PHILADELPH  PA
TECH MAHINDRA AMERICAS IN  475         540         1015            440         78          518           SOUTH PLAI  NJ
WIPRO LIMITED              270         652         922             437         189         626           EAST BRUNS  NJ
INFOSYS LTD                38          828         866             49          423         472           PLANO       TX

seems right. Almost 33% applications getting denied. 

Link to comment
Share on other sites
ekunadam_enkanna Hero

ekunadam_enkanna

Posted
  • Author
Posted 
2019 or since April 2018 data:

employer                   ia          ca        totalApprovals   id       cd         totalDenials      city      state
-------------------------  ----------  ----------  ----------  ----------  ----------  ----------  ----------  ----------
TATA CONSULTANCY SVCS LTD  1177        1881        3058        700         832         1532        ROCKVILLE   MD
COGNIZANT TECH SOLNS US C  158         1717        1875        217         996         1213        COLLEGE ST  TX
DELOITTE CONSULTING LLP    298         164         462         564         165         729         BOSTON      MA
DELOITTE CONSULTING LLP    125         1072        1197        150         497         647         PHILADELPH  PA
WIPRO LIMITED              270         652         922         437         189         626         EAST BRUNS  NJ
TECH MAHINDRA AMERICAS IN  475         540         1015        440         78          518         SOUTH PLAI  NJ
INFOSYS LTD                38          828         866         49          423         472         PLANO       TX
CAPGEMINI AMERICA INC      135         484         619         138         266         404         CHICAGO     IL
ACCENTURE LLP              100         466         566         96          138         234         CHICAGO     IL
HCL AMERICA INC            31          381         412         23          169         192         SUNNYVALE   CA
ERNST & YOUNG US LLP       83          627         710         65          106         171         SECAUCUS    NJ
IBM INDIA PRIVATE LIMITED  15          356         371         5           145         150         DURHAM      NC
LARSEN AND TOUBRO INFOTEC  317         417         734         83          55          138         EDISON      NJ
DELOITTE & TOUCHE LLP      59          149         208         54          78          132         BOSTON      MA
PRICEWATERHOUSECOOPERS AD  61          98          159         33          93          126         TAMPA       FL
SYNTEL INC                 23          144         167         16          84          100         TROY        MI
LUSSOTECH LLC              3           0           3           100         0           100         RESTON      VA
POPULUS GROUP LLC          25          42          67          58          33          91          TROY        MI
SAIBERSYS INC              1           2           3           86          4           90          CARROLLTON  TX
MPHASIS CORPORATION        222         218         440         60          25          85          NEW YORK    NY
KFORCE INC                 68          136         204         32          52          84          TAMPA       FL
MICROSOFT CORPORATION      364         485         849         54          15          69          REDMOND     WA
CLOUD BIG DATA TECHNOLOGI  2           1           3           61          3           64          DALLAS      TX
POLARIS CONSULTING & SERV  12          105         117         51          12          63          PISCATAWAY  NJ
PRINCIPLE INFORMATION TEC  6           2           8           62          0           62          HOUSTON     TX
PRICEWATERHOUSECOOPERS LL  133         62          195         36          23          59          TAMPA       FL
IBM CORPORATION            159         82          241         23          34          57          DURHAM      NC
SQA CONCEPTS INC           1           5           6           51          5           56          ASHBURN     VA
ANIRA SOLUTIONS INC        1           4           5           54          2           56          ASHBURN     VA
VERIDIC SOLUTIONS, LLC     28          4           32          52          3           55          DULUTH      GA
AMAZON.COM SERVICES INC    606         124         730         27          27          54          SEATTLE     WA
FRIENDLY CONSULTANTS INC   7           5           12          53          0           53          PRINCETON   NJ
E GIANTS TECHNOLOGIES LLC  22          7           29          49          4           53          CLIVE       IA
CITIUSTECH INC             56          39          95          40          12          52          PRINCETON   NJ
SOLOMONS INTERNATIONAL LL  1           0           1           50          0           50          HARLEYSVIL  PA
FRACTAL ANALYTICS INC      5           6           11          46          3           49          JERSEY CIT  NJ
PIONEER CONSULTING SERVIC  9           11          20          41          8           49          WEST DES M  IA
ERP ANALYSTS INC           7           47          54          17          30          47          DUBLIN      OH
EXLSERVICE.COM LLC         49          34          83          42          4           46          NEW YORK    NY
HCL GLOBAL SYSTEMS INC     8           39          47          27          18          45          FARMINGTON  MI
GOLDMAN SACHS & CO LLC     66          59          125         40          5           45          JERSEY CIT  NJ
RELIANT VISION GROUP INC   2           12          14          44          1           45          ISELIN      NJ
BIRLASOFT INC              46          45          91          38          6           44          EDISON      NJ
THE BOSTON CONSULTING GRO  35          21          56          41          2           43          BOSTON      MA
MCKINSEY & COMPANY INC US  82          36          118         34          9           43          NEW YORK    NY
L&T TECH SVCS LTD          51          290         341         11          32          43          EDISON      NJ
EPAM SYSTEMS INC           78          67          145         34          7           41          NEWTOWN     PA
ANTRA INC                  3           4           7           39          2           41          STERLING    VA
COMTEK GLOBAL INC DBA CEN  0           3           3           37          2           39          PISCATAWAY  NJ
3I INFOTECH INC            11          30          41          30          7           37          EDISON      NJ
VIRTUSA CORPORATION        80          187         267         18          18          36          SOUTHBOROU  MA
AVANI SYSTEMS INC          0           0           0           32          3           35          HOUSTON     TX
I3 INFOTEK INC             4           5           9           28          7           35          ISELIN      NJ
SMART IT FRAME LLC         2           0           2           33          1           34          JERSEY CIT  NJ
JNIT TECHNOLOGIES INC      1           0           1           33          0           33          GRAPEVINE   TX
VECTOR SYSTEMS INC         0           0           0           31          1           32          MATAWAN     NJ
XTRACIT INC                8           0           8           31          1           32          CHARLOTTE   NC
NEO PRISM SOLUTIONS LLC    0           8           8           26          5           31          CHARLOTTE   NC
GVA INFOTECH INC           6           0           6           29          2           31          ASHBURN     VA
VEDICSOFT SOLUTIONS LLC    9           29          38          20          11          31          ISELIN      NJ
ELITE IT PROFESSIONALS IN  0           0           0           31          0           31          SOMERSET    NJ
INFISYSTEMS LLC            1           6           7           28          2           30          CLEARWATER  FL
EALEARN INC                3           1           4           30          0           30          EDISON      NJ
VSION TECHNOLOGIES INC     7           5           12          26          4           30          CEDAR PARK  TX
MINDTREE LIMITED           58          219         277         3           27          30          WARREN      NJ
AMENSYS INC                8           1           9           26          3           29          LEWISVILLE  TX
LGBS SOFTWARE INC          0           0           0           29          0           29          MAHWAH      NJ
PROFUSION SYSS INC DBA ST  0           1           1           27          2           29          NORTH BRUN  NJ
V-SOFT CONSULTING GROUP I  1           50          51          7           22          29          LOUISVILLE  KY
CLOUD HYBRID TECHNOLOGIES  1           0           1           28          0           28          DALLAS      TX
MIRACLE SOFTTECH LLC       0           4           4           28          0           28          MOUNT LAUR  NJ
INTEL CORPORATION          213         115         328         19          9           28          CHANDLER    AZ
QUEST GLOBAL SERVICES-NA   43          18          61          26          1           27          EAST HARTF  CT
COMPUNNEL SOFTWARE GROUP   18          132         150         8           19          27          PLAINSBORO  NJ
JPMORGAN CHASE & CO        95          211         306         16          10          26          CHICAGO     IL
NTT DATA SERVICES LLC      44          27          71          24          2           26          CHARLESTOW  MA
BI LABS INC                7           6           13          26          0           26          ISELIN      NJ
PERFORMANCE RESOURCES NY   5           1           6           22          4           26          HAUPPAUGE   NY
MARLABS INC                35          52          87          23          3           26          PISCATAWAY  NJ
ANJANEYAP INC              2           1           3           25          1           26          MILPITAS    CA
WAL-MART ASSOCIATES INC    31          153         184         8           18          26          BENTONVILL  AR
GOOGLE LLC                 512         240         752         16          10          26          MOUNTAIN V  CA
MALVI SYSTEMS LLC          0           0           0           24          1           25          CRANBURY    NJ
AMITI CONSULTING INC       3           2           5           24          1           25          ASHBURN     VA
CNET GLOBAL SOLUTIONS INC  6           13          19          15          9           24          RICHARDSON  TX
COLLABERA INC              15          49          64          13          11          24          BASKING RI  NJ
GENPACT LLC                14          26          40          20          4           24          SHORT HILL  NJ
WAYFAIR LLC                1           32          33          19          5           24          BOSTON      MA
HEADSTRONG SERVICES LLC    16          51          67          18          6           24          SHORT HILL  NJ
ARKA TECHNOLOGIES INC      9           3           12          23          1           24          MIAMI       FL
MASTECH DIGITAL TECHNOLOG  7           63          70          2           21          23          CORAOPOLIS  PA
RJT COMPUQUEST INC         3           8           11          16          7           23          EL SEGUNDO  CA
EGEN SOLUTIONS INC         12          4           16          18          5           23          NAPERVILLE  IL
EPITEC INC                 11          8           19          21          2           23          SOUTHFIELD  MI
APLOMB TECHNOLOGIES INC    0           11          11          21          2           23          PRINCETON   NJ
MICRONET IT SOLUTIONS INC  10          0           10          21          2           23          PLEASANTON  CA
FIDENTIATECH LLC           0           0           0           23          0           23          RESTON      VA
CITIBANK NA                41          50          91          21          1           22          NEW YORK    NY
HEXAWARE TECHNOLOGIES INC  116         142         258         10          12          22          ISELIN      NJ
VORTALSOFT INC             1           6           7           22          0           22          SOMERSET    NJ

 

Link to comment
Share on other sites
ekunadam_enkanna Hero

ekunadam_enkanna

Posted
  • Author
Posted

Here are all mesthris, whose visas are picked up in 2018 April Lottery; however, their h1-bs got denied later: 

sqlite> select employer, ia, id from h2019 where ia = 0 and id > 0 order by id desc limit 150;
employer                           ia          id
---------------------------------  ----------  ----------
COMTEK GLOBAL INC DBA CENTILLIONZ  0           37
AVANI SYSTEMS INC                  0           32
VECTOR SYSTEMS INC                 0           31
ELITE IT PROFESSIONALS INC         0           31
LGBS SOFTWARE INC                  0           29
MIRACLE SOFTTECH LLC               0           28
PROFUSION SYSS INC DBA STAFFING F  0           27
NEO PRISM SOLUTIONS LLC            0           26
MALVI SYSTEMS LLC                  0           24
FIDENTIATECH LLC                   0           23
TEKGROUP LLC                       0           22
APLOMB TECHNOLOGIES INC            0           21
ICLOUD TECHNOLOGIES CORP           0           21
PURSUIT INC                        0           19
SIARAA TECHNOLOGIES INC            0           19
T2M CONSULTING SERVICES INC        0           18
TECHALPHA LLC                      0           17
EQUINOX IT SOLUTIONS LLC           0           16
NIKTOR LLC                         0           16
VASTEK INC                         0           15
SRIVIN INFOSYSTEMS INC DBA MAHIMA  0           14
LEARNBEYOND INC                    0           13
THE SAKS IT GROUP LLC              0           13
UNITED PHARMA TECHNOLOGIES INC     0           13
SUNBIZ HOLDINGS CORP               0           13
SOFTCOM SYSTEMS INC                0           11
VSLN INTERNATIONAL INC             0           11
EQUINOX IT SOLUTIONS LLC           0           11
ICOM INC                           0           11
GLOBE 2 TECHNOLOGIES INC           0           11
CRITICALRIVER INC                  0           11
EXPRESS GLOBAL SOLUTIONS LLC       0           11
IT SWARM LLC                       0           11
TIMESQUARE IT INC                  0           11
SRIT INC                           0           11
THE FOUNTAIN GROUP LLC             0           10
FISEC GLOBAL INC                   0           10
SPLN LLC                           0           10
SHOOLIN INC                        0           9
ITEK SOFTWARE LLC                  0           9
RD TECH SYSTEMS INC                0           9
SPHINX IT SOLUTIONS LLC            0           9
CYBERMINDS INC                     0           9
TECHRODE INC                       0           9
BA2CC SOLUTIONS INC                0           9
SECURITY IRIS INC                  0           9
EXCELSOFT SERVICES INC             0           8
HORIZON SOFTECH INC                0           8
Z-AXIS TECH SOLUTIONS INC          0           8
ENGINEERING TECH ASSOC INC         0           8
IKON SYSTEMS LLC                   0           8
TECHSTAR SOLUTIONS INC             0           8
PETA SYSTEMS INC                   0           8
FIREFLY PROS INC                   0           8
SLALOM LLC                         0           8
PERIGON INFOTECH INC               0           7
INFOYUGA TECHNOLOGIES INC          0           7
CYBERBRAINS INC                    0           7
STECK SYSTEMS INC                  0           7
BDSN INTERNATIONAL INC             0           7
TECHGURUS CONSULTING LLC           0           7
INDUS GROUP INC                    0           7
PEK SYSTEMS INC                    0           7
BHRIGUS INC                        0           6
BUSINESS TECH SOFTWARE SOLUTIONS   0           6
ITVISION INC                       0           6
SOFTWARE MERCHANT INC              0           6
SRNL INTERNATIONAL INC             0           6
CITY GURUS INC                     0           6
ENTERPRISE QA LABS INC             0           6
RUBIKTEK INC                       0           6
DATAMINDSOLUTIONS LLC              0           6
DIGITAL ITECHNOLOGY LLC            0           6
SUPERIOR SOFTWARE & TECH SOLUTION  0           6
IT HOPPERS INC                     0           6
VDRIVEINFO INC                     0           6
MOBILECOMM PROFESSIONALS INC       0           6
TEKREANT INC                       0           6
FUTURE IT SOLUTIONS LLC            0           6
XPRESS GLOBAL IT SOLUTIONS LLC     0           6
APPISOFT INC                       0           5
GLOBAL BRIDGE INFOTECH INC         0           5
INFO KEYS INC                      0           5
AUROPRO SYSTEMS INC                0           5
INTELLIGROUP USA LIMITED           0           5
ANTRA INC                          0           5
AMERICAN TECHNOLOGY CONSULTING LL  0           5
SUDHI INFOMATICS INC               0           5
ARKRIT LLC                         0           5
YASHRAJ TECHNOLOGIES INC           0           5
PRITNA INC                         0           5
MYAPPSHUB LLC                      0           5
NUWAY SOLUTIONS LLC                0           5
PIEZOS TECH SOLUTIONS INC          0           5
AZURE CONSULTING SERVICES LLC      0           5
UNICAREER LLC                      0           5
CYBERSOLVE IT INC                  0           5
ICF RESOURCES LLC                  0           5
SPENSYS INC                        0           5
MERLIN SIGHT LLC                   0           5
SOFTPATH TECHNOLOGIES LLC          0           5
KEY BUSINESS SOLUTIONS INC         0           5
CLICKSOFTWARE INC                  0           5
DEUTSCHE BANK TRUST CO AMERICAS    0           4
SIMPSON THACHER & BARTLETT LLP     0           4
PANTAR SOLUTIONS INC               0           4
AGILESOFT INC                      0           4
MVSOFTTECH INC DBA SVSS INFOTECH   0           4
ORPINE INC                         0           4
YES HARDSOFT SOLUTIONS INC         0           4
MILLENIUM INFO TECH INC            0           4
CANVAS INFOTECH INC                0           4
IBUSINESS SOLUTION LLC             0           4
REMOTE TIGER INC                   0           4
COMPUTE TECH INC                   0           4
SSB SOFTWARE TECHNOLOGIES INC      0           4
MINDSYS INC                        0           4
WAVE SOLUTIONS INC                 0           4
GSK SOLUTIONS INC                  0           4
WHOLEREN LLC                       0           4
IDEAL SOURCE INC                   0           4
IBM GLOBAL SYSTEMS INC DBA JOLT    0           4
VISUAL TECHNOLOGIES LLC            0           4
AMOR SYSTEMS LLC                   0           4
BRIGHTECH INTERNATIONAL LLC        0           4
ALTIMETRIK CORP                    0           4
INDUS USA INC                      0           4
UBERTAL INC D/B/A UBERTAL TECH     0           4
MSRCOSMOS LLC                      0           4
ASCII GROUP LLC                    0           4
TEG ANALYTICS LLC                  0           4
VOLANTSOFT INC                     0           4
RESOURCE INFORMATICS GROUP INC     0           4
AZEE SYSTEMS INC                   0           4
MARVELL TECH LLC                   0           4
TSQ SYSTEMS INC                    0           4
FINDREAM LLC                       0           4
NEXUS IT INC                       0           4
APPS GLOBE                         0           4
CIGNITI TECHNOLOGIES INC           0           4
HILLSOFT BUSINESS SOLUTIONS LLC    0           4
AA SOLUTIONS INC                   0           4
MULBERRY MANAGEMENT CORPORATION    0           4
RAK ITPRENEURS LLC                 0           4
LEO PROJECTS CORPORATION           0           4
LOGIXHUB LLC                       0           4
E BASE TECHNOLOGIES INC            0           4
ZENITH LIFESCIENCE LLC             0           4
FELTON GROUP INC                   0           4
HELIOZ SOLUTIONS INC               0           4

 

  • Upvote 1
Link to comment
Share on other sites
ekunadam_enkanna Hero

ekunadam_enkanna

Posted
  • Author
Posted 
2019  Total Intial Approvals, Total Intial Denials. What happened to 85000 H1-B quota?

sqlite> select sum(ia),sum(id), sum(ia+id) from h2019;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
33366.0     15345.0     48711

2018, here we see the total as 116070. Maybe, some are cap-exempt, like those H1-Bs sought by non-profit unis.

sqlite> select sum(ia),sum(id), sum(ia+id) from h2018;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
87889.0     28181.0     116070


sqlite> select sum(ia),sum(id), sum(ia+id) from h2017;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
96166.0     14518.0     110684

sqlite> select sum(ia),sum(id), sum(ia+id) from h2016;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
105092.0    11295.0     116387

sqlite> select sum(ia),sum(id), sum(ia+id) from h2015;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
111846.0    7644.0      119490

sqlite> select sum(ia),sum(id), sum(ia+id) from h2014;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
130616.0    10645.0     141261

sqlite> select sum(ia),sum(id), sum(ia+id) from h2013;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
130736.0    9596.0      140332

sqlite> select sum(ia),sum(id), sum(ia+id) from h2012;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
140809.0    7401.0      148210

sqlite> select sum(ia),sum(id), sum(ia+id) from h2011;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
114863.0    8583.0      123446

sqlite> select sum(ia),sum(id), sum(ia+id) from h2010;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
84038.0     7352.0      91390

sqlite> select sum(ia),sum(id), sum(ia+id) from h2009;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
99790.0     18099.0     117889

 

  • Upvote 1
Link to comment
Share on other sites
snoww LEGEND

snoww

Posted
Posted
3 hours ago, ekunadam_enkanna said: 

2019  Total Intial Approvals, Total Intial Denials. What happened to 85000 H1-B quota?

sqlite> select sum(ia),sum(id), sum(ia+id) from h2019;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
33366.0     15345.0     48711

2018, here we see the total as 116070. Maybe, some are cap-exempt, like those H1-Bs sought by non-profit unis.

sqlite> select sum(ia),sum(id), sum(ia+id) from h2018;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
87889.0     28181.0     116070


sqlite> select sum(ia),sum(id), sum(ia+id) from h2017;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
96166.0     14518.0     110684

sqlite> select sum(ia),sum(id), sum(ia+id) from h2016;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
105092.0    11295.0     116387

sqlite> select sum(ia),sum(id), sum(ia+id) from h2015;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
111846.0    7644.0      119490

sqlite> select sum(ia),sum(id), sum(ia+id) from h2014;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
130616.0    10645.0     141261

sqlite> select sum(ia),sum(id), sum(ia+id) from h2013;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
130736.0    9596.0      140332

sqlite> select sum(ia),sum(id), sum(ia+id) from h2012;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
140809.0    7401.0      148210

sqlite> select sum(ia),sum(id), sum(ia+id) from h2011;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
114863.0    8583.0      123446

sqlite> select sum(ia),sum(id), sum(ia+id) from h2010;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
84038.0     7352.0      91390

sqlite> select sum(ia),sum(id), sum(ia+id) from h2009;
sum(ia)     sum(id)     sum(ia+id)
----------  ----------  ----------
99790.0     18099.0     117889

 

Almost 1 in 3 applications getting rejected. MAGA 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...