Consolidated essential public procurement data (tabular format)
This dataset provides consolidated, reprocessed public procurement data for France in Parquet and CSV formats, drawn from the essential data (DDECPP) published under the Order of 22 December 2022, describing contracts at the time of award. Updated roughly daily by downloading and reprocessing multiple official data sources, it is more comprehensive than equivalent data published by the Ministry of Finance. Each contract is identified by a unique "uid" combining the buyer's SIRET and internal market identifier; multiple rows may describe one contract where there are several holders or subsequent amendments affecting fields such as holder, amount, or duration. Source code and further documentation are available online.Consolidated, reprocessed and published essential public procurement data (DDECPP) in Parquet and CSV formats. The DDECPPs are the data published under the Order of 22 December 2022, and describe the data at the time of the award of the public contract. This data is too large to be opened in spreadsheet software. On the other hand, you can explore, filter and download DDECPPs in Excel format on ddecpp.info (see overview below). These data are updated approximately every day by downloading and reprocessing the data made available by the data sources listed on this page. This dataset is for example more comprehensive than the data published by the Ministry of Finance here and here because it exploits more data sources. Source code for data processing and publication: More information on the project at ddecpp.info/a-propos ## Counting Public Procurement each public contract is identified globally via the ‘uid’ column. This field is the concatenation of the buyer's SIRET ('Buyer _id') and the internal market identifier ('id'). the same public contract can be described on several lines because it may have more than one holder (_holder fields) it may have undergone modifications such as amendments (_id modification field). If _id modification is equal to 0, this shall be the data for the initial award of the contract, without modification. a contract amendment may affect only the following fields: ‘_* holder’, ‘amount’ and ‘dureeMonth’. The fields "dateNotification `" and "datePublicationDonnees" also apply to changes ("change.
Trust score
How is this computed?Weighted across five axes. Tap a ring for what it measures.
Data schema (2 fields)
Click a field to see example values.
| Field | Type | Description |
|---|---|---|
| name: uidName: uid | text | Raw schema metadata line for the unique identifier field.Raw schema metadata line for the unique identifier field. |
| column_2Column 2 | text | Auxiliary or unused column, largely empty.Auxiliary or unused column, largely empty. |
Schema inferred from the distribution file's first records 3 days ago. Column types are sampled estimates, not source-declared.
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.
Sample data (5 records)
| name: uid | column_2 |
|---|---|
| type: string | |
| title: Identifiant unique | |
| description: Concaténation du SIRET de l'acheteur (acheteur_id) et de l'identifiant interne de l'acheteur (id). Utilisé comme identifiant de marché unique au niveau national. | |
| } | |
| name: id |
Live sample captured at profiling time — values may have changed upstream.
Verification Status
Using the API
Query examples
curl -sL 'https://www.data.gouv.fr/api/1/datasets/r/9a4144c0-ee44-4dec-bee5-bbef38191d9a' -o data.csvFull csv file download — the schema shown was inferred from the file's first records.
Dataset
Volume & freshness
License
No license declared upstream.
Distributions (1)
9a4144c0-ee44-4dec-bee5-bbef38191d9a
https://www.data.gouv.fr/api/1/datasets/r/9a4144c0-ee44-4dec-bee5-bbef38191d9a