Analysis of Company Master Data from MCA till March 2024

Open Source Data from Govt. of India

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

  • Company Master Data has been uploaded by Ministry of Corporate Affairs on this portal.

  • The data is uploaded for each state and union territory.

  • The data template is uniform containing 16 columns viz. 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.

Bird’s eye view on Data

After concatenating data for each state, the data has 28,42,475 rows having 16 columns which is the information of Company Data of India till 24.04.2024.

CIN CompanyName CompanyROCcode CompanyCategory CompanySubCategory CompanyClass AuthorizedCapital PaidupCapital CompanyRegistrationdate_date Registered_Office_Address Listingstatus CompanyStatus CompanyStateCode CompanyIndian/Foreign Company nic_code CompanyIndustrialClassification
U51909AP2017PTC106960 SREE MEENAKSHI ENTERPRENEURS PRIVATE LIMITED ROC Vijayawada Company limited by shares Non-government company Private 100000 100000 2017-11-02 D.NO:55-1-40 100 FEET ROAD,JAWAHAR AUTO NAGAR,VIJAYAWADA,Krishna,Andhra Pradesh,520007-India Unlisted Active andhra pradesh Indian 51909 Trading
U28199AP2024PTC117175 BHAIRAV ROBOTICS PRIVATE LIMITED ROC Vijayawada Company limited by shares Non-government company Private 1500000 203060 2024-12-26 13-1-27,Main Road,Kakinada,East Godavari,Andhra Pradesh,533001-India Unlisted Active andhra pradesh Indian 28199 Manufacturing (Machinery and Equipments)
U28910AP2015PTC097653 ENSEMBLE HEAVY ENGINEERING PRIVATE LIMITED ROC Vijayawada Company limited by shares Non-government company Private 1000000 100000 2015-11-03 #9/10/4 CHENNAREDDY STREET SAVITHRU PET,,TADEPALLIGUDEM,East Godavari,Andhra Pradesh,534102-India Unlisted Active andhra pradesh Indian 28910 Manufacturing (Metals and Chemicals, and products thereof)
U28910AP2015PTC097922 ZIXIN CYLINDERS PRIVATE LIMITED ROC Vijayawada Company limited by shares Non-government company Private 50000000 50000000 2015-12-14 Door No 59A-8/10-10A, Flat No F1 Maruthi Co-operative colony, Gurunanak C,olony Road,Vijayawada,Krishna,Andhra Pradesh,520010-India Unlisted Active andhra pradesh Indian 28910 Manufacturing (Metals and Chemicals, and products thereof)

Basic Analysis

S_No State Count
1 Maharashtra 554070
2 Delhi 427421
3 West bengal 248012
4 Uttar pradesh 212326
5 Tamil nadu 210121
6 Karnataka 194736
7 Telangana 171079
8 Gujarat 155049
9 Haryana 96214
10 Rajasthan 95463
11 Kerala 88638
12 Bihar 66225
13 Andhra pradesh 51456
14 Punjab 46003
15 Orissa 43429
16 Madhya pradesh 34317
17 Jharkhand 25769
18 Assam 20249
19 Chattisgarh 18582
20 Chandigarh 18094
21 Uttarakhand 17248
22 Jammu & kashmir 11932
23 Goa 11879
24 Himachal pradesh 10339
25 Pondicherry 4362
26 Manipur 1590
27 Meghalaya 1482
28 Tripura 1432
29 Arunachal pradesh 1217
30 Nagaland 1081
31 Andaman and nicobar islands 794
32 Dadra & nagar haveli 727
33 Daman and diu 521
34 Mizoram 468
35 Ladakh 102
36 Lakshadweep 46
37 Sikkim 2

Basic Analysis

S_No Company_Status Count
1 Active 1847569
2 Strike Off 867606
3 Amalgamated 37808
4 Under process of striking off 27436
5 Converted to LLP 27303
6 Dissolved (Liquidated) 12439
7 Under Liquidation 8498
8 Inactive for e-filing 7792
9 Dormant under section 455 2583
10 Under CIRP 1916
11 Dissolved under section 59(8) 634
12 Dissolved under section 54 363
13 Strike Off-AwaitingPublication 356
14 Dissolved 153
15 Not available for efiling 9
16 Inactive 6
17 Converted to LLP and Dissolved 2
18 Unclassified 1
19 Vanished 1

Time Series Analysis: Active companies pre 1900

S_No Name State Year
1 CHEVIOT AGRO INDUSTRIES PRIVATE LIMITED Delhi 1863
2 CHEVIOT AGRO INDUSTRIES PRIVATE LIMITED Delhi 1863
3 THE BOMBAY BURMAH TRADING CORPORATION LIMITED Maharashtra 1863
4 C L S LTD West bengal 1863
5 THE NEW PIECE GOODS BAZAR COMPANY LIMITED Maharashtra 1871
6 SINGELL TEA AND AGRICULTURAL INDUSTRIES PRIVATE LIMITED West bengal 1871
7 SIND PRESS COMPANY LIMITED Maharashtra 1872
8 THE MYLAPORE HINDU PERMANENT FUND NIDHI LIMITED Tamil nadu 1872
9 THE KHANDESH SPINNING AND WEAVING MILLS COMPANY LIMITED Maharashtra 1873
10 THE NEW GREAT EASTERN SPINNING AND WEAVING COMPANY LIMITED Maharashtra 1873
11 SWADESHIYA MALACHA VYAPAR KARNARI MANDALI LIMITED Maharashtra 1873
12 SWADESHIYA MALACHA VYAPAR KARNARI MANDALI LIMITED Maharashtra 1873
13 THE NEW BEERBHOOM COAL CO LTD West bengal 1873
14 THECENTRAL INDIA SPINNING, WEAVING AND MANUFACTURING COMPANY LIMITED Maharashtra 1874
15 THECENTRAL INDIA SPINNING, WEAVING AND MANUFACTURING COMPANY LIMITED Maharashtra 1874
16 THE LACKATOORAH TEA CO LTD West bengal 1874
17 CACHAR NATIVE JOINT STOCK CO LTD Assam 1876
18 AMLUCKIE INVESTMENT CO LTD West bengal 1876
19 AMLUCKIE INVESTMENT CO LTD West bengal 1876
20 TEESTA VALLEY TEA CO LTD West bengal 1876
21 KAMARHATTY CO LTD West bengal 1877
22 THACKER AND COMPANY LIMITED Maharashtra 1878
23 THACKER AND COMPANY LIMITED Maharashtra 1878
24 THE BOMBAY DYEING AND MANUFACTURING COMPANY LIMITED Maharashtra 1879
25 DARJEELING TEA & CHINCHONA ASSOCIATION LTD. West bengal 1879
26 LONGVIEW TEA CO LTD West bengal 1879
27 THE COLABA LAND AND MILL COMPANY LIMITED Maharashtra 1880
28 SRIMAN MADHWA SIDHANTAONNAHINI PERMANENT NIDHI LIMITED Tamil nadu 1881
29 BELLARY BRUCE PETTAH HINDU MUTUAL BENEFIT PERMANENT FUND LIMITED Karnataka 1882
30 BELLARY BRUCE PETTAH HINDU MUTUAL BENEFIT PERMANENT FUND LIMITED Karnataka 1882
31 CAMPERDOWN PRESSING CO LTD West bengal 1882
32 CHENGALPUT DHANASEKARA CHIT FUND PRIVATE LIMITED Tamil nadu 1883
33 CHENGALPUT DHANASEKARA CHIT FUND PRIVATE LIMITED Tamil nadu 1883
34 CALCUTTA CHAMBER OF COMMERCE West bengal 1883
35 THE DECCAN PAPER MILLS COMPANY LIMITED Maharashtra 1885
36 ARYA TEA CO LTD West bengal 1885
37 ARYA TEA CO LTD West bengal 1885
38 MANABARRIE TEA CO LIMITED West bengal 1885
39 EGMORE BENEFIT SASWATHA NIDHI LIMITED Tamil nadu 1886
40 BHARATVARSHIYA NATIONAL ASSOCIATION Uttar pradesh 1887
41 BHARATVARSHIYA NATIONAL ASSOCIATION Uttar pradesh 1887
42 THE NELLORE PERMANENT FUND NIDHI LIMITED Andhra pradesh 1888
43 D C M LIMITED Delhi 1889
44 D C M LIMITED Delhi 1889
45 THE MOTILAL HIRABHAI ESTATE AND WAREHOUSE LIMITED Gujarat 1889
46 THE MALAYALA MANORAMA CO PRIVATE LIMITED Kerala 1889
47 THE KRISHNA MILLS LTD Rajasthan 1889
48 THE MEERUT LAW CHAMBERS COMPANY LIMITED Uttar pradesh 1889
49 THE MOHES CHUNDER LAND RECLAMATION AND AGRICULTURAL IMPROVEMENT CO. LIMITED West bengal 1889
50 THE MOHES CHUNDER LAND RECLAMATION AND AGRICULTURAL IMPROVEMENT CO. LIMITED West bengal 1889
51 NEW CHUMTA TEA COMPANY LIMITED West bengal 1889
52 ADONI MUTUAL BENEFIT PERMANENT NIDHI LIMITED Andhra pradesh 1890
53 JHIRIGHAT NATIVE TEA CO LTD Assam 1890
54 GADAG MAHALAXMI ENTERPRISE PRIVATE LIMITED Karnataka 1890
55 FORT GLOSTER INDUSTRIES LIMITED West bengal 1890
56 FORT GLOSTER INDUSTRIES LIMITED West bengal 1890
57 TYROON TEA CO LTD West bengal 1890
58 TYROON TEA CO LTD West bengal 1890
59 HOWRAH MILLS CO LTD West bengal 1890
60 VADLAMUDI ESTATES PRIVATE LIMITED Andhra pradesh 1891
61 WHELER CLUB LTD. Uttar pradesh 1891
62 PAHARGOOMIAH TEA ASSOCIATION LTD West bengal 1891
63 EAST HOPETOWN ESTATE CO LIMITED Uttarakhand 1891
64 STANDARD INDUSTRIES LIMITED Maharashtra 1892
65 BHARAT LOAN COMPANY LIMITED Assam 1893
66 BRUSHWARE LTD Uttar pradesh 1893
67 TONGANI TEA COMPANY LIMITED West bengal 1893
68 KATRAS JHERRIAH COAL CO LTD West bengal 1893
69 THE BENGAL CHAMBER OF COMMERCE AND INDUSTRY West bengal 1893
70 GIELLE INVESTMENTS LTD West bengal 1894
71 JALPAIGURI CLUB COMPANY LTD West bengal 1894
72 BOMBAY INCORPORATED LAW SOCIETY Maharashtra 1895
73 ENGO TEA COMPANY PRIVATE LIMITED West bengal 1895
74 ALLIANCE UDYOG LTD. West bengal 1895
75 NAHORJAN TEA CO PVT LTD West bengal 1895
76 PURASAWALKAM DHANA VARDHANA SASWATHA NIDHI LIMITED Tamil nadu 1896
77 PURASAWALKAM DHANA VARDHANA SASWATHA NIDHI LIMITED Tamil nadu 1896
78 VISTA SOLAR ENERGY LIMITED West bengal 1896
79 VISTA SOLAR ENERGY LIMITED West bengal 1896
80 CACHAR CLUB CO LTD Assam 1897
81 HATHISING MFG CO LIMITED Gujarat 1897
82 ADITYA BIRLA REAL ESTATE LIMITED Maharashtra 1897
83 THE MILL STORES TRADING COMPANY OF INDIA PRIVATE LIMITED Maharashtra 1897
84 SRIVILLIPUTHUR SASWADHA NIDHI LIMITED Tamil nadu 1897
85 SRIVILLIPUTHUR SASWADHA NIDHI LIMITED Tamil nadu 1897
86 CHEVIOT CO LTD West bengal 1897
87 KOTHARI PHYTOCHEMICALS & INDUSTRIES LTD West bengal 1897
88 KOTHARI PHYTOCHEMICALS & INDUSTRIES LTD West bengal 1897
89 CHIDAMBARAM HINDU SASWATHA JANANKULA NIDHI LIMITED Tamil nadu 1898
90 CHIDAMBARAM HINDU SASWATHA JANANKULA NIDHI LIMITED Tamil nadu 1898
91 THE BENARES CLUB LIMITED Uttar pradesh 1898
92 MURRAY AND COMPANY PRIVATE LIMITED Uttar pradesh 1898
93 MURRAY AND COMPANY PRIVATE LIMITED Uttar pradesh 1898
94 SAMUEL FITZE & CO PVT LTD West bengal 1898
95 SAMUEL FITZE & CO PVT LTD West bengal 1898
96 VIMA MUDRAK AND PRAKASHAK LTD. Maharashtra 1899
97 USHA MALLITH WOOD PROCESSORS P LTD. Maharashtra 1899
98 DATA REPRAGRAPHIES PVT LTD Maharashtra 1899
99 USHA MALLITH WOOD PROCESSORS P LTD. Maharashtra 1899
100 KIRLOSKAR ENGINEERING PVT.LTD. Maharashtra 1899
101 THE MAHOMED BAGH CLUB LIMITED Uttar pradesh 1899
102 R. C. A. LIMITED West bengal 1899

Companies Registration post 2000

Active and Strike off Companies post 2000

Date of strike off in not available in the MCA data. The graph depicts the number of companies that are stricken off who were registered in the year appearing on x-axis

Spatial distribution of Companies post 2000

Analysis of pincode for year 2024

Reading layer `All_India_pincode_Boundary-cleaned' from data source 
  `/Users/ashishsinha/Library/CloudStorage/OneDrive-Personal/DG Systems/Company/data 2024/All_India_pincode_Boundary-19312.geojson' 
  using driver `GeoJSON'
Simple feature collection with 19312 features and 5 fields
Geometry type: MULTIPOLYGON
Dimension:     XY
Bounding box:  xmin: 68.17751 ymin: 6.710982 xmax: 97.4129 ymax: 37.08834
Geodetic CRS:  WGS 84

Companies grouped by same address

Registered_Office_Address Count RoC
NA,AT POST DEUL GALLI LOHA,NA,Maharashtra,431708-India 9251 ROC Mumbai
NA,C 114 GREATER KAILASH - I 2ND FLOOR,Delhi,Delhi,110048-India 604 ROC Delhi
430 MANGAL,PUNE,Maharashtra,411002-India 408 ROC Pune
NA,8-3-162/A/80/3 SANJAY NAGAR YOUSUF GUDA,NA,Hyderabad,Telangana,500018-India 301 ROC Hyderabad
NA,304 Daffodils Flats Near Ganga Jamuna Soc,NA,Ahmedabad,Gujarat,390007-India 255 ROC Ahmedabad
306-308, Square One, C-2, District Centre, Saket,New Delhi,South Delhi,Delhi,110017-India 239 ROC Delhi
Holding No- AS/275, BLOCK-A, Rajarhat Main Road 211 Bus Road, Jogar Danga,Kolkata,Kolkata,West Bengal,700136-India 194 ROC Kolkata
9,Weston Street,Kolkata,Kolkata,West Bengal,700013-India 159 ROC Kolkata
LGF-10, VASANT SQUARE MALL, PLOT-A, SECTOR-B, POCKET-V, COMMUNITY CENTRE, VASANT KUNJ,NEW DELHI,NEW DELHI,South West Delhi,Delhi,110070-India 158 ROC Delhi
Sahara India Center, 2, Kapoorthala Complex Aliganj, Lucknow-226024,Lucknow,Lucknow,Uttar Pradesh,226024-India 151 ROC Kanpur

Same address written differently

Registered_Office_Address Count
1E, JHANDEWALAN EXTENSION NAAZ CINEMA COMPLEX,NEW DELHI,Central Delhi,Delhi,110055-India 63
1E, Jhandewalan Extension, Naaz Cinema Complex,New Delhi,Central Delhi,Delhi,110055-India 35
1-E, JHANDEWALAN EXTENSION, NAAZ CINEMA COMPLEX,,NEW DELHI,Central Delhi,Delhi,110055-India 31
1E, JHANDEWALAN EXTENSION, NAAZ CINEMA COMLEX,NEW DELHI,Central Delhi,Delhi,110055-India 31
1E, JHANDEWALAN EXT. NAAZ CINEMA COMPLEX,NEW DELHI,Central Delhi,Delhi,110055-India 28
I-E JHANDEWALAN EXTENSION NAAZ CINEMA COMPLEX,NEW DELHI,Central Delhi,Delhi,110055-India 25
1E, JHANDEWALAN EXTENSION, NAAZ CINEMA COMPLEX,NEW DELHI,Central Delhi,Delhi,110055-India 23
1E, JHANDEWALAN EXTENSION, NAAZ CINEMA COMPLEX,,NEW DLHI,Central Delhi,Delhi,110055-India 16
1E, JHANDEWALAN EXTENSION NAAZ CINEMA COMPLEX,New Delhi,Central Delhi,Delhi,110055-India 15
1-E, JHANDEWALAN EXTENSION NAAZ CINEMA COMPLEX,NEW DELHI,Central Delhi,Delhi,110055-India 12
1E JHANDEWALAN EXTENSION NAAZ CINEMA COMPLEX,NEW DELHI,Central Delhi,Delhi,110055-India 10
1E,JHANDEWALAN EXTENSION NAAZ CINEMA COMPLEX,NEW DELHI,Central Delhi,Delhi,110055-India 9
1-E, JHANDEWALAN EXTENSION, NAAZ CINEMA COMPLEX,NEW DELHI,Central Delhi,Delhi,110055-India 5
1-E,JHANDEWALAN EXTENSION NAAZ CINEMA COMPLEX,NEW DELHI,Delhi,110055-India 5
1E, Jhandewalan Extension Naaz Cinema Complex,New Delhi,Delhi,110055-India 5
1-E JHANDEWALAN EXTENSION NAAZ CINEMA COMPLEX,NEW DELHI,Central Delhi,Delhi,110055-India 4
1-E, JHANDEWALAN EXTENSION, NAAZ CINEMA COMPLEX,NEW DELHI,Delhi,110055-India 4
1E, JHANDEWALAN EXTENSION, NAAZ CINEMA COMPLEX,,NEW DELHI,Central Delhi,Delhi,110055-India 4
1E, JHANDEWALAN EXTENTION NAAZ CINEMA COMPLEX,NEW DELHI,Central Delhi,Delhi,110055-India 3
4-C, Fourth Floor, Naaz Cinema, Lamington Road, Grant Road West,Mumbai,Mumbai City,Maharashtra,400004-India 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 transaction along with prosecution

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

  • Companies that has converted to LLP and later dissolved

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