ded_commerce_registry-open

Published by
Department of Dubai Economic Development (DED)
Number of Data Files / Resources 1
Updated: 22 Apr 2024
Open Data
Centralized register that maintains the master information (such as partners and activates) for related group of companies.
Show more
Request Permission

I acknowledge that I have read and agree to the terms and conditions

Cancel
Send Request
Your request has been successfully submitted
You will receive a confirmation within 14days time period. If you are
having any query feel free to contact us.
Done
Send Feedback
Commerce_Registry.csv
Updated: 22 Apr 2024 File Size : 210.97 MB
CSV
Field Value
Data Provenance for the group of companies within Dubai or a branch of company registered outside Dubai ( other emirate or internationally) the commerce registry is managing the parent organization details such as activities and partners. the branch activities are always a subset of the commerce registry activates. partners are managed on the commerce registry level, wile the managers and director are manage on the license level.
Dataset Source DED DB
Format CSV
Created 16 Feb 2018
Last updated 22 Apr 2024
Frequency of Update on Source
Frequency of Update to SDP
Weekly
Expected Volume/Ingestion Cycle(Daily if Real-time)
4000-5000
Language Arabic~English~English~English~English~English~Arabic~English~English~English~English~English~English~English~English~Arabic~English~English~English
State active
Rights N/A
License notspecified
Show more
Name Description Primary Key Size Datatype Foreign Key Range of Values Language Classification
legal_type_desc_ar Legal type description (e.g. Sole establishment, LLC etc..) No 100 VARCHAR2 Arabic Open
commerce_register_type_desc_ar Commerce registry type No 30 VARCHAR2 English Open
commerce_register_type_desc_en Commerce registry type No 40 VARCHAR2 Not Specified,Company with Commerce Registry,Sole Establishment,Civil Company,UAE Company not in Dubai,Comapny without Commerce Registry English Open
legal_type_code Legal type code No 2 NUMBER English Open
legal_type_desc_en Legal type description (e.g. Sole establishment, LLC etc..) No 100 VARCHAR2 English Open
nationality_code Nationality code No 4 NUMBER English Open
nationality_desc_ar Nationality of the company (useful for branch of foreign companies in Dubai) No 30 VARCHAR2 Arabic Open
nationality_desc_en Nationality of the company (useful for branch of foreign companies in Dubai) No 30 VARCHAR2 English Open
issue_date Issue date of commerce registry No Date English Open
expiry_date Expiry date of commerce registry No Date English Open
cancel_date Cancel date of commerce registry No Date English Open
paid_up_capital Paid up capital No 20 NUMBER English Open
nominated_capital Nominated capital No 20 NUMBER English Open
register_serial_number Commercial register number Yes 6 NUMBER English Open
commerce_number Commerce number (issued by DED for commercial licenses) No 7 NUMBER English Open
company_name_ar Company Name (for group of companies) No 120 VARCHAR2 Arabic Open
company_name_en Company Name (for group of companies) No 120 VARCHAR2 English Open
main_license_number Main license number No 10 NUMBER English Open
commerce_register_type_code Commerce registry type code No 1 CHAR 0,1,2,3,4,5,6 English Open
Show more Show less

Dubai Pulse Data API

Access resource data via a web API with powerful query support.

Endpoints
Expand
Collapse
The Data API can be accessed via the following actions of the CKAN action API.
  • Query
    https://www.dubaipulse.gov.ae/dataset/42a06aca-0aa6-4db9-a406-71ae95c2cc88/resource/47c7d04e-8aec-46ed-baf8-059e471750d7/download/commerce_registry.csv
How to Use?
Expand
Collapse
  • End Users will receive "API Key" and "API Secret" in two separate emails on the first time Grant of a Dataset, first Purchase of a Commercial Dataset, or Purchase of an API Package. This API Key and API Secret combination should be used to generate API token and the token will need to be included in the http headers of every API call made.

    Authentication Service to generate API token: https://api.dubaipulse.gov.ae/oauth/client_credential/accesstoken?grant_type=client_credentials with body 'client_id={API Key}&client_secret={API Secret}

    Read the value of "access_token" from the response of the above service and use it in the header of every API call. The obtained API token is valid for certain duration (for example 30 minutes) after which a fresh token needs to be obtained.

    Header Name : Authorization
    Value : Bearer {access_token}

  • Query Parameters
    API calls can be made for full dataset result (subject to maximum results limit) or to a subset of results. Different filters can be applied on the results. Developers can use the attributes to apply a combination of filters with and/or conditions.
  • Limiting the Response Size
    Developers can limit the number of records returned by an API call passing the "Limit" parameter in the call. The value of the "Limit" must be less than the allowed maximum limit.
  • Limiting the Attributes
    Developers can limit the API response to specific set of attributes by passing the attribute names in the API call. The example below explains how the attributes can be specified in the API call. This feature can be used in conjunction with query parameters.
Examples
Expand
Collapse
  • Curl Command Sample:
    curl -X GET --header "Authorization: qMtn6xQapeouAlirfHXD7DWJFabV" "https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api"
  • Query Samples:
    https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api?filter=location_id=223 AND zone_id=2 https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api?filter=location_id=223 OR zone_id=2
  • Record Limit Sample:
    https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api?limit=10
  • Record Offset Sample:
    https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api?order_by=primary_key_attribute&offset=10
  • Record Order By Sample:
    https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api?order_by=location_id
  • Attribute Limiting Sample:
    https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api?filter=location_id=223 OR zone_id=2 &column=zone_id,line_name,location_id