| DIVIPOLA | Political-Administrative Division: the official catalog of the DANE that assigns a unique code to each department and municipality. It ensures that «Bogotá D.C.», «Bogota», and «11» are understood as the same territory. The person loading data never types it: they select the municipality from a list and the code is filled automatically. |
|---|
| Homologate | Recognizing that two ways of writing the name of the same territory refer to the same entity (e.g., "Valle" and "Valle del Cauca") and standardizing them to the official code. |
|---|
| PIB | Gross Domestic Product: the value of what a territory produces. |
|---|
| IDC | Índice Departamental de Competitividad, del Consejo Privado de Competitividad y la Universidad del Rosario: mide la competitividad de los 32 departamentos y Bogotá D.C. y es la fuente de las brechas del Visor 2. |
|---|
| GEIH | Integrated Household Survey (DANE): source of employment data. |
|---|
| Working-age population | Persons aged 15 years or older, who are the individuals asked by the household survey whether they work. This does not include persons under that age. |
|---|
| Occupancy rate | Out of every 100 working-age individuals, how many are employed. This is a percentage, not a headcount. |
|---|
| Employed persons | Persons who had a job or were working during the reference period. This is the employment measure used by the viewers. |
|---|
| Proprietary calculation | Marker that the viewer assigns to a figure that this platform calculates instead of taking it as published. It appears, for example, in employment figures for territories where the household survey only has a sample in the capital: there, the figure is reconstructed from it, using the method declared in the original deliverable. Its purpose is to prevent anyone from confusing a calculated datum with one published by the source. |
|---|
| EVA | Municipal Agricultural Assessments (UPRA/MinAgricultura): agricultural area and production. |
|---|
| RUES · CIIU | Unique Business and Social Registry (the business registry) · International Standard Industrial Classification (the code for a company's economic activity). |
|---|
| SECOP | Electronic Public Procurement System: where state procurement is recorded. |
|---|
| Reporting year · cut | The year to which a data point corresponds. The "public cutoff" indicates the latest year visible to citizens. |
|---|
| Staging · draft | Data already uploaded that is not yet public: awaiting validation by the technical committee. |
|---|
| Historical Series | The sequence of years for a given indicator, enabling temporal comparison. |
|---|
| Indicator | What is measured (e.g., «PIBper capita»). Only those included in the official catalog of each viewer are available. |
|---|
| Overview | The data table of a viewer, organized as year × territory × indicator. |
|---|
| Dimension | The thematic group to which an indicator belongs. In Viewer 2, the 45 competitiveness indicators are grouped into 6 dimensions (secondary and higher education, human capital, market efficiency and financial system, infrastructure and ICT adoption, environmental sustainability, and innovation and business dynamics). When a chart displays dimensions, each bar summarizes multiple indicators and states this in parentheses. |
|---|
| Comparison group · structure | Each department is compared with those having a similar productive structure, not with the entire country. There are three groups defined by the Ministry of Commerce, Industry, and Tourism based on business density and institutional concentration of the department. |
|---|
| Border | The benchmark against which a department is measured. In static analysis, it is the average of the indicator within its comparison group; in dynamic analysis, it is the department with the highest score in the country in the last measured reporting year. |
|---|
| Static gap | The distance between the department's value and the frontier of its group, in a specific year. A negative value indicates lag; a positive value, advantage. |
|---|
| Dynamic gap | The difference between the growth rate of the department and that of the national benchmark, across the entire time series. It indicates whether convergence or divergence is occurring, not the current position. |
|---|
| Converge · Diverge · Maintains Pace | How the dynamic gap is classified: converges if the department approaches the benchmark, diverges if it moves away, and maintains pace if it grows at a similar rate. The threshold separating the three cases is defined by the source. |
|---|
| Comparison group · structure CRCI | The three groups into which the Ministry of Commerce, Industry and Tourism classifies departments according to their business density and institutional concentration. The viewers compare each department with the average of its group, not with the entire country: it is fairer to benchmark against similar territories. |
|---|
| Productivity frontier | The reference region against which average output per worker is measured. A department approaches it if its productivity grows faster, and moves away if it grows more slowly. |
|---|
| Non-mining productivity | Productivity calculated excluding the mining sector, whose price cycles would distort comparisons between territories. This is the measure used by the viewers. |
|---|
| Current prices · constant prices | Current: value at the prices of the respective year; used to assess the weight of each activity within a given year. Constant: value adjusted for inflation; used to compare different years. |
|---|
| Comparative Advantage | When a sector carries more weight within a department than it does within the country. It indicates the specialization of that territory. |
|---|
| Economic complexity | The degree of diversity and exclusivity of the knowledge required to produce a good. The more complex a product, the fewer territories possess the know-how to produce it, and the more difficult it is to imitate. |
|---|
| Strategic Value | Combines the complexity of a sector with distance: how close the required capabilities are to those already present in the territory. A complex and nearby sector represents a reasonable opportunity; a complex and distant one, a difficult challenge. |
|---|
| Productive linkages | The extent to which a sector depends on others and the extent to which others depend on it. The greater the linkages, the more it drives the rest of the economy when it grows. |
|---|
| Productive vocation | That for which a territory is better endowed, observed in where its companies are actually concentrated. Cross-referencing this with the gap reveals which productive bet is hindered by a specific problem. |
|---|
| ICC · City Competitiveness Index | Index by the Private Competitiveness Council and Universidad del Rosario that evaluates the 32 capital cities and their metropolitan areas. It is not the same as the IDC, which measures departments: they are not comparable. |
|---|
| p.p. (percentage points) | The unit in which gaps are expressed. It is the difference between two percentages: moving from 10% to 13% represents an increase of 3 percentage points, not 3%. |
|---|
| datos.gov.co | The Colombian State's open data portal, from which various sources are retrieved. |
|---|
| Socrata · SoQL | The technology powering datos.gov.co and its query mechanism: it allows requesting only the necessary data without downloading everything. |
|---|
| Dataset | A group of data that is stored and queried together (for example, «PIB, employed persons and productivity by department»). Each set has its own table in the database and its own column dictionary. |
|---|
| Reporting year column | The column indicating the year to which each row belongs. Not all datasets include this: in some cases, the year appears in the column name (for example, "employed 2025"), while others do not contain a year because they are catalogs. |
|---|
| Microdata | Records one by one, without aggregation (for example, each export declaration). They are downloaded in full for analysis; they are not queried record by record. |
|---|
