AN · données ouvertes
Explorateur / dossiers

dossiers.document_co_signataire

Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %

305 264 lignes (estimation)

Colonnes

#ColonneTypeCommentaire
1_idBIGINTidentifiant : code de la source × 10¹⁰ + rang
2_sourceVARCHARsource du catalogue (catalogue.py)
3_legislatureBIGINTcolonne constante de la source
4_racine_idBIGINT_id de la ligne racine
5_parent_idBIGINT_id de la ligne parente
6_ordreBIGINTrang dans le tableau d'origine (1…)
7acteur_acteur_refVARCHARdocument.coSignataires.coSignataire.acteur.acteurRef · présence : L17 25 %, L16 26 %, L15 28 %, L14 29 %
8date_cosignatureDATEdocument.coSignataires.coSignataire.dateCosignature · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
9date_retrait_cosignatureDATEdocument.coSignataires.coSignataire.dateRetraitCosignature · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
10editeBOOLEANdocument.coSignataires.coSignataire.edite · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
11organe_organe_refVARCHARdocument.coSignataires.coSignataire.organe.organeRef · présence : L17 0 %, L16 1 %, L15 1 %, L14 2 %
12organe_et_apparentesBOOLEANdocument.coSignataires.coSignataire.organe.etApparentes · présence : L17 0 %, L16 1 %, L15 1 %, L14 2 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordreacteur_acteur_refdate_cosignaturedate_retrait_cosignatureediteorgane_organe_reforgane_et_apparentes
17060000040137L17/dossiers17170600000401151706000004011521PA8421872025-06-24False
17060000040138L17/dossiers17170600000401151706000004011522PA8420372025-06-24False
17060000040139L17/dossiers17170600000401151706000004011523PA7918122025-06-24False
17060000040140L17/dossiers17170600000401151706000004011524PA7937362025-06-24False
17060000040141L17/dossiers17170600000401151706000004011525PA7212022025-06-24False
17060000040142L17/dossiers17170600000401151706000004011526PA7951362025-06-24False
17060000040143L17/dossiers17170600000401151706000004011527PA7934642025-06-24False
17060000040144L17/dossiers17170600000401151706000004011528PA8421552025-06-24False
17060000040145L17/dossiers17170600000401151706000004011529PA7952002025-06-24False
17060000040146L17/dossiers17170600000401151706000004011530PA7958442025-06-24False
17060000040147L17/dossiers17170600000401151706000004011531PA8412512025-06-24False
17060000040148L17/dossiers17170600000401151706000004011532PA7947862025-06-24False
17060000040149L17/dossiers17170600000401151706000004011533PA7948702025-06-24False
17060000040150L17/dossiers17170600000401151706000004011534PA7960702025-06-24False
17060000040151L17/dossiers17170600000401151706000004011535PA7944782025-06-24False
17060000040152L17/dossiers17170600000401151706000004011536PA8419472025-06-24False
17060000040153L17/dossiers17170600000401151706000004011537PA7941302025-06-24False
17060000040154L17/dossiers17170600000401151706000004011538PA7208462025-06-24False
17060000040155L17/dossiers17170600000401151706000004011539PA8417292025-06-24False
17060000040156L17/dossiers17170600000401151706000004011540PA7955162025-06-24False
17060000040157L17/dossiers17170600000401151706000004011541PA7956722025-06-24False
17060000040158L17/dossiers17170600000401151706000004011542PA7957462025-06-24False
17060000040159L17/dossiers17170600000401151706000004011543PA7951082025-06-24False
17060000040160L17/dossiers17170600000401151706000004011544PA8415152025-06-24False
17060000040161L17/dossiers17170600000401151706000004011545PA7952982025-06-24False
17060000040162L17/dossiers17170600000401151706000004011546PA7918242025-06-24False
17060000040163L17/dossiers17170600000401151706000004011547PA8420292025-06-24False
17060000040164L17/dossiers17170600000401151706000004011548PA7935322025-06-24False
17060000040165L17/dossiers17170600000401151706000004011549PA3423842025-06-24False
17060000040166L17/dossiers17170600000401151706000004011550PA7954222025-06-24False
17060000040167L17/dossiers17170600000401151706000004011551PA8412152025-06-24False
17060000040168L17/dossiers17170600000401151706000004011552PA7954822025-06-24False
17060000040169L17/dossiers17170600000401151706000004011553PA6106542025-06-24False
17060000040170L17/dossiers17170600000401151706000004011554PA8411912025-06-24False
17060000040171L17/dossiers17170600000401151706000004011555PA7219602025-06-24False
17060000040172L17/dossiers17170600000401151706000004011556PA7938722025-06-24False
17060000040173L17/dossiers17170600000401151706000004011557PA7208922025-06-24False
17060000040174L17/dossiers17170600000401151706000004011558PA8172112025-06-24False
17060000040175L17/dossiers17170600000401151706000004011559PA7937562025-06-24False
17060000040176L17/dossiers17170600000401151706000004011560PA7960622025-06-24False
17060000040177L17/dossiers17170600000401151706000004011561PA7195782025-06-24False
17060000040178L17/dossiers17170600000401151706000004011562PA7210622025-06-24False
17060000040179L17/dossiers17170600000401151706000004011563PA8418452025-06-24False
17060000040180L17/dossiers17170600000401151706000004011564PA7959822025-06-24False
17060000040181L17/dossiers17170600000401151706000004011565PA7954662025-06-24False
17060000040182L17/dossiers17170600000401151706000004011566PA7937442025-06-24False
17060000040183L17/dossiers17170600000401151706000004011567PA7209522025-06-24False
17060000040184L17/dossiers17170600000401151706000004011568PA7941062025-06-24False
17060000040185L17/dossiers17170600000401151706000004011569PA7951642025-06-24False
17060000040186L17/dossiers17170600000401151706000004011570PA7955962025-06-24False