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
17060000028354L17/dossiers1717060000028348170600000283485PA7955882025-12-19False
17060000028355L17/dossiers1717060000028348170600000283486PA7950842025-12-19False
17060000028356L17/dossiers1717060000028348170600000283487PA8421052025-12-19False
17060000028357L17/dossiers1717060000028348170600000283488PA8416572025-12-19False
17060000028358L17/dossiers1717060000028348170600000283489PA7204302025-12-19False
17060000028359L17/dossiers17170600000283481706000002834810PA7937722025-12-19False
17060000028360L17/dossiers17170600000283481706000002834811PA7956162025-12-19False
17060000028361L17/dossiers17170600000283481706000002834812PA7934442025-12-19False
17060000028362L17/dossiers17170600000283481706000002834813PA7949382025-12-19False
17060000028363L17/dossiers17170600000283481706000002834814PA7953182025-12-19False
17060000028364L17/dossiers17170600000283481706000002834815PA8410232025-12-19False
17060000028365L17/dossiers17170600000283481706000002834816PA7960902025-12-19False
17060000028366L17/dossiers17170600000283481706000002834817PA7939122025-12-19False
17060000028367L17/dossiers17170600000283481706000002834818PA8421872025-12-19False
17060000028368L17/dossiers17170600000283481706000002834819PA8420372025-12-19False
17060000028369L17/dossiers17170600000283481706000002834820PA7918122025-12-19False
17060000028370L17/dossiers17170600000283481706000002834821PA7937362025-12-19False
17060000028371L17/dossiers17170600000283481706000002834822PA7212022025-12-19False
17060000028372L17/dossiers17170600000283481706000002834823PA7951362025-12-19False
17060000028373L17/dossiers17170600000283481706000002834824PA7934642025-12-19False
17060000028374L17/dossiers17170600000283481706000002834825PA8421552025-12-19False
17060000028375L17/dossiers17170600000283481706000002834826PA7952002025-12-19False
17060000028376L17/dossiers17170600000283481706000002834827PA7958442025-12-19False
17060000028377L17/dossiers17170600000283481706000002834828PA8412512025-12-19False
17060000028378L17/dossiers17170600000283481706000002834829PA7947862025-12-19False
17060000028379L17/dossiers17170600000283481706000002834830PA7948702025-12-19False
17060000028380L17/dossiers17170600000283481706000002834831PA7960702025-12-19False
17060000028381L17/dossiers17170600000283481706000002834832PA7953102025-12-19False
17060000028382L17/dossiers17170600000283481706000002834833PA7944782025-12-19False
17060000028383L17/dossiers17170600000283481706000002834834PA8419472025-12-19False
17060000028384L17/dossiers17170600000283481706000002834835PA7940822025-12-19False
17060000028385L17/dossiers17170600000283481706000002834836PA7941302025-12-19False
17060000028386L17/dossiers17170600000283481706000002834837PA7208462025-12-19False
17060000028387L17/dossiers17170600000283481706000002834838PA8417292025-12-19False
17060000028388L17/dossiers17170600000283481706000002834839PA7955162025-12-19False
17060000028389L17/dossiers17170600000283481706000002834840PA7956722025-12-19False
17060000028390L17/dossiers17170600000283481706000002834841PA7957462025-12-19False
17060000028391L17/dossiers17170600000283481706000002834842PA7951082025-12-19False
17060000028392L17/dossiers17170600000283481706000002834843PA8415152025-12-19False
17060000028393L17/dossiers17170600000283481706000002834844PA7952982025-12-19False
17060000028394L17/dossiers17170600000283481706000002834845PA7918242025-12-19False
17060000028395L17/dossiers17170600000283481706000002834846PA8420292025-12-19False
17060000028396L17/dossiers17170600000283481706000002834847PA7935322025-12-19False
17060000028397L17/dossiers17170600000283481706000002834848PA3423842025-12-19False
17060000028398L17/dossiers17170600000283481706000002834849PA7954222025-12-19False
17060000028399L17/dossiers17170600000283481706000002834850PA8412152025-12-19False
17060000028400L17/dossiers17170600000283481706000002834851PA7954822025-12-19False
17060000028401L17/dossiers17170600000283481706000002834852PA6106542025-12-19False
17060000028402L17/dossiers17170600000283481706000002834853PA8411912025-12-19False
17060000028403L17/dossiers17170600000283481706000002834854PA7219602025-12-19False