Connecting
Feeds are part of the Company and Enterprise plans. Send your licence key as an Authorization: Bearer <key> header, or, in tools that cannot set headers, add ?token= with the read-only feed token from the dashboard's Downloads page (the licence key itself is not accepted in a URL). The data changes only when it is refreshed, and the feeds support ETag and Last-Modified, so scheduled refreshes skip unchanged data. Filter with ?industry=, ?size=, ?market= and ?sec= (comma-separated codes).
Excel (Power Query): Data → From Web → enter https://hardestmarket.com/api/hc/feed/companies.csv?token=<feed token>.
Power BI: Get data → Web → Advanced: URL https://hardestmarket.com/api/hc/feed/companies.csv, HTTP request header Authorization = Bearer <key>.
curl -H "Authorization: Bearer $HC_KEY" https://hardestmarket.com/api/hc/feed/history.json
Treat the licence key like a password. The feed token opens the feeds only, and you can replace it at any time, which stops the old one. Manage it and team members from the dashboard.
Companies, latest figures
One row per listed company: the latest workforce and gender figures, industry percentiles, board, executive pay and targets.
Feed: https://hardestmarket.com/api/hc/feed/companies.csv · https://hardestmarket.com/api/hc/feed/companies.json
| Column | Type · unit | Meaning | Source |
|---|---|---|---|
| sec | text | Securities code (4 characters) on the Tokyo Stock Exchange. | JPX |
| edinet | text | EDINET filer code. | EDINET |
| corporate_number | text | National Tax Agency corporate number (法人番号, 13 digits). | NTA |
| lei | text | Legal Entity Identifier, where one exists. | GLEIF |
| name | text | Company name in English. | EDINET / JPX |
| industry | text | Tokyo Stock Exchange 33-industry classification. | JPX |
| market | text | Listing market (Prime, Standard, Growth). | JPX |
| size_band | text | Headcount band used for benchmarks. | The Hardest Market |
| period_end | date | End of the fiscal year the figures relate to. | Annual securities report (有価証券報告書), EDINET |
| filed | date | Date the report was filed. | EDINET |
| edinet_doc | text | EDINET document ID of the source filing, for audit. | EDINET |
| employees | number · people | Employees of the reporting (parent) company. | Annual securities report (有価証券報告書), EDINET |
| avg_salary_yen | number · JPY a year | Average annual salary of the reporting company's employees, including bonuses. | Annual securities report (有価証券報告書), EDINET |
| avg_age | number · years | Average age of the reporting company's employees. | Annual securities report (有価証券報告書), EDINET |
| avg_tenure | number · years | Average length of service. | Annual securities report (有価証券報告書), EDINET |
| female_manager_ratio | number · % | Women as a share of employees in management positions. | Annual securities report; figure required under the Women's Advancement Act (女性活躍推進法) |
| male_childcare_leave | number · % | Share of eligible male employees who took childcare leave in the year. The legal formula can exceed 100% (leave this year for a child born last year). The basis (leave only, or leave plus childcare-purpose leave) is in gender_basis/notes. | Annual securities report; Childcare and Family Care Leave Act |
| pay_gap_all | number · % of men | Women's average pay as a percentage of men's, all employees. | Annual securities report; figure required under the Women's Advancement Act (女性活躍推進法) |
| pay_gap_regular | number · % of men | Women's average pay as a percentage of men's, regular (正規) employees. | Annual securities report; figure required under the Women's Advancement Act (女性活躍推進法) |
| pay_gap_nonregular | number · % of men | Women's average pay as a percentage of men's, part-time and fixed-term employees. | Annual securities report; figure required under the Women's Advancement Act (女性活躍推進法) |
| employees_consolidated | number · people | Employees of the group (consolidated). | Annual securities report (有価証券報告書), EDINET |
| avg_salary_yen_industry_pct | number · percentile | Percentile of avg_salary_yen within the company's TSE industry (0 lowest, 100 highest). | The Hardest Market |
| avg_age_industry_pct | number · percentile | Percentile of avg_age within the company's TSE industry (0 lowest, 100 highest). | The Hardest Market |
| avg_tenure_industry_pct | number · percentile | Percentile of avg_tenure within the company's TSE industry (0 lowest, 100 highest). | The Hardest Market |
| female_manager_ratio_industry_pct | number · percentile | Percentile of female_manager_ratio within the company's TSE industry (0 lowest, 100 highest). | The Hardest Market |
| male_childcare_leave_industry_pct | number · percentile | Percentile of male_childcare_leave within the company's TSE industry (0 lowest, 100 highest). | The Hardest Market |
| pay_gap_all_industry_pct | number · percentile | Percentile of pay_gap_all within the company's TSE industry (0 lowest, 100 highest). | The Hardest Market |
| pay_gap_regular_industry_pct | number · percentile | Percentile of pay_gap_regular within the company's TSE industry (0 lowest, 100 highest). | The Hardest Market |
| pay_gap_nonregular_industry_pct | number · percentile | Percentile of pay_gap_nonregular within the company's TSE industry (0 lowest, 100 highest). | The Hardest Market |
| gender_basis | text | Whether the gender figures are the parent's or, where the parent has none, a named subsidiary's. | Annual securities report (有価証券報告書), EDINET |
| notes | text | Quality notes on the figures (e.g. basis of the leave rate, corrections). | The Hardest Market |
| officers | number · people | Directors and auditors listed in the report (after the AGM where the report shows the proposal). | Annual securities report (有価証券報告書), EDINET |
| women_officers_pct | number · % | Women as a share of officers. | Annual securities report (有価証券報告書), EDINET |
| officers_median_age | number · years | Median age of officers. | Annual securities report (有価証券報告書), EDINET |
| hr_leader_among_officers | yes/no | Whether an inside director or listed officer has a title or current role covering HR. | Annual securities report (有価証券報告書), EDINET |
| avg_exec_director_pay_yen | number · JPY a year | Average pay of inside (executive) directors. | Annual securities report (有価証券報告書), EDINET |
| exec_pay_multiple_of_avg_salary | number · times | Average inside-director pay divided by the average employee salary. | Annual securities report (有価証券報告書), EDINET |
| officers_paid_100m_yen_plus | number · people | Officers whose total pay of ¥100 million or more is disclosed individually. | Annual securities report (有価証券報告書), EDINET |
| temporary_workers_parent | number · people | Average temporary workers at the reporting company (outside the headcount). | Annual securities report (有価証券報告書), EDINET |
| temporary_share_parent_pct | number · % | Temporary workers as a share of employees plus temporary workers. | Annual securities report (有価証券報告書), EDINET |
| avg_salary_change_pct | number · % | Change in average salary on the previous report. | Annual securities report (有価証券報告書), EDINET |
| women_managers_target_pct | number · % | The company's own published target for women in management. | Annual securities report (有価証券報告書), EDINET |
| women_managers_target_year | integer · year | Year by which the target is to be met. | Annual securities report (有価証券報告書), EDINET |
| women_managers_actual_vs_target_pct | number · % | The actual figure the company reports beside its target. | Annual securities report (有価証券報告書), EDINET |
History
One row per company and fiscal year filed: the same figures over time.
Feed: https://hardestmarket.com/api/hc/feed/history.csv · https://hardestmarket.com/api/hc/feed/history.json
| Column | Type · unit | Meaning | Source |
|---|---|---|---|
| sec | text | Securities code (4 characters) on the Tokyo Stock Exchange. | JPX |
| edinet | text | EDINET filer code. | EDINET |
| corporate_number | text | National Tax Agency corporate number (法人番号, 13 digits). | NTA |
| name | text | Company name in English. | EDINET / JPX |
| fiscal_year | integer · year | Fiscal year (calendar year in which it ends). | Annual securities report (有価証券報告書), EDINET |
| period_end | date | End of the fiscal year the figures relate to. | Annual securities report (有価証券報告書), EDINET |
| filed | date | Date the report was filed. | EDINET |
| edinet_doc | text | EDINET document ID of the source filing, for audit. | EDINET |
| employees | number · people | Employees of the reporting (parent) company. | Annual securities report (有価証券報告書), EDINET |
| avg_salary_yen | number · JPY a year | Average annual salary of the reporting company's employees, including bonuses. | Annual securities report (有価証券報告書), EDINET |
| avg_age | number · years | Average age of the reporting company's employees. | Annual securities report (有価証券報告書), EDINET |
| avg_tenure | number · years | Average length of service. | Annual securities report (有価証券報告書), EDINET |
| female_manager_ratio | number · % | Women as a share of employees in management positions. | Annual securities report; figure required under the Women's Advancement Act (女性活躍推進法) |
| male_childcare_leave | number · % | Share of eligible male employees who took childcare leave in the year. The legal formula can exceed 100% (leave this year for a child born last year). The basis (leave only, or leave plus childcare-purpose leave) is in gender_basis/notes. | Annual securities report; Childcare and Family Care Leave Act |
| pay_gap_all | number · % of men | Women's average pay as a percentage of men's, all employees. | Annual securities report; figure required under the Women's Advancement Act (女性活躍推進法) |
| pay_gap_regular | number · % of men | Women's average pay as a percentage of men's, regular (正規) employees. | Annual securities report; figure required under the Women's Advancement Act (女性活躍推進法) |
| pay_gap_nonregular | number · % of men | Women's average pay as a percentage of men's, part-time and fixed-term employees. | Annual securities report; figure required under the Women's Advancement Act (女性活躍推進法) |
| employees_consolidated | number · people | Employees of the group (consolidated). | Annual securities report (有価証券報告書), EDINET |
Boards and HR leaders
One row per company (or per HR leader where there are several): board size, women, ages, and the HR leader named among officers.
Feed: https://hardestmarket.com/api/hc/feed/board.csv · https://hardestmarket.com/api/hc/feed/board.json
| Column | Type · unit | Meaning | Source |
|---|---|---|---|
| sec | text | Securities code (4 characters) on the Tokyo Stock Exchange. | JPX |
| edinet | text | EDINET filer code. | EDINET |
| corporate_number | text | National Tax Agency corporate number (法人番号, 13 digits). | NTA |
| name | text | Company name in English. | EDINET / JPX |
| industry | text | Tokyo Stock Exchange 33-industry classification. | JPX |
| filed | date | Date the report was filed. | EDINET |
| basis | text | Whether the board is as at filing or as proposed to the AGM. | Annual securities report (有価証券報告書), EDINET |
| officers | number · people | Directors and auditors listed in the report (after the AGM where the report shows the proposal). | Annual securities report (有価証券報告書), EDINET |
| women | number · people | Women among them. | Annual securities report (有価証券報告書), EDINET |
| women_pct | number · % | Women as a share of officers. | Annual securities report (有価証券報告書), EDINET |
| median_age | number · years | Median age of officers. | Annual securities report (有価証券報告書), EDINET |
| mean_age | number · years | Mean age of officers. | Annual securities report (有価証券報告書), EDINET |
| under_50 | number · people | Officers under 50. | Annual securities report (有価証券報告書), EDINET |
| aged_70_plus | number · people | Officers aged 70 or over. | Annual securities report (有価証券報告書), EDINET |
| hr_leader_name | text | Name of that HR leader (romanised). | Annual securities report (有価証券報告書), EDINET |
| hr_leader_name_ja | text | Name in Japanese. | Annual securities report (有価証券報告書), EDINET |
| hr_leader_title_ja | text | Title as printed in the report. | Annual securities report (有価証券報告書), EDINET |
| hr_leader_current_role_ja | text | Current role from the career summary, where the title does not mention HR. | Annual securities report (有価証券報告書), EDINET |
| identified_from | text | "title" or "career": where the HR role was found. | The Hardest Market |
| chro_title | yes/no | Whether the title is CHRO or chief human resources officer. | Annual securities report (有価証券報告書), EDINET |
Targets
One row per published target (women in management, fathers' leave, pay gap and others), with the actual figure beside it.
Feed: https://hardestmarket.com/api/hc/feed/targets.csv · https://hardestmarket.com/api/hc/feed/targets.json
| Column | Type · unit | Meaning | Source |
|---|---|---|---|
| sec | text | Securities code (4 characters) on the Tokyo Stock Exchange. | JPX |
| edinet | text | EDINET filer code. | EDINET |
| corporate_number | text | National Tax Agency corporate number (法人番号, 13 digits). | NTA |
| name | text | Company name in English. | EDINET / JPX |
| industry | text | Tokyo Stock Exchange 33-industry classification. | JPX |
| period_end | date | End of the fiscal year the figures relate to. | Annual securities report (有価証券報告書), EDINET |
| metric_type | text | Which target: women_managers, male_leave, pay_gap or other. | The Hardest Market |
| metric_ja | text | The metric as named in the report. | Annual securities report (有価証券報告書), EDINET |
| unit_ja | text | Unit as printed. | Annual securities report (有価証券報告書), EDINET |
| target | number · as unit_ja | Target value. | Annual securities report (有価証券報告書), EDINET |
| actual | number · as unit_ja | Actual value reported beside the target. | Annual securities report (有価証券報告書), EDINET |
| target_year | integer · year | Target year. | Annual securities report (有価証券報告書), EDINET |
Executive pay
One row per company (or per officer paid ¥100 million or more): inside-director pay and its multiple of the average salary.
Feed: https://hardestmarket.com/api/hc/feed/officer-pay.csv · https://hardestmarket.com/api/hc/feed/officer-pay.json
| Column | Type · unit | Meaning | Source |
|---|---|---|---|
| sec | text | Securities code (4 characters) on the Tokyo Stock Exchange. | JPX |
| edinet | text | EDINET filer code. | EDINET |
| corporate_number | text | National Tax Agency corporate number (法人番号, 13 digits). | NTA |
| name | text | Company name in English. | EDINET / JPX |
| industry | text | Tokyo Stock Exchange 33-industry classification. | JPX |
| period_end | date | End of the fiscal year the figures relate to. | Annual securities report (有価証券報告書), EDINET |
| exec_directors | number · people | Inside directors in the pay disclosure. | Annual securities report (有価証券報告書), EDINET |
| avg_exec_director_pay_yen | number · JPY a year | Average pay of inside (executive) directors. | Annual securities report (有価証券報告書), EDINET |
| avg_salary_yen | number · JPY a year | Average annual salary of the reporting company's employees, including bonuses. | Annual securities report (有価証券報告書), EDINET |
| multiple | number · times | Average inside-director pay divided by the average employee salary. | Annual securities report (有価証券報告書), EDINET |
| officer_paid_100m_plus | text | Name of an officer paid ¥100 million or more (one row each). | Annual securities report (有価証券報告書), EDINET |
| officer_ja | text | Name in Japanese. | Annual securities report (有価証券報告書), EDINET |
| officer_group_pay_yen | number · JPY a year | That officer's total pay. | Annual securities report (有価証券報告書), EDINET |
Subsidiaries
One row per subsidiary that a listed parent reports gender figures for.
Feed: https://hardestmarket.com/api/hc/feed/subsidiaries.csv · https://hardestmarket.com/api/hc/feed/subsidiaries.json
| Column | Type · unit | Meaning | Source |
|---|---|---|---|
| sec | text | Securities code (4 characters) on the Tokyo Stock Exchange. | JPX |
| parent_corporate_number | text | Corporate number of the listed parent. | NTA |
| parent | text | Listed parent company name. | EDINET |
| fiscal_year | integer · year | Fiscal year (calendar year in which it ends). | Annual securities report (有価証券報告書), EDINET |
| order | integer | Order of the subsidiary in the report. | Annual securities report (有価証券報告書), EDINET |
| subsidiary | text | Subsidiary name (English). | Annual securities report (有価証券報告書), EDINET |
| subsidiary_ja | text | Subsidiary name (Japanese). | Annual securities report (有価証券報告書), EDINET |
| female_manager_ratio | number · % | Women as a share of employees in management positions. | Annual securities report; figure required under the Women's Advancement Act (女性活躍推進法) |
| male_childcare_leave | number · % | Share of eligible male employees who took childcare leave in the year. The legal formula can exceed 100% (leave this year for a child born last year). The basis (leave only, or leave plus childcare-purpose leave) is in gender_basis/notes. | Annual securities report; Childcare and Family Care Leave Act |
| pay_gap_all | number · % of men | Women's average pay as a percentage of men's, all employees. | Annual securities report; figure required under the Women's Advancement Act (女性活躍推進法) |
| pay_gap_regular | number · % of men | Women's average pay as a percentage of men's, regular (正規) employees. | Annual securities report; figure required under the Women's Advancement Act (女性活躍推進法) |
| pay_gap_nonregular | number · % of men | Women's average pay as a percentage of men's, part-time and fixed-term employees. | Annual securities report; figure required under the Women's Advancement Act (女性活躍推進法) |
All employers (MHLW)
One row per employer in MHLW's women's-advancement database, listed and unlisted, including foreign-owned subsidiaries.
Feed: https://hardestmarket.com/api/hc/feed/employers.csv · https://hardestmarket.com/api/hc/feed/employers.json
| Column | Type · unit | Meaning | Source |
|---|---|---|---|
| corporate_number | text | National Tax Agency corporate number (法人番号, 13 digits). | NTA |
| name_ja | text | Employer name in Japanese. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| prefecture | text | Prefecture of the head office. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| industry_jsic | text | Japan Standard Industrial Classification division, as MHLW labels it. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| industry_jsic_en | text | The same in English. | The Hardest Market |
| size_band | text | Headcount band used for benchmarks. | The Hardest Market |
| data_scope | text | Whether figures cover the employer or a group. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| data_as_of | text | Date the employer states its figures relate to. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| updated | date | Date the employer last updated its entry. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| employment_category_1 | text | Employment category the figures refer to, as the employer reports. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| women_managers | number · % | Women in management. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| women_supervisors | number · % | Women at supervisor (係長) level. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| women_officers | number · % | Women among officers (役員), as the employer reports. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| pay_gap_all | number · % of men | Women's average pay as a percentage of men's, all employees. | Annual securities report; figure required under the Women's Advancement Act (女性活躍推進法) |
| pay_gap_regular | number · % of men | Women's average pay as a percentage of men's, regular (正規) employees. | Annual securities report; figure required under the Women's Advancement Act (女性活躍推進法) |
| pay_gap_nonregular | number · % of men | Women's average pay as a percentage of men's, part-time and fixed-term employees. | Annual securities report; figure required under the Women's Advancement Act (女性活躍推進法) |
| male_childcare_leave | number · % | Share of eligible male employees who took childcare leave in the year. The legal formula can exceed 100% (leave this year for a child born last year). The basis (leave only, or leave plus childcare-purpose leave) is in gender_basis/notes. | Annual securities report; Childcare and Family Care Leave Act |
| female_childcare_leave | number · % | Women taking childcare leave. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| overtime_hours | number · hours a month | Average overtime per worker. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| paid_leave_uptake | number · % | Annual paid leave taken as a share of leave granted. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| women_share_of_hires | number · % | Women as a share of new hires. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| women_share_of_workforce | number · % | Women as a share of the workforce. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| tenure_m | number · years | Average tenure, men. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| tenure_f | number · years | Average tenure, women. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| retention10_m | number · % | Men hired about ten years ago who are still employed. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| retention10_f | number · % | Women hired about ten years ago who are still employed. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| hiring_ratio_m | number · applicants per hire | Competition for jobs, men. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| hiring_ratio_f | number · applicants per hire | Competition for jobs, women. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| midcareer_hires_m | number · people | Mid-career hires, men. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| midcareer_hires_f | number · people | Mid-career hires, women. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| policies | text | Policies the employer lists. | MHLW women's-advancement database (女性の活躍推進企業データベース) |
| certifications | text | Government certifications held (e.g. Eruboshi, Kurumin, Health & Productivity). | MHLW / METI / gBizINFO |
| foreign_parent | text | Foreign parent company, where identified. | GLEIF / company websites |
| foreign_parent_country | text | Country of that parent. | GLEIF |
| notes | text | Quality notes on the figures (e.g. basis of the leave rate, corrections). | The Hardest Market |
Plans and prices: Company and Enterprise. Sources: EDINET (Financial Services Agency, Public Data License 1.0), MHLW, National Tax Agency, GLEIF.