AN · données ouvertes
Explorateur / dossiers

dossiers.document_co_signataire

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

305 151 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 25 %, 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
17060000011601L17/dossiers17170600000115801706000001158020PA3467822025-02-17False
17060000011602L17/dossiers17170600000115801706000001158021PA7940382025-02-17False
17060000011606L17/dossiers1717060000011604170600000116041PA7934322025-03-07False
17060000011607L17/dossiers1717060000011604170600000116042PA8412072025-03-07False
17060000011608L17/dossiers1717060000011604170600000116043PA8414952025-03-07False
17060000011609L17/dossiers1717060000011604170600000116044PA7961182025-03-07False
17060000011610L17/dossiers1717060000011604170600000116045PA7945622025-03-07False
17060000011611L17/dossiers1717060000011604170600000116046PA7932382025-03-07False
17060000011612L17/dossiers1717060000011604170600000116047PA7933742025-03-07False
17060000011613L17/dossiers1717060000011604170600000116048PA7931582025-03-07False
17060000011614L17/dossiers1717060000011604170600000116049PA8416452025-03-07False
17060000011615L17/dossiers17170600000116041706000001160410PA8420012025-03-07False
17060000011616L17/dossiers17170600000116041706000001160411PA7208222025-03-07False
17060000011617L17/dossiers17170600000116041706000001160412PA7206682025-03-07False
17060000011618L17/dossiers17170600000116041706000001160413PA7960422025-03-07False
17060000011619L17/dossiers17170600000116041706000001160414PA7938442025-03-07False
17060000011620L17/dossiers17170600000116041706000001160415PA8414872025-03-07False
17060000011621L17/dossiers17170600000116041706000001160416PA8411312025-03-07False
17060000011622L17/dossiers17170600000116041706000001160417PA7931822025-03-07False
17060000011623L17/dossiers17170600000116041706000001160418PA7931342025-03-07False
17060000011624L17/dossiers17170600000116041706000001160419PA8400752025-03-07False
17060000011625L17/dossiers17170600000116041706000001160420PA8407212025-03-07False
17060000011626L17/dossiers17170600000116041706000001160421PA7204682025-03-07False
17060000011627L17/dossiers17170600000116041706000001160422PA7941982025-03-07False
17060000011628L17/dossiers17170600000116041706000001160423PA8401592025-03-07False
17060000011629L17/dossiers17170600000116041706000001160424PA7935482025-03-07False
17060000011630L17/dossiers17170600000116041706000001160425PA7956442025-03-07False
17060000011631L17/dossiers17170600000116041706000001160426PA8401192025-03-07False
17060000011632L17/dossiers17170600000116041706000001160427PA7931662025-03-07False
17060000011633L17/dossiers17170600000116041706000001160428PA7947622025-03-07False
17060000011634L17/dossiers17170600000116041706000001160429PA7931462025-03-07False
17060000011635L17/dossiers17170600000116041706000001160430PA8401352025-03-07False
17060000011636L17/dossiers17170600000116041706000001160431PA7947182025-03-07False
17060000011637L17/dossiers17170600000116041706000001160432PA7932462025-03-07False
17060000011638L17/dossiers17170600000116041706000001160433PA8407732025-03-07False
17060000011639L17/dossiers17170600000116041706000001160434PA8401432025-03-07False
17060000011640L17/dossiers17170600000116041706000001160435PA8408012025-03-07False
17060000011641L17/dossiers17170600000116041706000001160436PA7946782025-03-07False
17060000011642L17/dossiers17170600000116041706000001160437PA7938922025-03-07False
17060000011643L17/dossiers17170600000116041706000001160438PA8417372025-03-07False
17060000011644L17/dossiers17170600000116041706000001160439PA7960342025-03-07False
17060000011645L17/dossiers17170600000116041706000001160440PA7938322025-03-07False
17060000011646L17/dossiers17170600000116041706000001160441PA7931022025-03-07False
17060000011647L17/dossiers17170600000116041706000001160442PA7933622025-03-07False
17060000011648L17/dossiers17170600000116041706000001160443PA7944182025-03-07False
17060000011649L17/dossiers17170600000116041706000001160444PA7935922025-03-07False
17060000011650L17/dossiers17170600000116041706000001160445PA8414512025-03-07False
17060000011651L17/dossiers17170600000116041706000001160446PA7932182025-03-07False
17060000011652L17/dossiers17170600000116041706000001160447PA7936322025-03-07False
17060000011653L17/dossiers17170600000116041706000001160448PA7945982025-03-07False