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
17060000018983L17/dossiers17170600000189661706000001896616PA7938442025-03-07False
17060000018984L17/dossiers17170600000189661706000001896617PA8414872025-03-07False
17060000018985L17/dossiers17170600000189661706000001896618PA8411312025-03-07False
17060000018986L17/dossiers17170600000189661706000001896619PA7931822025-03-07False
17060000018987L17/dossiers17170600000189661706000001896620PA7931342025-03-07False
17060000018988L17/dossiers17170600000189661706000001896621PA8400752025-03-07False
17060000018989L17/dossiers17170600000189661706000001896622PA7204682025-03-07False
17060000018990L17/dossiers17170600000189661706000001896623PA7941982025-03-07False
17060000018991L17/dossiers17170600000189661706000001896624PA8401592025-03-07False
17060000018992L17/dossiers17170600000189661706000001896625PA7935482025-03-07False
17060000018993L17/dossiers17170600000189661706000001896626PA7956442025-03-07False
17060000018994L17/dossiers17170600000189661706000001896627PA8401192025-03-07False
17060000018995L17/dossiers17170600000189661706000001896628PA7931662025-03-07False
17060000018996L17/dossiers17170600000189661706000001896629PA7939282025-03-07False
17060000018997L17/dossiers17170600000189661706000001896630PA7947622025-03-07False
17060000018998L17/dossiers17170600000189661706000001896631PA7931462025-03-07False
17060000018999L17/dossiers17170600000189661706000001896632PA8401352025-03-07False
17060000019000L17/dossiers17170600000189661706000001896633PA8420732025-03-07False
17060000019001L17/dossiers17170600000189661706000001896634PA8417612025-03-07False
17060000019002L17/dossiers17170600000189661706000001896635PA7947182025-03-07False
17060000019003L17/dossiers17170600000189661706000001896636PA8416212025-03-07False
17060000019004L17/dossiers17170600000189661706000001896637PA7932462025-03-07False
17060000019005L17/dossiers17170600000189661706000001896638PA8416132025-03-07False
17060000019006L17/dossiers17170600000189661706000001896639PA8401432025-03-07False
17060000019007L17/dossiers17170600000189661706000001896640PA8408012025-03-07False
17060000019008L17/dossiers17170600000189661706000001896641PA7946782025-03-07False
17060000019009L17/dossiers17170600000189661706000001896642PA8411392025-03-07False
17060000019010L17/dossiers17170600000189661706000001896643PA7938922025-03-07False
17060000019011L17/dossiers17170600000189661706000001896644PA8417372025-03-07False
17060000019012L17/dossiers17170600000189661706000001896645PA7960342025-03-07False
17060000019013L17/dossiers17170600000189661706000001896646PA7938322025-03-07False
17060000019014L17/dossiers17170600000189661706000001896647PA7931022025-03-07False
17060000019015L17/dossiers17170600000189661706000001896648PA8416052025-03-07False
17060000019016L17/dossiers17170600000189661706000001896649PA7933622025-03-07False
17060000019017L17/dossiers17170600000189661706000001896650PA7944182025-03-07False
17060000019018L17/dossiers17170600000189661706000001896651PA7935922025-03-07False
17060000019019L17/dossiers17170600000189661706000001896652PA8407572025-03-07False
17060000019020L17/dossiers17170600000189661706000001896653PA8414512025-03-07False
17060000019021L17/dossiers17170600000189661706000001896654PA7947342025-03-07False
17060000019022L17/dossiers17170600000189661706000001896655PA7932182025-03-07False
17060000019023L17/dossiers17170600000189661706000001896656PA7959002025-03-07False
17060000019024L17/dossiers17170600000189661706000001896657PA7936322025-03-07False
17060000019025L17/dossiers17170600000189661706000001896658PA8420852025-03-07False
17060000019026L17/dossiers17170600000189661706000001896659PA7945982025-03-07False
17060000019027L17/dossiers17170600000189661706000001896660PA8414392025-03-07False
17060000019028L17/dossiers17170600000189661706000001896661PA7940302025-03-07False
17060000019029L17/dossiers17170600000189661706000001896662PA8417492025-03-07False
17060000019030L17/dossiers17170600000189661706000001896663PA8410752025-03-07False
17060000019031L17/dossiers17170600000189661706000001896664PA8408692025-03-07False
17060000019032L17/dossiers17170600000189661706000001896665PA7943542025-03-07False