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
17060000045674L17/dossiers1717060000045665170600000456658PA7931582025-09-17False
17060000045675L17/dossiers1717060000045665170600000456659PA7944342025-09-17False
17060000045676L17/dossiers17170600000456651706000004566510PA8416452025-09-17False
17060000045677L17/dossiers17170600000456651706000004566511PA8420012025-09-17False
17060000045678L17/dossiers17170600000456651706000004566512PA7208222025-09-17False
17060000045679L17/dossiers17170600000456651706000004566513PA7206682025-09-17False
17060000045680L17/dossiers17170600000456651706000004566514PA7948862025-09-17False
17060000045681L17/dossiers17170600000456651706000004566515PA7960422025-09-17False
17060000045682L17/dossiers17170600000456651706000004566516PA7938442025-09-17False
17060000045683L17/dossiers17170600000456651706000004566517PA8414872025-09-17False
17060000045684L17/dossiers17170600000456651706000004566518PA8411312025-09-17False
17060000045685L17/dossiers17170600000456651706000004566519PA7931822025-09-17False
17060000045686L17/dossiers17170600000456651706000004566520PA7931342025-09-17False
17060000045687L17/dossiers17170600000456651706000004566521PA8400752025-09-17False
17060000045688L17/dossiers17170600000456651706000004566522PA7204682025-09-17False
17060000045689L17/dossiers17170600000456651706000004566523PA7941982025-09-17False
17060000045690L17/dossiers17170600000456651706000004566524PA8401592025-09-17False
17060000045691L17/dossiers17170600000456651706000004566525PA7935482025-09-17False
17060000045692L17/dossiers17170600000456651706000004566526PA7956442025-09-17False
17060000045693L17/dossiers17170600000456651706000004566527PA8401192025-09-17False
17060000045694L17/dossiers17170600000456651706000004566528PA7931662025-09-17False
17060000045695L17/dossiers17170600000456651706000004566529PA7939282025-09-17False
17060000045696L17/dossiers17170600000456651706000004566530PA7947622025-09-17False
17060000045697L17/dossiers17170600000456651706000004566531PA7931462025-09-17False
17060000045698L17/dossiers17170600000456651706000004566532PA8401352025-09-17False
17060000045699L17/dossiers17170600000456651706000004566533PA8420732025-09-17False
17060000045700L17/dossiers17170600000456651706000004566534PA8417612025-09-17False
17060000045701L17/dossiers17170600000456651706000004566535PA8416212025-09-17False
17060000045702L17/dossiers17170600000456651706000004566536PA7932462025-09-17False
17060000045703L17/dossiers17170600000456651706000004566537PA8416132025-09-17False
17060000045704L17/dossiers17170600000456651706000004566538PA8401432025-09-17False
17060000045705L17/dossiers17170600000456651706000004566539PA8408012025-09-17False
17060000045706L17/dossiers17170600000456651706000004566540PA7946782025-09-17False
17060000045707L17/dossiers17170600000456651706000004566541PA8411392025-09-17False
17060000045708L17/dossiers17170600000456651706000004566542PA7938922025-09-17False
17060000045709L17/dossiers17170600000456651706000004566543PA8417372025-09-17False
17060000045710L17/dossiers17170600000456651706000004566544PA7960342025-09-17False
17060000045711L17/dossiers17170600000456651706000004566545PA7938322025-09-17False
17060000045712L17/dossiers17170600000456651706000004566546PA7931022025-09-17False
17060000045713L17/dossiers17170600000456651706000004566547PA8416052025-09-17False
17060000045714L17/dossiers17170600000456651706000004566548PA7933622025-09-17False
17060000045715L17/dossiers17170600000456651706000004566549PA7944182025-09-17False
17060000045716L17/dossiers17170600000456651706000004566550PA7935922025-09-17False
17060000045717L17/dossiers17170600000456651706000004566551PA8407572025-09-17False
17060000045718L17/dossiers17170600000456651706000004566552PA8414512025-09-17False
17060000045719L17/dossiers17170600000456651706000004566553PA7947342025-09-17False
17060000045720L17/dossiers17170600000456651706000004566554PA7932182025-09-17False
17060000045721L17/dossiers17170600000456651706000004566555PA7959002025-09-17False
17060000045722L17/dossiers17170600000456651706000004566556PA7936322025-09-17False
17060000045723L17/dossiers17170600000456651706000004566557PA8420852025-09-17False