Data dictionary

Contractor licence fields

One row per licence, served by /v1/contractors and /v1/contractors/{id}. Nevada licences come from the Nevada State Contractors Board, Austin's from the Texas Department of Licensing and Regulation (TDLR).

40 fields. Types are as served in JSON; dates are YYYY-MM-DD.

Field definitions

  • id integer

    The Puller identifier of the contractor record; permits.contractor_id refers to it.

    Filled in

    • Austin
    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
    • Carson City
  • board string

    The licensing board whose register the licence comes from, as a short code. In Nevada, it is nscb, the Nevada State Contractors Board. In Texas, it is tdlr, the Texas Department of Licensing and Regulation.

    Filled in

    • Austin
    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
    • Carson City
  • license_type string

    Kind of licence, as the licensing board classes it. In Nevada, each Nevada State Contractors Board licence is NSCB Contractor and the work it allows is in classifications. In Texas, it is one of the TDLR types Electrical Contractor, A/C Contractor or Electrical Sign Contractor.

    Filled in

    • Austin
    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
    • Carson City
  • license_number string

    The licence number the board issued, as text.

    Filled in

    • Austin
    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
    • Carson City
  • business_name string

    The licensee's business name as the licensing board publishes it, usually in upper case.

    Filled in

    • Austin
    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
    • Carson City
  • owner_name string

    Name of the license holder as TDLR publishes it: a person (LAST, FIRST MIDDLE) or, for some electrical licenses, the company name.

    Filled in

    • Austin
  • phone string

    Business telephone as the board publishes it.

    Filled in

    • Austin
    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • owner_phone string

    The license holder's own telephone as TDLR publishes it.

    Filled in

    • Austin
  • address string

    Business street address as the licensing board publishes it.

    Filled in

    • Austin
    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • city string

    City of the business, as the licensing board publishes it.

    Filled in

    • Austin
    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • county string

    Texas county of the business, upper case (for example TRAVIS), as TDLR publishes it.

    Filled in

    • Austin
  • license_expiration date

    Date the licence expires, as the board lists it.

    Filled in

    • Austin
    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • license_status string

    The state of the licence: active or expired, or not_in_source for a licence the board no longer lists.

    Filled in

    • Austin
    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
    • Carson City
  • name_norm string

    The business name (the owner name when there is none) prepared for matching: lower case, with punctuation and company suffixes removed.

    Filled in

    • Austin
    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
    • Carson City
  • phone_norm string

    The last 10 digits of the business telephone, or of the owner's telephone when there is no business number.

    Filled in

    • Austin
    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • last_seen_in_source_at timestamp

    When this licence was last listed on the Nevada State Contractors Board's register.

    Filled in

    • Austin
    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
    • Carson City
  • classifications string[]

    The licence's classification codes as the Nevada State Contractors Board lists them, in the board's order, for example B-2 (Residential and Small Commercial) or C-1D (Plumbing).

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
    • Carson City
  • monetary_limit number

    The largest job, in whole dollars, the Nevada State Contractors Board licence allows, as the board lists it.

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • zip string

    ZIP code (or a foreign postcode) of the business address as the Nevada State Contractors Board lists it.

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • board_status string

    The licence's status in the Nevada State Contractors Board's own words, for example Active, Active Probation, Suspended, Voluntary Surrender or Inactive.

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • board_status_reason string

    The reason the Nevada State Contractors Board gives for board_status, for example No Qualified Individual or DIR Violation.

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • board_status_date date

    The date the Nevada State Contractors Board set board_status.

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • license_origin_date date

    The date the Nevada State Contractors Board first issued the licence.

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • bond_amount number

    The amount of the licence bond, in US dollars; blank when the board lists no bond.

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • board_status_checked_at timestamp

    When this licence's status was last checked against the Nevada State Contractors Board's records.

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • discipline_actions_12m integer

    How many disciplinary or board actions the Nevada State Contractors Board lists for this licence in the last 12 months.

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • last_discipline_date date

    The date of the latest disciplinary or board action the Nevada State Contractors Board lists for this licence.

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • business_group_id integer

    The lowest id of the licences one business holds under one name, so they can be read together.

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
    • Carson City
  • dba_name string

    The name the business trades under (doing business as), as the Nevada State Contractors Board's detail page prints it.

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • business_type string

    The kind of business that holds the licence, as the Nevada State Contractors Board prints it, for example Limited Liability Company, Corporation or Sole Proprietorship.

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • license_limitation string

    A limitation the Nevada State Contractors Board puts on the licence, as printed (LIMITED TO RADON GAS MITIGATION).

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • mailing_address string

    The business's mailing street address on the Nevada State Contractors Board's detail page, its street lines joined with a space; the business address the listing gives is address.

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • mailing_city string

    City of the business's mailing address on the Nevada State Contractors Board's detail page.

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • mailing_state string

    State of the business's mailing address on the Nevada State Contractors Board's detail page, as printed (for example NV).

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • mailing_zip string

    ZIP code of the business's mailing address on the Nevada State Contractors Board's detail page, as printed.

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • mailing_phone string

    The telephone the Nevada State Contractors Board gives with the mailing address, as printed, for example (702) 555-0101; the one given with the business address is phone.

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • bond_surety string

    The surety company of the licence bond that bond_amount is from (the one with the latest effective date).

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • bond_type string

    The type of the licence bond that bond_amount is from, as the board prints it, for example Surety.

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite
  • bond_agent string

    The agent of the licence bond that bond_amount is from, as the board prints it.

    Filled in

    • Las Vegas
    • Henderson
    • Clark County
    • Mesquite