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
17060000050975L17/dossiers17170600000508911706000005089183PA8414792025-11-21False
17060000050976L17/dossiers17170600000508911706000005089184PA7939042025-11-21False
17060000050980L17/dossiers1717060000050978170600000509781PA7951442025-12-15False
17060000050981L17/dossiers1717060000050978170600000509782PA6428472025-12-15False
17060000050982L17/dossiers1717060000050978170600000509783PA7201622025-12-15False
17060000050983L17/dossiers1717060000050978170600000509784PA6426952025-12-15False
17060000050984L17/dossiers1717060000050978170600000509785PA7940942025-12-15False
17060000050985L17/dossiers1717060000050978170600000509786PA7190322025-12-15False
17060000050986L17/dossiers1717060000050978170600000509787PA7943302025-12-15False
17060000050987L17/dossiers1717060000050978170600000509788PA7198902025-12-15False
17060000050988L17/dossiers1717060000050978170600000509789PA8408172025-12-15False
17060000050989L17/dossiers17170600000509781706000005097810PA7220002025-12-15False
17060000050990L17/dossiers17170600000509781706000005097811PA7947982025-12-15False
17060000050991L17/dossiers17170600000509781706000005097812PA7217502025-12-15False
17060000050992L17/dossiers17170600000509781706000005097813PA8423112025-12-15False
17060000050993L17/dossiers17170600000509781706000005097814PA7958642025-12-15False
17060000050994L17/dossiers17170600000509781706000005097815PA7959082025-12-15False
17060000050995L17/dossiers17170600000509781706000005097816PA7954022025-12-15False
17060000050996L17/dossiers17170600000509781706000005097817PA7191182025-12-15False
17060000050997L17/dossiers17170600000509781706000005097818PA7223902025-12-15False
17060000050998L17/dossiers17170600000509781706000005097819PA8412952025-12-15False
17060000050999L17/dossiers17170600000509781706000005097820PA7931222025-12-15False
17060000051000L17/dossiers17170600000509781706000005097821PA6065732025-12-15False
17060000051001L17/dossiers17170600000509781706000005097822PA7201542025-12-15False
17060000051002L17/dossiers17170600000509781706000005097823PA6088262025-12-15False
17060000051003L17/dossiers17170600000509781706000005097824PA6431752025-12-15False
17060000051004L17/dossiers17170600000509781706000005097825PA8421952025-12-15False
17060000051005L17/dossiers17170600000509781706000005097826PA7221342025-12-15False
17060000051006L17/dossiers17170600000509781706000005097827PA7223662025-12-15False
17060000051007L17/dossiers17170600000509781706000005097828PA7210242025-12-15False
17060000051008L17/dossiers17170600000509781706000005097829PA7942342025-12-15False
17060000051009L17/dossiers17170600000509781706000005097830PA7212962025-12-15False
17060000051010L17/dossiers17170600000509781706000005097831PA7217642025-12-15False
17060000051011L17/dossiers17170600000509781706000005097832PA8401712025-12-15False
17060000051012L17/dossiers17170600000509781706000005097833PA8414712025-12-15False
17060000051013L17/dossiers17170600000509781706000005097834PA7221502025-12-15False
17060000051014L17/dossiers17170600000509781706000005097835PA2672002025-12-15False
17060000051015L17/dossiers17170600000509781706000005097836PA7203542025-12-15False
17060000051016L17/dossiers17170600000509781706000005097837PA7951562025-12-15False
17060000051017L17/dossiers17170600000509781706000005097838PA7953902025-12-15False
17060000051018L17/dossiers17170600000509781706000005097839PA8421252025-12-15False
17060000051019L17/dossiers17170600000509781706000005097840PA7200222025-12-15False
17060000051020L17/dossiers17170600000509781706000005097841PA3457222025-12-15False
17060000051021L17/dossiers17170600000509781706000005097842PA7203422025-12-15False
17060000051022L17/dossiers17170600000509781706000005097843PA7120142025-12-15False
17060000051023L17/dossiers17170600000509781706000005097844PA8409792025-12-15False
17060000051024L17/dossiers17170600000509781706000005097845PA7173792025-12-15False
17060000051025L17/dossiers17170600000509781706000005097846PA8421412025-12-15False
17060000051026L17/dossiers17170600000509781706000005097847PA7957302025-12-15False
17060000051027L17/dossiers17170600000509781706000005097848PA7942062025-12-15False