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
17060000042323L17/dossiers17170600000423041706000004230418PA7940942025-07-21False
17060000042324L17/dossiers17170600000423041706000004230419PA7936242025-07-21False
17060000042325L17/dossiers17170600000423041706000004230420PA7957622025-07-21False
17060000042326L17/dossiers17170600000423041706000004230421PA6082642025-07-21False
17060000042327L17/dossiers17170600000423041706000004230422PA8409032025-07-21False
17060000042328L17/dossiers17170600000423041706000004230423PA10082025-07-21False
17060000042329L17/dossiers17170600000423041706000004230424PA7933942025-07-21False
17060000042330L17/dossiers17170600000423041706000004230425PA7954302025-07-21False
17060000042331L17/dossiers17170600000423041706000004230426PA8419192025-07-21False
17060000042332L17/dossiers17170600000423041706000004230427PA6065732025-07-21False
17060000042333L17/dossiers17170600000423041706000004230428PA8416332025-07-21False
17060000042334L17/dossiers17170600000423041706000004230429PA7948542025-07-21False
17060000042335L17/dossiers17170600000423041706000004230430PA8421952025-07-21False
17060000042336L17/dossiers17170600000423041706000004230431PA6093322025-07-21False
17060000042337L17/dossiers17170600000423041706000004230432PA8416652025-07-21False
17060000042338L17/dossiers17170600000423041706000004230433PA3332852025-07-21False
17060000042339L17/dossiers17170600000423041706000004230434PA8409392025-07-21False
17060000042340L17/dossiers17170600000423041706000004230435PA3319732025-07-21False
17060000042341L17/dossiers17170600000423041706000004230436PA8401712025-07-21False
17060000042342L17/dossiers17170600000423041706000004230437PA15672025-07-21False
17060000042343L17/dossiers17170600000423041706000004230438PA8414712025-07-21False
17060000042344L17/dossiers17170600000423041706000004230439PA8422632025-07-21False
17060000042345L17/dossiers17170600000423041706000004230440PA8418132025-07-21False
17060000042346L17/dossiers17170600000423041706000004230441PA8418532025-07-21False
17060000042347L17/dossiers17170600000423041706000004230442PA16542025-07-21False
17060000042348L17/dossiers17170600000423041706000004230443PA6431922025-07-21False
17060000042349L17/dossiers17170600000423041706000004230444PA3350542025-07-21False
17060000042350L17/dossiers17170600000423041706000004230445PA7951562025-07-21False
17060000042351L17/dossiers17170600000423041706000004230446PA7749582025-07-21False
17060000042352L17/dossiers17170600000423041706000004230447PA8407652025-07-21False
17060000042353L17/dossiers17170600000423041706000004230448PA8414632025-07-21False
17060000042354L17/dossiers17170600000423041706000004230449PA6431572025-07-21False
17060000042355L17/dossiers17170600000423041706000004230450PA8411072025-07-21False
17060000042356L17/dossiers17170600000423041706000004230451PA8413812025-07-21False
17060000042357L17/dossiers17170600000423041706000004230452PA8407932025-07-21False
17060000042358L17/dossiers17170600000423041706000004230453PA7942702025-07-21False
17060000042359L17/dossiers17170600000423041706000004230454PA6081722025-07-21False
17060000042360L17/dossiers17170600000423041706000004230455PA6075532025-07-21False
17060000042361L17/dossiers17170600000423041706000004230456PA8409552025-07-21False
17060000042362L17/dossiers17170600000423041706000004230457PA8413672025-07-21False
17060000042363L17/dossiers17170600000423041706000004230458PA3419812025-07-21False
17060000042364L17/dossiers17170600000423041706000004230459PA8406732025-07-21False
17060000042365L17/dossiers17170600000423041706000004230460PA3421962025-07-21False
17060000042366L17/dossiers17170600000423041706000004230461PA8266352025-07-21False
17060000042367L17/dossiers17170600000423041706000004230462PA8413272025-07-21False
17060000042368L17/dossiers17170600000423041706000004230463PA8417172025-07-21False
17060000042369L17/dossiers17170600000423041706000004230464PA8412432025-07-21False
17060000042370L17/dossiers17170600000423041706000004230465PA7749602025-07-21False
17060000042374L17/dossiers1717060000042372170600000423721PA7918122025-07-11False
17060000042375L17/dossiers1717060000042372170600000423722PA7937362025-07-11False