Alexandria
All providers
Sign in
Sign up to use Socrata open-data portals
Firecrawl Alexandria
Public records

Socrata open-data portals

Discover and query datasets on any public Socrata (Tyler Data & Insights) open-data portal: city, county and state portals such as data.cityofchicago.org, data.ny.gov, data.austintexas.gov, data.wa.gov and hundreds more. Search the cross-portal catalog (Socrata Discovery API), read a dataset's columns, row count, license and update details, and query rows with SoQL (select/where/order/group/full text). Portals are verified as Socrata domains before they are contacted. Keyless; no app token.

5 Firecrawl tools use Socrata open-data portals
Try in Agent
Find Chicago building permits issued for 1576 N Milwaukee Ave.

Try Socrata open-data portals now.

Choose an example or ask your own question.

Socrata open-data portals
TRY ASKING
1Request
stringRequired

The dataset's Socrata 4x4 id (for example ydr8-5enu, from search_datasets) or a dataset URL on the same portal: /d/<id>, /<Category>/<Name>/<id>, /resource/<id>.json.

stringRequired

The portal: its hostname (data.cityofchicago.org, data.ny.gov, www.dallasopendata.com) or any URL on it. Must be a Socrata domain served by the Socrata Discovery API (US or EU region); anything else fails with invalid_input not_socrata_portal before the host is contacted.

string

`permit_type` (with an aggregate in select).

number

Rows per page (1-1000). A page is also cut at about 1 MB of row data; continue from next_offset.

number

Row offset (next_offset of the previous page).

string

E.g. `permit_, permit_type, issue_date` or `permit_type, count(*) AS n`.

string

String literals in single quotes ('O''Hare' escapes a quote). E.g. `issue_date >= '2024-01-01' AND permit_type = 'PERMIT - NEW CONSTRUCTION'`, `within_circle(location, 41.88, -87.63, 500)`.

5 credits
Codefollows the fields above
const result = await firecrawl.scrape({
  alexandria: {
    provider: "socrata-com",
    capability: "open-data/query_dataset",
    options: {
      dataset_id: "ydr8-5enu",
      limit: 5,
      portal: "data.cityofchicago.org",
      select: "id, permit_, permit_type, issue_date, street_number, street_direction, street_name",
      where: "permit_ = '100084789'",
    },
  },
});
2Response example

This is a sample shape. Press Run to see live data from Socrata open-data portals.

{
  "columns": [
    {
      "datatype": "text",
      "field_name": "id"
    },
    {
      "datatype": "text",
      "field_name": "permit_"
    },
    {
      "datatype": "text",
      "field_name": "permit_type"
    },
    {
      "datatype": "floating_timestamp",
      "field_name": "issue_date"
    },
    {
      "datatype": "number",
      "field_name": "street_number"
    },
    {
      "datatype": "text",
      "field_name": "street_direction"
    },
    {
      "datatype": "text",
      "field_name": "street_name"
    }
  ],
  "count": 1,
  "data_last_modified": "Fri, 09 Oct 2026 12:07:11 GMT",
  "dataset_id": "ydr8-5enu",
  "limit": 5,
  "next_offset": null,
  "observed_at_ms": 1791566245239,
  "offset": 0,
  "portal": "data.cityofchicago.org",
  "rows": [
    {
      "id": "1634695",
      "issue_date": "2006-01-03T00:00:00.000",
      "permit_": "100084789",
      "permit_type": "PERMIT - SIGNS",
      "street_direction": "N",
      "street_name": "MILWAUKEE AVE",
      "street_number": "1576"
    }
  ],
  "source_url": "https://data.cityofchicago.org/resource/ydr8-5enu.json?%24select=id%2C+permit_%2C+permit_type%2C+issue_date%2C+street_number%2C+street_direction%2C+street_name&%24where=permit_+%3D+%27100084789%27&%24order=%3Aid&%24limit=5"
}

Firecrawl tools

5

Ready-made Firecrawl tools that call Socrata open-data portals.

Uses Socrata open-data portals, DataSF open data portal, US Census BureauPermit turnaround peer benchmarkUse when a city building official or permitting director must show council how long permits take versus peer cities. Finds building-permit datasets on Socrata and DataSF, computes issue times by permit type from the raw records, normalises by population and housing growth from Census data, and drafts a benchmark with method notes.8 toolsOpen
Uses Vrbo vacation rentals, Socrata open-data portals, US Census BureauShort-term rental registration gap countUse when a city housing policy analyst is estimating how many short-term rentals operate without registering. Counts active Vrbo listings in the city, pulls the official registration counts from the city or state open-data portal, and adds Census housing units for scale. Produces a gap estimate by area with the method spelled out.6 toolsOpen
Uses FDA, Socrata open-data portals, MapsSupplier recall and inspection sweep for a restaurant groupUse when a food safety or QA manager at a multi-unit restaurant group runs the weekly compliance sweep. Checks FDA food recalls against the group's key ingredients and suppliers, pulls each unit's latest public health inspection from the city open-data portal, and scans recent Maps reviews for illness or hygiene complaints. Produces an action list by location.6 toolsOpen
Uses OpenStreetMap, City of Seattle, Socrata open-data portals, US Census BureauCouncil district constituent issue briefUse when a Seattle city council legislative aide prepares for a constituent meeting or neighbourhood walk. Maps an address to its council district and member, pulls the member's recent statements, counts open 311 and code-violation records nearby from city open data, and adds local demographics, giving the aide a sourced one-pager.9 toolsOpen
Uses US Census Bureau, BLS labor statistics, CMS data.cms.gov, OpenStreetMap, Socrata open-data portals+1Community health needs assessment data packUse when a nonprofit hospital's community benefit manager starts the triennial community health needs assessment. Pulls poverty, insurance, age and language from Census data, county unemployment from BLS, local hospital quality from CMS, and access to pharmacies and groceries from the map, then adds county open-data health datasets into a sourced secondary-data pack.8 toolsOpen

Benchmarks

Public records benchmarks

Quality, speed and cost, last 24 hours, across every agent call to Socrata open-data portals through Alexandria.

Quality
93.2%
Calls answered without a tool error
Speed
13.0 s
95% of successful calls finish faster
Cost
5 credits
Firecrawl credits per call
Calls
118
Last 24 hours, every Alexandria user
Quality and speed of each tool, last 24 hours
ToolQualitySpeedCalls
Query dataset90.3%14.4 s72
Search datasets97.3%3.2 s37

Related providers

Browse the library
//
Get started
//
Give your agent Socrata open-data portals.
One API key for the live web and every provider in Alexandria.
Use Socrata open-data portalsExplore Alexandria
Are you an AI agent? See setup options