Sample: Transactions DB - Specter API

One Transactions DB record, split by category so each block stays readable. A delivered record is a single flat object containing every field below.

Values are illustrative: one record assembled field by field to show each shape, with long arrays trimmed. It is not a row of a delivery.

Funding Rounds

Funding Rounds

{
  "funding_round_id": "fnr_1a2b3c4d5e6f",
  "name": "Series A",
  "company_name": "Acme Inc.",
  "company_id": "66d926166261234567890123",
  "investment_type": "Series A",
  "announced_on": "2024-03-01",
  "raised_amount_usd": 20000000,
  "pre_money_valuation_usd": 80000000,
  "post_money_valuation_usd": 100000000,
  "investors": [
    {
      "investor_id": "inv_abc123",
      "investor_name": "Accel",
      "is_lead_investor": true
    }
  ]
}

Acquisitions

Acquisitions

{
  "acquisition_id": "acq_5f3a2b1c4d5e6f7a8b9c0d1e",
  "acquirer_company_id": "1a2b3c4d5e6f1a2b3c4d5e6f",
  "acquirer_name": "Big Co",
  "acquirer_domain": "big.example",
  "acquiree_company_id": "9f8e7d6c5b4a9f8e7d6c5b4a",
  "acquiree_name": "Small Co",
  "acquiree_domain": "small.example",
  "acquisition_type": "acquisition",
  "price_usd": 10000000,
  "acquisition_date": "2024-02-15"
}

IPOs

IPOs

{
  "ipo_id": "ipo_5f3a2b1c4d5e6f7a8b9c0d1e",
  "company_id": "1a2b3c4d5e6f1a2b3c4d5e6f",
  "company_name": "ListedCo",
  "company_domain": "listed.example",
  "stock_exchange_symbol": "nasdaq",
  "stock_symbol": "FTW",
  "went_public_on": "2024-04-18",
  "share_price_usd": 42.5,
  "valuation_price_usd": 5000000000,
  "money_raised_usd": 750000000
}

Company DB Attributes

Company DB Attributes

{
  "company_id": "5e3b98e8137e998b5aec998c",
  "company_name": "Blu Smart",
  "company_name_alias": [
    "Rabot Energy"
  ],
  "website_domain": "blu-smart.com",
  "website_url": "https://blu-smart.com",
  "website_other_domains": "blu-smart.io; getblu-smart.co.uk",
  "founded_year": 2019,
  "hq_location": "Ahmedabad, Gujarat, India, Asia",
  "hq_regions": "Amsterdam Metropolitan Area, EMEA, European Union, Benelux",
  "linkedin_url": "https://www.linkedin.com/company/blu-smart-mobility",
  "twitter_url": "https://www.twitter.com/blusmartindia/",
  "instagram_url": "https://www.instagram.com/blusmartindia/",
  "facebook_url": "https://www.facebook.com/blusmartindia/"
}