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
17060000042900L17/dossiers1717060000042894170600000428945PA7941382025-07-11False
17060000042901L17/dossiers1717060000042894170600000428946PA7955882025-07-11False
17060000042902L17/dossiers1717060000042894170600000428947PA8421052025-07-11False
17060000042903L17/dossiers1717060000042894170600000428948PA8416572025-07-11False
17060000042904L17/dossiers1717060000042894170600000428949PA7204302025-07-11False
17060000042905L17/dossiers17170600000428941706000004289410PA7937722025-07-11False
17060000042906L17/dossiers17170600000428941706000004289411PA7956162025-07-11False
17060000042907L17/dossiers17170600000428941706000004289412PA7934442025-07-11False
17060000042908L17/dossiers17170600000428941706000004289413PA7949382025-07-11False
17060000042909L17/dossiers17170600000428941706000004289414PA7953182025-07-11False
17060000042910L17/dossiers17170600000428941706000004289415PA8410232025-07-11False
17060000042911L17/dossiers17170600000428941706000004289416PA7960902025-07-11False
17060000042912L17/dossiers17170600000428941706000004289417PA7939122025-07-11False
17060000042913L17/dossiers17170600000428941706000004289418PA8421872025-07-11False
17060000042914L17/dossiers17170600000428941706000004289419PA8420372025-07-11False
17060000042915L17/dossiers17170600000428941706000004289420PA7918122025-07-11False
17060000042916L17/dossiers17170600000428941706000004289421PA7937362025-07-11False
17060000042917L17/dossiers17170600000428941706000004289422PA7212022025-07-11False
17060000042918L17/dossiers17170600000428941706000004289423PA7951362025-07-11False
17060000042919L17/dossiers17170600000428941706000004289424PA7934642025-07-11False
17060000042920L17/dossiers17170600000428941706000004289425PA8421552025-07-11False
17060000042921L17/dossiers17170600000428941706000004289426PA7952002025-07-11False
17060000042922L17/dossiers17170600000428941706000004289427PA7958442025-07-11False
17060000042923L17/dossiers17170600000428941706000004289428PA8412512025-07-11False
17060000042924L17/dossiers17170600000428941706000004289429PA7947862025-07-11False
17060000042925L17/dossiers17170600000428941706000004289430PA7948702025-07-11False
17060000042926L17/dossiers17170600000428941706000004289431PA7960702025-07-11False
17060000042927L17/dossiers17170600000428941706000004289432PA7953102025-07-11False
17060000042928L17/dossiers17170600000428941706000004289433PA7944782025-07-11False
17060000042929L17/dossiers17170600000428941706000004289434PA8419472025-07-11False
17060000042930L17/dossiers17170600000428941706000004289435PA7940822025-07-11False
17060000042931L17/dossiers17170600000428941706000004289436PA7941302025-07-11False
17060000042932L17/dossiers17170600000428941706000004289437PA7208462025-07-11False
17060000042933L17/dossiers17170600000428941706000004289438PA8417292025-07-11False
17060000042934L17/dossiers17170600000428941706000004289439PA7955162025-07-11False
17060000042935L17/dossiers17170600000428941706000004289440PA7956722025-07-11False
17060000042936L17/dossiers17170600000428941706000004289441PA7957462025-07-11False
17060000042937L17/dossiers17170600000428941706000004289442PA7951082025-07-11False
17060000042938L17/dossiers17170600000428941706000004289443PA8415152025-07-11False
17060000042939L17/dossiers17170600000428941706000004289444PA7952982025-07-11False
17060000042940L17/dossiers17170600000428941706000004289445PA7918242025-07-11False
17060000042941L17/dossiers17170600000428941706000004289446PA8420292025-07-11False
17060000042942L17/dossiers17170600000428941706000004289447PA7935322025-07-11False
17060000042943L17/dossiers17170600000428941706000004289448PA3423842025-07-11False
17060000042944L17/dossiers17170600000428941706000004289449PA7954222025-07-11False
17060000042945L17/dossiers17170600000428941706000004289450PA7946862025-07-11False
17060000042946L17/dossiers17170600000428941706000004289451PA8412152025-07-11False
17060000042947L17/dossiers17170600000428941706000004289452PA7954822025-07-11False
17060000042948L17/dossiers17170600000428941706000004289453PA6106542025-07-11False
17060000042949L17/dossiers17170600000428941706000004289454PA8411912025-07-11False