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
17060000050595L17/dossiers1717060000050586170600000505868PA3356122025-11-18False
17060000050596L17/dossiers1717060000050586170600000505869PA7960102025-11-18False
17060000050597L17/dossiers17170600000505861706000005058610PA7931742025-11-18False
17060000050598L17/dossiers17170600000505861706000005058611PA7958202025-11-18False
17060000050599L17/dossiers17170600000505861706000005058612PA7212702025-11-18False
17060000050600L17/dossiers17170600000505861706000005058613PA7952402025-11-18False
17060000050601L17/dossiers17170600000505861706000005058614PA6057452025-11-18False
17060000050602L17/dossiers17170600000505861706000005058615PA8422992025-11-18False
17060000050606L17/dossiers1717060000050604170600000506041PA7961062025-11-18False
17060000050607L17/dossiers1717060000050604170600000506042PA7208382025-11-18False
17060000050608L17/dossiers1717060000050604170600000506043PA7947102025-11-18False
17060000050609L17/dossiers1717060000050604170600000506044PA7958682025-11-18False
17060000050610L17/dossiers1717060000050604170600000506045PA7218962025-11-18False
17060000050611L17/dossiers1717060000050604170600000506046PA7749622025-11-18False
17060000050612L17/dossiers1717060000050604170600000506047PA3356122025-11-18False
17060000050613L17/dossiers1717060000050604170600000506048PA7960102025-11-18False
17060000050614L17/dossiers1717060000050604170600000506049PA7931742025-11-18False
17060000050615L17/dossiers17170600000506041706000005060410PA7212702025-11-18False
17060000050616L17/dossiers17170600000506041706000005060411PA7952402025-11-18False
17060000050617L17/dossiers17170600000506041706000005060412PA7958762025-11-18False
17060000050618L17/dossiers17170600000506041706000005060413PA6057452025-11-18False
17060000050619L17/dossiers17170600000506041706000005060414PA8422992025-11-18False
17060000050623L17/dossiers1717060000050621170600000506211PA7955402025-11-18False
17060000050624L17/dossiers1717060000050621170600000506212PA7214862025-11-18False
17060000050625L17/dossiers1717060000050621170600000506213PA6084162025-11-18False
17060000050626L17/dossiers1717060000050621170600000506214PA7223902025-11-18False
17060000050627L17/dossiers1717060000050621170600000506215PA7218162025-11-18False
17060000050628L17/dossiers1717060000050621170600000506216PA7935202025-11-18False
17060000050629L17/dossiers1717060000050621170600000506217PA7188382025-11-18False
17060000050630L17/dossiers1717060000050621170600000506218PA7218442025-11-18False
17060000050631L17/dossiers1717060000050621170600000506219PA8413592025-11-18False
17060000050632L17/dossiers17170600000506211706000005062110PA2668082025-11-18False
17060000050633L17/dossiers17170600000506211706000005062111PA8409792025-11-18False
17060000050634L17/dossiers17170600000506211706000005062112PA7214422025-11-18False
17060000050635L17/dossiers17170600000506211706000005062113PA7950262025-11-18False
17060000050636L17/dossiers17170600000506211706000005062114PA7187842025-11-18False
17060000050637L17/dossiers17170600000506211706000005062115PA6427252025-11-18False
17060000050638L17/dossiers17170600000506211706000005062116PA7930942025-11-18False
17060000050639L17/dossiers17170600000506211706000005062117PA7931222025-11-18False
17060000050640L17/dossiers17170600000506211706000005062118PA7941782025-11-18False
17060000050641L17/dossiers17170600000506211706000005062119PA7214742025-11-18False
17060000050642L17/dossiers17170600000506211706000005062120PA6088262025-11-18False
17060000050643L17/dossiers17170600000506211706000005062121PA3467822025-11-18False
17060000050644L17/dossiers17170600000506211706000005062122PA3309092025-11-18False
17060000050645L17/dossiers17170600000506211706000005062123PA6431042025-11-18False
17060000050646L17/dossiers17170600000506211706000005062124PA8172032025-11-18False
17060000050650L17/dossiers1717060000050648170600000506481PA8408572025-11-18False
17060000050651L17/dossiers1717060000050648170600000506482PA8415872025-11-18False
17060000050652L17/dossiers1717060000050648170600000506483PA7940302025-11-18False
17060000050653L17/dossiers1717060000050648170600000506484PA7933302025-11-18False