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
16060000016873L16/dossiers16160600000168511606000001685121PA7953102023-01-17False
16060000016874L16/dossiers16160600000168511606000001685122PA7944782023-01-17False
16060000016875L16/dossiers16160600000168511606000001685123PA7940822023-01-17False
16060000016876L16/dossiers16160600000168511606000001685124PA7941302023-01-17False
16060000016877L16/dossiers16160600000168511606000001685125PA7208462023-01-17False
16060000016878L16/dossiers16160600000168511606000001685126PA7957462023-01-17False
16060000016879L16/dossiers16160600000168511606000001685127PA3423842023-01-17False
16060000016880L16/dossiers16160600000168511606000001685128PA7956922023-01-17False
16060000016881L16/dossiers16160600000168511606000001685129PA7940662023-01-17False
16060000016882L16/dossiers16160600000168511606000001685130PA7954222023-01-17False
16060000016883L16/dossiers16160600000168511606000001685131PA7219602023-01-17False
16060000016884L16/dossiers16160600000168511606000001685132PA7208922023-01-17False
16060000016885L16/dossiers16160600000168511606000001685133PA7960622023-01-17False
16060000016886L16/dossiers16160600000168511606000001685134PA7938842023-01-17False
16060000016887L16/dossiers16160600000168511606000001685135PA7959822023-01-17False
16060000016888L16/dossiers16160600000168511606000001685136PA7937242023-01-17False
16060000016889L16/dossiers16160600000168511606000001685137PA7941062023-01-17False
16060000016890L16/dossiers16160600000168511606000001685138PA7941662023-01-17False
16060000016891L16/dossiers16160600000168511606000001685139PA7951642023-01-17False
16060000016892L16/dossiers16160600000168511606000001685140PA7955962023-01-17False
16060000016893L16/dossiers16160600000168511606000001685141PA7931102023-01-17False
16060000016906L16/dossiers1616060000016904160600000169041PA7221502023-01-17True
16060000016907L16/dossiers1616060000016904160600000169042PA6050362023-01-17False
16060000016908L16/dossiers1616060000016904160600000169043PA7198662023-01-17False
16060000016909L16/dossiers1616060000016904160600000169044PA7220382023-01-17False
16060000016910L16/dossiers1616060000016904160600000169045PA7932782023-01-17False
16060000016911L16/dossiers1616060000016904160600000169046PA6059632023-01-17False
16060000016912L16/dossiers1616060000016904160600000169047PA7959502023-01-17False
16060000016913L16/dossiers1616060000016904160600000169048PA7211582023-01-17False
16060000016914L16/dossiers1616060000016904160600000169049PA7191002023-01-17False
16060000016915L16/dossiers16160600000169041606000001690410PA7951442023-01-17False
16060000016916L16/dossiers16160600000169041606000001690411PA7942142023-01-17False
16060000016917L16/dossiers16160600000169041606000001690412PA7215222023-01-17False
16060000016918L16/dossiers16160600000169041606000001690413PA7203622023-01-17False
16060000016919L16/dossiers16160600000169041606000001690414PA7199102023-01-17False
16060000016920L16/dossiers16160600000169041606000001690415PA7218282023-01-17False
16060000016921L16/dossiers16160600000169041606000001690416PA7220462023-01-17False
16060000016922L16/dossiers16160600000169041606000001690417PA7935002023-01-17False
16060000016923L16/dossiers16160600000169041606000001690418PA6426952023-01-17False
16060000016924L16/dossiers16160600000169041606000001690419PA6065072023-01-17False
16060000016925L16/dossiers16160600000169041606000001690420PA7935282023-01-17False
16060000016926L16/dossiers16160600000169041606000001690421PA7190322023-01-17False
16060000016927L16/dossiers16160600000169041606000001690422PA7187102023-01-17False
16060000016928L16/dossiers16160600000169041606000001690423PA7219082023-01-17False
16060000016929L16/dossiers16160600000169041606000001690424PA7959902023-01-17False
16060000016930L16/dossiers16160600000169041606000001690425PA7943302023-01-17False
16060000016931L16/dossiers16160600000169041606000001690426PA7213282023-01-17False
16060000016932L16/dossiers16160600000169041606000001690427PA7198902023-01-17False
16060000016933L16/dossiers16160600000169041606000001690428PA7220002023-01-17False
16060000016934L16/dossiers16160600000169041606000001690429PA7947982023-01-17False