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
17090000018232L17/questions_ecrites1717090000018229170900000182291JO_QUESTION2026-07-2120260029
17090000018247L17/questions_ecrites1717090000018242170900000182421JO_QUESTION2025-01-2820250004
17090000018276L17/questions_ecrites1717090000018273170900000182731JO_QUESTION2026-07-1420260028
17090000018284L17/questions_ecrites1717090000018281170900000182811JO_QUESTION2026-06-2320260025
17090000018290L17/questions_ecrites1717090000018285170900000182851JO_QUESTION2025-02-1120250006
17090000018328L17/questions_ecrites1717090000018324170900000183241JO_QUESTION2026-07-0720260027
17090000018366L17/questions_ecrites1717090000018363170900000183631JO_QUESTION2026-07-0720260027
17090000018379L17/questions_ecrites1717090000018376170900000183761JO_QUESTION2026-06-3020260026
17090000018394L17/questions_ecrites1717090000018391170900000183911JO_QUESTION2026-07-0720260027
17090000018438L17/questions_ecrites1717090000018434170900000184341JO_QUESTION2026-07-0720260027
17090000018563L17/questions_ecrites1717090000018558170900000185581JO_QUESTION2025-02-0420250005
17090000018571L17/questions_ecrites1717090000018568170900000185681JO_QUESTION2026-07-2820260030
17090000018636L17/questions_ecrites1717090000018633170900000186331JO_QUESTION2026-09-0820260036
17090000018751L17/questions_ecrites1717090000018748170900000187481JO_QUESTION2026-07-2820260030
17090000018849L17/questions_ecrites1717090000018846170900000188461JO_QUESTION2026-07-0720260027
17090000018977L17/questions_ecrites1717090000018973170900000189731JO_QUESTION2026-07-0720260027
17090000018994L17/questions_ecrites1717090000018991170900000189911JO_QUESTION2026-07-1420260028
17090000019015L17/questions_ecrites1717090000019012170900000190121JO_QUESTION2026-07-1420260028
17090000019036L17/questions_ecrites1717090000019033170900000190331JO_QUESTION2026-07-2120260029
17090000019040L17/questions_ecrites1717090000019037170900000190371JO_QUESTION2026-09-1520260037
17090000019226L17/questions_ecrites1717090000019223170900000192231JO_QUESTION2026-07-0720260027
17090000019238L17/questions_ecrites1717090000019230170900000192301JO_QUESTION2025-02-0420250005
17090000019285L17/questions_ecrites1717090000019280170900000192801JO_QUESTION2025-02-1120250006
17090000019286L17/questions_ecrites1717090000019280170900000192802JO_QUESTION2025-05-2720250021
17090000019287L17/questions_ecrites1717090000019280170900000192803JO_QUESTION2025-09-0220250035
17090000019302L17/questions_ecrites1717090000019299170900000192991JO_QUESTION2026-07-2820260030
17090000019325L17/questions_ecrites1717090000019321170900000193211JO_QUESTION2026-07-2820260030
17090000019415L17/questions_ecrites1717090000019412170900000194121JO_QUESTION2026-07-2820260030
17090000019459L17/questions_ecrites1717090000019455170900000194551JO_QUESTION2026-07-0720260027
17090000019556L17/questions_ecrites1717090000019552170900000195521JO_QUESTION2026-07-0720260027
17090000019590L17/questions_ecrites1717090000019584170900000195841JO_QUESTION2025-02-1120250006
17090000019598L17/questions_ecrites1717090000019595170900000195951JO_QUESTION2026-07-0720260027
17090000019602L17/questions_ecrites1717090000019599170900000195991JO_QUESTION2026-07-0720260027
17090000019616L17/questions_ecrites1717090000019612170900000196121JO_QUESTION2026-07-2120260029
17090000019643L17/questions_ecrites1717090000019640170900000196401JO_QUESTION2026-07-0720260027
17090000019675L17/questions_ecrites1717090000019669170900000196691JO_QUESTION2025-02-0420250005
17090000019753L17/questions_ecrites1717090000019749170900000197491JO_QUESTION2026-07-1420260028
17090000019808L17/questions_ecrites1717090000019805170900000198051JO_QUESTION2026-07-1420260028
17090000019842L17/questions_ecrites1717090000019837170900000198371JO_QUESTION2026-07-2820260030
17090000019862L17/questions_ecrites1717090000019856170900000198561JO_QUESTION2025-05-0620250018
17090000019904L17/questions_ecrites1717090000019899170900000198991JO_QUESTION2026-07-1420260028
17090000019917L17/questions_ecrites1717090000019913170900000199131JO_QUESTION2026-07-1420260028
17090000019944L17/questions_ecrites1717090000019941170900000199411JO_QUESTION2026-07-1420260028
17090000019954L17/questions_ecrites1717090000019950170900000199501JO_QUESTION2026-07-1420260028
17090000019960L17/questions_ecrites1717090000019955170900000199551JO_QUESTION2025-02-2520250008
17090000020011L17/questions_ecrites1717090000020006170900000200061JO_QUESTION2025-02-2520250008
17090000020026L17/questions_ecrites1717090000020023170900000200231JO_QUESTION2026-07-1420260028
17090000020069L17/questions_ecrites1717090000020065170900000200651JO_QUESTION2026-07-2120260029
17090000020178L17/questions_ecrites1717090000020174170900000201741JO_QUESTION2026-07-2120260029
17090000020191L17/questions_ecrites1717090000020186170900000201861JO_QUESTION2025-03-1120250010