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
17060000026296L17/dossiers17170600000262591706000002625936PA7749602025-03-11False
17060000026297L17/dossiers17170600000262591706000002625937PA7209522025-03-11False
17060000026298L17/dossiers17170600000262591706000002625938PA8418932025-03-11False
17060000026305L17/dossiers1717060000026303170600000263031PA7960782025-04-30False
17060000026306L17/dossiers1717060000026303170600000263032PA7942782025-04-30False
17060000026307L17/dossiers1717060000026303170600000263033PA7939922025-04-30False
17060000026308L17/dossiers1717060000026303170600000263034PA7951442025-04-30False
17060000026309L17/dossiers1717060000026303170600000263035PA6428472025-04-30False
17060000026310L17/dossiers1717060000026303170600000263036PA7952782025-04-30False
17060000026311L17/dossiers1717060000026303170600000263037PA8422112025-04-30False
17060000026312L17/dossiers1717060000026303170600000263038PA3322282025-04-30False
17060000026313L17/dossiers1717060000026303170600000263039PA6872142025-04-30False
17060000026314L17/dossiers17170600000263031706000002630310PA7192182025-04-30False
17060000026315L17/dossiers17170600000263031706000002630311PA5692025-04-30False
17060000026316L17/dossiers17170600000263031706000002630312PA7218162025-04-30False
17060000026317L17/dossiers17170600000263031706000002630313PA7190322025-04-30False
17060000026318L17/dossiers17170600000263031706000002630314PA8413392025-04-30False
17060000026319L17/dossiers17170600000263031706000002630315PA3300082025-04-30False
17060000026320L17/dossiers17170600000263031706000002630316PA8408172025-04-30False
17060000026321L17/dossiers17170600000263031706000002630317PA7947982025-04-30False
17060000026322L17/dossiers17170600000263031706000002630318PA7194722025-04-30False
17060000026323L17/dossiers17170600000263031706000002630319PA6428682025-04-30False
17060000026324L17/dossiers17170600000263031706000002630320PA8414312025-04-30False
17060000026325L17/dossiers17170600000263031706000002630321PA7120152025-04-30False
17060000026326L17/dossiers17170600000263031706000002630322PA7946582025-04-30False
17060000026327L17/dossiers17170600000263031706000002630323PA6056942025-04-30False
17060000026328L17/dossiers17170600000263031706000002630324PA2677802025-04-30False
17060000026329L17/dossiers17170600000263031706000002630325PA8402352025-04-30False
17060000026330L17/dossiers17170600000263031706000002630326PA7222842025-04-30False
17060000026331L17/dossiers17170600000263031706000002630327PA7944702025-04-30False
17060000026332L17/dossiers17170600000263031706000002630328PA7942342025-04-30False
17060000026333L17/dossiers17170600000263031706000002630329PA2667972025-04-30False
17060000026334L17/dossiers17170600000263031706000002630330PA7940582025-04-30False
17060000026335L17/dossiers17170600000263031706000002630331PA7220702025-04-30False
17060000026336L17/dossiers17170600000263031706000002630332PA16302025-04-30False
17060000026337L17/dossiers17170600000263031706000002630333PA8410172025-04-30False
17060000026338L17/dossiers17170600000263031706000002630334PA2672002025-04-30False
17060000026339L17/dossiers17170600000263031706000002630335PA7197782025-04-30False
17060000026340L17/dossiers17170600000263031706000002630336PA7190522025-04-30False
17060000026341L17/dossiers17170600000263031706000002630337PA7192822025-04-30False
17060000026342L17/dossiers17170600000263031706000002630338PA8421252025-04-30False
17060000026343L17/dossiers17170600000263031706000002630339PA7194122025-04-30False
17060000026344L17/dossiers17170600000263031706000002630340PA3457222025-04-30False
17060000026345L17/dossiers17170600000263031706000002630341PA7944262025-04-30False
17060000026346L17/dossiers17170600000263031706000002630342PA7120142025-04-30False
17060000026347L17/dossiers17170600000263031706000002630343PA7953862025-04-30False
17060000026348L17/dossiers17170600000263031706000002630344PA7948382025-04-30False
17060000026349L17/dossiers17170600000263031706000002630345PA8416012025-04-30False
17060000026350L17/dossiers17170600000263031706000002630346PA6427252025-04-30False
17060000026351L17/dossiers17170600000263031706000002630347PA7202302025-04-30False