Skip to content

Worker-firm relationships

This dataset collapses consecutive positions at the same firm into an employment relationship.

flowchart LR
    events[(Employment events)] --> group[Group by worker and<br/>relationship number]
    group --> relationships[(Worker-firm relationships)]

    classDef source fill:#e8eef7,stroke:#52739e
    classDef process fill:#fff0cc,stroke:#a66b00
    classDef data fill:#e2f2e7,stroke:#3b7a4b
    class events source
    class group process
    class relationships data

Grain: one consecutive worker-firm spell
Key: user_id, relationship_number
Location: /data/<coverage>/processed/employment_relationships_processed/
Builder: shared/data/build_processed.py --target relationships

For each relationship, the builder records:

  • company_id;
  • first position start as relationship_start_date;
  • relationship end date, left missing when any constituent position is open;
  • num_positions within the relationship;
  • next_company_id, taken from the worker's following relationship when one is observed.

The dataset distinguishes a relationship from a position: a worker can hold several roles at one firm without creating a new relationship. It feeds the model relationship-period builder and the observed firm-year employment counts.