Skip to content

Instantly share code, notes, and snippets.

@riow1983

riow1983/datagojp.ipynb

Created August 15, 2019 07:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save riow1983/835e291a8eaa39ab70de57ee78da1c52 to your computer and use it in GitHub Desktop.
Save riow1983/835e291a8eaa39ab70de57ee78da1c52 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
datagojp.ipynb
{
"cells": [
{
"cell_type": "markdown",
"metadata": {
"collapsed": true
},
"source": [
"# Data Go.JP\n",
"### https://www.data.go.jp/for-developer/for-developer/"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"# conda create -n <environment's name> anaconda\n",
"# conda create -n dsw anaconda\n",
"# https://qiita.com/ozaki_physics/items/985188feb92570e5b82d"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"api.xlsx datagojp.ipynb\r\n"
]
}
],
"source": [
"!ls"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd\n",
"import requests\n",
"import io"
]
},
{
"cell_type": "code",
"execution_count": 24,
"metadata": {},
"outputs": [],
"source": [
"manual = pd.read_excel(\"api.xlsx\")\n",
"manual = manual[:-2]\n",
"mnl = manual[[\"API\", \"説明\", \"引数\", \"パラメータ説明\"]]"
]
},
{
"cell_type": "code",
"execution_count": 26,
"metadata": {},
"outputs": [],
"source": [
"mnl[\"API\"].fillna(method='ffill', inplace=True)\n",
"mnl[\"説明\"].fillna(method='ffill', inplace=True)"
]
},
{
"cell_type": "code",
"execution_count": 30,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/anaconda/envs/dsw/lib/python3.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
"A value is trying to be set on a copy of a slice from a DataFrame.\n",
"Try using .loc[row_indexer,col_indexer] = value instead\n",
"\n",
"See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
" \"\"\"Entry point for launching an IPython kernel.\n"
]
}
],
"source": [
"mnl[\"API\"] = \"https://www.data.go.jp/data/\" + mnl[\"API\"]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# APIを利用したメタデータの取得例 ：\t\t\t\t\n",
"\n",
"#### (ア)組織に関するメタデータの取得： \t\t\t\t\t\n",
"- 登録されている組織の一覧 \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/organization_list\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- 登録されている組織の一覧(各組織のメタ情報も取得） \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/organization_list?all_fields=true\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- 登録されている組織の一覧（各組織のメタ情報を取得し、且つ組織のデータセット登録数順でソート） \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/organization_list?all_fields=true&order_by=packages\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- 指定した組織「内閣府」の詳細情報 \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/organization_show?id=org_0400\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"#### (イ)グループに関するメタデータの取得： \t\t\t\t\t\n",
"- 登録されているグループの一覧 \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/organization_list\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- 指定したグループ「行財政」の詳細情報\t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/group_show?id=gr_1300\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"#### (ウ)タグに関するメタデータの取得： \t\t\t\t\t\n",
"- タグの一覧 \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/tag_list\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- 指定したタグ「統計」を含むデータセット名の一覧（10件取得指定） \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/package_search?q=*:*&facet.limit=10&facet.field=[\"title_string\"]&fq=tags:統計&rows=0\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- キーワード「統計」を含むタグの検索 \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/tag_search?query=統計\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"#### (エ)データセットやリソースに関するメタデータの取得： \t\t\t\t\t\n",
"- 検索条件に合うデータセット「平成26年_新規登録、更新情報」が属しているグループ名の一覧 \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/package_search?q=*:*&facet.limit=10&facet.field=[\"groups\"]&fq=tags:統計&rows=0\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- 検索条件に合うデータセット「高度情報通信ネットワーク社会の形成に関する予算_平成26年度」とそのデータセットに含まれるリソースの一覧 \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/package_search?q=name:cas_20140901_0000\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- 指定したデータセット「高度情報通信ネットワーク社会の形成に関する予算_平成26年度」のメタデータ情報 \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/package_show?id=高度情報通信ネットワーク社会の形成に関する予算_平成26年度\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- 指定したリソース「高度情報通信ネットワーク社会の形成に関する平成26年度予算について（府省庁別）_HTML」のメタデータ情報 \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/resource_show?id=高度情報通信ネットワーク社会の形成に関する平成26年度予算について（府省庁別）_HTML\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- キーワード「統計」を含むデータセットの検索（10件取得指定） \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/package_search?q=統計&limit=10\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- 「name」属性にキーワード「統計」を含むリソースの検索（10件取得指定） \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/resource_search?query=name:統計&limit=10\t\t\t\t\t"
]
},
{
"cell_type": "code",
"execution_count": 31,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>API</th>\n",
" <th>説明</th>\n",
" <th>引数</th>\n",
" <th>パラメータ説明</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセット一覧を取得する。</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>https://www.data.go.jp/data/api/action/current...</td>\n",
" <td>データセット一覧(リソースを含む)を取得する。</td>\n",
" <td>limit</td>\n",
" <td>取得する最大のデータセット件数を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>https://www.data.go.jp/data/api/action/current...</td>\n",
" <td>データセット一覧(リソースを含む)を取得する。</td>\n",
" <td>page</td>\n",
" <td>「limit」の値で複数ページに分割されたデータセット一覧から、返却対象とするページの番号を...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>https://www.data.go.jp/data/api/action/group_list</td>\n",
" <td>グループ一覧を取得する。</td>\n",
" <td>order_by</td>\n",
" <td>nameでソートする場合は「name」、データセット数でソートする場合は「packages」...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>https://www.data.go.jp/data/api/action/group_list</td>\n",
" <td>グループ一覧を取得する。</td>\n",
" <td>groups</td>\n",
" <td>取得するグループの名称を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>https://www.data.go.jp/data/api/action/group_list</td>\n",
" <td>グループ一覧を取得する。</td>\n",
" <td>all_fields</td>\n",
" <td>すべてメタデータ項目を取得する場合は「true」、\\n「name」のみを取得する場合は「fa...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>https://www.data.go.jp/data/api/action/organiz...</td>\n",
" <td>組織一覧を取得する。</td>\n",
" <td>order_by</td>\n",
" <td>nameでソートする場合は「name」、データセット数でソートする場合は「packages」...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>https://www.data.go.jp/data/api/action/organiz...</td>\n",
" <td>組織一覧を取得する。</td>\n",
" <td>organizations</td>\n",
" <td>取得する組織の名称を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>https://www.data.go.jp/data/api/action/organiz...</td>\n",
" <td>組織一覧を取得する。</td>\n",
" <td>all_fields</td>\n",
" <td>すべてメタデータ項目を取得する場合は「true」、\\n「name」のみを取得する場合は「fa...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>https://www.data.go.jp/data/api/action/license...</td>\n",
" <td>ライセンス一覧を取得する。</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>https://www.data.go.jp/data/api/action/tag_list</td>\n",
" <td>タグ一覧を取得する。</td>\n",
" <td>query</td>\n",
" <td>取得するタグに含まれる文字列を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>https://www.data.go.jp/data/api/action/tag_list</td>\n",
" <td>タグ一覧を取得する。</td>\n",
" <td>all_fields</td>\n",
" <td>すべてメタデータ項目を取得する場合は「true」、\\n「name」のみを取得する場合は「fa...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセットの詳細を取得する。</td>\n",
" <td>id</td>\n",
" <td>取得するデータセットの「id」または、「name」を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>https://www.data.go.jp/data/api/action/resourc...</td>\n",
" <td>リソースの詳細を取得する。</td>\n",
" <td>id</td>\n",
" <td>取得するリソースの「id」を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>https://www.data.go.jp/data/api/action/group_show</td>\n",
" <td>グループの詳細を取得する。</td>\n",
" <td>id</td>\n",
" <td>取得するグループの「id」を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>https://www.data.go.jp/data/api/action/organiz...</td>\n",
" <td>組織の詳細を取得する。</td>\n",
" <td>id</td>\n",
" <td>取得する組織の「id」または、「name」を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>https://www.data.go.jp/data/api/action/group_p...</td>\n",
" <td>グループのデータセット一覧を取得する。</td>\n",
" <td>id</td>\n",
" <td>取得するグループの「id」または、「name」を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>https://www.data.go.jp/data/api/action/group_p...</td>\n",
" <td>グループのデータセット一覧を取得する。</td>\n",
" <td>limit</td>\n",
" <td>取得する最大のグループ数を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>https://www.data.go.jp/data/api/action/tag_show</td>\n",
" <td>タグの詳細を取得する。</td>\n",
" <td>id</td>\n",
" <td>取得するタグの「id」または、「name」を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセットを検索する。</td>\n",
" <td>q</td>\n",
" <td>データセットの検索クエリを指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセットを検索する。</td>\n",
" <td>fq</td>\n",
" <td>検索フィルターを指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセットを検索する。</td>\n",
" <td>sort</td>\n",
" <td>データセット一覧のソート順を指定する。\\n注：フィールド名称とソート順（「asc」または「d...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセットを検索する。</td>\n",
" <td>rows</td>\n",
" <td>取得するデータセット数を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセットを検索する。</td>\n",
" <td>start</td>\n",
" <td>複数ページに分割されたデータセット一覧を表示する場合、表示を開始するページ番号を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセットを検索する。</td>\n",
" <td>facet</td>\n",
" <td>ファセットを有効化する場合は「true」、\\n無効化する場合は「false」を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセットを検索する。</td>\n",
" <td>facet.mincount</td>\n",
" <td>ファセットが含むデータセットの最小数を指定する。\\nこの値よりもファセットが含むデータセット...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセットを検索する。</td>\n",
" <td>facet.limit</td>\n",
" <td>ファセットの最大取得数を指定する。\\n0より小さい値を指定した場合は全て取得される。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセットを検索する。</td>\n",
" <td>facet.field</td>\n",
" <td>ファセットを生成する対象のフィールド名を指定する。\\n指定しなかった場合、ファセットは空値で...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>https://www.data.go.jp/data/api/action/resourc...</td>\n",
" <td>リソースを検索する。</td>\n",
" <td>query</td>\n",
" <td>リソースの検索クエリを指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>https://www.data.go.jp/data/api/action/resourc...</td>\n",
" <td>リソースを検索する。</td>\n",
" <td>order_by</td>\n",
" <td>リソース一覧のソート順を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>https://www.data.go.jp/data/api/action/resourc...</td>\n",
" <td>リソースを検索する。</td>\n",
" <td>limit</td>\n",
" <td>取得する最大のデータセット件数を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>https://www.data.go.jp/data/api/action/resourc...</td>\n",
" <td>リソースを検索する。</td>\n",
" <td>offset</td>\n",
" <td>取得するオフセットの番号を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>https://www.data.go.jp/data/api/action/tag_search</td>\n",
" <td>指定した文字列が含まれたタグを検索する。</td>\n",
" <td>query</td>\n",
" <td>検索する文字列を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>https://www.data.go.jp/data/api/action/tag_search</td>\n",
" <td>指定した文字列が含まれたタグを検索する。</td>\n",
" <td>limit</td>\n",
" <td>取得する最大のタグ数を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>https://www.data.go.jp/data/api/action/tag_search</td>\n",
" <td>指定した文字列が含まれたタグを検索する。</td>\n",
" <td>offset</td>\n",
" <td>取得するオフセットの番号を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセット更新履歴を取得する。</td>\n",
" <td>id</td>\n",
" <td>取得するデータセットの「id」または、「name」を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセット更新履歴を取得する。</td>\n",
" <td>limit</td>\n",
" <td>取得する最大のアクティビティ数を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセット更新履歴を取得する。</td>\n",
" <td>offset</td>\n",
" <td>取得するオフセットの番号を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td>https://www.data.go.jp/data/api/action/group_a...</td>\n",
" <td>グループ更新履歴を取得する。</td>\n",
" <td>id</td>\n",
" <td>取得するグループの「id」または、「name」を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>https://www.data.go.jp/data/api/action/group_a...</td>\n",
" <td>グループ更新履歴を取得する。</td>\n",
" <td>limit</td>\n",
" <td>取得する最大のアクティビティ数を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>https://www.data.go.jp/data/api/action/group_a...</td>\n",
" <td>グループ更新履歴を取得する。</td>\n",
" <td>offset</td>\n",
" <td>取得するオフセットの番号を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>https://www.data.go.jp/data/api/action/organiz...</td>\n",
" <td>組織更新履歴を取得する。</td>\n",
" <td>id</td>\n",
" <td>取得する組織の「id」または、「name」を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>https://www.data.go.jp/data/api/action/recentl...</td>\n",
" <td>最近更新されたデータセット履歴を取得する。</td>\n",
" <td>limit</td>\n",
" <td>取得する最大のアクティビティ数を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td>https://www.data.go.jp/data/api/action/recentl...</td>\n",
" <td>最近更新されたデータセット履歴を取得する。</td>\n",
" <td>offset</td>\n",
" <td>取得するオフセットの番号を指定する。</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" API \\\n",
"0 https://www.data.go.jp/data/api/action/package... \n",
"1 https://www.data.go.jp/data/api/action/current... \n",
"2 https://www.data.go.jp/data/api/action/current... \n",
"3 https://www.data.go.jp/data/api/action/group_list \n",
"4 https://www.data.go.jp/data/api/action/group_list \n",
"5 https://www.data.go.jp/data/api/action/group_list \n",
"6 https://www.data.go.jp/data/api/action/organiz... \n",
"7 https://www.data.go.jp/data/api/action/organiz... \n",
"8 https://www.data.go.jp/data/api/action/organiz... \n",
"9 https://www.data.go.jp/data/api/action/license... \n",
"10 https://www.data.go.jp/data/api/action/tag_list \n",
"11 https://www.data.go.jp/data/api/action/tag_list \n",
"12 https://www.data.go.jp/data/api/action/package... \n",
"13 https://www.data.go.jp/data/api/action/resourc... \n",
"14 https://www.data.go.jp/data/api/action/group_show \n",
"15 https://www.data.go.jp/data/api/action/organiz... \n",
"16 https://www.data.go.jp/data/api/action/group_p... \n",
"17 https://www.data.go.jp/data/api/action/group_p... \n",
"18 https://www.data.go.jp/data/api/action/tag_show \n",
"19 https://www.data.go.jp/data/api/action/package... \n",
"20 https://www.data.go.jp/data/api/action/package... \n",
"21 https://www.data.go.jp/data/api/action/package... \n",
"22 https://www.data.go.jp/data/api/action/package... \n",
"23 https://www.data.go.jp/data/api/action/package... \n",
"24 https://www.data.go.jp/data/api/action/package... \n",
"25 https://www.data.go.jp/data/api/action/package... \n",
"26 https://www.data.go.jp/data/api/action/package... \n",
"27 https://www.data.go.jp/data/api/action/package... \n",
"28 https://www.data.go.jp/data/api/action/resourc... \n",
"29 https://www.data.go.jp/data/api/action/resourc... \n",
"30 https://www.data.go.jp/data/api/action/resourc... \n",
"31 https://www.data.go.jp/data/api/action/resourc... \n",
"32 https://www.data.go.jp/data/api/action/tag_search \n",
"33 https://www.data.go.jp/data/api/action/tag_search \n",
"34 https://www.data.go.jp/data/api/action/tag_search \n",
"35 https://www.data.go.jp/data/api/action/package... \n",
"36 https://www.data.go.jp/data/api/action/package... \n",
"37 https://www.data.go.jp/data/api/action/package... \n",
"38 https://www.data.go.jp/data/api/action/group_a... \n",
"39 https://www.data.go.jp/data/api/action/group_a... \n",
"40 https://www.data.go.jp/data/api/action/group_a... \n",
"41 https://www.data.go.jp/data/api/action/organiz... \n",
"42 https://www.data.go.jp/data/api/action/recentl... \n",
"43 https://www.data.go.jp/data/api/action/recentl... \n",
"\n",
" 説明 引数 \\\n",
"0 データセット一覧を取得する。 - \n",
"1 データセット一覧(リソースを含む)を取得する。 limit \n",
"2 データセット一覧(リソースを含む)を取得する。 page \n",
"3 グループ一覧を取得する。 order_by \n",
"4 グループ一覧を取得する。 groups \n",
"5 グループ一覧を取得する。 all_fields \n",
"6 組織一覧を取得する。 order_by \n",
"7 組織一覧を取得する。 organizations \n",
"8 組織一覧を取得する。 all_fields \n",
"9 ライセンス一覧を取得する。 - \n",
"10 タグ一覧を取得する。 query \n",
"11 タグ一覧を取得する。 all_fields \n",
"12 データセットの詳細を取得する。 id \n",
"13 リソースの詳細を取得する。 id \n",
"14 グループの詳細を取得する。 id \n",
"15 組織の詳細を取得する。 id \n",
"16 グループのデータセット一覧を取得する。 id \n",
"17 グループのデータセット一覧を取得する。 limit \n",
"18 タグの詳細を取得する。 id \n",
"19 データセットを検索する。 q \n",
"20 データセットを検索する。 fq \n",
"21 データセットを検索する。 sort \n",
"22 データセットを検索する。 rows \n",
"23 データセットを検索する。 start \n",
"24 データセットを検索する。 facet \n",
"25 データセットを検索する。 facet.mincount \n",
"26 データセットを検索する。 facet.limit \n",
"27 データセットを検索する。 facet.field \n",
"28 リソースを検索する。 query \n",
"29 リソースを検索する。 order_by \n",
"30 リソースを検索する。 limit \n",
"31 リソースを検索する。 offset \n",
"32 指定した文字列が含まれたタグを検索する。 query \n",
"33 指定した文字列が含まれたタグを検索する。 limit \n",
"34 指定した文字列が含まれたタグを検索する。 offset \n",
"35 データセット更新履歴を取得する。 id \n",
"36 データセット更新履歴を取得する。 limit \n",
"37 データセット更新履歴を取得する。 offset \n",
"38 グループ更新履歴を取得する。 id \n",
"39 グループ更新履歴を取得する。 limit \n",
"40 グループ更新履歴を取得する。 offset \n",
"41 組織更新履歴を取得する。 id \n",
"42 最近更新されたデータセット履歴を取得する。 limit \n",
"43 最近更新されたデータセット履歴を取得する。 offset \n",
"\n",
" パラメータ説明 \n",
"0 - \n",
"1 取得する最大のデータセット件数を指定する。 \n",
"2 「limit」の値で複数ページに分割されたデータセット一覧から、返却対象とするページの番号を... \n",
"3 nameでソートする場合は「name」、データセット数でソートする場合は「packages」... \n",
"4 取得するグループの名称を指定する。 \n",
"5 すべてメタデータ項目を取得する場合は「true」、\\n「name」のみを取得する場合は「fa... \n",
"6 nameでソートする場合は「name」、データセット数でソートする場合は「packages」... \n",
"7 取得する組織の名称を指定する。 \n",
"8 すべてメタデータ項目を取得する場合は「true」、\\n「name」のみを取得する場合は「fa... \n",
"9 - \n",
"10 取得するタグに含まれる文字列を指定する。 \n",
"11 すべてメタデータ項目を取得する場合は「true」、\\n「name」のみを取得する場合は「fa... \n",
"12 取得するデータセットの「id」または、「name」を指定する。 \n",
"13 取得するリソースの「id」を指定する。 \n",
"14 取得するグループの「id」を指定する。 \n",
"15 取得する組織の「id」または、「name」を指定する。 \n",
"16 取得するグループの「id」または、「name」を指定する。 \n",
"17 取得する最大のグループ数を指定する。 \n",
"18 取得するタグの「id」または、「name」を指定する。 \n",
"19 データセットの検索クエリを指定する。 \n",
"20 検索フィルターを指定する。 \n",
"21 データセット一覧のソート順を指定する。\\n注：フィールド名称とソート順（「asc」または「d... \n",
"22 取得するデータセット数を指定する。 \n",
"23 複数ページに分割されたデータセット一覧を表示する場合、表示を開始するページ番号を指定する。 \n",
"24 ファセットを有効化する場合は「true」、\\n無効化する場合は「false」を指定する。 \n",
"25 ファセットが含むデータセットの最小数を指定する。\\nこの値よりもファセットが含むデータセット... \n",
"26 ファセットの最大取得数を指定する。\\n0より小さい値を指定した場合は全て取得される。 \n",
"27 ファセットを生成する対象のフィールド名を指定する。\\n指定しなかった場合、ファセットは空値で... \n",
"28 リソースの検索クエリを指定する。 \n",
"29 リソース一覧のソート順を指定する。 \n",
"30 取得する最大のデータセット件数を指定する。 \n",
"31 取得するオフセットの番号を指定する。 \n",
"32 検索する文字列を指定する。 \n",
"33 取得する最大のタグ数を指定する。 \n",
"34 取得するオフセットの番号を指定する。 \n",
"35 取得するデータセットの「id」または、「name」を指定する。 \n",
"36 取得する最大のアクティビティ数を指定する。 \n",
"37 取得するオフセットの番号を指定する。 \n",
"38 取得するグループの「id」または、「name」を指定する。 \n",
"39 取得する最大のアクティビティ数を指定する。 \n",
"40 取得するオフセットの番号を指定する。 \n",
"41 取得する組織の「id」または、「name」を指定する。 \n",
"42 取得する最大のアクティビティ数を指定する。 \n",
"43 取得するオフセットの番号を指定する。 "
]
},
"execution_count": 31,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# view the manual\n",
"mnl"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Example"
]
},
{
"cell_type": "code",
"execution_count": 40,
"metadata": {},
"outputs": [],
"source": [
"url = 'https://www.data.go.jp/data/api/action/resource_search?query=name:統計&limit=10'\n",
"resp = requests.get(url)\n",
"assert resp.status_code == 200"
]
},
{
"cell_type": "code",
"execution_count": 52,
"metadata": {},
"outputs": [],
"source": [
"j = resp.json()\n",
"df = pd.DataFrame.from_dict(j[\"result\"][\"results\"])"
]
},
{
"cell_type": "code",
"execution_count": 64,
"metadata": {},
"outputs": [],
"source": [
"dls = df[\"url\"][0]\n",
"resp = requests.get(dls)\n",
"assert resp.status_code == 200"
]
},
{
"cell_type": "code",
"execution_count": 75,
"metadata": {},
"outputs": [],
"source": [
"with io.BytesIO(resp.content) as fh:\n",
" df = pd.io.excel.read_excel(fh, header=5, sheet_name=0)"
]
},
{
"cell_type": "code",
"execution_count": 78,
"metadata": {},
"outputs": [],
"source": [
"df.drop([\"Unnamed: 0\", \"Unnamed: 1\", \"Unnamed: 2\"], axis=1, inplace=True)"
]
},
{
"cell_type": "code",
"execution_count": 81,
"metadata": {},
"outputs": [],
"source": [
"df.rename(columns={\"Unnamed: 3\":\"Index\"}, inplace=True)\n",
"df.set_index(\"Index\", inplace=True)"
]
},
{
"cell_type": "code",
"execution_count": 84,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Agriculture,forestry,fishery</th>\n",
" <th>Mining</th>\n",
" <th>Foodstuffs</th>\n",
" <th>Textile products</th>\n",
" <th>Pulp, paper and wooden products</th>\n",
" <th>Chemical products</th>\n",
" <th>Petroleum products</th>\n",
" <th>Ceramics, stone and clay products</th>\n",
" <th>Iron, steel and its products</th>\n",
" <th>Non-rerrous metals and its products</th>\n",
" <th>...</th>\n",
" <th>Change in inventories.3</th>\n",
" <th>Other domestic final demand(AS)</th>\n",
" <th>Total fixed capital formation.3</th>\n",
" <th>Government consumption expenditures.3</th>\n",
" <th>Government purchases.3</th>\n",
" <th>Total of domestic final demand(AS)</th>\n",
" <th>Total of domestic final demand</th>\n",
" <th>Exports to ROW</th>\n",
" <th>Total amount of final demand</th>\n",
" <th>Total of domestic products</th>\n",
" </tr>\n",
" <tr>\n",
" <th>Index</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>Agriculture,forestry,fishery</th>\n",
" <td>1381</td>\n",
" <td>230</td>\n",
" <td>395026</td>\n",
" <td>3560</td>\n",
" <td>26785</td>\n",
" <td>1041</td>\n",
" <td>4</td>\n",
" <td>10</td>\n",
" <td>45</td>\n",
" <td>3</td>\n",
" <td>...</td>\n",
" <td>37</td>\n",
" <td>21</td>\n",
" <td>19</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>231</td>\n",
" <td>659745</td>\n",
" <td>-125</td>\n",
" <td>168074</td>\n",
" <td>659620</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Mining</th>\n",
" <td>80</td>\n",
" <td>0</td>\n",
" <td>1006</td>\n",
" <td>15</td>\n",
" <td>331</td>\n",
" <td>1500</td>\n",
" <td>851</td>\n",
" <td>1036</td>\n",
" <td>3856</td>\n",
" <td>2913</td>\n",
" <td>...</td>\n",
" <td>18</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>22</td>\n",
" <td>23326</td>\n",
" <td>-229</td>\n",
" <td>-961</td>\n",
" <td>23097</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Foodstuffs</th>\n",
" <td>67104</td>\n",
" <td>0</td>\n",
" <td>17003</td>\n",
" <td>-24</td>\n",
" <td>680</td>\n",
" <td>5938</td>\n",
" <td>1</td>\n",
" <td>127</td>\n",
" <td>4</td>\n",
" <td>1</td>\n",
" <td>...</td>\n",
" <td>97</td>\n",
" <td>14</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>0</td>\n",
" <td>1535</td>\n",
" <td>1366841</td>\n",
" <td>1804</td>\n",
" <td>1047417</td>\n",
" <td>1368645</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Textile products</th>\n",
" <td>4500</td>\n",
" <td>45</td>\n",
" <td>1196</td>\n",
" <td>88353</td>\n",
" <td>2798</td>\n",
" <td>621</td>\n",
" <td>128</td>\n",
" <td>878</td>\n",
" <td>277</td>\n",
" <td>73</td>\n",
" <td>...</td>\n",
" <td>247</td>\n",
" <td>45</td>\n",
" <td>15</td>\n",
" <td>30</td>\n",
" <td>0</td>\n",
" <td>2723</td>\n",
" <td>447031</td>\n",
" <td>24549</td>\n",
" <td>297384</td>\n",
" <td>471580</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Pulp, paper and wooden products</th>\n",
" <td>8455</td>\n",
" <td>316</td>\n",
" <td>25651</td>\n",
" <td>6147</td>\n",
" <td>10563</td>\n",
" <td>17287</td>\n",
" <td>67</td>\n",
" <td>6798</td>\n",
" <td>576</td>\n",
" <td>96</td>\n",
" <td>...</td>\n",
" <td>29</td>\n",
" <td>54</td>\n",
" <td>22</td>\n",
" <td>32</td>\n",
" <td>0</td>\n",
" <td>322</td>\n",
" <td>459390</td>\n",
" <td>4769</td>\n",
" <td>62052</td>\n",
" <td>464159</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Chemical products</th>\n",
" <td>32360</td>\n",
" <td>237</td>\n",
" <td>15417</td>\n",
" <td>36315</td>\n",
" <td>18693</td>\n",
" <td>0</td>\n",
" <td>1996</td>\n",
" <td>6424</td>\n",
" <td>6104</td>\n",
" <td>676</td>\n",
" <td>...</td>\n",
" <td>288</td>\n",
" <td>246</td>\n",
" <td>1</td>\n",
" <td>245</td>\n",
" <td>0</td>\n",
" <td>2222</td>\n",
" <td>643515</td>\n",
" <td>33524</td>\n",
" <td>140475</td>\n",
" <td>677039</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Petroleum products</th>\n",
" <td>17992</td>\n",
" <td>871</td>\n",
" <td>9757</td>\n",
" <td>6071</td>\n",
" <td>13501</td>\n",
" <td>35755</td>\n",
" <td>0</td>\n",
" <td>22506</td>\n",
" <td>9875</td>\n",
" <td>2246</td>\n",
" <td>...</td>\n",
" <td>63</td>\n",
" <td>100</td>\n",
" <td>0</td>\n",
" <td>100</td>\n",
" <td>0</td>\n",
" <td>224</td>\n",
" <td>552248</td>\n",
" <td>9647</td>\n",
" <td>129331</td>\n",
" <td>561895</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Ceramics, stone and clay products</th>\n",
" <td>1059</td>\n",
" <td>78</td>\n",
" <td>11439</td>\n",
" <td>115</td>\n",
" <td>2915</td>\n",
" <td>4068</td>\n",
" <td>1934</td>\n",
" <td>2674</td>\n",
" <td>2736</td>\n",
" <td>15</td>\n",
" <td>...</td>\n",
" <td>-17</td>\n",
" <td>107</td>\n",
" <td>101</td>\n",
" <td>6</td>\n",
" <td>0</td>\n",
" <td>426</td>\n",
" <td>330020</td>\n",
" <td>7751</td>\n",
" <td>24576</td>\n",
" <td>337771</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Iron, steel and its products</th>\n",
" <td>22</td>\n",
" <td>352</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1206</td>\n",
" <td>3457</td>\n",
" <td>0</td>\n",
" <td>4015</td>\n",
" <td>0</td>\n",
" <td>703</td>\n",
" <td>...</td>\n",
" <td>70</td>\n",
" <td>103</td>\n",
" <td>70</td>\n",
" <td>33</td>\n",
" <td>0</td>\n",
" <td>179</td>\n",
" <td>465584</td>\n",
" <td>45873</td>\n",
" <td>41287</td>\n",
" <td>511457</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Non-rerrous metals and its products</th>\n",
" <td>0</td>\n",
" <td>5</td>\n",
" <td>1452</td>\n",
" <td>17</td>\n",
" <td>320</td>\n",
" <td>3281</td>\n",
" <td>28</td>\n",
" <td>697</td>\n",
" <td>7602</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>-63</td>\n",
" <td>226</td>\n",
" <td>202</td>\n",
" <td>24</td>\n",
" <td>0</td>\n",
" <td>231</td>\n",
" <td>124400</td>\n",
" <td>2904</td>\n",
" <td>-7264</td>\n",
" <td>127304</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Metal products</th>\n",
" <td>1193</td>\n",
" <td>619</td>\n",
" <td>24026</td>\n",
" <td>1627</td>\n",
" <td>7267</td>\n",
" <td>8772</td>\n",
" <td>1609</td>\n",
" <td>2539</td>\n",
" <td>378</td>\n",
" <td>63</td>\n",
" <td>...</td>\n",
" <td>-294</td>\n",
" <td>1500</td>\n",
" <td>1157</td>\n",
" <td>343</td>\n",
" <td>0</td>\n",
" <td>1848</td>\n",
" <td>598412</td>\n",
" <td>7689</td>\n",
" <td>71221</td>\n",
" <td>606101</td>\n",
" </tr>\n",
" <tr>\n",
" <th>General machinery</th>\n",
" <td>5327</td>\n",
" <td>420</td>\n",
" <td>6339</td>\n",
" <td>1798</td>\n",
" <td>3164</td>\n",
" <td>7259</td>\n",
" <td>2785</td>\n",
" <td>5941</td>\n",
" <td>5362</td>\n",
" <td>759</td>\n",
" <td>...</td>\n",
" <td>-669</td>\n",
" <td>54206</td>\n",
" <td>52807</td>\n",
" <td>1399</td>\n",
" <td>0</td>\n",
" <td>54387</td>\n",
" <td>805540</td>\n",
" <td>54119</td>\n",
" <td>621340</td>\n",
" <td>859659</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Electric machinery</th>\n",
" <td>206</td>\n",
" <td>174</td>\n",
" <td>129</td>\n",
" <td>524</td>\n",
" <td>150</td>\n",
" <td>2383</td>\n",
" <td>2393</td>\n",
" <td>1209</td>\n",
" <td>5209</td>\n",
" <td>1928</td>\n",
" <td>...</td>\n",
" <td>2365</td>\n",
" <td>15374</td>\n",
" <td>14639</td>\n",
" <td>735</td>\n",
" <td>0</td>\n",
" <td>34163</td>\n",
" <td>1143994</td>\n",
" <td>128960</td>\n",
" <td>886848</td>\n",
" <td>1272954</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Automobiles</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>1834</td>\n",
" <td>18356</td>\n",
" <td>17337</td>\n",
" <td>1019</td>\n",
" <td>0</td>\n",
" <td>21262</td>\n",
" <td>579966</td>\n",
" <td>121866</td>\n",
" <td>566437</td>\n",
" <td>701832</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Other transport machinery</th>\n",
" <td>3129</td>\n",
" <td>2</td>\n",
" <td>16</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>5</td>\n",
" <td>2</td>\n",
" <td>31</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>-1345</td>\n",
" <td>8781</td>\n",
" <td>7621</td>\n",
" <td>1160</td>\n",
" <td>0</td>\n",
" <td>7898</td>\n",
" <td>122678</td>\n",
" <td>61413</td>\n",
" <td>141873</td>\n",
" <td>184091</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Precision machinery</th>\n",
" <td>19</td>\n",
" <td>0</td>\n",
" <td>11</td>\n",
" <td>12</td>\n",
" <td>16</td>\n",
" <td>107</td>\n",
" <td>5</td>\n",
" <td>16</td>\n",
" <td>15</td>\n",
" <td>6</td>\n",
" <td>...</td>\n",
" <td>253</td>\n",
" <td>7135</td>\n",
" <td>6878</td>\n",
" <td>257</td>\n",
" <td>0</td>\n",
" <td>8717</td>\n",
" <td>159784</td>\n",
" <td>14257</td>\n",
" <td>134780</td>\n",
" <td>174041</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Other manufactured products</th>\n",
" <td>7103</td>\n",
" <td>358</td>\n",
" <td>26618</td>\n",
" <td>12961</td>\n",
" <td>28083</td>\n",
" <td>17831</td>\n",
" <td>1338</td>\n",
" <td>3436</td>\n",
" <td>1858</td>\n",
" <td>347</td>\n",
" <td>...</td>\n",
" <td>52</td>\n",
" <td>1015</td>\n",
" <td>859</td>\n",
" <td>156</td>\n",
" <td>0</td>\n",
" <td>3881</td>\n",
" <td>863652</td>\n",
" <td>25089</td>\n",
" <td>253680</td>\n",
" <td>888741</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Construction</th>\n",
" <td>1858</td>\n",
" <td>113</td>\n",
" <td>2762</td>\n",
" <td>925</td>\n",
" <td>1636</td>\n",
" <td>3937</td>\n",
" <td>832</td>\n",
" <td>1418</td>\n",
" <td>5583</td>\n",
" <td>533</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2343798</td>\n",
" <td>0</td>\n",
" <td>2133319</td>\n",
" <td>2343798</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Electricity, water and gas supply</th>\n",
" <td>3133</td>\n",
" <td>2026</td>\n",
" <td>20365</td>\n",
" <td>11938</td>\n",
" <td>20175</td>\n",
" <td>46520</td>\n",
" <td>4496</td>\n",
" <td>16096</td>\n",
" <td>43389</td>\n",
" <td>12104</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>714770</td>\n",
" <td>911</td>\n",
" <td>227970</td>\n",
" <td>715681</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Commerce</th>\n",
" <td>25357</td>\n",
" <td>564</td>\n",
" <td>80130</td>\n",
" <td>47845</td>\n",
" <td>27764</td>\n",
" <td>24276</td>\n",
" <td>15418</td>\n",
" <td>18172</td>\n",
" <td>27117</td>\n",
" <td>5096</td>\n",
" <td>...</td>\n",
" <td>455</td>\n",
" <td>7168</td>\n",
" <td>6805</td>\n",
" <td>363</td>\n",
" <td>0</td>\n",
" <td>10444</td>\n",
" <td>2477638</td>\n",
" <td>42904</td>\n",
" <td>1621922</td>\n",
" <td>2520542</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Transportation</th>\n",
" <td>18212</td>\n",
" <td>523</td>\n",
" <td>39072</td>\n",
" <td>10347</td>\n",
" <td>22023</td>\n",
" <td>24243</td>\n",
" <td>6231</td>\n",
" <td>24092</td>\n",
" <td>38355</td>\n",
" <td>7643</td>\n",
" <td>...</td>\n",
" <td>50</td>\n",
" <td>695</td>\n",
" <td>617</td>\n",
" <td>78</td>\n",
" <td>0</td>\n",
" <td>1051</td>\n",
" <td>928904</td>\n",
" <td>153997</td>\n",
" <td>532673</td>\n",
" <td>1082901</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Other services</th>\n",
" <td>29355</td>\n",
" <td>2125</td>\n",
" <td>59802</td>\n",
" <td>29251</td>\n",
" <td>30944</td>\n",
" <td>82526</td>\n",
" <td>17581</td>\n",
" <td>36189</td>\n",
" <td>31823</td>\n",
" <td>6647</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>6</td>\n",
" <td>6581542</td>\n",
" <td>37257</td>\n",
" <td>4433907</td>\n",
" <td>6618799</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Government activities</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>486059</td>\n",
" <td>0</td>\n",
" <td>471775</td>\n",
" <td>486059</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Activities not elsewhere classified,others</th>\n",
" <td>16411</td>\n",
" <td>1616</td>\n",
" <td>36995</td>\n",
" <td>9365</td>\n",
" <td>17698</td>\n",
" <td>29733</td>\n",
" <td>6807</td>\n",
" <td>17348</td>\n",
" <td>24898</td>\n",
" <td>4126</td>\n",
" <td>...</td>\n",
" <td>48</td>\n",
" <td>263</td>\n",
" <td>0</td>\n",
" <td>263</td>\n",
" <td>0</td>\n",
" <td>602</td>\n",
" <td>816648</td>\n",
" <td>38536</td>\n",
" <td>57653</td>\n",
" <td>855184</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Total amount of intermediate input (Japan)</th>\n",
" <td>244256</td>\n",
" <td>10674</td>\n",
" <td>774212</td>\n",
" <td>267163</td>\n",
" <td>236712</td>\n",
" <td>320540</td>\n",
" <td>64506</td>\n",
" <td>171652</td>\n",
" <td>215063</td>\n",
" <td>45978</td>\n",
" <td>...</td>\n",
" <td>3518</td>\n",
" <td>115413</td>\n",
" <td>109151</td>\n",
" <td>6262</td>\n",
" <td>0</td>\n",
" <td>152374</td>\n",
" <td>23695485</td>\n",
" <td>817465</td>\n",
" <td>14057769</td>\n",
" <td>24512950</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Agriculture,forestry,fishery</th>\n",
" <td>913</td>\n",
" <td>0</td>\n",
" <td>24254</td>\n",
" <td>3249</td>\n",
" <td>7353</td>\n",
" <td>42</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>-157</td>\n",
" <td>91</td>\n",
" <td>75</td>\n",
" <td>16</td>\n",
" <td>0</td>\n",
" <td>1005</td>\n",
" <td>1327042</td>\n",
" <td>81506</td>\n",
" <td>345888</td>\n",
" <td>1408548</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Mining</th>\n",
" <td>0</td>\n",
" <td>5</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>36</td>\n",
" <td>371</td>\n",
" <td>38</td>\n",
" <td>458</td>\n",
" <td>5580</td>\n",
" <td>923</td>\n",
" <td>...</td>\n",
" <td>-131</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>-128</td>\n",
" <td>1590612</td>\n",
" <td>32282</td>\n",
" <td>49772</td>\n",
" <td>1622894</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Foodstuffs</th>\n",
" <td>129</td>\n",
" <td>0</td>\n",
" <td>8578</td>\n",
" <td>549</td>\n",
" <td>0</td>\n",
" <td>207</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>-426</td>\n",
" <td>42</td>\n",
" <td>0</td>\n",
" <td>42</td>\n",
" <td>0</td>\n",
" <td>2945</td>\n",
" <td>2732097</td>\n",
" <td>92865</td>\n",
" <td>2143350</td>\n",
" <td>2824962</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Textile products</th>\n",
" <td>13</td>\n",
" <td>0</td>\n",
" <td>4</td>\n",
" <td>360</td>\n",
" <td>16</td>\n",
" <td>4</td>\n",
" <td>2</td>\n",
" <td>7</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>-4</td>\n",
" <td>31</td>\n",
" <td>10</td>\n",
" <td>21</td>\n",
" <td>0</td>\n",
" <td>712</td>\n",
" <td>805724</td>\n",
" <td>26873</td>\n",
" <td>565657</td>\n",
" <td>832597</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Pulp, paper and wooden products</th>\n",
" <td>9</td>\n",
" <td>7</td>\n",
" <td>29</td>\n",
" <td>5</td>\n",
" <td>5582</td>\n",
" <td>225</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>14</td>\n",
" <td>62</td>\n",
" <td>10</td>\n",
" <td>52</td>\n",
" <td>0</td>\n",
" <td>271</td>\n",
" <td>1282865</td>\n",
" <td>35345</td>\n",
" <td>393536</td>\n",
" <td>1318210</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Non-rerrous metals and its products</th>\n",
" <td>22</td>\n",
" <td>2</td>\n",
" <td>27</td>\n",
" <td>26</td>\n",
" <td>79</td>\n",
" <td>15</td>\n",
" <td>3</td>\n",
" <td>23</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>...</td>\n",
" <td>-476</td>\n",
" <td>983</td>\n",
" <td>636</td>\n",
" <td>347</td>\n",
" <td>0</td>\n",
" <td>1042</td>\n",
" <td>97165</td>\n",
" <td>0</td>\n",
" <td>26133</td>\n",
" <td>97165</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Metal products</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>10</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>-609</td>\n",
" <td>34484</td>\n",
" <td>33623</td>\n",
" <td>861</td>\n",
" <td>0</td>\n",
" <td>34164</td>\n",
" <td>239595</td>\n",
" <td>0</td>\n",
" <td>153230</td>\n",
" <td>239595</td>\n",
" </tr>\n",
" <tr>\n",
" <th>General machinery</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>-437</td>\n",
" <td>8016</td>\n",
" <td>7190</td>\n",
" <td>826</td>\n",
" <td>0</td>\n",
" <td>12815</td>\n",
" <td>310530</td>\n",
" <td>0</td>\n",
" <td>177352</td>\n",
" <td>310530</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Electric machinery</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>1349</td>\n",
" <td>6750</td>\n",
" <td>6568</td>\n",
" <td>182</td>\n",
" <td>0</td>\n",
" <td>8353</td>\n",
" <td>400586</td>\n",
" <td>0</td>\n",
" <td>309951</td>\n",
" <td>400586</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Automobiles</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>-6</td>\n",
" <td>1132</td>\n",
" <td>965</td>\n",
" <td>167</td>\n",
" <td>0</td>\n",
" <td>1126</td>\n",
" <td>56236</td>\n",
" <td>0</td>\n",
" <td>33755</td>\n",
" <td>56236</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Other transport machinery</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>-996</td>\n",
" <td>15362</td>\n",
" <td>14450</td>\n",
" <td>912</td>\n",
" <td>0</td>\n",
" <td>15697</td>\n",
" <td>90327</td>\n",
" <td>0</td>\n",
" <td>67962</td>\n",
" <td>90327</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Precision machinery</th>\n",
" <td>5</td>\n",
" <td>0</td>\n",
" <td>17</td>\n",
" <td>3</td>\n",
" <td>8</td>\n",
" <td>7</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>-101</td>\n",
" <td>8</td>\n",
" <td>5</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>362</td>\n",
" <td>43096</td>\n",
" <td>0</td>\n",
" <td>9239</td>\n",
" <td>43096</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Other manufactured products</th>\n",
" <td>571</td>\n",
" <td>18</td>\n",
" <td>307</td>\n",
" <td>592</td>\n",
" <td>441</td>\n",
" <td>21790</td>\n",
" <td>3793</td>\n",
" <td>1984</td>\n",
" <td>965</td>\n",
" <td>197</td>\n",
" <td>...</td>\n",
" <td>442</td>\n",
" <td>1516</td>\n",
" <td>629</td>\n",
" <td>887</td>\n",
" <td>0</td>\n",
" <td>8420</td>\n",
" <td>671319</td>\n",
" <td>0</td>\n",
" <td>234124</td>\n",
" <td>671319</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Construction</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>1</td>\n",
" <td>119</td>\n",
" <td>0</td>\n",
" <td>119</td>\n",
" <td>0</td>\n",
" <td>499</td>\n",
" <td>59707</td>\n",
" <td>0</td>\n",
" <td>16131</td>\n",
" <td>59707</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Electricity, water and gas supply</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>199</td>\n",
" <td>153</td>\n",
" <td>46</td>\n",
" <td>0</td>\n",
" <td>199</td>\n",
" <td>3327</td>\n",
" <td>0</td>\n",
" <td>2649</td>\n",
" <td>3327</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Commerce</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>10</td>\n",
" <td>0</td>\n",
" <td>10</td>\n",
" <td>0</td>\n",
" <td>10</td>\n",
" <td>56084</td>\n",
" <td>0</td>\n",
" <td>3240</td>\n",
" <td>56084</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Transportation</th>\n",
" <td>34</td>\n",
" <td>6</td>\n",
" <td>233</td>\n",
" <td>234</td>\n",
" <td>88</td>\n",
" <td>238</td>\n",
" <td>64</td>\n",
" <td>153</td>\n",
" <td>169</td>\n",
" <td>24</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>1425</td>\n",
" <td>57</td>\n",
" <td>1368</td>\n",
" <td>0</td>\n",
" <td>14356</td>\n",
" <td>309074</td>\n",
" <td>0</td>\n",
" <td>123204</td>\n",
" <td>309074</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Other services</th>\n",
" <td>178</td>\n",
" <td>23</td>\n",
" <td>1499</td>\n",
" <td>527</td>\n",
" <td>537</td>\n",
" <td>1663</td>\n",
" <td>488</td>\n",
" <td>351</td>\n",
" <td>456</td>\n",
" <td>110</td>\n",
" <td>...</td>\n",
" <td>2</td>\n",
" <td>4542</td>\n",
" <td>313</td>\n",
" <td>4229</td>\n",
" <td>0</td>\n",
" <td>25695</td>\n",
" <td>367933</td>\n",
" <td>0</td>\n",
" <td>126468</td>\n",
" <td>367933</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Government activities</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>156</td>\n",
" <td>0</td>\n",
" <td>156</td>\n",
" <td>0</td>\n",
" <td>156</td>\n",
" <td>5421</td>\n",
" <td>0</td>\n",
" <td>5064</td>\n",
" <td>5421</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Activities not elsewhere classified,others</th>\n",
" <td>835</td>\n",
" <td>47</td>\n",
" <td>976</td>\n",
" <td>291</td>\n",
" <td>605</td>\n",
" <td>807</td>\n",
" <td>51</td>\n",
" <td>668</td>\n",
" <td>1367</td>\n",
" <td>122</td>\n",
" <td>...</td>\n",
" <td>-180</td>\n",
" <td>4225</td>\n",
" <td>3</td>\n",
" <td>4222</td>\n",
" <td>0</td>\n",
" <td>4109</td>\n",
" <td>541312</td>\n",
" <td>0</td>\n",
" <td>371900</td>\n",
" <td>541312</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Total amount of intermediate input (ROW)</th>\n",
" <td>4086</td>\n",
" <td>369</td>\n",
" <td>50865</td>\n",
" <td>17715</td>\n",
" <td>19405</td>\n",
" <td>44420</td>\n",
" <td>259289</td>\n",
" <td>7389</td>\n",
" <td>74959</td>\n",
" <td>27850</td>\n",
" <td>...</td>\n",
" <td>-3328</td>\n",
" <td>80600</td>\n",
" <td>65078</td>\n",
" <td>15522</td>\n",
" <td>0</td>\n",
" <td>164583</td>\n",
" <td>6633888</td>\n",
" <td>0</td>\n",
" <td>2343454</td>\n",
" <td>6633888</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Customs duties</th>\n",
" <td>585</td>\n",
" <td>5</td>\n",
" <td>7836</td>\n",
" <td>1335</td>\n",
" <td>258</td>\n",
" <td>1973</td>\n",
" <td>19085</td>\n",
" <td>107</td>\n",
" <td>324</td>\n",
" <td>658</td>\n",
" <td>...</td>\n",
" <td>7727</td>\n",
" <td>35168</td>\n",
" <td>33822</td>\n",
" <td>1346</td>\n",
" <td>0</td>\n",
" <td>77923</td>\n",
" <td>440845</td>\n",
" <td>0</td>\n",
" <td>216972</td>\n",
" <td>440845</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Total amount of intermediate input</th>\n",
" <td>254235</td>\n",
" <td>11290</td>\n",
" <td>908816</td>\n",
" <td>309559</td>\n",
" <td>289752</td>\n",
" <td>414719</td>\n",
" <td>412629</td>\n",
" <td>185565</td>\n",
" <td>312620</td>\n",
" <td>92608</td>\n",
" <td>...</td>\n",
" <td>286787</td>\n",
" <td>2474338</td>\n",
" <td>1816855</td>\n",
" <td>657483</td>\n",
" <td>0</td>\n",
" <td>6511733</td>\n",
" <td>126998772</td>\n",
" <td>6412279</td>\n",
" <td>81431869</td>\n",
" <td>133411051</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Compensation for employees</th>\n",
" <td>61141</td>\n",
" <td>8911</td>\n",
" <td>172029</td>\n",
" <td>114882</td>\n",
" <td>103126</td>\n",
" <td>108326</td>\n",
" <td>9074</td>\n",
" <td>78076</td>\n",
" <td>71254</td>\n",
" <td>15258</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>42897741</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>42897741</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Other value added</th>\n",
" <td>344244</td>\n",
" <td>2896</td>\n",
" <td>287800</td>\n",
" <td>47139</td>\n",
" <td>71281</td>\n",
" <td>153994</td>\n",
" <td>140192</td>\n",
" <td>74130</td>\n",
" <td>127583</td>\n",
" <td>19438</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>32220787</td>\n",
" <td>14191</td>\n",
" <td>1034757</td>\n",
" <td>32234978</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Indirect taxes + subsides</th>\n",
" <td>7324</td>\n",
" <td>-1139</td>\n",
" <td>148934</td>\n",
" <td>10016</td>\n",
" <td>10541</td>\n",
" <td>18124</td>\n",
" <td>112494</td>\n",
" <td>9181</td>\n",
" <td>19398</td>\n",
" <td>3426</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>12730</td>\n",
" <td>107967</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Indirect taxes</th>\n",
" <td>17752</td>\n",
" <td>518</td>\n",
" <td>179435</td>\n",
" <td>10016</td>\n",
" <td>10541</td>\n",
" <td>18232</td>\n",
" <td>112909</td>\n",
" <td>9181</td>\n",
" <td>19398</td>\n",
" <td>3426</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Current subsidies</th>\n",
" <td>-10428</td>\n",
" <td>-1657</td>\n",
" <td>-30501</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>-108</td>\n",
" <td>-415</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Operating surplus</th>\n",
" <td>260047</td>\n",
" <td>1773</td>\n",
" <td>109718</td>\n",
" <td>19505</td>\n",
" <td>36832</td>\n",
" <td>87545</td>\n",
" <td>16765</td>\n",
" <td>40331</td>\n",
" <td>74188</td>\n",
" <td>6973</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Depreciaton of fixed capital</th>\n",
" <td>76873</td>\n",
" <td>2262</td>\n",
" <td>29148</td>\n",
" <td>17618</td>\n",
" <td>23908</td>\n",
" <td>48325</td>\n",
" <td>10933</td>\n",
" <td>24618</td>\n",
" <td>33997</td>\n",
" <td>9039</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Value added tax not exemptable</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1461</td>\n",
" <td>926790</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Enterprise profit(006+007)</th>\n",
" <td>336920</td>\n",
" <td>4035</td>\n",
" <td>138866</td>\n",
" <td>37123</td>\n",
" <td>60740</td>\n",
" <td>135870</td>\n",
" <td>27698</td>\n",
" <td>64949</td>\n",
" <td>108185</td>\n",
" <td>16012</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Property-type income(005+006+007)</th>\n",
" <td>326492</td>\n",
" <td>2378</td>\n",
" <td>108365</td>\n",
" <td>37123</td>\n",
" <td>60740</td>\n",
" <td>135762</td>\n",
" <td>27283</td>\n",
" <td>64949</td>\n",
" <td>108185</td>\n",
" <td>16012</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Total of gross value</th>\n",
" <td>405385</td>\n",
" <td>11807</td>\n",
" <td>459829</td>\n",
" <td>162021</td>\n",
" <td>174407</td>\n",
" <td>262320</td>\n",
" <td>149266</td>\n",
" <td>152206</td>\n",
" <td>198837</td>\n",
" <td>34696</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>75118528</td>\n",
" <td>14191</td>\n",
" <td>1034757</td>\n",
" <td>75132719</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Value of domestic products</th>\n",
" <td>659620</td>\n",
" <td>23097</td>\n",
" <td>1368645</td>\n",
" <td>471580</td>\n",
" <td>464159</td>\n",
" <td>677039</td>\n",
" <td>561895</td>\n",
" <td>337771</td>\n",
" <td>511457</td>\n",
" <td>127304</td>\n",
" <td>...</td>\n",
" <td>286787</td>\n",
" <td>2474338</td>\n",
" <td>1816855</td>\n",
" <td>657483</td>\n",
" <td>0</td>\n",
" <td>6511733</td>\n",
" <td>202117300</td>\n",
" <td>6426470</td>\n",
" <td>82466626</td>\n",
" <td>208543770</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>141 rows × 137 columns</p>\n",
"</div>"
],
"text/plain": [
" Agriculture,forestry,fishery \\\n",
"Index \n",
"Agriculture,forestry,fishery 1381 \n",
"Mining 80 \n",
"Foodstuffs 67104 \n",
"Textile products 4500 \n",
"Pulp, paper and wooden products 8455 \n",
"Chemical products 32360 \n",
"Petroleum products 17992 \n",
"Ceramics, stone and clay products 1059 \n",
"Iron, steel and its products 22 \n",
"Non-rerrous metals and its products 0 \n",
"Metal products 1193 \n",
"General machinery 5327 \n",
"Electric machinery 206 \n",
"Automobiles 0 \n",
"Other transport machinery 3129 \n",
"Precision machinery 19 \n",
"Other manufactured products 7103 \n",
"Construction 1858 \n",
"Electricity, water and gas supply 3133 \n",
"Commerce 25357 \n",
"Transportation 18212 \n",
"Other services 29355 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 16411 \n",
"Total amount of intermediate input (Japan) 244256 \n",
"Agriculture,forestry,fishery 913 \n",
"Mining 0 \n",
"Foodstuffs 129 \n",
"Textile products 13 \n",
"Pulp, paper and wooden products 9 \n",
"... ... \n",
"Non-rerrous metals and its products 22 \n",
"Metal products 1 \n",
"General machinery 1 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 5 \n",
"Other manufactured products 571 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 34 \n",
"Other services 178 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 835 \n",
"Total amount of intermediate input (ROW) 4086 \n",
"Customs duties 585 \n",
"Total amount of intermediate input 254235 \n",
"Compensation for employees 61141 \n",
"Other value added 344244 \n",
"Indirect taxes + subsides 7324 \n",
"Indirect taxes 17752 \n",
"Current subsidies -10428 \n",
"Operating surplus 260047 \n",
"Depreciaton of fixed capital 76873 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 336920 \n",
"Property-type income(005+006+007) 326492 \n",
"Total of gross value 405385 \n",
"Value of domestic products 659620 \n",
"\n",
" Mining Foodstuffs \\\n",
"Index \n",
"Agriculture,forestry,fishery 230 395026 \n",
"Mining 0 1006 \n",
"Foodstuffs 0 17003 \n",
"Textile products 45 1196 \n",
"Pulp, paper and wooden products 316 25651 \n",
"Chemical products 237 15417 \n",
"Petroleum products 871 9757 \n",
"Ceramics, stone and clay products 78 11439 \n",
"Iron, steel and its products 352 0 \n",
"Non-rerrous metals and its products 5 1452 \n",
"Metal products 619 24026 \n",
"General machinery 420 6339 \n",
"Electric machinery 174 129 \n",
"Automobiles 0 0 \n",
"Other transport machinery 2 16 \n",
"Precision machinery 0 11 \n",
"Other manufactured products 358 26618 \n",
"Construction 113 2762 \n",
"Electricity, water and gas supply 2026 20365 \n",
"Commerce 564 80130 \n",
"Transportation 523 39072 \n",
"Other services 2125 59802 \n",
"Government activities 0 0 \n",
"Activities not elsewhere classified,others 1616 36995 \n",
"Total amount of intermediate input (Japan) 10674 774212 \n",
"Agriculture,forestry,fishery 0 24254 \n",
"Mining 5 0 \n",
"Foodstuffs 0 8578 \n",
"Textile products 0 4 \n",
"Pulp, paper and wooden products 7 29 \n",
"... ... ... \n",
"Non-rerrous metals and its products 2 27 \n",
"Metal products 0 1 \n",
"General machinery 0 0 \n",
"Electric machinery 0 0 \n",
"Automobiles 0 0 \n",
"Other transport machinery 0 0 \n",
"Precision machinery 0 17 \n",
"Other manufactured products 18 307 \n",
"Construction 0 0 \n",
"Electricity, water and gas supply 0 0 \n",
"Commerce 0 0 \n",
"Transportation 6 233 \n",
"Other services 23 1499 \n",
"Government activities 0 0 \n",
"Activities not elsewhere classified,others 47 976 \n",
"Total amount of intermediate input (ROW) 369 50865 \n",
"Customs duties 5 7836 \n",
"Total amount of intermediate input 11290 908816 \n",
"Compensation for employees 8911 172029 \n",
"Other value added 2896 287800 \n",
"Indirect taxes + subsides -1139 148934 \n",
"Indirect taxes 518 179435 \n",
"Current subsidies -1657 -30501 \n",
"Operating surplus 1773 109718 \n",
"Depreciaton of fixed capital 2262 29148 \n",
"Value added tax not exemptable 0 0 \n",
"Enterprise profit(006+007) 4035 138866 \n",
"Property-type income(005+006+007) 2378 108365 \n",
"Total of gross value 11807 459829 \n",
"Value of domestic products 23097 1368645 \n",
"\n",
" Textile products \\\n",
"Index \n",
"Agriculture,forestry,fishery 3560 \n",
"Mining 15 \n",
"Foodstuffs -24 \n",
"Textile products 88353 \n",
"Pulp, paper and wooden products 6147 \n",
"Chemical products 36315 \n",
"Petroleum products 6071 \n",
"Ceramics, stone and clay products 115 \n",
"Iron, steel and its products 1 \n",
"Non-rerrous metals and its products 17 \n",
"Metal products 1627 \n",
"General machinery 1798 \n",
"Electric machinery 524 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 12 \n",
"Other manufactured products 12961 \n",
"Construction 925 \n",
"Electricity, water and gas supply 11938 \n",
"Commerce 47845 \n",
"Transportation 10347 \n",
"Other services 29251 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 9365 \n",
"Total amount of intermediate input (Japan) 267163 \n",
"Agriculture,forestry,fishery 3249 \n",
"Mining 0 \n",
"Foodstuffs 549 \n",
"Textile products 360 \n",
"Pulp, paper and wooden products 5 \n",
"... ... \n",
"Non-rerrous metals and its products 26 \n",
"Metal products 0 \n",
"General machinery 0 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 3 \n",
"Other manufactured products 592 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 234 \n",
"Other services 527 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 291 \n",
"Total amount of intermediate input (ROW) 17715 \n",
"Customs duties 1335 \n",
"Total amount of intermediate input 309559 \n",
"Compensation for employees 114882 \n",
"Other value added 47139 \n",
"Indirect taxes + subsides 10016 \n",
"Indirect taxes 10016 \n",
"Current subsidies 0 \n",
"Operating surplus 19505 \n",
"Depreciaton of fixed capital 17618 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 37123 \n",
"Property-type income(005+006+007) 37123 \n",
"Total of gross value 162021 \n",
"Value of domestic products 471580 \n",
"\n",
" Pulp, paper and wooden products \\\n",
"Index \n",
"Agriculture,forestry,fishery 26785 \n",
"Mining 331 \n",
"Foodstuffs 680 \n",
"Textile products 2798 \n",
"Pulp, paper and wooden products 10563 \n",
"Chemical products 18693 \n",
"Petroleum products 13501 \n",
"Ceramics, stone and clay products 2915 \n",
"Iron, steel and its products 1206 \n",
"Non-rerrous metals and its products 320 \n",
"Metal products 7267 \n",
"General machinery 3164 \n",
"Electric machinery 150 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 16 \n",
"Other manufactured products 28083 \n",
"Construction 1636 \n",
"Electricity, water and gas supply 20175 \n",
"Commerce 27764 \n",
"Transportation 22023 \n",
"Other services 30944 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 17698 \n",
"Total amount of intermediate input (Japan) 236712 \n",
"Agriculture,forestry,fishery 7353 \n",
"Mining 36 \n",
"Foodstuffs 0 \n",
"Textile products 16 \n",
"Pulp, paper and wooden products 5582 \n",
"... ... \n",
"Non-rerrous metals and its products 79 \n",
"Metal products 7 \n",
"General machinery 0 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 8 \n",
"Other manufactured products 441 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 88 \n",
"Other services 537 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 605 \n",
"Total amount of intermediate input (ROW) 19405 \n",
"Customs duties 258 \n",
"Total amount of intermediate input 289752 \n",
"Compensation for employees 103126 \n",
"Other value added 71281 \n",
"Indirect taxes + subsides 10541 \n",
"Indirect taxes 10541 \n",
"Current subsidies 0 \n",
"Operating surplus 36832 \n",
"Depreciaton of fixed capital 23908 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 60740 \n",
"Property-type income(005+006+007) 60740 \n",
"Total of gross value 174407 \n",
"Value of domestic products 464159 \n",
"\n",
" Chemical products \\\n",
"Index \n",
"Agriculture,forestry,fishery 1041 \n",
"Mining 1500 \n",
"Foodstuffs 5938 \n",
"Textile products 621 \n",
"Pulp, paper and wooden products 17287 \n",
"Chemical products 0 \n",
"Petroleum products 35755 \n",
"Ceramics, stone and clay products 4068 \n",
"Iron, steel and its products 3457 \n",
"Non-rerrous metals and its products 3281 \n",
"Metal products 8772 \n",
"General machinery 7259 \n",
"Electric machinery 2383 \n",
"Automobiles 0 \n",
"Other transport machinery 5 \n",
"Precision machinery 107 \n",
"Other manufactured products 17831 \n",
"Construction 3937 \n",
"Electricity, water and gas supply 46520 \n",
"Commerce 24276 \n",
"Transportation 24243 \n",
"Other services 82526 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 29733 \n",
"Total amount of intermediate input (Japan) 320540 \n",
"Agriculture,forestry,fishery 42 \n",
"Mining 371 \n",
"Foodstuffs 207 \n",
"Textile products 4 \n",
"Pulp, paper and wooden products 225 \n",
"... ... \n",
"Non-rerrous metals and its products 15 \n",
"Metal products 0 \n",
"General machinery 0 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 7 \n",
"Other manufactured products 21790 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 238 \n",
"Other services 1663 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 807 \n",
"Total amount of intermediate input (ROW) 44420 \n",
"Customs duties 1973 \n",
"Total amount of intermediate input 414719 \n",
"Compensation for employees 108326 \n",
"Other value added 153994 \n",
"Indirect taxes + subsides 18124 \n",
"Indirect taxes 18232 \n",
"Current subsidies -108 \n",
"Operating surplus 87545 \n",
"Depreciaton of fixed capital 48325 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 135870 \n",
"Property-type income(005+006+007) 135762 \n",
"Total of gross value 262320 \n",
"Value of domestic products 677039 \n",
"\n",
" Petroleum products \\\n",
"Index \n",
"Agriculture,forestry,fishery 4 \n",
"Mining 851 \n",
"Foodstuffs 1 \n",
"Textile products 128 \n",
"Pulp, paper and wooden products 67 \n",
"Chemical products 1996 \n",
"Petroleum products 0 \n",
"Ceramics, stone and clay products 1934 \n",
"Iron, steel and its products 0 \n",
"Non-rerrous metals and its products 28 \n",
"Metal products 1609 \n",
"General machinery 2785 \n",
"Electric machinery 2393 \n",
"Automobiles 0 \n",
"Other transport machinery 2 \n",
"Precision machinery 5 \n",
"Other manufactured products 1338 \n",
"Construction 832 \n",
"Electricity, water and gas supply 4496 \n",
"Commerce 15418 \n",
"Transportation 6231 \n",
"Other services 17581 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 6807 \n",
"Total amount of intermediate input (Japan) 64506 \n",
"Agriculture,forestry,fishery 0 \n",
"Mining 38 \n",
"Foodstuffs 3 \n",
"Textile products 2 \n",
"Pulp, paper and wooden products 0 \n",
"... ... \n",
"Non-rerrous metals and its products 3 \n",
"Metal products 0 \n",
"General machinery 0 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 0 \n",
"Other manufactured products 3793 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 64 \n",
"Other services 488 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 51 \n",
"Total amount of intermediate input (ROW) 259289 \n",
"Customs duties 19085 \n",
"Total amount of intermediate input 412629 \n",
"Compensation for employees 9074 \n",
"Other value added 140192 \n",
"Indirect taxes + subsides 112494 \n",
"Indirect taxes 112909 \n",
"Current subsidies -415 \n",
"Operating surplus 16765 \n",
"Depreciaton of fixed capital 10933 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 27698 \n",
"Property-type income(005+006+007) 27283 \n",
"Total of gross value 149266 \n",
"Value of domestic products 561895 \n",
"\n",
" Ceramics, stone and clay products \\\n",
"Index \n",
"Agriculture,forestry,fishery 10 \n",
"Mining 1036 \n",
"Foodstuffs 127 \n",
"Textile products 878 \n",
"Pulp, paper and wooden products 6798 \n",
"Chemical products 6424 \n",
"Petroleum products 22506 \n",
"Ceramics, stone and clay products 2674 \n",
"Iron, steel and its products 4015 \n",
"Non-rerrous metals and its products 697 \n",
"Metal products 2539 \n",
"General machinery 5941 \n",
"Electric machinery 1209 \n",
"Automobiles 0 \n",
"Other transport machinery 31 \n",
"Precision machinery 16 \n",
"Other manufactured products 3436 \n",
"Construction 1418 \n",
"Electricity, water and gas supply 16096 \n",
"Commerce 18172 \n",
"Transportation 24092 \n",
"Other services 36189 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 17348 \n",
"Total amount of intermediate input (Japan) 171652 \n",
"Agriculture,forestry,fishery 0 \n",
"Mining 458 \n",
"Foodstuffs 0 \n",
"Textile products 7 \n",
"Pulp, paper and wooden products 7 \n",
"... ... \n",
"Non-rerrous metals and its products 23 \n",
"Metal products 10 \n",
"General machinery 2 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 0 \n",
"Other manufactured products 1984 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 153 \n",
"Other services 351 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 668 \n",
"Total amount of intermediate input (ROW) 7389 \n",
"Customs duties 107 \n",
"Total amount of intermediate input 185565 \n",
"Compensation for employees 78076 \n",
"Other value added 74130 \n",
"Indirect taxes + subsides 9181 \n",
"Indirect taxes 9181 \n",
"Current subsidies 0 \n",
"Operating surplus 40331 \n",
"Depreciaton of fixed capital 24618 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 64949 \n",
"Property-type income(005+006+007) 64949 \n",
"Total of gross value 152206 \n",
"Value of domestic products 337771 \n",
"\n",
" Iron, steel and its products \\\n",
"Index \n",
"Agriculture,forestry,fishery 45 \n",
"Mining 3856 \n",
"Foodstuffs 4 \n",
"Textile products 277 \n",
"Pulp, paper and wooden products 576 \n",
"Chemical products 6104 \n",
"Petroleum products 9875 \n",
"Ceramics, stone and clay products 2736 \n",
"Iron, steel and its products 0 \n",
"Non-rerrous metals and its products 7602 \n",
"Metal products 378 \n",
"General machinery 5362 \n",
"Electric machinery 5209 \n",
"Automobiles 0 \n",
"Other transport machinery 1 \n",
"Precision machinery 15 \n",
"Other manufactured products 1858 \n",
"Construction 5583 \n",
"Electricity, water and gas supply 43389 \n",
"Commerce 27117 \n",
"Transportation 38355 \n",
"Other services 31823 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 24898 \n",
"Total amount of intermediate input (Japan) 215063 \n",
"Agriculture,forestry,fishery 0 \n",
"Mining 5580 \n",
"Foodstuffs 0 \n",
"Textile products 0 \n",
"Pulp, paper and wooden products 2 \n",
"... ... \n",
"Non-rerrous metals and its products 2 \n",
"Metal products 1 \n",
"General machinery 4 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 0 \n",
"Other manufactured products 965 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 169 \n",
"Other services 456 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 1367 \n",
"Total amount of intermediate input (ROW) 74959 \n",
"Customs duties 324 \n",
"Total amount of intermediate input 312620 \n",
"Compensation for employees 71254 \n",
"Other value added 127583 \n",
"Indirect taxes + subsides 19398 \n",
"Indirect taxes 19398 \n",
"Current subsidies 0 \n",
"Operating surplus 74188 \n",
"Depreciaton of fixed capital 33997 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 108185 \n",
"Property-type income(005+006+007) 108185 \n",
"Total of gross value 198837 \n",
"Value of domestic products 511457 \n",
"\n",
" Non-rerrous metals and its products \\\n",
"Index \n",
"Agriculture,forestry,fishery 3 \n",
"Mining 2913 \n",
"Foodstuffs 1 \n",
"Textile products 73 \n",
"Pulp, paper and wooden products 96 \n",
"Chemical products 676 \n",
"Petroleum products 2246 \n",
"Ceramics, stone and clay products 15 \n",
"Iron, steel and its products 703 \n",
"Non-rerrous metals and its products 0 \n",
"Metal products 63 \n",
"General machinery 759 \n",
"Electric machinery 1928 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 6 \n",
"Other manufactured products 347 \n",
"Construction 533 \n",
"Electricity, water and gas supply 12104 \n",
"Commerce 5096 \n",
"Transportation 7643 \n",
"Other services 6647 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 4126 \n",
"Total amount of intermediate input (Japan) 45978 \n",
"Agriculture,forestry,fishery 0 \n",
"Mining 923 \n",
"Foodstuffs 0 \n",
"Textile products 0 \n",
"Pulp, paper and wooden products 0 \n",
"... ... \n",
"Non-rerrous metals and its products 1 \n",
"Metal products 0 \n",
"General machinery 0 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 0 \n",
"Other manufactured products 197 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 24 \n",
"Other services 110 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 122 \n",
"Total amount of intermediate input (ROW) 27850 \n",
"Customs duties 658 \n",
"Total amount of intermediate input 92608 \n",
"Compensation for employees 15258 \n",
"Other value added 19438 \n",
"Indirect taxes + subsides 3426 \n",
"Indirect taxes 3426 \n",
"Current subsidies 0 \n",
"Operating surplus 6973 \n",
"Depreciaton of fixed capital 9039 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 16012 \n",
"Property-type income(005+006+007) 16012 \n",
"Total of gross value 34696 \n",
"Value of domestic products 127304 \n",
"\n",
" ... Change in inventories.3 \\\n",
"Index ... \n",
"Agriculture,forestry,fishery ... 37 \n",
"Mining ... 18 \n",
"Foodstuffs ... 97 \n",
"Textile products ... 247 \n",
"Pulp, paper and wooden products ... 29 \n",
"Chemical products ... 288 \n",
"Petroleum products ... 63 \n",
"Ceramics, stone and clay products ... -17 \n",
"Iron, steel and its products ... 70 \n",
"Non-rerrous metals and its products ... -63 \n",
"Metal products ... -294 \n",
"General machinery ... -669 \n",
"Electric machinery ... 2365 \n",
"Automobiles ... 1834 \n",
"Other transport machinery ... -1345 \n",
"Precision machinery ... 253 \n",
"Other manufactured products ... 52 \n",
"Construction ... 0 \n",
"Electricity, water and gas supply ... 0 \n",
"Commerce ... 455 \n",
"Transportation ... 50 \n",
"Other services ... 0 \n",
"Government activities ... 0 \n",
"Activities not elsewhere classified,others ... 48 \n",
"Total amount of intermediate input (Japan) ... 3518 \n",
"Agriculture,forestry,fishery ... -157 \n",
"Mining ... -131 \n",
"Foodstuffs ... -426 \n",
"Textile products ... -4 \n",
"Pulp, paper and wooden products ... 14 \n",
"... ... ... \n",
"Non-rerrous metals and its products ... -476 \n",
"Metal products ... -609 \n",
"General machinery ... -437 \n",
"Electric machinery ... 1349 \n",
"Automobiles ... -6 \n",
"Other transport machinery ... -996 \n",
"Precision machinery ... -101 \n",
"Other manufactured products ... 442 \n",
"Construction ... 1 \n",
"Electricity, water and gas supply ... 0 \n",
"Commerce ... 0 \n",
"Transportation ... 0 \n",
"Other services ... 2 \n",
"Government activities ... 0 \n",
"Activities not elsewhere classified,others ... -180 \n",
"Total amount of intermediate input (ROW) ... -3328 \n",
"Customs duties ... 7727 \n",
"Total amount of intermediate input ... 286787 \n",
"Compensation for employees ... 0 \n",
"Other value added ... 0 \n",
"Indirect taxes + subsides ... 0 \n",
"Indirect taxes ... 0 \n",
"Current subsidies ... 0 \n",
"Operating surplus ... 0 \n",
"Depreciaton of fixed capital ... 0 \n",
"Value added tax not exemptable ... 0 \n",
"Enterprise profit(006+007) ... 0 \n",
"Property-type income(005+006+007) ... 0 \n",
"Total of gross value ... 0 \n",
"Value of domestic products ... 286787 \n",
"\n",
" Other domestic final demand(AS) \\\n",
"Index \n",
"Agriculture,forestry,fishery 21 \n",
"Mining 1 \n",
"Foodstuffs 14 \n",
"Textile products 45 \n",
"Pulp, paper and wooden products 54 \n",
"Chemical products 246 \n",
"Petroleum products 100 \n",
"Ceramics, stone and clay products 107 \n",
"Iron, steel and its products 103 \n",
"Non-rerrous metals and its products 226 \n",
"Metal products 1500 \n",
"General machinery 54206 \n",
"Electric machinery 15374 \n",
"Automobiles 18356 \n",
"Other transport machinery 8781 \n",
"Precision machinery 7135 \n",
"Other manufactured products 1015 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 7168 \n",
"Transportation 695 \n",
"Other services 3 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 263 \n",
"Total amount of intermediate input (Japan) 115413 \n",
"Agriculture,forestry,fishery 91 \n",
"Mining 0 \n",
"Foodstuffs 42 \n",
"Textile products 31 \n",
"Pulp, paper and wooden products 62 \n",
"... ... \n",
"Non-rerrous metals and its products 983 \n",
"Metal products 34484 \n",
"General machinery 8016 \n",
"Electric machinery 6750 \n",
"Automobiles 1132 \n",
"Other transport machinery 15362 \n",
"Precision machinery 8 \n",
"Other manufactured products 1516 \n",
"Construction 119 \n",
"Electricity, water and gas supply 199 \n",
"Commerce 10 \n",
"Transportation 1425 \n",
"Other services 4542 \n",
"Government activities 156 \n",
"Activities not elsewhere classified,others 4225 \n",
"Total amount of intermediate input (ROW) 80600 \n",
"Customs duties 35168 \n",
"Total amount of intermediate input 2474338 \n",
"Compensation for employees 0 \n",
"Other value added 0 \n",
"Indirect taxes + subsides 0 \n",
"Indirect taxes 0 \n",
"Current subsidies 0 \n",
"Operating surplus 0 \n",
"Depreciaton of fixed capital 0 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 0 \n",
"Property-type income(005+006+007) 0 \n",
"Total of gross value 0 \n",
"Value of domestic products 2474338 \n",
"\n",
" Total fixed capital formation.3 \\\n",
"Index \n",
"Agriculture,forestry,fishery 19 \n",
"Mining 1 \n",
"Foodstuffs 0 \n",
"Textile products 15 \n",
"Pulp, paper and wooden products 22 \n",
"Chemical products 1 \n",
"Petroleum products 0 \n",
"Ceramics, stone and clay products 101 \n",
"Iron, steel and its products 70 \n",
"Non-rerrous metals and its products 202 \n",
"Metal products 1157 \n",
"General machinery 52807 \n",
"Electric machinery 14639 \n",
"Automobiles 17337 \n",
"Other transport machinery 7621 \n",
"Precision machinery 6878 \n",
"Other manufactured products 859 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 6805 \n",
"Transportation 617 \n",
"Other services 0 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 0 \n",
"Total amount of intermediate input (Japan) 109151 \n",
"Agriculture,forestry,fishery 75 \n",
"Mining 0 \n",
"Foodstuffs 0 \n",
"Textile products 10 \n",
"Pulp, paper and wooden products 10 \n",
"... ... \n",
"Non-rerrous metals and its products 636 \n",
"Metal products 33623 \n",
"General machinery 7190 \n",
"Electric machinery 6568 \n",
"Automobiles 965 \n",
"Other transport machinery 14450 \n",
"Precision machinery 5 \n",
"Other manufactured products 629 \n",
"Construction 0 \n",
"Electricity, water and gas supply 153 \n",
"Commerce 0 \n",
"Transportation 57 \n",
"Other services 313 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 3 \n",
"Total amount of intermediate input (ROW) 65078 \n",
"Customs duties 33822 \n",
"Total amount of intermediate input 1816855 \n",
"Compensation for employees 0 \n",
"Other value added 0 \n",
"Indirect taxes + subsides 0 \n",
"Indirect taxes 0 \n",
"Current subsidies 0 \n",
"Operating surplus 0 \n",
"Depreciaton of fixed capital 0 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 0 \n",
"Property-type income(005+006+007) 0 \n",
"Total of gross value 0 \n",
"Value of domestic products 1816855 \n",
"\n",
" Government consumption expenditures.3 \\\n",
"Index \n",
"Agriculture,forestry,fishery 2 \n",
"Mining 0 \n",
"Foodstuffs 14 \n",
"Textile products 30 \n",
"Pulp, paper and wooden products 32 \n",
"Chemical products 245 \n",
"Petroleum products 100 \n",
"Ceramics, stone and clay products 6 \n",
"Iron, steel and its products 33 \n",
"Non-rerrous metals and its products 24 \n",
"Metal products 343 \n",
"General machinery 1399 \n",
"Electric machinery 735 \n",
"Automobiles 1019 \n",
"Other transport machinery 1160 \n",
"Precision machinery 257 \n",
"Other manufactured products 156 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 363 \n",
"Transportation 78 \n",
"Other services 3 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 263 \n",
"Total amount of intermediate input (Japan) 6262 \n",
"Agriculture,forestry,fishery 16 \n",
"Mining 0 \n",
"Foodstuffs 42 \n",
"Textile products 21 \n",
"Pulp, paper and wooden products 52 \n",
"... ... \n",
"Non-rerrous metals and its products 347 \n",
"Metal products 861 \n",
"General machinery 826 \n",
"Electric machinery 182 \n",
"Automobiles 167 \n",
"Other transport machinery 912 \n",
"Precision machinery 3 \n",
"Other manufactured products 887 \n",
"Construction 119 \n",
"Electricity, water and gas supply 46 \n",
"Commerce 10 \n",
"Transportation 1368 \n",
"Other services 4229 \n",
"Government activities 156 \n",
"Activities not elsewhere classified,others 4222 \n",
"Total amount of intermediate input (ROW) 15522 \n",
"Customs duties 1346 \n",
"Total amount of intermediate input 657483 \n",
"Compensation for employees 0 \n",
"Other value added 0 \n",
"Indirect taxes + subsides 0 \n",
"Indirect taxes 0 \n",
"Current subsidies 0 \n",
"Operating surplus 0 \n",
"Depreciaton of fixed capital 0 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 0 \n",
"Property-type income(005+006+007) 0 \n",
"Total of gross value 0 \n",
"Value of domestic products 657483 \n",
"\n",
" Government purchases.3 \\\n",
"Index \n",
"Agriculture,forestry,fishery 0 \n",
"Mining 0 \n",
"Foodstuffs 0 \n",
"Textile products 0 \n",
"Pulp, paper and wooden products 0 \n",
"Chemical products 0 \n",
"Petroleum products 0 \n",
"Ceramics, stone and clay products 0 \n",
"Iron, steel and its products 0 \n",
"Non-rerrous metals and its products 0 \n",
"Metal products 0 \n",
"General machinery 0 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 0 \n",
"Other manufactured products 0 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 0 \n",
"Other services 0 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 0 \n",
"Total amount of intermediate input (Japan) 0 \n",
"Agriculture,forestry,fishery 0 \n",
"Mining 0 \n",
"Foodstuffs 0 \n",
"Textile products 0 \n",
"Pulp, paper and wooden products 0 \n",
"... ... \n",
"Non-rerrous metals and its products 0 \n",
"Metal products 0 \n",
"General machinery 0 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 0 \n",
"Other manufactured products 0 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 0 \n",
"Other services 0 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 0 \n",
"Total amount of intermediate input (ROW) 0 \n",
"Customs duties 0 \n",
"Total amount of intermediate input 0 \n",
"Compensation for employees 0 \n",
"Other value added 0 \n",
"Indirect taxes + subsides 0 \n",
"Indirect taxes 0 \n",
"Current subsidies 0 \n",
"Operating surplus 0 \n",
"Depreciaton of fixed capital 0 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 0 \n",
"Property-type income(005+006+007) 0 \n",
"Total of gross value 0 \n",
"Value of domestic products 0 \n",
"\n",
" Total of domestic final demand(AS) \\\n",
"Index \n",
"Agriculture,forestry,fishery 231 \n",
"Mining 22 \n",
"Foodstuffs 1535 \n",
"Textile products 2723 \n",
"Pulp, paper and wooden products 322 \n",
"Chemical products 2222 \n",
"Petroleum products 224 \n",
"Ceramics, stone and clay products 426 \n",
"Iron, steel and its products 179 \n",
"Non-rerrous metals and its products 231 \n",
"Metal products 1848 \n",
"General machinery 54387 \n",
"Electric machinery 34163 \n",
"Automobiles 21262 \n",
"Other transport machinery 7898 \n",
"Precision machinery 8717 \n",
"Other manufactured products 3881 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 10444 \n",
"Transportation 1051 \n",
"Other services 6 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 602 \n",
"Total amount of intermediate input (Japan) 152374 \n",
"Agriculture,forestry,fishery 1005 \n",
"Mining -128 \n",
"Foodstuffs 2945 \n",
"Textile products 712 \n",
"Pulp, paper and wooden products 271 \n",
"... ... \n",
"Non-rerrous metals and its products 1042 \n",
"Metal products 34164 \n",
"General machinery 12815 \n",
"Electric machinery 8353 \n",
"Automobiles 1126 \n",
"Other transport machinery 15697 \n",
"Precision machinery 362 \n",
"Other manufactured products 8420 \n",
"Construction 499 \n",
"Electricity, water and gas supply 199 \n",
"Commerce 10 \n",
"Transportation 14356 \n",
"Other services 25695 \n",
"Government activities 156 \n",
"Activities not elsewhere classified,others 4109 \n",
"Total amount of intermediate input (ROW) 164583 \n",
"Customs duties 77923 \n",
"Total amount of intermediate input 6511733 \n",
"Compensation for employees 0 \n",
"Other value added 0 \n",
"Indirect taxes + subsides 0 \n",
"Indirect taxes 0 \n",
"Current subsidies 0 \n",
"Operating surplus 0 \n",
"Depreciaton of fixed capital 0 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 0 \n",
"Property-type income(005+006+007) 0 \n",
"Total of gross value 0 \n",
"Value of domestic products 6511733 \n",
"\n",
" Total of domestic final demand \\\n",
"Index \n",
"Agriculture,forestry,fishery 659745 \n",
"Mining 23326 \n",
"Foodstuffs 1366841 \n",
"Textile products 447031 \n",
"Pulp, paper and wooden products 459390 \n",
"Chemical products 643515 \n",
"Petroleum products 552248 \n",
"Ceramics, stone and clay products 330020 \n",
"Iron, steel and its products 465584 \n",
"Non-rerrous metals and its products 124400 \n",
"Metal products 598412 \n",
"General machinery 805540 \n",
"Electric machinery 1143994 \n",
"Automobiles 579966 \n",
"Other transport machinery 122678 \n",
"Precision machinery 159784 \n",
"Other manufactured products 863652 \n",
"Construction 2343798 \n",
"Electricity, water and gas supply 714770 \n",
"Commerce 2477638 \n",
"Transportation 928904 \n",
"Other services 6581542 \n",
"Government activities 486059 \n",
"Activities not elsewhere classified,others 816648 \n",
"Total amount of intermediate input (Japan) 23695485 \n",
"Agriculture,forestry,fishery 1327042 \n",
"Mining 1590612 \n",
"Foodstuffs 2732097 \n",
"Textile products 805724 \n",
"Pulp, paper and wooden products 1282865 \n",
"... ... \n",
"Non-rerrous metals and its products 97165 \n",
"Metal products 239595 \n",
"General machinery 310530 \n",
"Electric machinery 400586 \n",
"Automobiles 56236 \n",
"Other transport machinery 90327 \n",
"Precision machinery 43096 \n",
"Other manufactured products 671319 \n",
"Construction 59707 \n",
"Electricity, water and gas supply 3327 \n",
"Commerce 56084 \n",
"Transportation 309074 \n",
"Other services 367933 \n",
"Government activities 5421 \n",
"Activities not elsewhere classified,others 541312 \n",
"Total amount of intermediate input (ROW) 6633888 \n",
"Customs duties 440845 \n",
"Total amount of intermediate input 126998772 \n",
"Compensation for employees 42897741 \n",
"Other value added 32220787 \n",
"Indirect taxes + subsides 0 \n",
"Indirect taxes 0 \n",
"Current subsidies 0 \n",
"Operating surplus 0 \n",
"Depreciaton of fixed capital 0 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 0 \n",
"Property-type income(005+006+007) 0 \n",
"Total of gross value 75118528 \n",
"Value of domestic products 202117300 \n",
"\n",
" Exports to ROW \\\n",
"Index \n",
"Agriculture,forestry,fishery -125 \n",
"Mining -229 \n",
"Foodstuffs 1804 \n",
"Textile products 24549 \n",
"Pulp, paper and wooden products 4769 \n",
"Chemical products 33524 \n",
"Petroleum products 9647 \n",
"Ceramics, stone and clay products 7751 \n",
"Iron, steel and its products 45873 \n",
"Non-rerrous metals and its products 2904 \n",
"Metal products 7689 \n",
"General machinery 54119 \n",
"Electric machinery 128960 \n",
"Automobiles 121866 \n",
"Other transport machinery 61413 \n",
"Precision machinery 14257 \n",
"Other manufactured products 25089 \n",
"Construction 0 \n",
"Electricity, water and gas supply 911 \n",
"Commerce 42904 \n",
"Transportation 153997 \n",
"Other services 37257 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 38536 \n",
"Total amount of intermediate input (Japan) 817465 \n",
"Agriculture,forestry,fishery 81506 \n",
"Mining 32282 \n",
"Foodstuffs 92865 \n",
"Textile products 26873 \n",
"Pulp, paper and wooden products 35345 \n",
"... ... \n",
"Non-rerrous metals and its products 0 \n",
"Metal products 0 \n",
"General machinery 0 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 0 \n",
"Other manufactured products 0 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 0 \n",
"Other services 0 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 0 \n",
"Total amount of intermediate input (ROW) 0 \n",
"Customs duties 0 \n",
"Total amount of intermediate input 6412279 \n",
"Compensation for employees 0 \n",
"Other value added 14191 \n",
"Indirect taxes + subsides 12730 \n",
"Indirect taxes 0 \n",
"Current subsidies 0 \n",
"Operating surplus 0 \n",
"Depreciaton of fixed capital 0 \n",
"Value added tax not exemptable 1461 \n",
"Enterprise profit(006+007) 0 \n",
"Property-type income(005+006+007) 0 \n",
"Total of gross value 14191 \n",
"Value of domestic products 6426470 \n",
"\n",
" Total amount of final demand \\\n",
"Index \n",
"Agriculture,forestry,fishery 168074 \n",
"Mining -961 \n",
"Foodstuffs 1047417 \n",
"Textile products 297384 \n",
"Pulp, paper and wooden products 62052 \n",
"Chemical products 140475 \n",
"Petroleum products 129331 \n",
"Ceramics, stone and clay products 24576 \n",
"Iron, steel and its products 41287 \n",
"Non-rerrous metals and its products -7264 \n",
"Metal products 71221 \n",
"General machinery 621340 \n",
"Electric machinery 886848 \n",
"Automobiles 566437 \n",
"Other transport machinery 141873 \n",
"Precision machinery 134780 \n",
"Other manufactured products 253680 \n",
"Construction 2133319 \n",
"Electricity, water and gas supply 227970 \n",
"Commerce 1621922 \n",
"Transportation 532673 \n",
"Other services 4433907 \n",
"Government activities 471775 \n",
"Activities not elsewhere classified,others 57653 \n",
"Total amount of intermediate input (Japan) 14057769 \n",
"Agriculture,forestry,fishery 345888 \n",
"Mining 49772 \n",
"Foodstuffs 2143350 \n",
"Textile products 565657 \n",
"Pulp, paper and wooden products 393536 \n",
"... ... \n",
"Non-rerrous metals and its products 26133 \n",
"Metal products 153230 \n",
"General machinery 177352 \n",
"Electric machinery 309951 \n",
"Automobiles 33755 \n",
"Other transport machinery 67962 \n",
"Precision machinery 9239 \n",
"Other manufactured products 234124 \n",
"Construction 16131 \n",
"Electricity, water and gas supply 2649 \n",
"Commerce 3240 \n",
"Transportation 123204 \n",
"Other services 126468 \n",
"Government activities 5064 \n",
"Activities not elsewhere classified,others 371900 \n",
"Total amount of intermediate input (ROW) 2343454 \n",
"Customs duties 216972 \n",
"Total amount of intermediate input 81431869 \n",
"Compensation for employees 0 \n",
"Other value added 1034757 \n",
"Indirect taxes + subsides 107967 \n",
"Indirect taxes 0 \n",
"Current subsidies 0 \n",
"Operating surplus 0 \n",
"Depreciaton of fixed capital 0 \n",
"Value added tax not exemptable 926790 \n",
"Enterprise profit(006+007) 0 \n",
"Property-type income(005+006+007) 0 \n",
"Total of gross value 1034757 \n",
"Value of domestic products 82466626 \n",
"\n",
" Total of domestic products \n",
"Index \n",
"Agriculture,forestry,fishery 659620 \n",
"Mining 23097 \n",
"Foodstuffs 1368645 \n",
"Textile products 471580 \n",
"Pulp, paper and wooden products 464159 \n",
"Chemical products 677039 \n",
"Petroleum products 561895 \n",
"Ceramics, stone and clay products 337771 \n",
"Iron, steel and its products 511457 \n",
"Non-rerrous metals and its products 127304 \n",
"Metal products 606101 \n",
"General machinery 859659 \n",
"Electric machinery 1272954 \n",
"Automobiles 701832 \n",
"Other transport machinery 184091 \n",
"Precision machinery 174041 \n",
"Other manufactured products 888741 \n",
"Construction 2343798 \n",
"Electricity, water and gas supply 715681 \n",
"Commerce 2520542 \n",
"Transportation 1082901 \n",
"Other services 6618799 \n",
"Government activities 486059 \n",
"Activities not elsewhere classified,others 855184 \n",
"Total amount of intermediate input (Japan) 24512950 \n",
"Agriculture,forestry,fishery 1408548 \n",
"Mining 1622894 \n",
"Foodstuffs 2824962 \n",
"Textile products 832597 \n",
"Pulp, paper and wooden products 1318210 \n",
"... ... \n",
"Non-rerrous metals and its products 97165 \n",
"Metal products 239595 \n",
"General machinery 310530 \n",
"Electric machinery 400586 \n",
"Automobiles 56236 \n",
"Other transport machinery 90327 \n",
"Precision machinery 43096 \n",
"Other manufactured products 671319 \n",
"Construction 59707 \n",
"Electricity, water and gas supply 3327 \n",
"Commerce 56084 \n",
"Transportation 309074 \n",
"Other services 367933 \n",
"Government activities 5421 \n",
"Activities not elsewhere classified,others 541312 \n",
"Total amount of intermediate input (ROW) 6633888 \n",
"Customs duties 440845 \n",
"Total amount of intermediate input 133411051 \n",
"Compensation for employees 42897741 \n",
"Other value added 32234978 \n",
"Indirect taxes + subsides 0 \n",
"Indirect taxes 0 \n",
"Current subsidies 0 \n",
"Operating surplus 0 \n",
"Depreciaton of fixed capital 0 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 0 \n",
"Property-type income(005+006+007) 0 \n",
"Total of gross value 75132719 \n",
"Value of domestic products 208543770 \n",
"\n",
"[141 rows x 137 columns]"
]
},
"execution_count": 84,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.7.3"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
{
"cells": [
{
"cell_type": "markdown",
"metadata": {
"collapsed": true
},
"source": [
"# Data Go.JP\n",
"### https://www.data.go.jp/for-developer/for-developer/"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"# conda create -n <environment's name> anaconda\n",
"# conda create -n dsw anaconda\n",
"# https://qiita.com/ozaki_physics/items/985188feb92570e5b82d"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"api.xlsx datagojp.ipynb\r\n"
]
}
],
"source": [
"!ls"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd\n",
"import requests\n",
"import io"
]
},
{
"cell_type": "code",
"execution_count": 24,
"metadata": {},
"outputs": [],
"source": [
"manual = pd.read_excel(\"api.xlsx\")\n",
"manual = manual[:-2]\n",
"mnl = manual[[\"API\", \"説明\", \"引数\", \"パラメータ説明\"]]"
]
},
{
"cell_type": "code",
"execution_count": 26,
"metadata": {},
"outputs": [],
"source": [
"mnl[\"API\"].fillna(method='ffill', inplace=True)\n",
"mnl[\"説明\"].fillna(method='ffill', inplace=True)"
]
},
{
"cell_type": "code",
"execution_count": 30,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/anaconda/envs/dsw/lib/python3.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
"A value is trying to be set on a copy of a slice from a DataFrame.\n",
"Try using .loc[row_indexer,col_indexer] = value instead\n",
"\n",
"See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
" \"\"\"Entry point for launching an IPython kernel.\n"
]
}
],
"source": [
"mnl[\"API\"] = \"https://www.data.go.jp/data/\" + mnl[\"API\"]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# APIを利用したメタデータの取得例 ：\t\t\t\t\n",
"\n",
"#### (ア)組織に関するメタデータの取得： \t\t\t\t\t\n",
"- 登録されている組織の一覧 \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/organization_list\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- 登録されている組織の一覧(各組織のメタ情報も取得） \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/organization_list?all_fields=true\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- 登録されている組織の一覧（各組織のメタ情報を取得し、且つ組織のデータセット登録数順でソート） \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/organization_list?all_fields=true&order_by=packages\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- 指定した組織「内閣府」の詳細情報 \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/organization_show?id=org_0400\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"#### (イ)グループに関するメタデータの取得： \t\t\t\t\t\n",
"- 登録されているグループの一覧 \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/organization_list\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- 指定したグループ「行財政」の詳細情報\t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/group_show?id=gr_1300\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"#### (ウ)タグに関するメタデータの取得： \t\t\t\t\t\n",
"- タグの一覧 \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/tag_list\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- 指定したタグ「統計」を含むデータセット名の一覧（10件取得指定） \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/package_search?q=*:*&facet.limit=10&facet.field=[\"title_string\"]&fq=tags:統計&rows=0\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- キーワード「統計」を含むタグの検索 \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/tag_search?query=統計\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"#### (エ)データセットやリソースに関するメタデータの取得： \t\t\t\t\t\n",
"- 検索条件に合うデータセット「平成26年_新規登録、更新情報」が属しているグループ名の一覧 \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/package_search?q=*:*&facet.limit=10&facet.field=[\"groups\"]&fq=tags:統計&rows=0\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- 検索条件に合うデータセット「高度情報通信ネットワーク社会の形成に関する予算_平成26年度」とそのデータセットに含まれるリソースの一覧 \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/package_search?q=name:cas_20140901_0000\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- 指定したデータセット「高度情報通信ネットワーク社会の形成に関する予算_平成26年度」のメタデータ情報 \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/package_show?id=高度情報通信ネットワーク社会の形成に関する予算_平成26年度\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- 指定したリソース「高度情報通信ネットワーク社会の形成に関する平成26年度予算について（府省庁別）_HTML」のメタデータ情報 \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/resource_show?id=高度情報通信ネットワーク社会の形成に関する平成26年度予算について（府省庁別）_HTML\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- キーワード「統計」を含むデータセットの検索（10件取得指定） \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/package_search?q=統計&limit=10\t\t\t\t\t\n",
"\t\t\t\t\t\n",
"- 「name」属性にキーワード「統計」を含むリソースの検索（10件取得指定） \t\t\t\t\t\n",
"　　https://www.data.go.jp/data/api/action/resource_search?query=name:統計&limit=10\t\t\t\t\t"
]
},
{
"cell_type": "code",
"execution_count": 31,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>API</th>\n",
" <th>説明</th>\n",
" <th>引数</th>\n",
" <th>パラメータ説明</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセット一覧を取得する。</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>https://www.data.go.jp/data/api/action/current...</td>\n",
" <td>データセット一覧(リソースを含む)を取得する。</td>\n",
" <td>limit</td>\n",
" <td>取得する最大のデータセット件数を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>https://www.data.go.jp/data/api/action/current...</td>\n",
" <td>データセット一覧(リソースを含む)を取得する。</td>\n",
" <td>page</td>\n",
" <td>「limit」の値で複数ページに分割されたデータセット一覧から、返却対象とするページの番号を...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>https://www.data.go.jp/data/api/action/group_list</td>\n",
" <td>グループ一覧を取得する。</td>\n",
" <td>order_by</td>\n",
" <td>nameでソートする場合は「name」、データセット数でソートする場合は「packages」...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>https://www.data.go.jp/data/api/action/group_list</td>\n",
" <td>グループ一覧を取得する。</td>\n",
" <td>groups</td>\n",
" <td>取得するグループの名称を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>https://www.data.go.jp/data/api/action/group_list</td>\n",
" <td>グループ一覧を取得する。</td>\n",
" <td>all_fields</td>\n",
" <td>すべてメタデータ項目を取得する場合は「true」、\\n「name」のみを取得する場合は「fa...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>https://www.data.go.jp/data/api/action/organiz...</td>\n",
" <td>組織一覧を取得する。</td>\n",
" <td>order_by</td>\n",
" <td>nameでソートする場合は「name」、データセット数でソートする場合は「packages」...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>https://www.data.go.jp/data/api/action/organiz...</td>\n",
" <td>組織一覧を取得する。</td>\n",
" <td>organizations</td>\n",
" <td>取得する組織の名称を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>https://www.data.go.jp/data/api/action/organiz...</td>\n",
" <td>組織一覧を取得する。</td>\n",
" <td>all_fields</td>\n",
" <td>すべてメタデータ項目を取得する場合は「true」、\\n「name」のみを取得する場合は「fa...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>https://www.data.go.jp/data/api/action/license...</td>\n",
" <td>ライセンス一覧を取得する。</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>https://www.data.go.jp/data/api/action/tag_list</td>\n",
" <td>タグ一覧を取得する。</td>\n",
" <td>query</td>\n",
" <td>取得するタグに含まれる文字列を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>https://www.data.go.jp/data/api/action/tag_list</td>\n",
" <td>タグ一覧を取得する。</td>\n",
" <td>all_fields</td>\n",
" <td>すべてメタデータ項目を取得する場合は「true」、\\n「name」のみを取得する場合は「fa...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセットの詳細を取得する。</td>\n",
" <td>id</td>\n",
" <td>取得するデータセットの「id」または、「name」を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>https://www.data.go.jp/data/api/action/resourc...</td>\n",
" <td>リソースの詳細を取得する。</td>\n",
" <td>id</td>\n",
" <td>取得するリソースの「id」を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>https://www.data.go.jp/data/api/action/group_show</td>\n",
" <td>グループの詳細を取得する。</td>\n",
" <td>id</td>\n",
" <td>取得するグループの「id」を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>https://www.data.go.jp/data/api/action/organiz...</td>\n",
" <td>組織の詳細を取得する。</td>\n",
" <td>id</td>\n",
" <td>取得する組織の「id」または、「name」を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>https://www.data.go.jp/data/api/action/group_p...</td>\n",
" <td>グループのデータセット一覧を取得する。</td>\n",
" <td>id</td>\n",
" <td>取得するグループの「id」または、「name」を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>https://www.data.go.jp/data/api/action/group_p...</td>\n",
" <td>グループのデータセット一覧を取得する。</td>\n",
" <td>limit</td>\n",
" <td>取得する最大のグループ数を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>https://www.data.go.jp/data/api/action/tag_show</td>\n",
" <td>タグの詳細を取得する。</td>\n",
" <td>id</td>\n",
" <td>取得するタグの「id」または、「name」を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセットを検索する。</td>\n",
" <td>q</td>\n",
" <td>データセットの検索クエリを指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセットを検索する。</td>\n",
" <td>fq</td>\n",
" <td>検索フィルターを指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセットを検索する。</td>\n",
" <td>sort</td>\n",
" <td>データセット一覧のソート順を指定する。\\n注：フィールド名称とソート順（「asc」または「d...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセットを検索する。</td>\n",
" <td>rows</td>\n",
" <td>取得するデータセット数を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセットを検索する。</td>\n",
" <td>start</td>\n",
" <td>複数ページに分割されたデータセット一覧を表示する場合、表示を開始するページ番号を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセットを検索する。</td>\n",
" <td>facet</td>\n",
" <td>ファセットを有効化する場合は「true」、\\n無効化する場合は「false」を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセットを検索する。</td>\n",
" <td>facet.mincount</td>\n",
" <td>ファセットが含むデータセットの最小数を指定する。\\nこの値よりもファセットが含むデータセット...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセットを検索する。</td>\n",
" <td>facet.limit</td>\n",
" <td>ファセットの最大取得数を指定する。\\n0より小さい値を指定した場合は全て取得される。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセットを検索する。</td>\n",
" <td>facet.field</td>\n",
" <td>ファセットを生成する対象のフィールド名を指定する。\\n指定しなかった場合、ファセットは空値で...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>https://www.data.go.jp/data/api/action/resourc...</td>\n",
" <td>リソースを検索する。</td>\n",
" <td>query</td>\n",
" <td>リソースの検索クエリを指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>https://www.data.go.jp/data/api/action/resourc...</td>\n",
" <td>リソースを検索する。</td>\n",
" <td>order_by</td>\n",
" <td>リソース一覧のソート順を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>https://www.data.go.jp/data/api/action/resourc...</td>\n",
" <td>リソースを検索する。</td>\n",
" <td>limit</td>\n",
" <td>取得する最大のデータセット件数を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>https://www.data.go.jp/data/api/action/resourc...</td>\n",
" <td>リソースを検索する。</td>\n",
" <td>offset</td>\n",
" <td>取得するオフセットの番号を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>https://www.data.go.jp/data/api/action/tag_search</td>\n",
" <td>指定した文字列が含まれたタグを検索する。</td>\n",
" <td>query</td>\n",
" <td>検索する文字列を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>https://www.data.go.jp/data/api/action/tag_search</td>\n",
" <td>指定した文字列が含まれたタグを検索する。</td>\n",
" <td>limit</td>\n",
" <td>取得する最大のタグ数を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>https://www.data.go.jp/data/api/action/tag_search</td>\n",
" <td>指定した文字列が含まれたタグを検索する。</td>\n",
" <td>offset</td>\n",
" <td>取得するオフセットの番号を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセット更新履歴を取得する。</td>\n",
" <td>id</td>\n",
" <td>取得するデータセットの「id」または、「name」を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセット更新履歴を取得する。</td>\n",
" <td>limit</td>\n",
" <td>取得する最大のアクティビティ数を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td>https://www.data.go.jp/data/api/action/package...</td>\n",
" <td>データセット更新履歴を取得する。</td>\n",
" <td>offset</td>\n",
" <td>取得するオフセットの番号を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td>https://www.data.go.jp/data/api/action/group_a...</td>\n",
" <td>グループ更新履歴を取得する。</td>\n",
" <td>id</td>\n",
" <td>取得するグループの「id」または、「name」を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>https://www.data.go.jp/data/api/action/group_a...</td>\n",
" <td>グループ更新履歴を取得する。</td>\n",
" <td>limit</td>\n",
" <td>取得する最大のアクティビティ数を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>https://www.data.go.jp/data/api/action/group_a...</td>\n",
" <td>グループ更新履歴を取得する。</td>\n",
" <td>offset</td>\n",
" <td>取得するオフセットの番号を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>https://www.data.go.jp/data/api/action/organiz...</td>\n",
" <td>組織更新履歴を取得する。</td>\n",
" <td>id</td>\n",
" <td>取得する組織の「id」または、「name」を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>https://www.data.go.jp/data/api/action/recentl...</td>\n",
" <td>最近更新されたデータセット履歴を取得する。</td>\n",
" <td>limit</td>\n",
" <td>取得する最大のアクティビティ数を指定する。</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td>https://www.data.go.jp/data/api/action/recentl...</td>\n",
" <td>最近更新されたデータセット履歴を取得する。</td>\n",
" <td>offset</td>\n",
" <td>取得するオフセットの番号を指定する。</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" API \\\n",
"0 https://www.data.go.jp/data/api/action/package... \n",
"1 https://www.data.go.jp/data/api/action/current... \n",
"2 https://www.data.go.jp/data/api/action/current... \n",
"3 https://www.data.go.jp/data/api/action/group_list \n",
"4 https://www.data.go.jp/data/api/action/group_list \n",
"5 https://www.data.go.jp/data/api/action/group_list \n",
"6 https://www.data.go.jp/data/api/action/organiz... \n",
"7 https://www.data.go.jp/data/api/action/organiz... \n",
"8 https://www.data.go.jp/data/api/action/organiz... \n",
"9 https://www.data.go.jp/data/api/action/license... \n",
"10 https://www.data.go.jp/data/api/action/tag_list \n",
"11 https://www.data.go.jp/data/api/action/tag_list \n",
"12 https://www.data.go.jp/data/api/action/package... \n",
"13 https://www.data.go.jp/data/api/action/resourc... \n",
"14 https://www.data.go.jp/data/api/action/group_show \n",
"15 https://www.data.go.jp/data/api/action/organiz... \n",
"16 https://www.data.go.jp/data/api/action/group_p... \n",
"17 https://www.data.go.jp/data/api/action/group_p... \n",
"18 https://www.data.go.jp/data/api/action/tag_show \n",
"19 https://www.data.go.jp/data/api/action/package... \n",
"20 https://www.data.go.jp/data/api/action/package... \n",
"21 https://www.data.go.jp/data/api/action/package... \n",
"22 https://www.data.go.jp/data/api/action/package... \n",
"23 https://www.data.go.jp/data/api/action/package... \n",
"24 https://www.data.go.jp/data/api/action/package... \n",
"25 https://www.data.go.jp/data/api/action/package... \n",
"26 https://www.data.go.jp/data/api/action/package... \n",
"27 https://www.data.go.jp/data/api/action/package... \n",
"28 https://www.data.go.jp/data/api/action/resourc... \n",
"29 https://www.data.go.jp/data/api/action/resourc... \n",
"30 https://www.data.go.jp/data/api/action/resourc... \n",
"31 https://www.data.go.jp/data/api/action/resourc... \n",
"32 https://www.data.go.jp/data/api/action/tag_search \n",
"33 https://www.data.go.jp/data/api/action/tag_search \n",
"34 https://www.data.go.jp/data/api/action/tag_search \n",
"35 https://www.data.go.jp/data/api/action/package... \n",
"36 https://www.data.go.jp/data/api/action/package... \n",
"37 https://www.data.go.jp/data/api/action/package... \n",
"38 https://www.data.go.jp/data/api/action/group_a... \n",
"39 https://www.data.go.jp/data/api/action/group_a... \n",
"40 https://www.data.go.jp/data/api/action/group_a... \n",
"41 https://www.data.go.jp/data/api/action/organiz... \n",
"42 https://www.data.go.jp/data/api/action/recentl... \n",
"43 https://www.data.go.jp/data/api/action/recentl... \n",
"\n",
" 説明 引数 \\\n",
"0 データセット一覧を取得する。 - \n",
"1 データセット一覧(リソースを含む)を取得する。 limit \n",
"2 データセット一覧(リソースを含む)を取得する。 page \n",
"3 グループ一覧を取得する。 order_by \n",
"4 グループ一覧を取得する。 groups \n",
"5 グループ一覧を取得する。 all_fields \n",
"6 組織一覧を取得する。 order_by \n",
"7 組織一覧を取得する。 organizations \n",
"8 組織一覧を取得する。 all_fields \n",
"9 ライセンス一覧を取得する。 - \n",
"10 タグ一覧を取得する。 query \n",
"11 タグ一覧を取得する。 all_fields \n",
"12 データセットの詳細を取得する。 id \n",
"13 リソースの詳細を取得する。 id \n",
"14 グループの詳細を取得する。 id \n",
"15 組織の詳細を取得する。 id \n",
"16 グループのデータセット一覧を取得する。 id \n",
"17 グループのデータセット一覧を取得する。 limit \n",
"18 タグの詳細を取得する。 id \n",
"19 データセットを検索する。 q \n",
"20 データセットを検索する。 fq \n",
"21 データセットを検索する。 sort \n",
"22 データセットを検索する。 rows \n",
"23 データセットを検索する。 start \n",
"24 データセットを検索する。 facet \n",
"25 データセットを検索する。 facet.mincount \n",
"26 データセットを検索する。 facet.limit \n",
"27 データセットを検索する。 facet.field \n",
"28 リソースを検索する。 query \n",
"29 リソースを検索する。 order_by \n",
"30 リソースを検索する。 limit \n",
"31 リソースを検索する。 offset \n",
"32 指定した文字列が含まれたタグを検索する。 query \n",
"33 指定した文字列が含まれたタグを検索する。 limit \n",
"34 指定した文字列が含まれたタグを検索する。 offset \n",
"35 データセット更新履歴を取得する。 id \n",
"36 データセット更新履歴を取得する。 limit \n",
"37 データセット更新履歴を取得する。 offset \n",
"38 グループ更新履歴を取得する。 id \n",
"39 グループ更新履歴を取得する。 limit \n",
"40 グループ更新履歴を取得する。 offset \n",
"41 組織更新履歴を取得する。 id \n",
"42 最近更新されたデータセット履歴を取得する。 limit \n",
"43 最近更新されたデータセット履歴を取得する。 offset \n",
"\n",
" パラメータ説明 \n",
"0 - \n",
"1 取得する最大のデータセット件数を指定する。 \n",
"2 「limit」の値で複数ページに分割されたデータセット一覧から、返却対象とするページの番号を... \n",
"3 nameでソートする場合は「name」、データセット数でソートする場合は「packages」... \n",
"4 取得するグループの名称を指定する。 \n",
"5 すべてメタデータ項目を取得する場合は「true」、\\n「name」のみを取得する場合は「fa... \n",
"6 nameでソートする場合は「name」、データセット数でソートする場合は「packages」... \n",
"7 取得する組織の名称を指定する。 \n",
"8 すべてメタデータ項目を取得する場合は「true」、\\n「name」のみを取得する場合は「fa... \n",
"9 - \n",
"10 取得するタグに含まれる文字列を指定する。 \n",
"11 すべてメタデータ項目を取得する場合は「true」、\\n「name」のみを取得する場合は「fa... \n",
"12 取得するデータセットの「id」または、「name」を指定する。 \n",
"13 取得するリソースの「id」を指定する。 \n",
"14 取得するグループの「id」を指定する。 \n",
"15 取得する組織の「id」または、「name」を指定する。 \n",
"16 取得するグループの「id」または、「name」を指定する。 \n",
"17 取得する最大のグループ数を指定する。 \n",
"18 取得するタグの「id」または、「name」を指定する。 \n",
"19 データセットの検索クエリを指定する。 \n",
"20 検索フィルターを指定する。 \n",
"21 データセット一覧のソート順を指定する。\\n注：フィールド名称とソート順（「asc」または「d... \n",
"22 取得するデータセット数を指定する。 \n",
"23 複数ページに分割されたデータセット一覧を表示する場合、表示を開始するページ番号を指定する。 \n",
"24 ファセットを有効化する場合は「true」、\\n無効化する場合は「false」を指定する。 \n",
"25 ファセットが含むデータセットの最小数を指定する。\\nこの値よりもファセットが含むデータセット... \n",
"26 ファセットの最大取得数を指定する。\\n0より小さい値を指定した場合は全て取得される。 \n",
"27 ファセットを生成する対象のフィールド名を指定する。\\n指定しなかった場合、ファセットは空値で... \n",
"28 リソースの検索クエリを指定する。 \n",
"29 リソース一覧のソート順を指定する。 \n",
"30 取得する最大のデータセット件数を指定する。 \n",
"31 取得するオフセットの番号を指定する。 \n",
"32 検索する文字列を指定する。 \n",
"33 取得する最大のタグ数を指定する。 \n",
"34 取得するオフセットの番号を指定する。 \n",
"35 取得するデータセットの「id」または、「name」を指定する。 \n",
"36 取得する最大のアクティビティ数を指定する。 \n",
"37 取得するオフセットの番号を指定する。 \n",
"38 取得するグループの「id」または、「name」を指定する。 \n",
"39 取得する最大のアクティビティ数を指定する。 \n",
"40 取得するオフセットの番号を指定する。 \n",
"41 取得する組織の「id」または、「name」を指定する。 \n",
"42 取得する最大のアクティビティ数を指定する。 \n",
"43 取得するオフセットの番号を指定する。 "
]
},
"execution_count": 31,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# view the manual\n",
"mnl"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Example"
]
},
{
"cell_type": "code",
"execution_count": 40,
"metadata": {},
"outputs": [],
"source": [
"url = 'https://www.data.go.jp/data/api/action/resource_search?query=name:統計&limit=10'\n",
"resp = requests.get(url)\n",
"assert resp.status_code == 200"
]
},
{
"cell_type": "code",
"execution_count": 52,
"metadata": {},
"outputs": [],
"source": [
"j = resp.json()\n",
"df = pd.DataFrame.from_dict(j[\"result\"][\"results\"])"
]
},
{
"cell_type": "code",
"execution_count": 64,
"metadata": {},
"outputs": [],
"source": [
"dls = df[\"url\"][0]\n",
"resp = requests.get(dls)\n",
"assert resp.status_code == 200"
]
},
{
"cell_type": "code",
"execution_count": 75,
"metadata": {},
"outputs": [],
"source": [
"with io.BytesIO(resp.content) as fh:\n",
" df = pd.io.excel.read_excel(fh, header=5, sheet_name=0)"
]
},
{
"cell_type": "code",
"execution_count": 78,
"metadata": {},
"outputs": [],
"source": [
"df.drop([\"Unnamed: 0\", \"Unnamed: 1\", \"Unnamed: 2\"], axis=1, inplace=True)"
]
},
{
"cell_type": "code",
"execution_count": 81,
"metadata": {},
"outputs": [],
"source": [
"df.rename(columns={\"Unnamed: 3\":\"Index\"}, inplace=True)\n",
"df.set_index(\"Index\", inplace=True)"
]
},
{
"cell_type": "code",
"execution_count": 84,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Agriculture,forestry,fishery</th>\n",
" <th>Mining</th>\n",
" <th>Foodstuffs</th>\n",
" <th>Textile products</th>\n",
" <th>Pulp, paper and wooden products</th>\n",
" <th>Chemical products</th>\n",
" <th>Petroleum products</th>\n",
" <th>Ceramics, stone and clay products</th>\n",
" <th>Iron, steel and its products</th>\n",
" <th>Non-rerrous metals and its products</th>\n",
" <th>...</th>\n",
" <th>Change in inventories.3</th>\n",
" <th>Other domestic final demand(AS)</th>\n",
" <th>Total fixed capital formation.3</th>\n",
" <th>Government consumption expenditures.3</th>\n",
" <th>Government purchases.3</th>\n",
" <th>Total of domestic final demand(AS)</th>\n",
" <th>Total of domestic final demand</th>\n",
" <th>Exports to ROW</th>\n",
" <th>Total amount of final demand</th>\n",
" <th>Total of domestic products</th>\n",
" </tr>\n",
" <tr>\n",
" <th>Index</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>Agriculture,forestry,fishery</th>\n",
" <td>1381</td>\n",
" <td>230</td>\n",
" <td>395026</td>\n",
" <td>3560</td>\n",
" <td>26785</td>\n",
" <td>1041</td>\n",
" <td>4</td>\n",
" <td>10</td>\n",
" <td>45</td>\n",
" <td>3</td>\n",
" <td>...</td>\n",
" <td>37</td>\n",
" <td>21</td>\n",
" <td>19</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>231</td>\n",
" <td>659745</td>\n",
" <td>-125</td>\n",
" <td>168074</td>\n",
" <td>659620</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Mining</th>\n",
" <td>80</td>\n",
" <td>0</td>\n",
" <td>1006</td>\n",
" <td>15</td>\n",
" <td>331</td>\n",
" <td>1500</td>\n",
" <td>851</td>\n",
" <td>1036</td>\n",
" <td>3856</td>\n",
" <td>2913</td>\n",
" <td>...</td>\n",
" <td>18</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>22</td>\n",
" <td>23326</td>\n",
" <td>-229</td>\n",
" <td>-961</td>\n",
" <td>23097</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Foodstuffs</th>\n",
" <td>67104</td>\n",
" <td>0</td>\n",
" <td>17003</td>\n",
" <td>-24</td>\n",
" <td>680</td>\n",
" <td>5938</td>\n",
" <td>1</td>\n",
" <td>127</td>\n",
" <td>4</td>\n",
" <td>1</td>\n",
" <td>...</td>\n",
" <td>97</td>\n",
" <td>14</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>0</td>\n",
" <td>1535</td>\n",
" <td>1366841</td>\n",
" <td>1804</td>\n",
" <td>1047417</td>\n",
" <td>1368645</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Textile products</th>\n",
" <td>4500</td>\n",
" <td>45</td>\n",
" <td>1196</td>\n",
" <td>88353</td>\n",
" <td>2798</td>\n",
" <td>621</td>\n",
" <td>128</td>\n",
" <td>878</td>\n",
" <td>277</td>\n",
" <td>73</td>\n",
" <td>...</td>\n",
" <td>247</td>\n",
" <td>45</td>\n",
" <td>15</td>\n",
" <td>30</td>\n",
" <td>0</td>\n",
" <td>2723</td>\n",
" <td>447031</td>\n",
" <td>24549</td>\n",
" <td>297384</td>\n",
" <td>471580</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Pulp, paper and wooden products</th>\n",
" <td>8455</td>\n",
" <td>316</td>\n",
" <td>25651</td>\n",
" <td>6147</td>\n",
" <td>10563</td>\n",
" <td>17287</td>\n",
" <td>67</td>\n",
" <td>6798</td>\n",
" <td>576</td>\n",
" <td>96</td>\n",
" <td>...</td>\n",
" <td>29</td>\n",
" <td>54</td>\n",
" <td>22</td>\n",
" <td>32</td>\n",
" <td>0</td>\n",
" <td>322</td>\n",
" <td>459390</td>\n",
" <td>4769</td>\n",
" <td>62052</td>\n",
" <td>464159</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Chemical products</th>\n",
" <td>32360</td>\n",
" <td>237</td>\n",
" <td>15417</td>\n",
" <td>36315</td>\n",
" <td>18693</td>\n",
" <td>0</td>\n",
" <td>1996</td>\n",
" <td>6424</td>\n",
" <td>6104</td>\n",
" <td>676</td>\n",
" <td>...</td>\n",
" <td>288</td>\n",
" <td>246</td>\n",
" <td>1</td>\n",
" <td>245</td>\n",
" <td>0</td>\n",
" <td>2222</td>\n",
" <td>643515</td>\n",
" <td>33524</td>\n",
" <td>140475</td>\n",
" <td>677039</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Petroleum products</th>\n",
" <td>17992</td>\n",
" <td>871</td>\n",
" <td>9757</td>\n",
" <td>6071</td>\n",
" <td>13501</td>\n",
" <td>35755</td>\n",
" <td>0</td>\n",
" <td>22506</td>\n",
" <td>9875</td>\n",
" <td>2246</td>\n",
" <td>...</td>\n",
" <td>63</td>\n",
" <td>100</td>\n",
" <td>0</td>\n",
" <td>100</td>\n",
" <td>0</td>\n",
" <td>224</td>\n",
" <td>552248</td>\n",
" <td>9647</td>\n",
" <td>129331</td>\n",
" <td>561895</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Ceramics, stone and clay products</th>\n",
" <td>1059</td>\n",
" <td>78</td>\n",
" <td>11439</td>\n",
" <td>115</td>\n",
" <td>2915</td>\n",
" <td>4068</td>\n",
" <td>1934</td>\n",
" <td>2674</td>\n",
" <td>2736</td>\n",
" <td>15</td>\n",
" <td>...</td>\n",
" <td>-17</td>\n",
" <td>107</td>\n",
" <td>101</td>\n",
" <td>6</td>\n",
" <td>0</td>\n",
" <td>426</td>\n",
" <td>330020</td>\n",
" <td>7751</td>\n",
" <td>24576</td>\n",
" <td>337771</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Iron, steel and its products</th>\n",
" <td>22</td>\n",
" <td>352</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>1206</td>\n",
" <td>3457</td>\n",
" <td>0</td>\n",
" <td>4015</td>\n",
" <td>0</td>\n",
" <td>703</td>\n",
" <td>...</td>\n",
" <td>70</td>\n",
" <td>103</td>\n",
" <td>70</td>\n",
" <td>33</td>\n",
" <td>0</td>\n",
" <td>179</td>\n",
" <td>465584</td>\n",
" <td>45873</td>\n",
" <td>41287</td>\n",
" <td>511457</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Non-rerrous metals and its products</th>\n",
" <td>0</td>\n",
" <td>5</td>\n",
" <td>1452</td>\n",
" <td>17</td>\n",
" <td>320</td>\n",
" <td>3281</td>\n",
" <td>28</td>\n",
" <td>697</td>\n",
" <td>7602</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>-63</td>\n",
" <td>226</td>\n",
" <td>202</td>\n",
" <td>24</td>\n",
" <td>0</td>\n",
" <td>231</td>\n",
" <td>124400</td>\n",
" <td>2904</td>\n",
" <td>-7264</td>\n",
" <td>127304</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Metal products</th>\n",
" <td>1193</td>\n",
" <td>619</td>\n",
" <td>24026</td>\n",
" <td>1627</td>\n",
" <td>7267</td>\n",
" <td>8772</td>\n",
" <td>1609</td>\n",
" <td>2539</td>\n",
" <td>378</td>\n",
" <td>63</td>\n",
" <td>...</td>\n",
" <td>-294</td>\n",
" <td>1500</td>\n",
" <td>1157</td>\n",
" <td>343</td>\n",
" <td>0</td>\n",
" <td>1848</td>\n",
" <td>598412</td>\n",
" <td>7689</td>\n",
" <td>71221</td>\n",
" <td>606101</td>\n",
" </tr>\n",
" <tr>\n",
" <th>General machinery</th>\n",
" <td>5327</td>\n",
" <td>420</td>\n",
" <td>6339</td>\n",
" <td>1798</td>\n",
" <td>3164</td>\n",
" <td>7259</td>\n",
" <td>2785</td>\n",
" <td>5941</td>\n",
" <td>5362</td>\n",
" <td>759</td>\n",
" <td>...</td>\n",
" <td>-669</td>\n",
" <td>54206</td>\n",
" <td>52807</td>\n",
" <td>1399</td>\n",
" <td>0</td>\n",
" <td>54387</td>\n",
" <td>805540</td>\n",
" <td>54119</td>\n",
" <td>621340</td>\n",
" <td>859659</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Electric machinery</th>\n",
" <td>206</td>\n",
" <td>174</td>\n",
" <td>129</td>\n",
" <td>524</td>\n",
" <td>150</td>\n",
" <td>2383</td>\n",
" <td>2393</td>\n",
" <td>1209</td>\n",
" <td>5209</td>\n",
" <td>1928</td>\n",
" <td>...</td>\n",
" <td>2365</td>\n",
" <td>15374</td>\n",
" <td>14639</td>\n",
" <td>735</td>\n",
" <td>0</td>\n",
" <td>34163</td>\n",
" <td>1143994</td>\n",
" <td>128960</td>\n",
" <td>886848</td>\n",
" <td>1272954</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Automobiles</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>1834</td>\n",
" <td>18356</td>\n",
" <td>17337</td>\n",
" <td>1019</td>\n",
" <td>0</td>\n",
" <td>21262</td>\n",
" <td>579966</td>\n",
" <td>121866</td>\n",
" <td>566437</td>\n",
" <td>701832</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Other transport machinery</th>\n",
" <td>3129</td>\n",
" <td>2</td>\n",
" <td>16</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>5</td>\n",
" <td>2</td>\n",
" <td>31</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>-1345</td>\n",
" <td>8781</td>\n",
" <td>7621</td>\n",
" <td>1160</td>\n",
" <td>0</td>\n",
" <td>7898</td>\n",
" <td>122678</td>\n",
" <td>61413</td>\n",
" <td>141873</td>\n",
" <td>184091</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Precision machinery</th>\n",
" <td>19</td>\n",
" <td>0</td>\n",
" <td>11</td>\n",
" <td>12</td>\n",
" <td>16</td>\n",
" <td>107</td>\n",
" <td>5</td>\n",
" <td>16</td>\n",
" <td>15</td>\n",
" <td>6</td>\n",
" <td>...</td>\n",
" <td>253</td>\n",
" <td>7135</td>\n",
" <td>6878</td>\n",
" <td>257</td>\n",
" <td>0</td>\n",
" <td>8717</td>\n",
" <td>159784</td>\n",
" <td>14257</td>\n",
" <td>134780</td>\n",
" <td>174041</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Other manufactured products</th>\n",
" <td>7103</td>\n",
" <td>358</td>\n",
" <td>26618</td>\n",
" <td>12961</td>\n",
" <td>28083</td>\n",
" <td>17831</td>\n",
" <td>1338</td>\n",
" <td>3436</td>\n",
" <td>1858</td>\n",
" <td>347</td>\n",
" <td>...</td>\n",
" <td>52</td>\n",
" <td>1015</td>\n",
" <td>859</td>\n",
" <td>156</td>\n",
" <td>0</td>\n",
" <td>3881</td>\n",
" <td>863652</td>\n",
" <td>25089</td>\n",
" <td>253680</td>\n",
" <td>888741</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Construction</th>\n",
" <td>1858</td>\n",
" <td>113</td>\n",
" <td>2762</td>\n",
" <td>925</td>\n",
" <td>1636</td>\n",
" <td>3937</td>\n",
" <td>832</td>\n",
" <td>1418</td>\n",
" <td>5583</td>\n",
" <td>533</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2343798</td>\n",
" <td>0</td>\n",
" <td>2133319</td>\n",
" <td>2343798</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Electricity, water and gas supply</th>\n",
" <td>3133</td>\n",
" <td>2026</td>\n",
" <td>20365</td>\n",
" <td>11938</td>\n",
" <td>20175</td>\n",
" <td>46520</td>\n",
" <td>4496</td>\n",
" <td>16096</td>\n",
" <td>43389</td>\n",
" <td>12104</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>714770</td>\n",
" <td>911</td>\n",
" <td>227970</td>\n",
" <td>715681</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Commerce</th>\n",
" <td>25357</td>\n",
" <td>564</td>\n",
" <td>80130</td>\n",
" <td>47845</td>\n",
" <td>27764</td>\n",
" <td>24276</td>\n",
" <td>15418</td>\n",
" <td>18172</td>\n",
" <td>27117</td>\n",
" <td>5096</td>\n",
" <td>...</td>\n",
" <td>455</td>\n",
" <td>7168</td>\n",
" <td>6805</td>\n",
" <td>363</td>\n",
" <td>0</td>\n",
" <td>10444</td>\n",
" <td>2477638</td>\n",
" <td>42904</td>\n",
" <td>1621922</td>\n",
" <td>2520542</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Transportation</th>\n",
" <td>18212</td>\n",
" <td>523</td>\n",
" <td>39072</td>\n",
" <td>10347</td>\n",
" <td>22023</td>\n",
" <td>24243</td>\n",
" <td>6231</td>\n",
" <td>24092</td>\n",
" <td>38355</td>\n",
" <td>7643</td>\n",
" <td>...</td>\n",
" <td>50</td>\n",
" <td>695</td>\n",
" <td>617</td>\n",
" <td>78</td>\n",
" <td>0</td>\n",
" <td>1051</td>\n",
" <td>928904</td>\n",
" <td>153997</td>\n",
" <td>532673</td>\n",
" <td>1082901</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Other services</th>\n",
" <td>29355</td>\n",
" <td>2125</td>\n",
" <td>59802</td>\n",
" <td>29251</td>\n",
" <td>30944</td>\n",
" <td>82526</td>\n",
" <td>17581</td>\n",
" <td>36189</td>\n",
" <td>31823</td>\n",
" <td>6647</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>6</td>\n",
" <td>6581542</td>\n",
" <td>37257</td>\n",
" <td>4433907</td>\n",
" <td>6618799</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Government activities</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>486059</td>\n",
" <td>0</td>\n",
" <td>471775</td>\n",
" <td>486059</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Activities not elsewhere classified,others</th>\n",
" <td>16411</td>\n",
" <td>1616</td>\n",
" <td>36995</td>\n",
" <td>9365</td>\n",
" <td>17698</td>\n",
" <td>29733</td>\n",
" <td>6807</td>\n",
" <td>17348</td>\n",
" <td>24898</td>\n",
" <td>4126</td>\n",
" <td>...</td>\n",
" <td>48</td>\n",
" <td>263</td>\n",
" <td>0</td>\n",
" <td>263</td>\n",
" <td>0</td>\n",
" <td>602</td>\n",
" <td>816648</td>\n",
" <td>38536</td>\n",
" <td>57653</td>\n",
" <td>855184</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Total amount of intermediate input (Japan)</th>\n",
" <td>244256</td>\n",
" <td>10674</td>\n",
" <td>774212</td>\n",
" <td>267163</td>\n",
" <td>236712</td>\n",
" <td>320540</td>\n",
" <td>64506</td>\n",
" <td>171652</td>\n",
" <td>215063</td>\n",
" <td>45978</td>\n",
" <td>...</td>\n",
" <td>3518</td>\n",
" <td>115413</td>\n",
" <td>109151</td>\n",
" <td>6262</td>\n",
" <td>0</td>\n",
" <td>152374</td>\n",
" <td>23695485</td>\n",
" <td>817465</td>\n",
" <td>14057769</td>\n",
" <td>24512950</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Agriculture,forestry,fishery</th>\n",
" <td>913</td>\n",
" <td>0</td>\n",
" <td>24254</td>\n",
" <td>3249</td>\n",
" <td>7353</td>\n",
" <td>42</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>-157</td>\n",
" <td>91</td>\n",
" <td>75</td>\n",
" <td>16</td>\n",
" <td>0</td>\n",
" <td>1005</td>\n",
" <td>1327042</td>\n",
" <td>81506</td>\n",
" <td>345888</td>\n",
" <td>1408548</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Mining</th>\n",
" <td>0</td>\n",
" <td>5</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>36</td>\n",
" <td>371</td>\n",
" <td>38</td>\n",
" <td>458</td>\n",
" <td>5580</td>\n",
" <td>923</td>\n",
" <td>...</td>\n",
" <td>-131</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>-128</td>\n",
" <td>1590612</td>\n",
" <td>32282</td>\n",
" <td>49772</td>\n",
" <td>1622894</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Foodstuffs</th>\n",
" <td>129</td>\n",
" <td>0</td>\n",
" <td>8578</td>\n",
" <td>549</td>\n",
" <td>0</td>\n",
" <td>207</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>-426</td>\n",
" <td>42</td>\n",
" <td>0</td>\n",
" <td>42</td>\n",
" <td>0</td>\n",
" <td>2945</td>\n",
" <td>2732097</td>\n",
" <td>92865</td>\n",
" <td>2143350</td>\n",
" <td>2824962</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Textile products</th>\n",
" <td>13</td>\n",
" <td>0</td>\n",
" <td>4</td>\n",
" <td>360</td>\n",
" <td>16</td>\n",
" <td>4</td>\n",
" <td>2</td>\n",
" <td>7</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>-4</td>\n",
" <td>31</td>\n",
" <td>10</td>\n",
" <td>21</td>\n",
" <td>0</td>\n",
" <td>712</td>\n",
" <td>805724</td>\n",
" <td>26873</td>\n",
" <td>565657</td>\n",
" <td>832597</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Pulp, paper and wooden products</th>\n",
" <td>9</td>\n",
" <td>7</td>\n",
" <td>29</td>\n",
" <td>5</td>\n",
" <td>5582</td>\n",
" <td>225</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>14</td>\n",
" <td>62</td>\n",
" <td>10</td>\n",
" <td>52</td>\n",
" <td>0</td>\n",
" <td>271</td>\n",
" <td>1282865</td>\n",
" <td>35345</td>\n",
" <td>393536</td>\n",
" <td>1318210</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Non-rerrous metals and its products</th>\n",
" <td>22</td>\n",
" <td>2</td>\n",
" <td>27</td>\n",
" <td>26</td>\n",
" <td>79</td>\n",
" <td>15</td>\n",
" <td>3</td>\n",
" <td>23</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>...</td>\n",
" <td>-476</td>\n",
" <td>983</td>\n",
" <td>636</td>\n",
" <td>347</td>\n",
" <td>0</td>\n",
" <td>1042</td>\n",
" <td>97165</td>\n",
" <td>0</td>\n",
" <td>26133</td>\n",
" <td>97165</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Metal products</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>10</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>-609</td>\n",
" <td>34484</td>\n",
" <td>33623</td>\n",
" <td>861</td>\n",
" <td>0</td>\n",
" <td>34164</td>\n",
" <td>239595</td>\n",
" <td>0</td>\n",
" <td>153230</td>\n",
" <td>239595</td>\n",
" </tr>\n",
" <tr>\n",
" <th>General machinery</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>-437</td>\n",
" <td>8016</td>\n",
" <td>7190</td>\n",
" <td>826</td>\n",
" <td>0</td>\n",
" <td>12815</td>\n",
" <td>310530</td>\n",
" <td>0</td>\n",
" <td>177352</td>\n",
" <td>310530</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Electric machinery</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>1349</td>\n",
" <td>6750</td>\n",
" <td>6568</td>\n",
" <td>182</td>\n",
" <td>0</td>\n",
" <td>8353</td>\n",
" <td>400586</td>\n",
" <td>0</td>\n",
" <td>309951</td>\n",
" <td>400586</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Automobiles</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>-6</td>\n",
" <td>1132</td>\n",
" <td>965</td>\n",
" <td>167</td>\n",
" <td>0</td>\n",
" <td>1126</td>\n",
" <td>56236</td>\n",
" <td>0</td>\n",
" <td>33755</td>\n",
" <td>56236</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Other transport machinery</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>-996</td>\n",
" <td>15362</td>\n",
" <td>14450</td>\n",
" <td>912</td>\n",
" <td>0</td>\n",
" <td>15697</td>\n",
" <td>90327</td>\n",
" <td>0</td>\n",
" <td>67962</td>\n",
" <td>90327</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Precision machinery</th>\n",
" <td>5</td>\n",
" <td>0</td>\n",
" <td>17</td>\n",
" <td>3</td>\n",
" <td>8</td>\n",
" <td>7</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>-101</td>\n",
" <td>8</td>\n",
" <td>5</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>362</td>\n",
" <td>43096</td>\n",
" <td>0</td>\n",
" <td>9239</td>\n",
" <td>43096</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Other manufactured products</th>\n",
" <td>571</td>\n",
" <td>18</td>\n",
" <td>307</td>\n",
" <td>592</td>\n",
" <td>441</td>\n",
" <td>21790</td>\n",
" <td>3793</td>\n",
" <td>1984</td>\n",
" <td>965</td>\n",
" <td>197</td>\n",
" <td>...</td>\n",
" <td>442</td>\n",
" <td>1516</td>\n",
" <td>629</td>\n",
" <td>887</td>\n",
" <td>0</td>\n",
" <td>8420</td>\n",
" <td>671319</td>\n",
" <td>0</td>\n",
" <td>234124</td>\n",
" <td>671319</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Construction</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>1</td>\n",
" <td>119</td>\n",
" <td>0</td>\n",
" <td>119</td>\n",
" <td>0</td>\n",
" <td>499</td>\n",
" <td>59707</td>\n",
" <td>0</td>\n",
" <td>16131</td>\n",
" <td>59707</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Electricity, water and gas supply</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>199</td>\n",
" <td>153</td>\n",
" <td>46</td>\n",
" <td>0</td>\n",
" <td>199</td>\n",
" <td>3327</td>\n",
" <td>0</td>\n",
" <td>2649</td>\n",
" <td>3327</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Commerce</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>10</td>\n",
" <td>0</td>\n",
" <td>10</td>\n",
" <td>0</td>\n",
" <td>10</td>\n",
" <td>56084</td>\n",
" <td>0</td>\n",
" <td>3240</td>\n",
" <td>56084</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Transportation</th>\n",
" <td>34</td>\n",
" <td>6</td>\n",
" <td>233</td>\n",
" <td>234</td>\n",
" <td>88</td>\n",
" <td>238</td>\n",
" <td>64</td>\n",
" <td>153</td>\n",
" <td>169</td>\n",
" <td>24</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>1425</td>\n",
" <td>57</td>\n",
" <td>1368</td>\n",
" <td>0</td>\n",
" <td>14356</td>\n",
" <td>309074</td>\n",
" <td>0</td>\n",
" <td>123204</td>\n",
" <td>309074</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Other services</th>\n",
" <td>178</td>\n",
" <td>23</td>\n",
" <td>1499</td>\n",
" <td>527</td>\n",
" <td>537</td>\n",
" <td>1663</td>\n",
" <td>488</td>\n",
" <td>351</td>\n",
" <td>456</td>\n",
" <td>110</td>\n",
" <td>...</td>\n",
" <td>2</td>\n",
" <td>4542</td>\n",
" <td>313</td>\n",
" <td>4229</td>\n",
" <td>0</td>\n",
" <td>25695</td>\n",
" <td>367933</td>\n",
" <td>0</td>\n",
" <td>126468</td>\n",
" <td>367933</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Government activities</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>156</td>\n",
" <td>0</td>\n",
" <td>156</td>\n",
" <td>0</td>\n",
" <td>156</td>\n",
" <td>5421</td>\n",
" <td>0</td>\n",
" <td>5064</td>\n",
" <td>5421</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Activities not elsewhere classified,others</th>\n",
" <td>835</td>\n",
" <td>47</td>\n",
" <td>976</td>\n",
" <td>291</td>\n",
" <td>605</td>\n",
" <td>807</td>\n",
" <td>51</td>\n",
" <td>668</td>\n",
" <td>1367</td>\n",
" <td>122</td>\n",
" <td>...</td>\n",
" <td>-180</td>\n",
" <td>4225</td>\n",
" <td>3</td>\n",
" <td>4222</td>\n",
" <td>0</td>\n",
" <td>4109</td>\n",
" <td>541312</td>\n",
" <td>0</td>\n",
" <td>371900</td>\n",
" <td>541312</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Total amount of intermediate input (ROW)</th>\n",
" <td>4086</td>\n",
" <td>369</td>\n",
" <td>50865</td>\n",
" <td>17715</td>\n",
" <td>19405</td>\n",
" <td>44420</td>\n",
" <td>259289</td>\n",
" <td>7389</td>\n",
" <td>74959</td>\n",
" <td>27850</td>\n",
" <td>...</td>\n",
" <td>-3328</td>\n",
" <td>80600</td>\n",
" <td>65078</td>\n",
" <td>15522</td>\n",
" <td>0</td>\n",
" <td>164583</td>\n",
" <td>6633888</td>\n",
" <td>0</td>\n",
" <td>2343454</td>\n",
" <td>6633888</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Customs duties</th>\n",
" <td>585</td>\n",
" <td>5</td>\n",
" <td>7836</td>\n",
" <td>1335</td>\n",
" <td>258</td>\n",
" <td>1973</td>\n",
" <td>19085</td>\n",
" <td>107</td>\n",
" <td>324</td>\n",
" <td>658</td>\n",
" <td>...</td>\n",
" <td>7727</td>\n",
" <td>35168</td>\n",
" <td>33822</td>\n",
" <td>1346</td>\n",
" <td>0</td>\n",
" <td>77923</td>\n",
" <td>440845</td>\n",
" <td>0</td>\n",
" <td>216972</td>\n",
" <td>440845</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Total amount of intermediate input</th>\n",
" <td>254235</td>\n",
" <td>11290</td>\n",
" <td>908816</td>\n",
" <td>309559</td>\n",
" <td>289752</td>\n",
" <td>414719</td>\n",
" <td>412629</td>\n",
" <td>185565</td>\n",
" <td>312620</td>\n",
" <td>92608</td>\n",
" <td>...</td>\n",
" <td>286787</td>\n",
" <td>2474338</td>\n",
" <td>1816855</td>\n",
" <td>657483</td>\n",
" <td>0</td>\n",
" <td>6511733</td>\n",
" <td>126998772</td>\n",
" <td>6412279</td>\n",
" <td>81431869</td>\n",
" <td>133411051</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Compensation for employees</th>\n",
" <td>61141</td>\n",
" <td>8911</td>\n",
" <td>172029</td>\n",
" <td>114882</td>\n",
" <td>103126</td>\n",
" <td>108326</td>\n",
" <td>9074</td>\n",
" <td>78076</td>\n",
" <td>71254</td>\n",
" <td>15258</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>42897741</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>42897741</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Other value added</th>\n",
" <td>344244</td>\n",
" <td>2896</td>\n",
" <td>287800</td>\n",
" <td>47139</td>\n",
" <td>71281</td>\n",
" <td>153994</td>\n",
" <td>140192</td>\n",
" <td>74130</td>\n",
" <td>127583</td>\n",
" <td>19438</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>32220787</td>\n",
" <td>14191</td>\n",
" <td>1034757</td>\n",
" <td>32234978</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Indirect taxes + subsides</th>\n",
" <td>7324</td>\n",
" <td>-1139</td>\n",
" <td>148934</td>\n",
" <td>10016</td>\n",
" <td>10541</td>\n",
" <td>18124</td>\n",
" <td>112494</td>\n",
" <td>9181</td>\n",
" <td>19398</td>\n",
" <td>3426</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>12730</td>\n",
" <td>107967</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Indirect taxes</th>\n",
" <td>17752</td>\n",
" <td>518</td>\n",
" <td>179435</td>\n",
" <td>10016</td>\n",
" <td>10541</td>\n",
" <td>18232</td>\n",
" <td>112909</td>\n",
" <td>9181</td>\n",
" <td>19398</td>\n",
" <td>3426</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Current subsidies</th>\n",
" <td>-10428</td>\n",
" <td>-1657</td>\n",
" <td>-30501</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>-108</td>\n",
" <td>-415</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Operating surplus</th>\n",
" <td>260047</td>\n",
" <td>1773</td>\n",
" <td>109718</td>\n",
" <td>19505</td>\n",
" <td>36832</td>\n",
" <td>87545</td>\n",
" <td>16765</td>\n",
" <td>40331</td>\n",
" <td>74188</td>\n",
" <td>6973</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Depreciaton of fixed capital</th>\n",
" <td>76873</td>\n",
" <td>2262</td>\n",
" <td>29148</td>\n",
" <td>17618</td>\n",
" <td>23908</td>\n",
" <td>48325</td>\n",
" <td>10933</td>\n",
" <td>24618</td>\n",
" <td>33997</td>\n",
" <td>9039</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Value added tax not exemptable</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1461</td>\n",
" <td>926790</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Enterprise profit(006+007)</th>\n",
" <td>336920</td>\n",
" <td>4035</td>\n",
" <td>138866</td>\n",
" <td>37123</td>\n",
" <td>60740</td>\n",
" <td>135870</td>\n",
" <td>27698</td>\n",
" <td>64949</td>\n",
" <td>108185</td>\n",
" <td>16012</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Property-type income(005+006+007)</th>\n",
" <td>326492</td>\n",
" <td>2378</td>\n",
" <td>108365</td>\n",
" <td>37123</td>\n",
" <td>60740</td>\n",
" <td>135762</td>\n",
" <td>27283</td>\n",
" <td>64949</td>\n",
" <td>108185</td>\n",
" <td>16012</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Total of gross value</th>\n",
" <td>405385</td>\n",
" <td>11807</td>\n",
" <td>459829</td>\n",
" <td>162021</td>\n",
" <td>174407</td>\n",
" <td>262320</td>\n",
" <td>149266</td>\n",
" <td>152206</td>\n",
" <td>198837</td>\n",
" <td>34696</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>75118528</td>\n",
" <td>14191</td>\n",
" <td>1034757</td>\n",
" <td>75132719</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Value of domestic products</th>\n",
" <td>659620</td>\n",
" <td>23097</td>\n",
" <td>1368645</td>\n",
" <td>471580</td>\n",
" <td>464159</td>\n",
" <td>677039</td>\n",
" <td>561895</td>\n",
" <td>337771</td>\n",
" <td>511457</td>\n",
" <td>127304</td>\n",
" <td>...</td>\n",
" <td>286787</td>\n",
" <td>2474338</td>\n",
" <td>1816855</td>\n",
" <td>657483</td>\n",
" <td>0</td>\n",
" <td>6511733</td>\n",
" <td>202117300</td>\n",
" <td>6426470</td>\n",
" <td>82466626</td>\n",
" <td>208543770</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>141 rows × 137 columns</p>\n",
"</div>"
],
"text/plain": [
" Agriculture,forestry,fishery \\\n",
"Index \n",
"Agriculture,forestry,fishery 1381 \n",
"Mining 80 \n",
"Foodstuffs 67104 \n",
"Textile products 4500 \n",
"Pulp, paper and wooden products 8455 \n",
"Chemical products 32360 \n",
"Petroleum products 17992 \n",
"Ceramics, stone and clay products 1059 \n",
"Iron, steel and its products 22 \n",
"Non-rerrous metals and its products 0 \n",
"Metal products 1193 \n",
"General machinery 5327 \n",
"Electric machinery 206 \n",
"Automobiles 0 \n",
"Other transport machinery 3129 \n",
"Precision machinery 19 \n",
"Other manufactured products 7103 \n",
"Construction 1858 \n",
"Electricity, water and gas supply 3133 \n",
"Commerce 25357 \n",
"Transportation 18212 \n",
"Other services 29355 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 16411 \n",
"Total amount of intermediate input (Japan) 244256 \n",
"Agriculture,forestry,fishery 913 \n",
"Mining 0 \n",
"Foodstuffs 129 \n",
"Textile products 13 \n",
"Pulp, paper and wooden products 9 \n",
"... ... \n",
"Non-rerrous metals and its products 22 \n",
"Metal products 1 \n",
"General machinery 1 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 5 \n",
"Other manufactured products 571 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 34 \n",
"Other services 178 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 835 \n",
"Total amount of intermediate input (ROW) 4086 \n",
"Customs duties 585 \n",
"Total amount of intermediate input 254235 \n",
"Compensation for employees 61141 \n",
"Other value added 344244 \n",
"Indirect taxes + subsides 7324 \n",
"Indirect taxes 17752 \n",
"Current subsidies -10428 \n",
"Operating surplus 260047 \n",
"Depreciaton of fixed capital 76873 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 336920 \n",
"Property-type income(005+006+007) 326492 \n",
"Total of gross value 405385 \n",
"Value of domestic products 659620 \n",
"\n",
" Mining Foodstuffs \\\n",
"Index \n",
"Agriculture,forestry,fishery 230 395026 \n",
"Mining 0 1006 \n",
"Foodstuffs 0 17003 \n",
"Textile products 45 1196 \n",
"Pulp, paper and wooden products 316 25651 \n",
"Chemical products 237 15417 \n",
"Petroleum products 871 9757 \n",
"Ceramics, stone and clay products 78 11439 \n",
"Iron, steel and its products 352 0 \n",
"Non-rerrous metals and its products 5 1452 \n",
"Metal products 619 24026 \n",
"General machinery 420 6339 \n",
"Electric machinery 174 129 \n",
"Automobiles 0 0 \n",
"Other transport machinery 2 16 \n",
"Precision machinery 0 11 \n",
"Other manufactured products 358 26618 \n",
"Construction 113 2762 \n",
"Electricity, water and gas supply 2026 20365 \n",
"Commerce 564 80130 \n",
"Transportation 523 39072 \n",
"Other services 2125 59802 \n",
"Government activities 0 0 \n",
"Activities not elsewhere classified,others 1616 36995 \n",
"Total amount of intermediate input (Japan) 10674 774212 \n",
"Agriculture,forestry,fishery 0 24254 \n",
"Mining 5 0 \n",
"Foodstuffs 0 8578 \n",
"Textile products 0 4 \n",
"Pulp, paper and wooden products 7 29 \n",
"... ... ... \n",
"Non-rerrous metals and its products 2 27 \n",
"Metal products 0 1 \n",
"General machinery 0 0 \n",
"Electric machinery 0 0 \n",
"Automobiles 0 0 \n",
"Other transport machinery 0 0 \n",
"Precision machinery 0 17 \n",
"Other manufactured products 18 307 \n",
"Construction 0 0 \n",
"Electricity, water and gas supply 0 0 \n",
"Commerce 0 0 \n",
"Transportation 6 233 \n",
"Other services 23 1499 \n",
"Government activities 0 0 \n",
"Activities not elsewhere classified,others 47 976 \n",
"Total amount of intermediate input (ROW) 369 50865 \n",
"Customs duties 5 7836 \n",
"Total amount of intermediate input 11290 908816 \n",
"Compensation for employees 8911 172029 \n",
"Other value added 2896 287800 \n",
"Indirect taxes + subsides -1139 148934 \n",
"Indirect taxes 518 179435 \n",
"Current subsidies -1657 -30501 \n",
"Operating surplus 1773 109718 \n",
"Depreciaton of fixed capital 2262 29148 \n",
"Value added tax not exemptable 0 0 \n",
"Enterprise profit(006+007) 4035 138866 \n",
"Property-type income(005+006+007) 2378 108365 \n",
"Total of gross value 11807 459829 \n",
"Value of domestic products 23097 1368645 \n",
"\n",
" Textile products \\\n",
"Index \n",
"Agriculture,forestry,fishery 3560 \n",
"Mining 15 \n",
"Foodstuffs -24 \n",
"Textile products 88353 \n",
"Pulp, paper and wooden products 6147 \n",
"Chemical products 36315 \n",
"Petroleum products 6071 \n",
"Ceramics, stone and clay products 115 \n",
"Iron, steel and its products 1 \n",
"Non-rerrous metals and its products 17 \n",
"Metal products 1627 \n",
"General machinery 1798 \n",
"Electric machinery 524 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 12 \n",
"Other manufactured products 12961 \n",
"Construction 925 \n",
"Electricity, water and gas supply 11938 \n",
"Commerce 47845 \n",
"Transportation 10347 \n",
"Other services 29251 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 9365 \n",
"Total amount of intermediate input (Japan) 267163 \n",
"Agriculture,forestry,fishery 3249 \n",
"Mining 0 \n",
"Foodstuffs 549 \n",
"Textile products 360 \n",
"Pulp, paper and wooden products 5 \n",
"... ... \n",
"Non-rerrous metals and its products 26 \n",
"Metal products 0 \n",
"General machinery 0 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 3 \n",
"Other manufactured products 592 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 234 \n",
"Other services 527 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 291 \n",
"Total amount of intermediate input (ROW) 17715 \n",
"Customs duties 1335 \n",
"Total amount of intermediate input 309559 \n",
"Compensation for employees 114882 \n",
"Other value added 47139 \n",
"Indirect taxes + subsides 10016 \n",
"Indirect taxes 10016 \n",
"Current subsidies 0 \n",
"Operating surplus 19505 \n",
"Depreciaton of fixed capital 17618 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 37123 \n",
"Property-type income(005+006+007) 37123 \n",
"Total of gross value 162021 \n",
"Value of domestic products 471580 \n",
"\n",
" Pulp, paper and wooden products \\\n",
"Index \n",
"Agriculture,forestry,fishery 26785 \n",
"Mining 331 \n",
"Foodstuffs 680 \n",
"Textile products 2798 \n",
"Pulp, paper and wooden products 10563 \n",
"Chemical products 18693 \n",
"Petroleum products 13501 \n",
"Ceramics, stone and clay products 2915 \n",
"Iron, steel and its products 1206 \n",
"Non-rerrous metals and its products 320 \n",
"Metal products 7267 \n",
"General machinery 3164 \n",
"Electric machinery 150 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 16 \n",
"Other manufactured products 28083 \n",
"Construction 1636 \n",
"Electricity, water and gas supply 20175 \n",
"Commerce 27764 \n",
"Transportation 22023 \n",
"Other services 30944 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 17698 \n",
"Total amount of intermediate input (Japan) 236712 \n",
"Agriculture,forestry,fishery 7353 \n",
"Mining 36 \n",
"Foodstuffs 0 \n",
"Textile products 16 \n",
"Pulp, paper and wooden products 5582 \n",
"... ... \n",
"Non-rerrous metals and its products 79 \n",
"Metal products 7 \n",
"General machinery 0 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 8 \n",
"Other manufactured products 441 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 88 \n",
"Other services 537 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 605 \n",
"Total amount of intermediate input (ROW) 19405 \n",
"Customs duties 258 \n",
"Total amount of intermediate input 289752 \n",
"Compensation for employees 103126 \n",
"Other value added 71281 \n",
"Indirect taxes + subsides 10541 \n",
"Indirect taxes 10541 \n",
"Current subsidies 0 \n",
"Operating surplus 36832 \n",
"Depreciaton of fixed capital 23908 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 60740 \n",
"Property-type income(005+006+007) 60740 \n",
"Total of gross value 174407 \n",
"Value of domestic products 464159 \n",
"\n",
" Chemical products \\\n",
"Index \n",
"Agriculture,forestry,fishery 1041 \n",
"Mining 1500 \n",
"Foodstuffs 5938 \n",
"Textile products 621 \n",
"Pulp, paper and wooden products 17287 \n",
"Chemical products 0 \n",
"Petroleum products 35755 \n",
"Ceramics, stone and clay products 4068 \n",
"Iron, steel and its products 3457 \n",
"Non-rerrous metals and its products 3281 \n",
"Metal products 8772 \n",
"General machinery 7259 \n",
"Electric machinery 2383 \n",
"Automobiles 0 \n",
"Other transport machinery 5 \n",
"Precision machinery 107 \n",
"Other manufactured products 17831 \n",
"Construction 3937 \n",
"Electricity, water and gas supply 46520 \n",
"Commerce 24276 \n",
"Transportation 24243 \n",
"Other services 82526 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 29733 \n",
"Total amount of intermediate input (Japan) 320540 \n",
"Agriculture,forestry,fishery 42 \n",
"Mining 371 \n",
"Foodstuffs 207 \n",
"Textile products 4 \n",
"Pulp, paper and wooden products 225 \n",
"... ... \n",
"Non-rerrous metals and its products 15 \n",
"Metal products 0 \n",
"General machinery 0 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 7 \n",
"Other manufactured products 21790 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 238 \n",
"Other services 1663 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 807 \n",
"Total amount of intermediate input (ROW) 44420 \n",
"Customs duties 1973 \n",
"Total amount of intermediate input 414719 \n",
"Compensation for employees 108326 \n",
"Other value added 153994 \n",
"Indirect taxes + subsides 18124 \n",
"Indirect taxes 18232 \n",
"Current subsidies -108 \n",
"Operating surplus 87545 \n",
"Depreciaton of fixed capital 48325 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 135870 \n",
"Property-type income(005+006+007) 135762 \n",
"Total of gross value 262320 \n",
"Value of domestic products 677039 \n",
"\n",
" Petroleum products \\\n",
"Index \n",
"Agriculture,forestry,fishery 4 \n",
"Mining 851 \n",
"Foodstuffs 1 \n",
"Textile products 128 \n",
"Pulp, paper and wooden products 67 \n",
"Chemical products 1996 \n",
"Petroleum products 0 \n",
"Ceramics, stone and clay products 1934 \n",
"Iron, steel and its products 0 \n",
"Non-rerrous metals and its products 28 \n",
"Metal products 1609 \n",
"General machinery 2785 \n",
"Electric machinery 2393 \n",
"Automobiles 0 \n",
"Other transport machinery 2 \n",
"Precision machinery 5 \n",
"Other manufactured products 1338 \n",
"Construction 832 \n",
"Electricity, water and gas supply 4496 \n",
"Commerce 15418 \n",
"Transportation 6231 \n",
"Other services 17581 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 6807 \n",
"Total amount of intermediate input (Japan) 64506 \n",
"Agriculture,forestry,fishery 0 \n",
"Mining 38 \n",
"Foodstuffs 3 \n",
"Textile products 2 \n",
"Pulp, paper and wooden products 0 \n",
"... ... \n",
"Non-rerrous metals and its products 3 \n",
"Metal products 0 \n",
"General machinery 0 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 0 \n",
"Other manufactured products 3793 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 64 \n",
"Other services 488 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 51 \n",
"Total amount of intermediate input (ROW) 259289 \n",
"Customs duties 19085 \n",
"Total amount of intermediate input 412629 \n",
"Compensation for employees 9074 \n",
"Other value added 140192 \n",
"Indirect taxes + subsides 112494 \n",
"Indirect taxes 112909 \n",
"Current subsidies -415 \n",
"Operating surplus 16765 \n",
"Depreciaton of fixed capital 10933 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 27698 \n",
"Property-type income(005+006+007) 27283 \n",
"Total of gross value 149266 \n",
"Value of domestic products 561895 \n",
"\n",
" Ceramics, stone and clay products \\\n",
"Index \n",
"Agriculture,forestry,fishery 10 \n",
"Mining 1036 \n",
"Foodstuffs 127 \n",
"Textile products 878 \n",
"Pulp, paper and wooden products 6798 \n",
"Chemical products 6424 \n",
"Petroleum products 22506 \n",
"Ceramics, stone and clay products 2674 \n",
"Iron, steel and its products 4015 \n",
"Non-rerrous metals and its products 697 \n",
"Metal products 2539 \n",
"General machinery 5941 \n",
"Electric machinery 1209 \n",
"Automobiles 0 \n",
"Other transport machinery 31 \n",
"Precision machinery 16 \n",
"Other manufactured products 3436 \n",
"Construction 1418 \n",
"Electricity, water and gas supply 16096 \n",
"Commerce 18172 \n",
"Transportation 24092 \n",
"Other services 36189 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 17348 \n",
"Total amount of intermediate input (Japan) 171652 \n",
"Agriculture,forestry,fishery 0 \n",
"Mining 458 \n",
"Foodstuffs 0 \n",
"Textile products 7 \n",
"Pulp, paper and wooden products 7 \n",
"... ... \n",
"Non-rerrous metals and its products 23 \n",
"Metal products 10 \n",
"General machinery 2 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 0 \n",
"Other manufactured products 1984 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 153 \n",
"Other services 351 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 668 \n",
"Total amount of intermediate input (ROW) 7389 \n",
"Customs duties 107 \n",
"Total amount of intermediate input 185565 \n",
"Compensation for employees 78076 \n",
"Other value added 74130 \n",
"Indirect taxes + subsides 9181 \n",
"Indirect taxes 9181 \n",
"Current subsidies 0 \n",
"Operating surplus 40331 \n",
"Depreciaton of fixed capital 24618 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 64949 \n",
"Property-type income(005+006+007) 64949 \n",
"Total of gross value 152206 \n",
"Value of domestic products 337771 \n",
"\n",
" Iron, steel and its products \\\n",
"Index \n",
"Agriculture,forestry,fishery 45 \n",
"Mining 3856 \n",
"Foodstuffs 4 \n",
"Textile products 277 \n",
"Pulp, paper and wooden products 576 \n",
"Chemical products 6104 \n",
"Petroleum products 9875 \n",
"Ceramics, stone and clay products 2736 \n",
"Iron, steel and its products 0 \n",
"Non-rerrous metals and its products 7602 \n",
"Metal products 378 \n",
"General machinery 5362 \n",
"Electric machinery 5209 \n",
"Automobiles 0 \n",
"Other transport machinery 1 \n",
"Precision machinery 15 \n",
"Other manufactured products 1858 \n",
"Construction 5583 \n",
"Electricity, water and gas supply 43389 \n",
"Commerce 27117 \n",
"Transportation 38355 \n",
"Other services 31823 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 24898 \n",
"Total amount of intermediate input (Japan) 215063 \n",
"Agriculture,forestry,fishery 0 \n",
"Mining 5580 \n",
"Foodstuffs 0 \n",
"Textile products 0 \n",
"Pulp, paper and wooden products 2 \n",
"... ... \n",
"Non-rerrous metals and its products 2 \n",
"Metal products 1 \n",
"General machinery 4 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 0 \n",
"Other manufactured products 965 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 169 \n",
"Other services 456 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 1367 \n",
"Total amount of intermediate input (ROW) 74959 \n",
"Customs duties 324 \n",
"Total amount of intermediate input 312620 \n",
"Compensation for employees 71254 \n",
"Other value added 127583 \n",
"Indirect taxes + subsides 19398 \n",
"Indirect taxes 19398 \n",
"Current subsidies 0 \n",
"Operating surplus 74188 \n",
"Depreciaton of fixed capital 33997 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 108185 \n",
"Property-type income(005+006+007) 108185 \n",
"Total of gross value 198837 \n",
"Value of domestic products 511457 \n",
"\n",
" Non-rerrous metals and its products \\\n",
"Index \n",
"Agriculture,forestry,fishery 3 \n",
"Mining 2913 \n",
"Foodstuffs 1 \n",
"Textile products 73 \n",
"Pulp, paper and wooden products 96 \n",
"Chemical products 676 \n",
"Petroleum products 2246 \n",
"Ceramics, stone and clay products 15 \n",
"Iron, steel and its products 703 \n",
"Non-rerrous metals and its products 0 \n",
"Metal products 63 \n",
"General machinery 759 \n",
"Electric machinery 1928 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 6 \n",
"Other manufactured products 347 \n",
"Construction 533 \n",
"Electricity, water and gas supply 12104 \n",
"Commerce 5096 \n",
"Transportation 7643 \n",
"Other services 6647 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 4126 \n",
"Total amount of intermediate input (Japan) 45978 \n",
"Agriculture,forestry,fishery 0 \n",
"Mining 923 \n",
"Foodstuffs 0 \n",
"Textile products 0 \n",
"Pulp, paper and wooden products 0 \n",
"... ... \n",
"Non-rerrous metals and its products 1 \n",
"Metal products 0 \n",
"General machinery 0 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 0 \n",
"Other manufactured products 197 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 24 \n",
"Other services 110 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 122 \n",
"Total amount of intermediate input (ROW) 27850 \n",
"Customs duties 658 \n",
"Total amount of intermediate input 92608 \n",
"Compensation for employees 15258 \n",
"Other value added 19438 \n",
"Indirect taxes + subsides 3426 \n",
"Indirect taxes 3426 \n",
"Current subsidies 0 \n",
"Operating surplus 6973 \n",
"Depreciaton of fixed capital 9039 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 16012 \n",
"Property-type income(005+006+007) 16012 \n",
"Total of gross value 34696 \n",
"Value of domestic products 127304 \n",
"\n",
" ... Change in inventories.3 \\\n",
"Index ... \n",
"Agriculture,forestry,fishery ... 37 \n",
"Mining ... 18 \n",
"Foodstuffs ... 97 \n",
"Textile products ... 247 \n",
"Pulp, paper and wooden products ... 29 \n",
"Chemical products ... 288 \n",
"Petroleum products ... 63 \n",
"Ceramics, stone and clay products ... -17 \n",
"Iron, steel and its products ... 70 \n",
"Non-rerrous metals and its products ... -63 \n",
"Metal products ... -294 \n",
"General machinery ... -669 \n",
"Electric machinery ... 2365 \n",
"Automobiles ... 1834 \n",
"Other transport machinery ... -1345 \n",
"Precision machinery ... 253 \n",
"Other manufactured products ... 52 \n",
"Construction ... 0 \n",
"Electricity, water and gas supply ... 0 \n",
"Commerce ... 455 \n",
"Transportation ... 50 \n",
"Other services ... 0 \n",
"Government activities ... 0 \n",
"Activities not elsewhere classified,others ... 48 \n",
"Total amount of intermediate input (Japan) ... 3518 \n",
"Agriculture,forestry,fishery ... -157 \n",
"Mining ... -131 \n",
"Foodstuffs ... -426 \n",
"Textile products ... -4 \n",
"Pulp, paper and wooden products ... 14 \n",
"... ... ... \n",
"Non-rerrous metals and its products ... -476 \n",
"Metal products ... -609 \n",
"General machinery ... -437 \n",
"Electric machinery ... 1349 \n",
"Automobiles ... -6 \n",
"Other transport machinery ... -996 \n",
"Precision machinery ... -101 \n",
"Other manufactured products ... 442 \n",
"Construction ... 1 \n",
"Electricity, water and gas supply ... 0 \n",
"Commerce ... 0 \n",
"Transportation ... 0 \n",
"Other services ... 2 \n",
"Government activities ... 0 \n",
"Activities not elsewhere classified,others ... -180 \n",
"Total amount of intermediate input (ROW) ... -3328 \n",
"Customs duties ... 7727 \n",
"Total amount of intermediate input ... 286787 \n",
"Compensation for employees ... 0 \n",
"Other value added ... 0 \n",
"Indirect taxes + subsides ... 0 \n",
"Indirect taxes ... 0 \n",
"Current subsidies ... 0 \n",
"Operating surplus ... 0 \n",
"Depreciaton of fixed capital ... 0 \n",
"Value added tax not exemptable ... 0 \n",
"Enterprise profit(006+007) ... 0 \n",
"Property-type income(005+006+007) ... 0 \n",
"Total of gross value ... 0 \n",
"Value of domestic products ... 286787 \n",
"\n",
" Other domestic final demand(AS) \\\n",
"Index \n",
"Agriculture,forestry,fishery 21 \n",
"Mining 1 \n",
"Foodstuffs 14 \n",
"Textile products 45 \n",
"Pulp, paper and wooden products 54 \n",
"Chemical products 246 \n",
"Petroleum products 100 \n",
"Ceramics, stone and clay products 107 \n",
"Iron, steel and its products 103 \n",
"Non-rerrous metals and its products 226 \n",
"Metal products 1500 \n",
"General machinery 54206 \n",
"Electric machinery 15374 \n",
"Automobiles 18356 \n",
"Other transport machinery 8781 \n",
"Precision machinery 7135 \n",
"Other manufactured products 1015 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 7168 \n",
"Transportation 695 \n",
"Other services 3 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 263 \n",
"Total amount of intermediate input (Japan) 115413 \n",
"Agriculture,forestry,fishery 91 \n",
"Mining 0 \n",
"Foodstuffs 42 \n",
"Textile products 31 \n",
"Pulp, paper and wooden products 62 \n",
"... ... \n",
"Non-rerrous metals and its products 983 \n",
"Metal products 34484 \n",
"General machinery 8016 \n",
"Electric machinery 6750 \n",
"Automobiles 1132 \n",
"Other transport machinery 15362 \n",
"Precision machinery 8 \n",
"Other manufactured products 1516 \n",
"Construction 119 \n",
"Electricity, water and gas supply 199 \n",
"Commerce 10 \n",
"Transportation 1425 \n",
"Other services 4542 \n",
"Government activities 156 \n",
"Activities not elsewhere classified,others 4225 \n",
"Total amount of intermediate input (ROW) 80600 \n",
"Customs duties 35168 \n",
"Total amount of intermediate input 2474338 \n",
"Compensation for employees 0 \n",
"Other value added 0 \n",
"Indirect taxes + subsides 0 \n",
"Indirect taxes 0 \n",
"Current subsidies 0 \n",
"Operating surplus 0 \n",
"Depreciaton of fixed capital 0 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 0 \n",
"Property-type income(005+006+007) 0 \n",
"Total of gross value 0 \n",
"Value of domestic products 2474338 \n",
"\n",
" Total fixed capital formation.3 \\\n",
"Index \n",
"Agriculture,forestry,fishery 19 \n",
"Mining 1 \n",
"Foodstuffs 0 \n",
"Textile products 15 \n",
"Pulp, paper and wooden products 22 \n",
"Chemical products 1 \n",
"Petroleum products 0 \n",
"Ceramics, stone and clay products 101 \n",
"Iron, steel and its products 70 \n",
"Non-rerrous metals and its products 202 \n",
"Metal products 1157 \n",
"General machinery 52807 \n",
"Electric machinery 14639 \n",
"Automobiles 17337 \n",
"Other transport machinery 7621 \n",
"Precision machinery 6878 \n",
"Other manufactured products 859 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 6805 \n",
"Transportation 617 \n",
"Other services 0 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 0 \n",
"Total amount of intermediate input (Japan) 109151 \n",
"Agriculture,forestry,fishery 75 \n",
"Mining 0 \n",
"Foodstuffs 0 \n",
"Textile products 10 \n",
"Pulp, paper and wooden products 10 \n",
"... ... \n",
"Non-rerrous metals and its products 636 \n",
"Metal products 33623 \n",
"General machinery 7190 \n",
"Electric machinery 6568 \n",
"Automobiles 965 \n",
"Other transport machinery 14450 \n",
"Precision machinery 5 \n",
"Other manufactured products 629 \n",
"Construction 0 \n",
"Electricity, water and gas supply 153 \n",
"Commerce 0 \n",
"Transportation 57 \n",
"Other services 313 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 3 \n",
"Total amount of intermediate input (ROW) 65078 \n",
"Customs duties 33822 \n",
"Total amount of intermediate input 1816855 \n",
"Compensation for employees 0 \n",
"Other value added 0 \n",
"Indirect taxes + subsides 0 \n",
"Indirect taxes 0 \n",
"Current subsidies 0 \n",
"Operating surplus 0 \n",
"Depreciaton of fixed capital 0 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 0 \n",
"Property-type income(005+006+007) 0 \n",
"Total of gross value 0 \n",
"Value of domestic products 1816855 \n",
"\n",
" Government consumption expenditures.3 \\\n",
"Index \n",
"Agriculture,forestry,fishery 2 \n",
"Mining 0 \n",
"Foodstuffs 14 \n",
"Textile products 30 \n",
"Pulp, paper and wooden products 32 \n",
"Chemical products 245 \n",
"Petroleum products 100 \n",
"Ceramics, stone and clay products 6 \n",
"Iron, steel and its products 33 \n",
"Non-rerrous metals and its products 24 \n",
"Metal products 343 \n",
"General machinery 1399 \n",
"Electric machinery 735 \n",
"Automobiles 1019 \n",
"Other transport machinery 1160 \n",
"Precision machinery 257 \n",
"Other manufactured products 156 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 363 \n",
"Transportation 78 \n",
"Other services 3 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 263 \n",
"Total amount of intermediate input (Japan) 6262 \n",
"Agriculture,forestry,fishery 16 \n",
"Mining 0 \n",
"Foodstuffs 42 \n",
"Textile products 21 \n",
"Pulp, paper and wooden products 52 \n",
"... ... \n",
"Non-rerrous metals and its products 347 \n",
"Metal products 861 \n",
"General machinery 826 \n",
"Electric machinery 182 \n",
"Automobiles 167 \n",
"Other transport machinery 912 \n",
"Precision machinery 3 \n",
"Other manufactured products 887 \n",
"Construction 119 \n",
"Electricity, water and gas supply 46 \n",
"Commerce 10 \n",
"Transportation 1368 \n",
"Other services 4229 \n",
"Government activities 156 \n",
"Activities not elsewhere classified,others 4222 \n",
"Total amount of intermediate input (ROW) 15522 \n",
"Customs duties 1346 \n",
"Total amount of intermediate input 657483 \n",
"Compensation for employees 0 \n",
"Other value added 0 \n",
"Indirect taxes + subsides 0 \n",
"Indirect taxes 0 \n",
"Current subsidies 0 \n",
"Operating surplus 0 \n",
"Depreciaton of fixed capital 0 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 0 \n",
"Property-type income(005+006+007) 0 \n",
"Total of gross value 0 \n",
"Value of domestic products 657483 \n",
"\n",
" Government purchases.3 \\\n",
"Index \n",
"Agriculture,forestry,fishery 0 \n",
"Mining 0 \n",
"Foodstuffs 0 \n",
"Textile products 0 \n",
"Pulp, paper and wooden products 0 \n",
"Chemical products 0 \n",
"Petroleum products 0 \n",
"Ceramics, stone and clay products 0 \n",
"Iron, steel and its products 0 \n",
"Non-rerrous metals and its products 0 \n",
"Metal products 0 \n",
"General machinery 0 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 0 \n",
"Other manufactured products 0 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 0 \n",
"Other services 0 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 0 \n",
"Total amount of intermediate input (Japan) 0 \n",
"Agriculture,forestry,fishery 0 \n",
"Mining 0 \n",
"Foodstuffs 0 \n",
"Textile products 0 \n",
"Pulp, paper and wooden products 0 \n",
"... ... \n",
"Non-rerrous metals and its products 0 \n",
"Metal products 0 \n",
"General machinery 0 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 0 \n",
"Other manufactured products 0 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 0 \n",
"Other services 0 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 0 \n",
"Total amount of intermediate input (ROW) 0 \n",
"Customs duties 0 \n",
"Total amount of intermediate input 0 \n",
"Compensation for employees 0 \n",
"Other value added 0 \n",
"Indirect taxes + subsides 0 \n",
"Indirect taxes 0 \n",
"Current subsidies 0 \n",
"Operating surplus 0 \n",
"Depreciaton of fixed capital 0 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 0 \n",
"Property-type income(005+006+007) 0 \n",
"Total of gross value 0 \n",
"Value of domestic products 0 \n",
"\n",
" Total of domestic final demand(AS) \\\n",
"Index \n",
"Agriculture,forestry,fishery 231 \n",
"Mining 22 \n",
"Foodstuffs 1535 \n",
"Textile products 2723 \n",
"Pulp, paper and wooden products 322 \n",
"Chemical products 2222 \n",
"Petroleum products 224 \n",
"Ceramics, stone and clay products 426 \n",
"Iron, steel and its products 179 \n",
"Non-rerrous metals and its products 231 \n",
"Metal products 1848 \n",
"General machinery 54387 \n",
"Electric machinery 34163 \n",
"Automobiles 21262 \n",
"Other transport machinery 7898 \n",
"Precision machinery 8717 \n",
"Other manufactured products 3881 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 10444 \n",
"Transportation 1051 \n",
"Other services 6 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 602 \n",
"Total amount of intermediate input (Japan) 152374 \n",
"Agriculture,forestry,fishery 1005 \n",
"Mining -128 \n",
"Foodstuffs 2945 \n",
"Textile products 712 \n",
"Pulp, paper and wooden products 271 \n",
"... ... \n",
"Non-rerrous metals and its products 1042 \n",
"Metal products 34164 \n",
"General machinery 12815 \n",
"Electric machinery 8353 \n",
"Automobiles 1126 \n",
"Other transport machinery 15697 \n",
"Precision machinery 362 \n",
"Other manufactured products 8420 \n",
"Construction 499 \n",
"Electricity, water and gas supply 199 \n",
"Commerce 10 \n",
"Transportation 14356 \n",
"Other services 25695 \n",
"Government activities 156 \n",
"Activities not elsewhere classified,others 4109 \n",
"Total amount of intermediate input (ROW) 164583 \n",
"Customs duties 77923 \n",
"Total amount of intermediate input 6511733 \n",
"Compensation for employees 0 \n",
"Other value added 0 \n",
"Indirect taxes + subsides 0 \n",
"Indirect taxes 0 \n",
"Current subsidies 0 \n",
"Operating surplus 0 \n",
"Depreciaton of fixed capital 0 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 0 \n",
"Property-type income(005+006+007) 0 \n",
"Total of gross value 0 \n",
"Value of domestic products 6511733 \n",
"\n",
" Total of domestic final demand \\\n",
"Index \n",
"Agriculture,forestry,fishery 659745 \n",
"Mining 23326 \n",
"Foodstuffs 1366841 \n",
"Textile products 447031 \n",
"Pulp, paper and wooden products 459390 \n",
"Chemical products 643515 \n",
"Petroleum products 552248 \n",
"Ceramics, stone and clay products 330020 \n",
"Iron, steel and its products 465584 \n",
"Non-rerrous metals and its products 124400 \n",
"Metal products 598412 \n",
"General machinery 805540 \n",
"Electric machinery 1143994 \n",
"Automobiles 579966 \n",
"Other transport machinery 122678 \n",
"Precision machinery 159784 \n",
"Other manufactured products 863652 \n",
"Construction 2343798 \n",
"Electricity, water and gas supply 714770 \n",
"Commerce 2477638 \n",
"Transportation 928904 \n",
"Other services 6581542 \n",
"Government activities 486059 \n",
"Activities not elsewhere classified,others 816648 \n",
"Total amount of intermediate input (Japan) 23695485 \n",
"Agriculture,forestry,fishery 1327042 \n",
"Mining 1590612 \n",
"Foodstuffs 2732097 \n",
"Textile products 805724 \n",
"Pulp, paper and wooden products 1282865 \n",
"... ... \n",
"Non-rerrous metals and its products 97165 \n",
"Metal products 239595 \n",
"General machinery 310530 \n",
"Electric machinery 400586 \n",
"Automobiles 56236 \n",
"Other transport machinery 90327 \n",
"Precision machinery 43096 \n",
"Other manufactured products 671319 \n",
"Construction 59707 \n",
"Electricity, water and gas supply 3327 \n",
"Commerce 56084 \n",
"Transportation 309074 \n",
"Other services 367933 \n",
"Government activities 5421 \n",
"Activities not elsewhere classified,others 541312 \n",
"Total amount of intermediate input (ROW) 6633888 \n",
"Customs duties 440845 \n",
"Total amount of intermediate input 126998772 \n",
"Compensation for employees 42897741 \n",
"Other value added 32220787 \n",
"Indirect taxes + subsides 0 \n",
"Indirect taxes 0 \n",
"Current subsidies 0 \n",
"Operating surplus 0 \n",
"Depreciaton of fixed capital 0 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 0 \n",
"Property-type income(005+006+007) 0 \n",
"Total of gross value 75118528 \n",
"Value of domestic products 202117300 \n",
"\n",
" Exports to ROW \\\n",
"Index \n",
"Agriculture,forestry,fishery -125 \n",
"Mining -229 \n",
"Foodstuffs 1804 \n",
"Textile products 24549 \n",
"Pulp, paper and wooden products 4769 \n",
"Chemical products 33524 \n",
"Petroleum products 9647 \n",
"Ceramics, stone and clay products 7751 \n",
"Iron, steel and its products 45873 \n",
"Non-rerrous metals and its products 2904 \n",
"Metal products 7689 \n",
"General machinery 54119 \n",
"Electric machinery 128960 \n",
"Automobiles 121866 \n",
"Other transport machinery 61413 \n",
"Precision machinery 14257 \n",
"Other manufactured products 25089 \n",
"Construction 0 \n",
"Electricity, water and gas supply 911 \n",
"Commerce 42904 \n",
"Transportation 153997 \n",
"Other services 37257 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 38536 \n",
"Total amount of intermediate input (Japan) 817465 \n",
"Agriculture,forestry,fishery 81506 \n",
"Mining 32282 \n",
"Foodstuffs 92865 \n",
"Textile products 26873 \n",
"Pulp, paper and wooden products 35345 \n",
"... ... \n",
"Non-rerrous metals and its products 0 \n",
"Metal products 0 \n",
"General machinery 0 \n",
"Electric machinery 0 \n",
"Automobiles 0 \n",
"Other transport machinery 0 \n",
"Precision machinery 0 \n",
"Other manufactured products 0 \n",
"Construction 0 \n",
"Electricity, water and gas supply 0 \n",
"Commerce 0 \n",
"Transportation 0 \n",
"Other services 0 \n",
"Government activities 0 \n",
"Activities not elsewhere classified,others 0 \n",
"Total amount of intermediate input (ROW) 0 \n",
"Customs duties 0 \n",
"Total amount of intermediate input 6412279 \n",
"Compensation for employees 0 \n",
"Other value added 14191 \n",
"Indirect taxes + subsides 12730 \n",
"Indirect taxes 0 \n",
"Current subsidies 0 \n",
"Operating surplus 0 \n",
"Depreciaton of fixed capital 0 \n",
"Value added tax not exemptable 1461 \n",
"Enterprise profit(006+007) 0 \n",
"Property-type income(005+006+007) 0 \n",
"Total of gross value 14191 \n",
"Value of domestic products 6426470 \n",
"\n",
" Total amount of final demand \\\n",
"Index \n",
"Agriculture,forestry,fishery 168074 \n",
"Mining -961 \n",
"Foodstuffs 1047417 \n",
"Textile products 297384 \n",
"Pulp, paper and wooden products 62052 \n",
"Chemical products 140475 \n",
"Petroleum products 129331 \n",
"Ceramics, stone and clay products 24576 \n",
"Iron, steel and its products 41287 \n",
"Non-rerrous metals and its products -7264 \n",
"Metal products 71221 \n",
"General machinery 621340 \n",
"Electric machinery 886848 \n",
"Automobiles 566437 \n",
"Other transport machinery 141873 \n",
"Precision machinery 134780 \n",
"Other manufactured products 253680 \n",
"Construction 2133319 \n",
"Electricity, water and gas supply 227970 \n",
"Commerce 1621922 \n",
"Transportation 532673 \n",
"Other services 4433907 \n",
"Government activities 471775 \n",
"Activities not elsewhere classified,others 57653 \n",
"Total amount of intermediate input (Japan) 14057769 \n",
"Agriculture,forestry,fishery 345888 \n",
"Mining 49772 \n",
"Foodstuffs 2143350 \n",
"Textile products 565657 \n",
"Pulp, paper and wooden products 393536 \n",
"... ... \n",
"Non-rerrous metals and its products 26133 \n",
"Metal products 153230 \n",
"General machinery 177352 \n",
"Electric machinery 309951 \n",
"Automobiles 33755 \n",
"Other transport machinery 67962 \n",
"Precision machinery 9239 \n",
"Other manufactured products 234124 \n",
"Construction 16131 \n",
"Electricity, water and gas supply 2649 \n",
"Commerce 3240 \n",
"Transportation 123204 \n",
"Other services 126468 \n",
"Government activities 5064 \n",
"Activities not elsewhere classified,others 371900 \n",
"Total amount of intermediate input (ROW) 2343454 \n",
"Customs duties 216972 \n",
"Total amount of intermediate input 81431869 \n",
"Compensation for employees 0 \n",
"Other value added 1034757 \n",
"Indirect taxes + subsides 107967 \n",
"Indirect taxes 0 \n",
"Current subsidies 0 \n",
"Operating surplus 0 \n",
"Depreciaton of fixed capital 0 \n",
"Value added tax not exemptable 926790 \n",
"Enterprise profit(006+007) 0 \n",
"Property-type income(005+006+007) 0 \n",
"Total of gross value 1034757 \n",
"Value of domestic products 82466626 \n",
"\n",
" Total of domestic products \n",
"Index \n",
"Agriculture,forestry,fishery 659620 \n",
"Mining 23097 \n",
"Foodstuffs 1368645 \n",
"Textile products 471580 \n",
"Pulp, paper and wooden products 464159 \n",
"Chemical products 677039 \n",
"Petroleum products 561895 \n",
"Ceramics, stone and clay products 337771 \n",
"Iron, steel and its products 511457 \n",
"Non-rerrous metals and its products 127304 \n",
"Metal products 606101 \n",
"General machinery 859659 \n",
"Electric machinery 1272954 \n",
"Automobiles 701832 \n",
"Other transport machinery 184091 \n",
"Precision machinery 174041 \n",
"Other manufactured products 888741 \n",
"Construction 2343798 \n",
"Electricity, water and gas supply 715681 \n",
"Commerce 2520542 \n",
"Transportation 1082901 \n",
"Other services 6618799 \n",
"Government activities 486059 \n",
"Activities not elsewhere classified,others 855184 \n",
"Total amount of intermediate input (Japan) 24512950 \n",
"Agriculture,forestry,fishery 1408548 \n",
"Mining 1622894 \n",
"Foodstuffs 2824962 \n",
"Textile products 832597 \n",
"Pulp, paper and wooden products 1318210 \n",
"... ... \n",
"Non-rerrous metals and its products 97165 \n",
"Metal products 239595 \n",
"General machinery 310530 \n",
"Electric machinery 400586 \n",
"Automobiles 56236 \n",
"Other transport machinery 90327 \n",
"Precision machinery 43096 \n",
"Other manufactured products 671319 \n",
"Construction 59707 \n",
"Electricity, water and gas supply 3327 \n",
"Commerce 56084 \n",
"Transportation 309074 \n",
"Other services 367933 \n",
"Government activities 5421 \n",
"Activities not elsewhere classified,others 541312 \n",
"Total amount of intermediate input (ROW) 6633888 \n",
"Customs duties 440845 \n",
"Total amount of intermediate input 133411051 \n",
"Compensation for employees 42897741 \n",
"Other value added 32234978 \n",
"Indirect taxes + subsides 0 \n",
"Indirect taxes 0 \n",
"Current subsidies 0 \n",
"Operating surplus 0 \n",
"Depreciaton of fixed capital 0 \n",
"Value added tax not exemptable 0 \n",
"Enterprise profit(006+007) 0 \n",
"Property-type income(005+006+007) 0 \n",
"Total of gross value 75132719 \n",
"Value of domestic products 208543770 \n",
"\n",
"[141 rows x 137 columns]"
]
},
"execution_count": 84,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.7.3"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment