Firecrawl Alexandria
City of San Antonio Open Data: building permits (data.sanantonio.gov)
City of San Antonio, Texas building permits from the city's CKAN open data portal (data.sanantonio.gov): the Building Permits dataset of the Development Services Department (Land and Building Development), licensed Creative Commons Attribution (CC BY). It holds every issued building, trade (mechanical, electrical, plumbing, irrigation), repair, roof, solar, sign, tree, demolition and site permit from July 2020 to the city's latest load, over 430,000 permits. Search permits by street address, ZIP, primary contact (contractor, builder or expediter), permit or work type, issue or application date window and minimum declared valuation, newest issued, newest submitted or largest first; read one permit by number with every published column; and rank primary contacts by permits and valuation for an issue window. Garage sale permits are left out. Every response and record carries the CC BY licence with attribution to the City of San Antonio and a source URL. The dataset has no row update time, so new permits are polled with issued_since.
Try City of San Antonio Open Data: building permits (data.sanantonio.gov) now.
Choose an example or ask your own question.
TRY ASKING
Codefollows the fields above
const result = await firecrawl.scrape({
alexandria: {
provider: "data-sanantonio-gov",
capability: "building-permits/contractor_activity",
options: {
contractor: "Lennar",
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 San Antonio Open Data: building permits (data.sanantonio.gov).
{
"count": 2,
"dataset": {
"id": "building-permits",
"name": "Building Permits",
"portal": "data.sanantonio.gov",
"updated_at": "2026-10-25T04:01:50Z",
"url": "https://data.sanantonio.gov/dataset/building-permits"
},
"issued_since": "2025-01-01",
"issued_until": "2025-12-31",
"jurisdiction": {
"county": "Bexar",
"name": "San Antonio",
"state": "TX"
},
"license": {
"attribution": "City of San Antonio, Development Services Department: Building Permits, City of San Antonio Open Data Portal (data.sanantonio.gov)",
"name": "Creative Commons Attribution (CC BY)",
"url": "https://opendefinition.org/licenses/cc-by/"
},
"next_cursor": null,
"observed_at_ms": 1793149446554,
"records": [
{
"first_issued_date": "2025-01-02",
"last_issued_date": "2025-12-24",
"license": {
"attribution": "City of San Antonio, Development Services Department: Building Permits, City of San Antonio Open Data Portal (data.sanantonio.gov)",
"name": "Creative Commons Attribution (CC BY)",
"url": "https://opendefinition.org/licenses/cc-by/"
},
"name": "LENNAR HOMES",
"permits": 1209,
"source_url": "https://data.sanantonio.gov/api/3/action/datastore_search_sql?sql=SELECT+permit%2C+min%28src%29+AS+src%2C+string_agg%28DISTINCT+ptype%2C+%27%3B+%27%29+AS+permit_types%2C+max%28pname%29+AS+pname%2C+max%28wtype%29+AS+wtype%2C+max%28addr%29+AS+addr%2C+max%28x%29+AS+x%2C+max%28y%29+AS+y%2C+min%28submitted%29+AS+submitted%2C+max%28issued%29+AS+issued%2C+sum%28DISTINCT+CASE+WHEN+val+%7E+%27%5E%5B0-9%5D%2B%28%5B.%5D%5B0-9%5D%2B%29%3F%24%27+THEN+CAST%28val+AS+numeric%29+END%29+AS+valuation%2C+sum%28DISTINCT+CASE+WHEN+area+%7E+%27%5E%5B0-9%5D%2B%28%5B.%5D%5B0-9%5D%2B%29%3F%24%27+THEN+CAST%28area+AS+numeric%29+END%29+AS+area%2C+max%28contact%29+AS+contact%2C+max%28cd%29+AS+cd+FROM+%28SELECT+1+AS+src%2C+%22PERMIT+%23%22+AS+permit%2C+%22PERMIT+TYPE%22+AS+ptype%2C+%22PROJECT+NAME%22+AS+pname%2C+%22WORK+TYPE%22+AS+wtype%2C+%22ADDRESS%22+AS+addr%2C+%22X_COORD%22+AS+x%2C+%22Y_COORD%22+AS+y%2C+left%28CAST%28%22DATE+SUBMITTED%22+AS+text%29%2C+10%29+AS+submitted%2C+left%28CAST%28%22DATE+ISSUED%22+AS+text%29%2C+10%29+AS+issued%2C+%22DECLARED+VALUATION%22+AS+val%2C+%22AREA+%28SF%29%22+AS+area%2C+%22PRIMARY+CONTACT%22+AS+contact%2C+%22CD%22+AS+cd+FROM+%22c21106f9-3ef5-4f3a-8604-f992b4db7512%22%29+p+WHERE+ptype+%3C%3E+%27Garage+Sale%27+AND+upper%28contact%29+%3D+upper%28%27LENNAR+HOMES%27%29+AND+issued+%3E%3D+%272025-01-01%27+AND+issued+%3C%3D+%272025-12-31%27+GROUP+BY+permit+ORDER+BY+issued+DESC%2C+permit+DESC+LIMIT+100",
"total_valuation_usd": null
},
{
"first_issued_date": "2025-01-02",
"last_issued_date": "2025-12-19",
"license": {
"attribution": "City of San Antonio, Development Services Department: Building Permits, City of San Antonio Open Data Portal (data.sanantonio.gov)",
"name": "Creative Commons Attribution (CC BY)",
"url": "https://opendefinition.org/licenses/cc-by/"
},
"name": "COURTNEY CHAPPELL, LENNAR HOMES",
"permits": 53,
"source_url": "https://data.sanantonio.gov/api/3/action/datastore_search_sql?sql=SELECT+permit%2C+min%28src%29+AS+src%2C+string_agg%28DISTINCT+ptype%2C+%27%3B+%27%29+AS+permit_types%2C+max%28pname%29+AS+pname%2C+max%28wtype%29+AS+wtype%2C+max%28addr%29+AS+addr%2C+max%28x%29+AS+x%2C+max%28y%29+AS+y%2C+min%28submitted%29+AS+submitted%2C+max%28issued%29+AS+issued%2C+sum%28DISTINCT+CASE+WHEN+val+%7E+%27%5E%5B0-9%5D%2B%28%5B.%5D%5B0-9%5D%2B%29%3F%24%27+THEN+CAST%28val+AS+numeric%29+END%29+AS+valuation%2C+sum%28DISTINCT+CASE+WHEN+area+%7E+%27%5E%5B0-9%5D%2B%28%5B.%5D%5B0-9%5D%2B%29%3F%24%27+THEN+CAST%28area+AS+numeric%29+END%29+AS+area%2C+max%28contact%29+AS+contact%2C+max%28cd%29+AS+cd+FROM+%28SELECT+1+AS+src%2C+%22PERMIT+%23%22+AS+permit%2C+%22PERMIT+TYPE%22+AS+ptype%2C+%22PROJECT+NAME%22+AS+pname%2C+%22WORK+TYPE%22+AS+wtype%2C+%22ADDRESS%22+AS+addr%2C+%22X_COORD%22+AS+x%2C+%22Y_COORD%22+AS+y%2C+left%28CAST%28%22DATE+SUBMITTED%22+AS+text%29%2C+10%29+AS+submitted%2C+left%28CAST%28%22DATE+ISSUED%22+AS+text%29%2C+10%29+AS+issued%2C+%22DECLARED+VALUATION%22+AS+val%2C+%22AREA+%28SF%29%22+AS+area%2C+%22PRIMARY+CONTACT%22+AS+contact%2C+%22CD%22+AS+cd+FROM+%22c21106f9-3ef5-4f3a-8604-f992b4db7512%22%29+p+WHERE+ptype+%3C%3E+%27Garage+Sale%27+AND+upper%28contact%29+%3D+upper%28%27COURTNEY+CHAPPELL%2C+LENNAR+HOMES%27%29+AND+issued+%3E%3D+%272025-01-01%27+AND+issued+%3C%3D+%272025-12-31%27+GROUP+BY+permit+ORDER+BY+issued+DESC%2C+permit+DESC+LIMIT+100",
"total_valuation_usd": null
}
],
"source_url": "https://data.sanantonio.gov/api/3/action/datastore_search_sql?sql=SELECT+max%28contact%29+AS+contact%2C+count%28*%29+AS+permits%2C+sum%28valuation%29+AS+valuation%2C+min%28issued%29+AS+first_issued%2C+max%28issued%29+AS+last_issued+FROM+%28SELECT+permit%2C+max%28contact%29+AS+contact%2C+max%28issued%29+AS+issued%2C+sum%28DISTINCT+CASE+WHEN+val+%7E+%27%5E%5B0-9%5D%2B%28%5B.%5D%5B0-9%5D%2B%29%3F%24%27+THEN+CAST%28val+AS+numeric%29+END%29+AS+valuation+FROM+%28SELECT+1+AS+src%2C+%22PERMIT+%23%22+AS+permit%2C+%22PERMIT+TYPE%22+AS+ptype%2C+%22PROJECT+NAME%22+AS+pname%2C+%22WORK+TYPE%22+AS+wtype%2C+%22ADDRESS%22+AS+addr%2C+%22X_COORD%22+AS+x%2C+%22Y_COORD%22+AS+y%2C+left%28CAST%28%22DATE+SUBMITTED%22+AS+text%29%2C+10%29+AS+submitted%2C+left%28CAST%28%22DATE+ISSUED%22+AS+text%29%2C+10%29+AS+issued%2C+%22DECLARED+VALUATION%22+AS+val%2C+%22AREA+%28SF%29%22+AS+area%2C+%22PRIMARY+CONTACT%22+AS+contact%2C+%22CD%22+AS+cd+FROM+%22c21106f9-3ef5-4f3a-8604-f992b4db7512%22%29+p+WHERE+ptype+%3C%3E+%27Garage+Sale%27+AND+contact+IS+NOT+NULL+AND+contact+%3C%3E+%27NULL%27+AND+issued+%3E%3D+%272025-01-01%27+AND+issued+%3C%3D+%272025-12-31%27+AND+contact+ILIKE+%27%25Lennar%25%27+GROUP+BY+permit%29+g+GROUP+BY+upper%28contact%29+ORDER+BY+permits+DESC%2C+valuation+DESC+NULLS+LAST%2C+upper%28contact%29+LIMIT+5"
}Building Permits from the City of San Antonio Development Services Department, via the City of San Antonio Open Data Portal (data.sanantonio.gov), CC BY. (https://data.sanantonio.gov/dataset/building-permits)