Data Dictionary

11min

Overview 
Contains explanations and examples of all financial data fields available in the Professional Network Companies dataset.
This is not a comprehensive dictionary of Professional Network Companies. It only includes funding-related and financial data points.
All company information mentioned in this context is fictional and intended solely for illustrative purposes.
﻿Full company data sample﻿
﻿Full company data dictionary ﻿
Updated tables
﻿Financial website info ﻿
﻿Investors﻿
﻿Funding rounds﻿
﻿Stock info ﻿
﻿
Funding and financial information
Financial website info
Data point
Description
Data type
Example values
id
Identification key for the record
number (integer)
62195
company_id
Company record ID assigned in the database
number (integer)
30707
created
The time and date when we first scraped the record
string
2019-12-07 22:07:18
last_updated
The time and date when we last scraped the record
string
2020-09-06 04:51:48
deleted
One of two values - 1 or 0
1 - the last time we scraped the company page, the Page not found was returned
0 - we successfully scraped the company profile
boolean
deleted: 0
Data point
Description
Data type
company_financial_website_info_collection
Company  profile on the financial website
Array of objects
financial_website_url
Profile URL on the financial website
String
Financial website info table data sample:
Financial website info
 "company_financial_website_url_info_collection": [
        {
            "id": 258123,
            "company_id": 111371,
            "financial_website_url": "https://www.financial-website.com/organization/luxury-store-brand",
            "created": "2023-02-06 14:06:55",
            "last_updated": "2023-09-09 18:08:29",
            "deleted": 0
        }
    ],
 "company_financial_website_url_info_collection": [
        {
            "id": 258123,
            "company_id": 111371,
            "financial_website_url": "https://www.financial-website.com/organization/luxury-store-brand",
            "created": "2023-02-06 14:06:55",
            "last_updated": "2023-09-09 18:08:29",
            "deleted": 0
        }
    ],
﻿
Investors
Data point
Description
Data type
Example values
id
Identification key for the record
number (integer)
62195
company_id
Company record ID assigned in the database
number (integer)
30707
created
The time and date when we first scraped the record
string
2019-12-07 22:07:18
last_updated
The time and date when we last scraped the record
string
2020-09-06 04:51:48
deleted
One of two values - 1 or 0
1 - the last time we scraped the company page, the Page not found was returned
0 - we successfully scraped the company profile
boolean
deleted: 0
Data point
Description
Data type
company_featured_investors_collection
Consists of
record metadata and company_investors_list objects
Array of objects
investor_id
Identification key relating to the company_investors_list table
Integer
round_id
Identification key relating to the company_funding_rounds table
Integer
company_investors_list
List of company investors
Object
name
Investor's name
String
hash
Investor's name processed by the MD5 algorithm
String
financial_website_url
Investor's profile URL on the financial website
String
Featured investors table data sample:
Featured investors table
 "company_featured_investors_collection": [
        {
            "id": 812666,
            "company_id": 111371,
            "investor_id": 5311,
            "round_id": 1822807,
            "created": "2021-11-29 16:02:04",
            "last_updated": "2021-12-28 09:06:11",
            "deleted": 1,
            "company_investors_list": {
                "id": 5311,
                "name": "The Investor Company",
                "hash": "7b1fcd743ad2e20a8f72819749131678",
                "financial_website_url": "https://www.financial-website.com/organization/the-investor-company",
                "created": "2020-09-10 00:02:42",
                "last_updated": "2022-02-07 10:32:06"
            }
        }
    ],
 "company_featured_investors_collection": [
        {
            "id": 812666,
            "company_id": 111371,
            "investor_id": 5311,
            "round_id": 1822807,
            "created": "2021-11-29 16:02:04",
            "last_updated": "2021-12-28 09:06:11",
            "deleted": 1,
            "company_investors_list": {
                "id": 5311,
                "name": "The Investor Company",
                "hash": "7b1fcd743ad2e20a8f72819749131678",
                "financial_website_url": "https://www.financial-website.com/organization/the-investor-company",
                "created": "2020-09-10 00:02:42",
                "last_updated": "2022-02-07 10:32:06"
            }
        }
    ],
﻿
Funding rounds
Data point
Description
Data type
Example values
id
Identification key for the record
number (integer)
62195
company_id
Company record ID assigned in the database
number (integer)
30707
created
The time and date when we first scraped the record
string
2019-12-07 22:07:18
last_updated
The time and date when we last scraped the record
string
2020-09-06 04:51:48
deleted
One of two values - 1 or 0
1 - the last time we scraped the company page, the Page not found was returned
0 - we successfully scraped the company profile
boolean
deleted: 0
Data point
Description
Data type
company_funding_rounds_collection
Last funding round details
Array of objects
last_round_investors_count
Number of investors who have participated in the funding round
Integer
total_rounds_count
Total number of completed funding rounds
Integer
last_round_type
Last funding round type
String
last_round_date
Last funding round date
String
last_round_money_raised
Amount of money raised in the last funding round
String
financial_website_url
Funding round record URL on financial website
String
Funding rounds table data sample:
Funding rounds table
"company_funding_rounds_collection": [
        {
            "id": 2,
            "last_round_investors_count": 0,
            "total_rounds_count": 4,
            "last_round_type": "Seed",
            "last_round_date": "2016-06-01 00:00:00",
            "last_round_money_raised": "US$ 224.2K",
            "financial_website_url": "https://www.financial-website.com/funding_round/software-company-seed--92e35c7f",
            "created": "2020-09-07 13:01:57",
            "last_updated": "2020-09-26 16:29:54",
            "deleted": 1
        }
    ],
"company_funding_rounds_collection": [
        {
            "id": 2,
            "last_round_investors_count": 0,
            "total_rounds_count": 4,
            "last_round_type": "Seed",
            "last_round_date": "2016-06-01 00:00:00",
            "last_round_money_raised": "US$ 224.2K",
            "financial_website_url": "https://www.financial-website.com/funding_round/software-company-seed--92e35c7f",
            "created": "2020-09-07 13:01:57",
            "last_updated": "2020-09-26 16:29:54",
            "deleted": 1
        }
    ],
﻿
Stock info 
Data point
Description
Data type
Example values
id
Identification key for the record
number (integer)
62195
company_id
Company record ID assigned in the database
number (integer)
30707
created
The time and date when we first scraped the record
string
2019-12-07 22:07:18
last_updated
The time and date when we last scraped the record
string
2020-09-06 04:51:48
deleted
One of two values - 1 or 0
1 - the last time we scraped the company page, the Page not found was returned
0 - we successfully scraped the company profile
boolean
deleted: 0
Data point
Filter name
Data type
company_stock_info_collection
Stock details
Array of objects
ticker
Stock ticker 
String
exchange
Stock exchange 
String
Stock info table data sample:
Stock info table
"company_stock_info_collection": [
        {
            "id": 2789,
            "company_id": 111371,
            "ticker": "LSB",
            "exchange": "OTCM",
            "created": "2020-05-07 14:38:14",
            "last_updated": "2020-07-19 09:39:38",
            "deleted": 1
        }
    ],
"company_stock_info_collection": [
        {
            "id": 2789,
            "company_id": 111371,
            "ticker": "LSB",
            "exchange": "OTCM",
            "created": "2020-05-07 14:38:14",
            "last_updated": "2020-07-19 09:39:38",
            "deleted": 1
        }
    ],
﻿
﻿

Data point	Description	Data type	Example values
id	Identification key for the record	number (integer)	62195
company_id	Company record ID assigned in the database	number (integer)	30707
created	The time and date when we first scraped the record	string	2019-12-07 22:07:18
last_updated	The time and date when we last scraped the record	string	2020-09-06 04:51:48
deleted	One of two values - 1 or 0 1 - the last time we scraped the company page, the Page not found was returned 0 - we successfully scraped the company profile	boolean	deleted: 0

Data point	Description	Data type
company_financial_website_info_collection	Company profile on the financial website	Array of objects
financial_website_url	Profile URL on the financial website	String

Data point	Description	Data type	Example values
id	Identification key for the record	number (integer)	62195
company_id	Company record ID assigned in the database	number (integer)	30707
created	The time and date when we first scraped the record	string	2019-12-07 22:07:18
last_updated	The time and date when we last scraped the record	string	2020-09-06 04:51:48
deleted	One of two values - 1 or 0 1 - the last time we scraped the company page, the Page not found was returned 0 - we successfully scraped the company profile	boolean	deleted: 0

Data point	Description	Data type
company_featured_investors_collection	Consists of record metadata and company_investors_list objects	Array of objects
investor_id	Identification key relating to the company_investors_list table	Integer
round_id	Identification key relating to the company_funding_rounds table	Integer
company_investors_list	List of company investors	Object
name	Investor's name	String
hash	Investor's name processed by the MD5 algorithm	String
financial_website_url	Investor's profile URL on the financial website	String

Data point	Description	Data type	Example values
id	Identification key for the record	number (integer)	62195
company_id	Company record ID assigned in the database	number (integer)	30707
created	The time and date when we first scraped the record	string	2019-12-07 22:07:18
last_updated	The time and date when we last scraped the record	string	2020-09-06 04:51:48
deleted	One of two values - 1 or 0 1 - the last time we scraped the company page, the Page not found was returned 0 - we successfully scraped the company profile	boolean	deleted: 0

Data point	Description	Data type
company_funding_rounds_collection	Last funding round details	Array of objects
last_round_investors_count	Number of investors who have participated in the funding round	Integer
total_rounds_count	Total number of completed funding rounds	Integer
last_round_type	Last funding round type	String
last_round_date	Last funding round date	String
last_round_money_raised	Amount of money raised in the last funding round	String
financial_website_url	Funding round record URL on financial website	String

Data point	Description	Data type	Example values
id	Identification key for the record	number (integer)	62195
company_id	Company record ID assigned in the database	number (integer)	30707
created	The time and date when we first scraped the record	string	2019-12-07 22:07:18
last_updated	The time and date when we last scraped the record	string	2020-09-06 04:51:48
deleted	One of two values - 1 or 0 1 - the last time we scraped the company page, the Page not found was returned 0 - we successfully scraped the company profile	boolean	deleted: 0

Data point	Filter name	Data type
company_stock_info_collection	Stock details	Array of objects
ticker	Stock ticker	String
exchange	Stock exchange	String

Updated 09 Jul 2024

Did this page help you?

Professional Network: Funding

Data Sample

Data Dictionary

Overview

Full company data sample

Full company data dictionary

Data index

Funding and financial information

Financial website info

Repeat fields

Investors

Repeat fields

Funding rounds

Repeat fields

Stock info

Repeat fields

Data Dictionary

Overview

﻿Full company data sample﻿

﻿Full company data dictionary ﻿

Data index

Funding and financial information

Financial website info

Repeat fields

Investors

Repeat fields

Funding rounds

Repeat fields

Stock info

Repeat fields

Full company data sample

Full company data dictionary