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
17060000023021L17/dossiers17170600000229741706000002297446PA6100022025-02-03False
17060000023022L17/dossiers17170600000229741706000002297447PA8416812025-02-03False
17060000023023L17/dossiers17170600000229741706000002297448PA7944862025-02-03False
17060000023024L17/dossiers17170600000229741706000002297449PA7362012025-02-03False
17060000023025L17/dossiers17170600000229741706000002297450PA7937962025-02-03False
17060000023026L17/dossiers17170600000229741706000002297451PA8418932025-02-03False
17060000023027L17/dossiers17170600000229741706000002297452PA7938162025-02-03False
17060000023028L17/dossiers17170600000229741706000002297453PA7948302025-02-03False
17060000023032L17/dossiers1717060000023030170600000230301PA6429882025-03-07False
17060000023033L17/dossiers1717060000023030170600000230302PA7945622025-03-07False
17060000023034L17/dossiers1717060000023030170600000230303PA7194362025-03-07False
17060000023035L17/dossiers1717060000023030170600000230304PA8412072025-03-07False
17060000023036L17/dossiers1717060000023030170600000230305PA8420852025-03-07False
17060000023037L17/dossiers1717060000023030170600000230306PA8419812025-03-07False
17060000023038L17/dossiers1717060000023030170600000230307PA7956442025-03-07False
17060000023039L17/dossiers1717060000023030170600000230308PA8410672025-03-07False
17060000023040L17/dossiers1717060000023030170600000230309PA7936962025-03-07False
17060000023041L17/dossiers17170600000230301706000002303010PA7931822025-03-07False
17060000023042L17/dossiers17170600000230301706000002303011PA8418732025-03-07False
17060000023043L17/dossiers17170600000230301706000002303012PA7961182025-03-07False
17060000023044L17/dossiers17170600000230301706000002303013PA7931582025-03-07False
17060000023045L17/dossiers17170600000230301706000002303014PA8401352025-03-07False
17060000023046L17/dossiers17170600000230301706000002303015PA7960342025-03-07False
17060000023047L17/dossiers17170600000230301706000002303016PA8409672025-03-07False
17060000023048L17/dossiers17170600000230301706000002303017PA8417372025-03-07False
17060000023049L17/dossiers17170600000230301706000002303018PA7960262025-03-07False
17060000023050L17/dossiers17170600000230301706000002303019PA7947622025-03-07False
17060000023051L17/dossiers17170600000230301706000002303020PA7204682025-03-07False
17060000023052L17/dossiers17170600000230301706000002303021PA8408692025-03-07False
17060000023053L17/dossiers17170600000230301706000002303022PA8407212025-03-07False
17060000023054L17/dossiers17170600000230301706000002303023PA8414872025-03-07False
17060000023055L17/dossiers17170600000230301706000002303024PA7945822025-03-07False
17060000023056L17/dossiers17170600000230301706000002303025PA7959002025-03-07False
17060000023057L17/dossiers17170600000230301706000002303026PA7944422025-03-07False
17060000023058L17/dossiers17170600000230301706000002303027PA7933542025-03-07False
17060000023059L17/dossiers17170600000230301706000002303028PA7933142025-03-07False
17060000023060L17/dossiers17170600000230301706000002303029PA7948862025-03-07False
17060000023061L17/dossiers17170600000230301706000002303030PA7947702025-03-07False
17060000023062L17/dossiers17170600000230301706000002303031PA7219322025-03-07False
17060000023063L17/dossiers17170600000230301706000002303032PA7946782025-03-07False
17060000023064L17/dossiers17170600000230301706000002303033PA7959662025-03-07False
17060000023065L17/dossiers17170600000230301706000002303034PA8416052025-03-07False
17060000023066L17/dossiers17170600000230301706000002303035PA8414392025-03-07False
17060000023067L17/dossiers17170600000230301706000002303036PA8415632025-03-07False
17060000023068L17/dossiers17170600000230301706000002303037PA8409152025-03-07False
17060000023069L17/dossiers17170600000230301706000002303038PA7959742025-03-07False
17060000023070L17/dossiers17170600000230301706000002303039PA8420732025-03-07False
17060000023071L17/dossiers17170600000230301706000002303040PA8414792025-03-07False
17060000023072L17/dossiers17170600000230301706000002303041PA8414512025-03-07False
17060000023073L17/dossiers17170600000230301706000002303042PA7941982025-03-07False