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
17060000017911L17/dossiers171706000001779917060000017799111PA7200662026-04-16False
17060000017912L17/dossiers171706000001779917060000017799112PA7222522026-04-16False
17060000017913L17/dossiers171706000001779917060000017799113PA7955282026-04-16False
17060000017914L17/dossiers171706000001779917060000017799114PA8419272026-04-16False
17060000017915L17/dossiers171706000001779917060000017799115PA7932702026-04-16False
17060000017916L17/dossiers171706000001779917060000017799116PA7201382026-04-16False
17060000017917L17/dossiers171706000001779917060000017799117PA7201902026-04-16False
17060000017918L17/dossiers171706000001779917060000017799118PA8406732026-04-012026-04-03False
17060000017919L17/dossiers171706000001779917060000017799119PA7944862026-04-16False
17060000017920L17/dossiers171706000001779917060000017799120PA2677942026-04-16False
17060000017921L17/dossiers171706000001779917060000017799121PA7195502026-04-16False
17060000017922L17/dossiers171706000001779917060000017799122PA7941782026-04-16False
17060000017923L17/dossiers171706000001779917060000017799123PA7215842026-04-16False
17060000017924L17/dossiers171706000001779917060000017799124PA7959202026-04-16False
17060000017925L17/dossiers171706000001779917060000017799125PA6073952026-04-16False
17060000017926L17/dossiers171706000001779917060000017799126PA7953502026-04-16False
17060000017927L17/dossiers171706000001779917060000017799127PA7221022026-04-16False
17060000017928L17/dossiers171706000001779917060000017799128PA3315822026-04-16False
17060000017929L17/dossiers171706000001779917060000017799129PA7941182026-04-032026-04-03False
17060000017930L17/dossiers171706000001779917060000017799130PA7195122026-04-16False
17060000017931L17/dossiers171706000001779917060000017799131PA7950262026-04-16False
17060000017932L17/dossiers171706000001779917060000017799132PA7214742026-04-16False
17060000017933L17/dossiers171706000001779917060000017799133PA7211702026-04-16False
17060000017934L17/dossiers171706000001779917060000017799134PA7953262026-04-16False
17060000017935L17/dossiers171706000001779917060000017799135PA29602026-04-16False
17060000017939L17/dossiers1717060000017937170600000179371PA8412072024-11-19False
17060000017940L17/dossiers1717060000017937170600000179372PA8407012024-11-19False
17060000017941L17/dossiers1717060000017937170600000179373PA8407212024-11-19False
17060000017942L17/dossiers1717060000017937170600000179374PA8407732024-11-19False
17060000017943L17/dossiers1717060000017937170600000179375PA8409832024-11-19False
17060000017944L17/dossiers1717060000017937170600000179376PA8411832024-11-19False
17060000017945L17/dossiers1717060000017937170600000179377PA8413952024-11-19False
17060000017949L17/dossiers1717060000017947170600000179471PA7208922024-11-25False
17060000017950L17/dossiers1717060000017947170600000179472PA7952282024-11-25False
17060000017951L17/dossiers1717060000017947170600000179473PA7932622024-11-25False
17060000017952L17/dossiers1717060000017947170600000179474PA7949062024-11-25False
17060000017953L17/dossiers1717060000017947170600000179475PA7941382024-11-25False
17060000017954L17/dossiers1717060000017947170600000179476PA7955882024-11-25False
17060000017955L17/dossiers1717060000017947170600000179477PA7950842024-11-25False
17060000017956L17/dossiers1717060000017947170600000179478PA8421052024-11-25False
17060000017957L17/dossiers1717060000017947170600000179479PA8416572024-11-25False
17060000017958L17/dossiers17170600000179471706000001794710PA7937722024-11-25False
17060000017959L17/dossiers17170600000179471706000001794711PA7956162024-11-25False
17060000017960L17/dossiers17170600000179471706000001794712PA7934442024-11-25False
17060000017961L17/dossiers17170600000179471706000001794713PA7949382024-11-25False
17060000017962L17/dossiers17170600000179471706000001794714PA7953182024-11-25False
17060000017963L17/dossiers17170600000179471706000001794715PA8410232024-11-25False
17060000017964L17/dossiers17170600000179471706000001794716PA7960902024-11-25False
17060000017965L17/dossiers17170600000179471706000001794717PA7939122024-11-25False
17060000017966L17/dossiers17170600000179471706000001794718PA8421872024-11-25False