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
17060000038245L17/dossiers1717060000038242170600000382422PA7956362025-07-04False
17060000038246L17/dossiers1717060000038242170600000382423PA8420452025-07-04False
17060000038247L17/dossiers1717060000038242170600000382424PA7937082025-07-04False
17060000038248L17/dossiers1717060000038242170600000382425PA7941542025-07-04False
17060000038249L17/dossiers1717060000038242170600000382426PA6065452025-07-04False
17060000038250L17/dossiers1717060000038242170600000382427PA7950762025-07-04False
17060000038251L17/dossiers1717060000038242170600000382428PA7221422025-07-04False
17060000038252L17/dossiers1717060000038242170600000382429PA6100022025-07-04False
17060000038253L17/dossiers17170600000382421706000003824210PA7960182025-07-04False
17060000038254L17/dossiers17170600000382421706000003824211PA7362012025-07-04False
17060000038255L17/dossiers17170600000382421706000003824212PA8417132025-07-04False
17060000038256L17/dossiers17170600000382421706000003824213PA7939482025-07-04False
17060000038257L17/dossiers17170600000382421706000003824214PA29402025-07-04False
17060000038258L17/dossiers17170600000382421706000003824215PA6076192025-07-04False
17060000038259L17/dossiers17170600000382421706000003824216PA3421962025-07-04False
17060000038260L17/dossiers17170600000382421706000003824217PA7942702025-07-04False
17060000038261L17/dossiers17170600000382421706000003824218PA7940942025-07-04False
17060000038262L17/dossiers17170600000382421706000003824219PA3424152025-07-04False
17060000038263L17/dossiers17170600000382421706000003824220PA7940082025-07-04False
17060000038264L17/dossiers17170600000382421706000003824221PA7937802025-07-04False
17060000038265L17/dossiers17170600000382421706000003824222PA7953622025-07-04False
17060000038266L17/dossiers17170600000382421706000003824223PA7954542025-07-04False
17060000038267L17/dossiers17170600000382421706000003824224PA8420132025-07-04False
17060000038268L17/dossiers17170600000382421706000003824225PA8412232025-07-04False
17060000038269L17/dossiers17170600000382421706000003824226PA7936642025-07-04False
17060000038270L17/dossiers17170600000382421706000003824227PA7947782025-07-04False
17060000038271L17/dossiers17170600000382421706000003824228PA7958082025-07-04False
17060000038272L17/dossiers17170600000382421706000003824229PA6109682025-07-04False
17060000038273L17/dossiers17170600000382421706000003824230PA5888842025-07-04False
17060000038274L17/dossiers17170600000382421706000003824231PA8417012025-07-04False
17060000038275L17/dossiers17170600000382421706000003824232PA8409972025-07-04False
17060000038276L17/dossiers17170600000382421706000003824233PA8418852025-07-04False
17060000038277L17/dossiers17170600000382421706000003824234PA8415072025-07-04False
17060000038278L17/dossiers17170600000382421706000003824235PA7212102025-07-04False
17060000038279L17/dossiers17170600000382421706000003824236PA7934522025-07-04False
17060000038280L17/dossiers17170600000382421706000003824237PA8413512025-07-04False
17060000038281L17/dossiers17170600000382421706000003824238PA7950102025-07-04False
17060000038282L17/dossiers17170600000382421706000003824239PA8414192025-07-04False
17060000038283L17/dossiers17170600000382421706000003824240PA8409472025-07-04False
17060000038284L17/dossiers17170600000382421706000003824241PA7940222025-07-04False
17060000038291L17/dossiers1717060000038289170600000382891PA7191382025-12-09False
17060000038292L17/dossiers1717060000038289170600000382892PA8410472025-12-09False
17060000038293L17/dossiers1717060000038289170600000382893PA7192822025-12-09False
17060000038294L17/dossiers1717060000038289170600000382894PA6057822025-12-09False
17060000038295L17/dossiers1717060000038289170600000382895PA2677632025-12-09False
17060000038296L17/dossiers1717060000038289170600000382896PA7952442025-12-09False
17060000038297L17/dossiers1717060000038289170600000382897PA7209762025-12-09False
17060000038298L17/dossiers1717060000038289170600000382898PA8419312025-12-09False
17060000038299L17/dossiers1717060000038289170600000382899PA7932102025-12-09False
17060000038300L17/dossiers17170600000382891706000003828910PA8413592025-12-09False