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
17060000048090L17/dossiers17170600000480421706000004804247PA7195502025-11-18False
17060000048091L17/dossiers17170600000480421706000004804248PA7959202025-11-18False
17060000048092L17/dossiers17170600000480421706000004804249PA3315822025-11-18False
17060000048093L17/dossiers17170600000480421706000004804250PA29602025-11-18False
17060000048094L17/dossiers17170600000480421706000004804251PA7950462025-11-18False
17060000048098L17/dossiers1717060000048096170600000480961PA8408172025-10-20False
17060000048099L17/dossiers1717060000048096170600000480962PA7191382025-10-20False
17060000048100L17/dossiers1717060000048096170600000480963PA8419312025-10-20False
17060000048101L17/dossiers1717060000048096170600000480964PA7937962025-10-20False
17060000048102L17/dossiers1717060000048096170600000480965PA29522025-10-20False
17060000048103L17/dossiers1717060000048096170600000480966PA7945542025-10-20False
17060000048104L17/dossiers1717060000048096170600000480967PA7952442025-10-20False
17060000048105L17/dossiers1717060000048096170600000480968PA7214742025-10-20False
17060000048106L17/dossiers1717060000048096170600000480969PA7209602025-10-20False
17060000048110L17/dossiers1717060000048108170600000481081PA8408172025-10-20False
17060000048111L17/dossiers1717060000048108170600000481082PA7191382025-10-20False
17060000048112L17/dossiers1717060000048108170600000481083PA8419312025-10-20False
17060000048113L17/dossiers1717060000048108170600000481084PA7937962025-10-20False
17060000048114L17/dossiers1717060000048108170600000481085PA29522025-10-20False
17060000048115L17/dossiers1717060000048108170600000481086PA7945542025-10-20False
17060000048116L17/dossiers1717060000048108170600000481087PA7952442025-10-20False
17060000048117L17/dossiers1717060000048108170600000481088PA7214742025-10-20False
17060000048118L17/dossiers1717060000048108170600000481089PA7209602025-10-20False
17060000048122L17/dossiers1717060000048120170600000481201PA7188502025-10-14False
17060000048123L17/dossiers1717060000048120170600000481202PA6084162025-10-14False
17060000048124L17/dossiers1717060000048120170600000481203PA7941782025-10-14False
17060000048125L17/dossiers1717060000048120170600000481204PA7223902025-10-14False
17060000048129L17/dossiers1717060000048127170600000481271PA8408292025-10-14False
17060000048130L17/dossiers1717060000048127170600000481272PA8418852025-10-14False
17060000048131L17/dossiers1717060000048127170600000481273PA7191382025-10-14False
17060000048132L17/dossiers1717060000048127170600000481274PA7212102025-10-14False
17060000048133L17/dossiers1717060000048127170600000481275PA7946582025-10-14False
17060000048134L17/dossiers1717060000048127170600000481276PA6056942025-10-14False
17060000048135L17/dossiers1717060000048127170600000481277PA7939802025-10-14False
17060000048136L17/dossiers1717060000048127170600000481278PA7749622025-10-14False
17060000048137L17/dossiers1717060000048127170600000481279PA8407652025-10-14False
17060000048138L17/dossiers17170600000481271706000004812710PA7196322025-10-14False
17060000048139L17/dossiers17170600000481271706000004812711PA7936642025-10-14False
17060000048140L17/dossiers17170600000481271706000004812712PA7947782025-10-14False
17060000048141L17/dossiers17170600000481271706000004812713PA7952402025-10-14False
17060000048142L17/dossiers17170600000481271706000004812714PA3421962025-10-14False
17060000048143L17/dossiers17170600000481271706000004812715PA6065452025-10-14False
17060000048144L17/dossiers17170600000481271706000004812716PA6100022025-10-14False
17060000048145L17/dossiers17170600000481271706000004812717PA7958082025-10-14False
17060000048146L17/dossiers17170600000481271706000004812718PA7960182025-10-14False
17060000048147L17/dossiers17170600000481271706000004812719PA7362012025-10-14False
17060000048148L17/dossiers17170600000481271706000004812720PA29402025-10-14False
17060000048152L17/dossiers1717060000048150170600000481501PA7223902025-12-30False
17060000048153L17/dossiers1717060000048150170600000481502PA7192722025-12-30False
17060000048154L17/dossiers1717060000048150170600000481503PA16302025-12-30False