home / openregs

industries_sic_map

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

6 rows where industry_slug = "aerospace_defense_tech"

✎ View and edit SQL

This data as json, CSV (advanced)

Link sic_code industry_slug is_primary
3720,aerospace_defense_tech 3720 aerospace_defense_tech 1
3721,aerospace_defense_tech 3721 aerospace_defense_tech 1
3724,aerospace_defense_tech 3724 aerospace_defense_tech 1
3728,aerospace_defense_tech 3728 aerospace_defense_tech 1
3761,aerospace_defense_tech 3761 aerospace_defense_tech 1
3812,aerospace_defense_tech 3812 aerospace_defense_tech 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE industries_sic_map (
            sic_code TEXT NOT NULL,
            industry_slug TEXT NOT NULL,
            is_primary INTEGER NOT NULL DEFAULT 0,
            PRIMARY KEY (sic_code, industry_slug),
            FOREIGN KEY (industry_slug) REFERENCES industries(industry_slug)
        );
Powered by Datasette · Queries took 2.641ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API