Compare JCCDB Values Across Regions (latest)
compare_jccdb_regions品目と規格で、地域ごとの最新時点の値を並べ、最小・中央・最大と状態別の件数を返す。規格・単位・値の種類が同じものだけを比べる(普通と高炉は別の組)。中央値はこのサービスの計算(computed:true)。例: query='生コンクリート', spec='24-8-25(20)', layer='material', normalize='namacon'(局ごとの規格の書き方の違いを越えて束ねる)。 / Latest value per region for an item and spec, with min, median (computed) and max and counts by price status; only identical spec, unit and basis are compared.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| spec | No | 規格(例: 21-8-25(20))。 / Specification. | |
| layer | No | データの種類: material 資材、labor 労務単価、work 工事の単価、equipment 機械損料、index 指数、wage 賃金統計、bid_item 入札の品目単価、cost_sqft 面積あたり工事費、spending 工事支出と建築許可、house_price 住宅価格、cost_limit 費用の上限。国ごとの有無は get_jccdb_coverage で確かめる。 / Data type: material, labor (design labor rates), work (work-item unit prices), equipment (rental rates), index, wage (wage statistics), bid_item (bid unit prices), cost_sqft (cost per square foot), spending (construction spending and permits), house_price, cost_limit. Check availability per country with get_jccdb_coverage. | |
| limit | No | 比べる組(品目・規格・単位の組み合わせ)の上限(1〜20)。 / Maximum comparison groups to return (1 to 20). | |
| query | Yes | 品目名。 / Item name. | |
| country | No | 国で絞る: JP 日本、US 米国。 / Country filter: JP for Japan, US for the United States. | |
| normalize | No | exact(既定: 規格の文字が同じものだけ)/ namacon(生コンの規格を局をまたいで束ねる: セメント・呼び強度-スランプ-骨材・水セメント比・単位セメント量)。 / namacon groups ready-mix concrete specs across bureaus. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| count | No | How many records matched. 0 means the source was read and nothing matched. It never means the source could not be read, that returns isError: true. | |
| groups | No | 規格・単位・値の種類ごとの組(最小・中央・最大) / groups with min, median, max | |
| lookup | No | ok = the source was read and something matched. absent = the source was read and nothing matched. A source that could NOT be read never appears here: that returns isError: true and makes no claim about what does or does not exist. | |
| by_status | No | 状態別の件数 / counts by status | |
| source_read | No | true on every successful result. A failed lookup does not return a result at all, so this is never false, it is declared so a consumer can assert on it. | |
| did_you_mean | No | Near matches, when an exact match was not found. | |
| computed_note | No | 計算した値の説明 / computed fields |