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
17060000028118L17/dossiers17170600000280711706000002807146PA8409152025-03-11False
17060000028119L17/dossiers17170600000280711706000002807147PA7945822025-03-11False
17060000028120L17/dossiers17170600000280711706000002807148PA7936562025-03-11False
17060000028121L17/dossiers17170600000280711706000002807149PA7959662025-03-11False
17060000028122L17/dossiers17170600000280711706000002807150PA7932302025-03-11False
17060000028123L17/dossiers17170600000280711706000002807151PA8419812025-03-11False
17060000028124L17/dossiers17170600000280711706000002807152PA7944422025-03-11False
17060000028125L17/dossiers17170600000280711706000002807153PA7954102025-03-11False
17060000028126L17/dossiers17170600000280711706000002807154PA8420972025-03-11False
17060000028127L17/dossiers17170600000280711706000002807155PA8422552025-03-11False
17060000028128L17/dossiers17170600000280711706000002807156PA8415532025-03-11False
17060000028129L17/dossiers17170600000280711706000002807157PA7932982025-03-11False
17060000028130L17/dossiers17170600000280711706000002807158PA8414792025-03-11False
17060000028131L17/dossiers17170600000280711706000002807159PA8407212025-03-11False
17060000028132L17/dossiers17170600000280711706000002807160PA8407732025-03-11False
17060000028133L17/dossiers17170600000280711706000002807161PA8417692025-03-11False
17060000028137L17/dossiers1717060000028135170600000281351PA7203622025-03-11False
17060000028138L17/dossiers1717060000028135170600000281352PA8414312025-03-11False
17060000028139L17/dossiers1717060000028135170600000281353PA7203862025-03-11False
17060000028140L17/dossiers1717060000028135170600000281354PA7205522025-03-11False
17060000028144L17/dossiers1717060000028142170600000281421PA7949062025-03-11False
17060000028145L17/dossiers1717060000028142170600000281422PA7208922025-03-11False
17060000028146L17/dossiers1717060000028142170600000281423PA7952282025-03-11False
17060000028147L17/dossiers1717060000028142170600000281424PA7932622025-03-11False
17060000028148L17/dossiers1717060000028142170600000281425PA7941382025-03-11False
17060000028149L17/dossiers1717060000028142170600000281426PA7955882025-03-11False
17060000028150L17/dossiers1717060000028142170600000281427PA7950842025-03-11False
17060000028151L17/dossiers1717060000028142170600000281428PA8421052025-03-11False
17060000028152L17/dossiers1717060000028142170600000281429PA8416572025-03-11False
17060000028153L17/dossiers17170600000281421706000002814210PA7204302025-03-11False
17060000028154L17/dossiers17170600000281421706000002814211PA7937722025-03-11False
17060000028155L17/dossiers17170600000281421706000002814212PA7956162025-03-11False
17060000028156L17/dossiers17170600000281421706000002814213PA7934442025-03-11False
17060000028157L17/dossiers17170600000281421706000002814214PA7949382025-03-11False
17060000028158L17/dossiers17170600000281421706000002814215PA7953182025-03-11False
17060000028159L17/dossiers17170600000281421706000002814216PA8410232025-03-11False
17060000028160L17/dossiers17170600000281421706000002814217PA7960902025-03-11False
17060000028161L17/dossiers17170600000281421706000002814218PA8421872025-03-11False
17060000028162L17/dossiers17170600000281421706000002814219PA8420372025-03-11False
17060000028163L17/dossiers17170600000281421706000002814220PA7918122025-03-11False
17060000028164L17/dossiers17170600000281421706000002814221PA7937362025-03-11False
17060000028165L17/dossiers17170600000281421706000002814222PA7212022025-03-11False
17060000028166L17/dossiers17170600000281421706000002814223PA7951362025-03-11False
17060000028167L17/dossiers17170600000281421706000002814224PA7934642025-03-11False
17060000028168L17/dossiers17170600000281421706000002814225PA8421552025-03-11False
17060000028169L17/dossiers17170600000281421706000002814226PA7952002025-03-11False
17060000028170L17/dossiers17170600000281421706000002814227PA7958442025-03-11False
17060000028171L17/dossiers17170600000281421706000002814228PA8412512025-03-11False
17060000028172L17/dossiers17170600000281421706000002814229PA7947862025-03-11False
17060000028173L17/dossiers17170600000281421706000002814230PA7948702025-03-11False