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
17060000048037L17/dossiers17170600000480241706000004802412PA8418932026-01-19False
17060000048038L17/dossiers17170600000480241706000004802413PA7952402026-01-19False
17060000048039L17/dossiers17170600000480241706000004802414PA7954022026-01-19False
17060000048040L17/dossiers17170600000480241706000004802415PA6056942026-01-19False
17060000048044L17/dossiers1717060000048042170600000480421PA7211582025-11-18False
17060000048045L17/dossiers1717060000048042170600000480422PA6429352025-11-18False
17060000048046L17/dossiers1717060000048042170600000480423PA6426952025-11-18False
17060000048047L17/dossiers1717060000048042170600000480424PA7943302025-11-18False
17060000048048L17/dossiers1717060000048042170600000480425PA7198902025-11-18False
17060000048049L17/dossiers1717060000048042170600000480426PA7220002025-11-18False
17060000048050L17/dossiers1717060000048042170600000480427PA7194722025-11-18False
17060000048051L17/dossiers1717060000048042170600000480428PA7191182025-11-18False
17060000048052L17/dossiers1717060000048042170600000480429PA7223902025-11-18False
17060000048053L17/dossiers17170600000480421706000004804210PA7949822025-11-18False
17060000048054L17/dossiers17170600000480421706000004804211PA7201542025-11-18False
17060000048055L17/dossiers17170600000480421706000004804212PA8402352025-11-18False
17060000048056L17/dossiers17170600000480421706000004804213PA7223662025-11-18False
17060000048057L17/dossiers17170600000480421706000004804214PA7197362025-11-18False
17060000048058L17/dossiers17170600000480421706000004804215PA7212962025-11-18False
17060000048059L17/dossiers17170600000480421706000004804216PA7217642025-11-18False
17060000048060L17/dossiers17170600000480421706000004804217PA2673182025-11-18False
17060000048061L17/dossiers17170600000480421706000004804218PA6084162025-11-18False
17060000048062L17/dossiers17170600000480421706000004804219PA2672002025-11-18False
17060000048063L17/dossiers17170600000480421706000004804220PA7203542025-11-18False
17060000048064L17/dossiers17170600000480421706000004804221PA6431842025-11-18False
17060000048065L17/dossiers17170600000480421706000004804222PA8421252025-11-18False
17060000048066L17/dossiers17170600000480421706000004804223PA7200222025-11-18False
17060000048067L17/dossiers17170600000480421706000004804224PA7194122025-11-18False
17060000048068L17/dossiers17170600000480421706000004804225PA3457222025-11-18False
17060000048069L17/dossiers17170600000480421706000004804226PA7197562025-11-18False
17060000048070L17/dossiers17170600000480421706000004804227PA7120142025-11-18False
17060000048071L17/dossiers17170600000480421706000004804228PA8416012025-11-18False
17060000048072L17/dossiers17170600000480421706000004804229PA7947022025-11-18False
17060000048073L17/dossiers17170600000480421706000004804230PA7204462025-11-18False
17060000048074L17/dossiers17170600000480421706000004804231PA7203702025-11-18False
17060000048075L17/dossiers17170600000480421706000004804232PA7956642025-11-18False
17060000048076L17/dossiers17170600000480421706000004804233PA8172032025-11-18False
17060000048077L17/dossiers17170600000480421706000004804234PA7959622025-11-18False
17060000048078L17/dossiers17170600000480421706000004804235PA7212342025-11-18False
17060000048079L17/dossiers17170600000480421706000004804236PA7219162025-11-18False
17060000048080L17/dossiers17170600000480421706000004804237PA3357582025-11-18False
17060000048081L17/dossiers17170600000480421706000004804238PA7214262025-11-18False
17060000048082L17/dossiers17170600000480421706000004804239PA7200662025-11-18False
17060000048083L17/dossiers17170600000480421706000004804240PA7955282025-11-18False
17060000048084L17/dossiers17170600000480421706000004804241PA8419272025-11-18False
17060000048085L17/dossiers17170600000480421706000004804242PA7958882025-11-18False
17060000048086L17/dossiers17170600000480421706000004804243PA7932702025-11-18False
17060000048087L17/dossiers17170600000480421706000004804244PA7934162025-11-18False
17060000048088L17/dossiers17170600000480421706000004804245PA7201902025-11-18False
17060000048089L17/dossiers17170600000480421706000004804246PA7944862025-11-18False