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
17060000037523L17/dossiers1717060000037520170600000375202PA7933742025-05-13False
17060000037524L17/dossiers1717060000037520170600000375203PA7208222025-05-13False
17060000037525L17/dossiers1717060000037520170600000375204PA7206682025-05-13False
17060000037526L17/dossiers1717060000037520170600000375205PA7948862025-05-13False
17060000037527L17/dossiers1717060000037520170600000375206PA7960422025-05-13False
17060000037528L17/dossiers1717060000037520170600000375207PA8414872025-05-13False
17060000037529L17/dossiers1717060000037520170600000375208PA7931342025-05-13False
17060000037530L17/dossiers1717060000037520170600000375209PA7204682025-05-13False
17060000037531L17/dossiers17170600000375201706000003752010PA7935482025-05-13False
17060000037532L17/dossiers17170600000375201706000003752011PA8401192025-05-13False
17060000037533L17/dossiers17170600000375201706000003752012PA8401352025-05-13False
17060000037534L17/dossiers17170600000375201706000003752013PA8407732025-05-13False
17060000037535L17/dossiers17170600000375201706000003752014PA8408012025-05-13False
17060000037536L17/dossiers17170600000375201706000003752015PA7938922025-05-13False
17060000037537L17/dossiers17170600000375201706000003752016PA8417372025-05-13False
17060000037538L17/dossiers17170600000375201706000003752017PA7960342025-05-13False
17060000037539L17/dossiers17170600000375201706000003752018PA7931022025-05-13False
17060000037540L17/dossiers17170600000375201706000003752019PA8416052025-05-13False
17060000037541L17/dossiers17170600000375201706000003752020PA7935922025-05-13False
17060000037542L17/dossiers17170600000375201706000003752021PA8407572025-05-13False
17060000037543L17/dossiers17170600000375201706000003752022PA8420852025-05-13False
17060000037544L17/dossiers17170600000375201706000003752023PA7940302025-05-13False
17060000037545L17/dossiers17170600000375201706000003752024PA8410752025-05-13False
17060000037546L17/dossiers17170600000375201706000003752025PA8408692025-05-13False
17060000037547L17/dossiers17170600000375201706000003752026PA7959122025-05-13False
17060000037548L17/dossiers17170600000375201706000003752027PA8418372025-05-13False
17060000037549L17/dossiers17170600000375201706000003752028PA7932902025-05-13False
17060000037550L17/dossiers17170600000375201706000003752029PA6429882025-05-13False
17060000037551L17/dossiers17170600000375201706000003752030PA7936082025-05-13False
17060000037552L17/dossiers17170600000375201706000003752031PA8418732025-05-13False
17060000037553L17/dossiers17170600000375201706000003752032PA8409672025-05-13False
17060000037554L17/dossiers17170600000375201706000003752033PA7939042025-05-13False
17060000037555L17/dossiers17170600000375201706000003752034PA8415872025-05-13False
17060000037556L17/dossiers17170600000375201706000003752035PA7947702025-05-13False
17060000037557L17/dossiers17170600000375201706000003752036PA7933142025-05-13False
17060000037558L17/dossiers17170600000375201706000003752037PA7957862025-05-13False
17060000037559L17/dossiers17170600000375201706000003752038PA7955522025-05-13False
17060000037560L17/dossiers17170600000375201706000003752039PA7946702025-05-13False
17060000037561L17/dossiers17170600000375201706000003752040PA8411992025-05-13False
17060000037562L17/dossiers17170600000375201706000003752041PA7945822025-05-13False
17060000037563L17/dossiers17170600000375201706000003752042PA7932302025-05-13False
17060000037564L17/dossiers17170600000375201706000003752043PA7932982025-05-13False
17060000037565L17/dossiers17170600000375201706000003752044PA8414792025-05-13False
17060000037566L17/dossiers17170600000375201706000003752045PA2675612025-05-13False
17060000037567L17/dossiers17170600000375201706000003752046PA8416452025-05-13False
17060000037568L17/dossiers17170600000375201706000003752047PA8411312025-05-13False
17060000037569L17/dossiers17170600000375201706000003752048PA8407212025-05-13False
17060000037570L17/dossiers17170600000375201706000003752049PA7939282025-05-13False
17060000037571L17/dossiers17170600000375201706000003752050PA7947622025-05-13False
17060000037572L17/dossiers17170600000375201706000003752051PA8416212025-05-13False