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
17090000070163L17/questions_ecrites1717090000070157170900000701571JO_QUESTION2025-10-2120250042
17090000070202L17/questions_ecrites1717090000070196170900000701961JO_QUESTION2025-10-2820250043
17090000070225L17/questions_ecrites1717090000070220170900000702201JO_QUESTION2026-01-2020260003
17090000070226L17/questions_ecrites1717090000070220170900000702202JO_QUESTION2026-05-0520260018
17090000070301L17/questions_ecrites1717090000070295170900000702951JO_QUESTION2025-10-2120250042
17090000070333L17/questions_ecrites1717090000070328170900000703281JO_QUESTION2025-01-1420250002
17090000070334L17/questions_ecrites1717090000070328170900000703282JO_QUESTION2025-05-2020250020
17090000070340L17/questions_ecrites1717090000070335170900000703351JO_QUESTION2025-02-2520250008
17090000070353L17/questions_ecrites1717090000070347170900000703471JO_QUESTION2025-09-0220250035
17090000070386L17/questions_ecrites1717090000070380170900000703801JO_QUESTION2025-10-2120250042
17090000070402L17/questions_ecrites1717090000070397170900000703971JO_QUESTION2025-02-1120250006
17090000070413L17/questions_ecrites1717090000070407170900000704071JO_QUESTION2025-11-0420250044
17090000070419L17/questions_ecrites1717090000070414170900000704141JO_QUESTION2026-04-0720260014
17090000070444L17/questions_ecrites1717090000070437170900000704371JO_QUESTION2025-09-0220250035
17090000070445L17/questions_ecrites1717090000070437170900000704372JO_QUESTION2026-01-1320260002
17090000070446L17/questions_ecrites1717090000070437170900000704373JO_QUESTION2026-05-0520260018
17090000070447L17/questions_ecrites1717090000070437170900000704374JO_QUESTION2026-09-0120260035
17090000070497L17/questions_ecrites1717090000070490170900000704901JO_QUESTION2025-10-2120250042
17090000070532L17/questions_ecrites1717090000070526170900000705261JO_QUESTION2025-01-1420250002
17090000070579L17/questions_ecrites1717090000070573170900000705731JO_QUESTION2025-10-2120250042
17090000070580L17/questions_ecrites1717090000070573170900000705732JO_QUESTION2026-01-2720260004
17090000070581L17/questions_ecrites1717090000070573170900000705733JO_QUESTION2026-05-1220260019
17090000070582L17/questions_ecrites1717090000070573170900000705734JO_QUESTION2026-09-1520260037
17090000070615L17/questions_ecrites1717090000070607170900000706071JO_QUESTION2025-10-2120250042
17090000070642L17/questions_ecrites1717090000070636170900000706361JO_QUESTION2025-12-0220250048
17090000070702L17/questions_ecrites1717090000070694170900000706941JO_QUESTION2025-09-0220250035
17090000070738L17/questions_ecrites1717090000070732170900000707321JO_QUESTION2026-02-1020260006
17090000070767L17/questions_ecrites1717090000070760170900000707601JO_QUESTION2026-09-2220260038
17090000070779L17/questions_ecrites1717090000070773170900000707731JO_QUESTION2026-07-0720260027
17090000070816L17/questions_ecrites1717090000070809170900000708091JO_QUESTION2026-09-2220260038
17090000070841L17/questions_ecrites1717090000070834170900000708341JO_QUESTION2025-12-0220250048
17090000070842L17/questions_ecrites1717090000070834170900000708342JO_QUESTION2026-05-1220260019
17090000070858L17/questions_ecrites1717090000070850170900000708501JO_QUESTION2025-09-0920250036
17090000070886L17/questions_ecrites1717090000070880170900000708801JO_QUESTION2025-10-2120250042
17090000070974L17/questions_ecrites1717090000070966170900000709661JO_QUESTION2026-06-2320260025
17090000071012L17/questions_ecrites1717090000071005170900000710051JO_QUESTION2025-10-2120250042
17090000071019L17/questions_ecrites1717090000071013170900000710131JO_QUESTION2025-12-1620250050
17090000071142L17/questions_ecrites1717090000071137170900000711371JO_QUESTION2025-09-3020250039
17090000071143L17/questions_ecrites1717090000071137170900000711372JO_QUESTION2026-01-2720260004
17090000071144L17/questions_ecrites1717090000071137170900000711373JO_QUESTION2026-06-0220260022
17090000071145L17/questions_ecrites1717090000071137170900000711374JO_QUESTION2026-09-0820260036
17090000071247L17/questions_ecrites1717090000071241170900000712411JO_QUESTION2025-11-1820250046
17090000071268L17/questions_ecrites1717090000071262170900000712621JO_QUESTION2025-11-0420250044
17090000071294L17/questions_ecrites1717090000071288170900000712881JO_QUESTION2025-10-2120250042
17090000071325L17/questions_ecrites1717090000071319170900000713191JO_QUESTION2025-10-2820250043
17090000071442L17/questions_ecrites1717090000071434170900000714341JO_QUESTION2025-11-0420250044
17090000071443L17/questions_ecrites1717090000071434170900000714342JO_QUESTION2026-04-2120260016
17090000071444L17/questions_ecrites1717090000071434170900000714343JO_QUESTION2026-08-0420260031
17090000071476L17/questions_ecrites1717090000071469170900000714691JO_QUESTION2026-01-1320260002
17090000071539L17/questions_ecrites1717090000071533170900000715331JO_QUESTION2025-11-2520250047