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
17060000041896L17/dossiers17170600000418331706000004183362PA8418452025-07-21False
17060000041897L17/dossiers17170600000418331706000004183363PA7959822025-07-21False
17060000041898L17/dossiers17170600000418331706000004183364PA7954662025-07-21False
17060000041899L17/dossiers17170600000418331706000004183365PA7937442025-07-21False
17060000041900L17/dossiers17170600000418331706000004183366PA7209522025-07-21False
17060000041901L17/dossiers17170600000418331706000004183367PA7941062025-07-21False
17060000041902L17/dossiers17170600000418331706000004183368PA7941662025-07-21False
17060000041903L17/dossiers17170600000418331706000004183369PA7951642025-07-21False
17060000041904L17/dossiers17170600000418331706000004183370PA7955962025-07-21False
17060000041911L17/dossiers1717060000041909170600000419091PA7208922025-07-11False
17060000041912L17/dossiers1717060000041909170600000419092PA7952282025-07-11False
17060000041913L17/dossiers1717060000041909170600000419093PA7932622025-07-11False
17060000041914L17/dossiers1717060000041909170600000419094PA7949062025-07-11False
17060000041915L17/dossiers1717060000041909170600000419095PA7941382025-07-11False
17060000041916L17/dossiers1717060000041909170600000419096PA7955882025-07-11False
17060000041917L17/dossiers1717060000041909170600000419097PA7950842025-07-11False
17060000041918L17/dossiers1717060000041909170600000419098PA8421052025-07-11False
17060000041919L17/dossiers1717060000041909170600000419099PA8416572025-07-11False
17060000041920L17/dossiers17170600000419091706000004190910PA7204302025-07-11False
17060000041921L17/dossiers17170600000419091706000004190911PA7937722025-07-11False
17060000041922L17/dossiers17170600000419091706000004190912PA7956162025-07-11False
17060000041923L17/dossiers17170600000419091706000004190913PA7934442025-07-11False
17060000041924L17/dossiers17170600000419091706000004190914PA7949382025-07-11False
17060000041925L17/dossiers17170600000419091706000004190915PA7953182025-07-11False
17060000041926L17/dossiers17170600000419091706000004190916PA8410232025-07-11False
17060000041927L17/dossiers17170600000419091706000004190917PA7960902025-07-11False
17060000041928L17/dossiers17170600000419091706000004190918PA7939122025-07-11False
17060000041929L17/dossiers17170600000419091706000004190919PA8421872025-07-11False
17060000041930L17/dossiers17170600000419091706000004190920PA8420372025-07-11False
17060000041931L17/dossiers17170600000419091706000004190921PA7918122025-07-11False
17060000041932L17/dossiers17170600000419091706000004190922PA7937362025-07-11False
17060000041933L17/dossiers17170600000419091706000004190923PA7212022025-07-11False
17060000041934L17/dossiers17170600000419091706000004190924PA7951362025-07-11False
17060000041935L17/dossiers17170600000419091706000004190925PA7934642025-07-11False
17060000041936L17/dossiers17170600000419091706000004190926PA8421552025-07-11False
17060000041937L17/dossiers17170600000419091706000004190927PA7952002025-07-11False
17060000041938L17/dossiers17170600000419091706000004190928PA7958442025-07-11False
17060000041939L17/dossiers17170600000419091706000004190929PA8412512025-07-11False
17060000041940L17/dossiers17170600000419091706000004190930PA7947862025-07-11False
17060000041941L17/dossiers17170600000419091706000004190931PA7948702025-07-11False
17060000041942L17/dossiers17170600000419091706000004190932PA7960702025-07-11False
17060000041943L17/dossiers17170600000419091706000004190933PA7944782025-07-11False
17060000041944L17/dossiers17170600000419091706000004190934PA8419472025-07-11False
17060000041945L17/dossiers17170600000419091706000004190935PA7940822025-07-11False
17060000041946L17/dossiers17170600000419091706000004190936PA7941302025-07-11False
17060000041947L17/dossiers17170600000419091706000004190937PA7208462025-07-11False
17060000041948L17/dossiers17170600000419091706000004190938PA8417292025-07-11False
17060000041949L17/dossiers17170600000419091706000004190939PA7955162025-07-11False
17060000041950L17/dossiers17170600000419091706000004190940PA7956722025-07-11False
17060000041951L17/dossiers17170600000419091706000004190941PA7957462025-07-11False