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
17060000036368L17/dossiers1717060000036363170600000363634PA7941382025-05-07False
17060000036369L17/dossiers1717060000036363170600000363635PA7955882025-05-07False
17060000036370L17/dossiers1717060000036363170600000363636PA7950842025-05-07False
17060000036371L17/dossiers1717060000036363170600000363637PA8421052025-05-07False
17060000036372L17/dossiers1717060000036363170600000363638PA8416572025-05-07False
17060000036373L17/dossiers1717060000036363170600000363639PA7204302025-05-07False
17060000036374L17/dossiers17170600000363631706000003636310PA7937722025-05-07False
17060000036375L17/dossiers17170600000363631706000003636311PA7956162025-05-07False
17060000036376L17/dossiers17170600000363631706000003636312PA7934442025-05-07False
17060000036377L17/dossiers17170600000363631706000003636313PA7949382025-05-07False
17060000036378L17/dossiers17170600000363631706000003636314PA7953182025-05-07False
17060000036379L17/dossiers17170600000363631706000003636315PA8410232025-05-07False
17060000036380L17/dossiers17170600000363631706000003636316PA7960902025-05-07False
17060000036381L17/dossiers17170600000363631706000003636317PA7939122025-05-07False
17060000036382L17/dossiers17170600000363631706000003636318PA8421872025-05-07False
17060000036383L17/dossiers17170600000363631706000003636319PA8420372025-05-07False
17060000036384L17/dossiers17170600000363631706000003636320PA7918122025-05-07False
17060000036385L17/dossiers17170600000363631706000003636321PA7937362025-05-07False
17060000036386L17/dossiers17170600000363631706000003636322PA7212022025-05-07False
17060000036387L17/dossiers17170600000363631706000003636323PA7951362025-05-07False
17060000036388L17/dossiers17170600000363631706000003636324PA7934642025-05-07False
17060000036389L17/dossiers17170600000363631706000003636325PA8421552025-05-07False
17060000036390L17/dossiers17170600000363631706000003636326PA7952002025-05-07False
17060000036391L17/dossiers17170600000363631706000003636327PA7958442025-05-07False
17060000036392L17/dossiers17170600000363631706000003636328PA8412512025-05-07False
17060000036393L17/dossiers17170600000363631706000003636329PA7947862025-05-07False
17060000036394L17/dossiers17170600000363631706000003636330PA7948702025-05-07False
17060000036395L17/dossiers17170600000363631706000003636331PA7960702025-05-07False
17060000036396L17/dossiers17170600000363631706000003636332PA7953102025-05-07False
17060000036397L17/dossiers17170600000363631706000003636333PA7944782025-05-07False
17060000036398L17/dossiers17170600000363631706000003636334PA8419472025-05-07False
17060000036399L17/dossiers17170600000363631706000003636335PA7940822025-05-07False
17060000036400L17/dossiers17170600000363631706000003636336PA7208462025-05-07False
17060000036401L17/dossiers17170600000363631706000003636337PA7941302025-05-072025-05-07False
17060000036402L17/dossiers17170600000363631706000003636338PA8417292025-05-07False
17060000036403L17/dossiers17170600000363631706000003636339PA7955162025-05-07False
17060000036404L17/dossiers17170600000363631706000003636340PA7956722025-05-07False
17060000036405L17/dossiers17170600000363631706000003636341PA7957462025-05-07False
17060000036406L17/dossiers17170600000363631706000003636342PA7951082025-05-07False
17060000036407L17/dossiers17170600000363631706000003636343PA8415152025-05-07False
17060000036408L17/dossiers17170600000363631706000003636344PA7952982025-05-07False
17060000036409L17/dossiers17170600000363631706000003636345PA7918242025-05-07False
17060000036410L17/dossiers17170600000363631706000003636346PA8420292025-05-07False
17060000036411L17/dossiers17170600000363631706000003636347PA7935322025-05-07False
17060000036412L17/dossiers17170600000363631706000003636348PA3423842025-05-07False
17060000036413L17/dossiers17170600000363631706000003636349PA7954222025-05-07False
17060000036414L17/dossiers17170600000363631706000003636350PA7946862025-05-07False
17060000036415L17/dossiers17170600000363631706000003636351PA8412152025-05-07False
17060000036416L17/dossiers17170600000363631706000003636352PA7954822025-05-07False
17060000036417L17/dossiers17170600000363631706000003636353PA6106542025-05-07False