Register record·API·FRVERIFIED · checked 2d ago
A
Road Traffic Injury Accidents in Bordeaux Métropole 2006-2011Accidents corporels de la circulation sur Bordeaux Métropole 2006-2011
Accidents corporels de la circulation sur Bordeaux Métropole 2006-2011Road Traffic Injury Accidents in Bordeaux Métropole 2006-2011
This dataset provides records of personal injury road traffic accidents within Bordeaux Métropole for the period 2006-2011. It originates from a national accident database maintained by the French Ministry of the Interior, which was reformatted during an OpenDataCamp event organized by Etalab and Devoxx on 16 April 2014. The reformatting was carried out collectively so the data could be imported into standard database management systems and published as an open resource. It covers the geographic area of Bordeaux Métropole in France and is useful for analyzing local road safety trends over the period covered.Lors de l'OpenDataCamp organisé par Etalab et Devoxx le 16 avril 2014. La base de données des accidents du Ministère de l'Intérieur concernant la période 2006-2011 a pu être reformatée (travail collectif) afin d'être importable dans un SGBD classique et mis à disposition en ressource du jeu de do...
transport
Trust score
How is this computed?45
fair
Weighted across five axes. Tap a ring for what it measures.
Data schema (52 fields)
Filterable via the API (51)
orglumaggintatmcoldepcatrinfravoiev1v2circnbvprpr1vospprofplansituttuetbgtbltindmtypenumeronumerodistancemetrelibellevoiecoderivoligravgpslatlongadrnumaccodeinseegeoflamatchnbimpliqueorganismelumiereagglomerationintersectioncondition_atmospheriquetype_de_collisioncategorie_de_routeregime_de_circulationvoie_specialeprofil_en_longtrace_en_plansituation_de_l_accidentdepartement
Click a field to see example values.
| Fill | Field | Type | Description |
|---|---|---|---|
| 100% | orgOrganisme | text | Code for the authority reporting the accident (police, gendarmerie, etc.).1 - Gendarmerie 2 - Préfecture de Police de Paris 3 - C.R.S. 4 - P.A.F. 5 - Sécurité publique |
| 100% | lumLumière | text | Code for lighting conditions at the time of the accident.1 – Plein jour 2 – Crépuscule ou aube 3 – Nuit sans éclairage public 4 - Nuit avec éclairage public non allumé 5 – Nuit avec éclairage public allumé |
| 100% | aggAgglomération | text | Code indicating whether the accident occurred in a built-up area and its population size.1 – Hors agglomération 2 – Agglomération de moins de 2 000 habitants 3 – Agglomération entre 2 000 habitants et 5 000 habitants 4 - Agglomération entre 5 000 habitants et 10 000 habitants 5 - Agglomération entre 10 000 habitants et 20 000 habitants 6 - Agglomération entre 20 000 habitants et 50 000 habitants 7 - Agglomération entre 50 000 habitants et 100 000 habitants 8 – Agglomération entre 100 000 habitants et 300 000 habitants 9 – Agglomération de plus de 300 000 habitants |
| 100% | intIntersection | text | Code for the type of intersection where the accident occurred.1 – Hors intersection 2 – Intersection en X 3 – Intersection en T 4 – Intersection en Y 5 - Intersection à plus de 4 branches 6 - Giratoire 7 - Place 8 – Passage à niveau 9 – Autre intersection |
| 100% | atmCondition atmosphérique | text | Code for atmospheric/weather conditions at the time of the accident.1 – Normale 2 – Pluie légère 3 – Pluie forte 4 – Neige - grêle 5 – Brouillard - fumée 6 – Vent fort - tempete 7 – Temps éblouissant 8 – Temps couvert 9 – Autre |
| 100% | colType de Collision | text | Code for the type of collision involved in the accident.1 – Deux véhicules - frontale 2 – Deux véhicules – par l’arrière 3 – Deux véhicules – par le coté 4 – Trois véhicules et plus – en chaîne 5 – Trois véhicules et plus - collisions multiples 6 – Autre collision 7 – Sans collision |
| 100% | depDépartement | int | INSEE department code where the accident occurred.Code INSEE du département suivi d'un 0 (sauf 02A et 02B) – métropole et 4 DOM comme indiqué plus haut |
| 100% | catrCatégorie de route | text | Code for the category of road where the accident occurred.1 - Autoroute 2 - Route Nationale 3 - Route Départementale 4 - Voie Communale 5 - Hors réseau public 6 - Parc de stationnement ouvert à la circulation publique 9 – autre |
| 100% | infraAménagement - Infrastructure | text | Code for special infrastructure present at the accident location.1 – Souterrain - tunnel 2 – Pont - autopont 3 – Bretelle d’échangeur ou de raccordement 4 - Voie ferrée 5 – Carrefour aménagé 6 – Zone piétonne 7 – Zone de péage |
| 99.9% | voie | text | Road number where the accident occurred.Numéro de la route |
| 52.1% | v1 | text | Numeric suffix index of the road number, e.g. bis, ter.Indice numérique du numéro de route (exemple : 2 bis, 3 ter etc) |
| 0.2% | v2 | text | Alphanumeric suffix of the road identifier.Indice alphanumérique de la route |
| 100% | circRégime de circulation | text | Code for the traffic flow regime on the road.1 – A sens unique 2 – Bidirectionnelle 3 – A chaussées séparées 4 – Avec voies d’affectation variable |
| 99.1% | nbvNombre total de voies de circulation | text | Total number of traffic lanes at the accident location.Nombre total de voies de circulation |
| 21.8% | pr | text | Reference marker number of the nearest upstream milestone.Numéro du PR de rattachement (numéro de la borne amont) |
| 21.8% | pr1 | text | Distance in meters to the reference upstream milestone.Distance en mètres au PR (par rapport à la borne amont) |
| 100% | vospVoie spéciale | text | Code indicating presence of a special reserved lane.1 – Piste cyclable 2 – Bande cyclable 3 – Voie réservée |
| 100% | profProfil en long | text | Code for the longitudinal road profile (flat, slope, crest, etc.).1 - Plat 2 - Pente 3 - Sommet de cote 4- Bas de côte |
| 100% | planTracé en plan | text | Code for the road's plan layout (straight, curve, S-shape).1 – Partie rectiligne 2 – En courbe à gauche 3 – En courbe à droite 4- En « S » |
| 100% | situSituation de l’accident | text | Code for the accident's location relative to the road (carriageway, shoulder, etc.).1 – Sur chaussée 2 – Sur bande d’arret d’urgence 3 – Sur accotement 4 – Sur trottoir 5 – Sur piste cyclable |
| 100% | ttueNombre de personnes tuées dans l'accident | int | Number of people killed in the accident.Nombre de personnes tuées dans l'accident |
| 100% | tbgNombre de blessés hospitalisés (blessés graves) dans l'accident | int | Number of people hospitalized with serious injuries in the accident.Nombre de blessés hospitalisés (blessés graves) dans l'accident |
| 100% | tblNombre de blessés légers dans l'accident | int | Number of people with minor injuries in the accident.Nombre de blessés légers dans l'accident |
| 100% | tindmNombre de personnes indemnes dans l'accident | int | Number of people unharmed in the accident.Nombre de personnes indemnes dans l'accident |
| 89.2% | typenumero | int | Code for the type of street number reference used.0 – Numéro non renseigné 1 – Adresse postale 2 - Candélabre (quand on se rattache à un candélabre répertorié dans une base de données urbaine) 9 – Autre |
| 78% | numero | int | Street or lamp post number associated with the accident location.Numéro de l'adresse ou du candélabre. Peut contenir bis, ter... |
| 89.2% | distancemetre | int | Distance in meters to the referenced street number.Distance au numéro, blancs si non renseigné |
| 89.1% | libellevoie | text | Name of the road or street where the accident occurred.Libellé de la voie |
| 0% | coderivoli | text | RIVOLI cadastral code for the street.code rivoli (Cf. cadastre) |
| 100% | gravIndice de gravité de l'accident | double | Severity index of the accident based on weighted casualty costs.Calculé selon le cout normalisé des atteintes aux victimes (intervenant dans le calcul annuel du coût pour la Nation de l’insécurité routière), en proportion des valeurs tutélaires misses à jour pour l’année 2011 (chaque tué est ainsi valorisé à hauteur de 100 points d’indice, chaque hospitalisé à hauteur de10,8, chaque blessé léger à hauteur de 0,44). |
| — | gps | text | Code for the geographic region (mainland or overseas territory).M = Métropole A = Antilles (Martinique ou Guadeloupe) G = Guyane R = Réunion |
| — | latLatitude | text | Latitude coordinate of the accident location.Latitude |
| — | longLongitude | text | Longitude coordinate of the accident location.Longitude |
| — | adrAdresse | text | Approximate, non-standardized address of the accident location.Adresse sommaire non normalisée (en principe inutile si l'adresse normalisée est correctement renseignée, voir plus loin) |
| — | numac | int | Unique identifier of the accident record.Identifiant de l'accident |
| — | codeinsee | text | INSEE code of the municipality where the accident occurred.Code Insee |
| — | geoflamatch | text | Indicator of whether the location matched the geolocation database.Soit "O", soit "N" pour signifier s'il correspond ou non. Soit "C" lorsqu'il a du être corrigé pour correspondre. L'outre-mer n'a pas été traité en ce sens, il est noté "N" par défaut. |
| — | nbimpliqueNombre impliques | int | Number of people involved in the accident.Nombre de personnes impliquées dans l'accident |
| — | coordCoordonnées | geo_point_2d | Geographic coordinates of the accident location.Coordonnées géographiques |
| — | organisme | text | Name of the authority that reported the accident.Name of the authority that reported the accident. |
| 100% | lumiereLumière | text | Lighting conditions at the time of the accident.Lighting conditions at the time of the accident. |
| 100% | agglomerationAgglomération | text | Description of the built-up area classification of the location.Description of the built-up area classification of the location. |
| 100% | intersection | text | Type of intersection where the accident occurred.Type of intersection where the accident occurred. |
| 100% | condition_atmospheriqueCondition atmosphérique | text | Weather conditions at the time of the accident.Weather conditions at the time of the accident. |
| 100% | type_de_collisionType de collision | text | Type of collision involved in the accident.Type of collision involved in the accident. |
| 100% | categorie_de_routeCatégorie de route | text | Category of road where the accident occurred.Category of road where the accident occurred. |
| 97.4% | regime_de_circulationRégime de circulation | text | Traffic flow regime of the road at the accident site.Traffic flow regime of the road at the accident site. |
| 19.5% | voie_specialeVoie spéciale | text | Type of special reserved lane present at the location.Type of special reserved lane present at the location. |
| 97.5% | profil_en_longProfil en long | text | Longitudinal profile of the road at the accident site.Longitudinal profile of the road at the accident site. |
| 96.8% | trace_en_planTracé en plan | text | Plan layout of the road at the accident site.Plan layout of the road at the accident site. |
| 97.6% | situation_de_l_accidentSituation de l accident | text | Location of the accident relative to the roadway.Location of the accident relative to the roadway. |
| 100% | departementDépartement | text | Name or code of the department where the accident occurred.Name or code of the department where the accident occurred. |
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.
=
Sample data (5 records)
These rows are ODbL-1.0: share-alike. Reusing them obliges you to license any derived database on the same terms.
Record 1pr: 66 · v1: —
{
"pr": "66",
"v1": null,
"v2": null,
"adr": null,
"agg": "1",
"atm": "2",
"col": "1",
"dep": 330,
"gps": null,
"int": "1",
"lat": "4492900",
"lum": "2",
"nbv": "2",
"org": "1",
"pr1": "90",
"tbg": 1,
"tbl": 1,
"catr": "3",
"circ": "2",
"grav": 11.23,
"long": "-54400",
"plan": "3",
"prof": "1",
"situ": "1",
"ttue": 0,
"voie": "10",
"vosp": "0",
"coord": {
"lat": 44.9582743614,
"lon": -0.533092800544
},
"infra": "0",
"numac": 389483,
"tindm": 0,
"numero": null,
"lumiere": "Crépuscule ou aube",
"codeinsee": "33434",
"organisme": "Gendarmerie",
"coderivoli": null,
"nbimplique": 2,
"typenumero": null,
"departement": "33",
"geoflamatch": "O",
"libellevoie": null,
"intersection": "Hors intersection",
"agglomeration": "Hors agglomération",
"distancemetre": null,
"trace_en_plan": "En courbe à droite",
"voie_speciale": null,
"profil_en_long": "Plat",
"type_de_collision": "Deux véhicules - frontale",
"categorie_de_route": "Route Départementale",
"regime_de_circulation": "Bidirectionnelle",
"condition_atmospherique": "Pluie légère",
"situation_de_l_accident": "Sur chaussée"
}Record 2pr: 0035 · v1: 0
{
"pr": "0035",
"v1": "0",
"v2": null,
"adr": null,
"agg": "1",
"atm": "2",
"col": "4",
"dep": 330,
"gps": null,
"int": "1",
"lat": null,
"lum": "2",
"nbv": "6",
"org": "3",
"pr1": "0500",
"tbg": 0,
"tbl": 4,
"catr": "2",
"circ": "3",
"grav": 1.72,
"long": null,
"plan": "1",
"prof": "1",
"situ": "1",
"ttue": 0,
"voie": "00230",
"vosp": "0",
"coord": {
"lat": 44.8160953539,
"lon": -0.50487313207
},
"infra": "0",
"numac": 252249,
"tindm": 3,
"numero": null,
"lumiere": "Crépuscule ou aube",
"codeinsee": "33065",
"organisme": "C.R.S.",
"coderivoli": null,
"nbimplique": 7,
"typenumero": null,
"departement": "33",
"geoflamatch": "O",
"libellevoie": null,
"intersection": "Hors intersection",
"agglomeration": "Hors agglomération",
"distancemetre": null,
"trace_en_plan": "Partie rectiligne",
"voie_speciale": null,
"profil_en_long": "Plat",
"type_de_collision": "Trois véhicules et plus – en chaîne",
"categorie_de_route": "Route Nationale",
"regime_de_circulation": "A chaussées séparées",
"condition_atmospherique": "Pluie légère",
"situation_de_l_accident": "Sur chaussée"
}Record 3pr: 0000 · v1: 0
{
"pr": "0000",
"v1": "0",
"v2": null,
"adr": null,
"agg": "1",
"atm": "1",
"col": "1",
"dep": 330,
"gps": null,
"int": "1",
"lat": "0",
"lum": "1",
"nbv": "3",
"org": "1",
"pr1": "0350",
"tbg": 1,
"tbl": 0,
"catr": "3",
"circ": "2",
"grav": 10.8,
"long": "0",
"plan": "1",
"prof": "0",
"situ": "1",
"ttue": 0,
"voie": "00001",
"vosp": "0",
"coord": {
"lat": 44.8690837903,
"lon": -0.684443512134
},
"infra": "0",
"numac": 291110,
"tindm": 1,
"numero": null,
"lumiere": "Plein jour",
"codeinsee": "33200",
"organisme": "Gendarmerie",
"coderivoli": null,
"nbimplique": 2,
"typenumero": null,
"departement": "33",
"geoflamatch": "O",
"libellevoie": null,
"intersection": "Hors intersection",
"agglomeration": "Hors agglomération",
"distancemetre": null,
"trace_en_plan": "Partie rectiligne",
"voie_speciale": null,
"profil_en_long": null,
"type_de_collision": "Deux véhicules - frontale",
"categorie_de_route": "Route Départementale",
"regime_de_circulation": "Bidirectionnelle",
"condition_atmospherique": "Normale",
"situation_de_l_accident": "Sur chaussée"
}Record 4pr: 0000 · v1: 0
{
"pr": "0000",
"v1": "0",
"v2": null,
"adr": null,
"agg": "1",
"atm": "1",
"col": "7",
"dep": 330,
"gps": null,
"int": "1",
"lat": "0",
"lum": "3",
"nbv": "1",
"org": "1",
"pr1": "0000",
"tbg": 1,
"tbl": 0,
"catr": "4",
"circ": "2",
"grav": 110.8,
"long": "0",
"plan": "1",
"prof": "1",
"situ": "1",
"ttue": 1,
"voie": "00000",
"vosp": "0",
"coord": {
"lat": 45.0115337381,
"lon": -0.548307688841
},
"infra": "0",
"numac": 448111,
"tindm": 0,
"numero": null,
"lumiere": "Nuit sans éclairage public",
"codeinsee": "33004",
"organisme": "Gendarmerie",
"coderivoli": null,
"nbimplique": 2,
"typenumero": null,
"departement": "33",
"geoflamatch": "O",
"libellevoie": null,
"intersection": "Hors intersection",
"agglomeration": "Hors agglomération",
"distancemetre": null,
"trace_en_plan": "Partie rectiligne",
"voie_speciale": null,
"profil_en_long": "Plat",
"type_de_collision": "Sans collision",
"categorie_de_route": "Voie Communale",
"regime_de_circulation": "Bidirectionnelle",
"condition_atmospherique": "Normale",
"situation_de_l_accident": "Sur chaussée"
}Record 5pr: 0000 · v1: 0
{
"pr": "0000",
"v1": "0",
"v2": null,
"adr": null,
"agg": "1",
"atm": "1",
"col": "1",
"dep": 330,
"gps": null,
"int": "1",
"lat": "0",
"lum": "1",
"nbv": "2",
"org": "1",
"pr1": "0000",
"tbg": 3,
"tbl": 0,
"catr": "3",
"circ": "0",
"grav": 32.4,
"long": "0",
"plan": "1",
"prof": "1",
"situ": "1",
"ttue": 0,
"voie": "01215",
"vosp": "0",
"coord": {
"lat": 44.9333497941,
"lon": -0.748518197327
},
"infra": "0",
"numac": 425353,
"tindm": 0,
"numero": null,
"lumiere": "Plein jour",
"codeinsee": "33376",
"organisme": "Gendarmerie",
"coderivoli": null,
"nbimplique": 3,
"typenumero": null,
"departement": "33",
"geoflamatch": "O",
"libellevoie": null,
"intersection": "Hors intersection",
"agglomeration": "Hors agglomération",
"distancemetre": null,
"trace_en_plan": "Partie rectiligne",
"voie_speciale": null,
"profil_en_long": "Plat",
"type_de_collision": "Deux véhicules - frontale",
"categorie_de_route": "Route Départementale",
"regime_de_circulation": null,
"condition_atmospherique": "Normale",
"situation_de_l_accident": "Sur chaussée"
}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/accidents-corporels-de-la-circulation-sur-bordeaux-metropole-2006-2011
License
- ✓ Redistributable
- ✓ Attribution required
Query examples
curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/accidents-corporels-de-la-circulation-sur-bordeaux-metropole-2006-2011/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.
Rate limits
10 000 000 req/day
per ipmeasured
observed 2 days ago
Dataset
Volume & freshness
Records
9.0k
9015
Last upstream update
7 years ago
2019-08-08
License
No license declared upstream.
○ Documentation○ Data dictionary○ Versioning
Source: opendatasoft
Machine-readable & source
Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.