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
17060000027773L17/dossiers17170600000277531706000002775319PA8417132025-02-19False
17060000027774L17/dossiers17170600000277531706000002775320PA8418932025-02-19False
17060000027775L17/dossiers17170600000277531706000002775321PA7214742025-02-19False
17060000027776L17/dossiers17170600000277531706000002775322PA7941662025-02-19False
17060000027780L17/dossiers1717060000027778170600000277781PA8406652025-03-03False
17060000027781L17/dossiers1717060000027778170600000277782PA6427642025-03-03False
17060000027782L17/dossiers1717060000027778170600000277783PA8408292025-03-03False
17060000027783L17/dossiers1717060000027778170600000277784PA3424152025-03-03False
17060000027784L17/dossiers1717060000027778170600000277785PA6067932025-03-03False
17060000027785L17/dossiers1717060000027778170600000277786PA8422112025-03-03False
17060000027786L17/dossiers1717060000027778170600000277787PA8413152025-03-03False
17060000027787L17/dossiers1717060000027778170600000277788PA7940942025-03-03False
17060000027788L17/dossiers1717060000027778170600000277789PA7936242025-03-03False
17060000027789L17/dossiers17170600000277781706000002777810PA7957622025-03-03False
17060000027790L17/dossiers17170600000277781706000002777811PA6082642025-03-03False
17060000027791L17/dossiers17170600000277781706000002777812PA8409032025-03-03False
17060000027792L17/dossiers17170600000277781706000002777813PA8412952025-03-03False
17060000027793L17/dossiers17170600000277781706000002777814PA10082025-03-03False
17060000027794L17/dossiers17170600000277781706000002777815PA7933942025-03-03False
17060000027795L17/dossiers17170600000277781706000002777816PA7954302025-03-03False
17060000027796L17/dossiers17170600000277781706000002777817PA8419192025-03-03False
17060000027797L17/dossiers17170600000277781706000002777818PA6065732025-03-03False
17060000027798L17/dossiers17170600000277781706000002777819PA8416332025-03-03False
17060000027799L17/dossiers17170600000277781706000002777820PA7948542025-03-03False
17060000027800L17/dossiers17170600000277781706000002777821PA8421952025-03-03False
17060000027801L17/dossiers17170600000277781706000002777822PA6093322025-03-03False
17060000027802L17/dossiers17170600000277781706000002777823PA8416652025-03-03False
17060000027803L17/dossiers17170600000277781706000002777824PA8409392025-03-03False
17060000027804L17/dossiers17170600000277781706000002777825PA3319732025-03-03False
17060000027805L17/dossiers17170600000277781706000002777826PA8414712025-03-03False
17060000027806L17/dossiers17170600000277781706000002777827PA8422632025-03-03False
17060000027807L17/dossiers17170600000277781706000002777828PA8418132025-03-03False
17060000027808L17/dossiers17170600000277781706000002777829PA8418532025-03-03False
17060000027809L17/dossiers17170600000277781706000002777830PA6431922025-03-03False
17060000027810L17/dossiers17170600000277781706000002777831PA3350542025-03-03False
17060000027811L17/dossiers17170600000277781706000002777832PA7951562025-03-03False
17060000027812L17/dossiers17170600000277781706000002777833PA8414632025-03-03False
17060000027813L17/dossiers17170600000277781706000002777834PA6431572025-03-03False
17060000027814L17/dossiers17170600000277781706000002777835PA8411072025-03-03False
17060000027815L17/dossiers17170600000277781706000002777836PA8413812025-03-03False
17060000027816L17/dossiers17170600000277781706000002777837PA8407932025-03-03False
17060000027817L17/dossiers17170600000277781706000002777838PA7942702025-03-03False
17060000027818L17/dossiers17170600000277781706000002777839PA8409552025-03-03False
17060000027819L17/dossiers17170600000277781706000002777840PA8413672025-03-03False
17060000027820L17/dossiers17170600000277781706000002777841PA3419812025-03-03False
17060000027821L17/dossiers17170600000277781706000002777842PA8406732025-03-03False
17060000027822L17/dossiers17170600000277781706000002777843PA3421962025-03-03False
17060000027823L17/dossiers17170600000277781706000002777844PA8266352025-03-03False
17060000027824L17/dossiers17170600000277781706000002777845PA8413272025-03-03False
17060000027825L17/dossiers17170600000277781706000002777846PA8417172025-03-03False