PROPOSAL: New list SIORG of official identifiers for federal government bodies in Brazil

[augusto-herrmann]

Note

I've been waiting for years to propose this list because org-id is supposedly frozen since 2019. Now we are considering the possibility of using the Open Contracting Data Standard and saw that it uses org-id.

Proposal

What open data standard are you working with? (e.g. 'OCDS', '360Giving', 'BODS' etc.) None, but considering OCDS.

The name of the list (or the organization that manages the list) Federal Government Public Organizations (Brazil)

A suggested code for the list (optional) BR-SIORG

A short description of the list Government bodies and entities at the federal level and executive branch in Brazil (official source).

The country or countries that the list covers Brazil

The legal form or organizations that the list covers Full structure (from organization down to smallest office unit) of federal government bodies, including organizations like ministries, agencies, state-owned companies, etc.

Any specific sectors that the list covers Public sector, federal level, executive branch.

A URL for information on the list, and a URL for looking up identifiers (if available) For general information about the SIORG system, see the description page (in Portuguese).

For information about the data, see the dataset page at the Brazilian open data portal.

For looking up entities, there is an end-user interface.

Any information on available open data copies of this list There are open data available either as a API (OpenAPI specification here or as a CSV file for download. Both are linked to in the dataset page in the open data portal.

One or more examples of identifier from this list, and how you found them

• Ministério da Economia (Ministry of Economy): code 235876
• Ministério da Saúde (Ministry of Health): code 304

Alternative ways to find the code:

1. By user interface.
   • Browse the list hierarchy until you find the organization.
   • Click on it.
   • The number is under the field "Código".
2. In the CSV.
   • Download the CSV (over a hundred MB).
   • Open in spreadsheet (might be slow).
   • Create auto filter from the header row.
   • Search for the organization's name under column "nome" (might be really slow or not even work because of the data volume).
   • Find the URL in the "codigoUnidade" field.
   • The code is the last path element of the URI.
3. By using the JSON API.
   • Open a JSON API call containing all organizations (the "resumida" (summary) call is much faster, because it does not descent into the smaller administrative office units).
   • Search for the organization's name in the browser. Alternatively, if using code, iterate on the "unidades" JSON object.
   • The name is under the "nome" property. The URI is under the "codigoUnidade" property. The number is the last path element of the URI.

Note: this official dataset is also read by and synchronized weekly with publicbodies.org via Github Actions. However, the code is not used there as an identifier. Instead publicbodies.org uses a slug created from the organization's name (see org-id's list XI-PB).

[kd-ods]

Hi @augusto-herrmann - thanks for your recent contributions. Since they relate to potential OCDS (open contracting) data publication, you way wish to contact the OCDS helpdesk, data@open-contracting.org. They should be able to review the proposal and your PR in a shorter timeframe. (cc @mrshll1001)

[augusto-herrmann]

We're hosting a workshop tomorrow for the Open Data Day, in Portuguese, for a Brazilian audience, featuring both datasets: contracts and public organizations.