Geographic origin of public contract holders 2018-2023Origine géographique des titulaires de marchés 2018-2023

Origine géographique des titulaires de marchés 2018-2023Geographic origin of public contract holders 2018-2023

APIExecutable4/7Query nowOpen workbench Subscribe🇫🇷France

This dataset traces the geographic origin of holders of public procurement contracts awarded between 2018 and 2023, published by the city of Strasbourg. It links contract data (subject, amount, duration, procedure) with the postal code of the holding entity, or of the lead partner in case of joint bidding. The dataset allows analysis of where contract-winning companies are based relative to the contracting authority, supporting studies on local economic impact and the geographic distribution of public procurement awards.Ce jeu de données permet de retracer l’origine géographique des titulaires, cela revient à faire correspondre les données des marchés (objet, montant, durée, procédure…) avec le code postal de la structure titulaire (ou du mandataire en cas de cotraitance) pour la période 2018-2023 . Informations...

⬇ 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 (10 fields)

Filterable via the API (9)

exerciceproceduremontanttiers_villetiers_code_postalgranularitetiers_code_paysliennum_unique

Click a field to see example values.

Field	Type	Description
geo_point_2dGeo Point	geo_point_2d	Geographic coordinates (latitude/longitude) of the contract holder.Geographic coordinates (latitude/longitude) of the contract holder.
exercice	text	Fiscal or contract year.Fiscal or contract year.
procedure	text	Type of procurement procedure used.Type of procurement procedure used.
montant	double	Contract amount, likely in euros.Contract amount, likely in euros.
tiers_villeTiers ville	text	City where the contract holder is located.City where the contract holder is located.
tiers_code_postalTiers code postal	text	Postal code of the contract holder's location.Postal code of the contract holder's location.
granularite	text	Geographic area level, such as department name.Geographic area level, such as department name.
tiers_code_paysTiers code pays	text	Country code of the contract holder.Country code of the contract holder.
lien	text	Code linking country and department identifiers.Code linking country and department identifiers.
num_uniqueNum unique	text	Unique identifier for the contract record.Unique identifier for the contract record.

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 1lien: 250_67 · montant: 954

{
  "lien": "250_67",
  "montant": 954,
  "exercice": "2018",
  "procedure": "MAPA 0",
  "num_unique": "VDS 2018 0 640082 1",
  "granularite": "Bas-Rhin",
  "tiers_ville": "STRASBOURG",
  "geo_point_2d": {
    "lat": 48.5716222333,
    "lon": 7.76768232804
  },
  "tiers_code_pays": "250",
  "tiers_code_postal": "67200"
}

Record 2lien: 250_67 · montant: 29

{
  "lien": "250_67",
  "montant": 29,
  "exercice": "2022",
  "procedure": "MAPA 0",
  "num_unique": "VDS 2022 0 756516 1",
  "granularite": "Bas-Rhin",
  "tiers_ville": "STRASBOURG",
  "geo_point_2d": {
    "lat": 48.5716222333,
    "lon": 7.76768232804
  },
  "tiers_code_pays": "250",
  "tiers_code_postal": "67200"
}

Record 3lien: 250_68 · montant: 396.45

{
  "lien": "250_68",
  "montant": 396.45,
  "exercice": "2018",
  "procedure": "MAPA 0",
  "num_unique": "VDS 2018 0 656649 1",
  "granularite": "Haut-Rhin",
  "tiers_ville": "COLMAR",
  "geo_point_2d": {
    "lat": 48.1102094696,
    "lon": 7.38500410192
  },
  "tiers_code_pays": "250",
  "tiers_code_postal": "68000"
}

Record 4lien: 250_77 · montant: 304.8

{
  "lien": "250_77",
  "montant": 304.8,
  "exercice": "2021",
  "procedure": "MAPA 0",
  "num_unique": "CUS 2021 0 693286 1",
  "granularite": "France (hors Alsace) (hors Alsace) (hors Alsace) (hors Alsace)",
  "tiers_ville": "VAUX LE PENIL",
  "geo_point_2d": {
    "lat": 48.5229543545,
    "lon": 2.67825416798
  },
  "tiers_code_pays": "250",
  "tiers_code_postal": "77000"
}

Record 5lien: 250_67 · montant: 98.42

{
  "lien": "250_67",
  "montant": 98.42,
  "exercice": "2019",
  "procedure": "MAPA 0",
  "num_unique": "VDS 2019 0 677039 1",
  "granularite": "Bas-Rhin",
  "tiers_ville": "STRASBOURG",
  "geo_point_2d": {
    "lat": 48.5716222333,
    "lon": 7.76768232804
  },
  "tiers_code_pays": "250",
  "tiers_code_postal": "67200"
}

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

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

82k

81760

Last upstream update

2 years ago

2024-08-19

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.