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
17060000037022L17/dossiers17170600000369761706000003697645PA7938322025-05-13False
17060000037023L17/dossiers17170600000369761706000003697646PA7931022025-05-13False
17060000037024L17/dossiers17170600000369761706000003697647PA8416052025-05-13False
17060000037025L17/dossiers17170600000369761706000003697648PA7933622025-05-13False
17060000037026L17/dossiers17170600000369761706000003697649PA7944182025-05-13False
17060000037027L17/dossiers17170600000369761706000003697650PA7935922025-05-13False
17060000037028L17/dossiers17170600000369761706000003697651PA8407572025-05-13False
17060000037029L17/dossiers17170600000369761706000003697652PA8414512025-05-13False
17060000037030L17/dossiers17170600000369761706000003697653PA7947342025-05-13False
17060000037031L17/dossiers17170600000369761706000003697654PA7932182025-05-13False
17060000037032L17/dossiers17170600000369761706000003697655PA7959002025-05-13False
17060000037033L17/dossiers17170600000369761706000003697656PA7936322025-05-13False
17060000037034L17/dossiers17170600000369761706000003697657PA8420852025-05-13False
17060000037035L17/dossiers17170600000369761706000003697658PA7945982025-05-13False
17060000037036L17/dossiers17170600000369761706000003697659PA8414392025-05-13False
17060000037037L17/dossiers17170600000369761706000003697660PA7940302025-05-13False
17060000037038L17/dossiers17170600000369761706000003697661PA8417492025-05-13False
17060000037039L17/dossiers17170600000369761706000003697662PA8410752025-05-13False
17060000037040L17/dossiers17170600000369761706000003697663PA8408692025-05-13False
17060000037041L17/dossiers17170600000369761706000003697664PA7943542025-05-13False
17060000037042L17/dossiers17170600000369761706000003697665PA7959122025-05-13False
17060000037043L17/dossiers17170600000369761706000003697666PA7206142025-05-13False
17060000037044L17/dossiers17170600000369761706000003697667PA8418372025-05-13False
17060000037045L17/dossiers17170600000369761706000003697668PA7960262025-05-13False
17060000037046L17/dossiers17170600000369761706000003697669PA8408572025-05-13False
17060000037047L17/dossiers17170600000369761706000003697670PA7932902025-05-13False
17060000037048L17/dossiers17170600000369761706000003697671PA6429882025-05-13False
17060000037049L17/dossiers17170600000369761706000003697672PA7936082025-05-13False
17060000037050L17/dossiers17170600000369761706000003697673PA8418732025-05-13False
17060000037051L17/dossiers17170600000369761706000003697674PA8409672025-05-13False
17060000037052L17/dossiers17170600000369761706000003697675PA7936722025-05-13False
17060000037053L17/dossiers17170600000369761706000003697676PA7939042025-05-13False
17060000037054L17/dossiers17170600000369761706000003697677PA7219322025-05-13False
17060000037055L17/dossiers17170600000369761706000003697678PA7959742025-05-13False
17060000037056L17/dossiers17170600000369761706000003697679PA7945902025-05-13False
17060000037057L17/dossiers17170600000369761706000003697680PA8415872025-05-13False
17060000037058L17/dossiers17170600000369761706000003697681PA8415632025-05-13False
17060000037059L17/dossiers17170600000369761706000003697682PA7945302025-05-13False
17060000037060L17/dossiers17170600000369761706000003697683PA8408372025-05-13False
17060000037061L17/dossiers17170600000369761706000003697684PA8418252025-05-13False
17060000037062L17/dossiers17170600000369761706000003697685PA7947702025-05-13False
17060000037063L17/dossiers17170600000369761706000003697686PA7933142025-05-13False
17060000037064L17/dossiers17170600000369761706000003697687PA7933302025-05-13False
17060000037065L17/dossiers17170600000369761706000003697688PA7936162025-05-13False
17060000037066L17/dossiers17170600000369761706000003697689PA7194362025-05-13False
17060000037067L17/dossiers17170600000369761706000003697690PA7933542025-05-13False
17060000037068L17/dossiers17170600000369761706000003697691PA7957862025-05-13False
17060000037069L17/dossiers17170600000369761706000003697692PA7943222025-05-13False
17060000037070L17/dossiers17170600000369761706000003697693PA7938522025-05-13False
17060000037071L17/dossiers17170600000369761706000003697694PA8409152025-05-13False