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.

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.

5 credits
Codefollows the fields above
const result = await firecrawl.scrape({
  alexandria: {
    provider: "socrata-com",
    capability: "open-data/describe_dataset",
    options: {
      dataset_id: "ydr8-5enu",
      portal: "data.cityofchicago.org",
    },
  },
});
2Response example

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

Long values are shortened in this preview. The full response is 24 KB.

{
  "api_url": "https://data.cityofchicago.org/resource/ydr8-5enu.json",
  "asset_type": "dataset",
  "attribution": "City of Chicago",
  "attribution_link": "http://www.cityofchicago.org",
  "category": "Buildings",
  "column_count": 122,
  "columns": [
    {
      "datatype": "text",
      "description": "Unique database record identifier",
      "field_name": "id",
      "name": "ID"
    },
    {
      "datatype": "text",
      "description": "Tracking number assigned at beginning of permit application process",
      "field_name": "permit_",
      "name": "PERMIT#"
    },
    {
      "datatype": "text",
      "description": "Current status of permit (not available for all permit types).",
      "field_name": "permit_status",
      "name": "PERMIT_STATUS"
    },
    {
      "datatype": "text",
      "description": "Current milestone of permit (not available for all permit types).",
      "field_name": "permit_milestone",
      "name": "PERMIT_MILESTONE"
    },
    {
      "datatype": "text",
      "description": "Type of permit",
      "field_name": "permit_type",
      "name": "PERMIT_TYPE"
    },
    {
      "datatype": "text",
      "description": "Process used to review permit application",
      "field_name": "review_type",
      "name": "REVIEW_TYPE"
    },
    {
      "datatype": "calendar_date",
      "description": "Date when City began reviewing permit application",
      "field_name": "application_start_date",
      "name": "APPLICATION_START_DATE"
    },
    {
      "datatype": "calendar_date",
      "description": "For most permit types, date when City determined permit was ready to issue, subject to payment of permit fees; For Express Permit Program, date when permit issued based on full payment of applicable permit fee",
      "field_name": "issue_date",
      "name": "ISSUE_DATE"
    },
    {
      "datatype": "number",
      "description": "Number of days between APPLICATION_START_DATE and ISSUE_DATE",
      "field_name": "processing_time",
      "name": "PROCESSING_TIME"
    },
    {
      "datatype": "number",
      "description": "Address number - for buildings with address ranges, primary address is used",
      "field_name": "street_number",
      "name": "STREET_NUMBER"
    },
    {
      "datatype": "text",
      "description": "Street direction",
      "field_name": "street_direction",
      "name": "STREET_DIRECTION"
    },
    {
      "datatype": "text",
      "description": "Street name",
      "field_name": "street_name",
      "name": "STREET_NAME"
    },
    {
      "datatype": "text",
      "description": "Classification of activity authorized by permit (not available for all permit types).",
      "field_name": "work_type",
      "name": "WORK_TYPE"
    },
    {
      "datatype": "text",
      "description": "Description of work authorized by the permit",
      "field_name": "work_description",
      "name": "WORK_DESCRIPTION"
    },
    {
      "datatype": "text",
      "description": "Conditions or comments added by reviewing department(s)",
      "field_name": "permit_condition",
      "name": "PERMIT_CONDITION"
    },
    {
      "datatype": "number",
      "description": "Amount of building permit fees received",
      "field_name": "building_fee_paid",
      "name": "BUILDING_FEE_PAID"
    },
    {
      "datatype": "number",
      "description": "Amount of zoning review fees received",
      "field_name": "zoning_fee_paid",
      "name": "ZONING_FEE_PAID"
    },
    {
      "datatype": "number",
      "description": "Amount of other permit-related fees received",
      "field_name": "other_fee_paid",
      "name": "OTHER_FEE_PAID"
    },
    {
      "datatype": "number",
      "description": "Sum of BUILDING_FEE_PAID, ZONING_FEE_PAID and OTHER_FEE_PAID",
      "field_name": "subtotal_paid",
      "name": "SUBTOTAL_PAID"
    },
    {
      "datatype": "number",
      "description": "Amount of building permit fees due",
      "field_name": "building_fee_unpaid",
      "name": "BUILDING_FEE_UNPAID"
    },
    {
      "datatype": "number",
      "description": "Amount of zoning review fees due",
      "field_name": "zoning_fee_unpaid",
      "name": "ZONING_FEE_UNPAID"
    },
    {
      "datatype": "number",
      "description": "Amount of other permit-related fees due",
      "field_name": "other_fee_unpaid",
      "name": "OTHER_FEE_UNPAID"
    },
    {
      "datatype": "number",
      "description": "Sum of BUILDING_FEE_UNPAID, ZONING_FEE_UNPAID and OTHER_FEE_UNPAID",
      "field_name": "subtotal_unpaid",
      "name": "SUBTOTAL_UNPAID"
    },
    {
      "datatype": "number",
      "description": "Amount of building permit fees waived",
      "field_name": "building_fee_waived",
      "name": "BUILDING_FEE_WAIVED"
    },
    {
      "datatype": "number",
      "description": "Sum of BUILDING_FEE_PAID, BUILDING_FEE_UNPAID and BUILDING_FEE_WAIVED",
      "field_name": "building_fee_subtotal",
      "name": "BUILDING_FEE_SUBTOTAL"
    },
    {
      "datatype": "number",
      "description": "Sum of ZONING_FEE_PAID, ZONING _FEE_UNPAID and ZONING _FEE_WAIVED",
      "field_name": "zoning_fee_subtotal",
      "name": "ZONING_FEE_SUBTOTAL"
    },
    {
      "datatype": "number",
      "description": "Sum of OTHER_FEE_PAID, OTHER _FEE_UNPAID and OTHER _FEE_WAIVED",
      "field_name": "other_fee_subtotal",
      "name": "OTHER_FEE_SUBTOTAL"
    },
    {
      "datatype": "number",
      "description": "Amount of zoning review fees waived",
      "field_name": "zoning_fee_waived",
      "name": "ZONING_FEE_WAIVED"
    },
    {
      "datatype": "number",
      "description": "Amount of other permit-related fees waived",
      "field_name": "other_fee_waived",
      "name": "OTHER_FEE_WAIVED"
    },
    {
      "datatype": "number",
      "description": "Sum of BUILDING_FEE_WAIVED, ZONING_FEE_WAIVED and OTHER_FEE_WAIVED",
      "field_name": "subtotal_waived",
      "name": "SUBTOTAL_WAIVED"
    },
    {
      "datatype": "number",
      "description": "Sum of SUBTOTAL_PAID, SUBTOTAL_UNPAID and SUBTOTAL_WAIVED",
      "field_name": "total_fee",
      "name": "TOTAL_FEE"
    },
    {
      "datatype": "text",
      "description": "Contact 1's relationship to permit",
      "field_name": "contact_1_type",
      "name": "CONTACT_1_TYPE"
    },
    {
      "datatype": "text",
      "description": "Contact 1's full name",
      "field_name": "contact_1_name",
      "name": "CONTACT_1_NAME"
    },
    {
      "datatype": "text",
      "description": "Contact 1's primary address city",
      "field_name": "contact_1_city",
      "name": "CONTACT_1_CITY"
    },
    {
      "datatype": "text",
      "description": "Contact 1's primary address state",
      "field_name": "contact_1_state",
      "name": "CONTACT_1_STATE"
    },
    {
      "datatype": "text",
      "description": "Contact 1's primary address ZIP code",
      "field_name": "contact_1_zipcode",
      "name": "CONTACT_1_ZIPCODE"
    },
    {
      "datatype": "text",
      "description": "Contact 2's relationship to permit",
      "field_name": "contact_2_type",
      "name": "CONTACT_2_TYPE"
    },
    {
      "datatype": "text",
      "description": "Contact 2's full name",
      "field_name": "contact_2_name",
      "name": "CONTACT_2_NAME"
    },
    {
      "datatype": "text",
      "description": "Contact 2's primary address city",
      "field_name": "contact_2_city",
      "name": "CONTACT_2_CITY"
    },
    {
      "datatype": "text",
      "description": "Contact 2's primary address state",
      "field_name": "contact_2_state",
      "name": "CONTACT_2_STATE"
    },
    {
      "datatype": "text",
      "description": "Contact 2's primary address ZIP code",
      "field_name": "contact_2_zipcode",
      "name": "CONTACT_2_ZIPCODE"
    },
    {
      "datatype": "text",
      "description": "Contact 3's relationship to permit",
      "field_name": "contact_3_type",
      "name": "CONTACT_3_TYPE"
    },
    {
      "datatype": "text",
      "description": "Contact 3's full name",
      "field_name": "contact_3_name",
      "name": "CONTACT_3_NAME"
    },
    {
      "datatype": "text",
      "description": "Contact 3's primary address city",
      "field_name": "contact_3_city",
      "name": "CONTACT_3_CITY"
    },
    {
      "datatype": "text",
      "description": "Contact 3's primary address state",
      "field_name": "contact_3_state",
      "name": "CONTACT_3_STATE"
    },
    {
      "datatype": "text",
      "description": "Contact 3's primary address ZIP code",
      "field_name": "contact_3_zipcode",
      "name": "CONTACT_3_ZIPCODE"
    },
    {
      "datatype": "text",
      "description": "Contact 4's relationship to permit",
      "field_name": "contact_4_type",
      "name": "CONTACT_4_TYPE"
    },
    {
      "datatype": "text",
      "description": "Contact 4's full name",
      "field_name": "contact_4_name",
      "name": "CONTACT_4_NAME"
    },
    {
      "datatype": "text",
      "description": "Contact 4's primary address city",
      "field_name": "contact_4_city",
      "name": "CONTACT_4_CITY"
    },
    {
      "datatype": "text",
      "description": "Contact 4's primary address state",
      "field_name": "contact_4_state",
      "name": "CONTACT_4_STATE"
    },
    "… [72 more items]"
  ],
  "created_at": "2011-09-30T12:00:08Z",
  "custom_fields": [
    {
      "field": "Changes and Other Historical Information Useful to Understanding This Dataset",
      "section": "Metadata",
      "value": "https://www.google.com/search?q=site:data.cityofchicago.org/stories+\"Related+dataset+ID+s\"+\"ydr8-5enu\""
    },
    {
      "field": "Data Owner",
      "section": "Metadata",
      "value": "Department of Buildings"
    },
    {
      "field": "Frequency",
      "section": "Metadata",
      "value": "Data are updated daily"
    },
    {
      "field": "Time Period",
      "section": "Metadata",
      "value": "2006 to present"
    }
  ],
  "description": "This dataset includes information about building permits issued by the City of Chicago from 2006 to the present, excluding permits that have been voided or revoked after issuance. Most types of permits are issued subject to payment of the applicable permit fee. Work under a permit may not begin until the applicable permit fee is paid. For more information about building permits, see http://www.chicago.gov/permit.",
  "id": "ydr8-5enu",
  "license": {
    "id": "SEE_TERMS_OF_USE",
    "name": "See Terms of Use",
    "terms_link": null
  },
  "metadata_url": "https://data.cityofchicago.org/api/views/ydr8-5enu.json",
  "name": "Building Permits",
  "observed_at_ms": 1791566243621,
  "permalink": "https://data.cityofchicago.org/d/ydr8-5enu",
  "portal": "data.cityofchicago.org",
  "provenance": "official",
  "publication_date": "2025-10-14T22:14:12Z",
  "row_count": 849932,
  "rows_updated_at": "2026-10-09T12:06:53Z",
  "tags": [
    "permits",
    "buildings"
  ],
  "view_last_modified": "2026-05-29T18:56:10Z",
  "view_type": "tabular"
}

Related providers

Browse the library