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
17060000023557L17/dossiers17170600000234701706000002347086PA8418932025-02-04False
17060000023561L17/dossiers1717060000023559170600000235591PA7208922025-01-21False
17060000023562L17/dossiers1717060000023559170600000235592PA7952282025-01-21False
17060000023563L17/dossiers1717060000023559170600000235593PA7932622025-01-21False
17060000023564L17/dossiers1717060000023559170600000235594PA7949062025-01-21False
17060000023565L17/dossiers1717060000023559170600000235595PA7941382025-01-21False
17060000023566L17/dossiers1717060000023559170600000235596PA7955882025-01-21False
17060000023567L17/dossiers1717060000023559170600000235597PA7950842025-01-21False
17060000023568L17/dossiers1717060000023559170600000235598PA8421052025-01-21False
17060000023569L17/dossiers1717060000023559170600000235599PA8416572025-01-21False
17060000023570L17/dossiers17170600000235591706000002355910PA7204302025-01-21False
17060000023571L17/dossiers17170600000235591706000002355911PA7937722025-01-21False
17060000023572L17/dossiers17170600000235591706000002355912PA7956162025-01-21False
17060000023573L17/dossiers17170600000235591706000002355913PA7934442025-01-21False
17060000023574L17/dossiers17170600000235591706000002355914PA7949382025-01-21False
17060000023575L17/dossiers17170600000235591706000002355915PA7953182025-01-21False
17060000023576L17/dossiers17170600000235591706000002355916PA8410232025-01-21False
17060000023577L17/dossiers17170600000235591706000002355917PA7960902025-01-21False
17060000023578L17/dossiers17170600000235591706000002355918PA7939122025-01-21False
17060000023579L17/dossiers17170600000235591706000002355919PA8421872025-01-21False
17060000023580L17/dossiers17170600000235591706000002355920PA8420372025-01-21False
17060000023581L17/dossiers17170600000235591706000002355921PA7918122025-01-21False
17060000023582L17/dossiers17170600000235591706000002355922PA7212022025-01-21False
17060000023583L17/dossiers17170600000235591706000002355923PA7951362025-01-21False
17060000023584L17/dossiers17170600000235591706000002355924PA7934642025-01-21False
17060000023585L17/dossiers17170600000235591706000002355925PA8421552025-01-21False
17060000023586L17/dossiers17170600000235591706000002355926PA7952002025-01-21False
17060000023587L17/dossiers17170600000235591706000002355927PA7958442025-01-21False
17060000023588L17/dossiers17170600000235591706000002355928PA8412512025-01-21False
17060000023589L17/dossiers17170600000235591706000002355929PA7947862025-01-21False
17060000023590L17/dossiers17170600000235591706000002355930PA7948702025-01-21False
17060000023591L17/dossiers17170600000235591706000002355931PA7960702025-01-21False
17060000023592L17/dossiers17170600000235591706000002355932PA7953102025-01-21False
17060000023593L17/dossiers17170600000235591706000002355933PA7944782025-01-21False
17060000023594L17/dossiers17170600000235591706000002355934PA8419472025-01-21False
17060000023595L17/dossiers17170600000235591706000002355935PA7940822025-01-21False
17060000023596L17/dossiers17170600000235591706000002355936PA7941302025-01-21False
17060000023597L17/dossiers17170600000235591706000002355937PA7208462025-01-21False
17060000023598L17/dossiers17170600000235591706000002355938PA8417292025-01-21False
17060000023599L17/dossiers17170600000235591706000002355939PA7955162025-01-21False
17060000023600L17/dossiers17170600000235591706000002355940PA7956722025-01-21False
17060000023601L17/dossiers17170600000235591706000002355941PA8415152025-01-21False
17060000023602L17/dossiers17170600000235591706000002355942PA7957462025-01-21False
17060000023603L17/dossiers17170600000235591706000002355943PA7951082025-01-21False
17060000023604L17/dossiers17170600000235591706000002355944PA7952982025-01-21False
17060000023605L17/dossiers17170600000235591706000002355945PA7918242025-01-21False
17060000023606L17/dossiers17170600000235591706000002355946PA8420292025-01-21False
17060000023607L17/dossiers17170600000235591706000002355947PA7935322025-01-21False
17060000023608L17/dossiers17170600000235591706000002355948PA3423842025-01-21False
17060000023609L17/dossiers17170600000235591706000002355949PA7954222025-01-21False