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
17060000037408L17/dossiers1717060000037400170600000374007PA7933222025-05-13False
17060000037409L17/dossiers1717060000037400170600000374008PA8407732025-05-13False
17060000037410L17/dossiers1717060000037400170600000374009PA8409832025-05-13False
17060000037411L17/dossiers17170600000374001706000003740010PA8411832025-05-13False
17060000037412L17/dossiers17170600000374001706000003740011PA8413952025-05-13False
17060000037413L17/dossiers17170600000374001706000003740012PA8417692025-05-13False
17060000037414L17/dossiers17170600000374001706000003740013PA8406572025-05-13False
17060000037415L17/dossiers17170600000374001706000003740014PA8406852025-05-13False
17060000037416L17/dossiers17170600000374001706000003740015PA8408092025-05-13False
17060000037423L17/dossiers1717060000037421170600000374211PA8410672025-05-13False
17060000037424L17/dossiers1717060000037421170600000374212PA7945622025-05-13False
17060000037425L17/dossiers1717060000037421170600000374213PA2675612025-05-13False
17060000037426L17/dossiers1717060000037421170600000374214PA7208222025-05-13False
17060000037427L17/dossiers1717060000037421170600000374215PA7206682025-05-13False
17060000037428L17/dossiers1717060000037421170600000374216PA7948862025-05-13False
17060000037429L17/dossiers1717060000037421170600000374217PA7960422025-05-13False
17060000037430L17/dossiers1717060000037421170600000374218PA8414872025-05-13False
17060000037431L17/dossiers1717060000037421170600000374219PA8411312025-05-13False
17060000037432L17/dossiers17170600000374211706000003742110PA7931342025-05-13False
17060000037433L17/dossiers17170600000374211706000003742111PA8400752025-05-13False
17060000037434L17/dossiers17170600000374211706000003742112PA7204682025-05-13False
17060000037435L17/dossiers17170600000374211706000003742113PA7935482025-05-13False
17060000037436L17/dossiers17170600000374211706000003742114PA7939282025-05-13False
17060000037437L17/dossiers17170600000374211706000003742115PA8401352025-05-13False
17060000037438L17/dossiers17170600000374211706000003742116PA8420732025-05-13False
17060000037439L17/dossiers17170600000374211706000003742117PA8417612025-05-13False
17060000037440L17/dossiers17170600000374211706000003742118PA8408012025-05-13False
17060000037441L17/dossiers17170600000374211706000003742119PA7946782025-05-13False
17060000037442L17/dossiers17170600000374211706000003742120PA8417372025-05-13False
17060000037443L17/dossiers17170600000374211706000003742121PA7960342025-05-13False
17060000037444L17/dossiers17170600000374211706000003742122PA7931022025-05-13False
17060000037445L17/dossiers17170600000374211706000003742123PA8416052025-05-13False
17060000037446L17/dossiers17170600000374211706000003742124PA7935922025-05-13False
17060000037447L17/dossiers17170600000374211706000003742125PA8407572025-05-13False
17060000037448L17/dossiers17170600000374211706000003742126PA8414512025-05-13False
17060000037449L17/dossiers17170600000374211706000003742127PA7947342025-05-13False
17060000037450L17/dossiers17170600000374211706000003742128PA8414392025-05-13False
17060000037451L17/dossiers17170600000374211706000003742129PA8408692025-05-13False
17060000037452L17/dossiers17170600000374211706000003742130PA8418372025-05-13False
17060000037453L17/dossiers17170600000374211706000003742131PA6429882025-05-13False
17060000037454L17/dossiers17170600000374211706000003742132PA7936082025-05-13False
17060000037455L17/dossiers17170600000374211706000003742133PA8409672025-05-13False
17060000037456L17/dossiers17170600000374211706000003742134PA7939042025-05-13False
17060000037457L17/dossiers17170600000374211706000003742135PA7959742025-05-13False
17060000037458L17/dossiers17170600000374211706000003742136PA8415872025-05-13False
17060000037459L17/dossiers17170600000374211706000003742137PA7945302025-05-13False
17060000037460L17/dossiers17170600000374211706000003742138PA8408372025-05-13False
17060000037461L17/dossiers17170600000374211706000003742139PA7933142025-05-13False
17060000037462L17/dossiers17170600000374211706000003742140PA7936162025-05-13False
17060000037463L17/dossiers17170600000374211706000003742141PA7957862025-05-13False