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
17060000019398L17/dossiers17170600000193451706000001934552PA8402352025-03-10False
17060000019399L17/dossiers17170600000193451706000001934553PA7954222025-03-10False
17060000019400L17/dossiers17170600000193451706000001934554PA8172112025-03-10False
17060000019401L17/dossiers17170600000193451706000001934555PA7950102025-03-10False
17060000019408L17/dossiers1717060000019406170600000194061PA6056942024-11-19False
17060000019409L17/dossiers1717060000019406170600000194062PA7221342024-11-19False
17060000019410L17/dossiers1717060000019406170600000194063PA8402352024-11-19False
17060000019411L17/dossiers1717060000019406170600000194064PA7200382024-11-19False
17060000019412L17/dossiers1717060000019406170600000194065PA6431842024-11-19False
17060000019413L17/dossiers1717060000019406170600000194066PA3457222024-11-19False
17060000019414L17/dossiers1717060000019406170600000194067PA6774832024-11-19False
17060000019415L17/dossiers1717060000019406170600000194068PA7944862024-11-19False
17060000019416L17/dossiers1717060000019406170600000194069PA7195122024-11-19False
17060000019417L17/dossiers17170600000194061706000001940610PA7950462024-11-19False
17060000019421L17/dossiers1717060000019419170600000194191PA7214102025-02-19False
17060000019422L17/dossiers1717060000019419170600000194192PA7218162025-02-19False
17060000019423L17/dossiers1717060000019419170600000194193PA7940582025-02-19False
17060000019424L17/dossiers1717060000019419170600000194194PA16302025-02-19False
17060000019425L17/dossiers1717060000019419170600000194195PA3467822025-02-19False
17060000019426L17/dossiers1717060000019419170600000194196PA6955122025-02-19False
17060000019427L17/dossiers1717060000019419170600000194197PA6080162025-02-19False
17060000019428L17/dossiers1717060000019419170600000194198PA7940382025-02-19False
17060000019429L17/dossiers1717060000019419170600000194199PA2668082025-02-19False
17060000019430L17/dossiers17170600000194191706000001941910PA7749542025-02-19False
17060000019431L17/dossiers17170600000194191706000001941911PA7206442025-02-19False
17060000019432L17/dossiers17170600000194191706000001941912PA7214422025-02-19False
17060000019433L17/dossiers17170600000194191706000001941913PA7930942025-02-19False
17060000019434L17/dossiers17170600000194191706000001941914PA7188842025-02-19False
17060000019435L17/dossiers17170600000194191706000001941915PA3309092025-02-19False
17060000019436L17/dossiers17170600000194191706000001941916PA6088262025-02-19False
17060000019437L17/dossiers17170600000194191706000001941917PA7192722025-02-19False
17060000019438L17/dossiers17170600000194191706000001941918PA2677942025-02-19False
17060000019439L17/dossiers17170600000194191706000001941919PA7941782025-02-19False
17060000019440L17/dossiers17170600000194191706000001941920PA6070902025-02-19False
17060000019441L17/dossiers17170600000194191706000001941921PA7935082025-02-19False
17060000019442L17/dossiers17170600000194191706000001941922PA7188502025-02-19False
17060000019443L17/dossiers17170600000194191706000001941923PA7203862025-02-19False
17060000019444L17/dossiers17170600000194191706000001941924PA2667972025-02-19False
17060000019445L17/dossiers17170600000194191706000001941925PA7933422025-02-19False
17060000019449L17/dossiers1717060000019447170600000194471PA7208922024-12-03False
17060000019450L17/dossiers1717060000019447170600000194472PA7952282024-12-03False
17060000019451L17/dossiers1717060000019447170600000194473PA7932622024-12-03False
17060000019452L17/dossiers1717060000019447170600000194474PA7949062024-12-03False
17060000019453L17/dossiers1717060000019447170600000194475PA7941382024-12-03False
17060000019454L17/dossiers1717060000019447170600000194476PA7955882024-12-03False
17060000019455L17/dossiers1717060000019447170600000194477PA7950842024-12-03False
17060000019456L17/dossiers1717060000019447170600000194478PA8421052024-12-03False
17060000019457L17/dossiers1717060000019447170600000194479PA8416572024-12-03False
17060000019458L17/dossiers17170600000194471706000001944710PA7204302024-12-03False
17060000019459L17/dossiers17170600000194471706000001944711PA7937722024-12-03False