All providers
Sign in
Sign up to use City of Columbus Building Permits (opendata.columbus.gov)
Firecrawl Alexandria
Real estate

City of Columbus Building Permits (opendata.columbus.gov)

City of Columbus, Ohio building permits from the Department of Building and Zoning Services, published on the City's open data hub opendata.columbus.gov as the ArcGIS layer Building Permits (item f7a785b863454d96a0fe3f5aa5368e7d): about 690,000 permits since 2010, reloaded nightly. Search permits by site address, ZIP, Franklin County parcel, applicant business (usually the contractor), permit type, status, issue date, latest status change and job value; read one permit with every published column; and rank applicant businesses by permits and value for a date window. Records use the shared permit shape with coordinates and Citizen Access links. The data is dedicated to the public domain under CC0: every response and record carries its licence, attribution and source URL.

Try in Agent
What building permits were issued at 1357 Edgehill Rd in Columbus, Ohio, and when did the apartment building get its certificate of occupancy?

Try City of Columbus Building Permits (opendata.columbus.gov) now.

Choose an example or ask your own question.

City of Columbus Building Permits (opendata.columbus.gov)
TRY ASKING
1Request
stringRequired

string

The next_cursor of the previous page; repeat the same filters with it.

string

number

Records per page.

5 credits
Codefollows the fields above
const result = await firecrawl.scrape({
  alexandria: {
    provider: "opendata-columbus-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 Columbus Building Permits (opendata.columbus.gov).

{
  "count": 10,
  "dataset": {
    "id": "f7a785b863454d96a0fe3f5aa5368e7d_0",
    "name": "Building Permits",
    "portal": "opendata.columbus.gov",
    "updated_at": "2026-10-27T09:03:53Z",
    "url": "https://opendata.columbus.gov/datasets/f7a785b863454d96a0fe3f5aa5368e7d_0/about"
  },
  "issued_since": "2025-01-01",
  "issued_until": "2025-12-31",
  "jurisdiction": {
    "county": "Franklin",
    "name": "Columbus",
    "state": "OH"
  },
  "license": {
    "attribution": "City of Columbus, Department of Building and Zoning Services: Building Permits (opendata.columbus.gov)",
    "name": "CC0 1.0 Universal (public domain dedication)",
    "url": "https://creativecommons.org/publicdomain/zero/1.0/"
  },
  "next_cursor": "10",
  "observed_at_ms": 1793149073148,
  "records": [
    {
      "first_issued_date": "2025-01-02",
      "last_issued_date": "2025-12-31",
      "license": {
        "attribution": "City of Columbus, Department of Building and Zoning Services: Building Permits (opendata.columbus.gov)",
        "name": "CC0 1.0 Universal (public domain dedication)",
        "url": "https://creativecommons.org/publicdomain/zero/1.0/"
      },
      "name": "ECO PLUMBERS INC",
      "permits": 1448,
      "source_url": "https://services1.arcgis.com/9yy6msODkIBzkUXU/arcgis/rest/services/Building_Permits/FeatureServer/0/query?where=ISSUED_DT+%3E%3D+TIMESTAMP+%272025-01-01+00%3A00%3A00%27+AND+ISSUED_DT+%3C%3D+TIMESTAMP+%272025-12-31+23%3A59%3A59%27+AND+APPLICANT_BUS_NAME+%3D+%27ECO+PLUMBERS+INC%27&outFields=OBJECTID%2CB1_ALT_ID%2CB1_PER_GROUP%2CB1_PER_TYPE%2CB1_PER_SUB_TYPE%2CB1_PER_CATEGORY%2CGENERAL_TYPE%2CB1_PARCEL_NBR%2CCOLS_KEY%2CSITE_ADDRESS%2CB1_SITUS_ZIP%2CPERMIT_STATUS%2CAPPLICANT_BUS_NAME%2CSQFT%2CG3_VALUE_TTL%2CISSUED_YEAR%2CISSUED_DT%2CLAST_STATUS_DT%2CCONST_TYPE_CODE%2CVALUE_DESC%2CACA_URL%2CUNITS%2CB1_APPL_STATUS&orderByFields=ISSUED_DT+DESC%2COBJECTID+DESC&resultRecordCount=100&returnGeometry=true&outSR=4326&f=json",
      "total_valuation_usd": 0
    },
    {
      "first_issued_date": "2025-01-03",
      "last_issued_date": "2025-12-31",
      "license": {
        "attribution": "City of Columbus, Department of Building and Zoning Services: Building Permits (opendata.columbus.gov)",
        "name": "CC0 1.0 Universal (public domain dedication)",
        "url": "https://creativecommons.org/publicdomain/zero/1.0/"
      },
      "name": "Atlas Butler Heating and Cooling",
      "permits": 1204,
      "source_url": "https://services1.arcgis.com/9yy6msODkIBzkUXU/arcgis/rest/services/Building_Permits/FeatureServer/0/query?where=ISSUED_DT+%3E%3D+TIMESTAMP+%272025-01-01+00%3A00%3A00%27+AND+ISSUED_DT+%3C%3D+TIMESTAMP+%272025-12-31+23%3A59%3A59%27+AND+APPLICANT_BUS_NAME+%3D+%27Atlas+Butler+Heating+and+Cooling%27&outFields=OBJECTID%2CB1_ALT_ID%2CB1_PER_GROUP%2CB1_PER_TYPE%2CB1_PER_SUB_TYPE%2CB1_PER_CATEGORY%2CGENERAL_TYPE%2CB1_PARCEL_NBR%2CCOLS_KEY%2CSITE_ADDRESS%2CB1_SITUS_ZIP%2CPERMIT_STATUS%2CAPPLICANT_BUS_NAME%2CSQFT%2CG3_VALUE_TTL%2CISSUED_YEAR%2CISSUED_DT%2CLAST_STATUS_DT%2CCONST_TYPE_CODE%2CVALUE_DESC%2CACA_URL%2CUNITS%2CB1_APPL_STATUS&orderByFields=ISSUED_DT+DESC%2COBJECTID+DESC&resultRecordCount=100&returnGeometry=true&outSR=4326&f=json",
      "total_valuation_usd": 0
    },
    {
      "first_issued_date": "2025-01-02",
      "last_issued_date": "2025-12-31",
      "license": {
        "attribution": "City of Columbus, Department of Building and Zoning Services: Building Permits (opendata.columbus.gov)",
        "name": "CC0 1.0 Universal (public domain dedication)",
        "url": "https://creativecommons.org/publicdomain/zero/1.0/"
      },
      "name": "COLUMBUS/WORTHINGTON AIR",
      "permits": 1041,
      "source_url": "https://services1.arcgis.com/9yy6msODkIBzkUXU/arcgis/rest/services/Building_Permits/FeatureServer/0/query?where=ISSUED_DT+%3E%3D+TIMESTAMP+%272025-01-01+00%3A00%3A00%27+AND+ISSUED_DT+%3C%3D+TIMESTAMP+%272025-12-31+23%3A59%3A59%27+AND+APPLICANT_BUS_NAME+%3D+%27COLUMBUS%2FWORTHINGTON+AIR%27&outFields=OBJECTID%2CB1_ALT_ID%2CB1_PER_GROUP%2CB1_PER_TYPE%2CB1_PER_SUB_TYPE%2CB1_PER_CATEGORY%2CGENERAL_TYPE%2CB1_PARCEL_NBR%2CCOLS_KEY%2CSITE_ADDRESS%2CB1_SITUS_ZIP%2CPERMIT_STATUS%2CAPPLICANT_BUS_NAME%2CSQFT%2CG3_VALUE_TTL%2CISSUED_YEAR%2CISSUED_DT%2CLAST_STATUS_DT%2CCONST_TYPE_CODE%2CVALUE_DESC%2CACA_URL%2CUNITS%2CB1_APPL_STATUS&orderByFields=ISSUED_DT+DESC%2COBJECTID+DESC&resultRecordCount=100&returnGeometry=true&outSR=4326&f=json",
      "total_valuation_usd": 0
    },
    {
      "first_issued_date": "2025-01-02",
      "last_issued_date": "2025-12-30",
      "license": {
        "attribution": "City of Columbus, Department of Building and Zoning Services: Building Permits (opendata.columbus.gov)",
        "name": "CC0 1.0 Universal (public domain dedication)",
        "url": "https://creativecommons.org/publicdomain/zero/1.0/"
      },
      "name": "The Waterworks",
      "permits": 704,
      "source_url": "https://services1.arcgis.com/9yy6msODkIBzkUXU/arcgis/rest/services/Building_Permits/FeatureServer/0/query?where=ISSUED_DT+%3E%3D+TIMESTAMP+%272025-01-01+00%3A00%3A00%27+AND+ISSUED_DT+%3C%3D+TIMESTAMP+%272025-12-31+23%3A59%3A59%27+AND+APPLICANT_BUS_NAME+%3D+%27The+Waterworks%27&outFields=OBJECTID%2CB1_ALT_ID%2CB1_PER_GROUP%2CB1_PER_TYPE%2CB1_PER_SUB_TYPE%2CB1_PER_CATEGORY%2CGENERAL_TYPE%2CB1_PARCEL_NBR%2CCOLS_KEY%2CSITE_ADDRESS%2CB1_SITUS_ZIP%2CPERMIT_STATUS%2CAPPLICANT_BUS_NAME%2CSQFT%2CG3_VALUE_TTL%2CISSUED_YEAR%2CISSUED_DT%2CLAST_STATUS_DT%2CCONST_TYPE_CODE%2CVALUE_DESC%2CACA_URL%2CUNITS%2CB1_APPL_STATUS&orderByFields=ISSUED_DT+DESC%2COBJECTID+DESC&resultRecordCount=100&returnGeometry=true&outSR=4326&f=json",
      "total_valuation_usd": 0
    },
    {
      "first_issued_date": "2025-01-07",
      "last_issued_date": "2025-12-31",
      "license": {
        "attribution": "City of Columbus, Department of Building and Zoning Services: Building Permits (opendata.columbus.gov)",
        "name": "CC0 1.0 Universal (public domain dedication)",
        "url": "https://creativecommons.org/publicdomain/zero/1.0/"
      },
      "name": "Rosati Windows",
      "permits": 648,
      "source_url": "https://services1.arcgis.com/9yy6msODkIBzkUXU/arcgis/rest/services/Building_Permits/FeatureServer/0/query?where=ISSUED_DT+%3E%3D+TIMESTAMP+%272025-01-01+00%3A00%3A00%27+AND+ISSUED_DT+%3C%3D+TIMESTAMP+%272025-12-31+23%3A59%3A59%27+AND+APPLICANT_BUS_NAME+%3D+%27Rosati+Windows%27&outFields=OBJECTID%2CB1_ALT_ID%2CB1_PER_GROUP%2CB1_PER_TYPE%2CB1_PER_SUB_TYPE%2CB1_PER_CATEGORY%2CGENERAL_TYPE%2CB1_PARCEL_NBR%2CCOLS_KEY%2CSITE_ADDRESS%2CB1_SITUS_ZIP%2CPERMIT_STATUS%2CAPPLICANT_BUS_NAME%2CSQFT%2CG3_VALUE_TTL%2CISSUED_YEAR%2CISSUED_DT%2CLAST_STATUS_DT%2CCONST_TYPE_CODE%2CVALUE_DESC%2CACA_URL%2CUNITS%2CB1_APPL_STATUS&orderByFields=ISSUED_DT+DESC%2COBJECTID+DESC&resultRecordCount=100&returnGeometry=true&outSR=4326&f=json",
      "total_valuation_usd": 5638023
    },
    {
      "first_issued_date": "2025-01-02",
      "last_issued_date": "2025-12-30",
      "license": {
        "attribution": "City of Columbus, Department of Building and Zoning Services: Building Permits (opendata.columbus.gov)",
        "name": "CC0 1.0 Universal (public domain dedication)",
        "url": "https://creativecommons.org/publicdomain/zero/1.0/"
      },
      "name": "FIVE STAR HOME SERVICES",
      "permits": 587,
      "source_url": "https://services1.arcgis.com/9yy6msODkIBzkUXU/arcgis/rest/services/Building_Permits/FeatureServer/0/query?where=ISSUED_DT+%3E%3D+TIMESTAMP+%272025-01-01+00%3A00%3A00%27+AND+ISSUED_DT+%3C%3D+TIMESTAMP+%272025-12-31+23%3A59%3A59%27+AND+APPLICANT_BUS_NAME+%3D+%27FIVE+STAR+HOME+SERVICES%27&outFields=OBJECTID%2CB1_ALT_ID%2CB1_PER_GROUP%2CB1_PER_TYPE%2CB1_PER_SUB_TYPE%2CB1_PER_CATEGORY%2CGENERAL_TYPE%2CB1_PARCEL_NBR%2CCOLS_KEY%2CSITE_ADDRESS%2CB1_SITUS_ZIP%2CPERMIT_STATUS%2CAPPLICANT_BUS_NAME%2CSQFT%2CG3_VALUE_TTL%2CISSUED_YEAR%2CISSUED_DT%2CLAST_STATUS_DT%2CCONST_TYPE_CODE%2CVALUE_DESC%2CACA_URL%2CUNITS%2CB1_APPL_STATUS&orderByFields=ISSUED_DT+DESC%2COBJECTID+DESC&resultRecordCount=100&returnGeometry=true&outSR=4326&f=json",
      "total_valuation_usd": 0
    },
    {
      "first_issued_date": "2025-01-03",
      "last_issued_date": "2025-12-29",
      "license": {
        "attribution": "City of Columbus, Department of Building and Zoning Services: Building Permits (opendata.columbus.gov)",
        "name": "CC0 1.0 Universal (public domain dedication)",
        "url": "https://creativecommons.org/publicdomain/zero/1.0/"
      },
      "name": "Able Roof",
      "permits": 518,
      "source_url": "https://services1.arcgis.com/9yy6msODkIBzkUXU/arcgis/rest/services/Building_Permits/FeatureServer/0/query?where=ISSUED_DT+%3E%3D+TIMESTAMP+%272025-01-01+00%3A00%3A00%27+AND+ISSUED_DT+%3C%3D+TIMESTAMP+%272025-12-31+23%3A59%3A59%27+AND+APPLICANT_BUS_NAME+%3D+%27Able+Roof%27&outFields=OBJECTID%2CB1_ALT_ID%2CB1_PER_GROUP%2CB1_PER_TYPE%2CB1_PER_SUB_TYPE%2CB1_PER_CATEGORY%2CGENERAL_TYPE%2CB1_PARCEL_NBR%2CCOLS_KEY%2CSITE_ADDRESS%2CB1_SITUS_ZIP%2CPERMIT_STATUS%2CAPPLICANT_BUS_NAME%2CSQFT%2CG3_VALUE_TTL%2CISSUED_YEAR%2CISSUED_DT%2CLAST_STATUS_DT%2CCONST_TYPE_CODE%2CVALUE_DESC%2CACA_URL%2CUNITS%2CB1_APPL_STATUS&orderByFields=ISSUED_DT+DESC%2COBJECTID+DESC&resultRecordCount=100&returnGeometry=true&outSR=4326&f=json",
      "total_valuation_usd": 6966860.98
    },
    {
      "first_issued_date": "2025-01-07",
      "last_issued_date": "2025-12-31",
      "license": {
        "attribution": "City of Columbus, Department of Building and Zoning Services: Building Permits (opendata.columbus.gov)",
        "name": "CC0 1.0 Universal (public domain dedication)",
        "url": "https://creativecommons.org/publicdomain/zero/1.0/"
      },
      "name": "Go Permits, LLC",
      "permits": 341,
      "source_url": "https://services1.arcgis.com/9yy6msODkIBzkUXU/arcgis/rest/services/Building_Permits/FeatureServer/0/query?where=ISSUED_DT+%3E%3D+TIMESTAMP+%272025-01-01+00%3A00%3A00%27+AND+ISSUED_DT+%3C%3D+TIMESTAMP+%272025-12-31+23%3A59%3A59%27+AND+APPLICANT_BUS_NAME+%3D+%27Go+Permits%2C+LLC%27&outFields=OBJECTID%2CB1_ALT_ID%2CB1_PER_GROUP%2CB1_PER_TYPE%2CB1_PER_SUB_TYPE%2CB1_PER_CATEGORY%2CGENERAL_TYPE%2CB1_PARCEL_NBR%2CCOLS_KEY%2CSITE_ADDRESS%2CB1_SITUS_ZIP%2CPERMIT_STATUS%2CAPPLICANT_BUS_NAME%2CSQFT%2CG3_VALUE_TTL%2CISSUED_YEAR%2CISSUED_DT%2CLAST_STATUS_DT%2CCONST_TYPE_CODE%2CVALUE_DESC%2CACA_URL%2CUNITS%2CB1_APPL_STATUS&orderByFields=ISSUED_DT+DESC%2COBJECTID+DESC&resultRecordCount=100&returnGeometry=true&outSR=4326&f=json",
      "total_valuation_usd": 3812835.05
    },
    {
      "first_issued_date": "2025-01-02",
      "last_issued_date": "2025-12-16",
      "license": {
        "attribution": "City of Columbus, Department of Building and Zoning Services: Building Permits (opendata.columbus.gov)",
        "name": "CC0 1.0 Universal (public domain dedication)",
        "url": "https://creativecommons.org/publicdomain/zero/1.0/"
      },
      "name": "FEAZEL ROOFING LLC",
      "permits": 330,
      "source_url": "https://services1.arcgis.com/9yy6msODkIBzkUXU/arcgis/rest/services/Building_Permits/FeatureServer/0/query?where=ISSUED_DT+%3E%3D+TIMESTAMP+%272025-01-01+00%3A00%3A00%27+AND+ISSUED_DT+%3C%3D+TIMESTAMP+%272025-12-31+23%3A59%3A59%27+AND+APPLICANT_BUS_NAME+%3D+%27FEAZEL+ROOFING+LLC%27&outFields=OBJECTID%2CB1_ALT_ID%2CB1_PER_GROUP%2CB1_PER_TYPE%2CB1_PER_SUB_TYPE%2CB1_PER_CATEGORY%2CGENERAL_TYPE%2CB1_PARCEL_NBR%2CCOLS_KEY%2CSITE_ADDRESS%2CB1_SITUS_ZIP%2CPERMIT_STATUS%2CAPPLICANT_BUS_NAME%2CSQFT%2CG3_VALUE_TTL%2CISSUED_YEAR%2CISSUED_DT%2CLAST_STATUS_DT%2CCONST_TYPE_CODE%2CVALUE_DESC%2CACA_URL%2CUNITS%2CB1_APPL_STATUS&orderByFields=ISSUED_DT+DESC%2COBJECTID+DESC&resultRecordCount=100&returnGeometry=true&outSR=4326&f=json",
      "total_valuation_usd": 5597385.79
    },
    {
      "first_issued_date": "2025-01-02",
      "last_issued_date": "2025-12-31",
      "license": {
        "attribution": "City of Columbus, Department of Building and Zoning Services: Building Permits (opendata.columbus.gov)",
        "name": "CC0 1.0 Universal (public domain dedication)",
        "url": "https://creativecommons.org/publicdomain/zero/1.0/"
      },
      "name": "CUSTOM AIR CONDITIONING & HEATING CO",
      "permits": 310,
      "source_url": "https://services1.arcgis.com/9yy6msODkIBzkUXU/arcgis/rest/services/Building_Permits/FeatureServer/0/query?where=ISSUED_DT+%3E%3D+TIMESTAMP+%272025-01-01+00%3A00%3A00%27+AND+ISSUED_DT+%3C%3D+TIMESTAMP+%272025-12-31+23%3A59%3A59%27+AND+APPLICANT_BUS_NAME+%3D+%27CUSTOM+AIR+CONDITIONING+%26+HEATING+CO%27&outFields=OBJECTID%2CB1_ALT_ID%2CB1_PER_GROUP%2CB1_PER_TYPE%2CB1_PER_SUB_TYPE%2CB1_PER_CATEGORY%2CGENERAL_TYPE%2CB1_PARCEL_NBR%2CCOLS_KEY%2CSITE_ADDRESS%2CB1_SITUS_ZIP%2CPERMIT_STATUS%2CAPPLICANT_BUS_NAME%2CSQFT%2CG3_VALUE_TTL%2CISSUED_YEAR%2CISSUED_DT%2CLAST_STATUS_DT%2CCONST_TYPE_CODE%2CVALUE_DESC%2CACA_URL%2CUNITS%2CB1_APPL_STATUS&orderByFields=ISSUED_DT+DESC%2COBJECTID+DESC&resultRecordCount=100&returnGeometry=true&outSR=4326&f=json",
      "total_valuation_usd": 0
    }
  ],
  "source_url": "https://services1.arcgis.com/9yy6msODkIBzkUXU/arcgis/rest/services/Building_Permits/FeatureServer/0/query?where=ISSUED_DT+%3E%3D+TIMESTAMP+%272025-01-01+00%3A00%3A00%27+AND+ISSUED_DT+%3C%3D+TIMESTAMP+%272025-12-31+23%3A59%3A59%27+AND+APPLICANT_BUS_NAME+IS+NOT+NULL+AND+APPLICANT_BUS_NAME+%3C%3E+%27%27+AND+UPPER%28APPLICANT_BUS_NAME%29+NOT+IN+%28%27PROPERTY+OWNER%27%2C%27HOMEOWNER%27%2C%27HOME+OWNER%27%29&groupByFieldsForStatistics=APPLICANT_BUS_NAME&outStatistics=%5B%7B%22statisticType%22%3A%22count%22%2C%22onStatisticField%22%3A%22B1_ALT_ID%22%2C%22outStatisticFieldName%22%3A%22permits%22%7D%2C%7B%22statisticType%22%3A%22sum%22%2C%22onStatisticField%22%3A%22G3_VALUE_TTL%22%2C%22outStatisticFieldName%22%3A%22total_valuation%22%7D%2C%7B%22statisticType%22%3A%22min%22%2C%22onStatisticField%22%3A%22ISSUED_DT%22%2C%22outStatisticFieldName%22%3A%22first_issued%22%7D%2C%7B%22statisticType%22%3A%22max%22%2C%22onStatisticField%22%3A%22ISSUED_DT%22%2C%22outStatisticFieldName%22%3A%22last_issued%22%7D%5D&orderByFields=permits+DESC%2Ctotal_valuation+DESC%2CAPPLICANT_BUS_NAME&resultRecordCount=10&f=json"
}

Building permits from the City of Columbus Department of Building and Zoning Services, via opendata.columbus.gov, CC0 1.0 Universal (Public Domain Dedication). (https://opendata.columbus.gov/datasets/f7a785b863454d96a0fe3f5aa5368e7d_0/about)

Related providers

Browse the library