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
17060000046416L17/dossiers171706000004629817060000046298117PA8415532025-09-17False
17060000046417L17/dossiers171706000004629817060000046298118PA7932982025-09-17False
17060000046418L17/dossiers171706000004629817060000046298119PA8407812025-09-17False
17060000046419L17/dossiers171706000004629817060000046298120PA7949462025-09-17False
17060000046420L17/dossiers171706000004629817060000046298121PA8415752025-09-17False
17060000046421L17/dossiers171706000004629817060000046298122PA8414792025-09-17False
17060000046425L17/dossiers1717060000046423170600000464231PA7940082025-11-24False
17060000046426L17/dossiers1717060000046423170600000464232PA6109682025-11-24False
17060000046427L17/dossiers1717060000046423170600000464233PA7937802025-11-24False
17060000046428L17/dossiers1717060000046423170600000464234PA5888842025-11-24False
17060000046429L17/dossiers1717060000046423170600000464235PA8417012025-11-24False
17060000046430L17/dossiers1717060000046423170600000464236PA7953622025-11-24False
17060000046431L17/dossiers1717060000046423170600000464237PA7954542025-11-24False
17060000046432L17/dossiers1717060000046423170600000464238PA8409972025-11-24False
17060000046433L17/dossiers1717060000046423170600000464239PA8418852025-11-24False
17060000046434L17/dossiers17170600000464231706000004642310PA8415072025-11-24False
17060000046435L17/dossiers17170600000464231706000004642311PA7212102025-11-24False
17060000046436L17/dossiers17170600000464231706000004642312PA7934522025-11-24False
17060000046437L17/dossiers17170600000464231706000004642313PA7939802025-11-24False
17060000046438L17/dossiers17170600000464231706000004642314PA7950102025-11-24False
17060000046439L17/dossiers17170600000464231706000004642315PA8414192025-11-24False
17060000046440L17/dossiers17170600000464231706000004642316PA8420132025-11-24False
17060000046441L17/dossiers17170600000464231706000004642317PA8409472025-11-24False
17060000046442L17/dossiers17170600000464231706000004642318PA7940222025-11-24False
17060000046443L17/dossiers17170600000464231706000004642319PA7941462025-11-24False
17060000046444L17/dossiers17170600000464231706000004642320PA8412232025-11-24False
17060000046445L17/dossiers17170600000464231706000004642321PA7956362025-11-24False
17060000046446L17/dossiers17170600000464231706000004642322PA8420452025-11-24False
17060000046447L17/dossiers17170600000464231706000004642323PA7937082025-11-24False
17060000046448L17/dossiers17170600000464231706000004642324PA7936642025-11-24False
17060000046449L17/dossiers17170600000464231706000004642325PA7941542025-11-24False
17060000046450L17/dossiers17170600000464231706000004642326PA7947782025-11-24False
17060000046451L17/dossiers17170600000464231706000004642327PA6065452025-11-24False
17060000046452L17/dossiers17170600000464231706000004642328PA7950762025-11-24False
17060000046453L17/dossiers17170600000464231706000004642329PA7221422025-11-24False
17060000046454L17/dossiers17170600000464231706000004642330PA6100022025-11-24False
17060000046455L17/dossiers17170600000464231706000004642331PA7958082025-11-24False
17060000046456L17/dossiers17170600000464231706000004642332PA7960182025-11-24False
17060000046457L17/dossiers17170600000464231706000004642333PA7362012025-11-24False
17060000046458L17/dossiers17170600000464231706000004642334PA8417132025-11-24False
17060000046459L17/dossiers17170600000464231706000004642335PA7939482025-11-24False
17060000046460L17/dossiers17170600000464231706000004642336PA29402025-11-24False
17060000046461L17/dossiers17170600000464231706000004642337PA8422632025-11-24False
17060000046462L17/dossiers17170600000464231706000004642338PA7749622025-11-24False
17060000046463L17/dossiers17170600000464231706000004642339PA7952402025-11-24False
17060000046464L17/dossiers17170600000464231706000004642340PA8413592025-11-24False
17060000046465L17/dossiers17170600000464231706000004642341PA6081722025-11-24False
17060000046466L17/dossiers17170600000464231706000004642342PA7940942025-11-24False
17060000046467L17/dossiers17170600000464231706000004642343PA8416332025-11-24False
17060000046468L17/dossiers17170600000464231706000004642344PA8407932025-11-24False