home / openregs

industries_sic_map

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

37 rows where industry_slug = "retail"

✎ View and edit SQL

This data as json, CSV (advanced)

Link sic_code industry_slug is_primary
5000,retail 5000 retail 1
5040,retail 5040 retail 1
5045,retail 5045 retail 1
5050,retail 5050 retail 1
5070,retail 5070 retail 1
5080,retail 5080 retail 1
5090,retail 5090 retail 1
5094,retail 5094 retail 1
5099,retail 5099 retail 1
5100,retail 5100 retail 1
5110,retail 5110 retail 1
5190,retail 5190 retail 1
5200,retail 5200 retail 1
5211,retail 5211 retail 1
5311,retail 5311 retail 1
5331,retail 5331 retail 1
5399,retail 5399 retail 1
5400,retail 5400 retail 1
5411,retail 5411 retail 1
5412,retail 5412 retail 1
5500,retail 5500 retail 1
5600,retail 5600 retail 1
5621,retail 5621 retail 1
5651,retail 5651 retail 1
5661,retail 5661 retail 1
5700,retail 5700 retail 1
5712,retail 5712 retail 1
5731,retail 5731 retail 1
5734,retail 5734 retail 1
5735,retail 5735 retail 1
5900,retail 5900 retail 1
5912,retail 5912 retail 1
5940,retail 5940 retail 1
5944,retail 5944 retail 1
5945,retail 5945 retail 1
5961,retail 5961 retail 1
5990,retail 5990 retail 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 429.799ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API