DataScoop public data

How to get full access: the current plan of this connection, row caps, prices (free preview, one-off export, Pro subscription), 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.

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.

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.

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.

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.

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.