home / openregs

industries_sic_map

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

11 rows where industry_slug = "electric_utilities"

✎ View and edit SQL

This data as json, CSV (advanced)

Link sic_code industry_slug is_primary
4900,electric_utilities 4900 electric_utilities 1
4911,electric_utilities 4911 electric_utilities 1
4931,electric_utilities 4931 electric_utilities 1
4932,electric_utilities 4932 electric_utilities 1
4941,electric_utilities 4941 electric_utilities 1
4950,electric_utilities 4950 electric_utilities 1
4953,electric_utilities 4953 electric_utilities 1
4955,electric_utilities 4955 electric_utilities 1
4959,electric_utilities 4959 electric_utilities 1
4961,electric_utilities 4961 electric_utilities 1
4991,electric_utilities 4991 electric_utilities 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 112.908ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API