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
17060000025136L17/dossiers17170600000250561706000002505679PA8406572025-05-21False
17060000025137L17/dossiers17170600000250561706000002505680PA8419812025-05-21False
17060000025138L17/dossiers17170600000250561706000002505681PA8422272025-05-21False
17060000025139L17/dossiers17170600000250561706000002505682PA7944422025-05-21False
17060000025140L17/dossiers17170600000250561706000002505683PA8420972025-05-21False
17060000025141L17/dossiers17170600000250561706000002505684PA7949542025-05-21False
17060000025142L17/dossiers17170600000250561706000002505685PA8422552025-05-21False
17060000025143L17/dossiers17170600000250561706000002505686PA7933822025-05-21False
17060000025144L17/dossiers17170600000250561706000002505687PA8415532025-05-21False
17060000025145L17/dossiers17170600000250561706000002505688PA8407812025-05-21False
17060000025146L17/dossiers17170600000250561706000002505689PA8415752025-05-21False
17060000025147L17/dossiers17170600000250561706000002505690PA8414792025-05-21False
17060000025151L17/dossiers1717060000025149170600000251491PA8407732025-03-07False
17060000025152L17/dossiers1717060000025149170600000251492PA7947702025-03-07False
17060000025153L17/dossiers1717060000025149170600000251493PA7959742025-03-07False
17060000025154L17/dossiers1717060000025149170600000251494PA7931822025-03-07False
17060000025155L17/dossiers1717060000025149170600000251495PA7933542025-03-07False
17060000025156L17/dossiers1717060000025149170600000251496PA7936162025-03-07False
17060000025157L17/dossiers1717060000025149170600000251497PA7956442025-03-07False
17060000025158L17/dossiers1717060000025149170600000251498PA7945622025-03-07False
17060000025159L17/dossiers1717060000025149170600000251499PA7959002025-03-07False
17060000025160L17/dossiers17170600000251491706000002514910PA7949542025-03-07False
17060000025161L17/dossiers17170600000251491706000002514911PA6429882025-03-07False
17060000025162L17/dossiers17170600000251491706000002514912PA8419812025-03-07False
17060000025163L17/dossiers17170600000251491706000002514913PA8409672025-03-07False
17060000025164L17/dossiers17170600000251491706000002514914PA7931662025-03-07False
17060000025165L17/dossiers17170600000251491706000002514915PA7946782025-03-07False
17060000025166L17/dossiers17170600000251491706000002514916PA7941982025-03-07False
17060000025167L17/dossiers17170600000251491706000002514917PA8410752025-03-07False
17060000025168L17/dossiers17170600000251491706000002514918PA7933302025-03-07False
17060000025169L17/dossiers17170600000251491706000002514919PA8408372025-03-07False
17060000025170L17/dossiers17170600000251491706000002514920PA8412072025-03-07False
17060000025171L17/dossiers17170600000251491706000002514921PA7948862025-03-07False
17060000025172L17/dossiers17170600000251491706000002514922PA7944422025-03-07False
17060000025173L17/dossiers17170600000251491706000002514923PA8414792025-03-07False
17060000025174L17/dossiers17170600000251491706000002514924PA7931582025-03-07False
17060000025175L17/dossiers17170600000251491706000002514925PA7960262025-03-07False
17060000025176L17/dossiers17170600000251491706000002514926PA7957862025-03-07False
17060000025177L17/dossiers17170600000251491706000002514927PA7194362025-03-07False
17060000025178L17/dossiers17170600000251491706000002514928PA8407012025-03-07False
17060000025179L17/dossiers17170600000251491706000002514929PA7932902025-03-07False
17060000025180L17/dossiers17170600000251491706000002514930PA8410672025-03-07False
17060000025181L17/dossiers17170600000251491706000002514931PA8420732025-03-07False
17060000025182L17/dossiers17170600000251491706000002514932PA7943542025-03-07False
17060000025183L17/dossiers17170600000251491706000002514933PA7935482025-03-07False
17060000025184L17/dossiers17170600000251491706000002514934PA7935922025-03-07False
17060000025185L17/dossiers17170600000251491706000002514935PA8414512025-03-07False
17060000025186L17/dossiers17170600000251491706000002514936PA8416052025-03-07False
17060000025187L17/dossiers17170600000251491706000002514937PA8418252025-03-07False
17060000025188L17/dossiers17170600000251491706000002514938PA7938322025-03-07False