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
17060000015029L17/dossiers1717060000015019170600000150199PA7221342025-04-30False
17060000015030L17/dossiers17170600000150191706000001501910PA8402352025-04-30False
17060000015031L17/dossiers17170600000150191706000001501911PA2673182025-04-30False
17060000015032L17/dossiers17170600000150191706000001501912PA7200382025-04-30False
17060000015033L17/dossiers17170600000150191706000001501913PA7947022025-04-30False
17060000015034L17/dossiers17170600000150191706000001501914PA7948102025-04-30False
17060000015035L17/dossiers17170600000150191706000001501915PA7212342025-04-30False
17060000015036L17/dossiers17170600000150191706000001501916PA7214582025-04-30False
17060000015037L17/dossiers17170600000150191706000001501917PA7932702025-04-30False
17060000015038L17/dossiers17170600000150191706000001501918PA7944862025-04-30False
17060000015039L17/dossiers17170600000150191706000001501919PA7959202025-04-30False
17060000015040L17/dossiers17170600000150191706000001501920PA7221022025-04-30False
17060000015041L17/dossiers17170600000150191706000001501921PA7950262025-04-30False
17060000015042L17/dossiers17170600000150191706000001501922PA7223362025-04-30False
17060000015043L17/dossiers17170600000150191706000001501923PA7196322025-04-30False
17060000015044L17/dossiers17170600000150191706000001501924PA7942062025-04-30False
17060000015045L17/dossiers17170600000150191706000001501925PA7190242025-04-30False
17060000015046L17/dossiers17170600000150191706000001501926PA7214262025-04-30False
17060000015047L17/dossiers17170600000150191706000001501927PA7960102025-04-30False
17060000015048L17/dossiers17170600000150191706000001501928PA7211102025-04-30False
17060000015049L17/dossiers17170600000150191706000001501929PA2677802025-04-30False
17060000015050L17/dossiers17170600000150191706000001501930PA8418012025-04-30False
17060000015051L17/dossiers17170600000150191706000001501931PA8416012025-04-30False
17060000015052L17/dossiers17170600000150191706000001501932PA7940582025-04-30False
17060000015053L17/dossiers17170600000150191706000001501933PA2677632025-04-30False
17060000015054L17/dossiers17170600000150191706000001501934PA7945542025-04-30False
17060000015055L17/dossiers17170600000150191706000001501935PA6431842025-04-30False
17060000015056L17/dossiers17170600000150191706000001501936PA7937082025-04-30False
17060000015057L17/dossiers17170600000150191706000001501937PA8419312025-04-30False
17060000015058L17/dossiers17170600000150191706000001501938PA7201902025-04-30False
17060000015059L17/dossiers17170600000150191706000001501939PA7935722025-04-30False
17060000015060L17/dossiers17170600000150191706000001501940PA7212702025-04-30False
17060000015061L17/dossiers17170600000150191706000001501941PA7944662025-04-30False
17060000015062L17/dossiers17170600000150191706000001501942PA6872142025-04-30False
17060000015063L17/dossiers17170600000150191706000001501943PA7223662025-04-30False
17060000015064L17/dossiers17170600000150191706000001501944PA2672002025-04-30False
17060000015065L17/dossiers17170600000150191706000001501945PA7195502025-04-30False
17060000015066L17/dossiers17170600000150191706000001501946PA8417092025-04-30False
17060000015067L17/dossiers17170600000150191706000001501947PA7171612025-04-30False
17060000015068L17/dossiers17170600000150191706000001501948PA7210042025-04-30False
17060000015069L17/dossiers17170600000150191706000001501949PA7173792025-04-30False
17060000015070L17/dossiers17170600000150191706000001501950PA7957302025-04-30False
17060000015071L17/dossiers17170600000150191706000001501951PA8407132025-04-30False
17060000015072L17/dossiers17170600000150191706000001501952PA6426952025-04-30False
17060000015073L17/dossiers17170600000150191706000001501953PA7191182025-04-30False
17060000015074L17/dossiers17170600000150191706000001501954PA7217642025-04-30False
17060000015075L17/dossiers17170600000150191706000001501955PA3357582025-04-30False
17060000015076L17/dossiers17170600000150191706000001501956PA7203422025-04-30False
17060000015077L17/dossiers17170600000150191706000001501957PA7195122025-04-30False
17060000015078L17/dossiers17170600000150191706000001501958PA6073952025-04-30False