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
17060000027299L17/dossiers17170600000272771706000002727721PA7940302025-02-18False
17060000027300L17/dossiers17170600000272771706000002727722PA7943542025-02-18False
17060000027301L17/dossiers17170600000272771706000002727723PA8409832025-02-18False
17060000027302L17/dossiers17170600000272771706000002727724PA8411832025-02-18False
17060000027303L17/dossiers17170600000272771706000002727725PA7945302025-02-18False
17060000027304L17/dossiers17170600000272771706000002727726PA7936162025-02-18False
17060000027305L17/dossiers17170600000272771706000002727727PA7194362025-02-18False
17060000027306L17/dossiers17170600000272771706000002727728PA8417692025-02-18False
17060000027307L17/dossiers17170600000272771706000002727729PA7936962025-02-18False
17060000027308L17/dossiers17170600000272771706000002727730PA7945822025-02-18False
17060000027309L17/dossiers17170600000272771706000002727731PA7932302025-02-18False
17060000027310L17/dossiers17170600000272771706000002727732PA7944422025-02-18False
17060000027311L17/dossiers17170600000272771706000002727733PA7933822025-02-18False
17060000027312L17/dossiers17170600000272771706000002727734PA7932982025-02-18False
17060000027313L17/dossiers17170600000272771706000002727735PA7949462025-02-18False
17060000027314L17/dossiers17170600000272771706000002727736PA7945982025-02-18False
17060000027315L17/dossiers17170600000272771706000002727737PA8406572025-02-18False
17060000027316L17/dossiers17170600000272771706000002727738PA8408692025-02-18False
17060000027320L17/dossiers1717060000027318170600000273181PA7192722025-03-31False
17060000027321L17/dossiers1717060000027318170600000273182PA7214862025-03-31False
17060000027322L17/dossiers1717060000027318170600000273183PA7194122025-03-31False
17060000027323L17/dossiers1717060000027318170600000273184PA7212342025-03-31False
17060000027324L17/dossiers1717060000027318170600000273185PA7937962025-03-31False
17060000027325L17/dossiers1717060000027318170600000273186PA8419312025-03-31False
17060000027326L17/dossiers1717060000027318170600000273187PA2670422025-03-31False
17060000027327L17/dossiers1717060000027318170600000273188PA7944702025-03-31False
17060000027328L17/dossiers1717060000027318170600000273189PA7952402025-03-31False
17060000027329L17/dossiers17170600000273181706000002731810PA7200922025-03-31False
17060000027330L17/dossiers17170600000273181706000002731811PA7214422025-03-31False
17060000027331L17/dossiers17170600000273181706000002731812PA8421172025-03-31False
17060000027332L17/dossiers17170600000273181706000002731813PA7194722025-03-31False
17060000027333L17/dossiers17170600000273181706000002731814PA6076192025-03-31False
17060000027334L17/dossiers17170600000273181706000002731815PA2677802025-03-31False
17060000027335L17/dossiers17170600000273181706000002731816PA7935082025-03-31False
17060000027336L17/dossiers17170600000273181706000002731817PA6056942025-03-31False
17060000027337L17/dossiers17170600000273181706000002731818PA7202302025-03-31False
17060000027338L17/dossiers17170600000273181706000002731819PA8413592025-03-31False
17060000027339L17/dossiers17170600000273181706000002731820PA2677632025-03-31False
17060000027340L17/dossiers17170600000273181706000002731821PA7934162025-03-31False
17060000027341L17/dossiers17170600000273181706000002731822PA8408172025-03-31False
17060000027342L17/dossiers17170600000273181706000002731823PA7949822025-03-31False
17060000027343L17/dossiers17170600000273181706000002731824PA7223902025-03-31False
17060000027344L17/dossiers17170600000273181706000002731825PA6075532025-03-31False
17060000027345L17/dossiers17170600000273181706000002731826PA3457222025-03-31False
17060000027346L17/dossiers17170600000273181706000002731827PA7120142025-03-31False
17060000027347L17/dossiers17170600000273181706000002731828PA2673182025-03-31False
17060000027348L17/dossiers17170600000273181706000002731829PA7930942025-03-31False
17060000027349L17/dossiers17170600000273181706000002731830PA7931222025-03-31False
17060000027350L17/dossiers17170600000273181706000002731831PA3467822025-03-31False
17060000027351L17/dossiers17170600000273181706000002731832PA8417692025-03-31False