How do the JSON output and object description table of Global Database company financials API work?

In this article, I will clarify the object table and JSON output of the Global Database company financials API. Specifically, I will explain the format and structure of the data within these two outputs, and how they can be used in programming applications. It is important to understand the object table and JSON output in order to effectively utilize the data provided by the Global Database company financials API.

Object table

• year: The year for which the data is being reported.

• Share-Capital: The amount of capital that is represented by shares of stock in the company.

• Pretax-Profit-Margin: The percentage of revenue that a company retains as profit before taxes.

• Bank-Overdraft-And-LTL: The amount that a company has borrowed from a bank in the form of an overdraft or a line of credit.

• Cash-To-Total-Assets: The ratio of a company's total cash to its total assets.

• Employee-Numbers-Yoy: The year-over-year change in the number of employees at a company.

• EBITDA: Earnings before interest, taxes, depreciation, and amortization.

• World-Turnover: The total amount of money that a company generates in sales during a given period, regardless of where the sales took place.

• Revenue-Per-Employee: The amount of revenue generated by each employee of a company.

• Pre-Tax-Profit: The profit a company makes before taxes are taken out.

• Capital-Employed: The total amount of money that a company has invested in its operations, including assets, inventory, and working capital.

• Human-Capital-Value-Added: A measure of the value that a company's employees add to its operations.

• Stocks-And-Work-in-Progress: The value of raw materials, finished goods, and work in progress that a company has on hand.

• Interest-Payable: The amount of interest that a company owes to its creditors.

• Intangible-Assets: Non-physical assets such as patents, trademarks, and copyrights.

• P-And-L-Account-Reserve: A reserve created from the profits of a company that can be used to offset future losses or to distribute to shareholders.

• Cost-of-Sales: The total cost of producing a company's goods or services.

• Currency: The currency in which the financial data is reported.

• Turnover: The total amount of money that a company generates in sales during a given period.

The information in the table is useful because it provides detailed financial data about a company. This data can be used to analyze the company's financial performance, assess its financial health, and make informed business decisions. For example, the Pretax-Profit-Margin can be used to understand how efficient a company is at generating profit, while the Cash-To-Total-Assets ratio can help to determine a company's liquidity and ability to meet its short-term financial obligations. The Employee-Numbers-Yoy can provide insight into the company's workforce and its ability to attract and retain employees. Overall, the information in the table is valuable for anyone looking to understand the financial dynamics of a company.

Json output

This JSON output provides financial data for a company in the year 2020. The data includes the company's share capital, pretax profit margin, bank overdraft and line of credit, cash to total assets ratio, year-over-year change in employee numbers, EBITDA, world turnover, revenue per employee, pre-tax profit, capital employed, human capital value added, value of stocks and work in progress, interest payable, intangible assets, profit and loss account reserve, cost of sales, currency, and turnover. The JSON also includes data on the company's total long-term liabilities, number of employees, other long-term financing, year-over-year change in total liabilities, net assets, other short-term loans, total current assets, EBITDA margin, consolidated accounts status, net debt to EBITDA ratio, dividends payable, other short-term financing, return on assets, total non-current hire purchase and lease commitments, liquidity ratio, reporting period, taxation, miscellaneous current assets, shareholder funds, auditor fees, days payable outstanding, net debt basis gearing, net cash flow before financing, audit fees, other audit costs, year-over-year change in turnover, days inventory outstanding, miscellaneous current liabilities, gross debt basis gearing, interest receivable, wages and salaries, days sales outstanding, current hire purchase commitments, cash, net margin, return on equity, depreciation of tangibles, total fixed assets, profit after tax, year-over-year change in profit after tax, debt to capital ratio, employee remuneration, year-over-year change in exports, contingent liability, gross margin, operating profit margin, net cashflow before financing, net worth, bank overdraft, sundry reserves, other reserves, and current lease commitments.

{
"2020": {
"Share-Capital": 535500,
"Pretax-Profit-Margin": 0.55,
"Bank-Overdraft-And-LTL": 1234603,
"Cash-To-Total-Assets": 22.59,
"Employee-Numbers-Yoy": -1,
"EBITDA": 305579,
"World-Turnover": 30705740,
"Revenue-Per-Employee": 310158.9898989899,
"Pre-Tax-Profit": 168377,
"Capital-Employed": 4533491,
"Human-Capital-Value-Added": 40796.79797979798,
"Stocks-And-Work-in-Progress": 2321893,
"Interest-Payable": 18160,
"Intangible-Assets": 0,
"P-And-L-Account-Reserve": 1739798,
"Cost-of-Sales": 25720263,
"Currency": "GBP",
"Turnover": 30705740,
"Total-Long-Term-Liabilities": 1184603,
"Employee-Numbers": 99,
"Other-Long-Term-Financing": 0,
"Total-Liabilities-Yoy": 47.55891242551835,
"Net-Assets": 3348888,
"Other-Short-Term-Loans": 0,
"Total-Current-Assets": 7329410,
"EBITDA-Margin": 1.0,
"Consolidated-Accounts": "N",
"Net-Debt-To-EBITDA-Ratio": -3.5359628770301623,
"Dividends-Payable": 250430,
"Other-Short-Term-Financing": 0,
"Return-On-Assets": 1.99,
"Total-Non-Current-HP-And-Lease-Commitments": 0,
"Liquidity-Ratio": 0.8434609219101853,
"Reporting-period": 13,
"Taxation": -50772,
"Miscellaneous-Current-Assets": 0,
"Shareholder-Funds": 3348888,
"Auditor-Fees": 43350,
"Days-Payable-Outstanding": 25.678956218293727,
"Gearing-Net-Debt-Basis": -32.26,
"Net-Cash-Flow-before-Financing": 0,
"Audit-Fees": 25000,
"Other-Audit-Costs": 18350,
"Turnover-Yoy": 14.205527131629847,
"Days-Inventory-Outstanding": 26.96832823987842,
"Miscellaneous-Current-Liabilities": 2041890,
"Gearing-Gross-Debt-Basis": 38.36,
"Interest-Receivable": 0,
"Wages-And-Salaries": 3852346,
"Days-Sales-Outstanding": 21.509643066736057,
"Current-Hire-Purchase-Commitments": 0,
"Cash": 2365119,
"Net-Margin": 0.38,
"Return-On-Equity": 3.51,
"Depreciation-of-Tangibles": 119042,
"Total-Fixed-Assets": 3140950,
"Profit-after-Tax": 117605,
"Profit-after-Tax-Yoy": -52.05490621343628,
"Debt-To-Capital": 68.02,
"Employee-Remuneration": 3416507,
"Exports-Yoy": 43.78552368091236,
"Contingent-Liability": 0,
"Gross-Margin": 16.24,
"Operating-Profit-Margin": 0.61,
"Net-Cashflow-before-Financing": 0,
"Net-Worth": 3348888,
"Bank-Overdraft": 50000,
"Sundry-Reserves": 170463,
"Directors-Remuneration": 590808,
"Cash-To-Turnover": 5.449435512708698,
"Revaluation-Reserve": 903127,
"EBITDA-Yoy": -6.058938540616316,
"Current-Ratio": 1.234558148411225,
"Amortisation-of-Intangibles": 0,
"Reported-Date": "2020-05-31",
"Return-On-Capital-Employed": 4.56,
"Tangible-Assets": 3140950,
"Interest-Coverage-Ratio": 10.271861233480177,
"Equity-Paid-Up": 535500,
"Inventory-Turnover-Ratio": 13.22444229772862,
"Cash-Conversion-Cycle": 22.79901508832075,
"Total-Liabilities": 7121472,
"Gearing-Liability-Basis": 212.65,
"Cash-To-Current-Liabilities-Ratio": 0.3983781686946436,
"Retained-Profit": -132825,
"Operating-Profit": 186537,
"Total-Long-Term-Loans": 950000,
"Trade-Debtors": 1594061,
"Bank-Loan": 50000,
"Total-Assets": 10470360,
"Trade-Creditors": 3844979,
"Total-Current-Liabilities": 5936869,
"Investment-And-Other": 0,
"Gross-Profit": 4985477,
"Working-Capital": 1392541
}
}

In summary

In conclusion, we have discussed the object table and JSON output of the Global Database company financials API. The object table lists various financial data points, while the JSON output provides the values for those data points for a specific year. This financial data can be used to analyze a company's performance, assess its financial health, and make informed business decisions. Understanding the object table and JSON output is essential for effectively utilizing the data provided by the Global Database company financials API.

Footnote

The Global Database company financials API is a tool that provides access to financial data for companies around the world. If you are interested in using this API, you can request access through the third party data marketplace of Worldindata. Worldindata is a platform that connects businesses with data providers, enabling them to purchase and use data sets in their operations. By requesting access to the Global Database company financials API through Worldindata, you can easily and securely access the financial data you need for your business.