Firecrawl Alexandria

City of Seattle Open Data: permits and land use decisions

City of Seattle permits from the Seattle Department of Construction and Inspections (SDCI) on data.seattle.gov, Seattle's Socrata open data portal: building, trade, electrical and land use permits (master use permits and design review, the land use decisions that precede building permits) as one normalized permit record. Search by address, ZIP, contractor, type, status or work description, filter by application, issue or decision date, value and the land use decision a building permit implements; read one permit with every published column; rank contractors by permits issued. Public Domain, refreshed nightly.

Try City of Seattle Open Data: permits and land use decisions now.

Choose an example or ask your own question.

City of Seattle Open Data: permits and land use decisions
TRY ASKING
1Request
stringRequired

string

The next_cursor of the previous page.

string

string

Which dataset to rank: building (Building Permits; contractor named on about a sixth of permits), trade or electrical (contractor named on most permits).

number

Records per page.

5 credits
Codefollows the fields above
const result = await firecrawl.scrape({
  alexandria: {
    provider: "data-seattle-gov",
    capability: "building-permits/contractor_activity",
    options: {
      issued_since: "2025-01-01",
      issued_until: "2025-12-31",
      limit: 10,
    },
  },
});
2Response example

This is a sample shape. Press Run to see live data from City of Seattle Open Data: permits and land use decisions.

{
  "count": 10,
  "dataset": {
    "id": "76t5-zqzr",
    "name": "Building Permits",
    "portal": "data.seattle.gov",
    "updated_at": "2026-10-27T01:15:43Z",
    "url": "https://data.seattle.gov/d/76t5-zqzr"
  },
  "issued_since": "2025-01-01",
  "issued_until": "2025-12-31",
  "jurisdiction": {
    "county": "King County",
    "name": "City of Seattle",
    "state": "WA"
  },
  "license": {
    "attribution": "City of Seattle, Seattle Department of Construction and Inspections: Building Permits (https://data.seattle.gov/d/76t5-zqzr)",
    "name": "Public Domain",
    "url": "https://data.seattle.gov/stories/s/Terms-of-Use/6ukr-wvup"
  },
  "next_cursor": "10",
  "observed_at_ms": 1793141562840,
  "records": [
    {
      "first_issued_date": "2025-01-02",
      "last_issued_date": "2025-12-29",
      "license": {
        "attribution": "City of Seattle, Seattle Department of Construction and Inspections: Building Permits (https://data.seattle.gov/d/76t5-zqzr)",
        "name": "Public Domain",
        "url": "https://data.seattle.gov/stories/s/Terms-of-Use/6ukr-wvup"
      },
      "name": "VALENTINE ROOFING",
      "permits": 195,
      "source_url": "https://data.seattle.gov/resource/76t5-zqzr.json?%24where=upper%28trim%28contractorcompanyname%29%29+%3D+%27VALENTINE+ROOFING%27+AND+issueddate+%3E%3D+%272025-01-01T00%3A00%3A00%27+AND+issueddate+%3C%3D+%272025-12-31T23%3A59%3A59.999%27&%24order=issueddate+DESC+NULL+LAST%2C+%3Aid",
      "total_valuation_usd": 3839623.77
    },
    {
      "first_issued_date": "2025-01-28",
      "last_issued_date": "2025-12-11",
      "license": {
        "attribution": "City of Seattle, Seattle Department of Construction and Inspections: Building Permits (https://data.seattle.gov/d/76t5-zqzr)",
        "name": "Public Domain",
        "url": "https://data.seattle.gov/stories/s/Terms-of-Use/6ukr-wvup"
      },
      "name": "STATE ROOFING INC",
      "permits": 26,
      "source_url": "https://data.seattle.gov/resource/76t5-zqzr.json?%24where=upper%28trim%28contractorcompanyname%29%29+%3D+%27STATE+ROOFING+INC%27+AND+issueddate+%3E%3D+%272025-01-01T00%3A00%3A00%27+AND+issueddate+%3C%3D+%272025-12-31T23%3A59%3A59.999%27&%24order=issueddate+DESC+NULL+LAST%2C+%3Aid",
      "total_valuation_usd": 810438.41
    },
    {
      "first_issued_date": "2025-01-16",
      "last_issued_date": "2025-09-03",
      "license": {
        "attribution": "City of Seattle, Seattle Department of Construction and Inspections: Building Permits (https://data.seattle.gov/d/76t5-zqzr)",
        "name": "Public Domain",
        "url": "https://data.seattle.gov/stories/s/Terms-of-Use/6ukr-wvup"
      },
      "name": "FLAT ROOF PROS INC",
      "permits": 8,
      "source_url": "https://data.seattle.gov/resource/76t5-zqzr.json?%24where=upper%28trim%28contractorcompanyname%29%29+%3D+%27FLAT+ROOF+PROS+INC%27+AND+issueddate+%3E%3D+%272025-01-01T00%3A00%3A00%27+AND+issueddate+%3C%3D+%272025-12-31T23%3A59%3A59.999%27&%24order=issueddate+DESC+NULL+LAST%2C+%3Aid",
      "total_valuation_usd": 327283.21
    },
    {
      "first_issued_date": "2025-08-20",
      "last_issued_date": "2025-11-19",
      "license": {
        "attribution": "City of Seattle, Seattle Department of Construction and Inspections: Building Permits (https://data.seattle.gov/d/76t5-zqzr)",
        "name": "Public Domain",
        "url": "https://data.seattle.gov/stories/s/Terms-of-Use/6ukr-wvup"
      },
      "name": "JAMES KING ROOFING, LLC",
      "permits": 7,
      "source_url": "https://data.seattle.gov/resource/76t5-zqzr.json?%24where=upper%28trim%28contractorcompanyname%29%29+%3D+%27JAMES+KING+ROOFING%2C+LLC%27+AND+issueddate+%3E%3D+%272025-01-01T00%3A00%3A00%27+AND+issueddate+%3C%3D+%272025-12-31T23%3A59%3A59.999%27&%24order=issueddate+DESC+NULL+LAST%2C+%3Aid",
      "total_valuation_usd": 646980
    },
    {
      "first_issued_date": "2025-01-28",
      "last_issued_date": "2025-04-30",
      "license": {
        "attribution": "City of Seattle, Seattle Department of Construction and Inspections: Building Permits (https://data.seattle.gov/d/76t5-zqzr)",
        "name": "Public Domain",
        "url": "https://data.seattle.gov/stories/s/Terms-of-Use/6ukr-wvup"
      },
      "name": "JAMES KING ROOFING",
      "permits": 7,
      "source_url": "https://data.seattle.gov/resource/76t5-zqzr.json?%24where=upper%28trim%28contractorcompanyname%29%29+%3D+%27JAMES+KING+ROOFING%27+AND+issueddate+%3E%3D+%272025-01-01T00%3A00%3A00%27+AND+issueddate+%3C%3D+%272025-12-31T23%3A59%3A59.999%27&%24order=issueddate+DESC+NULL+LAST%2C+%3Aid",
      "total_valuation_usd": 486467
    },
    {
      "first_issued_date": "2025-01-18",
      "last_issued_date": "2025-12-02",
      "license": {
        "attribution": "City of Seattle, Seattle Department of Construction and Inspections: Building Permits (https://data.seattle.gov/d/76t5-zqzr)",
        "name": "Public Domain",
        "url": "https://data.seattle.gov/stories/s/Terms-of-Use/6ukr-wvup"
      },
      "name": "FOUR SEASONS ROOF",
      "permits": 7,
      "source_url": "https://data.seattle.gov/resource/76t5-zqzr.json?%24where=upper%28trim%28contractorcompanyname%29%29+%3D+%27FOUR+SEASONS+ROOF%27+AND+issueddate+%3E%3D+%272025-01-01T00%3A00%3A00%27+AND+issueddate+%3C%3D+%272025-12-31T23%3A59%3A59.999%27&%24order=issueddate+DESC+NULL+LAST%2C+%3Aid",
      "total_valuation_usd": 279541
    },
    {
      "first_issued_date": "2025-03-04",
      "last_issued_date": "2025-08-27",
      "license": {
        "attribution": "City of Seattle, Seattle Department of Construction and Inspections: Building Permits (https://data.seattle.gov/d/76t5-zqzr)",
        "name": "Public Domain",
        "url": "https://data.seattle.gov/stories/s/Terms-of-Use/6ukr-wvup"
      },
      "name": "ALTERNATIVE ROOFING SYSTEMS INC.",
      "permits": 6,
      "source_url": "https://data.seattle.gov/resource/76t5-zqzr.json?%24where=upper%28trim%28contractorcompanyname%29%29+%3D+%27ALTERNATIVE+ROOFING+SYSTEMS+INC.%27+AND+issueddate+%3E%3D+%272025-01-01T00%3A00%3A00%27+AND+issueddate+%3C%3D+%272025-12-31T23%3A59%3A59.999%27&%24order=issueddate+DESC+NULL+LAST%2C+%3Aid",
      "total_valuation_usd": 1105713.5
    },
    {
      "first_issued_date": "2025-03-07",
      "last_issued_date": "2025-07-25",
      "license": {
        "attribution": "City of Seattle, Seattle Department of Construction and Inspections: Building Permits (https://data.seattle.gov/d/76t5-zqzr)",
        "name": "Public Domain",
        "url": "https://data.seattle.gov/stories/s/Terms-of-Use/6ukr-wvup"
      },
      "name": "ELITE OFFICE",
      "permits": 5,
      "source_url": "https://data.seattle.gov/resource/76t5-zqzr.json?%24where=upper%28trim%28contractorcompanyname%29%29+%3D+%27ELITE+OFFICE%27+AND+issueddate+%3E%3D+%272025-01-01T00%3A00%3A00%27+AND+issueddate+%3C%3D+%272025-12-31T23%3A59%3A59.999%27&%24order=issueddate+DESC+NULL+LAST%2C+%3Aid",
      "total_valuation_usd": 451501
    },
    {
      "first_issued_date": "2025-02-20",
      "last_issued_date": "2025-04-10",
      "license": {
        "attribution": "City of Seattle, Seattle Department of Construction and Inspections: Building Permits (https://data.seattle.gov/d/76t5-zqzr)",
        "name": "Public Domain",
        "url": "https://data.seattle.gov/stories/s/Terms-of-Use/6ukr-wvup"
      },
      "name": "ARLETTA L VANHOOF",
      "permits": 5,
      "source_url": "https://data.seattle.gov/resource/76t5-zqzr.json?%24where=upper%28trim%28contractorcompanyname%29%29+%3D+%27ARLETTA+L+VANHOOF%27+AND+issueddate+%3E%3D+%272025-01-01T00%3A00%3A00%27+AND+issueddate+%3C%3D+%272025-12-31T23%3A59%3A59.999%27&%24order=issueddate+DESC+NULL+LAST%2C+%3Aid",
      "total_valuation_usd": 120001
    },
    {
      "first_issued_date": "2025-04-22",
      "last_issued_date": "2025-06-23",
      "license": {
        "attribution": "City of Seattle, Seattle Department of Construction and Inspections: Building Permits (https://data.seattle.gov/d/76t5-zqzr)",
        "name": "Public Domain",
        "url": "https://data.seattle.gov/stories/s/Terms-of-Use/6ukr-wvup"
      },
      "name": "ROOFWORX LLC",
      "permits": 5,
      "source_url": "https://data.seattle.gov/resource/76t5-zqzr.json?%24where=upper%28trim%28contractorcompanyname%29%29+%3D+%27ROOFWORX+LLC%27+AND+issueddate+%3E%3D+%272025-01-01T00%3A00%3A00%27+AND+issueddate+%3C%3D+%272025-12-31T23%3A59%3A59.999%27&%24order=issueddate+DESC+NULL+LAST%2C+%3Aid",
      "total_valuation_usd": 67177.65
    }
  ],
  "source_url": "https://data.seattle.gov/resource/76t5-zqzr.json?%24select=upper%28trim%28contractorcompanyname%29%29+AS+contractor%2C+count%28*%29+AS+permits%2C+sum%28estprojectcost%29+AS+total_valuation%2C+min%28issueddate%29+AS+first_issued%2C+max%28issueddate%29+AS+last_issued&%24where=contractorcompanyname+IS+NOT+NULL+AND+issueddate+%3E%3D+%272025-01-01T00%3A00%3A00%27+AND+issueddate+%3C%3D+%272025-12-31T23%3A59%3A59.999%27&%24group=contractor&%24order=permits+DESC%2C+total_valuation+DESC+NULL+LAST%2C+contractor&%24limit=10"
}

Contains City of Seattle open data (SDCI Building, Trade, Electrical and Land Use Permits), Public Domain. (https://data.seattle.gov/)

Browse the library