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
17060000041407L17/dossiers17170600000413531706000004135353PA8419812025-09-17False
17060000041408L17/dossiers17170600000413531706000004135354PA8422272025-09-17False
17060000041409L17/dossiers17170600000413531706000004135355PA8422552025-09-17False
17060000041410L17/dossiers17170600000413531706000004135356PA7933822025-09-17False
17060000041411L17/dossiers17170600000413531706000004135357PA7945022025-09-17False
17060000041412L17/dossiers17170600000413531706000004135358PA8415532025-09-17False
17060000041416L17/dossiers1717060000041414170600000414141PA8408172025-08-27False
17060000041417L17/dossiers1717060000041414170600000414142PA7945542025-08-27False
17060000041418L17/dossiers1717060000041414170600000414143PA7223902025-08-27False
17060000041419L17/dossiers1717060000041414170600000414144PA7940422025-08-27False
17060000041420L17/dossiers1717060000041414170600000414145PA7946582025-08-27False
17060000041421L17/dossiers1717060000041414170600000414146PA6056942025-08-27False
17060000041422L17/dossiers1717060000041414170600000414147PA8402352025-08-27False
17060000041423L17/dossiers1717060000041414170600000414148PA7944702025-08-27False
17060000041424L17/dossiers1717060000041414170600000414149PA7200382025-08-27False
17060000041425L17/dossiers17170600000414141706000004141410PA7194122025-08-27False
17060000041426L17/dossiers17170600000414141706000004141411PA7120142025-08-27False
17060000041427L17/dossiers17170600000414141706000004141412PA7193382025-08-27False
17060000041428L17/dossiers17170600000414141706000004141413PA7944662025-08-27False
17060000041429L17/dossiers17170600000414141706000004141414PA8413592025-08-27False
17060000041430L17/dossiers17170600000414141706000004141415PA7218442025-08-27False
17060000041431L17/dossiers17170600000414141706000004141416PA7930942025-08-27False
17060000041432L17/dossiers17170600000414141706000004141417PA7214742025-08-27False
17060000041433L17/dossiers17170600000414141706000004141418PA7209922025-08-27False
17060000041437L17/dossiers1717060000041435170600000414351PA7953622025-07-11False
17060000041438L17/dossiers1717060000041435170600000414352PA7940082025-07-11False
17060000041439L17/dossiers1717060000041435170600000414353PA7950102025-07-11False
17060000041440L17/dossiers1717060000041435170600000414354PA6100022025-07-11False
17060000041441L17/dossiers1717060000041435170600000414355PA8417012025-07-11False
17060000041442L17/dossiers1717060000041435170600000414356PA7941542025-07-11False
17060000041443L17/dossiers1717060000041435170600000414357PA8415072025-07-11False
17060000041444L17/dossiers1717060000041435170600000414358PA7939482025-07-11False
17060000041445L17/dossiers1717060000041435170600000414359PA8420452025-07-11False
17060000041446L17/dossiers17170600000414351706000004143510PA7937802025-07-11False
17060000041447L17/dossiers17170600000414351706000004143511PA8413512025-07-11False
17060000041448L17/dossiers17170600000414351706000004143512PA8417132025-07-11False
17060000041449L17/dossiers17170600000414351706000004143513PA7940222025-07-11False
17060000041450L17/dossiers17170600000414351706000004143514PA8414192025-07-11False
17060000041451L17/dossiers17170600000414351706000004143515PA7947782025-07-11False
17060000041452L17/dossiers17170600000414351706000004143516PA7950762025-07-11False
17060000041453L17/dossiers17170600000414351706000004143517PA8420132025-07-11False
17060000041454L17/dossiers17170600000414351706000004143518PA8418852025-07-11False
17060000041455L17/dossiers17170600000414351706000004143519PA8409472025-07-11False
17060000041456L17/dossiers17170600000414351706000004143520PA29402025-07-11False
17060000041457L17/dossiers17170600000414351706000004143521PA7958082025-07-11False
17060000041458L17/dossiers17170600000414351706000004143522PA8412232025-07-11False
17060000041459L17/dossiers17170600000414351706000004143523PA7362012025-07-11False
17060000041460L17/dossiers17170600000414351706000004143524PA8409972025-07-11False
17060000041461L17/dossiers17170600000414351706000004143525PA6065452025-07-11False
17060000041462L17/dossiers17170600000414351706000004143526PA7956362025-07-11False