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
17060000032035L17/dossiers17170600000320171706000003201717PA7960902025-03-28False
17060000032036L17/dossiers17170600000320171706000003201718PA7939122025-03-28False
17060000032037L17/dossiers17170600000320171706000003201719PA8421872025-03-28False
17060000032038L17/dossiers17170600000320171706000003201720PA8420372025-03-28False
17060000032039L17/dossiers17170600000320171706000003201721PA7918122025-03-28False
17060000032040L17/dossiers17170600000320171706000003201722PA7937362025-03-28False
17060000032041L17/dossiers17170600000320171706000003201723PA7212022025-03-28False
17060000032042L17/dossiers17170600000320171706000003201724PA7951362025-03-28False
17060000032043L17/dossiers17170600000320171706000003201725PA7934642025-03-28False
17060000032044L17/dossiers17170600000320171706000003201726PA8421552025-03-28False
17060000032045L17/dossiers17170600000320171706000003201727PA7952002025-03-28False
17060000032046L17/dossiers17170600000320171706000003201728PA7958442025-03-28False
17060000032047L17/dossiers17170600000320171706000003201729PA8412512025-03-28False
17060000032048L17/dossiers17170600000320171706000003201730PA7947862025-03-28False
17060000032049L17/dossiers17170600000320171706000003201731PA7948702025-03-28False
17060000032050L17/dossiers17170600000320171706000003201732PA7960702025-03-28False
17060000032051L17/dossiers17170600000320171706000003201733PA7953102025-03-28False
17060000032052L17/dossiers17170600000320171706000003201734PA7944782025-03-28False
17060000032053L17/dossiers17170600000320171706000003201735PA8419472025-03-28False
17060000032054L17/dossiers17170600000320171706000003201736PA7940822025-03-28False
17060000032055L17/dossiers17170600000320171706000003201737PA7941302025-03-28False
17060000032056L17/dossiers17170600000320171706000003201738PA7208462025-03-28False
17060000032057L17/dossiers17170600000320171706000003201739PA8417292025-03-28False
17060000032058L17/dossiers17170600000320171706000003201740PA7955162025-03-28False
17060000032059L17/dossiers17170600000320171706000003201741PA7956722025-03-28False
17060000032060L17/dossiers17170600000320171706000003201742PA7957462025-03-28False
17060000032061L17/dossiers17170600000320171706000003201743PA8415152025-03-28False
17060000032062L17/dossiers17170600000320171706000003201744PA7952982025-03-28False
17060000032063L17/dossiers17170600000320171706000003201745PA7918242025-03-28False
17060000032064L17/dossiers17170600000320171706000003201746PA8420292025-03-28False
17060000032065L17/dossiers17170600000320171706000003201747PA7935322025-03-28False
17060000032066L17/dossiers17170600000320171706000003201748PA3423842025-03-28False
17060000032067L17/dossiers17170600000320171706000003201749PA7954222025-03-28False
17060000032068L17/dossiers17170600000320171706000003201750PA7946862025-03-28False
17060000032069L17/dossiers17170600000320171706000003201751PA8412152025-03-28False
17060000032070L17/dossiers17170600000320171706000003201752PA7954822025-03-28False
17060000032071L17/dossiers17170600000320171706000003201753PA6106542025-03-28False
17060000032072L17/dossiers17170600000320171706000003201754PA8411912025-03-28False
17060000032073L17/dossiers17170600000320171706000003201755PA7219602025-03-28False
17060000032074L17/dossiers17170600000320171706000003201756PA7938722025-03-28False
17060000032075L17/dossiers17170600000320171706000003201757PA8172112025-03-28False
17060000032076L17/dossiers17170600000320171706000003201758PA7937562025-03-28False
17060000032077L17/dossiers17170600000320171706000003201759PA7960622025-03-28False
17060000032078L17/dossiers17170600000320171706000003201760PA7195782025-03-28False
17060000032079L17/dossiers17170600000320171706000003201761PA7210622025-03-28False
17060000032080L17/dossiers17170600000320171706000003201762PA8418452025-03-28False
17060000032081L17/dossiers17170600000320171706000003201763PA7959822025-03-28False
17060000032082L17/dossiers17170600000320171706000003201764PA7954662025-03-28False
17060000032083L17/dossiers17170600000320171706000003201765PA7937442025-03-28False
17060000032084L17/dossiers17170600000320171706000003201766PA7209522025-03-28False