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 151 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
17060000012806L17/dossiers17170600000127921706000001279213PA7941782024-11-13False
17060000012807L17/dossiers17170600000127921706000001279214PA8410472024-11-13False
17060000012808L17/dossiers17170600000127921706000001279215PA13272024-11-13False
17060000012809L17/dossiers17170600000127921706000001279216PA3309092024-11-13False
17060000012813L17/dossiers1717060000012811170600000128111PA7192722024-10-15False
17060000012814L17/dossiers1717060000012811170600000128112PA7223902024-10-15False
17060000012815L17/dossiers1717060000012811170600000128113PA2667932024-10-15False
17060000012816L17/dossiers1717060000012811170600000128114PA7120152024-10-15False
17060000012817L17/dossiers1717060000012811170600000128115PA7933422024-10-15False
17060000012818L17/dossiers1717060000012811170600000128116PA3422402024-10-15False
17060000012819L17/dossiers1717060000012811170600000128117PA7935082024-10-15False
17060000012820L17/dossiers1717060000012811170600000128118PA6955122024-10-15False
17060000012821L17/dossiers1717060000012811170600000128119PA6088262024-10-15False
17060000012822L17/dossiers17170600000128111706000001281110PA13272024-10-15False
17060000012823L17/dossiers17170600000128111706000001281111PA7214422024-10-15False
17060000012827L17/dossiers1717060000012825170600000128251PA7934322025-03-07False
17060000012828L17/dossiers1717060000012825170600000128252PA7945622025-03-07False
17060000012829L17/dossiers1717060000012825170600000128253PA7932382025-03-07False
17060000012830L17/dossiers1717060000012825170600000128254PA7933742025-03-07False
17060000012831L17/dossiers1717060000012825170600000128255PA7931582025-03-07False
17060000012832L17/dossiers1717060000012825170600000128256PA7944342025-03-07False
17060000012833L17/dossiers1717060000012825170600000128257PA8416452025-03-07False
17060000012834L17/dossiers1717060000012825170600000128258PA3096432025-03-07False
17060000012835L17/dossiers1717060000012825170600000128259PA7208222025-03-07False
17060000012836L17/dossiers17170600000128251706000001282510PA7206682025-03-07False
17060000012837L17/dossiers17170600000128251706000001282511PA7948862025-03-07False
17060000012838L17/dossiers17170600000128251706000001282512PA7960422025-03-07False
17060000012839L17/dossiers17170600000128251706000001282513PA8414872025-03-07False
17060000012840L17/dossiers17170600000128251706000001282514PA8411312025-03-07False
17060000012841L17/dossiers17170600000128251706000001282515PA7931342025-03-07False
17060000012842L17/dossiers17170600000128251706000001282516PA8400752025-03-07False
17060000012843L17/dossiers17170600000128251706000001282517PA8407212025-03-07False
17060000012844L17/dossiers17170600000128251706000001282518PA7204682025-03-07False
17060000012845L17/dossiers17170600000128251706000001282519PA7941982025-03-07False
17060000012846L17/dossiers17170600000128251706000001282520PA7935482025-03-07False
17060000012847L17/dossiers17170600000128251706000001282521PA7956442025-03-07False
17060000012848L17/dossiers17170600000128251706000001282522PA7931662025-03-07False
17060000012849L17/dossiers17170600000128251706000001282523PA7939282025-03-07False
17060000012850L17/dossiers17170600000128251706000001282524PA7933222025-03-07False
17060000012851L17/dossiers17170600000128251706000001282525PA7947622025-03-07False
17060000012852L17/dossiers17170600000128251706000001282526PA7931462025-03-07False
17060000012853L17/dossiers17170600000128251706000001282527PA8401352025-03-07False
17060000012854L17/dossiers17170600000128251706000001282528PA8417612025-03-07False
17060000012855L17/dossiers17170600000128251706000001282529PA7947182025-03-07False
17060000012856L17/dossiers17170600000128251706000001282530PA7932462025-03-07False
17060000012857L17/dossiers17170600000128251706000001282531PA7946782025-03-07False
17060000012858L17/dossiers17170600000128251706000001282532PA7938922025-03-07False
17060000012859L17/dossiers17170600000128251706000001282533PA7960342025-03-07False
17060000012860L17/dossiers17170600000128251706000001282534PA7938322025-03-07False
17060000012861L17/dossiers17170600000128251706000001282535PA7931022025-03-07False