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
17060000052783L17/dossiers17170600000527691706000005276913PA7199682025-12-05False
17060000052784L17/dossiers17170600000527691706000005276914PA7214102025-12-05False
17060000052785L17/dossiers17170600000527691706000005276915PA2667932025-12-05False
17060000052786L17/dossiers17170600000527691706000005276916PA7171612025-12-05False
17060000052787L17/dossiers17170600000527691706000005276917PA6426952025-12-05False
17060000052788L17/dossiers17170600000527691706000005276918PA7218162025-12-05False
17060000052789L17/dossiers17170600000527691706000005276919PA6065072025-12-05False
17060000052790L17/dossiers17170600000527691706000005276920PA7935082025-12-05False
17060000052791L17/dossiers17170600000527691706000005276921PA7943302025-12-05False
17060000052792L17/dossiers17170600000527691706000005276922PA7198902025-12-05False
17060000052793L17/dossiers17170600000527691706000005276923PA8408172025-12-05False
17060000052794L17/dossiers17170600000527691706000005276924PA7188382025-12-05False
17060000052795L17/dossiers17170600000527691706000005276925PA7220002025-12-05False
17060000052796L17/dossiers17170600000527691706000005276926PA7947982025-12-05False
17060000052797L17/dossiers17170600000527691706000005276927PA7217502025-12-032025-12-03False
17060000052798L17/dossiers17170600000527691706000005276928PA8423112025-12-05False
17060000052799L17/dossiers17170600000527691706000005276929PA7199222025-12-05False
17060000052800L17/dossiers17170600000527691706000005276930PA7939402025-12-05False
17060000052801L17/dossiers17170600000527691706000005276931PA7194722025-12-05False
17060000052802L17/dossiers17170600000527691706000005276932PA7958642025-12-05False
17060000052803L17/dossiers17170600000527691706000005276933PA7959082025-12-05False
17060000052804L17/dossiers17170600000527691706000005276934PA7954022025-12-05False
17060000052805L17/dossiers17170600000527691706000005276935PA7191182025-12-05False
17060000052806L17/dossiers17170600000527691706000005276936PA7223902025-12-05False
17060000052807L17/dossiers17170600000527691706000005276937PA3325232025-12-05False
17060000052808L17/dossiers17170600000527691706000005276938PA7931222025-12-05False
17060000052809L17/dossiers17170600000527691706000005276939PA7949822025-12-05False
17060000052810L17/dossiers17170600000527691706000005276940PA3309092025-12-05False
17060000052811L17/dossiers17170600000527691706000005276941PA7203862025-12-05False
17060000052812L17/dossiers17170600000527691706000005276942PA7223822025-12-05False
17060000052813L17/dossiers17170600000527691706000005276943PA7120152025-12-05False
17060000052814L17/dossiers17170600000527691706000005276944PA6088262025-12-05False
17060000052815L17/dossiers17170600000527691706000005276945PA8700092025-12-05False
17060000052816L17/dossiers17170600000527691706000005276946PA7958842025-12-05False
17060000052817L17/dossiers17170600000527691706000005276947PA7221342025-12-05False
17060000052818L17/dossiers17170600000527691706000005276948PA2677802025-12-05False
17060000052819L17/dossiers17170600000527691706000005276949PA8402352025-12-05False
17060000052820L17/dossiers17170600000527691706000005276950PA8411512025-12-05False
17060000052821L17/dossiers17170600000527691706000005276951PA7223662025-12-05False
17060000052822L17/dossiers17170600000527691706000005276952PA7197362025-12-05False
17060000052823L17/dossiers17170600000527691706000005276953PA7223582025-12-05False
17060000052824L17/dossiers17170600000527691706000005276954PA7210242025-12-05False
17060000052825L17/dossiers17170600000527691706000005276955PA7944702025-12-05False
17060000052826L17/dossiers17170600000527691706000005276956PA7186742025-12-05False
17060000052827L17/dossiers17170600000527691706000005276957PA7217642025-12-05False
17060000052828L17/dossiers17170600000527691706000005276958PA7940582025-12-05False
17060000052829L17/dossiers17170600000527691706000005276959PA16302025-12-05False
17060000052830L17/dossiers17170600000527691706000005276960PA6084162025-12-05False
17060000052831L17/dossiers17170600000527691706000005276961PA2672002025-12-05False
17060000052832L17/dossiers17170600000527691706000005276962PA7959542025-12-05False