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
17090000007410L17/questions_ecrites1717090000007407170900000074071JO_QUESTION2026-03-1020260010
17090000007411L17/questions_ecrites1717090000007407170900000074072JO_QUESTION2026-06-2320260025
17090000007412L17/questions_ecrites1717090000007407170900000074073JO_QUESTION2026-09-2920260039
17090000007416L17/questions_ecrites1717090000007413170900000074131JO_QUESTION2026-05-1220260019
17090000007432L17/questions_ecrites1717090000007428170900000074281JO_QUESTION2026-06-1620260024
17090000007531L17/questions_ecrites1717090000007528170900000075281JO_QUESTION2026-03-1720260011
17090000007532L17/questions_ecrites1717090000007528170900000075282JO_QUESTION2026-06-2320260025
17090000007533L17/questions_ecrites1717090000007528170900000075283JO_QUESTION2026-09-2920260039
17090000007602L17/questions_ecrites1717090000007597170900000075971JO_QUESTION2026-05-1220260019
17090000007659L17/questions_ecrites1717090000007656170900000076561JO_QUESTION2026-06-1620260024
17090000007668L17/questions_ecrites1717090000007664170900000076641JO_QUESTION2026-04-2120260016
17090000007669L17/questions_ecrites1717090000007664170900000076642JO_QUESTION2026-08-0420260031
17090000007678L17/questions_ecrites1717090000007674170900000076741JO_QUESTION2026-04-2120260016
17090000007679L17/questions_ecrites1717090000007674170900000076742JO_QUESTION2026-08-0420260031
17090000007811L17/questions_ecrites1717090000007807170900000078071JO_QUESTION2026-04-0720260014
17090000007832L17/questions_ecrites1717090000007825170900000078251JO_QUESTION2025-03-1820250011
17090000007865L17/questions_ecrites1717090000007860170900000078601JO_QUESTION2026-05-2620260021
17090000007883L17/questions_ecrites1717090000007878170900000078781JO_QUESTION2025-02-1120250006
17090000007884L17/questions_ecrites1717090000007878170900000078782JO_QUESTION2025-05-2720250021
17090000007930L17/questions_ecrites1717090000007925170900000079251JO_QUESTION2025-02-1820250007
17090000008006L17/questions_ecrites1717090000008003170900000080031JO_QUESTION2026-05-1920260020
17090000008019L17/questions_ecrites1717090000008016170900000080161JO_QUESTION2026-04-1420260015
17090000008027L17/questions_ecrites1717090000008020170900000080201JO_QUESTION2025-03-1820250011
17090000008032L17/questions_ecrites1717090000008028170900000080281JO_QUESTION2026-04-1420260015
17090000008040L17/questions_ecrites1717090000008037170900000080371JO_QUESTION2026-04-1420260015
17090000008077L17/questions_ecrites1717090000008072170900000080721JO_QUESTION2025-01-2820250004
17090000008114L17/questions_ecrites1717090000008110170900000081101JO_QUESTION2026-03-2420260012
17090000008172L17/questions_ecrites1717090000008165170900000081651JO_QUESTION2025-01-2820250004
17090000008173L17/questions_ecrites1717090000008165170900000081652JO_QUESTION2025-05-0620250018
17090000008193L17/questions_ecrites1717090000008190170900000081901JO_QUESTION2026-09-2220260038
17090000008364L17/questions_ecrites1717090000008360170900000083601JO_QUESTION2026-05-0520260018
17090000008435L17/questions_ecrites1717090000008431170900000084311JO_QUESTION2026-05-1220260019
17090000008533L17/questions_ecrites1717090000008530170900000085301JO_QUESTION2026-03-2420260012
17090000008534L17/questions_ecrites1717090000008530170900000085302JO_QUESTION2026-06-3020260026
17090000008540L17/questions_ecrites1717090000008535170900000085351JO_QUESTION2025-03-2520250012
17090000008547L17/questions_ecrites1717090000008544170900000085441JO_QUESTION2026-03-3120260013
17090000008548L17/questions_ecrites1717090000008544170900000085442JO_QUESTION2026-07-1420260028
17090000008571L17/questions_ecrites1717090000008566170900000085661JO_QUESTION2026-03-2420260012
17090000008572L17/questions_ecrites1717090000008566170900000085662JO_QUESTION2026-06-3020260026
17090000008635L17/questions_ecrites1717090000008630170900000086301JO_QUESTION2025-02-1820250007
17090000008651L17/questions_ecrites1717090000008647170900000086471JO_QUESTION2026-03-2420260012
17090000008652L17/questions_ecrites1717090000008647170900000086472JO_QUESTION2026-06-3020260026
17090000008680L17/questions_ecrites1717090000008677170900000086771JO_QUESTION2026-03-2420260012
17090000008720L17/questions_ecrites1717090000008716170900000087161JO_QUESTION2026-03-2420260012
17090000008732L17/questions_ecrites1717090000008725170900000087251JO_QUESTION2025-01-2820250004
17090000008733L17/questions_ecrites1717090000008725170900000087252JO_QUESTION2025-05-0620250018
17090000008734L17/questions_ecrites1717090000008725170900000087253JO_QUESTION2025-12-1620250050
17090000008735L17/questions_ecrites1717090000008725170900000087254JO_QUESTION2026-03-3120260013
17090000008761L17/questions_ecrites1717090000008757170900000087571JO_QUESTION2026-03-2420260012
17090000008762L17/questions_ecrites1717090000008757170900000087572JO_QUESTION2026-06-3020260026