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
17060000012252L17/dossiers17170600000121671706000001216784PA7959202024-11-20False
17060000012253L17/dossiers17170600000121671706000001216785PA6073952024-11-20False
17060000012254L17/dossiers17170600000121671706000001216786PA7221022024-11-20False
17060000012255L17/dossiers17170600000121671706000001216787PA7195122024-11-20False
17060000012256L17/dossiers17170600000121671706000001216788PA7211702024-11-20False
17060000012257L17/dossiers17170600000121671706000001216789PA29602024-11-20False
17060000012258L17/dossiers17170600000121671706000001216790PA7950462024-11-20False
17060000012262L17/dossiers1717060000012260170600000122601PA8420372024-10-31False
17060000012263L17/dossiers1717060000012260170600000122602PA7937802024-10-31False
17060000012264L17/dossiers1717060000012260170600000122603PA7961062024-10-31False
17060000012265L17/dossiers1717060000012260170600000122604PA8418852024-10-31False
17060000012266L17/dossiers1717060000012260170600000122605PA8412952024-10-31False
17060000012267L17/dossiers1717060000012260170600000122606PA7939802024-10-31False
17060000012268L17/dossiers1717060000012260170600000122607PA8414192024-10-31False
17060000012269L17/dossiers1717060000012260170600000122608PA3356122024-10-31False
17060000012270L17/dossiers1717060000012260170600000122609PA7956362024-10-31False
17060000012271L17/dossiers17170600000122601706000001226010PA7937082024-10-31False
17060000012272L17/dossiers17170600000122601706000001226011PA7952402024-10-31False
17060000012273L17/dossiers17170600000122601706000001226012PA29402024-10-31False
17060000012274L17/dossiers17170600000122601706000001226013PA7952282024-10-31False
17060000012275L17/dossiers17170600000122601706000001226014PA7932622024-10-31False
17060000012276L17/dossiers17170600000122601706000001226015PA7949062024-10-31False
17060000012277L17/dossiers17170600000122601706000001226016PA7941382024-10-31False
17060000012278L17/dossiers17170600000122601706000001226017PA7955882024-10-31False
17060000012279L17/dossiers17170600000122601706000001226018PA7950842024-10-31False
17060000012280L17/dossiers17170600000122601706000001226019PA8421052024-10-31False
17060000012281L17/dossiers17170600000122601706000001226020PA8416572024-10-31False
17060000012282L17/dossiers17170600000122601706000001226021PA7204302024-10-31False
17060000012283L17/dossiers17170600000122601706000001226022PA7937722024-10-31False
17060000012284L17/dossiers17170600000122601706000001226023PA7956162024-10-31False
17060000012285L17/dossiers17170600000122601706000001226024PA7934442024-10-31False
17060000012286L17/dossiers17170600000122601706000001226025PA7949382024-10-31False
17060000012287L17/dossiers17170600000122601706000001226026PA7953182024-10-31False
17060000012288L17/dossiers17170600000122601706000001226027PA8410232024-10-31False
17060000012289L17/dossiers17170600000122601706000001226028PA7960902024-10-31False
17060000012290L17/dossiers17170600000122601706000001226029PA7939122024-10-31False
17060000012291L17/dossiers17170600000122601706000001226030PA8421872024-10-31False
17060000012292L17/dossiers17170600000122601706000001226031PA7918122024-10-31False
17060000012293L17/dossiers17170600000122601706000001226032PA7937362024-10-31False
17060000012294L17/dossiers17170600000122601706000001226033PA7212022024-10-31False
17060000012295L17/dossiers17170600000122601706000001226034PA7951362024-10-31False
17060000012296L17/dossiers17170600000122601706000001226035PA7934642024-10-31False
17060000012297L17/dossiers17170600000122601706000001226036PA8421552024-10-31False
17060000012298L17/dossiers17170600000122601706000001226037PA7952002024-10-31False
17060000012299L17/dossiers17170600000122601706000001226038PA7958442024-10-31False
17060000012300L17/dossiers17170600000122601706000001226039PA8412512024-10-31False
17060000012301L17/dossiers17170600000122601706000001226040PA7947862024-10-31False
17060000012302L17/dossiers17170600000122601706000001226041PA7948702024-10-31False
17060000012303L17/dossiers17170600000122601706000001226042PA7960702024-10-31False
17060000012304L17/dossiers17170600000122601706000001226043PA7953102024-10-31False