industries_sic_map

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

14 rows where industry_slug = "big_tech"

✎ View and edit SQL

This data as json, CSV (advanced)

Link sic_code industry_slug is_primary
3570,big_tech 3570 big_tech 1
3571,big_tech 3571 big_tech 1
3572,big_tech 3572 big_tech 1
3575,big_tech 3575 big_tech 1
3576,big_tech 3576 big_tech 1
3577,big_tech 3577 big_tech 1
3578,big_tech 3578 big_tech 1
3579,big_tech 3579 big_tech 1
7370,big_tech 7370 big_tech 1
7371,big_tech 7371 big_tech 1
7372,big_tech 7372 big_tech 1
7373,big_tech 7373 big_tech 1
7374,big_tech 7374 big_tech 1
7377,big_tech 7377 big_tech 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)
        );