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
17060000042217L17/dossiers1717060000042209170600000422097PA7932622025-09-11False
17060000042218L17/dossiers1717060000042209170600000422098PA7949062025-09-11False
17060000042219L17/dossiers1717060000042209170600000422099PA7941382025-09-11False
17060000042220L17/dossiers17170600000422091706000004220910PA7955882025-09-11False
17060000042221L17/dossiers17170600000422091706000004220911PA7950842025-09-11False
17060000042222L17/dossiers17170600000422091706000004220912PA8421052025-09-11False
17060000042223L17/dossiers17170600000422091706000004220913PA8416572025-09-11False
17060000042224L17/dossiers17170600000422091706000004220914PA7204302025-09-11False
17060000042225L17/dossiers17170600000422091706000004220915PA7937722025-09-11False
17060000042226L17/dossiers17170600000422091706000004220916PA7956162025-09-11False
17060000042227L17/dossiers17170600000422091706000004220917PA7934442025-09-11False
17060000042228L17/dossiers17170600000422091706000004220918PA7949382025-09-11False
17060000042229L17/dossiers17170600000422091706000004220919PA8410232025-09-11False
17060000042230L17/dossiers17170600000422091706000004220920PA7960902025-09-11False
17060000042231L17/dossiers17170600000422091706000004220921PA7939122025-09-11False
17060000042232L17/dossiers17170600000422091706000004220922PA8420372025-09-11False
17060000042233L17/dossiers17170600000422091706000004220923PA7918122025-09-11False
17060000042234L17/dossiers17170600000422091706000004220924PA7937362025-09-11False
17060000042235L17/dossiers17170600000422091706000004220925PA7212022025-09-11False
17060000042236L17/dossiers17170600000422091706000004220926PA7951362025-09-11False
17060000042237L17/dossiers17170600000422091706000004220927PA7934642025-09-11False
17060000042238L17/dossiers17170600000422091706000004220928PA8421552025-09-11False
17060000042239L17/dossiers17170600000422091706000004220929PA7952002025-09-11False
17060000042240L17/dossiers17170600000422091706000004220930PA7958442025-09-11False
17060000042241L17/dossiers17170600000422091706000004220931PA8412512025-09-11False
17060000042242L17/dossiers17170600000422091706000004220932PA7947862025-09-11False
17060000042243L17/dossiers17170600000422091706000004220933PA7948702025-09-11False
17060000042244L17/dossiers17170600000422091706000004220934PA7960702025-09-11False
17060000042245L17/dossiers17170600000422091706000004220935PA7953102025-09-11False
17060000042246L17/dossiers17170600000422091706000004220936PA7944782025-09-11False
17060000042247L17/dossiers17170600000422091706000004220937PA8419472025-09-11False
17060000042248L17/dossiers17170600000422091706000004220938PA7940822025-09-11False
17060000042249L17/dossiers17170600000422091706000004220939PA7941302025-09-11False
17060000042250L17/dossiers17170600000422091706000004220940PA7208462025-09-11False
17060000042251L17/dossiers17170600000422091706000004220941PA8417292025-09-11False
17060000042252L17/dossiers17170600000422091706000004220942PA7955162025-09-11False
17060000042253L17/dossiers17170600000422091706000004220943PA7956722025-09-11False
17060000042254L17/dossiers17170600000422091706000004220944PA7957462025-09-11False
17060000042255L17/dossiers17170600000422091706000004220945PA8415152025-09-11False
17060000042256L17/dossiers17170600000422091706000004220946PA7952982025-09-11False
17060000042257L17/dossiers17170600000422091706000004220947PA8420292025-09-11False
17060000042258L17/dossiers17170600000422091706000004220948PA7935322025-09-11False
17060000042259L17/dossiers17170600000422091706000004220949PA3423842025-09-11False
17060000042260L17/dossiers17170600000422091706000004220950PA7954222025-09-11False
17060000042261L17/dossiers17170600000422091706000004220951PA7946862025-09-11False
17060000042262L17/dossiers17170600000422091706000004220952PA8412152025-09-11False
17060000042263L17/dossiers17170600000422091706000004220953PA7954822025-09-11False
17060000042264L17/dossiers17170600000422091706000004220954PA6106542025-09-11False
17060000042265L17/dossiers17170600000422091706000004220955PA8411912025-09-11False
17060000042266L17/dossiers17170600000422091706000004220956PA7219602025-09-11False