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 151 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
17060000014240L17/dossiers17170600000142251706000001422514PA7200922025-01-14False
17060000014241L17/dossiers17170600000142251706000001422515PA7937162025-01-14False
17060000014242L17/dossiers17170600000142251706000001422516PA7218162025-01-14False
17060000014243L17/dossiers17170600000142251706000001422517PA7955282025-01-14False
17060000014244L17/dossiers17170600000142251706000001422518PA7218442025-01-14False
17060000014245L17/dossiers17170600000142251706000001422519PA8416932025-01-14False
17060000014246L17/dossiers17170600000142251706000001422520PA7952402025-01-14False
17060000014247L17/dossiers17170600000142251706000001422521PA7214862025-01-14False
17060000014248L17/dossiers17170600000142251706000001422522PA7205522025-01-14False
17060000014249L17/dossiers17170600000142251706000001422523PA7948302025-01-14False
17060000014250L17/dossiers17170600000142251706000001422524PA7932702025-01-14False
17060000014251L17/dossiers17170600000142251706000001422525PA7948102025-01-14False
17060000014252L17/dossiers17170600000142251706000001422526PA7953742025-01-14False
17060000014253L17/dossiers17170600000142251706000001422527PA7202302025-01-14False
17060000014254L17/dossiers17170600000142251706000001422528PA6872142025-01-14False
17060000014255L17/dossiers17170600000142251706000001422529PA7939922025-01-14False
17060000014256L17/dossiers17170600000142251706000001422530PA7944702025-01-14False
17060000014257L17/dossiers17170600000142251706000001422531PA8419312025-01-14False
17060000014258L17/dossiers17170600000142251706000001422532PA7950462025-01-14False
17060000014259L17/dossiers17170600000142251706000001422533PA7202562025-01-14False
17060000014260L17/dossiers17170600000142251706000001422534PA8051662025-01-14False
17060000014261L17/dossiers17170600000142251706000001422535PA7213362025-01-14False
17060000014262L17/dossiers17170600000142251706000001422536PA7218362024-10-222024-12-03False
17060000014263L17/dossiers17170600000142251706000001422537PA7935202025-01-14False
17060000014264L17/dossiers17170600000142251706000001422538PA6056942025-01-14False
17060000014265L17/dossiers17170600000142251706000001422539PA7199142024-10-222024-12-03False
17060000014266L17/dossiers17170600000142251706000001422540PA7199382025-01-14False
17060000014267L17/dossiers17170600000142251706000001422541PA7222842025-01-14False
17060000014268L17/dossiers17170600000142251706000001422542PA7205602025-01-14False
17060000014269L17/dossiers17170600000142251706000001422543PA7951202024-10-222024-12-03False
17060000014270L17/dossiers17170600000142251706000001422544PA2673182025-01-14False
17060000014271L17/dossiers17170600000142251706000001422545PA7952582025-01-14False
17060000014272L17/dossiers17170600000142251706000001422546PA7223742025-01-14False
17060000014273L17/dossiers17170600000142251706000001422547PA7200382025-01-14False
17060000014274L17/dossiers17170600000142251706000001422548PA7199182025-01-14False
17060000014275L17/dossiers17170600000142251706000001422549PA7219842025-01-14False
17060000014276L17/dossiers17170600000142251706000001422550PA7941142025-01-14False
17060000014277L17/dossiers17170600000142251706000001422551PA7951002025-01-14False
17060000014278L17/dossiers17170600000142251706000001422552PA7207282025-01-14False
17060000014279L17/dossiers17170600000142251706000001422553PA7196402025-01-14False
17060000014280L17/dossiers17170600000142251706000001422554PA7951242025-01-14False
17060000014281L17/dossiers17170600000142251706000001422555PA7203342025-01-14False
17060000014282L17/dossiers17170600000142251706000001422556PA7211822025-01-14False
17060000014283L17/dossiers17170600000142251706000001422557PA7212342025-01-14False
17060000014284L17/dossiers17170600000142251706000001422558PA7207202025-01-14False
17060000014285L17/dossiers17170600000142251706000001422559PA7198222025-01-14False
17060000014286L17/dossiers17170600000142251706000001422560PA7221622025-01-14False
17060000014287L17/dossiers17170600000142251706000001422561PA3315822025-01-14False
17060000014288L17/dossiers17170600000142251706000001422562PA7214742025-01-14False
17060000014289L17/dossiers17170600000142251706000001422563PA7942782024-12-032025-01-14False