industries_sic_map

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

7 rows where industry_slug = "medical_devices"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_primary

Link sic_code industry_slug is_primary
2835,medical_devices 2835 medical_devices 0
3841,medical_devices 3841 medical_devices 1
3842,medical_devices 3842 medical_devices 1
3843,medical_devices 3843 medical_devices 1
3844,medical_devices 3844 medical_devices 1
3845,medical_devices 3845 medical_devices 1
5047,medical_devices 5047 medical_devices 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)
        );