industries_sic_map

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

14 rows where industry_slug = "chemicals"

✎ View and edit SQL

This data as json, CSV (advanced)

Link sic_code industry_slug is_primary
2800,chemicals 2800 chemicals 1
2810,chemicals 2810 chemicals 1
2812,chemicals 2812 chemicals 1
2820,chemicals 2820 chemicals 1
2821,chemicals 2821 chemicals 1
2850,chemicals 2850 chemicals 1
2860,chemicals 2860 chemicals 1
2870,chemicals 2870 chemicals 1
2873,chemicals 2873 chemicals 1
2890,chemicals 2890 chemicals 1
3000,chemicals 3000 chemicals 1
3080,chemicals 3080 chemicals 1
3089,chemicals 3089 chemicals 1
5160,chemicals 5160 chemicals 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)
        );