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
17060000046316L17/dossiers17170600000462981706000004629817PA8414872025-09-17False
17060000046317L17/dossiers17170600000462981706000004629818PA8411312025-09-17False
17060000046318L17/dossiers17170600000462981706000004629819PA7931822025-09-17False
17060000046319L17/dossiers17170600000462981706000004629820PA7931342025-09-17False
17060000046320L17/dossiers17170600000462981706000004629821PA8400752025-09-17False
17060000046321L17/dossiers17170600000462981706000004629822PA7204682025-09-17False
17060000046322L17/dossiers17170600000462981706000004629823PA7941982025-09-17False
17060000046323L17/dossiers17170600000462981706000004629824PA8401592025-09-17False
17060000046324L17/dossiers17170600000462981706000004629825PA7935482025-09-17False
17060000046325L17/dossiers17170600000462981706000004629826PA7956442025-09-17False
17060000046326L17/dossiers17170600000462981706000004629827PA8401192025-09-17False
17060000046327L17/dossiers17170600000462981706000004629828PA7931662025-09-17False
17060000046328L17/dossiers17170600000462981706000004629829PA7939282025-09-17False
17060000046329L17/dossiers17170600000462981706000004629830PA7947622025-09-17False
17060000046330L17/dossiers17170600000462981706000004629831PA7931462025-09-17False
17060000046331L17/dossiers17170600000462981706000004629832PA8401352025-09-17False
17060000046332L17/dossiers17170600000462981706000004629833PA8420732025-09-17False
17060000046333L17/dossiers17170600000462981706000004629834PA8417612025-09-17False
17060000046334L17/dossiers17170600000462981706000004629835PA8416212025-09-17False
17060000046335L17/dossiers17170600000462981706000004629836PA7932462025-09-17False
17060000046336L17/dossiers17170600000462981706000004629837PA8416132025-09-17False
17060000046337L17/dossiers17170600000462981706000004629838PA8401432025-09-17False
17060000046338L17/dossiers17170600000462981706000004629839PA8408012025-09-17False
17060000046339L17/dossiers17170600000462981706000004629840PA7946782025-09-17False
17060000046340L17/dossiers17170600000462981706000004629841PA8411392025-09-17False
17060000046341L17/dossiers17170600000462981706000004629842PA7938922025-09-17False
17060000046342L17/dossiers17170600000462981706000004629843PA8417372025-09-17False
17060000046343L17/dossiers17170600000462981706000004629844PA7960342025-09-17False
17060000046344L17/dossiers17170600000462981706000004629845PA7938322025-09-17False
17060000046345L17/dossiers17170600000462981706000004629846PA7931022025-09-17False
17060000046346L17/dossiers17170600000462981706000004629847PA8416052025-09-17False
17060000046347L17/dossiers17170600000462981706000004629848PA7933622025-09-17False
17060000046348L17/dossiers17170600000462981706000004629849PA7944182025-09-17False
17060000046349L17/dossiers17170600000462981706000004629850PA7935922025-09-17False
17060000046350L17/dossiers17170600000462981706000004629851PA8407572025-09-17False
17060000046351L17/dossiers17170600000462981706000004629852PA8414512025-09-17False
17060000046352L17/dossiers17170600000462981706000004629853PA7947342025-09-17False
17060000046353L17/dossiers17170600000462981706000004629854PA7932182025-09-17False
17060000046354L17/dossiers17170600000462981706000004629855PA7959002025-09-17False
17060000046355L17/dossiers17170600000462981706000004629856PA7936322025-09-17False
17060000046356L17/dossiers17170600000462981706000004629857PA8420852025-09-17False
17060000046357L17/dossiers17170600000462981706000004629858PA7945982025-09-17False
17060000046358L17/dossiers17170600000462981706000004629859PA8414392025-09-17False
17060000046359L17/dossiers17170600000462981706000004629860PA7940302025-09-17False
17060000046360L17/dossiers17170600000462981706000004629861PA8417492025-09-17False
17060000046361L17/dossiers17170600000462981706000004629862PA8410752025-09-17False
17060000046362L17/dossiers17170600000462981706000004629863PA8408692025-09-17False
17060000046363L17/dossiers17170600000462981706000004629864PA7943542025-09-17False
17060000046364L17/dossiers17170600000462981706000004629865PA7959122025-09-17False
17060000046365L17/dossiers17170600000462981706000004629866PA7206142025-09-17False