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
17060000019993L17/dossiers17170600000199641706000001996428PA8411392025-03-11False
17060000019994L17/dossiers17170600000199641706000001996429PA7938922025-03-11False
17060000019995L17/dossiers17170600000199641706000001996430PA7960342025-03-11False
17060000019996L17/dossiers17170600000199641706000001996431PA7938322025-03-11False
17060000019997L17/dossiers17170600000199641706000001996432PA7931022025-03-11False
17060000019998L17/dossiers17170600000199641706000001996433PA8416052025-03-11False
17060000019999L17/dossiers17170600000199641706000001996434PA7933622025-03-11False
17060000020000L17/dossiers17170600000199641706000001996435PA7944182025-03-11False
17060000020001L17/dossiers17170600000199641706000001996436PA7935922025-03-11False
17060000020002L17/dossiers17170600000199641706000001996437PA8407572025-03-11False
17060000020003L17/dossiers17170600000199641706000001996438PA8414512025-03-11False
17060000020004L17/dossiers17170600000199641706000001996439PA7932182025-03-11False
17060000020005L17/dossiers17170600000199641706000001996440PA7959002025-03-11False
17060000020006L17/dossiers17170600000199641706000001996441PA8414392025-03-11False
17060000020007L17/dossiers17170600000199641706000001996442PA7940302025-03-11False
17060000020008L17/dossiers17170600000199641706000001996443PA8417492025-03-11False
17060000020009L17/dossiers17170600000199641706000001996444PA8410752025-03-11False
17060000020010L17/dossiers17170600000199641706000001996445PA8408692025-03-11False
17060000020011L17/dossiers17170600000199641706000001996446PA7943542025-03-11False
17060000020012L17/dossiers17170600000199641706000001996447PA8418372025-03-11False
17060000020013L17/dossiers17170600000199641706000001996448PA7960262025-03-11False
17060000020014L17/dossiers17170600000199641706000001996449PA6429882025-03-11False
17060000020015L17/dossiers17170600000199641706000001996450PA7936082025-03-11False
17060000020016L17/dossiers17170600000199641706000001996451PA8418732025-03-11False
17060000020017L17/dossiers17170600000199641706000001996452PA8409672025-03-11False
17060000020018L17/dossiers17170600000199641706000001996453PA7939042025-03-11False
17060000020019L17/dossiers17170600000199641706000001996454PA7959742025-03-11False
17060000020020L17/dossiers17170600000199641706000001996455PA8415872025-03-11False
17060000020021L17/dossiers17170600000199641706000001996456PA8411832025-03-11False
17060000020022L17/dossiers17170600000199641706000001996457PA8415632025-03-11False
17060000020023L17/dossiers17170600000199641706000001996458PA8408372025-03-11False
17060000020024L17/dossiers17170600000199641706000001996459PA8418252025-03-11False
17060000020025L17/dossiers17170600000199641706000001996460PA7947702025-03-11False
17060000020026L17/dossiers17170600000199641706000001996461PA7933142025-03-11False
17060000020027L17/dossiers17170600000199641706000001996462PA7933302025-03-11False
17060000020028L17/dossiers17170600000199641706000001996463PA7936162025-03-11False
17060000020029L17/dossiers17170600000199641706000001996464PA7957862025-03-11False
17060000020030L17/dossiers17170600000199641706000001996465PA7943222025-03-11False
17060000020031L17/dossiers17170600000199641706000001996466PA7936962025-03-11False
17060000020032L17/dossiers17170600000199641706000001996467PA7946702025-03-11False
17060000020033L17/dossiers17170600000199641706000001996468PA7945822025-03-11False
17060000020034L17/dossiers17170600000199641706000001996469PA7936562025-03-11False
17060000020035L17/dossiers17170600000199641706000001996470PA7959662025-03-11False
17060000020036L17/dossiers17170600000199641706000001996471PA7932302025-03-11False
17060000020037L17/dossiers17170600000199641706000001996472PA7932542025-03-11False
17060000020038L17/dossiers17170600000199641706000001996473PA8419812025-03-11False
17060000020039L17/dossiers17170600000199641706000001996474PA8422272025-03-11False
17060000020040L17/dossiers17170600000199641706000001996475PA7944422025-03-11False
17060000020041L17/dossiers17170600000199641706000001996476PA7954102025-03-11False
17060000020042L17/dossiers17170600000199641706000001996477PA7960502025-03-11False