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
17060000077432L17/dossiers1717060000077425170600000774256PA2275952014-03-14False
17060000077433L17/dossiers1717060000077425170600000774257PA6958292014-03-14False
17060000077434L17/dossiers1717060000077425170600000774258PA3040772014-03-14False
17060000077435L17/dossiers1717060000077425170600000774259PA4154562014-03-14False
17060000077436L17/dossiers17170600000774251706000007742510PA3040852014-03-14False
17060000077437L17/dossiers17170600000774251706000007742511PA7252014-03-14False
17060000077438L17/dossiers17170600000774251706000007742512PA4298702014-03-14False
17060000077439L17/dossiers17170600000774251706000007742513PA4298622014-03-14False
17060000077440L17/dossiers17170600000774251706000007742514PA7912014-03-14False
17060000077441L17/dossiers17170600000774251706000007742515PA3080372014-03-14False
17060000077442L17/dossiers17170600000774251706000007742516PA2274402014-03-14False
17060000077443L17/dossiers17170600000774251706000007742517PA9352014-03-14False
17060000077444L17/dossiers17170600000774251706000007742518PA9452014-03-14False
17060000077445L17/dossiers17170600000774251706000007742519PA3040792014-03-14False
17060000077446L17/dossiers17170600000774251706000007742520PA10192014-03-14False
17060000077447L17/dossiers17170600000774251706000007742521PA4253222014-03-14False
17060000077448L17/dossiers17170600000774251706000007742522PA11422014-03-14False
17060000077449L17/dossiers17170600000774251706000007742523PA11582014-03-14False
17060000077450L17/dossiers17170600000774251706000007742524PA4298342014-03-14False
17060000077451L17/dossiers17170600000774251706000007742525PA11832014-03-14False
17060000077452L17/dossiers17170600000774251706000007742526PA11922014-03-14False
17060000077453L17/dossiers17170600000774251706000007742527PA2674192014-03-14False
17060000077454L17/dossiers17170600000774251706000007742528PA2677882014-03-14False
17060000077455L17/dossiers17170600000774251706000007742529PA13012014-03-14False
17060000077456L17/dossiers17170600000774251706000007742530PA13442014-03-14False
17060000077457L17/dossiers17170600000774251706000007742531PA4154542014-03-14False
17060000077458L17/dossiers17170600000774251706000007742532PA13752014-03-14False
17060000077459L17/dossiers17170600000774251706000007742533PA14432014-03-14False
17060000077460L17/dossiers17170600000774251706000007742534PA4154732014-03-14False
17060000077461L17/dossiers17170600000774251706000007742535PA15272014-03-14False
17060000077462L17/dossiers17170600000774251706000007742536PA15522014-03-14False
17060000077463L17/dossiers17170600000774251706000007742537PA2270782014-03-14False
17060000077464L17/dossiers17170600000774251706000007742538PA16322014-03-14False
17060000077465L17/dossiers17170600000774251706000007742539PA16602014-03-14False
17060000077466L17/dossiers17170600000774251706000007742540PA3047372014-03-14False
17060000077467L17/dossiers17170600000774251706000007742541PA4298752014-03-14False
17060000077468L17/dossiers17170600000774251706000007742542PA4154762014-03-14False
17060000077469L17/dossiers17170600000774251706000007742543PA3946762014-03-14False
17060000077470L17/dossiers17170600000774251706000007742544PA3040002014-03-14False
17060000077471L17/dossiers17170600000774251706000007742545PA4154512014-03-14False
17060000077472L17/dossiers17170600000774251706000007742546PA2270872014-03-14False
17060000077473L17/dossiers17170600000774251706000007742547PA4154472014-03-14False
17060000077474L17/dossiers17170600000774251706000007742548PA19192014-03-14False
17060000077475L17/dossiers17170600000774251706000007742549PA4154672014-03-14False
17060000077476L17/dossiers17170600000774251706000007742550PA2270882014-03-14False
17060000077477L17/dossiers17170600000774251706000007742551PA19932014-03-14False
17060000077478L17/dossiers17170600000774251706000007742552PA11722014-03-14False
17060000077479L17/dossiers17170600000774251706000007742553PA6914752014-03-14False
17060000077480L17/dossiers17170600000774251706000007742554PA4154892014-03-14False
17060000077481L17/dossiers17170600000774251706000007742555PA21972014-03-14False