Aller au contenu
blackout

dossiers.document_co_signataire

Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %

309 756 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 26 %, 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
16060000015074L16/dossiers1616060000015068160600000150685PA7945222022-12-15False
16060000015075L16/dossiers1616060000015068160600000150686PA7208222022-12-15False
16060000015076L16/dossiers1616060000015068160600000150687PA7948862022-12-15False
16060000015077L16/dossiers1616060000015068160600000150688PA7946382022-12-15False
16060000015078L16/dossiers1616060000015068160600000150689PA7204682022-12-15False
16060000015079L16/dossiers16160600000150681606000001506810PA7935482022-12-15False
16060000015080L16/dossiers16160600000150681606000001506811PA7942222022-12-15False
16060000015081L16/dossiers16160600000150681606000001506812PA7956442022-12-15False
16060000015082L16/dossiers16160600000150681606000001506813PA7931462022-12-15False
16060000015083L16/dossiers16160600000150681606000001506814PA7932462022-12-15False
16060000015084L16/dossiers16160600000150681606000001506815PA7938922022-12-15False
16060000015085L16/dossiers16160600000150681606000001506816PA7960342022-12-15False
16060000015086L16/dossiers16160600000150681606000001506817PA7931022022-12-15False
16060000015087L16/dossiers16160600000150681606000001506818PA7955402022-12-15False
16060000015088L16/dossiers16160600000150681606000001506819PA7947342022-12-15False
16060000015089L16/dossiers16160600000150681606000001506820PA7945982022-12-15False
16060000015090L16/dossiers16160600000150681606000001506821PA7959122022-12-15False
16060000015091L16/dossiers16160600000150681606000001506822PA7960262022-12-15False
16060000015092L16/dossiers16160600000150681606000001506823PA7932902022-12-15False
16060000015093L16/dossiers16160600000150681606000001506824PA6429882022-12-15False
16060000015094L16/dossiers16160600000150681606000001506825PA7936722022-12-15False
16060000015095L16/dossiers16160600000150681606000001506826PA7219322022-12-15False
16060000015096L16/dossiers16160600000150681606000001506827PA7959742022-12-15False
16060000015097L16/dossiers16160600000150681606000001506828PA7947702022-12-15False
16060000015098L16/dossiers16160600000150681606000001506829PA7933302022-12-15False
16060000015099L16/dossiers16160600000150681606000001506830PA7938522022-12-15False
16060000015100L16/dossiers16160600000150681606000001506831PA7955522022-12-15False
16060000015101L16/dossiers16160600000150681606000001506832PA7946702022-12-15False
16060000015102L16/dossiers16160600000150681606000001506833PA7959662022-12-15False
16060000015103L16/dossiers16160600000150681606000001506834PA7932302022-12-15False
16060000015104L16/dossiers16160600000150681606000001506835PA7932542022-12-15False
16060000015105L16/dossiers16160600000150681606000001506836PA7944422022-12-15False
16060000015106L16/dossiers16160600000150681606000001506837PA7945702022-12-15False
16060000015107L16/dossiers16160600000150681606000001506838PA7945022022-12-15False
16060000015118L16/dossiers1616060000015116160600000151161PA6428472022-12-15False
16060000015119L16/dossiers1616060000015116160600000151162PA7188842022-12-15False
16060000015120L16/dossiers1616060000015116160600000151163PA7214102022-12-15False
16060000015121L16/dossiers1616060000015116160600000151164PA3422402022-12-15False
16060000015122L16/dossiers1616060000015116160600000151165PA7935082022-12-15False
16060000015123L16/dossiers1616060000015116160600000151166PA7223902022-12-15False
16060000015124L16/dossiers1616060000015116160600000151167PA3325232022-12-15False
16060000015125L16/dossiers1616060000015116160600000151168PA6088262022-12-15False
16060000015126L16/dossiers1616060000015116160600000151169PA13272022-12-15False
16060000015127L16/dossiers16160600000151161606000001511610PA2673242022-12-15False
16060000015128L16/dossiers16160600000151161606000001511611PA6059912022-12-15False
16060000015129L16/dossiers16160600000151161606000001511612PA16302022-12-15False
16060000015130L16/dossiers16160600000151161606000001511613PA6084162022-12-15False
16060000015131L16/dossiers16160600000151161606000001511614PA3467822022-12-15False
16060000015132L16/dossiers16160600000151161606000001511615PA18742022-12-15False
16060000015133L16/dossiers16160600000151161606000001511616PA6080162022-12-15False