AN · données ouvertes
Explorateur / questions_ecrites

questions_ecrites.question_renouvellement

Chemin question.renouvellements.renouvellement · présence : L17 11 %, L16 10 %, L15 14 %, L14 23 %

85 044 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…)
7info_jo_type_joVARCHARquestion.renouvellements.renouvellement.infoJO.typeJO · présence : L17 11 %, L16 10 %, L15 14 %, L14 23 %
8info_jo_date_joVARCHARquestion.renouvellements.renouvellement.infoJO.dateJO · présence : L17 11 %, L16 10 %, L15 14 %, L14 23 %
9info_jo_page_joVARCHARquestion.renouvellements.renouvellement.infoJO.pageJO · présence : L17 11 %, L16 10 %
10info_jo_num_joBIGINTquestion.renouvellements.renouvellement.infoJO.numJO · présence : L17 11 %, L16 10 %
11info_jo_url_legifranceVARCHARquestion.renouvellements.renouvellement.infoJO.urlLegifrance · présence : L17 11 %, L16 10 %
12info_jo_reference_norVARCHARquestion.renouvellements.renouvellement.infoJO.referenceNOR · présence : L17 11 %, L16 10 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordreinfo_jo_type_joinfo_jo_date_joinfo_jo_page_joinfo_jo_num_joinfo_jo_url_legifranceinfo_jo_reference_nor
17090000088624L17/questions_ecrites1717090000088616170900000886161JO_QUESTION2026-01-2720260004
17090000088648L17/questions_ecrites1717090000088640170900000886401JO_QUESTION2026-01-2720260004
17090000088667L17/questions_ecrites1717090000088661170900000886611JO_QUESTION2026-01-2720260004
17090000088697L17/questions_ecrites1717090000088691170900000886911JO_QUESTION2025-12-2320250051
17090000088739L17/questions_ecrites1717090000088734170900000887341JO_QUESTION2025-02-2520250008
17090000088767L17/questions_ecrites1717090000088761170900000887611JO_QUESTION2025-12-2320250051
17090000088896L17/questions_ecrites1717090000088890170900000888901JO_QUESTION2026-01-1320260002
17090000088926L17/questions_ecrites1717090000088921170900000889211JO_QUESTION2025-12-2320250051
17090000088927L17/questions_ecrites1717090000088921170900000889212JO_QUESTION2026-03-3120260013
17090000088928L17/questions_ecrites1717090000088921170900000889213JO_QUESTION2026-07-2820260030
17090000088947L17/questions_ecrites1717090000088941170900000889411JO_QUESTION2026-01-2720260004
17090000088954L17/questions_ecrites1717090000088948170900000889481JO_QUESTION2026-01-2720260004
17090000089005L17/questions_ecrites1717090000088999170900000889991JO_QUESTION2026-01-2020260003
17090000089011L17/questions_ecrites1717090000089006170900000890061JO_QUESTION2025-03-2520250012
17090000089037L17/questions_ecrites1717090000089031170900000890311JO_QUESTION2026-03-0320260009
17090000089038L17/questions_ecrites1717090000089031170900000890312JO_QUESTION2026-06-1620260024
17090000089156L17/questions_ecrites1717090000089150170900000891501JO_QUESTION2026-05-2620260021
17090000089157L17/questions_ecrites1717090000089150170900000891502JO_QUESTION2026-09-2220260038
17090000089216L17/questions_ecrites1717090000089210170900000892101JO_QUESTION2026-02-0320260005
17090000089222L17/questions_ecrites1717090000089217170900000892171JO_QUESTION2025-01-2120250003
17090000089431L17/questions_ecrites1717090000089426170900000894261JO_QUESTION2026-09-1520260037
17090000089438L17/questions_ecrites1717090000089432170900000894321JO_QUESTION2025-02-0420250005
17090000089492L17/questions_ecrites1717090000089486170900000894861JO_QUESTION2026-01-0620260001
17090000089499L17/questions_ecrites1717090000089493170900000894931JO_QUESTION2026-08-1120260032
17090000089523L17/questions_ecrites1717090000089517170900000895171JO_QUESTION2025-12-3020250052
17090000089524L17/questions_ecrites1717090000089517170900000895172JO_QUESTION2026-04-0720260014
17090000089525L17/questions_ecrites1717090000089517170900000895173JO_QUESTION2026-07-1420260028
17090000089551L17/questions_ecrites1717090000089544170900000895441JO_QUESTION2025-12-3020250052
17090000089655L17/questions_ecrites1717090000089649170900000896491JO_QUESTION2026-01-2720260004
17090000089687L17/questions_ecrites1717090000089681170900000896811JO_QUESTION2026-01-1320260002
17090000089688L17/questions_ecrites1717090000089681170900000896812JO_QUESTION2026-04-2120260016
17090000089767L17/questions_ecrites1717090000089760170900000897601JO_QUESTION2026-01-2720260004
17090000089768L17/questions_ecrites1717090000089760170900000897602JO_QUESTION2026-09-2220260038
17090000089808L17/questions_ecrites1717090000089802170900000898021JO_QUESTION2026-01-2720260004
17090000089857L17/questions_ecrites1717090000089852170900000898521JO_QUESTION2026-01-1320260002
17090000089917L17/questions_ecrites1717090000089911170900000899111JO_QUESTION2026-01-2720260004
17090000089940L17/questions_ecrites1717090000089935170900000899351JO_QUESTION2025-01-2120250003
17090000089941L17/questions_ecrites1717090000089935170900000899352JO_QUESTION2025-04-2920250017
17090000089974L17/questions_ecrites1717090000089966170900000899661JO_QUESTION2026-05-0520260018
17090000089992L17/questions_ecrites1717090000089987170900000899871JO_QUESTION2026-09-1520260037
17090000090015L17/questions_ecrites1717090000090009170900000900091JO_QUESTION2026-02-1720260007
17090000090108L17/questions_ecrites1717090000090101170900000901011JO_QUESTION2026-01-1320260002
17090000090109L17/questions_ecrites1717090000090101170900000901012JO_QUESTION2026-04-2120260016
17090000090110L17/questions_ecrites1717090000090101170900000901013JO_QUESTION2026-07-2820260030
17090000090127L17/questions_ecrites1717090000090122170900000901221JO_QUESTION2026-04-1420260015
17090000090128L17/questions_ecrites1717090000090122170900000901222JO_QUESTION2026-09-2920260039
17090000090136L17/questions_ecrites1717090000090129170900000901291JO_QUESTION2026-01-2720260004
17090000090148L17/questions_ecrites1717090000090143170900000901431JO_QUESTION2025-01-2120250003
17090000090149L17/questions_ecrites1717090000090143170900000901432JO_QUESTION2025-05-0620250018
17090000090156L17/questions_ecrites1717090000090150170900000901501JO_QUESTION2026-01-1320260002