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 151 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
17060000007094L17/dossiers17170600000070561706000000705637PA7947862024-10-31False
17060000007095L17/dossiers17170600000070561706000000705638PA7948702024-10-31False
17060000007096L17/dossiers17170600000070561706000000705639PA7960702024-10-31False
17060000007097L17/dossiers17170600000070561706000000705640PA7953102024-10-31False
17060000007098L17/dossiers17170600000070561706000000705641PA7944782024-10-31False
17060000007099L17/dossiers17170600000070561706000000705642PA8419472024-10-31False
17060000007100L17/dossiers17170600000070561706000000705643PA7940822024-10-31False
17060000007101L17/dossiers17170600000070561706000000705644PA7941302024-10-31False
17060000007102L17/dossiers17170600000070561706000000705645PA7208462024-10-31False
17060000007103L17/dossiers17170600000070561706000000705646PA8417292024-10-31False
17060000007104L17/dossiers17170600000070561706000000705647PA7955162024-10-31False
17060000007105L17/dossiers17170600000070561706000000705648PA7957462024-10-31False
17060000007106L17/dossiers17170600000070561706000000705649PA7951082024-10-31False
17060000007107L17/dossiers17170600000070561706000000705650PA8415152024-10-31False
17060000007108L17/dossiers17170600000070561706000000705651PA7952982024-10-31False
17060000007109L17/dossiers17170600000070561706000000705652PA7918242024-10-31False
17060000007110L17/dossiers17170600000070561706000000705653PA8420292024-10-31False
17060000007111L17/dossiers17170600000070561706000000705654PA7935322024-10-31False
17060000007112L17/dossiers17170600000070561706000000705655PA7956362024-10-31False
17060000007113L17/dossiers17170600000070561706000000705656PA3423842024-10-31False
17060000007114L17/dossiers17170600000070561706000000705657PA7954222024-10-31False
17060000007115L17/dossiers17170600000070561706000000705658PA7946862024-10-31False
17060000007116L17/dossiers17170600000070561706000000705659PA8412152024-10-31False
17060000007117L17/dossiers17170600000070561706000000705660PA7954822024-10-31False
17060000007118L17/dossiers17170600000070561706000000705661PA7958202024-10-31False
17060000007119L17/dossiers17170600000070561706000000705662PA6106542024-10-31False
17060000007120L17/dossiers17170600000070561706000000705663PA8411912024-10-31False
17060000007121L17/dossiers17170600000070561706000000705664PA7219602024-10-31False
17060000007122L17/dossiers17170600000070561706000000705665PA8420452024-10-31False
17060000007123L17/dossiers17170600000070561706000000705666PA7938722024-10-31False
17060000007124L17/dossiers17170600000070561706000000705667PA8172112024-10-31False
17060000007125L17/dossiers17170600000070561706000000705668PA7937562024-10-31False
17060000007126L17/dossiers17170600000070561706000000705669PA7960622024-10-31False
17060000007127L17/dossiers17170600000070561706000000705670PA7195782024-10-31False
17060000007128L17/dossiers17170600000070561706000000705671PA8411672024-09-172024-10-31False
17060000007129L17/dossiers17170600000070561706000000705672PA7210622024-10-31False
17060000007130L17/dossiers17170600000070561706000000705673PA7950762024-10-31False
17060000007131L17/dossiers17170600000070561706000000705674PA8418452024-10-31False
17060000007132L17/dossiers17170600000070561706000000705675PA7959822024-10-31False
17060000007133L17/dossiers17170600000070561706000000705676PA7954662024-10-31False
17060000007134L17/dossiers17170600000070561706000000705677PA7937442024-10-31False
17060000007135L17/dossiers17170600000070561706000000705678PA7952282024-10-31False
17060000007136L17/dossiers17170600000070561706000000705679PA7362012024-10-31False
17060000007137L17/dossiers17170600000070561706000000705680PA7941062024-10-31False
17060000007138L17/dossiers17170600000070561706000000705681PA7941662024-10-31False
17060000007139L17/dossiers17170600000070561706000000705682PA7951642024-10-31False
17060000007143L17/dossiers1717060000007141170600000071411PA7749542025-02-17False
17060000007144L17/dossiers1717060000007141170600000071412PA7199682025-02-17False
17060000007145L17/dossiers1717060000007141170600000071413PA7214102025-02-17False
17060000007146L17/dossiers1717060000007141170600000071414PA7935082025-02-17False