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
17060000016453L17/dossiers17170600000163991706000001639953PA3421962024-10-29False
17060000016454L17/dossiers17170600000163991706000001639954PA8266352024-10-29False
17060000016455L17/dossiers17170600000163991706000001639955PA8413272024-10-29False
17060000016456L17/dossiers17170600000163991706000001639956PA8417172024-10-29False
17060000016457L17/dossiers17170600000163991706000001639957PA8412432024-10-29False
17060000016458L17/dossiers17170600000163991706000001639958PA7749602024-10-29False
17060000016459L17/dossiers17170600000163991706000001639959PA3403432024-10-29False
17060000016460L17/dossiers17170600000163991706000001639960PA8410912024-10-29False
17060000016461L17/dossiers17170600000163991706000001639961PA8416812024-10-29False
17060000016462L17/dossiers17170600000163991706000001639962PA8418932024-10-29False
17060000016463L17/dossiers17170600000163991706000001639963PA7938162024-10-29False
17060000016464L17/dossiers17170600000163991706000001639964PA7944942024-10-29False
17060000016465L17/dossiers17170600000163991706000001639965PA7209922024-10-29False
17060000016469L17/dossiers1717060000016467170600000164671PA6056942024-10-29False
17060000016470L17/dossiers1717060000016467170600000164672PA7221342024-10-29False
17060000016471L17/dossiers1717060000016467170600000164673PA8402352024-10-29False
17060000016472L17/dossiers1717060000016467170600000164674PA7200382024-10-29False
17060000016473L17/dossiers1717060000016467170600000164675PA6431842024-10-29False
17060000016474L17/dossiers1717060000016467170600000164676PA3457222024-10-29False
17060000016475L17/dossiers1717060000016467170600000164677PA6774832024-10-29False
17060000016476L17/dossiers1717060000016467170600000164678PA7944862024-10-29False
17060000016477L17/dossiers1717060000016467170600000164679PA7195122024-10-29False
17060000016478L17/dossiers17170600000164671706000001646710PA7950462024-10-29False
17060000016482L17/dossiers1717060000016480170600000164801PA7951642025-10-28False
17060000016483L17/dossiers1717060000016480170600000164802PA6057452025-10-28False
17060000016484L17/dossiers1717060000016480170600000164803PA7939802025-10-28False
17060000016485L17/dossiers1717060000016480170600000164804PA7940942025-10-28False
17060000016486L17/dossiers1717060000016480170600000164805PA7952282025-10-28False
17060000016487L17/dossiers1717060000016480170600000164806PA7932622025-10-28False
17060000016488L17/dossiers1717060000016480170600000164807PA7949062025-10-28False
17060000016489L17/dossiers1717060000016480170600000164808PA7941382025-10-28False
17060000016490L17/dossiers1717060000016480170600000164809PA6109682025-10-28False
17060000016491L17/dossiers17170600000164801706000001648010PA7955882025-10-28False
17060000016492L17/dossiers17170600000164801706000001648011PA7950842025-10-28False
17060000016493L17/dossiers17170600000164801706000001648012PA8421052025-10-28False
17060000016494L17/dossiers17170600000164801706000001648013PA5888842025-10-28False
17060000016495L17/dossiers17170600000164801706000001648014PA8417012025-10-28False
17060000016496L17/dossiers17170600000164801706000001648015PA8416572025-10-28False
17060000016497L17/dossiers17170600000164801706000001648016PA7961062025-10-28False
17060000016498L17/dossiers17170600000164801706000001648017PA7204302025-10-28False
17060000016499L17/dossiers17170600000164801706000001648018PA7937722025-10-28False
17060000016500L17/dossiers17170600000164801706000001648019PA7956162025-10-28False
17060000016501L17/dossiers17170600000164801706000001648020PA7934442025-10-28False
17060000016502L17/dossiers17170600000164801706000001648021PA8418852025-10-28False
17060000016503L17/dossiers17170600000164801706000001648022PA7949382025-10-28False
17060000016504L17/dossiers17170600000164801706000001648023PA7953182025-10-28False
17060000016505L17/dossiers17170600000164801706000001648024PA8410232025-10-28False
17060000016506L17/dossiers17170600000164801706000001648025PA7960902025-10-28False
17060000016507L17/dossiers17170600000164801706000001648026PA7939122025-10-28False
17060000016508L17/dossiers17170600000164801706000001648027PA8421872025-10-28False