facilities

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

32 rows where license_type = "Class B - Dealer" and site_state = "Illinois" sorted by legal_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: customer_number, legal_name, site_city, site_zip, last_seen_date (date)

CREATE TABLE facilities (
    cert_number TEXT PRIMARY KEY,
    customer_number TEXT,
    legal_name TEXT,
    dba_name TEXT,
    site_name TEXT,
    site_address TEXT,
    site_city TEXT,
    site_state TEXT,
    site_zip TEXT,
    license_type TEXT,
    status TEXT,
    first_seen_date TEXT,
    last_seen_date TEXT
);
CREATE INDEX idx_facilities_state ON facilities(site_state);
CREATE INDEX idx_facilities_type ON facilities(license_type);
CREATE INDEX idx_facilities_name ON facilities(legal_name);