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
17060000035973L17/dossiers17170600000359561706000003595616PA7199222025-05-23False
17060000035974L17/dossiers17170600000359561706000003595617PA7939402025-05-23False
17060000035975L17/dossiers17170600000359561706000003595618PA7194722025-05-23False
17060000035976L17/dossiers17170600000359561706000003595619PA7958642025-05-23False
17060000035977L17/dossiers17170600000359561706000003595620PA7959082025-05-23False
17060000035978L17/dossiers17170600000359561706000003595621PA7191182025-05-23False
17060000035979L17/dossiers17170600000359561706000003595622PA7949822025-05-23False
17060000035980L17/dossiers17170600000359561706000003595623PA7223822025-05-23False
17060000035981L17/dossiers17170600000359561706000003595624PA7201542025-05-23False
17060000035982L17/dossiers17170600000359561706000003595625PA7946582025-05-23False
17060000035983L17/dossiers17170600000359561706000003595626PA7221342025-05-23False
17060000035984L17/dossiers17170600000359561706000003595627PA8402352025-05-23False
17060000035985L17/dossiers17170600000359561706000003595628PA7223662025-05-23False
17060000035986L17/dossiers17170600000359561706000003595629PA7197362025-05-23False
17060000035987L17/dossiers17170600000359561706000003595630PA7223582025-05-23False
17060000035988L17/dossiers17170600000359561706000003595631PA7210242025-05-23False
17060000035989L17/dossiers17170600000359561706000003595632PA7186742025-05-23False
17060000035990L17/dossiers17170600000359561706000003595633PA7212962025-05-23False
17060000035991L17/dossiers17170600000359561706000003595634PA7217642025-05-23False
17060000035992L17/dossiers17170600000359561706000003595635PA8417092025-05-23False
17060000035993L17/dossiers17170600000359561706000003595636PA7203542025-05-23False
17060000035994L17/dossiers17170600000359561706000003595637PA7193722025-05-23False
17060000035995L17/dossiers17170600000359561706000003595638PA6431842025-05-23False
17060000035996L17/dossiers17170600000359561706000003595639PA7197982025-05-23False
17060000035997L17/dossiers17170600000359561706000003595640PA7210042025-05-23False
17060000035998L17/dossiers17170600000359561706000003595641PA8416932025-05-23False
17060000035999L17/dossiers17170600000359561706000003595642PA7200222025-05-23False
17060000036000L17/dossiers17170600000359561706000003595643PA7194122025-05-23False
17060000036001L17/dossiers17170600000359561706000003595644PA7194042025-05-23False
17060000036002L17/dossiers17170600000359561706000003595645PA3457222025-05-23False
17060000036003L17/dossiers17170600000359561706000003595646PA7193882025-05-23False
17060000036004L17/dossiers17170600000359561706000003595647PA7197562025-05-23False
17060000036005L17/dossiers17170600000359561706000003595648PA7203422025-05-23False
17060000036006L17/dossiers17170600000359561706000003595649PA7218522025-05-23False
17060000036007L17/dossiers17170600000359561706000003595650PA7120142025-05-23False
17060000036008L17/dossiers17170600000359561706000003595651PA7953862025-05-23False
17060000036009L17/dossiers17170600000359561706000003595652PA7211342025-05-23False
17060000036010L17/dossiers17170600000359561706000003595653PA8416012025-05-23False
17060000036011L17/dossiers17170600000359561706000003595654PA7204462025-05-23False
17060000036012L17/dossiers17170600000359561706000003595655PA7173792025-05-23False
17060000036013L17/dossiers17170600000359561706000003595656PA7957302025-05-23False
17060000036014L17/dossiers17170600000359561706000003595657PA7942062025-05-23False
17060000036015L17/dossiers17170600000359561706000003595658PA7190802025-05-23False
17060000036016L17/dossiers17170600000359561706000003595659PA7201462025-05-23False
17060000036017L17/dossiers17170600000359561706000003595660PA6774832025-05-23False
17060000036018L17/dossiers17170600000359561706000003595661PA7193382025-05-23False
17060000036019L17/dossiers17170600000359561706000003595662PA7203702025-05-23False
17060000036020L17/dossiers17170600000359561706000003595663PA7951762025-05-23False
17060000036021L17/dossiers17170600000359561706000003595664PA8172032025-05-23False
17060000036022L17/dossiers17170600000359561706000003595665PA7959622025-05-23False