home / openregs

industries_sic_map

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

13 rows where industry_slug = "automotive"

✎ View and edit SQL

This data as json, CSV (advanced)

Link sic_code industry_slug is_primary
3011,automotive 3011 automotive 1
3700,automotive 3700 automotive 1
3710,automotive 3710 automotive 1
3711,automotive 3711 automotive 1
3713,automotive 3713 automotive 1
3714,automotive 3714 automotive 1
3715,automotive 3715 automotive 1
3716,automotive 3716 automotive 1
5010,automotive 5010 automotive 1
5511,automotive 5511 automotive 1
5531,automotive 5531 automotive 1
7510,automotive 7510 automotive 1
7530,automotive 7530 automotive 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 184.034ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API