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 151 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
17060000015394L17/dossiers1717060000015391170600000153912PA16302025-02-17False
17060000015395L17/dossiers1717060000015391170600000153913PA7930942025-02-17False
17060000015396L17/dossiers1717060000015391170600000153914PA7953862025-02-17False
17060000015397L17/dossiers1717060000015391170600000153915PA7957222025-02-17False
17060000015398L17/dossiers1717060000015391170600000153916PA7955282025-02-17False
17060000015399L17/dossiers1717060000015391170600000153917PA6872142025-02-17False
17060000015400L17/dossiers1717060000015391170600000153918PA7120152025-02-17False
17060000015401L17/dossiers1717060000015391170600000153919PA7212342025-02-17False
17060000015402L17/dossiers17170600000153911706000001539110PA7212962025-02-17False
17060000015403L17/dossiers17170600000153911706000001539111PA6428472025-02-17False
17060000015404L17/dossiers17170600000153911706000001539112PA7941782025-02-17False
17060000015405L17/dossiers17170600000153911706000001539113PA7223902025-02-17False
17060000015406L17/dossiers17170600000153911706000001539114PA8419312025-02-17False
17060000015407L17/dossiers17170600000153911706000001539115PA3325232024-11-152025-02-17False
17060000015408L17/dossiers17170600000153911706000001539116PA6088262025-02-17False
17060000015409L17/dossiers17170600000153911706000001539117PA2667972025-02-17False
17060000015410L17/dossiers17170600000153911706000001539118PA8408172025-02-17False
17060000015411L17/dossiers17170600000153911706000001539119PA3467822025-02-17False
17060000015412L17/dossiers17170600000153911706000001539120PA7214102025-02-17False
17060000015413L17/dossiers17170600000153911706000001539121PA4085782025-02-17False
17060000015414L17/dossiers17170600000153911706000001539122PA3457222025-02-17False
17060000015415L17/dossiers17170600000153911706000001539123PA7203862025-02-17False
17060000015419L17/dossiers1717060000015417170600000154171PA7949822024-10-30False
17060000015420L17/dossiers1717060000015417170600000154172PA6088262024-10-30False
17060000015421L17/dossiers1717060000015417170600000154173PA2677802024-10-30False
17060000015422L17/dossiers1717060000015417170600000154174PA7212962024-10-30False
17060000015423L17/dossiers1717060000015417170600000154175PA7200382024-10-30False
17060000015424L17/dossiers1717060000015417170600000154176PA7947022024-10-30False
17060000015425L17/dossiers1717060000015417170600000154177PA7214262024-10-30False
17060000015429L17/dossiers1717060000015427170600000154271PA7949822025-05-02False
17060000015430L17/dossiers1717060000015427170600000154272PA2677802025-05-02False
17060000015431L17/dossiers1717060000015427170600000154273PA7212962025-05-02False
17060000015432L17/dossiers1717060000015427170600000154274PA7200382025-05-02False
17060000015433L17/dossiers1717060000015427170600000154275PA7947022025-05-02False
17060000015434L17/dossiers1717060000015427170600000154276PA7214262025-05-02False
17060000015435L17/dossiers1717060000015427170600000154277PA7959502025-05-02False
17060000015436L17/dossiers1717060000015427170600000154278PA7211582025-05-02False
17060000015437L17/dossiers1717060000015427170600000154279PA7951442025-05-02False
17060000015438L17/dossiers17170600000154271706000001542710PA7221902025-05-02False
17060000015439L17/dossiers17170600000154271706000001542711PA6429352025-05-02False
17060000015440L17/dossiers17170600000154271706000001542712PA7192182025-05-02False
17060000015441L17/dossiers17170600000154271706000001542713PA6426952025-05-02False
17060000015442L17/dossiers17170600000154271706000001542714PA6065072025-05-02False
17060000015443L17/dossiers17170600000154271706000001542715PA7959902025-05-02False
17060000015444L17/dossiers17170600000154271706000001542716PA7943302025-05-02False
17060000015445L17/dossiers17170600000154271706000001542717PA7198902025-05-02False
17060000015446L17/dossiers17170600000154271706000001542718PA7220002025-05-02False
17060000015447L17/dossiers17170600000154271706000001542719PA7947982025-05-02False
17060000015448L17/dossiers17170600000154271706000001542720PA7217502025-05-02False
17060000015449L17/dossiers17170600000154271706000001542721PA7953302025-05-02False