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
17060000025086L17/dossiers17170600000250561706000002505629PA8417372025-05-21False
17060000025087L17/dossiers17170600000250561706000002505630PA7960342025-05-21False
17060000025088L17/dossiers17170600000250561706000002505631PA7938322025-05-21False
17060000025089L17/dossiers17170600000250561706000002505632PA8416052025-05-21False
17060000025090L17/dossiers17170600000250561706000002505633PA7935922025-05-21False
17060000025091L17/dossiers17170600000250561706000002505634PA8407572025-05-21False
17060000025092L17/dossiers17170600000250561706000002505635PA7947342025-05-21False
17060000025093L17/dossiers17170600000250561706000002505636PA7932182025-05-21False
17060000025094L17/dossiers17170600000250561706000002505637PA7959002025-05-21False
17060000025095L17/dossiers17170600000250561706000002505638PA8420852025-05-21False
17060000025096L17/dossiers17170600000250561706000002505639PA7945982025-05-21False
17060000025097L17/dossiers17170600000250561706000002505640PA8414392025-05-21False
17060000025098L17/dossiers17170600000250561706000002505641PA8408692025-05-21False
17060000025099L17/dossiers17170600000250561706000002505642PA8418372025-05-21False
17060000025100L17/dossiers17170600000250561706000002505643PA7960262025-05-21False
17060000025101L17/dossiers17170600000250561706000002505644PA8408572025-05-21False
17060000025102L17/dossiers17170600000250561706000002505645PA7932902025-05-21False
17060000025103L17/dossiers17170600000250561706000002505646PA8409832025-05-21False
17060000025104L17/dossiers17170600000250561706000002505647PA6429882025-05-21False
17060000025105L17/dossiers17170600000250561706000002505648PA7936082025-05-21False
17060000025106L17/dossiers17170600000250561706000002505649PA8418732025-05-21False
17060000025107L17/dossiers17170600000250561706000002505650PA8409672025-05-21False
17060000025108L17/dossiers17170600000250561706000002505651PA7939042025-05-21False
17060000025109L17/dossiers17170600000250561706000002505652PA7219322025-05-21False
17060000025110L17/dossiers17170600000250561706000002505653PA7959742025-05-21False
17060000025111L17/dossiers17170600000250561706000002505654PA7945902025-05-21False
17060000025112L17/dossiers17170600000250561706000002505655PA8415632025-05-21False
17060000025113L17/dossiers17170600000250561706000002505656PA7945302025-05-21False
17060000025114L17/dossiers17170600000250561706000002505657PA7933422025-05-21False
17060000025115L17/dossiers17170600000250561706000002505658PA7947702025-05-21False
17060000025116L17/dossiers17170600000250561706000002505659PA7933142025-05-21False
17060000025117L17/dossiers17170600000250561706000002505660PA7933302025-05-21False
17060000025118L17/dossiers17170600000250561706000002505661PA7936162025-05-21False
17060000025119L17/dossiers17170600000250561706000002505662PA7194362025-05-21False
17060000025120L17/dossiers17170600000250561706000002505663PA7933542025-05-21False
17060000025121L17/dossiers17170600000250561706000002505664PA7957862025-05-21False
17060000025122L17/dossiers17170600000250561706000002505665PA7943222025-05-21False
17060000025123L17/dossiers17170600000250561706000002505666PA7938522025-05-21False
17060000025124L17/dossiers17170600000250561706000002505667PA8413952025-05-21False
17060000025125L17/dossiers17170600000250561706000002505668PA8417692025-05-21False
17060000025126L17/dossiers17170600000250561706000002505669PA7936962025-05-21False
17060000025127L17/dossiers17170600000250561706000002505670PA7214862025-05-21False
17060000025128L17/dossiers17170600000250561706000002505671PA7955522025-05-21False
17060000025129L17/dossiers17170600000250561706000002505672PA7946702025-05-21False
17060000025130L17/dossiers17170600000250561706000002505673PA8411992025-05-21False
17060000025131L17/dossiers17170600000250561706000002505674PA7945822025-05-21False
17060000025132L17/dossiers17170600000250561706000002505675PA7936562025-05-21False
17060000025133L17/dossiers17170600000250561706000002505676PA7959662025-05-21False
17060000025134L17/dossiers17170600000250561706000002505677PA7932302025-05-21False
17060000025135L17/dossiers17170600000250561706000002505678PA7932542025-05-21False