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
17060000018338L17/dossiers1717060000018335170600000183352PA7943302025-01-20False
17060000018339L17/dossiers1717060000018335170600000183353PA7198902025-01-20False
17060000018340L17/dossiers1717060000018335170600000183354PA8408172025-01-20False
17060000018341L17/dossiers1717060000018335170600000183355PA7947982025-01-20False
17060000018342L17/dossiers1717060000018335170600000183356PA7201542025-01-20False
17060000018343L17/dossiers1717060000018335170600000183357PA7946582025-01-20False
17060000018344L17/dossiers1717060000018335170600000183358PA8402352025-01-20False
17060000018345L17/dossiers1717060000018335170600000183359PA7203542025-01-20False
17060000018346L17/dossiers17170600000183351706000001833510PA7194042025-01-20False
17060000018347L17/dossiers17170600000183351706000001833511PA3457222025-01-20False
17060000018348L17/dossiers17170600000183351706000001833512PA7944262025-01-20False
17060000018349L17/dossiers17170600000183351706000001833513PA7197562025-01-20False
17060000018350L17/dossiers17170600000183351706000001833514PA7953742025-01-20False
17060000018351L17/dossiers17170600000183351706000001833515PA6076192025-01-20False
17060000018352L17/dossiers17170600000183351706000001833516PA7214582025-01-20False
17060000018353L17/dossiers17170600000183351706000001833517PA7953502025-01-20False
17060000018354L17/dossiers17170600000183351706000001833518PA7937962025-01-20False
17060000018355L17/dossiers17170600000183351706000001833519PA7195582025-01-20False
17060000018359L17/dossiers1717060000018357170600000183571PA6428472025-03-13False
17060000018360L17/dossiers1717060000018357170600000183572PA7933422025-03-13False
17060000018361L17/dossiers1717060000018357170600000183573PA7206442025-03-13False
17060000018362L17/dossiers1717060000018357170600000183574PA7223902025-03-13False
17060000018363L17/dossiers1717060000018357170600000183575PA7214422025-03-13False
17060000018364L17/dossiers1717060000018357170600000183576PA6080162025-03-13False
17060000018365L17/dossiers1717060000018357170600000183577PA6088262025-03-13False
17060000018366L17/dossiers1717060000018357170600000183578PA7930942025-03-13False
17060000018367L17/dossiers1717060000018357170600000183579PA13272025-03-13False
17060000018371L17/dossiers1717060000018369170600000183691PA6428472025-03-13False
17060000018372L17/dossiers1717060000018369170600000183692PA7933422025-03-13False
17060000018373L17/dossiers1717060000018369170600000183693PA7206442025-03-13False
17060000018374L17/dossiers1717060000018369170600000183694PA7223902025-03-13False
17060000018375L17/dossiers1717060000018369170600000183695PA7214422025-03-13False
17060000018376L17/dossiers1717060000018369170600000183696PA6080162025-03-13False
17060000018377L17/dossiers1717060000018369170600000183697PA6088262025-03-13False
17060000018378L17/dossiers1717060000018369170600000183698PA7930942025-03-13False
17060000018379L17/dossiers1717060000018369170600000183699PA13272025-03-13False
17060000018383L17/dossiers1717060000018381170600000183811PA6428472025-03-13False
17060000018384L17/dossiers1717060000018381170600000183812PA7933422025-03-13False
17060000018385L17/dossiers1717060000018381170600000183813PA7206442025-03-13False
17060000018386L17/dossiers1717060000018381170600000183814PA7223902025-03-13False
17060000018387L17/dossiers1717060000018381170600000183815PA7214422025-03-13False
17060000018388L17/dossiers1717060000018381170600000183816PA6080162025-03-13False
17060000018389L17/dossiers1717060000018381170600000183817PA3309092025-03-13False
17060000018390L17/dossiers1717060000018381170600000183818PA6088262025-03-13False
17060000018391L17/dossiers1717060000018381170600000183819PA7930942025-03-13False
17060000018392L17/dossiers17170600000183811706000001838110PA13272025-03-13False
17060000018396L17/dossiers1717060000018394170600000183941PA7221022024-11-192024-11-19False
17060000018397L17/dossiers1717060000018394170600000183942PA8417012024-12-11False
17060000018398L17/dossiers1717060000018394170600000183943PA7195582024-12-11False
17060000018399L17/dossiers1717060000018394170600000183944PA7202562024-12-11False