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
17060000036023L17/dossiers17170600000359561706000003595666PA7957222025-05-23False
17060000036024L17/dossiers17170600000359561706000003595667PA7196322025-05-23False
17060000036025L17/dossiers17170600000359561706000003595668PA7219162025-05-23False
17060000036026L17/dossiers17170600000359561706000003595669PA3357582025-05-23False
17060000036027L17/dossiers17170600000359561706000003595670PA7214262025-05-23False
17060000036028L17/dossiers17170600000359561706000003595671PA7200662025-05-23False
17060000036029L17/dossiers17170600000359561706000003595672PA7222522025-05-23False
17060000036030L17/dossiers17170600000359561706000003595673PA7955282025-05-23False
17060000036031L17/dossiers17170600000359561706000003595674PA8419272025-05-23False
17060000036032L17/dossiers17170600000359561706000003595675PA7958882025-05-23False
17060000036033L17/dossiers17170600000359561706000003595676PA7932702025-05-23False
17060000036034L17/dossiers17170600000359561706000003595677PA7572252025-05-23False
17060000036035L17/dossiers17170600000359561706000003595678PA7934162025-05-23False
17060000036036L17/dossiers17170600000359561706000003595679PA7948022025-05-23False
17060000036037L17/dossiers17170600000359561706000003595680PA7201902025-05-23False
17060000036038L17/dossiers17170600000359561706000003595681PA7944862025-05-23False
17060000036039L17/dossiers17170600000359561706000003595682PA7195502025-05-23False
17060000036040L17/dossiers17170600000359561706000003595683PA7215842025-05-23False
17060000036041L17/dossiers17170600000359561706000003595684PA7959202025-05-23False
17060000036042L17/dossiers17170600000359561706000003595685PA6073952025-05-23False
17060000036043L17/dossiers17170600000359561706000003595686PA7221022025-05-23False
17060000036044L17/dossiers17170600000359561706000003595687PA7195122025-05-23False
17060000036045L17/dossiers17170600000359561706000003595688PA7211702025-05-23False
17060000036046L17/dossiers17170600000359561706000003595689PA29602025-05-23False
17060000036047L17/dossiers17170600000359561706000003595690PA7950462025-05-23False
17060000036051L17/dossiers1717060000036049170600000360491PA8406652025-05-07False
17060000036052L17/dossiers1717060000036049170600000360492PA6109682025-05-07False
17060000036053L17/dossiers1717060000036049170600000360493PA6427642025-05-07False
17060000036054L17/dossiers1717060000036049170600000360494PA8408292025-05-07False
17060000036055L17/dossiers1717060000036049170600000360495PA7203622025-05-07False
17060000036056L17/dossiers1717060000036049170600000360496PA8422112025-05-07False
17060000036057L17/dossiers1717060000036049170600000360497PA7961062025-05-07False
17060000036058L17/dossiers1717060000036049170600000360498PA8413152025-05-07False
17060000036059L17/dossiers1717060000036049170600000360499PA6065072025-05-07False
17060000036060L17/dossiers17170600000360491706000003604910PA7940942025-05-07False
17060000036061L17/dossiers17170600000360491706000003604911PA7208382025-05-07False
17060000036062L17/dossiers17170600000360491706000003604912PA7943302025-05-07False
17060000036063L17/dossiers17170600000360491706000003604913PA7947102025-05-07False
17060000036064L17/dossiers17170600000360491706000003604914PA7957622025-05-07False
17060000036065L17/dossiers17170600000360491706000003604915PA6082642025-05-07False
17060000036066L17/dossiers17170600000360491706000003604916PA7953302025-05-07False
17060000036067L17/dossiers17170600000360491706000003604917PA7191382025-05-07False
17060000036068L17/dossiers17170600000360491706000003604918PA8423112025-05-07False
17060000036069L17/dossiers17170600000360491706000003604919PA7199222025-05-07False
17060000036070L17/dossiers17170600000360491706000003604920PA8409032025-05-07False
17060000036071L17/dossiers17170600000360491706000003604921PA8412952025-05-07False
17060000036072L17/dossiers17170600000360491706000003604922PA10082025-05-07False
17060000036073L17/dossiers17170600000360491706000003604923PA7933942025-05-07False
17060000036074L17/dossiers17170600000360491706000003604924PA7954302025-05-07False
17060000036075L17/dossiers17170600000360491706000003604925PA7949822025-05-07False