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
17060000025688L17/dossiers171706000002558517060000025585102PA7945822025-03-07False
17060000025689L17/dossiers171706000002558517060000025585103PA7936562025-03-07False
17060000025690L17/dossiers171706000002558517060000025585104PA7959662025-03-07False
17060000025691L17/dossiers171706000002558517060000025585105PA7932302025-03-07False
17060000025692L17/dossiers171706000002558517060000025585106PA7932542025-03-07False
17060000025693L17/dossiers171706000002558517060000025585107PA8419812025-03-07False
17060000025694L17/dossiers171706000002558517060000025585108PA8422272025-03-07False
17060000025695L17/dossiers171706000002558517060000025585109PA7944422025-03-07False
17060000025696L17/dossiers171706000002558517060000025585110PA7954102025-03-07False
17060000025697L17/dossiers171706000002558517060000025585111PA8420972025-03-07False
17060000025698L17/dossiers171706000002558517060000025585112PA7948942025-03-07False
17060000025699L17/dossiers171706000002558517060000025585113PA7945702025-03-07False
17060000025700L17/dossiers171706000002558517060000025585114PA7949542025-03-07False
17060000025701L17/dossiers171706000002558517060000025585115PA7960502025-03-07False
17060000025702L17/dossiers171706000002558517060000025585116PA8417772025-02-142025-03-07False
17060000025703L17/dossiers171706000002558517060000025585117PA8422552025-03-07False
17060000025704L17/dossiers171706000002558517060000025585118PA7933822025-03-07False
17060000025705L17/dossiers171706000002558517060000025585119PA7957782025-03-07False
17060000025706L17/dossiers171706000002558517060000025585120PA7945022025-03-07False
17060000025707L17/dossiers171706000002558517060000025585121PA8415532025-03-07False
17060000025708L17/dossiers171706000002558517060000025585122PA7932982025-03-07False
17060000025709L17/dossiers171706000002558517060000025585123PA8407812025-03-07False
17060000025710L17/dossiers171706000002558517060000025585124PA7949462025-03-07False
17060000025711L17/dossiers171706000002558517060000025585125PA8415752025-03-07False
17060000025712L17/dossiers171706000002558517060000025585126PA8414792025-03-07False
17060000025713L17/dossiers171706000002558517060000025585127PA7944182025-03-07False
17060000025717L17/dossiers1717060000025715170600000257151PA7208922025-02-05False
17060000025718L17/dossiers1717060000025715170600000257152PA7937442025-02-05False
17060000025719L17/dossiers1717060000025715170600000257153PA7937562025-02-05False
17060000025720L17/dossiers1717060000025715170600000257154PA7949062025-02-05False
17060000025721L17/dossiers1717060000025715170600000257155PA7952282025-02-05False
17060000025722L17/dossiers1717060000025715170600000257156PA7932622025-02-05False
17060000025723L17/dossiers1717060000025715170600000257157PA7941382025-02-05False
17060000025724L17/dossiers1717060000025715170600000257158PA7955882025-02-05False
17060000025725L17/dossiers1717060000025715170600000257159PA7950842025-02-05False
17060000025726L17/dossiers17170600000257151706000002571510PA8421052025-02-05False
17060000025727L17/dossiers17170600000257151706000002571511PA8416572025-02-05False
17060000025728L17/dossiers17170600000257151706000002571512PA7204302025-02-05False
17060000025729L17/dossiers17170600000257151706000002571513PA7937722025-02-05False
17060000025730L17/dossiers17170600000257151706000002571514PA7956162025-02-05False
17060000025731L17/dossiers17170600000257151706000002571515PA7934442025-02-05False
17060000025732L17/dossiers17170600000257151706000002571516PA7949382025-02-05False
17060000025733L17/dossiers17170600000257151706000002571517PA7953182025-02-05False
17060000025734L17/dossiers17170600000257151706000002571518PA8410232025-02-05False
17060000025735L17/dossiers17170600000257151706000002571519PA7960902025-02-05False
17060000025736L17/dossiers17170600000257151706000002571520PA7939122025-02-05False
17060000025737L17/dossiers17170600000257151706000002571521PA8421872025-02-05False
17060000025738L17/dossiers17170600000257151706000002571522PA8420372025-02-05False
17060000025739L17/dossiers17170600000257151706000002571523PA7918122025-02-05False
17060000025740L17/dossiers17170600000257151706000002571524PA7937362025-02-05False