entity_dominance

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

17,705 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: notes

Next page

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);