Firecrawl Alexandria

City of Cambridge, MA permits (data.cambridgema.gov)

Building, roof, siding, solar, electrical, mechanical and plumbing permits issued by the City of Cambridge, Massachusetts Inspectional Services Department, from nine datasets on the Cambridge Open Data Portal (data.cambridgema.gov, Socrata), reloaded daily from the city's permitting system. Search one category, or the five building permit datasets merged, by address, ZIP, map-block-lot parcel, contractor, permit type, work description, status, equipment (heat pumps, ductless splits, EV chargers, solar PV, batteries, generators, electric water heaters), issue and application dates and declared cost, newest first; read one permit with every published column; and rank contractors by permits and declared cost in a date window. Records follow the shared permits shape with typed equipment details for solar (kW, panels, inverter, battery), electrical, mechanical and plumbing permits. The data is dedicated to the public domain under the ODC PDDL: every response and record carries its licence, attribution and source URL.

Try City of Cambridge, MA permits (data.cambridgema.gov) now.

Choose an example or ask your own question.

City of Cambridge, MA permits (data.cambridgema.gov)
TRY ASKING
1Request
stringRequired

Which dataset to rank contractors in.

stringRequired

string

next_cursor from the previous page; repeat the same filters with it.

string

Only permits with this equipment, by the dataset's own counts: electrical (heat_pump, ductless_split, ev_charger, solar_pv, generator), mechanical (heat_pump, ductless_split), solar (solar_pv, battery_storage), plumbing (electric_water_heater). Needs category; other pairs are invalid_input.

string

number

Records per page.

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

This is a sample shape. Press Run to see live data from City of Cambridge, MA permits (data.cambridgema.gov).

{
  "category": "solar",
  "count": 5,
  "dataset": {
    "category": "solar",
    "id": "whpw-w55x",
    "name": "Solar Installation Permits",
    "portal": "data.cambridgema.gov",
    "updated_at": "2026-10-27T09:55:05Z",
    "url": "https://data.cambridgema.gov/d/whpw-w55x"
  },
  "issued_since": "2025-01-01",
  "issued_until": "2025-12-31",
  "jurisdiction": {
    "county": "Middlesex County",
    "name": "City of Cambridge",
    "state": "MA"
  },
  "license": {
    "attribution": "City of Cambridge, MA, Inspectional Services Department, via the Cambridge Open Data Portal (data.cambridgema.gov)",
    "name": "Open Data Commons Public Domain Dedication and License",
    "url": "http://opendatacommons.org/licenses/pddl/1.0/"
  },
  "next_cursor": "5",
  "observed_at_ms": 1793149568566,
  "records": [
    {
      "first_issued_date": "2025-01-14",
      "last_issued_date": "2025-11-14",
      "license": {
        "attribution": "City of Cambridge, MA, Inspectional Services Department, via the Cambridge Open Data Portal (data.cambridgema.gov)",
        "name": "Open Data Commons Public Domain Dedication and License",
        "url": "http://opendatacommons.org/licenses/pddl/1.0/"
      },
      "license_number": null,
      "name": "Great Sky Solar",
      "permits": 11,
      "source_url": "https://data.cambridgema.gov/resource/whpw-w55x.json?%24where=issue_date+%3E%3D+%272025-01-01T00%3A00%3A00%27+AND+issue_date+%3C%3D+%272025-12-31T23%3A59%3A59.999%27+AND+upper%28trim%28firm_name%29%29+%3D+%27GREAT+SKY+SOLAR%27&%24order=issue_date+DESC%2C+id",
      "total_valuation_usd": 349909.4
    },
    {
      "first_issued_date": "2025-10-16",
      "last_issued_date": "2025-10-28",
      "license": {
        "attribution": "City of Cambridge, MA, Inspectional Services Department, via the Cambridge Open Data Portal (data.cambridgema.gov)",
        "name": "Open Data Commons Public Domain Dedication and License",
        "url": "http://opendatacommons.org/licenses/pddl/1.0/"
      },
      "license_number": null,
      "name": "The Boston Solar Company LLC",
      "permits": 10,
      "source_url": "https://data.cambridgema.gov/resource/whpw-w55x.json?%24where=issue_date+%3E%3D+%272025-01-01T00%3A00%3A00%27+AND+issue_date+%3C%3D+%272025-12-31T23%3A59%3A59.999%27+AND+upper%28trim%28firm_name%29%29+%3D+%27THE+BOSTON+SOLAR+COMPANY+LLC%27&%24order=issue_date+DESC%2C+id",
      "total_valuation_usd": 652356.15
    },
    {
      "first_issued_date": "2025-05-08",
      "last_issued_date": "2025-11-24",
      "license": {
        "attribution": "City of Cambridge, MA, Inspectional Services Department, via the Cambridge Open Data Portal (data.cambridgema.gov)",
        "name": "Open Data Commons Public Domain Dedication and License",
        "url": "http://opendatacommons.org/licenses/pddl/1.0/"
      },
      "license_number": null,
      "name": "Boston Solar",
      "permits": 8,
      "source_url": "https://data.cambridgema.gov/resource/whpw-w55x.json?%24where=issue_date+%3E%3D+%272025-01-01T00%3A00%3A00%27+AND+issue_date+%3C%3D+%272025-12-31T23%3A59%3A59.999%27+AND+upper%28trim%28firm_name%29%29+%3D+%27BOSTON+SOLAR%27&%24order=issue_date+DESC%2C+id",
      "total_valuation_usd": 422403.88
    },
    {
      "first_issued_date": "2025-03-11",
      "last_issued_date": "2025-12-02",
      "license": {
        "attribution": "City of Cambridge, MA, Inspectional Services Department, via the Cambridge Open Data Portal (data.cambridgema.gov)",
        "name": "Open Data Commons Public Domain Dedication and License",
        "url": "http://opendatacommons.org/licenses/pddl/1.0/"
      },
      "license_number": null,
      "name": "ReVision Energy",
      "permits": 8,
      "source_url": "https://data.cambridgema.gov/resource/whpw-w55x.json?%24where=issue_date+%3E%3D+%272025-01-01T00%3A00%3A00%27+AND+issue_date+%3C%3D+%272025-12-31T23%3A59%3A59.999%27+AND+upper%28trim%28firm_name%29%29+%3D+%27REVISION+ENERGY%27&%24order=issue_date+DESC%2C+id",
      "total_valuation_usd": 275262
    },
    {
      "first_issued_date": "2025-01-23",
      "last_issued_date": "2025-12-29",
      "license": {
        "attribution": "City of Cambridge, MA, Inspectional Services Department, via the Cambridge Open Data Portal (data.cambridgema.gov)",
        "name": "Open Data Commons Public Domain Dedication and License",
        "url": "http://opendatacommons.org/licenses/pddl/1.0/"
      },
      "license_number": null,
      "name": "Trinity Solar LLC",
      "permits": 6,
      "source_url": "https://data.cambridgema.gov/resource/whpw-w55x.json?%24where=issue_date+%3E%3D+%272025-01-01T00%3A00%3A00%27+AND+issue_date+%3C%3D+%272025-12-31T23%3A59%3A59.999%27+AND+upper%28trim%28firm_name%29%29+%3D+%27TRINITY+SOLAR+LLC%27&%24order=issue_date+DESC%2C+id",
      "total_valuation_usd": 206430.82
    }
  ],
  "source_url": "https://data.cambridgema.gov/resource/whpw-w55x.json?%24select=upper%28trim%28firm_name%29%29+AS+contractor_key%2Cmax%28firm_name%29+AS+contractor_name%2Ccount%28*%29+AS+permits%2Csum%28total_cost%29+AS+valuation%2Cmin%28issue_date%29+AS+first_issued%2Cmax%28issue_date%29+AS+last_issued&%24where=issue_date+%3E%3D+%272025-01-01T00%3A00%3A00%27+AND+issue_date+%3C%3D+%272025-12-31T23%3A59%3A59.999%27+AND+firm_name+IS+NOT+NULL&%24group=upper%28trim%28firm_name%29%29&%24order=permits+DESC%2C+valuation+DESC+NULL+LAST%2C+contractor_key&%24limit=5"
}

Permit data from the City of Cambridge, MA Inspectional Services Department via the Cambridge Open Data Portal, dedicated to the public domain under the Open Data Commons PDDL 1.0. (https://data.cambridgema.gov/)

Browse the library
//
Get started
//
Give your agent City of Cambridge, MA permits (data.cambridgema.gov).
One API key for the live web and every provider in Alexandria.
Are you an AI agent? See setup options