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
17060000025588L17/dossiers1717060000025585170600000255852PA8419552025-03-07False
17060000025589L17/dossiers1717060000025585170600000255853PA7206682025-03-07False
17060000025590L17/dossiers1717060000025585170600000255854PA7934322025-03-07False
17060000025591L17/dossiers1717060000025585170600000255855PA8412072025-03-07False
17060000025592L17/dossiers1717060000025585170600000255856PA8414952025-03-07False
17060000025593L17/dossiers1717060000025585170600000255857PA7961182025-03-07False
17060000025594L17/dossiers1717060000025585170600000255858PA7945622025-03-07False
17060000025595L17/dossiers1717060000025585170600000255859PA8422792025-03-07False
17060000025596L17/dossiers17170600000255851706000002558510PA7932382025-03-07False
17060000025597L17/dossiers17170600000255851706000002558511PA7933742025-03-07False
17060000025598L17/dossiers17170600000255851706000002558512PA7931582025-03-07False
17060000025599L17/dossiers17170600000255851706000002558513PA7944342025-03-07False
17060000025600L17/dossiers17170600000255851706000002558514PA8416452025-03-07False
17060000025601L17/dossiers17170600000255851706000002558515PA8420012025-03-07False
17060000025602L17/dossiers17170600000255851706000002558516PA7208222025-03-07False
17060000025603L17/dossiers17170600000255851706000002558517PA7948862025-03-07False
17060000025604L17/dossiers17170600000255851706000002558518PA7960422025-03-07False
17060000025605L17/dossiers17170600000255851706000002558519PA7938442025-03-07False
17060000025606L17/dossiers17170600000255851706000002558520PA8414872025-03-07False
17060000025607L17/dossiers17170600000255851706000002558521PA8411312025-03-07False
17060000025608L17/dossiers17170600000255851706000002558522PA7931822025-03-07False
17060000025609L17/dossiers17170600000255851706000002558523PA7931342025-03-07False
17060000025610L17/dossiers17170600000255851706000002558524PA8400752025-03-07False
17060000025611L17/dossiers17170600000255851706000002558525PA8407212025-03-07False
17060000025612L17/dossiers17170600000255851706000002558526PA7204682025-03-07False
17060000025613L17/dossiers17170600000255851706000002558527PA7941982025-03-07False
17060000025614L17/dossiers17170600000255851706000002558528PA8401592025-03-07False
17060000025615L17/dossiers17170600000255851706000002558529PA7935482025-03-07False
17060000025616L17/dossiers17170600000255851706000002558530PA7956442025-03-07False
17060000025617L17/dossiers17170600000255851706000002558531PA8401192025-03-07False
17060000025618L17/dossiers17170600000255851706000002558532PA7931662025-03-07False
17060000025619L17/dossiers17170600000255851706000002558533PA7939282025-03-07False
17060000025620L17/dossiers17170600000255851706000002558534PA7947622025-03-07False
17060000025621L17/dossiers17170600000255851706000002558535PA7931462025-03-07False
17060000025622L17/dossiers17170600000255851706000002558536PA8401352025-03-07False
17060000025623L17/dossiers17170600000255851706000002558537PA8420732025-03-07False
17060000025624L17/dossiers17170600000255851706000002558538PA8417612025-03-07False
17060000025625L17/dossiers17170600000255851706000002558539PA8416212025-03-07False
17060000025626L17/dossiers17170600000255851706000002558540PA7932462025-03-07False
17060000025627L17/dossiers17170600000255851706000002558541PA8416132025-03-07False
17060000025628L17/dossiers17170600000255851706000002558542PA8401432025-03-07False
17060000025629L17/dossiers17170600000255851706000002558543PA8408012025-03-07False
17060000025630L17/dossiers17170600000255851706000002558544PA7946782025-03-07False
17060000025631L17/dossiers17170600000255851706000002558545PA8411392025-03-07False
17060000025632L17/dossiers17170600000255851706000002558546PA7938922025-03-07False
17060000025633L17/dossiers17170600000255851706000002558547PA8417372025-03-07False
17060000025634L17/dossiers17170600000255851706000002558548PA7960342025-03-07False
17060000025635L17/dossiers17170600000255851706000002558549PA7938322025-03-07False
17060000025636L17/dossiers17170600000255851706000002558550PA7931022025-03-07False
17060000025637L17/dossiers17170600000255851706000002558551PA8416052025-03-07False