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
17060000028940L17/dossiers1717060000028930170600000289309PA2675612025-04-25False
17060000028941L17/dossiers17170600000289301706000002893010PA8407212025-04-25False
17060000028942L17/dossiers17170600000289301706000002893011PA7947702025-04-25False
17060000028943L17/dossiers17170600000289301706000002893012PA8422272025-04-25False
17060000028944L17/dossiers17170600000289301706000002893013PA7933742025-04-25False
17060000028945L17/dossiers17170600000289301706000002893014PA7932382025-04-25False
17060000028946L17/dossiers17170600000289301706000002893015PA8409152025-04-25False
17060000028947L17/dossiers17170600000289301706000002893016PA8400752025-04-25False
17060000028948L17/dossiers17170600000289301706000002893017PA8422552025-04-25False
17060000028952L17/dossiers1717060000028950170600000289501PA7942782025-03-11False
17060000028953L17/dossiers1717060000028950170600000289502PA7939922025-03-11False
17060000028954L17/dossiers1717060000028950170600000289503PA7952782025-03-11False
17060000028955L17/dossiers1717060000028950170600000289504PA3322282025-03-11False
17060000028956L17/dossiers1717060000028950170600000289505PA6872142025-03-11False
17060000028957L17/dossiers1717060000028950170600000289506PA7190322025-03-11False
17060000028958L17/dossiers1717060000028950170600000289507PA8413392025-03-11False
17060000028959L17/dossiers1717060000028950170600000289508PA6428682025-03-11False
17060000028960L17/dossiers1717060000028950170600000289509PA8414312025-03-11False
17060000028961L17/dossiers17170600000289501706000002895010PA2677802025-03-11False
17060000028962L17/dossiers17170600000289501706000002895011PA7944702025-03-11False
17060000028963L17/dossiers17170600000289501706000002895012PA7220702025-03-11False
17060000028964L17/dossiers17170600000289501706000002895013PA7197782025-03-11False
17060000028965L17/dossiers17170600000289501706000002895014PA7190522025-03-11False
17060000028966L17/dossiers17170600000289501706000002895015PA7944262025-03-11False
17060000028967L17/dossiers17170600000289501706000002895016PA7948382025-03-11False
17060000028968L17/dossiers17170600000289501706000002895017PA7202302025-03-11False
17060000028969L17/dossiers17170600000289501706000002895018PA7944662025-03-11False
17060000028970L17/dossiers17170600000289501706000002895019PA7209082025-03-11False
17060000028971L17/dossiers17170600000289501706000002895020PA7933982025-03-11False
17060000028972L17/dossiers17170600000289501706000002895021PA7218442025-03-11False
17060000028973L17/dossiers17170600000289501706000002895022PA7935722025-03-11False
17060000028974L17/dossiers17170600000289501706000002895023PA7952702025-03-11False
17060000028975L17/dossiers17170600000289501706000002895024PA7205522025-03-11False
17060000028976L17/dossiers17170600000289501706000002895025PA7214582025-03-11False
17060000028977L17/dossiers17170600000289501706000002895026PA7201382025-03-11False
17060000028978L17/dossiers17170600000289501706000002895027PA7953502025-03-11False
17060000028979L17/dossiers17170600000289501706000002895028PA7950262025-03-11False
17060000028980L17/dossiers17170600000289501706000002895029PA7942342025-03-11False
17060000028981L17/dossiers17170600000289501706000002895030PA7192822025-03-11False
17060000028985L17/dossiers1717060000028983170600000289831PA7961062025-04-03False
17060000028986L17/dossiers1717060000028983170600000289832PA7208382025-04-03False
17060000028987L17/dossiers1717060000028983170600000289833PA7958682025-04-03False
17060000028988L17/dossiers1717060000028983170600000289834PA2673062025-04-03False
17060000028989L17/dossiers1717060000028983170600000289835PA7218962025-04-03False
17060000028990L17/dossiers1717060000028983170600000289836PA7959982025-04-03False
17060000028991L17/dossiers1717060000028983170600000289837PA7749622025-04-03False
17060000028992L17/dossiers1717060000028983170600000289838PA3356122025-04-03False
17060000028993L17/dossiers1717060000028983170600000289839PA7960102025-04-03False
17060000028994L17/dossiers17170600000289831706000002898310PA8422712025-04-03False
17060000028995L17/dossiers17170600000289831706000002898311PA7931742025-04-03False