entity_dominance

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

1 row where entity_id = 1147715

✎ View and edit SQL

This data as json, CSV (advanced)

CREATE TABLE entity_dominance (
            name_normalized TEXT PRIMARY KEY,
            entity_id INTEGER NOT NULL,
            dominance_ratio REAL NOT NULL,  -- size(top) / size(#2)
            candidate_count INTEGER NOT NULL,
            size REAL NOT NULL,
            notes TEXT,
            FOREIGN KEY (entity_id) REFERENCES entities(entity_id)
        );
CREATE INDEX idx_ed_nn ON entity_dominance(name_normalized);