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 264 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
17060000026931L17/dossiers171706000002668517060000026685245PA7195782025-03-31False
17060000026932L17/dossiers171706000002668517060000026685246PA8410912025-03-31False
17060000026933L17/dossiers171706000002668517060000026685247PA8266352025-02-142025-03-03False
17060000026934L17/dossiers171706000002668517060000026685248PA7210622025-03-31False
17060000026935L17/dossiers171706000002668517060000026685249PA8416812025-03-31False
17060000026936L17/dossiers171706000002668517060000026685250PA7959822025-03-31False
17060000026937L17/dossiers171706000002668517060000026685251PA7944942025-03-31False
17060000026938L17/dossiers171706000002668517060000026685252PA7954662025-03-31False
17060000026939L17/dossiers171706000002668517060000026685253PA7209922025-03-31False
17060000026940L17/dossiers171706000002668517060000026685254PA7937442025-03-31False
17060000026941L17/dossiers171706000002668517060000026685255PA7960902025-03-31False
17060000026942L17/dossiers171706000002668517060000026685256PA7951642025-03-31False
17060000026943L17/dossiers171706000002668517060000026685257PA7955962025-03-31False
17060000026944L17/dossiers171706000002668517060000026685258PA7941662025-03-31False
17060000026945L17/dossiers171706000002668517060000026685259PA7947502025-03-31False
17060000026946L17/dossiers171706000002668517060000026685260PA2667972025-03-31False
17060000026950L17/dossiers1717060000026948170600000269481PA7931742025-02-13False
17060000026951L17/dossiers1717060000026948170600000269482PA7749622025-02-13False
17060000026952L17/dossiers1717060000026948170600000269483PA7961062025-02-13False
17060000026953L17/dossiers1717060000026948170600000269484PA7208382025-02-13False
17060000026954L17/dossiers1717060000026948170600000269485PA7958682025-02-13False
17060000026955L17/dossiers1717060000026948170600000269486PA2673062025-02-13False
17060000026956L17/dossiers1717060000026948170600000269487PA7218962025-02-13False
17060000026957L17/dossiers1717060000026948170600000269488PA7959982025-02-13False
17060000026958L17/dossiers1717060000026948170600000269489PA3356122025-02-13False
17060000026959L17/dossiers17170600000269481706000002694810PA8422712025-02-13False
17060000026960L17/dossiers17170600000269481706000002694811PA7958202025-02-13False
17060000026961L17/dossiers17170600000269481706000002694812PA7212702025-02-13False
17060000026962L17/dossiers17170600000269481706000002694813PA7952402025-02-13False
17060000026963L17/dossiers17170600000269481706000002694814PA7958762025-02-13False
17060000026964L17/dossiers17170600000269481706000002694815PA6057452025-02-13False
17060000026965L17/dossiers17170600000269481706000002694816PA8422992025-02-13False
17060000026969L17/dossiers1717060000026967170600000269671PA7935322025-02-18False
17060000026970L17/dossiers1717060000026967170600000269672PA7749582025-02-18False
17060000026971L17/dossiers1717060000026967170600000269673PA7956362025-02-18False
17060000026972L17/dossiers1717060000026967170600000269674PA7954222025-02-18False
17060000026973L17/dossiers1717060000026967170600000269675PA8422712025-02-18False
17060000026974L17/dossiers1717060000026967170600000269676PA7946862025-02-18False
17060000026975L17/dossiers1717060000026967170600000269677PA8414632025-02-18False
17060000026976L17/dossiers1717060000026967170600000269678PA8412152025-02-18False
17060000026977L17/dossiers1717060000026967170600000269679PA7954822025-02-18False
17060000026978L17/dossiers17170600000269671706000002696710PA7958202025-02-18False
17060000026979L17/dossiers17170600000269671706000002696711PA7219602025-02-18False
17060000026980L17/dossiers17170600000269671706000002696712PA8420452025-02-18False
17060000026981L17/dossiers17170600000269671706000002696713PA7208922025-02-18False
17060000026982L17/dossiers17170600000269671706000002696714PA7212702025-02-18False
17060000026983L17/dossiers17170600000269671706000002696715PA7937082025-02-18False
17060000026984L17/dossiers17170600000269671706000002696716PA8172112025-02-18False
17060000026985L17/dossiers17170600000269671706000002696717PA3424152025-02-18False
17060000026986L17/dossiers17170600000269671706000002696718PA7940222025-02-18False