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
17060000011704L17/dossiers17170600000116041706000001160499PA8414792025-03-07False
17060000011705L17/dossiers171706000001160417060000011604100PA8417612025-03-07False
17060000011712L17/dossiers1717060000011710170600000117101PA7194122026-04-01False
17060000011713L17/dossiers1717060000011710170600000117102PA6073952026-04-01False
17060000011714L17/dossiers1717060000011710170600000117103PA7935202026-04-01False
17060000011715L17/dossiers1717060000011710170600000117104PA7200382026-04-01False
17060000011716L17/dossiers1717060000011710170600000117105PA8413392026-04-01False
17060000011717L17/dossiers1717060000011710170600000117106PA2677802026-04-01False
17060000011718L17/dossiers1717060000011710170600000117107PA7190242026-04-01False
17060000011719L17/dossiers1717060000011710170600000117108PA7220002026-04-01False
17060000011720L17/dossiers1717060000011710170600000117109PA7935722026-04-01False
17060000011721L17/dossiers17170600000117101706000001171010PA7214262026-04-01False
17060000011722L17/dossiers17170600000117101706000001171011PA7952582026-04-01False
17060000011723L17/dossiers17170600000117101706000001171012PA7948382026-04-01False
17060000011724L17/dossiers17170600000117101706000001171013PA7952782026-04-01False
17060000011725L17/dossiers17170600000117101706000001171014PA7203422026-04-01False
17060000011726L17/dossiers17170600000117101706000001171015PA7942342026-04-01False
17060000011727L17/dossiers17170600000117101706000001171016PA7193382026-04-01False
17060000011728L17/dossiers17170600000117101706000001171017PA7192862026-04-01False
17060000011729L17/dossiers17170600000117101706000001171018PA7191382026-04-01False
17060000011730L17/dossiers17170600000117101706000001171019PA7209082026-04-01False
17060000011731L17/dossiers17170600000117101706000001171020PA7195502026-04-01False
17060000011732L17/dossiers17170600000117101706000001171021PA7221022026-04-01False
17060000011733L17/dossiers17170600000117101706000001171022PA6774832026-04-01False
17060000011734L17/dossiers17170600000117101706000001171023PA7194042026-04-01False
17060000011735L17/dossiers17170600000117101706000001171024PA6426952026-04-01False
17060000011736L17/dossiers17170600000117101706000001171025PA6071932026-04-01False
17060000011737L17/dossiers17170600000117101706000001171026PA6056942026-04-01False
17060000011738L17/dossiers17170600000117101706000001171027PA7223662026-04-01False
17060000011739L17/dossiers17170600000117101706000001171028PA7944262026-04-01False
17060000011740L17/dossiers17170600000117101706000001171029PA6088262026-04-01False
17060000011741L17/dossiers17170600000117101706000001171030PA7932702026-04-01False
17060000011742L17/dossiers17170600000117101706000001171031PA7190322026-04-01False
17060000011743L17/dossiers17170600000117101706000001171032PA7953302026-04-01False
17060000011744L17/dossiers17170600000117101706000001171033PA7201542026-04-01False
17060000011745L17/dossiers17170600000117101706000001171034PA6076192026-04-01False
17060000011746L17/dossiers17170600000117101706000001171035PA2677632026-04-01False
17060000011747L17/dossiers17170600000117101706000001171036PA7218442026-04-01False
17060000011748L17/dossiers17170600000117101706000001171037PA7957222026-04-01False
17060000011749L17/dossiers17170600000117101706000001171038PA7947022026-04-01False
17060000011750L17/dossiers17170600000117101706000001171039PA7946582026-04-01False
17060000011751L17/dossiers17170600000117101706000001171040PA7937802024-10-152024-12-16False
17060000011752L17/dossiers17170600000117101706000001171041PA7212342026-04-01False
17060000011753L17/dossiers17170600000117101706000001171042PA13272026-04-01False
17060000011754L17/dossiers17170600000117101706000001171043PA7930942026-04-01False
17060000011758L17/dossiers1717060000011756170600000117561PA3422402024-10-15False
17060000011759L17/dossiers1717060000011756170600000117562PA7935082024-10-15False
17060000011760L17/dossiers1717060000011756170600000117563PA7223902024-10-15False
17060000011761L17/dossiers1717060000011756170600000117564PA7940582024-10-15False
17060000011762L17/dossiers1717060000011756170600000117565PA7933422024-10-15False