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
17060000027143L17/dossiers17170600000271061706000002710636PA8416212025-03-11False
17060000027144L17/dossiers17170600000271061706000002710637PA7932462025-03-11False
17060000027145L17/dossiers17170600000271061706000002710638PA8416132025-03-11False
17060000027146L17/dossiers17170600000271061706000002710639PA8401432025-03-11False
17060000027147L17/dossiers17170600000271061706000002710640PA8408012025-03-11False
17060000027148L17/dossiers17170600000271061706000002710641PA7946782025-03-11False
17060000027149L17/dossiers17170600000271061706000002710642PA8411392025-03-11False
17060000027150L17/dossiers17170600000271061706000002710643PA7938922025-03-11False
17060000027151L17/dossiers17170600000271061706000002710644PA8417372025-03-11False
17060000027152L17/dossiers17170600000271061706000002710645PA7960342025-03-11False
17060000027153L17/dossiers17170600000271061706000002710646PA7931022025-03-11False
17060000027154L17/dossiers17170600000271061706000002710647PA8416052025-03-11False
17060000027155L17/dossiers17170600000271061706000002710648PA7933622025-03-11False
17060000027156L17/dossiers17170600000271061706000002710649PA7944182025-03-11False
17060000027157L17/dossiers17170600000271061706000002710650PA7935922025-03-11False
17060000027158L17/dossiers17170600000271061706000002710651PA8407572025-03-11False
17060000027159L17/dossiers17170600000271061706000002710652PA8414512025-03-11False
17060000027160L17/dossiers17170600000271061706000002710653PA7947342025-03-11False
17060000027161L17/dossiers17170600000271061706000002710654PA7932182025-03-11False
17060000027162L17/dossiers17170600000271061706000002710655PA7959002025-03-11False
17060000027163L17/dossiers17170600000271061706000002710656PA7936322025-03-11False
17060000027164L17/dossiers17170600000271061706000002710657PA8420852025-03-11False
17060000027165L17/dossiers17170600000271061706000002710658PA7945982025-03-11False
17060000027166L17/dossiers17170600000271061706000002710659PA8414392025-03-11False
17060000027167L17/dossiers17170600000271061706000002710660PA7940302025-03-11False
17060000027168L17/dossiers17170600000271061706000002710661PA8417492025-03-11False
17060000027169L17/dossiers17170600000271061706000002710662PA8410752025-03-11False
17060000027170L17/dossiers17170600000271061706000002710663PA8408692025-03-11False
17060000027171L17/dossiers17170600000271061706000002710664PA7943542025-03-11False
17060000027172L17/dossiers17170600000271061706000002710665PA7959122025-03-11False
17060000027173L17/dossiers17170600000271061706000002710666PA8418372025-03-11False
17060000027174L17/dossiers17170600000271061706000002710667PA7960262025-03-11False
17060000027175L17/dossiers17170600000271061706000002710668PA8408572025-03-11False
17060000027176L17/dossiers17170600000271061706000002710669PA7932902025-03-11False
17060000027177L17/dossiers17170600000271061706000002710670PA6429882025-03-11False
17060000027178L17/dossiers17170600000271061706000002710671PA7936082025-03-11False
17060000027179L17/dossiers17170600000271061706000002710672PA8418732025-03-11False
17060000027180L17/dossiers17170600000271061706000002710673PA8409672025-03-11False
17060000027181L17/dossiers17170600000271061706000002710674PA7936722025-03-11False
17060000027182L17/dossiers17170600000271061706000002710675PA7939042025-03-11False
17060000027183L17/dossiers17170600000271061706000002710676PA7219322025-03-11False
17060000027184L17/dossiers17170600000271061706000002710677PA7959742025-03-11False
17060000027185L17/dossiers17170600000271061706000002710678PA7945902025-03-11False
17060000027186L17/dossiers17170600000271061706000002710679PA8415872025-03-11False
17060000027187L17/dossiers17170600000271061706000002710680PA8415632025-03-11False
17060000027188L17/dossiers17170600000271061706000002710681PA7945302025-03-11False
17060000027189L17/dossiers17170600000271061706000002710682PA8408372025-03-11False
17060000027190L17/dossiers17170600000271061706000002710683PA8418252025-03-11False
17060000027191L17/dossiers17170600000271061706000002710684PA7947702025-03-11False
17060000027192L17/dossiers17170600000271061706000002710685PA7933142025-03-11False