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 151 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
17060000011121L17/dossiers17170600000110301706000001103090PA8408892025-03-07False
17060000011122L17/dossiers17170600000110301706000001103091PA8407212025-03-07False
17060000011123L17/dossiers17170600000110301706000001103092PA3302402025-03-07False
17060000011124L17/dossiers17170600000110301706000001103093PA7933222025-03-07False
17060000011125L17/dossiers17170600000110301706000001103094PA8407732025-03-07False
17060000011126L17/dossiers17170600000110301706000001103095PA8409832025-03-07False
17060000011127L17/dossiers17170600000110301706000001103096PA8413952025-03-07False
17060000011128L17/dossiers17170600000110301706000001103097PA8417692025-03-07False
17060000011129L17/dossiers17170600000110301706000001103098PA8406572025-03-07False
17060000011130L17/dossiers17170600000110301706000001103099PA8406852025-03-07False
17060000011131L17/dossiers171706000001103017060000011030100PA8408092025-03-07False
17060000011132L17/dossiers171706000001103017060000011030101PA8414792025-03-07False
17060000011133L17/dossiers171706000001103017060000011030102PA8401592025-03-07False
17060000011134L17/dossiers171706000001103017060000011030103PA8415532025-03-07False
17060000011135L17/dossiers171706000001103017060000011030104PA8415752025-03-07False
17060000011136L17/dossiers171706000001103017060000011030105PA8411312025-03-07False
17060000011137L17/dossiers171706000001103017060000011030106PA8422792025-03-07False
17060000011138L17/dossiers171706000001103017060000011030107PA8411832025-03-07False
17060000011139L17/dossiers171706000001103017060000011030108PA7961182025-03-07False
17060000011140L17/dossiers171706000001103017060000011030109PA8401192025-03-07False
17060000011141L17/dossiers171706000001103017060000011030110PA8400752025-03-07False
17060000011142L17/dossiers171706000001103017060000011030111PA8422552025-03-07False
17060000011143L17/dossiers171706000001103017060000011030112PA8409152025-03-07False
17060000011147L17/dossiers1717060000011145170600000111451PA8410672024-10-15False
17060000011148L17/dossiers1717060000011145170600000111452PA8412072024-10-15False
17060000011149L17/dossiers1717060000011145170600000111453PA2675612024-10-15False
17060000011150L17/dossiers1717060000011145170600000111454PA8408892024-10-15False
17060000011151L17/dossiers1717060000011145170600000111455PA8407012024-10-15False
17060000011152L17/dossiers1717060000011145170600000111456PA8407212024-10-15False
17060000011153L17/dossiers1717060000011145170600000111457PA7933222024-10-15False
17060000011154L17/dossiers1717060000011145170600000111458PA8407732024-10-15False
17060000011155L17/dossiers1717060000011145170600000111459PA8409832024-10-15False
17060000011156L17/dossiers17170600000111451706000001114510PA8411832024-10-15False
17060000011157L17/dossiers17170600000111451706000001114511PA8413952024-10-15False
17060000011158L17/dossiers17170600000111451706000001114512PA8417692024-10-15False
17060000011159L17/dossiers17170600000111451706000001114513PA8406852024-10-15False
17060000011160L17/dossiers17170600000111451706000001114514PA8406572024-10-15False
17060000011161L17/dossiers17170600000111451706000001114515PA8408092024-10-15False
17060000011165L17/dossiers1717060000011163170600000111631PA8410672024-10-15False
17060000011166L17/dossiers1717060000011163170600000111632PA7934322024-10-15False
17060000011167L17/dossiers1717060000011163170600000111633PA8412072024-10-15False
17060000011168L17/dossiers1717060000011163170600000111634PA8414952024-10-15False
17060000011169L17/dossiers1717060000011163170600000111635PA7945622024-10-15False
17060000011170L17/dossiers1717060000011163170600000111636PA8422792024-10-15False
17060000011171L17/dossiers1717060000011163170600000111637PA7932382024-10-15False
17060000011172L17/dossiers1717060000011163170600000111638PA7931582024-10-15False
17060000011173L17/dossiers1717060000011163170600000111639PA3096432024-10-15False
17060000011174L17/dossiers17170600000111631706000001116310PA8420012024-10-15False
17060000011175L17/dossiers17170600000111631706000001116311PA7208222024-10-15False
17060000011176L17/dossiers17170600000111631706000001116312PA7206682024-10-15False