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
17060000047291L17/dossiers17170600000472071706000004720783PA7932542026-02-09False
17060000047295L17/dossiers1717060000047293170600000472931PA7199682025-10-14False
17060000047296L17/dossiers1717060000047293170600000472932PA2667932025-10-14False
17060000047297L17/dossiers1717060000047293170600000472933PA7223902025-10-14False
17060000047298L17/dossiers1717060000047293170600000472934PA8409792025-10-14False
17060000047299L17/dossiers1717060000047293170600000472935PA7188842025-10-14False
17060000047300L17/dossiers1717060000047293170600000472936PA2668082025-10-14False
17060000047301L17/dossiers1717060000047293170600000472937PA6428472025-10-14False
17060000047302L17/dossiers1717060000047293170600000472938PA7203862025-10-14False
17060000047303L17/dossiers1717060000047293170600000472939PA7940582025-10-14False
17060000047304L17/dossiers17170600000472931706000004729310PA7949942025-10-14False
17060000047305L17/dossiers17170600000472931706000004729311PA7940422025-10-14False
17060000047306L17/dossiers17170600000472931706000004729312PA6088262025-10-14False
17060000047307L17/dossiers17170600000472931706000004729313PA3467822025-10-14False
17060000047308L17/dossiers17170600000472931706000004729314PA3422402025-10-14False
17060000047309L17/dossiers17170600000472931706000004729315PA7187842025-10-14False
17060000047313L17/dossiers1717060000047311170600000473111PA7199682025-10-14False
17060000047314L17/dossiers1717060000047311170600000473112PA2667932025-10-14False
17060000047315L17/dossiers1717060000047311170600000473113PA7223902025-10-14False
17060000047316L17/dossiers1717060000047311170600000473114PA8409792025-10-14False
17060000047317L17/dossiers1717060000047311170600000473115PA7188842025-10-14False
17060000047318L17/dossiers1717060000047311170600000473116PA2668082025-10-14False
17060000047319L17/dossiers1717060000047311170600000473117PA6428472025-10-14False
17060000047320L17/dossiers1717060000047311170600000473118PA7218162025-10-14False
17060000047321L17/dossiers1717060000047311170600000473119PA7940582025-10-14False
17060000047322L17/dossiers17170600000473111706000004731110PA7940422025-10-14False
17060000047323L17/dossiers17170600000473111706000004731111PA6088262025-10-14False
17060000047324L17/dossiers17170600000473111706000004731112PA3422402025-10-14False
17060000047325L17/dossiers17170600000473111706000004731113PA7187842025-10-14False
17060000047329L17/dossiers1717060000047327170600000473271PA7218962026-02-09False
17060000047330L17/dossiers1717060000047327170600000473272PA7219082026-02-09False
17060000047331L17/dossiers1717060000047327170600000473273PA5888842026-02-09False
17060000047332L17/dossiers1717060000047327170600000473274PA8417012026-02-09False
17060000047333L17/dossiers1717060000047327170600000473275PA7195582026-02-09False
17060000047334L17/dossiers1717060000047327170600000473276PA7953622026-02-09False
17060000047335L17/dossiers1717060000047327170600000473277PA7954542026-02-09False
17060000047336L17/dossiers1717060000047327170600000473278PA8418852026-02-09False
17060000047337L17/dossiers1717060000047327170600000473279PA8415072026-02-09False
17060000047338L17/dossiers17170600000473271706000004732710PA6065072026-02-09False
17060000047339L17/dossiers17170600000473271706000004732711PA7940942026-02-09False
17060000047340L17/dossiers17170600000473271706000004732712PA7208382026-02-09False
17060000047341L17/dossiers17170600000473271706000004732713PA7936242026-02-09False
17060000047342L17/dossiers17170600000473271706000004732714PA6082642026-02-09False
17060000047343L17/dossiers17170600000473271706000004732715PA7191382026-02-09False
17060000047344L17/dossiers17170600000473271706000004732716PA7958682026-02-09False
17060000047345L17/dossiers17170600000473271706000004732717PA8423112026-02-09False
17060000047346L17/dossiers17170600000473271706000004732718PA7939402026-02-09False
17060000047347L17/dossiers17170600000473271706000004732719PA7940082026-02-09False
17060000047348L17/dossiers17170600000473271706000004732720PA8409032026-02-09False
17060000047349L17/dossiers17170600000473271706000004732721PA7933942026-02-09False