Mar 28, 2026, 12:02 AM
Greetings to the community, I bring a completely free contribution
This time about the portal pbn.vuce.gov.co
Contribution made in collaboration with NyxarGroup
Let me explain what data we can find: Colombian exporting and importing companies
In this JSON file that I'm uploading, we can find two arrays: data_empresa and data_personal
As you can see, we have 38,627 rows in the data_empresa table, which include: Company name, company address, company email, company number, and even address.
In the data_personal table, there are 56,841 rows for company personnel, which include: Relationship (whether manager, employee, secretary, etc.), name, home address, phone number, email, etc.
Here's the structure in TypeScript:
Root {
type: string
version: string
comment: string
data_empresa: DataEmpresa[]
data_personal: DataPersonal[]
}
DataEmpresa {
id: string
NOMBRE_SUCURSAL: string
DIRECCION_ELECTRONICA: string
DIRECCION: string
BARRIO: string
CIUDAD: string
TELEFONO: string
CELULAR: string
LUGAR_ZONA: string
TIPO_INSTALACION: string
}
DataPersonal {
id: string
RELACION_EMPRESA: string
TIPO_IDENTIFICACION: string
IDENTIFICACION: string
NOMBRES: string
MAIL: string
VIGENTE: string
DIRECCION: string
CIUDAD: string
BARRIO: string
TELEFONO: string
CELULAR: string
}[URL unfurl="true"]https://gofile.io/d/cWZ0Ub[/URL]
