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
17060000027405L17/dossiers17170600000273891706000002738915PA7947982025-04-01False
17060000027406L17/dossiers17170600000273891706000002738916PA7188502025-04-01False
17060000027407L17/dossiers17170600000273891706000002738917PA7223902025-04-01False
17060000027408L17/dossiers17170600000273891706000002738918PA7937162025-04-01False
17060000027409L17/dossiers17170600000273891706000002738919PA3309092025-04-01False
17060000027410L17/dossiers17170600000273891706000002738920PA7940422025-04-01False
17060000027411L17/dossiers17170600000273891706000002738921PA7203862025-04-01False
17060000027412L17/dossiers17170600000273891706000002738922PA7120152025-04-01False
17060000027413L17/dossiers17170600000273891706000002738923PA2670422025-04-01False
17060000027414L17/dossiers17170600000273891706000002738924PA2667972025-04-01False
17060000027415L17/dossiers17170600000273891706000002738925PA7940582025-04-01False
17060000027416L17/dossiers17170600000273891706000002738926PA6084162025-04-01False
17060000027417L17/dossiers17170600000273891706000002738927PA3467822025-04-01False
17060000027418L17/dossiers17170600000273891706000002738928PA8421172025-03-212025-03-25False
17060000027419L17/dossiers17170600000273891706000002738929PA8409792025-04-01False
17060000027420L17/dossiers17170600000273891706000002738930PA6955122025-04-01False
17060000027421L17/dossiers17170600000273891706000002738931PA6427252025-04-01False
17060000027422L17/dossiers17170600000273891706000002738932PA7947502025-04-01False
17060000027423L17/dossiers17170600000273891706000002738933PA7941142025-04-01False
17060000027424L17/dossiers17170600000273891706000002738934PA6060982025-04-01False
17060000027425L17/dossiers17170600000273891706000002738935PA7933422025-04-01False
17060000027426L17/dossiers17170600000273891706000002738936PA8419312025-04-01False
17060000027427L17/dossiers17170600000273891706000002738937PA7196402025-04-01False
17060000027428L17/dossiers17170600000273891706000002738938PA7192722025-04-01False
17060000027429L17/dossiers17170600000273891706000002738939PA7206442025-04-01False
17060000027430L17/dossiers17170600000273891706000002738940PA7214422025-04-01False
17060000027431L17/dossiers17170600000273891706000002738941PA7212342025-04-01False
17060000027432L17/dossiers17170600000273891706000002738942PA7930942025-04-01False
17060000027433L17/dossiers17170600000273891706000002738943PA7941782025-04-01False
17060000027434L17/dossiers17170600000273891706000002738944PA6070902025-04-01False
17060000027435L17/dossiers17170600000273891706000002738945PA3315822025-04-01False
17060000027436L17/dossiers17170600000273891706000002738946PA2672852025-04-01False
17060000027437L17/dossiers17170600000273891706000002738947PA13272025-04-01False
17060000027438L17/dossiers17170600000273891706000002738948PA16302025-04-01False
17060000027439L17/dossiers17170600000273891706000002738949PA7749542025-04-01False
17060000027440L17/dossiers17170600000273891706000002738950PA2677942025-04-01False
17060000027441L17/dossiers17170600000273891706000002738951PA7944702025-04-01False
17060000027442L17/dossiers17170600000273891706000002738952PA8410472025-04-01False
17060000027443L17/dossiers17170600000273891706000002738953PA29522025-04-01False
17060000027444L17/dossiers17170600000273891706000002738954PA7214742025-04-01False
17060000027445L17/dossiers17170600000273891706000002738955PA7209762025-04-01False
17060000027446L17/dossiers17170600000273891706000002738956PA7947022025-04-01False
17060000027447L17/dossiers17170600000273891706000002738957PA7201002025-04-01False
17060000027448L17/dossiers17170600000273891706000002738958PA7214862025-04-01False
17060000027449L17/dossiers17170600000273891706000002738959PA6076192025-04-01False
17060000027450L17/dossiers17170600000273891706000002738960PA7931222025-04-01False
17060000027454L17/dossiers1717060000027452170600000274521PA7942782026-05-06False
17060000027455L17/dossiers1717060000027452170600000274522PA8408292026-05-06False
17060000027456L17/dossiers1717060000027452170600000274523PA2677632026-05-06False
17060000027457L17/dossiers1717060000027452170600000274524PA6428472026-05-06False