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
17060000040346L17/dossiers1717060000040340170600000403405PA8406732025-06-30False
17060000040347L17/dossiers1717060000040340170600000403406PA3421962025-06-30False
17060000040351L17/dossiers1717060000040349170600000403491PA7932702026-01-13False
17060000040352L17/dossiers1717060000040349170600000403492PA8226172026-01-13False
17060000040353L17/dossiers1717060000040349170600000403493PA7951202026-01-13False
17060000040354L17/dossiers1717060000040349170600000403494PA7199302026-01-13False
17060000040355L17/dossiers1717060000040349170600000403495PA7199382026-01-13False
17060000040356L17/dossiers1717060000040349170600000403496PA7212702026-01-13False
17060000040357L17/dossiers1717060000040349170600000403497PA7932102026-01-13False
17060000040358L17/dossiers1717060000040349170600000403498PA7194122026-01-13False
17060000040359L17/dossiers1717060000040349170600000403499PA7951442026-01-13False
17060000040360L17/dossiers17170600000403491706000004034910PA16542026-01-13False
17060000040361L17/dossiers17170600000403491706000004034911PA7936642026-01-13False
17060000040362L17/dossiers17170600000403491706000004034912PA6075532026-01-13False
17060000040363L17/dossiers17170600000403491706000004034913PA2667932026-01-13False
17060000040364L17/dossiers17170600000403491706000004034914PA7936242026-01-13False
17060000040365L17/dossiers17170600000403491706000004034915PA6774832026-01-13False
17060000040366L17/dossiers17170600000403491706000004034916PA8406732026-01-13False
17060000040367L17/dossiers17170600000403491706000004034917PA8406652026-01-13False
17060000040368L17/dossiers17170600000403491706000004034918PA6427642026-01-13False
17060000040369L17/dossiers17170600000403491706000004034919PA3424152026-01-13False
17060000040370L17/dossiers17170600000403491706000004034920PA6428472026-01-13False
17060000040371L17/dossiers17170600000403491706000004034921PA3322282026-01-13False
17060000040372L17/dossiers17170600000403491706000004034922PA8051662026-01-13False
17060000040373L17/dossiers17170600000403491706000004034923PA5692026-01-13False
17060000040374L17/dossiers17170600000403491706000004034924PA7199682026-01-13False
17060000040375L17/dossiers17170600000403491706000004034925PA7214102026-01-13False
17060000040376L17/dossiers17170600000403491706000004034926PA6426952026-01-13False
17060000040377L17/dossiers17170600000403491706000004034927PA7190322026-01-13False
17060000040378L17/dossiers17170600000403491706000004034928PA8413392026-01-13False
17060000040379L17/dossiers17170600000403491706000004034929PA7935082026-01-13False
17060000040380L17/dossiers17170600000403491706000004034930PA7947102026-01-13False
17060000040381L17/dossiers17170600000403491706000004034931PA7198902026-01-13False
17060000040382L17/dossiers17170600000403491706000004034932PA7188382026-01-13False
17060000040383L17/dossiers17170600000403491706000004034933PA7220002026-01-13False
17060000040384L17/dossiers17170600000403491706000004034934PA7947982026-01-13False
17060000040385L17/dossiers17170600000403491706000004034935PA7194722026-01-13False
17060000040386L17/dossiers17170600000403491706000004034936PA8410472026-01-13False
17060000040387L17/dossiers17170600000403491706000004034937PA7188502026-01-13False
17060000040388L17/dossiers17170600000403491706000004034938PA7191182026-01-13False
17060000040389L17/dossiers17170600000403491706000004034939PA7944302026-01-13False
17060000040390L17/dossiers17170600000403491706000004034940PA7937162026-01-13False
17060000040391L17/dossiers17170600000403491706000004034941PA7223902026-01-13False
17060000040392L17/dossiers17170600000403491706000004034942PA7931222026-01-13False
17060000040393L17/dossiers17170600000403491706000004034943PA10082026-01-13False
17060000040394L17/dossiers17170600000403491706000004034944PA7954302026-01-13False
17060000040395L17/dossiers17170600000403491706000004034945PA7949822026-01-13False
17060000040396L17/dossiers17170600000403491706000004034946PA6065732026-01-13False
17060000040397L17/dossiers17170600000403491706000004034947PA7201542026-01-13False
17060000040398L17/dossiers17170600000403491706000004034948PA8416332026-01-13False