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
17060000020267L17/dossiers17170600000202311706000002023135PA7936322025-03-20False
17060000020268L17/dossiers17170600000202311706000002023136PA7223742025-03-20False
17060000020269L17/dossiers17170600000202311706000002023137PA7203542025-03-20False
17060000020270L17/dossiers17170600000202311706000002023138PA7197782025-03-20False
17060000020271L17/dossiers17170600000202311706000002023139PA7200382025-03-20False
17060000020272L17/dossiers17170600000202311706000002023140PA7190522025-03-20False
17060000020273L17/dossiers17170600000202311706000002023141PA7192822025-03-20False
17060000020274L17/dossiers17170600000202311706000002023142PA8421252025-03-20False
17060000020275L17/dossiers17170600000202311706000002023143PA7194122025-03-20False
17060000020276L17/dossiers17170600000202311706000002023144PA7944262025-03-20False
17060000020277L17/dossiers17170600000202311706000002023145PA8409792025-03-20False
17060000020278L17/dossiers17170600000202311706000002023146PA7948382025-03-20False
17060000020279L17/dossiers17170600000202311706000002023147PA8416012025-03-20False
17060000020280L17/dossiers17170600000202311706000002023148PA7202302025-03-20False
17060000020281L17/dossiers17170600000202311706000002023149PA7942062025-03-20False
17060000020282L17/dossiers17170600000202311706000002023150PA7933422025-03-20False
17060000020283L17/dossiers17170600000202311706000002023151PA7201462025-03-20False
17060000020284L17/dossiers17170600000202311706000002023152PA8419312025-03-20False
17060000020285L17/dossiers17170600000202311706000002023153PA8410132025-03-20False
17060000020286L17/dossiers17170600000202311706000002023154PA7944662025-03-20False
17060000020287L17/dossiers17170600000202311706000002023155PA7209082025-03-20False
17060000020288L17/dossiers17170600000202311706000002023156PA7214862025-03-20False
17060000020289L17/dossiers17170600000202311706000002023157PA7940382025-03-20False
17060000020290L17/dossiers17170600000202311706000002023158PA7948302025-03-20False
17060000020291L17/dossiers17170600000202311706000002023159PA7951242025-03-20False
17060000020292L17/dossiers17170600000202311706000002023160PA7196322025-03-20False
17060000020293L17/dossiers17170600000202311706000002023161PA7933982025-03-20False
17060000020294L17/dossiers17170600000202311706000002023162PA7212342025-03-20False
17060000020295L17/dossiers17170600000202311706000002023163PA7218442025-03-20False
17060000020296L17/dossiers17170600000202311706000002023164PA7935722025-03-20False
17060000020297L17/dossiers17170600000202311706000002023165PA7195282025-03-20False
17060000020298L17/dossiers17170600000202311706000002023166PA7952702025-03-20False
17060000020299L17/dossiers17170600000202311706000002023167PA7201002025-03-20False
17060000020300L17/dossiers17170600000202311706000002023168PA7205522025-03-20False
17060000020301L17/dossiers17170600000202311706000002023169PA7930942025-03-20False
17060000020302L17/dossiers17170600000202311706000002023170PA7214582025-03-20False
17060000020303L17/dossiers17170600000202311706000002023171PA7932702025-03-20False
17060000020304L17/dossiers17170600000202311706000002023172PA7201382025-03-20False
17060000020305L17/dossiers17170600000202311706000002023173PA7944862025-03-20False
17060000020306L17/dossiers17170600000202311706000002023174PA7223362025-03-20False
17060000020307L17/dossiers17170600000202311706000002023175PA7953502025-03-20False
17060000020308L17/dossiers17170600000202311706000002023176PA7221022025-03-20False
17060000020309L17/dossiers17170600000202311706000002023177PA3315822025-03-20False
17060000020310L17/dossiers17170600000202311706000002023178PA7195122025-03-20False
17060000020311L17/dossiers17170600000202311706000002023179PA7950262025-03-20False
17060000020312L17/dossiers17170600000202311706000002023180PA7214742025-03-20False
17060000020319L17/dossiers1717060000020317170600000203171PA7203862024-12-03False
17060000020323L17/dossiers1717060000020321170600000203211PA7953502024-12-16False
17060000020324L17/dossiers1717060000020321170600000203212PA7214262024-12-16False
17060000020325L17/dossiers1717060000020321170600000203213PA2677802024-12-16False