Entity graph export

Vector search alone fails on multi-hop reasoning — corporate ownership chains, compliance lineage, cascading civic approvals, vessel-to-company-to-sanction chains. The entity graph export gives you a compact, queryable edge list you can import into your own graph layer.

The entity graph export is available on the Enterprise tier only. It ships as codex_entity_graph.parquet alongside per-dataset slices and a stats sidecar with every Enterprise catalog purchase.

What you get

A single Parquet edge-list file (Snappy-compressed) with per-dataset slices. This is not a graph database — you import it into your own graph engine (Neo4j, Kuzu, TigerGraph, DuckDB, NetworkX, or similar). Expected size at launch: approximately 8–12 million edges across all dataset families.

Edge schema

Each edge in the graph has the following fields:

Field	Type	Description
`from_id`	string	APRS URN or raw ID (e.g. H3 index, MMSI)
`from_type`	string	Node type of the source (see node types)
`edge_type`	string	Relationship type (see edge types)
`to_id`	string	APRS URN or raw ID
`to_type`	string	Node type of the target
`confidence`	float	Pipeline confidence in the edge, 0 to 1
`source_dataset`	string	Which Codex dataset emitted it
`source_record_id`	string	Record that generated the edge (for provenance)
`valid_from`	date	When the relationship became true
`valid_to`	date	When it stopped being true (null = currently valid)
`extracted_at`	timestamp	When the pipeline extracted the edge
`extractor`	string	Name and version of the extractor
`evidence_anchor`	JSON	`{doc_id, page, span}` where applicable
`attrs`	JSON	Edge-type-specific metadata (e.g. vote tally, ownership percentage)

Node types

Every node is addressable by a stable ID. Most use APRS URNs.

Node type	ID format	Source
`entity:person`	`urn:aprs:entity:person:{id}`	Civic records, OSHA, entity resolution
`entity:organization`	`urn:aprs:entity:company:{id}`	Government records, permits
`entity:agency`	`urn:aprs:entity:agency:{id}`	Issuing authorities
`entity:vessel`	`urn:aprs:record:maritime:vessel:{imo}`	AIS and Equasis
`entity:trust`	`urn:aprs:entity:trust:{id}`	Beneficial ownership resolution
`record:civic`	`urn:aprs:record:civic:us:{source}:{id}`	Civic Intelligence
`record:permit`	`urn:aprs:record:permit:...`	Permit Signals
`record:event`	`urn:axiom:event:{uuid}`	Events Timeline
`record:osha_case`	`urn:aprs:record:osha:case:{id}`	OSHA Safety
`record:poi`	`urn:aprs:record:poi:{source}:{id}`	POI Intelligence
`record:parcel`	`{jurisdiction_slug}:{parcel-number}`	Permits, assessor feeds
`h3_cell`	Raw H3 res-8 string	Derived across datasets
`port`	`urn:axiom:port:{unlocode}`	AIS Maritime
`jurisdiction`	`jurisdiction_slug`	Civic, Permits

Edge types

Civic

Edge type	Direction	Attributes
`SUPPORTS`	entity:person → record:civic	`mention_count`, `excerpt_span`
`OPPOSES`	entity:person → record:civic	`mention_count`, `excerpt_span`
`ABSTAINS_ON`	entity:person → record:civic	`mention_count`, `excerpt_span`
`MENTIONS`	record:civic → entity	`sentiment`, `role`, `mention_count`
`REPRESENTS`	entity:person → entity:organization	`capacity` (attorney, lobbyist, staff)
`HAS_CONFLICT_ON`	entity:person → record:civic	`source`
`AMENDS`	record:civic → record:civic	`relationship_type`

Events

Edge type	Direction	Attributes
`FOLLOWS`	record:event → record:event	`lag_days`
`TRIGGERED`	record:event → record:event	Reverse of `FOLLOWS` for cascade detection
`AFFECTS`	record:event → entity	When event has an `entity_id`
`OCCURS_AT`	record:event → h3_cell	Spatial index

Maritime

Edge type	Direction	Attributes
`CALLED_AT`	entity:vessel → port	`eta`, `ata`, `etd`, `atd`, `berth_id`
`OWNS`	entity:organization → entity:vessel	`ownership_pct`, `effective_from`, `source`
`MANAGES`	entity:organization → entity:vessel	`source`
`FLAGS`	entity:vessel → jurisdiction	`flag_state_iso3`
`SANCTIONED_BY`	entity:organization → jurisdiction	`sanctions_list`, `listed_on`

Permits

Edge type	Direction	Attributes
`LOCATED_IN`	record:permit → h3_cell	Direct H3 mapping
`LOCATED_ON`	record:permit → record:parcel	When parcel is known
`APPLIED_BY`	record:permit → entity	Applicant
`ISSUED_BY`	record:permit → entity:agency	Authority
`CONTINGENT_ON`	record:permit → record:permit or record:civic	Scope dependency

Urban Signal Grid

Edge type	Direction	Attributes
`HAS_SCORE`	h3_cell → score node	`composite_score`, `scored_at`
`CONTAINS`	h3_cell → record:poi or record:permit	Spatial join
`NEIGHBORS`	h3_cell → h3_cell	`k: 1` (direct neighbor only)

OSHA

Edge type	Direction	Attributes
`ENFORCED_AGAINST`	record:osha_case → entity:organization	`penalty_usd`, `citation_count`
`PARENT_OF`	entity:organization → entity:organization	Corporate parent links
`AT_FACILITY`	record:osha_case → record:poi	When FRS match exists

Example queries

You can query the graph directly with DuckDB and Parquet — no external graph database required.

Vessel → owner → sanctions → sister vessels

WITH owners AS (
  SELECT from_id AS owner_id
  FROM codex.entity_graph
  WHERE edge_type = 'OWNS' AND to_id = :vessel_urn
),
sanctioned AS (
  SELECT from_id AS owner_id
  FROM codex.entity_graph
  WHERE edge_type = 'SANCTIONED_BY'
    AND from_id IN (SELECT owner_id FROM owners)
),
other_vessels AS (
  SELECT to_id AS sister_vessel
  FROM codex.entity_graph
  WHERE edge_type = 'OWNS'
    AND from_id IN (SELECT owner_id FROM sanctioned)
    AND to_id != :vessel_urn
)
SELECT * FROM other_vessels;

Recursive cascade — downstream records from a dark event (up to 3 hops)

WITH RECURSIVE reachable(id, hop) AS (
  SELECT :seed_event_uuid, 0
  UNION ALL
  SELECT e.to_id, r.hop + 1
  FROM codex.entity_graph e
  JOIN reachable r ON e.from_id = r.id
  WHERE e.edge_type IN ('FOLLOWS', 'TRIGGERED', 'AFFECTS')
    AND r.hop < 3
)
SELECT r.id, r.hop, e.to_type
FROM reachable r
JOIN codex.entity_graph e ON e.from_id = r.id;

Provenance

Every emitted edge carries evidence_anchor, extractor, and confidence, following the same contract as the claim/fact layer. You can join edges on source_record_id back to the record’s claims[] array for full provenance.

Tier availability

Tier	Graph export included
Research	No
Commercial	No
Enterprise	Yes — full graph, per-dataset slices, and stats sidecar

Get started

Frameworks

Reference

What you get

Edge schema

Node types

Edge types

Civic

Events

Maritime

Permits

Urban Signal Grid

OSHA

Example queries

Vessel → owner → sanctions → sister vessels

Recursive cascade — downstream records from a dark event (up to 3 hops)

Provenance

Tier availability

​What you get

​Edge schema

​Node types

​Edge types

​Civic

​Events

​Maritime

​Permits

​Urban Signal Grid

​OSHA

​Example queries

​Vessel → owner → sanctions → sister vessels

​Recursive cascade — downstream records from a dark event (up to 3 hops)

​Provenance

​Tier availability

What you get

Edge schema

Node types

Edge types

Civic

Events

Maritime

Permits

Urban Signal Grid

OSHA

Example queries

Vessel → owner → sanctions → sister vessels

Recursive cascade — downstream records from a dark event (up to 3 hops)

Provenance

Tier availability