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
17060000040290L17/dossiers171706000004018817060000040188101PA7948302025-10-02False
17060000040291L17/dossiers171706000004018817060000040188102PA7221502025-10-02False
17060000040292L17/dossiers171706000004018817060000040188103PA7120142025-10-02False
17060000040293L17/dossiers171706000004018817060000040188104PA7205522025-10-02False
17060000040294L17/dossiers171706000004018817060000040188105PA7959622025-10-02False
17060000040295L17/dossiers171706000004018817060000040188106PA7937962025-10-02False
17060000040296L17/dossiers171706000004018817060000040188107PA7196322025-10-02False
17060000040297L17/dossiers171706000004018817060000040188108PA7214582025-10-02False
17060000040298L17/dossiers171706000004018817060000040188109PA7950262025-10-02False
17060000040299L17/dossiers171706000004018817060000040188110PA7200222025-10-02False
17060000040300L17/dossiers171706000004018817060000040188111PA7191382025-10-02False
17060000040301L17/dossiers171706000004018817060000040188112PA7190322025-10-02False
17060000040302L17/dossiers171706000004018817060000040188113PA7197362025-10-02False
17060000040303L17/dossiers171706000004018817060000040188114PA8416012025-10-02False
17060000040304L17/dossiers171706000004018817060000040188115PA7195122025-10-02False
17060000040305L17/dossiers171706000004018817060000040188116PA7223662025-10-02False
17060000040306L17/dossiers171706000004018817060000040188117PA6431842025-10-02False
17060000040307L17/dossiers171706000004018817060000040188118PA6076192025-10-02False
17060000040308L17/dossiers171706000004018817060000040188119PA7944262025-10-02False
17060000040309L17/dossiers171706000004018817060000040188120PA6056942025-10-02False
17060000040310L17/dossiers171706000004018817060000040188121PA7946582025-10-02False
17060000040311L17/dossiers171706000004018817060000040188122PA7942062025-10-02False
17060000040312L17/dossiers171706000004018817060000040188123PA7214742025-10-02False
17060000040313L17/dossiers171706000004018817060000040188124PA7948382025-10-02False
17060000040314L17/dossiers171706000004018817060000040188125PA7190522025-10-02False
17060000040315L17/dossiers171706000004018817060000040188126PA7953302025-10-02False
17060000040319L17/dossiers1717060000040317170600000403171PA8417372025-06-24False
17060000040320L17/dossiers1717060000040317170600000403172PA7936162025-06-24False
17060000040321L17/dossiers1717060000040317170600000403173PA7960262025-06-24False
17060000040322L17/dossiers1717060000040317170600000403174PA8409832025-06-24False
17060000040323L17/dossiers1717060000040317170600000403175PA8406572025-06-24False
17060000040324L17/dossiers1717060000040317170600000403176PA7204682025-06-24False
17060000040325L17/dossiers1717060000040317170600000403177PA8410672025-06-24False
17060000040326L17/dossiers1717060000040317170600000403178PA8408012025-06-24False
17060000040327L17/dossiers1717060000040317170600000403179PA8417692025-06-24False
17060000040328L17/dossiers17170600000403171706000004031710PA7938922025-06-24False
17060000040329L17/dossiers17170600000403171706000004031711PA8407732025-06-24False
17060000040330L17/dossiers17170600000403171706000004031712PA8407012025-06-24False
17060000040331L17/dossiers17170600000403171706000004031713PA7935922025-06-24False
17060000040332L17/dossiers17170600000403171706000004031714PA7959122025-06-24False
17060000040333L17/dossiers17170600000403171706000004031715PA8413952025-06-24False
17060000040334L17/dossiers17170600000403171706000004031716PA2675612025-06-24False
17060000040335L17/dossiers17170600000403171706000004031717PA7208222025-06-24False
17060000040336L17/dossiers17170600000403171706000004031718PA8408892025-06-24False
17060000040337L17/dossiers17170600000403171706000004031719PA8407212025-06-24False
17060000040338L17/dossiers17170600000403171706000004031720PA7936962025-06-24False
17060000040342L17/dossiers1717060000040340170600000403401PA7749602025-06-30False
17060000040343L17/dossiers1717060000040340170600000403402PA6427642025-06-30False
17060000040344L17/dossiers1717060000040340170600000403403PA8418532025-06-30False
17060000040345L17/dossiers1717060000040340170600000403404PA6431922025-06-30False