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
17060000021872L17/dossiers1717060000021866170600000218665PA7950842025-03-03False
17060000021873L17/dossiers1717060000021866170600000218666PA7955882024-12-192025-01-28False
17060000021874L17/dossiers1717060000021866170600000218667PA8421052025-03-03False
17060000021875L17/dossiers1717060000021866170600000218668PA8416572025-03-03False
17060000021876L17/dossiers1717060000021866170600000218669PA7956162025-03-03False
17060000021877L17/dossiers17170600000218661706000002186610PA7204302024-12-192025-01-28False
17060000021878L17/dossiers17170600000218661706000002186611PA7934442025-03-03False
17060000021879L17/dossiers17170600000218661706000002186612PA7937722024-12-192025-01-28False
17060000021880L17/dossiers17170600000218661706000002186613PA7949382025-03-03False
17060000021881L17/dossiers17170600000218661706000002186614PA7953182025-03-03False
17060000021882L17/dossiers17170600000218661706000002186615PA8410232025-03-03False
17060000021883L17/dossiers17170600000218661706000002186616PA7960902025-03-03False
17060000021884L17/dossiers17170600000218661706000002186617PA8421872025-03-03False
17060000021885L17/dossiers17170600000218661706000002186618PA7937362025-03-03False
17060000021886L17/dossiers17170600000218661706000002186619PA7951362025-03-03False
17060000021887L17/dossiers17170600000218661706000002186620PA7934642025-03-03False
17060000021888L17/dossiers17170600000218661706000002186621PA7939122024-12-192025-01-28False
17060000021889L17/dossiers17170600000218661706000002186622PA8421552025-03-03False
17060000021890L17/dossiers17170600000218661706000002186623PA7952002025-03-03False
17060000021891L17/dossiers17170600000218661706000002186624PA8420372024-12-192025-01-28False
17060000021892L17/dossiers17170600000218661706000002186625PA8412512025-03-03False
17060000021893L17/dossiers17170600000218661706000002186626PA7212022024-12-192025-01-28False
17060000021894L17/dossiers17170600000218661706000002186627PA7947862025-03-03False
17060000021895L17/dossiers17170600000218661706000002186628PA7948702025-03-03False
17060000021896L17/dossiers17170600000218661706000002186629PA7960702025-03-03False
17060000021897L17/dossiers17170600000218661706000002186630PA7953102025-03-03False
17060000021898L17/dossiers17170600000218661706000002186631PA8419472025-03-03False
17060000021899L17/dossiers17170600000218661706000002186632PA7940822025-03-03False
17060000021900L17/dossiers17170600000218661706000002186633PA7958442024-12-192025-01-28False
17060000021901L17/dossiers17170600000218661706000002186634PA7941302025-03-03False
17060000021902L17/dossiers17170600000218661706000002186635PA7208462025-03-03False
17060000021903L17/dossiers17170600000218661706000002186636PA8417292025-03-03False
17060000021904L17/dossiers17170600000218661706000002186637PA7955162025-03-03False
17060000021905L17/dossiers17170600000218661706000002186638PA7956722025-03-03False
17060000021906L17/dossiers17170600000218661706000002186639PA7944782024-12-192025-01-28False
17060000021907L17/dossiers17170600000218661706000002186640PA7951082025-03-03False
17060000021908L17/dossiers17170600000218661706000002186641PA8415152025-03-03False
17060000021909L17/dossiers17170600000218661706000002186642PA7952982025-03-03False
17060000021910L17/dossiers17170600000218661706000002186643PA7918242025-03-03False
17060000021911L17/dossiers17170600000218661706000002186644PA7935322025-03-03False
17060000021912L17/dossiers17170600000218661706000002186645PA7954222025-03-03False
17060000021913L17/dossiers17170600000218661706000002186646PA7946862025-03-03False
17060000021914L17/dossiers17170600000218661706000002186647PA8412152025-03-03False
17060000021915L17/dossiers17170600000218661706000002186648PA6106542025-03-03False
17060000021916L17/dossiers17170600000218661706000002186649PA7957462024-12-192025-01-28False
17060000021917L17/dossiers17170600000218661706000002186650PA8411912025-03-03False
17060000021918L17/dossiers17170600000218661706000002186651PA7938722025-03-03False
17060000021919L17/dossiers17170600000218661706000002186652PA8172112025-03-03False
17060000021920L17/dossiers17170600000218661706000002186653PA7937562025-03-03False
17060000021921L17/dossiers17170600000218661706000002186654PA7195782025-03-03False