SourceFinch Verified · Company registries
Commercial Vacancy - All Properties
Recent records from Commercial Vacancy - All Properties on citydata.mesaaz.gov: up to 1,000 rows with stable identifiers for change monitoring. Contact columns are excluded.
- Healthy
- Company registries
- Citymesaaz open data
- citydata.mesaaz.gov
- Open data portal
- 11 typed fields
At a glance
- Publisher
- Citymesaaz open data · homepage
- Category
- Company registries
- Jurisdiction
- citydata.mesaaz.gov
- Publisher updates
- Updated by the publisher; typically daily or weekly
- Recommended schedule
- Daily for your monitor; SourceFinch verifies the recipe daily
- Records per run
- 697 in the latest run
- Record key
id- Acquired from
- Open data portal:
https://citydata.mesaaz.gov/resource/73s5-mf6u.json?$select=total_square_footage_occupied,direct_number_of_leasing_activity_deals,location,calendar_year,property_type,calendar_year_and_quarter,building_inventory,building_inventory_square,direct_vacant_square_footage,sublet_vacant_square_footage,direct_vacancy_rate&$limit=1000&$order=direct_number_of_leasing_activity_deals - Recipe
- v1.0.0, approved November 17, 2026
- Version notes
- First Verified version generated 2026-11-17 from batch backlog.
- Verified since
- November 17, 2026
- Last green run
- November 17, 2026
What the data contains
Open data published on citydata.mesaaz.gov as “Commercial Vacancy - All Properties”. Each daily run reads up to 1,000 rows through the portal's SODA API, naming only non-contact columns. A monitor reports new and changed rows inside the cohort. Leaving the cohort does not establish deletion. SourceFinch is independent of the publisher.
Fields and types
Every record has these fields. The key field id identifies a record across runs, so changes are reported field by field.
| Field | Type | Description |
|---|---|---|
idkey | string | Publisher field `total_square_footage_occupied`. The record key. |
direct_number_of_leasing_activity_deals | string, nullable | Publisher field `direct_number_of_leasing_activity_deals`. |
location | string, nullable | Publisher field `location`. |
calendar_year | string, nullable | Publisher field `calendar_year`. |
property_type | string, nullable | Publisher field `property_type`. |
calendar_year_and_quarter | string, nullable | Publisher field `calendar_year_and_quarter`. |
building_inventory | string, nullable | Publisher field `building_inventory`. |
building_inventory_square | string, nullable | Publisher field `building_inventory_square`. |
direct_vacant_square_footage | string, nullable | Publisher field `direct_vacant_square_footage`. |
sublet_vacant_square_footage | string, nullable | Publisher field `sublet_vacant_square_footage`. |
direct_vacancy_rate | string, nullable | Publisher field `direct_vacancy_rate`. |
Sample output
The first 5 of 697 records from SourceFinch's own run on November 17, 2026, exactly as delivered.
| Field | Record 1 | Record 2 | Record 3 | Record 4 | Record 5 |
|---|---|---|---|---|---|
id | 597899 | 598795 | 571636 | 586394 | 622698 |
direct_number_of_leasing_activity_deals | 0 | 0 | 0 | 0 | 0 |
location | Downtown Mesa | Downtown Mesa | Downtown Mesa | Downtown Mesa | Downtown Mesa |
calendar_year | 2018 | 2017 | 2009 | 2008 | 2006 |
property_type | Retail | Retail | Retail | Retail | Retail |
calendar_year_and_quarter | 2018 Q1 | 2017 Q3 | 2009 Q1 | 2008 Q4 | 2006 Q1 |
building_inventory | 102 | 102 | 104 | 104 | 103 |
building_inventory_square | 649275 | 649275 | 652424 | 652424 | 650198 |
direct_vacant_square_footage | 50476 | 50480 | 80788 | 66030 | 27500 |
sublet_vacant_square_footage | 900 | 0 | 0 | 0 | 0 |
direct_vacancy_rate | 0.078 | 0.078 | 0.124 | 0.101 | 0.042 |
Sample as JSON
[
{
"id": "597899",
"location": "Downtown Mesa",
"calendar_year": "2018",
"property_type": "Retail",
"building_inventory": "102",
"direct_vacancy_rate": "0.078",
"building_inventory_square": "649275",
"calendar_year_and_quarter": "2018 Q1",
"direct_vacant_square_footage": "50476",
"sublet_vacant_square_footage": "900",
"direct_number_of_leasing_activity_deals": "0"
},
{
"id": "598795",
"location": "Downtown Mesa",
"calendar_year": "2017",
"property_type": "Retail",
"building_inventory": "102",
"direct_vacancy_rate": "0.078",
"building_inventory_square": "649275",
"calendar_year_and_quarter": "2017 Q3",
"direct_vacant_square_footage": "50480",
"sublet_vacant_square_footage": "0",
"direct_number_of_leasing_activity_deals": "0"
},
{
"id": "571636",
"location": "Downtown Mesa",
"calendar_year": "2009",
"property_type": "Retail",
"building_inventory": "104",
"direct_vacancy_rate": "0.124",
"building_inventory_square": "652424",
"calendar_year_and_quarter": "2009 Q1",
"direct_vacant_square_footage": "80788",
"sublet_vacant_square_footage": "0",
"direct_number_of_leasing_activity_deals": "0"
},
{
"id": "586394",
"location": "Downtown Mesa",
"calendar_year": "2008",
"property_type": "Retail",
"building_inventory": "104",
"direct_vacancy_rate": "0.101",
"building_inventory_square": "652424",
"calendar_year_and_quarter": "2008 Q4",
"direct_vacant_square_footage": "66030",
"sublet_vacant_square_footage": "0",
"direct_number_of_leasing_activity_deals": "0"
},
{
"id": "622698",
"location": "Downtown Mesa",
"calendar_year": "2006",
"property_type": "Retail",
"building_inventory": "103",
"direct_vacancy_rate": "0.042",
"building_inventory_square": "650198",
"calendar_year_and_quarter": "2006 Q1",
"direct_vacant_square_footage": "27500",
"sublet_vacant_square_footage": "0",
"direct_number_of_leasing_activity_deals": "0"
}
]Evidence behind every value
- Each run keeps the publisher's exact response, hashed with SHA-256. This sample came from a response with hash
5e706c2496720f252a6571102ed5a1ccec5662d23c0ff40fbda91c7a8a116ec8. - Every value records where it came from in that response: a JSON Pointer into the retained capture.
- Each run gets a signed manifest (Ed25519) timestamped by an RFC 3161 authority: this run's manifest hash is
53950059828bd407965189360bea1062ebcbf692c83719e10c4d9a55e9a6aa33, timestamped November 17, 2026. - The compliance state at capture is recorded with the evidence: robots.txt hash and verdict, AI-preference signals, crawler identity and the usage rights below.
- Download any run as an evidence bundle (WACZ) and check it offline, without trusting SourceFinch:
sourcefinch verify-bundle run.wacz.
Terms posture and usage rights
- Terms
- Automated access permitted · publisher's terms
- robots.txt
- Allows this path · SHA-256
30b4d60d0a4dfbad… - AI-preference signals
- None observed at review
- Public record
- Yes. Municipal/state open data portal dataset 73s5-mf6u on citydata.mesaaz.gov.
- Reviewed
- November 17, 2026; next review May 17, 2027
- Licence basis
- Publisher's terms of use
- Commercial use
- Allowed
- Redistribution
- Allowed
- Attribution
- Required (text below)
Published on the citydata.mesaaz.gov open data portal for public use. Anonymous SODA API access needs no key. Portal robots.txt typically allows /resource/ with a crawl delay. Contact-name columns are not requested by this recipe.
Citymesaaz open data (citydata.mesaaz.gov). SourceFinch is independent of the publisher.
Usage rights travel with every record SourceFinch delivers (API, exports, webhooks and evidence bundles). They are our documented understanding of the publisher's stated terms, not legal advice.
Reliability
- Runs, last 30 days
- 0
- Green
- —
- Failed
- 0
- Median run time
- —
- Latest run
- success, November 17, 2026
Measured on completed runs of this recipe version across SourceFinch, anonymized, within a rolling 30-day window. First successful observation: November 17, 2026. A new recipe has only the history collected since that date; this is not a 30-day uptime guarantee.
Use it
Every surface creates the same monitor from this Verified recipe. Monitors keep record history, report field-level changes and deliver by webhook, export or email. You confirm you have the right to collect the source (rights: true).
Console
Open this recipe in the console: it preserves the reviewed URL, fields and record key. Review the latest captured sample, confirm source rights, and choose a schedule before creating your monitor.
Portable recipe
Copy into the console's Import or share a recipe panel to customize fields, types and schedules. This configuration contains no captured records or workspace IDs.
{
"schema": "sourcefinch/source@1",
"name": "Commercial Vacancy - All Properties",
"url": "https://citydata.mesaaz.gov/resource/73s5-mf6u.json?$select=total_square_footage_occupied,direct_number_of_leasing_activity_deals,location,calendar_year,property_type,calendar_year_and_quarter,building_inventory,building_inventory_square,direct_vacant_square_footage,sublet_vacant_square_footage,direct_vacancy_rate&$limit=1000&$order=direct_number_of_leasing_activity_deals",
"recipe": {
"mode": "http",
"format": "json",
"items": "[*]",
"fields": {
"id": "total_square_footage_occupied",
"location": "location",
"calendar_year": "calendar_year",
"property_type": "property_type",
"building_inventory": "building_inventory",
"direct_vacancy_rate": "direct_vacancy_rate",
"building_inventory_square": "building_inventory_square",
"calendar_year_and_quarter": "calendar_year_and_quarter",
"direct_vacant_square_footage": "direct_vacant_square_footage",
"sublet_vacant_square_footage": "sublet_vacant_square_footage",
"direct_number_of_leasing_activity_deals": "direct_number_of_leasing_activity_deals"
},
"required": [
"id"
]
},
"schedule": "daily",
"key_field": "id"
}source.json
The request body used by the API, CLI and SDK examples.
{
"name": "Commercial Vacancy - All Properties",
"url": "https://citydata.mesaaz.gov/resource/73s5-mf6u.json?$select=total_square_footage_occupied,direct_number_of_leasing_activity_deals,location,calendar_year,property_type,calendar_year_and_quarter,building_inventory,building_inventory_square,direct_vacant_square_footage,sublet_vacant_square_footage,direct_vacancy_rate&$limit=1000&$order=direct_number_of_leasing_activity_deals",
"recipe": {
"mode": "http",
"format": "json",
"items": "[*]",
"fields": {
"id": "total_square_footage_occupied",
"location": "location",
"calendar_year": "calendar_year",
"property_type": "property_type",
"building_inventory": "building_inventory",
"direct_vacancy_rate": "direct_vacancy_rate",
"building_inventory_square": "building_inventory_square",
"calendar_year_and_quarter": "calendar_year_and_quarter",
"direct_vacant_square_footage": "direct_vacant_square_footage",
"sublet_vacant_square_footage": "sublet_vacant_square_footage",
"direct_number_of_leasing_activity_deals": "direct_number_of_leasing_activity_deals"
},
"required": [
"id"
]
},
"key_field": "id",
"schedule": "daily",
"rights": true,
"catalog": {
"slug": "citydata-commercial-vacancy-all-properties",
"version_id": "a01ef57f-074e-4a13-be11-32f64180ed42"
}
}REST API
Create an API key under Console → API keys. Reference: /docs/api.
# the Verified entry (fields, recipe, sample, terms) as JSON
curl https://sourcefinch.com/v1/catalog/citydata-commercial-vacancy-all-properties -H "Authorization: Bearer $SOURCEFINCH_API_KEY"
# create the monitor from source.json (below)
curl -X POST https://sourcefinch.com/v1/sources \
-H "Authorization: Bearer $SOURCEFINCH_API_KEY" \
-H "Content-Type: application/json" \
-H "Idempotency-Key: $(uuidgen)" \
-d @source.json
# then run it now (later runs follow the schedule)
curl -X POST https://sourcefinch.com/v1/sources/$SOURCE_ID/runs \
-H "Authorization: Bearer $SOURCEFINCH_API_KEY" \
-H "Idempotency-Key: $(uuidgen)"CLI
The sourcefinch CLI is not on npm yet; see /docs/cli.
sourcefinch login
sourcefinch catalog get citydata-commercial-vacancy-all-properties --source-json > source.json
sourcefinch sources create --file source.json
sourcefinch runs create $SOURCE_ID --wait
sourcefinch records $SOURCE_IDTypeScript SDK
The SDK is not on npm yet; see /docs/sdk.
import { SourceFinch } from "@sourcefinch/sdk";
const sf = new SourceFinch({ apiKey: process.env.SOURCEFINCH_API_KEY });
const entry = await sf.catalog.get("citydata-commercial-vacancy-all-properties");
const source = await sf.sources.create({
catalog: { slug: entry.slug, version_id: entry.recipe.version_id },
name: entry.name.slice(0, 100),
url: entry.acquisition_path.endpoint,
recipe: entry.recipe.definition,
key_field: entry.recipe.key_field,
schedule: entry.recipe.schedule,
rights: true, // you confirm you have the right to collect this source
});
const run = await sf.runs.wait((await sf.runs.create(source.id)).id);
console.log(run.status);MCP
Remote MCP server with OAuth; see /docs/mcp.
claude mcp add --transport http sourcefinch https://sourcefinch.com/mcp
# then ask your agent:
"Use SourceFinch to monitor Commercial Vacancy - All Properties: get_catalog_source citydata-commercial-vacancy-all-properties,
then create_source with its create_source_args (dry run first), then run_source."Pricing
Each check is one run, whatever the number of records, and failed runs are free. On its default daily schedule this source uses about 30 runs a month, which fits the Free plan's 300 runs. It uses HTTP acquisition, so no browser runs are needed. See plans.
Related sources
More from Citymesaaz open data and in company registries.
SourceFinch is independent and is not affiliated with or endorsed by Citymesaaz open data. This page describes commercial vacancy - all properties as SourceFinch acquires it.