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
17060000046534L17/dossiers1717060000046528170600000465285PA7214102025-09-30False
17060000046535L17/dossiers1717060000046528170600000465286PA8421172025-09-30False
17060000046536L17/dossiers1717060000046528170600000465287PA7188842025-09-30False
17060000046537L17/dossiers1717060000046528170600000465288PA6427252025-09-30False
17060000046538L17/dossiers1717060000046528170600000465289PA7949942025-09-30False
17060000046539L17/dossiers17170600000465281706000004652810PA7941782025-09-30False
17060000046540L17/dossiers17170600000465281706000004652811PA3300082025-09-30False
17060000046541L17/dossiers17170600000465281706000004652812PA8700102025-09-30False
17060000046542L17/dossiers17170600000465281706000004652813PA6088262025-09-30False
17060000046543L17/dossiers17170600000465281706000004652814PA6084162025-09-30False
17060000046544L17/dossiers17170600000465281706000004652815PA2668082025-09-30False
17060000046545L17/dossiers17170600000465281706000004652816PA7940582025-09-30False
17060000046546L17/dossiers17170600000465281706000004652817PA16302025-09-30False
17060000046547L17/dossiers17170600000465281706000004652818PA6955122025-09-30False
17060000046548L17/dossiers17170600000465281706000004652819PA3422402025-09-30False
17060000046549L17/dossiers17170600000465281706000004652820PA13272025-09-30False
17060000046550L17/dossiers17170600000465281706000004652821PA3309092025-09-30False
17060000046554L17/dossiers1717060000046552170600000465521PA8408292025-11-03False
17060000046555L17/dossiers1717060000046552170600000465522PA10082025-11-03False
17060000046556L17/dossiers1717060000046552170600000465523PA8413592025-11-03False
17060000046557L17/dossiers1717060000046552170600000465524PA6081722025-11-03False
17060000046558L17/dossiers1717060000046552170600000465525PA8172032025-11-03False
17060000046559L17/dossiers1717060000046552170600000465526PA7938162025-11-03False
17060000046560L17/dossiers1717060000046552170600000465527PA3421962025-11-03False
17060000046561L17/dossiers1717060000046552170600000465528PA6075532025-11-03False
17060000046562L17/dossiers1717060000046552170600000465529PA6431572025-11-03False
17060000046563L17/dossiers17170600000465521706000004655210PA7948542025-11-03False
17060000046564L17/dossiers17170600000465521706000004655211PA7223902025-11-03False
17060000046565L17/dossiers17170600000465521706000004655212PA7942702025-11-03False
17060000046566L17/dossiers17170600000465521706000004655213PA8409552025-11-03False
17060000046567L17/dossiers17170600000465521706000004655214PA8401712025-11-03False
17060000046568L17/dossiers17170600000465521706000004655215PA7952402025-11-03False
17060000046569L17/dossiers17170600000465521706000004655216PA7933422025-11-03False
17060000046570L17/dossiers17170600000465521706000004655217PA7933942025-11-03False
17060000046571L17/dossiers17170600000465521706000004655218PA7749622025-11-03False
17060000046572L17/dossiers17170600000465521706000004655219PA8406732025-11-03False
17060000046573L17/dossiers17170600000465521706000004655220PA8417172025-11-03False
17060000046574L17/dossiers17170600000465521706000004655221PA8422632025-11-03False
17060000046575L17/dossiers17170600000465521706000004655222PA8413812025-11-03False
17060000046576L17/dossiers17170600000465521706000004655223PA6082642025-11-03False
17060000046577L17/dossiers17170600000465521706000004655224PA8418532025-11-03False
17060000046578L17/dossiers17170600000465521706000004655225PA8416812025-11-03False
17060000046579L17/dossiers17170600000465521706000004655226PA15672025-11-03False
17060000046580L17/dossiers17170600000465521706000004655227PA8416652025-11-03False
17060000046581L17/dossiers17170600000465521706000004655228PA2677942025-11-03False
17060000046585L17/dossiers1717060000046583170600000465831PA7961062025-09-30False
17060000046586L17/dossiers1717060000046583170600000465832PA7208382025-09-30False
17060000046587L17/dossiers1717060000046583170600000465833PA7947102025-09-30False
17060000046588L17/dossiers1717060000046583170600000465834PA7958682025-09-30False
17060000046589L17/dossiers1717060000046583170600000465835PA7218962025-09-30False