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
17060000022635L17/dossiers17170600000226221706000002262212PA3422402025-02-17False
17060000022636L17/dossiers17170600000226221706000002262213PA3325232024-12-292025-02-17False
17060000022637L17/dossiers17170600000226221706000002262214PA2667932025-02-17False
17060000022638L17/dossiers17170600000226221706000002262215PA7749542025-02-17False
17060000022639L17/dossiers17170600000226221706000002262216PA7214422025-02-17False
17060000022640L17/dossiers17170600000226221706000002262217PA7214102025-02-17False
17060000022641L17/dossiers17170600000226221706000002262218PA6428472025-02-17False
17060000022642L17/dossiers17170600000226221706000002262219PA7218162025-02-17False
17060000022643L17/dossiers17170600000226221706000002262220PA7940382025-02-17False
17060000022644L17/dossiers17170600000226221706000002262221PA16302025-02-17False
17060000022645L17/dossiers17170600000226221706000002262222PA6088262025-02-17False
17060000022646L17/dossiers17170600000226221706000002262223PA3300082025-02-17False
17060000022647L17/dossiers17170600000226221706000002262224PA6060982025-02-17False
17060000022648L17/dossiers17170600000226221706000002262225PA7930942025-02-17False
17060000022658L17/dossiers1717060000022656170600000226561PA8410672025-02-12False
17060000022659L17/dossiers1717060000022656170600000226562PA8412072025-02-12False
17060000022660L17/dossiers1717060000022656170600000226563PA2675612025-02-12False
17060000022661L17/dossiers1717060000022656170600000226564PA7948862025-02-12False
17060000022662L17/dossiers1717060000022656170600000226565PA7931342025-02-12False
17060000022663L17/dossiers1717060000022656170600000226566PA8407012025-02-12False
17060000022664L17/dossiers1717060000022656170600000226567PA7204682025-02-12False
17060000022665L17/dossiers1717060000022656170600000226568PA3302402025-02-12False
17060000022666L17/dossiers1717060000022656170600000226569PA7933222025-02-12False
17060000022667L17/dossiers17170600000226561706000002265610PA7932462025-02-12False
17060000022668L17/dossiers17170600000226561706000002265611PA7938922025-02-12False
17060000022669L17/dossiers17170600000226561706000002265612PA8417372025-02-12False
17060000022670L17/dossiers17170600000226561706000002265613PA7932182025-02-12False
17060000022671L17/dossiers17170600000226561706000002265614PA7959742025-02-12False
17060000022672L17/dossiers17170600000226561706000002265615PA8411832025-02-12False
17060000022673L17/dossiers17170600000226561706000002265616PA7947702025-02-12False
17060000022674L17/dossiers17170600000226561706000002265617PA7933142025-02-12False
17060000022675L17/dossiers17170600000226561706000002265618PA7194362025-02-12False
17060000022676L17/dossiers17170600000226561706000002265619PA7957862025-02-12False
17060000022677L17/dossiers17170600000226561706000002265620PA8417692025-02-12False
17060000022678L17/dossiers17170600000226561706000002265621PA8409152025-02-12False
17060000022679L17/dossiers17170600000226561706000002265622PA7936962025-02-12False
17060000022680L17/dossiers17170600000226561706000002265623PA8406572025-02-12False
17060000022681L17/dossiers17170600000226561706000002265624PA8422272025-02-12False
17060000022682L17/dossiers17170600000226561706000002265625PA7944422025-02-12False
17060000022686L17/dossiers1717060000022684170600000226841PA8417452025-02-17False
17060000022687L17/dossiers1717060000022684170600000226842PA6428472025-02-17False
17060000022688L17/dossiers1717060000022684170600000226843PA7188842025-02-17False
17060000022689L17/dossiers1717060000022684170600000226844PA7749542025-02-17False
17060000022690L17/dossiers1717060000022684170600000226845PA7199682025-02-17False
17060000022691L17/dossiers1717060000022684170600000226846PA7214102025-02-17False
17060000022692L17/dossiers1717060000022684170600000226847PA7218162025-02-17False
17060000022693L17/dossiers1717060000022684170600000226848PA3422402025-02-17False
17060000022694L17/dossiers1717060000022684170600000226849PA7935082025-02-17False
17060000022695L17/dossiers17170600000226841706000002268410PA3325232024-12-192025-02-17False
17060000022696L17/dossiers17170600000226841706000002268411PA3309092025-02-17False