All integrationsGovernment & Public Data

Socrata

Read open data from any Socrata portal (Tyler Data & Insights), used by hundreds of cities and governments: search datasets across portals, read rows with filters and sorting, and count them.

actions
8

Actions

Steps a workflow can run in Socrata.

  • Search datasetsSearch the datasets of every Socrata portal at once, or of one portal, by words, category and tag.
  • Find portalsFind the Socrata portals that publish data about a place or topic, with how many matching datasets each has.
  • List categoriesList a portal's dataset categories, with how many datasets are in each.
  • List tagsList a portal's most used tags, with how many datasets carry each.
  • Get a datasetGet a dataset's details and its columns, with each column's field name and type for filtering and sorting.
  • Get rowsRead a dataset's rows: choose columns, filter, search, sort and page through them.
  • Count rowsCount how many of a dataset's rows match a filter, or all of them.
  • Count rows by valueCount how many rows hold each value of a column, such as complaints per borough, most common first.

Automate Socrata with Lodol.

Connect Socrata and ask your AI for your first workflow.

Free plan, no credit card