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
16060000016380L16/dossiers16160600000163251606000001632554PA7931662023-01-17False
16060000016381L16/dossiers16160600000163251606000001632555PA7939282023-01-17False
16060000016382L16/dossiers16160600000163251606000001632556PA7947622023-01-17False
16060000016383L16/dossiers16160600000163251606000001632557PA7931462023-01-17False
16060000016384L16/dossiers16160600000163251606000001632558PA7939642023-01-17False
16060000016385L16/dossiers16160600000163251606000001632559PA7945382023-01-17False
16060000016386L16/dossiers16160600000163251606000001632560PA7938922023-01-17False
16060000016387L16/dossiers16160600000163251606000001632561PA7960342023-01-17False
16060000016388L16/dossiers16160600000163251606000001632562PA7938322023-01-17False
16060000016389L16/dossiers16160600000163251606000001632563PA7936082023-01-17False
16060000016393L16/dossiers1616060000016391160600000163911PA7939482023-01-17True
16060000016394L16/dossiers1616060000016391160600000163912PA7952282023-01-17False
16060000016395L16/dossiers1616060000016391160600000163913PA7949062023-01-17False
16060000016396L16/dossiers1616060000016391160600000163914PA7955882023-01-17False
16060000016397L16/dossiers1616060000016391160600000163915PA7950842023-01-17False
16060000016398L16/dossiers1616060000016391160600000163916PA5888842023-01-17False
16060000016399L16/dossiers1616060000016391160600000163917PA7204302023-01-17False
16060000016400L16/dossiers1616060000016391160600000163918PA7937722023-01-17False
16060000016401L16/dossiers1616060000016391160600000163919PA7956162023-01-17False
16060000016402L16/dossiers16160600000163911606000001639110PA7949382023-01-17False
16060000016403L16/dossiers16160600000163911606000001639111PA7939122023-01-17False
16060000016404L16/dossiers16160600000163911606000001639112PA7955802023-01-17False
16060000016405L16/dossiers16160600000163911606000001639113PA7937362023-01-17False
16060000016406L16/dossiers16160600000163911606000001639114PA7212022023-01-17False
16060000016407L16/dossiers16160600000163911606000001639115PA7951362023-01-17False
16060000016408L16/dossiers16160600000163911606000001639116PA7936802023-01-17False
16060000016409L16/dossiers16160600000163911606000001639117PA7934522023-01-17False
16060000016410L16/dossiers16160600000163911606000001639118PA10082023-01-17False
16060000016411L16/dossiers16160600000163911606000001639119PA7952002023-01-17False
16060000016412L16/dossiers16160600000163911606000001639120PA7958442023-01-17False
16060000016413L16/dossiers16160600000163911606000001639121PA7944582023-01-17False
16060000016414L16/dossiers16160600000163911606000001639122PA7218962023-01-17False
16060000016415L16/dossiers16160600000163911606000001639123PA7947862023-01-17False
16060000016416L16/dossiers16160600000163911606000001639124PA7948702023-01-17False
16060000016417L16/dossiers16160600000163911606000001639125PA7961322023-01-17False
16060000016418L16/dossiers16160600000163911606000001639126PA7953102023-01-17False
16060000016419L16/dossiers16160600000163911606000001639127PA7944782023-01-17False
16060000016420L16/dossiers16160600000163911606000001639128PA7940822023-01-17False
16060000016421L16/dossiers16160600000163911606000001639129PA7208462023-01-17False
16060000016422L16/dossiers16160600000163911606000001639130PA7955162023-01-17False
16060000016423L16/dossiers16160600000163911606000001639131PA7951842023-01-17False
16060000016424L16/dossiers16160600000163911606000001639132PA7951082023-01-17False
16060000016425L16/dossiers16160600000163911606000001639133PA7944022023-01-17False
16060000016426L16/dossiers16160600000163911606000001639134PA7935322023-01-17False
16060000016427L16/dossiers16160600000163911606000001639135PA7936882023-01-17False
16060000016428L16/dossiers16160600000163911606000001639136PA3423842023-01-17False
16060000016429L16/dossiers16160600000163911606000001639137PA7940662023-01-17False
16060000016430L16/dossiers16160600000163911606000001639138PA7954222023-01-17False
16060000016431L16/dossiers16160600000163911606000001639139PA7954822023-01-17False
16060000016432L16/dossiers16160600000163911606000001639140PA7958202023-01-17False