home / openregs

industries_sic_map

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

20 rows where industry_slug = "banking"

✎ View and edit SQL

This data as json, CSV (advanced)

Link sic_code industry_slug is_primary
6020,banking 6020 banking 1
6021,banking 6021 banking 1
6022,banking 6022 banking 1
6029,banking 6029 banking 1
6035,banking 6035 banking 1
6036,banking 6036 banking 1
6099,banking 6099 banking 1
6100,banking 6100 banking 1
6111,banking 6111 banking 1
6141,banking 6141 banking 1
6153,banking 6153 banking 1
6159,banking 6159 banking 1
6162,banking 6162 banking 1
6163,banking 6163 banking 1
6172,banking 6172 banking 1
6189,banking 6189 banking 1
6200,banking 6200 banking 1
6211,banking 6211 banking 1
6221,banking 6221 banking 1
6282,banking 6282 banking 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 430.293ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API