Aller au contenu
blackout

dossiers.document_co_signataire

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

309 130 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
17060000077378L17/dossiers1717060000077373170600000773734PA7822013-12-18False
17060000077379L17/dossiers1717060000077373170600000773735PA4298722013-12-18False
17060000077380L17/dossiers1717060000077373170600000773736PA4298782013-12-18False
17060000077381L17/dossiers1717060000077373170600000773737PA9442013-12-18False
17060000077382L17/dossiers1717060000077373170600000773738PA4154832013-12-18False
17060000077383L17/dossiers1717060000077373170600000773739PA10482013-12-18False
17060000077384L17/dossiers17170600000773731706000007737310PA11442013-12-18False
17060000077385L17/dossiers17170600000773731706000007737311PA4298332013-12-18False
17060000077386L17/dossiers17170600000773731706000007737312PA4298502013-12-18False
17060000077387L17/dossiers17170600000773731706000007737313PA4154682013-12-18False
17060000077388L17/dossiers17170600000773731706000007737314PA14762013-12-18False
17060000077389L17/dossiers17170600000773731706000007737315PA15022013-12-18False
17060000077390L17/dossiers17170600000773731706000007737316PA4154522013-12-18False
17060000077391L17/dossiers17170600000773731706000007737317PA2270832013-12-18False
17060000077392L17/dossiers17170600000773731706000007737318PA4298652013-12-18False
17060000077393L17/dossiers17170600000773731706000007737319PA17792013-12-18False
17060000077394L17/dossiers17170600000773731706000007737320PA4154702013-12-18False
17060000077395L17/dossiers17170600000773731706000007737321PA2107412013-12-18False
17060000077396L17/dossiers17170600000773731706000007737322PA19982013-12-18False
17060000077397L17/dossiers17170600000773731706000007737323PA20272013-12-18False
17060000077398L17/dossiers17170600000773731706000007737324PA20562013-12-18False
17060000077399L17/dossiers17170600000773731706000007737325PA4298682013-12-18False
17060000077400L17/dossiers17170600000773731706000007737326PA21832013-12-18False
17060000077401L17/dossiers17170600000773731706000007737327PA4154662013-12-18False
17060000077402L17/dossiers17170600000773731706000007737328PA4154572013-12-18False
17060000077403L17/dossiers17170600000773731706000007737329PA23342013-12-18False
17060000077404L17/dossiers17170600000773731706000007737330PA23372013-12-18False
17060000077405L17/dossiers17170600000773731706000007737331PA4154632013-12-18False
17060000077406L17/dossiers17170600000773731706000007737332PA24762013-12-18False
17060000077407L17/dossiers17170600000773731706000007737333PA3246072013-12-18False
17060000077408L17/dossiers17170600000773731706000007737334PA2270922013-12-18False
17060000077409L17/dossiers17170600000773731706000007737335PA4154962013-12-18False
17060000077410L17/dossiers17170600000773731706000007737336PA25282013-12-18False
17060000077411L17/dossiers17170600000773731706000007737337PA27762013-12-18False
17060000077412L17/dossiers17170600000773731706000007737338PA4298522013-12-18False
17060000077413L17/dossiers17170600000773731706000007737339PA3041132013-12-18False
17060000077416L17/dossiers1717060000077414170600000774141PA10752014-01-16False
17060000077417L17/dossiers1717060000077414170600000774142PA2270292014-01-16False
17060000077418L17/dossiers1717060000077414170600000774143PA4298492014-01-16False
17060000077419L17/dossiers1717060000077414170600000774144PA2270992014-01-16False
17060000077420L17/dossiers1717060000077414170600000774145PA4298872014-01-16False
17060000077421L17/dossiers1717060000077414170600000774146PA4298632014-01-16False
17060000077422L17/dossiers1717060000077414170600000774147PA4298962014-01-16False
17060000077423L17/dossiers1717060000077414170600000774148PA2622014-01-16False
17060000077424L17/dossiers1717060000077414170600000774149PA22272014-01-16False
17060000077427L17/dossiers1717060000077425170600000774251PA2692014-03-14False
17060000077428L17/dossiers1717060000077425170600000774252PA2271082014-03-14False
17060000077429L17/dossiers1717060000077425170600000774253PA4298582014-03-14False
17060000077430L17/dossiers1717060000077425170600000774254PA4192014-03-14False
17060000077431L17/dossiers1717060000077425170600000774255PA4452014-03-14False