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
17060000024264L17/dossiers17170600000242281706000002422835PA8413952025-03-07False
17060000024265L17/dossiers17170600000242281706000002422836PA7945982025-03-07False
17060000024266L17/dossiers17170600000242281706000002422837PA7945302025-03-07False
17060000024270L17/dossiers1717060000024268170600000242681PA7749622025-01-21False
17060000024271L17/dossiers1717060000024268170600000242682PA7961062025-01-21False
17060000024272L17/dossiers1717060000024268170600000242683PA7208382025-01-21False
17060000024273L17/dossiers1717060000024268170600000242684PA7958682025-01-21False
17060000024274L17/dossiers1717060000024268170600000242685PA2673062025-01-21False
17060000024275L17/dossiers1717060000024268170600000242686PA7218962025-01-21False
17060000024276L17/dossiers1717060000024268170600000242687PA7959982025-01-21False
17060000024277L17/dossiers1717060000024268170600000242688PA3356122025-01-21False
17060000024278L17/dossiers1717060000024268170600000242689PA7960102025-01-21False
17060000024279L17/dossiers17170600000242681706000002426810PA8422712025-01-21False
17060000024280L17/dossiers17170600000242681706000002426811PA7958202025-01-21False
17060000024281L17/dossiers17170600000242681706000002426812PA7212702025-01-21False
17060000024282L17/dossiers17170600000242681706000002426813PA7952402025-01-21False
17060000024283L17/dossiers17170600000242681706000002426814PA7958762025-01-21False
17060000024284L17/dossiers17170600000242681706000002426815PA6057452025-01-21False
17060000024285L17/dossiers17170600000242681706000002426816PA8422992025-01-21False
17060000024292L17/dossiers1717060000024290170600000242901PA8418372025-01-21False
17060000024293L17/dossiers1717060000024290170600000242902PA7959742025-01-21False
17060000024294L17/dossiers1717060000024290170600000242903PA7944422025-01-21False
17060000024295L17/dossiers1717060000024290170600000242904PA8422272025-01-21False
17060000024296L17/dossiers1717060000024290170600000242905PA7947702025-01-21False
17060000024297L17/dossiers1717060000024290170600000242906PA7933822025-01-21False
17060000024298L17/dossiers1717060000024290170600000242907PA7219322025-01-21False
17060000024299L17/dossiers1717060000024290170600000242908PA7949462025-01-21False
17060000024300L17/dossiers1717060000024290170600000242909PA8411832025-01-21False
17060000024301L17/dossiers17170600000242901706000002429010PA3096432025-01-21False
17060000024302L17/dossiers17170600000242901706000002429011PA8406572025-01-21False
17060000024303L17/dossiers17170600000242901706000002429012PA7933742025-01-21False
17060000024304L17/dossiers17170600000242901706000002429013PA8417372025-01-21False
17060000024305L17/dossiers17170600000242901706000002429014PA8407212025-01-21False
17060000024306L17/dossiers17170600000242901706000002429015PA8409152025-01-21False
17060000024307L17/dossiers17170600000242901706000002429016PA7935922025-01-21False
17060000024314L17/dossiers1717060000024312170600000243121PA6428472025-04-22False
17060000024315L17/dossiers1717060000024312170600000243122PA3322282025-04-22False
17060000024316L17/dossiers1717060000024312170600000243123PA3422402025-04-22False
17060000024317L17/dossiers1717060000024312170600000243124PA7947982025-04-22False
17060000024318L17/dossiers1717060000024312170600000243125PA7194722025-04-22False
17060000024319L17/dossiers1717060000024312170600000243126PA8414312025-04-22False
17060000024320L17/dossiers1717060000024312170600000243127PA7937162025-04-22False
17060000024321L17/dossiers1717060000024312170600000243128PA7201542025-04-22False
17060000024322L17/dossiers1717060000024312170600000243129PA6088262025-04-22False
17060000024323L17/dossiers17170600000243121706000002431210PA7221342025-04-22False
17060000024324L17/dossiers17170600000243121706000002431211PA3332852025-04-22False
17060000024325L17/dossiers17170600000243121706000002431212PA2667972025-04-22False
17060000024326L17/dossiers17170600000243121706000002431213PA2673182025-04-22False
17060000024327L17/dossiers17170600000243121706000002431214PA7200382025-04-22False
17060000024328L17/dossiers17170600000243121706000002431215PA7197982025-04-22False