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
17060000022579L17/dossiers17170600000225271706000002252751PA7959742025-01-07False
17060000022580L17/dossiers17170600000225271706000002252752PA7933302025-01-07False
17060000022581L17/dossiers17170600000225271706000002252753PA8419812025-01-07False
17060000022582L17/dossiers17170600000225271706000002252754PA8418372025-01-07False
17060000022583L17/dossiers17170600000225271706000002252755PA7939042025-01-07False
17060000022584L17/dossiers17170600000225271706000002252756PA7938322025-01-07False
17060000022585L17/dossiers17170600000225271706000002252757PA8400752025-01-07False
17060000022586L17/dossiers17170600000225271706000002252758PA8415532025-01-07False
17060000022587L17/dossiers17170600000225271706000002252759PA8409152025-01-07False
17060000022588L17/dossiers17170600000225271706000002252760PA7948862025-01-07False
17060000022589L17/dossiers17170600000225271706000002252761PA8414872025-01-07False
17060000022590L17/dossiers17170600000225271706000002252762PA7945022025-01-07False
17060000022591L17/dossiers17170600000225271706000002252763PA8415752025-01-07False
17060000022592L17/dossiers17170600000225271706000002252764PA7219322025-01-07False
17060000022593L17/dossiers17170600000225271706000002252765PA7945902025-01-07False
17060000022594L17/dossiers17170600000225271706000002252766PA7931462025-01-07False
17060000022595L17/dossiers17170600000225271706000002252767PA8411312025-01-07False
17060000022596L17/dossiers17170600000225271706000002252768PA8408692025-01-07False
17060000022597L17/dossiers17170600000225271706000002252769PA7936162025-01-07False
17060000022598L17/dossiers17170600000225271706000002252770PA7933742025-01-07False
17060000022599L17/dossiers17170600000225271706000002252771PA7204682025-01-07False
17060000022600L17/dossiers17170600000225271706000002252772PA7947622025-01-07False
17060000022601L17/dossiers17170600000225271706000002252773PA7943542025-01-07False
17060000022602L17/dossiers17170600000225271706000002252774PA7941982025-01-07False
17060000022603L17/dossiers17170600000225271706000002252775PA8408372025-01-07False
17060000022604L17/dossiers17170600000225271706000002252776PA7960422025-01-07False
17060000022605L17/dossiers17170600000225271706000002252777PA8411992025-01-07False
17060000022606L17/dossiers17170600000225271706000002252778PA7945702025-01-07False
17060000022607L17/dossiers17170600000225271706000002252779PA8417372025-01-07False
17060000022608L17/dossiers17170600000225271706000002252780PA7949462025-01-07False
17060000022609L17/dossiers17170600000225271706000002252781PA8407212025-01-07False
17060000022610L17/dossiers17170600000225271706000002252782PA8412072025-01-07False
17060000022614L17/dossiers1717060000022612170600000226121PA7204302024-12-19False
17060000022615L17/dossiers1717060000022612170600000226122PA7212022024-12-19False
17060000022616L17/dossiers1717060000022612170600000226123PA7957462024-12-19False
17060000022617L17/dossiers1717060000022612170600000226124PA6082642024-12-19False
17060000022618L17/dossiers1717060000022612170600000226125PA8421952024-12-19False
17060000022619L17/dossiers1717060000022612170600000226126PA8414192024-12-19False
17060000022620L17/dossiers1717060000022612170600000226127PA8420452024-12-19False
17060000022624L17/dossiers1717060000022622170600000226221PA7223902025-02-17False
17060000022625L17/dossiers1717060000022622170600000226222PA7199682025-02-17False
17060000022626L17/dossiers1717060000022622170600000226223PA7188502025-02-17False
17060000022627L17/dossiers1717060000022622170600000226224PA7188382025-02-17False
17060000022628L17/dossiers1717060000022622170600000226225PA7206442025-02-17False
17060000022629L17/dossiers1717060000022622170600000226226PA7941782025-02-17False
17060000022630L17/dossiers1717060000022622170600000226227PA6070902025-02-17False
17060000022631L17/dossiers1717060000022622170600000226228PA7188842025-02-17False
17060000022632L17/dossiers1717060000022622170600000226229PA8421172025-02-17False
17060000022633L17/dossiers17170600000226221706000002262210PA7187842025-02-17False
17060000022634L17/dossiers17170600000226221706000002262211PA8417452025-02-17False