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
17060000041042L17/dossiers17170600000409801706000004098061PA8410752025-09-17False
17060000041043L17/dossiers17170600000409801706000004098062PA8408692025-09-17False
17060000041044L17/dossiers17170600000409801706000004098063PA7943542025-09-17False
17060000041045L17/dossiers17170600000409801706000004098064PA7959122025-09-17False
17060000041046L17/dossiers17170600000409801706000004098065PA7206142025-09-17False
17060000041047L17/dossiers17170600000409801706000004098066PA8418372025-09-17False
17060000041048L17/dossiers17170600000409801706000004098067PA7960262025-09-17False
17060000041049L17/dossiers17170600000409801706000004098068PA8408572025-09-17False
17060000041050L17/dossiers17170600000409801706000004098069PA7932902025-09-17False
17060000041051L17/dossiers17170600000409801706000004098070PA6429882025-09-17False
17060000041052L17/dossiers17170600000409801706000004098071PA7936082025-09-17False
17060000041053L17/dossiers17170600000409801706000004098072PA8418732025-09-17False
17060000041054L17/dossiers17170600000409801706000004098073PA8409672025-09-17False
17060000041055L17/dossiers17170600000409801706000004098074PA7936722025-09-17False
17060000041056L17/dossiers17170600000409801706000004098075PA7939042025-09-17False
17060000041057L17/dossiers17170600000409801706000004098076PA7219322025-09-17False
17060000041058L17/dossiers17170600000409801706000004098077PA7959742025-09-17False
17060000041059L17/dossiers17170600000409801706000004098078PA7945902025-09-17False
17060000041060L17/dossiers17170600000409801706000004098079PA8415872025-09-17False
17060000041061L17/dossiers17170600000409801706000004098080PA7945302025-09-17False
17060000041062L17/dossiers17170600000409801706000004098081PA8408372025-09-17False
17060000041063L17/dossiers17170600000409801706000004098082PA8418252025-09-17False
17060000041064L17/dossiers17170600000409801706000004098083PA7947702025-09-17False
17060000041065L17/dossiers17170600000409801706000004098084PA7933142025-09-17False
17060000041066L17/dossiers17170600000409801706000004098085PA7933302025-09-17False
17060000041067L17/dossiers17170600000409801706000004098086PA7936162025-09-17False
17060000041068L17/dossiers17170600000409801706000004098087PA7194362025-09-17False
17060000041069L17/dossiers17170600000409801706000004098088PA7933542025-09-17False
17060000041070L17/dossiers17170600000409801706000004098089PA7957862025-09-17False
17060000041071L17/dossiers17170600000409801706000004098090PA7943222025-09-17False
17060000041072L17/dossiers17170600000409801706000004098091PA7938522025-09-17False
17060000041073L17/dossiers17170600000409801706000004098092PA8409152025-09-17False
17060000041074L17/dossiers17170600000409801706000004098093PA7936962025-09-17False
17060000041075L17/dossiers17170600000409801706000004098094PA7955522025-09-17False
17060000041076L17/dossiers17170600000409801706000004098095PA7946702025-09-17False
17060000041077L17/dossiers17170600000409801706000004098096PA8411992025-09-17False
17060000041078L17/dossiers17170600000409801706000004098097PA7945822025-09-17False
17060000041079L17/dossiers17170600000409801706000004098098PA7936562025-09-17False
17060000041080L17/dossiers17170600000409801706000004098099PA7959662025-09-17False
17060000041081L17/dossiers171706000004098017060000040980100PA7932302025-09-17False
17060000041082L17/dossiers171706000004098017060000040980101PA7932542025-09-17False
17060000041083L17/dossiers171706000004098017060000040980102PA8419552025-09-17False
17060000041084L17/dossiers171706000004098017060000040980103PA8419812025-09-17False
17060000041085L17/dossiers171706000004098017060000040980104PA8422272025-09-17False
17060000041086L17/dossiers171706000004098017060000040980105PA7944422025-09-17False
17060000041087L17/dossiers171706000004098017060000040980106PA7954102025-09-17False
17060000041088L17/dossiers171706000004098017060000040980107PA8420972025-09-17False
17060000041089L17/dossiers171706000004098017060000040980108PA7948942025-09-17False
17060000041090L17/dossiers171706000004098017060000040980109PA7945702025-09-17False
17060000041091L17/dossiers171706000004098017060000040980110PA7949542025-09-17False