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
17060000045023L17/dossiers1717060000045014170600000450148PA8407812025-09-30False
17060000045024L17/dossiers1717060000045014170600000450149PA7933742025-09-30False
17060000045025L17/dossiers17170600000450141706000004501410PA8417692025-09-30False
17060000045026L17/dossiers17170600000450141706000004501411PA7935482025-09-30False
17060000045027L17/dossiers17170600000450141706000004501412PA7931022025-09-30False
17060000045028L17/dossiers17170600000450141706000004501413PA8407212025-09-30False
17060000045032L17/dossiers1717060000045030170600000450301PA8410672025-09-30False
17060000045033L17/dossiers1717060000045030170600000450302PA7944342025-09-30False
17060000045034L17/dossiers1717060000045030170600000450303PA8407012025-09-30False
17060000045035L17/dossiers1717060000045030170600000450304PA7933222025-09-30False
17060000045036L17/dossiers1717060000045030170600000450305PA8414512025-09-30False
17060000045037L17/dossiers1717060000045030170600000450306PA7940302025-09-30False
17060000045038L17/dossiers1717060000045030170600000450307PA7219322025-09-30False
17060000045039L17/dossiers1717060000045030170600000450308PA8407812025-09-30False
17060000045040L17/dossiers1717060000045030170600000450309PA7933742025-09-30False
17060000045041L17/dossiers17170600000450301706000004503010PA8417692025-09-30False
17060000045042L17/dossiers17170600000450301706000004503011PA7935482025-09-30False
17060000045043L17/dossiers17170600000450301706000004503012PA7931022025-09-30False
17060000045044L17/dossiers17170600000450301706000004503013PA8407212025-09-30False
17060000045048L17/dossiers1717060000045046170600000450461PA8406652025-09-16False
17060000045049L17/dossiers1717060000045046170600000450462PA6427642025-09-16False
17060000045050L17/dossiers1717060000045046170600000450463PA6431432025-09-16False
17060000045051L17/dossiers1717060000045046170600000450464PA8408292025-09-16False
17060000045052L17/dossiers1717060000045046170600000450465PA3424152025-09-16False
17060000045053L17/dossiers1717060000045046170600000450466PA6067932025-09-16False
17060000045054L17/dossiers1717060000045046170600000450467PA8422112025-09-16False
17060000045055L17/dossiers1717060000045046170600000450468PA8413152025-09-16False
17060000045056L17/dossiers1717060000045046170600000450469PA7940942025-09-16False
17060000045057L17/dossiers17170600000450461706000004504610PA7936242025-09-16False
17060000045058L17/dossiers17170600000450461706000004504611PA7957622025-09-16False
17060000045059L17/dossiers17170600000450461706000004504612PA6082642025-09-16False
17060000045060L17/dossiers17170600000450461706000004504613PA8409032025-09-16False
17060000045061L17/dossiers17170600000450461706000004504614PA8412952025-09-16False
17060000045062L17/dossiers17170600000450461706000004504615PA10082025-09-16False
17060000045063L17/dossiers17170600000450461706000004504616PA7933942025-09-16False
17060000045064L17/dossiers17170600000450461706000004504617PA7954302025-09-16False
17060000045065L17/dossiers17170600000450461706000004504618PA8419192025-09-16False
17060000045066L17/dossiers17170600000450461706000004504619PA6065732025-09-16False
17060000045067L17/dossiers17170600000450461706000004504620PA8416332025-09-16False
17060000045068L17/dossiers17170600000450461706000004504621PA7948542025-09-16False
17060000045069L17/dossiers17170600000450461706000004504622PA8421952025-09-16False
17060000045070L17/dossiers17170600000450461706000004504623PA6093322025-09-16False
17060000045071L17/dossiers17170600000450461706000004504624PA8416652025-09-16False
17060000045072L17/dossiers17170600000450461706000004504625PA3332852025-09-16False
17060000045073L17/dossiers17170600000450461706000004504626PA8409392025-09-16False
17060000045074L17/dossiers17170600000450461706000004504627PA8415392025-09-16False
17060000045075L17/dossiers17170600000450461706000004504628PA3319732025-09-16False
17060000045076L17/dossiers17170600000450461706000004504629PA8401712025-09-16False
17060000045077L17/dossiers17170600000450461706000004504630PA15672025-09-16False
17060000045078L17/dossiers17170600000450461706000004504631PA8414712025-09-16False