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
17060000020164L17/dossiers17170600000201531706000002015310PA7950842024-12-03False
17060000020165L17/dossiers17170600000201531706000002015311PA8421052024-12-03False
17060000020166L17/dossiers17170600000201531706000002015312PA8416572024-12-03False
17060000020167L17/dossiers17170600000201531706000002015313PA7204302024-12-03False
17060000020168L17/dossiers17170600000201531706000002015314PA7937722024-12-03False
17060000020169L17/dossiers17170600000201531706000002015315PA7956162024-12-03False
17060000020170L17/dossiers17170600000201531706000002015316PA7934442024-12-03False
17060000020171L17/dossiers17170600000201531706000002015317PA7949382024-12-03False
17060000020172L17/dossiers17170600000201531706000002015318PA7953182024-12-03False
17060000020173L17/dossiers17170600000201531706000002015319PA8410232024-12-03False
17060000020174L17/dossiers17170600000201531706000002015320PA7960902024-12-03False
17060000020175L17/dossiers17170600000201531706000002015321PA7939122024-12-03False
17060000020176L17/dossiers17170600000201531706000002015322PA7958682024-12-03False
17060000020177L17/dossiers17170600000201531706000002015323PA8421872024-12-03False
17060000020178L17/dossiers17170600000201531706000002015324PA8420372024-12-03False
17060000020179L17/dossiers17170600000201531706000002015325PA7918122024-12-03False
17060000020180L17/dossiers17170600000201531706000002015326PA7937362024-12-03False
17060000020181L17/dossiers17170600000201531706000002015327PA7212022024-12-03False
17060000020182L17/dossiers17170600000201531706000002015328PA7951362024-12-03False
17060000020183L17/dossiers17170600000201531706000002015329PA7934642024-12-03False
17060000020184L17/dossiers17170600000201531706000002015330PA8421552024-12-03False
17060000020185L17/dossiers17170600000201531706000002015331PA7952002024-12-03False
17060000020186L17/dossiers17170600000201531706000002015332PA7958442024-12-03False
17060000020187L17/dossiers17170600000201531706000002015333PA8412512024-12-03False
17060000020188L17/dossiers17170600000201531706000002015334PA7947862024-12-03False
17060000020189L17/dossiers17170600000201531706000002015335PA7948702024-12-03False
17060000020190L17/dossiers17170600000201531706000002015336PA7960702024-12-03False
17060000020191L17/dossiers17170600000201531706000002015337PA7953102024-12-03False
17060000020192L17/dossiers17170600000201531706000002015338PA7944782024-12-03False
17060000020193L17/dossiers17170600000201531706000002015339PA8419472024-12-03False
17060000020194L17/dossiers17170600000201531706000002015340PA7940822024-12-03False
17060000020195L17/dossiers17170600000201531706000002015341PA7941302024-12-03False
17060000020196L17/dossiers17170600000201531706000002015342PA7208462024-12-03False
17060000020197L17/dossiers17170600000201531706000002015343PA8417292024-12-03False
17060000020198L17/dossiers17170600000201531706000002015344PA7955162024-12-03False
17060000020199L17/dossiers17170600000201531706000002015345PA7956722024-12-03False
17060000020200L17/dossiers17170600000201531706000002015346PA7957462024-12-03False
17060000020201L17/dossiers17170600000201531706000002015347PA7951082024-12-03False
17060000020202L17/dossiers17170600000201531706000002015348PA8415152024-12-03False
17060000020203L17/dossiers17170600000201531706000002015349PA7749622024-12-03False
17060000020204L17/dossiers17170600000201531706000002015350PA7952982024-12-03False
17060000020205L17/dossiers17170600000201531706000002015351PA7918242024-12-03False
17060000020206L17/dossiers17170600000201531706000002015352PA8420292024-12-03False
17060000020207L17/dossiers17170600000201531706000002015353PA7935322024-12-03False
17060000020208L17/dossiers17170600000201531706000002015354PA7956362024-12-03False
17060000020209L17/dossiers17170600000201531706000002015355PA3423842024-12-03False
17060000020210L17/dossiers17170600000201531706000002015356PA7954222024-12-03False
17060000020211L17/dossiers17170600000201531706000002015357PA8412152024-12-03False
17060000020212L17/dossiers17170600000201531706000002015358PA7954822024-12-03False
17060000020213L17/dossiers17170600000201531706000002015359PA6106542024-12-03False