home / risk-management-plans / rmp_facility_naics

Menu

rmp_facility_naics

9 rows where naics_code = 115111

✎ View and edit SQL

This data as json, CSV (advanced)

facility_naics_id ▼ facility_id naics_code
976 100000030101 115111
2012 100000174081 115111
16115 100000018278 115111
18456 100000008181 115111
18795 100000054166 115111
18799 100000054282 115111
18800 100000054326 115111
18818 100000056271 115111
19925 100000175231 115111

Advanced export

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

CSV options:

CREATE TABLE rmp_facility_naics (
        facility_naics_id INTEGER PRIMARY KEY,
        facility_id TEXT,
        naics_code TEXT,
        FOREIGN KEY (facility_id) REFERENCES rmp_facility(epa_facility_id),
        FOREIGN KEY (naics_code) REFERENCES rmp_naics(naics_code)
    );
CREATE INDEX idx_rmp_facility_naics_facility_id ON rmp_facility_naics(facility_id);
Powered by Datasette · Queries took 1.2ms