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
17060000044702L17/dossiers1717060000044692170600000446929PA8411832025-09-16False
17060000044703L17/dossiers17170600000446921706000004469210PA8413952025-09-16False
17060000044704L17/dossiers17170600000446921706000004469211PA8417692025-09-16False
17060000044705L17/dossiers17170600000446921706000004469212PA8406572025-09-16False
17060000044706L17/dossiers17170600000446921706000004469213PA8406852025-09-16False
17060000044707L17/dossiers17170600000446921706000004469214PA8408092025-09-16False
17060000044714L17/dossiers1717060000044712170600000447121PA7199682025-09-16False
17060000044715L17/dossiers1717060000044712170600000447122PA7188502025-09-16False
17060000044716L17/dossiers1717060000044712170600000447123PA7940422025-09-16False
17060000044717L17/dossiers1717060000044712170600000447124PA7188842025-09-16False
17060000044718L17/dossiers1717060000044712170600000447125PA6427252025-09-16False
17060000044719L17/dossiers1717060000044712170600000447126PA4085782025-09-16False
17060000044720L17/dossiers1717060000044712170600000447127PA2672852025-09-16False
17060000044721L17/dossiers1717060000044712170600000447128PA13272025-09-16False
17060000044722L17/dossiers1717060000044712170600000447129PA7749542025-09-16False
17060000044723L17/dossiers17170600000447121706000004471210PA6084162025-09-16False
17060000044724L17/dossiers17170600000447121706000004471211PA7941782025-09-16False
17060000044725L17/dossiers17170600000447121706000004471212PA7947502025-09-16False
17060000044726L17/dossiers17170600000447121706000004471213PA3422402025-09-16False
17060000044727L17/dossiers17170600000447121706000004471214PA7188382025-09-16False
17060000044728L17/dossiers17170600000447121706000004471215PA7223902025-09-16False
17060000044729L17/dossiers17170600000447121706000004471216PA7203862025-09-16False
17060000044730L17/dossiers17170600000447121706000004471217PA16302025-09-16False
17060000044731L17/dossiers17170600000447121706000004471218PA2667932025-09-16False
17060000044732L17/dossiers17170600000447121706000004471219PA7930942025-09-16False
17060000044733L17/dossiers17170600000447121706000004471220PA7935082025-09-16False
17060000044734L17/dossiers17170600000447121706000004471221PA6088262025-09-16False
17060000044738L17/dossiers1717060000044736170600000447361PA3421962025-10-01False
17060000044739L17/dossiers1717060000044736170600000447362PA7120142025-10-01False
17060000044740L17/dossiers1717060000044736170600000447363PA2677802025-10-01False
17060000044741L17/dossiers1717060000044736170600000447364PA7930942025-10-01False
17060000044742L17/dossiers1717060000044736170600000447365PA8419312025-10-01False
17060000044743L17/dossiers1717060000044736170600000447366PA7944862025-10-01False
17060000044744L17/dossiers1717060000044736170600000447367PA7195502025-10-01False
17060000044745L17/dossiers1717060000044736170600000447368PA7195122025-10-01False
17060000044746L17/dossiers1717060000044736170600000447369PA7212962025-10-01False
17060000044747L17/dossiers17170600000447361706000004473610PA7214262025-10-01False
17060000044748L17/dossiers17170600000447361706000004473611PA7946582025-10-01False
17060000044749L17/dossiers17170600000447361706000004473612PA8408292025-10-01False
17060000044750L17/dossiers17170600000447361706000004473613PA7200382025-10-01False
17060000044751L17/dossiers17170600000447361706000004473614PA7944342025-10-01False
17060000044752L17/dossiers17170600000447361706000004473615PA7931942025-10-01False
17060000044753L17/dossiers17170600000447361706000004473616PA7200222025-10-01False
17060000044754L17/dossiers17170600000447361706000004473617PA7933742025-10-01False
17060000044755L17/dossiers17170600000447361706000004473618PA7952402025-10-01False
17060000044756L17/dossiers17170600000447361706000004473619PA7214742025-10-01False
17060000044757L17/dossiers17170600000447361706000004473620PA6872142025-10-01False
17060000044758L17/dossiers17170600000447361706000004473621PA29402025-10-01False
17060000044759L17/dossiers17170600000447361706000004473622PA8416812025-10-01False
17060000044760L17/dossiers17170600000447361706000004473623PA8407652025-10-01False