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
17060000005299L17/dossiers171706000000515617060000005156142PA7572252023-07-04False
17060000005300L17/dossiers171706000000515617060000005156143PA7934162023-07-04False
17060000005301L17/dossiers171706000000515617060000005156144PA7948022023-07-04False
17060000005302L17/dossiers171706000000515617060000005156145PA7196722023-07-04False
17060000005303L17/dossiers171706000000515617060000005156146PA7201902023-07-04False
17060000005304L17/dossiers171706000000515617060000005156147PA7944862023-07-04False
17060000005305L17/dossiers171706000000515617060000005156148PA7207542023-07-04False
17060000005306L17/dossiers171706000000515617060000005156149PA7195502023-07-04False
17060000005307L17/dossiers171706000000515617060000005156150PA7949302023-07-04False
17060000005308L17/dossiers171706000000515617060000005156151PA7215842023-07-04False
17060000005309L17/dossiers171706000000515617060000005156152PA7200142023-07-04False
17060000005310L17/dossiers171706000000515617060000005156153PA6073952023-07-04False
17060000005311L17/dossiers171706000000515617060000005156154PA7214822023-07-04False
17060000005312L17/dossiers171706000000515617060000005156155PA7221022023-07-04False
17060000005313L17/dossiers171706000000515617060000005156156PA6066392023-07-04False
17060000005314L17/dossiers171706000000515617060000005156157PA7195122023-07-04False
17060000005315L17/dossiers171706000000515617060000005156158PA7211702023-07-04False
17060000005316L17/dossiers171706000000515617060000005156159PA7931942023-07-04False
17060000005317L17/dossiers171706000000515617060000005156160PA7212622023-07-04False
17060000005318L17/dossiers171706000000515617060000005156161PA7953262023-07-04False
17060000005319L17/dossiers171706000000515617060000005156162PA29602023-07-04False
17060000005320L17/dossiers171706000000515617060000005156163PA7950462023-07-04False
17060000005321L17/dossiers171706000000515617060000005156164PA7189622023-07-04False
17060000005322L17/dossiers171706000000515617060000005156165PA7959342023-07-042023-07-06False
17060000005329L17/dossiers1717060000005327170600000053271PA7187842023-10-17False
17060000005330L17/dossiers1717060000005327170600000053272PA2667882023-10-17False
17060000005331L17/dossiers1717060000005327170600000053273PA7190242023-10-17False
17060000005332L17/dossiers1717060000005327170600000053274PA7933062023-10-17False
17060000005333L17/dossiers1717060000005327170600000053275PA7207542023-10-17False
17060000005334L17/dossiers1717060000005327170600000053276PA7221622023-10-17False
17060000005335L17/dossiers1717060000005327170600000053277PA7218442023-10-17False
17060000005336L17/dossiers1717060000005327170600000053278PA3403432023-10-17False
17060000005340L17/dossiers1717060000005338170600000053381PA7196642023-10-17False
17060000005341L17/dossiers1717060000005338170600000053382PA7940382023-10-17False
17060000005342L17/dossiers1717060000005338170600000053383PA6427642023-10-17False
17060000005343L17/dossiers1717060000005338170600000053384PA7214102023-10-17False
17060000005344L17/dossiers1717060000005338170600000053385PA7187102023-10-17False
17060000005345L17/dossiers1717060000005338170600000053386PA7940082023-10-17False
17060000005346L17/dossiers1717060000005338170600000053387PA7931222023-10-17False
17060000005347L17/dossiers1717060000005338170600000053388PA7948542023-10-17False
17060000005348L17/dossiers1717060000005338170600000053389PA6056942023-10-17False
17060000005349L17/dossiers17170600000053381706000000533810PA6059912023-10-17False
17060000005350L17/dossiers17170600000053381706000000533811PA2673362023-10-17False
17060000005351L17/dossiers17170600000053381706000000533812PA7940222023-10-17False
17060000005352L17/dossiers17170600000053381706000000533813PA7198742023-10-17False
17060000005353L17/dossiers17170600000053381706000000533814PA7193822023-10-17False
17060000005354L17/dossiers17170600000053381706000000533815PA7948102023-10-17False
17060000005355L17/dossiers17170600000053381706000000533816PA3442012023-10-17False
17060000005356L17/dossiers17170600000053381706000000533817PA6081722023-10-17False
17060000005357L17/dossiers17170600000053381706000000533818PA6075532023-10-17False