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
16060000014753L16/dossiers1616060000014745160600000147457PA7948862022-12-15False
16060000014754L16/dossiers1616060000014745160600000147458PA7960422022-12-15False
16060000014755L16/dossiers1616060000014745160600000147459PA7958362022-12-15False
16060000014756L16/dossiers16160600000147451606000001474510PA7946382022-12-15False
16060000014757L16/dossiers16160600000147451606000001474511PA7941982022-12-15False
16060000014758L16/dossiers16160600000147451606000001474512PA7935482022-12-15False
16060000014759L16/dossiers16160600000147451606000001474513PA7956442022-12-15False
16060000014760L16/dossiers16160600000147451606000001474514PA7939282022-12-15False
16060000014761L16/dossiers16160600000147451606000001474515PA7932462022-12-15False
16060000014762L16/dossiers16160600000147451606000001474516PA7946782022-12-15False
16060000014763L16/dossiers16160600000147451606000001474517PA7938922022-12-15False
16060000014764L16/dossiers16160600000147451606000001474518PA7955402022-12-15False
16060000014765L16/dossiers16160600000147451606000001474519PA7947342022-12-15False
16060000014766L16/dossiers16160600000147451606000001474520PA7932182022-12-15False
16060000014767L16/dossiers16160600000147451606000001474521PA7936322022-12-15False
16060000014768L16/dossiers16160600000147451606000001474522PA7940302022-12-15False
16060000014769L16/dossiers16160600000147451606000001474523PA6429882022-12-15False
16060000014770L16/dossiers16160600000147451606000001474524PA7939042022-12-15False
16060000014771L16/dossiers16160600000147451606000001474525PA7219322022-12-15False
16060000014772L16/dossiers16160600000147451606000001474526PA7947702022-12-15False
16060000014773L16/dossiers16160600000147451606000001474527PA7936162022-12-15False
16060000014774L16/dossiers16160600000147451606000001474528PA7194362022-12-15False
16060000014775L16/dossiers16160600000147451606000001474529PA7957862022-12-15False
16060000014776L16/dossiers16160600000147451606000001474530PA7943222022-12-15False
16060000014777L16/dossiers16160600000147451606000001474531PA7936962022-12-15False
16060000014778L16/dossiers16160600000147451606000001474532PA7946702022-12-15False
16060000014779L16/dossiers16160600000147451606000001474533PA7959662022-12-15False
16060000014780L16/dossiers16160600000147451606000001474534PA7932542022-12-15False
16060000014781L16/dossiers16160600000147451606000001474535PA7944422022-12-15False
16060000014782L16/dossiers16160600000147451606000001474536PA7949542022-12-15False
16060000014783L16/dossiers16160600000147451606000001474537PA7960502022-12-15False
16060000014784L16/dossiers16160600000147451606000001474538PA7933822022-12-15False
16060000014785L16/dossiers16160600000147451606000001474539PA7945022022-12-15False
16060000014789L16/dossiers1616060000014787160600000147871PA7193182022-12-15True
16060000014790L16/dossiers1616060000014787160600000147872PA7188842022-12-15True
16060000014791L16/dossiers1616060000014787160600000147873PA7214102022-12-15False
16060000014792L16/dossiers1616060000014787160600000147874PA2667932022-12-15False
16060000014793L16/dossiers1616060000014787160600000147875PA3422402022-12-15False
16060000014794L16/dossiers1616060000014787160600000147876PA3300082022-12-15False
16060000014795L16/dossiers1616060000014787160600000147877PA7935082022-12-15False
16060000014796L16/dossiers1616060000014787160600000147878PA7188382022-12-15False
16060000014797L16/dossiers1616060000014787160600000147879PA2674292022-12-15False
16060000014798L16/dossiers16160600000147871606000001478710PA7223902022-12-15False
16060000014799L16/dossiers16160600000147871606000001478711PA3325232022-12-15False
16060000014800L16/dossiers16160600000147871606000001478712PA3309092022-12-15False
16060000014801L16/dossiers16160600000147871606000001478713PA7203862022-12-15False
16060000014802L16/dossiers16160600000147871606000001478714PA7120152022-12-15False
16060000014803L16/dossiers16160600000147871606000001478715PA7934762022-12-15False
16060000014804L16/dossiers16160600000147871606000001478716PA13272022-12-15False
16060000014805L16/dossiers16160600000147871606000001478717PA2673242022-12-15False