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
17060000033042L17/dossiers1717060000033037170600000330374PA8407012025-04-01False
17060000033043L17/dossiers1717060000033037170600000330375PA8407732025-04-01False
17060000033044L17/dossiers1717060000033037170600000330376PA7959002025-04-01False
17060000033045L17/dossiers1717060000033037170600000330377PA7936322025-04-01False
17060000033046L17/dossiers1717060000033037170600000330378PA8408172025-04-01False
17060000033047L17/dossiers1717060000033037170600000330379PA8400752025-04-01False
17060000033048L17/dossiers17170600000330371706000003303710PA7933222025-04-01False
17060000033049L17/dossiers17170600000330371706000003303711PA7956442025-04-01False
17060000033050L17/dossiers17170600000330371706000003303712PA7936162025-04-01False
17060000033051L17/dossiers17170600000330371706000003303713PA8409152025-04-01False
17060000033052L17/dossiers17170600000330371706000003303714PA7214862025-04-01False
17060000033053L17/dossiers17170600000330371706000003303715PA8422552025-04-01False
17060000033057L17/dossiers1717060000033055170600000330551PA8417372025-04-01False
17060000033058L17/dossiers1717060000033055170600000330552PA7959002025-04-01False
17060000033059L17/dossiers1717060000033055170600000330553PA7944422025-04-01False
17060000033060L17/dossiers1717060000033055170600000330554PA7933142025-04-01False
17060000033061L17/dossiers1717060000033055170600000330555PA7936962025-04-01False
17060000033062L17/dossiers1717060000033055170600000330556PA7960342025-04-01False
17060000033063L17/dossiers1717060000033055170600000330557PA8410672025-04-01False
17060000033064L17/dossiers1717060000033055170600000330558PA8420852025-04-01False
17060000033065L17/dossiers1717060000033055170600000330559PA8407732025-04-01False
17060000033066L17/dossiers17170600000330551706000003305510PA7931662025-04-01False
17060000033067L17/dossiers17170600000330551706000003305511PA7959122025-04-01False
17060000033068L17/dossiers17170600000330551706000003305512PA7959742025-04-01False
17060000033069L17/dossiers17170600000330551706000003305513PA2675612025-04-01False
17060000033070L17/dossiers17170600000330551706000003305514PA8407012025-04-01False
17060000033071L17/dossiers17170600000330551706000003305515PA7933222025-04-01False
17060000033072L17/dossiers17170600000330551706000003305516PA8408012025-04-01False
17060000033073L17/dossiers17170600000330551706000003305517PA7943542025-04-01False
17060000033074L17/dossiers17170600000330551706000003305518PA7936082025-04-01False
17060000033075L17/dossiers17170600000330551706000003305519PA7194362025-04-01False
17060000033076L17/dossiers17170600000330551706000003305520PA8411992025-04-01False
17060000033077L17/dossiers17170600000330551706000003305521PA7945822025-04-01False
17060000033078L17/dossiers17170600000330551706000003305522PA7932302025-04-01False
17060000033079L17/dossiers17170600000330551706000003305523PA8420972025-04-01False
17060000033080L17/dossiers17170600000330551706000003305524PA7949462025-04-01False
17060000033081L17/dossiers17170600000330551706000003305525PA8417692025-04-01False
17060000033082L17/dossiers17170600000330551706000003305526PA8406572025-04-01False
17060000033086L17/dossiers1717060000033084170600000330841PA8410672025-07-03False
17060000033087L17/dossiers1717060000033084170600000330842PA8407012025-07-03False
17060000033088L17/dossiers1717060000033084170600000330843PA8417692025-07-03False
17060000033089L17/dossiers1717060000033084170600000330844PA7936962025-07-03False
17060000033090L17/dossiers1717060000033084170600000330845PA7933222025-07-03False
17060000033091L17/dossiers1717060000033084170600000330846PA7936082025-07-03False
17060000033092L17/dossiers1717060000033084170600000330847PA7932302025-07-03False
17060000033096L17/dossiers1717060000033094170600000330941PA7936162025-04-02False
17060000033097L17/dossiers1717060000033094170600000330942PA7957862025-04-02False
17060000033098L17/dossiers1717060000033094170600000330943PA8401352025-04-02False
17060000033099L17/dossiers1717060000033094170600000330944PA7947702025-04-02False
17060000033100L17/dossiers1717060000033094170600000330945PA7957782025-04-02False