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
17060000037682L17/dossiers17170600000376671706000003766714PA7953182025-05-13False
17060000037683L17/dossiers17170600000376671706000003766715PA8410232025-05-13False
17060000037684L17/dossiers17170600000376671706000003766716PA7960902025-05-13False
17060000037685L17/dossiers17170600000376671706000003766717PA7939122025-05-13False
17060000037686L17/dossiers17170600000376671706000003766718PA8421872025-05-13False
17060000037687L17/dossiers17170600000376671706000003766719PA7918122025-05-13False
17060000037688L17/dossiers17170600000376671706000003766720PA7937362025-05-13False
17060000037689L17/dossiers17170600000376671706000003766721PA7212022025-05-13False
17060000037690L17/dossiers17170600000376671706000003766722PA7951362025-05-13False
17060000037691L17/dossiers17170600000376671706000003766723PA7934642025-05-13False
17060000037692L17/dossiers17170600000376671706000003766724PA8421552025-05-13False
17060000037693L17/dossiers17170600000376671706000003766725PA7952002025-05-13False
17060000037694L17/dossiers17170600000376671706000003766726PA7958442025-05-13False
17060000037695L17/dossiers17170600000376671706000003766727PA8412512025-05-13False
17060000037696L17/dossiers17170600000376671706000003766728PA7947862025-05-13False
17060000037697L17/dossiers17170600000376671706000003766729PA7948702025-05-13False
17060000037698L17/dossiers17170600000376671706000003766730PA7960702025-05-13False
17060000037699L17/dossiers17170600000376671706000003766731PA7953102025-05-13False
17060000037700L17/dossiers17170600000376671706000003766732PA7944782025-05-13False
17060000037701L17/dossiers17170600000376671706000003766733PA8419472025-05-13False
17060000037702L17/dossiers17170600000376671706000003766734PA7940822025-05-13False
17060000037703L17/dossiers17170600000376671706000003766735PA7941302025-05-13False
17060000037704L17/dossiers17170600000376671706000003766736PA7208462025-05-13False
17060000037705L17/dossiers17170600000376671706000003766737PA8417292025-05-13False
17060000037706L17/dossiers17170600000376671706000003766738PA7955162025-05-13False
17060000037707L17/dossiers17170600000376671706000003766739PA7956722025-05-13False
17060000037708L17/dossiers17170600000376671706000003766740PA7957462025-05-13False
17060000037709L17/dossiers17170600000376671706000003766741PA7951082025-05-13False
17060000037710L17/dossiers17170600000376671706000003766742PA8415152025-05-13False
17060000037711L17/dossiers17170600000376671706000003766743PA7952982025-05-13False
17060000037712L17/dossiers17170600000376671706000003766744PA7918242025-05-13False
17060000037713L17/dossiers17170600000376671706000003766745PA8420292025-05-13False
17060000037714L17/dossiers17170600000376671706000003766746PA7935322025-05-13False
17060000037715L17/dossiers17170600000376671706000003766747PA3423842025-05-13False
17060000037716L17/dossiers17170600000376671706000003766748PA7954222025-05-13False
17060000037717L17/dossiers17170600000376671706000003766749PA7946862025-05-13False
17060000037718L17/dossiers17170600000376671706000003766750PA8412152025-05-13False
17060000037719L17/dossiers17170600000376671706000003766751PA7954822025-05-13False
17060000037720L17/dossiers17170600000376671706000003766752PA6106542025-05-13False
17060000037721L17/dossiers17170600000376671706000003766753PA8411912025-05-13False
17060000037722L17/dossiers17170600000376671706000003766754PA7219602025-05-13False
17060000037723L17/dossiers17170600000376671706000003766755PA7938722025-05-13False
17060000037724L17/dossiers17170600000376671706000003766756PA7208922025-05-13False
17060000037725L17/dossiers17170600000376671706000003766757PA8172112025-05-13False
17060000037726L17/dossiers17170600000376671706000003766758PA7937562025-05-13False
17060000037727L17/dossiers17170600000376671706000003766759PA7960622025-05-13False
17060000037728L17/dossiers17170600000376671706000003766760PA7195782025-05-13False
17060000037729L17/dossiers17170600000376671706000003766761PA7210622025-05-13False
17060000037730L17/dossiers17170600000376671706000003766762PA8418452025-05-13False
17060000037731L17/dossiers17170600000376671706000003766763PA7959822025-05-13False