Personal injury road accidents in Bordeaux Métropole 2012-2019Accidents corporels de la circulation sur Bordeaux Métropole 2012-2019
Accidents corporels de la circulation sur Bordeaux Métropole 2012-2019Personal injury road accidents in Bordeaux Métropole 2012-2019
This dataset lists personal injury road accidents recorded within Bordeaux Métropole between 2012 and 2019, covering incidents on public roads involving at least one vehicle and resulting in at least one victim requiring medical care. For each accident, law enforcement units record descriptive information such as location, date, and circumstances at the time the incident is reported. The data is published via the Bordeaux Métropole open data portal and can be used for road safety analysis, traffic planning, and research into accident patterns across the metropolitan area over the covered period.Pour chaque accident corporel (soit un accident survenu sur une voie ouverte à la circulation publique, impliquant au moins un véhicule et ayant fait au moins une victime ayant nécessité des soins), des saisies d’information décrivant l’accident sont effectuées par l’unité des forces de l’ordre (...
Trust score
How is this computed?Weighted across five axes. Tap a ring for what it measures.
Data schema (70 fields)
Click a field to see example values.
| Fill | Field | Type | Description |
|---|---|---|---|
| 100% | num_accIdentifiant de l'accident | text | Unique identifier of the accident.Numéro d'identifiant de l'accident |
| 100% | datetimeDate et heure | datetime | Date and time the accident occurred.Date et heure de l'accident |
| 100% | nom_comNom com | text | Name of the municipality where the accident occurred.Commune |
| 100% | anAnnée | text | Year the accident occurred.Année |
| 100% | mois | text | Month the accident occurred.Mois |
| 100% | jour | text | Day of the month the accident occurred.Jour |
| 100% | hrmnHeure minute | text | Time of the accident (hour and minute).Heure minute |
| 100% | lumLumière | text | Lighting conditions at the time of the accident.Lumière : conditions d'éclairage dans lesquelles l'accident s'est produit |
| 100% | aggLocalisation | text | Whether the accident occurred within a built-up area or not.Localisation |
| 100% | intIntersection | text | Whether the accident occurred at an intersection.Intersection |
| 100% | atmConditions atmosphériques | text | Atmospheric conditions at the time of the accident.Conditions atmosphériques |
| 100% | colCollision | text | Type of collision involved in the accident.Type de collision |
| 100% | depDépartement | text | INSEE code of the département where the accident occurred.Département : Code INSEE |
| 100% | comCode commune | text | INSEE municipality code, right-aligned 3-digit number.Commune : Le numéro de commune est un code donné par l'INSEE. Le code comporte 3 chiffres calés à droite |
| 100% | inseeCode Insee | text | INSEE code of the municipality.Code insee |
| 100% | code_postalPostal code | text | Postal code of the accident location.Code postal |
| 93.5% | adrAdresse | text | Postal address, recorded for accidents within built-up areas.Adresse postale : variable renseignée pour les accidents survenus en agglomération |
| 30.1% | latLatitude | text | Latitude of the accident location.Latitude |
| 30.1% | longLongitude | text | Longitude of the accident location.Longitude |
| 14.8% | numNuméro | text | House or building number of the accident location.Numéro |
| — | coordonneesCoordonnées | geo_point_2d | Geographic coordinates of the accident location.Coordonnées |
| — | pr | text | Reference marker (PR) number upstream of the accident.Numéro du PR de rattachement (numéro de la borne amont) |
| — | pr1 | text | Distance in meters from the upstream PR marker.Distance en mètres au PR (par rapport à la borne amont) |
| — | surfSurface | text | Condition of the road surface.Etat de la surface |
| — | v1 | text | Numeric index of the road number (e.g. 2 bis, 3 ter).Indice numérique du numéro de route (exemple : 2 bis, 3 ter etc.) |
| — | v2 | text | Alphanumeric letter index of the road.Lettre indice alphanumérique de la route |
| — | circCirculation | text | Traffic flow regime at the accident site.Régime de circulation |
| — | vospVoie réservée | text | Indicates presence of a reserved lane near the accident.Signale l'existence d'une voie réservée, indépendamment du fait que l'accident ait lieu ou non sur cette voie |
| — | vmaVitesse maximale autorisée | text | Maximum authorized speed at the accident site and time.Vitesse maximale autorisée sur le lieu et au moment de l’accident. |
| — | env1 | text | Indicates proximity to a school zone.point école : proximité d'une école |
| 87% | voie | text | Road number where the accident occurred.Numéro de la route |
| 88.5% | larroutLargeur de la chaussée | text | Width of the roadway used for vehicle traffic, in meters.Largeur de la chaussée affectée à la circulation des véhicules ne sont pas compris les bandes d'arrêt d'urgence, les TPC et les places de stationnement |
| 56.7% | lartpcLargeur terre plein central | text | Width of the central reservation, if present.Largeur du terre plein central (TPC) s'il existe |
| 99.9% | nbvNombre de voies | text | Total number of traffic lanes.Nombre total de voies de circulation |
| 100% | catrCatégorie route | text | Category of the road.Catégorie de route |
| 100.5% | plan | text | Horizontal road alignment at the accident site.Tracé en plan |
| 100.4% | profProfil | text | Longitudinal road profile (slope) at the accident site.Profil en long décrit la déclivité de la route à l'endroit de l'accident |
| 100.8% | infraInfrastructure | text | Type of infrastructure or road development present.Aménagement - Infrastructure |
| 100.4% | situSituation | text | Situation of the accident relative to the roadway.Situation de l'accident |
| 227% | an_naisAnnée de naissance | text | Birth year of the person involved.Année de naissance de l'usager |
| 147.9% | sexe | text | Sex of the person involved.Sexe de l'usager |
| 114.7% | actpAction piéton | text | Action of the pedestrian at the time of the accident.Action du piéton |
| 184.7% | gravGravité | text | Severity level of injury sustained by the person.Gravité de l'accident : Les usagers accidentés sont classés en trois catégories de victimes plus les indemnes |
| 154.7% | secu1 | text | First type of safety equipment used.Premier équipement de sécurité |
| 100% | secu2 | text | Second type of safety equipment used.Deuxième équipement de sécurité |
| 100% | secu3 | text | Third type of safety equipment used.Troisième équipement de sécurité |
| 114.2% | locpLocalisation du piéton | text | Location of the pedestrian at the time of the accident.Localisation du piéton |
| 100% | num_vehIdentifiant véhicule | text | Identifier of the vehicle for its occupants.Identifiant du véhicule repris pour chacun des usagers occupant ce véhicule |
| 137.7% | place | text | Seating position of the person within the vehicle.Permet de situer la place occupée dans le véhicule par l'usager au moment de l'accident |
| 137.2% | catuCatégorie d'usager | text | Category of road user (e.g. driver, passenger, pedestrian).Catégorie d'usager |
| 112.5% | etatpPiéton seul ou non | text | Indicates whether the pedestrian was alone or not.Cette variable permet de préciser si le piéton accidenté était seul ou non |
| 149.8% | trajetMotif trajet | text | Purpose of the trip at the time of the accident.Motif du déplacement au moment de l'accident |
| 169.1% | chocPoint de choc | text | Initial point of impact on the vehicle.Point de choc initial |
| 152.7% | manvManœuvre | text | Main maneuver performed before the accident.Manœuvre principale avant l'accident |
| 100% | sencSens | text | Direction of travel at the accident site.Sens de circulation |
| 123.1% | obsmObstacle mobile heurté | text | Moving obstacle struck during the accident.Obstacle mobile heurté |
| 106.1% | obsObstacle fixe heurté | text | Fixed obstacle struck during the accident.Obstacle fixe heurté |
| 154.6% | catvCatégorie véhicule | text | Category of the vehicle involved.Catégorie du véhicule |
| 2.2% | occutcNombre d'occupants | text | Number of occupants in a public transport vehicle.Nombre d'occupants dans le transport en commun |
| 30.8% | gps | text | Source of the geolocation data.Indicateur de provenance |
| — | year_georefYear georef | text | Year of the geographic reference dataset used.Année du référentiel géographique |
| — | reg_codeCode région | text | Code of the administrative region.Code région |
| — | reg_nameNom région | text | Name of the administrative region.Nom de la région |
| — | dep_codeCode département | text | Code of the département.Code département |
| — | dep_nameNom département | text | Name of the département.Nom du département |
| — | epci_codeCode EPCI | text | Code of the inter-municipal body (EPCI).Code EPCI |
| — | epci_nameNom EPCI | text | Name of the inter-municipal body (EPCI).Nom de l'EPCI |
| — | com_nameNom commune | text | Name of the municipality.Nom de la commune |
| — | com_arm_nameNom commune arrondissement | text | Name of the municipality including its district (arrondissement).Nom de la commune avec arrondissement |
| — | com_codeCode commune | text | Code of the municipality.Code commune |
Schema captured from opendatasoft 3 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)
Record 1an: 2022 · pr: (1)
{
"an": "2022",
"pr": "(1)",
"v1": "0",
"v2": null,
"adr": "Quai des Salinières",
"agg": "En agglomération",
"atm": "Normale",
"col": "Deux véhicules - par le côté",
"com": "33063",
"dep": "33",
"gps": null,
"int": "Hors intersection",
"lat": null,
"lum": "Plein jour",
"nbv": "2",
"num": null,
"obs": [
"Sans objet"
],
"pr1": "(1)",
"vma": [
"20"
],
"actp": [
"Non renseigné"
],
"catr": "Voie Communales",
"catu": [
"Conducteur"
],
"catv": [
"Bicyclette",
"EDP à moteur"
],
"choc": [
"Côté gauche",
"Côté droit"
],
"circ": [
"Bidirectionnelle"
],
"env1": "-1",
"grav": [
"Blessé léger"
],
"hrmn": "08:20",
"jour": "11",
"locp": [
"Non renseigné"
],
"long": null,
"manv": [
"Sans changement de direction",
"Dépassant A droite"
],
"mois": "05",
"obsm": [
"Véhicule"
],
"plan": [
"Partie rectiligne"
],
"prof": [
"Plat"
],
"senc": "PK ou PR ou numéro d’adresse postale croissant",
"sexe": [
"Féminin",
"Masculin"
],
"situ": [
"Sur piste cyclable"
],
"surf": [
"Normale"
],
"voie": "QUAI DES SALINIERES",
"vosp": "Piste cyclable",
"etatp": [
"Non renseigné"
],
"infra": [
"Zone piétonne"
],
"insee": "33063",
"place": [
"2"
],
"secu1": [
"Aucun équipement"
],
"secu2": "Non renseigné",
"secu3": "Non renseigné",
"lartpc": null,
"occutc": null,
"trajet": [
"Domicile – travail",
"Non renseigné"
],
"an_nais": [
"1978",
"1982"
],
"larrout": "-1",
"nom_com": "Bordeaux",
"num_acc": "202200045494",
"num_veh": "A01,B01",
"com_code": "33063",
"com_name": "Bordeaux",
"datetime": "2022-05-11T08:20:00+00:00",
"dep_code": "33",
"dep_name": "Gironde",
"reg_code": "75",
"reg_name": "Nouvelle-Aquitaine",
"epci_code": "243300316",
"epci_name": "Bordeaux Métropole",
"code_postal": "33200",
"coordonnees": null,
"year_georef": "2022",
"com_arm_name": "Bordeaux"
}Record 2an: 2016 · pr: —
{
"an": "2016",
"pr": null,
"v1": null,
"v2": null,
"adr": "14-16, CRS E.VAILLANT",
"agg": "En agglomération",
"atm": "Normale",
"col": "Deux véhicules - par le côté",
"com": "063",
"dep": "33",
"gps": "Métropole",
"int": "Hors intersection",
"lat": "44.8595",
"lum": "Plein jour",
"nbv": "04",
"num": "14",
"obs": [
"Sans objet",
"Véhicule en stationnement"
],
"pr1": null,
"vma": [
"Non renseigné"
],
"actp": [
"Non renseigné ou sans objet"
],
"catr": "Voie Communales",
"catu": [
"Conducteur"
],
"catv": [
"VL seul"
],
"choc": [
"Avant"
],
"circ": [
"Bidirectionnelle"
],
"env1": "00",
"grav": [
"Blessé léger",
"Indemne"
],
"hrmn": "18:30",
"jour": "02",
"locp": [
"Sans objet"
],
"long": "-0.55722",
"manv": [
"En faisant demi-tour sur la chaussée",
"Sans changement de direction"
],
"mois": "09",
"obsm": [
"Véhicule"
],
"plan": [
"Partie rectiligne"
],
"prof": [
"Plat"
],
"senc": "PK ou PR ou numéro d’adresse postale décroissant,PK ou PR ou numéro d’adresse postale croissant",
"sexe": [
"Masculin"
],
"situ": [
"Sur chaussée"
],
"surf": [
"Normale"
],
"voie": null,
"vosp": "Sans objet",
"etatp": [
"Non renseigné"
],
"infra": [
"Aucun"
],
"insee": "33063",
"place": [
"1"
],
"secu1": [
"Ceinture"
],
"secu2": "Non renseigné",
"secu3": "Non renseigné",
"lartpc": "000",
"occutc": null,
"trajet": [
"Non renseigné"
],
"an_nais": [
"1974",
"1957"
],
"larrout": "000",
"nom_com": "Bordeaux",
"num_acc": "201600024127",
"num_veh": "A01,B01",
"com_code": "33063",
"com_name": "Bordeaux",
"datetime": "2016-09-02T18:30:00+00:00",
"dep_code": "33",
"dep_name": "Gironde",
"reg_code": "75",
"reg_name": "Aquitaine-Limousin-Poitou-Charentes",
"epci_code": "243300316",
"epci_name": "Bordeaux Métropole",
"code_postal": "33200",
"coordonnees": {
"lat": 44.8595,
"lon": -0.55722
},
"year_georef": "2016",
"com_arm_name": "Bordeaux"
}Record 3an: 2012 · pr: —
{
"an": "2012",
"pr": null,
"v1": null,
"v2": null,
"adr": "CHEM DES ORPHELINS",
"agg": "En agglomération",
"atm": "Normale",
"col": "Autre collision",
"com": "550",
"dep": "33",
"gps": null,
"int": "Intersection en X",
"lat": null,
"lum": "Plein jour",
"nbv": "04",
"num": null,
"obs": [
"Sans objet"
],
"pr1": null,
"vma": [
"Non renseigné"
],
"actp": [
"Non renseigné ou sans objet"
],
"catr": "Voie Communales",
"catu": [
"Conducteur"
],
"catv": [
"VL seul",
"Scooter < 50 cm3"
],
"choc": [
"Avant gauche"
],
"circ": [
"A chaussées séparées"
],
"env1": "00",
"grav": [
"Indemne",
"Blessé léger"
],
"hrmn": "14:25",
"jour": "13",
"locp": [
"Sans objet"
],
"long": null,
"manv": [
"Tournant A gauche",
"Sans changement de direction"
],
"mois": "03",
"obsm": [
"Véhicule"
],
"plan": [
"Partie rectiligne"
],
"prof": [
"Plat"
],
"senc": "Inconnu",
"sexe": [
"Masculin"
],
"situ": [
"Sur chaussée"
],
"surf": [
"Normale"
],
"voie": "0",
"vosp": "Sans objet",
"etatp": [
"Non renseigné"
],
"infra": [
"Carrefour aménagé"
],
"insee": "33550",
"place": [
"1"
],
"secu1": [
"Ceinture",
"Casque"
],
"secu2": "Non renseigné",
"secu3": "Non renseigné",
"lartpc": "000",
"occutc": null,
"trajet": [
"Non renseigné"
],
"an_nais": [
"1984",
"1977"
],
"larrout": "164",
"nom_com": "Villenave D Ornon",
"num_acc": "201200024921",
"num_veh": "A01,B01",
"com_code": "33550",
"com_name": "Villenave-d'Ornon",
"datetime": "2012-03-13T14:25:00+00:00",
"dep_code": "33",
"dep_name": "Gironde",
"reg_code": "72",
"reg_name": "Aquitaine",
"epci_code": "243300316",
"epci_name": "Bordeaux Métropole",
"code_postal": "33140",
"coordonnees": {
"lat": 44.796147,
"lon": -0.574936
},
"year_georef": "2015",
"com_arm_name": "Villenave-d'Ornon"
}Record 4an: 2016 · pr: —
{
"an": "2016",
"pr": null,
"v1": null,
"v2": null,
"adr": "V.HUGO/MARTYRSRESISTANCE",
"agg": "En agglomération",
"atm": "Normale",
"col": "Deux véhicules - par le côté",
"com": "039",
"dep": "33",
"gps": "Métropole",
"int": "Giratoire",
"lat": "44.8076",
"lum": "Plein jour",
"nbv": "02",
"num": null,
"obs": [
"Sans objet"
],
"pr1": null,
"vma": [
"Non renseigné"
],
"actp": [
"Non renseigné ou sans objet"
],
"catr": "Voie Communales",
"catu": [
"Conducteur",
"Passager"
],
"catv": [
"VL seul",
"Scooter < 50 cm3"
],
"choc": [
"Avant",
"Côté droit"
],
"circ": [
"Bidirectionnelle"
],
"env1": "00",
"grav": [
"Indemne",
"Blessé léger",
"Blessé hospitalisé"
],
"hrmn": "07:45",
"jour": "03",
"locp": [
"Sans objet"
],
"long": "-0.56049",
"manv": [
"En s’insérant",
"Sans changement de direction"
],
"mois": "10",
"obsm": [
"Véhicule",
"Aucun"
],
"plan": [
"Partie rectiligne"
],
"prof": [
"Plat"
],
"senc": "PK ou PR ou numéro d’adresse postale décroissant,Inconnu",
"sexe": [
"Féminin",
"Masculin"
],
"situ": [
"Sur chaussée"
],
"surf": [
"Normale"
],
"voie": null,
"vosp": "Sans objet",
"etatp": [
"Non renseigné"
],
"infra": [
"Aucun"
],
"insee": "33039",
"place": [
"1",
"2"
],
"secu1": [
"Ceinture",
"Casque"
],
"secu2": "Non renseigné",
"secu3": "Non renseigné",
"lartpc": "000",
"occutc": null,
"trajet": [
"Utilisation professionnelle",
"Domicile – travail"
],
"an_nais": [
"1961",
"1995",
"1972"
],
"larrout": "070",
"nom_com": "Begles",
"num_acc": "201600024226",
"num_veh": "A01,B01",
"com_code": "33039",
"com_name": "Bègles",
"datetime": "2016-10-03T07:45:00+00:00",
"dep_code": "33",
"dep_name": "Gironde",
"reg_code": "75",
"reg_name": "Aquitaine-Limousin-Poitou-Charentes",
"epci_code": "243300316",
"epci_name": "Bordeaux Métropole",
"code_postal": "33130",
"coordonnees": {
"lat": 44.8076,
"lon": -0.56049
},
"year_georef": "2016",
"com_arm_name": "Bègles"
}Record 5an: 2012 · pr: —
{
"an": "2012",
"pr": null,
"v1": null,
"v2": null,
"adr": "95, RUE CROIX DE SEGUEY",
"agg": "En agglomération",
"atm": "Normale",
"col": "Autre collision",
"com": "063",
"dep": "33",
"gps": null,
"int": "Intersection en T",
"lat": null,
"lum": "Nuit avec éclairage public allumé",
"nbv": "03",
"num": "95",
"obs": [
"Sans objet"
],
"pr1": null,
"vma": [
"Non renseigné"
],
"actp": [
"Non renseigné ou sans objet",
"Traversant"
],
"catr": "Voie Communales",
"catu": [
"Conducteur",
"Piéton"
],
"catv": [
"VL seul"
],
"choc": [
"Avant"
],
"circ": [
"Non renseigné"
],
"env1": "00",
"grav": [
"Indemne",
"Blessé léger"
],
"hrmn": "19:22",
"jour": "02",
"locp": [
"Sans objet",
"Sur passage piéton avec signalisation lumineuse"
],
"long": null,
"manv": [
"Sans changement de direction"
],
"mois": "02",
"obsm": [
"Piéton"
],
"plan": [
"Non renseigné"
],
"prof": [
"Non renseigné"
],
"senc": "Inconnu",
"sexe": [
"Masculin"
],
"situ": [
"Aucun"
],
"surf": [
"Non renseigné"
],
"voie": "0",
"vosp": "Sans objet",
"etatp": [
"Non renseigné",
"Accompagné"
],
"infra": [
"Aucun"
],
"insee": "33063",
"place": [
"1"
],
"secu1": [
"Ceinture",
"Autre"
],
"secu2": "Non renseigné",
"secu3": "Non renseigné",
"lartpc": "000",
"occutc": null,
"trajet": [
"Promenade – loisirs",
"Non renseigné"
],
"an_nais": [
"1921",
"2003"
],
"larrout": "000",
"nom_com": "Bordeaux",
"num_acc": "201200024815",
"num_veh": "A01",
"com_code": "33063",
"com_name": "Bordeaux",
"datetime": "2012-02-02T19:22:00+00:00",
"dep_code": "33",
"dep_name": "Gironde",
"reg_code": "72",
"reg_name": "Aquitaine",
"epci_code": "243300316",
"epci_name": "Bordeaux Métropole",
"code_postal": "33200",
"coordonnees": {
"lat": 44.843535,
"lon": -0.625113
},
"year_georef": "2015",
"com_arm_name": "Bordeaux"
}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-2012-2019
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-2012-2019/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
Dataset
Volume & freshness
License
No license declared upstream.
Source: opendatasoft
Machine-readable & source
Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.