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
17060000025298L17/dossiers1717060000025295170600000252952PA7935082025-03-05False
17060000025299L17/dossiers1717060000025295170600000252953PA8408172025-03-05False
17060000025300L17/dossiers1717060000025295170600000252954PA7223902025-03-05False
17060000025301L17/dossiers1717060000025295170600000252955PA8409792025-03-05False
17060000025302L17/dossiers1717060000025295170600000252956PA7947022025-03-05False
17060000025303L17/dossiers1717060000025295170600000252957PA7933422025-03-05False
17060000025304L17/dossiers1717060000025295170600000252958PA8413592025-03-05False
17060000025305L17/dossiers1717060000025295170600000252959PA7214422025-03-05False
17060000025306L17/dossiers17170600000252951706000002529510PA7949942025-03-05False
17060000025307L17/dossiers17170600000252951706000002529511PA7930942025-03-05False
17060000025308L17/dossiers17170600000252951706000002529512PA7931222025-03-05False
17060000025309L17/dossiers17170600000252951706000002529513PA6427252025-03-05False
17060000025310L17/dossiers17170600000252951706000002529514PA7199682025-03-05False
17060000025311L17/dossiers17170600000252951706000002529515PA7188382025-03-05False
17060000025312L17/dossiers17170600000252951706000002529516PA8421172025-03-05False
17060000025313L17/dossiers17170600000252951706000002529517PA6070902025-03-05False
17060000025314L17/dossiers17170600000252951706000002529518PA7214742025-03-05False
17060000025315L17/dossiers17170600000252951706000002529519PA3467822025-03-05False
17060000025316L17/dossiers17170600000252951706000002529520PA3309092025-03-05False
17060000025317L17/dossiers17170600000252951706000002529521PA6060982025-03-05False
17060000025321L17/dossiers1717060000025319170600000253191PA7939922025-02-24False
17060000025322L17/dossiers1717060000025319170600000253192PA3467822025-02-24False
17060000025323L17/dossiers1717060000025319170600000253193PA3457222025-02-24False
17060000025324L17/dossiers1717060000025319170600000253194PA7953742025-02-24False
17060000025325L17/dossiers1717060000025319170600000253195PA7214862025-02-24False
17060000025326L17/dossiers1717060000025319170600000253196PA7214742025-02-24False
17060000025334L17/dossiers1717060000025332170600000253321PA2667932025-02-17False
17060000025335L17/dossiers1717060000025332170600000253322PA7930942025-02-17False
17060000025336L17/dossiers1717060000025332170600000253323PA7940582025-02-17False
17060000025337L17/dossiers1717060000025332170600000253324PA6070902025-02-17False
17060000025338L17/dossiers1717060000025332170600000253325PA7188382025-02-17False
17060000025339L17/dossiers1717060000025332170600000253326PA3325232025-02-042025-02-17False
17060000025340L17/dossiers1717060000025332170600000253327PA7941782025-02-17False
17060000025341L17/dossiers1717060000025332170600000253328PA2667972025-02-17False
17060000025342L17/dossiers1717060000025332170600000253329PA7120152025-02-17False
17060000025343L17/dossiers17170600000253321706000002533210PA16302025-02-17False
17060000025344L17/dossiers17170600000253321706000002533211PA7223902025-02-17False
17060000025345L17/dossiers17170600000253321706000002533212PA13272025-02-17False
17060000025346L17/dossiers17170600000253321706000002533213PA7188842025-02-17False
17060000025347L17/dossiers17170600000253321706000002533214PA6428472025-02-17False
17060000025348L17/dossiers17170600000253321706000002533215PA3467822025-02-17False
17060000025349L17/dossiers17170600000253321706000002533216PA7187842025-02-17False
17060000025350L17/dossiers17170600000253321706000002533217PA7935082025-02-17False
17060000025351L17/dossiers17170600000253321706000002533218PA7214422025-02-17False
17060000025352L17/dossiers17170600000253321706000002533219PA7218162025-02-17False
17060000025353L17/dossiers17170600000253321706000002533220PA3422402025-02-17False
17060000025354L17/dossiers17170600000253321706000002533221PA7941182025-02-17False
17060000025355L17/dossiers17170600000253321706000002533222PA7192722025-02-17False
17060000025356L17/dossiers17170600000253321706000002533223PA2668082025-02-17False
17060000025357L17/dossiers17170600000253321706000002533224PA7214102025-02-17False