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
17060000013548L17/dossiers17170600000134781706000001347869PA7209522024-10-31False
17060000013549L17/dossiers17170600000134781706000001347870PA7941062024-10-31False
17060000013550L17/dossiers17170600000134781706000001347871PA7955962024-10-31False
17060000013554L17/dossiers1717060000013552170600000135521PA6428472025-03-05False
17060000013555L17/dossiers1717060000013552170600000135522PA2667932025-03-05False
17060000013556L17/dossiers1717060000013552170600000135523PA7935082025-03-05False
17060000013557L17/dossiers1717060000013552170600000135524PA3325232024-10-162025-02-17False
17060000013558L17/dossiers1717060000013552170600000135525PA7203862025-03-05False
17060000013559L17/dossiers1717060000013552170600000135526PA6080162025-03-05False
17060000013560L17/dossiers1717060000013552170600000135527PA7206442025-03-05False
17060000013561L17/dossiers1717060000013552170600000135528PA7218162025-03-05False
17060000013562L17/dossiers1717060000013552170600000135529PA7223902025-03-05False
17060000013563L17/dossiers17170600000135521706000001355210PA6088262025-03-05False
17060000013564L17/dossiers17170600000135521706000001355211PA13272025-03-05False
17060000013568L17/dossiers1717060000013566170600000135661PA7951362024-10-31False
17060000013569L17/dossiers1717060000013566170600000135662PA7208922024-10-31False
17060000013570L17/dossiers1717060000013566170600000135663PA7952282024-10-31False
17060000013571L17/dossiers1717060000013566170600000135664PA7937362024-10-31False
17060000013572L17/dossiers1717060000013566170600000135665PA7212022024-10-31False
17060000013573L17/dossiers1717060000013566170600000135666PA7934642024-10-31False
17060000013574L17/dossiers1717060000013566170600000135667PA8421552024-10-31False
17060000013575L17/dossiers1717060000013566170600000135668PA7952002024-10-31False
17060000013576L17/dossiers1717060000013566170600000135669PA7958442024-10-31False
17060000013577L17/dossiers17170600000135661706000001356610PA8412512024-10-31False
17060000013578L17/dossiers17170600000135661706000001356611PA7947862024-10-31False
17060000013579L17/dossiers17170600000135661706000001356612PA7948702024-10-31False
17060000013580L17/dossiers17170600000135661706000001356613PA7960702024-10-31False
17060000013581L17/dossiers17170600000135661706000001356614PA7953102024-10-31False
17060000013582L17/dossiers17170600000135661706000001356615PA7944782024-10-31False
17060000013583L17/dossiers17170600000135661706000001356616PA8419472024-10-31False
17060000013584L17/dossiers17170600000135661706000001356617PA7940822024-10-31False
17060000013585L17/dossiers17170600000135661706000001356618PA7941302024-10-31False
17060000013586L17/dossiers17170600000135661706000001356619PA7208462024-10-31False
17060000013587L17/dossiers17170600000135661706000001356620PA8417292024-10-31False
17060000013588L17/dossiers17170600000135661706000001356621PA7955162024-10-31False
17060000013589L17/dossiers17170600000135661706000001356622PA7956722024-10-31False
17060000013590L17/dossiers17170600000135661706000001356623PA7957462024-10-31False
17060000013591L17/dossiers17170600000135661706000001356624PA7951082024-10-31False
17060000013592L17/dossiers17170600000135661706000001356625PA8415152024-10-31False
17060000013593L17/dossiers17170600000135661706000001356626PA7952982024-10-31False
17060000013594L17/dossiers17170600000135661706000001356627PA7918242024-10-31False
17060000013595L17/dossiers17170600000135661706000001356628PA7935322024-10-31False
17060000013596L17/dossiers17170600000135661706000001356629PA3423842024-10-31False
17060000013597L17/dossiers17170600000135661706000001356630PA7954222024-10-31False
17060000013598L17/dossiers17170600000135661706000001356631PA7946862024-10-31False
17060000013599L17/dossiers17170600000135661706000001356632PA8412152024-10-31False
17060000013600L17/dossiers17170600000135661706000001356633PA7954822024-10-31False
17060000013601L17/dossiers17170600000135661706000001356634PA6106542024-10-31False
17060000013602L17/dossiers17170600000135661706000001356635PA8411912024-10-31False
17060000013603L17/dossiers17170600000135661706000001356636PA7219602024-10-31False