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
17060000021065L17/dossiers171706000002081417060000020814250PA8412152025-03-24False
17060000021066L17/dossiers171706000002081417060000020814251PA7942702025-03-24False
17060000021067L17/dossiers171706000002081417060000020814252PA7954822025-03-24False
17060000021068L17/dossiers171706000002081417060000020814253PA6075532025-03-24False
17060000021069L17/dossiers171706000002081417060000020814254PA6106542025-03-24False
17060000021070L17/dossiers171706000002081417060000020814255PA8413672025-03-24False
17060000021071L17/dossiers171706000002081417060000020814256PA8411912025-03-24False
17060000021072L17/dossiers171706000002081417060000020814257PA3419812025-03-24False
17060000021079L17/dossiers1717060000021077170600000210771PA7208922024-12-03False
17060000021080L17/dossiers1717060000021077170600000210772PA7952282024-12-03False
17060000021081L17/dossiers1717060000021077170600000210773PA7932622024-12-03False
17060000021082L17/dossiers1717060000021077170600000210774PA7949062024-12-03False
17060000021083L17/dossiers1717060000021077170600000210775PA7941382024-12-03False
17060000021084L17/dossiers1717060000021077170600000210776PA7955882024-12-03False
17060000021085L17/dossiers1717060000021077170600000210777PA7950842024-12-03False
17060000021086L17/dossiers1717060000021077170600000210778PA8421052024-12-03False
17060000021087L17/dossiers1717060000021077170600000210779PA8416572024-12-03False
17060000021088L17/dossiers17170600000210771706000002107710PA7204302024-12-03False
17060000021089L17/dossiers17170600000210771706000002107711PA7937722024-12-03False
17060000021090L17/dossiers17170600000210771706000002107712PA7956162024-12-03False
17060000021091L17/dossiers17170600000210771706000002107713PA7934442024-12-03False
17060000021092L17/dossiers17170600000210771706000002107714PA7949382024-12-03False
17060000021093L17/dossiers17170600000210771706000002107715PA7953182024-12-03False
17060000021094L17/dossiers17170600000210771706000002107716PA8410232024-12-03False
17060000021095L17/dossiers17170600000210771706000002107717PA7960902024-12-03False
17060000021096L17/dossiers17170600000210771706000002107718PA7939122024-12-03False
17060000021097L17/dossiers17170600000210771706000002107719PA8421872024-12-03False
17060000021098L17/dossiers17170600000210771706000002107720PA8420372024-12-03False
17060000021099L17/dossiers17170600000210771706000002107721PA7918122024-12-03False
17060000021100L17/dossiers17170600000210771706000002107722PA7212022024-12-03False
17060000021101L17/dossiers17170600000210771706000002107723PA7951362024-12-03False
17060000021102L17/dossiers17170600000210771706000002107724PA7934642024-12-03False
17060000021103L17/dossiers17170600000210771706000002107725PA8421552024-12-03False
17060000021104L17/dossiers17170600000210771706000002107726PA7952002024-12-03False
17060000021105L17/dossiers17170600000210771706000002107727PA7958442024-12-03False
17060000021106L17/dossiers17170600000210771706000002107728PA8412512024-12-03False
17060000021107L17/dossiers17170600000210771706000002107729PA7947862024-12-03False
17060000021108L17/dossiers17170600000210771706000002107730PA7948702024-12-03False
17060000021109L17/dossiers17170600000210771706000002107731PA7960702024-12-03False
17060000021110L17/dossiers17170600000210771706000002107732PA7953102024-12-03False
17060000021111L17/dossiers17170600000210771706000002107733PA7944782024-12-03False
17060000021112L17/dossiers17170600000210771706000002107734PA8419472024-12-03False
17060000021113L17/dossiers17170600000210771706000002107735PA7940822024-12-03False
17060000021114L17/dossiers17170600000210771706000002107736PA7941302024-12-03False
17060000021115L17/dossiers17170600000210771706000002107737PA7208462024-12-03False
17060000021116L17/dossiers17170600000210771706000002107738PA8417292024-12-03False
17060000021117L17/dossiers17170600000210771706000002107739PA7955162024-12-03False
17060000021118L17/dossiers17170600000210771706000002107740PA7956722024-12-03False
17060000021119L17/dossiers17170600000210771706000002107741PA8415152024-12-03False
17060000021120L17/dossiers17170600000210771706000002107742PA7957462024-12-03False