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
17060000037072L17/dossiers17170600000369761706000003697695PA7936962025-05-13False
17060000037073L17/dossiers17170600000369761706000003697696PA7955522025-05-13False
17060000037074L17/dossiers17170600000369761706000003697697PA7946702025-05-13False
17060000037075L17/dossiers17170600000369761706000003697698PA8411992025-05-13False
17060000037076L17/dossiers17170600000369761706000003697699PA7945822025-05-13False
17060000037077L17/dossiers171706000003697617060000036976100PA7936562025-05-13False
17060000037078L17/dossiers171706000003697617060000036976101PA7932302025-05-13False
17060000037079L17/dossiers171706000003697617060000036976102PA7932542025-05-13False
17060000037080L17/dossiers171706000003697617060000036976103PA8419552025-05-13False
17060000037081L17/dossiers171706000003697617060000036976104PA8419812025-05-13False
17060000037082L17/dossiers171706000003697617060000036976105PA8422272025-05-13False
17060000037083L17/dossiers171706000003697617060000036976106PA7944422025-05-13False
17060000037084L17/dossiers171706000003697617060000036976107PA7954102025-05-13False
17060000037085L17/dossiers171706000003697617060000036976108PA8420972025-05-13False
17060000037086L17/dossiers171706000003697617060000036976109PA7948942025-05-13False
17060000037087L17/dossiers171706000003697617060000036976110PA7945702025-05-13False
17060000037088L17/dossiers171706000003697617060000036976111PA7949542025-05-13False
17060000037089L17/dossiers171706000003697617060000036976112PA7960502025-05-13False
17060000037090L17/dossiers171706000003697617060000036976113PA8422552025-05-13False
17060000037091L17/dossiers171706000003697617060000036976114PA7933822025-05-13False
17060000037092L17/dossiers171706000003697617060000036976115PA7957782025-05-13False
17060000037093L17/dossiers171706000003697617060000036976116PA7945022025-05-13False
17060000037094L17/dossiers171706000003697617060000036976117PA8415532025-05-13False
17060000037095L17/dossiers171706000003697617060000036976118PA7932982025-05-13False
17060000037096L17/dossiers171706000003697617060000036976119PA8407812025-05-13False
17060000037097L17/dossiers171706000003697617060000036976120PA7949462025-05-13False
17060000037098L17/dossiers171706000003697617060000036976121PA8415752025-05-13False
17060000037099L17/dossiers171706000003697617060000036976122PA8414792025-05-13False
17060000037100L17/dossiers171706000003697617060000036976123PA8410672025-05-13False
17060000037101L17/dossiers171706000003697617060000036976124PA8412072025-05-13False
17060000037102L17/dossiers171706000003697617060000036976125PA2675612025-05-13False
17060000037103L17/dossiers171706000003697617060000036976126PA8408892025-05-13False
17060000037104L17/dossiers171706000003697617060000036976127PA8407012025-05-13False
17060000037105L17/dossiers171706000003697617060000036976128PA8407212025-05-13False
17060000037106L17/dossiers171706000003697617060000036976129PA3302402025-05-13False
17060000037107L17/dossiers171706000003697617060000036976130PA7933222025-05-13False
17060000037108L17/dossiers171706000003697617060000036976131PA8407732025-05-13False
17060000037109L17/dossiers171706000003697617060000036976132PA8409832025-05-13False
17060000037110L17/dossiers171706000003697617060000036976133PA8411832025-05-13False
17060000037111L17/dossiers171706000003697617060000036976134PA8413952025-05-13False
17060000037112L17/dossiers171706000003697617060000036976135PA8417692025-05-13False
17060000037113L17/dossiers171706000003697617060000036976136PA8406572025-05-13False
17060000037114L17/dossiers171706000003697617060000036976137PA8406852025-05-13False
17060000037115L17/dossiers171706000003697617060000036976138PA8408092025-05-13False
17060000037119L17/dossiers1717060000037117170600000371171PA8410672025-07-07False
17060000037120L17/dossiers1717060000037117170600000371172PA7934322025-07-07False
17060000037121L17/dossiers1717060000037117170600000371173PA8414952025-07-07False
17060000037122L17/dossiers1717060000037117170600000371174PA7961182025-07-07False
17060000037123L17/dossiers1717060000037117170600000371175PA7945622025-07-07False
17060000037124L17/dossiers1717060000037117170600000371176PA2675612025-07-07False