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
17060000021439L17/dossiers17170600000213971706000002139741PA2677942025-02-17False
17060000021440L17/dossiers17170600000213971706000002139742PA7941782025-02-17False
17060000021441L17/dossiers17170600000213971706000002139743PA7941182025-02-17False
17060000021442L17/dossiers17170600000213971706000002139744PA6070902025-02-17False
17060000021443L17/dossiers17170600000213971706000002139745PA3467822025-02-17False
17060000021447L17/dossiers1717060000021445170600000214451PA2672852026-01-14False
17060000021448L17/dossiers1717060000021445170600000214452PA8417452026-01-14False
17060000021449L17/dossiers1717060000021445170600000214453PA6428472026-01-14False
17060000021450L17/dossiers1717060000021445170600000214454PA7188842026-01-14False
17060000021451L17/dossiers1717060000021445170600000214455PA4085782026-01-14False
17060000021452L17/dossiers1717060000021445170600000214456PA7749542026-01-14False
17060000021453L17/dossiers1717060000021445170600000214457PA7199682026-01-14False
17060000021454L17/dossiers1717060000021445170600000214458PA7214102026-01-14False
17060000021455L17/dossiers1717060000021445170600000214459PA2667932026-01-14False
17060000021456L17/dossiers17170600000214451706000002144510PA3422402026-01-14False
17060000021457L17/dossiers17170600000214451706000002144511PA3300082026-01-14False
17060000021458L17/dossiers17170600000214451706000002144512PA7935082026-01-14False
17060000021459L17/dossiers17170600000214451706000002144513PA7188382026-01-14False
17060000021460L17/dossiers17170600000214451706000002144514PA8410472026-01-14False
17060000021461L17/dossiers17170600000214451706000002144515PA7188502026-01-14False
17060000021462L17/dossiers17170600000214451706000002144516PA7223902026-01-14False
17060000021463L17/dossiers17170600000214451706000002144517PA3309092026-01-14False
17060000021464L17/dossiers17170600000214451706000002144518PA3325232024-12-032025-02-17False
17060000021465L17/dossiers17170600000214451706000002144519PA7203862026-01-14False
17060000021466L17/dossiers17170600000214451706000002144520PA7120152026-01-14False
17060000021467L17/dossiers17170600000214451706000002144521PA6088262026-01-14False
17060000021468L17/dossiers17170600000214451706000002144522PA13272026-01-14False
17060000021469L17/dossiers17170600000214451706000002144523PA8418692026-01-14False
17060000021470L17/dossiers17170600000214451706000002144524PA2667972026-01-14False
17060000021471L17/dossiers17170600000214451706000002144525PA7940582026-01-14False
17060000021472L17/dossiers17170600000214451706000002144526PA16302026-01-14False
17060000021473L17/dossiers17170600000214451706000002144527PA8421172026-01-14False
17060000021474L17/dossiers17170600000214451706000002144528PA7223282026-01-14False
17060000021475L17/dossiers17170600000214451706000002144529PA8409792026-01-14False
17060000021476L17/dossiers17170600000214451706000002144530PA6955122026-01-14False
17060000021477L17/dossiers17170600000214451706000002144531PA6427252026-01-14False
17060000021478L17/dossiers17170600000214451706000002144532PA6080162026-01-14False
17060000021479L17/dossiers17170600000214451706000002144533PA6060982026-01-14False
17060000021480L17/dossiers17170600000214451706000002144534PA7933422026-01-14False
17060000021481L17/dossiers17170600000214451706000002144535PA7192722026-01-14False
17060000021482L17/dossiers17170600000214451706000002144536PA7940382026-01-14False
17060000021483L17/dossiers17170600000214451706000002144537PA7206442026-01-14False
17060000021484L17/dossiers17170600000214451706000002144538PA7214422026-01-14False
17060000021485L17/dossiers17170600000214451706000002144539PA7930942026-01-14False
17060000021486L17/dossiers17170600000214451706000002144540PA2668082026-01-14False
17060000021487L17/dossiers17170600000214451706000002144541PA2677942026-01-14False
17060000021488L17/dossiers17170600000214451706000002144542PA7941782026-01-14False
17060000021489L17/dossiers17170600000214451706000002144543PA7941182026-01-14False
17060000021490L17/dossiers17170600000214451706000002144544PA6070902026-01-14False
17060000021491L17/dossiers17170600000214451706000002144545PA7218162026-01-14False