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 151 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
17060000016188L17/dossiers17170600000161561706000001615631PA6431572024-10-29False
17060000016189L17/dossiers17170600000161561706000001615632PA8411072024-10-29False
17060000016190L17/dossiers17170600000161561706000001615633PA8413812024-10-29False
17060000016191L17/dossiers17170600000161561706000001615634PA8407932024-10-29False
17060000016192L17/dossiers17170600000161561706000001615635PA6081722024-10-29False
17060000016193L17/dossiers17170600000161561706000001615636PA6075532024-10-29False
17060000016194L17/dossiers17170600000161561706000001615637PA8409552024-10-29False
17060000016195L17/dossiers17170600000161561706000001615638PA8413672024-10-29False
17060000016196L17/dossiers17170600000161561706000001615639PA3419812024-10-29False
17060000016197L17/dossiers17170600000161561706000001615640PA8406732024-10-29False
17060000016198L17/dossiers17170600000161561706000001615641PA3421962024-10-29False
17060000016199L17/dossiers17170600000161561706000001615642PA8266352024-10-29False
17060000016200L17/dossiers17170600000161561706000001615643PA8413272024-10-29False
17060000016201L17/dossiers17170600000161561706000001615644PA8417172024-10-29False
17060000016202L17/dossiers17170600000161561706000001615645PA8412432024-10-29False
17060000016203L17/dossiers17170600000161561706000001615646PA7749602024-10-29False
17060000016204L17/dossiers17170600000161561706000001615647PA3403432024-10-29False
17060000016205L17/dossiers17170600000161561706000001615648PA8410912024-10-29False
17060000016206L17/dossiers17170600000161561706000001615649PA8416812024-10-29False
17060000016207L17/dossiers17170600000161561706000001615650PA8418932024-10-29False
17060000016208L17/dossiers17170600000161561706000001615651PA7938162024-10-29False
17060000016209L17/dossiers17170600000161561706000001615652PA7944942024-10-29False
17060000016210L17/dossiers17170600000161561706000001615653PA7209922024-10-29False
17060000016211L17/dossiers17170600000161561706000001615654PA7199302024-10-29False
17060000016212L17/dossiers17170600000161561706000001615655PA6093322024-10-29False
17060000016213L17/dossiers17170600000161561706000001615656PA6431922024-10-29False
17060000016214L17/dossiers17170600000161561706000001615657PA6427642024-10-29False
17060000016215L17/dossiers17170600000161561706000001615658PA8406652024-10-29False
17060000016216L17/dossiers17170600000161561706000001615659PA6431432024-10-29False
17060000016217L17/dossiers17170600000161561706000001615660PA8408292024-10-29False
17060000016218L17/dossiers17170600000161561706000001615661PA3424152024-10-29False
17060000016219L17/dossiers17170600000161561706000001615662PA6067932024-10-29False
17060000016220L17/dossiers17170600000161561706000001615663PA8422112024-10-29False
17060000016221L17/dossiers17170600000161561706000001615664PA8413152024-10-29False
17060000016225L17/dossiers1717060000016223170600000162231PA7220462024-10-29False
17060000016226L17/dossiers1717060000016223170600000162232PA8416932024-10-29False
17060000016227L17/dossiers1717060000016223170600000162233PA7953862024-10-29False
17060000016228L17/dossiers1717060000016223170600000162234PA7951762024-10-29False
17060000016229L17/dossiers1717060000016223170600000162235PA7955282024-10-29False
17060000016230L17/dossiers1717060000016223170600000162236PA7201382024-10-29False
17060000016231L17/dossiers1717060000016223170600000162237PA29602024-10-29False
17060000016235L17/dossiers1717060000016233170600000162331PA7953302024-10-29False
17060000016239L17/dossiers1717060000016237170600000162371PA5692025-03-04False
17060000016240L17/dossiers1717060000016237170600000162372PA7213362025-03-04False
17060000016241L17/dossiers1717060000016237170600000162373PA8408172025-03-04False
17060000016242L17/dossiers1717060000016237170600000162374PA7202302025-03-04False
17060000016243L17/dossiers1717060000016237170600000162375PA7196322025-03-04False
17060000016244L17/dossiers1717060000016237170600000162376PA7190322025-03-04False
17060000016245L17/dossiers1717060000016237170600000162377PA3300082025-03-04False
17060000016246L17/dossiers1717060000016237170600000162378PA7194722025-03-04False