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 = "shipping_logistics"

✎ View and edit SQL

This data as json, CSV (advanced)

Link sic_code industry_slug is_primary
3730,shipping_logistics 3730 shipping_logistics 1
3743,shipping_logistics 3743 shipping_logistics 1
4011,shipping_logistics 4011 shipping_logistics 1
4100,shipping_logistics 4100 shipping_logistics 1
4119,shipping_logistics 4119 shipping_logistics 1
4131,shipping_logistics 4131 shipping_logistics 1
4200,shipping_logistics 4200 shipping_logistics 1
4210,shipping_logistics 4210 shipping_logistics 1
4213,shipping_logistics 4213 shipping_logistics 1
4220,shipping_logistics 4220 shipping_logistics 1
4231,shipping_logistics 4231 shipping_logistics 1
4400,shipping_logistics 4400 shipping_logistics 1
4412,shipping_logistics 4412 shipping_logistics 1
4420,shipping_logistics 4420 shipping_logistics 1
4424,shipping_logistics 4424 shipping_logistics 1
4440,shipping_logistics 4440 shipping_logistics 1
4490,shipping_logistics 4490 shipping_logistics 1
4700,shipping_logistics 4700 shipping_logistics 1
4731,shipping_logistics 4731 shipping_logistics 1
4741,shipping_logistics 4741 shipping_logistics 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 3.545ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API