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
17060000077239L17/dossiers1717060000077232170600000772325PA4298862012-11-28False
17060000077240L17/dossiers1717060000077232170600000772326PA10712012-11-28False
17060000077241L17/dossiers1717060000077232170600000772327PA2270272012-11-28False
17060000077242L17/dossiers1717060000077232170600000772328PA4298712012-11-28False
17060000077243L17/dossiers1717060000077232170600000772329PA13112012-11-28False
17060000077244L17/dossiers17170600000772321706000007723210PA13362012-11-28False
17060000077245L17/dossiers17170600000772321706000007723211PA3915052012-11-28False
17060000077246L17/dossiers17170600000772321706000007723212PA6782632012-11-28False
17060000077247L17/dossiers17170600000772321706000007723213PA18672012-11-28False
17060000077248L17/dossiers17170600000772321706000007723214PA4298392012-11-28False
17060000077249L17/dossiers17170600000772321706000007723215PA4154612012-11-28False
17060000077250L17/dossiers17170600000772321706000007723216PA2673952012-11-28False
17060000077251L17/dossiers17170600000772321706000007723217PA28932012-11-28False
17060000077252L17/dossiers17170600000772321706000007723218PA4298412012-11-28False
17060000077255L17/dossiers1717060000077253170600000772531PA4298382013-04-26True
17060000077260L17/dossiers17170600000772581706000007725812013-06-12TruePO77710True
17060000077263L17/dossiers1717060000077261170600000772611PA4298582013-09-09False
17060000077264L17/dossiers1717060000077261170600000772612PA5502013-09-09False
17060000077265L17/dossiers1717060000077261170600000772613PA6958292013-09-09False
17060000077266L17/dossiers1717060000077261170600000772614PA3040852013-09-09False
17060000077267L17/dossiers1717060000077261170600000772615PA7912013-09-09False
17060000077268L17/dossiers1717060000077261170600000772616PA3080372013-09-09False
17060000077269L17/dossiers1717060000077261170600000772617PA8752013-09-09False
17060000077270L17/dossiers1717060000077261170600000772618PA10462013-09-09False
17060000077271L17/dossiers1717060000077261170600000772619PA13442013-09-09False
17060000077272L17/dossiers17170600000772611706000007726110PA15522013-09-09False
17060000077273L17/dossiers17170600000772611706000007726111PA3946762013-09-09False
17060000077274L17/dossiers17170600000772611706000007726112PA18422013-09-09False
17060000077275L17/dossiers17170600000772611706000007726113PA3040862013-09-09False
17060000077276L17/dossiers17170600000772611706000007726114PA25432013-09-09False
17060000077277L17/dossiers17170600000772611706000007726115PA3039942013-09-09False
17060000077278L17/dossiers17170600000772611706000007726116PA3039962013-09-09False
17060000077279L17/dossiers17170600000772611706000007726117PA28442013-09-09False
17060000077280L17/dossiers17170600000772611706000007726118PA29052013-09-09False
17060000077308L17/dossiers1717060000077306170600000773061PA4082013-10-08False
17060000077309L17/dossiers1717060000077306170600000773062PA9052013-10-08False
17060000077310L17/dossiers1717060000077306170600000773063PA2232312013-10-08False
17060000077311L17/dossiers1717060000077306170600000773064PA16672013-10-08False
17060000077312L17/dossiers1717060000077306170600000773065PA4154642013-10-08False
17060000077313L17/dossiers1717060000077306170600000773066PA6774832013-10-08False
17060000077314L17/dossiers1717060000077306170600000773067PA4154822013-10-08False
17060000077315L17/dossiers1717060000077306170600000773068PA24262013-10-08False
17060000077316L17/dossiers1717060000077306170600000773069PA4298952013-10-08False
17060000077317L17/dossiers17170600000773061706000007730610PA3245392013-10-08False
17060000077318L17/dossiers17170600000773061706000007730611PA4154802013-10-08False
17060000077319L17/dossiers17170600000773061706000007730612PA3132082013-10-08False
17060000077322L17/dossiers1717060000077320170600000773201PA2271082013-12-03False
17060000077323L17/dossiers1717060000077320170600000773202PA4298582013-12-03False
17060000077324L17/dossiers1717060000077320170600000773203PA4282013-12-03False
17060000077325L17/dossiers1717060000077320170600000773204PA3040772013-12-03False