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
17060000028613L17/dossiers17170600000285601706000002856052PA8406732025-03-11False
17060000028614L17/dossiers17170600000285601706000002856053PA3421962025-03-11False
17060000028615L17/dossiers17170600000285601706000002856054PA8266352025-03-11False
17060000028616L17/dossiers17170600000285601706000002856055PA8413272025-03-11False
17060000028617L17/dossiers17170600000285601706000002856056PA8417172025-03-11False
17060000028618L17/dossiers17170600000285601706000002856057PA8412432025-03-11False
17060000028619L17/dossiers17170600000285601706000002856058PA7749602025-03-11False
17060000028620L17/dossiers17170600000285601706000002856059PA3403432025-03-11False
17060000028621L17/dossiers17170600000285601706000002856060PA8410912025-03-11False
17060000028622L17/dossiers17170600000285601706000002856061PA8416812025-03-11False
17060000028623L17/dossiers17170600000285601706000002856062PA8418932025-03-11False
17060000028624L17/dossiers17170600000285601706000002856063PA7938162025-03-11False
17060000028625L17/dossiers17170600000285601706000002856064PA7944942025-03-11False
17060000028626L17/dossiers17170600000285601706000002856065PA7209922025-03-11False
17060000028630L17/dossiers1717060000028628170600000286281PA8407012025-03-11False
17060000028631L17/dossiers1717060000028628170600000286282PA8417692025-03-11False
17060000028632L17/dossiers1717060000028628170600000286283PA7943542025-03-11False
17060000028633L17/dossiers1717060000028628170600000286284PA7204682025-03-11False
17060000028634L17/dossiers1717060000028628170600000286285PA7949462025-03-11False
17060000028635L17/dossiers1717060000028628170600000286286PA7955522025-03-11False
17060000028636L17/dossiers1717060000028628170600000286287PA8407212025-03-11False
17060000028637L17/dossiers1717060000028628170600000286288PA7931342025-03-11False
17060000028638L17/dossiers1717060000028628170600000286289PA7936962025-03-11False
17060000028639L17/dossiers17170600000286281706000002862810PA8410672025-03-11False
17060000028640L17/dossiers17170600000286281706000002862811PA7959002025-03-11False
17060000028641L17/dossiers17170600000286281706000002862812PA8409672025-03-11False
17060000028642L17/dossiers17170600000286281706000002862813PA7936562025-03-11False
17060000028643L17/dossiers17170600000286281706000002862814PA8406572025-03-11False
17060000028644L17/dossiers17170600000286281706000002862815PA7960262025-03-11False
17060000028645L17/dossiers17170600000286281706000002862816PA8422272025-03-11False
17060000028646L17/dossiers17170600000286281706000002862817PA8408012025-03-11False
17060000028647L17/dossiers17170600000286281706000002862818PA8409152025-03-11False
17060000028648L17/dossiers17170600000286281706000002862819PA8422552025-03-11False
17060000028649L17/dossiers17170600000286281706000002862820PA7945022025-03-11False
17060000028650L17/dossiers17170600000286281706000002862821PA8417372025-03-11False
17060000028654L17/dossiers1717060000028652170600000286521PA7934322025-03-13False
17060000028655L17/dossiers1717060000028652170600000286522PA7945622025-03-13False
17060000028656L17/dossiers1717060000028652170600000286523PA7933742025-03-13False
17060000028657L17/dossiers1717060000028652170600000286524PA7931582025-03-13False
17060000028658L17/dossiers1717060000028652170600000286525PA7944342025-03-13False
17060000028659L17/dossiers1717060000028652170600000286526PA8416452025-03-13False
17060000028660L17/dossiers1717060000028652170600000286527PA8420012025-03-13False
17060000028661L17/dossiers1717060000028652170600000286528PA7948862025-03-13False
17060000028662L17/dossiers1717060000028652170600000286529PA7960422025-03-13False
17060000028663L17/dossiers17170600000286521706000002865210PA8411312025-03-13False
17060000028664L17/dossiers17170600000286521706000002865211PA7931342025-03-13False
17060000028665L17/dossiers17170600000286521706000002865212PA8400752025-03-13False
17060000028666L17/dossiers17170600000286521706000002865213PA7204682025-03-13False
17060000028667L17/dossiers17170600000286521706000002865214PA7941982025-03-13False
17060000028668L17/dossiers17170600000286521706000002865215PA8401592025-03-13False