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
17060000023345L17/dossiers1717060000023340170600000233404PA3359992025-01-07False
17060000023346L17/dossiers1717060000023340170600000233405PA7953622025-01-07False
17060000023347L17/dossiers1717060000023340170600000233406PA7954542025-01-07False
17060000023348L17/dossiers1717060000023340170600000233407PA8409972025-01-07False
17060000023349L17/dossiers1717060000023340170600000233408PA8418852025-01-07False
17060000023350L17/dossiers1717060000023340170600000233409PA8415072025-01-07False
17060000023351L17/dossiers17170600000233401706000002334010PA7940082025-01-07False
17060000023352L17/dossiers17170600000233401706000002334011PA7212102025-01-07False
17060000023353L17/dossiers17170600000233401706000002334012PA7934522025-01-07False
17060000023354L17/dossiers17170600000233401706000002334013PA8413512025-01-07False
17060000023355L17/dossiers17170600000233401706000002334014PA7939802025-01-07False
17060000023356L17/dossiers17170600000233401706000002334015PA7950102025-01-07False
17060000023357L17/dossiers17170600000233401706000002334016PA8414192025-01-07False
17060000023358L17/dossiers17170600000233401706000002334017PA8420132025-01-07False
17060000023359L17/dossiers17170600000233401706000002334018PA8409472025-01-07False
17060000023360L17/dossiers17170600000233401706000002334019PA7940222025-01-07False
17060000023361L17/dossiers17170600000233401706000002334020PA7941462025-01-07False
17060000023362L17/dossiers17170600000233401706000002334021PA8412232025-01-07False
17060000023363L17/dossiers17170600000233401706000002334022PA7956362025-01-07False
17060000023364L17/dossiers17170600000233401706000002334023PA8420452025-01-07False
17060000023365L17/dossiers17170600000233401706000002334024PA7937082025-01-07False
17060000023366L17/dossiers17170600000233401706000002334025PA7936642025-01-07False
17060000023367L17/dossiers17170600000233401706000002334026PA7941542025-01-07False
17060000023368L17/dossiers17170600000233401706000002334027PA7947782025-01-07False
17060000023369L17/dossiers17170600000233401706000002334028PA6065452025-01-07False
17060000023370L17/dossiers17170600000233401706000002334029PA7950762025-01-07False
17060000023371L17/dossiers17170600000233401706000002334030PA7221422025-01-07False
17060000023372L17/dossiers17170600000233401706000002334031PA6100022025-01-07False
17060000023373L17/dossiers17170600000233401706000002334032PA7958082025-01-07False
17060000023374L17/dossiers17170600000233401706000002334033PA7960182025-01-07False
17060000023375L17/dossiers17170600000233401706000002334034PA7362012025-01-07False
17060000023376L17/dossiers17170600000233401706000002334035PA8417132025-01-07False
17060000023377L17/dossiers17170600000233401706000002334036PA7939482025-01-07False
17060000023378L17/dossiers17170600000233401706000002334037PA29402025-01-07False
17060000023382L17/dossiers1717060000023380170600000233801PA8417012025-02-17False
17060000023383L17/dossiers1717060000023380170600000233802PA7940942025-02-17False
17060000023384L17/dossiers1717060000023380170600000233803PA6082642025-02-17False
17060000023385L17/dossiers1717060000023380170600000233804PA7191382025-02-17False
17060000023386L17/dossiers1717060000023380170600000233805PA7218962025-02-17False
17060000023387L17/dossiers1717060000023380170600000233806PA7939802025-02-17False
17060000023388L17/dossiers1717060000023380170600000233807PA7951082025-02-17False
17060000023389L17/dossiers1717060000023380170600000233808PA7937082025-02-17False
17060000023390L17/dossiers1717060000023380170600000233809PA8417132025-02-17False
17060000023391L17/dossiers17170600000233801706000002338010PA8418932025-02-17False
17060000023392L17/dossiers17170600000233801706000002338011PA29402025-02-17False
17060000023396L17/dossiers1717060000023394170600000233941PA7959822025-01-16False
17060000023397L17/dossiers1717060000023394170600000233942PA7208922025-01-16False
17060000023398L17/dossiers1717060000023394170600000233943PA7952282025-01-16False
17060000023399L17/dossiers1717060000023394170600000233944PA7932622025-01-16False
17060000023400L17/dossiers1717060000023394170600000233945PA7949062025-01-16False