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
17060000032827L17/dossiers1717060000032819170600000328197PA7946702025-04-01False
17060000032828L17/dossiers1717060000032819170600000328198PA7945822025-04-01False
17060000032829L17/dossiers1717060000032819170600000328199PA8419812025-04-01False
17060000032830L17/dossiers17170600000328191706000003281910PA7932982025-04-01False
17060000032831L17/dossiers17170600000328191706000003281911PA7959002025-04-01False
17060000032832L17/dossiers17170600000328191706000003281912PA8415632025-04-01False
17060000032833L17/dossiers17170600000328191706000003281913PA7947702025-04-01False
17060000032834L17/dossiers17170600000328191706000003281914PA7936162025-04-01False
17060000032835L17/dossiers17170600000328191706000003281915PA7960422025-04-01False
17060000032836L17/dossiers17170600000328191706000003281916PA7931342025-04-01False
17060000032837L17/dossiers17170600000328191706000003281917PA8401592025-04-01False
17060000032838L17/dossiers17170600000328191706000003281918PA8417372025-04-01False
17060000032839L17/dossiers17170600000328191706000003281919PA7960342025-04-01False
17060000032840L17/dossiers17170600000328191706000003281920PA7932182025-04-01False
17060000032841L17/dossiers17170600000328191706000003281921PA8408692025-04-01False
17060000032842L17/dossiers17170600000328191706000003281922PA7943542025-04-01False
17060000032843L17/dossiers17170600000328191706000003281923PA8418252025-04-01False
17060000032844L17/dossiers17170600000328191706000003281924PA7933142025-04-01False
17060000032845L17/dossiers17170600000328191706000003281925PA7957862025-04-01False
17060000032846L17/dossiers17170600000328191706000003281926PA7943222025-04-01False
17060000032847L17/dossiers17170600000328191706000003281927PA8411992025-04-01False
17060000032848L17/dossiers17170600000328191706000003281928PA7936562025-04-01False
17060000032849L17/dossiers17170600000328191706000003281929PA7932542025-04-01False
17060000032850L17/dossiers17170600000328191706000003281930PA7960502025-04-01False
17060000032851L17/dossiers17170600000328191706000003281931PA7932382025-04-01False
17060000032852L17/dossiers17170600000328191706000003281932PA8401432025-04-01False
17060000032853L17/dossiers17170600000328191706000003281933PA7944182025-04-01False
17060000032854L17/dossiers17170600000328191706000003281934PA8418372025-04-01False
17060000032855L17/dossiers17170600000328191706000003281935PA8409672025-04-01False
17060000032856L17/dossiers17170600000328191706000003281936PA7959742025-04-01False
17060000032857L17/dossiers17170600000328191706000003281937PA7194362025-04-01False
17060000032858L17/dossiers17170600000328191706000003281938PA7944422025-04-01False
17060000032859L17/dossiers17170600000328191706000003281939PA7949542025-04-01False
17060000032860L17/dossiers17170600000328191706000003281940PA8414792025-04-01False
17060000032861L17/dossiers17170600000328191706000003281941PA8410672025-04-01False
17060000032862L17/dossiers17170600000328191706000003281942PA7931582025-04-01False
17060000032863L17/dossiers17170600000328191706000003281943PA7208222025-04-01False
17060000032864L17/dossiers17170600000328191706000003281944PA8417612025-04-01False
17060000032865L17/dossiers17170600000328191706000003281945PA7932462025-04-01False
17060000032866L17/dossiers17170600000328191706000003281946PA7938922025-04-01False
17060000032867L17/dossiers17170600000328191706000003281947PA8417492025-04-01False
17060000032868L17/dossiers17170600000328191706000003281948PA7960262025-04-01False
17060000032869L17/dossiers17170600000328191706000003281949PA7945902025-04-01False
17060000032870L17/dossiers17170600000328191706000003281950PA7959662025-04-01False
17060000032871L17/dossiers17170600000328191706000003281951PA8422272025-04-01False
17060000032872L17/dossiers17170600000328191706000003281952PA8407812025-04-01False
17060000032873L17/dossiers17170600000328191706000003281953PA7944342025-04-01False
17060000032874L17/dossiers17170600000328191706000003281954PA7206682025-04-01False
17060000032875L17/dossiers17170600000328191706000003281955PA7941982025-04-01False
17060000032876L17/dossiers17170600000328191706000003281956PA7935482025-04-01False