Public Contracts Awarded 2006-2012Marchés publics conclus 2006-2012

Marchés publics conclus 2006-2012Public Contracts Awarded 2006-2012

APIJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

This dataset lists public contracts awarded by the Urban Community of Strasbourg (CUS) and the City of Strasbourg with a value exceeding 4,000 euros. Each entry includes the contract threshold, the awarded contractor, the award date, the type of contract, and the subject matter of the contract. Historical coverage extends back to 2006. The dataset is published via the Strasbourg open data portal and is useful for tracking public procurement activity and contractor awards within the Strasbourg metropolitan area over this period.Ce jeu de données contient la liste des marchés publics conclus de la CUS et de la ville de Strasbourg qui sont supérieurs à 4000 euros. Ils sont complétés par le seuil du marché, l'attributaire, la date d'attribution, le type de marché et l'objet du marché. L'historique remonte jusqu'à 2006. Les...

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

Trust score

How is this computed?

fair

Weighted across five axes. Tap a ring for what it measures.

Data schema (11 fields)

Filterable via the API (9)

collectiviteannee_de_marchenumero_de_marcheobjet_du_marche_1objet_du_marche_2attributairecpdebut_d_executionseuils

Click a field to see example values.

Fill	Field	Type	Description
100%	collectivite	text	Local authority awarding the contract (e.g. city or urban community).Local authority awarding the contract (e.g. city or urban community).
100%	annee_de_marcheAnnee de marche	date	Year the public contract was concluded.Year the public contract was concluded.
100%	numero_de_marcheNumero de marche	text	Identification number of the public contract.Identification number of the public contract.
100%	objet_du_marche_1Objet du marche 1	text	Main description of the contract's subject matter.Main description of the contract's subject matter.
71.3%	objet_du_marche_2Objet du marche 2	text	Additional description or detail of the contract's subject matter.Additional description or detail of the contract's subject matter.
100%	attributaire	text	Name of the company or entity awarded the contract.Name of the company or entity awarded the contract.
100%	cp	text	Postal code associated with the contractor or contract location.Postal code associated with the contractor or contract location.
100%	debut_d_executionDebut d execution	date	Start date of contract execution.Start date of contract execution.
100%	seuils	text	Value threshold range of the contract in euros excluding tax.Value threshold range of the contract in euros excluding tax.
83.8%	coord	geo_shape	Geographic shape associated with the contract location.Geographic shape associated with the contract location.
—	geo_point_2dCoordinates	geo_point_2d	Geographic coordinates (latitude and longitude) of the contract location.Geographic coordinates (latitude and longitude) of the contract location.

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 1cp: 67230 · coord: [large value omitted]

{
  "cp": "67230",
  "coord": "[large value omitted]",
  "seuils": "Marchés de 90 000 à 199 999,99 euros HT",
  "attributaire": "LA PAYSAGERIE",
  "collectivite": "VDS",
  "geo_point_2d": {
    "lat": 48.35346977023232,
    "lon": 7.594349377476886
  },
  "annee_de_marche": "2008",
  "numero_de_marche": "1171",
  "debut_d_execution": "2008-04-11",
  "objet_du_marche_1": "PREST. DE NETTOYAGE DES PLANS D'EAU ET DES BERGES DE STBG",
  "objet_du_marche_2": null
}

Record 2cp: 67000 · coord: [large value omitted]

{
  "cp": "67000",
  "coord": "[large value omitted]",
  "seuils": "Marchés de 4 000 à 19 999,99 euros HT",
  "attributaire": "ATELIER POSTE 4",
  "collectivite": "VDS",
  "geo_point_2d": {
    "lat": 48.57162223329029,
    "lon": 7.767682328042654
  },
  "annee_de_marche": "2013",
  "numero_de_marche": "1438",
  "debut_d_execution": "2014-05-01",
  "objet_du_marche_1": "PREPRESSE, GRAPHISME ET IMPRESSION PRODUITS DERIVES ET",
  "objet_du_marche_2": "CATALOGUE DE COLLECTION DES MUSEES. LOT 3"
}

Record 3cp: 67000 · coord: [large value omitted]

{
  "cp": "67000",
  "coord": "[large value omitted]",
  "seuils": "Marchés de 20 000 à 89 999,99 euros HT",
  "attributaire": "LIBRAIRIE INTERNATIONALE",
  "collectivite": "CUS",
  "geo_point_2d": {
    "lat": 48.57162223329029,
    "lon": 7.767682328042654
  },
  "annee_de_marche": "2015",
  "numero_de_marche": "9",
  "debut_d_execution": "2015-01-01",
  "objet_du_marche_1": "ACQUIS. DOCUMENTS IMPRIMES, JEUX VIDEO ET DVD POUR LES",
  "objet_du_marche_2": "MEDIATHEQUES ET LES ECOLES"
}

Record 4cp: 67700 · coord: [large value omitted]

{
  "cp": "67700",
  "coord": "[large value omitted]",
  "seuils": "Marchés de 4 000 à 19 999,99 euros HT",
  "attributaire": "EUROFINS ANALYSES ENVIRON FRANCE",
  "collectivite": "CUS",
  "geo_point_2d": {
    "lat": 48.735801488236035,
    "lon": 7.354736009726269
  },
  "annee_de_marche": "2009",
  "numero_de_marche": "7",
  "debut_d_execution": "2009-01-01",
  "objet_du_marche_1": "CONTROLE REJETS AQUEUX, ATMOSPHERIQUES ET SOLIDES DE L'UIOM",
  "objet_du_marche_2": "DE LA CUS. LOT 2"
}

Record 5cp: 91520 · coord: {"type":"Feature","geometry":{"type":"Po

{
  "cp": "91520",
  "coord": {
    "type": "Feature",
    "geometry": {
      "type": "Polygon",
      "coordinates": [
        [
          [
            2.19909512456702,
            48.5800858401812
          ],
          [
            2.22572169143772,
            48.5841590263193
          ],
          [
            2.23489298219595,
            48.5889698773559
          ],
          [
            2.23894080158983,
            48.5805560414133
          ],
          [
            2.2380736531681498,
            48.5761371671161
          ],
          [
            2.22636918433892,
            48.5667554541749
          ],
          [
            2.22399857400488,
            48.5666635500947
          ],
          [
            2.20107638663915,
            48.573740910101
          ],
          [
            2.1985201224832602,
            48.5756650215519
          ],
          [
            2.19909512456702,
            48.5800858401812
          ]
        ]
      ]
    },
    "properties": {}
  },
  "seuils": "Marchés de 20 000 à 89 999,99 euros HT",
  "attributaire": "HABA",
  "collectivite": "VDS",
  "geo_point_2d": {
    "lat": 48.576991381210135,
    "lon": 2.220936791958178
  },
  "annee_de_marche": "2013",
  "numero_de_marche": "1019",
  "debut_d_execution": "2013-08-26",
  "objet_du_marche_1": "FOURN. POUR LA RESTRUCTURATION DU BATIMENT DE L'ACTUELLE",
  "objet_du_marche_2": "BIBLIOTHEQUE DU NEUHOF EN UNE MAISON DE L'ENFANCE"
}

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

Verification Status

Using the API

Configuration

Base URL: https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/marches-publics-conclus

License

Licence Ouverte 2.0 (France / Etalab)Open

✓ Redistributable
✓ Attribution required

Query examples

curl -s 'https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/marches-publics-conclus/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

2 000 000 req/day

per ipmeasured

observed 2 days ago

Dataset

Volume & freshness

Records

23k

22543

Last upstream update

8 years ago

2019-02-06

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.