industries_sic_map

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

20 rows where industry_slug = "oil_gas"

✎ View and edit SQL

This data as json, CSV (advanced)

Link sic_code industry_slug is_primary
1311,oil_gas 1311 oil_gas 1
1381,oil_gas 1381 oil_gas 1
1382,oil_gas 1382 oil_gas 1
1389,oil_gas 1389 oil_gas 1
2900,oil_gas 2900 oil_gas 1
2911,oil_gas 2911 oil_gas 1
2950,oil_gas 2950 oil_gas 1
2990,oil_gas 2990 oil_gas 1
3533,oil_gas 3533 oil_gas 1
4610,oil_gas 4610 oil_gas 1
4612,oil_gas 4612 oil_gas 1
4613,oil_gas 4613 oil_gas 1
4619,oil_gas 4619 oil_gas 1
4922,oil_gas 4922 oil_gas 1
4923,oil_gas 4923 oil_gas 1
4924,oil_gas 4924 oil_gas 1
4925,oil_gas 4925 oil_gas 1
5170,oil_gas 5170 oil_gas 1
5171,oil_gas 5171 oil_gas 1
5172,oil_gas 5172 oil_gas 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)
        );