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
17060000007026L17/dossiers17170600000069611706000000696164PA7201902026-01-20False
17060000007027L17/dossiers17170600000069611706000000696165PA7944862026-01-20False
17060000007028L17/dossiers17170600000069611706000000696166PA6073952026-01-20False
17060000007029L17/dossiers17170600000069611706000000696167PA7221622026-01-20False
17060000007030L17/dossiers17170600000069611706000000696168PA7214742026-01-20False
17060000007031L17/dossiers17170600000069611706000000696169PA7931942026-01-20False
17060000007032L17/dossiers17170600000069611706000000696170PA7200222026-01-20False
17060000007033L17/dossiers17170600000069611706000000696171PA6088262026-01-20False
17060000007034L17/dossiers17170600000069611706000000696172PA8411512026-01-20False
17060000007035L17/dossiers17170600000069611706000000696173PA7937162026-01-20False
17060000007045L17/dossiers1717060000007043170600000070431PA7946582024-10-18False
17060000007046L17/dossiers1717060000007043170600000070432PA6056942024-10-18False
17060000007047L17/dossiers1717060000007043170600000070433PA7214862024-10-18False
17060000007048L17/dossiers1717060000007043170600000070434PA7948302024-10-18False
17060000007058L17/dossiers1717060000007056170600000070561PA7956162024-10-31False
17060000007059L17/dossiers1717060000007056170600000070562PA7956722024-10-31False
17060000007060L17/dossiers1717060000007056170600000070563PA7209522024-10-31False
17060000007061L17/dossiers1717060000007056170600000070564PA7955962024-10-31False
17060000007062L17/dossiers1717060000007056170600000070565PA7208922024-10-31False
17060000007063L17/dossiers1717060000007056170600000070566PA7932622024-10-31False
17060000007064L17/dossiers1717060000007056170600000070567PA7949062024-10-31False
17060000007065L17/dossiers1717060000007056170600000070568PA7941382024-10-31False
17060000007066L17/dossiers1717060000007056170600000070569PA7955882024-10-31False
17060000007067L17/dossiers17170600000070561706000000705610PA7950842024-10-31False
17060000007068L17/dossiers17170600000070561706000000705611PA8421052024-10-31False
17060000007069L17/dossiers17170600000070561706000000705612PA7937802024-10-31False
17060000007070L17/dossiers17170600000070561706000000705613PA8417012024-10-31False
17060000007071L17/dossiers17170600000070561706000000705614PA8416572024-10-31False
17060000007072L17/dossiers17170600000070561706000000705615PA7204302024-10-31False
17060000007073L17/dossiers17170600000070561706000000705616PA7937722024-10-31False
17060000007074L17/dossiers17170600000070561706000000705617PA7934442024-10-31False
17060000007075L17/dossiers17170600000070561706000000705618PA8418852024-10-31False
17060000007076L17/dossiers17170600000070561706000000705619PA7949382024-10-31False
17060000007077L17/dossiers17170600000070561706000000705620PA7953182024-10-31False
17060000007078L17/dossiers17170600000070561706000000705621PA8410232024-10-31False
17060000007079L17/dossiers17170600000070561706000000705622PA7960902024-10-31False
17060000007080L17/dossiers17170600000070561706000000705623PA7939122024-10-31False
17060000007081L17/dossiers17170600000070561706000000705624PA8420372024-10-31False
17060000007082L17/dossiers17170600000070561706000000705625PA7940082024-10-31False
17060000007083L17/dossiers17170600000070561706000000705626PA7918122024-10-31False
17060000007084L17/dossiers17170600000070561706000000705627PA7937362024-10-31False
17060000007085L17/dossiers17170600000070561706000000705628PA7212022024-10-31False
17060000007086L17/dossiers17170600000070561706000000705629PA7212102024-10-31False
17060000007087L17/dossiers17170600000070561706000000705630PA7951362024-10-31False
17060000007088L17/dossiers17170600000070561706000000705631PA7934642024-10-31False
17060000007089L17/dossiers17170600000070561706000000705632PA8421552024-10-31False
17060000007090L17/dossiers17170600000070561706000000705633PA7952002024-10-31False
17060000007091L17/dossiers17170600000070561706000000705634PA7958442024-10-31False
17060000007092L17/dossiers17170600000070561706000000705635PA7218962024-10-31False
17060000007093L17/dossiers17170600000070561706000000705636PA8412512024-10-31False