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 151 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
17060000015973L17/dossiers17170600000159231706000001592349PA2667972024-10-29False
17060000015974L17/dossiers17170600000159231706000001592350PA7948302024-10-29False
17060000015975L17/dossiers17170600000159231706000001592351PA7951002024-10-29False
17060000015976L17/dossiers17170600000159231706000001592352PA8051662024-10-29False
17060000015980L17/dossiers1717060000015978170600000159781PA7195582025-01-29False
17060000015981L17/dossiers1717060000015978170600000159782PA7220462025-01-29False
17060000015982L17/dossiers1717060000015978170600000159783PA7192182025-01-29False
17060000015983L17/dossiers1717060000015978170600000159784PA7201622025-01-29False
17060000015984L17/dossiers1717060000015978170600000159785PA7943302025-01-29False
17060000015985L17/dossiers1717060000015978170600000159786PA8408172025-01-29False
17060000015986L17/dossiers1717060000015978170600000159787PA7220002025-01-29False
17060000015987L17/dossiers1717060000015978170600000159788PA7953302025-01-29False
17060000015988L17/dossiers1717060000015978170600000159789PA7194722025-01-29False
17060000015989L17/dossiers17170600000159781706000001597810PA7935202025-01-29False
17060000015990L17/dossiers17170600000159781706000001597811PA7949822025-01-29False
17060000015991L17/dossiers17170600000159781706000001597812PA7201542025-01-29False
17060000015992L17/dossiers17170600000159781706000001597813PA6431752025-01-29False
17060000015993L17/dossiers17170600000159781706000001597814PA7946582025-01-29False
17060000015994L17/dossiers17170600000159781706000001597815PA6056942025-01-29False
17060000015995L17/dossiers17170600000159781706000001597816PA7221342025-01-29False
17060000015996L17/dossiers17170600000159781706000001597817PA7223662025-01-29False
17060000015997L17/dossiers17170600000159781706000001597818PA7212962025-01-29False
17060000015998L17/dossiers17170600000159781706000001597819PA8409472025-01-29False
17060000015999L17/dossiers17170600000159781706000001597820PA7223742025-01-29False
17060000016000L17/dossiers17170600000159781706000001597821PA7203542025-01-29False
17060000016001L17/dossiers17170600000159781706000001597822PA6431842025-01-29False
17060000016002L17/dossiers17170600000159781706000001597823PA7200222025-01-29False
17060000016003L17/dossiers17170600000159781706000001597824PA7194122025-01-29False
17060000016004L17/dossiers17170600000159781706000001597825PA3457222025-01-29False
17060000016005L17/dossiers17170600000159781706000001597826PA7193382025-01-29False
17060000016006L17/dossiers17170600000159781706000001597827PA7942062024-11-262025-01-29False
17060000016007L17/dossiers17170600000159781706000001597828PA7951762025-01-29False
17060000016008L17/dossiers17170600000159781706000001597829PA7956642025-01-29False
17060000016009L17/dossiers17170600000159781706000001597830PA6076192025-01-29False
17060000016010L17/dossiers17170600000159781706000001597831PA7948102025-01-29False
17060000016011L17/dossiers17170600000159781706000001597832PA7957222025-01-29False
17060000016012L17/dossiers17170600000159781706000001597833PA7196322025-01-29False
17060000016013L17/dossiers17170600000159781706000001597834PA7937082025-01-29False
17060000016014L17/dossiers17170600000159781706000001597835PA7952402025-01-29False
17060000016015L17/dossiers17170600000159781706000001597836PA7200662025-01-29False
17060000016016L17/dossiers17170600000159781706000001597837PA7222522025-01-29False
17060000016017L17/dossiers17170600000159781706000001597838PA7214582025-01-29False
17060000016018L17/dossiers17170600000159781706000001597839PA7932702025-01-29False
17060000016019L17/dossiers17170600000159781706000001597840PA7944862025-01-29False
17060000016020L17/dossiers17170600000159781706000001597841PA7937962025-01-29False
17060000016021L17/dossiers17170600000159781706000001597842PA7939482025-01-29False
17060000016022L17/dossiers17170600000159781706000001597843PA7953502025-01-29False
17060000016023L17/dossiers17170600000159781706000001597844PA7950262025-01-29False
17060000016027L17/dossiers1717060000016025170600000160251PA7206142025-03-07False
17060000016028L17/dossiers1717060000016025170600000160252PA8410672025-03-07False