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
17060000017048L17/dossiers17170600000170071706000001700740PA8407652024-10-29False
17060000017049L17/dossiers17170600000170071706000001700741PA8414632024-10-29False
17060000017050L17/dossiers17170600000170071706000001700742PA6431572024-10-29False
17060000017051L17/dossiers17170600000170071706000001700743PA8411072024-10-29False
17060000017052L17/dossiers17170600000170071706000001700744PA8413812024-10-29False
17060000017053L17/dossiers17170600000170071706000001700745PA8407932024-10-29False
17060000017054L17/dossiers17170600000170071706000001700746PA7942702024-10-29False
17060000017055L17/dossiers17170600000170071706000001700747PA6081722024-10-29False
17060000017056L17/dossiers17170600000170071706000001700748PA6075532024-10-29False
17060000017057L17/dossiers17170600000170071706000001700749PA8409552024-10-29False
17060000017058L17/dossiers17170600000170071706000001700750PA8413672024-10-29False
17060000017059L17/dossiers17170600000170071706000001700751PA3419812024-10-29False
17060000017060L17/dossiers17170600000170071706000001700752PA8406732024-10-29False
17060000017061L17/dossiers17170600000170071706000001700753PA3421962024-10-29False
17060000017062L17/dossiers17170600000170071706000001700754PA8266352024-10-29False
17060000017063L17/dossiers17170600000170071706000001700755PA8413272024-10-29False
17060000017064L17/dossiers17170600000170071706000001700756PA8417172024-10-29False
17060000017065L17/dossiers17170600000170071706000001700757PA8412432024-10-29False
17060000017066L17/dossiers17170600000170071706000001700758PA7749602024-10-29False
17060000017067L17/dossiers17170600000170071706000001700759PA3403432024-10-29False
17060000017068L17/dossiers17170600000170071706000001700760PA8410912024-10-29False
17060000017069L17/dossiers17170600000170071706000001700761PA8416812024-10-29False
17060000017070L17/dossiers17170600000170071706000001700762PA8418932024-10-29False
17060000017071L17/dossiers17170600000170071706000001700763PA7938162024-10-29False
17060000017072L17/dossiers17170600000170071706000001700764PA7944942024-10-29False
17060000017073L17/dossiers17170600000170071706000001700765PA7209922024-10-29False
17060000017077L17/dossiers1717060000017075170600000170751PA16542024-10-29False
17060000017078L17/dossiers1717060000017075170600000170752PA6431922024-10-29False
17060000017079L17/dossiers1717060000017075170600000170753PA3350542024-10-29False
17060000017080L17/dossiers1717060000017075170600000170754PA7749582024-10-29False
17060000017081L17/dossiers1717060000017075170600000170755PA8407652024-10-29False
17060000017082L17/dossiers1717060000017075170600000170756PA8414632024-10-29False
17060000017083L17/dossiers1717060000017075170600000170757PA6431572024-10-29False
17060000017084L17/dossiers1717060000017075170600000170758PA8411072024-10-29False
17060000017085L17/dossiers1717060000017075170600000170759PA8413812024-10-29False
17060000017086L17/dossiers17170600000170751706000001707510PA8407932024-10-29False
17060000017087L17/dossiers17170600000170751706000001707511PA7942702024-10-29False
17060000017088L17/dossiers17170600000170751706000001707512PA6081722024-10-29False
17060000017089L17/dossiers17170600000170751706000001707513PA6075532024-10-29False
17060000017090L17/dossiers17170600000170751706000001707514PA8409552024-10-29False
17060000017091L17/dossiers17170600000170751706000001707515PA3419812024-10-29False
17060000017092L17/dossiers17170600000170751706000001707516PA8406732024-10-29False
17060000017093L17/dossiers17170600000170751706000001707517PA8266352024-10-29False
17060000017094L17/dossiers17170600000170751706000001707518PA8413272024-10-29False
17060000017095L17/dossiers17170600000170751706000001707519PA8417172024-10-29False
17060000017096L17/dossiers17170600000170751706000001707520PA8412432024-10-29False
17060000017097L17/dossiers17170600000170751706000001707521PA7749602024-10-29False
17060000017098L17/dossiers17170600000170751706000001707522PA3403432024-10-29False
17060000017099L17/dossiers17170600000170751706000001707523PA8410912024-10-29False
17060000017100L17/dossiers17170600000170751706000001707524PA8416812024-10-29False