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
17060000023778L17/dossiers17170600000237551706000002375522PA7212022025-01-21False
17060000023779L17/dossiers17170600000237551706000002375523PA7951362025-01-21False
17060000023780L17/dossiers17170600000237551706000002375524PA7934642025-01-21False
17060000023781L17/dossiers17170600000237551706000002375525PA8421552025-01-21False
17060000023782L17/dossiers17170600000237551706000002375526PA7952002025-01-21False
17060000023783L17/dossiers17170600000237551706000002375527PA7958442025-01-21False
17060000023784L17/dossiers17170600000237551706000002375528PA8412512025-01-21False
17060000023785L17/dossiers17170600000237551706000002375529PA7947862025-01-21False
17060000023786L17/dossiers17170600000237551706000002375530PA7948702025-01-21False
17060000023787L17/dossiers17170600000237551706000002375531PA7960702025-01-21False
17060000023788L17/dossiers17170600000237551706000002375532PA7953102025-01-21False
17060000023789L17/dossiers17170600000237551706000002375533PA7944782025-01-21False
17060000023790L17/dossiers17170600000237551706000002375534PA8419472025-01-21False
17060000023791L17/dossiers17170600000237551706000002375535PA7940822025-01-21False
17060000023792L17/dossiers17170600000237551706000002375536PA7941302025-01-21False
17060000023793L17/dossiers17170600000237551706000002375537PA7208462025-01-21False
17060000023794L17/dossiers17170600000237551706000002375538PA8417292025-01-21False
17060000023795L17/dossiers17170600000237551706000002375539PA7955162025-01-21False
17060000023796L17/dossiers17170600000237551706000002375540PA7956722025-01-21False
17060000023797L17/dossiers17170600000237551706000002375541PA7957462025-01-21False
17060000023798L17/dossiers17170600000237551706000002375542PA7951082025-01-21False
17060000023799L17/dossiers17170600000237551706000002375543PA8415152025-01-21False
17060000023800L17/dossiers17170600000237551706000002375544PA7952982025-01-21False
17060000023801L17/dossiers17170600000237551706000002375545PA7918242025-01-21False
17060000023802L17/dossiers17170600000237551706000002375546PA8420292025-01-21False
17060000023803L17/dossiers17170600000237551706000002375547PA7935322025-01-21False
17060000023804L17/dossiers17170600000237551706000002375548PA3423842025-01-21False
17060000023805L17/dossiers17170600000237551706000002375549PA7954222025-01-21False
17060000023806L17/dossiers17170600000237551706000002375550PA7946862025-01-21False
17060000023807L17/dossiers17170600000237551706000002375551PA8412152025-01-21False
17060000023808L17/dossiers17170600000237551706000002375552PA7954822025-01-21False
17060000023809L17/dossiers17170600000237551706000002375553PA6106542025-01-21False
17060000023810L17/dossiers17170600000237551706000002375554PA8411912025-01-21False
17060000023811L17/dossiers17170600000237551706000002375555PA7219602025-01-21False
17060000023812L17/dossiers17170600000237551706000002375556PA7938722025-01-21False
17060000023813L17/dossiers17170600000237551706000002375557PA8172112025-01-21False
17060000023814L17/dossiers17170600000237551706000002375558PA7937562025-01-21False
17060000023815L17/dossiers17170600000237551706000002375559PA7960622025-01-21False
17060000023816L17/dossiers17170600000237551706000002375560PA7195782025-01-21False
17060000023817L17/dossiers17170600000237551706000002375561PA7210622025-01-21False
17060000023818L17/dossiers17170600000237551706000002375562PA8418452025-01-21False
17060000023819L17/dossiers17170600000237551706000002375563PA7959822025-01-21False
17060000023820L17/dossiers17170600000237551706000002375564PA7954662025-01-21False
17060000023821L17/dossiers17170600000237551706000002375565PA7937442025-01-21False
17060000023822L17/dossiers17170600000237551706000002375566PA7209522025-01-21False
17060000023823L17/dossiers17170600000237551706000002375567PA7941062025-01-21False
17060000023824L17/dossiers17170600000237551706000002375568PA7941662025-01-21False
17060000023825L17/dossiers17170600000237551706000002375569PA7951642025-01-21False
17060000023826L17/dossiers17170600000237551706000002375570PA7955962025-01-21False
17060000023830L17/dossiers1717060000023828170600000238281PA7942782025-01-21False