Register record·API·FR·Updated AnnualVERIFIED · checked 2d ago

E

Loans since 2002 of the City of BordeauxEmprunts depuis 2002 de la ville de Bordeaux

Name: Loans since 2002 of the City of Bordeaux
Creator: opendatasoft

Emprunts depuis 2002 de la ville de BordeauxLoans since 2002 of the City of Bordeaux

APIExecutable4/7Query nowOpen workbench Subscribe🇫🇷France

This API provides data on loan lines repaid since 2002 for the main budget of the City of Bordeaux, France. It is published as part of Bordeaux Métropole's open data portal and offers free access without authentication. The dataset details individual borrowing entries related to municipal finances, allowing users to track the city's debt repayment history over time. It is primarily relevant for financial transparency and analysis of local public debt management.Détails des lignes d'emprunts remboursés depuis 2002 pour le budget principal.

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

Data schema (12 fields)

Filterable via the API (12)

partitionkeyrowkeytimestampentityidexercicenumobjcontratpreteurdureeresiduellefinexercicetypetauxtauxprevisionnel0101exercicedette0101exerciceecheanceexercice

Click a field to see example values.

Fill	Field	Type	Description
100%	partitionkey	text	Table storage partition key identifying the loan entity.Table storage partition key identifying the loan entity.
100%	rowkey	text	Unique row identifier for the loan record.Unique row identifier for the loan record.
100%	timestamp	datetime	Date and time the record was last updated.Date and time the record was last updated.
100%	entityid	text	Unique identifier of the loan entity.Unique identifier of the loan entity.
100%	exercice	date	Fiscal year the loan record refers to.Fiscal year the loan record refers to.
100%	numobjcontrat	text	Contract number and description of the loan's purpose.Contract number and description of the loan's purpose.
100%	preteur	text	Name of the lending institution.Name of the lending institution.
100%	dureeresiduellefinexercice	int	Remaining loan duration in years at fiscal year end.Remaining loan duration in years at fiscal year end.
100%	typetaux	text	Type of interest rate applied (e.g. fixed or variable).Type of interest rate applied (e.g. fixed or variable).
100%	tauxprevisionnel0101exercice	double	Forecast interest rate as of January 1st of the fiscal year.Forecast interest rate as of January 1st of the fiscal year.
100%	dette0101exercice	double	Outstanding debt amount as of January 1st of the fiscal year.Outstanding debt amount as of January 1st of the fiscal year.
100%	echeanceexercice	double	Total loan repayment amount due during the fiscal year.Total loan repayment amount due during the fiscal year.

Schema captured from opendatasoft 6 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: 09513552-0f1a-4b6e-9cd2-45238e4a91cf · preteur: CAISSE DES DEPOTS ET CONSIGNATIONS

{
  "rowkey": "09513552-0f1a-4b6e-9cd2-45238e4a91cf",
  "preteur": "CAISSE DES DEPOTS ET CONSIGNATIONS",
  "entityid": "070b914d-98a5-4d34-8328-2efc0e46de10",
  "exercice": "2009",
  "typetaux": "Variable",
  "timestamp": "2015-07-06T19:02:56+00:00",
  "partitionkey": "070b914d-98a5-4d34-8328-2efc0e46de10",
  "numobjcontrat": "11023 - P.R.U. 2002 Terrain aux essences des armées phase 2",
  "echeanceexercice": 218075.46,
  "dette0101exercice": 1531046.54,
  "dureeresiduellefinexercice": 8,
  "tauxprevisionnel0101exercice": 3.25
}

Record 2rowkey: 5ad9a233-cd9b-4af9-b651-d04fc5b6bb80 · preteur: SOCIETE GENERALE

{
  "rowkey": "5ad9a233-cd9b-4af9-b651-d04fc5b6bb80",
  "preteur": "SOCIETE GENERALE",
  "entityid": "0a1227e0-681f-4b28-b59a-b1d62aa4f1a8",
  "exercice": "2009",
  "typetaux": "Variable",
  "timestamp": "2015-07-06T19:02:57+00:00",
  "partitionkey": "0a1227e0-681f-4b28-b59a-b1d62aa4f1a8",
  "numobjcontrat": "11025 - Programme d'investissement 2003",
  "echeanceexercice": 861114.72,
  "dette0101exercice": 7195394.9,
  "dureeresiduellefinexercice": 9,
  "tauxprevisionnel0101exercice": 3.33
}

Record 3rowkey: 37b96460-3eeb-4bd5-b230-be3dcf3f897c · preteur: CAISSE DES DEPOTS ET CONSIGNATIONS

{
  "rowkey": "37b96460-3eeb-4bd5-b230-be3dcf3f897c",
  "preteur": "CAISSE DES DEPOTS ET CONSIGNATIONS",
  "entityid": "0fcd9046-6946-4dd4-998c-05b2b87bba3b",
  "exercice": "2015",
  "typetaux": "FIXE",
  "timestamp": "2015-07-06T19:02:59+00:00",
  "partitionkey": "0fcd9046-6946-4dd4-998c-05b2b87bba3b",
  "numobjcontrat": "94 - H.L.M.Claveau,1ère tranche",
  "echeanceexercice": 9469.71,
  "dette0101exercice": 18737.44,
  "dureeresiduellefinexercice": 1,
  "tauxprevisionnel0101exercice": 2
}

Record 4rowkey: 14264cf9-ca5c-4bfb-9ea9-fe016f9558e6 · preteur: CAISSE DES DEPOTS ET CONSIGNATIONS

{
  "rowkey": "14264cf9-ca5c-4bfb-9ea9-fe016f9558e6",
  "preteur": "CAISSE DES DEPOTS ET CONSIGNATIONS",
  "entityid": "12d12b1f-ac32-46e2-8ba9-2968e431a2de",
  "exercice": "2005",
  "typetaux": "Fixe",
  "timestamp": "2015-07-06T19:02:55+00:00",
  "partitionkey": "12d12b1f-ac32-46e2-8ba9-2968e431a2de",
  "numobjcontrat": "10965 - Renégociation de la dette. Emp.817",
  "echeanceexercice": 398959.77,
  "dette0101exercice": 376022.41,
  "dureeresiduellefinexercice": 0,
  "tauxprevisionnel0101exercice": 6.0941
}

Record 5rowkey: 93a2f5bb-c816-43d3-ad3f-2e072f8f6c12 · preteur: CAISSE DES DEPOTS ET CONSIGNATIONS

{
  "rowkey": "93a2f5bb-c816-43d3-ad3f-2e072f8f6c12",
  "preteur": "CAISSE DES DEPOTS ET CONSIGNATIONS",
  "entityid": "14b45a42-50cb-4b20-aa74-08351fb8d6c2",
  "exercice": "2012",
  "typetaux": "Variable",
  "timestamp": "2015-07-06T19:02:58+00:00",
  "partitionkey": "14b45a42-50cb-4b20-aa74-08351fb8d6c2",
  "numobjcontrat": "10994 - Reprise des Hameaux de Garonne",
  "echeanceexercice": 152297.61,
  "dette0101exercice": 1410599.73,
  "dureeresiduellefinexercice": 11,
  "tauxprevisionnel0101exercice": 3.55
}

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/emprunts

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/emprunts/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 6 days ago

Dataset

Volume & freshness

Records

793

Update cadence

Annual

declared upstream

Last upstream update

6 years ago

2020-12-18

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.

Loans since 2002 of the City of BordeauxEmprunts depuis 2002 de la ville de Bordeaux

Trust score

Data schema (12 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