query_dataset

org.georgiacivicdata/georgia-civic-data · Verify this server

Query one topic's gold facts with dimension labels joined in (the district/school/county/demographic names come back on every row). `filters` is a dict of column → value or list-of-values: FK codes (district_code, school_code, county_fips, demographic) and any categorical column — see describe_dataset's `filters` for the exact keys and enum values. Use `year` (exact) OR `year_min`/`year_max` (range), never both. `detail` picks the grain (default is the finest available). Returns `rows` plus a `columns` descriptor array (type/role/unit/null-meaning, and `is_key_metric` flagging the headline column) so you interpret values and NULLs correctly — NULL usually means SUPPRESSED, not zero (see null_semantics). The top-level `key_metric` echoes which column is the answer. Use `columns` to project a subset, `include_labels=false` to skip the joined name columns (codes only), and `order_by`+`order` for server-side top-N instead of over-fetching. Pages are small (default 100, max 500); when `truncated` is true a `bulk_export` block points at the REST CSV/Parquet endpoint and the source path for the full pull — do not loop pagination to dump a table. A bad filter returns a self-describing error listing the valid keys/values.