--- type: "firecrawl-provider" description: "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." use_when: "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." categories: "Real estate" capabilities: 3 credits_per_call: 5 --- # City of Columbus Building Permits (opendata.columbus.gov) on Firecrawl Alexandria 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. - Categories: Real estate - Category index: [Real estate category](https://firecrawl.dev/alexandria/agents/categories/real-estate) - Provider key: `opendata-columbus-gov` - Access: Firecrawl credits - Cost: 5 credits per call ## More - [Human guide](https://firecrawl.dev/app/alexandria/opendata-columbus-gov) - [OpenAPI spec](https://firecrawl.dev/alexandria/agents/providers/opendata-columbus-gov/openapi.json) ## Capabilities - [Contractor activity](https://firecrawl.dev/alexandria/agents/providers/opendata-columbus-gov/building-permits/contractor_activity): Rank the applicant businesses on City of Columbus building permits issued in a date window by permits, then total declared value, in one grouped ArcGIS statistics request. Optional permit type words and ZIP. Permits without a business name or pulled by the property owner (PROPERTY OWNER, HOMEOWNER) are left out. Each row links to that business's permits. For trade permits the applicant is the contractor of record; spellings of one firm stay separate. A window with no named business is a successful result with count 0. - [Get permit](https://firecrawl.dev/alexandria/agents/providers/opendata-columbus-gov/building-permits/get_permit): Read one City of Columbus building permit by its record number: the shared permit record plus raw, the layer's row exactly as published (every column except the applicant's personal name, epoch-millisecond dates as published), and the dataset. An unknown permit number is not_found. - [Search permits](https://firecrawl.dev/alexandria/agents/providers/opendata-columbus-gov/building-permits/search_permits): Search City of Columbus building permits (Department of Building and Zoning Services, 2010 to date, about 690,000 permits, reloaded nightly) by site address, ZIP, Franklin County parcel, applicant business (usually the contractor), permit type or work category, status, issue-date window, latest status-change date and minimum job value. Newest issued first by default, or most recent status change, or largest value. Each record has the shared permit shape (number, type, kind, work category, status, issued, completed and expired dates, address, coordinates, parcel, value, units, square feet, applicant business, Citizen Access link, licence). An empty page is a valid result. ## 1. Choose this provider when 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. ## 2. Minimal request Call `POST https://api.firecrawl.dev/v2/scrape` with `{ alexandria: { provider, capability, options } }`. For a batch, send `{ alexandria: [...] }` with up to 10 calls. ```json { "provider": "opendata-columbus-gov", "capability": "building-permits/contractor_activity", "options": { "issued_since": "2025-01-01", "issued_until": "2025-12-31", "limit": 10 } } ``` ## 3. Add provider options Use only the options needed for the task: - `cursor` (string): The next_cursor of the previous page; repeat the same filters with it. Pattern: ^[0-9]{1,7}$. Example: `` - `issued_since` (string, required): First issue date, inclusive (YYYY-MM-DD). Pattern: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$. Example: `` - `issued_until` (string): Last issue date, inclusive (YYYY-MM-DD); open-ended when omitted. Pattern: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$. Example: `` - `limit` (number): Records per page. Example: `25` - `permit_type` (string): Case-insensitive substring over property class, permit kind, work category, general type and Census category: new structure, demolition, roof, plumbing, mechanical, fire protection, sign, commercial, multi family, single family houses detached, five or more family. Example: `` - `zip` (string): Five-digit site ZIP code, for example 43215. Pattern: ^[0-9]{5}$. Example: `` ## 4. Request through your preferred interface ### JavaScript ```javascript 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, }, }, }); ``` ### Python ```python result = 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 } }) ``` ### cURL ```sh curl https://api.firecrawl.dev/v2/scrape \ -H "Authorization: Bearer $FIRECRAWL_API_KEY" \ -H "Content-Type: application/json" \ -d '{ "alexandria": { "provider": "opendata-columbus-gov", "capability": "building-permits/contractor_activity", "options": { "issued_since": "2025-01-01", "issued_until": "2025-12-31", "limit": 10 } } }' ``` ### CLI ```sh firecrawl scrape 'opendata-columbus-gov/building-permits/contractor_activity' \ --options '{"issued_since":"2025-01-01","issued_until":"2025-12-31","limit":10}' ``` ### MCP Call the FCX MCP retrieve tool with this object: ```json { "provider": "opendata-columbus-gov", "capability": "building-permits/contractor_activity", "options": { "issued_since": "2025-01-01", "issued_until": "2025-12-31", "limit": 10 } } ``` Ask for only the returned fields needed by the task. ## 5. Full request shape ```json { "provider": "opendata-columbus-gov", "capability": "building-permits/contractor_activity", "options": { "issued_since": "2025-01-01", "issued_until": "2025-12-31", "limit": 10 } } ``` ## 6. Response data The response includes `success`, `provider`, `capability`, `creditsCost` and `data`. This example shows the provider payload in `data`: ```json { "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" } ``` ## API reference-derived contract The following capability contract is generated from the same normalized Alexandria API reference exposed in the API spec. ### Contractor activity - Capability: `building-permits/contractor_activity` - Description: Rank the applicant businesses on City of Columbus building permits issued in a date window by permits, then total declared value, in one grouped ArcGIS statistics request. Optional permit type words and ZIP. Permits without a business name or pulled by the property owner (PROPERTY OWNER, HOMEOWNER) are left out. Each row links to that business's permits. For trade permits the applicant is the contractor of record; spellings of one firm stay separate. A window with no named business is a successful result with count 0. - Instructions: Who is most active in Columbus for a permit type, ZIP or period; contractor market share; finding a contractor's exact published name before searching its permits with search_permits contractor. - Cost: 5 credits per call - Capability file: [Contractor activity](https://firecrawl.dev/alexandria/agents/providers/opendata-columbus-gov/building-permits/contractor_activity) Accepted options: - `cursor` (string): The next_cursor of the previous page; repeat the same filters with it. Pattern: ^[0-9]{1,7}$. Example: `` - `issued_since` (string, required): First issue date, inclusive (YYYY-MM-DD). Pattern: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$. Example: `` - `issued_until` (string): Last issue date, inclusive (YYYY-MM-DD); open-ended when omitted. Pattern: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$. Example: `` - `limit` (number): Records per page. Example: `25` - `permit_type` (string): Case-insensitive substring over property class, permit kind, work category, general type and Census category: new structure, demolition, roof, plumbing, mechanical, fire protection, sign, commercial, multi family, single family houses detached, five or more family. Example: `` - `zip` (string): Five-digit site ZIP code, for example 43215. Pattern: ^[0-9]{5}$. Example: `` Response schema example: ```json { "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" } ``` ### Get permit - Capability: `building-permits/get_permit` - Description: Read one City of Columbus building permit by its record number: the shared permit record plus raw, the layer's row exactly as published (every column except the applicant's personal name, epoch-millisecond dates as published), and the dataset. An unknown permit number is not_found. - Instructions: A permit number from search_permits, a Citizen Access page or a document, when the published columns (milestone, Census construction code, last status date, issue year) are needed. - Cost: 5 credits per call - Capability file: [Get permit](https://firecrawl.dev/alexandria/agents/providers/opendata-columbus-gov/building-permits/get_permit) Accepted options: - `permit_number` (string, required): City record number, letters and digits, case-insensitive: NEWM2322813, PMEPR2643164. Pattern: ^ *[A-Za-z0-9-]{4,30} *$. Example: `` Response schema example: ```json { "address": "1357 EDGEHILL RD", "applied_date": null, "city": "Columbus", "completed_date": "2024-10-29", "contractors": [ { "company": "Archall Architects", "license_number": null, "name": null, "phone": null, "role": "applicant" } ], "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" }, "description": "Five or More Family Buildings", "expires_date": null, "housing_units": 276, "issued_date": "2023-09-18", "jurisdiction": { "county": "Franklin", "name": "Columbus", "state": "OH" }, "latitude": 39.987036, "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/" }, "longitude": -83.029564, "observed_at_ms": 1793149071244, "parcel_id": "010062664", "permit_class": "Structural", "permit_number": "NEWM2322813", "permit_type": "Multi Family", "raw": { "ACA_URL": "https://ca.columbus.gov/permits/urlrouting.ashx?type=1000&Module=Building&capID1=23CAP&capID2=00000&capID3=00MQ9&AgencyCode=COLUMBUS", "APPLICANT_BUS_NAME": "Archall Architects", "B1_ALT_ID": "NEWM2322813", "B1_APPL_STATUS": "Closed", "B1_PARCEL_NBR": "010062664", "B1_PER_CATEGORY": "New Structure", "B1_PER_GROUP": "Building", "B1_PER_SUB_TYPE": "Structural", "B1_PER_TYPE": "Multi Family", "B1_SITUS_ZIP": "43212", "COLS_KEY": 1701231, "CONST_TYPE_CODE": "105", "G3_VALUE_TTL": 47000000, "GENERAL_TYPE": "Multi Family - New Structure", "ISSUED_DT": 1694995200000, "ISSUED_YEAR": 2023, "LAST_STATUS_DT": 1730160000000, "OBJECTID": 153425, "PERMIT_STATUS": "Certificate of Occupancy Issued", "SITE_ADDRESS": "1357 EDGEHILL RD", "SQFT": 277474, "UNITS": 276, "VALUE_DESC": "Five or More Family Buildings" }, "source_url": "https://ca.columbus.gov/permits/urlrouting.ashx?type=1000&Module=Building&capID1=23CAP&capID2=00000&capID3=00MQ9&AgencyCode=COLUMBUS", "square_feet": 277474, "state": "OH", "status": "Closed", "valuation_usd": 47000000, "work_class": "New Structure", "zip": "43212" } ``` ### Search permits - Capability: `building-permits/search_permits` - Description: Search City of Columbus building permits (Department of Building and Zoning Services, 2010 to date, about 690,000 permits, reloaded nightly) by site address, ZIP, Franklin County parcel, applicant business (usually the contractor), permit type or work category, status, issue-date window, latest status-change date and minimum job value. Newest issued first by default, or most recent status change, or largest value. Each record has the shared permit shape (number, type, kind, work category, status, issued, completed and expired dates, address, coordinates, parcel, value, units, square feet, applicant business, Citizen Access link, licence). An empty page is a valid result. - Instructions: Permit history at a Columbus address or parcel, a contractor's jobs, new construction or demolitions, large projects above a value, or polling: pass issued_since (the last day you checked) for newly issued permits, or updated_since with sort updated_desc for permits whose status changed (issued, finaled, expired). The layer reloads nightly. For contractor rankings use contractor_activity; for one permit's published row use get_permit. - Cost: 5 credits per call - Capability file: [Search permits](https://firecrawl.dev/alexandria/agents/providers/opendata-columbus-gov/building-permits/search_permits) Accepted options: - `address` (string): Site street address, case-insensitive, words matched in order: 1357 Edgehill Rd, 788 E Columbus St, Olentangy River. Only the part before a comma is used; spelled-out directions and a trailing street type become the City's abbreviations (West -> W, Road -> RD, Avenue -> AVE) and a leading house number is matched exactly, so 788 does not match 1788. Example: `
` - `contractor` (string): Case-insensitive substring of the applicant business name (APPLICANT_BUS_NAME), for example Atlas Butler, Eco Plumbers, Rosati Windows. Personal applicant names are not searched. Example: `` - `cursor` (string): The next_cursor of the previous page; repeat the same filters with it. Pattern: ^[0-9]{1,7}$. Example: `` - `issued_since` (string): First issue date, inclusive (YYYY-MM-DD). Poll for newly issued permits with this. Pattern: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$. Example: `` - `issued_until` (string): Last issue date, inclusive (YYYY-MM-DD). Pattern: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$. Example: `` - `limit` (number): Records per page. Example: `25` - `min_valuation` (number): Only permits whose declared job value is at least this many US dollars. Example: `10` - `parcel_id` (string): Franklin County parcel number, with or without dashes and the 2-digit suffix: 010-062664-00, 010-062664 or 010062664. Pattern: ^ *[0-9]{3}-?[0-9]{6}(-?[0-9]{2})? *$. Example: `` - `permit_type` (string): Case-insensitive substring over property class, permit kind, work category, general type and Census category: new structure, demolition, roof, plumbing, mechanical, fire protection, sign, commercial, multi family, single family houses detached, five or more family. Example: `` - `sort` (string): issued_desc: newest issue date first; updated_desc: most recent status change first; valuation_desc: largest declared value first. Missing values sort last. Example: `issued_desc` - `status` (string): Case-insensitive substring over record status and milestone: issued, closed, expired, void, final inspection, certificate of occupancy. Example: `` - `updated_since` (string): YYYY-MM-DD or RFC 3339 timestamp (its day is used): only permits whose latest status change (LAST_STATUS_DT: issued, closed after final inspection, expired, voided) is on or after that day. It is a per-record business date, not a load timestamp: in October 2026 about 2,000 permits issued before October changed status. Pattern: ^[0-9]{4}-[0-9]{2}-[0-9]{2}([Tt ][0-9]{2}:[0-9]{2}:[0-9]{2}(\.[0-9]+)?([Zz]|[+-][0-9]{2}:[0-9]{2}))?$. Example: `` - `zip` (string): Five-digit site ZIP code, for example 43215. Pattern: ^[0-9]{5}$. Example: `` Response schema example: ```json { "count": 8, "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" }, "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": null, "observed_at_ms": 1793149066381, "records": [ { "address": "1357 EDGEHILL RD", "applied_date": null, "city": "Columbus", "completed_date": "2025-08-06", "contractors": [ { "company": "Romanoff Group", "license_number": null, "name": null, "phone": null, "role": "applicant" } ], "description": null, "expires_date": null, "housing_units": null, "issued_date": "2024-10-24", "latitude": 39.987036, "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/" }, "longitude": -83.029564, "parcel_id": "010062664", "permit_class": "Fire Protection", "permit_number": "FALRM2439553", "permit_type": "Multi Family", "source_url": "https://ca.columbus.gov/permits/urlrouting.ashx?type=1000&Module=Building&capID1=24CAP&capID2=00000&capID3=0139Q&AgencyCode=COLUMBUS", "square_feet": null, "state": "OH", "status": "Closed", "valuation_usd": 0, "work_class": "Fire Alarm", "zip": "43212" }, { "address": "1357 EDGEHILL RD", "applied_date": null, "city": "Columbus", "completed_date": "2025-08-04", "contractors": [ { "company": "ROMANOFF HEATING & COOLING LLC", "license_number": null, "name": null, "phone": null, "role": "applicant" } ], "description": null, "expires_date": null, "housing_units": null, "issued_date": "2024-10-11", "latitude": 39.987036, "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/" }, "longitude": -83.029564, "parcel_id": "010062664", "permit_class": "MEP", "permit_number": "MMEPM2441208", "permit_type": "Multi Family", "source_url": "https://ca.columbus.gov/permits/urlrouting.ashx?type=1000&Module=Building&capID1=24CAP&capID2=00000&capID3=0155O&AgencyCode=COLUMBUS", "square_feet": null, "state": "OH", "status": "Closed", "valuation_usd": 0, "work_class": "Mechanical", "zip": "43212" }, { "address": "1357 EDGEHILL RD", "applied_date": null, "city": "Columbus", "completed_date": "2024-10-29", "contractors": [ { "company": "BEREAN ELECTRIC", "license_number": null, "name": null, "phone": null, "role": "applicant" } ], "description": null, "expires_date": null, "housing_units": null, "issued_date": "2024-09-23", "latitude": 39.987036, "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/" }, "longitude": -83.029564, "parcel_id": "010062664", "permit_class": "MEP", "permit_number": "EMEPC2438246", "permit_type": "Commercial", "source_url": "https://ca.columbus.gov/permits/urlrouting.ashx?type=1000&Module=Building&capID1=24CAP&capID2=00000&capID3=011UE&AgencyCode=COLUMBUS", "square_feet": null, "state": "OH", "status": "Closed", "valuation_usd": 0, "work_class": "Electrical", "zip": "43212" }, { "address": "1357 EDGEHILL RD", "applied_date": null, "city": "Columbus", "completed_date": "2025-07-16", "contractors": [ { "company": "Mongiovi and Son Fire Protection Services LP.", "license_number": null, "name": null, "phone": null, "role": "applicant" } ], "description": null, "expires_date": null, "housing_units": null, "issued_date": "2024-09-19", "latitude": 39.987036, "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/" }, "longitude": -83.029564, "parcel_id": "010062664", "permit_class": "Fire Protection", "permit_number": "FSUPM2435582", "permit_type": "Multi Family", "source_url": "https://ca.columbus.gov/permits/urlrouting.ashx?type=1000&Module=Building&capID1=24CAP&capID2=00000&capID3=00YW3&AgencyCode=COLUMBUS", "square_feet": null, "state": "OH", "status": "Closed", "valuation_usd": 0, "work_class": "Fire Suppression", "zip": "43212" }, { "address": "1357 EDGEHILL RD", "applied_date": null, "city": "Columbus", "completed_date": "2025-08-05", "contractors": [ { "company": "TG PLUMBING & MECHANICAL INC", "license_number": null, "name": null, "phone": null, "role": "applicant" } ], "description": null, "expires_date": null, "housing_units": null, "issued_date": "2024-08-01", "latitude": 39.987036, "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/" }, "longitude": -83.029564, "parcel_id": "010062664", "permit_class": "MEP", "permit_number": "MMEPC2430518", "permit_type": "Commercial", "source_url": "https://ca.columbus.gov/permits/urlrouting.ashx?type=1000&Module=Building&capID1=24CAP&capID2=00000&capID3=00TQH&AgencyCode=COLUMBUS", "square_feet": null, "state": "OH", "status": "Closed", "valuation_usd": 0, "work_class": "Mechanical", "zip": "43212" }, { "address": "1357 EDGEHILL RD", "applied_date": null, "city": "Columbus", "completed_date": "2025-08-06", "contractors": [ { "company": "ROMANOFF ELECTRIC INC", "license_number": null, "name": null, "phone": null, "role": "applicant" } ], "description": null, "expires_date": null, "housing_units": null, "issued_date": "2024-07-25", "latitude": 39.987036, "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/" }, "longitude": -83.029564, "parcel_id": "010062664", "permit_class": "MEP", "permit_number": "EMEPM2429980", "permit_type": "Multi Family", "source_url": "https://ca.columbus.gov/permits/urlrouting.ashx?type=1000&Module=Building&capID1=24CAP&capID2=00000&capID3=00TBM&AgencyCode=COLUMBUS", "square_feet": null, "state": "OH", "status": "Closed", "valuation_usd": 0, "work_class": "Electrical", "zip": "43212" }, { "address": "1357 EDGEHILL RD", "applied_date": null, "city": "Columbus", "completed_date": "2025-08-15", "contractors": [ { "company": "TG Plumbing & Mechanical, Inc", "license_number": null, "name": null, "phone": null, "role": "applicant" } ], "description": null, "expires_date": null, "housing_units": null, "issued_date": "2024-07-03", "latitude": 39.987036, "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/" }, "longitude": -83.029564, "parcel_id": "010062664", "permit_class": "MEP", "permit_number": "PMEPM2427611", "permit_type": "Multi Family", "source_url": "https://ca.columbus.gov/permits/urlrouting.ashx?type=1000&Module=Building&capID1=24CAP&capID2=00000&capID3=00QY1&AgencyCode=COLUMBUS", "square_feet": null, "state": "OH", "status": "Closed", "valuation_usd": 0, "work_class": "Plumbing", "zip": "43212" }, { "address": "1357 EDGEHILL RD", "applied_date": null, "city": "Columbus", "completed_date": "2024-10-29", "contractors": [ { "company": "Archall Architects", "license_number": null, "name": null, "phone": null, "role": "applicant" } ], "description": "Five or More Family Buildings", "expires_date": null, "housing_units": 276, "issued_date": "2023-09-18", "latitude": 39.987036, "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/" }, "longitude": -83.029564, "parcel_id": "010062664", "permit_class": "Structural", "permit_number": "NEWM2322813", "permit_type": "Multi Family", "source_url": "https://ca.columbus.gov/permits/urlrouting.ashx?type=1000&Module=Building&capID1=23CAP&capID2=00000&capID3=00MQ9&AgencyCode=COLUMBUS", "square_feet": 277474, "state": "OH", "status": "Closed", "valuation_usd": 47000000, "work_class": "New Structure", "zip": "43212" } ], "source_url": "https://services1.arcgis.com/9yy6msODkIBzkUXU/arcgis/rest/services/Building_Permits/FeatureServer/0/query?where=UPPER%28SITE_ADDRESS%29+LIKE+%271357+%25EDGEHILL%25RD%25%27+ESCAPE+%27%5C%27+AND+ISSUED_DT+%3C%3D+TIMESTAMP+%272024-12-31+23%3A59%3A59%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=25&returnGeometry=true&outSR=4326&f=json" } ```