Subnational

domain

Returns ordinal version of a number with "th", "nd" or "st".

ordinal

Given a date, returns you the date in words
Year --> 2023= 2023
Quarter --> 20231 = 2023-Q1
Month --> 202301 == Jan 2023

time

Converts a country code to small flag icon.

flag

link

Abbreviates a number into a smaller more human-readible number.

abbreviate

incompleteYearName

Change month id to name (202405 --> May 2025)

longMonth

initMonthQuarterIncomplete

prevMonthQuarterIncomplete

icon

monthName

increaseOrDecreasePresent

Rounds to nearest whole number and adds commas.

commas

increaseOrDecreasePast

Return period in month when you have data in quarters

incompleteYearQuarter

timeFull

Return boolean (or boolean[]) if input country/ies are in subnational countries list.

hasSubnat

Return boolean (or boolean[]) if input country/ies are in subnational complexity countries list.

hasComplexitySubnat

hasCountryLatestTrends

apostrophe

Returns boolean if the subnational cube has HS classification

hasSubnatHS

Checks if the cube should have complexity values at subnational profile

subnationalComplexityAvailability

lowerCaseFirst

ordinalSuperscript

If n < 20 returns the number name, else returns the number

numbersWord

countryPotentialExportsAvailability

Adds abbreviate with subnational data currency support

abbreviateSubnat

symmetricRange

hasSubnatMap

dollar

Joins an array of strings together, adding commas and 'and' when necessary.

list

Calculates the growth percentage between two numbers provided the following object format: {curr, prev}. Also supports calculating the growth between two margin of errors using this format: {curr, currMoe, prev, prevMoe}.

growth

growthPct

shortMonthName

China Provinces

Germany Regions

Spain Autonomous Communities

Spain Provinces

Japan Regions

Japan Prefectures

Russia Districts

Russia Regions

UK Ports

Canada Provinces

Bolivia Departments

France Regions

France Departments

Italy Macroregions

Italy Regions

Italy Provinces

US States

US Districts

US Ports

Brazil States

Brazil Municipalities

Chile Regions

Chile Comunas

South Africa Ports

Portugal Regions

Portugal Comunidade

Portugal Municipality

Madrid

Icon123

IconCalendarMonth

tabler

transparent

<p>Historical Data</p>

In February 2025, the increase in Madrid year-by-year exports was explained primarily by a increase in exports to <a href="/en/profile/hs/packaged-medicaments">Packaged Medicaments</a> (€250M or 89.8%), <a href="/en/profile/hs/electricity">Electricity</a> (€157M or 144%), <a href="/en/profile/hs/gold">Gold</a> (€127M or 59.6%), <a href="/en/profile/hs/planes-helicopters-andor-spacecraft">Planes, Helicopters, and/or Spacecraft</a> (€99.8M or 82.9%), and <a href="/en/profile/hs/vaccines-blood-antisera-toxins-and-cultures">Vaccines, blood, antisera, toxins and cultures</a> (€55.2M or 51.7%).

In February 2025, the decrease in Madrid year-by-year imports was explained primarily by a decrease in imports from <a href="/en/profile/hs/planes-helicopters-andor-spacecraft">Planes, Helicopters, and/or Spacecraft</a> (-€180M or -100%), <a href="/en/profile/hs/motor-vehicles-parts-and-accessories-8701-to-8705">Motor vehicles; parts and accessories (8701 to 8705)</a> (-€160M or -53.3%), <a href="/en/profile/hs/vaccines-blood-antisera-toxins-and-cultures">Vaccines, blood, antisera, toxins and cultures</a> (-€106M or -30%), <a href="/en/profile/hs/delivery-trucks">Delivery Trucks</a> (-€105M or -66.1%), and <a href="/en/profile/hs/combustion-engines">Combustion Engines</a> (-€63M or -65.5%).