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
17060000017101L17/dossiers17170600000170751706000001707525PA8418932024-10-29False
17060000017102L17/dossiers17170600000170751706000001707526PA7938162024-10-29False
17060000017103L17/dossiers17170600000170751706000001707527PA7944942024-10-29False
17060000017104L17/dossiers17170600000170751706000001707528PA7209922024-10-29False
17060000017105L17/dossiers17170600000170751706000001707529PA7199302024-10-29False
17060000017106L17/dossiers17170600000170751706000001707530PA8412952024-10-29False
17060000017107L17/dossiers17170600000170751706000001707531PA8401712024-10-29False
17060000017108L17/dossiers17170600000170751706000001707532PA8422632024-10-29False
17060000017109L17/dossiers17170600000170751706000001707533PA8418132024-10-29False
17060000017110L17/dossiers17170600000170751706000001707534PA8418532024-10-29False
17060000017111L17/dossiers17170600000170751706000001707535PA8413672024-10-29False
17060000017112L17/dossiers17170600000170751706000001707536PA3421962024-10-29False
17060000017113L17/dossiers17170600000170751706000001707537PA8406652024-10-29False
17060000017114L17/dossiers17170600000170751706000001707538PA6427642024-10-29False
17060000017115L17/dossiers17170600000170751706000001707539PA6431432024-10-29False
17060000017116L17/dossiers17170600000170751706000001707540PA8408292024-10-29False
17060000017117L17/dossiers17170600000170751706000001707541PA3424152024-10-29False
17060000017118L17/dossiers17170600000170751706000001707542PA6067932024-10-29False
17060000017119L17/dossiers17170600000170751706000001707543PA8422112024-10-29False
17060000017120L17/dossiers17170600000170751706000001707544PA8413152024-10-29False
17060000017121L17/dossiers17170600000170751706000001707545PA7940942024-10-29False
17060000017122L17/dossiers17170600000170751706000001707546PA7936242024-10-29False
17060000017123L17/dossiers17170600000170751706000001707547PA7957622024-10-29False
17060000017124L17/dossiers17170600000170751706000001707548PA6082642024-10-29False
17060000017125L17/dossiers17170600000170751706000001707549PA8409032024-10-29False
17060000017126L17/dossiers17170600000170751706000001707550PA10082024-10-29False
17060000017127L17/dossiers17170600000170751706000001707551PA7933942024-10-29False
17060000017128L17/dossiers17170600000170751706000001707552PA7954302024-10-29False
17060000017129L17/dossiers17170600000170751706000001707553PA8419192024-10-29False
17060000017130L17/dossiers17170600000170751706000001707554PA6065732024-10-29False
17060000017131L17/dossiers17170600000170751706000001707555PA8416332024-10-29False
17060000017132L17/dossiers17170600000170751706000001707556PA7948542024-10-29False
17060000017133L17/dossiers17170600000170751706000001707557PA8421952024-10-29False
17060000017134L17/dossiers17170600000170751706000001707558PA6093322024-10-29False
17060000017135L17/dossiers17170600000170751706000001707559PA8416652024-10-29False
17060000017136L17/dossiers17170600000170751706000001707560PA3332852024-10-29False
17060000017137L17/dossiers17170600000170751706000001707561PA8409392024-10-29False
17060000017138L17/dossiers17170600000170751706000001707562PA8415392024-10-29False
17060000017139L17/dossiers17170600000170751706000001707563PA3319732024-10-29False
17060000017140L17/dossiers17170600000170751706000001707564PA15672024-10-29False
17060000017141L17/dossiers17170600000170751706000001707565PA8414712024-10-29False
17060000017145L17/dossiers1717060000017143170600000171431PA6428472025-02-17False
17060000017146L17/dossiers1717060000017143170600000171432PA7188842025-02-17False
17060000017147L17/dossiers1717060000017143170600000171433PA7199682025-02-17False
17060000017148L17/dossiers1717060000017143170600000171434PA7214102025-02-17False
17060000017149L17/dossiers1717060000017143170600000171435PA7218162025-02-17False
17060000017150L17/dossiers1717060000017143170600000171436PA7188502025-02-17False
17060000017151L17/dossiers1717060000017143170600000171437PA7203862025-02-17False
17060000017152L17/dossiers1717060000017143170600000171438PA3325232024-10-292025-02-17False
17060000017153L17/dossiers1717060000017143170600000171439PA7120152025-02-17False