Analysis of Company Master Data from MCA till March 2021

Ashish Sinha

Open Source data from Govt. of India

https://data.gov.in provides open source data from various Ministries of Government of India

  • Company Master Data has been uploaded annually by Ministry of Corporate Affairs since 2015. However, the last data uploaded is till March 2021.

  • Data contains various information like CIN, Company Name, Company Status, Authorized Capital in INR, Paid-up Capital in INR, Date of Registration, Registered State, Registrar of Companies, Principal Business Activity, Registered Office Address etc. https://data.gov.in/catalog/company-master-data

Data details

The data has 21,57,105 rows and 19 columns.

CORPORATE_IDENTIFICATION_NUMBER Company_Name Company_status Company_class Company_Category Company_sub_category DATE_OF_REGISTRATION REGISTERED_STATE AUTHORIZED_CAP PAIDUP_CAPITAL Industrial_Class PRINCIPAL_BUSINESS_ACTIVITY_AS_PER_CIN Registered_Office_Address REGISTRAR_OF_COMPANIES EMAIL_ADDR Latest_Year_AR Latest_Year_BS
U00339AN1986PLC007658 HIGHTECH PISTON (KARNATAKA) LIMITED Strike Off Public Company limited by Shares Non-govt company 1986-06-18 Andaman and Nicobar Islands 500000 0 339 Unclassified 3RD FLOOR,TOWER BLOCK,UNITYBUILDINGS,J.C.ROAD, ,BANGALORE-2. BANGALORE , Unclassified AN 000000 RoC-ANDAMAN NA NA NA
U01100AN2016PTC005301 AMMAN POULTRY AND FEEDS PRIVATE LIMITED Active Private Company limited by Shares Non-govt company 2016-05-30 Andaman and Nicobar Islands 3000000 2000000 1100 Agriculture, hunting and related service activities BEODNABAD MAKKA PAHAR PORT BLAIR , Andaman Islands Unclassified AN 744105 RoC-ANDAMAN murugang1978@gmail.com 42825 42825
U01110AN2016PTC005317 ISLAND ORGANIC PRODUCER COMPANY LIMITED Active Private Company limited by Shares Non-govt company 2016-10-18 Andaman and Nicobar Islands 100000 100000 1110 Agriculture, hunting and related service activities NIKETAN COLONY SCHOOL LINE PORT BLAIR , Andaman Islands Unclassified AN 744103 RoC-ANDAMAN ANDAMANCPC@GMAIL.COM 43190 43190
U01110AN2017PTC005386 MAYABUNDER AGRICULTURAL PRODUCER COMPANYLIMITED Active Private Company limited by Shares Non-govt company 2017-12-21 Andaman and Nicobar Islands 1000000 100000 1110 Agriculture, hunting and related service activities Harinagar, Mayabunder Tehsil N & M Andaman MAYABUNDER , Andaman Islands Unclassified AN 744202 RoC-ANDAMAN JAYANTANAGBOD@GMAIL.COM NA NA

Basic Data Analysis

Company_status Count
Active 1343186
Strike Off 699399
Under Process of Striking off 39008
Amalgamated 27038
Converted to LLP 15052
Dissolved 9922
Not Available for eFiling 8309
Under liquidation 6888
Converted to LLP and dissolved 4866
Dormant under section 455 2265
Liquidated 1119

Companies Registration post 2000

Active and Strike off Companies post 2000

Spatial Distribution of companies post 2000

Companies grouped by same address

Registered_Office_Address Count RoC
306-308, Square One, C-2, District Centre, Saket New Delhi , South Delhi Unclassified DL 110017 214 RoC-Delhi
Holding No- AS/275, BLOCK-A, Rajarhat Main Road 211 Bus Road, Jogar Danga Kolkata , Kolkata Unclassified WB 700136 195 RoC-Kolkata
9,Weston Street Kolkata , Kolkata Unclassified WB 700013 168 RoC-Kolkata
Sahara India Center, 2, Kapoorthala Complex Aliganj, Lucknow-226024 Lucknow , Lucknow Unclassified UP 226024 117 RoC-Kanpur
LGF-10, VASANT SQUARE MALL, PLOT-A, SECTOR-B, POCKET-V, COMMUNITY CENTRE, VASANT KUNJ NEW DELHI , South West Delhi Unclassified DL 110070 114 RoC-Delhi
BASEMENT, 6, COMMUNITY CENTRE SAKET NEW DELHI , South Delhi Unclassified DL 110017 112 RoC-Delhi
Fortune Monarch Mall, 3rd Floor, # 306 Plot No.707-709, Jubilee Hills, Road # 36 Hyderabad , Hyderabad Unclassified TG 500033 106 RoC-Hyderabad
7 LOCAL SHOPPING CENTRE KALKAJI NEW DELHI , New Delhi Unclassified DL 110019 103 RoC-Delhi
B-II/32, Mohan Co-operative Industrial Estate, Badarpur, New Delhi New Delhi , South Delhi Unclassified DL 110044 101 RoC-Delhi
PARSVNATH TOWER NEAR SHAHDARA METRO STATION, SHAHDARA DELHI , East Delhi Unclassified DL 110032 94 RoC-Delhi

Same address, written differently

Registered_Office_Address Count
1E, JHANDEWALAN EXTENSION NAAZ CINEMA COMPLEX NEW DELHI , Central Delhi Unclassified DL 110055 52
1E, JHANDEWALAN EXTENSION, NAAZ CINEMA COMLEX NEW DELHI , Central Delhi Unclassified DL 110055 31
1E, Jhandewalan Extension, Naaz Cinema Complex New Delhi , Central Delhi Unclassified DL 110055 30
1E, JHANDEWALAN EXTENSION, NAAZ CINEMA COMPLEX NEW DELHI , Central Delhi Unclassified DL 110055 29
1-E, JHANDEWALAN EXTENSION, NAAZ CINEMA COMPLEX, NEW DELHI , Central Delhi Unclassified DL 110055 27
1E, JHANDEWALAN EXT. NAAZ CINEMA COMPLEX NEW DELHI , Central Delhi Unclassified DL 110055 26
1E, JHANDEWALAN EXTENSION, NAAZ CINEMA COMPLEX, NEW DLHI , Central Delhi Unclassified DL 110055 20
I-E JHANDEWALAN EXTENSION NAAZ CINEMA COMPLEX NEW DELHI , Central Delhi Unclassified DL 110055 20
1-E, Jhandewalan Extension Naaz Cinema Complex New Delhi , Central Delhi Unclassified DL 110055 20
1E, JHANDEWALAN EXTENSION NAAZ CINEMA COMPLEX New Delhi , Central Delhi Unclassified DL 110055 11
1-E, JHANDEWALAN EXTENSION NAAZ CINEMA COMPLEX NEW DELHI , Central Delhi Unclassified DL 110055 8
1E JHANDEWALAN EXTENSION NAAZ CINEMA COMPLEX NEW DELHI , Central Delhi Unclassified DL 110055 8
1E,JHANDEWALAN EXTENSION NAAZ CINEMA COMPLEX NEW DELHI , Central Delhi Unclassified DL 110055 8
1-E, JHANDEWALAN EXTENSION, NAAZ CINEMA COMPLEX NEW DELHI , Central Delhi Unclassified DL 110055 6
1E, JHANDEWALAN EXTENSION, NAAZ CINEMA COMLEX NEW DELHI , Unclassified DL 110055 6
1-E, JHANDEWALAN EXTENSION NAAZ CINEMA COMPLEX NEW DELHI , Unclassified DL 110055 5
1E, JHANDEWALAN EXTENSION, NAAZ CINEMA COMPLEX, NEW DELHI , Central Delhi Unclassified DL 110055 5
1-E,JHANDEWALAN EXTENSION NAAZ CINEMA COMPLEX NEW DELHI , Unclassified DL 110055 4
1E, JHANDEWALAN EXTENTION NAAZ CINEMA COMPLEX NEW DELHI , Central Delhi Unclassified DL 110055 4
I-E JHANDEWALAN EXTENSION NAAZ CINEMA COMPLEX NEW DELHI , Unclassified DL 110055 4
1E, Jhandewalan Extension, Naaz Cinema Complex New Delhi , Unclassified DL 110055 4
1E, JHANDEWALAN EXTENSION NAAZ CINEMA COMPLEX NEW DELHI , Unclassified DL 110055 3
1E, JHANDEWALAN EXTENSION, NAAZ CINEMA COMPLEX, NEW DLHI , Unclassified DL 110055 3
1E, Jhandewalan Extension Naaz Cinema Complex New Delhi , Central Delhi Unclassified DL 110055 3

What’s next

  • PAN - CIN mapping for Active companies. Is one PAN mapped with more than one CIN and vice versa ?

  • Are there companies which are active in MCA database without PAN?

  • Analysis of Non-Filers with high value tansaction along with prosecution

  • Use of AI to find clusters based on address and directors

  • Comapnies that has converted to LLP and later dissolved

  • Use of interactive visualization and data exploration tools in Project Insight for better decision making

…

.reveal .slide-logo {
  display: block;
  position: fixed;
  bottom: unset !important;
  left: unset !important;
  top: 5px;
  right: 15px;
  height: 200px !important;
  width: 200x !important;
  max-width: unset !important;
  max-height: unset !important;
}