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
17060000034006L17/dossiers1717060000034001170600000340014PA3300082025-05-06False
17060000034007L17/dossiers1717060000034001170600000340015PA7935082025-05-06False
17060000034008L17/dossiers1717060000034001170600000340016PA7223902025-05-06False
17060000034009L17/dossiers1717060000034001170600000340017PA3309092025-05-06False
17060000034010L17/dossiers1717060000034001170600000340018PA7940422025-05-06False
17060000034011L17/dossiers1717060000034001170600000340019PA6088262025-05-06False
17060000034012L17/dossiers17170600000340011706000003400110PA16302025-05-06False
17060000034013L17/dossiers17170600000340011706000003400111PA6084162025-05-06False
17060000034014L17/dossiers17170600000340011706000003400112PA8421172025-05-06False
17060000034015L17/dossiers17170600000340011706000003400113PA8409792025-05-06False
17060000034016L17/dossiers17170600000340011706000003400114PA6427252025-05-06False
17060000034017L17/dossiers17170600000340011706000003400115PA7947502025-05-06False
17060000034018L17/dossiers17170600000340011706000003400116PA8421412025-05-06False
17060000034019L17/dossiers17170600000340011706000003400117PA7214422025-04-172025-05-06False
17060000034020L17/dossiers17170600000340011706000003400118PA7930942025-05-06False
17060000034024L17/dossiers1717060000034022170600000340221PA8420452026-03-30False
17060000034025L17/dossiers1717060000034022170600000340222PA7950762026-03-30False
17060000034029L17/dossiers1717060000034027170600000340271PA7950102026-03-30False
17060000034030L17/dossiers1717060000034027170600000340272PA8420452026-03-30False
17060000034031L17/dossiers1717060000034027170600000340273PA7950762026-03-30False
17060000034035L17/dossiers1717060000034033170600000340331PA7208922025-05-07False
17060000034036L17/dossiers1717060000034033170600000340332PA7952282025-05-07False
17060000034037L17/dossiers1717060000034033170600000340333PA7932622025-05-07False
17060000034038L17/dossiers1717060000034033170600000340334PA7949062025-05-07False
17060000034039L17/dossiers1717060000034033170600000340335PA7941382025-05-07False
17060000034040L17/dossiers1717060000034033170600000340336PA7955882025-05-07False
17060000034041L17/dossiers1717060000034033170600000340337PA7950842025-05-07False
17060000034042L17/dossiers1717060000034033170600000340338PA8421052025-05-07False
17060000034043L17/dossiers1717060000034033170600000340339PA8416572025-05-07False
17060000034044L17/dossiers17170600000340331706000003403310PA7204302025-05-07False
17060000034045L17/dossiers17170600000340331706000003403311PA7937722025-05-07False
17060000034046L17/dossiers17170600000340331706000003403312PA7956162025-05-07False
17060000034047L17/dossiers17170600000340331706000003403313PA7934442025-05-07False
17060000034048L17/dossiers17170600000340331706000003403314PA7949382025-05-07False
17060000034049L17/dossiers17170600000340331706000003403315PA7953182025-05-07False
17060000034050L17/dossiers17170600000340331706000003403316PA8410232025-05-07False
17060000034051L17/dossiers17170600000340331706000003403317PA7960902025-05-07False
17060000034052L17/dossiers17170600000340331706000003403318PA7939122025-05-07False
17060000034053L17/dossiers17170600000340331706000003403319PA8421872025-05-07False
17060000034054L17/dossiers17170600000340331706000003403320PA8420372025-05-07False
17060000034055L17/dossiers17170600000340331706000003403321PA7918122025-05-07False
17060000034056L17/dossiers17170600000340331706000003403322PA7937362025-05-07False
17060000034057L17/dossiers17170600000340331706000003403323PA7951362025-05-07False
17060000034058L17/dossiers17170600000340331706000003403324PA7934642025-05-07False
17060000034059L17/dossiers17170600000340331706000003403325PA8421552025-05-07False
17060000034060L17/dossiers17170600000340331706000003403326PA7952002025-05-07False
17060000034061L17/dossiers17170600000340331706000003403327PA7958442025-05-07False
17060000034062L17/dossiers17170600000340331706000003403328PA8412512025-05-07False
17060000034063L17/dossiers17170600000340331706000003403329PA7947862025-05-07False
17060000034064L17/dossiers17170600000340331706000003403330PA7948702025-05-07False