Skip to main content
fastCRW Pergamon
Public records · US

DataSF

data.sf.gov

San Francisco's open data portal.

Showing the catalogue

1Request

Exact operating carrier name.

Exact marketing carrier name.

1 credit⌘ ↵
Code follows the fields above
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.

JSON
[
  {
    "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>