Seattle Data Describe Dataset
seattle_data_describe_datasetInspect a Seattle open dataset's columns, live row count, time coverage, and place/geo fields before querying to choose valid filters for area or near searches.
Instructions
Decide whether and how to query a dataset: columns, live row count, data_coverage
(actual time range), place fields for "in " questions (with reliability),
and geo columns for near.
Call before querying a dataset whose columns you do not know.
For area questions, use detail="full".
Filter a place field on its value, never its label; an area may span several values.
Example: {"dataset_id": "kzjm-xkqj", "detail": "full"}.
Typically 1-3 s; fails with query_timeout after 30 s.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| detail | No | summary (default) or full: adds place-field values and column stats. | |
| dataset_id | Yes | Socrata dataset id, e.g. kzjm-xkqj (from seattle_data_search_datasets). | |
| sample_rows | No | Example rows to include. Default 0. | |
| column_query | No | Only columns whose name or description contains this; omit for all. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| title | Yes | ||
| source | Yes | ||
| columns | Yes | ||
| guide_uri | No | ||
| row_count | Yes | ||
| dataset_id | Yes | ||
| geo_columns | Yes | ||
| sample_rows | No | ||
| geo_unusable | No | ||
| place_fields | Yes | ||
| queryability | Yes | ||
| data_coverage | Yes | ||
| time_semantics | Yes | ||
| example_queries | No | ||
| stats_available | Yes |