DataScoop public data

List every dataset DataScoop carries (official public records: UK food hygiene ratings, Scotland FHIS, CQC care providers, the UK charity register, US restaurant inspections, US building permits, and more as added) with country, coverage, row count, licence, refresh date and the page URLs. Call this or search_datasets first.

{
  "type": "object",
  "properties": {
    "country": {
      "type": "string",
      "description": "Optional ISO 3166-1 alpha-2 country code to filter by, e.g. GB or US"
    }
  },
  "additionalProperties": false
}

Find which DataScoop dataset answers a need, by keywords such as "care homes Yorkshire", "restaurant inspections Chicago", "charities income", "food hygiene Leeds", "building permits". Returns matching datasets with their filters and an example query.

{
  "type": "object",
  "properties": {
    "query": {
      "type": "string",
      "description": "What the user is looking for, in plain words"
    },
    "country": {
      "type": "string",
      "description": "Optional ISO country code, e.g. GB or US"
    }
  },
  "required": [
    "query"
  ],
  "additionalProperties": false
}

Get a dataset's columns and the exact filters it accepts (key, type, allowed options, example). Use the filter keys, not column names, when calling query_dataset.

{
  "type": "object",
  "properties": {
    "dataset": {
      "type": "string",
      "description": "Dataset id from list_datasets, e.g. fsa, cqc, charity-commission, us-food-inspections, us-building-permits, fhis-scotland"
    }
  },
  "required": [
    "dataset"
  ],
  "additionalProperties": false
}

Return the rows of a dataset that match a set of filters, with the total count and the attribution to cite. Organisational data only (businesses, premises, charities, permits), never personal contact data. Without a Pro key each call returns at most 25 rows and sets truncated=true with the total; the result then includes next_step with the exact links and wording to give the user so they can get every row (one-off spreadsheet export, or a free account upgraded to Pro for unlimited API and MCP rows). Page with offset; ask for format "summary" to get counts only.

{
  "type": "object",
  "properties": {
    "dataset": {
      "type": "string",
      "description": "Dataset id, e.g. fsa"
    },
    "filters": {
      "type": "object",
      "description": "Filter object keyed by the filter keys from get_dataset_schema (not column names), e.g. {\"localAuthority\":\"Leeds\",\"rating\":\"1\"}. Text filters are case-insensitive; \"contains\" filters match substrings; enum filters must use one of the listed options.",
      "additionalProperties": true
    },
    "limit": {
      "type": "integer",
      "minimum": 0,
      "maximum": 1000,
      "description": "Rows to return (default 25, max 1000 per call; free plans are capped at 25)"
    },
    "offset": {
      "type": "integer",
      "minimum": 0,
      "description": "Rows to skip, for paging through large results (Pro)"
    },
    "format": {
      "type": "string",
      "enum": [
        "rows",
        "summary"
      ],
      "description": "\"rows\" (default) returns the rows; \"summary\" returns only the total and links"
    }
  },
  "required": [
    "dataset"
  ],
  "additionalProperties": false
}

Free aggregate statistics for datasets that have a rating (food hygiene ratings by local authority, Scotland FHIS by council, US restaurant inspections and building permits by city area): totals, share rated well or poorly, rank among areas, breakdown by type, and the most recently rated low performers. Omit area to list the areas available. Cite the page URL returned.

{
  "type": "object",
  "properties": {
    "dataset": {
      "type": "string",
      "description": "Dataset id with statistics, e.g. fsa, fhis-scotland, us-food-inspections, us-building-permits"
    },
    "area": {
      "type": "string",
      "description": "Area name or slug, e.g. \"Leeds\" or \"leeds\". Omit to list areas."
    }
  },
  "required": [
    "dataset"
  ],
  "additionalProperties": false
}

How to get full access: the current plan of this connection, row caps, prices (free preview, one-off export, Pro annual pass), the signup and pricing URLs, how to pass an API key, and the wording to use when telling a user how to get every row.

{
  "type": "object",
  "additionalProperties": false
}