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
17060000016995L17/dossiers17170600000169391706000001693955PA3421962024-10-29False
17060000016996L17/dossiers17170600000169391706000001693956PA8266352024-10-29False
17060000016997L17/dossiers17170600000169391706000001693957PA8413272024-10-29False
17060000016998L17/dossiers17170600000169391706000001693958PA8417172024-10-29False
17060000016999L17/dossiers17170600000169391706000001693959PA8412432024-10-29False
17060000017000L17/dossiers17170600000169391706000001693960PA3403432024-10-29False
17060000017001L17/dossiers17170600000169391706000001693961PA8416812024-10-29False
17060000017002L17/dossiers17170600000169391706000001693962PA8418932024-10-29False
17060000017003L17/dossiers17170600000169391706000001693963PA7938162024-10-29False
17060000017004L17/dossiers17170600000169391706000001693964PA7944942024-10-29False
17060000017005L17/dossiers17170600000169391706000001693965PA7209922024-10-29False
17060000017009L17/dossiers1717060000017007170600000170071PA7199302024-10-29False
17060000017010L17/dossiers1717060000017007170600000170072PA8406652024-10-29False
17060000017011L17/dossiers1717060000017007170600000170073PA6427642024-10-29False
17060000017012L17/dossiers1717060000017007170600000170074PA6431432024-10-29False
17060000017013L17/dossiers1717060000017007170600000170075PA8408292024-10-29False
17060000017014L17/dossiers1717060000017007170600000170076PA3424152024-10-29False
17060000017015L17/dossiers1717060000017007170600000170077PA6067932024-10-29False
17060000017016L17/dossiers1717060000017007170600000170078PA8422112024-10-29False
17060000017017L17/dossiers1717060000017007170600000170079PA8413152024-10-29False
17060000017018L17/dossiers17170600000170071706000001700710PA7940942024-10-29False
17060000017019L17/dossiers17170600000170071706000001700711PA7957622024-10-29False
17060000017020L17/dossiers17170600000170071706000001700712PA6082642024-10-29False
17060000017021L17/dossiers17170600000170071706000001700713PA8409032024-10-29False
17060000017022L17/dossiers17170600000170071706000001700714PA8412952024-10-29False
17060000017023L17/dossiers17170600000170071706000001700715PA10082024-10-29False
17060000017024L17/dossiers17170600000170071706000001700716PA7933942024-10-29False
17060000017025L17/dossiers17170600000170071706000001700717PA7954302024-10-29False
17060000017026L17/dossiers17170600000170071706000001700718PA8419192024-10-29False
17060000017027L17/dossiers17170600000170071706000001700719PA6065732024-10-29False
17060000017028L17/dossiers17170600000170071706000001700720PA8416332024-10-29False
17060000017029L17/dossiers17170600000170071706000001700721PA7948542024-10-29False
17060000017030L17/dossiers17170600000170071706000001700722PA8421952024-10-29False
17060000017031L17/dossiers17170600000170071706000001700723PA6093322024-10-29False
17060000017032L17/dossiers17170600000170071706000001700724PA8416652024-10-29False
17060000017033L17/dossiers17170600000170071706000001700725PA3332852024-10-29False
17060000017034L17/dossiers17170600000170071706000001700726PA8409392024-10-29False
17060000017035L17/dossiers17170600000170071706000001700727PA8415392024-10-29False
17060000017036L17/dossiers17170600000170071706000001700728PA3319732024-10-29False
17060000017037L17/dossiers17170600000170071706000001700729PA8401712024-10-29False
17060000017038L17/dossiers17170600000170071706000001700730PA15672024-10-29False
17060000017039L17/dossiers17170600000170071706000001700731PA8414712024-10-29False
17060000017040L17/dossiers17170600000170071706000001700732PA8422632024-10-29False
17060000017041L17/dossiers17170600000170071706000001700733PA8418132024-10-29False
17060000017042L17/dossiers17170600000170071706000001700734PA8418532024-10-29False
17060000017043L17/dossiers17170600000170071706000001700735PA16542024-10-29False
17060000017044L17/dossiers17170600000170071706000001700736PA6431922024-10-29False
17060000017045L17/dossiers17170600000170071706000001700737PA3350542024-10-29False
17060000017046L17/dossiers17170600000170071706000001700738PA7951562024-10-29False
17060000017047L17/dossiers17170600000170071706000001700739PA7749582024-10-29False