home / openregs

industries_sic_map

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

10 rows where industry_slug = "telecommunications"

✎ View and edit SQL

This data as json, CSV (advanced)

Link sic_code industry_slug is_primary
3661,telecommunications 3661 telecommunications 1
3663,telecommunications 3663 telecommunications 1
3669,telecommunications 3669 telecommunications 1
4812,telecommunications 4812 telecommunications 1
4813,telecommunications 4813 telecommunications 1
4822,telecommunications 4822 telecommunications 1
4832,telecommunications 4832 telecommunications 1
4833,telecommunications 4833 telecommunications 1
4841,telecommunications 4841 telecommunications 1
4899,telecommunications 4899 telecommunications 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.484ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API