DataSF
data.sf.gov
San Francisco's open data portal.
GET /v1/data/datasf/air-traffic-passengers1Request
Exact operating carrier name.
Exact marketing carrier name.
curl "https://api.fastcrw.com/v1/data/datasf/air-traffic-passengers" \ -H "Authorization: Bearer $FASTCRW_API_KEY"
2Response example
A sample shape. Press Run to see live data from DataSF.
[
{
"activity_period": "202608",
"activity_period_start_date": "2026-08-01T00:00:00.000",
"operating_airline": "United Airlines",
"operating_airline_iata_code": "UA",
"published_airline": "United Airlines",
"published_airline_iata_code": "UA",
"geo_summary": "Domestic",
"geo_region": "US",
"activity_type_code": "Thru / Transit",
"price_category_code": "Other",
"terminal": "Terminal 3",
"boarding_area": "F",
"passenger_count": "2548",
"data_as_of": "2026-09-20T13:00:18.000",
"data_loaded_at": "2026-10-20T15:05:41.000"
},
{
"activity_period": "202608",
"activity_period_start_date": "2026-08-01T00:00:00.000",
"operating_airline": "United Airlines",
"operating_airline_iata_code": "UA",
"published_airline": "United Airlines",
"published_airline_iata_code": "UA",
"geo_summary": "International",
"geo_region": "Asia",
"activity_type_code": "Deplaned",
"price_category_code": "Other",
"terminal": "International",
"boarding_area": "A",
"passenger_count": "1178",
"data_as_of": "2026-09-20T13:00:18.000",
"data_loaded_at": "2026-10-20T15:05:41.000"
},
"… 198 more items"
]Attribution: Source: DataSF
Licence: DataSF terms of use: public data provided as-is for any lawful purpose.
Ask with this source
A prompt for your agent that names this source and how to call it through the crw MCP.
SFO air traffic passenger statistics
Use DataSF (datasf) from fastCRW Pergamon, capability "SFO air traffic passenger statistics" (air-traffic-passengers). You want monthly passenger volumes through San Francisco International Airport by airline, region or terminal. Example options: operating_airline=United Airlines, published_airline=United Airlines, geo_summary=International. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "datasf" and capability "air-traffic-passengers". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
Building and construction permits
Use DataSF (datasf) from fastCRW Pergamon, capability "Building and construction permits" (building-permits). You want San Francisco construction, electrical or plumbing permit filings and how long they took to issue. Example options: recordtype=Electrical permit (standard), status_detail=Active - Issued, permit_issued=Building Permit. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "datasf" and capability "building-permits". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
Registered business locations
Use DataSF (datasf) from fastCRW Pergamon, capability "Registered business locations" (business-locations). You want San Francisco business registrations — who is operating where, when they opened and whether they have closed. Example options: city=San Francisco, state=CA, business_zip=94110. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "datasf" and capability "business-locations". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
Dataset metadata and schema
Use DataSF (datasf) from fastCRW Pergamon, capability "Dataset metadata and schema" (dataset-metadata). You have a four-by-four id and need the exact column field names and types before writing a SoQL filter or query. Example options: dataset=vw6y-z8j6. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "datasf" and capability "dataset-metadata". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
