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
17060000050330L17/dossiers1717060000050326170600000503263PA7932462025-11-18False
17060000050334L17/dossiers1717060000050332170600000503321PA7211582026-01-21False
17060000050335L17/dossiers1717060000050332170600000503322PA7951442026-01-21False
17060000050336L17/dossiers1717060000050332170600000503323PA7221902026-01-21False
17060000050337L17/dossiers1717060000050332170600000503324PA6429352026-01-21False
17060000050338L17/dossiers1717060000050332170600000503325PA7192182026-01-21False
17060000050339L17/dossiers1717060000050332170600000503326PA7171612026-01-21False
17060000050340L17/dossiers1717060000050332170600000503327PA6426952026-01-21False
17060000050341L17/dossiers1717060000050332170600000503328PA6065072026-01-21False
17060000050342L17/dossiers1717060000050332170600000503329PA7943302026-01-21False
17060000050343L17/dossiers17170600000503321706000005033210PA7198902026-01-21False
17060000050344L17/dossiers17170600000503321706000005033211PA7220002026-01-21False
17060000050345L17/dossiers17170600000503321706000005033212PA7947982026-01-21False
17060000050346L17/dossiers17170600000503321706000005033213PA7217502026-01-21False
17060000050347L17/dossiers17170600000503321706000005033214PA8423112026-01-21False
17060000050348L17/dossiers17170600000503321706000005033215PA7199222026-01-21False
17060000050349L17/dossiers17170600000503321706000005033216PA7939402026-01-21False
17060000050350L17/dossiers17170600000503321706000005033217PA7194722026-01-21False
17060000050351L17/dossiers17170600000503321706000005033218PA7958642026-01-21False
17060000050352L17/dossiers17170600000503321706000005033219PA7959082026-01-21False
17060000050353L17/dossiers17170600000503321706000005033220PA7954022026-01-21False
17060000050354L17/dossiers17170600000503321706000005033221PA7191182026-01-21False
17060000050355L17/dossiers17170600000503321706000005033222PA7949822026-01-21False
17060000050356L17/dossiers17170600000503321706000005033223PA7223822026-01-21False
17060000050357L17/dossiers17170600000503321706000005033224PA7201542026-01-21False
17060000050358L17/dossiers17170600000503321706000005033225PA7958842026-01-21False
17060000050359L17/dossiers17170600000503321706000005033226PA7221342026-01-21False
17060000050360L17/dossiers17170600000503321706000005033227PA8402352026-01-21False
17060000050361L17/dossiers17170600000503321706000005033228PA7223662026-01-21False
17060000050362L17/dossiers17170600000503321706000005033229PA7197362026-01-21False
17060000050363L17/dossiers17170600000503321706000005033230PA7223582026-01-21False
17060000050364L17/dossiers17170600000503321706000005033231PA7210242026-01-21False
17060000050365L17/dossiers17170600000503321706000005033232PA7186742026-01-21False
17060000050366L17/dossiers17170600000503321706000005033233PA7212962026-01-21False
17060000050367L17/dossiers17170600000503321706000005033234PA2672002026-01-21False
17060000050368L17/dossiers17170600000503321706000005033235PA7959542026-01-21False
17060000050369L17/dossiers17170600000503321706000005033236PA7203542026-01-21False
17060000050370L17/dossiers17170600000503321706000005033237PA7193722026-01-21False
17060000050371L17/dossiers17170600000503321706000005033238PA6431842026-01-21False
17060000050372L17/dossiers17170600000503321706000005033239PA7197982026-01-21False
17060000050373L17/dossiers17170600000503321706000005033240PA7210042026-01-21False
17060000050374L17/dossiers17170600000503321706000005033241PA7953902026-01-21False
17060000050375L17/dossiers17170600000503321706000005033242PA7953342026-01-21False
17060000050376L17/dossiers17170600000503321706000005033243PA7200222026-01-21False
17060000050377L17/dossiers17170600000503321706000005033244PA7194122026-01-21False
17060000050378L17/dossiers17170600000503321706000005033245PA7194042026-01-21False
17060000050379L17/dossiers17170600000503321706000005033246PA3457222026-01-21False
17060000050380L17/dossiers17170600000503321706000005033247PA7193882026-01-21False
17060000050381L17/dossiers17170600000503321706000005033248PA7197562026-01-21False
17060000050382L17/dossiers17170600000503321706000005033249PA7203422026-01-21False