Register record·API·FR·Updated AnnualVERIFIED · checked 10h ago

B

2012 Budget by Public Policy AreaBudget 2012 par politique publique

Budget 2012 par politique publique2012 Budget by Public Policy Area

APIExecutable4/7Query nowOpen workbench Subscribe🇫🇷France

This API provides access to a dataset published by Bordeaux Métropole listing budget appropriations voted in the primary budget, broken down by public policy area, programme and section. It covers the 2012 fiscal year, part of a series of yearly files produced from 2012 onward. The data is useful for analyzing how the metropolitan authority allocates public funds across policy domains and programmes, supporting budget transparency and financial monitoring at the local government level.Crédits votés au budget primitif par politique publique, programmes et section. Un fichier par exercice à compter de 2012.

public-finance

⬇ Export CSV List records Select & filter Run verified request Read the docs

Data schema (13 fields)

Filterable via the API (13)

partitionkeyrowkeytimestampentityidcode_politique_dominantedescription_politique_dominantecode_secteur_interventiondescription_secteur_interventioncode_programmedescription_programmenature_affect_operationvsectsubvvmt_bp

Click a field to see example values.

Fill	Field	Type	Description
100%	partitionkey	text	Partition key used for storage table indexing.Partition key used for storage table indexing.
100%	rowkey	text	Unique identifier for the record row.Unique identifier for the record row.
100%	timestamp	datetime	Date and time the record was last updated.Date and time the record was last updated.
100%	entityid	text	Unique identifier for the budget entity record.Unique identifier for the budget entity record.
100%	code_politique_dominanteCode politique dominante	text	Code identifying the main public policy area.Code identifying the main public policy area.
100%	description_politique_dominanteDescription politique dominante	text	Name of the main public policy area.Name of the main public policy area.
100%	code_secteur_interventionCode secteur intervention	text	Code identifying the intervention sector.Code identifying the intervention sector.
100%	description_secteur_interventionDescription secteur intervention	text	Name of the intervention sector.Name of the intervention sector.
100%	code_programmeCode programme	text	Code identifying the budget programme.Code identifying the budget programme.
100%	description_programmeDescription programme	text	Name of the budget programme.Name of the budget programme.
100%	nature_affect_operationNature affect operation	text	Nature of the operation, e.g. expenditure or revenue.Nature of the operation, e.g. expenditure or revenue.
100%	vsectsubv	text	Budget section, e.g. investment or operating.Budget section, e.g. investment or operating.
100%	vmt_bpVmt bp	int	Amount voted in the primary budget, in euros.Amount voted in the primary budget, in euros.

Schema captured from opendatasoft 2 days ago.

Query the data

Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.

Where=

Sort by

Sample data (5 records)

Record 1rowkey: e1257d5a-a120-4790-9ce4-b6a45e70aeac · vmt_bp: 199264

{
  "rowkey": "e1257d5a-a120-4790-9ce4-b6a45e70aeac",
  "vmt_bp": 199264,
  "entityid": "9b752021-6f27-4379-b8d8-2f57ab362a81",
  "timestamp": "2015-05-06T10:28:21+00:00",
  "vsectsubv": "Fonctionnement",
  "partitionkey": "9b752021-6f27-4379-b8d8-2f57ab362a81",
  "code_programme": "P024",
  "description_programme": "Commerce et artisanat",
  "nature_affect_operation": "Dépense",
  "code_politique_dominante": "C-",
  "code_secteur_intervention": "C-01",
  "description_politique_dominante": "DEVELOPPEMENT URBAIN DURABLE",
  "description_secteur_intervention": "Dév. éco, emploi et ens. sup."
}

Record 2rowkey: 8492c594-0eac-448a-b22c-f51daa4168ef · vmt_bp: 36000

{
  "rowkey": "8492c594-0eac-448a-b22c-f51daa4168ef",
  "vmt_bp": 36000,
  "entityid": "7f73ec2b-fb31-4358-b80f-2c705fae0d1b",
  "timestamp": "2015-05-06T10:28:22+00:00",
  "vsectsubv": "Subventions",
  "partitionkey": "7f73ec2b-fb31-4358-b80f-2c705fae0d1b",
  "code_programme": "P121",
  "description_programme": "Santé",
  "nature_affect_operation": "Dépense",
  "code_politique_dominante": "G-",
  "code_secteur_intervention": "G-04",
  "description_politique_dominante": "Vie en société",
  "description_secteur_intervention": "Développement social terr."
}

Record 3rowkey: e98643ad-19fd-4277-80ef-d96915a294a1 · vmt_bp: 238000

{
  "rowkey": "e98643ad-19fd-4277-80ef-d96915a294a1",
  "vmt_bp": 238000,
  "entityid": "7bea9023-2a0c-4eaf-8c90-45e2e969313c",
  "timestamp": "2015-05-06T10:28:21+00:00",
  "vsectsubv": "Fonctionnement",
  "partitionkey": "7bea9023-2a0c-4eaf-8c90-45e2e969313c",
  "code_programme": "P030",
  "description_programme": "Droit des sols",
  "nature_affect_operation": "Dépense",
  "code_politique_dominante": "C-",
  "code_secteur_intervention": "C-02",
  "description_politique_dominante": "DEVELOPPEMENT URBAIN DURABLE",
  "description_secteur_intervention": "Aménagement urbain"
}

Record 4rowkey: b68ba2a9-8630-41c3-9be0-1c09f80d054b · vmt_bp: 297000

{
  "rowkey": "b68ba2a9-8630-41c3-9be0-1c09f80d054b",
  "vmt_bp": 297000,
  "entityid": "e4418716-fee3-4ee1-b36c-6fc33caee1ca",
  "timestamp": "2015-05-06T10:28:21+00:00",
  "vsectsubv": "Fonctionnement",
  "partitionkey": "e4418716-fee3-4ee1-b36c-6fc33caee1ca",
  "code_programme": "P021",
  "description_programme": "Actions de développement artistique",
  "nature_affect_operation": "Dépense",
  "code_politique_dominante": "B-",
  "code_secteur_intervention": "B-04",
  "description_politique_dominante": "DEVELOPPEMENT CULTUREL",
  "description_secteur_intervention": "Dév. action artistiq et cult."
}

Record 5rowkey: a1cc55c8-ecdf-4c48-86d4-73c6d0bf62c0 · vmt_bp: 605796

{
  "rowkey": "a1cc55c8-ecdf-4c48-86d4-73c6d0bf62c0",
  "vmt_bp": 605796,
  "entityid": "4b4a5758-0f62-4616-a3da-e4481a70aa14",
  "timestamp": "2015-05-06T10:28:21+00:00",
  "vsectsubv": "Investissement",
  "partitionkey": "4b4a5758-0f62-4616-a3da-e4481a70aa14",
  "code_programme": "P037",
  "description_programme": "Paysages urbains",
  "nature_affect_operation": "Recette",
  "code_politique_dominante": "C-",
  "code_secteur_intervention": "C-06",
  "description_politique_dominante": "DEVELOPPEMENT URBAIN DURABLE",
  "description_secteur_intervention": "Paysages et patrimoine urbains"
}

Live sample captured at profiling time — values may have changed upstream.

Verification Status

Using the API

Configuration

Base URL: https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/budgetpolpub2012

License

Licence Ouverte 2.0 (France / Etalab)Open

✓ Redistributable
✓ Attribution required

Query examples

curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/budgetpolpub2012/records?limit=20' -H 'Accept: application/json'

First 20 records of the dataset as JSON.

Uses the Opendatasoft Explore v2.1 syntax — supports select, where, group_by and order_by.

Full API documentation ↗

Rate limits

50 000 req/day

per ipmeasured

observed 2 days ago

Dataset

Volume & freshness

Records

366

Update cadence

Annual

declared upstream

Last upstream update

6 years ago

2020-07-23

License

No license declared upstream.

○ Documentation○ Data dictionary○ Versioning

Source: opendatasoft

Machine-readable & source

JSON

Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.

2012 Budget by Public Policy AreaBudget 2012 par politique publique

Trust score

Data schema (13 fields)

Query the data

Sample data (5 records)

Verification Status

Using the API

Configuration

License

Query examples

Rate limits

Dataset

Volume & freshness

License

Machine-readable & source