Get U.S. Wholesale and Retail Gross Margins (Census) and BEA Margin Structure
get_us_trade_margins米国の卸と小売の粗利率を NAICS で返す(Census AWTS 1992〜2022、ARTS 1993〜2022、AIES 2024)。kake_cost_ratio = 1 - 粗利率(売値のうち仕入れ原価の割合)。commodity か include_bea で BEA 2007 の建設業と家計の購入の流通構造(生産者価格・運賃・卸・小売・購入者価格)も。業種の平均で、個々の会社の仕入れ値ではない。例: naics='4233'(建材卸)、naics='444110'(ホームセンター)。 / U.S. wholesale and retail gross margins by NAICS (Census AWTS, ARTS, AIES 2024) with kake_cost_ratio = 1 - margin; optionally the BEA 2007 margin structure. Industry averages, not any firm's cost.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| year | No | 年(例 2022。AIES は 2024)。 / Year, e.g. 2022 (AIES covers 2024). | |
| limit | No | 返す行の上限(1〜200)。 / Maximum rows to return (1 to 200). | |
| naics | No | NAICS の頭(4233 建材卸、423720 配管・暖房卸、4441 建材小売、444110 ホームセンター)。 / NAICS prefix. | |
| query | No | 業種の語(英語。例 plumbing, paint)。 / Industry words in English. | |
| trade | No | wholesale 卸 か retail 小売 で絞る。 / Filter to wholesale or retail. | |
| history | No | true で年ごと。 / All years. | |
| commodity | No | BEA の品目の語(英語。例 cement, lighting)。 / BEA commodity words. | |
| include_bea | No | true で BEA 2007 の流通構造(生産者価格・運賃・卸・小売・購入者価格)も返す。 / true to add the BEA 2007 margin structure (producer price, freight, wholesale, retail, purchaser price). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | No | NAICS ごとの粗利率と kake_cost_ratio / margins and cost ratio by NAICS | |
| 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. | |
| 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. | |
| 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. | |
| margin_index | No | マージン物価指数 / trade-margin price indexes |