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
17060000015920L17/dossiers17170600000159051706000001590514PA8406572024-10-28False
17060000015921L17/dossiers17170600000159051706000001590515PA8408092024-10-28False
17060000015925L17/dossiers1717060000015923170600000159231PA7221622024-10-29False
17060000015926L17/dossiers1717060000015923170600000159232PA6056942024-10-29False
17060000015927L17/dossiers1717060000015923170600000159233PA7937162024-10-29False
17060000015928L17/dossiers1717060000015923170600000159234PA7931222024-10-29False
17060000015929L17/dossiers1717060000015923170600000159235PA7952582024-10-29False
17060000015930L17/dossiers1717060000015923170600000159236PA7195582024-10-29False
17060000015931L17/dossiers1717060000015923170600000159237PA7200382024-10-29False
17060000015932L17/dossiers1717060000015923170600000159238PA7190242024-10-29False
17060000015933L17/dossiers1717060000015923170600000159239PA3315822024-10-29False
17060000015934L17/dossiers17170600000159231706000001592310PA7200922024-10-29False
17060000015935L17/dossiers17170600000159231706000001592311PA7948102024-10-29False
17060000015936L17/dossiers17170600000159231706000001592312PA7953742024-10-29False
17060000015937L17/dossiers17170600000159231706000001592313PA7933982024-10-29False
17060000015938L17/dossiers17170600000159231706000001592314PA7190802024-10-29False
17060000015939L17/dossiers17170600000159231706000001592315PA6431842024-10-29False
17060000015940L17/dossiers17170600000159231706000001592316PA7191182024-10-29False
17060000015941L17/dossiers17170600000159231706000001592317PA6872142024-10-29False
17060000015942L17/dossiers17170600000159231706000001592318PA8172032024-10-29False
17060000015943L17/dossiers17170600000159231706000001592319PA7221022024-10-29False
17060000015944L17/dossiers17170600000159231706000001592320PA6065072024-10-29False
17060000015945L17/dossiers17170600000159231706000001592321PA7955282024-10-29False
17060000015946L17/dossiers17170600000159231706000001592322PA3457222024-10-29False
17060000015947L17/dossiers17170600000159231706000001592323PA7944862024-10-29False
17060000015948L17/dossiers17170600000159231706000001592324PA7202302024-10-29False
17060000015949L17/dossiers17170600000159231706000001592325PA8419312024-10-29False
17060000015950L17/dossiers17170600000159231706000001592326PA29602024-10-29False
17060000015951L17/dossiers17170600000159231706000001592327PA8413592024-10-29False
17060000015952L17/dossiers17170600000159231706000001592328PA7949822024-10-29False
17060000015953L17/dossiers17170600000159231706000001592329PA7957302024-10-29False
17060000015954L17/dossiers17170600000159231706000001592330PA7214262024-10-29False
17060000015955L17/dossiers17170600000159231706000001592331PA7950262024-10-29False
17060000015956L17/dossiers17170600000159231706000001592332PA2677802024-10-29False
17060000015957L17/dossiers17170600000159231706000001592333PA16302024-10-29False
17060000015958L17/dossiers17170600000159231706000001592334PA7201902024-10-29False
17060000015959L17/dossiers17170600000159231706000001592335PA6774832024-10-29False
17060000015960L17/dossiers17170600000159231706000001592336PA6088262024-10-29False
17060000015961L17/dossiers17170600000159231706000001592337PA7201542024-10-29False
17060000015962L17/dossiers17170600000159231706000001592338PA7944262024-10-29False
17060000015963L17/dossiers17170600000159231706000001592339PA7194722024-10-29False
17060000015964L17/dossiers17170600000159231706000001592340PA7930942024-10-29False
17060000015965L17/dossiers17170600000159231706000001592341PA7221342024-10-29False
17060000015966L17/dossiers17170600000159231706000001592342PA6073952024-10-29False
17060000015967L17/dossiers17170600000159231706000001592343PA13272024-10-29False
17060000015968L17/dossiers17170600000159231706000001592344PA8408172024-10-29False
17060000015969L17/dossiers17170600000159231706000001592345PA7205522024-10-29False
17060000015970L17/dossiers17170600000159231706000001592346PA7214742024-10-29False
17060000015971L17/dossiers17170600000159231706000001592347PA7947982024-10-29False
17060000015972L17/dossiers17170600000159231706000001592348PA7946582024-10-29False