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
17060000021601L17/dossiers1717060000021591170600000215919PA7960102024-12-03False
17060000021602L17/dossiers17170600000215911706000002159110PA8422712024-12-03False
17060000021603L17/dossiers17170600000215911706000002159111PA7958202024-12-03False
17060000021604L17/dossiers17170600000215911706000002159112PA7212702024-12-03False
17060000021605L17/dossiers17170600000215911706000002159113PA7952402024-12-03False
17060000021606L17/dossiers17170600000215911706000002159114PA7958762024-12-03False
17060000021607L17/dossiers17170600000215911706000002159115PA6057452024-12-03False
17060000021608L17/dossiers17170600000215911706000002159116PA8422992024-12-03False
17060000021612L17/dossiers1717060000021610170600000216101PA7188502025-02-17False
17060000021613L17/dossiers1717060000021610170600000216102PA7199682025-02-17False
17060000021614L17/dossiers1717060000021610170600000216103PA6955122025-02-17False
17060000021615L17/dossiers1717060000021610170600000216104PA7935082025-02-17False
17060000021616L17/dossiers1717060000021610170600000216105PA7206442025-02-17False
17060000021617L17/dossiers1717060000021610170600000216106PA8409792025-02-17False
17060000021618L17/dossiers1717060000021610170600000216107PA7940582025-02-17False
17060000021619L17/dossiers1717060000021610170600000216108PA7203862025-02-17False
17060000021620L17/dossiers1717060000021610170600000216109PA7223902025-02-17False
17060000021621L17/dossiers17170600000216101706000002161010PA7187842025-02-17False
17060000021622L17/dossiers17170600000216101706000002161011PA3422402025-02-17False
17060000021623L17/dossiers17170600000216101706000002161012PA3325232024-12-092025-02-17False
17060000021624L17/dossiers17170600000216101706000002161013PA7214102025-02-17False
17060000021625L17/dossiers17170600000216101706000002161014PA7188382025-02-17False
17060000021626L17/dossiers17170600000216101706000002161015PA7941782025-02-17False
17060000021627L17/dossiers17170600000216101706000002161016PA7940382025-02-17False
17060000021628L17/dossiers17170600000216101706000002161017PA7214422025-02-17False
17060000021629L17/dossiers17170600000216101706000002161018PA16302025-02-17False
17060000021633L17/dossiers1717060000021631170600000216311PA2675612025-02-12False
17060000021634L17/dossiers1717060000021631170600000216312PA8407012025-02-12False
17060000021635L17/dossiers1717060000021631170600000216313PA8417372025-02-12False
17060000021636L17/dossiers1717060000021631170600000216314PA8409832025-02-12False
17060000021637L17/dossiers1717060000021631170600000216315PA7947702025-02-12False
17060000021638L17/dossiers1717060000021631170600000216316PA7957862025-02-12False
17060000021639L17/dossiers1717060000021631170600000216317PA8417692025-02-12False
17060000021640L17/dossiers1717060000021631170600000216318PA8409152025-02-12False
17060000021641L17/dossiers1717060000021631170600000216319PA8422272025-02-12False
17060000021642L17/dossiers17170600000216311706000002163110PA7933222025-02-12False
17060000021646L17/dossiers1717060000021644170600000216441PA7208922024-12-17False
17060000021647L17/dossiers1717060000021644170600000216442PA7952282024-12-17False
17060000021648L17/dossiers1717060000021644170600000216443PA7932622024-12-17False
17060000021649L17/dossiers1717060000021644170600000216444PA7949062024-12-17False
17060000021650L17/dossiers1717060000021644170600000216445PA7941382024-12-17False
17060000021651L17/dossiers1717060000021644170600000216446PA7955882024-12-17False
17060000021652L17/dossiers1717060000021644170600000216447PA7950842024-12-17False
17060000021653L17/dossiers1717060000021644170600000216448PA8421052024-12-17False
17060000021654L17/dossiers1717060000021644170600000216449PA8416572024-12-17False
17060000021655L17/dossiers17170600000216441706000002164410PA7204302024-12-17False
17060000021656L17/dossiers17170600000216441706000002164411PA7937722024-12-17False
17060000021657L17/dossiers17170600000216441706000002164412PA7956162024-12-17False
17060000021658L17/dossiers17170600000216441706000002164413PA7934442024-12-17False
17060000021659L17/dossiers17170600000216441706000002164414PA7949382024-12-17False