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
17060000077482L17/dossiers17170600000774251706000007742556PA4154792014-03-14False
17060000077483L17/dossiers17170600000774251706000007742557PA3040762014-03-14False
17060000077484L17/dossiers17170600000774251706000007742558PA4060652014-03-14False
17060000077485L17/dossiers17170600000774251706000007742559PA4040732014-03-14False
17060000077486L17/dossiers17170600000774251706000007742560PA3139242014-03-14False
17060000077487L17/dossiers17170600000774251706000007742561PA24442014-03-14False
17060000077488L17/dossiers17170600000774251706000007742562PA3040862014-03-14False
17060000077489L17/dossiers17170600000774251706000007742563PA25052014-03-14False
17060000077490L17/dossiers17170600000774251706000007742564PA4263272014-03-14False
17060000077491L17/dossiers17170600000774251706000007742565PA25382014-03-14False
17060000077492L17/dossiers17170600000774251706000007742566PA25432014-03-14False
17060000077493L17/dossiers17170600000774251706000007742567PA26842014-03-14False
17060000077494L17/dossiers17170600000774251706000007742568PA4298512014-03-14False
17060000077495L17/dossiers17170600000774251706000007742569PA2270942014-03-14False
17060000077496L17/dossiers17170600000774251706000007742570PA3039942014-03-14False
17060000077497L17/dossiers17170600000774251706000007742571PA3039962014-03-14False
17060000077498L17/dossiers17170600000774251706000007742572PA29052014-03-14False
17060000077501L17/dossiers1717060000077499170600000774991PA4154602014-05-16False
17060000077502L17/dossiers1717060000077499170600000774992PA4298642014-05-16False
17060000077503L17/dossiers1717060000077499170600000774993PA27742014-05-16False
17060000077504L17/dossiers1717060000077499170600000774994PA4298972014-05-16False
17060000077505L17/dossiers1717060000077499170600000774995PA4154882014-05-16False
17060000077506L17/dossiers1717060000077499170600000774996PA3412722014-05-16False
17060000077507L17/dossiers1717060000077499170600000774997PA4154592014-05-16False
17060000077508L17/dossiers1717060000077499170600000774998PA2680402014-05-16False
17060000077509L17/dossiers1717060000077499170600000774999PA9442014-05-16False
17060000077510L17/dossiers17170600000774991706000007749910PA12292014-05-16False
17060000077511L17/dossiers17170600000774991706000007749911PA13082014-05-16False
17060000077512L17/dossiers17170600000774991706000007749912PA2270302014-05-16False
17060000077513L17/dossiers17170600000774991706000007749913PA14522014-05-16False
17060000077514L17/dossiers17170600000774991706000007749914PA4154682014-05-16False
17060000077515L17/dossiers17170600000774991706000007749915PA14762014-05-16False
17060000077516L17/dossiers17170600000774991706000007749916PA14872014-05-16False
17060000077517L17/dossiers17170600000774991706000007749917PA4298652014-05-16False
17060000077518L17/dossiers17170600000774991706000007749918PA3040902014-05-16False
17060000077519L17/dossiers17170600000774991706000007749919PA4298322014-05-16False
17060000077520L17/dossiers17170600000774991706000007749920PA4298682014-05-16False
17060000077521L17/dossiers17170600000774991706000007749921PA22722014-05-16False
17060000077522L17/dossiers17170600000774991706000007749922PA24352014-05-16False
17060000077523L17/dossiers17170600000774991706000007749923PA3039952014-05-16False
17060000077524L17/dossiers17170600000774991706000007749924PA27762014-05-16False
17060000077525L17/dossiers17170600000774991706000007749925PA4298382014-05-16False
17060000077526L17/dossiers17170600000774991706000007749926PA4298612014-05-16False
17060000077527L17/dossiers17170600000774991706000007749927PA7034902014-10-01False
17060000077528L17/dossiers17170600000774991706000007749928PA6022014-10-01False
17060000077529L17/dossiers17170600000774991706000007749929PA7332014-10-01False
17060000077530L17/dossiers17170600000774991706000007749930PA7035082014-10-01False
17060000077531L17/dossiers17170600000774991706000007749931PA7035362014-10-01False
17060000077532L17/dossiers17170600000774991706000007749932PA7035332014-10-01False
17060000077533L17/dossiers17170600000774991706000007749933PA7035122014-10-01False