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
17060000026465L17/dossiers1717060000026461170600000264613PA7932622025-02-19False
17060000026466L17/dossiers1717060000026461170600000264614PA7949062025-02-19False
17060000026467L17/dossiers1717060000026461170600000264615PA7941382025-02-19False
17060000026468L17/dossiers1717060000026461170600000264616PA7955882025-02-19False
17060000026469L17/dossiers1717060000026461170600000264617PA7950842025-02-19False
17060000026470L17/dossiers1717060000026461170600000264618PA8421052025-02-19False
17060000026471L17/dossiers1717060000026461170600000264619PA8416572025-02-19False
17060000026472L17/dossiers17170600000264611706000002646110PA7204302025-02-19False
17060000026473L17/dossiers17170600000264611706000002646111PA7937722025-02-19False
17060000026474L17/dossiers17170600000264611706000002646112PA7956162025-02-19False
17060000026475L17/dossiers17170600000264611706000002646113PA7934442025-02-19False
17060000026476L17/dossiers17170600000264611706000002646114PA7949382025-02-19False
17060000026477L17/dossiers17170600000264611706000002646115PA7953182025-02-19False
17060000026478L17/dossiers17170600000264611706000002646116PA8410232025-02-19False
17060000026479L17/dossiers17170600000264611706000002646117PA7960902025-02-19False
17060000026480L17/dossiers17170600000264611706000002646118PA7939122025-02-19False
17060000026481L17/dossiers17170600000264611706000002646119PA8421872025-02-19False
17060000026482L17/dossiers17170600000264611706000002646120PA8420372025-02-19False
17060000026483L17/dossiers17170600000264611706000002646121PA7937362025-02-19False
17060000026484L17/dossiers17170600000264611706000002646122PA7212022025-02-19False
17060000026485L17/dossiers17170600000264611706000002646123PA7951362025-02-19False
17060000026486L17/dossiers17170600000264611706000002646124PA7934642025-02-19False
17060000026487L17/dossiers17170600000264611706000002646125PA8421552025-02-19False
17060000026488L17/dossiers17170600000264611706000002646126PA7952002025-02-19False
17060000026489L17/dossiers17170600000264611706000002646127PA7958442025-02-19False
17060000026490L17/dossiers17170600000264611706000002646128PA8412512025-02-19False
17060000026491L17/dossiers17170600000264611706000002646129PA7947862025-02-19False
17060000026492L17/dossiers17170600000264611706000002646130PA7948702025-02-19False
17060000026493L17/dossiers17170600000264611706000002646131PA7960702025-02-19False
17060000026494L17/dossiers17170600000264611706000002646132PA7953102025-02-19False
17060000026495L17/dossiers17170600000264611706000002646133PA7944782025-02-19False
17060000026496L17/dossiers17170600000264611706000002646134PA8419472025-02-19False
17060000026497L17/dossiers17170600000264611706000002646135PA7940822025-02-19False
17060000026498L17/dossiers17170600000264611706000002646136PA7941302025-02-19False
17060000026499L17/dossiers17170600000264611706000002646137PA7208462025-02-19False
17060000026500L17/dossiers17170600000264611706000002646138PA8417292025-02-19False
17060000026501L17/dossiers17170600000264611706000002646139PA7955162025-02-19False
17060000026502L17/dossiers17170600000264611706000002646140PA7956722025-02-19False
17060000026503L17/dossiers17170600000264611706000002646141PA7957462025-02-19False
17060000026504L17/dossiers17170600000264611706000002646142PA7951082025-02-19False
17060000026505L17/dossiers17170600000264611706000002646143PA8415152025-02-19False
17060000026506L17/dossiers17170600000264611706000002646144PA7952982025-02-19False
17060000026507L17/dossiers17170600000264611706000002646145PA7918242025-02-19False
17060000026508L17/dossiers17170600000264611706000002646146PA8420292025-02-19False
17060000026509L17/dossiers17170600000264611706000002646147PA7935322025-02-19False
17060000026510L17/dossiers17170600000264611706000002646148PA3423842025-02-19False
17060000026511L17/dossiers17170600000264611706000002646149PA7954222025-02-19False
17060000026512L17/dossiers17170600000264611706000002646150PA7946862025-02-19False
17060000026513L17/dossiers17170600000264611706000002646151PA8412152025-02-19False
17060000026514L17/dossiers17170600000264611706000002646152PA7954822025-02-19False