Firecrawl Alexandria

Oregon Open Data Portal

Oregon's open data portal (data.oregon.gov) for contractor licensing: the Construction Contractors Board's active licences, with endorsements, surety bonds, liability insurance and responsible managing individuals, and the Building Codes Division's active electrical, plumbing, boiler, elevator, prefab and manufactured dwelling licences and inspector certifications. Search by name, licence number, city, ZIP, county or licence type, poll CCB for licences registered since a date, and read one licence in full.

Try in Agent

Is Hoffman Construction Company of Oregon licensed with the Oregon CCB, and what bonds and insurance does it carry?

Try Oregon Open Data Portal now.

Choose an example or ask your own question.

What do you want to do with Oregon Open Data Portal?

Oregon Open Data Portal

TRY ASKING

Codefollows the fields above

const result = await firecrawl.scrape({
  alexandria: {
    provider: "data-oregon-gov",
    capability: "licenses/get_license",
    options: {
      license_number: "28417",
    },
  },
});

2Response example

This is a sample shape. Press Run to see live data from Oregon Open Data Portal.

{
  "address": "5500 MEADOWS RD. STE 500",
  "bonds": [
    {
      "amount_usd": 80000,
      "company": "FEDERAL INS CO",
      "effective_date": null,
      "expiration_date": "2028-04-07"
    },
    {
      "amount_usd": 25000,
      "company": "FEDERAL INS CO",
      "effective_date": null,
      "expiration_date": "2028-04-07"
    }
  ],
  "business_name": "HOFFMAN CONSTRUCTION COMPANY OF OREGON",
  "city": "LAKE OSWEGO",
  "county": "Clackamas",
  "dataset": {
    "id": "g77e-6bhs",
    "name": "CCB Active Licenses",
    "portal": "data.oregon.gov",
    "updated_at": "2026-10-27T17:04:21Z",
    "url": "https://data.oregon.gov/d/g77e-6bhs"
  },
  "dba_names": null,
  "discipline": null,
  "effective_date": null,
  "endorsements": [
    {
      "code": "CGC1",
      "expiration_date": "2028-04-07",
      "issue_date": "1979-04-25",
      "name": "Commercial General Contractor Level 1"
    },
    {
      "code": "RGC",
      "expiration_date": "2028-04-07",
      "issue_date": "1979-04-25",
      "name": "Residential General Contractor"
    }
  ],
  "expiration_date": "2028-04-07",
  "insurance": [
    {
      "amount_usd": 5000000,
      "company": "RRG - AMERICAN CONTRACTORS INS CO",
      "expiration_date": "2027-06-01"
    }
  ],
  "issue_date": "1979-04-25",
  "license": {
    "attribution": "Oregon Construction Contractors Board, CCB Active Licenses (data.oregon.gov dataset g77e-6bhs)",
    "name": "Public Domain U.S. Government",
    "url": "https://www.usa.gov/government-works"
  },
  "license_number": "28417",
  "license_type": "CGC1, RGC",
  "observed_at_ms": 1793141720624,
  "person_name": null,
  "phone": "5032218811",
  "principals": [
    {
      "name": "LEANNE HOIYEE LEGARE",
      "title": "Responsible Managing Individual"
    }
  ],
  "raw": {
    "rows": [
      {
        "address": "5500 MEADOWS RD. STE 500",
        "bond_amount": "80000",
        "bond_company": "FEDERAL INS CO",
        "bond_exp_date": "04/07/2028",
        "city": "LAKE OSWEGO",
        "county_code": "3",
        "county_name": "Clackamas",
        "endorsement_text": "Commercial General Contractor Level 1",
        "exempt_text": "Nonexempt",
        "full_name": "HOFFMAN CONSTRUCTION COMPANY OF OREGON",
        "ins_amount": "5000000",
        "ins_company": "RRG - AMERICAN CONTRACTORS INS CO",
        "ins_exp_date": "06/01/2027",
        "lic_exp_date": "04/07/2028",
        "license_number": "28417",
        "license_type": "CGC1",
        "orig_regis_date": "04/25/1979",
        "phone_number": "5032218811",
        "rmi_name": "LEANNE HOIYEE LEGARE",
        "state": "OR",
        "zip_code": "97035"
      },
      {
        "address": "5500 MEADOWS RD. STE 500",
        "bond_amount": "25000",
        "bond_company": "FEDERAL INS CO",
        "bond_exp_date": "04/07/2028",
        "city": "LAKE OSWEGO",
        "county_code": "3",
        "county_name": "Clackamas",
        "endorsement_text": "Residential General Contractor",
        "exempt_text": "Nonexempt",
        "full_name": "HOFFMAN CONSTRUCTION COMPANY OF OREGON",
        "ins_amount": "5000000",
        "ins_company": "RRG - AMERICAN CONTRACTORS INS CO",
        "ins_exp_date": "06/01/2027",
        "lic_exp_date": "04/07/2028",
        "license_number": "28417",
        "license_type": "RGC",
        "orig_regis_date": "04/25/1979",
        "phone_number": "5032218811",
        "rmi_name": "LEANNE HOIYEE LEGARE",
        "state": "OR",
        "zip_code": "97035"
      }
    ]
  },
  "registry_id": null,
  "related_licenses": [],
  "source_url": "https://data.oregon.gov/resource/g77e-6bhs.json?license_number=28417",
  "specialties": [
    "Commercial General Contractor Level 1",
    "Residential General Contractor"
  ],
  "state": "OR",
  "status": "active",
  "suspend_date": null,
  "zip": "97035"
}

Contains public domain data from the Oregon Construction Contractors Board (CCB Active Licenses, g77e-6bhs) and the Department of Consumer and Business Services, Building Codes Division (Active Contractor/Individual Licenses, vhbr-cuaq). (https://data.oregon.gov/)

Browse the library

Oregon Open Data Portal

Try Oregon Open Data Portal now.

Related providers