Firms

The firm table combines Revelio company attributes with firms observed in the employment events.

The diagram describes the full build.

flowchart TB
    mapping[(Revelio company mapping)]
    events[(Employment events)]
    counts[(Observed firm-year employment)]
    build[Construct firm universe<br/>and attributes]
    firms[(Firms)]

    mapping --> build
    events --> build
    counts --> build
    build --> firms

    classDef source fill:#e8eef7,stroke:#52739e
    classDef process fill:#fff0cc,stroke:#a66b00
    classDef data fill:#e2f2e7,stroke:#3b7a4b
    class mapping,events,counts source
    class build process
    class firms data

Grain and key: one row per company_id
Location: /data/<coverage>/processed/companies_processed.parquet
Full builder: shared/data/build_processed.py --target companies
Sample builder: shared/data/build_processed_sample.py

For full coverage, the Revelio company mapping supplies company attributes and descriptions. Employment events restrict it to observed firms and identify orphan company IDs. Under the current canonical column contract, observed firm-year employment supplies the observed_size_bucket, based on active users observed through 2024. Firms present in employment events but absent from the vendor mapping are retained and marked with is_orphan_company = TRUE.

The one_percent and samples firm tables are subsets of the completed full firm table for firms referenced by sampled events, relationships, or observed next employers. They are not rebuilt directly from the vendor mapping or from sample-specific firm-year counts.

The table defines the company universe and firm-side categorical features. about_clean is separately embedded into the company-description embeddings.