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
17060000008122L17/dossiers17170600000081101706000000811011PA6075532024-10-042024-10-07False
17060000008123L17/dossiers17170600000081101706000000811012PA7949462024-10-07False
17060000008124L17/dossiers17170600000081101706000000811013PA7196322024-10-07False
17060000008125L17/dossiers17170600000081101706000000811014PA15672024-09-202024-09-26False
17060000008126L17/dossiers17170600000081101706000000811015PA6088262024-10-07False
17060000008127L17/dossiers17170600000081101706000000811016PA7214102024-10-07False
17060000008128L17/dossiers17170600000081101706000000811017PA7937962024-10-07False
17060000008129L17/dossiers17170600000081101706000000811018PA3467822024-10-07False
17060000008130L17/dossiers17170600000081101706000000811019PA8413812024-10-07False
17060000008131L17/dossiers17170600000081101706000000811020PA7952442024-10-07False
17060000008132L17/dossiers17170600000081101706000000811021PA2667932024-10-07False
17060000008133L17/dossiers17170600000081101706000000811022PA3309092024-10-07False
17060000008134L17/dossiers17170600000081101706000000811023PA8408172024-10-07False
17060000008162L17/dossiers1717060000008160170600000081601PA7188842025-02-17False
17060000008163L17/dossiers1717060000008160170600000081602PA7214102025-02-17False
17060000008164L17/dossiers1717060000008160170600000081603PA7935082025-02-17False
17060000008165L17/dossiers1717060000008160170600000081604PA7188382025-02-17False
17060000008166L17/dossiers1717060000008160170600000081605PA6088262025-02-17False
17060000008167L17/dossiers1717060000008160170600000081606PA3325232024-09-172025-02-17False
17060000008168L17/dossiers1717060000008160170600000081607PA6059912025-02-17False
17060000008169L17/dossiers1717060000008160170600000081608PA6084162025-02-17False
17060000008170L17/dossiers1717060000008160170600000081609PA3467822025-02-17False
17060000008171L17/dossiers17170600000081601706000000816010PA6955122025-02-17False
17060000008172L17/dossiers17170600000081601706000000816011PA6060982025-02-17False
17060000008173L17/dossiers17170600000081601706000000816012PA7933422025-02-17False
17060000008174L17/dossiers17170600000081601706000000816013PA7192722025-02-17False
17060000008175L17/dossiers17170600000081601706000000816014PA7940382025-02-17False
17060000008176L17/dossiers17170600000081601706000000816015PA7949942025-02-17False
17060000008177L17/dossiers17170600000081601706000000816016PA7930942025-02-17False
17060000008178L17/dossiers17170600000081601706000000816017PA2677942025-02-17False
17060000008179L17/dossiers17170600000081601706000000816018PA7941782025-02-17False
17060000008180L17/dossiers17170600000081601706000000816019PA7749542025-02-17False
17060000008184L17/dossiers1717060000008182170600000081821PA7188842025-02-17False
17060000008185L17/dossiers1717060000008182170600000081822PA7749542025-02-17False
17060000008186L17/dossiers1717060000008182170600000081823PA7214102025-02-17False
17060000008187L17/dossiers1717060000008182170600000081824PA7188382025-02-17False
17060000008188L17/dossiers1717060000008182170600000081825PA3325232024-09-172025-02-17False
17060000008189L17/dossiers1717060000008182170600000081826PA6059912025-02-17False
17060000008190L17/dossiers1717060000008182170600000081827PA2667972025-02-17False
17060000008191L17/dossiers1717060000008182170600000081828PA7940582025-02-17False
17060000008192L17/dossiers1717060000008182170600000081829PA6955122025-02-17False
17060000008193L17/dossiers17170600000081821706000000818210PA7933422025-02-17False
17060000008194L17/dossiers17170600000081821706000000818211PA7940382025-02-17False
17060000008195L17/dossiers17170600000081821706000000818212PA7192722025-02-17False
17060000008196L17/dossiers17170600000081821706000000818213PA7206442025-02-17False
17060000008197L17/dossiers17170600000081821706000000818214PA7214422025-02-17False
17060000008198L17/dossiers17170600000081821706000000818215PA7187842025-02-17False
17060000008199L17/dossiers17170600000081821706000000818216PA7949942025-02-17False
17060000008200L17/dossiers17170600000081821706000000818217PA7930942025-02-17False
17060000008201L17/dossiers17170600000081821706000000818218PA2668082025-02-17False