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
17060000027558L17/dossiers171706000002745217060000027452105PA7949942026-05-06False
17060000027562L17/dossiers1717060000027560170600000275601PA8412952025-03-20False
17060000027563L17/dossiers1717060000027560170600000275602PA7947022025-03-20False
17060000027564L17/dossiers1717060000027560170600000275603PA7212962025-03-20False
17060000027565L17/dossiers1717060000027560170600000275604PA7944862025-03-20False
17060000027566L17/dossiers1717060000027560170600000275605PA7195582025-03-20False
17060000027567L17/dossiers1717060000027560170600000275606PA8413592025-03-20False
17060000027568L17/dossiers1717060000027560170600000275607PA7952582025-03-20False
17060000027569L17/dossiers1717060000027560170600000275608PA7960182025-03-20False
17060000027570L17/dossiers1717060000027560170600000275609PA7218442025-03-20False
17060000027571L17/dossiers17170600000275601706000002756010PA7749622025-03-20False
17060000027572L17/dossiers17170600000275601706000002756011PA7199222025-03-20False
17060000027573L17/dossiers17170600000275601706000002756012PA7952402025-03-20False
17060000027574L17/dossiers17170600000275601706000002756013PA7202562025-03-20False
17060000027575L17/dossiers17170600000275601706000002756014PA7191382025-03-20False
17060000027576L17/dossiers17170600000275601706000002756015PA6100022025-03-20False
17060000027577L17/dossiers17170600000275601706000002756016PA8402352025-03-20False
17060000027578L17/dossiers17170600000275601706000002756017PA29402025-03-20False
17060000027579L17/dossiers17170600000275601706000002756018PA7946582025-03-20False
17060000027580L17/dossiers17170600000275601706000002756019PA7941542025-03-20False
17060000027581L17/dossiers17170600000275601706000002756020PA7950102025-03-20False
17060000027582L17/dossiers17170600000275601706000002756021PA7958682025-03-20False
17060000027583L17/dossiers17170600000275601706000002756022PA8417012025-03-20False
17060000027584L17/dossiers17170600000275601706000002756023PA7221502025-03-20False
17060000027585L17/dossiers17170600000275601706000002756024PA7954222025-03-20False
17060000027586L17/dossiers17170600000275601706000002756025PA8413512025-03-20False
17060000027587L17/dossiers17170600000275601706000002756026PA8226172025-03-20False
17060000027588L17/dossiers17170600000275601706000002756027PA7951002025-03-20False
17060000027589L17/dossiers17170600000275601706000002756028PA7947782025-03-20False
17060000027590L17/dossiers17170600000275601706000002756029PA8422712025-03-20False
17060000027591L17/dossiers17170600000275601706000002756030PA7942062025-03-20False
17060000027592L17/dossiers17170600000275601706000002756031PA7960102025-03-20False
17060000027593L17/dossiers17170600000275601706000002756032PA7937962025-03-20False
17060000027594L17/dossiers17170600000275601706000002756033PA7946862025-03-20False
17060000027595L17/dossiers17170600000275601706000002756034PA7939802025-03-20False
17060000027596L17/dossiers17170600000275601706000002756035PA7947862025-03-20False
17060000027597L17/dossiers17170600000275601706000002756036PA5888842025-03-20False
17060000027598L17/dossiers17170600000275601706000002756037PA7212702025-03-20False
17060000027599L17/dossiers17170600000275601706000002756038PA8406652025-03-20False
17060000027600L17/dossiers17170600000275601706000002756039PA6427642025-03-20False
17060000027601L17/dossiers17170600000275601706000002756040PA6431432025-03-20False
17060000027602L17/dossiers17170600000275601706000002756041PA8408292025-03-20False
17060000027603L17/dossiers17170600000275601706000002756042PA3424152025-03-20False
17060000027604L17/dossiers17170600000275601706000002756043PA6067932025-03-20False
17060000027605L17/dossiers17170600000275601706000002756044PA8422112025-03-20False
17060000027606L17/dossiers17170600000275601706000002756045PA8413152025-03-20False
17060000027607L17/dossiers17170600000275601706000002756046PA7940942025-03-20False
17060000027608L17/dossiers17170600000275601706000002756047PA7936242025-03-20False
17060000027609L17/dossiers17170600000275601706000002756048PA7957622025-03-20False
17060000027610L17/dossiers17170600000275601706000002756049PA6082642025-03-20False