industries_ntee_map

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

23 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: industry_slug

Link ntee_code industry_slug is_primary
B40,education B40 education 1
B41,education B41 education 1
B42,education B42 education 1
B43,education B43 education 1
B50,education B50 education 1
B60,education B60 education 1
E20,hospitals_health_systems E20 hospitals_health_systems 1
E21,hospitals_health_systems E21 hospitals_health_systems 1
E22,hospitals_health_systems E22 hospitals_health_systems 1
E24,hospitals_health_systems E24 hospitals_health_systems 1
E30,hospitals_health_systems E30 hospitals_health_systems 1
E31,health_insurance E31 health_insurance 1
E32,hospitals_health_systems E32 hospitals_health_systems 1
E40,hospitals_health_systems E40 hospitals_health_systems 1
E50,hospitals_health_systems E50 hospitals_health_systems 1
F30,hospitals_health_systems F30 hospitals_health_systems 1
K02,agriculture_agribusiness K02 agriculture_agribusiness 1
K28,agriculture_agribusiness K28 agriculture_agribusiness 1
K30,agriculture_agribusiness K30 agriculture_agribusiness 1
Y20,insurance_non_health Y20 insurance_non_health 1
Y22,insurance_non_health Y22 insurance_non_health 1
Y23,insurance_non_health Y23 insurance_non_health 1
Y24,insurance_non_health Y24 insurance_non_health 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE industries_ntee_map (
            ntee_code TEXT NOT NULL,
            industry_slug TEXT NOT NULL,
            is_primary INTEGER NOT NULL DEFAULT 0,
            PRIMARY KEY (ntee_code, industry_slug),
            FOREIGN KEY (industry_slug) REFERENCES industries(industry_slug)
        );