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
17060000019781L17/dossiers171706000001966417060000019664116PA7193722025-03-04False
17060000019782L17/dossiers171706000001966417060000019664117PA7210042025-03-04False
17060000019783L17/dossiers171706000001966417060000019664118PA8416932025-03-04False
17060000019784L17/dossiers171706000001966417060000019664119PA7200222025-03-04False
17060000019785L17/dossiers171706000001966417060000019664120PA7194122025-03-04False
17060000019786L17/dossiers171706000001966417060000019664121PA7193882025-03-04False
17060000019787L17/dossiers171706000001966417060000019664122PA7218522025-03-04False
17060000019788L17/dossiers171706000001966417060000019664123PA7120142025-03-04False
17060000019789L17/dossiers171706000001966417060000019664124PA7953862025-03-04False
17060000019790L17/dossiers171706000001966417060000019664125PA7211342025-03-04False
17060000019791L17/dossiers171706000001966417060000019664126PA7173792025-03-04False
17060000019792L17/dossiers171706000001966417060000019664127PA7957302025-03-04False
17060000019793L17/dossiers171706000001966417060000019664128PA7190802025-03-04False
17060000019794L17/dossiers171706000001966417060000019664129PA7193382025-03-04False
17060000019795L17/dossiers171706000001966417060000019664130PA7203702025-03-04False
17060000019796L17/dossiers171706000001966417060000019664131PA7951762025-03-04False
17060000019797L17/dossiers171706000001966417060000019664132PA7956642025-03-04False
17060000019798L17/dossiers171706000001966417060000019664133PA8172032025-03-04False
17060000019799L17/dossiers171706000001966417060000019664134PA7196322025-03-04False
17060000019800L17/dossiers171706000001966417060000019664135PA3357582025-03-04False
17060000019801L17/dossiers171706000001966417060000019664136PA7214262025-03-04False
17060000019802L17/dossiers171706000001966417060000019664137PA8419272025-03-04False
17060000019803L17/dossiers171706000001966417060000019664138PA7958882025-03-04False
17060000019804L17/dossiers171706000001966417060000019664139PA7934162025-03-04False
17060000019805L17/dossiers171706000001966417060000019664140PA7948022025-03-04False
17060000019806L17/dossiers171706000001966417060000019664141PA7215842025-03-04False
17060000019807L17/dossiers171706000001966417060000019664142PA7959202025-03-04False
17060000019808L17/dossiers171706000001966417060000019664143PA7211702025-03-04False
17060000019809L17/dossiers171706000001966417060000019664144PA29602025-03-04False
17060000019810L17/dossiers171706000001966417060000019664145PA7950462025-03-04False
17060000019814L17/dossiers1717060000019812170600000198121PA8417012025-09-17False
17060000019815L17/dossiers1717060000019812170600000198122PA8418852025-09-17False
17060000019816L17/dossiers1717060000019812170600000198123PA7212102025-09-17False
17060000019817L17/dossiers1717060000019812170600000198124PA7950102025-09-17False
17060000019818L17/dossiers1717060000019812170600000198125PA8420452025-09-17False
17060000019819L17/dossiers1717060000019812170600000198126PA7941542025-09-17False
17060000019820L17/dossiers1717060000019812170600000198127PA7947782025-09-17False
17060000019821L17/dossiers1717060000019812170600000198128PA6065452025-09-17False
17060000019822L17/dossiers1717060000019812170600000198129PA6100022025-09-17False
17060000019823L17/dossiers17170600000198121706000001981210PA8417132025-09-17False
17060000019827L17/dossiers1717060000019825170600000198251PA7941302025-05-14False
17060000019828L17/dossiers1717060000019825170600000198252PA7941382025-05-14False
17060000019829L17/dossiers1717060000019825170600000198253PA7208922025-05-14False
17060000019830L17/dossiers1717060000019825170600000198254PA7199302025-05-14False
17060000019831L17/dossiers1717060000019825170600000198255PA7940082025-05-14False
17060000019832L17/dossiers1717060000019825170600000198256PA7218962025-05-14False
17060000019833L17/dossiers1717060000019825170600000198257PA7952282025-05-14False
17060000019834L17/dossiers1717060000019825170600000198258PA7932622025-05-14False
17060000019835L17/dossiers1717060000019825170600000198259PA7949062025-05-14False
17060000019836L17/dossiers17170600000198251706000001982510PA7955882025-05-14False