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
17060000024485L17/dossiers171706000002435117060000024351133PA7958642026-06-11False
17060000024489L17/dossiers1717060000024487170600000244871PA7194122025-05-28False
17060000024490L17/dossiers1717060000024487170600000244872PA8414192025-05-28False
17060000024491L17/dossiers1717060000024487170600000244873PA7195582025-05-28False
17060000024492L17/dossiers1717060000024487170600000244874PA8413392025-05-142025-05-14False
17060000024493L17/dossiers1717060000024487170600000244875PA7953302025-05-28False
17060000024494L17/dossiers1717060000024487170600000244876PA7191382025-05-28False
17060000024495L17/dossiers1717060000024487170600000244877PA6075532025-05-28False
17060000024496L17/dossiers1717060000024487170600000244878PA8410232025-05-28False
17060000024497L17/dossiers1717060000024487170600000244879PA2667932025-05-28False
17060000024498L17/dossiers17170600000244871706000002448710PA7958202025-05-28False
17060000024499L17/dossiers17170600000244871706000002448711PA8402352025-05-28False
17060000024500L17/dossiers17170600000244871706000002448712PA7958882025-05-28False
17060000024501L17/dossiers17170600000244871706000002448713PA7190322025-02-042025-02-28False
17060000024502L17/dossiers17170600000244871706000002448714PA7948102025-05-28False
17060000024503L17/dossiers17170600000244871706000002448715PA3421962025-05-28False
17060000024504L17/dossiers17170600000244871706000002448716PA8409972025-05-28False
17060000024505L17/dossiers17170600000244871706000002448717PA7190242025-05-28False
17060000024506L17/dossiers17170600000244871706000002448718PA8415072025-05-28False
17060000024507L17/dossiers17170600000244871706000002448719PA6082642025-05-28False
17060000024508L17/dossiers17170600000244871706000002448720PA8418012025-05-28False
17060000024509L17/dossiers17170600000244871706000002448721PA7199222025-05-28False
17060000024510L17/dossiers17170600000244871706000002448722PA7192862025-05-28False
17060000024511L17/dossiers17170600000244871706000002448723PA7935202025-05-28False
17060000024512L17/dossiers17170600000244871706000002448724PA7201542025-05-28False
17060000024513L17/dossiers17170600000244871706000002448725PA6056942025-05-28False
17060000024514L17/dossiers17170600000244871706000002448726PA7221342025-05-28False
17060000024515L17/dossiers17170600000244871706000002448727PA2677802025-05-28False
17060000024516L17/dossiers17170600000244871706000002448728PA7221502025-05-28False
17060000024517L17/dossiers17170600000244871706000002448729PA7223742025-05-28False
17060000024518L17/dossiers17170600000244871706000002448730PA7200382025-05-28False
17060000024519L17/dossiers17170600000244871706000002448731PA7197982025-05-28False
17060000024520L17/dossiers17170600000244871706000002448732PA7199182025-05-28False
17060000024521L17/dossiers17170600000244871706000002448733PA7219842025-05-28False
17060000024522L17/dossiers17170600000244871706000002448734PA7953742025-05-28False
17060000024523L17/dossiers17170600000244871706000002448735PA7749582025-05-28False
17060000024524L17/dossiers17170600000244871706000002448736PA7947022025-05-28False
17060000024525L17/dossiers17170600000244871706000002448737PA7951002025-05-28False
17060000024526L17/dossiers17170600000244871706000002448738PA7207282025-05-28False
17060000024527L17/dossiers17170600000244871706000002448739PA8419312025-05-28False
17060000024528L17/dossiers17170600000244871706000002448740PA7196402025-05-28False
17060000024529L17/dossiers17170600000244871706000002448741PA7214862025-05-28False
17060000024530L17/dossiers17170600000244871706000002448742PA7957222025-05-28False
17060000024531L17/dossiers17170600000244871706000002448743PA7948302025-05-28False
17060000024532L17/dossiers17170600000244871706000002448744PA8420452025-05-28False
17060000024533L17/dossiers17170600000244871706000002448745PA7951242025-05-28False
17060000024534L17/dossiers17170600000244871706000002448746PA7211822025-05-28False
17060000024535L17/dossiers17170600000244871706000002448747PA7212342025-05-28False
17060000024536L17/dossiers17170600000244871706000002448748PA7935722025-05-142025-05-21False
17060000024537L17/dossiers17170600000244871706000002448749PA7207202025-05-28False